Microsoft Excel (Advanced with Power Query & Pivot Tables)
Tarun Agarwal
Data Analyst | Business Intelligence | SQL | Power BI | Tableau
Summary
Detailed Data Analyst Intern well-versed in various statistical methods such as descriptive and influential statistics. Independent and versatile individual skillful in identifying data issues and monitoring existing metrics. Offering strong analytical mindset and eagerness to learn and grow in data-centric environment, establishing facts and drawing valid conclusions. Proficient in Power BI, Tableau, SQL, MS Excel, Python & other BI/Analytical Tools paired with first-rate report writing abilities.
Overview
3
3
years of professional experience
1
1
Language
14
14
Certificates
Work History
Data Analyst Intern
Zonein Media FZCO
03.2024 - 02.2025
- Converted raw datasets into meaningful formats by performing extensive pre-processing activities such as normalization and transformation.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
- Assisted management in making informed decisions by presenting clear and concise reports detailing analytical findings.
- Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
COLLECTOR (COLLECTION SPECIALIST)
Provana India Private Limited
09.2024 - 01.2025
- Developed strong relationships with clients, fostering trust and facilitating successful account resolutions.
- Streamlined debt collection processes for increased efficiency in the workplace.
- Optimized collection efficiency by analyzing customer payment trends using Excel and Power BI.
- Developed reports to track overdue accounts.
HS ACCOUNT MANAGER
Weavings Manpower Solutions
06.2024 - 08.2024
- Used data analysis techniques to improve customer satisfaction and retention.
- Provided data-driven insights on sales trends and developed reports for business decision-making.
- Increased client satisfaction by building strong relationships and addressing their needs promptly.
CONSUMER SALES SOLUTION
Telus International
02.2024 - 05.2024
- Self-motivated, with a strong sense of personal responsibility.
- Excellent communication skills, both verbal and written.
- Proven ability to learn quickly and adapt to new situations.
- Created Excel-based reports to track customer engagement and sales performance.
- Conducted data-driven sales analysis to identify revenue opportunities.
Account Manager
Midland Credit Management
05.2022 - 01.2024
- Managed and analyzed customer accounts, improving operational efficiency.
- Implemented data-driven strategies for debt collection, increasing payment success rates.
CUSTOMER SERVICE REPRESENTATIVE
IGT Solutions
11.2021 - 05.2022
- Managed and analyzed customer accounts, improving operational efficiency.
- Implemented data-driven strategies for debt collection, increasing payment success rates.
Education
Advanced Data Analytics & AI - Data Analytics
Skillnation
Mumbai, India 04.2001 -
Executive Post Graduate Certification - Data Science & Artificial Intelligence
Intellipaat (IIT Roorkee Affiliated)
Bengaluru, India 04.2001 -
Bachelor of Commerce - Accounting And Finance
Dr. A.P.J Abdul Kalam University
Indore, India 04.2001 -
Skills
Analytical skills
Timeline
Artificial Intelligence (Intellipaat)
03-2025
Azure Administrator (Intellipaat)
03-2025
Power BI (Intellipaat)
03-2025
Tata Group - Data Visualisation: Power BI & Tableau Empowering Business with Effective Insights (Forage)
03-2025
Advanced Microsoft Excel (Skill Nation)
02-2025
Advanced Power BI Certificate (Skill Nation)
02-2025
Advanced Tableau Dashboard
02-2025
Python (Intellipaat)
02-2025
Deloitte Australia - Data Analytics using Tableau (Forage)
02-2025
Microsoft SQL Certification Training (Intellipaat)
02-2025
PwC Switzerland - Power BI Job Simulation (Forage)
02-2025
AI Dashboards using Microsoft Power BI (Skill Nation)
01-2025
Data Visualization With Power BI (Great learning)
01-2025
COLLECTOR (COLLECTION SPECIALIST)
Provana India Private Limited
09.2024 - 01.2025
HS ACCOUNT MANAGER
Weavings Manpower Solutions
06.2024 - 08.2024
Data Analyst Intern
Zonein Media FZCO
03.2024 - 02.2025
CONSUMER SALES SOLUTION
Telus International
02.2024 - 05.2024
SQL (Intellipaat)
02-2024
Account Manager
Midland Credit Management
05.2022 - 01.2024
CUSTOMER SERVICE REPRESENTATIVE
IGT Solutions
11.2021 - 05.2022
Advanced Data Analytics & AI - Data Analytics
Skillnation
04.2001 -
Executive Post Graduate Certification - Data Science & Artificial Intelligence
Intellipaat (IIT Roorkee Affiliated)
04.2001 -
Bachelor of Commerce - Accounting And Finance
Dr. A.P.J Abdul Kalam University
04.2001 -
Accomplishments
- Developed an interactive Power BI dashboard to analyze sales trends, revenue, and customer demographics.
- Implemented DAX measures to calculate KPIs like total sales, profit margins, and customer retention rates.
- Enhanced data visualization with filters, slicers, and drill-through features for better insights.
- Analyzed 100K+ customer records to identify churn trends using SQL queries.
- Built an interactive Tableau dashboard to visualize key insights and patterns in customer behavior.
- Provided actionable recommendations to reduce churn and improve customer retention.
- Created an Excel dashboard with pivot tables and charts to track employee attrition and performance.
- Used Power BI for real-time visualization and reporting of HR metrics.
- Completed a simulation involving creating data visualizations for Tata Group.
- Designed effective visuals and communicated insights to senior leadership.
- Developed reports for data-driven decision-making to help executives.
Sales Performance Dashboard (Power BI) PWC
Customer Churn Analysis (SQL & Tableau) Deloitte
HR Analytics Report (Excel & Power BI) PWC
Tata Group Data Visualization Simulation (Forage)
Software
Microsoft Power BI
Tableau
Python (NumPy, Pandas, Matplotlib, Seaborn, Scikit-learn)
MySQL / SQL Server
Microsoft PowerPoint (Advanced)
Azure
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)
Work Preference
Work Type
Full TimeWork Location
On-SiteRemoteHybridCertification
Artificial Intelligence (Intellipaat)
Personal Information
- Father's Name: Mr. Rajesh Kumar Agarwal
- Date of Birth: 12/29/95
- Gender: Male
- Nationality: Indian
Skill Sets
- Knowledge of accounting
- Strong analytical, organizational ability
- Written and communication skills
- Proficient in computer skills
- Willingness to learn
Technical Skill
- Basic knowledge of computers & Internet
- MS-Office
- C++
- HTML
Similar Profiles
PARVEZ ALI KHANPARVEZ ALI KHAN
Accountant at Techmax Trading Services FZCOAccountant at Techmax Trading Services FZCO
MUDASSIR AHMEDMUDASSIR AHMED
Logistics Coordinator at Marina Retail Corporation FZCO, Marina Home InteriorsLogistics Coordinator at Marina Retail Corporation FZCO, Marina Home Interiors
Sudhanshu KumarSudhanshu Kumar
Data Analytics Manager at DBMSC Steel FZCOData Analytics Manager at DBMSC Steel FZCO