Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Accomplishments
Software
Timeline
BusinessAnalyst
SANJEEV KHAKRE

SANJEEV KHAKRE

Indore/Bangalore

Summary

Highly skilled Senior Data Analyst with 15+ years of experience in delivering data-driven business insights, enhancing sales performance, and driving business growth. Proficient in advanced data analytics, dashboard creation, and KPI tracking using Power BI and DAX. Collaborates with sales teams to align strategies with business objectives to maximize operational efficiency and foster innovation.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

Mensa Brand Technologies Private Limited
06.2023 - Current
  • Lead sales reporting efforts for both online and offline channels by creating comprehensive reports that provide actionable insights for top management
  • Manage the admin console of the Sales Field Assist platform, ensuring the sales team has access to the required tools and resources
  • Act as the main point of contact for the sales team, offering support, responding to inquiries, and ensuring smooth operations
  • Regularly communicate updated inventory details to the sales team, facilitating informed sales decisions
  • Provide daily updates on Month-to-Date (MTD) sales target achievements to ensure real-time performance tracking
  • Send daily notifications and critical updates to the team, ensuring timely communication

MIS Executive

Dharampal Satyapal Group (The Good Stuff Private Limited)
08.2022 - 06.2023
  • Administered the Sales Force application for the entire organization across India, ensuring smooth operations
  • Generated primary and secondary sales reports for stakeholders, prepared PowerPoint presentations for weekly reviews, and supported DOPO, TSE, and salary-related activities
  • Monitored stock flow and provided critical sales insights

Senior Data Analyst

Future Consumer Limited
02.2022 - 07.2022
  • Maintained minimum inventory levels for raw materials and ensured compliance with committed order values
  • Prepared market analysis reports and coordinated with suppliers to streamline operations
  • Worked on product edging and ensured data accuracy for business decisions

MIS Executive

Mysore Deep Perfumery House (Zed Black)
04.2018 - 01.2022
  • Created detailed MTD, QTD, YTD sales reports categorized by state, zone, category, division, and product
  • Monitored new product sales trends and prepared schemes for article distribution
  • Managed slow-moving product data, dead stock, and export sales reports
  • Delivered daily depot stock positions to the management team and evaluated distributor performance

Senior MIS Executive

SAI Brushes Pvt. Ltd.
01.2010 - 03.2018
  • Generated daily, monthly, and yearly sales reports, and managed incentive schemes, growth metrics, and stock reporting
  • Maintained production planning sheets and streamlined the distribution process
  • Evaluated zero billing parties and analysed year-on-year growth

Education

Bachelor of Arts - Political Science

Devi Ahilya Vishwavidyalaya (DAVV)
Indore
01.2012

12th Grade -

Madhya Pradesh Board
01.2007

Skills

  • Data Analytics and Reporting
  • Power BI
  • Tableau
  • PostgreSQL
  • Power Query (ETL)
  • Advanced Excel
  • Programming and Automation
  • Python
  • VBA
  • Macro
  • DAX (Power Pivot)
  • Data Visualization
  • Dashboard creation
  • PowerPoint presentations
  • Sales Analytics
  • KPI tracking
  • Sales forecasting
  • Inventory analysis
  • Tools
  • Salesforce
  • Admin Console Management
  • AI (ChatGPT)

Certification

  • Diploma in computer Application
  • 3 Month Internal Auditor Training for ISO 9001-2015 certification
  • Udemy Power Bi Course
  • Udemy Excel Certification
  • Udemy Visually Effective Dashboard
  • Udemy Google sheets -The Comprehensive Master Class
  • Udemy The Complete Prompt Engineering for AI Bootcamp (2024)

Additional Information

15 Years

Accomplishments

  • Used Microsoft Excel to develop inventory tracking spreadsheets.
  • Achieved [Result] through effectively helping with [Task].
  • Resolved product issue through consumer testing.
  • Collaborated with team of 300 in the development of [Project name].
  • Achieved [Result] by introducing [Software] for [Type] tasks.
  • Achieved [Result] by completing [Task] with accuracy and efficiency.
  • Collaborated with team of [Number] in the development of [Project name].
  • Documented and resolved [Issue] which led to [Results].
  • Supervised team of [Number] staff members.

Software

Power bi

Zoho

Tally ERP 9

SAP

Field Assist and Bizom

Timeline

Senior Data Analyst

Mensa Brand Technologies Private Limited
06.2023 - Current

MIS Executive

Dharampal Satyapal Group (The Good Stuff Private Limited)
08.2022 - 06.2023

Senior Data Analyst

Future Consumer Limited
02.2022 - 07.2022

MIS Executive

Mysore Deep Perfumery House (Zed Black)
04.2018 - 01.2022

Senior MIS Executive

SAI Brushes Pvt. Ltd.
01.2010 - 03.2018
  • Diploma in computer Application
  • 3 Month Internal Auditor Training for ISO 9001-2015 certification
  • Udemy Power Bi Course
  • Udemy Excel Certification
  • Udemy Visually Effective Dashboard
  • Udemy Google sheets -The Comprehensive Master Class
  • Udemy The Complete Prompt Engineering for AI Bootcamp (2024)

Bachelor of Arts - Political Science

Devi Ahilya Vishwavidyalaya (DAVV)

12th Grade -

Madhya Pradesh Board
SANJEEV KHAKRE