Technology Consultants

       Turning Data into Information 

                     

             Email: lbailey@lbaileyinc.com  

                 Phone: (206) 782 - 8054

 
 
 

    Home   Resume    Endorsements    Contact Us

   Resume

Lawrence David Bailey

 

A senior data processing professional with over twenty years consulting experience as a project manager, business analyst, System Architect, Data Architect and DBA of business and scientific systems.  Project experience includes multi-tier environments using multiple operating and files systems in the development of OLTP and OLAP applications.

 

Talents

Project Management

Technical Management

Off-shore Engagement Management

Business Analysis

Data Warehouse/Mart Design

Requirements Definition

Performance and tuning

Solution Architecture

Data Conversion (ETL)

Application Design

Application Development

Automated Tool Development

Testing Methods

Database Design

Production Implementation

Database Administration

 Recruiting

Mentoring

Documentation

SOA Service Components Design

Data Retention and Archive

 

 

 

Expertise

CRM

Marketing

Portfolio Management

Investment Banking

Finance

Taxes

Document Tracking

Security

Federal Welfare Programs

Criminal Tracking

Manufacturing

Inventory Management /

Supply Chain

Oracle ERP

Oracle Financials

 Billing

Credit Card/EFT

Oracle TCA

Oracle Order Entry

Oracle Order Management

Oracle AP

Technologies

Oracle Unix

Oracle NT

PL/SQL

Oracle Application Suite

SQL

UNIX Script

Perl

Java

Informatica

MS/SQL

BPEL

XML

Data Hub

UTL_HTTP

SOAP

 

     

Education:    University of Michigan

                                 MBA in Financial Management

                                 MSW in behavioral psychology         

 

Major Consulting Experience

 

     Lawrence Bailey & Associates, Inc. - 7/2000 - present

     

World Vision, Seattle, WA - 7/2000 10/2008

 

Title:

Senior Architect/Lead Developer

Environments:

Oracle 9i, UNIX

Oracle 10g, Linux

Application:

Oracle Applications 11.5.8

Oracle custom applications Donor Services Platform

Web iStore integration for credit card / EFT on the web

SOA Party Service component

NCOALink Web Service XML interface

 

Responsibilities:

 

      Architectural responsibility for integration of billing to World Vision customers on the Web.  Oracle integration components include: Order Management, Order Entry, Accounts Receivable and Credit Card/EFT interface with ACH vendors.

      Overall architectural responsibility for the design of Party Service component (SOA).

      Overall architectural responsibility for web service (XML) interface with USPS NCOALink.

      Responsible for SQL performance tuning and overall application adherence to SLA.

      Responsible for Data Retention and archive design and development.   

      Responsible for providing level of effort estimates and project tasks to management.  This includes monitoring actual against estimated and escalation of issues when appropriate.

      Responsible for turning business requirements into technical specifications and database design.

      Responsible for adhering to SDLC methods and standards during the project development cycle. This includes creation of documentation allowing traceability of business rules to specifications, program components and unit testing.

      Responsible for the creation of production deployment plan, including the creation of installation scripts, both manual and technical.  This responsibility includes testing the deployment scripts in multiple test environments.

      Responsible for 24 hour post-production support.

      Responsible for designing and writing pl/sql and Korn Shell objects.

 

 

Title:

Senior Architect/Lead Developer

Environments:

Oracle 9i, UNIX

Oracle 10g, Linux

Application:

Oracle Applications 11.5.8

Oracle custom applications

Large Oracle Dimensional Data warehouse

 

Responsibilities:

 

      Overall architectural responsibility for application projects including, Oracle Financials, TCA, Order Entry, Order Management, Inventory Management, iStore, custom extensions, xml interfaces, SOA Service components, and large data warehouse (1.7 terabytes).  This includes participation in coordinating project activities with business, management, testing, reporting and production support groups

      Responsible for SQL performance tuning and overall application adherence to SLA.

      Responsible for data retention and archive design and development.

      Responsible for providing level of effort estimates and project tasks to management.  This includes monitoring actual against estimated and escalation of issues when appropriate.

      Responsible for providing technical management, leadership and mentoring for up to five customer employees.  This includes knowledge transfer and work assignment to project team members.

      Responsible for providing technical management and leadership for offshore engagements. This includes the development and execution of acceptance criteria.

      Responsible for turning business requirements into technical specifications and database design.

      Responsible for adhering to SDLC methods and standards during the project development cycle. This includes creation of documentation allowing traceability of business rules to specifications, program components and unit testing.

      Responsible for the creation of production deployment plan, including the creation of installation scripts, both manual and technical.  This responsibility includes testing the deployment scripts in multiple test environments.

      Responsible for 24 hour post-production support.

      Overall architectural responsibility for the implementation of Oracle Business events and Oracle Workflow.

      Responsible for designing and writing pl/sql and Korn Shell objects.

 

 

