Power Bi Data Analyst

RACHAMALLA MUKUNDA PRIYA

Orange, CA +1-940-***-**** *****************@*****.*** LinkedIn

PROFESSIONAL SUMMARY

An Experienced Reporting and Data Analyst with over 5+ years of expertise in SQL, Python, Power BI, and Tableau. Skilled in creating dynamic dashboards, optimizing ETL pipelines, and managing databases to deliver actionable insights. Proficient in leveraging cloud platforms like AWS, Azure and big data technologies for scalable solutions. Strong focus on workflow automation, regulatory compliance, and aligning analytics with business goals.

WORK EXPERIENCE

CalOptima Health Orange, CA

Sr. Data Warehouse Reporting Analyst Oct 2024 – Current

Designed and maintained dynamic reports using SSRS and Power BI to deliver real-time insights on healthcare metrics, improving operational efficiency.

Developed complex SQL queries in SSMS for data extraction, transformation, and validation, ensuring accuracy and compliance with regulatory requirements.

Streamlined reporting workflows by integrating SSRS with automated data pipelines, reducing manual effort and enhancing report delivery timelines.

Utilized Matillion ETL to automate data pipelines, integrating disparate healthcare data sources into Snowflake for streamlined analytics and reporting.

Created interactive dashboards in Power BI to monitor key performance indicators (KPIs), such as member satisfaction and service utilization, enabling data-driven strategic planning.

Worked with Azure Data Factory to orchestrate and automate data flows across various healthcare data sources, ensuring efficient data movement and transformation processes.

Collaborated with cross-functional teams to consolidate and validate data for compliance reporting, leveraging SQL (SSMS) and Power BI to meet CMS and DHCS standards effectively.

Tungsten Automation Formerly Kofax Irvine, CA

Reporting Analyst Feb 2023 – Apr 2024

Prepared interactive dashboards and performance reports using Power BI and Tableau, providing actionable insights on software utilization and operational efficiency.

Streamlined data workflows by automating recurring reports with SQL and Python, reducing manual reporting efforts by 30%.

Monitored key performance indicators (KPIs) and created custom reports from MySQL databases to support data-driven decision-making for product teams.

Collaborated with cross-functional teams to align reporting requirements and ensure data accuracy, leveraging ETL processes and cloud platforms like AWS for real-time analytics.

Optimized reporting processes by integrating advanced data visualization techniques, improving stakeholder understanding of system performance trends.

Ensured compliance with data privacy standards and implemented robust data integrity measures in all reporting activities.

Sigma Infosolutions Ltd. Bengaluru, IN

Data Analyst Nov 2021 - Aug 2022

Managed end-to-end ETL pipelines, transforming raw data into actionable insights using SQL, Python, and Power BI, supporting strategic decision-making in healthcare operations and improving data accessibility.

Developed and optimized relational databases (MySQL, PostgreSQL) and integrated data from various sources into Snowflake and Azure platforms, ensuring data integrity, security, and compliance with healthcare industry standards.

Designed interactive dashboards and reports in Power BI to visualize complex datasets, enabling stakeholders in healthcare and home health environments to monitor KPIs such as patient satisfaction, service utilization, and operational efficiency.

Implemented data migration and integration processes, consolidating healthcare data from diverse systems into unified platforms, and leveraging Matillion ETL to automate data flows and simplify analytics pipelines.

Collaborated with cross-functional teams to align data solutions with client requirements, integrating advanced analytics, predictive models, and healthcare-specific insights to address challenges like patient outcomes and care efficiency.

Streamlined compliance with healthcare regulations, ensuring adherence to CMS, HIPAA, and other industry standards by implementing robust data quality checks and ensuring security protocols were followed across data management workflows.

Supported digital transformation initiatives in the healthcare sector by leveraging Azure Data Factory, AWS, and other cloud platforms to deliver scalable, cost-effective data solutions, enhancing system performance and streamlining operations.

Magna Infotech Bengaluru, IN

Data Analyst Nov 2018 - Nov 2021

Ensured accurate and efficient data collection, transformation, and integration processes using SQL, Python, and ETL pipelines, supporting data-driven decision-making.

Managed and optimized relational databases, including MySQL, PostgreSQL, and MongoDB, to streamline data storage and retrieval for business analytics.

Designed interactive dashboards and reports using Power BI and Tableau, providing stakeholders with actionable insights and enhancing data visualization capabilities.

Conducted exploratory data analysis (EDA) with Python and Pandas, uncovering trends and patterns to drive business strategies and improve process efficiencies.

Developed automated workflows for repetitive data tasks, leveraging Python scripting and SQL queries, resulting in a 25% increase in operational efficiency.

Implemented and monitored key performance indicators (KPIs) using SQL and Power BI, enabling teams to track progress and achieve strategic goals effectively.

Executed robust data cleaning and preprocessing using Python and NumPy, ensuring data quality and consistency across multiple projects.

Ensured compliance with data governance and regulatory requirements, such as HIPAA and GDPR, through meticulous data handling and reporting practices.

Collaborated with cross-functional teams to align data analytics with business objectives, leveraging cloud platforms like AWS and Azure for scalable data solutions.

TECHNICAL SKILLS

Programming Languages: Python, SQL, C

Databases: MySQL, SQL Server, Snowflake, PostgreSQL, MongoDB

BigData Technologies: Hadoop, HDFS, Hive, HBase, Spark, Nifi, Apache Airflow, Databricks

Cloud Computing: AWS (S3, CloudWatch, RedShift, EMR, EC2, DynamoDB), Azure (Data Factory, Blob Storage, Databricks)

Data Analytics: Data Cleaning, Data Masking, Data Manipulation, Data Visualization Reporting Platforms: SSRS, Microsoft Power BI, Tableau, Sigma Computing, Metabase File Formats: Parquet, Avro, ORC, JSON

ETL/ELT Tools: SSIS, SSAS, Matillion ETL, Informatica, Azure Data Factory, DBT

Operating Systems: Windows, Linux, Unix

EDUCATION

Master of Science in Computer Science May 2024

University of North Texas Dallas, TX

Bachelor of Engineering in Computer Science Engineering June 2020

Anna University Chennai, IN

ACADEMIC PROJECTS

Data Warehouse Optimization Project

Optimized Snowflake architecture, reducing query execution times and storage costs while enhancing overall system performance.

Implemented efficient SSRS reports with advanced queries, improving data retrieval speeds and report accuracy.

Streamlined system updates in collaboration with contractors, ensuring seamless integration and fostering team expertise in query optimization.

Real-time Data Streaming Solution

Designed and implemented a Snowflake-based real-time data pipeline using Snowpipe, significantly reducing data latency and ensuring accurate updates for real-time reporting.

Enhanced system scalability, reliability, and performance by integrating advanced data streaming technologies and aligning project outcomes with business objectives.

Delivered dynamic SSRS reports sourced from the real-time pipeline, providing actionable insights to support strategic decision-making.

Contact this candidate