Kandarp

Data Analyst

[email protected] +91 9601063230

Resume

Hello, I am

Kandarp.

1

Excel
Project

2

PowerBI
Projects

2

SQL
Projects

About Me

Hey there! 👋 I'm on a mission to turn raw data into actionable insights, introducing myself as a Data Analyst. With a Bachelor's in Instrumentation & Control Engineering, I swiftly discovered my talent for extracting stories hidden within data.
My journey into data analysis is captivating. While not at a formal desk, I refine my skills using Excel, Power BI & SQL, piecing together the puzzle of numbers, trends and outliers.
What sets me apart? My engineering background, coupled with a passion for data, gives me a unique perspective. Despite the lack of corporate titles, my portfolio showcases hands-on business projects, each a testament to my analytical prowess.
Ready to elevate your team's data game? Dive into my portfolio, and let's embark on a data-driven journey together! 🚀

Key Skills

MySQL

PowerPoint

My Projects

Sales & Finance Analytics

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Provide Insights to Management in Consumer Goods Domain.

AtliQ Mart Promotional Insights in FMCG domain

Domain/Function: FMCG

SHIELD Insurance

Domain/Function: Insurance

My Experience

Data Analyst | November 2022 – Present | Numerator PV T. LTD., Vadodara

•Conduct in-depth brand and category research for critical client insights.

• Enhanced insight development through rigorous research on brands and categories, consistently delivering data with a quality rating surpassing 99%.

Data Associate | May 2021 – November 2022 | Numerator PV T. LTD., Vadodara

• Conduct summary and full transcriptions for OCR (Optical Character Recognition)- received receipts in the Transcription process.

• Maintain a consistent daily output, surpassing targets by transcribing 2700+ items per day with over 99% quality.

• Developed and honed decision-making skills through daily tasks and responsibilities.

Senior Executive | July 2019 – March 2021 | Atul LTD., Valsad

• Handle routine and breakdown maintenance across 7 plants as an Instrumentation Maintenance Engineer.

• Hands-on experience with Oracle-based ERP for updating calibration records of over 200 field instruments.

Awards & Certificate

AtliQ Mart - Promotional insights in FMCG domain

AtliQ Technologies - Virtual Internship

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.

Mail Me

[email protected]

https://www.linkedin.com/in/desaikandarp/

Call Me

+91 9601063230

GitHub

https://github.com/kd1811

Excel Project

Sales & Finance Analytics

Generated sales reports for customer and market evaluation, aligning with targets. For finance report, crafted P&L statements to extract key business insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Pivot

Power Query

Customer Performance Report: Displays net sales for each customer from 2019 to 2021, highlighting Year-over-year analysis for the period 2020 to 2021.

Market performance vs Target Report: Evaluates country-wise net sales against set targets, aiding stakeholders in performance assessment across years.

Project Details

In this project, I utilized Excel pivot tables to construct a comprehensive sales report. This tool empowers businesses to discern effective customer discounts, facilitate negotiations, and pinpoint potential expansion opportunities in promising countries. The generated reports offer actionable insights and recommendations, aiding businesses in optimizing sales strategies, elevating customer satisfaction, and maximizing revenue.
I have learned the following:
1. Pivot table
2.Power Pivot
3. Power Query
4. DAX (Basics)
5. Conditional Formatting
6. Report Beautification
7. Sales Domain Metrics
The primary objective is to equip businesses with the essential tools and insights needed to monitor, evaluate, and elevate their sales activities. Through meticulous sales data analysis, businesses can uncover new opportunities, foster growth, and maintain competitiveness in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. Implementing Power BI for advanced analytics, aiming to enhance competitiveness through data-driven decision-making.

View Project
Engagement

Other Tools

MySQL

Dashboard design with a user-empathetic landing page, placing a strong emphasis on understanding and meeting user needs.

Data modeling with a network of over 10 interconnected tables.

Project Details

Project objective is to develop a comprehensive report catering to stakeholders in finance, sales, marketing and the executive team, with a focus on:

1. Robust Data Modeling
2. User-centric Report Design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

SQL Project

Provide Insights to Management in Consumer Goods Domain.

AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, they do not get enough insights to make quick and smart data-informed decisions. There are 10 ad-hoc requests for which the business needs insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

PowerPoint

The input data consists of customer information, product information and sales information for fiscal year 2020 and 2021.

Month wise gross sales for AtliQ Exclusive: The report provides the information related to high and low performing months in terms of gross sales.

Project Details

Project Objective:
- Provide top-level management with data-informed insights through 10 ad-hoc requests.
- Optimize sales strategies and identify strong areas and areas of focus for sold products across divisions.

Tools Utilized:
- SQL: Queried the database to fulfill ad-hoc requests.
- Power BI: Visualized output data for clear interpretation.
- PowerPoint: Presented final insights to management.

Significance:
- Empowers business decisions with data-driven strategies.
- Facilitates growth on a global scale.

SQL Project

AtliQ Mart Promotional Insights in FMCG domain

Domain/Function: FMCG

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a promotion during the festive time in India on their AtliQ branded products. Now the company wants some key insights to make informed decision for the future.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Microsoft PowerPoint

Input Data consists of store information, product information, information about the campaigns and sales information during the festive season.

Promotion type analysis: The report provides the information related to different promotions and their performance during the festive season.

Project Details

Project Objective:
- Provide SQL-based report for important business questions posed by Senior Executive team.
- Design a dashboard with important metrics and analysis with actionable insights and present it to the sales director.

Tools Utilized:
- SQL: Queried the database to fulfill ad-hoc requests.
- Power BI: Visualized output data for clear interpretation.
- PowerPoint: Presented final insights to management.

Significance:
- Empowers business decisions with data-driven strategies for the next promotional cycle.

PowerBI Project

SHIELD Insurance

Domain/Function: Insurance

This project is a part of my virtual internship at AtliQ Technologies and it is for our client Shield Insurance company. This project helps the stakeholders to study customer behavior and revenue trends based on demographics, Sales modes and various policies.

View Project
Engagement

View Project
on GitHUB

Other Tools

Microsoft PowerPoint

Dashboard design with a user-centric landing page, prioritizing a deep understanding of and responsiveness to user needs.

Data modeling with a network of given CSV files as an input data.

Project Details

Project Objective:
- This Power BI project provided a comprehensive analysis of customer behavior and revenue trends in the insurance domain, offering actionable insights to optimize business strategies. Policy trends highlighted distinct customer preferences, with certain policies excelling in specific age groups.
- The client can leverage these insights to tailor marketing strategies, enhance customer engagement, and optimize policy offerings, potentially boosting revenue by targeting high-potential segments.

Tools Utilized:
- Power BI: Visualized data for enhanced clarity and interpretation.
- PowerPoint: Delivered final insights to management through a compelling presentation.

Significance:
- This project can enable the company to streamline operations and increase efficiency by at least 15%, driving better decision-making.