Balram Pandey

I’m a client-focused operations professional with 3+ years of experience managing customer queries, resolving service issues, and driving process accuracy in a fast-paced pharmacy retail environment. I serve as a primary point of contact for billing, prescription, and service questions while staying steady in SLA-driven workflows.

I’m proven at identifying operational gaps and building data-driven solutions. After noticing recurring stock mismanagement and billing discrepancies, I created a self-initiated Power BI dashboard to track and resolve the issue, reducing billing discrepancies by 34%, while coordinating with procurement, billing, and pharmacy teams to improve day-to-day reliability.

I also bring an analytics mindset to real business problems, from capstone forecasting to risk intelligence. I built an XGBoost demand forecasting model with ABC-XYZ segmentation and safety stock/reorder point optimization (~6% MAPE, 97.6% service level) and developed an end-to-end Excel/SQL/Python/Power BI workflow in PharmaPulse to flag medication adherence and revenue-leakage risk patterns relevant to pharmacy operations.