July **, **** Page *

Jerry Castro

Sherman Oaks

ad41vz@r.postjobfree.com

818-***-****

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