Mahesh Kumar Raajbhar

Work History

Data Analyst

ByteDance Ind. Pvt. Ltd

Gurgaon

07.2019 - Current

As a Data Analyst, I am responsible for the planning and development of design and procedures for metrics reports. To accomplish this, I work closely with cross-functional teams and stakeholders to identify business requirements and develop data-driven solutions to meet their needs. I utilize my expertise in data analysis, data visualization, and data management to ensure the development of effective and efficient metrics reporting processes.
I take a proactive approach to continuously improve the metrics reporting processes, keeping abreast of the latest trends, technologies, and best practices in the industry. I collaborate with internal and external partners to identify opportunities for innovation and optimization in metrics reporting, ensuring that we stay ahead of the curve.
I have successfully designed and implemented metrics reporting processes that have improved the accuracy, timeliness, and relevance of data. I have developed dashboards and other reporting tools that enable stakeholders to easily access, analyze, and interpret data, driving informed decision-making across the organization.
I developed a new business model that requires minimal training and is divided into five segments. As a result, we observed significant improvements in latency and productivity, and it also enables the MODs to access more accurate and timely information.
I've created an algorithm using Google Scripts that rapidly pairs individuals from different roles and departments, and immediately sends them an invitation containing information about their respective backgrounds and interests. This efficient process facilitates connections between individuals from different roles, allowing them to gain a better understanding of each other's work nature.
Investigate data quality issues reported by stakeholders and find solutions/fixes.
Worked with the management team to create a prioritized list of needs for each business segment.
Use Google Sheets, Google Script, and DataPower to prepare real-time dynamic dashboards and visualize data.
I collaborate with internal and external partners to identify opportunities for innovation and optimization in metrics reporting, ensuring that we stay ahead of the curve
I have successfully designed and implemented metrics reporting processes that have improved the accuracy, timeliness, and relevance of data
I have developed dashboards and other reporting tools that enable stakeholders to easily access, analyze, and interpret data, driving informed decision-making across the organization
I developed a new business model that requires minimal training and is divided into five segments
As a result, we observed significant improvements in latency and productivity, and it also enables the MODs to access more accurate and timely information
I've created an algorithm using Google Scripts that rapidly pairs individuals from different roles and departments, and immediately sends them an invitation containing information about their respective backgrounds and interests
This efficient process facilitates connections between individuals from different roles, allowing them to gain a better understanding of each other's work nature
Build and update dashboards to drive actionable insights and self-service for all stakeholders
Investigate data quality issues reported by stakeholders and find solutions/fixes
Use Google Sheets, Google Script, and DataPower to prepare real-time dynamic dashboards and visualize data
Worked with the management team to create a prioritized list of needs for each business segment
Collaborated with departmental managers to identify specific data needs for each business method analysis project
Converted data into actionable insights by predicting and modeling future outcomes.
Utilized Excel, SQL, DataPower, MMP, TCS, and other dashboard/visualization toolsets for data intelligence and analysis.
Successfully realigned the Helo Business, resulting in increased efï¬ciency by 30% and quality by 10% within a month
Created an automated sheet that enables stakeholders to check key metrics status with just one click
Created specifications and generated reports and analysis mapping as per business needs
Provided consultation and led cross-functional teams to address business issues.
Created Scorecard for Agents/Duty Ofï¬cers/Team Leaders
Produce datasets and reports for analysis using databases and reporting tools
Provide actionable data-driven recommendations to stakeholdersâ business questions
Established current and ongoing data support and reporting needs
Coming up with solutions to costly business problems
Preparing weekly/monthly weekly business review for top management.

Data Analyst

Medlife international Pvt. Ltd

10.2018 - 07.2019

I was responsible for overseeing and managing the planning and execution of supply chain operations
Specifically, my role involved ensuring that all products were delivered on time and in compliance with customer requirements
I worked closely with cross-functional teams, including operations and logistics, teams, to develop and implement supply chain plans that aligned with business objectives
I monitored supply chain performance metrics, identified areas for improvement, and implemented process improvements to increase efficiency and reduce costs
My role involved creating performance reports for in-house shipments across multiple locations and analyzing shipment data to determine the cost per shipment at each location
I am responsible for creating performance reports for all third-party logistics (3PL) partners, which includes analyzing their Return to Origin (RTO) rate, damage rate, and loss rate to identify areas of improvement for each partners
As part of my responsibilities, I create cost analysis reports to provide insights into project expenses and share them with management for decision-making purposes
I collect data to determine the root cause of cancellations, analyzing factors such as customer feedback, product quality, and operational issues to identify patterns and opportunities for improvement
I optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis
I utilized macros and created them as needed for automation purposes
I was accountable to include verifying the accuracy of all the information entered into the system, and updating it as necessary to maintain data integrity
Presented data and conclusions to team in order to improve strategies and operations
Proposed solutions to improve system efficiencies and reduce total expenses
I have utilized advanced features of Microsoft Excel, such as creating pivot tables and pivot reports, and utilizing functions such as VLOOKUP, Index-match, Nested IF, COUNTIF, and SUMIF, to streamline data analysis and improve report accuracy.

Executive

MIS, Pepperfry

07.2015 - 10.2018

Demonstrated ability to collaborate cross-functionally with procurement, logistics, and production teams to develop and execute supply chain strategies that align with business objectives
Experience in developing and maintaining data models, dashboards, and reports to identify trends, patterns, and insights that support data-driven decision making in the supply chain
Strong understanding of supply chain operations and processes, including procurement, planning, logistics, and inventory management
Demonstrated ability to work collaboratively with cross-functional teams to identify data requirements and provide analytical support for supply chain improvement initiatives
Prepared Daily/weekly/monthly performance status report
Creating a report on business analysis for multiple locations across India, including PAN India
Creating a reward scheme for temporary employees across various locations in India
Gathered, evaluated, and recorded the quarterly and semi-annual performance data of the company
I prepare and maintain trackers for Vehicle Compliance (RC, Fitness Renewal, Pollution) and highlight them to the transport team before the expiration of Vehicle Compliance (RC, Fitness Renewal, Pollution)
I oversaw the implementation of MIS processes and assessed their efficacy
Provide strong reporting and analytical information support to management team
Generate both periodic and ad-hoc reports as needed
Analyze business information to identify process improvements for increasing business efficiency and effectiveness
Participate in cross-functional meetings to resolve recurring customer issues.

Executive

Vulcan Express

New Delhi

09.2014 - 07.2015

I was responsible for overseeing warehouse operations, such as periodic inventory audits, invoicing, packaging, and dispatch.
Effectively monitors flow of goods and implements First-In First-Out (FIFO) method in the use of raw materials and in dispatching of finished goods.
Responsible for preparing reports include inventory of stocks, dead stock, consumption and manpower.
Ensuring SDD & NDD Orders handover to courier partner within timeline.
Planning Manpower schedule for busy seasonal schedule.

Summary

Overview

Work History

Data Analyst

Data Analyst

Executive

Executive

Education

Bachelor of Computer Application -

12th - undefined

10th - undefined

Skills

Timeline

Similar Profiles

Pratik SharmaPratik Sharma

Aniket AdesaraAniket Adesara

AMRITESH KUMARAMRITESH KUMAR

Sukanta MalakarSukanta Malakar

Samiksha SinghSamiksha Singh