Mohan Agrawal

Business Analyst

Aurangabad, Maharashtra, India4 yrs 7 mos experience

Key Highlights

Over 3 years of data analysis experience.
Expert in Power BI and SQL for data-driven insights.
Proven ability to present complex findings to stakeholders.

Stackforce AI infers this person is a Data Analyst with expertise in E-commerce and Finance sectors.

Contact

mohanagrawal7171@gmail.com LinkedIn

Skills

Core Skills

Data AnalysisData VisualizationBusiness Analysis

Other Skills

AdministrationAnalytical SkillsBusiness DevelopmentCorporate Social ResponsibilityCritical ThinkingCustomer Relationship Management (CRM)Customer RetentionDashboard BuildingDashboardsData AnalyticsData CleaningData MiningData ScienceData WarehousingData-Driven Insights

About

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

Flipkart

Business Analyst

Jan 2024 – Present · 2 yrs 2 mos · Bengaluru, Karnataka, India · On-site

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.

Power BISQLData VisualizationData AnalysisStatistical Analysis

Code icons technology

Data Analyst

Aug 2021 – Jan 2024 · 2 yrs 5 mos · Pune, Maharashtra, India

As a dedicated Data Analyst with over 2.5 years of hands-on experience in analytics and systems development, I have successfully applied my expertise in SQL Server, Power BI, and Tableau to drive data-driven decision-making in the banking, finance, and insurance sectors. I have been responsible for creating SQL datasets that serve as the foundation for both recurring and ad-hoc reports, significantly enhancing reporting efficiency and accuracy.
In my role, I developed ad-hoc reports using Tableau Desktop, connecting diverse data sources to produce meaningful insights and visualizations for stakeholders. By closely collaborating with cross-functional teams, I gathered requirements and translated them into effective dashboards and reporting visualizations, directly addressing business needs. My proficiency in SQL allowed me to construct complex queries involving joins, subqueries, and Common Table Expressions (CTEs), ensuring thorough data analysis across multiple tables.
I have expertly crafted various reports in Power BI tailored to client specifications, leveraging advanced features such as Filters (Slicers) and Drill-down Reports. By utilizing DAX expressions, I created calculated columns and measures that added depth to my analyses. My experience in building dashboards, scorecards, and pivot tables enabled me to facilitate further data exploration and performance tracking.
Additionally, I maintained and scheduled a variety of reports in SQL Server Reporting Services (SSRS), including tabular and matrix reports, which provided timely insights to management. I excelled at connecting multiple data sources in Power BI, implementing comprehensive reporting solutions that empowered stakeholders to make informed decisions.
Recognizing the importance of knowledge sharing, I conducted advanced Power BI training sessions for stakeholders and team members, equipping them with essential analytics skills.

SQLPower BITableauData AnalysisReportingBusiness Analysis