Upendra Venkatesh Siddala

About Upendra Venkatesh Siddala

Business analyst | Supply Chain Analyst | Procurement & Purchase Analyst | Data Analytics & Automation Engineer Power BI | SQL | Excel VBA | Python (Selenium)| Oracle Cloud | Process AutomationI’m a results-driven supply chain and procurement professional with a passion for process optimization, data-driven decision-making, and automation. I bring a unique blend of operational experience and technical expertise, which has helped streamline procurement workflows, reduce cycle times, and improve supply chain performance. My core capabilities include:Data Analysis & Visualization:Proficient in writing SQL scripts to extract, clean, and manipulate data from multiple sources. I use Microsoft Power BI to build interactive dashboards that provide real-time insights into procurement KPIs, supplier performance, and purchasing trends.Automation & Efficiency:Automated several key procurement and planning processes using Excel VBA and Python (Selenium), cutting manual effort by over 70%. Developed consolidated macros for multi-workbook analysis and daily reporting, saving valuable time and reducing human error.Strategic Procurement Support:Assisted in implementing procurement strategies focused on cost savings, vendor performance, and supply continuity. Generated detailed reports on spend analysis, delivery trends, and price breaks to support sourcing managers in decision-making and negotiations.Oracle Cloud Integration:Created macros for Quotation Uploads in Oracle Cloud and automated RFQ follow-ups, reducing turnaround time by 80%. Supported change management initiatives to improve quotation accuracy and pricing workflows.Process Improvement & Collaboration:Worked closely with cross-functional teams to identify bottlenecks, improve inventory control, and manage shortage allocations. Led a procurement team of 4 members to enhance supplier communication and reduce delays in order fulfillment. I also built a unified email automation system to send Open Order Reports (OORs), Purchase Orders (POs), and follow-up emails, improving turnaround time and accountability. I thrive in environments where technology meets operations and continuously seek opportunities to improve processes through automation, analytics, and strategic insight. I am passionate about enabling organizations to make smarter, faster, and data-informed decisions.Let’s connect if you’re exploring opportunities in supply chain analytics, procurement transformation, or process automation.

Experience

1. Operational Business Analyst

   Optimas Solutions

   Dec 2025 — Present · IN

   Analyze and evaluate existing business processes to identify inefficiencies and areas for improvement.Monitor and report on the performance of implemented improvements to ensure sustained success.Collaborate with cross-functional teams to gather and analyze data and develop actionable insights.Conduct root cause analysis to address operational issues and implement corrective actions.Assist in the development and maintenance of key performance indicators (KPIs) to measure process effectiveness.Support the continuous improvement culture by promoting innovation and a problem-solving mindset across the organization.Designed end-to-end freight analytics dashboards (lane, carrier, mode mix) improving spend visibility across multi-carrier network. Identified ~₹1.2 lakh/month optimization opportunities through detailed freight cost and SLA performance analysis. Developed Billed vs Expected freight variance controls preventing in overbilling. Automated FedEx invoice data cleanup reducing 90% manual effort (~25 hrs/month saved). Reduced daily reporting time from 4 hours to 20 minutes via VBA automation pipelines (~72 hrs/month productivity gain). Improved shipment data accuracy to 99% by implementing validation rules and automated exception logging. Eliminated 120+ manual ERP updates per month through NetSuite–TMS workflow synchronization automation. Conducted RCA for SLA breaches and shipment delays; implemented KPI governance cadence across Logistics & Finance teams.

Education

• Sri Venkateswara College of Engineering And Technology, Nh-5, Etcherla, PIN-532402 (CC-MT)

  Bachelor of Technology, Mechanical Engineering

  2017 — 2021