Owner Resume Encinitas, CA - Hire IT People

TECHNICAL SKILLS

RDBMS: Oracle 11g - 10g-9i-8i-7.x, 6.x

Operating Systems: UNIX (Sun Solaris), MS Windows (all versions), MS DOS

Languages: SQL (Ad Hoc Queries), PL/SQL, SQR, Clipper, COBOL

Version Control: Visual Source Safe, Serena Changeman.

Scripting: PL/SQL Scripts

Other Tools: MS-Office, PL/SQL SQL Developer, TOAD, SQL*Loader, ImportAtomic Applications Manager (v8), WinSCP, Hybris

PROFESSIONAL EXPERIENCE

Confidential, Encinitas, CA

Owner

Responsibilities:

Confidential, Charlotte, NC

Sr. Developer

Responsibilities:

Supported custom application for a retail company.
The Main Entry System is constructed and maintained using Oracle Developer 10g (Forms and Reports, and PL/SQL Constructs such as scripts, packages, procedures and functions).
Focused on Price Changes, Promotions, Inventory Transfers. Identified, analyzed, designed, coded, tested and implemented modules that required hard coded s to department numbers replaced with dynamic department number selection.
Performed maintenance on 60 Oracle Forms, 30 Oracle Reports, 32 Scripts and Packages.

Confidential, Encinitas, CA

Sr. Developer

Responsibilities:

Created an application for the transportation industry.
The Dump Truck System (DTS) was constructed and maintained using Oracle Developer 6i (Forms and Reports, and PL/SQL Constructs such as packages, procedures and functions).
Identified, analyzed, designed, coded, tested and implemented modules that required hard coded s to department numbers replaced with dynamic department number selection.
Installs are performed on stand-alone systems or in a networked environment (client/server).
Capabilities include: Equipment Maintenance Tracking, Human Resources, Safety and Compliance, Accounts Receivables, Accounts Payables, Payroll for three states and integrated accounting that is GAAP compliant.
The current system consists of over 1,000 Oracle Forms and 1,200 Oracle Reports.
These modules consisted of Oracle Forms and Reports 6I, SQR 4.3.2.1, Packages, SQL Scripts and Korn Shell Scripts. Prepared test scripts.
Migrated information from other databases, spreadsheets & flat files using UTL FILE and SQL*Loader.
In addition, debugged and modified SQR reports and developed cronjobs.
Prepared documentation for and presented changed modules at Change Advisory Board meetings. Implemented changes to production systems.

Confidential

Oracle Developer

Responsibilities:

Filled in for vacationing Production Support Technicians.
Monitored the system; checked work scripts, modified production data as required, debugged the Oracle Developer 6i application, prepared requests for changes, coded & tested changes and implemented into production.
Loaded Postal Soft updates.
Loaded data from user’s spreadsheets.

Confidential

Oracle Developer

Responsibilities:

Analyzed MicroFocus Cobol programs with embedded Oracle calls.
Developed PL/SQL procedures to populate tables from different schema so COBOL programs could execute.

Confidential

Oracle Developer

Responsibilities:

Confidential

Oracle Energy Project

Responsibilities: