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: **********@*****.***
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 ******-*******@**.******.***
Kirt *****-****.*****@*******.**
Charles ******-********@*******.***
Olga Doldan *****-***********@*******.***