Angel Chavez

Background

About Angel Chavez

SELECTED ACCOMPLISHMENTS 1) Developed and integrated an e-Kanban database for wire processing based on customer requirements migrating data to Oracle's order management module using visual basic code interface, reducing excess wire inventory by 35%$3.1 M and processing time by 70%. 2) Developed and integrated a plan-for-every-part database for circuits using maximum and minimum quantity, spaces in a circuit storage, adding routings in oracle, and a trigger to a cutting order; reducing obsolescence (80%),$1.4M excess inventory (35%), and processing time between cycles (35%). 3) Reduced the Raw Material monthly buy for circuits by 22% by creating, integrating, and implementing a Cutting Schedule database interfacing with the Oracle MRP module. Implemented the database in 7 manufacturing plant locations in Mexico and Honduras.$5.4 M over 3 years 4) Reduced barcode label customization costs 75%$250K over 2 years by creating and integrating an AIAG finished goods label customer identification database (1D, 2D and PDF barcode collection), successfully migrating data from Oracle. 5) Designed, installed, and integrated a data national database program (Chrysler test base) successfully migrating data from SQL and reducing development costs by 50%$75K. 6) Created and integrated a Data national digital manufacturing counter based on Tak-Time vs. production (16 seconds cycle) for four production lines successfully migrating data from SQL data server, reducing 80%$45K labor cost. 7) Improved Manufacturing Requirements Planning (MRP) explosion based on requirements and Bills of Materials (BOM) by implementing a database successfully migrating data from Oracle, reducing 60% processing time. 8) Developed, installed, and integrated a shortage database report based on customer requirements vs. on hand inventory successfully migrating data from Oracle, reducing 70% processing time. 9) Implemented Oracle 8 and upgrades (10.3 and 11i) in 17 Manufacturing Plant locations