US-FL-SFL Sr. P/A Oracle 7/8, PL/SQL, Crystal Reports

[RC1560]

I am interested in this job. Please see attached resume below for my
experience and see how well it matches

Thanks
Rich Carter

Richard K. Carter
34233 36th PL. S.W.
Federal Way, WA. 98023
(253) 874-0857 Hm
rc1...@aol.com EMail

Experience

7/98 - Present Consultant, NextLink, Bellevue, WA.
Work as a Oracle Conversion Analyst in the Account Billing Group to convert an
old Sybase AS400 Billing system to the new Sun Oracle System using Oracle 7.3,
AS400, SQL*Loader, PL*SQL, Unix, Sybase and Windows NT 4.0.

4/98 - 7/98 Consultant, Weyerhaeuser, Tacoma, WA.
Work as a Data Analyst in the Container Board Packaging Group to Analyze user
requests and data structures to create business and standard reports for new
customer system (Witron) using Visual InterDev, MS SQL Server(SQL scripts) and
Crystal Reports using MS Visual Studio 97, MS Visual InterDev 1.0, SQL Server
6.5, Visual Source Save 5.0, Crystal Reports 6.0 and Windows NT 4.0.

3/98 - 7/98 Consultant, PC&S, Tukwila, WA.
Work as a Oracle DBA to install and implement Oracle Enterprise Manager 7.3,
create Oracle instances, tables, database tuning, backup and recovery and data
loader scripts for a client server based resume tracking system. Load data
from old Wang system into new Oracle system and write some SQL Reports. Using
Oracle Enterprise Manager 7.3, SQL*LOADER, PL/SQL and Windows NT 4.0.

10/96 - 4/98 Consultant, Boeing, Renton, WA.
Create custom Web Sites and Web Pages with database backends, for various Upper
Management customers using Front Page 97, Visual InterDev, Cold Fusion 2.0,
HTML 3.2 & 4.0, JAVA 1.1, JavaScript, VBscript, Netscape 4.0, Internet Explorer
4.0, Visual Cafe and VC++.
Support, Design, Implementation and Maintenance of Computer Systems for
Commercial Airplane Division. Convert Oracle 6 applications (FIR, FOS) to
Oracle 7, create stored procedures and database triggers to enhance
performance, perform DBA duties (optimize data and re-design tables and
indexes). Create and load new custom Oracle system (Rejection Tag) using
SQL*LOADER, Enterprise Manager, PL/SQL and Reports 2.5 from various multiple
data sources. Convert old Paradox 3.0 applications to new Oracle 7.3
applications. Convert Access 2.0 systems to Access 7.0 and build input screens
and custom reports. using Oracle 7.3, Oracle Webserver 2.0, Access 2.0, 5.0 &
7.0, Visual Basic 3.0, 4.0 & 5.0, Visual FoxPro, Windows 95, Windows NT 4.0 on
an IBM 3090 and Sun 1000.

09/95 - 10/96 Systems Analyst III, MIDCOM Comm., Seattle, WA.
Support Design and Maintenance of Oracle Financials including AR, AP and GL.
Create and implement custom forms and reports. Perform DBA duties. Monitor and
update rollback segments, tablespace, indexes and tables. Design, create,
expand and update tables, database triggers, PL/SQL scripts, stored procedures
and SQL*LOADER data scripts. Run explain plans to optimize SQL queries and
views. Update and create UNIX scripts and libraries. Created and maintained
System Documentation. System based in Oracle 7.1, Financials 9.4 and Forms
3.0, C++, Visual Basic 3.0, Access 2.0 using Windows NT 3.0 on an Sun 2000.

Experience cont.

06/95 - 09/95 Oracle Consultant, Digital Systems International, Redmond, WA.
Design and implementation of custom system that interfaced with Host Database
and DSI telemarketing product. This product provided batch processing from
workstations, performed terminal emulation and screen navigator processing to
read and write data to Host Mainframes. Perform DBA duties, data modeling,
table design and process flows. Perform detail design, coding and
implementation. Create tables, tablespace, rollback segments, indexes and
views. Create and update database triggers, PL/SQL scripts and stored
procedures. System based in Oracle Designer 2000, Visual Basic 4.0, Visual
C++, Access 2.0, FoxPro, MFC, ODBC, PRO*C, Windows NT, and Extra on an HP 5/66.

