Home About Skills Projects Achievements Experience Education Certifications Contact
Available for opportunities

Ashish
Rawat.

Data Analyst
›

Results-driven Data Analyst with hands-on expertise in Power BI, SQL, Python, and Excel. Passionate about transforming raw datasets into actionable business insights and building interactive dashboards that drive data-driven decisions.

View Projects Hire Me Resume
0
Projects
0
Year Exp.
0
Records/Week
0
Certifications
Ashish Rawat profile photo
analytics_summary.bi
📊 Weekly Interactions 500+
⚡ Reporting Automation 60%↑
🎯 Customer Satisfaction 90%+
📉 Attendance Time Saved 80%↓
Power BI Proficiency80%
SQL Skills75%
Excel Expertise85%
About Me

Turning Data Into Decisions

I'm a results-driven, entry-level Data Analyst currently pursuing my MCA with a specialization in Artificial Intelligence & Data Science from Graphic Era Hill University, Dehradun.

With over a year of professional experience at Concentrix, I developed strong analytical instincts — analyzing 500+ customer interactions weekly, monitoring KPI dashboards, and generating data-driven reports that directly influenced business decisions.

I thrive at the intersection of business and data — translating messy datasets into clean, visual stories using Power BI, SQL, Python, and Excel. I'm an immediate joiner, willing to relocate, and eager to contribute to impactful analytics teams.

📍
Location
Dehradun, India
🎓
Degree
MCA – AI & DS
⚡
Availability
Immediate Joiner
✈️
Relocation
Willing to Relocate
  • Name: Ashish Rawat
  • Email: Ashishrawat.da@gmail.com
  • Phone: +91 9105335275
  • GitHub: github.com/Ashish-da
  • LinkedIn: linkedin.com/in/ashish-da
  • Experience: 1 Year (Concentrix)
  • Core Tools: Power BI, SQL, Excel, Python
Resume Summary

Results-driven entry-level Data Analyst with hands-on experience in Excel, SQL, Power BI, and Python for dashboard development, reporting automation, data cleaning, and business analysis. Experienced in analyzing 500+ customer interactions weekly and managing KPI-based reporting in fast-paced business environments. Currently pursuing MCA with specialization in AI & Data Science.

Technical Skills

Skills & Expertise

A comprehensive toolkit for end-to-end data analytics — from raw data wrangling to production-ready dashboards.

Microsoft Excel
Pivot Tables & Power Query90%
VLOOKUP / Advanced Formulas85%
Dashboard Reporting88%
Conditional Formatting Charts Data Validation
SQL
Joins & Subqueries80%
Aggregations & Filtering82%
Query Optimization72%
GROUP BY CTEs Window Functions
Power BI
Interactive Dashboards80%
DAX Formulas70%
KPI Monitoring85%
Data Modeling Power Query Reports
Python
Pandas / NumPy75%
Data Cleaning & EDA78%
OpenCV / Tkinter65%
EDA Matplotlib Data Wrangling
Data Analytics
Business Intelligence KPI Monitoring Reporting Automation Data Transformation Customer Analytics Trend Analysis Statistical Analysis Data Storytelling
Tools & Platforms
GitHub CRM Systems PowerPoint Canva MS Office Suite Google Sheets
Tech Stack

Tools & Technologies

📊
Power BI
Visualization
🐍
Python
Programming
🗄️
SQL
Database
📗
Excel
Analytics
🐼
Pandas
Data Processing
🔢
NumPy
Computation
👁️
OpenCV
Computer Vision
🐙
GitHub
Version Control
📋
CRM Tools
Business Ops
📐
PowerPoint
Presentation
Portfolio

Featured Projects

Real-world data analytics projects demonstrating end-to-end analytical thinking, dashboard development, and business impact.

