ABHISHEK RAJ
Data Analyst | MIS Executive | SQL Server | Power BI | Advanced Excel
Phone: +91-9262648753 |
Email: abhishekr359@gmail.com |
LinkedIn: linkedin.com/in/abhishekrajverma |
Location: Gurgaon & Noida, India
Professional Summary
Data-focused MIS Executive and aspiring Data Analyst with 1+ years of hands-on experience in reporting automation,
dashboard development, and business performance analysis. Strong working knowledge of SQL Server, Power BI, Excel,
Power Query, and Excel VBA. Delivered measurable impact by reducing manual reporting effort by 60 percent and
improving dashboard/report performance by up to 40 percent. Comfortable converting business requirements into clear
KPI frameworks and decision-ready insights.
Core Skills
PythonNumPyPandas
MatplotlibSeabornSQL Server
Advanced ExcelPower BIPower Query
Excel VBAMIS ReportingDashboard Development
KPI TrackingData CleaningData Validation
EDATrend AnalysisRoot Cause Analysis
Business InsightsStakeholder Communication
Prompt Engineering
Professional Experience
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.
Projects
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 using indexing, query tuning, and cleaner data model relationships; dashboards supported 500+ daily users.
Kaggle Zomato Data Analytics Project | SQL Server, Excel, Power BI
- Performed data cleaning and transformation for missing values, duplicate records, 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, average 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.
Education
B.Tech, Computer Science and Engineering
MM University, Haryana | 2020 - 2024 | GPA: 8.23/10
Certifications
Data Analyst Certification — Simplilearn
Additional Information
Languages: English, Hindi