Swaroop Kumar Vathada
Data Analyst / BI Analyst
Visakhapatnam - 530008, Andhra Pradesh, India
+91 9573742803
swaroop.vathada@gmail.com
linkedin.com/in/swaroopkumarvathada
github.com/swaroop456
Data Analyst with 17 months experience at Tata Consultancy Services (TCS), including 1 year as an SAP Analytics Cloud Developer. Skilled in Python, SQL, Power BI, Tableau, and Advanced Excel with hands-on experience in data cleaning, EDA, data modelling, dashboard development, and KPI reporting. Adept at transforming complex datasets into actionable business insights to support data-driven decision-making.
17
Months at TCS
5+
Dashboards Built at TCS
6
Analytics Projects
10+
Tech Skills
Professional Experience
Assistant System Engineer
Tata Consultancy Services (TCS) — Hyderabad, India
SAP Analytics Cloud Developer | LDF Project – German Client | Aug 2024 – Aug 2025
- Worked as an SAP Analytics Cloud Developer on the Ledvance Digital Future (LDF) enterprise analytics project.
- Developed over more than 5 interactive dashboards and KPI tracking reports using SAP Analytics Cloud for business performance monitoring.
- Worked with analysing 5–7 data sets in SAP Analytics Cloud for data transformation and reporting.
- Developed enterprise-level dashboards and analytical reports for business performance monitoring.
- Built and optimized 5–7 data models ensuring high performance and data reliability to 30% more.
- Ensured data accuracy, consistency, and integrity across all reporting layers up to 40% for business outcomes.
- Delivered analytics solutions aligned with cross-functional teams.
Data Analytics Projects
Amazon Orders Data Analytics Project
- Performed end-to-end analysis on Amazon Orders Dataset containing 1,13,698+ records and 29 columns spanning Jan 2022 – Sep 2022 using Python, Excel, MySQL Workbench, and Power BI.
- Executed data cleaning, preprocessing, and exploratory data analysis (EDA) using Pandas, NumPy, Matplotlib, and Seaborn to uncover customer behaviour and sales performance trends.
- Built a 5-page interactive Power BI dashboard and Excel KPI reports analysing revenue, product categories, fulfilment performance, promotions, and geographic sales distribution across India.
- Identified Kurta and Set categories contributing 77% of total orders, while Maharashtra and Karnataka emerged as the highest revenue-generating states.
- Derived actionable business insights revealing promoted orders generate 2.5x higher revenue and expedited shipping contributes nearly 75% of total revenue.
Cafeteria Sales Data Analysis
- Performed end-to-end data cleaning and preprocessing on 10,000+ rows of raw cafeteria transactional sales data using Python and Pandas, ensuring data accuracy and integrity for downstream analysis.
- Conducted Exploratory Data Analysis (EDA) and identified that purchases between 2–7 units are the highest revenue contributors, while high-quantity purchases show reduced revenue efficiency due to bulk discounting behaviour.
- Derived 3 actionable business recommendations — tiered pricing strategy, limiting bulk discounts, and value-based pricing — to optimize revenue margins and improve sustainable sales performance.
Classic Models Database Analysis
- Analysed the Classic Models relational sales database using 10 structured SQL queries to extract actionable business insights across revenue, customers, employees, and supply chain operations.
- Applied advanced SQL operations — JOIN, GROUP BY, aggregate functions (SUM, AVG, COUNT), and date functions to perform multi-dimensional business analysis across 10 analytical problem statements.
- Delivered an executive-level SQL analysis report converting raw transactional data into 10 business insights covering revenue concentration, customer dependency, seasonal trends, and inventory gaps.
Retail Store Sales Analysis
- Performed end-to-end data cleaning on 12,575 rows (2022–2025) — resolved 6,625 blank cell issues across 5 columns, removed duplicates, standardized formats, and added 4 helper columns for time-based analysis.
- Applied 17 Advanced Excel formulas including SUMIFS, XLOOKUP, UNIQUE, SORT, FILTER, LARGE, and Nested IF with Dynamic Arrays — total revenue: $1,552,071, average order value: $129.65.
- Built 4 interactive Pivot Tables with slicers — Butchers as highest revenue category ($208,118), Cash as top payment method ($537,710).
- Performed What-If Analysis using Goal Seek and Scenario Manager — modelled 3 sales performance scenarios (Low: $50, Base: $200, High: $500) for revenue forecasting.
Financial Sales Dashboard
- Imported Microsoft Financial Sample dataset (700 rows, 16 columns) into Power BI Desktop via Excel Workbook connector.
- Built a dedicated _Measures table and developed 6 DAX measures — Total Sales (118.73M), Total Profit (16.89M), Total Units Sold (1.13M), Total COGS (101.83M), Total Discounts (9.21M), Profit Margin % (14.2%).
- Designed a 4-page interactive Financial Sales Dashboard — Financial Overview (executive KPIs), Product featuring 15 visuals.
- Identified Government segment driving 44.22% of total sales (52.5M) and 65.04% of total profit; USA and Canada each contribute 25M in sales as top 2 geographic markets.
- Time intelligence analysis: October 2014 was peak sales month at 12.4M; 2014 significantly outperformed 2013 across all segments.
HR Analytics Dashboard
- Built a comprehensive HR Analytics dashboard in Power BI covering employee metrics, attrition analysis, department performance, and workforce trends.
- Developed 7 DAX measures and 4 interactive dashboard pages published to Power BI Service.
- Designed interactive visuals with slicers, drill-throughs, and cross-filter interactivity for in-depth HR analysis.
Store Sales Dashboard
- Connected and explored raw retail sales dataset of 31,047 records (21 columns, full year Jan–Dec 2022) from Store_data.xlsx using Tableau Desktop Public Edition 2026.1.
- Built 7 interactive chart types — Line Chart revealing March–April 2022 as peak sales months, Horizontal Bar Chart confirming Amazon as top revenue channel, Pie Chart showing 92% order delivery success rate, Top 10 States Bar Charts.
- Created a 5-point Tableau Story — Sales Peaked in March 2022, Amazon is Top Selling Channel.
- Derived 8 key business insights: Amazon leads all 7 sales channels; Maharashtra is #1 state; women are dominant buyer segment; Adult age group contributes highest sales; Set and Kurta are top product categories; 92% of 31,047 orders successfully delivered.
Technical Skills
Programming Languages
Python
SQL
Python Libraries
Pandas
NumPy
Matplotlib
Database & Tools
MySQL
MySQL Workbench
Analytics & BI Tools
SAP Analytics Cloud
Power BI Desktop
Power BI Service
Tableau Desktop
Advanced Excel
Data Analytics
Power Query
DAX
Data Visualization
EDA
Data Cleaning
Data Analysis
Business Intelligence
KPI
Dashboards
Data Modelling
ETL
Core Concepts & Version Control
Data Structures
CRUD Operations
Basic OOP Concepts
Git
GitHub
Education
B.Tech – Mechanical Engineering
Avanthi Institute of Engineering and Technology
July 2019 – April 2023
CGPA: 7.18
Certifications
Exploring SAP Analytics Cloud
Record of Achievement — Issued by SAP
October 2024 | Foundational Level
View Credential
Contact
Location
Visakhapatnam - 530008
Andhra Pradesh, India
Andhra Pradesh, India
Phone
LinkedIn
GitHub
I'm actively looking for Data Analyst / BI Analyst opportunities. Feel free to reach out — I'd love to discuss how I can contribute to your team!