Lead AVP, Credit Information Architect at Synchrony Financial (2019-09 – Present)
Lead data modernization at Synchrony Financial, driving alignment between business strategy and technical execution through complex transformation and data curation projects. People Manager, Process optimization, IT and Stakeholder Collaboration.
- Automated model: Build for classification of PII/Sensitive columns, reducing manual effort from 2 to 3 days to 30 seconds, maintaining 95.7% accuracy.
- Agile setup: Streamlined the assignment of manual requests to JIRA by implementing board forms with multi-level validations, automated email notifications, and governance controls.
- Defining and maintaining logical and physical data models for the data lake for Credit Cards data, ensuring reusability, scalability, and alignment with enterprise standards.
- Led the migration effort of legacy credit application platform (Surveyor) to Synapps which impacted 100+ variables of RDG (Curated DB). Built automated validation process and templates that kept lifecycle of application. Outcome: $500K/year storage cost reduction | Application uniformity.
- Led redesign of RDG platform, updating 50+ Ab Initio ETL graphs with modular and dimensional architecture. Outcome: Reduced batch process from 3 to 1 day (66% faster), $1.2M saved annually, 40% SLA compliance improvement.
- Enhanced C360 view, directed data modeling & designed SCD Type 1/2 for attributes and junk dimensions for transaction flags. Outcome: Expanded credit vision for strategy | 400+ active business consumers.
- Curated the data to build new CCAR table as per the regulatory standards.
- Neo4J - Modeled for fraud detection, achieving 28% early detection improvement > Enhanced risk decisioning
- ER studio - New client onboarded > creating reusable ontology models
- Conexus - Validated POC > running in-house pilot.
Senior Data Engineer at Tata Consultancy Services (2016-12 – 2019-09)
- Space Management Analytics: Built automated Hadoop data lake processing 14 TB/week retail data leading to 24-way parallel processing via Ab Initio multi file systems.
- ETL Automation: Eliminated manual backdated SSIS exclusions process achieving 80% effort reduction for US retail client.
- Led dimensional schema redesign for BDM platform, converting legacy point-in-time data structures into star/snowflake models.
- Designed conformed fact tables (Dim Date, SKU) with shared dimensions (Customers, Store, Products) enabling cross-domain analytics.
Senior Systems Engineer at Infosys Ltd (2014-02 – 2016-12)
- Modernized legacy ETL flows & Optimized fact table grain and dimension hierarchies to balance query performance with analytical flexibility in the Helios Project earning DNA Star Award
- Completed zero-downtime migration with automated validation during Teradata Upgrade
Project Assistant | Innovation Catalyst at CSIR Delhi (2013-05 – 2014-02)
- Developed Android app for HRDG database access using Java/SQLite, achieving 65% faster data retrieval. Built efficient mobile data architecture serving 500+ monthly users
