Skip to content

Hema Likhitha Adapa

Business Analyst • Austin, TX • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Business Analyst with 3+ years of experience in healthcare and financial services, specializing in data analysis, business intelligence, and process optimization. I have a strong track record of translating complex business requirements into actionable insights and scalable solutions that drive operational efficiency and strategic decision-making.

Technical Skills

Programming Language: Python,R,SQL
Cloud Platforms: AWS,S3,AWS Athena
Data Analysis & Visualization: Microsoft Excel,Power BI,Tableau,QuickSight,Looker,KPI Reporting,Alteryx
UI/UX Design: A/B Testing
Supply Chain Management: Pricing Strategy,Competitive Pricing Analysis,Price Elasticity,Promotional Pricing,Merchandising Analytics,Price Index,Markdown Optimization
ERP & Supply Chain Systems: SAP
Project Management & Collaboration: Gap Analysis,SWOT Analysis,Risk Analysis,Jira,Microsoft Project,Agile,Scrum,Waterfall,SDLC
Enterprise Platforms: SharePoint
Process Modeling & Documentation: Requirements Gathering,Microsoft Visio,BRD,FRD,Process Flow Diagram
Financial Planning & Analysis (FP&A): Cost-Benefit Analysis,Financial Modeling

Work Experience

Cigna Health
United States
Business Analyst
Apr 2025 – Present
Global health insurance & services provider; supported merchandising and business leaders with data-driven pricing dashboards, models, and analytics to accelerate and sharpen strategic price decisions.
  • Built and maintained category-level pricing and operational dashboards in Power BI with drill-down capabilities, enabling merchandising and business leadership to evaluate pricing trends and make strategic price recommendations; improved reporting efficiency by 45% and reduced decision-making time by 30%.
  • Analyzed large-scale datasets using SQL to identify pricing inefficiencies, cost anomalies, and competitive pricing gaps, delivering ad-hoc pricing analyses and recurring reports to business stakeholders and leadership teams.
  • Developed category-specific pricing models in Excel and Python (Pandas) to evaluate historical pricing effectiveness and recommend forward-looking price changes aligned with financial targets.
  • • Collaborated with merchandising and cross-functional leadership to define financial targets and competitive pricing logic, translating complex data into clear, actionable pricing recommendations for non-technical audiences.
  • Optimized SQL-based ETL pipelines integrating data from multiple systems, improving data processing efficiency by 18% and reducing query execution time by 15%, enabling faster access to large pricing datasets.
  • Conducted root cause analysis on pricing and operational data, surfacing category-level trends and communicating insights to merchandising and leadership teams through structured presentations.
Mphasis
Business Analyst
Feb 2022 – Aug 2023
IT consulting and services firm; delivered interactive dashboards and statistical analyses that informed client category pricing strategies and streamlined financial and performance reporting.
  • Developed interactive Power BI dashboards to monitor category-level KPIs including budget variance, cost-to-revenue ratios, and ROI, directly supporting pricing strategy evaluation and competitive pricing decisions with business leadership.
  • Performed segmentation and competitive pricing analysis on large customer and portfolio datasets using SQL and Python to identify high-value segments and inform price recommendations and resource allocation strategies.
  • • Executed A/B testing and statistical analysis on pricing strategies and promotional pricing campaigns, improving ROI by 18% through data-backed price change recommendations presented to merchandising leadership.
  • Evaluated historical pricing effectiveness across categories and business units, presenting findings and strategic price recommendations to leadership to guide future pricing and financial planning cycles.
  • Automated financial and pricing performance reporting using Excel and AWS Athena across very large datasets, reducing manual reporting effort by 30% and accelerating insight delivery to stakeholders.

Education

Northwest Missouri State University
Master of Science in Computer Science • Aug 2023 – Dec 2024
KKR & KSR Institute of Technology and Sciences
Bachelor of Technology in Computer Science • Aug 2019 – May 2023

Powered by Drivetube · Create your own profile at drivetube.ai

Everything on Drivetube

Six products, two of them free forever. Start wherever you are.

Read the docs →
  • Your free digital resume

    at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept.

    Documentation
  • Verified jobs, posted in the last 3 days

    verified openings crawled ATS-by-ATS from 160,000+ real company career pages across 50+ ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed.

    Documentation
  • Written by senior career writers

    human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile.

    Documentation
  • Drivetube OneFrom $39.99 / 3 mo

    Daily matched jobs, tailored resumes, or we apply for you

    Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.

    Documentation
  • For employers — no job postings, no applications

    hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do.

    Documentation
  • Documentation

    every product explained in full, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

  • Playbooks

    tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.

Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.