Vipin Tyagi
Delhi
Summary
A dedicated professional with 7+ years of experience as a Data Analyst. Proficient in analyzing data from multiple data streams, including Access, Power BI, and Advance Excel with a proven history in supporting the senior management to prepare automated dashboards for their monthly and quarterly reviews.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Junior Manager
Paytm
11.2024 - Current
- Led the preparation of monthly Headcount and Attrition reports, ensuring timely and accurate data delivery for key decision-making.
- Collaborated with regional management to automate CHRO and VP dashboards using Power BI, enhancing reporting efficiency and data accessibility.
- Designed and maintained Full & Final and Payroll Dashboards using Power BI and advanced Excel, enhancing reporting efficiency and data visualization.
- Analyzed and consolidated employee data for 48,000+ employees across PAN India, delivering actionable insights to regional stakeholders for business reviews and strategic decision-making
- Assisted the Talent Acquisition team in developing monthly recruitment dashboards in Power BI, optimizing recruitment analytics and performance tracking.
- Supported the Payroll team in the creation of monthly Payroll dashboards and data analysis, ensuring accuracy and timely payroll reporting.
Sr. Executive
InsuranceDekho
09.2023 - 11.2024
- Responsible for the preparation of monthly Headcount Reports
- Played a vital role in assisting the regional management to automate the CHRO dashboards using Power BI
- Responsible for preparing attrition of 23 Functions to prepare dashboards and derive business insight by using Advanced Excel and Power BI
- Collate and analyze PAN India employee data and share it with regional stakeholders for further business reviews
- Prepare the HR related data for review for the investor like (historical Headcount data, Attrition related)
- Support the talent acquisition team to prepare monthly recruitment dashboards in Power BI
- Provided Advanced Excel training to employees across 23 departments, enhancing their proficiency in complex data analysis and spreadsheet management
Payroll Executive (Data Analyst)
INTERTEK INDIA PVT. LTD
12.2021 - 09.2023
- Responsible for the preparation of monthly Headcount Reports of countries entire India, Bangladesh, and Sri Lanka
- Played a vital role in assisting the regional management to automate the South Asia dashboards using Power BI
- Working closely with the Head of C&B for analysis of payroll, attrition, and overtime data of 11 business lines to prepare dashboards and derive business insight by using Advanced Excel and Power BI
- Collate and analyze PAN India employee data and share it with regional stakeholders for further business reviews
- Support the talent acquisition team to prepare monthly recruitment dashboards in Power BI
Data Analyst
AIRTEL
04.2017 - 11.2021
- Prepared monthly reports using tables, pivot reports and charts to directly support the key decision-making stakeholders
- Responsible for preparation of YTD dashboards
- Prepared dashboards using Power BI & Excel to further share with senior management
- Forecast monthly targets for sales and services and map it against the actual achieved figures using Advanced Excel
- Coordinated with regional stakeholders to collect daily area wise service data which was further analyzed and shared with the senior managers
Education
B.com -
University of Delhi
Skills
- Advance Excel
- Microsoft Power BI
- Microsoft PowerPoint
- Macros
- Microsoft Outlook
- Data Validation
- Data Visualization
- Data Analysis
- Google Sheet
Certification
Data Science, XL Academy, 01/01/21, 12/31/21, Advanced Excel, SQL Server, Tableau, Power BI
Timeline
Junior Manager
Paytm
11.2024 - Current
Sr. Executive
InsuranceDekho
09.2023 - 11.2024
Payroll Executive (Data Analyst)
INTERTEK INDIA PVT. LTD
12.2021 - 09.2023
Data Analyst
AIRTEL
04.2017 - 11.2021
B.com -
University of Delhi
Similar Profiles
Pankaj KediaPankaj Kedia
General Manager, Internal Audit at PaytmGeneral Manager, Internal Audit at Paytm
DIPAK UTTAM MATSAGARDIPAK UTTAM MATSAGAR
Sales Manager Team Leading at PaytmSales Manager Team Leading at Paytm
Sanjna PriyadarshniSanjna Priyadarshni
Deputy Manager - Brand Marketing at PaytmDeputy Manager - Brand Marketing at Paytm