Cloud migration
SQL Server → Snowflake Data Mart
End-to-end migration of a legacy on-prem data mart to Snowflake. Designed virtual warehouses, resource monitors, and RBAC; translated complex T-SQL into Snowflake SQL using Streams & Tasks; rewired DataStage ETLs into bulk loads via internal named stages.
SnowflakeDataStageT-SQL → Snowflake SQLRBAC
Serverless · AWS
Secure Financial Data Portal
Architected a serverless portal that lets bank customers view their managed entities. Cognito identity, API Gateway + Lambda authorization layer, DynamoDB-backed user/account hierarchy maintained by DataStage pipelines, and AWS Secrets Manager + private endpoints for FIS Global API calls.
0
long-lived secrets in code
AWS CognitoAPI GatewayLambdaDynamoDBSecrets Manager
Hybrid cloud · Microsoft Fabric
Hybrid Pipelines: ADF → Fabric DataMart
Built lift-and-shift pipelines from on-prem EDW SQL Server into Fabric Warehouse using Azure Data Factory, then drove Fabric DataMart loads via stored procedures. Event streams + Activators auto-trigger Fabric loads on DataStage completion and refresh MicroStrategy reports.
Event-driven
end-to-end batch
Azure Data FactoryMicrosoft FabricActivatorsMicroStrategy
Lakehouse
Databricks PySpark Lakehouse Staging
Modular PySpark notebooks for file validation, transformation, and movement across Lakehouse staging — with automated archival of processed CSVs to ensure idempotent reruns and end-to-end traceability.
DatabricksPySparkFabric Lakehouse
Reliability
Real-time DataStage Monitoring
Built a real-time monitoring pipeline and operational dashboard over the DataStage ecosystem ingesting from 15+ core banking systems and external SOAP/REST APIs — giving Operations first-time visibility into batch performance.
First-time
batch visibility
DataStage 11.7SOAP / RESTOperational dashboard
Enterprise ETL
Healthcare & Medicaid Analytics Pipelines
Decade of leading IBM DataStage delivery — Medicaid enrollment / eligibility analytics for NY DOH (Cognos), clinical and member data for HCSC, and HR/EPM data for USAA. Type 1/2 dimensions, surrogate keys, Quality Stage cleansing, and DataStage 8.1 → 9.1 in production with no downtime.
10+ yrs
DataStage delivery
DataStagePL/SQLQuality StageCognos