Gaurav Bhat Email & Phone Number

Pune, Maharashtra, India

• Develop and maintain HR dashboards using SAP Analytics, Power BI and Qualtrics
• Create ad-hoc reports by understanding stakeholder’s requirement, developing SOPs, and communicate the requirement with Manager
• Automate recurring reports, and annual KPI’s file with Power Query, Power Pivot
• Launched Dashboards for Onboarding, PDP Completion, Employee Field Changes, Action Planning Overview, Compa Ratio Gender Analysis, PPM Analysis, Absenteeism, D&I, Position Creation, Referral and Recruitment.
• Utilize SQL functions like JOIN, GROUP BY, ORDER BY, HAVING, WHERE, WINDOW, PARTITION BY, and AGGREGATION for complex data analysis.

Pune, Maharashtra, India

• Data Collation – Complete weekly headcount data of active and inactive employees by taking inputs from Talent Acquisition Team and update in People Strong and BDO.
• Data Preparation & Management – Create master data source by comparing system reports, cleaning, and managing the aggregated data - Power BI – DAX, Power Query.
• Data Submissions – Forecast and headcount numbers, Meet the stakeholders' deadlines and monthly data obligations
• Additional Projects & Reports – Monthly Attrition, H1 & H2 Attrition Analysis, Critical Positions review, Promotion Reviews.
• Discuss with HRIS System Vendor twice a week and implement the requirements in HRIS tool for HR Life Cycle Modules.
• Utilize SQL functions like JOIN, GROUP BY, ORDER BY, HAVING, WHERE, WINDOW, PARTITION BY, and AGGREGATION for complex data analysis.

Pune, Maharashtra, India

• Running daily HCM and ADP report – An automated report which is taking the Data from HCM and updates in ADP portals like Separation, Rehire, New Hire, and Promotions.
• Uploading eTime-Novitex file about a punch in and punch out of all the employees of Exela and after that sending it to the concerned person to rectify and process their payments.
• Downloading the data for SOX-Compliance and taking the manager approvals for all the pending employees for a particular pay period.

Pune, Maharashtra, India

• Weekly Reports – PPAP, SCAR, MNC, SR Reports update in MS Excel using Queries & Connections.
• Monthly Reports – PPM Scorecard, MNC & Disruption Report, Global KPI’s, Staff Meeting PPT’s and Graphs update and send it to the respective stakeholders.
• Projects – Power BI Dashboard created for all the Weekly and Monthly Reports.
• Tools and Applications – Power BI - DAX, Microsoft Access, Advanced Excel.

Pune Area, India

• Data Collation – Collate monthly head count data of active and inactive employees from all the line HR’s with the help of MS access.
• Data Preparation & Management – Clean and maintain the collated data, prepare master data source with comparing One Source reports.
• Data Submissions – Forecast and AOP head count numbers of all the Business Units Full fill the monthly data requirements and timelines of Stake Holders
• Additional Projects & Reports – Monthly Attrition, H1 & H2 Attrition Analysis, Critical Positions approval process, Seating Arrangement, Campus Hire Growth Analysis, Succession Planning, Promotion Reviews, Time in.

Pune Area, India

• Daily Reports – Daily survey and installed sites data collation and updating in proper Excel format and present the plan vs actual progress of eNB+MW sites.
• Data Collation, Preparation & Submissions – Daily eNB+MW Actual MDB with all details, maintain the attendance of all the employees, prepared reports and presentations for CTO meetings
• Audit & Reconciliation – Reconciled the data of Excel entries with system entries – avg. 90% of the data recorded in systems and audited.

Pgd Certification In Data Science, Business Analyst, 3.4/5

Master Of Business Administration - Mba, Human Resource & International Business

Bachelor Of Commerce - Bcom