I have also developed and implemented several HRIS systems and prototyped the same using
Excel VBA and Macros.
Some of my projects include:
1. Development and Implementation of WhatsApp ChatBot for Initial Screening.
2. Development and Implementation of HRIS System.
3. Development, Implementation, and Adoption of Employee Self-Service Portals.
4. Sentiment Analysis to get an insight into the overall sentiment of the organization.
Also, I have been appointed as Guest Lecturer with
ISTD (Indian Society for Training and Development), which was established in 1970.
Some of my achievements include the MAVEN certificate from NASA for successfully sending my name to Mars in the MAVEN spacecraft.
As a fitness enthusiast, I have been playing several sports like
Boxing and
Tae Kwan Do.
Work Experience
Sr. People Analyst - Price Waterhouse Coopers (PwC) - Oct 2021 to Till Date
Handled Analytics Team for providing insights to clients.
Working on People Analytics Solutions to guide the organization for seamless HR Automation.
Guiding with Analytical Insights to the Stakeholders
Cleaning and Warehousing of Data
Web Scraping using Google Apps Script
Automation of Reports and Emails using Google Apps Script
Development and Maintenance of Analytical Dashboards
Text Analysis using tools like R, Python, Power BI, Tableau, and Alteryx
Prototyping and Adoption Strategies
User Persona and User Journey Maping
Streamlining HR Processes
Strategic SOP Deployment
Video Transcription using Python
Data Extraction using Data Studio, Big Query, and Tableau Analytics for Dashboard Development
Sr. HR Data Analyst - t Cosmoline® - May 2020 to Oct 2021
Created and Implemented an HRIS System for the organization
Handling IT Recruitment for the HO
Recruitment and Onboarding of Candidates
Sourcing of Candidates on Job Portals like Naukri, Indeed Jobs, IIM Jobs, etc
MIS Report Generation for Stakeholders
Responsible for updating HR Systems and Automation the same
Responsible for Handling Payroll and Attendance of Employees
An Active Member of the Employee Engagement Team
Responsible for maintenance of HR Database
Developed Employee Self-Service Dashboard
Coordinated Yoga Sessions & Doctor's Sessions as part of Employee Engagement Activities
Developed and Implemented an Attendance Tracker in the employee dashboard
Developed and Maintained HR & KC (Knowledge Center) Website for employee-ready access
Implemented Automated WhatsApp recruiter & automated initial screening of potential candidates by getting their video interviews
Trained employees when required for technology-related topics, such as Advanced Excel, web page creation, etc
Created Exit Analysis Reports using Advanced Excel and Visual Basics
Management Trainee (HR Analytics) - Karvy - March 2019 to May 2020
End-to-End Recruitment Process for Head Office and Branches
Responsible for Predicting the Attrition Rate based on the Sentiment of Departments
Responsible for handling joining formalities
An active member of the Employee Engagement Team
Assisted in the implementation of a new Cloud Based ERP System in the organization
Responsible for Full and Final Settlements
Implemented WhatsApp-based HR help desk
Webpage scraping for Job Review websites using R for Sentiment Analysis
Worked on Digital Marketing Reports
Helped in interconnecting Work Management System and MIS
Provided insights to Management with Employee Surveys
Provided and Coordinated Training and Counselling sessions for employees Technical Expertise, Soft Skills, and Client Handling.
Management Trainee - Aamby Valley City (Sahara India Project) - June 2015 to June 2017
Gained experience in all the major departments in Hotel
Coordinated BMW Event
Forecasted Sales Revenue
Analyzed Data with regards to Sales and Marketing
Internships
Trainee (HR Analytics) - The Impals Marcom - May 2018 to July 2018
Created Excel Format for daily reports and helped in managing the same in cloud network
Handled two clients: View My Records (VMR) and Ecliptic HR
Worked on Digital Marketing Reports
Helped in interconnecting Work Management System and MIS
Provided insights to management with Employee Surveys
Provided and Coordinated training and counseling sessions for employees concerning Technical Expertise, Soft Skills, and Client Handling
Trainee (Cluster Lead South East Asia) - Global Blockchain Foundation - Nov 2017 to Jan 2018
Assisted startups in implementing Blockchain Technology on the international level
Generated leads worth INR 3,20,000 for the Singapore Blockchain Event
Data Mining, Cleaning, and Analysis
Worked on Sentiment Analysis and Employee Engagement in the organization
Education Qualification
1. PGDM HR Analytics - 2017 to 2019 - Pune Institute of
Business Management
2. BSc. BHM - 2012 to 2015 - Dr. Ambedkar Institute for Hospitality and Catering Technology
Projects & Achievements
1. Got a MAVEN Certificate or sending name for Mars Exploration powered by NASA.
2. Developed
Blogs on HR Analytics.
3. Delivered Lectures about HR and People Analytics, Tools used in HR Analytics, Sentiment Analysis, Web Scraping, Analytics Without Coding, Power BI in Analytics, and other Software Used in Analytics.
5. Associated with ISTD
Skills
R, Python, HTML, PHP, Java Scripts, Power BI, Tableau, WordPress, Doku Wiki, Media Wiki, AJAX, MySQL, Oracle, NoSQL, MS Access, CSS, Advanced Excel, VBA, Macros, Drupal, Elgg, Code Igniter, Darwin Box, Zoho HR, Work Day, SAP, Keka HRIS, Alteryx, Microsoft Power Apps, Pendo, Miro, Google Data Studio/Looker Studio, MS Visio, ODBC, Big Query, Tableau Analytics, Dremio, Postman, Microsoft Share Point, Google Apps Script, One Stream, Law, Legal, Business laws, Labor Laws, Power Automate, Azure DevOps.
Contact Details
Location: Safakadal, Bharat
Email ID: mithlesh.dhar@gmail.com
Phone No: +919130011968
Interests
Traveling, Blogging, Web Development, People Analytics,
Kashmir