Title:

Senior Architect/Lead Developer

Environments:

Oracle 9i, UNIX

Application:

Oracle Application 11.5.8

Custom Credit Card/EFT application

 

Responsibilities:

 

      Overall architectural responsibility for Credit Card / EFT solution.

      Business Analysis supporting requirements to replace Oracle iPayment module and provide Credit Card and EFT processing reconciliation.

      Responsible for SQL performance tuning and overall application adherence to SLA.

      Responsible for data retention and archive design and development.

      Responsible for providing level of effort estimates and project tasks to management.  This includes monitoring the actual against estimated and escalation of issues when appropriate.

      Responsible for coordinating project activities with business, management, testing, reporting and production support groups.

      Responsible for turning business requirements into technical specifications and database design.

      Responsible for providing technical management, leadership and mentoring for three customer employees.  This includes knowledge transfer and work assignments to project team members.

      Responsible for Credit Card / EFT Vendor coordination.

      Responsible for adhering to SDLC methods and standards during the project development cycle. This includes creation of documentation allowing traceability of business rules to specifications, program components and unit testing.

      Responsible for the creation of production deployment plan, including the creation of installation scripts, both manual and technical.  This responsibility includes testing the deployment scripts in multiple test environments.

      Responsible for 24 hour post-production support.

      Responsible for designing and writing pl/sql, Oracle analytic functions and Korn Shell objects. 

 

 

Title:

Senior Architect/Lead Developer Performance enhancements

Environments:

Oracle 9i, UNIX

Application:

Oracle Application 11.5.8

Custom Oracle Applications

Large Dimensional Data Warehouse

 

Responsibilities:

 

      Responsible for overall project management of Oracle Applications post go live performance enhancement projects.

      Responsible for the redesign and implementation of the process architecture (ETL) supporting dimensional eCRM data warehouse.  Run time was reduced from 14 plus hours to less than one hour.

      Overall architectural responsibility for the re-design of Inventory distribution.  Existing process was I/O contained and unable to support transaction levels of 3500 per day.  New architecture is able to support 3500 plus transaction per second.

      Responsible for providing benchmarks to validate performance enhancements.

      Responsible for providing level of effort estimates and project tasks to management.  This includes monitoring the actual against estimated and escalation of issues when appropriate.

      Responsible for coordinating project activities with business, management, testing, reporting and production support groups.

      Responsible for turning business requirements into technical specifications and database design.

      Responsible for providing technical management, leadership and mentoring for three customer employees.  This includes knowledge transfer and work assignments to project team members.

      Responsible for adhering to SDLC methods and standards during the project development cycle. This includes creation of documentation allowing traceability of business rules to specifications, program components and unit testing.

      Responsible for the creation of production deployment plan, including the creation of installation scripts, both manual and technical.  This responsibility includes testing the deployment scripts in multiple test environments.

      Responsible for 24 hour post-production support.

      Responsible for providing technical management and leadership of offshore engagements.

      Responsible for designing and writing pl/sql, Oracle Analytic functions and Korn Shell objects.

 

 

Title:

Conversion Senior Architect/Lead Developer

Environments:

AS/400, Oracle 8i, UNIX, Oracle 9i, UNIX 

Application:

Multiple disparate Legacy Systems

to Oracle Application 11.5.8 Conversion

 

Responsibilities:

 

      Overall Architectural responsibility for Legacy Conversion to Oracle Application 11.5.8 Open Interface and API target entry points.  The conversion included Oracle financials, TCA, Inventory, Order Management and Install Base modules.

      Overall responsibility for the design and implementation of ETL procedures.

      Responsible for providing technical management, leadership and mentoring for seven customer employees and contractors.  This includes knowledge transfer and work assignments to project team members.

      Business analysis responsibilities supporting the CIO and Business Leadership.

      Oracle UNIX DBA responsibilities.

      Responsible for designing and writing pl/sql and Korn Shell objects.

 

 

