ABHISHEK RAJ

MIS Executive

Worldfa Exports Pvt Ltd, Haryana, India | May 2025 - Present

• Created and maintained 30+ daily, weekly, and monthly MIS reports using SQL Server and Advanced Excel, reducing reporting delays by 35 percent.
• Designed 12+ Power BI dashboards to monitor sales, inventory, finance, and operations KPIs, cutting decision turnaround time by 25 percent.
• Systematized repetitive reporting workflows with Power Query and Excel VBA, reducing manual effort by approximately 60 percent.
• Wrote and optimized 100+ SQL queries, views, and stored procedures, improving data extraction speed by 40 percent and reducing data errors by 20 percent.
• Improved dashboard/report performance by up to 40 percent through better SQL logic, indexing, and data model improvements.
• Collaborated with 6+ cross-functional teams to convert business questions into 20+ trackable KPIs and monthly actionable insight reports.

Enterprise ERP Analytics Dashboard | SQL, Power BI, Excel

• Developed module-wise dashboards for Inventory, HR, Finance, and Sales with drill-down filters for plant, team, time period, and product category analysis.
• Created reusable SQL views and stored procedures to standardize KPI calculations such as fill rate, order cycle time, inventory turnover, and variance against targets.
• Improved query execution and dashboard responsiveness by up to 40 percent; dashboards supported 500+ daily users.

Kaggle Zomato Data Analytics Project | SQL Server, Excel, Power BI

• Performed data cleaning and transformation for missing values, duplicates, and inconsistent location/cuisine tags before loading curated data into SQL Server.
• Built analysis-ready SQL views for city-wise and cuisine-wise performance, price bands, ratings, vote volume, and online delivery adoption trends.
• Published an interactive Power BI dashboard with slicers and KPI cards to compare restaurant segments and identify high-demand cuisines and target markets.

MIS Reporting Process Optimization Suite | Excel VBA, Power Query, SQL Server

• Built a standardized reporting suite that pulled data from SQL Server, transformed it in Power Query, and exported ready-to-share MIS summaries for management.
• Used Excel VBA macros to automate refresh, formatting, validation checks, and scheduled report packaging, reducing manual reporting touchpoints and turnaround time.