Supply Chain Power Bi

Ramesh Pedada

+1-716-***-**** ***********@*****.*** NY Open to relocation

PROFESSIONAL SUMMARY

• Experienced supply chain professional with 4 years of expertise in demand planning, cost reduction, production planning, and process optimization, as well as proficiency in SAP ERP systems and Microsoft Office tools.

• Skilled in leveraging ERP tools for efficient material management, procurement, and inventory planning, ensuring data accuracy, integration, and real-time reporting.

• Utilized advanced forecasting models, reducing stockouts and improving inventory turnover. Also proficient in tools such as SAP IBP and Forecast Pro for predictive analytics

• Experienced Procurement Analyst skilled in vendor contract management, negotiations, and logistics operations.

• Proficient in conducting RFPs, managing purchase orders, and ensuring timely vendor deliveries.

• Expertise in Excel with advanced functions (VLOOKUP, PivotTables, Macros) and Power BI for creating dynamic reports and dashboards, delivering key insights to drive business decisions

• Identified and implemented process improvement initiatives using Lean principles like Kanban and 5S, resulting in an increase in operational efficiency and improvement in customer satisfaction

• Streamlined inventory control through Lean and Just-In-Time (JIT) methodologies, reducing waste and storage costs while ensuring materials were available to meet production schedules

• Implemented MRP solutions to improve material planning efficiency, reducing operational inefficiencies and supplier lead times

• Collaborated with vendors to optimize contracts, reduce costs drastically annually through improved transportation routes, and ensure reliable, on-time deliveries.

• Implemented Lean manufacturing techniques such as Kaizen and root cause analysis, reducing production defects and enhancing product quality

• Engaged in Collaborative Planning, Forecasting, and Replenishment (CPFR) with suppliers and stakeholders to improve forecast accuracy and align production with market demand

• Proficient in presenting complex supply chain data using Power BI and Tableau, enabling data-driven decision- making through visually intuitive dashboards.

• Developed and monitored KPIs within SAP and Power BI, enhancing operational oversight and supporting strategic decision-making

• Regularly reviewed and refined supply chain processes, achieving a significant reduction in costs and improvement in service levels through the application of Six Sigma methodologies (Green Belt Certified)

• Trained and mentored new hires and served as a Subject Matter Expert (SME) on supply chain operations, improving team performance and knowledge retention

TECHNICAL SKILLS

• ERP Systems: SAP (WM, MM, PP, IBP), Oracle ERP, SAP Business One

• Data Analytics & Visualization: Power BI, Tableau, Excel (VLOOKUP, PivotTables, Macros), DAX

• Forecasting & Inventory Management: SAP IBP, Forecast Pro, Just-In-Time (JIT), Kanban, Lean

• Process Improvement & Lean Manufacturing: Lean Six Sigma (Kaizen, 5S, Green Belt), Time and Motion Studies

• Automation & AI: AI-based analytics, ERP automation tool

• Vendor & Supplier Management: MRP solutions, vendor evaluation, contract negotiation

• Programming & Data Science: Python, R

• KPI Management: SAP, Power BI, Excel (Macros, DAX) PROFESSIONAL EXPERIENCE

Research Assistant – Binghamton University, NY March 2022 – present

• Working on a project to optimize patient flow and resource allocation in healthcare facilities, applying Lean Six Sigma techniques to reduce waiting times and improve service delivery in clinical settings.

• Using data analysis in Python and discrete event simulation in Arena to model patient flow and identify bottlenecks, contributing to enhanced efficiency in hospital operations and patient care outcomes.

• Compiling insights into a comprehensive report and assisting in presentations for healthcare stakeholders, providing data-driven recommendations that align with the industry’s best practices in healthcare and industrial engineering. Analyst - Amazon, India September 2021 – July 2022

• Collaborated on process improvement initiatives to enhance efficiency and accuracy in supply chain operations using value stream mapping.

• Utilized advanced data visualization tools to create dynamic charts, graphs, and diagrams that visually represented workflow processes for Amazon stores, resulting in a 15% improvement in operational efficiency.

• Analyzed data sets and provided strategic recommendations to the Customer Experience Improvement team, leading to a 20% increase in customer satisfaction scores. Supply Chain Planner – Netalia Solutions Pvt Ltd, Bengaluru, India July 2017 – December 2020

• Implemented advanced demand forecasting models for clients, reducing stockouts and improving inventory turnover.

• Conducted supplier performance evaluations to maintain high-quality standards and address any supply chain disruptions

• Collaborated with vendors and negotiated contracts to secure favorable pricing, terms, and delivery schedules

• Conducted SKU-level cost-benefit analysis for transportation routes, resulting in annual savings of approximately

$10,000 through optimized carrier selection and route planning for a retail unit.

• Developed and integrated dynamic dashboards, reporting systems, and key performance indicators (KPIs) within the SAP Business One ERP system to enhance and support business decision-making processes.

• Conducted weekly and monthly inventory statistics using MS Excel and Power BI and provided actionable recommendations.

Industrial Engineer Intern – Sant Valves Pvt Ltd, Jalandhar, India May 2016 – August 2016

• Conducted time and motion studies to identify process inefficiencies, increasing production efficiency. Implemented Lean manufacturing principles like 5S and Kanban.

• Conducted root cause analysis, contributing to a 30% decrease in production defects and improved overall product quality.

• Worked closely with the engineering team to design an optimized layout for the manufacturing plant, focusing on reducing material movement and streamlining production processes. ACADEMIC PROJECTS

Decision Support System for Healthcare Industry Minitab, Excel Binghamton, Fall 2022

• Designed and implemented a decision support system, optimizing MRI unit quantity in the healthcare industry.

• Conducted thorough data analysis and modeling using Excel and Minitab, employing forecasting methods such as time series analysis and demand planning to enhance accuracy and responsiveness to market dynamics.

• Applied advanced algorithms and mathematical models, decreasing potential risk areas related to MRI unit acquisition.

• Offered data-driven insights and recommendations, enabling healthcare organizations to reduce costs by 20% in MRI unit procurement and allocation.

EDUCATION

SUNY Binghamton University, Binghamton 2022-2024

Master of Science in Industrial and Systems Engineering NIT, Jalandhar, India 2013-2017

Bachelor of Technology in Industrial and Production Engineering

Contact this candidate