Swarup Sampad Sahoo
Sales Support Management
Bengaluru
Summary
Results-driven Analyst with 3 years of experience leveraging Power BI, Excel, and MySQL to extract insights, optimize business processes, and drive data-informed decision-making. Skilled in data visualization, business intelligence, and statistical analysis. Proven track record of designing interactive dashboards, conducting root cause analysis, and improving KPI metrics. Collaborative team player experienced in translating complex datasets into actionable insights, enhancing operational efficiency, and driving business growth. Passionate about problem-solving and continuous learning in the field of data analytics.
Overview
6
6
years of professional experience
Work History
Sales Support Management
HP India
02.2022 - Current
- Collaborated with cross-functional teams to gather and analyze business requirements, resulting in improved decision-making processes
- Utilized SQL to extract and manipulate data from diverse sources, ensuring data accuracy and integrity
- Developed interactive Power BI dashboards, providing visual representations of key performance indicators (KPIs) for executive stakeholders
- Conducted data-driven analysis to identify trends, patterns, and opportunities for process optimization
- Played a key role in the team for the Analyzing customers’ accounts resulting in improved KPI metrics of the team.
- Enabled data-driven decision making with advanced analytics tools, generating valuable insights for the organization.
- Increased resource efficiency by analyzing detailed business requirements.
Customer Support Executive
Tech Mahindra
05.2019 - 01.2022
- Conducted the Root Cause Analysis of customer issues
- Responded to customer queries and issues with a focus on providing exceptional service within Amazon's customer service environment
- Utilized Excel to organize and analyze customer data, contributing to the resolution of complex issues
- Demonstrated strong problem-solving skills and attention to detail in handling customer escalations
- Collaborated with team members to improve overall customer satisfaction metrics
Education
Bachelor of Technology - Information Technology
KIIT University
Bhubaneshwar 04.2001 -
Skills
- Power BI (By Using DAX ,ETL and data from various sources worked on it and provided data driven conclusions)
- Excel
- SQL (MySQL)
- Communication
- Presentation Skills
- Data Visualization,Data Cleaning
Projects
1. Sales Insights FROM Company requests
Problem Statement -Atliq Hardware, one of the leading computer hardware producers in India with customers
from across the globe, want to get insights on company products sales to make data-informed decisions.
Tools Used - Power Bi, And SQL. Sql is used for the Data Analysis and Power Bi is used for the Demonstration.
of the Charts and for the Visualization purpose.
2. Atiqo Telecom Analysis DashBoard
Problem - Atliqo is a Company which Provides the telecom service to its customers. They thought of
Introduction of 5G. But they later noticed that there is a decrease in the revenue. The management
is keen to compare the performance between these periods and get insights that would enable them to
make informed decisions to recover their active user rate and other key metrics. They also wonder if
they can optimize their internet plans to get more active users
Tools Used - Power Bi for the Data Visualization purpose and For the Analysis.
3. Super Store Sales Analysis, Product Analysis and Shiping Analysis Dashboards.
Problem - A certain superstore wanted to know the Sales, Product and Shipping Analysis for the year 2020 to 2022.So, they wanted the details to be displayed in the visuals.
Tools Used - SQL and excel for the analysis, Power Bi for the Data Visualization.
4. Prepare a new team of T20 world Cup data.
Problem - We have to create a best playing 11 from all the team participated in T20 world Cup which happened in 2022.
Tools Used – We did Web scrapping of Data from Espn website Power Bi for Visualization, Pandas for Data Analysis.
Timeline
Sales Support Management
HP India
02.2022 - Current
Customer Support Executive
Tech Mahindra
05.2019 - 01.2022
Bachelor of Technology - Information Technology
KIIT University
04.2001 -
Similar Profiles
Jai MisraJai Misra
Senior Copywriter at HP IndiaSenior Copywriter at HP India
Imran NagoriImran Nagori
Territory Sales Executive at HP IndiaTerritory Sales Executive at HP India
Abhishek PathakAbhishek Pathak
Regional Training Manager at HP India SalesRegional Training Manager at HP India Sales