Jithender Vummadi

Spearheaded the development of a 10TB HR data warehouse at Capital One, unifying data from 15+ internal and external systems to empower 500+ HR users with actionable insights. As Master Data Engineer, I:

• Led a team of 8 engineers, overseeing project delivery from requirements gathering to technical design and execution.
• Mentored 2 junior engineers to senior level, cultivating talent within the team and fostering growth.
• Served as the technical and product liaison for HR leadership, providing expertise and guidance on feasibility and implementation.
• Streamlined project management through detailed plans, weekly reports, and efficient Scrum ceremonies.
• Boosted team productivity by 50% through automating mapping document creation (earning the prestigious Limelight Award).
• Proactively ensured data warehouse health by building and monitoring operational dashboards with CloudWatch and proactive alerts.

Spearheaded Cloud Migration and Analytics Innovation at Fanniemae

• Led a team of developers supporting the migration of critical Mortgage Loan Integrated System (MLIS) and Underwriting Data to the cloud, enabling future-proof analytics capabilities.
• Architected and delivered key Single Family Business Unit reports for the Federal Housing Financial Agency (FHFA) using PySpark in the cloud.
• Developed automated data pipelines in EMR with Lambda to process historical MLIS reports and implemented secure encryption/decryption processes for NPI data.
• Championed data governance and discoverability by migrating MLIS applications to the Enterprise Data Catalog, ensuring cloud compliance and efficient data access.
• Masterminded the successful 40TB on-prem to cloud migration of Underwriting data, designing a future-state architecture utilizing Redshift Spectrum, Athena, and Redshift.
• Leveraged Talend Big Data on AWS to process Underwriting data and load it to Hive and Redshift, streamlining data pipelines.
• Demonstrated expertise in diverse ETL tools (Informatica, Ab Initio, Talend) while retiring legacy systems (RDW).
• Enhanced data quality and reporting through the day-one certainty project DVS solution, utilizing Hadoop Spark to process data and load it to Hive tables.

• Masterminded Citigroup's liquidity reporting overhaul by leading an 8-person team to build a high-performance Ab Initio application, streamlining GBNP and GCE data flows for CitiDirect.

• Masterminded Citigroup's Equity Derivatives Reconciliation with Ab Initio: I built streamlined ETL pipelines that reconciled data from diverse sources (XMLs, flat files, mainframe) and different products, ensuring clean data for accurate reporting. Automated the process with Autosys Jibs and optimized workflows with data load/error reports via Unix Shell scripts.
• Led the technical design and execution of Home Depot's DB2 to Teradata migration, streamlining data processing through generic ETL frameworks and Unix scripts, resulting in a smoother and more efficient data warehouse.