Data Analyst Power Bi

Divya Medapureddy

Email: ****************.***@*****.***

Mobile: +1-667-***-****

Data Analyst

PROFESSIONAL SUMMARY:

Data Analyst with 5+ years of experience applying analytical thinking and innovative problem-solving skills to transform data into actionable insights across diverse business functions. Strong attention to detail ensures accuracy.

Built and optimized ETL pipelines, demonstrating proficiency in connecting dots across applications for an E2E view, while working in Agile/Scrum teams and managing multiple projects simultaneously.

Created interactive dashboards and reports, communicating effectively to both technical and non-technical audiences, and identifying priorities to guide team success as a strong team player.

Designed statistical models and utilized query tools, including strong PL/SQL skills to write and analyze complex queries and stored procedures, while working with minimal supervision.

Streamlined reporting workflows by writing efficient SQL queries, demonstrating expertise with Microsoft Office suite usage, and willingness to ask questions and reach out for assistance.

Integrated cloud solutions to enhance scalability and centralize data access, leveraging experience with Oracle Exadata or 10g and above for enterprise-level analytics and reporting.

Collaborated with business teams to define KPIs and improve dashboard usability, demonstrating know-how in effort and financials estimation, and ability to influence and guide teams.

Automated Excel-based reports using Python, applied Git version control, and supported finance teams, showcasing good communication and presentation skills across the organization.

TECHNICAL SKILLS:

Languages - Python, SQL, R, PL/SQL

Visualization Tools - Tableau, Power BI, Excel

Databases - MySQL, PostgreSQL, Amazon Redshift, Oracle Exadata

Cloud Platforms & Tools - AWS, Snowflake, Jupyter, Git

Statistical Analysis - Regression, A/B Testing, Time Series Forecasting

Others - ETL Processes, Data Cleaning, Data Warehousing, Stored Procedures, Microsoft Office

Methodologies - Agile, Scrum

PROFESSIONAL EXPERIENCE:

Kaiser Permanente Sep 2023 – Present

Data Analyst

Responsibilities:

Designed and maintained executive-facing Tableau dashboards to track clinical KPIs, demonstrating analytical thinking and attention to detail in assessing care performance across multiple hospital service lines. This improved decision-making.

Utilized strong PL/SQL skills to analyze healthcare service data, uncovering patient flow patterns and reducing bottlenecks in care delivery, while forecasting resource demand for high-volume periods. This showcased problem-solving skills.

Automated reporting pipelines using SQL procedures and Python scripts, reducing turnaround time from days to hours and improving consistency across recurring performance reports, working with minimal supervision. This demonstrated innovative thinking.

Partnered with clinical and administrative stakeholders in an Agile/scrum team to define key metrics, translating business requirements into interactive dashboards supporting strategic hospital initiatives, ensuring team success.

Integrated structured data from multiple EHR systems to generate unified care metrics, enabling cross-departmental comparisons and improving accuracy in quality and performance reporting, while identifying priorities effectively.

Built forecasting models to predict readmissions and patient inflow using time-series techniques, supporting staffing models and improving readiness during high-demand windows, demonstrating proficiency in connecting dots across applications.

Developed Python-based anomaly detection for billing data and patient admissions, increasing visibility into inconsistencies and enabling proactive responses to fraud and compliance concerns, showcasing strong communication skills.

Worked with IT to optimize backend data processes, reduce dashboard latency, and ensure near real-time access to metrics across clinical, operational, and executive teams, while managing multiple projects simultaneously.

Delivered training sessions for staff on dashboard navigation and produced documentation outlining logic and data definitions, enabling self-service analytics and greater transparency, demonstrating willingness to ask questions.

Proficiently wrote and analyzed complex queries using Oracle Exadata to extract and transform data, supporting the creation of insightful reports and dashboards for various business stakeholders, reaching out for assistance as required.

Amazon Development Center Nov 2020 – Apr 2022

