Abhay Khanna

Responsible for orchestrating the delivery of certified, high-quality data assets, and establishing governed data domains for major regulatory submissions, including FR Y-9C, FR Y-14 CCAR, LCR, 2052a, FDIC 370, FFIEC 031, and CECL, demonstrating a deep understanding and interpretation of complex reporting instructions.

• Spearheaded the migration of legacy data infrastructure to more robust cloud-based platforms, enhancing data ingestion and storage for compliance needs.
• Executed enterprise-wide data management programs, focusing on architecture and business intelligence platforms.
• Collaborated with Regulatory Reporting and Risk Governance teams to align data strategies with compliance requirements.
• Designed and enforced data governance frameworks to ensure integrity, traceability, and compliance across data lifecycle.
• Established rigorous policies for accurate reporting in line with regulatory guidelines.
• Automated end-to-end data pipelines, increasing reporting process efficiency by 30% through metadata-driven validation.

Defined and implemented the enterprise-wide data governance and quality strategy specifically for regulatory reporting, cultivating a culture of data trustworthiness, and accountability. Designed and implemented governed, compliance-driven logical and physical data models, and orchestrated robust data pipelines for efficient regulatory data flow and transformation, ensuring alignment with FR Y-9C and reporting instructions.

• Instituted data quality monitoring and proactive data issue resolution processes, minimizing data discrepancies, and ensuring data fitness for use prior to reporting cycles.
• Fortified SOX and FR Y-14 CCAR compliance by establishing and operationalizing data ownership, stewardship, and accountability frameworks across key data domains.
• Developed and implemented comprehensive data governance frameworks that significantly reduced regulatory risk by ensuring data integrity, end-to-end data lineage, and strict adherence to regulatory policies, including those for SEC reporting (10-K, 10-Q).
• Received Truist's Best Performance Reward in 2019 for outstanding contributions to data management initiatives.

Oversaw the design, development, and optimization of enterprise data warehousing solutions and robust ETL/ELT pipelines, serving as the authoritative source for credit risk analytics and regulatory reporting. Drove initiatives to elevate data accuracy, completeness, and consistency for critical regulatory reports, aligning with enterprise data quality standards.

• Collaborated with reporting teams to identify root causes of data anomalies, and implement governed, sustainable data remediation solutions.
• Designed and deployed data quality dashboards and key data quality indicators (DQIs) for continuous monitoring and executive oversight of data asset health and compliance.
• Successfully led the effort to close a significant CCAR reporting-related federal matter requiring attention (MRA).
• Resolved over 150 critical data issues, significantly improving the reliability and integrity of reporting data.
• Reduced report exception rates by 40% through enhanced data validation, profiling, and quality controls, ensuring data integrity for regulatory submissions.

• Provided Tier 1/2 production support for ETL data warehousing applications, leading incident management to resolve complex job failures, and minimize downtime.
• Implemented proactive monitoring and collaborated with cross-functional teams to diagnose and fix production issues, ensuring the timely delivery of validated data feeds.
• Developed runbooks and documentation to standardize production support activities, and ensure consistent operations.

• Engineered and optimized complex ETL processes using Ab Initio, improving data flow efficiency for large datasets.
• Collaborated with data architects and analysts to translate business needs into technical specifications for data pipelines.
• Maintained data quality and integrity by implementing validation rules and error handling, while also providing troubleshooting support to ensure job stability.