Jason Horn

Calgary, AB, Canada, T*J *S*

403-***-**** adq549@r.postjobfree.com

https://www.linkedin.com/in/jason-horn-4614071a

Professional Summary

Resourceful Supply Chain - Materials Management knowledge worker effective at improving operations utilizing ERP/EAM COTS applications such as SAP and IBM Maximo. I am especially proficient at providing complex data (ETL) extraction, transformation and loading solutions for information systems requiring clean and standardized Master Data such as Equipment, Vendors and Materials. I am certified in Business Management and licensed as an Inter-Provincial Journeyman Parts Technician. Skill set includes:

Advanced skills in MS Office, Excel, Visio, MS Project, MSSQL Server, PL/SQL, TOAD, Oracle.

Expert at utilizing ISO 14224: Collection and Exchange of Equipment and Reliability & Maintenance Data.

Efficient at converting P&ID’s into SAP’s BOM’s and Maximo Item Assembly Structures.

Detailed O&G equipment knowledge such as Turbines, Pumps, Compressors, Engines, Electric Motors, Generators, Measurement Devices, HVAC and Tubular Goods.

Systems development life cycle expertise in design, build, test/fix, deployment and maintenance of SAP ECC6.0 MM/PM/FICO applications in the oil & gas industry. Knowledge of HANAS/4.

Experience in IBM Maximo Configuration, Database, Security, Application and Workflow Designer.

Business Analyst capabilities utilizing BATK such as ITIL, PLCM, BPM and the SDLC frameworks.

Expertise using a Process Control Framework to facilitate Business Improvement.

Strong knowledge of Materials and Maintenance Management best practices in the oil and gas industry.

Experienced Warehouse equipment operator including Forklift, Reach Truck and Overhead Crane.

Able to effectively communicate and explain complex system and data requirements to business units including Supply Chain, Finance, Maintenance, Operations and Projects.

Work Experience

Maximo 7.6 Data Analyst, Altagas, Calgary, AB (11/2020 - 7/2021)

Extracted Maintscape data, transformed and loaded into Maximo 7.6 Storeroom/ Materials/Inventory.

Created SQL scripts to insert Maximo data into JDE Edwards through Struxure data standards tool.

Applied UNSPC standards to Maximo Item Master Data using Struxure MDM tool.

Lead Field Data collection team in creating new Item Masters, Storeroom and Inventory records.

Instructor - Supply Chain Management & Logistics, CDI College, Calgary, AB (02/2020 - 11/2020)

Delivered online (Zoom) and classroom training on learning modules including: Business Essentials, Information Systems, Negotiation Skills, Project Management, Operations Management, Procurement, Contract Management, Demand Planning, Inventory Management & Control, Logistics Management, Packaging & Materials Handling Equipment, Customs, Transportation & Freight Forwarding, Integrated Supply Chain Management and Career & Employment Strategies.

Instructed adult learners to execute tasks, conduct analysis & present deliverables on SCM Principles, Risk Management, Operations, Logistics and Distribution, MM/Transportation Systems & Reverse Logistics, Warehouse Design & Planning, Effective Communication and Professionalism, IT Applications for Logistics and SCM, Third-Party Logistics (3PL) and Distribution Centre Management. Supply/Demand Management, Strategic Sourcing, International Logistics and Customs Regulations.

Coached, developed, challenged, delegated, tested, graded and graduated students to required standards.

SAP MM/EAM Data Conversion, Manitoba Hydro, Winnipeg, MB (01/2019 - 03/2019)

Mapped and migrated legacy AMPS data to SAP ECC6.0-HANAS4.

Supported SAP PM/MM instructional training.

Provided onsite MS Excel training to Master Data analysts.

SAP MM Consultant, Pembina Pipelines, Calgary, AB (05/2016 - 11/2017)

Traveled to all warehouse locations and created SAP Material Masters records. Prepared warehouses for roll out of barcode readers & Bin Labels. Consolidated Bins. Developed staging for non-inventory purchases.

Introduced and delivered new inventory processes including identification of physical inventory, spearhead discussions on identification of obsolescence and instruction & oversight of initial entry of inventory.

Provided local training on inventory processes and developed/instructed warehousing acumen.

Defined and developed consumables solutions fit for business respecting all necessary governance requirements (SOX, security, segregation of duties).

Worked with site personal to assess criticality of spares and instruct on critical conversations with maintenance. Provided progress updates to PM and SCM lead as required.

Maximo v7.5 Asset Management & Reliability Data Consultant, Inter Pipe, Calgary, AB (05/2015 - 11/2015)

Create, map and migrate equipment Location Hierarchies from facility P&ID drawings.

Created data collection lists in XL for field equipment reconnaissance team.

