Data Analyst Business Intelligence

Susmitha Panguluri

New Haven CT ***** 475-***-**** *****************@*****.***

Professional Summary

Experienced healthcare data analyst with expertise in data mining, trend analysis, and reporting across medical, pharmacy, and behavioral health claims data. Skilled in identifying cost drivers and opportunities for medical expense savings. Adept at transforming complex datasets into actionable insights to support strategic decision- making. Excellent communicator with the ability to present findings clearly to stakeholders. Education

MASTER’S DEGREE JAN 2022-MAY 2023 UNIVERSITY OF NEW HAVEN GPA: 4.0/4.0

Major: Business Analytics

Related coursework: This course of business analysis helped me understand various business intelligence tools like Power, R studio, Tableau, MYSQL, RDBMS, and concepts involving types of regression models with training and validation of various data sets. Elective courses like supply chain management, decision-making in operation management, and marketing analytics were also included in the coursework to understand the various analytics methods used in different fields of industries. Work Experience

SOFTWARE DATA ANALYST STATE OF FLORIDA OCT 2023- Current

Collect and analyze data from various sources to identify trends and patterns

Develop and maintain dashboards and reports to provide insights to key stakeholders

Build and maintain statistical models to help predict business outcomes

Collaborate with cross-functional teams to identify opportunities for process improvements and cost savings

Develop and implement data-driven solutions to business problems

Communicate insights and recommendations to key stakeholders in a clear and concise manner

Stay up-to-date with industry trends and best practices in data analysis and business intelligence QA DATA ANALYST BAYLOR SCOTT HEALTH AND WHITE JAN 2023-OCTOBER 2023

Performed data mining and multi-dimensional analysis on large claims datasets for payer clients

Created visualizations and dashboards to monitor key metrics like cost per member, readmissions, etc.

Conducted root cause analysis to identify drivers of high-cost claims and recommend interventions

Develop reports and dashboards highlighting medical expense trends by service category, provider, diagnosis, etc.

Assess the viability of vendor partnerships and new initiatives through data analysis and ROI modeling

Writing SQL queries to pull specific records and practice filtering tables while working with large databases.

Source data from various data repositories, validate data for consistency, and partner with teams to ensure data integrity and KPI calculations

Page 2

ML DATA ASSOCIATE AMAZON DEVELOPMENT CENTER JAN 2019-JAN 2022

Conducted detailed requirement-gathering sessions with stakeholders to understand business needs and translated them into functional specifications and user stories.

Worked closely with the development team in an Agile/Scrum environment to ensure project goals were met, resulting in an on-time project delivery rate of over 95%.

Designed and implemented database solutions based on project specifications.

Collaborated with business analysts to understand data requirements and translate them into effective database structures.

Conducted regular database maintenance tasks and ensured data consistency.

Created and maintained comprehensive documentation, including process flows, data models, and user manuals.

Collaborated with the QA team to develop test plans, and test cases, and perform thorough testing to ensure software quality.

Presented findings, recommendations, and insights to senior management, aiding strategic decision- making processes.

Review, understand, and analyze the efficiency of existing project scope and recommend new strategies for future projects.

Assisted the Sr. Business Analysts in migrating the database from Microsoft SQL to PostgreSQL.

Co-ordinated in producing weekly analytical reports that went to various divisions in the firm using SQL and MS. Excel.

Learnt how the End-to-End testing is done ensuring that the code changes made by the developer team match business requirements.

Generating plots, visualizations, and informative dashboards using Splunk and Power Bi.

Gained an experience in advanced querying techniques working with the Postgres Pg-Admin tool. Key Skills

Data Mining & Analysis

Claims Data Analysis

Medical/Pharmacy/BH Utilization Analysis

CRM

EPIC

HTML

POSTMAN

Data Visualization (Tableau, Power BI)

SQL, Python, R

Project Management

Stakeholder Presentations

Contact this candidate