Data Analyst

Responsibilities:

Analyzed customer behavior and product interactions to uncover insights that enhanced personalization features and improved recommendation systems across e-commerce and retail platforms, demonstrating analytical thinking and problem-solving skills.

Designed and optimized SQL queries to extract and transform data from transactional systems, enabling detailed behavioral analysis and supporting real-time reporting for business stakeholders, showcasing strong PL/SQL skills.

Collaborated with product managers and UX teams to define engagement metrics, assess feature adoption, and guide development priorities based on user behavior trends and feedback loops, working well in a team environment.

Automated recurring reporting tasks using Python scripts and SQL views, reducing manual effort, improving accuracy, and ensuring consistent delivery of weekly and monthly analytics reports, demonstrating attention to detail.

Analyzed clickstream data to identify user journey bottlenecks, contributing to product changes that improved navigation experience and boosted engagement by approximately 15%, showcasing innovative thinking skills.

Built interactive Power BI dashboards to monitor A/B test results and user behavior, enabling fast, data-driven decisions during product iterations and marketing experiments, while identifying priorities effectively.

Created segmentation models in R based on customer behavior and demographics, supporting targeted marketing efforts and improving campaign effectiveness and conversion outcomes, demonstrating proficiency in connecting dots.

Worked with engineering teams to validate data tracking across platforms, ensuring correct event instrumentation and maintaining accurate input for analytics pipelines and reporting tools, showcasing strong communication skills.

Delivered performance reports to leadership with feature usage trends, user insights, and experiment results that informed strategic planning and roadmap decisions, demonstrating ability to effectively communicate across organization.

Tuned Redshift database performance by optimizing indexes and queries, while implementing QA procedures to maintain reliability and accuracy across analytics pipelines and dashboards, working with minimal supervision.

PLE Pvt. Ltd Jul 2018 – Nov 2020

Financial Data Analyst

Responsibilities:

Built dynamic forecasting models in Excel and Python to project cash flow, expense trends, and operational budgets, enabling executive leaders to plan with greater accuracy and financial visibility, demonstrating analytical thinking.

Designed automated dashboards to track key financial health metrics such as revenue growth, net margin, and ROI, allowing real-time performance monitoring and improved decision-making, showcasing attention to detail.

Developed Python scripts to detect anomalies in transactional data, reducing exposure to fraudulent entries, improving audit readiness, and enhancing accuracy in month-end and quarterly close cycles, demonstrating problem-solving skills.

Conducted detailed variance analysis comparing forecasts against actual results, identifying root causes of deviations and presenting findings to leadership for strategic financial planning, showcasing strong communication skills.

Created internal dashboards to monitor budget adherence, vendor payments, and invoicing cycles, streamlining financial oversight and strengthening procurement and payment compliance processes, demonstrating innovative thinking.

Collaborated with department heads to standardize reporting formats, reducing reconciliation errors and improving cross-functional visibility into financial KPIs and cost management efforts, working well in a team environment.

Automated monthly and quarterly reporting workflows, decreasing manual effort, reducing turnaround time, and ensuring consistency and traceability of key financial data across periods, working with minimal supervision.

Built simulation-based financial models in Excel to assess business risks, using Monte Carlo and scenario analysis techniques to support liquidity planning and long-term financial forecasting, demonstrating proficiency in connecting dots.

Produced multi-year trend visualizations to highlight financial performance shifts, enabling leadership to make strategic investment decisions and prioritize resource allocation effectively, demonstrating ability to effectively communicate.

Supported external audits by compiling required datasets, reconciling financial records from ERP systems, and creating documentation to ensure data integrity, governance, and compliance continuity, while identifying priorities effectively.

Educational Details:

Master of Science in Data Science - University of Maryland, Baltimore County

Bachelor of Technology in Electronics & Communication Engineering - GITAM Deemed to be University

Contact this candidate