Summary
Overview
Work History
Education
Skills
Certification
Projects
Websites
Timeline
Generic

Mounika Reddy

Redmond,USA

Summary

Data Analyst with over 3 years of experience in utilizing data-driven insights to improve decision-making in healthcare, technology, and consumer goods sectors. Skilled in data collection, cleansing, and transformation, with proven success in developing predictive models and advanced statistical analyses. Proficient in creating interactive dashboards using Tableau and Power BI, and experienced in designing scalable ETL pipelines with Apache Airflow and AWS Glue. Strong coding abilities in Python, SQL, and R, with expertise in big data technologies including Snowflake and Databricks.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

Tech Group Inc
Redmond, WA
05.2024 - Current
  • Utilized Power BI, Tableau, and SSRS to deliver real-time, interactive dashboards and visual reports for population health monitoring, quality improvement, and Medicaid performance metrics.
  • Applied advanced SQL using SQL Server 2016/2019, Azure Synapse Analytics, and Azure SQL for large-scale cohort extraction, quality measure development, and predictive utilization modeling.
  • Employed Python, R, and PySpark for statistical modeling, survival analysis, and trend forecasting across chronic disease populations and behavioral health cohorts.
  • Implemented machine learning models using ML.NET, scikit-learn, and Azure Machine Learning to predict readmission risk, identify high-utilizers, and stratify members by cost or risk.
  • Developed and maintained ETL pipelines via Azure Data Factory, SSIS, and Databricks to support ingestion of claims, clinical, pharmacy, and social determinants of health data into the CDR.
  • Integrated clinical code systems such as ICD-10, SNOMED CT, LOINC, CPT, and NDC to support consistent diagnosis, lab result, procedure, and medication analysis across care settings.

Data Base Administrator

Central Michigan University
Mount Pleasant, Michigan
10.2022 - Current
  • Designed and maintained dashboards using Power BI and Tableau to visualize KPIs, quality metrics, and ADAS performance data, supporting real-time business decision-making.
  • Administered and maintained enterprise-level SQL Server and Azure SQL databases supporting academic, administrative, and research applications.
  • Designed and implemented stored procedures, views, triggers, and functions to support data transformation, reporting, and business logic across university systems.
  • Performed regular performance tuning and query optimization to ensure fast and efficient data retrieval for high-volume students, faculty, and financial systems.
  • Built and monitored ETL pipelines using tools such as SSIS and Azure Data Factory to automate the extraction, transformation, and loading of academic and institutional data.
  • Collaborated with developers and analysts to integrate Power BI dashboards and reports, enabling data-driven decisions across departments.

Data Analyst

ZF Group
Hyderabad, Telangana
07.2021 - 06.2022
  • Written complex SQL queries to extract data from relational databases like production systems, ERP, and supply chain databases.
  • Developed and maintained robust SQL Server and Azure SQL databases to support automotive manufacturing analytics, supply chain systems, and production monitoring tools.
  • Built and optimized ETL pipelines using Azure Data Factory, SSIS, and Python to consolidate sensors, ERP, and MES data across plants for centralized reporting.
  • Created interactive dashboards and visualizations using Power BI to present insights on production efficiency, downtime, scrap rates, and inventory levels to engineering and operations teams.
  • Participated in the development and deployment of CI/CD pipelines for database and reporting solutions using Azure DevOps, YAML, and Git.
  • Integrated IoT sensor data with structured plant systems for predictive analytics using Python, Snowflake, and Azure Synapse Analytics.
  • Supported large-scale data initiatives by collaborating on system migrations from legacy databases to cloud-based architectures like Azure, AWS.
  • Contributed to process automation by developing Power Platform solutions using PowerApps, Power Automate, and Power Pages for plant-level data entry and approval workflows.

Data Analyst Intern

Ace Engineering College
Hyderabad, India
09.2020 - 05.2021
  • Performed data validation and preprocessing to ensure accuracy and completeness for analysis.
  • Supported the creation of reports and visualizations using tools like Excel, Power BI, or Tableau to present student performance and attendance trends.

Education

Master of Science - Information Systems

Central Michigan University
Michigan
05.2024

Skills

  • Methodologies: Agile, Waterfall
  • Programming Languages: Python, SQL, R PySpark
  • Development Environments: PyCharm, Jupyter Notebook, IntelliJ IDEA
  • Data Warehousing and Big Data Technologies: Snowflake, Hadoop, Apache Spark, Databricks, Kafka
  • Machine Learning: Regression, Random Forest, Logistic Regression, k-Means Clustering, Classification, Deep Learning, Natural Language Processing (NLP), Time Series Analysis, SVM
  • KNN Libraries: NumPy, Pandas, Matplotlib, Seaborn, SciPy, ScikitLearn
  • ETL Tools: Apache Airflow, Talend, AWS Glue, Alteryx, SSIS
  • Data Visualization: Tableau, Power BI, Google Data Studio, QuickSight
  • Excel Databases: MySQL, Redshift, Google BigQuery, SQL server, Oracle, Amazon RDS, PostgreSQL, MongoDB
  • Version Control: Git, GitHub
  • Cloud Platforms and Services: AWS (Glue, S3, QuickSight, RedShift), Google Big Query, Azure

Certification

  • AWS Certified Data Engineer – Associate- 2024
  • Google Data Analytics – 2024
  • AWS Certified Developer- Associate-2024

Projects

Multiuser Blog (Python, Tkinter) (https://github.com/Mounikareddy13/Multiuser-Blog) Nov 2024 - Dec 2024, Developed a multiuser blog application with five screens such as user registration and user authentication, home page, my profile and logout., Developed these screens using python and graphical user interface Tkinter, SQL for database management.

Timeline

Data Analyst

Tech Group Inc
05.2024 - Current

Data Base Administrator

Central Michigan University
10.2022 - Current

Data Analyst

ZF Group
07.2021 - 06.2022

Data Analyst Intern

Ace Engineering College
09.2020 - 05.2021

Master of Science - Information Systems

Central Michigan University

Similar Profiles

CREATE PROFILE
Mounika Reddy