Kavita Deopa
Data Analyst - Business Intelligence and Analytics
Hire this person
Send a job offer directly to this candidate
About
Results-driven Data Analyst with 6+ years of experience in business intelligence, automated KPI tracking, and process optimization. Skilled in Power BI, SQL, and Advanced Excel, transforming large and complex datasets into actionable insights. Combines technical analytics expertise with domain knowledge in ecommerce, and beauty and cosmetics product analytics to drive category growth, optimize supply chain metrics, and improve data integrity.
Immediate joiner, available to start without a notice period.
Experience
Data Analyst at Capgemini Invent (2020-01 – 2026-07)
- Designed and deployed interactive Power BI dashboards and executive scorecards to track critical KPIs across cross-functional projects.
- Engineered and maintained large-scale datasets using SQL, structuring complex relational product records in Excel for operational and predictive analysis.
- Delivered exception-based reporting mechanisms that enhanced corporate risk management and executive decision-making.
- Applied advanced statistical validation methods across enterprise datasets, increasing data accuracy and integrity by 15%.
- Led data cleansing and restructuring initiatives that reduced data redundancy by 40%, improving reporting reliability and query consistency.
- Delivered e-commerce analytics projects across apparel, toys, and beauty business units, with a focus on premium haircare, skincare, body care, and fragrance portfolios.
- Built and managed centralized Excel product databases of 1,000-2,000 SKUs, automating stock tracking, category dashboards, and expiry alerts, cutting manual reporting effort by 30%.
- Documented brand descriptions, ingredient profiles, and consumer use-case mappings to improve product data accuracy and search discoverability.
- Synthesized consumer insights and market trends into Power BI visualizations, presenting growth opportunities to stakeholders to optimize brand performance.
Education
Diploma in Computer Science Engineering – Government Polytechnic, Almora
Bachelor of Arts – MBPG College, Haldwani



