Back to Developers
Ashu Rocks

Ashu Rocks

Data Analyst

Raipur, Chhattisgarh, India 3+ yrs exp 91 · Outstanding

About

Data Analyst with 3+ years of experience turning complex datasets into actionable business insights through SQL, Power BI (DAX), and Advanced Excel (Power Query, PivotTables). Skilled in data cleaning, ETL, exploratory data analysis, and KPI reporting. Built a 12-page HR Analytics dashboard on 100,000+ records and cleaned 110,500 raw records to 100,470 for analysis. Holds a B.Tech in Mechanical Engineering, with a proven track record of delivering dashboards and data quality improvements that support data-driven decision-making.

Skills & Expertise (51)

SQL Intermediate
7.5/10
3
Years Exp
Power BI Intermediate
7.5/10
3
Years Exp
Data Visualization Intermediate
7.0/10
3
Years Exp
Data Cleaning Intermediate
7.0/10
3
Years Exp
Python Intermediate
6.5/10
3
Years Exp
EDA VLOOKUP Conditional Formatting Data Validation Charts Pandas NumPy Matplotlib ETL Advanced Excel Outlier Detection IQR Descriptive Statistics Churn Analysis Customer Segmentation Attrition Analysis SQLite DBeaver Jupyter Notebook VS Code Git GitHub Data Quality Checks Joins CTEs Subqueries Window Functions RANK LAG Lead Views Temp tables Indexing Query Optimization XLOOKUP COALESCE CASE WHEN DAX Power Query Star Schema Data Modeling Dashboard Development KPI Reporting Drill-through Slicers PivotTables

Work Experience

Data Analyst

Keylong Systems Pvt. Ltd.

Feb 2022 - Apr 2025

Cleaned and preprocessed large-scale datasets using Excel (VLOOKUP, PivotTables, Power Query), resolving duplicates, missing values, and outliers to improve data accuracy for downstream reporting. Developed complex SQL queries using joins, subqueries, CTEs, and window functions to extract, transform, and analyze transactional data, identifying trends and supporting business decisions. Built interactive Power BI dashboards using DAX, data modeling, and visualization best practices, delivering actionable insights and KPI reports to business stakeholders. Partnered with cross-functional teams to gather requirements and deliver end-to-end data analytics solutions — from data cleaning through SQL analysis to Power BI reporting — enabling data-driven decision-making.

Education

B.Tech in Mechanical Engineering - Shri Shankaracharya Engineering College

- 2021 · Afghanistan

Higher Secondary (Class XII) - Krishna Public School

- 2017 · Afghanistan

Secondary (Class X) - Krishna Public School

- 2015 · Afghanistan

Certifications

SQL (Basic)

HackerRank · 2026

Python (Basic)

HackerRank · 2026

Power BI for Business Intelligence

Udemy · 2022

SQL for Data Analytics

Udemy · 2022

Statistics for Data Science

Udemy · 2022

Interested in this developer?

Profile Score Breakdown

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

Profile Overview

Member sinceSep 2026