Open to opportunities

shah ahmed

@shahahmed

Message

Senior data analyst delivering enterprise-scale data solutions with strong ETL expertise.

United States

Message

What I'm looking for

I’m open for REMOTE POSITION, looking to drive ETL/data pipelines, data quality, and governance in regulated environments—improving efficiency, automation, lineage, and compliance through reliable, high-performance analytics systems.

I’m a Senior Data Analyst with 10+ years of experience designing and delivering enterprise-scale data solutions for large financial institutions. I specialize in ETL frameworks and data integration systems, with a strong focus on data modeling, data quality, and governance.

In my current role, I’ve worked to reduce regulatory and classification risk by updating source logic and data attributes to accurately identify and tag “Combo” loans under U.S. Basel regulations and CCAR 14M requirements. I also enforce data quality controls (for example, mandatory population based on status_type_code) and perform root cause analysis to resolve mismatches between sources and loan modification documents.

I build end-to-end pipelines that extract from SQL systems, transform, and securely load into AWS S3, then optimize analytics workflows through AWS Glue and Snowflake integrations. I’ve automated ingestion, partitioning, and query optimization for reporting, and used AWS AI services (Rekognition, Comprehend, Lex, Polly) to support real-world business solutions.

I’m equally comfortable strengthening governance: I use Collibra for metadata management, define operating models with clear roles and workflows, and document data lineage and controls across layers. Earlier, I supported compliance-focused initiatives such as OFAC screening migrations and wealth management validation controls—always with an emphasis on auditability, traceability, and reliable outcomes.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Analyst

Current

Citi Bank

Jul 2024 - Present (2 years)

Updated loan classification source logic to correctly tag agency vs. combo loan scenarios to mitigate regulatory risk (Volcker Rule, U.S. Basel/CCAR 14M). Built and optimized cloud ETL pipelines in AWS/Snowflake and enforced data quality controls for loan attributes.

Data Quality Data Governance Root Cause Analysis ETL Data Pipelines SQL AWS S3 AWS Glue Snowflake Data Cataloging Partitioning Query Optimization Data Cleansing Comprehend

Senior Data Analyst

Bank of America

Feb 2022 - Jun 2024 (2 years 4 months)

Designed ETL solutions to transform transactional data into dimensional models using Snowflake and AWS, supporting data quality and governance objectives. Built a metadata management platform in Collibra integrated with Tableau and developed data lineage documentation and data ingestion controls.

ETL Snowflake AWS Dimensional Models Data Ingestion Collibra Tableau Data Governance Data Lineage Data Mapping DynamoDB Hive Hue Impala Data Quality Agile Ceremonies PyCharm Spark SQL Hadoop

Senior Data Analyst

Citibank

Aug 2021 - Jan 2022 (5 months)

Developed and enhanced proxy default logic frameworks to address missing, inconsistent, and inaccurate data across exposure types. Supported reporting and risk analysis with IBM Cognos/Power BI/Tableau and validated data quality with data quality rules and ETL/reporting workflows.

Proxy Default Logic Data Analysis Data Visualization Cognos Power BI Excel Pivot Tables Tableau DQC (Expression Data Validation Kafka

Senior Data Analyst

Capital One Financial Corporation

Jul 2018 - Sep 2019 (1 year 2 months)

Led migration and integration of commercial banking documents from legacy platforms (See Docs/FileNet) to the One View system, evaluating feasibility, architecture, and user requirements. Validated business reports with SQL, migrated multi-format documents, and supported integrated search across document repositories.

Migration SQL Enterprise Content Management Integrated Search Data Acquisition Data Aggregation Statistical Analysis PDF AFP Jenkins Ansible AWS Azure Maven Puppet Docker GitHub Confluence

Senior Data Analyst

Mitsubishi Trust Bank

Sep 2016 - Jun 2018 (1 year 9 months)

Led migration of OFAC screening systems from legacy 314(a) FIS to FircoSoft to improve sanctions compliance and screening accuracy. Defined validation workflows, reconciliation/audit trail requirements, and produced compliance monitoring reporting with PRIME Compliance Suite.

PEP DFAT EU Compliance PRIME Compliance Suite FircoSoft FIS Prime Systems Validation Accuracy Vendor Log Validation Jira Data Integration INNO MUTB Fedwire

Senior Data Analyst

Morgan Stanley Investment Bank

Jul 2014 - Aug 2016 (2 years 1 month)

Enhanced validation controls and data workflows supporting Offshore Mutual Fund selection for UMA account onboarding and proposal processes. Built a requirement traceability matrix, validated offshore eligibility with World-Check/BlueSky, and integrated an MFT Offshore Calendar API to align trade and settlement cycles.

Requirements Traceability Matrix World Check Bluesky Offshore Mutual Fund Eligibility MFT Offshore Calendar API Integration Unify SRS Workflows Risk & Analytics Lydia Health Check Control Panel Invesment Screener

Senior Data Analyst

Wells Fargo Bank

Feb 2014 - Jun 2014 (4 months)

Supported enhancements and development of New Account Opening (NAO) and maintenance processes across advisory, brokerage, and mutual fund platforms. Contributed to end-to-end testing and integrated SIGFIG Online Investment Advisor into InfoMax, validating data integrity and client account lifecycle flows.