Mahesh Kumar Raajbhar - Data Analyst - ByteDance Ind. Pvt. Ltd

Summary

Profile Summary As a highly skilled and proactive Data Analyst, my objective is to leverage my expertise in data analysis, visualization, and management to drive the planning and development of metrics reports that meet the evolving needs of cross-functional teams and stakeholders. With a track record of successfully designing and implementing metrics reporting processes, I aim to improve data accuracy, timeliness, and relevance while enabling stakeholders to access and interpret data for informed decision-making. My proficiency in tools such as Advance Excel, SQL,Python, and visualization platforms like Google DataStudio and DataPower allows me to build real-time dynamic dashboards and provide actionable insights. I excel in collaborating with internal and external partners to identify opportunities for innovation and optimization in metrics reporting, ensuring continuous improvement and staying ahead of industry trends. Additionally, my ability to develop efficient business models and algorithms that foster connections between individuals from different roles further enhances organizational efficiency and understanding. With a strong commitment to driving results and addressing complex business challenges, I strive to deliver measurable value and contribute to the success of the organization.

Overview

9

years of professional experience

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.

Education

Bachelor of Computer Application -

12th - undefined

UP Board

10th - undefined

UP Board

Skills

Python: Proficient in utilizing Python for data analysis, data manipulation, and automation tasks Experienced in using libraries such as Pandas, NumPy, and Matplotlib for data processing, analysis, and visualization

SQL: Strong proficiency in SQL (Structured Query Language) for querying and manipulating databases Skilled in writing complex SQL queries to extract, transform, and analyze data

Advanced Excel: Extensive knowledge of advanced Excel functionalities, including data manipulation, complex formulas, pivot tables, conditional formatting, and macros Proficient in utilizing Excel for data analysis, reporting, and visualization

Google Sheets: Expertise in working with Google Sheets, including data entry, manipulation, and analysis Skilled in utilizing formulas, functions, and data validation in Google Sheets for efficient data management

Google Data Studio: Proficient in creating interactive and visually appealing dashboards and reports using Google Data Studio Skilled in connecting and visualizing data from various sources to provide meaningful insights to stakeholders

Google Data Studio: Proficient in creating interactive and visually appealing dashboards and reports

Google Script: Experienced in utilizing Google Script to automate tasks and enhance the functionality of Google Sheets and other Google Workspace applications Proficient in creating custom functions, triggers, and add-ons using JavaScript within the Google Script environment

Timeline

Data Analyst - ByteDance Ind. Pvt. Ltd

07.2019 - Current

Data Analyst - Medlife international Pvt. Ltd

10.2018 - 07.2019

Executive - MIS, Pepperfry

07.2015 - 10.2018

Executive - Vulcan Express

09.2014 - 07.2015

- Bachelor of Computer Application,

UP Board - 12th,

UP Board - 10th,