Post Job Free

Resume

Sign in

Production Planner Power Bi

Location:
Sylmar, CA
Salary:
85000
Posted:
January 04, 2024

Contact this candidate

Resume:

IVAN D. LAVERDE

QUALIFICATIONS & KNOWLEDGE:

EXCEL, ACCESS, POWERPOINT, E-MAIL, PIVOT TABLES, VLOOKUPS, MATCH, HLOOKUP, LOTUS 123/ QUICKBOOKS POSTING

MACROS IN EXCEL, POWER QUERY, POWER BI, MICROSOFT PROJECT, OLAP, FINANCIAL CALCULATOR HP 12C AND MS PROJECT.

“MAPIX 400”, “SYMIX”4.0 VERSION, ORACLE, OMNI, “DPRODUCE” AND SYLINE and C-ERP, JDE

18 YEARS AS A MASTER SCHEDULER AND PLANNER IN AEROSPACE FOR COMMERCIAL AND MILITARY COMPANIES

3 YEARS IN FINANCIAL ANALYSIS

FLUENT IN SPANISH

Professional Experience:

Acro Services/ EATON Corp., Camarillo, CA (assignation Completed) 06-05-2023/12-29- 2023

Production Planner for Machine Shop and Stamping Department

Plan and Releases Work Orders as required to meet customer demand while maintaining optimum lead

Work closely with production team and Engineers to monitor work orders progress. Anticipate impact of future.

Provide the adjustment in scheduling as needed.

Prints drawings and creates jobs packs from MRP System output for use by the floor as required.

Management the priorities in the Floor, update the boards on the floor.

Provide Estimation completion dates( ECD) to the Managers

Report the Shortage Report to the Purchase Department to expedite parts.

Created in Excel the Capacity report by CNC Machines and Mills. To know how many orders have to be in the floor.

Maintains and reports out assigned Metrics such as work orders on time release (OTR), on time delivery (OTD).

Working with the ME to fix the standards and routers. Inform to the Master Planning the new ideas for the MPS parts. Actalent/ Sensata, Thousand Oaks, CA (Project-based, contract completed) 03-28-2022/01-25-2023 Production Planner/ Purchase/ Stockroom

Generate an order to the floor for BEI line to the floor.

Generated purchase orders to address the shortage in new orders for BEI Thousand Oaks and France.

Started the implementation of the barcode system in stock room.

Created a production and maintenance plan report with Supervisor and maintained updated files on a daily basis

Coordinated with Document Control and Engineers to resolve issues with BOM and documents

Called the Vendors and sent an E-mail to expedite the parts

Analyze the data to improve standards and obtain a more accurate forecast. New Vac LLC

PRODUCTION PLANNER AND SCHEDULER (Contract completed) 02-09-2021/03-27-2022

Implement the Production Scheduler in Excel 365

Implementing barcode labeling for all racks in the stock room and on the mobile racks.

Coordinating priorities with the team leaders.

Develop dashboards to track team leaders performance.

Develop dashboards to monitor company performance.

Create an MS Report for 13 Month to forecast the capacity of the company and how many personal is required.

Help in New First Articles Approve using MS Project Concept. PDI PNEUDRAULICS, INC 04-16-2018/01-16-2020

PLANNER AN PRODUCTION CONTROL (Laid off, position eliminated)

Generate work order for Assembly components and made the schedule

Create and implement many reports like Shortage Report and Capacity Report for all the Work Centers

Call the Vendors to get information about the Deliveries

Expedite orders on the floor

Inform the Supervisors of the change of the priorities in the work orders

Change the lot size in the orders

Fix the lead times in OP to agree with the History performance for the vendors CPP CONSOLIDATE PRECISION PRODUCTS 07-19-2017/01-17-2018 MASTER SCHEDULER

Efficiency improve the release process from order acceptance to customer receipt.

Ensure that raw material requirements and work orders are properly scheduled to meet release dates through monitoring.

Track raw material, WIP, and finished goods through every required process step and follow up where necessary to eliminate all slack time

Provide regular status reports to management and customer service

Follow up wherever and whenever necessary to ensure all commitments Are met and timelines are followed

Provide advance notification to Outside Processing Planner as to when product will be available

Provide regular updates to Sales, Management, and Customer Service on projected ship dates

Communicate, and escalate as required, all issues with the potential of affecting Our ability to meet committed ship dates

Participate on customer conference calls related to past due part numbers and create Recovery plan for past dues

