# Amitha Kedika

Amitha Kedika is a remote worker on Himalayas, Senior Data Analyst at The Vanguard Group, based in United States.

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

```text
Senior Data Analyst at The Vanguard Group developing investment analytics and AI-assisted workflows for natural-language insights and anomaly detection.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United States |
| Authorized to work in | United States |
| Salary expectations | 60k+ USD |
| Job categories | Data Analyst |
| Skills | Data Analysis, SQL, Power BI, Python, Business Intelligence, Exploratory Data Analysis, Statistical Analysis, Data Visualization, KPI development, Root Cause Analysis, Trend Analysis, Variance Analysis, Anomaly Detection, Data Modeling, ETL ELT |

## About

```text
At The Vanguard Group, I analyze investment, portfolio, client, and financial data to develop KPIs, dashboards, reports, and recommendations. I also develop AI-assisted analytical workflows using Amazon Bedrock, OpenAI, Python, and LLMs for natural-language insights, anomaly detection, and report summarization.

At Blue Cross Blue Shield of Michigan, I analyzed healthcare claims and operational data, improving reporting turnaround time by 20% and helping save an estimated $500K annually through root-cause analysis of payment discrepancies. Across my work at CDK Global and DataFactz, I developed SQL analysis and reporting, supported Power BI dashboards, and validated data and reporting outputs.
```

## Experience

### Senior Data Analyst (current)

[The Vanguard Group](https://himalayas.app/companies/vanguard). Sep 2025 - Present

```text
Analyze large-scale investment, portfolio, client, and financial datasets to identify trends, performance drivers, anomalies, and actionable business insights. Develop automated reporting and analytical workflows using Python, Pandas, SQL, Power BI, and AWS services.
```

Skills: SQL, Python, Pandas, Power-BI, DAX, Power-Query, S3, AWS-Glue, Amazon-Athena, AWS-Lambda, Cloudwatch, Amazon-Bedrock, OpenAI, LLM, ETL, Data-Modeling, Star-Schemas, KPI-Reporting, Ad-hoc-Analysis, Root-Cause-Analysis, UAT

### Data Analyst

[Blue Cross Blue Shield of Michigan](https://himalayas.app/companies/blue-cross-blue-shield-of-michigan). May 2023 - Aug 2025

```text
Generated and analyzed operational and claims reports, improving reporting turnaround time by 20% and reducing manual reporting effort by 30%. Played key role in RCS to PAREO migration, ensuring zero critical errors post-migration.
```

Skills: SQL, Excel, Pivot-Tables, V-Lookups, VBA-Macros, Power-Query, DAX, Python, Power-BI, Pareo, RCS, SharePoint, AWS, UAT, Data-Migration, Healthcare-Analytics, HIPAA-compliance, Ad-hoc-Analysis, Root-Cause-Analysis, AI-Assisted-Analytics

### Data Analyst

[CDK Global](https://himalayas.app/companies/cdk-global). Feb 2021 - Apr 2023

```text
Analyzed business and operational data supporting automotive dealership processes. Developed complex SQL queries and created Power BI dashboards and Excel reports to monitor sales performance, service operations, and inventory trends.
```

Skills: SQL, Power-BI, Excel, Pivot-Tables, Power-Query, AWS, Python, AWS-Data-Pipeline, UAT, KPI-Reporting, Business-Analysis, Trend-Analysis, Variance-Analysis, Root-Cause-Analysis, data-transformation, Ad-Hoc-Reporting

### Data Analyst

DataFactz. Jun 2018 - Sep 2020

```text
Collected, cleaned, and analyzed business data from multiple sources to support operational and management reporting. Developed SQL queries and created Excel reports, dashboards, and KPI summaries for business stakeholders.
```

Skills: SQL, Excel, Pivot-Tables, Excel-Charts, Power-BI, KPI-Reporting, Business-Intelligence, Ad-Hoc-Reporting, Business-requirements-analysis, Data-Quality

## Education

### Jawaharlal Nehru Technological University Hyderabad

Bachelor's, Information Technology

```text
Bachelor's degree in Information Technology from JNTU Hyderabad, completed in May 2018.
```

## Tech stack

- AWS Glue
- Amazon CloudWatch
- NumPy
- Pandas
- MySQL
- PostgreSQL
- Oracle
- Jira
- Python
- AWS Lambda
- Git
- Amazon Athena
- SQL
- Power BI

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

## People also viewed

- [Asritha User](https://himalayas.app/@asrithauser): Data Analyst, HCA Healthcare
- [Shashidhar Reddy](https://himalayas.app/@shashidharreddy): Data Analyst, Cigna Group
- [Harimaheswar Reddy T](https://himalayas.app/@harimaheswarreddyt): Data Analyst, Cigna Healthcare
- [Sahithi Palumari](https://himalayas.app/@sahithipalumari): Senior Data Analyst, Cigna Healthcare
- [Navya Sree Madagoni](https://himalayas.app/@navyasreemadagoni): Senior Data Analyst, Vanguard
- [Basheerunisa Shaik](https://himalayas.app/@basheerunisashaik): Business Analyst, Humana
- [Shiva sai Pothnak](https://himalayas.app/@shivasaipothnak): Data Analyst, Tenet Healthcare
- [Hemanth Garnapally](https://himalayas.app/@hemanthgarnapally): Data Analyst, JPMorgan Chase
- [sreya p](https://himalayas.app/@sreyap): Senior Data Analyst, Capital One
- [DARA ABHIGNA](https://himalayas.app/@daraabhigna): Sr. Data Analyst, Aetna, CVS Health