Back to Developers
Devendera Rawat

Devendera Rawat

Data analyst

Gurgaon
70
Profile Score

Skills & Expertise (50)

Power BI Advanced
8.5/10
3
Years Exp
Advanced Excel Advanced
8.3/10
3
Years Exp
SQL Advanced
8.1/10
3
Years Exp
Python Intermediate
7.9/10
2
Years Exp
Tableau Intermediate
7.1/10
2
Years Exp
Data Cleaning RELATED RELATEDTABLE LOOKUPVALUE Sprinklr PowerPoint MIS Reporting KPI Tracking Dashboarding Table Report Automation Conditional Formatting Data Validation XLOOKUP Charts Joins Subqueries Aggregations Window Function Data Modeling Data visualization with Power BI and Excel Query Folding ROW_NUMBER RANK DENSE_RANK LIMIT OFFSET Correlated Subquery Recursive CTE Cumulative Analysis DAX ETL Star Schema Matrix Performance Analyzer Bar Chart Column Chart Line Chart Pie Chart Stacked bar Chart Area Chart Scatter Plot Map Chart KPI Card Visual

Work Experience

Data Analyst

Cheil India

Aug 2024 - Mar 2026

Led end-to-end MIS reporting and dashboarding for multiple consumer electronics categories (ACs, TVs, Refrigerators, Washing Machines, Microwave). Designed Power BI dashboards to track KPIs, product performance, and campaign effectiveness, reducing manual reporting effort by 30–40%. Automated recurring reports using Python and Excel Power Query, improving turnaround time and data accuracy. Analyzed CRM and social media data via Sprinklr (YouTube, Facebook, Instagram) to measure brand Sentiment, Reach, and Engagement. Delivered weekly executive-ready insights and recommendations during product launches and Marketing Campaigns. Partnered with Marketing, Operations, and Client Stakeholders to translate data into actionable business insights.

Analyst

Concentrix

Apr 2022 - Dec 2023

Analyzed large-scale CRM and operations datasets to identify performance trends and operational gaps. Built interactive Excel dashboards using Pivot Tables, XLOOKUP, INDEX-MATCH, and charts for leadership reporting. Generated daily, weekly, and monthly MIS reports for operations, quality, and management teams. Tracked KPIs, SLAs, and customer experience metrics, supporting improvements in service efficiency. Delivered customized, stakeholder-specific reports enabling faster decision-making.

Education

B.Tech Civil Engineering - Uttaranchal University

2014 - 2018 · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 0/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 70/100

Profile Overview

Member sinceMar 2026

Skills (50)

Power BI Advanced Excel SQL Python Tableau Data Cleaning RELATED RELATEDTABLE LOOKUPVALUE Sprinklr +40 more