Oracle Sql

Tom Foster

661-***-**** / *********.**@*****.***

Skills Profile

Operating Systems: UNIX, Windows NT, Windows server 2003/2007,

Windows, MAC

Database: Oracle, DB2, Access

Languages: Oracle PL/SQL, SQL, C, Pro*C, PowerShell, VB, UNIX Korn Shell Scripts, HTML

Tools: PL/SQL Developer, SQL Navigator, Toad, Cognos PowerPlay, BrioQuery, SQL*Forms 3.0/4.5, Oracle Reports 6i, SQL*Plus, SQL*Loader, GMC Inspire, SQR 3.0/4.0, Maximo 4.0, Oracle Discoverer Administration, Oracle Discoverer, PVCS Version Manager, Appworx Batch Scheduling System, MS Word, MS Excel, MS Power Point, Exchange, Siebel Analytics, Lotus Notes, Informatica, FileZilla, WinSCP, AxCrypt, PGP, TrueCrypt

Work Experience

Arvato Digital Services LLC, Valencia, CA

Programmer

Feb. 2012 - Mar. 2017

Build Oracle package for a Print On Demand mailing system

Use GMC Inspire to build custom Print On Demand mailings

Collect business requirements and build Oracle processes to support them

Automate data loading and build mailing orders using VB, PowerShell and DOS

Install and train users on custom built programs

Princess Cruises, Valencia, CA

Programmer Analyst

Feb. 2006 - Feb. 2012

Automated DVD Online ordering process

Created and automated the processing of invalid and unsubscribed emails

Built and modified Oracle packages, procedures and functions for business needs

Developed functions in DB2

Evaluated software for department implementation

Coordinated with outside vendors for file transfer and encryption strategies

Loaded and extracted data from the Oracle and DB2 using various tools

Produced mail and email list for Marketing

Generated and modified Informatica workflows

Created direct mail and email mailing list in Oracle, DB2, and Alterian Marketing Suite

Generated email and direct mail campaigns using Siebel Analytics

Gathered, compiled, organized, and analyzed data to create reports for senior management

Produced weekly, monthly and yearly reports for all direct mail and email marketing campaigns

Provided support to internal customer as needed

Robbins Brothers, Glendale, CA

Independent Consultant

July 2002 - Feb. 2003

Installed and administered Oracle Discoverer

Gathered requirements and developed custom Oracle 6i reports

Built Oracle Discoverer reports

Customized Oracle Financial Form

OSI Consulting, Woodland Hills, CA

Senior Programmer

Mar. 1999 - June 2002

Gathered requirements and produced custom Oracle 6i and BrioQuery Reports

Developed Oracle packages, procedures, and function for new business requirements

Built and modified UNIX Korn shell scripts for new business needs

Migrated data from a J. D. Edwards database into an Oracle database using SQL*Loader

Automated the creation of tables and SQL*Loader control files using UNIX Korn shell scripts

Helped implement and maintain a new Cognos web based system for Amgen’s entire sales force team

Gathered requirements, created and modified SQR reports for Maximo Computerized Maintenance Management System

Installed and administered BrioQuery

Generated documentation in order to comply with FDA requirements

The Zenith, Woodland Hills, CA.

Programmer/Analyst

Nov. 1996 - Mar. 1999

Developed Oracle procedures and functions to increase timeliness

Converted programs from Pro*C to SQR

Built and modified Korn shell scripts for new business requirements

Created and revise SQL and SQR reports for new business requirements

Developed and modified Oracle Forms 3.0/4.5 and Reports 6i

Education

Bachelor of Arts in Psychology

California State University Northridge, Northridge, CA

Contact this candidate