Tejesh Kumar Rankireddy

Texas,TX

Summary

Supply Chain Analyst with extensive experience in leveraging advanced analytics, ERP systems, and automation tools to optimize end-to-end supply chain operations. Skilled in building predictive models using Python, streamlining procurement workflows in SAP ERP, and designing KPI-rich dashboards in Power BI and Tableau. Proven track record in reducing planning errors, transportation costs, and excess inventory using tools such as Logility, Oracle TMS, Llamasoft, and Coupa. Adept at enhancing material planning accuracy with SAP IBP, integrating WMS systems for real-time visibility, and automating reporting processes with Power Automate. Certified Lean Six Sigma Green Belt with strong data-driven decision-making skills to improve operational agility, vendor performance, and fulfillment efficiency across global supply networks.

Overview

years of professional experience

Certificate

Work History

Data Analyst

Motiva Enterprises LLC

07.2023 - Current

Developed Python-based predictive analytics models for 12 product datasets, improving forecast accuracy and reducing data-driven planning errors by 44%.
Designed and deployed interactive Power BI dashboards integrating ERP and WMS datasets, reducing reporting cycle time by 58% and enabling faster executive decision-making.
Performed data analysis and optimization modeling on transportation datasets using Oracle TMS data, identifying cost-saving opportunities and reducing logistics expenses by 33%.
Conducted vendor performance and sourcing analytics using Coupa data, improving supplier evaluation efficiency by 49% through data-driven insights.
Automated data workflows and reporting pipelines within SAP ERP, improving operational productivity by 52% and minimizing manual data-entry errors.
Analyzed inventory datasets using Logility planning data to identify trends and inefficiencies, reducing excess inventory by 40% and improving turnover metrics.
Built distribution and network simulation models in Llamasoft to evaluate logistics scenarios, improving execution speed by 35% and reducing lead-time variability.
Created Tableau dashboards for demand and trend analysis, improving response time to demand fluctuations by 46%.
Automated procurement data tracking using Power Automate, reducing manual reporting effort by 61% and enhancing real-time data visibility.
Led data integration and validation initiatives between ERP and WMS systems, improving data accuracy to 96% and enabling 32% faster warehouse fulfillment analytics.

Supply Chain Analyst

Stovekraft Limited

06.2020 - 10.2022

Built real-time inventory dashboards in Tableau, improving turnover visibility by 54% and reducing aging stock by 31%.
Automated procurement workflows in SAP ERP, reducing PO processing time by 42%.
Applied Logility to streamline replenishment, cutting overstock management costs by 37%.
Automated dispatch reporting in Power Automate, reducing manual errors by 48% and speeding decision cycles.
Designed Coupa-based vendor performance reports, increasing supplier efficiency by 45%.
Analyzed market trends and leveraged SAP IBP for demand forecasting, resulting in a 41% increase in planning accuracy.
Developed and implemented regional network models in Llamasoft to minimize last-mile delivery expenses.
Enhanced planning agility by 63% via KPI dashboards in Power BI.
Built Python demand deviation analytics, improving planning cycle accuracy by 39%.
Integrated ERP with WMS tools, improving warehouse utilization and accuracy by 35%.
Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.

Education

Master of Science - Management information system

Lamar University

Texas

01.2024

Skills

ERP/MRP Systems: SAP, Oracle, Microsoft Dynamics

Supply Chain Management Software: SAP, TMS, WMS

Forecasting & Demand Planning: SAP IBP, Excel-based models

Data Analytics & Statistical Tools: Power BI, Excel, SQL

Business Intelligence & Data Visualization: Power BI, Tableau, Excel

Planning Metrics Monitoring & KPI Improvement

Inventory Management & Optimization: EOQ, Reorder Point, ABC Analysis

Supply Chain Optimization Techniques

SQL (Queries)

Python

Lean Six Sigma Tools: DMAIC, VSM

Logistics & Distribution

Process Improvement

Excel (Advanced Functions & Pivot Tables)

Microsoft Office Suite: Excel, Word, PowerPoint

Cross-Functional Collaboration & Communication

Certification

Six Sigma: Green Belt
Learning SAP MM (Materials Management)
SQL Essential Training
Demand Planning Professional Certificate

Timeline