Excel/VBA for Creative Problem Solving, Part 1
Stephen Potter
Mechanical Completion / Pre-Commissioning Coordinator
Paphos
Summary
A specialist in Mechanical/System Completion and Turnover packages, with extensive experience in both Greenfield and Brownfield construction sites, including remote and challenging locations. Expertise spans the full lifecycle from Mechanical Completion (MC) through Pre-Commissioning, Commissioning, Start-up, and final handover, with a focus on the Transfer of Care and Custody phases.
Hands-on and adaptable to evolving project conditions, highly skilled in coordinating Walkdowns, MC, and Punchlist meetings, and proficient in using custom reports and charts derived from Systems Completion Databases. Experienced in defining and revising System Boundaries, coordinating Walkdown teams for MC/PC, and managing punch list activities.
I am dedicated to upholding Health, Safety, and Environmental (HSE) standards in the oil and gas construction industry and in my personal life. I prioritize safety and sustainability in all operations, ensuring compliance with HSE regulations to protect people, property, and the environment. This commitment extends to my personal life, where I continue to practice safety and environmental responsibility.
I bring industry-specific knowledge from work in fabrication yards in the UK, abroad, onshore and offshore, for both clients and contractors. Involvement in hook-up phases and Brownfield projects ensures safe, timely, and within-budget project delivery, with minimal punch items and carryover.
Proven ability to build strong relationships with a wide range of stakeholders, ensuring alignment on shared project goals. Confident, clear communicator with a flexible and innovative approach to problem-solving, grounded in real-world experience and a systematic methodology using a systematic approach.
Overview
25
25
years of professional experience
8
8
years of post-secondary education
3
3
Certifications
Work History
HUC Completions Coordinator
POSCO International at HHI Ulsan Offshore Yard
11.2022 - 4 2024
- Participated in the handover and closure of 15,450 ITRA, 4,100, ITRB, 40 ITRC and the close out of 8,044 Punch list items
- Coordination of Completion Activities for Subsystem MCCR/CCR and Punch
- Weekly reporting of Project Completions and Certificate Status
- Attend weekly Safety walkthrough in the Fabrication yard and offshore.
- Produce System/Subsystem Skylines and Rundown charts (Excel/VBA)
- Produce Certificate and MCCR/CCR /Punch reports for use in Handover/Punch Meetings enabling an efficient way of liquidating the remaining MCCR/CCR and Punch blocking DAC/RFCC Handovers
- Management of Punch Closure
- Review check and verify engineering data in HHI PCS
- Coordinate MC Walkdown scheduling and resources
- Managing Certificate flow and review for handover (DAC/RFCC/MCC/RFSU)
- Attend weekly completions coordination meeting between Client and Contractor
- Offshore HUC scope of work till Final RFSU and MAC
HUC Pre-Commissioning Coordinator
Absheron EPS Project
Baku
02.2022 - 10.2022
- Participated in the handover and closure of 16,302 Pre-com, 1,885 COM and 852 punch items
- Day to day management of Pre-commissioning work scopes during the various phases of the Project: design development, fabrication, construction, materials verification, mobilisation and logistics
- Co-ordination of all Pre-Commissioning activities including Electrical, Mechanical, HVAC, Piping, Instrumentation and Telecommunications
- Apply knowledge of commissioning/completions to achieve efficient document handover between contractor and client
- To ensure that all Pre-Commissioning personnel are aware of / implement safe working practices / procedures and are provided with a safe working environment
- Responsible for the compilation of all Pre-Commissioning Dossiers
- Ensure WebICAPS data is correct
- To co-ordinate and report on a weekly and monthly basis on all Pre-Commissioning progress, highlights and concerns
- Maintain and deliver the Pre-Commissioning activities within budget, and, where applicable, implement cost saving initiatives
- Liaise with the JOCAP Completions & Commissioning teams to ensure that Project objectives are being met.
- Coordinated cross-functional teams, resulting in seamless project execution and enhanced outcomes.
- Entered data, generated reports, and produced tracking documents.
Senior Completions Specialist
Tyra Redevelopment Project
Batam
06.2020 - 04.2021
- Participated in the handover and closure of 27,905 MCCR, 11,389 CCR and 57 COM along with the closure of 9,835 punch items
- Coordination of MC Activities for MC / PC and Punch
- Weekly reporting of Project Completions and Certificate Status
- Produce MC Skylines and Rundown chart (PHP)
- Produce CERT/DAC and ITR/Punch App in Java for use in MC and Punch Meetings to enable a quick efficient way of chasing down the remaining MC/PC ITR and Punch holding up MC/PC Handovers
- Management of Punch Closure
- Review check and verify engineering data in PIMS
- Manage MC Walkdown scheduling and resources
- Managing Certificate flow and review for handover.
Lead Completions Coordinator
TCO FGP/WPMP Project
06.2017 - 09.2019
- Participated in the turnover and closure of 85,593 A1 check sheets, 12,305 B1 check records, 176 C1 com tasks and 4,950 D1 De-Stack Check sheets.
- Turnover of 28 complex Modules from Korean Fab yard to Site in Kazakhstan
- Weekly reporting of Module QVD and Punch Status from MCPlus
- Produce MC Skylines and Rundown chart (PHP)
- Manage Discipline Completion Coordinators, giving guidance on MC / PC priorities
- Review check and verify engineering data in MCPlus
- Manage MC Walkdown scheduling and resources
- Managing Certificate flow, review documentation and request signatures for completed DAC and SMCC
- Manage team of MC Walkdown Inspectors.
Preservation Superintendent/Punchlist Coordinator
Inpex Venturer FPSO
08.2014 - 03.2017
- Participated in the handover of 268,993 CCK and PIP along with 87,411 FTS, OTS, PRC, PVP and STS checks.
- Punch list count was 56,394 from 16,152 A, 35,466 B and 4,776 C.
- Manage Preservation and Punch list for Topside Modules and Hull
- Identify and implement best preservation practice to enhance the effectiveness of current methods used in project for preserving equipment and materials
- Develop and implement a preservation strategy & procedures for Post mechanical completion
- Support QA/QC team (project) on preservation process pre-mechanical completion
- Supervise the Contractor for the implementation of preservation
- Provide assurance and an appropriate level of verification for the preservation activities
- Defines and communicates the philosophy, strategy and tactics required to ensure effective Implementation of the preservation process
- Accountable to preserve and protect equipment and material to maintain its original integrity from receipt on site to final handover of asset to owner
- Maintains preservation of equipment after installation
- Ensures initial preservation of bulk materials, including piping, valves, and complete piping systems according to the company's specifications
- Review ICAPS Preservation Module and carryout surveillance to confirm activities are carried out as per Action Card, vendor procedures and in a timely fashion
- Review ICAPS Punch List Module, interface with Contractor regarding Punch List Killing to enable a timely transition between project phases
- (Produce Weekly Summary Reports of PL Status).
Systems Completion Database Lead
Sakhalin1 Arkutun-Dagi Project
5 2012 - 8 2013
- Manage and Administer the System Completions Database and admin Team
- Manage the population of all engineering data to be uploaded to WinPCS
- Monitoring & verifying the accuracy of the System Completion System data
- Ensure status reporting is accurate and true
- Work closely with System owners and provide support for data validation and checklist allocation
- Ensure all changes are documented and aligned with the Planning and Commissioning tools
- Organise and plan weekly activities for WinPCS group and assign roles and responsibilities
- Ensure preservation plan is in place and is carried out in a timely fashion with limited carryover
- Ensure there is a seamless handover of Subsystems from Construction thru Static and Dynamic commissioning and onto Start-up.
Completion & Turnover Engineer
Kashagan Experimental Project
01.2008 - 05.2012
- Manage the handovers and punch items related to Power Generation, Utilities and OGS Trains
- Monitoring Execution Contractors Completion System Team
- Monitoring & verifying the accuracy of the Completion System data provided by Subcontractors
- Ensuring the accuracy of Execution Contractor Information loaded into completion system
- Checking the correct preparation of the Sub-system dossiers by Execution Contractor according to data loaded into the completion system
- Review Sub-system dossiers in cooperation with the other related AKCO departments, (Construction, QA/QC and Commissioning) according to Contract requirements and relevant procedures
- Coordination of AKCO Commissioning, Construction & QA/QC engineers for handover (walk down) and Punchlist generation and consolidation in cooperation with the related Execution Contractors
- Monitoring of preparation, implementation, and closure of AKCO punch lists
- Ensuring that no Punch list A items are still open before issue of the MC or DAC Certificate
- Ensuring that no non-conformities are still open before issue of the MC or PC certificates.
WinPCS Advisor/Turnover Coordinator
De-Kastri Oil Export Project
01.2005 - 12.2006
- Administer and load the System Completion Database (WinPCS)
- Advise on the population / administration / maintenance of the WinPCS Project Certification System
- Office-based for 6 months with site visits to the SPM Construction Site at HHI Facility in Ulsan
- On loan to NSNL EPC 2 Pipeline on Sakhalin Island administrating CMS completions database
- Subsequently in a supervisory role on-site at De-Kastri Oil Export Terminal, Russia
- Co-ordinate review of construction, pre-com, and commissioning check sheets
- Manage Turn over Completion Packages (TCP) and System Hand over documentation.
WinPCS Administrator/Turnover Coordinator
BP Maddog project
04.2004 - 11.2004
- Manage the System Completion Database (WinPCS) and Handover process
- Ensured implementation of the mechanical completions process in a controlled and structured manner
- Certification of project was governed by the BP GOC 'Guidance on Certification'
- Production / issue of field-test reports and liaison with construction / pre-commissioning personnel
- Day-to-day operation / control of WinPCS, updating of database and system completion records
- Population of WinPCS database in line with applicable project procedures and latest design data
- Verified the project in line with the latest revision drawings, procedures, and specifications
- Identified sub-system limits and updated limits in line with latest revision P&ID's / SLD's
- Completion of data downloads and verification of data on completion of imports.
WinPCS Administrator
AGIP ENI Sabratha Project
12.2003
- Loading Engineering data into the WinPCS System Completion Database
- Loading engineering data for the Sabratha Project, in the AGIP ENI office in Milan
- Liaising with Discipline Engineers regarding Subsystem and Test Pack Boundaries
- Allocating MC and PC ITR's as per the project ITR allocation Matrix
- Flagging the ITR's as per Onshore and Hook-up Scope.
Commissioning Acceptance Management Technical Support Engineer
British Gas Karachaganak Project
08.2001 - 11.2003
- Administer and load Engineering Deliverables to the System Completions Database (WinPCS)
- Administrated WinPCS as the Project Certification System
- Reconfigured WinPCS architecture to meet additional and changing requirements
- Provided accurate, timely and structured progress, acceptance, and hand-over reports
- Input engineering data for mechanical completion / pre-commission / commissioning phases
- Supported Commissioning Engineers in the preparation of inspection test records and indices.
Electrical Commissioning Technician
Kvaerner Oil & Gas Elgin Franklin Hook-up and Tartan Platform Ex-survey
01.2001 - 01.2001
- Responsible for electrical commissioning activities on the hot oil package
- Carrying out Ex surveys of equipment in Hazardous areas and updating the Ex hazardous area database.
Electrical Technician
AMEC Capital Projects Brae Bravo and Miller Projects
01.2000 - 01.2001
- Installation Electrician on the Brae Bravo Platform
- Responsible for installation of cuttings re-injection package on BP Miller
- Decommissioning Electrician on the Miller Platform
- A member of the solstice decommissioning and mothballing team on Brae Bravo.
Electrical Commissioning Technician
Kvaerner Oil & Gas Texaco Captain Bridge Linked Platform Hook-up Project
01.2000 - 01.2001
- Commissioning of Electrical plant on the Texaco Captain BLP
- Responsible for commissioning of LV motors, lighting, small power circuits, trace heating circuits.
Electrical Technician
Total Elf Fina Elgin / Franklin Hook-up Project
01.2000 - 01.2000
- Responsible for electrical commissioning activities on the hot oil package.
Electrical Commissioning Technician
Shell Shearwater Hook-up
01.2000 - 01.2000
- Carrying out Ex surveys of equipment in Hazardous areas and updating the Ex hazardous area database.
Mechanical Completions Administrator
Norske Hydro Snorre Project
01.1999 - 01.2000
- Engaged on Norske Hydro Snorre Project.
Leading Electrical Technician
Esso Balder FPSO
01.1998 - 01.1999
- Leading Electrical Technician on the Esso Balder FPSO for James Scott of Aberdeen.
E. & I. Inspector
BP (ETAP) Offshore Hook-up
01.1998 - 03.1998
- E&I Inspector on the BP (ETAP) Offshore Hook-up for Kvaerner Oil & Gas Limited.
Education
GED -
University of Hertfordshire(Online)
Hertfordshire 01.2020 - Current
High School Diploma -
Scottish Qualifications Authority
Glenrothes 04.2001 -
High School Diploma -
Joint Apprenticeship Council, EIC
Glenrothes 04.2001 -
High School Diploma -
Glenrothes And Buckhaven Technical College
Glenrothes 01.1980 - 05.1983
Skills
30 years in Oil & Gas, LNG, FPSO projects
Mechanical/System Completion & Turnover expertise
Experience with Pre-Comm, Commissioning, and handover
Greenfield/Brownfield site operations in remote locations
Walkdown, MC, and Punchlist coordination
System Boundaries set up and revisions
Onshore/Offshore experience with Client/Contractor
Strong stakeholder engagement and relationship-building
Software Proficiencies
- Microsoft Office Suite of Programs (Excel, Word, PowerPoint, Visio)
- MS Excel / VBA Certification from University of Boulder Colorado
- MS PowerBI
- CMS including PIMS,
- Total ICAPS and new WebICAPS using the OPERCOM Methodology
- WinPCS
- MCPlus
- KEPCS
- HHI-PCS
- CoreWorx
- Documentum
Survivaltrainingcourses
- BOSIET - EBS / OPITO 6th ~ 8th February 2023, expires 7th February 2027
- CB - EBS / OPITO 8th February 2023 does not expire.
Career Outline
Mechanical Completion Specialist / Turnover Engineer and Punchlist Coordinator with 30 years' experience in Oil & GAS, LNG, FPSO & Gas Compression projects across Korea, Russia, Kazakhstan, Europe, and North America.
Software
Excel/VBA for Creative Problem Solving, Part 2
Excel/VBA for Creative Problem Solving, Part 3
Certification
Excel/VBA Creative Problem Solving
Additional Information
FPSO, Gas Compression, LNG, Onshore, Offshore, BOSIET, Turnover, Mechanical Completion, Handover, Punchlist, Punch List, Greenfield, Brownfield, DAC, RFC, RFSU, MCC, MAC
Timeline
Excel/VBA Creative Problem Solving
07-2024
HUC Completions Coordinator
POSCO International at HHI Ulsan Offshore Yard
11.2022 - 4 2024
HUC Pre-Commissioning Coordinator
Absheron EPS Project
02.2022 - 10.2022
Senior Completions Specialist
Tyra Redevelopment Project
06.2020 - 04.2021
GED -
University of Hertfordshire(Online)
01.2020 - Current
Lead Completions Coordinator
TCO FGP/WPMP Project
06.2017 - 09.2019
Preservation Superintendent/Punchlist Coordinator
Inpex Venturer FPSO
08.2014 - 03.2017
Completion & Turnover Engineer
Kashagan Experimental Project
01.2008 - 05.2012
ISO 9001:2000 Internal QMS Auditor
06-2007
WinPCS Advisor/Turnover Coordinator
De-Kastri Oil Export Project
01.2005 - 12.2006
WinPCS Administrator/Turnover Coordinator
BP Maddog project
04.2004 - 11.2004
WinPCS Administrator
AGIP ENI Sabratha Project
12.2003
Commissioning Acceptance Management Technical Support Engineer
British Gas Karachaganak Project
08.2001 - 11.2003
High School Diploma -
Scottish Qualifications Authority
04.2001 -
High School Diploma -
Joint Apprenticeship Council, EIC
04.2001 -
SQA HNC Computing Modules
01-2001
Electrical Commissioning Technician
Kvaerner Oil & Gas Elgin Franklin Hook-up and Tartan Platform Ex-survey
01.2001 - 01.2001
Electrical Technician
AMEC Capital Projects Brae Bravo and Miller Projects
01.2000 - 01.2001
Electrical Commissioning Technician
Kvaerner Oil & Gas Texaco Captain Bridge Linked Platform Hook-up Project
01.2000 - 01.2001
Electrical Technician
Total Elf Fina Elgin / Franklin Hook-up Project
01.2000 - 01.2000
Electrical Commissioning Technician
Shell Shearwater Hook-up
01.2000 - 01.2000
Mechanical Completions Administrator
Norske Hydro Snorre Project
01.1999 - 01.2000
Leading Electrical Technician
Esso Balder FPSO
01.1998 - 01.1999
E. & I. Inspector
BP (ETAP) Offshore Hook-up
01.1998 - 03.1998
High School Diploma -
Glenrothes And Buckhaven Technical College
01.1980 - 05.1983
Systems Completion Database Lead
Sakhalin1 Arkutun-Dagi Project
5 2012 - 8 2013
Similar Profiles
Jang Young (Tiger) ChoiJang Young (Tiger) Choi
Regional Sales Manager in Steel Trading at POSCO International MadridRegional Sales Manager in Steel Trading at POSCO International Madrid
SAEID HAJI NIASAEID HAJI NIA
Account Manager at Posco International CorporationAccount Manager at Posco International Corporation
MAYUR KULTHEMAYUR KULTHE
Sr. HR & Admin Executive at Posco International India Pvt LtdSr. HR & Admin Executive at Posco International India Pvt Ltd