Skip to content
View Richa-OnData-AI's full-sized avatar

Block or report Richa-OnData-AI

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Richa-OnData-AI/README.md

Richa Rani

Data AnalyticsData Scientist

Building scalable solutions that help businesses make smarter decisions through Data Analytics, Machine Learning, and Business Intelligence.


Professional Summary

  • Building data-driven solutions through Data Analytics, Machine Learning, and Business Intelligence.
  • Worked on projects involving statistical analysis, demand forecasting, predictive analytics, business intelligence, fraud detection, and election analytics.
  • Built dashboards and analytical solutions inspired by the operational needs of local businesses and educational institutions to deliver actionable insights.
  • Data becomes valuable when it helps people make informed decisions.
  • Every dataset tells a story that can be translated into practical solutions and measurable impact.

Technical Skills

Programming

  • Python • SQL

Data Analysis

  • Pandas • NumPy • Microsoft Excel • Statistics

Machine Learning

  • Scikit-learn • XGBoost • Regression • Classification • Deep Learning

Data Visualization

  • Power BI • Matplotlib • Seaborn

Tools

  • Git • GitHub • Jupyter Notebook • VS Code

Featured Projects

Election Intelligence Analytics (Ongoing)

A data storytelling project developed for AtliQ Media to analyze the Tamil Nadu Assembly Elections using Python, SQL and Power BI. The objective is to transform complex election data into meaningful insights that help editorial teams explain how voting patterns, turnout, regional dynamics, and electoral outcomes changed between the 2021 and 2026 Assembly Elections.

Key Analysis

  • Compared the 2021 and 2026 Assembly Elections to analyze changes in voter turnout, regional seat distribution, and winning margins.
  • Identified constituency-level seat flips, regional strongholds, and shifts in voting patterns across Tamil Nadu.
  • Examined the electoral impact of emerging political parties, including TVK, on constituency-level competition and regional performance.
  • Performed SQL- and Python-based analysis to uncover trends behind election outcomes and support data-driven storytelling.
  • Built interactive Power BI dashboards that enable journalists and editorial teams to communicate election insights through data rather than opinion.

Business Value

Helped transform large-scale election data into clear, evidence-based stories, enabling audiences to better understand voter behaviour, regional trends, and the factors influencing election results.

Technologies

Python • SQL • Power BI


Inventory Demand Forecasting & Stock-out Prediction

Forecasted future product demand and identified stock-out risks using Machine Learning to support inventory planning and replenishment decisions.

Project Highlights

  • Achieved an R² Score of 82.7% using XGBoost for demand forecasting.
  • Compared multiple regression and classification models to identify the best-performing approach.
  • Identified products with high stock-out risk through inventory trend and replenishment analysis.
  • Visualized model performance and feature importance to improve interpretability and business understanding.

Key Business Insights

Supported data-driven inventory planning by improving demand visibility, reducing stock-out risks, and enabling proactive replenishment decisions.

Technologies

Python • Pandas • Scikit-learn • XGBoost • Matplotlib


Pharmacy Inventory & Business Intelligence Dashboard

Built an interactive Power BI dashboard to help pharmacy businesses monitor inventory, reduce stock-related losses, and support faster operational decision-making. The dashboard transforms sales and inventory data into actionable insights, enabling pharmacists to identify stock shortages, monitor medicine expiry, and prioritize timely replenishment.

Key Analysis

  • Monitored inventory health by tracking low-stock, out-of-stock, and expiring medicines.
  • Identified medicines requiring immediate replenishment through reorder-level analysis.
  • Analyzed sales performance, customer purchasing behaviour, payment trends, and executive KPIs.
  • Assessed inventory risk by measuring the potential financial impact of expired and unavailable medicines.
  • Delivered actionable recommendations through interactive Power BI dashboards and KPI-driven insights.

Key Business Insights

  • Identified 29 out-of-stock medicines and 1,000 low-stock medicines requiring immediate replenishment.
  • Detected 5,000 expired medicines, including 130 expiring within 7 days and 344 within 30 days, supporting proactive inventory planning.
  • Highlighted an estimated Inventory Loss of ₹308 Million and Revenue at Risk of ₹414 Million, demonstrating the business impact of inventory inefficiencies.
  • Recommended urgent replenishment of Amoxicillin, Azithromycin, and Vitamin C based on inventory levels and customer demand.
  • Identified Sunday as the highest revenue-generating day, with 33.65% of transactions completed through UPI, providing insights into customer purchasing behaviour.

Technologies

Power BI • Microsoft Excel • DAX


Focus Areas

Applying Data Analytics, Machine Learning, Deep Learning and Artificial Intelligence to develop practical solutions for business problems.

  • Predictive Analytics
  • Business Intelligence
  • Decision Intelligence
  • Data Storytelling
  • AI Applications

Connect

Platform Link
GitHub Richa-OnData-AI
LinkedIn Richa Rani
Email richa.insight@gmail.com
Medium Medium
Stack Overflow Stack Overflow
Reddit Reddit
Quora Quora

Popular repositories Loading

  1. Air-Purifier-SQL-project Air-Purifier-SQL-project Public

    Analysis of air quality data to understand pollution trends and environmental impact.

    4

  2. Chicago-Data-Analysis-Using-SQL Chicago-Data-Analysis-Using-SQL Public

    This project involves analyzing real-world datasets from the City of Chicago using SQL. The datasets include census data, crime records, and public school information. The goal is to answer practic…

    3

  3. Pharmacy-Inventory-Business-Intelligence-Dashboard Pharmacy-Inventory-Business-Intelligence-Dashboard Public

    Designed interactive dashboards using DAX and data modeling to visualize regional sales, identify growth opportunities, and support data-driven decisions.

    3

  4. Chipotle-Data-Cleaning Chipotle-Data-Cleaning Public

    This project showcases a complete data cleaning workflow on the Chipotle Orders dataset. It involves importing raw data, correcting inconsistencies,converting price values to numeric, standardizing…

    Jupyter Notebook 2

  5. India-Domestic-Flights-Analytics-2019- India-Domestic-Flights-Analytics-2019- Public

    This project analyzes a dataset of 10,683 domestic flights in India (2019), exploring pricing trends, flight distributions, stoppages, and travel patterns. The goal is to extract actionable insight…

    Jupyter Notebook 2

  6. FIFA-World-Cup-Statistical-Analysis FIFA-World-Cup-Statistical-Analysis Public

    This project analyzes 18,207 FIFA players using Python to uncover insights on performance, wages, potential, skills, and demographics. It applies statistical methods like outlier detection, confide…

    Jupyter Notebook 2