Back to Developers
Ashutosh Gusain

Ashutosh Gusain

Data Analyst

Noida
80
Profile Score

About

Data Analyst with 1.3 years of experience converting complex datasets into actionable insights that improve decision-making and performance. Proficient in SQL, Tableau, and Excel; strong in data modeling, visualization, KPI design, and stakeholder reporting.

Skills & Expertise (24)

Excel Advanced
7.8/10
2
Years Exp
SQL Intermediate
7.5/10
2
Years Exp
Visualization Advanced
7.2/10
2
Years Exp
Data Visualization Intermediate
7.2/10
2
Years Exp
Data Modeling Intermediate
6.9/10
2
Years Exp
Tableau Intermediate
6.8/10
2
Years Exp
Time Series Analysis Advanced Excel Multivariate Analysis Customer Segmentation Exploratory data analysis Pivot Tables Countifs SUMIFS Lookups Parameters Filters Calculated Fields LODs Window Functions CTEs Joins Stakeholder Reporting KPI Design

Work Experience

Business Operations Specialist

Amazon

Jul 2022 - Jul 2024

Assisted in designing and maintaining Tableau dashboards for accurate, real-time visualization. Transformed raw data into KPIs that increased departmental productivity by 5%. Detected and removed 100+ counterfeit products on marketplaces, reducing complaints and protecting brand integrity. Wrote advanced SQL to optimize Tableau models, cutting processing time by 20+ minutes per report while preserving integrity. Led analytics initiatives using Excel and SQL to define metrics and streamline operational workflows.

CRM Data Analyst Intern

AMPM

Apr 2025 - Aug 2025

Consolidated 10+ years of legacy sales and customer data from multiple Excel files into a single structured source using Power Query. Maintained CRM and sales data for marketing; collaborated with finance to align datasets and improve reporting accuracy. Cleaned and standardized 100,000+ international phone numbers; filled missing values and implemented validation checks. Conducted RFM analysis to segment customers for personalized outreach, improving targeting and engagement. Supported a 15% MoM sales increase in June and a 10% YoY improvement in retention.

Education

Japanese Language - MOSAI

2019 - 2022 · Afghanistan

Bachelor of Arts (Literature) - Delhi University

2018 - 2021 · Afghanistan

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 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceFeb 2026

Skills (24)

Excel SQL Visualization Data Visualization Data Modeling Tableau Time Series Analysis Advanced Excel Multivariate Analysis Customer Segmentation +14 more