Data Analyst Supply Chain

Sai surya kandela

Data Analyst

• **********@*****.*** • +1-203-***-**** •

SUMMARY

Data Analyst with 4+ years of experience transforming complex datasets into actionable insights across healthcare, finance, supply chain, and operations. Proficient in SQL (PostgreSQL, MySQL), Python (Pandas, NumPy, Matplotlib), and Advanced Excel for data extraction, modeling, and automation. Skilled in building interactive dashboards with Tableau, Power BI, and Looker, enabling leadership to monitor KPIs and trends in real time. Experienced in cloud analytics platforms (AWS Redshift, Google BigQuery, Azure Synapse) and data engineering workflows (Airflow, dbt, Spark) for scalable analytics. Strong background in A/B testing, hypothesis testing, and predictive modeling, delivering measurable improvements in business performance and cost efficiency.

SKILLS

Programming & Tools: Python, SQL, R, Excel, Alteryx, SAS, dbt, Apache Airflow, Talend

Data Analysis & Modeling: Regression, Hypothesis Testing, A/B Testing, Time Series Forecasting, Clustering, Predictive Analytics, Data Mining

Visualization: Tableau, Power BI, Looker, Google Data Studio, Qlik Sense

Libraries & Packages: Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn, StatsModels, Plotly, Dask

Databases: SQL Server, MySQL, PostgreSQL, MongoDB

Cloud & Data Warehousing: AWS (S3, Redshift, Athena), GCP (BigQuery, Cloud Storage), Azure (Synapse, Data Factory, AutoML)

PROFESSIONAL EXPERIENCE

CVS Health August 2024 – Present New York Data Data Analyst

Performed deep-dive analysis on patient data to uncover factors influencing medication adherence, improving adherence rates by 14%.

Developed predictive models in Python and SQL to estimate readmission risk, contributing to a 9% reduction in hospital readmissions and lowering costs by $XM annually.

Built and maintained Tableau and Excel dashboards to visualize KPIs, enabling real-time, data-driven decisions across clinical and operational teams.

Automated recurring reporting workflows with Python and SQL, cutting manual workload by 62% and improving data accuracy.

Led A/B testing initiatives on patient engagement strategies, achieving a 17% increase in patient retention and satisfaction.

Collaborated with clinical and operations teams to refine KPIs, supporting continuous improvement in healthcare quality metrics.

Ensured compliance with HIPAA guidelines, maintaining data privacy and regulatory standards across all analytics projects.

University Of New Haven February 2024– August 2024 Newhaven, Connecticut

Data Analysis Teaching Assistant

•Assisted in delivering graduate-level courses in Data Analytics, Statistical Programming, and Business Intelligence for 50+ students.

•Provided guidance on assignments involving Python, SQL, and R, ensuring accurate data manipulation, modeling, and analysis.

•Led weekly lab sessions and office hours to support students with data cleaning, exploratory analysis, and visualization using Python (Pandas, NumPy) and R (ggplot2, dplyr).

•Designed case studies using Snowflake and Big Query for querying large datasets and optimizing SQL-based analytics workflows.

•Supported students in building predictive models and conducting statistical analysis using SAS and Python, offering one-on-one technical guidance.

•Collaborated with instructors to develop practical datasets, exercises, and tutorials aligned with real-world business problems.

•Maintained documentation, coding guides, and learning materials to improve course efficiency and student outcomes.

HSBC Bank January 2022 – July2023 India

Junior Data Analyst

•Automated month-end financial closing reports using Python scripts and Excel workflows, reducing manual processing by 40+ hours per cycle.

•Conducted data analysis on revenue streams, operational costs, and cash flows using SQL and Excel, identifying $120K+ in unallocated expenses and improving forecast accuracy.

•Designed and maintained Excel dashboards and R-based reporting templates for monitoring budget variances and financial KPIs.

•Performed variance analysis on forecasted vs. actuals across 10+ departments, identifying an 8% overspend in marketing budgets and supporting corrective decisions.

•Built automated ETL pipelines in Python to ingest ERP data into centralized warehouses, improving data consistency and reducing retrieval time by 85%.

•Partnered with compliance and audit teams to validate ledger records, support financial audits, and ensure accuracy using SQL-based queries.

EDUCATION

Master of Science in Business Analytics GPA: 3.20/4.0 New Haven, Connecticut

University of New Haven, Connecticut

CERTIFICATIONS

•AWS Certified Cloud Practitioner – Amazon Web Services

•Introduction to Data Warehouses – LinkedIn Learning

•Reporting with R Markdown – Data Camp

Contact this candidate