SANKET PATOLE

adnm1o@r.postjobfree.com 682-***-**** LinkedIn

HR Data Analytics HR Information Systems Business Intelligence Solutions Relationship Management

Passionate about exploring HR Information Systems and Analytics to create a positive impact on the business and its People – the most valuable of its resources. I strongly believe in the power of People Analytics in influencing strategic business decisions.

PROFILE SUMMARY

5 years multi-industry experience in HR Data Analytics, HR Information Systems, ERP and leveraging data to derive business decisions

Experience in working cross-functional teams for data generation and analysis of workforce management metrics

High energy, action-oriented, analytical, and problem-solving acumen to complement leadership traits

EDUCATION

MS Business Analytics, The University of Texas at Dallas 2018

MBA Human Resources, University of Mumbai 2013

BE Computer Engineering, University of Mumbai 2011

PROFESSIONAL EXPERIENCE

OM

Medical College of Wisconsin – Senior HR Analytics Consultant (full-time position) Oct 2020 – Present

Optimizing analytics and reporting in Power BI Dashboards, Oracle Discoverer and Recruitment Management System.

Collaborating HR Business Intelligence with the IT, Finance, Business Operations, and vendors to drive enterprise-wide analytics.

Deliver data- insights and presentation of findings to the Senior Management supported by logic and technical processes.

Data-partnership with Talent Acquisition, Diversity & Inclusion, Employee Relations, Benefits etc. to ensure effectiveness of plans.

Monitor Cherwell ticketing system for adhoc data requests and perform regular State and Federal data reporting and submissions.

Providing analytical guidance, mentoring, and training to the internal customers facilitating data-driven decisions.

Identifying data source deficiencies at all levels of company data and enhancing data accuracy with effective resolutions.

Alternative Behavior Strategies Inc. - HR Data Analyst (full-time position) Sep 2019 – Oct 2020

Led project for data-migration of 37000 applicants’ information into iCIMS from Google HIRE Applicant Tracking System (ATS).

Analyzing data from iCIMS ATS to monitor candidate progression at hiring stages- Applications, Interviews, Offers and Hires.

Designed an interactive dashboard in Tableau to quantify effectiveness of the Recruitment Marketing initiatives by analyzing inflow of job applicants from various job portals, Cost per Hire, spending on advertisements and the quality of hires.

Identified top sources for the inflow of job applicants among multiple job portals and monitor the ROI of each channel.

Employee Turnover Analysis across different factors like demographics, job type, job locations, hours worked, wages etc.

Survey Monkey Exit Feedback- designed, tested and administered survey to analyze feedback from the terminated employees.

Saved 20% of the company’s Over Time payment spending for the Behavioral Therapists by enhancing scheduling mechanism using measures to map client location to minimize the work-travel time and utilizing virtual classrooms.

Superior Plus Energy Services - HR Data Analyst (project-based role) Jul 2019 – Sep 2019

Optimizing HRIS PayChex to conceptualize, design, and implement advanced reporting and analytics.

Designed an intuitive Workforce Leave dashboard showing number of employees on leave types- PTO, LOA, FMLA, Jury Duty etc.

Project Management to implement SmarterU- Learning Management System in alliance with the vendor and tech-team in Canada.

Mapped data tables using file exports to update latest changes and additions in data fields like business units, cost centers and develop linkage with the employee records.

Created Tableau based HR dashboards and partnered with data analysts from Finance and Operations team to establish data links.

Automated a comprehensive Census report file feed for the Benefits vendor for weekly enrollment of new joiners, updating terminations and any other changes in employee data.

Six Flags Entertainment Corporation - HR Business Data Analyst (project-based role) Nov 2018 – Apr 2019

Implementation analyst for Core HR module transition from ADP to UltiPro- data conversion, mapping, and role-based security.

Charted the metrics to monitor turnover trends, changes in wages, over-time, revenue, and sales using Tableau dashboards.

Partnered closely with IT for SDLC Agile project management, including requirements, implementation, testing, and maintenance.

Dual Data Maintenance to validate data flow, mapping, and audits to ensure 97% data accuracy in the new ERP.

Led the creation and development of the automation framework for 200 reports and reduced processing time by 70%.

Extensively trained and mentored the internal customers with user-friendly documentation to improve 63% usability of the regional dashboards. Fostered close relationships with the key clients: recognized as a ‘Shining Star’ for exceeding expectations.

Southern Glazer’s Wine & Spirits - People Analytics Data Analyst (full-time project post MS at UT Dallas) Jul 2018 – Oct 2018

Effectively utilized Alteryx to extract, transform, and load (ETL) 6 million rows of high-volume data, aggregated from multiple sources, obtaining a file with consistent data structure for advanced analytics.

Executed the optimization of workflows in Alteryx with logic development and coding, resulting in 30% faster data loads to the Tableau dashboards. Coordinated with the corporate IT team for updated dashboard publication in the sandbox and production.

Performed ad-hoc reporting for quantitative analysis using SAP HCM Spinifex tool and transaction codes and with Oracle BI EE custom reports. Automated the reports output optimizing the scheduling feature to receive the reports through emails.

Built an innovative story-telling visual dashboard introducing the concept of Diversity Quotient for the Diversity & Inclusion team. Established a data-partnership, catering the analytics needs of the Talent Acquisition and Talent Management teams.

Drove the project for creation of a database in MySQL with Alteryx data loads utilizing relational data warehouse design, leading to the optimization of query processing by 35%.

Played a key role in research for ODBC connections and API for connecting ETL Alteryx to Tableau sandbox and production server.

MV Transportation - HR Data Analyst Intern (full-time internship during MS at UT Dallas) Feb 2018 – Jul 2018

Orchestrated and project managed the development of interactive MicroStrategy dashboards, enabling real-time data analysis.

Effectively employed MS Excel pivot tables, data validation, graphical manipulation for quantitative data and trend analysis.

Piloted the design, revamp, and testing of an ETL strategy to populate date from multiple sources, leading to a 35% improvement in reporting performance.

Utilized root-cause analysis to maintain quality assurance of data with queries and audits, resulting in a 75% enhancement in the accuracy of historical data.

Administered in-depth sentiment analysis to investigate callouts and reasons for ‘Email un-subscription’ – recovered 50% loss.

Carried out the forecasting and statistical analysis of employee data- regression, significance testing, and decision trees.

ISS Facility Services - HR and Compensation Analytics Intern (full-time internship during MS at UT Dallas) Jun 2017 – Dec 2017

Senior Associate Corporate Human Capital (full-time position post MBA HR) Jul 2013 – Apr 2015

Operated in a pivotal capacity by performing tableau-based analysis of 14500 responses from the annual Employee Engagement Survey and identified the scope of increasing the employee Net Promoter Score (NPS).

Implemented segmentation and targeted promotional strategies to increased campaign effectiveness and response rate by 20%.

Recognized with ‘Apple Award’ for improving the Net Promoter Score (NPS) to 60% targeted score with root-cause analysis.

Administered advanced MS Excel analysis of the Executive Compensation data from Mercer Benchmarking Database.

Valuated and analyzed click-stream data to study ‘Online Applicant Behavior’ - Acknowledged root-cause for 77%-page drops.

Conducted the extensive evaluation of A/B testing data using significance tests to identify and pinpoint necessary improvements for better user experience.

Contact this candidate