Sudhir Rout

About Sudhir Rout

Always curious to learn new technology and embedded in my daily routine.I believe in hardwork, consistency and dedication to achieve something.

Experience

1. Senior Executive (HR Analytics)

   Crisil

   Aug 2024 — Present · Mumbai, IN

   1- Designed and developed multiple dashboards for Executive Management and senior leadership, providing real-time visibility into key performance indicators (KPIs) and business objectives.2 -Utilized advanced tools such as DAX queries, Power Query, and Row-Level Security (RLS) to ensure secure and relevant data access for respective senior management teams.3- Automate the task by creating Power Automate flow.4- Keep track of every change management and ensure all the project should be complete within SLA.5- Preparing ESG report, CXO report, CXO Dashoboard, MDreport, and share with all CXO leader.6 - Manage end to end HR products Darwinbox(HRMS), Zawayam(ATS), Xoxoday(Rewards & Recognition), Leena AI(Ticketing & Survey)Key Skills: Power BI, Power Automate, API testing, HR AnalyticsProjects: Dasboard:1 - People Management Dashboard, 2 - Attrtion & Diversity Dashboards, 3- Hiring & VOc dasbhord 4 - Hiring Cost Dashobard (Including Cost per hire)5 - Compensation & Benefit Dashoboard ( For Comp team)6- CXO Dashobard (Overview of Hiring, Attrion, Cost, VoC, Diversity, & other details)( Acces shared to,CXO & HR Leader}RLS & Dax function use for all Above dashboard.Automation: 1- Letter AUtomation (Extract documents Using power automate from HRMS and store it in Shared drive)2- Data collate Automation ( Create power Automate flow to copy all the files from various source and consolidate it and prepare the final ouput file)Integration & Implimentation:1 - Sharepoint integration with Helpdesk App -2- HRMS & ATS Integration : AUtomate Onboarding Task.( Reduce 2 peoples work).3- ATS & Third party system integrationReceived 2 YMD award for my performance & countribution in projects.

Education

• Utkal University

  Bachelor of Commerce - BCom, Business Administration and Management, General