Data Analyst Power Bi

Mohana Sai Venkata Lakshmi Appala Data Analyst

Location: Alabama, USA Mail: ***************@*****.*** Ph.: +1-659-***-**** LinkedIn PROFESSIONAL SUMMARY:

* ***** ** ********** ** a Data Analyst with expertise in designing and deploying interactive dashboards, optimizing ETL pipelines and developing predictive models to drive data-driven decision-making. Proven ability to enhance data visibility, streamline reporting and improve operational efficiencies while ensuring data integrity and compliance. Proficient in SQL, Python, Tableau, Power BI, Azure Data Factory, Alteryx, SSIS, AWS Redshift, AWS Glue, Epic, Cerner, HL7, EDI, HP ALM, Git and GitHub. TECHNICAL SKILLS:

Data Visualization: Tableau, Power BI, Matplotlib

Programming Languages: Python (Pandas, NumPy, Scikit-learn) Data Analysis: A/B Testing, Statistical Modeling, Predictive Analytics, Risk Stratification

ETL & Data Pipelines: Azure Data Factory, SSIS, Alteryx, AWS Glue

Databases & SQL: SQL Server, T-SQL, Stored Procedures, CTEs, Window Functions, Indexing

Cloud Platforms: Microsoft Azure, AWS (Amazon Redshift, AWS Glue)

Healthcare Systems: Epic, Cerner, HL7, EDI 837/835, ICD-10, CPT Compliance & Security: HIPAA, PHI Protocols

Testing & QA: HP ALM, Source-to-Target Mapping

Version Control: Git, GitHub

Agile Methodologies: Agile, Scrum

Office Tools: Microsoft Excel (PivotTables, Power Query, VLOOKUP, XLOOKUP)

Other Skills and Soft Skiils: Ggplot, Jupyter Notebook, decision tree, linear regression, Data Storytelling, Data Wrangling, Regression analysis, Data Modeling, Data Cleaning, Data Transformation, Data Visualization, Data warehousing, Dbt, Storytelling, Communication Skills

Operating Systems: Windows, Linux, Mac iOS

PROFESSIONAL EXPERIENCE:

UnitedHealth Group – AL Data Analyst July 2024 – Present

• Increased clinical and operational KPI visibility by 70% by designing and deploying interactive Tableau dashboards, enabling real-time decision-making for hospital leadership and care management teams.

• Reduced ETL processing time by 60% by refactoring data pipelines in Azure Data Factory and integrating Alteryx for parallelized batch processing of claims and patient encounter data.

• Developed and validated predictive models using Python (Logistic Regression, Random Forest) to identify high-risk patient no-show patterns, resulting in a 23% improvement in scheduling efficiency.

• Extracted, transformed and loaded (ETL) structured clinical data from Epic and Cerner EHR systems using optimized SQL scripts and orchestrated workflows in Azure Data Factory for unified analytics.

• Created and tuned stored procedures and complex T-SQL queries using Common Table Expressions (CTEs), window functions and indexing strategies to enhance query performance by 55%.

• Mapped and integrated HL7 messages and EDI 837/835 transaction sets to streamline claims analytics and billing cycle intelligence, reducing claim denial rates by 18%.

• Maintained strict HIPAA compliance and PHI security protocols during data ingestion, transformation and predictive modeling, ensuring zero compliance violations during audits.

• Mapped and validated ICD-10 and CPT codes for clinical condition segmentation and procedure grouping, supporting advanced cost-of- care and risk stratification analysis.

• Authored, executed and maintained HP ALM test cases for end-to-end validation of ETL pipelines, source-to-target data mapping and Power BI/Excel-based reporting deliverables.

Deloitte – India Data Analyst January 2021 - December 2022

• Spearheaded the design and execution of a robust ETL pipeline utilizing SQL Server Integration Services (SSIS), achieving a 30% reduction in data processing time and enhancing data accuracy for financial reporting.

• Developed dynamic and interactive KPI dashboards in Power BI tailored for financial metrics, resulting in a 25% increase in stakeholder engagement and facilitating data-driven decision-making across departments.

• Automated the end-to-end regulatory reporting processes in compliance with Reserve Bank of India (RBI) and Securities and Exchange Board of India (SEBI) standards, which improved reporting efficiency by 40% and minimized the risk of non-compliance.

• Designed, optimized and maintained SQL databases to ensure efficient data storage, retrieval and integrity, supporting complex financial queries and reporting requirements.

• Leveraged advanced Excel functions, including pivot tables and VLOOKUP, to conduct comprehensive financial analysis and generate insightful reports that informed strategic business decisions.

• Conducted A/B testing to assess the performance of various marketing strategies, providing actionable insights that enhanced campaign effectiveness and customer engagement.

• Implemented AWS services such as Amazon Redshift & AWS Glue to streamline data warehousing & ETL processes, resulting in a 35% improvement in data retrieval times for financial analytics & enabling real-time insights for strategic decision-making.

• Implemented version control protocols using Git and GitHub for meticulous project documentation, ensuring seamless collaboration and tracking of changes in data analysis projects.

• Actively participated in Agile/Scrum meetings to monitor project milestones, address challenges and ensure alignment with business objectives, fostering a collaborative team environment.

• Utilized Python libraries such as Pandas, NumPy and Matplotlib for advanced statistical analysis and data visualization, enabling the extraction of meaningful insights from complex datasets. EDUCATION:

Masters in Information Technology Management - Cumberland University, Lebanon Tennessee, USA Bachelor's in biotechnology - Acharya Nagarjuna University andhra Pradesh, India CERTIFICATION:

Certified IBM Data analyst - Coursera

Certified Extract, Transform & Load Data in Power BI - Coursera Certified Harnessing the Power of Data with Power BI - Coursera Certified Introduction to Programming Using Python - Udemy Certified Databricks fundamentals accreditation - Microsoft

Contact this candidate