Looking for a job

Amitha Kedika

@amithakedika

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

United States

Message

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

Work history, roles, and key accomplishments

Current

Senior Data Analyst

Current

The Vanguard Group

Sep 2025 - Present (1 year)

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.

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

May 2023 - Aug 2025 (2 years 3 months)

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.

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

Feb 2021 - Apr 2023 (2 years 2 months)

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.

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 (2 years 3 months)

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.