Powered by
Codebasics Data Analytics Bootcamp

Harshal Salunkhe

Data anaylst

+91 9594252470 [email protected]

Resume

Hello, I am

Harshal Salunkhe.

1

Excel Project

1

PowerBI Project

About Me

Hello, I'm Harshal – an aspiring Data Analyst with a talent for finding insights using Excel and Power BI. I have a bachelor's degree in Commerce but discovered my passion for data analysis.

For the past 7 years, I’ve worked as an Office Executive, managing daily tasks, improving efficiency, and building strong client relationships. I create useful reports, work well with different teams.

Top 3 things I bring to the table:
1) Efficient daily operations management
2) Customer satisfaction and retention strategies
3) Data-driven decision-making expertise

I love working with others and am eager to join projects that use my skills. My portfolio includes several business projects where I’ve applied my expertise. If you need someone who excels in managing operations, ensuring client satisfaction, and making data-based decisions, let’s connect and achieve great results together.

Key Skills

MySQL

MIS Reporting

Data Modeling

Data Visualization

ETL Process

Problem-Solving

My Projects

My Experience

Sky Tech and Cleaning Systems PVT LTD, Navi Mumbai – Office Executive
Jul 2019 – July 2024

Developed detailed reports and MIS to enhance strategic decisions, increasing operational efficiency by 20%.

Achieved a 40% increase in repeat business through effective customer relationship management.

Maintained a 95% customer satisfaction rate by implementing proactive customer service strategies.

Dezaview Learning and Training System PVT LTD, Navi Mumbai – Office Executive
Jan 2018 - Jun 2019

Implemented an MIS to track daily operations, boosting transparency and productivity by 30%.

Improved client communication by promptly handling queries, increasing satisfaction by 20%.

Supported the training team, resulting in a 15% increase in training effectiveness.

PAMAC Finserve PVT LTD, Thane -- Credit & OPS Executive
Apr 2016 - Dec 2017

Analyzed customer profiles comprehensively, improving credit risk assessment accuracy by 25%.

Prepared Credit Approval Memos and notes, ensuring 100% compliance with regulations.

Conducted detailed credit checks on financial data, banking, and CIBIL reports, reducing credit risk by 20%.

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/harshal-salunkhe-executive/

+ 91 9594252470

https://github.com/Harshal-Executive?tab=repositories

Excel Project

Customer & Market Analysis

I've developed engaging customer performance reports, analyzing market trends by comparing sales targets. I generate detailed Profit and Loss (P&L) reports for strategic financial decision-making, focusing on user-centric design to deliver clear insights.

View Project
Engagement

View Project
on GitHUB

Customer & Market Analysis

Customer Performance Report: Delivers detailed net sales performance for each customer over multiple years.

Customer & Market Analysis

Market Performance vs. Target Report: Evaluates country performance against set targets across consecutive years, enabling strategic assessment and co

Project Details

In this project, I created dynamic Excel pivot tables for sales reports. These insights optimize customer discounts, enhance negotiation strategies, and identify growth opportunities in key markets. The actionable insights refine sales strategies, boost customer satisfaction, and drive revenue growth.

Knowledge Gained: Key Takeaways
1. Business Reporting: Profit & Loss, statistical analysis
2. Power Pivot: Advanced data modelling, reporting
3. Power Query: Data cleaning, merging
4. Essential Formulas: IF, SUMIF, COUNTIF, AVERAGE
5. Lookup Functions: VLOOKUP, INDEX & MATCH, XLOOKUP
6. Data Visualization: Excel charting (pie charts, data bars, bubble charts)
7. Conditional Formatting: Visual data insights
8. Basic VBA: Task automation

This project empowers businesses to track, evaluate, and improve sales activities effectively, leveraging data analysis to discover growth opportunities and maintain competitiveness in a rapidly changing market.

PowerBI Project

Million Records, One Vision AtliQ Hardware's Strategy

AtliQ Hardware is a fast-growing global tech company specializing in computers and accessories. Despite their rapid expansion, they struggled with outdated Excel reports. Business Insight 360, a Power BI solution, turns data into clear insights, helping AtliQ make smarter decisions

View Project
Engagement

View Project
on GitHUB

Million Records, One Vision AtliQ Hardware's Strategy

Unlock Insights: A Deep Dive into AtliQ Hardware’s Performance with 5 Views

Million Records, One Vision AtliQ Hardware's Strategy

Organizing Data: Modeling Insights from 10+ Tables

Project Details

The main goal is to use financial analytics to improve AtliQ Hardware's performance and profitability. Analyzing the company's financial data will reveal insights for decision-makers to make strategic choices and achieve sustainable growth.

Key Power BI skills acquired during this project:
• Proficiency in ETL processes (Power Query)
• Expertise in Data Modelling (10+ Tables)
• Development of calculated columns and DAX measures
• New Parameters for dynamic filtering
• Interactive toggle buttons
• Enhancement of visuals with conditional formatting
• Design of New card visuals and New button slicers
• Seamless visual navigation with bookmarks
• Report publication to Power BI services
• Configuration of personal gateways for auto-refresh

This project has empowered AtliQ Hardware, enabling the company to unlock valuable insights from data, leading to smarter business decisions and a stronger competitive position in the global tech market.

Project video

Live Interactive Dashboard