Name: Lawrence Preston Pipella

Address: **** *. *** ** ******

City/State Scottsdale, Arizona 85260

Occupation: Global/Architecture and Design Practice Chair

Phone Work: 480-***-****

Home: 480-***-****

Cell Home: 480-***-****

E-Mail: acsrq9@r.postjobfree.com

Hardware: IBM Mainframes, AS/400, Sun, HP-UX, Tandem

Technical Professional Skills: Enterprise Architect, Infrastructure Architect, Data Architect, Senior Business Architect-Data Warehouse, QA Manager, Project Manager,

Senior Systems Analyst, Senior Software Engineer, Manager of Software Engineers, Senior Business Analyst, Senior Programmer/Analyst, Principal Database Analyst,

Knowledge Management, Teradata, DBA-(ORACLE,DB2,UDB),INFORMIX.SYBASE,IMS

Case Tools: Workbench, IBM Rational Suite, UML, Enterprise Architect, Power Designer, Erwin

TeraData:Manager of Installation, ETL, Load and Design of BI Data Warehouse.

Technical Responsibilities:

Global Enterprise Architect

Technical Skills/Software: SAP, PeopleSoft, JD Edwards, SAS, Mac Pac D,

American Software, McCormick & Dodge, Walker Accounting, Hogan, DB2, DB2/UDB, ORACLE, MS/SQL, NOMAD, TOAD, Workbench, MS Project Manager,SOA Architecture,Informatica, Cognos, Brio, MicroSoft Products, Mercury, WinRunner, Test Director, LoadRunner, TestBytes, ETL, Ascential-Data Stage, etc…

Technical Skills/Languages:Cobol, Fortran, Assembler, PL/SQL, SQL, QMF,

C++, UNIX Script

Experience

11/07/2008-Current -Consultant, Scottsdale, Az

1Architecture & Design

2Data Architect, Enterprise Architect

3Senior Business Architect

4Data Management /ETL

Experience Expansion

As Architect and DBA deployed business intelligence design. Responsible for modeling; Logical and physical. Responsible for Solution and Enterprise

Architecture.

06/2002 to 11/07/2008 Present Global Enterprise Architect, Principal Infrastructure Engineer. DHL,Scottsdale, Az

1 Architecture & Design

2 Data Architect, Enterprise Architect

3 Senior Business Architect

4 Data Management /ETL

1 Architecture & Design Practice Chair (Manager of Supply Infrastructure Architects)

2 Data Architect, Enterprise Architect

3 Senior Business Architect

7Data Management /ETL

8Infrastructure support for QA to Data Base Administration

9Teradata Design/Management

10Global participation in Data and messaging standard

Experience Expansion

As a Global Enterprise Architect I was responsible for defining the sources of Knowledge (KM) and creating rules of governance and centralized repositories for this knowledge, worked with both development and business parts of our organization.

As a Data Manager/Data Architect regulated data quality for the region and global community. As part of the DM functions guided three ETL staff in sourcing and

clean zing data for regional/global BI Data Warehouse. Served in an Architecture Infrastructure capacity supporting major and minor integrations.

Managed Teradata install and test and QA beds. Reported to upper management. Handled issues between management and vendor (NCR). Data modeling;logical and physical. Part of the team maintaining Corporate Data Model.

10/2000 to 6/2002 Senior Database Analyst Fedex Freight, Phoenix, Az

1 Enterprise Infrastructure and Data Architect

2 Software Developer for Costing, Customer, and AR systems LTL

3 Migration and Integration of Business systems

4 Developed logical and physical models for new systems

5 Design on Enterprise components of LTL system

Experience Expansion

As Architect and DBA deployed the business and global tracking Data Warehouse,DB2, ORACLE, to provide business intelligence. Responsible for modeling;

Logical

and physical. Responsible for Solution and Enterprise architecture,

10/1998 to 10/2000 DataBase Specialist Principal ASU, Tempe, AZ

1 Data Base Administrator DB2, Data Architecture

2 Liaison to Developers on use of DB2 and performance

3 Developed logical and physical Data Models

4 Y2K Project Manager

5 SAP technical support for New ASU student administration system

Experience Expansion

Responsible for Y2K project. As a Database Specialist Principal responsible for regulating Database,DB2, designs, and software deployment. Responsible for

modeling; Logical and physical.

Lead SAP project for a new admin system.

10/1995 to 10/1998 Architect, QA Manager, Project Manager, Senior Systems Analyst,Database Specialist Bank One, Phoenix, Az

