Data Analyst Power Bi

LAVANYA CH

Data Analyst

+1-469-***-**** ***********.**@*****.*** TX,USA

Summary

With Around 3 years of experience as a Data Analyst efficiently in retrieving and manipulating data from relational databases, with expertise in writing complex queries using SQL and forecasting techniques. Skilled at analyzing and interpreting healthcare data through utilizing SQL, Excel and Python for collecting and modeling large datasets. Developed and maintained Python-based data pipelines to automate ETL processes, resulting in increased operational efficiency and decreased. errors. Created Pandas and NumPy libraries for advanced data analysis and statistical modeling to identify key trends and patterns that influenced strategic business decisions.

Utilized regression analysis and predictive modeling techniques proficiently to support data-driven decision-making. Effectively leveraged Electronic Health Records (EHR) systems to streamline clinical workflows for optimal patient outcomes. Skills

Business Intelligence MS-SQL SDLC Data Modelling Requirement Gathering Predictive Modeling AWS Business Solutions Self Learning Python Agile Methodology Data Warehouse concepts Tableau Power BI ETL Informatica Experience

CVS Pharmacy TX-USA

Data Analyst 06/2023 - Present

• Expert in BI tools like Tableau and Power BI, specializing in creating dynamic reports, dashboards, and advanced analytics, skilled in data blending and hierarchies, delivering precise metrics and actionable KPIs, reducing issues by 25% and enhancing data quality

• Performed data integrity audits, optimized SQL queries for peak efficiency, and implemented dimensional modeling for Pharmacy data, rigorously adhering to HIPAA standards to ensure compliance and data accuracy

• Automated data workflows with AWS Lambda, reducing manual data handling and improving data processing efficiency by 20%

• Developed and implemented efficient data solutions, leveraging Python tools like Pandas and NumPy, to improve workflow efficiency and enhance data insights

• Developed dynamic, real-time dashboards by integrating Tableau and Power BI with AWS data services, offering stakeholders valuable insights for decision-making

• Developed User Acceptance Testing (UAT) plans, facilitated sessions with business users, ensuring timely and effective sprint release validations

• Collaborated closely with business teams, including Insurance Policies to gather requirements and expert in writing Business Requirement Documents (BRD)

Accenture Hyd-India

Data Analyst 07/2020 - 08/2021

• Leveraged SQL, Excel and other relevant tools to collect, cleansing and analyzing diverse healthcare data (financial, Banking)

• Utilized SQL and Python for data mining, ETL operations and maintaining data pipelines, enhancing KPI calculation and reporting accuracy.

• Implemented advanced data models and optimized databases, boosting strategic decision-making and improving operational efficiency by 35%

• Developed Python scripts for data processing and analysis, implementing complex algorithms and optimizing code for improved performance

• Leveraged Tableau and Power BI to dynamic dashboards and visualizations, delivering impactful data insights and compelling presentations to stakeholders and users

• Proficient in effectively analyzing large data sets using advanced techniques in MS Excel including Pivot Tables and VLOOKUP for efficient data analysis and report generation.

• Experienced data analyst with a proven track record of leveraging Power BI and AWS to deliver actionable insights to stakeholders

• Strong analytical skills and experience in data modelling, ETL processes, and data visualization using Power BI Education

University of Newhaven Connecticut, USA

Master of Science in Data Science 08/2021 - 05/2023 Sathyabama Institute of Science and Technology Chennai, India Bachelor of Engineering in Computer Science Engineering 07/2016 - 05/2020

Contact this candidate