Data Analyst - KPI Insights & Automated Reporting Expert

Poojitha Guntupalli

Data Analyst

+1-551-***-**** ************@*****.***

SUMMARY

Data Analyst with 4+ years of experience delivering KPI-driven insights, building automated reporting solutions, and developing scalable data pipelines across healthcare and financial domains. Skilled in SQL, Python, Power BI, ETL development, data modeling, DAX, AWS analytics services, and advanced Excel for end-to-end data analysis. Proven track record of reducing manual effort, increasing forecast accuracy, and improving data quality through automation and process optimization. Adept at translating business requirements into analytical solutions and collaborating with cross-functional teams in Agile/Scrum environments. Committed to driving data-informed decision-making through accurate reporting, clear visualizations, and strong analytical methodologies.

SKILLS

Programming & Analytics: Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn), SQL, R, Statistical Analysis, Data Wrangling, Data Cleaning

Business Intelligence & Visualization: Power BI (DAX, Power Query, Row-Level Security), Tableau (LOD Expressions), Excel Dashboards (Pivot Tables, VBA Macros), KPI & Metric Development Databases: SQL Server, PostgreSQL, Oracle, MySQL, Snowflake, Amazon Redshift, Azure SQL Database Cloud Platforms: AWS (S3, Redshift, Glue, Athena, Lambda), Azure Synapse Analytics, Azure Data Factory, GCP BigQuery. ETL & Data Pipelines: SSIS, ADF Pipelines, Python ETL Scripts, Power Query, Airflow (basics), Data Warehouse Concepts

(Star/Snowflake Schema)

Statistics & Modeling: Regression (Linear/Logistic), Forecasting Models, Time Series (ARIMA, Prophet), Clustering (K-Means, DBSCAN), Hypothesis Testing, A/B Testing

Automation & Optimization: Power Automate, Python Scripting, Excel VBA, Workflow Automation, Report Scheduling Tools & Platforms: Git, GitHub, Bitbucket, JIRA, Confluence. Methodologies & Other Agile/Scrum, Data Governance, Data Quality Frameworks, Data Modeling, Data Storytelling, SDLC. Additional Professional Skills: Stakeholder Management, Requirements Gathering, Cross-functional Collaboration, Business Process Mapping, Problem-Solving, Presentation Skills WORK EXPERIENCE

Molina Healthcare, NY. Aug 2023 – Present

Data Analyst

• Designed and developed interactive Power BI dashboards for member utilization, claims aging, HEDIS quality metrics, and provider performance, enabling data-driven decisions for care management and compliance teams.

• Automated high-volume claims and utilization datasets using Python, SQL, and ETL workflows, reducing manual reporting effort by 40% and improving data refresh reliability.

• Conducted regression modeling, risk-score analysis, and trend forecasting to support targeted care interventions and improve accuracy of member risk stratification.

• Integrated and validated data from AWS Redshift, S3, Oracle, and SQL Server to support regulatory audits, STAR ratings submissions, and enterprise analytics initiatives.

• Defined and standardized KPI frameworks for claims processing TAT, denial categorizations, provider network performance, and utilization benchmarks to improve operational transparency.

• Executed data quality checks, variance analysis, and root-cause investigations, improving accuracy of claims and utilization datasets used across business units.

• Collaborated with product owners, clinical teams, and compliance analysts in Agile/Scrum sprints, supporting requirement gathering, backlog refinement, and cross-functional reporting needs. Infosys, Hyderabad, India Sep 2021 – Aug 2022

Data Analyst

• Analyzed large-scale enterprise sales and delivery datasets to monitor revenue trends, pipeline health, customer churn, and operational KPIs, enabling more accurate business performance insights.

• Developed automated Power BI and Excel dashboards for senior leadership, reducing manual data compilation time by 30% and improving reporting consistency across business units.

• Designed and optimized SQL queries, stored procedures, and validation scripts, enhancing accuracy and reliability of Quarterly Business Review (QBR) reporting.

• Improved data warehouse quality and reduced redundancy by 25% by collaborating with data engineering teams on schema optimization, resulting in faster reporting and cleaner data structures. EDUCATION

Master’s in Information technology management, (CGPA: 3.59/4.00) Marion, IN Indiana Wesleyan University

Bachelor of Technology in Computer Science and Engineering, (CGPA: 3.45/4.00) Guntur, India JNTU University

CERTIFICATION

• Microsoft Power BI Data Analyst (PL-300)

• AWS Certified Cloud Practitioner

Contact this candidate