<ul><li>Currently pursuing Data Science certification at Newton School, covering machine learning, statistics, and data visualization.</li><li>Trained in SQL, Advanced Excel, and Power BI with hands-on experience in data analysis and reporting.</li><li>Applying analytical skills on real-world datasets to support data-driven decision-making.</li></ul>

Professional Certificate in Data Analyst

Bachelor of Computer Applications

Computer Applications

Intermediate (Class XII)

Science

Matriculation (Class X)

<ul><li>Analyzed daily revenue data and tracked business performance trends across departments</li><li>Conducted comparative analysis of monthly and year-over-year revenue growth (month-on-month and same-month-previous-year comparisons) to identify performance patterns</li><li>Built and maintained interactive dashboards in Excel using VBA and Macros to automate data consolidation and enable real-time visibility into key business metrics</li><li>Tracked vehicle delivery timelines and deadlines using time-tracking systems to ensure timely order fulfillment</li><li>Identified bottlenecks in operational and delivery processes through data analysis, driving process improvements and efficiency gains</li><li>Automated repetitive reporting tasks using VBA macros, reducing manual effort and turnaround time for report generation</li><li>Presented data-driven insights to management to support decision-making on revenue growth and operational efficiency</li></ul>

Data Science & Analytics

<ul><li>Provided technical support and resolved system/application-related issues for users.</li><li>Worked with SQL, APIs, and Microsoft Excel for data analysis, troubleshooting, and reporting.</li><li>Used the Zoho platform to manage tickets, workflows, and customer data.</li><li>Coordinated with internal teams to ensure smooth operations and quick issue resolution.</li></ul>

IT Support & Networking

Tech Support Executive

Indira Gandhi National Open University, New Delhi

India

Data Analyst skilled in SQL, Excel, Power BI, and Python with hands-on experience in data analysis, dashboard development, KPI reporting, and business insights generation. Built analytical solutions using datasets containing 600K+ orders and 100K+ customers. Currently pursuing Data Science at Newton School and seeking opportunities in Data Analytics and Business Intelligence.

<ul><li>Built 3 interactive Power BI dashboards to analyze Amazon sales, customer behavior, and product performance across 4 zones and 5 categories.</li><li>Analyzed 113K+ customers, 602K+ orders, and ₹107M+ revenue using DAX and KPIs (AOV ₹949, return rate 27%, ratings 2.73) to identify trends and high-performing regions.</li><li>Performed customer segmentation and time-series analysis (2015–2020), identifying a ~40% revenue growth in 2020 and key business insights.</li></ul>

E - Commerce Project

<ul><li>Performed end-to-end SQL analysis using JOINs, CTEs, subqueries, and window functions on customer, invoice, and track data.</li><li>Analyzed revenue by country, genre, and customer segments, identifying USA as top market and Rock as best-selling genre; calculated ~73% churn using cohort logic.</li><li>Segmented high- vs low-value customers by lifetime spend and frequency, delivering retention and loyalty insights with optimized, readable SQL queries.</li></ul>

Chinook Music Store Analysis

<ul><li>Analyzed 28K+ consultation records using Excel (Pivot Tables, XLOOKUP, COUNTIFS, SUMIFS) to evaluate agent performance and revenue.</li><li>Identified 43.5% success rate, avg rating 2.93, and ₹2.14L revenue, with call-based consultations outperforming chat.</li><li>Analyzed time-slot trends (08:00 AM–04:00 PM peak) and recommended process, training, and schedule optimizations to improve service quality and revenue.</li></ul>

Aritra Khanra

Social Accounts

Achievements

Projects

E - Commerce Project

Chinook Music Store Analysis

AstroSage Call Center Optimization Project

Experience

EDP

Tech Support Executive

Education

Indira Gandhi National Open University

New Andul H.C School

New Andul H.C School

Certificates

Professional Certificate in Data Analyst

Skills