At Aurobindo Pharma Ltd, I built Power BI dashboards and MIS reports tracking $70M+ monthly revenue, open demand, backorders, and dispatch KPIs. Using DAX and data modelling, I replaced manual Excel workflows and reduced reporting turnaround time.
I maintain pharmaceutical sales, inventory, and supply chain datasets, applying data quality checks across weekly, monthly, and quarterly refreshes. I also defined governance standards and validation rules to support data integrity across cross-functional teams.
For the U.S. market, I analyze sales, supply, and inventory data with SQL and Power BI, and translate stakeholder requirements into reporting frameworks. I lead S&OP, including one-year demand forecasting and backorder analysis, supporting capacity planning and decisions for a $1B+ generics portfolio.
I automated SKU licensing master data workflows with Advanced Excel and Power Query, eliminating 3–4 hours of manual effort per week and reducing data entry errors. I also manage DEA tracking and controlled substance export documentation, and monitor workflows using Oracle ERP, Agile PLM, and QMS.
