Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Certificates

Contact

Hello, I am

Sumitra Adhya

Senior Engineer
Resume
Sumitra Adhya

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About

Me

I am an Ex-Senior Engineer at Ericsson Global Service Pvt. Ltd. I worked as a data analyst (business analyst) in the Telecom and Finance domain. I Have Tool experience in Microsoft Office Suite, Power BI, SQL, and Python. I have experience extracting insights and making data-driven decisions.
Specialize in transforming data into actionable insights that drive business results. My work in the industry has enhanced operational efficiencies, leading to measurable improvements in performance and decision-making.

Key

Skills

SQL

Python

Stakeholder Management

DAX

Data Analysis

Data visualization

communication

Power Query

Power BI

Advance Excel

My

Projects

Excel: Sales & Finance Analytics
Excel: Sales & Finance Analytics

Domain/Function: Brick & Mortar Business

Analyzed extensive datasets, extracting insights with Excel for informed decision-making. Leveraged ETL processes and Excel's Power Query/Pivot for efficient data handling. Produced impactful sales and financial reports guiding strategic decisions.

Business Insights 360
Business Insights 360

Domain/Function: Brick & Mortar & e-commerce

Developed an advanced Power BI dashboard for AtliQ Hardware, providing in-depth analytics and actionable insights across finance, sales, marketing, and supply chain functions, driving informed decision-making and fostering organizational growth.

Hospitality Analysis
Hospitality Analysis

Domain/Function: Hospitality Industry

Atliq Grands are losing its market share and revenue in the luxury/business hotels category. To regain their market share managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence”.

Consumer Goods Analysis
Consumer Goods Analysis

Domain/Function: Brick & Mortar & e-commerce

The management of Atliq Hardware wanted to get enough insights to make quick and smart data-driven decisions while expanding their business effectively.

The Oberoi Hospitality Analysis
The Oberoi Hospitality Analysis

Domain/Function: Hospitality Industry

The Oberoi are losing its market share and revenue in the luxury/business hotels category.
To regain their market share and revenue will use business Intelligence.

My

Experience

·       Expertise in Pivot Table, Formulas, Power Pivot, Power BI, Power Query, DAX. Hands on experience in Data Cleaning, Data Modelling and Python for data analytics. Knowledge about basic probability statistics and hypothesis testing.

·       Data extraction & cleaning, ETL process, exploratory data analysis, database management, dashboard and reporting using power BI.

·       Expertise in working with Power BI Service and Power BI Desktop, especially in developing reports and dashboards using Microsoft Power BI.

·       Proficient in using DAX for making Dashboard in Power BI.

·       Developed SQL Queries to implement complex aggregation logic and transformation of data.

·       Possesses extensive analytical and problem-solving skills, strong attention to detail, and a significant ability to work in a team environment.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

CB Cert

Python: Beginner to Advanced For Data Professionals

SQL Advanced

SQL Advanced

SQL Intermediate

SQL Intermediate