1 Developed and published QA Standards for Bank One

2 Developed and Published Project Management Standards for Bank One

3 Senior Business Architect for Data Warehouse for Risk Management

4 Developed systems for tracking Retail performance on Bank products

5 DA/DBA analysis for Hogan deposit systems

Experience Expansion

Built Data Warehouses, DB2,IMS, with business and sales analytics. Responsible for modeling; Logical and physical. Wrote the Project Management and QA

Standards and Procedures for the bank including training. As a pre-requisite took all of the PMI classes. Built another Data Warehouse,DB2, for Hogan conversion.

8/1993 to 10/1995 Infrastructure Architect, ORACLE DBA, Senior Programmer/Analyst

Best Western, Phoenix, Az

1 Infrastructure Architect

2 Database development for new Reservation system

3 Support for world wide business systems and financials

4 Technical supported for Controller and CIO

5 Participated in writing specifications to change business and reservation system

6 EDI and data warehouse support for business and financial sector

7 Participated in benchmark team for new software and hardware systems

Experience Expansion

As a Senior programmer Analyst I was responsible for enhancing, and supporting the existing systems at Best Western. Wrote specifications to move both the

reservation and business system from a mainframe environment to a production server environment. Took ORACLE DBA training to build the Data Warehouse for

storing business and client information. Responsible for modeling; Logical and physical.

04/1991 to 08/1993 Project Manager Plutus Co., Scottsdale, Az

1 Planning, development, and installation of Juvenile Detention Student system

2 Infrastructure Architect

3 Writing specifications to spare and part military weapon systems in Saudi Arabia

4 Project team architecting hardware and software for component system

5 Supported accounting and financial system

Experience Expansion

As a project manager and developer I deployed a Data Warehouse, DB2, for tracking Juvenile clients in the Buffalo Soldier program. Juveniles were from all over the

US. Trained staff in the use of the system which contained educational, criminal, and psychological profiles.

I became engaged in a project as a Senior Software engineer to design, and install a system in a Data Warehouse,DB2, sparing and parting all ground weapon systems

in Saudi Arabia. This included deploying mainframes in Jeddah, and Riyadh, prior to Desert Storm. Responsible for modeling; Logical and physical.

07/1986 to 04/1991 Manager Sr. Software Engineers Motorola GEG Scottsdale, Az

1 Manufacturing software full life cycle support

2 Interface between manufacturing, and design engineering

3 Enterprise participation at Corporate level President’s committee

4 Manager of 20 software engineers, engineering support

Experience Expansion

Managed twenty Senior Software Engineers supporting Design and Manufacturing.

Developed a major Data Warehouse,DB2, for storing design information. Responsible for modeling; Logical and physical. Our efforts resulted in a 9 layer board,

6-SIGMA

09/1984 to 07/1986 IT Manager Sunland Industries, Phoenix, Az

1 Benchmarked manufacturing and accounting systems

2 Vice President for Acquisitions

3 Project Manager for team installing accounting and manufacturing system

Experience Expansion

As the IT Manager lead the project to install accounting software on an IBM System 38 for a manufacturing system. Handled training and departmental issues

concerning the system.

As Vice President for acquisitions reviewed candidates and prepared financial analysis of potential acquisitions. Worked with major brokerage houses in releasing corporate announcements.

Developed a major Data Warehouse to manage inventory and WIP processes. Responsible for modeling; Logical and physical

03/1981 to 09/1984 Senior Systems Analyst, Enterprise Infrastructure Architect, Mobil Oil Denver, Co

1 Feasibility study for accounting and technical mining systems

2 Bench marked systems

3 Installation and support of accounting and mining systems

Experience Expansion

As a Senior Systems Analyst as was responsible for supporting our mining, oil, and gas operations regionally and globally. I wrote specifications and supported

hardware and software needs for operations regionally and globally. Answered to my manager and the Vice President of Western and Asia hemisphere operations.

The mining, oil, and gas data was stored in a Data Warehouse,Focus, System 2000, IMS, which I built in IMS and System 2000.

Responsible for modeling; Logical and physical

Education

B.S. Political Science

System Analysis and Design, IBM

QA Mercury Products – Bank One

ORACLE DBA – Best Western

DB2/UDB DBA – Motorola GEG

Architect, DBA-IMS DB/DC – Mobil Oil

References

Roger acsrq9@r.postjobfree.com

Kirt acsrq9@r.postjobfree.com

Charles acsrq9@r.postjobfree.com

Olga Doldan acsrq9@r.postjobfree.com

Contact this candidate