SUMMARY

• 26+ years of IT experience with expertise in database design and development.
• 20+ years of data architecture, ETL (Ab Initio - 6 yr, Informatica - 10 yr, Pentaho, ODI, Talend, SSIS), data warehouses, data lakes, metrics, KPI’s.
• 20+ years of Development DBA (15 yr Oracle, 8 yr SQL Server, 7 yr DB2).
• 20+ years of data modeling experience (Oracle, Teradata, SQL Server, DB2, PostgreSQL, Snowflake, Syncfusion Hadoop-SparkSQL, Hive), IBM DB2 Big SQL (Hadoop), metadata modeling, data analysis, and Data Vault (Hubs - Links - Satellites).
• 15+ years Oracle EBS/Fusion-Weblogic/SOA/OBIEE/OBIA, CRM-SalesForce, Supply Chain - PeopleSoft and ORA Financials (R11 and 12), SAP CRM ERP, SAP HANA Data Modeling, Views and Performance, SAP BODS ETL, SAP BOBJ Reports and Web Intel, SAP ECC FICO MM MDG SD, OSI PI, Attunity replication.
• Predictive analytics with Weka and Alteryx for XGBoost, Random Tree, Random Forest, RBF Network, Bagging, Ensemble Selection, Random Subspace, Multi-Scheme, Decision Table, Zero R and REP Tree analysis with Python.
• Cloud development in Azure, Informatica, AWS - S3 (Object Storage), EC2 (Elastic Compute Cloud), EMR (Elastic MapReduce), Kinesis (Streaming - Spark), Lambda, Serverless, Step Functions, EBS (Elastic Block Store), ECS (Elastic Container Service), PostgreSQL, AWS RDS - AWS Aurora (Pg), Redshift, AWS DynamoDB, Oracle, Hadoop, Spark, IaaS, PaaS, SaaS.
• Strong Oracle, Sybase, and SQL Server development using PL/SQL, SQL*Plus, SQL*Loader, Transact-SQL, and BCP.

TECHNICAL SKILLS

• Oracle E-Business/Fusion/SOA
• CRM/SalesForce and ORA Financials (GL AP AR PO INV)
• Peoplesoft (GL AP PO)
• Clarify
• Siebel
• SAP ABAP BAPI RFC IDOC
• Ab Initio
• Informatica
• SSIS
• SSAS
• OBIEE
• OBIA
• ODI
• Oracle
• DB2
• Sybase
• SQL Server
• PL/SQL
• Pro*C
• T-SQL
• CT/DB Lib
• Powerbuilder
• Rational Rose
• Erwin
• C
• C++
• Python
• VB
• Forms
• Discoverer
• Microstrategy
• Business Objects
• Cognos
• Tableau
• PowerJ
• JDev
• Perl
• TFS
• SVN
• HP-UX
• Solaris
• Korn
• VM
• MVS
• IDMS
• ADS/O
• CICS
• Novell
• VTAM
• REXX
• Assembler
• MicroFocus COBOL
• Teradata
• Trillium
• XML
• JSON.

PROFESSIONAL EXPERIENCE

Cloud Data/ETL Architect

Confidential

Responsibilities:

• Responsible for architecture, modeling, design and build of AWS PostgreSQL, Snowflake, Syncfusion Hadoop - SparkSQL, Hive, Map Reduce, IBM DB2 Big SQL (Hadoop), cloud Azure SQL data warehouse (Blob storage, Polybase) and Azure Data Lake Store, Azure Data Factory and Power BI with SSIS, predictive analytics with Weka and Alteryx for XGBoost, Random Tree, Random Forest, RBF Network, Bagging, Ensemble Selection and REP Tree analysis with Python. SAP HANA Data Modeling, Views and Performance, SAP BODS ETL, SAP BOBJ Reports and Web Intel, SAP ECC FICO MM MDG SD, OSI PI, Attunity replication.
• Responsible for architecture, modeling, design and build of Oracle, Sql Server, Teradata, DB2, dimensional data model integration w/ Informatica and OBIA, CRM-SalesForce, Peoplesoft, Pentaho, ODI, OBIEE, Business Objects, Tableau, staging, cleansing, transformation, partitioning, and materialized views. Staging designs for Oracle EBS/Fusion-Weblogic and Financials. Performed CDC, Master Data Mgmt (MDM), IDQ, data profiling, metrics, KPI’s. Performed requirements gathering, development of functional and technical design, data migration, post-implementation support, and support for domain architectures and processes. Design and development of metrics and performance tuning and QA.
• Responsible for architecture, modeling and build of Oracle, Teradata, PostgreSQL, Greenplum data warehouses for SAP CRM, ERP, MDG, MM and FICO w/ Informatica/OBIA/SOA, CRM/SalesForce, Pentaho. Architecture staging using SAP ABAP, RFC, BAPI, IDOC into DW w/ Microstrategy and Cognos BI reports.
• Responsible for multi-tier integration architecture and modeling of Oracle, DB2, Sql Server DW for Oracle EBS/Fusion-Weblogic Financials R11 and 12 (GL, AP, AR, PO, INV) w/ OBIEE and OWB. Architecture staging, merging into Teradata.
• ODS conversion from Informatica mappings to Ab Initio (ETL) graphs. Data staging, and cleansing of Oracle E-Business Financials w/ BI Brio reports.
• Production DBA for object-oriented XML/relational GIS Oracle DW.
• Integrated DSS (5 subsystems - orders (Clarify, Siebel), provisioning, (Oracle CRM/FIN), data integration w/ Ab Initio, DB2, Sql Server, Brio, dev. DBA.
• Served as an Oracle Siebel CRM/XML Data Administrator in a Unix / NT environment. Performed data modeling, replication and a Veritas installation.
• Responsible for multi-tier integration architecture of Oracle CRM, DB2, Sql Server data warehouses (Supply Chain) with PB. Worked with business users gathering requirements, translated those requirements into a technical solution, created a dimensional data model design and ETL design, and implemented BI reporting.
• Responsible for OO design / methodology with UML (Rational Rose) and development of a 3-tier distributed marketing Sql Server ODS for CSG and ICOMS. Worked with business users gathering requirements, translated those requirements into a technical solution, created a dimensional data model design and ETL design.
• Responsible for Oracle DB modeling and development of a real-time (SCADA) GIS natural gas warehouse from SAP. Translated requirements into a technical solution, created a dimensional data model design and ETL design, and BI reporting/analysis.
• Responsible for database design of a new DB2 Powerbuilder pharma system.
• Responsible for all program development in the Rates Subsystem of a FERC Order 636 GIS DB2 implementation (gas pipe). Performed OO design in Gas Nominations.
• Responsible for program development on a Sql Server oil and gas distribution and trading system. Performed object-oriented design and programming in C++ in a client/server environment and performed requirements gathering.
• Responsible for programming on a Sql Server PB manufacturing system (MRP).

Sr. Systems Analyst

Confidential

Responsibilities:

• Performed requirements gathering, analysis, planning, data modeling, and programming at corporate headquarters.
• Applications included client/server EDI system.
• Developed CA-IDMS Accounts Receivable, GL, and Fixed Assets.
• Performed VM and IDMS system tuning.
• Developed PC-to-mainframe system, such as a turbine simulation system using GE LM6000, 5000 and 2500 turbine simulation programs on the mainframe coupled with fuel subsystems and simulation subsystems on the PC.
• Developed PC-to-mainframe and PC-to-System 38 communication programs.
• From this PC experience, began evaluation testing, and using PowerBuilder in the spring of 1992.

Sr. Systems Analyst / Assistant Treasurer

Confidential

Responsibilities:

• Developed business plans, cash flow analysis, and SCFP for a pipeline company.
• Performed portfolio analysis, merger analysis, lease analysis, and CAPM.
• Performed nominations on UGPL, Lone Star, and Tenneco.
• Developed systems for gas nominations, transportation and exchange, FERC Order 500, gas imbalance accounting, EDP audit, and revenue accounting - division of interest (joint, working).
• Managed and programmed a System 36 using COBOL, OCL, and SEU.
• Developed PC programs using Microfocus COBOL, Assembler, and BASIC.