Validated Equipment, Asset and Location returned data collection prior to loading into Maximo.

Enriched Item Master data of Pumps, Motors, Valves, Input Devices and Valves.

Facilitated optimization of Capitalized Spares, Inventory Management and Procurement best practices.

Master Facilities Data Analyst, Penn West, Calgary, AB (06/2012 - 06/2014)

Developed a Data Warehouse and .NET application capable of mining and standardizing all equipment information across the enterprise to be suitable for migration into COTS applications.

Operated TOAD to analyze data from source systems including Roughneck CMMS, Property Tax, AFE Navigator, PAS, IIHS, QByte, CS Explorer, Maxitrac, AMICS, ERCB, Flare Check, Peleton Well/Site View.

Designed EDI ISO 14224 equipment classification and attribute source system conversion process solution.

Designed data quality exception reports for Equipment/Asset, Location, Vendor and Manufacturer records.

Automated resolution of Asset, Location and Company records duplicates into single entity.

Designed executive summary reports on data cleansing progress.

Further customized, de-bugged and fine tuned application for automated data migration into Maximo v7.5.

SAP MM ECC6.0, Talisman Energy, Calgary, AB (03/2011 - 06/2012)

Provided Full Life Cycle support for SAP ECC6.0 SCM and Finance integration project.

Extracted Maximo v7.0 source data for SAP ECC6.0 Material Masters and Vendor data conversion.

Completed integration testing of SAP Vendor Masters, Material Masters, and SLA Contracts.

Facilitated review and improvement of Workflow and release strategy.

Monitored P2P process including Open Text Vendor Invoice Management and provided keystroke training to Requestors, Approvers, Purchasers, Receivers and Invoice creators.

Warehouse Coordinator, Devon Energy, Calgary, AB (08/2010 - 03/2011)

Supervised Warehouse, Procurement and Materials Management at Jackfish SAGD operation.

Purchased direct issue WO materials and managed warehouse inventory and repairable spares.

Trained contractors and field staff in effective use of IGOR CMMS P2P purchase-to-pay process.

SAP MM Master Data Analyst, Suncor Energy, Ft. McMurray, AB (05/2010 - 08/2010)

Directed field team in validation and conversion of Trans-Alta Co-gen data for migration into SAP.

Matched Trans-Alta Vendors to Suncor Vendor Masters and eliminated duplicates.

Maximo Trainer, Talisman Energy, Calgary, AB (06/2009 - 09/2009)

Instructed Maximo v.6.0 training for ‘Introduction to Maximo, Work Requests, WorkFlow Approvals, Planning, Scheduling, Completions and Administration'.

Developed and facilitated ‘Mobile Work Management’ integration.

Maximus Developer, University of Alberta, Edmonton, AB (09/2007 - 02/2009)

Designed, configured and delivered SCM financial approval workflow.

Analyzed, prepared and delivered plan to integrate Maximus CMMS and PeopleSoft P2P interface solution.

Validated inventory data and prepared business requirements for inventory management functionality.

Facilitated development workshops and training. Reported progress to Board of Facilities Mgmt.

SAP MM ECC6.0, Conoco Phillips, Calgary, AB (07/2006 to 07/2007)

Provided Full Life Cycle support for SAP ECC6.0 MM integration of Burlington Resources.

Validated standardized and migrated equipment data valued at 80M.

Documented and presented as-is and to-be Burlington business process to Conoco Executive board.

Proposed to-be SAP Project Stock business process to Executives.

Provided Unit, LIT, and global FIT testing including Pipeline (ERS), Project Stock, and P2P workflow solutions.

Developed User Guides and acted as lead trainer in approx. 20 classroom type SAP training sessions.

Education & Certification

Business Management N.A.I.T. Edmonton, AB, 1996

Journeyman Parts Technician (#J-30-40600) N.A.I.T. Edmonton, AB, 1996

Programming in Java, C++ S.A.I.T. Calgary, AB, 2007

Oracle Data Modeling and Design S.A.I.T. Calgary, AB, 2002

H2S Alive Current

TDG/WHMIS

Areas of Professional Development and Knowledge Base:

Dale Carnegie

Business Conflict Resolution, Coaching/Developing High Performance Teams

ISO9002 Quality Assurance in Production, Installation and Servicing

ISO14224 Collection and Exchange of Reliability & Maintenance Data for Equipment.

Systems Analysis & Design, Information Technology Infrastructure Library

SQL/PL/Tools for Oracle Application & Design

Business Analysts Toolkit

Business Process Management

Project Life Cycle Management, Project Leadership

Fundamentals of Construction Estimating, Operations Management, Drilling,

Six Sigma Techniques and Tools for Process Improvement

Contact this candidate