Gaurav Bhat Email & Phone Number

Pune, Mh, In

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 Grade Change Analysis, Predictive Attrition Data Support.

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