Provide customers regular status updates, as required MOC PRODUCTS COMPANY INC.- OPPER STAFFING & BIZ OPPS 02-02-2016/03-24-2017 INVENTORY SUPERVISOR AND PLANNER (OFS)

Managed and controlled Inventory levels in three separate building Coordinated Deliveries with the Production Department

Implement Bar Code System

Developed capacity modules for decision making

Created various reports such as back order report, item identification with product pictures, and consolidated BOM for Line of Business (LOB) products

Provide training to personnel on Excel and other systems using OBS program

.

AEROTEK 06-04-2014/11-20-2015

PLANNER IN CURTISS WRIGHT AVIONICS AND ELECTRONICS

Generated Travelers and Released to all Departments. Develop a Database, created macros, pivot tables, VLOOKUPs and reports for management information Systems(MIS)

Inform of the Status of the Travelers

Generate the Production Plan for the Month

Generate Order Requested for MRP

Implement Barcode System for the location of the units

Process all the NCMR and generated the Demand in the System to Replace the Components

Receive in the System all the Units to be repaired and manage the Log

Control and File the Documents required in the Repair Process CRANE AEROSPACE, Burbank CA 08-2013/02-2014

PRODUCTION PLANNER

Generate the Production Plan for the Month

Expedite Orders in Production

Generated travelers and released to all Departments

Created Database, macros, pivot tables and VLOOKUPs

Provided updates on the status of travelers

Conducted meetings to inform the Financial Vice President of high-risk orders

Participated in President’s Kaizen Event in the Servo Cell and Body Cell

Generate Order Requested for MRP, R&O Factory, OEM Returns and Kanban Cards TIMCO AEROSYSTEMS /BRICE MANUFACTURING CO., Pacoima, CA 06-2011/05-2012, 04-1993/2001 (Rehired) MASTER SCHEDULER AND PLANNER

METHODS and PLANNER

Plan for 12 Different Work Centers agree with the Master Production Scheduler (MPS) Report.

Released Jobs Operations and Drawings to the Work Centers.

Generated Database Using Pivot Tables and VLOOKUP, to create the Schedule for all the WC.

Take the Decision to Produce in House or send to Out Side Process agree with the available Capacity.

Created a Part Shortages List for Every Seats Program

Fix the Standard Cost with the Manufacturing Engineer (ME)

Suggested changes to Manufacturing Process or Work Instructions to Improve the Products

Close and Cancelled Data or Demands Not Required in MRP System

Pull Material from stock room and issue to the job or to the sales order

Created the Planning Department. Developed the Work Instruction Book,

Planner the New Seats for Boeing using MS Project and created the 5 years forecast.

.

FIELD FRESH FOODS, INC., Gardena, CA 05-2006/06-2011 COST ANALYST / AR/ INVENTORY CONTROL in Finance Dept.

Generated the Cost of Goods Sold “COGS” Daily Report and Report any Variance

Analysis of Prices vs. actual Cost and project the trend

Controlled the Inventory Report Daily for all the company departments

Generated the inventory monthly end reports

Created the Recipe Codes in the D produce System and put the Standard Cost (Raw, Direct, Indirect)

Received the Purchase Documents, fix it with the Vendors and Distribute the Freight Cost according to deliveries

Post the Purchase in QuickBooks System; Generated the analysis for Sales, distribution and purchasing

Generated multiple reports with Pivot Tables, Vlookups, Match and Macros, for Sales and Commodities Performance

Provide support to Marketing with multiple analysis report for future negotiation

The Daily Commodities Cost

STELLEX BANDY MACHINING, INC., San Fernando, CA 04-2002/05-2003 PROJECT MANAGER

Generate the Production Scheduler for B747 Back Door Hinges Vought Program and Boeing CO

Expedite Work Orders. Coordinate the New Programs in CNC

Reduce the Cost of Manufacturing Process

Coordinate the “OP” Process/ Created status report for all the customers.

Expedite the orders and talk with the vendors.

EDUCATION:

BS . Business Administration and Finance. - Universidad de Administracion y Finanzas (E.A.F.I.T. ) Medellin, Colombia Continue Education in Financial Management from EAFIT in Colombia. Obtained a Master’s Planning certification, material and capacity requirement certification from LTU University in Chatsworth, CA. Received a certificate of Achievement BOEING’S D1-9000A, Continuous Quality Improvement, Problem Solving Skill and Statistical Process Control in Glendale Community College, CA. Leader and Management Skills. CONTACT

Phone= 818-***-****.

E-Mail = ad2gf1@r.postjobfree.com



Contact this candidate