Project Oracle

Title:Systems Analyst

*******@*****.***

Document

Source below

NAME:,

ADDRESS:

ADDRESS2:

CITY:

STATE:

ZIP:

CANDIDATE ID: 2930329

US CITIZENSHIP:

EDUCATION:

EXPERIENCE: 0

WILL RELOCATE: No -

JOB WANTED:

RATE NEEDED:

TELEPHONE:

EMAIL: *******@*****.***

HOMEPAGE:

HOTTEST SKILLS: oracle, database, sql, market, marketing, proposal, solaris, unix,

product, lien, database administrator, information systems, vms, banking, credit,

statement, data modeling, microsoft, programmer, communication

REVISION: 08-SEP-02

RESUME:

NAME: Thomas Pratt

ADDRESS: 642 S. Batchewana

CITY: Clawson

STATE/PROVINCE: MI

ZIP/POSTAL CODE: 48017

COUNTRY: USA

EMAIL: *******@*****.***

PHONE:

CANDIDATE ID: 220535

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 10

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

COMMENTS:

HOTSKILLS: Oracle, SQL, PL/SQL, SQL Server, Visio, Visual Basic, UNIX,

ESUME

Career Summary

Mr. Pratt has been in the information technology industry for 10 and one half

years. He has extensive experience working on database design and

implementation. He has excellent knowledge of Logical Data Modeling (LDM),

development, conversion, and enhancement projects. He has experience in

analysis, design, code modification, and implementation of various software

projects. In many occasions, he has acted as a mentor or a team leader. Mr.

Pratt also has great knowledge of Oracle and MS SQL*Server. He works well with

others and his technical abilities are complimented nicely by his verbal and

written communications skills. These attributes along with his willingness to

help would make him an asset to any organization.

Tools Experience

Hardware Sun E250,E450 & SPARC Station Intel based PCs &

Compatibles. HP 9000 Compaq/Digital Alpha IBM 3090

Operating Systems UNIX (Solaris, HP Unix) Windows NT/2000

Open VMS

Databases Oracle 7.X Oracle 8.0.5 Parallel server Oracle

8i MS SQL*Server 7.0 Sybase 12.0

Languages PL/SQL Transact SQL Visual Basic

Software/Other Oracle Enterprise Manager plus Performance pack

Oracle Web Application Server Version 3.0 Developer/2000

Designer/2000 Oracle SQLPlus Oracle SQLLoader Structured

Query Language (SQL) CA ErWin/ModelMart Quest SQLLab Compaq/Digital

Code Management System (CMS) Word Excel Visio Access Project

ODBC Embarcadero ERStudio Embarcadero DBArtisan Query

Management Facility (QMF) ProEdit

Professional Accomplishments

Destiny WebSolutions - Bank of New York Private Banking February 2001 to July

2001

Senior Data Architect

Mr. Pratt worked on the Private Client Web (PCW) project. The technical

objective of this project was to provide customers online access to their

portfolio statements. The architecture used a java front-end and the business

logic was implemented on a separate Web Logic application server and a data

abstraction layer within the database. The relational database stored legacy

financial data that was refreshed on a daily basis. The proposed system will

provide the capability for the customer to aggregate multiple accounts and

grant access to interested third parties.

Mr. Pratt was involved in the following activities:

Senior Data Architect solely responsible for back end design of private

banking web system.

Developed project plans and resource allocation estimates in

conjunction with Senior Project Manager and Senior Web Architect

Designed system level architecture to support scalable, maintainable

system, working closely with Senior Web Architect.

Proactively interacted with client in a joint development environment,

successfully facilitating generation of requirements from business and

technical team members.

Implemented user security and authorization through data abstraction

layer consisting of stored procedures and views. This architecture promoted

critical communication between application and database developers, delivering

a flexible and extensible system.

Developed legacy systems integration process, consisting of physical

database design, process flow, and daily loads job from source system extracts.

HARDWARE: Sun E250, Intel based PC

SOFTWARE: Sun Solaris, Sybase Adaptive Server Enterprise v12.0,

Embarcadero DBArtesian, CA ErWin

Destiny WebSolutions Brinker Capital December 2000 to July 2001

Senior Data Architect

Mr. Pratt worked on the ProGen project. The ProGen system provided Brinker the

capability of providing their internal investment advisor and independent

broker to generate investment proposal for high net worth customers. The

architecture was a Microsoft n tier architecture leveraging a data abstraction

layer allowing developers a stable yet flexible database environment.

