# Hemanth Garnapally

Hemanth Garnapally is a remote worker on Himalayas, Data Analyst at JPMorgan Chase, based in United States.

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

```text
Data Analyst at JPMorgan Chase building consumer banking reporting and AI-assisted compliance tools.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | United States |
| Authorized to work in | United States |
| Job categories | Data Analyst |
| Skills | SQL, Data Analysis, Power BI, Snowflake, DBT, Python, ETL ELT Data Pipelines, Data Modeling, Financial Reporting, Healthcare Analytics, Consumer Banking, Financial Audit, Data Reconciliation, Data Quality, Data Governance |

## About

```text
At JPMorgan Chase, I consolidated four consumer banking systems into a Power BI reporting suite tracking 18 executive KPIs, reducing weekly close preparation from eight hours to under two. I also replaced an overnight batch job with same-day Snowflake transformation workflows.

I developed dbt data contracts and validation tests to address month-end schema drift, reducing flagged general-ledger exceptions from roughly 500 to under 40. I also deployed an Azure OpenAI Service workflow that routes regulatory compliance queries to the right review team.

At Blue Cross Blue Shield, I worked on claims analytics and member risk segmentation, including a K-means model for 180,000 members across six chronic-condition risk tiers. I also helped establish a governed Snowflake reporting layer for medical loss ratio, claims denial, and network adequacy metrics.

At KPMG, I built operational dashboards for manufacturing clients and developed SSIS data-cleansing and audit pipelines. My project work has also included customer and sales analytics platforms, using Snowflake, dbt, Python, Power BI, BigQuery, and Looker Studio.
```

## Experience

### Data Analyst (current)

[JPMorgan Chase](https://himalayas.app/companies/jpmorgan-chase-co). May 2025 - Present

```text
Consolidated upstream consumer banking systems into a Power BI financial reporting suite tracking 18 executive KPIs, cutting weekly close-prep from 8 hours to under 2. Replaced overnight batch jobs with same-day Snowflake transformation workflows and deployed Azure OpenAI Service for document classification.
```

Skills: Power-BI, Snowflake, DBT, T-SQL, Microsoft-Fabric, Azure-OpenAI, Python, Pandas, Jira, Agile-Scrum

### Data Analyst

[Blue Cross Blue Shield](https://himalayas.app/companies/blue-cross-blue-shield-association). Dec 2024 - Apr 2025

```text
Engineered a claims analytics pipeline using SQL window functions and CTEs across adjudicated claims data for 8 regional populations. Applied K-means clustering to segment 180,000 members into risk tiers and implemented HIPAA-compliant PHI masking and RBAC.
```

Skills: SQL, Snowflake, scikit-learn, HIPAA, RBAC, Confluence

### Data Analyst

[KPMG](https://himalayas.app/companies/kpmg-india). Jan 2020 - Jan 2023

```text
Built Tableau operational dashboards for manufacturing clients, unifying KPIs from 5 source systems. Developed variance-detection scripts in R and established ETL pipelines in SSIS with SOX data lineage documentation.
```

Skills: Tableau, SSIS, R, SQL, DAX, Excel, Power-Query

## Education

### Saint Peter's University

Master of Science, Business Analytics. 2023 - 2024. Grade: 3.5

```text
Master of Science in Business Analytics from Saint Peter's University, completed from February 2023 to November 2024 with a GPA of 3.5.
```

### Osmania University

Bachelor of Business Administration, Business Administration. 2016 - 2020. Grade: 3.9

```text
Bachelor of Business Administration from Osmania University, completed from June 2016 to May 2020 with a GPA of 3.9.
```

## Tech stack

- Snowflake
- AWS Glue
- Tableau
- Looker
- ggplot2
- Microsoft Azure
- Google Cloud Platform
- Amazon S3
- NumPy
- Pandas
- dbt
- Databricks
- Microsoft Teams
- Azure DevOps
- Jira
- Python
- scikit-learn
- Confluence
- AWS Lambda
- Git
- SQL
- Azure Blob Storage
- LangChain
- Delta Lake
- Great Expectations
- Microsoft Fabric
- Matplotlib
- Retrieval-Augmented Generation (RAG)
- Power BI
- Looker Studio
- AWS

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

## People also viewed

- [Shashidhar Reddy](https://himalayas.app/@shashidharreddy): Data Analyst, Cigna Group
- [Deepthi Pamisetty](https://himalayas.app/@deepthipamisetty2): Data Analyst, JP Morgan Chase & Co.
- [Rajasree Tella](https://himalayas.app/@rajasreetella): Data Analyst, JPMC
- [Sanjay Kumar Sigiri](https://himalayas.app/@sanjaykumarsigiri): Senior Data Analyst, U.S. Bank
- [SUSMITHA KALLI](https://himalayas.app/@susmithakalli): Data Analyst, Fifth Third Bank
- [Sreeja Nama](https://himalayas.app/@sreejanama): Sr. Data Analyst, Discover Financial Services
- [Amitha Kedika](https://himalayas.app/@amithakedika): Senior Data Analyst, The Vanguard Group
- [sreya p](https://himalayas.app/@sreyap): Senior Data Analyst, Capital One
- [mohammed User](https://himalayas.app/@mohammeduser28): Data Analyst, AT&T
- [Dolma Gurung](https://himalayas.app/@dolmagurung): Data Analyst / Analytics Engineer, Bank of America