Jason Olson Email & Phone Number

Medina, Ohio, US

Grosse Pointe Farms, Michigan, US

Developed efficient ETL data integration solution using IIPAAS to ingest large healthcare member change of benefit text files from SFTP File Server, sort them based on record type, and insert them into appropriate database, achieving a 97% reduction in mass ingest cycle time compared to the original version through continuous improvement.

Aurora, Ontario, CA

• Data Extract Transform and Load, Data Visualization DashboardsACCOMPLISHMENTS:
• Utilized Grafana based application using docker in background as process container software to support dashboard instances of PostgreSQL Databbase.
• Supported and strategized implementation of system wide change, existing framework not easily interpretable. New and improved data collection framework understandable, that enables machine performance KPI calculations.
• Developed python script to extract data from PostgreSQL Database using psycopg library Application Programmable Interface. Transformed data using pandas DataFrames to then reload data back in native PostgreSQL Database.

• Commercial Construction Sub Contractor, project management, and oversight of all trades.ACCOMPLISHMENTS:
• Responsibility of determining a competitive bid price with General Contractors agreement for allconstruction services rendered(Trade Supervision, Project Coordination with Walmart Management Team, Project Management).
• Utilized market segmentation analysis to uniquely position services in area of specialty to further build customer affinity.
• Constructed budget and revenue projections to adhere to growth targets, and managed company P & L statements.

Detroit, Michigan, US

• Accomplished design and release of electromechanical chassis brake components as subject matterexpert by delivering key project deliverables on time and to budget, while adhering to an agile program.
• Lead K2xx mid cycle order brake optimization project with a projected cost savings of 1.2 million per year.
• Executed MY18 launch project on full size van that would affect 100% of saleable vehicles, utilized CAN bus vehicle spy software, embedded brake controller software code and determined root cause and tested corrective.
• Presented and implemented improved brake bracket design change to Change Approval Board leadership, new design improved stress/strain from previous version by 25%.

London, England, GB

• Complete responsibility for assembly and process quality of exterior body in white components including closures, bodyside apertures, underbody, and roof. Held cross functional meeting regularly between supplier, plant.
• Through using Robust Dimensional Tolerancing reviewed all BIW component GDT in totality which performed an RSS stack analysis on each sub assembly and main assembly that constructed full BIW unit, therefore allowing an.
• Successfully launched dimensional inline vision Net Form Pierce System utilizing dynabot software, resulting in reduced cycle time and ultimately an 8% increase in overall system throughput.

London, England, GB

• Solve top occurring dimensional variation problems through using pareto analysis and World Class Manufacturing 7 step structured problem-solving methodology. Accomplished reduction in geometrical variation of.
• Lead Gauge R & R tool repeatability studies with plant electricians and Advanced ManufacturingEngineering Team to identify variation in the automated process, improvements made resulted in a 21%reduction in automated.
• Implemented advanced kaizen project by utilizing Design of Experiments, Annova, Box-Plots and Multivari Charts that improved customer perceived quality, resulting in 70% reduction of variation, furthermore a $100,000.

• Managed current open issues list of responsible product launches at the plant, prioritizing list due to severity of problem. Worked along a cross functional team to support design reviews and changes happening to.
• Developed and implemented component attribute gage for incoming hood striker wire, resulting in 22%rework reduction.
• Created and executed tensile destructive test process for K2XX hood striker that adhered to GM weld standards.

• Improved current state of Acute Rehab Center and developed solution toimprove patient throughput by 25%.

• Designed and Implemented Spare Parts Inventory Control System for spare parts of production lines, resulted in 90% cost savings.

Bachelor Of Science, Industrial And Systems Engineering

Education record