Akanksha Gurram

01. About Me

I'm a Data Analyst with 4+ years of experience across healthcare and financial services, writing SQL at scale, building dashboards executives rely on, and automating the reporting work nobody wants to do manually.

At Morgan Stanley and Cigna, my work cut reporting time by 30–40% and helped teams spot patterns they'd been missing for months. I collaborate well with both engineers and business leads, and I'm at my best when the problem isn't fully defined yet.

4+ Years Experience

$4M Cost Reduction

30+ Dashboards Built

3 Certifications

Masters in Computer Science

University of Missouri Kansas City, MO, USA | Jan 2022 – Jul 2023

Based in the USA

Open to remote, hybrid, and on-site Data Analyst roles

02. Skills & Expertise

Languages

SQL CTEs Window Functions Python Pandas NumPy SciPy Scikit-learn R DAX VBA

BI & Visualization

Power BI Tableau Looker Amazon QuickSight Advanced Excel PivotTables Power Query Macros

Cloud & Data

Snowflake Amazon Redshift Azure Synapse AWS S3 AWS Glue AWS Lambda GCS Teradata Databricks

ETL & Pipelines

SQL Pipelines Apache Airflow AWS Glue Snowpipe dbt CI/CD Anomaly Detection

AI & Machine Learning

Generative AI / LLMs ChatGPT API Copilot AutoML K-Means Clustering ARIMA Forecasting Predictive Modeling Feature Engineering

Analytics

A/B Testing Cohort Analysis Regression Time Series Forecasting Root Cause Analysis KPI Design Data Storytelling

Tools & Process

Git / GitHub Jira Confluence Agile / Scrum Stakeholder Reporting BRDs FRDs Sprint Planning

03. Experience

Mar 2025 – Present Full-Time

Data Analyst II

Morgan Stanley | USA

Built SQL and Python data models in Snowflake tracking KPIs across 3 financial portfolios, improving team visibility into revenue and client trends.
Launched 6 executive dashboards in Power BI and Tableau, cutting reporting turnaround by 30% and giving leadership same-day access to key metrics.
Ran cohort and funnel analysis that flagged a client segment driving 38% of product revenue — directly shaped the Q2 retention strategy.
Automated 12+ recurring reports with SQL and Excel, saving 35% of weekly analyst time and eliminating a recurring data inconsistency issue.
Led scenario modeling in Excel for C-suite stakeholders, supporting 3 major decisions including a pricing adjustment and client tier restructure.
Worked across Product, Finance, and Risk in Agile sprints, turning vague business questions into clean analysis delivered within 5-day turnarounds.

Snowflake Power BI Tableau SQL Python Agile

Jan 2023 – Mar 2025 Full-Time

Data & Business Strategy Analyst

Cigna Health | USA

Analyzed 300K+ claims and patient records to surface cost drivers and utilization gaps, supporting a $4M cost reduction initiative for a major plan.
Rebuilt SQL pipelines across 8 reporting streams, reducing data discrepancies by 30% and fixing a recurring reconciliation issue impacting financial close.
Built a Power BI and Tableau dashboard suite tracking 15 healthcare KPIs, adopted as the primary reporting tool by 4 clinical operations teams.
Designed an anomaly detection framework in SQL and Python that caught 1,200+ erroneous claims monthly, strengthening audit and compliance reporting.
Automated 9 weekly reports using SQL macros, cutting manual effort by 40% and freeing up 6+ analyst hours each week for higher-value work.
Partnered with clinical, ops, and finance teams across 20+ working sessions to translate findings into practical changes in care delivery processes.

Healthcare Analytics SQL Python Power BI Anomaly Detection

May 2020 – Dec 2021 Full-Time

Data Analyst

HCL Technologies | Hyderabad, India

Tracked 10 KPIs across sales, inventory, and fulfillment for 3 supply chain units using SQL and Excel, enabling weekly decisions for regional ops leads.
Built Tableau dashboards covering 500+ SKUs for inventory and fulfillment health, reducing reporting turnaround by 30% over the prior Excel process.
Identified a vendor lead-time pattern behind 15% of stockouts through root-cause analysis — recommendation was adopted by the supply chain team.
Created 25+ reusable SQL views and standard reporting datasets, cutting ad-hoc data requests by 40% and aligning metric definitions across 3 teams.
Optimized high-volume SQL queries on 10M+ row datasets using indexing and window functions, improving average execution time by 20–25%.

Supply Chain SQL Tableau Query Optimization

04. Projects

Dashboard & Segmentation

$50M+ Revenue

Revenue & Customer Segmentation Dashboard

Built a Power BI dashboard analyzing $50M+ in revenue across 8 segments, pinpointing cohorts generating 60% of total revenue. Ran K-Means clustering on 10K+ customers using an RFM model in Python — output became the base for a targeted retention and upsell strategy. Automated the data refresh pipeline with SQL and Power Query, cutting weekly reporting prep from 4 hours down to under 15 minutes.

Power BI Python SQL K-Means RFM

Healthcare Analytics

89% Forecast Accuracy

Healthcare Cost & Utilization Analysis

Analyzed 100K+ synthetic claims to find that 12% of members accounted for 47% of spend — insight mapped directly to care management prioritization. Built a Tableau storyboard with demographic and diagnosis drill-throughs, reducing time-to-insight from days to minutes. Applied ARIMA forecasting to project 90-day utilization with 89% accuracy.

Python Tableau SQL ARIMA

Experimentation

$240K ARR Impact

A/B Testing: Onboarding Conversion Lift

Designed an A/B test across 5,000 simulated users using a two-proportion z-test with proper sample size calculation. Variant B showed an 18% lift in 7-day activation (p = 0.03), documented in a Jupyter notebook with plain-language business takeaways. Built a Power BI summary translating results into an estimated $240K ARR impact.

Python SQL Statistics Power BI

05. Highlights & Certifications

Impact Highlights

$4M

Cost reduction supported at Cigna Health

30–40%

Reporting time cut across Morgan Stanley & Cigna

1,200+/mo

Erroneous claims caught via anomaly detection

89%

ARIMA forecast accuracy on 90-day utilization

Certifications

AWS Certified Solutions Architect – Associate

Amazon Web Services | SAA-C03

Microsoft Certified: Azure Data Engineer Associate

Microsoft | DP-203

Google Data Analytics Professional Certificate

Google | Coursera

Cross-Functional Strengths

Stakeholder Translation

Product, Finance, Risk, Clinical, Ops

Turn vague business questions into clean analysis delivered within 5-day turnarounds

Automation Mindset

SQL macros, Power Query, Airflow, dbt

Automated 20+ recurring reports across roles, freeing analyst hours each week

Domain Range

Healthcare claims + Financial portfolios

Comfortable with HIPAA-sensitive data, financial KPIs, and supply chain metrics