Siddharth Suresh Kotian
Ram Mandir, Mumbai
Overview
12
12
years of professional experience
Work History
Viacom18
11.2023 - Current
- HR Dashboard & Data Maintenance: Created an end-to-end HR Dashboard on Powebi, integrated with multiple HR Systems which included key areas and aspects such as Manpower & Demographics (SAP), Employee Attrition (SAP), Learning & LD (LinkedIn and Coursera), Employee Productivity, HR Operations & Processes (SAP), and Employee Engagement (Leena), PMS(Darwin Box )along with regular data audits
- Talent Acquisition Analytics: Setting up an API based PowerBi dashboard connected real time with the Lever system. Implement a ‘Selection Model’ based on multiple candidate data points to generate correct and quick hire candidates from across all applications for multiple job postings, this helped reduce closure timelines by 20%. Created a Hiring Manager dashboard to operationally help Managers as well as recruiters to close around 1000 positions in a year. Created multiple descriptive views like Pass through rates, TAT based on percentiles & average, active candidate pipelines, recruiter feedback analytics.
- Talent Acquisition Systems Development: Worked towards implementation and development of the Lever recruitment system in Viacom18. Integrating the system across multiple platforms like Leena, SAP, Chatbot, etc
- Candidate Survey: Setting up of candidate experience survey which was sent to all candidates who have given an interview for Viacom18. Post the implementation of the survey, candidate NPS score increased by 65%. Created a PowerBi dashboard for the same based on Net Promoter Score, Average Satisfaction Scores and Subjective/textual analytics (using R) based on themes
Manager(Jul22-Oct23) ; Asst Manager(Mar20-Jun22)
Otis (India)
03.2020 - 10.2023
- HR Analytics: Creating and managing an overall HR Dashboard in Power BI and Ms Excel which includes key areas and aspects such as Manpower & Demographics, Employee Attrition, Recruitment, Learning & LD, Employee Productivity, HR Operations & Processes, Payroll, and Employee Engagement. Analyzing real time & historical data to provide insights on what and why a certain thing happened. Few areas analyzed on these aspects were Leave & Attendance, Payroll, Employee Mediclaim & Insurance, Attrition, Spans and Layers, L&D.
- Managing Collective Bargaining Agreements for Unions: Contract negotiations with union representatives along with ensuring compliance with contract terms and resolving disputes while addressing employee concerns. Conducting research and analysis of industry trends, labor laws, and case precedents.Train managers and supervisors on CBA terms, workplace policies, and effective communication strategies with unionized employees
- Payroll – Part of the team that manages end to end payroll, the role specifically includes Time Ticket calculations, Sales Incentive processing, Allowance management, Union Salary Increment in accordance with the agreement, Payroll Draft checking with observations and management of Payroll Schedules
- Policy Implementations: Develop and implement company policies aligned with corporate values, legal standards, and industry best practices. Collaborate across teams to address gaps, ensure compliance, and tailor policies to organizational goals. Communicate updates through documentation and training, monitoring effectiveness for continuous improvement
- HR Technology Configuration & Automation: Designing and recommending changes for multiple modules in Workday and Local HRIS which includes ESS and MSS, WD Learning, Leave and Attendance, Payroll System and Engagement Survey System, also working closely with the technology partners. Leveraging Office 365 as a tool to create workflow systems for HR processes
- Managing Benefits Program: To oversee the development and administration of benefits programs, including health insurance, retirement plans, wellness initiatives, and leave policies. Negotiate with vendors to secure cost-effective-quality packages
Senior Executive
Viacom18
06.2017 - 03.2020
- HR Dashboard & Data Maintenance: Created an end-to-end HR Dashboard which included key areas and aspects such as Manpower & Demographics, Employee Attrition, Recruitment, Learning & LD, Employee Productivity, HR Operations & Processes, and Employee Engagement, along with regular data audits
- Descriptive Analytics: Analyzing real time & historical data to provide insights on future decisions through infographics, few areas analyzed on this aspect were Leave & Attendance, Employee Mediclaim & Insurance, Performance Reports, Exit Interviews (Subjective), etc
- HR Systems Modification & Development: Continuous development of the existing HR systems (Success Factors) through the organization Restructure, ongoing data movement of historical data into the system for better data control and usage, managing rights and roles in SF across the entire organization
- Process Developments: Liaising with the BUHRs & Process Owners to provide relevant data and technical know-how (macros) for process improvements
- Team Management: Managing a team of 2 members with strong Operations Background
Sales Analyst Business Analytics
DHL Express
12.2016 - 06.2017
- Sales Budgeting: Responsible for creating budgets that will allocate the Company’s AOP to the targeted Channel Managers from the bottoms up methodology by conducting an in-depth analysis of various micro and macro environment systems and plotting significant discrepancies between actual and budgeted targets
- Commercial Dashboard: Delivery of monthly commercial reports to the Marketing and Sales Head (Revenue Deck, Shipment & Weight Dashboards, Franchise Dashboards, Product Dashboards & etc.)
- System Automation: Implementation of various system automations combining SQL Servers, MS Access, and Excel VBA, as per business requirements
Intern
Municipal Corporation of Greater Mumbai
05.2016 - 06.2016
- Project Title: Data Analytics for Key MCGM Initiatives
- Objectives: To understand the perception of citizens and their readiness to implement Zero Garbage initiative of MCGM
- To study the pedestrian movement trends in H-West Ward with respect to the usage of Skywalk
- The Brihanmumbai Municipal Corporation (BMC) also known as the Municipal Corporation of Greater Mumbai is the civic body that governs the capital city of Mumbai in Maharashtra and is India's richest municipal organization
Junior Associate (2013-15) ; EAP(2012-13)
Edelweiss Financial Services Limited
06.2012 - 06.2015
- HR Dashboard: Deliver a Standard Suite of Reports monthly to HR/Business Heads and HRD (HC, Attrition Analysis, HR Performance Dashboards, L&D Dashboards, Recruitment Dashboard, Sales Productivity Dashboards,360 Degree Reports, Performance Appraisal Reports & et al)
- HRMS System Configuration & Development: Designing and Development of the HRMS Reports module which includes a total of 60 Reports & Dashboards
- HR Operations Process Development: Timely Development of Processes in HR Operations with a View of Increasing the Team Productivity
- (Processes Included Employee On-boarding, Employee Background Vetting, Employee Full & Final)
- Ad hoc Reporting: Address ad-hoc queries/reporting requests related to HR from HR/Business Head
- HR Surveys – Creating surveys regarding to employee satisfaction organization wide
Education
M.A. - Economics
Mumbai University (Part 1)
06.2023
M.Com -
Mumbai University
06.2018
PGDM (HR) (Full Time) -
Indian Education Society MCRC
12.2016
T.Y.B.M.S -
Mumbai University
04.2012
H.S.C -
Maharashtra Board
02.2009
S.S.C -
Maharashtra Board
03.2007
Skills
- Success Factors
- Workday
- Lever
- Advanced MS Excel
- Macros
- Access
- Power BI
- Basics of R
- Office 365 Suite
- Power Automate
- Basics of Power Apps
Accomplishments
Otis India
- A total automation of the Medical Insurance Process was undertaken along with a mobile platform, all inclusive of one touch approvals/send backs with robust data and document architecture, received a recognition award for the same.
- Launched HR Dashboard for direct regions in Power BI which included data analytics of various verticals in HR
- Created an end-to-end motor usage policy for the organization with an online platform.
- Part of the team which launched the Compensation and Benefits Module on Workday and managed 3 back-to-back merit cycles from 2020 to 2023, received a recognition award for the same.
- Automation of the incentive calculation process which reduced the earlier man-hour of 8hours to 30 minutes.
- Part of the team that undertook the process of regional grade restructuring by providing descriptive analysis of Spans and Layers for different regions.
- Worked on creating 2 models to predict the cost as well as the structure impact the New Labor Laws would have on Otis India
- Part of the team which launched and managed the Voluntary Separation Program
- Received a recognition award for fully automating the offer letter creation process, which is currently embedded with 6 structural combinations.
- Conducted various training session on Ms Excel, O365 & Power BI which was well received throughout the organization.
Viacom18
- Received an award for Implementing the Technology platform for Talent team, with a full- scale BI integration for Data analytics.
- Setting up of Hiring Framework(Selection Model) to reduce overall turn around time with quality sustainable hires.
- Managed to create an in-house HRMS system for interns using MS Access prior to the Success Factors movement.
- Launching 3 modules in Success Factors within a short span of time to make the entire HRMS eco system complete in the organization, also had received a team award for the same.
- Received a recognition award for having created an entire database of employees having worked in Viacom18 since inception, the data was collected from disparate sources, this database was then used for several purposes across the company.
Awards
- Received 4 awards in Otis India across the tenure for multiple projects.
- Received 3 awards in Viacom18 across the tenure for multiple projects.
- Felicitated by the Assistant Commissioner of MCGM for securing the award for the Best Summer Project (MBA)
Hobbies and Interests
- I am a passionate footballer and have played district level football for my school.
- I am a cycling enthusiast and mostly travel places with my cycle.
- I have a special interest in reading books on financial management and economics.
Timeline
Viacom18
11.2023 - Current
Manager(Jul22-Oct23) ; Asst Manager(Mar20-Jun22)
Otis (India)
03.2020 - 10.2023
Senior Executive
Viacom18
06.2017 - 03.2020
Sales Analyst Business Analytics
DHL Express
12.2016 - 06.2017
Intern
Municipal Corporation of Greater Mumbai
05.2016 - 06.2016
Junior Associate (2013-15) ; EAP(2012-13)
Edelweiss Financial Services Limited
06.2012 - 06.2015
M.A. - Economics
Mumbai University (Part 1)
M.Com -
Mumbai University
PGDM (HR) (Full Time) -
Indian Education Society MCRC
T.Y.B.M.S -
Mumbai University
H.S.C -
Maharashtra Board
S.S.C -
Maharashtra Board
Similar Profiles
Neelima AppannaNeelima Appanna
Senior Manager at Viacom18Senior Manager at Viacom18
ADITYA BHONSLEADITYA BHONSLE
Assistant Manager at Viacom18Assistant Manager at Viacom18
Mrinalini MishraMrinalini Mishra
Supervising Producer at Viacom18Supervising Producer at Viacom18
Bhoomi KumbhaniBhoomi Kumbhani
Clinical Physiotherapist at Umiya Physiotherapy ClinicClinical Physiotherapist at Umiya Physiotherapy Clinic
Diksha SinghDiksha Singh
Key Account (Project Management Office) at Brandola Marketing Solutions Pvt. Ltd.Key Account (Project Management Office) at Brandola Marketing Solutions Pvt. Ltd.