Open To Work
MATIDEV KUMAR
Bengaluru
Work Preference
Summary
Detail-oriented Data Analyst with 4 years of experience leveraging SQL, Python, and Power BI to provide actionable insights. Expertise in optimizing operations, enhancing data accuracy, and automating workflows. Proficient in building ETL pipelines, developing executive dashboards, and collaborating in Agile environments to achieve business objectives.
Overview
5
5
years of professional experience
Work History
Data Analyst
Capgemini
08.2021 - Current
- Optimized complex SQL queries and CTES, improving data retrieval performance by 40%
- Automated weekly ETL processes using Python (Pandas, NumPy), reducing manual reporting effort by 15+ hours per week
- Developed executive-level Power BI dashboards using advanced DAX, facilitating data-driven decision-making and enhancing operational efficiency by 10%
- Established standardized data framework ('Single Source of Truth'), minimizing reporting discrepancies by 30% and ensuring consistent data reliability
- Managed end-to-end data lifecycle in Agile environment using Jira and Confluence, achieving 95% on-time delivery
- Identified annual cost savings of $50K+ through vendor performance analysis and optimization of resource allocation, contributing to budgetary efficiency
- Collaborated with cross-functional teams to translate business KPIs into data-driven solutions
Education
B.Tech - Electrical Engineering
National Institute of Technology (NIT)
Patna07-2021
Skills
- Data visualization
- Data transformation
- Data cleaning
- SQL
- Python (Pandas, NumPy)
- ETL pipelines
- Performance optimization
- Data modeling
- Data governance
- DAX development
- JIRA and Confluence
Projects
Customer Churn & Revenue Insights Dashboard (SQL, Python, Power BI)
Developed an end-to-end data analytics project to identify customer churn patterns, improve retention, and optimize revenue growth using transactional and customer behavior data. Cleaned and transformed 100K+ records using SQL and Python, performed exploratory data analysis to uncover churn drivers, and built interactive Power BI dashboards with KPIs such as churn rate, customer lifetime value, monthly revenue, and retention trends. Generated actionable recommendations that could reduce churn by 15% and improve business decision-making through data-driven insights.
Timeline
Data Analyst
Capgemini
08.2021 - Current
B.Tech - Electrical Engineering
National Institute of Technology (NIT)