Case study · Automation and data
Operations & Analytics Suite
YourTechConsultants built the Suite for Puranmal Sons. It brings together a WhatsApp Business CRM with Gemini, a SQL-fed ledger and stock explorer, and ERP dashboards. It runs inside the business today, with over 17,000 bills tracked live.
Puranmal Sons’ leadership commissioned, reviewed and approved the Suite. Raghav Palriwala, the founder of YourTechConsultants, has been a Partner at Puranmal Sons since November 2024, and YourTechConsultants continues to build the products it requests.
| Client | Puranmal Sons, a wholesale building-materials distributor in Indore and a YourTechConsultants client since 2019. |
|---|---|
| Delivered by | YourTechConsultants, led by Raghav Palriwala. |
| What it does | WhatsApp campaigns with Gemini assistance, ledger-to-stock lookups in near-real time, and finance, sales and inventory dashboards. |
| Stack | |
| Status | Ongoing. The Suite runs live inside the business. |
Problem
Puranmal Sons distributes building materials wholesale in Indore. The Suite works from the company’s own SQL Server and ERP data and adds three tools on top of it.
YourTechConsultants knows the work the Suite supports from the inside, because its founder is a Partner in the business.
What was built
The Suite has three parts, built around Puranmal Sons’ ERP and processes.
WhatsApp Business CRM
Built with Flask and Postgres. It runs bulk campaigns over WhatsApp Business, with Gemini giving AI assistance.
Ledger and stock explorer
Fed from SQL. It drills from party to ledger to bill to item stock in near-real time. It runs as an always-on service against Puranmal Sons’ SQL Server.
ERP dashboards
Financial, sales and inventory dashboards, fed from Puranmal Sons’ ERP.
Result
In numbers
17,000+ bills tracked live
Operations & Analytics Suite · Built by YourTechConsultants for Puranmal SonsReported by YourTechConsultants, as of Oct 2026
Together the three tools let Puranmal Sons’ teams reach customers over WhatsApp Business and trace a party from ledger to bill to item stock. The dashboards show finance, sales and inventory.
Earlier work for the same client points the same way. In 2020 to 2021 YourTechConsultants built an interactive GIS sales dashboard (Leaflet.js, Folium, GeoPandas) and a bot that sent payment reminders to debtors, after which receivables fell by more than 20%.
The WhatsApp CRM is an upcoming SaaS product.
The WhatsApp Business CRM with Gemini assistance that runs inside the Suite is in the pipeline as a SaaS (software-as-a-service) product for other businesses. It already runs bulk campaigns over WhatsApp Business for Puranmal Sons.
Tell me what you would use it for. The interest I receive decides which product comes first.
Tell me the workflow you want automated or upgraded.
I read every message and reply personally.
Write to me
Two or three sentences is plenty, for example: “Customers ask me the same questions on WhatsApp and I answer by hand” or “I want my ledger and stock in one place”. No client data, please. If you would like a call, mention day and time for the call.