Looking for a job

Rajat Kumar

@rajatkumar10

Senior Business Analyst at Genpact building Power BI dashboards and SQL/Python pipelines that cut recurring reporting effort by 60%.

India

Message

At Genpact, I build Power BI dashboards and SQL and Python pipelines for revenue, SLA, and operational KPI reporting. I cut manual effort on recurring reports by 60% by moving Excel reporting to Python with scheduled SQL, and use Copilot, Claude, and ChatGPT with structured prompts to improve analyst productivity by 35%.

Previously, at Pramerica Life Insurance, I reduced report generation time by 50% with Python tools for finance and actuarial teams. At OYO Hotels & Homes, I automated reporting for 1,000+ hotels, saving more than 100 hours of manual work each week.

Experience

Work history, roles, and key accomplishments

Current

Senior Business Analyst

Current

Genpact India Pvt. Ltd.

Feb 2023 - Present (3 years 8 months)

Leading BI and analytics for a large US client, building Power BI dashboards and ETL pipelines, and automating reporting workflows. Achieved 60% reduction in manual effort and 35% productivity gain through AI tools.

Power BI SQL Python ETL Data Analysis Automation Generative AI Stakeholder Management Selenium GitHub

Senior Finance MIS – Analytics

Pramerica Life Insurance

Apr 2022 - Jan 2023 (9 months)

Automated dashboards for claims, underwriting, and premium collection, reducing report generation time by 50%. Performed trend analysis and variance reporting using SQL, Python, and Excel.

SQL Python Excel Power BI Data Analysis Automation Financial Modeling

Data Executive – Analytics & Reporting

OYO Hotels & Homes

Jul 2019 - Apr 2022 (2 years 9 months)

Produced automated reports for 1,000+ hotels and saved 100+ hours of manual work weekly using Python and Google APIs. Analyzed pricing and competitor data to support revenue management.

Python SQL Excel Google Sheets API Data Analysis Automation Reporting

Finance Executive – Finance

Rentickle.com

Mar 2018 - Jul 2019 (1 year 4 months)

Prepared daily stock and sales reports, performed bank reconciliations and variance analysis, and reduced manual effort by 35% with Excel dashboards.

Excel Financial Analysis Data Analysis Reporting Reconciliations

Education

Degrees, certifications, and relevant coursework

Chaudhary Charan Singh University

Master of Commerce, Commerce

2017 - 2019

Master of Commerce with coursework in Computer Application in Business, Financial Management, Security Analysis & Portfolio Management, and Project Planning & Control.

Chaudhary Charan Singh University

Bachelor of Commerce, Commerce

2014 - 2017

Bachelor of Commerce with coursework in Information Technology & Its Implementation in Business, Corporate Accounting, Auditing, and Financial Management.