Summary
Overview
Work History
Education
Skills
Academic Projects
Timeline
Generic

Charulata Ranbhare

Newark,NJ

Summary

A University of Texas at Dallas Graduate in Business Analytics, proficient in collecting, analyzing, and interpreting complex datasets to drive actionable insights and data-driven decision-making. A proactive problem-solver with a keen eye for detail, committed to delivering accurate and impactful solutions in a fast-paced and challenging environment

Overview

3
3
years of professional experience

Work History

Business Analyst

Saubhagya Enterprise
04.2019 - 04.2020
  • Analyzed and Optimized inventory management using MS Excel, resulting in a 30% reduction in stock-outs
  • Performed a comprehensive cost-benefit analysis of the vendor selection process, resulting in a 15% reduction in procurement cost
  • Pioneered and implemented a pricing strategy, resulting in a 10% increase in profit margins while maintaining customer satisfaction

Marketing Analyst

Vrundavan Food Ventures
03.2018 - 03.2019
  • Developed key performance indicators (KPIs) using SQL to measure marketing campaign effectiveness and ROI, resulting in a 25% increase in customer acquisition and a 15% improvement in customer retention
  • Utilized Excel and Power BI to create interactive dashboards and reports, providing real-time insights on marketing performance, customer behavior, enhancing data-driven decision-making processes
  • Conducted customer satisfaction surveys, analyzed feedback, and implemented improvements, resulting in a 15% increase in customer satisfaction scores and enhanced brand reputation

Data Analyst Intern

West Coast Laboratories
04.2017 - 02.2018
  • Assisted in creating and maintaining data documentation, ensuring transparency, accuracy, and compliance with privacy regulations
  • Devised and executed data cleaning and validation processes using Python, resulting in a 95% reduction in data errors and improved data integrity across multiple databases

Education

Master of Science - Business Analytics

The University of Texas
Dallas, TX
05.2023

Bachelor of Commerce in Financial Management -

The University of Mumbai
India
04.2017

Skills

  • Programming Languages: Python, SQL, R
  • Libraries & Packages: Pandas, NumPy, Tidyverse, matplotlib, seaborn, dplyr, ggplot2, caret, randomForest
  • Visualization Software: Power BI, Tableau, Stata, Tally ERP
  • Tools: MS Office, Jupyter Notebook, SAP Business Object, SAS, NoSQL, SharePoint, Jira, Agile
  • Cloud: AWS, Microsoft Azure
  • Certification: Google Analytics Individual Qualification (ID: 134186884)

Academic Projects

Diabetes Prediction model (Marketing and Predictive Analytics)

  • Conducted prediction to identify subjects who might have diabetes with an accuracy of more than 80% using logistic regression model
  • Successfully determined that increase in pedigree level by 1.2 times increases the odds of having diabetes and diabetes can be prevented and treated if high glucose levels are present in the blood

Enhancing Prognosis of Breast Cancer using Azure ML (Database Foundation)

  • Developed models using ML algorithms forecasting early breast cancer prognosis before showing early signs using healthcare dataset
  • Achieved 95% accuracy using random decision forest for deploying into real life applications

Instacart case study using tableau (Data Visualization)

  • Analyzed Instacart Dataset in tableau and ArcGIS for visualization and curated views by selecting the best evidence displaying insights
  • Interpreted product Analysis, bestselling products, most ordered & re-ordered products, and organized storyline with storyboarding

Timeline

Business Analyst

Saubhagya Enterprise
04.2019 - 04.2020

Marketing Analyst

Vrundavan Food Ventures
03.2018 - 03.2019

Data Analyst Intern

West Coast Laboratories
04.2017 - 02.2018

Master of Science - Business Analytics

The University of Texas

Bachelor of Commerce in Financial Management -

The University of Mumbai
Charulata Ranbhare