Senior Data Engineer AML/GRC Pipelines

Niranjan Naik Lavudia

Senior Data Engineer

+1-814-***-**** ***************@*****.*** San Antonio, TX

Professional Summary

Senior Data Engineer with 10+ years of experience in enterprise data warehousing, ETL/ELT development, cloud integration, data modeling, and governance for regulated financial services environments. Strong expertise in DataStage, Snowflake, Databricks, Spark, dbt, MFP, SnapLogic, and Control-M, with a proven track record in AML, fraud, audit, and GRC data engineering. Skilled in designing secure, scalable, and governed data pipelines, implementing data quality controls, and building dimensional and curated datasets to support compliance monitoring, regulatory reporting, and enterprise risk management. Experienced leader managing large onsite/offshore teams and collaborating with cross-functional stakeholders in high-compliance environments.

Core Strengths

AML (Anti-Money Laundering), Audit, and GRC (Governance, Risk and Compliance) Data Engineering

Data Modeling and Schema Design

ETL/ELT Design and Optimization

Cloud Data Warehousing and Data Lakes

Data Quality, Lineage, and Governance

Team Leadership and Offshore Coordination

Stakeholder Management and Cross-Functional Collaboration

Performance Tuning and Production Support

AI-Assisted Engineering with EagleGPT and GitHub Copilot

Technical Skills

ETL/ELT: IBM InfoSphere DataStage 11.5/11.7, Databricks, Spark, dbt, MFP, SnapLogic, Control-M

Cloud/Data Warehousing: Snowflake, AWS, Delta Lake

Data Modeling: Dimensional Modeling, Star Schema, Snowflake Schema, 3NF, SCD, Data Vault concepts, Logical/Physical data models

AI/Developer Productivity: EagleGPT, GitHub Copilot, AI-assisted code generation and troubleshooting

Databases: Oracle 11g, IBM DB2, SQL Server, Teradata, Salesforce

Languages: SQL, PL/SQL, Python, Shell Scripting, XSLT

Reporting: Tableau

Tools: RSA Archer, UNIX, PuTTY, WinSCP, JIRA

DevOps: GitLab CI/CD, IBM UrbanCode Deploy

Governance: Data Quality, Reconciliation, Lineage, Access Control, Stewardship

Operating Systems: Windows, UNIX/Linux

Professional Experience

USAA San Antonio, TX

Senior Data Engineer November 2022 – Present

Led the AML RTB team and supported the Actimize application as a Senior Data Engineer, delivering trusted data solutions for risk and compliance operations.

Designed and maintained secure, scalable ETL/ELT pipelines for AML, fraud, transaction, customer due diligence, suspicious activity monitoring, sanctions, and watchlist data across enterprise banking and insurance systems.

Developed and maintained data models for AML monitoring, customer intelligence, fraud, and risk reporting, including dimensional and curated datasets for analytics, investigations, and compliance operations.

Utilized Databricks and Spark to build scalable processing workflows for large-volume AML, fraud, and compliance datasets, improving transformation speed and analytical efficiency.

Leveraged EagleGPT and GitHub Copilot to accelerate data pipeline development, optimize SQL and Python logic, support troubleshooting, and improve documentation quality across AML and GRC workflows.

Developed Databricks-based ETL and validation workflows to support reconciliation, quality checks, and advanced analytics across enterprise sources and Snowflake targets.

Built governed, reusable data models and curated datasets to support AML investigations, alerting, internal audit reporting, and regulatory compliance monitoring.

Partnered with AML analysts, risk managers, and compliance stakeholders to define requirements for KYC/AML controls, sanctions screening, and suspicious activity monitoring.

Implemented data quality checks, reconciliation logic, lineage tracking, and validation frameworks to ensure trusted, auditable data for AML, audit, and GRC use cases.

Automated control evidence and exception reporting processes to strengthen audit readiness, reduce manual effort, and improve governance oversight.

Built and maintained MFP, dbt, and SnapLogic pipelines for the Audit ASRAP application to support daily Tableau business reporting.

Automated pipeline execution using Control-M to ensure reliable, repeatable, and timely business-critical data delivery.

Integrated structured and unstructured data from multiple enterprise sources into Snowflake to enable compliance analytics, risk monitoring, and audit support.

