Data Analyst Power Bi

SRIKANTH NANKENA

737-***-**** *****************@*****.*** MI, 48335

Summary

• Business Data Analyst with 5 years of experience using statistical analysis, data mining, and data visualization to drive business decisions and deliver business intelligence solutions.

• Experience in SQL scripting for project cycles including data acquisition, data cleaning, data exploration, and data modeling using Python libraries like Pandas, NumPy, SciPy, Scikit-learn, Matplotlib, and Seaborn.

• Performed statistical analysis, causal inference, and statistical modeling in Python, interpreting and analyzing results of hypothesis tests, A/B tests, and multivariate tests and providing recommendations based on data.

• Solid working expertise with RDBMS, wrote various stored procedures, triggers and complex queries containing multiple joins, subqueries and window functions to create reports and perform analysis. Skills

• Data Analysis: SQL, Excel (VLOOKUP, HLOOKUP, Pivot Tables), Python (Pandas, NumPy), Power BI, Tableau

• Data Visualization: Tableau, Power BI, Excel Charts

• Data Engineering: SSIS, Talend, ETL Pipelines, AWS (Backup & Recovery)

• Documentation: BRD, FRD, SRS, RTM, User Stories, Data Lineage Documentation

• Statistical Analysis: Regression, KPI Tracking, Forecasting, Risk/GAP/SWOT Analysis

• Requirement Gathering: JAD Sessions, Stakeholder Interviews, UAT, Agile Ceremonies (Scrum, Sprint Planning)

• Tools & Platforms: JIRA, Confluence, Git, AWS, Microsoft Excel, PowerPoint

• Project Methodologies: Agile, Scrum, UAT, SDLC

• Domain Expertise: Healthcare Analytics, Claims & Utilization Analysis, Revenue Trends, Property/Real Estate Experience

Data Analyst July 2024 - Present

HCA Healthcare USA

• Collaborated with clinical and administrative teams to gather and analyze patient data from Electronic Health Records (EHR) to identify trends and operational inefficiencies.

• Designed and maintained interactive Tableau dashboards to monitor KPIs such as patient wait times, readmission rates, and staff utilization, improving visibility into clinical performance.

• Utilized SQL and Python to extract, clean, and analyze large datasets from internal databases and third-party healthcare data sources to support predictive analytics.

• Conducted gap analysis to identify discrepancies in patient discharge processes, leading to a 12% reduction in 30-day readmission rates.

• Created BRDs and FRDs by liaising with stakeholders including physicians, IT teams, and compliance officers to ensure proper documentation of business requirements.

• Performed data validation, quality checks, and HIPAA-compliant audits to ensure data integrity and adherence to healthcare regulations.

• Delivered weekly and monthly reports using Power BI and Excel that supported decision-making for cross-functional teams in quality improvement initiatives.

Business Data Analyst Sep 2023 - Jun 2024

United Healthcare Group NC-USA

• Facilitated Agile methodology practices, engaging in Sprint Meetings, Sprint Planning meetings, sprint reviews, and retrospective meetings to foster a collaborative and iterative project execution environment.

• Produced Functional Requirement Documents (FRD), Business Requirement Documents (BRD), and System Requirements and specifications (SRS) documentation with 95% accuracy and met stakeholder expectations.

• Employed SQL queries and Excel functions to analyze revenue trends, resulting in a 40% reduction in data processing time and a 25% improvement in the accuracy and efficiency of revenue calculations.

• Identified opportunities for business process improvement through automation and data analytics, leading to more efficient property management.

• Developed statistical reports and dashboards using Power BI, providing real estate market insights, property performance metrics, and investment trend analysis.

Business Data Analyst Jan 2018 - July 2021

Experion Technologies Hyderabad-India

• Facilitated Joint Application Development (JAD) sessions and User Acceptance Testing (UAT), fostering strong stakeholder engagement and achieving 95% alignment on project goals.

• Utilized VLOOKUPs and HLOOKUPs to meticulously validate data integrity by cross-referencing multiple datasets, which led to a 25% improvement in overall data accuracy and consistency.

• Conducted in-depth analyses, including cost/benefit, GAP, risk, and SWOT analyses, while maintaining a Requirements Traceability Matrix (RTM) to ensure precise project tracking and accountability.

• Designed and implemented robust AWS data backup and recovery strategies, resulting in a 20% increase in data reliability and enhancing our disaster recovery capabilities.

• Participated in User Acceptance Testing (UAT) for new data solutions, validating system functionality and ensuring business requirements were met.

• Built and maintained efficient ETL pipelines using SSIS and Talend to seamlessly extract, and transform. Education

Masters: Science in Information Systems Trine University, IN, USA Jan 2022 –July 2023 Bachelors: Computer Science Engineering Sree Dattha Institute of Engineering and Science, Rangareddy, Telangana, India Sep 2012 –Dec 2016

Contact this candidate