Summary
Overview
Work History
Education
Skills
Accomplishments
Interests
Languages
Certification
Timeline
Hi, I’m

KARTHIK THENTU

Albany,NY

Summary

Experienced Data Analyst with over 7 years of expertise in banking, hospitality, e-commerce, food delivery, supply chain

specialized in delivering impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Python, SQL, and Excel, SPSS, ensuring robust data solutions and strategic recommendations.

Overview

7
years of professional experience
4
Certification

Work History

Bank of America

Data Analyst
02.2024 - Current

Job overview

  • Conducted and summarized complex financial data analyses using SAS, SQL, and Python to optimize loan portfolio performance, analyze credit risk, and support regulatory compliance reporting
  • Developed statistical models in Python and SAS, such as credit risk scoring, loss forecasting, and customer lifetime value (CLV) analysis, providing actionable insights to enhance decision-making for loan approvals, risk mitigation, and investment strategies
  • Leveraged SAS and Tableau to enhance data collection processes and create dashboards, improving insights for strategic initiatives like branch optimization and product development.

Swiggy

Data Analyst (Biz Ops / Customer Exp /Assistant Manager, Supply Chain Management
04.2019 - 02.2022

Job overview

  • Developed demand forecasting models using SQL and Python, incorporating historical sales data, seasonality, and external factors to optimize stock levels across multiple fulfillment centers
  • Analyzed market demand, customer purchase behavior, and geographic trends to identify optimal locations for warehouse pods to support Swiggy Instamart’s expansion
  • Conducted data-driven analysis on delivery performance, warehouse operations, and vendor fulfillment to identify inefficiencies and bottlenecks
  • Developed segment-based trade promotions—aggressive for new restaurants, moderate for top brands, and controlled for already high-performing outlets
  • Assessed how price reductions impacted demand, ensuring the trade-off between margin loss and order volume growth was optimal
  • Created predictive models to determine which trade promotions (flat discounts, cashback, free delivery) would yield the highest revenue impact
  • Used historical data to identify frequently ordered combinations (e.g., McD Fries + Coke) and structured bundled pricing and determined the optimal discount percentage that maximized revenue while ensuring brands retained profitability.
  • Monitored Ad spend efficiency in CPC and ROI, reallocating budgets towards high-performing categories
  • Assessed contribution margins per menu item, identifying high-margin vs
  • Low-margin items and adjusted commission structures based on restaurant size, order volume, and profitability thresholds
  • Established and maintained pricing strategies for restaurant partners, optimizing commission structures and discount frameworks
  • Managed restaurant onboarding, revenue growth, and pricing negotiations to maximize margins while ensuring competitiveness
  • Conducted in-depth economic modeling for pricing adjustments, bundling strategies, and promotional effectiveness, presenting insights to leadership
  • Constructed statistical and financial models using Python and Excel, including time series forecasting, linear regression, and scenario analysis models, to predict business performance and future revenue
  • These models provided key insights to support strategic decisions related to demand forecasting, workforce optimization, and channel management
  • Monitored order fulfillment rates, picking efficiency, and turnaround times, identifying bottlenecks and improving warehouse operational efficiency
  • Worked closely with operations, logistics, and category teams to translate business challenges into data-driven solutions
  • Worked with ERP tools like Oracle to manage procurement, inventory tracking, and warehouse operations
  • Analyzed historical sales data, supplier SLAs, and replenishment cycles to improve forecasting accuracy and reduce supply chain disruptions
  • Developed scalable Excel and Power BI dashboards for real-time performance tracking, revenue forecasting, and pricing decisions
  • Partnered with Sales, Category Management, and Operations to align pricing strategies with business objectives
  • Integrated supplier performance data with warehouse inventory data to optimize procurement cycles, ensuring high availability of high-demand items while minimizing excess stock
  • Defined, tracked, and visualized key performance indicators (KPIs) using Tableau and Power BI to measure business performance, comparing actual data with forecasted values to ensure alignment with business objectives



OYO

Data Analyst
04.2016 - 04.2019

Job overview

  • Developed predictive models using Python and Excel, such as linear regression, time series forecasting, and clustering models, to analyze room occupancy rates and revenue trends, resulting in a 10% increase in occupancy rates by optimizing pricing strategies
  • Mentored junior analysts on technical tools and troubleshooting techniques, improving team efficiency and problem-solving capabilities
  • Managed corporate partnerships, structuring competitive pricing and discount programs to drive corporate bookings and revenue
  • Analyzed competitor pricing and customer demand trends to develop targeted promotions and optimize room rates
  • Led RFP management and contract negotiations for bulk bookings, ensuring profitability while maintaining competitive positioning
  • Oversaw trade spend and rebate programs, ensuring accurate cost tracking and financial reporting
  • Utilized Excel and SQL to analyze booking trends, revenue impact, and customer segmentation, supporting data-driven decision-making
  • Validated and refined predictive models for occupancy rates and revenue projections, applying cross-validation techniques to improve forecast accuracy by 15%, which informed key business strategies
  • Collaborated with IT and operations teams, using SQL and Python, to simulate real-world data scenarios and resolve discrepancies in data flows, ensuring accurate reporting for business performance analysis with defined needs

Education

Loyola University of Chicago

MS from Business Analytics & Supply chain Mgt

University Overview

GPA: 3.75

Andhra Loyola University

MBA from Finance & Marketing

University Overview

GPA: 3.5

SRM University

B.Tech from Electronics Engineering

University Overview

Skills

  • Programming:
  • Python (NumPy, Pandas, Seaborn, Scikit-learn), SQL, R, IBM SPSS, Alteryx, Snowflake, MS SQL
  • Machine Learning: Linear Regression, Logistic Regression, Decision Trees, Random Forest, NLP, Time Series, Clustering (K-means, Hierarchical), Gradient Boost, Statistical Methods
  • Analytics and Networking software: Excel, Tableau, Power BI, Data Visualization, IBM Logic Net, Simio

Accomplishments

Accomplishments

Act like an Owner award:


Recognized for demonstrating exceptional ownership and accountability in driving data-driven decision-making and for leading impactful analyses on discount optimization, spend efficiency, and margin improvement, directly influencing revenue growth and cost savings and for proactively identifying and resolving inefficiencies in pricing strategies, improving restaurant profitability and platform competitiveness.

Interests

  • Avid Reader
  • Exploring famous landmarks, historical sites, and cultural attractions in a new destination
  • Community Cleanup
  • Cooking

Languages

English
Full Professional
Japanese
Limited Working
Hindi
Native or Bilingual
Telugu
Native or Bilingual
Tamil
Limited Working

Certification

  • Tableau Desktop Specialist - Tableau Software.
  • Certified Business Intelligence Professional (CBIP) - Transforming Data With Intelligence (TDWI).
  • Six Sigma Green Belt Certification – American Society for Quality (ASQ).
  • CBAP - Certified Business Analysis Professional

Timeline

Data Analyst
Bank of America
02.2024 - Current
Data Analyst (Biz Ops / Customer Exp /Assistant Manager, Supply Chain Management
Swiggy
04.2019 - 02.2022
Data Analyst
OYO
04.2016 - 04.2019
Andhra Loyola University
MBA from Finance & Marketing
SRM University
B.Tech from Electronics Engineering
Loyola University of Chicago
MS from Business Analytics & Supply chain Mgt
KARTHIK THENTU