Mr. Pratt was involved in the following activities:

Primary Data Architect for high net worth investment proposal

generation system.

Worked with Web Architects on design of data abstraction layer,

consisting of stored procedures and views.

Tuned and/or rewrote existing stored procedures reducing runtime from

three minutes to 10 seconds

HARDWARE: Intel based Server and PC

SOFTWARE: Microsoft Windows 2000, SQL*Server 7.0, Embarcadero ERStudio (Data

Modeling tool).

Destiny WebSolutions Citigroup Private Banking November 2000 to

December 2000

Senior Data Architect

Mr. Pratt worked on the Private Banking portal project. This portal provided

high net worth customers with a single access point to the Citigroups

available sites. The technical objective of this effort was to log the login

event of the portal at the user level. The product allowed Citigroup employees

to download various reports providing stratification statistics of user

activity.

Mr. Pratt was involved in the following activities:

Developed logging package (PL/SQL) to supplement Web Trends site

activity statistics.

Advised development team on the design of a long-term maintainable and

scalable database.

HARDWARE: Sun E250, Intel PC

SOFTWARE: Sun Solaris, Oracle 8.0.5, Oracle Procedure Builder and Embarcadero

ERStudio

Destiny WebSolutions Fleet Credit Card Services -eBusiness July 2000 to

October 2000

Senior Data Architect

Mr. Pratt worked on the Real Time Marketing project. The technical objective

of this project was to provide a single real time marketing engine for all of

Fleets eBusiness initiatives. A real time marketing product was extended

through customized Oracle packages to use Fleets database design.

Mr. Pratt was involved in the following activities:

Primary Oracle consultant (DBA and Developer) for development team

consisting of Fleet employees and their subcontractors.

Primary Database Designer/Developer for Fleets eBusiness architecture

working with Fleets Systems Architect Manager.

Responsible for Oracle performance tuning of all Fleets eBusiness

applications.

Designed and managed Fleets enterprise data model using ErWin and

ModelMart.

Lead Database Designer for Fleets Real Time Marketing

(Personalization) project that personalizes all offers presented by Fleets

websites (Online Application and Card Member Access).

HARDWARE: Sun E450, Intel PC

SOFTWARE: Sun Solaris, Oracle 8i Release 2 (version 8.1.6), Oracle Procedure

Builder, Oracle SQLLoader, CA ErWin

Walkett Group Fleet Credit Card Services -eBusiness December 1999 to July

2000

Information Systems Consultant

Mr. Pratt worked on the Real Time Marketing project. The technical objective

of this project was to provide a single real time marketing engine for all of

Fleets eBusiness initiatives. A real time marketing product was extended

through customized Oracle packages to use Fleets database design.

Mr. Pratt was involved in the following activities:

Primary Oracle consultant (DBA and Developer) for development team

consisting of Fleet employees and their subcontractors.

Primary Database Designer/Developer for Fleets eBusiness architecture

working with Fleets Systems Architect Manager.

Responsible for Oracle performance tuning of all Fleets eBusiness

applications.

Designed and managed Fleets enterprise data model using ErWin and

ModelMart.

Lead Database Designer for Fleets Real Time Marketing

(Personalization) project that personalizes all offers presented by Fleets

websites (Online Application and Card Member Access).

HARDWARE: Sun E450, Intel PC

SOFTWARE: Sun Solaris, Oracle 8

i Release 2 (

version 8.1.6), Oracle Procedure

Builder, Oracle SQLLoader, CA ErWin

Walkett Group Fleet Credit Card Services

July 1999 to December 1999Information Systems Consultant

Mr. Pratt worked on the re-architecture of Relationship Management System

project. The technical objective of this project was upgrading the existing

the RMS and migrating from a VAX/flat file to a Unix/Oracle platform. This

system proved Fleet Customer Service Representative with customer information

including current transactions and six months of statement history. The

database was approximately 400 GB with 5GB being loaded on a daily basis.

Mr. Pratt was involved in the following activities:

Primary Database Designer/Developer for re-architecture project moving

RMS indexed file to Oracle RDBMS.

Primary Oracle Consultant for development team consisting of Fleet

employees and their subcontractors.

Normalized data structure to reduce storage requirements and improve

production load performance.

Created logical and physical model using ErWin.

Developed partition plan for credit card statement history.

Designed and developed all Oracle stored packages and database triggers

used in manipulating and loading source data.

HARDWARE: HP N Class, Intel PC

