Vamshi Krishna Edulakanti
Data Analyst
**********@*****.*** +1-989-***-**** MI www.linkedin.com/in/vamshike802
SUMMARY
Data Analyst with 3+ years of experience in healthcare, finance, and retail domains. Skilled in SQL, Python, Power BI, Tableau, and cloud platforms (Azure, AWS, Snowflake, Redshift, BigQuery). Experienced in healthcare analytics (Epic, claims, HIPAA compliance) and financial forecasting/risk modeling, with a proven record of optimizing reporting workflows, enhancing data accuracy, and delivering actionable insights.
TECHNICAL SKILLS
Programming Languages: Python, R, SQL
Methodologies: SDLC, Agile, Waterfall, EDA, Forecasting, A/B Testing, Logistic Regression, Time Series Analysis
Databases & ETl SQL (MySQL, Azure SQL, Redshift), Azure Data Factory, AWS Glue/S3
Healthcare Tools: Epic Payer Platform, HIPAA, Medicare/ Medicaid reporting
Big Data Tools: Apache Kafka, Spark, Airflow, Hadoop, Hive
Data Warehousing: Snowflake, Amazon Redshift, Google Big Query
Project Management Tools: JIRA, Confluence, BRS, BRD, PRD, User Stories, Stakeholder engagement, Agile collaboration
Data Analytic Skills: Data Mining, Data Cleaning, Statistical Analysis, Data Visualization
Data Visualization Tools: Tableau, Power BI, AWS Quick sight, Matplotlib, Seaborn, Plotly, SSRS
Machine Learning Skills: Scikit-learn, Random Forest, Predictive Modeling, Clustering and Time Series Analysis
PROFESSIONAL EXPERIENCE
Molina Healthcare Feb 2025 – Current
Data Analyst MI
●Built automated capacity planning and healthcare utilization reports with Python (NumPy, Pandas, Matplotlib), streamlining reporting workflows and improving healthcare operations efficiency by 25%.
●Analyzed patient claims, provider performance, and care delivery datasets using SQL and Power BI to identify inefficiencies, driving a 20% improvement in resource allocation across healthcare networks.
●Analyzed Epic Payer Platform datasets to identify patterns in patient engagement and claims processing, delivering insights that improved care coordination and reduced administrative delays by 15%.
●Developed and optimized complex SQL queries (joins, sub-queries) for healthcare data profiling, improving patient and provider reporting accuracy by 30%
●Leveraged Azure SQL Database and Power BI to process and visualize large clinical and claims datasets, improving reporting speed and enabling timely decision-making for care management teams.
●Delivered actionable insights via Power BI dashboards, Excel (Pivot Tables, Power Query, Charts), and PowerPoint, analyzing member engagement data and providing recommendations to improve patient experience and outreach strategies.
Cybage Dec 2020 – Dec 2022
Business Intelligence Analyst India
● Conducted EDA on 10M+ financial records with Python (Pandas, NumPy), using time series decomposition (STL & Prophet) to identify seasonal trends and anomalies, boosting revenue forecasting accuracy by 15%.
●Built predictive models (logistic regression in Scikit-learn) with SHAP interpretability, driving $1.2M in annual cross-sell revenue.
●Implemented A/B testing frameworks (Python StatsModels) to evaluate marketing campaigns, achieving 95% statistical confidence and optimizing ad spend by 30%.
●Optimized MySQL schemas to streamline reporting workflows, cutting monthly report generation time by 35%.
●Automated financial variance analysis with Excel Power Query & Monte Carlo simulations, reducing FP&A cycle time by 40% and enhancing scenario modeling.
● Leveraged AWS Glue & S3 to curate near-real-time datasets, accelerating ad-hoc analysis by 25% and improving time-to-insight.
●Developed quantitative models in R/Python, contributing to $200K operational cost savings and improving process efficiency by 25%.
●Translated business needs into BRDs/FRDs, aligning KPIs (CAC, ROI) with goals, and cutting misalignment issues by 20%.
●Collaborated with stakeholders in Agile workflows, ensuring 95% on-time delivery of analytics insights to guide quarterly strategic pivots.
Value Labs Dec 2019 – Nov 2020
Data Analyst India
●Coordinated with 3+ business teams to design Tableau dashboards (scatter plots, maps, trend charts), reducing time spent on manual reporting by 25% and enabling faster insights into procurement and customer behavior.
●Coordinated with business and procurement teams to design Tableau dashboards (scatter plots, maps, trend charts), reducing manual reporting time by 25% and enabling faster insights.
●Integrated data from Oracle, ServiceNow, and procurement tools into Tableau, resolving silos and improving cross-departmental decision-making.
●Wrote and optimized SQL queries for customer feedback and sales anomaly analysis, reducing response time by 50% and supporting executive reporting.
●Cleaned and preprocessed datasets in Python (Pandas) with high accuracy, enabling reliable analysis of customer churn drivers and financial trends.
●Assisted in developing ETL workflows in AWS Redshift, improving data accessibility for reporting by 25%.
●Supported projects with basic SDLC methodologies, ensuring structured workflows and more predictable outcomes.
●Conducted customer feedback sentiment analysis, helping reduce complaints by 20% and improving satisfaction tracking.
●Established data validation checks and quality standards, improving dataset reliability by 30%.
●Collaborated with Finance, Procurement, and IT teams to resolve 15+ data bottlenecks, identifying profitability trends and unlocking $500K+ in revenue.
●Executed A/B testing on product features, leading to a 12% increase in user adoption through data-backed prioritization.
EDUCATION
Central Michigan University Jan 2023 - Dec 2024
Master of Science in Information Systems MI, USA
Sri Indu College of Engineering and Technology Jun 2016 – May 2020
Bachelor of Technology in ECE India
PROJECTS
Healthcare Cost and Insurance Data Analysis
WEB scraped and processed 15.6M+ records spanning 178,893 HIPAA codes and 400+ insurance providers using Python (BeautifulSoup, Pandas), ensuring data consistency and accuracy.
Designed and hosted a scalable PostgreSQL database on AWS (EC2, S3, RDS), securely managing 6M+ records and delivering APIs, improving healthcare cost transparency and enabling informed decision-making for users.
Credit Card Financial Analytics Dashboard Development
Developed an interactive Credit Card Financial Dashboard using Power BI, integrating SQL data, providing real-time insights and cutting down report generation time by 60%.
Implemented DAX queries for revenue trend analysis, weekly performance tracking, and KPI monitoring, leading to a 28.8% increase in revenue insights and improved strategic decision-making.
Netflix Product Strategy and User Experience Analysis
Administered product research and competitive analysis, developing PRDs, user surveys, and pain point assessments to refine features, enhance user experience, and support data-driven decision-making for strategic product improvements.
Collaborated with a team of students to oversee feature development and analyzing Netflix’s innovation, market expansion, user experience optimization and user engagement strategies as part of an academic project.
CERTIFICATIONS
●Microsoft Certified: Azure Data Engineer Associate (DP-203)
●Google Cloud Certified Data Analyst