Supply Chain Analyst
Resume:
Jerry Castro
Sherman Oaks
*.*******@*****.***
Objective:
Supply Chain Analyst with 10+ years of experience organizing presentations, preparing facility reports, and maintaining the utmost confidentiality. Expertise in Data Visualization to leverage my role as a project and data manager, Accomplished results-oriented by adapting quickly to new environments and acquisitions. Professional Summary:
• Business/Supply Chain Analyst with extensive experience in manufacturing domain.
• Developed scripts using Cognos and Power BI geared to develop a forecasting accuracy model.
• Analyzed barcodes segments with the marketing team to update weekly demands to forecast.
• Implemented A/B Testing procedures in service to improve conversion optimization and google analytics.
• E-Commerce and ERP problem resolution and business process improvements for sales order conversation.
• Research leading problem resolution and business process improvements to assist.
• Optimization of existing shopping campaign components including the Ecommerce site for spinning.com
• Retailing association Ecommerce manager produced tactics and techniques to drive new customer acquisition.
• Meeting targeted KPIs related to corporate strategy of acquisition channels for direct-to-consumer products.
• Documented business excellence projects life cycle by managing project milestones from start to end.
• Worked with Cognos, Rapid Response, SAP, Hyperion, Business objects, Smart sheet, and Tableau.
• Accurately monitoring and assessing ongoing campaign performance by adding value to leadership dashboards.
• Designed a Data Service Sales Force and implemented the supply chain vendor item master.
• Consumer-facing E-commerce platform for creative decks call to action e-commerce P&L models.
• Created reports and manuals for On-Time delivery system to provide insights targeting website sales and ROI’s.
• Designed queries, extracted data and created reports designed to drive category reviews for pricing decisions.
• Advanced Excel Expert created reports and visuals into dashboard, by using Spotfire, Brio, Power BI. Skills:
• Applications: IBM Cognos, Rapid Response, SAP ECC 6.0, Hyperion, Business Objects, Smartsheet, Tableau, MS Office Suite
(PowerPoint, Excel, Word, Access)
• Supply Chain, Purchasing, Forecasting, Inventory
• Certification in Production and Inventory Management (CPIM)
• Certified Supply Chain Professional (CSCP)
• MS Office, Excel, Access, Outlook.
• Pricing Cost & Negotiating skills.
• Purchasing: 2 years
• Planner: 5 years
Professional Experience:
Bachem AG, Torrance CA November 2020 – Current.
Production Scheduling / Project Manager - BAM
• Served as the primary user of the enterprise resource planning system in SAP (production and planning)
• Worked with the Production Managers for Peptide, R&D, Planning, Production, GEN 1.1 and legacy line Planning.
• Reviewed and approved Batch Production records for various stages to support QA & QC.
• Worked with planning to support Mater4ial management and material transfers from various Bachem sites.
• Validated production schedule for QA, QC and Material Management with required Specs, SOPs and Forms for manufacturing to orders to improve our OTIF/ MPA and RM and SC demands Within the required timelines.
• Release production schedule for downstream and upstream projects using Microsoft projects and Power BI.
• Key user for SAP and S4 hanna and CMMS equipment and Functional Location designer for various SAP projects. July 31, 2023 Page 2
Amgen Inc, Thousand Oaks, CA July 2019- October 2020 Sr. Associate Supply Chain (contract complete)
• Designing Tech ops analytics Spotfire dashboards.
• Metric Portfolio Automation for Tableau for the On-Time Delivery Workbook.
• Weekly Visual Creation of Data Mining Insights to Support a Strategic Decision for Contract Manufacturing.
• Implemented Master Data Push Alerts by designing a Smartsheet Calendar Supporting the External Planning & Delivery BU, Published Inventory below Target Level Reports by Targeting Site Performance utilized Rapid Response Brio-intelligence to Design queries and Data Mapping Executions.
Astra Mfg., Canoga, CA October 2018 - June 2019
Supply Chain Analyst (contract, recruited by Lloyd Manufacturing)
• Conducted accumatica data dump for Astra’s complete line of coffee makers, conducted daily domestic and international shipments for MOD orders.
• Executing Shortfall Data for current Sales Force Behaviors design a Dollarized Report for Units deliverables using Cognos and Power BI all geared to develop an Excel Forecasting Model.
• Shipped Freight, scheduled outbound order priority for customers, developed BOM’s and sub assembly for Astra components.
• Improvement strategies for business process data intelligence for the business excellence team.
• Data modeling to complete and support projects.
• Data Structure and standardization of projects to validate deployments.
• Strong collaboration with team members and core data metric owners.
• Taking on new projects and making good judgment for proactiveness.
• Heavy Excel, Data Lake, Spotfire expression tables.
• Developed a Forecast Accuracy Spotfire, model to drive US/EU 1, 3, 6-month lag.
• Demand planner support ensuring data accuracy in reporting and management of forecasts actuals. Sony Pictures, Culver City, CA October 2016 - September 2017 Data Analyst (contract complete)
• Creation of Material, UPC and Video Version Numbers, Seasonal Promotional Launch of Catalog Titles for Sony SPE Home Entertaining Group, Maintained Expiration Moratorium Data for Expired Titles.
• Weekly and Monthly Communication of New Product Launch. Warner Brothers, Burbank, CA December 2013 - October 2015 Technical Operations Data Analyst (Full Time Role)
• Front End Analyst Distributed Large Data Sets for Programming Announcements.
• Designed the Digital Avails Schedule System, Creation of Key Metadata Start and End Dates, Advanced Excel
• Data Functions for Data Migration and Standardization Using SQL 2008 Visual Studio and Toad load SQL.
• Developed Key Performance Indicators to find Root Cause Issues. Hawker Pacific Aerospace, Sun Valley, CA March 2012 – December 2009 Demand Planner Analyst (part-time/off-hours)
• Presented Negotiations and directions for spare parts items to produce at product6ion sites.
• Consensus meetings for product release and facilitation.
• Forecasting, statistics, and quantities to execute, customer quotes, bids and proposals.
• Oracle and Access demand-planning forecast used for item master and Bom set ups.
• Display, landing gear Pricing and incremental forecasting for items below target inventory level.
• Interacting with sales, senior buyers, and retail managers to display kits and product pricing.
• Managed new product release participated in special projects sold over 1.5 million in spare parts. Education:
• Bachelors, Business Administration; CEI University / DeVry University
Contact this candidate