Mohan Agrawal

About Mohan Agrawal

Detail-oriented and results-driven Data Analyst with over 3 years of experience in data extraction, transformation, manipulation, and cleaning using SQL, Power BI, and MS Excel. Proficient in creating insightful visualizations, analytical dashboards, and reports that drive data-driven business decisions. Adept at presenting complex findings to executive stakeholders using PowerPoint. Experienced in leveraging analytical and visualization tools to provide decision-making insights. Demonstrated leadership and teamwork skills, with the ability to work independently and deliver results under minimal supervision.

Experience

1. Business Analyst

   Flipkart

   Jan 2024 — Present · Bengaluru, IN

   Responsible for driving seller profitability through optimizing offers, pricing strategies, improving product listings, and managing stock for seasonal sales using data-driven insights.•Designed, developed, and tested various Power BI dashboards and ad-hoc reports by connecting to multiple data sources and databases, providing key insights to business stakeholders.As a Power BI SME, I spearheaded the design, development, and support of interactive visualizations used across the company, ensuring best practices for data modeling and visualization.Created diverse visualizations such as scatter plots, Sankey charts, Gantt charts, trend lines, and geo-maps to enhance the usability of dashboards for end users.Managed Power BI portal tasks such as data refreshes, user management, and setting up gateway data refresh.Utilized parameters, quick filters, dynamic axes, and table calculations to build complex dashboards with drill-down/up functionalities, enhancing user experience.•Conducted meetings with business stakeholders, clients, and director-level members for requirement gathering, presenting solutions using best data visualization practices.•Extensive experience in blending multiple data sources and creating joins to ensure smooth integration for analysis, using SQL for data extraction and validation.Used advanced SQL queries (JOINs, subqueries, CTEs) to validate data, ensuring data quality for analysis and decision-making.•Leveraged my data visualization, statistical analysis, and presentation skills to create reports that supported strategic decision-making for business growth.

Education

• MGM's Dr GYP college of CS and IT

  Bachelor's degree, Information Technology

• PSBA English School

  10th

• Shivchattrapati College

  HSC, Computer Science

• Deogiri Institute of Engineering and Management Studies, Aurangabad

  Master of Business Administration - MBA, Marketing