Ram Rawat

HR Associate

Delhi, India14 yrs 6 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 5 years of experience in MIS reporting.
Expert in data analysis and dashboard automation.
Strong coordination skills across departments.

Stackforce AI infers this person is a Data Analyst with expertise in HR Tech and Reporting.

Contact

ram.rawat@makemytrip.com LinkedIn

Skills

Core Skills

Reporting & AnalysisData Analysis

Other Skills

AccessAdvance ExcelDashboard PublishingData CoordinationData ExtractionDatabase ManagementEmail MarketingPayroll ReportingPerformance AnalysisReport PreparationReportingSQL

About

I have 5+ years experience in MIS reporting. I'm good in creating MIS reports, Dashboards automation, thinking best solution to business in reporting and analytics domain, coordinating within the team & with other department for the data and report related queries. I'm expert in MS EXCEL, MS ACCESS, Basic Queries with SQL Server & other internal tools.

Experience

Makemytrip.com

Senior HR Analyst

Oct 2015 – Present · 10 yrs 5 mos · Gurugram, Haryana, India

Database Management of Candidates status for Talent Acquisition Team for all the Business Units.
 Create Daily/Weekly/Monthly/Yearly reports for the manning status & performance.
 Publish Quality of hire and G&O Dashboard as a monthly & quarterly report.
 Hiring cost analysis, source mix, Offer-Join ratio, TAT, Offer abort percentage.
 Dashboard publishing for gender diversity & critical roles along with regular hiring updates.
 Co-ordination with HR operation team for ER amount, new joining, notice buyout cases.
 Consultant database management & invoice processing.
 Coordinated interview drives.
 Responsible for TA HR Provision for finance team.

Database ManagementReportingDashboard PublishingData AnalysisReporting & Analysis

Metlife

Sr.Associate Planning & Reporting(MIS)

Dec 2012 – Oct 2015 · 2 yrs 10 mos · Noida, Uttar Pradesh, India

Locking payroll report on daily basis in Employee Database for various stateside locations.
 Preparing the payroll reports, employee termination, overtime data on weekly and monthly basis.
 Coordination with the Supervisor/Managers to share the attendance payroll and dashboard data.
 Update daily payroll activities of state site employees like STD, RTW, LOA, OT, PTO, PER in Utilities.
 Create Daily/Weekly/Monthly/Yearly reports of auditing, quality status & performance
 Collect the team member’s data and create the production report, accuracy report, TAT, audit report on daily and monthly basis.

Payroll ReportingData CoordinationReport PreparationReporting & AnalysisData Analysis

Dealsandyou.com

MIS Executive

Oct 2011 – Dec 2012 · 1 yr 2 mos · Gurugram, Haryana, India

Extract the customer data from SQL, upload in utility and create segmentation.
 Deploy Daily E-Newsletter, promotional mails to city wise mailer and also sent the SMS to the same on daily basis.
 Coordination with Marketing team for reports and Open and Click rates reports.
 Creation and maintenance of reports on daily basis of EDM mailer’s data %
 Create daily/weekly/monthly reports and tracking mailer’s performance for the CRM team.
 Analysis of Open rate, click rate, open to click rate% on daily, weekly & monthly basis.

Data ExtractionEmail MarketingPerformance AnalysisData AnalysisReporting & Analysis