Amitha Kedika

Senior Data Analyst

The Vanguard Group

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.

SQLPythonPandasPower BIDAXPower QueryS3AWS GlueAmazon AthenaAWS LambdaCloudwatchAmazon BedrockOpenAILLMETLData ModelingStar SchemasKPI ReportingAd hoc AnalysisRoot Cause AnalysisUAT

Data Analyst

Blue Cross Blue Shield of Michigan

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.

SQLExcelPivot TablesV LookupsVBA MacrosPower QueryDAXPythonPower BIPareoRCSSharePointAWSUATData MigrationHealthcare AnalyticsHIPAA compliance

Data Analyst

CDK Global

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.

SQLPower BIExcelPivot TablesPower QueryAWSPythonAWS Data PipelineUATKPI ReportingBusiness AnalysisTrend AnalysisVariance AnalysisRoot Cause Analysisdata transformationAd Hoc Reporting

Data Analyst

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.

SQLExcelPivot TablesExcel ChartsPower BIKPI ReportingBusiness IntelligenceAd Hoc ReportingBusiness requirements analysisData Quality