Mohit Agrawal

Business Analyst

Mumbai, Maharashtra, India5 yrs 1 mo experience

Highly Stable

Key Highlights

Developed comprehensive dashboards for executive decision-making.
Automated reporting processes, improving efficiency by 60%.
Expert in data visualization and analysis across multiple platforms.

Stackforce AI infers this person is a Data Analyst with expertise in Business Intelligence and Data Visualization within the Fintech sector.

Contact

Skills

Core Skills

Data AnalysisBusiness Intelligence

Other Skills

Data ScienceOperational AnalysisSQLExcelMetabaseData VisualizationPowerPointGoogle SheetsTime ManagementResearch SkillsProject ManagementOffice 365TrainingData AcquisitionData Architecture

About

Fuelled by data and a relentless curiosity, I'm a data analyst who loves transforming numbers into insights and insights into impact. My journey through data analysis, data science, data visualization, and business intelligence has been an adventure in problem-solving, where tools like Excel, Tableau, and Power BI are my trusty sidekicks. From streamlining processes to cracking the code on call center efficiency, I’m all about making data work smarter, not harder. With a solid mix of tech and non-tech skills, I’ve tackled over 30 projects—everything from workforce planning to loan default analysis—building a dynamic perspective on data-driven solutions. Certified in data analytics and fluent in MySQL and Python, I’m always leveling up my toolkit to stay ahead in the ever-evolving world of data. When I'm not digging into datasets, you’ll find me exploring new destinations and hidden cafés, chasing inspiration wherever it may wander. Let’s connect if you’re up for a chat about data, fresh perspectives, or creative collaborations!

Experience

5 yrs 1 mo

Total Experience

3 yrs 6 mos

Average Tenure

1 yr 6 mos

Current Experience

Blox.xyz

Data Analyst CSO office

Nov 2024 – Present · 1 yr 6 mos · Mumbai, Maharashtra, India · On-site

Developed a comprehensive Payments Dashboard for the Finance team, enabling the CFO and CEO to monitor collections, disbursements, and cash flow with high accuracy.
Created a strategic Investor Dashboard and accompanying PPT used by the CBO in executive-level reviews with the CFO and CEO.
Designed and built automated sales performance dashboards in Metabase, reducing manual reporting by 60% and supporting data-driven decisions across teams.
Wrote and optimized SQL queries to extract, clean, and validate data from multiple sources (CRM, spreadsheets, internal tools).
Built advanced models and reports using Excel (pivot tables, XLOOKUP, dynamic dashboards) to support ad-hoc analysis and revenue tracking.
Created dynamic dashboards in Google Sheets using advanced formulas including QUERY(), ARRAYFORMULA(), conditional formatting, and data validation—enabling real-time, collaborative reporting for cross-functional teams.
Conducted deep sales funnel analysis, identifying key drop-off points and improvement areas, leading to a measurable lift in conversion rates.
Built and maintained an incentive dashboard for the Sales team, streamlining RM payout calculations and improving transparency.
Performed cohort analysis and A/B testing to evaluate campaign effectiveness and inform optimization strategies for the Digital Marketing team.
Delivered in-depth ad channel performance analysis, helping reduce CAC and reallocate spend toward higher-performing sources.
Partnered with the Tech and Product teams to provide behavioral insights that guided development of the company’s new RM app.
Authored a company-wide Metabase guidebook to improve dashboard adoption and reduce BI support dependency.

Data ScienceOperational AnalysisSQLExcelMetabaseData Analysis+1

Grid work it

Data Analyst

Sep 2024 – Nov 2024 · 2 mos · Mumbai, Maharashtra, India · Remote

Built Tableau and Power BI dashboards to track employee satisfaction, attrition, and onboarding
metrics for 400+ employees, enabling data-driven decisions.
Automated reporting for key HR metrics including average tenure, policy compliance, and exit
trends, improving operational efficiency.
Collaborated with client success and engineering teams to translate business requirements into
scalable reports, ensuring cross-functional alignment.

Freelance

Data Analyst

Jan 2021 – Aug 2024 · 3 yrs 7 mos · Mumbai, Maharashtra, India · Remote

Partnered with a retail client to design a sales performance dashboard in Tableau, enabling real-time tracking of SKUs and driving a 10% increase in revenue through better stock management.
Built an Excel- and Google Sheets-based financial model for a startup, automating monthly reporting and cashflow forecasting, reducing manual effort by 70%.
Delivered data-cleaning and standardization solutions for a client managing multiple CRM sources, improving reporting accuracy and reducing errors in campaign ROI tracking.
Created Power BI dashboards for a digital marketing agency to visualize ad spend vs. lead conversions, helping identify underperforming campaigns and reallocate budgets effectively.
Consulted for a small hospitality business to analyze guest booking and feedback trends, providing actionable recommendations that reduced cancellations by 12% and improved guest satisfaction ratings.
Assisted an e-commerce client in building customer segmentation models in Excel/SQL, enabling targeted email campaigns that improved click-through rates by 18%.
Designed a Google Sheets automation with QUERY & IMPORTRANGE for a consulting firm, consolidating data from multiple teams and reducing reporting prep time from 4 hours to 30 minutes weekly.
Conducted a deep-dive churn analysis for a subscription-based client, identifying retention drivers and providing actionable recommendations that cut churn by 9%.
Delivered a KPI monitoring suite in Power BI for a logistics startup, tracking delivery times, order accuracy, and costs, which improved SLA compliance by 15%.
Collaborated with an independent finance advisor to visualize investment portfolio performance in Tableau, making client presentations more data-driven and impactful.