Hi, I'mAbhishek Raj

MIS Executive with 1+ years of hands-on experience in ERP-based operational MIS reporting, covering challan, e-way bill, and procurement workflows at Worldfa Exports. Skilled in building and automating daily, weekly, and monthly MIS reports using Advanced Excel (PivotTables, XLOOKUP, SUMIFS/COUNTIFS, INDEX-MATCH) and Power Query—reducing manual ETL effort across recurring reporting cycles. Performs pre-distribution data validation and reconciliation to ensure data accuracy before reports reach leadership and handles ad hoc analysis requests within defined TAT.

• Prepared and distributed MIS reports across 5 recurring report categories—covering inward and outward challan activity (Job Work, Packing, Dent, Super Tool Rejection, Punching, Bending, Polishing, and Circle Cutting)—tracking up to 2,000 challans processed daily, rolled up into daily, weekly, and monthly cycles by extracting ERP-entered transaction data and analysing it in Excel using PivotTables, XLOOKUP, SUMIFS/COUNTIFS, and INDEX-MATCH.
• Downloaded and analysed data from the government E-Way Bill portal, preparing daily reports on the ~20 inward and outward e-way bills generated, using PivotTables and conditional formatting to flag anomalies and support operational visibility.
• Prepared daily reports on the ~100 Purchase Orders (POs) raised in the ERP, using SUMIFS, COUNTIFS, and PivotTables to track PO count, vendor/party, material, and order value, giving purchasing and management teams a clear daily view of procurement activity.
• Replaced a fully manual, repetitive ERP data-extraction and transformation process—previously done by the team for every report—by automating it in Power Query, so pointing to the data source alone regenerated all recurring reports, eliminating repeated manual ETL work across daily/weekly/monthly cycles.
• Performed data validation and reconciliation across ERP, challan, PO, and e-way bill exports before report distribution, catching mismatches multiple times a week before they reached leadership.
• Handled ad hoc data requests from department heads, delivering custom analysis and summary reports within agreed turnaround times.

GPA: 8.23/10 — Foundation in programming, databases, and software engineering.

Percentage: 79.8% (399/500) — Completed Higher Secondary (Science) under Bihar School Examination Board (BSEB), Patna, with a strong foundation in Mathematics, Physics, Chemistry, and analytical problem-solving.

Percentage: 68.6% (343/500) — Completed Secondary Education under Bihar School Examination Board (BSEB), Patna, building a strong foundation in Mathematics, Science, English, and analytical thinking.