Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

NITESH KUMAR

Pune

Summary

Diligent Admin Professional with expertise in logistics operations, currently contributing to Xpressbees' Headquarters. Responsible for managing and overseeing administrative expenses exceeding 50 crore per month across 900 locations nationwide. Proficient in SQL, Excel, and Power BI for data analysis and reporting. Skilled in coordinating with regional managers and team members to ensure accurate expense tracking and compliance with organizational standards. A detail-oriented problem-solver committed to optimizing cost-efficiency and streamlining administrative processes.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Executive- MIS Lead (Data Analysis And Reporting)- PAN India

XpressBees -Busybees Logistics Solutions Pvt. Ltd
Pune
04.2023 - Current
  • Led the Admin MIS Team, end-to-end tracking of 750 pan-India locations of all expenses
  • Tracking of monthly and yearly provisioned expenses and licensing with external auditors
  • Implemented cost-effective measures, overseeing admin dashboards for monthly reports on 50 crore transactions using Excel, SQL, and Power BI
  • Enable Risk management and compliance, CPS calculations, and cost analysis for Hubs and e-commerce channels in coordination with NHQ & regional teams
  • Streamline pan-India admin data and error and improvised tracking of all bills paid or unpaid bills by the live dashboard
  • Leveraged client data and available insights to improve alignment of business priorities and utilization of resources
  • Liaised between operational and engineering teams to coordinate successful business improvement projects
  • Improved alignment of business priorities and resource utilization by leveraging client data insights.

Sr Associate (Analyst MIS)

Magicpin
Gurgaon
12.2021 - 01.2023
  • Working with operation team preparation & circulation of MIS Reports on a daily, monthly, and quarterly Basis
  • Successfully managed the Brand Privilege Program, achieving a 500% increase in daily bills
  • Produced daily reports, assigned data to field agents, and developed effective sales strategies
  • Utilized Excel, SQL, and Tableau for data analysis and visualization
  • Managed data collection, visualization, and reporting for projects of different scales and applications
  • Devised and optimized tracking metrics for assessing sales and consumer data
  • Reviewed and analyzed litigation files to brief colleagues and clients.

Associate

Magicpin
Gurgaon
12.2019 - 12.2021
  • Working in a sales team dealing with the client, managing his dashboard, and increasing sales revenue by 8% per month
  • Identified and resolved customer needs promptly and efficiently
  • Produced and sent sales and KPI reports to managers to provide an overview of business health and profitability
  • Analyzed past sales data and team performance to develop realistic sales goals through Tableau and CRM
  • Made daily reports in Excel and cold-called for new business leads.

Demand Manger (Oyo)

Enser Communication PVT.Ltd
Gurgaon
03.2019 - 12.2019
  • Manage corporate deals with the company maintain booking and traveling churned merchants and create daily revenue reports
  • Met supply requirements by strengthening inventory systems
  • Maintained required inventory levels at minimal cost
  • Negotiated contracts with suppliers to establish quality, cost, and delivery requirements.

Education

PG DEPLOMA IN DATA SCIENCE -

Scalar Academy
06.2023

Mechanical Engineering -

Jaipur National University
03.2019

PCM -

Red Rose School
03.2014

Skills

  • Advanced Excel
  • Tableau
  • Dataset Analysis
  • SAP
  • Data Cleaning
  • Risk Management
  • Team Management
  • Data Modelling
  • Data Visualization
  • Power BI
  • Pandas
  • NumPy
  • Analytical Problem Solving
  • Data Analysis
  • Dashboarding
  • Data Validation
  • Process Improvement
  • Data Warehousing
  • Business Needs Analysis
  • Data Analysis
  • Dashboarding
  • Data Validation
  • Process Improvement
  • Data Warehousing
  • Business Needs Analysis
  • Data Analysis
  • Dashboarding
  • Data Validation
  • Process Improvement
  • Data Warehousing
  • Business Needs Analysis

Certification

  • 06/2023, Google Data Analytics Certificate
  • 04/2022, Business Analytics with Excel Simplilearn
  • 03/2023, Basic(SQL) Hacker Rank
  • 01/2024, Six Sigma (Green Belt) LinkedIn
  • 03/2024, Mocrosoft PowerBI

Accomplishments

  • Achieved a 500% increase in daily bills through effective management of the Brand Privilege Program.
  • Developed and implemented realistic sales goals resulting in improved team performance.
  • Reduced expenses and enhanced efficiency in the Admin Department.
  • Reduced expenses and enhanced efficiency in the Admin Department.

Timeline

Senior Executive- MIS Lead (Data Analysis And Reporting)- PAN India

XpressBees -Busybees Logistics Solutions Pvt. Ltd
04.2023 - Current

Sr Associate (Analyst MIS)

Magicpin
12.2021 - 01.2023

Associate

Magicpin
12.2019 - 12.2021

Demand Manger (Oyo)

Enser Communication PVT.Ltd
03.2019 - 12.2019

PG DEPLOMA IN DATA SCIENCE -

Scalar Academy

Mechanical Engineering -

Jaipur National University

PCM -

Red Rose School
NITESH KUMAR