Portfolio - Umang Vataliya

Umang Vataliya

Data Analyst

Resume

1

Excel Project

1

PowerBI Project

1

SQL Project

About Me

Welcome to my portfolio! I am an aspiring Data Analyst with a passion for transforming raw data into actionable insights. I have a knack for digging into data and finding valuable insights using tools like Excel, Power BI, SQL, and Python. My educational background includes a Bachelor's degree in Computer Application and Information Technology (B.Sc. IT). It's where I laid the foundation for my passion for data analysis and honed my skills in technology. Although I haven't yet had the opportunity to work in a formal organizational setting, I've been actively engaged in several dynamic business projects. You can explore these projects further in my portfolio below. I'm always keen to improve and use data to make smart choices. If you need someone who's ready to learn and make a difference as a Data Analyst, I'm here for you.

Thank you for visiting my portfolio, and I look forward to connecting with recruiters who appreciate the power of data and are ready to leverage it for success.

Key Skills

Statistical analysis

Excel

Power Bi

SQL

My Projects

Sales Analytics(FMCG)

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

Finance Analytics SQL Project

Domain/Function: Finance

My Experience

Awards & Certificate

Google Data Analytics Capstone: Complete a Case Study

Cisco Data Analytics Essentials

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/umang-vataliya-76a342283/

GitHub

https://github.com/01UvCoder

Excel Project

Sales Analytics(FMCG)

Developed 2 concise sales reports to evaluate customer and market performance against targets. These reports empower the sales team with actionable insights for informed decision-making and strategic planning.

View Project
on GitHUB

Customer Performance Report: Delivers insights into individual customer net sales performance across multiple years.

Market Performance vs. Target Report: Empowers stakeholders to evaluate country performance against predefined targets across multiple years.

Project Details

In this project, I crafted a sales report using Excel pivot tables. This report helps businesses figure out the best customer discounts, negotiate with customers, and spot growth chances in promising countries. The reports I made give clear insights and suggestions for businesses to improve their sales strategies, make customers happier, and earn more money.

Here's what I learned:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to give businesses the tools and insights they need to watch, assess, and boost their sales activities. By analyzing sales data, businesses can find new opportunities, grow, and stay competitive in the changing market.

PowerBI Project

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

AtliQ Hardware, an expanding consumer electronics company, is lagging behind competitors due to its reliance on Excel reports. My objective is to introduce an advanced analytics solution using Power BI. This solution will equip the company with valuable insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

Excel

DAX Studio

Creating a user-friendly landing page as part of dashboard design, prioritizing the needs and experience of the users.

Data modelling involving 10+ tables

Project Details

This project aims to create a single report that serves stakeholders from sales, marketing, finance, and the executive team. Key focuses include following

1. Creating a strong data model.
2. Designing user-friendly reports.
3. Providing detailed, drillable insights.

Through this project, I've gained expertise in:

1. Basic and advanced Power Query operations.
2. Basic and complex DAX formulas
3. Data modeling involving 10+ tables
4. Selecting appropriate visuals and formatting.
5. Dashboard designing principles
6. Using Bookmarks to switch between two visuals
7. Deploying reports in Power BI service.
8. Incorporating stakeholder feedback.
9. Understanding metrics from various departments.
10.Setting up auto-refresh of data using personal gateway.

Live Interactive Dashboard

SQL Project

Finance Analytics SQL Project

Domain/Function: Finance

I completed a Finance Analytics project where I applied advanced SQL techniques, including user-defined functions and stored procedures, to enhance finance analytics for Atliq Hardware. This resulted in faster data retrieval, improved accuracy, and impactful business insights.

View Project
Engagement

Efficiently calculate fiscal years with this user-defined SQL function.

Efficiently generate monthly sales reports for any customer with this stored procedure.

Project Details

In this project, I explored the powerful capabilities of SQL, focusing on both fundamental and advanced topics to enhance finance analytics at Atliq Hardware. I implemented essential techniques such as joins and user-defined functions, allowing for tailored data manipulation and analysis. A standout feature of this project was the development of stored procedures, which streamlined repetitive tasks, improved security, and boosted performance through efficient code execution.

By optimizing data retrieval and manipulation processes, I enabled timely insights that drive strategic decision-making and foster business growth. This project not only reflects my technical proficiency in SQL but also my commitment to leveraging data for impactful financial outcomes.