SOFTWARE: HPUnix version 11(64 bit), Oracle version 8.0.5, Oracle Procedure

Builder, Oracle SQLLoader, Platinum ErWin

Walkett Group PJM Interconnection

May 1999 to July 1999Information Systems Consultant

Mr. Pratt worked on the Data Warehouse project. PJM Interconnect controls the

power grid consisting of Pennsylvania, New Jersey, Delaware and Maryland. The

technical objective of this project was to provide telemetry data to the

production analysts. The architecture consisted of an Oracle Parallel instance

running on IBM Netfinity cluster.

Mr. Pratt was involved in the following activities:

Database Administrator for data warehouse project.

Developed partition plan for large tables i.e. 80 GB.

Implemented Analyze plan for data warehouse.

Supported developers and tuned database using Oracle Performance Pack.

HARDWARE: IBM Netfinity cluster, Intel PC

SOFTWARE MS Windows NT cluster, Oracle Parallel Server version 8.0.5, Oracle

Enterprise Manager plus Oracle Performance Pack, PL/SQL package creation,

SQLPlus, Oracle SQLLoader, MS Access.

Walkett Group Dupont Pharmaceuticals

June 1998 to April 1999Information Systems Consultant

Mr. Pratt worked on the Conversion of Clinical Trials Management System

(CTMS). The technical objective of this project was to convert the existing

CTMS from Oracle SQL Forms 3.0 to Developer/2000 version 4.5. This project

also rewrote and redesigned a module from a legacy platform and integrated that

module into the new CTMS.

Mr. Pratt was involved in the following activities:

Lead Developer/Data Modeler for conversion of companys Clinical Trials

Management System (CTMS) from VAX to Alpha VMS platform.

Redesigned legacy portion of system from RDB to Oracle

7.3/Developer/2000.

Employed SQLLab to tune application, which involved redesigning indexes

and reconfiguring SGA.

Created first physical data model for system using ErWin.

Rewrote Pro*C batch routines to database triggers using stored packages.

Responsible for front-end screen development using Developer/2000.

HARDWARE: Compaq/Digital Alpha, Intel PC

SOFTWARE Open VMS 7.0.Oracle 7.3, Oracle Developer/2000 version 4.5, ErWin,

Quest SQLLab

The Boeing Company

Rotorcraft Division

October 1993

to June 1998Database Administrator/Application Developer

Database Administrator for the divisional Software Configuration

Management (S.C.M) system for flight control software, residing on VMS

platform.

Primary data modeler and programmer analyst on upgraded components of

S.C.M system. Implemented a client/server development environment on Windows

NT.

Using Oracles Web Application Server, implemented a client/server

development environment and thin client reporting on Windows NT.

Cost Estimator

Cost Estimator for subcontracting efforts for foreign governments and

commercial businesses. Responsible for development, preparation and

presentation of proposals to management.

Developed a proposal database taking advantage of divisions

distributed data warehouse architecture, reducing process flow and data

redundancy.

Recruited from previous position to train and assist the Philadelphia

Finance Organization in the implementation and utilization of a system I

developed described below.

Defense and Space Group

March 1988 to

October 1993

Business Systems/Data Analyst

Lead Analyst

on an integrated (DB2) government cost system.

Responsible for analyzing end user requirements and writing detail

specification for programming.

Verify application system quality, accuracy, integrity, and

functionality by conducting operational, functional and system test.

Established and reviewed resource estimates and personnel assignments

of six Programmer Analysts by coordinating needs and department requirements

with customers and management.

Primary data modeler/analyst working with database administrator to

define and tune application database.

Use available analysis tools to provide ad-hoc reporting and reduce

response time in support of program management.

Designed and implemented integrated cost system for a national user

base across multiple financial organizations.

Recognized as primary corporate trainer.

Cost Accounting Price Estimator

Cost Estimator for subcontracting effort for government business.

Responsible for development, preparation and presentation of proposals

to management.

Developed spreadsheet application that converted manual process of

proposal generation.

Responsible for developing trade studies on support of cost reduction

initiatives for program.

Awarded for outstanding performance.

Education

Bachelor of Arts

from Graceland University, Lamoni, IA

Major: Business Administration

Graduation Date: May 1987

Additional Training/Certification

Certified Oracle PL/SQL

Extensive course work in Systems Analysis and Logical Data Modeling

Oracle Designer MS Certified training: Mastering MS Visual Basic 5.0

Fundamentals, Mastering MS Visual Basic 5.0 Advanced, VB certification training.

Contact this candidate