• Built and managed reporting Data Warehouse using Azure Synapse Analytics in dedicated SQL pool• Managed Data Lake in serverless pool and Azure BLOB Storage• Maintain Azure Data Factory pipelines for both Data Warehouse and Data Lake imports and exports• Create and manage APIs and RESTlets for moving data in and out of Oracle Netsuite• Maintained and manage data sets built through Netsuite Analytics• Utilized PowerShell to POST, GET, PUT, DEL:ETE data to and from Netsuite via OAUTH 1.0 and OAUTH 2.0; test with POSTMan

• created and maintained ETL Jobs to transmit data from On Prem Databases using SSIS and Azure DataFactory and SQL Stored Procedures to encapsulate business rules within complex T-SQL queries• Python development to merge Salesforce and Vertica data to Azure Sql Database and Vertica on-prem datawarehouse

Short contract to implement several ETL flows moving data from on-prem SQL Server to Azure SQL database. Also migrated ETL flows from SSIS to Azure Data Factory

Data Warehouse Engineer - Designed and implemented several ETL workflows for short contract.

• Primary resource in charge of design and develop of SQL related projects, from Logical/Physical Data Modeling, SQL Object Creation (Table, Views, Procedures, Functions, Triggers) in Oracle, Netezza, Teradata, SQL Serve , PostGres, and Snowflake platforms as well as writing business rules using complex T-SQL, PL-SQL, NZSql, Teradata SQL and SnowSQL Queries. • Held Key role in 3 database migrations – SQL Server to Netezza, Netezza to Teradata, Teradata on-prem to Snowflake cloud; responsible for ensuring database objects and ETL processes worked as they did in all former platforms• Held key role in migrations from Visual Source Safe to Github to Azure Dev Ops code reposititories • Maintained, optimized 400+ (Control-M, Cron, SSIS, DMExpress, SQL) ETL jobs to load 500+ customer data files.• Developed, deployed and scheduled (SSIS, SQL, Python) ETL jobs to load customer data files.• Collaborated with stakeholders to gather functional and technical requirements; assist in creating Agile user stories based upon stakeholder’s functional requirements• Collaborated with Business Intelligence team to optimize, extend and improve Data Warehouse SQL Objects and overall database performance• Supported development staff with advanced T-SQL, PL-SQL, NZSql, Teradata SQL and SnowSQLcoding techniques• .NET development – VB.Net, C#.net (in and out of SSIS)• Conducted code peer reviews • Built custom ETL processes with DMExpress to optimize loads and extracts, making them 50 percent faster overall vs. SSIS and Informatica• Led implementation of Control-M DataManagment group-wide• Led effort to make MetroPCS POS extract files consumable by SAP for Supply Chain and handset replenishment• Served as a primary resource for extracting from and loading to Salesforce, the primary source for most store data using Lightning and classic interfaces as well as ETL flows connecting to Salesforce APIs

• Applied various skills to evaluate, design, implement and optimize databases and database applications.• Partnered with project management teams on development of scope and timelines.• Supported development staff with advanced T-SQL coding techniques• Wrote scripts and processes for data integration and bug fixes.• Identified databases not reaching peak performance and determined ways to solve concerns.• Planned, designed and streamlined data structures for analysis.• Developed, deployed and scheduled (SSIS) ETL jobs to load customer data files.• 24/7 Oncall Production support• supported custom connectivity with payment processors (Paymentech, NYCE, etc...)• supported Web interface and IVR payments for hundreds of utility, auto and insurance payments• supported report creation for financial data to be reconciled with payment processors and clients• Lead QA Tester for new software releases• Lead Operations Technician