PAUL HOPKINSON

abopgx@r.postjobfree.com

613-***-****

Profile

Supply Chain (PLM) Specialist with over 26 years experience in the telecom

industry working at Ericsson, Nortel Networks, Alcatel-Lucent and

Celestica. Provides seamless Extract, Transform and Load (ETL); and data

warehouse solutions between external partners' PLM systems and internal PLM

systems. Areas of specialization include: Supply Chain solutions,

Engineering to Manufacturing design transfer applications, Supply

Management, Order Management and Logistics. Has experience with Product

Lifecycle Management (PLM), Supply Management and Enterprise Resource

Planning (ERP) systems such as Enovia eMatrix (Matrix One), PTC Windchill,

Agile, SAP, BaaN as well as several other proprietary systems.

Selected Accomplishments

. Completed 30+ extractions of Intellectual Property from Nortel's current

and legacy PLM systems and Supply Management system for the five buyers

of Nortel's assets (Avaya, Ciena, Ericsson, Genband and Kapsch). Worked

with each of the five buyers to help integrate the IP into their

respective PLM systems. All extractions were completed ahead of schedule

and under budget.

. Due to my extensive experience with Nortel's PLM systems I was asked to

return to Nortel after a two year absence to assist with the transfer of

Nortel's IP assets to the final five buyers.

. Successfully completed a complex transfer of intellectual property from

Nortel to Alcatel-Lucent ahead of schedule with zero defects. Due to the

nature and timing of this task, I worked both sides of this transfer,

preparing the data package at Nortel and then receiving and processing

the data package at Alcatel-Lucent.

. Prepared and delivered a complete package of Nortel Intellectual Property

for Nortel's litigation team working on a patent infringement case.

Delivery of the Intellectual Property on-time and in the correct format

prevented a potential stop-sale order from being imposed by the court and

thereby averting a significant loss of revenue.

. Integrated Matra Communications' (France) Engineering data into Nortel's

Product Lifecycle Management system allowing a ramp up to production a

year ahead of the original schedule. The Matra/Nortel work led to a 6

month assignment in France.

. While on assignment in France, simultaneously worked on another Joint

Venture (Micom) with a colleague in North America taking advantage of the

time-zone difference to half the original delivery schedule.

PAUL HOPKINSON

613-***-****

Selected Accomplishments

. Integrated Qualcomm's (CDMA) Intellectual Property into Nortel's Product

Lifecycle Management system facilitating an on time ramp to production.

The size and complexity of the Intellectual Property received required a

significant amount of data transformation and cleansing.

Professional Experience

Volunteer, Continuing Education, Ottawa, Ontario May 2012-

Present

. Volunteer work at my children's school.

o Fundraising, assisting with planning and organizing annual book

fair.

. Continuing Education.

o Training in Microsoft SQL Server 2008/2012.

Ericsson, Ottawa, Ontario Nov 2011-Apr 2012

Data Architect, Analyst

. Design and implement data integration model for population of Nortel IP

into Ericsson's proprietary PLM system.

. Design and develop multiple comprehensive reports based on IP received

from Nortel spanning three business units.

. Worked with internal and external resources assisting with the population

of Nortel IP within Ericsson's proprietary PLM system.

Nortel Networks, Ottawa, Ontario Oct 2009-Nov 2011

Senior Data Architect, ETL Specialist

. Consulted with the five buyers of Nortel's IP assets to assist in their

loading of the newly acquired IP into their respective PLM databases.

. Extracted millions of lines of metadata and >25T of design files from the

PLM and Supply Management systems.

. Defined and set up a data warehouse for IP transfer to the buyers.

. Updated and developed custom applications to speed up transfer of data,

bypassing the existing API's thereby reducing the schedule from weeks to

hours/days.

. Defined and managed data warehouse specification.

Celestica, Ottawa, Ontario Mar 2008-Jun 2009

Senior Data Architect

. Defined architecture for PLM infrastructure to support Global Design

