Supply Chain Business Analyst Resume
2.00/5 (Submit Your Rating)
Chicago, IL
PROFESSIONAL SUMMARY:
- Technically strong, detail oriented business professional with over 4.5 years of supply chain planning/consulting/analytical/ERP experience.
- Results - oriented with demonstrated expertise in inventory planning and analysis of statistical data to determine inadequacies in business processes, to forecast future risks, and establish strategies for positive change.
SKILL:
- Data Analytics, Data Mining, Data Warehousing
- SQL, R, Tableau, SAP, MS Excel, Access, Qlikview
- Supply Chain Planning, Demand Planning
- Project Management
- Process Improvement
- Business Data Analytics
- Data Modeling
- Inventory Management
- Creativity, Collaboration
- Problem Solving, Decision Making
PROFESSIONAL EXPERIENCE:
Confidential, Chicago, IL
Supply Chain Business Analyst
Responsibilities:
- Performing as a Supply Chain Business Analyst in the healthcare industry focusing on process improvements, analyzing and integrating Supply Chain, Marketing, Finance and Sales teams in the project.
- Managed inventory for new product line which generated over $20.5 million first year sales.
- Created Pricing Tool using VBA which has been highly appreciated and used by Sales Confidential team to carry out contract negotiation with customers.
- Created interactive dashboard using advanced excel, Qlikview and SAP to provide complete end to end visibility of supply chain process.
- Responsible for forecasting demand, managing inventory and planning the replenishment cycles on a monthly basis to prevent product excess or shortfall/stock out situation.
- Serving as a liaise between Supply Chain, Marketing, Sales, Finance and IT teams and providing analysis to Confidential .
- Built and maintained effective working relationships with key stakeholders.
- Introduced Tableau software into the project to create interactive presentations.
- Tracked, analyzed and interpreted trends in sales and inventory and created reports to track inventory.
- Reported KPI's to account managers, directors, and senior management on a weekly and monthly basis.
- Worked closely with Sales and Marketing team to design and implement strategies to improve lead time on strategically important product lines.
Confidential, Minneapolis, MN
Supply Chain Analyst
Responsibilities:
- Performed as a Supply Chain Analyst in the automobile industry to analyze shortcomings between supply and demand and developed an automated tool that made immediate process improvements.
- Utilized sharp presentation skills and background in software engineering to present a demo of the tool to the executive director of Supply Chain department and other stakeholders in the chain.
- Created a complex report/dashboard using advanced excel and Tableau and performed data analysis on large dataset to solve business issues.
- Developed acumen for defining key performance indicators, and identified trends in proven business models that hampered operations.
- Conducted data retrieval and transformation along with conducting quantitative and qualitative analysis.
- Maintained influential relationship with vendors and customers.
- Created weekly reports in designed Excel spreadsheet with pivot tables.
Confidential
Senior Consultant
Responsibilities:
- Performed as an ERP consultant providing detailed business analysis using SAP technology in the consumer goods industry.
- Improved purchase order alert functionality usage by 70% by designing and implementing a customized logic.
- Reduced service request and incident count by 50% by implementing Vendor Managed Inventory process.
- Introduced standardized templates for reporting purpose, decreasing wait time from 180 to 5 minutes.
- Enhanced system performance by 30% by implementing several innovations and process improvements.
- Made forecast recommendations to ensure a proper level of inventory in a warehouse with >100k items which in turn contributed to 25% inventory reduction.
- Collaborated with global supply chain team to streamline the overseas suppliers and reduce material shortages up to 20%.
- Analyzed statistical data and reports to ascertain trends in performance, resulting in maximum effective and efficient use of logistical resources.
- Improved customer service performance from 80% to 99%.
- Responsible for forecasting demand, managing inventory and planning the replenishment cycles on a daily basis to prevent product excess or shortfall/stock out situation in SAP SNC.
- Carried out replenishment runs by taking into account sales from SAP BW, forecast from SAP APO and created sales orders in SAP SD.
- Expertise in implementing end to end purchase order life cycle in addition to outline agreements, source list, info records, quota arrangement, scheduling agreement and subcontracting in ERP system.
- Hands-on experience in Purchase Order creation, Purchase Order Release, Scheduling Agreement, Confirmation of orders, Goods Issue and Goods Receipt.
- Analyzed and tested Message Transmission data (IDOCS and XML proxy messages) from and to SAP ECC.
- Proven expertise in SAP PP in setting up MRP, BOMs, routings, work centers/ resources, planning and optimization.
- Hands on experience in SAP MM in configuring Material Master Data, Vendor Master Data, Purchase requisition, Purchases order and Scheduling agreement.
- Maintained and reviewed CIF Integration Models for Master Data and Transaction Data transfer between R/3 and APO.
- Conducted weekly client calls with the planning team to discuss about the current issues related to forecasting demand and inventory and present process improvement ideas for approval.
- Strong understanding of Kanban process, Just In Time/Lean Management, economic order quantity (EOQ).
- Demonstrated strengths in supply chain planning, demand planning, supply network collaboration, sales and distribution, forecasting, inventory management, material management and transportation planning.
- Displayed excellent interpersonal skills; familiar with the intricacies of customer service management and maintaining relationships with customers and vendors to facilitate ongoing business engagement.
- Led and mentored a team of six software engineering analysts successfully over a period of 18 months.
- Directly involved in supporting key supply chain processes to reduce costs and increase operational efficiency.
- Provided training to Supply Chain stakeholders - planners/schedulers/buyers.
Confidential, Chicago, IL
President
Responsibilities:
- Provided Confidential and vision for the direction of QGBA.
- Assisted the Vice-President of Finance in developing the annual budget.