Mahesh Katula

Transforming Data Into
Strategic Impact

View Work

About Me

I am a data enthusiast adept at transforming complex datasets into actionable insights. With a proven track record at Amazon in fraud prevention analytics, I specialize in identifying trends that drive innovation.

My tech stack bridges the gap between raw data and strategic decision-making, utilizing Advanced SQL, Power BI, and AI-driven automation to solve high-stakes business problems.

3+
Major Projects
8.48
CGPA
Amazon
Ex-Associate

Featured Projects

Logistics Optimization

Engineered a scalable SQL analytics framework to diagnose supply chain inefficiencies. implemented Recursive CTEs, Subqueries, and Window Functions to analyze delivery latency across diverse routes.

"The solution identified critical bottlenecks, enabling a data-driven logistics optimization strategy."
SQLCTEsWinFuncJoins
View Code

Retail Customer Retention

Architected an end-to-end predictive analytics dashboard to combat customer churn. Constructed a robust Star Schema data model and utilized Advanced DAX to quantify Customer Lifetime Value (CLV).

"Identified churn reasons, segmented at-risk demographics and provided actionable recommendation to improve loyalty and retention."
Power BIDAXPower QueryData Modeling
View Code

Social Media Analytics

Developed an automated Social Media Intelligence tool using Advanced Excel Functions (XLOOKUP, Array Formulas, etc) and Interactive Pivot Charts. Streamlined the ETL process for raw engagement metrics.

"Provided real-time visibility into campaign performance and impact, data driven strategic insights and recommendations on platform ROI, content strategy an hashtag optimization."
ExcelAutomationPivot TablesData Cleaning
View Code

Professional Journey

Jan 2024 - May 2024

CAP Associate

Amazon, Virtual
  • Worked in a highly confidential environment to help minimize the abuse of Amazon's policies.
  • Leveraged proprietary research and analytics to identify and address potential instances of concession misuse within the Indian marketplace.
  • Maintained strict confidentiality regarding sensitive information and internal processes, in accordance with company policies.
  • Contributed to loss prevention efforts by demonstrating strong analytical, problem-solving, and decision-making skills to effectively mitigate concession abuse.
Oct 2023 - Dec 2023

D2AS Associate

Amazon, Virtual
  • Provided comprehensive technical support and troubleshooting for a wide range of digital devices and Alexa-enabled smart home products in the North American marketplace.
  • Contributed to enhancing customer satisfaction and brand loyalty through effective communication and timely issue resolution.

Let's Collaborate

Ready to transform your data into a strategic asset? I'm available for full-time roles and freelance projects.

© 2025 Mahesh Katula. All Rights Reserved.