At Allengers Medical Systems Pvt. Ltd., I design and maintain Excel workbooks for daily, weekly and monthly MIS reporting. My reporting changes cut preparation time from 1–2 hours to 5–10 minutes.
I also built a date-wise Shortage Dashboard that compares yesterday’s shortage with today’s position and highlights items needing action. For management reviews, I create interactive dashboards with PivotTables, PivotCharts, slicers and timelines.
I use Power Query to clean, validate and transform data from multiple sources, and extract material and shortage data from SAP S/4HANA CDS views into Excel reporting models. I’ve also created inventory and sales dashboards to show stock, usage trends and state-wise shipments.
Before this, I reviewed customer and client documents at Concentrix for tampering and inconsistencies, and supported data entry, documentation, Excel reporting and SAP payroll data handling during my apprenticeship at Bharat Electronics Limited (BEL).

