Portfolio - Sajal Gupta

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About

Data Analyst proficient in extracting valuable insights through the adept use of Advanced Excel, Power BI, SQL, and Python. Despite holding both a bachelor's and master's degree in computer science and technology, my intrinsic aptitude led me to specialize in data analysis.
While my professional tenure may be in its nascent stage, my portfolio stands testament to my proficiency. It showcases a collection of meticulously executed business projects, underscoring my ability to synthesize complex data into actionable intelligence. My academic background, coupled with practical experience, positions me as a formidable candidate.
I am eager to contribute my analytical skills to a dynamic team, offering a harmonious blend of theoretical knowledge and hands-on expertise. Please explore my portfolio for a detailed insight into my capabilities. I look forward to the opportunity to discuss how I can bring value to your organization.

Key

Skills

SQL

Python

Stakeholder Management

Effective Communication

Problem solving

PowerBI

Excel

My

Projects

Sales Analytics(FMCG)

Prepare comprehensive reports for the sales team that will assist them in assessing customer performance and gaining insights into market dynamics relative to their targets.

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

I'm helping AtliQ Hardwares, a tech company, grow faster. They're falling behind because they don't use data well. I plan to fix that by setting up a smart analytics system using Power BI. This will help them understand things better and make smarter choices.

Business Insights for AtilQ Hospitality Domain

"AtliQ Grands, a leading hospitality chain, faces market challenges. To regain lost market share, they seek a strategic edge. Our project aims to infuse 'Business and Data Intelligence,' enabling informed decision-making.

Consumer Good Ad_Hoc_Insights

Delivered key insights through analysis, addressing 10 ad hoc requests, contributing to strategic decisionmaking for stakeholders.

Transitioned from Excel to SQL, optimizing efficiency and reducing analysis time by 60-70%.

Waste Water Management

The wastewater management project monitors and optimizes treatment and disposal across multiple U.S. plants, ensuring efficient wastewater treatment from various sources.

My

Experience

Hospitality Analysis- Hotel Chain Business [Power BI | Excel | SQL]

Led the development of a Power BI dashboard to analysed 3 months of data for AtliQ Grands, enabling the Revenue team to pinpoint a loss in Earnings.
Provided actionable insights through data analysis, empowering AtliQ Grands to strategize and regain a targeted 20% Gross income increase within the next month.
Contributed to the diagnosis of market share and revenue decline for AtliQ Grands, resulting in the implementation of targeted strategies to reverse the trend and drive business growth.

Business Insights 360 - [Power BI | Excel | SQL | Python]
Developed a comprehensive Power BI dashboard integrating trade data from diverse sources, including Excel/CSV files and a SQL database, and utilized DAX Studio for optimization. Additionally, implemented Python scripts to automate data extraction and cleansing processes, enhancing the overall efficiency.
Achieved a 5% performance enhancement through the implementation of DAX Studio, while projecting a significant 12% revenue growth and 20% reduction in data-related expenses. The integration of Python further streamlined data processing, reducing manual intervention and improving accuracy.