Data Analyst Power Bi

Yaswanth Satyanarayana Reddy Pulagam Data Analyst

815-***-**** *****************@*****.*** LinkedIn

Summary

Data Analyst with around 2 years of experience spanning healthcare and IT analytics, delivering outcome-focused analytics across claims, clinical, behavioral, and pharmacy domains as well as enterprise IT observability. Expertise includes SQL, Python, R, ETL/ELT, data modeling, and predictive analytics, with proven success improving data quality, accelerating HEDIS computations, reducing manual reporting, and driving uptime/performance gains. Skilled in building executive-ready dashboards and KPI frameworks using Power BI/Tableau and automating regulatory and operational reporting. Hands-on with Snowflake, PostgreSQL, MySQL, Oracle, Erwin Data Modeler, Pandas/NumPy/Scikit-learn, and AWS/Azure tools and workflows. Strong governance mindset with HIPAA/NCQA/CMS alignment, access control, and data dictionary stewardship. Collaborative communicator working in Agile teams with JIRA/Confluence, partnering with clinicians, pharmacy leaders, DevOps, and business stakeholders to translate requirements into measurable, production-grade insights.

Technical Skills

Programming Languages: Python, SQL, R

Data Visualization: Power BI, Tableau, Excel (Pivot Tables, Charts), Matplotlib, Seaborn Databases: Snowflake, PostgreSQL, MySQL, SQL Server, Oracle Data Manipulation & Analysis: Pandas, NumPy, Scikit-learn, Data Wrangling, Data Cleaning ETL / Data Pipelines: Python Scripts, Snowflake, SQL Stored Procedures, Talend Analytics & Reporting: Google Analytics, KPI Tracking, Ad Hoc Reporting, Forecasting Data Governance & Modeling: Data Quality Checks, Access Control, Erwin Data Modeler, Data Dictionary Maintenance

Collaboration & Documentation: Agile Methodologies, JIRA, Confluence, Business Requirement Translation Machine Learning: Regression Models, Classification Models, Predictive Analytics Tools & Utilities: Jupyter Notebooks, Git, VS Code, Anaconda, Excel, PowerPoint, Word, Outlook, Access

Soft Skills: Problem Solving, Cross-functional Collaboration, Business Communication, Microsoft office, PowerPoint World

Experience

Elevance Health, Data Analyst June 2025 – Current

• Unified member data (claims, clinical, pharmacy, behavioral) via SQL/Python ETL on Snowflake/PostgreSQL/Oracle to create a longitudinal view; enabled cross-domain visibility for health plans and complex care; adopted as the operational source of truth by 7+ care management and quality teams, supporting 15+ daily workflows.

• Curated HIPAA-compliant pipelines with Pandas/NumPy/Talend to normalize codes (ICD, CPT, NDC, provider IDs); ensured audit-ready datasets for quality/utilization review; reduced data defects by 23% and sped up HEDIS computations by 30%.

• Modeled episodes, care gaps, adherence, and behavioral engagement in Erwin; aligned analytics with plan benefits, case management, and pharmacy programs; improved KPI query speed and standardized definitions enterprise-wide.

• Built risk and readmission models in Python/R (Scikit-learn) using claims, SDoH, adherence, and behavioral indicators; prioritized complex-care outreach; increased high-risk member identification by 14% and program enrollment by 11%.

• Deployed Power BI dashboards for care gap closure, MPR, therapy continuity, and ED/hospital utilization; delivered near-real- time insights to clinicians and leaders; improved care gap closure by 9% and adherence metrics by 6%.

• Automated NCQA/CMS and operational reports with SQL procedures and Python schedules, delivering Excel outputs; streamlined compliance and pharmacy/utilization reviews; cut manual effort by 40% and boosted on-time submissions to 98%.

• Enforced governance with data quality checks, role-based access, and a maintained data dictionary; protected PHI and standardized Elevance Health semantics; achieved clean audits and clearer data stewardship.

• Drove Agile delivery with JIRA/Confluence (requirements, acceptance criteria, lineage docs); translated clinical/pharmacy goals into measurable analytics; accelerated releases and raised stakeholder satisfaction. Elevance Health, Data Analyst Intern Feb 2025 – May 2025

• Assembled prototype datasets from raw claims, pharmacy fills, and case notes using SQL and Python to support pilot analyses; surfaced early data gaps that informed production data contracts and mappings.

• Profiled data quality with Pandas (nulls, outliers, code set coverage) and documented remediation steps; increased downstream pipeline reliability by 28% for HEDIS and utilization studies and reduced data-related reruns by 35%.

• Drafted KPI specifications (care gap closure, MPR, ED revisit rate) with clinical SMEs and converted them into reusable SQL logic; ensured consistent metric definitions across intern and analyst deliverables.

• Built exploratory Power BI views to validate member cohorts, stratifications, and provider performance; accelerated stakeholder feedback cycles by 50% (from biweekly to weekly reviews) and cut pre–dashboard rollout defects by 30%.

• Assisted in feature engineering for readmission and adherence models (lags, rolling rates, comorbidity indices); boosted baseline model discrimination while maintaining interpretability.

• Authored Confluence runbooks and data lineage notes, and managed JIRA tasks for sprints; accelerated team onboarding and improved traceability from business requirement to analytic artifact. Addons Softtech, Data Analyst, India May 2022 – July2023

• Analyzed structured and unstructured datasets with SQL and Python to surface usage trends and performance patterns; informed engineering optimizations that reduced application latency by 18%.

• Built interactive Power BI dashboards for enterprise KPIs (uptime, latency, incident volume); enabled real-time observability and cut incident response times by 25%.

• Interpreted server logs and performance telemetry to pinpoint system bottlenecks; delivered remediation insights to DevOps, contributing to a 30% increase in uptime.

• Engineered automated ETL pipelines using Python (Pandas) and Snowflake to transform and integrate daily data feeds; decreased manual handling by 40% and improved pipeline reliability.

• Assessed user behavior with Google Analytics and Excel cohort models to identify drop-offs; guided frontend changes that improved user retention by 12%.

• Built predictive models in Scikit-learn using historical support tickets to forecast recurring issues; enabled proactive interventions and reduced ticket volume by 20%.

• Unified API logs, CRM data, and cloud usage reports into client-ready analytics deliverables; improved executive reporting, customer satisfaction, and renewal rates by 15%.

• Validated schema integrity across PostgreSQL/MySQL using SQL and Erwin Data Modeler; ensured data accuracy and supported clean findings in quarterly audits.

• Optimized SQL and indexing strategies for reporting workloads on PostgreSQL/MySQL; improved query performance by 35% and stabilized SLA adherence.

• Documented analytics methodologies, dashboard logic, and data dictionaries in Confluence; strengthened knowledge transfer and long-term maintainability for IT analytics solutions. Education

Lewis University, IL (CGPA: 4/4) May 2025

Master in Business Analytics

ICFAI Business School, India (CGPA: 6.09/10) Jun 2023 Bachelors of Business Administration (BBA)

Projects

• Capstone Project: Optimizing Marketing Campaign Strategies to Maximize ROI and Engagement. Analyzed 200,000+ campaign records to improve ROI and customer engagement.

• Amazon Sale 2024: Uncovered key performance trends and delivered actionable insights through interactive dashboards, ultimately optimizing sales strategies and customer engagement. Certifications

• Google Data Analytics

Awards

M.S. Business Analytics Award for Scholastic Achievement & Service Excellence

Contact this candidate