Data Analyst Power Bi

DIVYA INDRA KUMAR

Data Analyst

919-***-**** *****.*@*************.*** LinkedIn Green Card

Summary

Data Analyst with 4+ years of experience transforming complex data into strategic business insights. Skilled in Python, SQL, and cloud platforms to extract actionable insights and optimize decision-making Proficient in developing sophisticated data pipelines, and driving organizational efficiency through data-driven decision-making. Experienced in optimizing reporting workflows and implementing data-driven solutions that measurably impact results. Skills

Methodologies: SDLC, Agile (Scrum, Kanban), Waterfall Programming Languages: Python, SQL, R

Libraries: Pandas, NumPy, Sckit-learn, ggplot2, Matplotlib, Seaborn Database: Microsoft SQL Server, MySQL

Data Visualization Tools and Platforms: Tableau, Power BI, Advanced Excel Cloud Platforms: AWS, Microsoft Azure

IDEs: Visual Studio Code, PyCharm, Jupyter Notebook Version Control: Git, GitHub

Soft Skills: Critical thinking, Problem solving, Attention to detail, Strong written and verbal communication skills, Data storytelling, Collaboration with cross-functional team, Stakeholder management Education

Bachelor of Engineering Visvesvaraya Technological University, India July 2010 Work Experience

Data Analyst Cardinal Health, North Carolina January 2023 - Current

• Collected and validated healthcare data from multiple EHR systems using SQL and Python, ensuring HIPAA compliance while maintaining data accuracy for downstream analysis.

• Developed and maintained interactive Tableau dashboards for operational metrics with Python, Pandas for data preparation, reducing monthly reporting time by 40% while improving data driven decision-making.

• Led revenue cycle analytics project using SQL Server queries that identified $1M in billing inefficiencies through analysis of claims data and denial patterns, following Agile methodology for project delivery.

• Performed statistical analysis with R and ggplot2 comparing treatment effectiveness across different patient populations, supporting clinical teams in optimizing health care protocols.

• Collaborated with clinical teams to gather data requirements, analyzed healthcare metrics using SQL, and presented actionable insights at bi-weekly meetings, resulting in implementation of cost-saving initiatives.

• Created and documented standardized data extraction processes with version control via GitHub, reducing manual work and increasing department productivity by 25%.

• Conducted ad-hoc analysis using SQL queries against AWS hosted databases and visualized results in Tableau, providing actionable insights for time sensitive business questions within required timeframes. Data Analyst PNC, North Carolina March 2021 - December 2022

• Extracted and cleaned financial transaction data using SQL and Python with Pandas library, establishing automated ETL pipelines that improved data reliability for quarterly compliance reporting by 25%.

• Developed interactive Power BI dashboards to visualize key financial metrics, reducing monthly reporting time by 40% and enabling data-driven decision-making for senior management.

• Utilized Python for cost analysis across operational departments, collaborating with stakeholders to implement findings that reduced overhead expenses by 15%.

• Performed market trend analysis with advanced Excel and automated techniques to identify emerging opportunities, presenting insights in Agile sprint reviews that contributed to two new product offerings.

• Maintained financial reporting workflows on Microsoft SQL Server hosted on Azure cloud, automating regular reports to ensure timely delivery of critical KPIs to stakeholders.

• Collaborated with finance teams through Agile (Scrum) methodology to analyze budget variances, using Git for version control of analysis scripts that improved next-quarter budget precision by 20%.

• Designed data quality validation procedures using SQL and implemented them within the SDLC framework, reducing compliance issues and ensuring adherence to financial industry standards. Certifications

Professional Scrum Master (PSM)

Java Certificate from Wake Tech University, Raleigh NC

Contact this candidate