📊
Power BI
Sales Performance Dashboard
Designed and built a fully interactive Power BI dashboard analyzing 10,000+ sales records to uncover revenue trends, track regional performance, and visualize KPI metrics in real time. Integrated dynamic slicers and drill-through capabilities for executive-level reporting.
Reduced manual reporting effort by ~60% via automated visual dashboards
Analyzed 10,000+ sales records across multiple regions
Enabled real-time KPI tracking for business stakeholders
Power BI DAX Power Query Excel
🎓
Python
Face Recognition Attendance System
Engineered a real-time automated attendance system using Python, OpenCV, and Tkinter capable of recognizing 50+ registered users simultaneously. The system captures, encodes, and matches facial data in milliseconds, storing attendance logs with timestamps automatically.
Reduced manual attendance processing time by ~80%
Supports recognition for 50+ registered users in real time
Automated timestamp-based logging with CSV export
Python OpenCV Tkinter Pandas
👥
Power BI
HR Analytics Dashboard
Developed a comprehensive HR analytics dashboard using Power BI to analyze 2,000+ employee records, providing deep insights into workforce composition, attrition trends, department-level performance, and diversity metrics for HR leadership decision-making.
Analyzed workforce data across 2,000+ employee records
Tracked attrition rate, tenure, and departmental KPIs
Improved HR reporting efficiency and decision-making visibility
Power BI DAX Excel Data Modeling
🗃️
SQL
Customer Interaction Data Analysis
Designed and executed complex SQL queries to analyze 500+ weekly customer interactions from CRM databases, identifying recurring service bottlenecks and building aggregated reports for operational insights used in performance reviews.
Identified top 5 recurring service issues via trend analysis
Improved response efficiency by 15% through data insights
Built weekly automated report pipelines from CRM data
SQL Joins Aggregations CRM
📗
Excel
KPI Reporting Automation (Excel)
Built a comprehensive KPI tracking workbook using advanced Excel features — Pivot Tables, Power Query, VLOOKUP, and Conditional Formatting — to automate weekly business performance reports across sales and customer support operations, reducing manual data entry by over 40%.
Automated weekly reporting, saving 4+ hours/week
Reduced manual data entry errors by ~40%
Enabled real-time KPI monitoring for team leads
Excel Pivot Tables Power Query VLOOKUP
Work History

Work Experience

Customer Service Executive
Concentrix · Gurugram, Haryana
Jul 2023 – Jul 2024
  • Analyzed 500+ customer interactions weekly to identify recurring service issues, enabling a 15% improvement in response efficiency through data-informed process changes.
  • Managed CRM records and monitored KPI dashboards while handling 200+ customer cases daily across sales and support operations — developing strong data management instincts.
  • Consistently achieved monthly sales targets while maintaining 90%+ customer satisfaction scores — a direct result of leveraging customer data insights to personalize service.
  • Generated weekly customer insight reports that supported data-driven business decisions, contributing to service optimization and operational improvements.
  • Gained hands-on experience with CRM systems, report generation, and business intelligence tools in a high-volume production environment.
CRM KPI Dashboards Data Reporting Customer Analytics Excel
Academics

Education Timeline

🎓
Master of Computer Applications (MCA)
Graphic Era Hill University
Specialization: AI & Data Science · Dehradun, Uttarakhand · 2024–2026
GPA: 75%
🎓
Bachelor of Computer Applications (BCA)
Himalayan Garhwal University
Pauri Garhwal, Uttarakhand · 2021–2023
GPA: 71%
📚
Class 12 (CBSE)
K.V. Birpur
Dehradun, Uttarakhand · 2019
GPA: 75%
📘
Class 10 (CBSE)
Army Public School
Dehradun, Uttarakhand · 2017
GPA: 72%
Certifications

Licenses & Certifications

AI in Excel
AI in Excel
Excel Certification
Hack2Skill Certification
Hack2Skill Certificate
Professional Bootcamp
Internship Studio
Internship Studio
Training Completion
Intermediate Excel
Intermediate Excel
Excel Mastery
Macros & VBA
Macros & VBA
Excel Automation
Upskill Program Letter
Upskill Program
Program Completion
Key Metrics

Achievements & Impact

0%
Reduction in manual reporting via automated Power BI dashboards
0%
Decrease in attendance processing time via Face Recognition System
0%
Customer satisfaction score consistently maintained at Concentrix
0%
Improvement in service response efficiency through data-driven analysis
0+
Sales records analyzed in Power BI Sales Dashboard project
0+
Employee records visualized in HR Analytics Dashboard
Get In Touch

Let's Connect

Open to data analyst roles, internships, and collaborations. I'm an immediate joiner and willing to relocate.

Email
Ashishrawat.da@gmail.com
LinkedIn
linkedin.com/in/ashish-da
GitHub
github.com/Ashish-da
Location
Dehradun, India · Willing to Relocate
Send a Message