Sumit Samantray

Data Enthusiast

[email protected] +91 7503885223

Resume

Hello, I am

Sumit Samantray.

3

PowerBI
Projects

2

Python
Projects

1

Excel
Project

About Me

Hi, I’m Sumit Samantray, a recent postgraduate from DIT University in Dehradun with a specialization in Computer Applications and a focus on data science. My career started in sales and marketing, working with companies like Google and Samsung, but my passion for data led me to pursue analytics.

With skills in Excel, SQL, Python, and Power BI, I enjoy turning numbers into stories, uncovering insights, and driving data-driven decisions. I believe in continuous learning and staying adaptable in the fast-evolving world of analytics.

Beyond data, I’m a travel enthusiast and photographer, capturing the essence of each destination I visit. I combine my love for storytelling with analytical skills to offer fresh perspectives in problem-solving.

Key Skills

MS Excel

PowerBI

Tableau

SQL

Python

Storytelling

My Projects

Business Insight 360

Domain/Function: Brick & Mortar and E-commerce

Hospitality Analysis

Domain/Function: Hospitality

Patients Emergency Room Visit Report

Domain/Function: Health Care

AtliQ Hotels Report

Domain/Function: Hospitality

Diwali Sales Trends

Domain/Function: Sales

Finance and Sales Analysis

Domain/Function: Finance and Sales

My Experience

I'm Sumit Samantray, and information is my favourite! I'm a recent postgraduate from DIT University in Dehradun, specialising in Computer Applications with a focus on data science.

My journey began in the fast-paced world of sales and marketing, where I had the privilege of working with industry giants like Google and Samsung for over five years. The thrill of closing deals was exciting, but my analytical side craved more, which led me to dive deeper into the world of data analytics. Numbers have always fascinated me—not as mere figures but as stories waiting to be discovered and told.

Throughout my academic and professional journey, I’ve honed skills in Excel, Business Mathematics, SQL, Python, and Power BI. These tools have been instrumental in my ability to dissect complex data, uncover hidden insights, and drive business decisions. One of the key lessons learned during my journey is the importance of continuous learning and adaptability, especially in the ever-evolving field of data analytics.

I aim to leverage these skills to contribute to data-driven decision-making processes and continually grow as a data analyst by staying at the forefront of industry trends. My interests extend beyond data—I'm passionate about photography and travel, which provide me with a creative outlet and a fresh perspective on problem-solving. When I'm not immersed in data, I channel my storytelling skills through another medium: photography. Travelling to new places fuels my creativity, allowing me to capture the essence of each destination. I like to think of myself as an information expert with an explorer's spirit or a travel photographer with a knack for numbers. I'm a curious learner, passionate analyst, and storyteller, eager to bring my unique blend of skills, experiences, and interests to your team.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Google | Foundation of Business Intelligence

Google | Foundation Data

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/sumit-samantray/

Call Me

+91 7503885223

GitHub

https://github.com/sumitsamantray

PowerBI Project

Business Insight 360

Domain/Function: Brick & Mortar and E-commerce

AtliQ Hardware, a rapidly growing company, is implementing Power BI for data analytics to gain a competitive edge and make informed, data-driven decisions. The project aims to address stakeholder questions across finance, sales, marketing, and supply chain, enhancing overall business performance.

View Project
Engagement

View Project
on GitHUB

Get a P&L(profit and loss) Statement for any customer/product/country or aggregation of the above over any period and more

Analyze the performance of your customers over key metrics like net sales, and gross margin and view the same in the profitability/growth matrix.

Project Details

AltiQ Hardware is a company which has grown vastly in recent years, and opened business all over the globe. It is a company which sells, computers and computer accessories through three mediums/channel

● Retailers
● Direct
● Distributors Recently the company has faced an unforeseen loss by opening a store in America based on surveys, intuition and some Excel analysis also the company’s competitors have a handful of analytics teams to perform analysis and make data-driven decisions. So, the AltiQ hardware has no other option other than building its analytics team for data-driven insights and decisions in the future to survive better in the industry.

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

Domain/Function: Hospitality

Atliq Grands, a 20-year veteran in the luxury hotel industry, is losing market share and revenue due to competitors' strategies and poor decision-making.

View Project
on GitHUB

Mumbai leads in revenue generation with ₹669 million, followed by Bangalore, Hyderabad, and Delhi. Among AtliQ's seven property types, AtliQ Exotica

Week 24 saw the highest revenue of ₹139.6 million. Delhi leads in both occupancy and rating, followed by Hyderabad, Mumbai, and others.

Project Details

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective management decision-making, Atliq Grands is losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue. However, they do not have an in-house data analytics team to provide these insights.

Live Interactive Dashboard

PowerBI Project

Patients Emergency Room Visit Report

Domain/Function: Health Care

Key insights from ER visit data include reducing wait times, optimizing staffing, analyzing demographics, monitoring admissions, managing costs, and addressing frequent visitors to enhance patient care and resource efficiency.

View Project
Engagement

View Project
on GitHUB

Key insights from ER visit data include reducing wait times, optimizing staffing, analyzing demographics, monitoring admissions, managing costs, and a

Project Details

Key insights from ER visit data aim to enhance patient care and optimize resources. Reducing wait times improves satisfaction, while identifying common visit reasons aids resource allocation. Optimizing staffing during peak hours ensures efficiency, and analyzing visits by age and gender enables targeted interventions. Monitoring admission rates signals case severity, while tracking outcomes provides insights into care effectiveness. Managing costs per visit supports financial planning, and addressing frequent visitors through improved access to primary care enhances experiences. These insights collectively drive better patient care and efficient ER management! 💡

Live Interactive Dashboard

Python Project

AtliQ Hotels Report

Domain/Function: Hospitality

AtliQ Grands, a leader in the hospitality industry for 20 years, owns multiple five-star hotels across India, delivering luxury experiences and top-tier services to their guests.

View Project
on GitHUB

View Project
on Google Collab | Jupyter Notebook

“Business and Data Intelligence” to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them w

Project Details

AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands is losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.

Python Project

Diwali Sales Trends

Domain/Function: Sales

View Project
on GitHUB

View Project
on Google Collab | Jupyter NoteBook

Data Cleaning and Manipulation: A meticulous process of data refinement sets the stage for meaningful analysis.

Exploratory Data Analysis (EDA): Employing the prowess of Pandas, NumPy, Matplotlib, and Seaborn, we unearth hidden patterns and trends.

Project Details

Welcome to the Diwali Sales Analysis Using Python project! In the realm of data science, Exploratory Data Analysis (EDA) stands as a pivotal element, often dictating the trajectory of analysis. This repository serves as an illustrative guide to the techniques and methodologies employed in EDA, powered by Python.

The focal point of this project revolves around the Diwali Sales dataset, sourced from Kaggle. This dataset serves as an ideal playground for delving into EDA, a crucial step toward unlocking the fascinating domain of data science.

Excel Project

Finance and Sales Analysis

Domain/Function: Finance and Sales

In this project, I've crafted a sales report using Excel's powerful pivot tables. This report empowers businesses to optimize customer discounts, streamline negotiations, and identify growth opportunities in new markets.

View Project
on GitHUB

View Project
on Sales & Finance Report

Embark on an exciting journey through over 500,000 sales records, analyzing AtliQ Hardware's financial health and market position using advanced Excel

Project Details

Embark on an exciting journey through over 500,000 sales records, analyzing AtliQ Hardware's financial health and market position using advanced Excel tools. Discover key insights such as "Customer Net Sales Performance" and "Market Performance vs. Target" to drive smarter business decisions.