Summary
Overview
Work History
Education
Skills
Projects
Websites
Accomplishments
Timeline
Generic
Abhishek Kotipally

Abhishek Kotipally

Hyderabad

Summary

Client-centric and results-oriented Business Analyst with over +9 years of experience in analytics, data visualization, and process automation across e-commerce and service domains. Adept at using emerging technologies to deliver actionable insights that have led to measurable business outcomes—such as a 30% reduction in SLA breaches, 15% increase in operational efficiency, and increase in annual revenue growth through data-driven strategies.

Proven success in engaging with internal and external clients, understanding business needs, and translating them into scalable analytical solutions. Experienced in leading cross-functional teams and collaborating with stakeholders to design dashboards, automate reporting, and optimize decision-making processes. Currently transitioning from operations and entrepreneurship into a full-time analytics role, with a strong focus on consumer insights, stakeholder alignment, and data-backed business transformation.

Overview

10
10
years of professional experience

Work History

Freelance

Zetabyte
09.2023 - Current
  • Analyzed customer trends & restaurant performance to recommend growth strategies for Zomato. Implemented Advanced Excel-based reporting system to track operational KPIs.
  • Developed a SQL-based farm yield tracking system, increasing productivity by 15% through geospatial analysis.
  • Achieved a 95% Airbnb occupancy rate using dynamic pricing models in SQL and Excel.
  • Analyzed and detected Salary differences and attrition rates - Hero Fincorp Data Analysis Project
  • Prepared and published performance optimized dashboard for Techsphere using PowerBI

Manager – Data Analytics

Amazon
03.2022 - 04.2023
  • Automated ticketing workflows using SQL and ETL, achieving 30% reduction in invalid tickets.
  • Designed SLA compliance dashboards, resulting in 25% decrease in SLA breaches.
  • Led 20-member team, leveraging data insights for performance coaching and KPI tracking.
  • Implemented training programs, enhancing process accuracy and quality of handling by 20% in multiple domains.
  • Engaged with stakeholders to drive strategic initiatives and optimize operational efficiency.

Technical Team Lead

Amazon
02.2017 - 01.2022
  • Applied SQL and Lean Six Sigma principles to enhance supply chain efficiency, achieving a 30% reduction in turnaround time.
  • Developed real-time dashboards to enhance vendor compliance by 100%.
  • Conducted training on BI tools, boosting team-wide data literacy and engagement.
  • Led audits to strengthen process quality, decreasing audit coaching opportunities from 27% to 8%.
  • Collaborated with program managers on pricing strategies, improving product performance and sales.

Associate

Amazon
06.2015 - 02.2017
  • Managed vendor accounts, enhancing performance on Vendor Central Dashboard through tailored strategy implementation.
  • Educated vendors on chargeback avoidance and fulfillment optimization, leading to improved operational efficiency.
  • Served as primary contact for Electronic Data Interchange, automating supply chain processes efficiently.
  • Trained and mentored teams, successfully promoting over 5 members to leadership roles.
  • Analyzed data trends to provide actionable insights, contributing to increased order volumes and revenue growth.

Education

Business Analytics & Data Science -

HeroVired
05.2025

Lean Six Sigma Green Belt - undefined

Amazon
01.2023

PG Diploma in Business Management - undefined

Prof. G Ram Reddy Centre for Distance Education
01.2020

B.Tech - Electronics & Communications

Jawaharlal Nehru Technological University
Hyderabad, India
03-2015

Skills

  • Power BI
  • Excel
  • SQL
  • Python
  • Pandas
  • ETL Processes
  • Data Cleaning
  • Data Wrangling
  • Predictive Analytics
  • GitHub
  • Stakeholder Management
  • Leadership

Projects

  • Retail Data Analysis with Python & Power BI, Developed Python-based predictive models for sales forecasting., Created interactive Power BI dashboards to track customer purchasing behavior.
  • Zomato Restaurant Insights – Excel & SQL, Analyzed customer trends & restaurant performance to recommend growth strategies., Implemented SQL-based reporting system to track operational KPIs.
  • Amazon PO Management Ticketing System – SQL & BI, Reduced invalid PO tickets to zero, ensuring 100% compliance across vendor networks., Designed BI dashboards for real-time tracking of vendor escalations.

Accomplishments

  • Reduced Potential Coaching Opportunity in audits from 27% to 8%.
  • Awarded Best Advisor of the Quarter – Peak 2018 at Amazon.
  • Improved farm operations efficiency, increasing crop yield by 15%.
  • Established an Airbnb business with 90% occupancy rate using BI-based pricing models.
  • Successfully closed PO Management Project, bringing invalid Purchase Order tickets to zero.

Timeline

Freelance

Zetabyte
09.2023 - Current

Manager – Data Analytics

Amazon
03.2022 - 04.2023

Technical Team Lead

Amazon
02.2017 - 01.2022

Associate

Amazon
06.2015 - 02.2017

Lean Six Sigma Green Belt - undefined

Amazon

PG Diploma in Business Management - undefined

Prof. G Ram Reddy Centre for Distance Education

Business Analytics & Data Science -

HeroVired

B.Tech - Electronics & Communications

Jawaharlal Nehru Technological University
Abhishek Kotipally