Powered by
Codebasics DA Bootcamp

suraj patil

Data Aspirant

+91 9370025424 [email protected]

Resume

Hello, I am

suraj patil.

1

Excel Project

1

PowerBI Project

About Me

Detail-oriented Data Aspirant with 4+ years of experience in pharmaceutical quality control, skilled in data collection, cleaning, analysis, and reporting. Proficient in Excel, SQL, Power BI, and MySQL, with a strong understanding of compliance documentation and laboratory data management. Adept at transforming raw data into actionable insights to improve processes and ensure regulatory compliance.

Key Skills

Excel

Power BI

SQL

Problem Solving

Presentation Skills

My Projects

My Experience

With over 4 years of experience in Pharmaceutical Quality Control, I utilized Excel to track, analyze, and report quality metrics, thereby improving efficiency in reporting processes.

👉𝗪𝗵𝗮𝘁 𝗶 𝗯𝗿𝗶𝗻𝗴 𝘁𝗼 𝘁𝗵𝗲 𝘁𝗮𝗯𝗹𝗲:

✅ MS Excel – Advanced Excel, Data cleaning, Pivot Table, Pivot Chart, Lookup Functions, Power Query, Excel Functions, Excel dashboard, MIS preparation.

✅ Power BI – Power Bi Desktop, Power Query, Data Modelling, DAX, Power Bi Services, Extract, Transform & Load (ETL), Data Reporting, Data Transformation, Data Visualization, Power Apps.

✅ SQL – SQL Queries, Subqueries, Joins, CTE, Window functions, Aggregate functions, MySQL, SQL Server, Aggregate functions, Data Warehouse Concept.

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/suraj-patil-597748210

+ 91 9370025424

Excel Project

Sales and Financial Analytics

Domain/Function: FMCG

The goal of this project is to deeply understand how the company is doing financially and where it stands in the market. I have created different reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using basic and advanced Excel skills.

Sales and Financial Analytics

The Customer Performance Report reveals the net sales performance of each customer over multiple years.

Sales and Financial Analytics

The Market Performance vs Target report allows stakeholders to evaluate how well the country is doing and compare it against the target.

Project Details

In this project, I've developed a dynamic sales report using Excel pivot tables, offering businesses invaluable insights into customer discounts, negotiation strategies, and untapped markets. These reports provide actionable recommendations, empowering businesses to refine sales tactics, elevate customer experiences, and maximize revenue.

Throughout this journey, I've honed skills in:

1. Pivot tables
2. Power Query
3. Basic DAX functions
4. Effective Conditional Formatting
5. Report Presentation
6. Sales Domain Metrics

The primary goal is to arm businesses with the tools and insights needed to monitor, assess, and optimize their sales efforts. By leveraging data-driven analysis, businesses can uncover opportunities for growth, adapt to market changes, and maintain a competitive edge in an ever-evolving landscape.

PowerBI Project

AtliQ- Business Insights--360

Domain/Function: FMCG

AtliQ Hardware faced challenges managing data within Excel. Objective: Shift from Excel to Power BI for better comprehension. Goal: Achieve insights into finance, sales, and supply chain areas. Data Volume: 1.8 million entries. Tools Used: SQL, Power BI, Excel, DAX Studio.

AtliQ- Business Insights--360

Data Modelling involving 10+ tables

AtliQ- Business Insights--360

Designing a landing page that connects with users, making it an essential part of our dashboard.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic 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