Title:

CRM Data Warehouse Senior Architect/Lead Developer

Environments:

Oracle 8i, UNIX

Application:

Large Oracle Data Warehouse eCRM

 

 

Responsibilities:

 

     Overall Architectural responsibility for eCRM solution.

      Project Management responsibility for integrating financials into the eCRM warehouse.

      Management responsibility for up to seven employees and contractors.

      Design and implementation of three data Marts

1.      Sales Force

2.      Mass Marketing

3.      Financials forecasting and costing

      Oracle UNIX/NT DBA responsibilities

      Design and implementation of a multi-tier object oriented warehouse/data mart ETL process architecture.

      Responsible for designing and writing pl/sql objects.

 

 

Xchange, Inc.  11/1999 07/2000

 

Staples, Framingham, MA 2/2000 7/2000

 

Title:

Business Analysis/System and Data Architect

Environments:

Oracle 8.0.6, UNIX/NT, Informatica

Application:

eCRM

  

 

Responsibilities:

 

        Business Analysis providing Gap Analysis.

        Overall Architectural responsibility for eCRM solution

        Data Mart design and implementation

        Oracle UNIX/NT DBA responsibilities

        Design and implement ETL procedures, PL/SQL and Informatica

        Design and implement triggers

 

 

Ameritrade Chicago, IL 11/1999 5/2000

 

Title:

Oracle DBA

Environments:

Oracle 8.0.6, NT, Informatica

Application:

eCRM 

 

Responsibilities:

 

        Oracle NT DBA responsibilities

        NT server maintenance

        Design and implement procedures, PL/SQL and Informatica

        Design and implement triggers

 

EDEN Technologies 7/1999 11/1999

 

I-CUBE International Integration INC. Cambridge, MA 7/1999 11/1999

 

 

Title:

System Architect

Environment:

Visual Basic, COMTI, Microsoft SNA Server, CICS, DB2, COBOL, Microsoft Windows NT, MFE (Micro Focus Mainframe Express),  XDB                        

Application:

Financial system for Mercedes Benz Credit Corp. 

 

Responsibilities:

 

      Overall Architectural responsibility from multi-tier system environment (Visual Basic, COMTI, CICS, DB2)

      Designed and prototype Architectural controls to manage data integrity and COMTI communication area limitations.

      Data Architect responsibilities

      DB2 DBA responsibilities

      Application Architect responsibilities

      Technical Design of complex business processes   

      Customer skills transfer

 

IBM 12/1989 12/1998

 

IBM Chicago, Chicago, IL 1/1997 12/1998

 

Title:

System Architect/Conversion specialist

Environment:

 MVS, JCL, DB2, COBOL OS/2, and REXX

Application:

Year 2000 estimating tool, RA

 

 

Responsibilities:

 

      Developed COBOL parser that populates RA relational data architecture

      Developed JCL parser that populates RA relational data architecture

      DB2 DBA responsibilities

      Received formal year 2000 business analysis training

      Performed five year 2000 business analysis, project schedules and man hour estimates

1.      NationsBank Charlotte, NC

2.      Jefferson Pilot Greensboro, NC

3.      Oklahoma City Light and Gas - Oklahoma City, OK

4.      Barnett Bank - Jacksonville, FL

5.      Mutual of Omaha - Omaha, NE  

 

Equicredit, Jacksonville, FL 3/1995 1/1997

 

Title:

System Architect/Conversion specialist

Environment:

AIX, CICS6000, DB26000, SCRIPT, and Microfocus COBOL

Application:

Multiple Financial systems

 

 

Responsibilities:

 

      Developed tool to parse Honeywell JCL and forward engineer to UNIX SCRIPT

      Developed tool to parse Honeywell COBOL and forward engineer to Microfocus Cobol

      DB2/2 DBA responsibilities

      Defined all phases of testing

      Production implementation

 

Leon County, Tallahassee, FL 2/1994 3/1995

 

Title:

Project Manager/DBA/Conversion Specialist

Environment:

VM, SQL/DS, and CSP

Application:

Criminal tracking system

 