04/95 - 06/95 Oracle Consultant, Metro (King County), Seattle, WA.
Design and implementation of custom project application that emulates the
functionality of Oracle Financials but will fit and operate on a radio
frequency hand held LRT device. This menu driven system used the Miscellaneous
Transfer, Cycle Count and Sub Inventory Transfer modules in Oracle Financials
using Oracle Forms and supporting tools. Perform Data Modeling, Table Design,
Process Flows and Detail Design. Design, create and implement SQL*LOADER
scripts. Create tables, database triggers, PL/SQL scripts and stored
procedures. Perform extensive user support and testing, including training.
System based in Oracle 7.1, Forms 2.3 and Financials 10.4 on an VAX Alpha and
UNIX.

10/94 - 03/95 Oracle Consultant, Weyerhaeuser Inc., Federal Way, WA.
Updating and implementation of Corporate Marketing and Financial systems, using
Oracle and supporting tools. Conversion of Systems from Oracle 6.0 to Oracle
7.0. Perform Detail Design, Coding, Documentation and Implementation. Advise
management on length and complexity of tasks. Schedule tasks to achieve goals.
Perform extensive user support, including training and telephone support.
System based in Oracle 6.0, 7.0 and Forms 3.0, Access 2.0 and UNIX on an HP
6000.

04/94 - 10/94 Systems Analyst III, SpaceLabs Medical, Redmond, WA.
Design and implementation of 2 corporate Marketing systems using Oracle and
supporting tools. Perform data modeling, table design process flows and detail
design. Create tables, database triggers, PL/SQL scripts and stored procedures.
Design, create and implement SQL*LOADER scripts. Perform coding,
documentation and implementation. Advise Management on length and complexity
of tasks. Schedule tasks to achieve goals. Perform user support including
training. Perform DBA duties. System based in Oracle 7.0 and Forms 3.0, Visual
Basic 2.0, Access 2.0 on an VAX 6340 (VMS)

01/94 - 04/94 Oracle Consultant, Lease Insurance Inc., Bellevue, WA.
Design of complex corporate marketing and lease tracking system using Oracle 7
and supporting tools. Perform DBA duties, data modeling, table design and
process flows. Perform detail design, coding and implementation. Create
tables, tablespace, rollback segments, indexes and views. Create and update
database triggers, PL/SQL scripts and stored procedures. Design, create and
implement SQL*LOADER scripts. Perform coding, documentation and
implementation. System based in Oracle 7.0 and Forms 4.0, Visual Basic 2.0 and
Access 2.0 on an VAX 6340 (VMS).

Experience cont.

08/93 - 12/93 Oracle Consultant, Portland Power and Light, Portland, OR.
Design and testing of Corporate reporting system. Perform detail design,
coding, documentation and implementation. Perform DBA duties, data modeling,
table design and process flows. Create tables, tablespace, rollback segments,
indexes and views. Design, create and implement SQL*LOADER scripts. Perform
duties in transfer of data from DB2 database to VAX Oracle database. Advise
Management on length and complexity of tasks. Schedule tasks to achieve goals.
System based in Oracle 7 and ReportWriter 2.0, on an VAX 6860 (VMS) using OS/2
as client server network and UNIX.

06/93 - 08/93 Consultant, Lamonts, Bellevue, WA.
Design, Code, Test and implementation of POS (Point of Sale) corporate pricing
and reporting system. Perform detail design, documentation, coding and
implementation. Create detail reports for Management Tracking and Information.
Advise Management on length and complexity of tasks. Schedule tasks to
achieve goals. System based in COBOL and IMS on an IBM 3090.

06/92 - 06/93 Systems Analyst/Computing, Boeing (BCS), Seattle, WA.
Design and implementation of complex Corporate Production Order and Material
Reporting System. Perform detail design, table design, coding, documentation
and implementation. Design, create and implement SQL*LOADER data scripts.
Advise Management on length and complexity of tasks. Schedule tasks to achieve
goals. Perform user support including training and telephone support. Support
members of the technical staff as both a troubleshooter and a Tutor. System
based in Oracle 6, Forms 3.0 and PRO*C on an VAX 6840 (VMS)

09/89 - 06/92 Systems Analyst II, Boeing (BCS), Seattle, WA.
Design and implementation of Factory Inventory and Material Handling system.
Perform detail design, data modeling, database design, coding, documentation
and implementation. Design, create and implement SQL*LOADER data scripts.
Perform DBA duties, create tables, tablespace, rollback segments, indexes and
views. Monitor system and performance to optimize SQL queries and views.
Perform system manager duties including memory upgrade and system upgrades.
Advise Management on length and complexity of tasks. Schedule tasks to achieve
goals. Perform user support including training and telephone support. System
based in Oracle 5, Forms 2.3 and user exits in 'C' on a, VAX 3400 (VMS)

