Data Analyst

Excel Expert Oracle Manufacturing Production Planning

Data Analyst with 17+ years of experience performing data analytics in the manufacturing sector. Expert level knowledge of Excel including extracting, compiling, cleansing and formatting data using VLOOKUP and Pivot Tables. Extensive use of Oracle E-Business Suite including data extraction and data cleansing. Ability to read and write SQL queries to extract data. Ability to work collaboratively inside or outside a team environment with little or no supervision. Team leader and critical thinker, effectively and efficiently managing and executing large projects, quickly resolving crisis issues, analyzing alternatives and providing innovative solutions. Excellent organizational, interpersonal and communication skill sets with flexibility to adjust to changing priorities.

Professional Career History and Achievements

Sanmina (November 2000 – September 2017) – Data Analyst/Production Planner

Responsible for data collection and verification from Oracle E-Business Suite 11i.

Managed ongoing modifications to existing production reports and created new reports such as the Assembly Cumulative Leadtime Verification, Orders at Risk Due < (revolving) 6wks and Customer Clear to Build reports.

Extensively used VLOOKUPS, pivot tables and other Excel functions to extract and blend multiple datasets from text, CSV and Oracle to create customer specific inventory, order backlog reports and spreadsheets.

Worked directly with program managers and team leads to create customer specific inventory snapshots, WIP status and other purposes.

Evaluated, scheduled and coordinated production of raw materials through the complete manufacturing cycle using Oracle 11i by analyzing existing and forecast demand for multi-billion dollar companies to ensure all work orders were submitted per specified schedule.

Developed, generated and published a wide range of custom reports from extracted Oracle data using Excel such as Excess Inventory Tracking, Purchase Order Reschedule Activity by Dollar Value and Aging Workorder > 30 days Summary/Analysis.

Oversaw intercompany transfer of materials to minimize delays in production, ensure accuracy of component availability, approved manufacturer parts, date code compliance and cost effectiveness of transfer.

Served as department lead for internal metrics program by generating, maintaining and archiving related records and reports for corporate quarterly onsite review.

Selected as Plant Champion of the Advance Planning System - Kinaxis Rapid Response. Responsible for implementation and training of Production Control personnel, Material Planners and Program Management on customer specific inventory value and burn off analysis reports.

Other Functional Experiences:

Pacific Die Cut Industries Warehouse Supervisor/Inventory Analyst March 1998 – November 2000

Viavi Solution Buyer/Planner May 1994 – March 1998

Ashland Chemical Buyer May 1992 – May 1994

Education, Certifications and Professional Development

Udacity Nanodegree Program – Data Analytics (Completion Date 11/2017)

James Logan High School - Union City CA

Contact this candidate