I will build an inventory optimization and safety stock dashboard

India

I speak Hindi, English

Turning Complex Data and Workflows Into Automated Action

👋 Hi, I am Sachin — Data Analyst & BI Consultant. 📊 I engineer automated data pipelines and visual analytics that reduce costs and uncover hidden revenue. My inventory models reduced overstock by ...
About this Gig

Are you losing revenue to stockouts on best-sellers while your capital is tied up in dead overstock?



Balancing inventory is the hardest part of scaling a retail or e-commerce business. I help wholesale distributors and omni-channel brands turn chaotic supply chain data into automated, mathematically sound purchasing decisions.


Using advanced PostgreSQL (Window Functions) and Tableau, I engineer pipelines that calculate dynamic safety stock and Reorder Points (ROP) based on your historical lead times and sales velocity. In past commercial roles, my inventory models successfully reduced capital overstocking by 18%.


What You Get In This Gig:

  • Data Normalization: Cleaning messy ERP, Amazon, or Shopify inventory exports.
  • Inventory Mathematics: Calculating Lead Time Demand and dynamic Safety Stock buffers.
  • ABC Categorization: Segmenting your SKUs by revenue contribution so you know exactly what to prioritize.
  • Executive Dashboard: A live Tableau scorecard alerting you exactly when and how much to reorder.


Please send me a direct message before placing an order so we can review your data structure and lead times!

Technology:

Excel

•

Google Sheets

•

Tableau

Analysis Type:

Quantitative Analysis

•

Qualitative Analysis

Expertise:

Business Insights

•

Trends

•

Algorithms

•

Prediction

Programming language:

Python

•

SQL

My Portfolio

Other Data Analytics Services I Offer