RAKESH KUMAR
Ghaziabad
Summary
To give my best in my profession pursuit for overall benefit and growth of the company. I will show my capability and gain experience and contribute to organization growth of the company.
Overview
11
11
years of professional experience
Work History
Data Analyst
Bill Gosling India Pvt. LTD.
02.2022 - Current
- Data management and analysis for dashboard creation.
- I have shared the Excel-based Weekly, Monthly, and Quarterly dashboards with the operations team and multiple functions, as well as the analysis dashboard, to help make business decisions and grow the business.
- I prepare new dashboard creation and development dashboards through Excel functions and VBA macros.
- My job is to prepare dashboards in accordance with the operational requirements and current running dashboard modifications, as well as the new dashboard requirements based on Excel and Power BI desktop applications.
- In my role, I receive raw data in an unstructured format from all operational teams and transform it into a structured format using Power Query, with data cleaning, data manipulation, data validation, data formatting, and data analysis using Power Query.
- My role is creating a new dashboard using Power BI Desktop and Excel-based applications through analysis of DAX (Data Analysis Expressions), Power Query, relationships (Data Modeling View), and using visualization to create a visual view.
MIS Executive
Indus Tower LTD
10.2021 - 11.2021
- Company Overview: On Payroll of Ouess Corp Ltd.
- Data Management and Analysis.
- I have shared the Excel-based Weekly, Monthly, and Quarterly dashboards with the field team and reporting manager, as well as the analysis dashboard, to help make business decisions and grow the business.
- Preparation of Corporate Review Presentations.
- Prepared KPI based on monthly data as per work done by the vendor, and shared the KPI with the vendor for signup.
- Flashing the performance management scorecard on a monthly basis based on operational KPIs.
- Coordinating for information from zones, HO, and circle functional heads to track plan vs. actual trends.
- Publishing and maintaining dashboards to monitor the progress of various projects.
- Using ERP Oracle to generate a Purchase Requisition (PR) and punching the BOQ.
- Preparing monthly provisions based on actual work done.
- Regular customer meetings and discussions about issues, if any, while maintaining a high level of customer relationships.
- Invoice verification and monitoring of pending invoices.
MIS Executive
Bharti Infratel LTD
07.2015 - 09.2021
- Company Overview: On Payroll of Olympus Personnel Allied Services Pvt.
- Data Management and Analysis.
- I have shared the Excel-based Weekly, Monthly, and Quarterly dashboards with the field team and reporting manager, as well as the analysis dashboard, to help make business decisions and grow the business.
- Preparation of Corporate Review Presentations.
- Prepared KPI based on monthly data as per work done by the vendor, and shared the KPI with the vendor for signup.
- Flashing the performance management scorecard on a monthly basis based on operational KPIs.
- Coordinating for information from zones, HO, and circle functional heads to track plan vs. actual trends.
- Publishing and maintaining dashboards to monitor the progress of various projects.
- Using ERP Oracle to generate a Purchase Requisition (PR) and punching the BOQ.
- Preparing monthly provisions based on actual work done
- Regular customer meetings and discussions about issues, if any, while maintaining a high level of customer relationships.
- Invoice verification and monitoring of pending invoices.
MIS Executive
CMC LTD
12.2013 - 06.2015
- Company Overview: on the payroll of T&M Service Consulting Pvt Ltd.
- Data Management and Analysis.
- The dashboard team-wise performance has been shared with the manager.
- Preparing the daily basis report for the cancellation policy, the new policy, and sharing it with the field team.
- Using advanced Excel tools like VLOOKUP, PivotTable, SUMIF, COUNTIFS, and logical functions.
Education
High School -
U.P. Board
U.P.Intermediate -
U.P. Board
U.P.B.A -
Dr. Bhim Rao Ambedkar University
Agra, U.P.Skills
- Advanced Excel Functions
- Dashboards
- Power Query
- Power Pivot (Measure)
- Pivot Table
- Power BI Desktop
- Dax (Data Analysis Expression)
- Data Modeling
- Visualization
- Basic SQL Server
- Data Analysis
- Excel VBA
- Data Cleaning
- Data Manipulation
- Data Validation
- Data Formatting
- Oracle ERP
- Outlook Mail
Accomplishments
- Received well done award consecutively for 2 years (2021, 2023, and 2024) from Bill Gosling India Pvt. Ltd.
- Received well done award consecutively for 4 years (2017, 2018, 2019, 2020 and 2021) from Bharti Infratel and Indus Towers LTD.
Personal Information
- Father's Name: Mr. Harishchandra Saraswat
- Date of Birth: 08/10/91
- Nationality: Indian
- Marital Status: Married
- Religion: Hindu
Languages
- Hindi
- English
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge and belief.
Timeline
Data Analyst
Bill Gosling India Pvt. LTD.
02.2022 - Current
MIS Executive
Indus Tower LTD
10.2021 - 11.2021
MIS Executive
Bharti Infratel LTD
07.2015 - 09.2021
MIS Executive
CMC LTD
12.2013 - 06.2015
High School -
U.P. Board
Intermediate -
U.P. Board
B.A -
Dr. Bhim Rao Ambedkar University
Similar Profiles
Raghuveer SinghRaghuveer Singh
QA Consultant at Bill Gosling India Private Limited.QA Consultant at Bill Gosling India Private Limited.
Mohit ChawlaMohit Chawla
Senior Manager Finance at Bill Gosling India Private LimitedSenior Manager Finance at Bill Gosling India Private Limited
Carlisha HinesCarlisha Hines
Collections Agent at Bill Gosling OutsourcingCollections Agent at Bill Gosling Outsourcing