AKSHATH SHETTY
BENGALURU URBAN
Summary
Certified Data Analyst (DataMites, Bangalore) with over 10 years of experience in retail analytics, merchandising, and business planning. Skilled in Excel, Power BI, Tableau, SQL, and statistics, with hands-on experience in dashboarding, KPI reporting, and data-driven decision-making. Building on my experience in retail planning and insights, I have transitioned into data analytics to apply deeper analytical, visualization, and problem-solving skills to support strategic business decisions. Experienced in forecasting, inventory optimization, and retail performance analytics, combined with additional exposure to digital analytics tools like GA4, SEO, and campaign performance tracking. Seeking opportunities as a Data Analyst, Business Analyst, or Reporting Analyst.
Overview
12
12
years of professional experience
Work History
Merchandising Planner
Soch Apparels Pvt. Ltd.
03.2023 - 07.2023
- Built assortment strategies based on SKU contribution and store profile
- Managed PO tracking, replenishment, and ideal stock cover
- Analyzed WTD/MTD Sell-Through% and planned replenishment
- Conducted aging analysis and reduced non-moving inventory
- Improved accuracy of inventory visibility using SAP
Regional Merchandising Controller
Reliance Trends
06.2022 - 03.2023
- Oversaw stock allocation, replenishment, and store-category performance
- Monitored KPIs: Sell-Through%, WOC, Stock Turn, Base Stock Variance
- Conducted audits for stock distribution and VM alignment
- Prepared Plan vs Actual performance reports across stores
- Improved fill rate and balanced stock distribution using data insights
Sr. Executive, Planning & Allocation
Aditya Birla Fashion & Retail (ABFRL)
08.2017 - 11.2022
- Supported planning for multiple categories and formats
- Assisted OTB planning, new-season intake, and supply flow
- Automated allocation logic in Symphony to reduce manual errors
- Conducted WTD/MTD/YTD analysis and controlled stock ageing
- Worked closely with finance on budget utilization and inventory control
Sr. Executive, Planning & Allocation
Landmark Group (MAX)
09.2011 - 08.2017
- Managed store-level inventory allocation and seasonal planning
- Monitored sell-through, sales trends, and stock rotation
- Managed OTB budgets and reviewed forecasts
- Ensured balanced inventory across regions and stores
Education
Certified Data Analyst -
DataMites
Bangalore01.2025
Digital Marketing Certification -
Web Marketing Academy
Bangalore01.2024
Bachelor of Computer Applications (BCA) -
EIILM University
Sikkim01.2013
Diploma in Computer Science -
APS College of Engineering
Bangalore01.2004
Skills
- Excel (advanced)
- Power BI
- Tableau
- SQL
- Git
- Power Query
- DAX
- Data cleaning
- Data visualization
- Dashboarding
- KPI reporting
- Trend analysis
- Descriptive stats
- Hypothesis testing
- Correlation
- Regression
- Sales forecasting
- Inventory optimization
- OTB planning
- Merchandising analytics
- Google Analytics (GA4)
- SEO analytics
- Campaign tracking
- sap
- Symphony
- Oracle RMS
- Data storytelling
- Business understanding
- Collaboration
- sql server studio
- MySQL
- Google Ads
- Meta Ads Manager
- WordPress
- VS Code
- Google Sheets
- PowerPoint
Tools Technologies
- Excel (Advanced)
- Power BI
- Tableau
- SQL Server Studio
- MySQL
- Power Query
- DAX
- SAP
- Symphony
- Oracle RMS
- Google Analytics GA4
- Google Ads
- Meta Ads Manager
- WordPress
- VS Code
- Google Sheets
- PowerPoint
Career Transition - Description
Building on a successful decade in Retail Merchandising & Planning, I upskilled in Data Analytics through Data Mites, gaining hands-on experience with real datasets, dashboards, SQL problem-solving, and statistical analysis. My strong business domain understanding now enhances my analytical capabilities in Data Analytics roles.
Data Analytics Projects
- Customer Data Analysis, Power BI, Tableau, Excel, Analysed customer behaviour across 10 malls (01/01/21–12/31/23) to identify trends across demographics, categories, and payment modes., Female customers contributed ~60% of total revenue, Seniors (51+) were the highest spending group, Clothing, Footwear & Technology categories generated 90% of revenue, Recommended steps to enhance category focus & digital payment adoption, Power BI, Tableau, Excel, Visualization, KPI Analysis
- Medical Data History – SQL Case Study, Executed 30+ SQL queries to analyse patient, doctor, and admission records., Identified patient health patterns (Dementia, Epilepsy, repeat admissions), Cleaned allergy fields (standardized NULL → 'NKA'), Combined multiple datasets using joins to build unified entity-level insights, SQL Joins, Aggregations, Data Cleaning, Subqueries
- Supply Chain Analysis, Power BI, Evaluated SKU movement, supplier performance, and logistics efficiency across 100 SKUs and $577K revenue., Skincare contributed 42% revenue, Cosmetics had low fill rate (73%) causing revenue leakage, 17% deliveries delayed; Carrier B performed best, Identified data quality issues affecting stock turnover, Power BI, Supply Chain KPIs, Dashboarding
Languages
- English
- Kannada
- Hindi
- Tulu
Profile Summary - Summary
Certified Data Analyst (DataMites, Bangalore) with 10+ years of experience in retail analytics, merchandising, and business planning. Skilled in Excel, Power BI, Tableau, SQL, and Statistics with hands-on experience in dashboarding, KPI reporting, and data-driven decision-making. Building on my experience in retail planning and insights, I have transitioned into Data Analytics to apply deeper analytical, visualization, and problem-solving skills to support strategic business decisions. Experienced in forecasting, inventory optimization, and retail performance analytics, combined with additional exposure to digital analytics tools like GA4, SEO, and campaign performance tracking. Seeking opportunities as a Data Analyst / Business Analyst / Reporting Analyst.
Hobbies
AI Tools, Chess, Rap Music Production, Video Editing, Writing
Timeline
Merchandising Planner
Soch Apparels Pvt. Ltd.
03.2023 - 07.2023
Regional Merchandising Controller
Reliance Trends
06.2022 - 03.2023
Sr. Executive, Planning & Allocation
Aditya Birla Fashion & Retail (ABFRL)
08.2017 - 11.2022
Sr. Executive, Planning & Allocation
Landmark Group (MAX)
09.2011 - 08.2017
Certified Data Analyst -
DataMites
Digital Marketing Certification -
Web Marketing Academy
Bachelor of Computer Applications (BCA) -
EIILM University
Diploma in Computer Science -
APS College of Engineering