Data Warehouse/ODS Architect Resume

SUMMARY

Over 30 years of Oracle and SQL Server experience.
Extensive Database Modeling, Architecture, and Development experience.
Analysis Services, Reporting Services, Integration Services, OBIEE, DB Artisan, Microsoft Dynamics CRM, Oracle Warehouse Builder, Forms (2.3,3.0, 4.0, 4.5, 5.0, 6i), Reports (1.1, 2.0, 2.5, 3.0, 6i.), Oracle Applications 10.7, 11.0.3, 11.5.3, Crystal Reports/Analysis, Oracle Enterprise Manager, PL/SQL, Oracle Analytical Functions, Master Data Management, Toad, SQL - Plus, Designer 2000/Web Server, Informatica Powercenter (1.6,1.7,5.1,6,8.6,9.6) and Powermart (4.6,4.7), Erwin, UNIX shell scripting (HP, Solaris) Python, Power BI, Tableau, Sparx EA

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse/ODS Architect

Responsibilities:

Responsible for creating and maintaining the data models for the ODS and EDW utilizing Sparx EA.
Supervised a team of 9 offshore developers.
Implemented declarative database development utilizing SQL Server Database Tools.
Designed and developed templates for SSIS development.
Designed and implemented a SDLC process for promoting code from Development to Production.
Created complex stored procedures utilizing TSQL.
Performed SQL performance tuning as needed,
Created program to process 834 EDI files into the ODS using C#
Created and maintained Data Vault in Oracle 11G.
Created EDW and Data Marts in the cloud using Azure SQL Data Warehouse and Azure Data Lake Gen2 built on Azure Blob Storage.
Copied data to Azure Blob Storage using Azure Data Factory and Azure AzCopy.
Implemented Azure Security according to Microsoft’s “Azure Best Practices for Security”
Created complex packages in Oracle 11G.
Created reports and dashboards using Power BI Desktop and Power BI Pro.
Created complex Mash ups using Power BI (Power Query).
Designed What If analyses using PowerApps Custom Visual.

Confidential

Data Warehouse Architect

Responsibilities:

Functioned as the principal architect for design and implementation of a Kimball methodology Enterprise Data Warehouse.
Designed and developed complex ETL loads from various source systems to the Enterprise Data Warehouse utilizing SQL Server Integration Services and Transact SQL.
Implemented declarative database development utilizing SQL Server Database Tools.
Designed and developed end user reports utilizing Tableau and Microsoft Power BI.
Created a comparison presentation between Power BI and Tableau so that the analysts could choose the best tool.
Designed and implemented a robust ETL auditing system.
Maintained and repaired legacy Informatica ETL mappings.
Created Proof of Concept for Azure/Data Factory.
Created complex packages in Oracle 11G.
Maintained Data Model for the EDW utilizing ERwin.

Confidential

Senior Business Intelligence Architect

Responsibilities:

Designed and developed complex ETL loads from source systems to the Enterprise Data Warehouse utilizing SQL Server Integration Services and Transact SQL.
Performed extensive database and ETL tuning.
Responsible for the design and implementation of Master Data Management utilizing Master Data Services.
Designed and developed end user reports utilizing SQL Server Reporting Services.
Performed extensive data modeling utilizing ERwin.
Designed and developed complex stored procedures and functions to enforce business rules and calculate analytic measures (Z-Scores).
Maintained and repaired legacy reporting system during development of Enterprise Data Warehouse.

Confidential

Senior Business Intelligence Architect

Responsibilities:

Designed and developed complex ETL loads from JD Edwards source to Oracle data warehouse tables utilizing PL/SQL packages and SQL Server Integration Services
Designed and developed SQL Server Integration Services packages to load data from SAP generated flat files into operational data store tables.
Designed and developed complex customer matching algorithms to identify duplicate customers and to facilitate rolling up of bill to/ship to relationships.
Created functions to manipulate SQL Server stage table data utilizing Transact SQL.
Designed, created and maintained OBIEE repository (RPD)
Maintained Data Model for the EDW utilizing ERwin

Confidential

Business Intelligence Architect

Responsibilities:

Designed and developed SQL Server Integration Services packages to load data warehouse tables from flat files.
Designed and developed complex ETL auditing and data lineage controls.
Designed and developed complex functions and procedures utilizing Transact SQL.
Performed performance tuning on existing SSIS packages.