r
rohityadav47

Rohit Y

@rohityadav47

Data Analyst

India
English, Hindi
About me
I am Certified Power BI data analyst with 1.5+ years in the field of Data Analytics and Business Intelligence. I am skilled in SQL, Python, Excel, and Power BI-driven analytics, including data cleaning, transformation, and KPI reporting.... Read more

Skills

r
rohityadav47
Rohit Y
Offline • 

Work experience

Capgemini

Analyst

Capgemini • Full-time

Jul 2024 - Present • 2 yrs

Consolidated and cleaned multi-source operational, incident, and financial datasets using SQL (joins, filters, aggregation) and Excel to prepare analytics ready data for reporting. Designed and delivered Power BI dashboards for leadership and operations teams to track incident trends, backlog aging, and budget variances, reducing decision-making time by ~30%. Automated recurring reporting workflows using VBA and Python, eliminating manual steps and saving 15+ hours per week across teams. Partnered with stakeholders to define and standardize operational KPIs (incident volume, backlog aging, budget variance), translating business requirements into scalable Power BI metrics for executive and weekly reviews.