Data Analyst

Jorge Cervantes

San Bernardino, Ca • 626-***-**** • adfw36@r.postjobfree.com

CAREER PROFILE

Analyst with 4 years of experience in data analytics, extracting and transforming data into reports utilized for critical business decisions. Data analytics skills are complimented by 8 years of investigative analysis activities within a quality and financial environment.

Core competencies include; Process Mapping, Data Mapping, SIPOC, FMEA, Tableau, Power BI, Excel Power Pivot, Power Query, SAS, mySQL, Dashboard building, Data Trending, Forecasting, Budget Analysis, Expense Analysis, Capital Expenditures Analysis, and Quality Assurance metrics analysis.

CAREER HIGHLIGHTS

Increased department output to manufacturing stakeholders by 65% in implementing 5s concepts, six sigma applications, including operations best practices.

Cut customer returns by 52% by performing deep analysis into process failures discovered through data analysis resulting in 2 major process changes: 1) Total process change of assembly procedures 2) retraining of staff per changes made. Increasing customer satisfaction by 48% over a 60-day period.

Reclaimed $1.3 million from a $2.1 million rejected materials inventory by creating a salvage evaluation model to analyze rejections in relation to other customer requirements. Subsequently resulting in 1) increase in on time customer delivery and 2) increase in salvage revenue versus scrap value.

Restructured data model to correct gaps found in Oracle ERP that was affecting 60% of output products. Utilizing data mapping to identify gaps affecting operation while working closely with IT to validate all changes for correctness as well as consistency. Leading to positive output and increase in customer satisfaction rating of 38% over a period of 60 days.

PROFESSIONAL EXPERIENCE

Logistics and Operations Analyst

Blue Water Thinking LLC. Washington DC, 5/2020 - Present

Supporting Veterans Health Administration’s efforts with Covid 19; performing a deep dive analysis into critical systems affecting PPE deliverables and over budget costs.

Presented corrective solutions resulting from investigative findings using SIPOC, FMEA, and Data Analysis tools to pinpoint operational areas that will affect deliveries of critical life saving equipment.

Introduced innovative practices to automate redundant actives that included communications via electronic media and cloud services.

Systems Analyst 5/2020 - Present

Technical consultant evaluating current data reporting method for tracking, purchasing, and value assessment of high-tech medical equipment.

Introduced streamlined reporting methods through use of Power BI for consistent reporting and ease of data retrieval for authorized users.

Implementation of data modeling through SQL and Power Query to provide visible road map of table relationships to include data flow.

Perform administrative analysis on reporting SQL servers; identify and correct tables to improve performance, set up test validation scenarios, and report applicable findings to the team.

Quality Analyst

Concorde Battery Corp. West Covina, Ca 12/2019-3/2020

Evaluated database requirement for the migration of AS400 and MS Access data to SQL server services and automated reporting.

Performed an analysis of standard operating procedures for process gaps and built teams to perform corrective actions/preventative actions with schedule end dates to be validated for conformity to AS9100.

Identified and corrected data stream failures within MS Access databases including validation tests

Quality and Operations Analyst

Dover Corporation, Grand Terrace Ca 06/2017 -11/2019

Published metrics used for critical business decisions using technologies such as Excel Power Query, MS Access, and Power BI.

Budget Analysis of department and project costs to determine budget forecasting to include over budget costs.

Analysis of quality KPIs to detect opportunities for improvement resulting in process corrections and a reduction of customer returns by 52%.

Quality and Operations Analyst

ATI Forged Products, Irvine Ca 09/2016-03/2017

Published metrics concerning internal and customer rejected material to be followed by corrective action activities using Excel and Power BI.

Applying data analytics and process analysis to pinpoint contributing factors leading to internal failures affecting On Time Deliveries as well as Customer Satisfaction.

Drafted and implemented reevaluation model to salvage $1.3 million in potential scrap materials from a $2.1 million rejected inventory.

Quality Associate

C and H Molding, Mira Loma, Ca 06/2016-09/2016

Point of contact for customer related issues as well as supplier quality management

Created supplier rating system within the guidance of ISO and ASQ

Managed all quality inspection activities and process staging.

Quality Lead

Cosasco, Santa Fe Springs, Ca 08/2008-03/2016

Increased efficiency and delivery times to other intercompany stakeholder, increasing output from inspections by 65% while maintaining a 24-business hour window.

Published weekly performance metrics using Excel drawing data from both paper sources and ERP systems.

Recognized inspector talents and identified staff to engineering roles including field service staff.

Point of contact for all quality related activities including allocation of resources to support product development, engineering research, and staff acquisitions

EDUCATION

Keller Graduate School of Management 2011

Pomona, Ca

Master’s Degree with an emphasis in project management

DeVry University, Pomona Ca, 2008

Pomona, Ca

Bachelor’s in Business

Contact this candidate