Services.

. Worked with IT team finalizing budget for rollout of multiple design

tools.

. Defined and set up Change Management process within Celestica's eMatrix

system.

. Worked on contract with design teams from Microsoft to define their

Change Management processes within Celestica's eMatrix system.

PAUL HOPKINSON

613-***-****

Professional Experience

Alcatel-Lucent, Ottawa, Ontario Mar 2007-Jun 2009

System Integration Engineer (Supply Chain)

. Played a lead role in the cross-company Nortel/Alcatel-Lucent integration

team.

. Extracted the Intellectual Property from the Nortel Engineering systems

and prepared that IP for integration into the Alcatel-Lucent Supply

Chain.

. Transitioned the former Nortel UMTS Engineering Teams in Canada and

France into the Alcatel-Lucent Supply Chain. This transition included

training business primes, working with business units to define new

hybrid processes related to the Alcatel-Lucent tools. Developed new data

models to support the hybrid processes.

. Defined a hybrid Change Management process and acted as EC coordinator

for the former Nortel products using Alcatel-Lucent's eMatrix system.

Nortel Networks, Ottawa, Ontario Oct 1986-Feb 2007

ETL (Supply Chain) Subject Matter Expert (2002-2007)

. Consulted on architectural decisions regarding the decommissioning of the

Nortel legacy PLM system. Worked with customers to insure that legacy

data was transferred seamlessly to a new PLM system.

. Interfaced legacy file storage system containing over 5 million ECAD and

MCAD files (more than 4 Terabytes) to the new system decreasing the

projected migration time from years to months.

. Packaged and transferred over 1 Terabyte of Intellectual Property from

the Engineering and Manufacturing systems for 35 divested product lines

to various companies such as Zhone Technologies, Arris and BreconRidge.

Global Operations (2000-2002)

. Worked on the development of the Data Access Portal, a tool used by

contract manufactures to access data required for the manufacturing.

. Member of several Business Transformation teams defining and documenting

new Business Processes related to Product Lifecycle Management.

. Defined a new part-numbering process and Engineering Bill of Material

data model to mitigate design/ordering issues related to customer

notification of product evolution.

. Prepared a white paper comparing Industry Standard Bill of Material Part

Management Process vs. Nortel's legacy Engineering Documentation System.

NT Corporate (1992-2000)

. Worked on acquisitions and joint ventures moving Intellectual Property

from the partner companies' PLM systems into the Nortel PLM system.

. Developed tools for on-going transfer of Intellectual Property between

partner companies and Nortel.

. Spent 6 months as an ex-pat in France working on the Matra/Nortel joint

venture.

PAUL HOPKINSON

613-***-****

Professional Experience

Software Engineer (1986-1991)

. Administrator of a Hardware Integrity database in the R&D labs.

. Spent 1 year in Raleigh, NC co-developing a new (replacement) Hardware

Integrity database for the R&D labs.

. Deployed the database and trained staff at 8 R&D labs in North America

and Europe.

Awards

. Presidential Award of Excellence

. Award of Merit

. Pride Award

Education

St Lawrence College (1981-1984), Kingston, Ontario

. Electrical Engineering Technologist Diploma

Professional Development

Nortel Networks, Ottawa, Ontario

. Project Management Tier I & II

. Ethical Business Practices Certification

Professional Development

Queens University, Kingston, Ontario

. Software Engineering Courses

Carleton University, Ottawa, Ontario

. Electrical Engineering Courses

Skills/Proficiencies

ERP, PLM, ETL (Extract, Transform, Load), Data Warehouse, Big Data, Enovia

eMatrix (Engineering Central, MQL, Business Object/Data Modeling), PTC

Windchill, SAP, BaaN, Agile, SQL, Microsoft Office (Access, Excel, Word,

PowerPoint), Visual Basic, VBA, UNIX scripting (perl, tcl, ksh, etc), PC

Scripting, C, Java, html, XEDIT, REXX

Contact this candidate