Responsibilities:

 

      Developed tool to convert legacy system free form text (dockets) to structured input format

      Developed tool to load the input device to process structured data to criminal tracking system data base

      SQL/DS DBA responsibilities

      Fiscal Management

      Business analyst

      Recruitment

      Management of up to ten employees / contractors / data entry personnel

 

State of Florida HRS, Tallahassee, FL 10/1992 2/1994

 

Title:

Project Manager

Environment:

MVS, JCL, DB2, and CSP

Application:

Project Independence, PI (JOBS)

 

Responsibilities:

 

        Fiscal Management

        Business analyst

        DB2 DBA responsibilities

        Management of up to seven employees / contractors

        Recruitment

        Design

        Coding

        All phases of testing

        Technical documentation

        Publication of user manual

        State wide implementation

 

 

 

State of Florida HRS, Tallahassee, FL 3/1991 7/1993

 

Title:

Project Manager

Environment:

MVS, JCL, DB2, and CSP

Application:

Woman Infants and Children, WIC

 

Responsibilities:

 

        Fiscal Management

        Business analyst

        DB2 DBA responsibilities

        Management of up to fifteen employees / contractors

        Recruitment

        Design

        Coding

        All phases of testing

        Technical documentation

        Publication of user manual

        State wide training

        State wide implementation

 

Florida Power and Light St. Lucie Nuclear Plant, St. Lucie, FL 3/1990 3/1991

 

Title:

System Architect

Environment:

 MVS, JCL, DB2, ISPF Dialog Manager, and COBOL

Application:

Entrance Security

 

Responsibilities:

 

        Management of twelve application programmers

        Development of DB2 COBOL code generator

        DB2 DBA responsibilities

 

 

Boroughs Welcome, RTP, NC 12/1989 3/1990

 

Title:

DBA

Environment:

VM, SQL/DS, and QMF

Application:

Multiple databases

 

Responsibilities:

 

        Development/installation of SQL/DS DBA tools.

        SQL/DS DBA responsibilities

        SQL/DS DBA responsibilities

 

 

Computer Task Group 7/1987 12/1989

 

USS POSSCO, Pittsburgh, CA 3/1989 12/1989

 

Title:

Manager of Data Base Administration

Environment:

MVS, JCL, IMS DB/CICS, and COBOL

Application:

Manufacturing

 

 

Responsibilities:

        Fiscal Management

        Customer interface

        System availability

        System performance

        Data integrity

        Data recovery

        Management of three IMS DBA'S

 

MBANK Dallas, TX 12/1988 3/1989

 

Title:

Conversion Specialist - DBA

Environment:

MVS, DB2, FOCUS, and QMF

Application:

Investment Banking

 

Responsibilities:

 

        Design of relational data architecture

        DB2 DBA responsibilities

        Data Conversion from FOCUS to DB2

        Data Integrity

 

Texas Utilities at Glen Rose Nuclear Plant, Glen Rose, TX 11/1987 12/1988

 

Title:

DBA

Environment:

VM, SQL/DS, REXX, and CSP

Application:

Document Tracking

 

 

Responsibilities:

 

        Design of relational data architecture

        SQL/DS DBA responsibilities

        Data Conversion from multiple OEM (non-IBM) platforms to SQL/DS

        Data Integrity

        Development of SQL/DS DBA tools.

 

 

Hyundai Corporation, Orange County, CA 7/1987 11/1987

 

Title:

DBA

Environment:

MVS, JCL, DB2, QMF, and CSP

Application:

Marketing Information System

 

Responsibilities:

 

        Customer skills transfer

        Relational data base design

        Legacy application conversion

        Legacy data conversion

        DB2 DBA responsibilities

 

Southeastern Computer Corporation 3/1984 7/1987

 

Mobile Oil Corporation, Dallas, TX 12/1985 7/1987

 

Title:

Programmer/Analyst

Environment:

MVS, JCL, DB2, ISPF Dialog Manager, and COBOL

Application:

Sales Tax

 

 

Responsibilities:

 

        Relational Data Base design

        Application design                                                         

        Program specifications

        Application development

        Unit testing

        System Testing

        Production implementation

        DB2 BETA training

        DB2 DBA training

 

Mobile Oil Corporation, Dallas, TX 3/1984 11/1985

 

Title:

Programmer/Analyst

Environment:

MVS, JCL, IMS DB/DC, and COBOL

Application:

Property Tax

 

Responsibilities:

 

        Application development

        Unit testing