PRANAY KUMAR
I am DATA ANALYST
No Data Found
PRANAY KUMAR
DATA ANALYST
I help businesses make better decisions by turning data into insights. With 2.7 years at Capgemini, I have automated reports, built dashboards, and delivered solutions that save time, improve accuracy, and meet business needs.
Work Experience
Empowering Creativity through
January 2023 - Present
Capgemini
Associate I / Analyst
• Automated 10+ recurring reports using SQL, Python, and Excel, saving ~15 – 20 hours/week and reducing errors by 25%. • Built and maintained dashboards in Tableau and Power BI, enabling teams to track KPIs 40% faster and improve decision-making. • Cleaned and organized large datasets from multiple systems, improving data accuracy by ~20% and reducing processing time by 30%. • Collaborated with product, operations, and tech teams to deliver data-driven solutions for 3 major business functions. • Identified trends and insights from data, recommending optimizations that improved processes and reduced cost by 50%
My Skills
Core competencies that drive my performance.
My Skills
SQL95 %
Power BI92 %
Data Governance92 %
Advanced Excel (Pivot Tables)99 %
Data Analytics93 %
Microsoft Office 36594 %
Microsoft Copilot96 %
Power Query90 %
Data Visualization92 %
ETL Data Pipelines93 %
Python NumPy99 %
Data Cleaning92 %
Matplotlib99 %
Education
Empowering Creativity through
July 2023 - July 2025
PGDM (IT PROJECT MANAGEMENT)
Welingkar Institute of Management
Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
August 2018 – Sept 2021
BCA (Computer Application)
IIMT COLLEGE OF MANAGEMENT
Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
My Projects
Customer Experiences: A Tapestry of Happy Moments
Excel + ChatGPT Data Automation Project
Automated data cleaning and standardization (dates, categories, product codes) using Excel formulas and ChatGPT. Extracted meaningful text from URLs and performed sentiment analysis on open-ended responses. Built logic-driven workflows to classify and enhance data quality, reducing manual effort.
Power BI Project: IPL Analysis (2008 – 2025)
Designed an interactive Power BI dashboard to analyze IPL matches, teams, and players from 2008 – 2025. Visualized key metrics like wins, top scorers, strike rates, and venue-wise performance trends. Applied DAX measures and slicers to enable dynamic filtering by team, season, and player. Helped uncover insights into player consistency, team dominance, and match-winning patterns over the years.
Customer Churn Prediction & Insights Dashboard
Predicted customer churn with ~85% accuracy using ML models on cleaned customer data. Built an interactive dashboard showing churn risk by segment, helping drive retention strategies.
Contact Information
Email : [email protected]
Phone : +91 9117086909
LinkedIn : www.linkedin.com/in/pranay-kumar-b8a17a354
Location : Newtown, Kolkata, West Bengal
Full Name
Email
Message
Send
