Umesh Chander Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

Optimize business processes and improve Decision making - Working as a member of the centralized team (PRA) at SBI Card and Services since February 2022. Main responsibilities include analyzing KPIs for portfolios using various data sets by collecting, validating, manipulating, cleaning, and analyzing raw tabular data for all the major functions. Additionally, involved in migrating preexisting reports from Excel to Power BI or Tableau for better visualization and user experience also contributing to a project team that utilizes analytics to optimize business processes and improve decision making.

Noida Area, India

Worked at Idemia Pvt Ltd in the Human Resource - Reporting & Analytics . Main responsibilities included preparing dashboards for HR on a global level. This included creating reports on actual joiners and separated employees on a monthly basis, as well as analyzing leaving reasons also automated existing HR reports, such as attrition, headcount, new joiners, and average CTC, and prepared month or year wise comparisons. In addition, were involved in the learning management system (LMS) and created an interactive dashboard with different cuts like average hours, total hours, and month/year wise comparisons on a single platform. It had helped provide insights into the company's HR and LMS functions, and helped drive informed decision-making.

Need to take care of reporting part based on Excel, VBA,Power View ,BI tool .below are synopsis:-• Preparation of HC and attrition report • Employee attendance report on a basis of attendance marked on portal. • Leave summary report – It includes leave variances between leaves taken & leaves applied• Data analysis of Job absconding cases – Future analysis• Attrition report basis on leaving reason and tenure• Database management (Scrabble BI tool)- Entire SBI card functions• Updating and deletion of employee records as and when require• Employee rehire status• Background check verification of employee • Taking care of requests raised by employee, like Leaves, Comp off etc• Creation of new dashboard as required by Leadership team basis on leaves/UL/compensatory off• Creation of new data form & workflows as and require • Weekly change of employee attendance as per the guidelines• Liaoning with different support teams and operations team • Employees working days’ summary for incentive purpose• Ensure, process is being adhered by the stakeholders• Employee incentive plan- Planning and implementation• Employee Invoicing tracker• Roster adherence report • Leave summary report – It includes leave variances• Weekly and monthly dashboards • Preparing Transport schedule report – Transport roster• Query resolution through email or call

Bachelor Of Commerce, Business/Commerce, General

Intermediate, International Business/Trade/Commerce