Ayush Jain

Techno-functional BI professional with overall 13+ years of progressive experience in enterprise data architecture, governance, and business analytics across financial services.

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

MBA in IT & Operations – Amity University (2012-08 – 2015-05)

B.Tech in Computer Science Engineering – BM Engineering College (2008-08 – 2012-05)