# shah ahmed

shah ahmed is a remote worker on Himalayas, Senior Data Analyst at Citi Bank, based in United States.

Source: https://himalayas.app/@shahahmed

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

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | United States |
| Authorized to work in | United States |
| Job categories | Senior Data Analyst, Data Engineer, Business Intelligence Analyst, Data Governance Analyst, Data Scientist, Senior Data Analytics, Senior Level Data Analyst, Senior Staff Data Analyst, Senior Analytics Analyst, Senior BI and Data Analyst, Senior Data Analyst Roles |
| Skills | AWS Glue, Snowflake, SQL, Hive, Impala, Hue, ETL, Data Modeling, Data Pipelines, Data Quality, Data Governance, Collibra, Data Lineage, Power BI, Tableau, IBM Cognos Analytics, Jira, Confluence, VersionOne, AWS Data Engineer – Associate, AWS AI Services, Rekognition, Comprehend, Polly, DynamoDB, Hadoop, Spark, Ansible, Bitbucket, GitHub, Jenkins, Kafka, Matrix, PyCharm, S3, Unify |

## What I'm looking for

```text
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.
```

## About

```text
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

### Senior Data Analyst (current)

[Citi Bank](https://himalayas.app/companies/citibank-switzerland-ag). Jul 2024 - Present

```text
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.
```

Skills: Data-Quality, Data-Governance, Root-Cause-Analysis, ETL, Data-Pipelines, SQL, AWS-Glue, Snowflake, Data-Cataloging, Partitioning, Query-Optimization, Comprehend, Data-Cleaning, S3

### Senior Data Analyst

[Bank of America](https://himalayas.app/companies/bank-of-america). Feb 2022 - Jun 2024

```text
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.
```

Skills: 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](https://himalayas.app/companies/citibank-switzerland-ag). Aug 2021 - Jan 2022

```text
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.
```

Skills: Proxy-Default-Logic, Data-Analysis, Data-Visualization, Cognos, Power-BI, Excel-Pivot-Tables, Tableau, DQC, Data-Validation, Kafka

### Senior Data Analyst

Capital One Financial Corporation. Jul 2018 - Sep 2019

```text
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.
```

Skills: 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

```text
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.
```

Skills: 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

```text
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.
```

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

### Senior Data Analyst

[Wells Fargo Bank](https://himalayas.app/companies/wells-fargo). Feb 2014 - Jun 2014

```text
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.
```

Skills: Account-Opening, End-To-End-Testing, Data-Integrity, Brokerage-Advisory-Workflow-Testing, Thomson-Reuters-BETA-Systems-Integration, AML, InfoMax, VersionOne, Tableau, Bloomberg-Terminal, Robo-Advisory-Integration, Discretionary-Non-Discretionary-Workflows

## Education

### Ashland University

Master of Business Administration, Business Administration

```text
Earned a Master of Business Administration (MBA) from Ashland University in Ohio.
```

## Tech stack

- AWS Glue
- GitHub
- Bitbucket
- Jenkins
- Hadoop
- Gmail
- PyCharm
- Jira
- Kafka
- Ansible
- Root Cause
- SQL
- Collibra
- Transform
- Dynamic
- Matrix
- Remote
- Check
- Unify

To contact shah, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Gaurav Shridhar](https://himalayas.app/@gauravshridhar): Senior Data Analyst, Broadridge Financials
- [Meenal Garg](https://himalayas.app/@meenalgarg): Data Analytics Tech. Lead, Freddie Mac
- [Ali Bashir](https://himalayas.app/@alibashir): Sr. Data Analyst, Wintrust Financial
- [Tarun Shrestha](https://himalayas.app/@tarunshrestha): Sr. Data Analyst, Lone Star Financing
- [Faisal Tahir](https://himalayas.app/@faisaltahir): Senior Data Analyst, First American Bank
- [Dhruti Gaudana](https://himalayas.app/@dhrutigaudana): Senior Data Analyst, AIonix11
- [Harish Dammigari](https://himalayas.app/@harishdammigari): Business Data Analyst, SGI
- [Naveenreddy Lankela](https://himalayas.app/@naveenreddylankela): Senior Data Analyst, Hitachi
- [Jyothi Boyina](https://himalayas.app/@jyothiboyina): Assistant Vice President, IT Sr Data Quality Analyst, Citigroup
- [Dolma Gurung](https://himalayas.app/@dolmagurung): Data Analyst / Analytics Engineer, Bank of America
