Abhishek Pandey
Data Analyst / MIS
Delhi
Summary
Detail-oriented and analytical Data Analyst/MIS professional with 5+ years of experience in managing, analyzing, and visualizing data to support strategic business decisions. Proficient in using tools like Excel (Advanced), SQL, Power BI, and AI platforms (ChatGPT) to streamline reporting processes, automate workflows, and deliver actionable insights. Adept at creating dashboards, performing root cause analysis, and enhancing MIS efficiency across operations.
Overview
6
6
years of professional experience
2016
2016
years of post-secondary education
3
3
Certifications
2
2
Languages
Work History
Data Analyst / MIS Executive
Creamy Foods Ltd. (Madhusudan) SMC Group
10.2024 - Current
- Automated repetitive reporting processes using Power BI, Excel macros and ChatGPT, reducing manual effort by 40%.
- ChatGPT to generate summaries, automate email drafts, or assist in report commentary.
- Gather data from internal systems (ERP, CRM, databases) and external sources.
- Design and automate MIS reports (daily, weekly, monthly) for stakeholders.
- Build interactive dashboards in Power BI to visualize KPIs and metrics.
- Use Advanced Excel (PivotTables, SUMPRODUCT, INDEX-MATCH, VLOOKUP, XLOOKUP, SUMIF,OFFSET, VBA) for custom reports.
- Support budgeting, forecasting, and performance reviews with data-driven insights.
- Ensure compliance with data privacy and security protocols.
- Clean, validate, and organize raw data for analysis and Perform root cause analysis to support business decision
Data Analyst / MIS Executive
Genpact Pvt. Ltd.(Walmart Process)
04.2019 - 10.2024
- Designed and maintained interactive dashboards and KPIs in Power BI for performance tracking and forecasting.
- Developed and optimized complex SQL queries to extract meaningful insights from large datasets.
- Maintain documentation for data sources, logic, and report definition.
- Created weekly/monthly MIS reports and executive summaries for senior stakeholders.
- Analyzed business trends and provided actionable insights to improve operational efficiency.
- Design and automate MIS reports (daily, weekly, monthly) for stakeholders.
- Use Advanced Excel (PivotTables, SUMPRODUCT, INDEX-MATCH, VBA) for custom reports.
Education
Bachelor of Computer Applications -
Skills
Power BI
Excel Dashboards
PivotTables
DAX
Advanced Excel
SQL
ChatGPT
Copilot
Data Visualization
Reporting
MS Word
MS PowerPoint
Report Writing
Attention to detail
effective communication
problem-solving mindset
Certification
Microsoft Certified: Data Analyst Associate (Power BI)
Interests
Internet Surfing
Disclaimer
I hereby declare that the information furnished above is given with full sincerity and honesty. I bear the responsibility for the correctness of all mentioned above information.
Personal Information
- Date of Birth: 01/01/93
- Gender: Male
- Nationality: Indian
- Marital Status: Married
- Religion: Hindu
Software
Power BI, SQL, Excel, ChatGPT, Copilot
Timeline
Data Analyst / MIS Executive
Creamy Foods Ltd. (Madhusudan) SMC Group
10.2024 - Current
Data Analyst / MIS Executive
Genpact Pvt. Ltd.(Walmart Process)
04.2019 - 10.2024