Jaswanthika Kattekota

About Jaswanthika Kattekota

I help businesses make smarter decisions using data. With a Master’s degree in Information Systems (graduating Spring 2025) and over 2 years of industry experience, I specialize in analyzing data, building reports, and creating dashboards that simplify complex information. I’ve worked with SQL, Power BI, Excel, and Tableau to automate processes, reduce manual work, and support data-driven planning. In my previous roles, I’ve automated business intelligence reports, reducing manual reporting time by 40%, and created data validation scripts that improved accuracy by 30%. I’ve worked with SQL, Power BI, Tableau, Excel, and Python to analyze sales performance, track KPIs, and design dashboards that make data accessible and actionable for cross-functional teams. One of my proudest contributions was initiating a reporting automation project that eliminated repetitive manual work for the operations team—freeing them up to focus on higher-impact tasks. I collaborated across departments to understand reporting needs, built scalable data models, and delivered a self-service dashboard that leadership continues to use for strategic planning. I don’t just work with data—I find the story behind it. Whether I’m identifying trends in customer behavior or supporting market performance reviews, I focus on delivering clarity and value through clean, reliable, and insightful analytics. Here’s what I bring to the table: Strong analytical and problem-solving mindset Technical proficiency with data tools and reporting platforms 🤝 Experience collaborating with stakeholders to turn business needs into data-driven strategies Initiative and ownership—always looking for opportunities to improve systems and add value My goal? To always turn noise into clarity. Skilled in: Data Analysis | Business Analysis | Business Intelligence | Reporting Automation Tools I use: SQL | Power BI | Tableau | Excel | Python Master’s in Information Systems, Cleveland State University (Spring 2025) Let’s connect—I’m always open to roles in data, analytics, and insights that create real impact.

Experience

1. Supply Chain Analyst

   PepsiCo

   Jan 2025 — Present · OH, US

   Elevated forecast accuracy 18% using Python and R, reducing stockouts 12% and preventing $2M lost sales, while ensuring better replenishment planning across North American distribution networks.• Minimized annual carrying costs $3.2M by optimizing inventory allocation through SAP MM/PP and Manhattan WMS, lowering excess stock levels 15% and increasing working capital efficiency enterprise-wide.• Expanded inventory turns 20% by aligning safety stock policies with demand variability across multiple regions, reducing obsolete inventory and improving responsiveness to market fluctuations.• Cut transportation costs 9% by analyzing freight data, optimizing lane assignments, and implementing carrier consolidation strategies, strengthening logistics efficiency across regional distribution channels.• Shortened order cycle times 10% by creating Tableau dashboards tracking fulfillment rates, delivery performance, and supplier lead times, improving operational visibility for procurement and logistics leadership.• Digitized ETL pipelines with Alteryx, cutting reporting time 40% and reducing errors 25%, while enabling consistent real-time reporting for procurement, manufacturing, and distribution teams.• Enhanced supplier collaboration by integrating KPI dashboards in Power BI, improving supplier visibility and accountability, and enabling procurement leaders to strengthen contract negotiations and delivery commitments.• Supported ESG compliance initiatives by implementing waste reduction tracking and aligning supply chain metrics with sustainability goals, enhancing reporting accuracy and corporate compliance readiness.

Education

• Cleveland State University

  Master's degree

  2023 — 2025