Optimized large-scale financial data processing using partitioning, incremental loads, and performance tuning to improve efficiency and scalability.

Led the GRC RTB team and served in the IT DPO role for the GRC space, owning data platform responsibilities, governance alignment, and operational support for enterprise risk and compliance initiatives.

Established data standards, lineage, and stewardship practices across AML, Audit, and GRC domains to ensure consistency, traceability, and accountability.

Collaborated with cybersecurity, privacy, audit, compliance, and technology teams to align engineering work with enterprise standards and regulatory obligations.

Environment: IBM InfoSphere Information Server DataStage 11.7, Snowflake, Databricks, Spark, Control-M, MFP, dbt, SnapLogic, SQL Server, DB2, Oracle 11g, Salesforce, Tableau, Python, PL/SQL, UNIX, GitLab CI/CD, JIRA, IBM UrbanCode Deploy, Windows 10, EagleGPT, GitHub Copilot

USAA San Antonio, TX

Senior DataStage Developer November 2018 – November 2022

Supported the RSA Archer application for the EagleEye Security team, designing and maintaining ETL processes for enterprise security and compliance operations.

Designed, analyzed, monitored, and scheduled ETL jobs using Control-M and UNIX shell scripting in alignment with business and regulatory requirements.

Led onsite and offshore teams to streamline development activities, code reviews, and issue resolution for production support.

Designed and implemented data models for staging, warehouse, and reporting layers, including SCD-based loads and data transformation logic supporting enterprise security and compliance reporting.

Extracted and transformed data from multiple operational sources into staging and warehouse layers using SCD-based load patterns.

Integrated data from Oracle, IBM DB2, SQL Server, Snowflake, Teradata, XML files, and mainframe sources into data marts and target systems.

Wrote complex SnowSQL scripts and performed Snowflake-based data analysis for reporting and analytics use cases.

Developed Python scripts for automation, operational efficiency, and supporting data quality analysis.

Deployed ETL code using IBM UrbanCode Deploy and GitLab CI/CD.

Worked with SQL and PL/SQL to build stored procedures, validation logic, and data retrieval processes across enterprise databases.

Partnered with business and technical stakeholders to automate workflows, improve data quality, and strengthen operational governance.

Environment: IBM InfoSphere DataStage 11.5/11.7, Snowflake, eGRC RSA Archer 6.5, SQL Server, DB2, Oracle 11g, Salesforce, UNIX, Python, PL/SQL, IBM UrbanCode Deploy, GitLab CI/CD, JIRA, Windows 10

FIS Menomonee Falls, WI

ETL Developer June 2018 – October 2018

Provided application software development and technical support for the FCM Data Hub project.

Developed and migrated DataStage jobs for Bank Control, Deposit, Loan, and Customer modules.

Performed performance tuning and optimization of DataStage mappings and transformations for improved processing efficiency.

Implemented Java Split Conversion Framework migration from the legacy environment to the new environment.

Created and maintained ETL jobs using Aggregator, Join, Merge, Lookup, Row Generator, and Oracle/Teradata connectors.

Scheduled daily jobs using BMC Control-M and CA Autosys and ensured smooth production execution.

Worked with Harvest Workbench for version control and package migration across application environments.

Environment: DataStage 11.5/8.1, SQL Server 2009, SQL, Windows, BMC Control-M, CA Autosys, Korn Shell scripting, MS Excel, Harvest Workbench

State Street Corporation Quincy, MA

ETL/DataStage Developer May 2016 – May 2018

Maintained and supported enterprise data warehouse and BI systems for business-critical reporting and analytics.

Designed and developed ELT/ETL processes to extract, transform, and load data from heterogeneous sources into the Data Warehouse.

Applied business rules and data quality controls to support operational data standards and reliability.

Tuned and optimized complex ETL jobs to improve performance and reduce processing time.

Led offshore and onsite teams in solution design, development, and release support.

Created high-level design documents, source-to-target mappings, unit test scripts, and support documentation.

Environment: DataStage 11.5/8.5.0, Windows XP/NT/2000, SQL Server 2005/2008, SQL, Oracle 10g, Teradata, MS Excel, Mainframes, MS Visio

Education:

Bachelors degree from Kakatiya University – India (2013)

Masters degree from Gannon University – Pennsylvania (2015)

Contact this candidate