Rani Routhu

About Rani Routhu

I am a detail-oriented and data-driven professional with over 2 years of experience as a Data Analyst, passionate about transforming raw data into actionable insights that drive business success. At Genpact I specialized in operational data analysis. My work involved cleaning and preparing data from internal portals, and creating reports in Excel and Google Sheets to monitor shrinkage, late logins, productive hours, and agent performance. I developed employee rating reports based on KPIs like AHT, FCR, CSAT, Quality Score, and more. I also designed dashboards to visualize data and shared insights to help managers make informed decisions to improve team performance. At V Dream Technology and Communication I was responsible for collecting, cleaning, and analyzing sales data. I created and maintained comprehensive performance reports (daily, weekly, monthly, yearly), conducted regional sales trend analysis, and collaborated closely with team leads to support strategic decision-making. I also leveraged historical product data for launch planning and conducted monthly budgeting based on sales and expenditure trends. I thrive on diving deep into data to uncover patterns, solve problems, and optimize performance. With strong skills in Excel, Google Sheets, and data visualization tools, I aim to contribute to organizational growth through efficient, insight-driven reporting and analysis.

Experience

1. Process Associate

   Genpact

   May 2024 — Present · Hyderabad, IN

   Managed workforce analytics for India region of Google Client, focusing on headcount data and client billing to develop monthly business proposals through long-term forecasting.• Prepared and analysed Employee Evaluation Sheets (AES) based on performance metrics such as late logins, shrinkage, quality, adherence, productivity, average handle time, and customer satisfaction.• Assigned monthly performance ratings to employees based on comprehensive metrics evaluations and monitored employee login times in accordance with shift schedules.• Calculated daily shrinkage by accounting for planned and unplanned leaves against total rostered headcount.• Assessed employee productivity by evaluating signed-in hours, excluding unproductive hours such as breaks and unauthorized auxiliary times.• Generated and shared daily performance reports with team leads and managers and provided weekly reports to clients for business overview and target setting.• Conducted comprehensive monthly performance reviews to determine employee ratings based on various metrics including quality and customer satisfaction.• Created detailed daily performance reports for internal review and shared weekly reports with clients to provide a business overview and facilitate target setting for the upcoming month.

Education

• Kasturba Gandhi Degree & PG College for Women

  Master of Business Administration - MBA, Finance, General

• Kasturba Gandhi Degree & PG College for Women

  Bachelor of Commerce - BCom

  2017 — 2020