07/87 - 09/89 Systems Analyst I, Boeing (BCS), Seattle, WA.
Design, Code, implementation and maintenance of Composite Inventory and
Management System. Perform detail design, table design, coding, documentation
and implementation. Advise Management on length and complexity of tasks.
Schedule tasks to achieve goals. Perform user support including training and
telephone support. Perform DBA duties as backup. System based in COBOL and
DB2 on an IBM 3090 (MVS).

Experience cont.

11/86 - 07/87 Systems Analyst I, Boeing (BCS), Seattle, WA.
Design, Code, implementation and maintenance of Maintenance Manual Management
System. Design a Mainframe to PC data download interface for Manuals. Advise
Management on length and complexity of tasks. Schedule tasks to achieve goals.
Perform user support including training and telephone support. Perform DBA
duties as backup. System based in COBOL and IDMS on an IBM 3090 (MVS).

08/85 - 11/86 Sr. Programmer Analyst, Rainier National Bank, Tukwila, WA.
Design, Code, implementation and maintenance of Checking and Savings Deposit
systems. Perform detail design, table design, coding, documentation and
implementation. Created a Functional Test system. Create reports. Advise
Management on length and complexity of tasks. Schedule tasks to achieve goals.
System based in COBOL, Panvalet Dyl280 and IMS on an IBM 3090 (MVS) with
reports generated in MARK IV.

04/80 - 08/85 Programmer Analyst, Pacific Northwest Bell, Seattle, WA.
Design, Code, implementation and maintenance of Company Payroll System.
Perform detail design, table design, coding, documentation and implementation.
Advise Management on length and complexity of tasks. Schedule tasks to achieve
goals. Create reports with Mark IV. System based in COBOL, MARK IV and IMS on
an IBM 3090 (MVS).

Technical Areas

Systems: Inventory Management, Process control Real Time Data
Acquisition, Oracle Financials, System Administration, Database Administration,
System Management, Radio control LRT

Hardware: VAX 11/785, 3100, 3400, 6350, VAX 3100 Workstation, IBM 286 –
586 PC's, IBM 360, 370, 3080, 3090 Mainframes, 3031, 3033 DASD.

Software: ORACLE RDBMS 5, 6 & 7, SQL*FORMS 2.3, 3.0, 4.0, 4.5, SQL*PLUS,
SQL*REPORTWRITER 1.0 & 2.0, SQL*LOADER, PRO*C, SQL*NET, ORACLE FINANCIALS 9.4 &
10.4, ORACLE DESIGNER 2000, Paradox, Windows 3.0, Access 2.0, 3.0, 5.0 and 7.0,
Excel 2.0 & 5.0, TCP/IP, NetWare, MS InterDev.

Languages: 'C', PRO*C, SQL, PL/SQL, DCL, COBOL, JCL, VSAM, PL/1, MARK IV,
ASSEMBLER, VISUAL BASIC, VISUAL C ++, HTML, JavaScript, JAVA, BASIC, FoxPro

O/S: VAX/VMS, UNIX, PC DOS, MVS, VM/SP, OS/VS1, WINDOWS 3.0 & 95,
Windows NT 3.51 & 4.0, OS/2.

Education

1972-1976 California State University at Northridge, BS
Engineering/Computer Science
Technical Training: FROM ORACLE: SQL*FORMS, SQL*PLUS, ADVANCED ORACLE FOR
DEVELOPERS/FORMS, ADVANCED ORACLE FOR DEVELOPERS/RDBMS, ORACLE
ARCHITECTURE/APPLICATION TUNING, PL/SQL, DBA ARCHITECTURE VERSION 5 & 6, FORMS
2.3, 3.0, 4.0, 4.5, FORMS2.3 TO 3.0 CONVERSION, EXTENDED RELATIONAL ANALYSIS,
ORACLE CASE TOOLS, SQL*REPORTWRITER 1.2, 2.0 , Microsoft Visual Studio 97,
Netscapes Dev Com Conference 97.

Membership PSOUG – Puget Sound Oracle Users Group.
NWOUG – Northwest Oracle Users Group.