Looking for a job

Serge Shermon

@sergeshermon

Senior Data Engineer at Apple Bank who designed a metadata-driven ETL framework for data quality and reconciliation.

At Apple Bank, I designed and implemented an SSIS and Snowflake metadata-driven ETL framework that automates file validation, audit logging, and historical data reconciliation. I also translate external sources into reusable business datasets for analytics, reporting, and operational use.

At Stifel Financial, I architected automated Salesforce data-integration pipelines with centralized monitoring and self-healing capabilities. I also designed data models and dimensional schemas for BI applications and performance reporting.

At IPG (Digital Media), I designed data-warehouse and data-mart architectures for digital marketing analytics, and developed AWS Redshift and Netezza warehouses. Earlier, at WebMD and Mizuho Corporate Bank, I worked on database development, ETL, performance tuning, and reporting.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Engineer | Data Architect

Current

Apple Bank

Jan 2021 - Present (5 years 9 months)

Lead database architect and developer for the conversion, design, and modernization of the bank's vendor application data platform. Designed and implemented an enterprise SSIS and Snowflake metadata-driven ETL framework with automated file validation, audit logging, and reconciliation.

Snowflake SQL Server SSIS SSRS Business Objects ETL Data Modeling Data Governance Performance Optimization

Senior Database Engineer

Stifel Financial

Oct 2017 - Dec 2020 (3 years 2 months)

Architected and built automated Salesforce data-integration pipelines with centralized monitoring and self-healing capabilities. Defined ETL framework rules, architectural patterns, and quality controls using SSIS and COZYROC.

SQL Server SSIS SSRS Salesforce Cozyroc ETL Data Modeling Performance Optimization

Data Architect / Lead Developer

IPG

Oct 2013 - Sep 2017 (3 years 11 months)

Designed enterprise data warehouse and data-mart architectures supporting digital marketing analytics. Led process design for end-to-end BI and ETL solutions, including C# scripting, logging, and alerting frameworks in a version-controlled Microsoft TFS environment.

SQL Server SSIS SSRS AWS RedShift Netezza Tableau TFS C#Data Modeling ETL

Senior SQL Server DBA / Developer

WebMD

Sep 2012 - Oct 2013 (1 year 1 month)

Managed database administration and development, including performance tuning, replication, and user-access control. Designed stored procedures, functions, and triggers to streamline business processes and improve performance.

SQL Server SSIS SSRS Vertica Oracle Performance Optimization ETL

Senior Programmer / Analyst

Mizuho Corporate Bank

Nov 2000 - Sep 2012 (11 years 10 months)

Designed and implemented database architectures and ETL processes for multiple core banking systems. Developed .NET and SQL-based systems integrating multiple banking applications into a unified platform.

SQL Server SSIS ASP.NET VB.NET C#Crystal Reports ETL Performance Optimization