Every data warehousing project from traditional to big data I’ve been a part of has successfully gone into production (well over 20). I include in the ETL runbook verification code to the hundredth of a penny (rare these days). I have over 15 years of data warehousing traditional and modern experience working leading consulting firms that includes most if not all the technologies mentioned in the job description. I have worked with Airflow, Glue, Spark, Hive as well as columnar database and file technologies. I can wear many hats from architect to engineer and have played lead roles also have admin experience and extensive Data Quality, matching and MDM experience. I have also worked on Azure, AWS, and have many years and have been team lead several times.

• Provided data mapping, ETL and engineering expertise on Azure with ADF and SQL Server and Salesforce• Implemented TSQL stored procs and instituted validation procedures. • Designed developed MDM and DQ processes harnessing levenshtein distance algorithm with python, and C# to clean, consolidate that improved Data Quality.

Suffolk Construction Big Data Warehousing Engineer and Architect• Provided Architectural expertise on Enterprise Data Lakehouse implementing Kimball Methodology that was designed for specifically for AWS Redshift, but could easily be implemented in any cloud technology. • Successfully implemented the EDW as an architect, data warehouse tech lead and goto trouble shooter. Designed high performance ETL and established guidelines and best practices for all aspects of the project that utilized Oracle, AWS S3 and Redshift, python, pandas, Airflow and DataBricks. Brought a high degree of number accuracy to financial reporting and data lakehouse processing utilizing Oracle EBS, AWS, Azure and various other cloud sources• Designed and developed MDM and DQ processes harnessing levenshtein distance algorithm with python and Redshift in stored procedures.

Lead Big Data Warehousing Architect• Provided Architectural expertise on Enterprise Data Lakehouse implementing Kimball Methodology that was designed for specifically for Azure, but could easily be implemented in any cloud technology. • Successfully implemented the EDW into production as an architect, tech lead and goto trouble shooter. Designed high performance ETL and established guidelines and best practices for all aspects of the project that contained 2 years of data that loaded 2 million invoices a day to a high degree of data quality and accuracy that improved reporting reliability.• Contributed all coding and design aspects from batch loading procedures to SSIS and assisted in the design of SSIS packages that loaded a billion rows in under 3 hours.• Architected MDM, Archiving Strategy with Hadoop, Partitioning, High Performance ETL, modeling and all aspects of the Enterprise architecture and modeling• Provided highly accurate results of mission critical financial data to the business by successfully being the driving force putting the solution into production allowing reporting that was not available beforehand.• Acted as lead Data Scientist that designed star schema and IN-memory DAX and traditional MDX OLAP cubes that accommodated complex this week last week variance calculations and derivatives

DBA & Data Architect• Provided DBA/Architectural expertise on Oracle RAC 10G on Windows and RAC 11G & 12c on Linux running on ASM that utilized an EMC VNX in a 24/365 manufacturing mission critical pharmaceutical production environment. • Furnished extensive process manufacturing experience in a worldwide SAP implementation that includes MES and DeltaV that utilized TIBCO.• Contributed all aspects of SQL Server from 2012 - current versions including cloud doing performance tuning, installation and coding • Worked extensively tuning, configuring Logical and Physical DataGuard with ASM and RAC that included resyncing with RMAN on Oracle 10G – 12c in Window and Linux.• Implemented a proactive architectural review of all database systems including adding ASM disks, memory, security and any maintenance issues.