Data Analytics Projects
Current Healthcare Patients Analysis (Skills: EDA, Advanced Excel, Dashboarding)Exploratory Data Analysis – Extracted, transformed and loaded large set into Power BI. Analysed healthcare data that identified pattern and trend on key factors that influences patient’s diseases and the likelihood of patients having hypertension and heart disease. Developed an interactive dashboard using descriptive statistics to show trends based on historic data. Generated key insights and wrote an executive report outlining the problems and recommendations on the impact of demographic & behavioural factors on heart disease and hypertension. Healthcare Insurance Analysis (skills: Analysis, Dashboard development, Data storytelling) Anomaly Detection Billing Data – Performed exploratory data analysis on healthcare insurance Medicare claims data and built and analytics dash board to track and monitor KPI metrics towards patient’s payment. Identified anomalies &patterns that helped reduced fraudulent claims and provided action-able insights and recommendations to improve overall billing systems. Sales & Customer Analysis (Skills: Time-series Analysis, Root-cause Analysis, KPI metrics)Time-series & exploratory data analysis - identified trends, uncoveredactionableinsights on key factors impacting revenue deceleration. Created a data-drivenstrategies to help scale revenue. Analyzed customer data to for correlationbetween demographic factors & customer behavior. SQL Database Development (skills: SQL commands, data modeling, ER diagram)Created a data model, relational database and ingested tables fromdisparatesources into the database to store customer data using data using SQLDML&DDL commands. Machine Learning Project (skills: EDA, Python, ML, Regression, RandomForest)Developed a forecasting model - to project call volumes using labeleddatawithregression and random forest algorithms enrollment data.