Lalit Upadhyay

Corporate DataLake / Financial Crime / KYC

Led and delivered enterprise data engineering solutions across regulatory reporting, transaction monitoring, and data lake initiatives using Ab Initio and AWS. Designed and developed scalable ETL pipelines, ensuring high data quality, governance, and compliance across multiple jurisdictions.

• Gathered requirements, performed impact analysis, and designed scalable data solutions aligned with enterprise standards.
• Developed complex Ab Initio graphs integrating multiple source systems, supporting regulatory reporting and transaction monitoring (Actimize).
• Owned end-to-end SDLC including development, testing, deployment, and production support with zero-defect delivery.
• Collaborated with cross-functional teams (BAs, DevOps, governance, upstream/downstream systems) to ensure seamless data integration and compliance.
• Managed code migrations, release deployments, and production issue resolution.
• Led technical problem-solving, resolved dependencies, and mentored junior team members.
• Drove innovation through POCs, including on-prem data encryption using AWS KMS and PySpark.

Key Achievements:

• Delivered multiple regulatory projects (Partner Banks, GIFT City, SFDC, MI reporting) on time with zero defects.
• Ensured reliable data availability for transaction monitoring systems enabling accurate alert generation.
• Led BVP migration for data lake, creating documentation that significantly reduced migration effort.
• Successfully demonstrated data encryption POC with AWS KMS and PySpark to senior leadership.

• Barclays (TM – SAM8)
• Project Description: Transaction Monitoring (Suspicious Activity Management) ETL team. Responsible for ensuring data availability for the Actimize team, which uses the data for alert generation across multiple jurisdictions.
• Roles and Responsibilities:
• Owned requirements analysis, Ab Initio development, and unit testing to ensure data availability for Actimize alert generation.
• Managed code migrations and deployments across environments, and supported production releases and troubleshooting.
• Tools and Technology: Ab Initio GDE, Metadata Hub, shell scripting, Oracle, Bitbucket, Jenkins, TWS, AutoSys, ServiceNow

• Barclays (JB2 - MI Canned Reports)
• Project Description: Jet Bridge 2.0 facilitates the client journey, starting from onboarding and KYC refresh through ongoing maintenance. JB2 MI Canned Reports ensure the availability of regulatory, control, operational efficiency, and ad hoc reports.
• Roles and Responsibility:
• Quickly adapted to the new team and application and understood complex regulatory requirements.
• Collaborated with BAs to finalize ever-changing requirements to deliver regulatory reports.
• Developed AI graphs with complex logic, integrating two source systems with different granularities to generate the required reports.
• Adhered to strict and challenging timelines, JB2 delivery was critical and high priority.
• Supported QA testing alongside development activities which themselves were very strict in terms of timelines.
• Tools and Technology: Ab Initio GDE, Shell Scripting, TWS

Allocation Processing and Settlement System

Worked on the Allocation Processing and Settlement System (APSS) ETL team, supporting data pipelines for the APSS dashboard.

• Collaborated with Product Owners, Business Analysts, developers, and QA teams to ensure smooth delivery of enhancements.
• Contributed to multiple critical system enhancements, ensuring timely and high-quality releases.
• Managed parallel tasks across projects, quickly adapting to the application framework and business requirements.
• Received client recognition for effectively handling multiple deliverables and demonstrating strong learning agility.

Risk Finance & Treasury

Worked on risk data engineering solutions to support Capital & Impairment Models by ensuring seamless availability of breach and default-related data during the transition from legacy (BUK) to the new BI DoD system.

• Designed and developed ETL processes to merge legacy (BUK) and new (BI DoD) customer data, ensuring uninterrupted data supply for risk and capital impairment models.
• Built reusable and flexible data processing frameworks to handle single and multi-day data loads efficiently.
• Developed shell scripts for job orchestration, preprocessing, date controls, and archival processes.
• Executed end-to-end SDLC including requirement gathering, data profiling, development, testing, and production implementation.
• Collaborated with business stakeholders and model owners to translate requirements into scalable data solutions.
• Performed in-depth data analysis and profiling to ensure data quality and alignment with model requirements.

Consumer Cards & Payments

Worked on multiple data engineering initiatives in the consumer banking domain, including FDR Data Lake Ingestion, Client First Sales Reporting (CFSR), Dataline History Load, and DDR Tiering Remediation.

• Built and enhanced Consumer Cards Data Mart and regulatory/business reports, ensuring accuracy and timely delivery.
• Led end-to-end implementation of FDR source layout changes, including impact analysis, stakeholder communication, code updates, and downstream testing support.
• Designed scalable ingestion and processing frameworks for mainframe datasets, enabling multi-day processing and supporting ~18 months of historical data loads.
• Performed metadata validations to ensure data lineage integrity and compliance with governance standards; supported audits and documentation.
• Collaborated with downstream teams for requirement gathering, change communication, and validation of data changes.
• Identified and resolved data discrepancies (e.g., DDR tiering), proposing remediation strategies and driving stakeholder alignment.
• Mentored new team members and supported onboarding through knowledge transfer on ingestion and reconciliation frameworks.