Analyst Oracle

HA

Douglas

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

Objective:

OBJECTIVE

Challenging professional assignments in a progressive Information Systems

department

Continuing my specialization with PeopleSoft, primarily in technical areas but

also functionally.

Desired Occupation(s):

COMPUTER SYSTEMS ANALYSTS

Employment History:

Employer: **

Location: MD

Title: Systems Analyst

Duration: 10/1997

- 12/1999

Job Duties:

Oct. 1997

- presentSystems Analyst using PeopleSoft HR and Payroll

Provided primary support to HR department for the PeopleSoft application.

Created various reports, panel changes, and ad-hoc queries upon demand.

Created an SQR interface with Website, to load/create website data (benefit

elections/terminations), via an ASCII file, into the PeopleSoft database.

Calculate general deductions to force a one-month employee prepayment of

benefits.

Designed and implemented a customized version of the leave accrual process.

Aided in the design and implementation of Cobra Administration.

Responsible for setting up and maintaining benefit programs in PeopleSoft.

Developed an SQR interface ("Enumeration Verification System") to verify

employee SSNs with the Social Security Administration.

Worked on the conversion of the benefits panels/menus/peoplecode/reports to

PeopleSoft version 7.

Customized the PeopleSoft Employees table and data-population SQR. Created a

similar table and SQR for tracking contractor (i.e. non-employee) data.

Assisted in migration of PeopleSoft from Informix to Oracle.

Employer: **

Location: MD

Title: Systems Analyst

Duration: 12

/0196 - 10/1997

Job Duties:

Dec 1996

- Oct 1997Systems Analyst using PeopleSoft HR and Payroll

Responsible for modifying/creating reports using SQR for their PeopleSoft (HR

and payroll) application (Oracle database). Learned the PeopleSoft toolset

through various projects involving screen and table design.

Developed the IS department's coding standards for SQR and scripts (database

modification files written in SQL); creation of SQR and script templates for use

by developers.

Created a set of tables, panels, PeopleCode, and reports for tracking employment

applications. Data is moved to the "standard" PeopleSoft tables when applicant

is hired.

Developed Payroll Positive Pay Interface - SQR program to extract check data to

an ASCII file for transmittal to banks, for verification of check

numbers/amounts

Designed a series of database triggers for auditing specific tables (bypassing

PeopleSoft's auditing function).

Performance-tuned custom and PeopleSoft-delivered SQRs.

Created a set of SQR and SQL*Loader programs to validate and load ASCII data

(for data migration from an acquired company) to the PeopleSoft database.

Employer: **

Location: **,

MD

Title: Systems Analyst

Duration: 11/1996

- 01/1998

Job Duties:

1988

- 1996Systems Analyst, Environmental Information Management Systems

(EIMS

)

division

Worked exclusively with the Environmental Compliance Management System (ECMS), a

large Oracle database application (approximately 400 to 500 tables). Involved

in all phases of the development life cycle, including analysis, design, coding,

and testing. Manage client projects and provide customer support. Responsible

for the conversion of our application to Oracle*Forms 4.5.

Duties included:

Supporting all clients still using the character-based (Oracle RDBMS v6,

SQL*Forms v3.0) version of our application

Creating and modifying screens and reports using Oracle*Forms and SQR

Implementing all database changes to our application

Testing coding changes made by others

Establishing database change procedures, database object standards, screen and

report standards, and coding standards

Reviewing on-line documentation

Managing client projects

Training new clients on our application

Mentoring of new employees

Supervising application releases

Serving as module manager for various subject-area modules within the application

Skills and Abilities:

Software:

PeopleSoft HR/Payroll (versions 5 & 7); SQL; SQR; Oracle; Informix; Oracle

tools: SQL*Forms v2.3 and 3.0, Developer 2000 (Forms v4.5), SQL*Plus, PL*Sql,

SQL*Report (RPT), SQL*Loader, Import/Export

Operating Systems:

Windows (NT & 95), VMS, Unix, MSDOS

PeopleSoft

Experienced in HR and Payroll with emphasis on benefits - Base Benefits, Cobra

Administration, Benefits Administration

Desired Location:

Within the state of Marylan

Contact this candidate