Resume of ORACLE PL/SQL APPLICATIONS DEVELOPER/PROGRAMMER

Title
ORACLE PL/SQL APPLICATIONS DEVELOPER/PROGRAMMER

Primary Skills
Oracle Forms 9i & 10g, Oracle Reports 10g , PLSQL,Oracle 8I, 9i & 10g

Location
US-NJ-Springfield

Posted
May-18-08

EDUCATION

ITHACA COLLEGE, Bachelor of Science

CHUBB COMPUTER SERVICES, Course of study included Structured Programming, and Relational Database Design

TECHNICAL EXPERIENCE

Databases: Oracle 8i, 9i & 10g, DB2
Tools: Oracle Forms 9i & 10g, Oracle Reports 10g , PLSQL Developer, Oracle Developer Suite, TOAD, Oracle SQL Developer, SQL, SQL*Loader SQL*Plus, Visual Source Safe, File-aid, TKPROF, Xpediter, Change man, KEA, PowerTerm
Languages: PL/SQL, IBM COBOL, VAX COBOL, UNIX Shell Scripting, DCL, JCL, CICS, VSAM
Operating Systems: Windows NT, Windows server 2003, UNIX, Linux, OpenVMS, MVS/ESA, OS390
Superior PC skills, Proficiency with Microsoft Office suite and other commonly used PC software.

WORK EXPERIENCE

Maher Terminals, LLC., Berkeley Heights, N.J (Operators of facilities where cargo ships load and unload)
12/99 to present
ORACLE PL/SQL APPLICATIONS DEVELOPER/ANALYST (10/2002 - present)
* Design, develop, test, deploy and support OLTP applications used to track containers moving in or out of our terminal.
* Create/maintain database stored procedures, functions, packages, views, materialized views, types, tables, and triggers that efficiently implement business functions.
* Fine Tune SQL statements for maximum efficiency using Oracle Explain Plan, SQL trace and TKPROF.
* Design, Create and maintain front end data entry applications and reports, using Oracle Forms and Oracle Reports.
* Communicate with end users to provide technical guidance, discuss new development and support User Acceptance Testing.
* Mentor colleagues in best practices for architecture design in implementing business solutions.
COBOL APPLICATIONS DEVELOPER/ ANALYST (12/99 - 10/2002)
* Maintained existing programs and produced new development on our previous Vax COBOL system.

Chubb Computer Services, Parsippany, N.J. (Consultant assigned to United Parcel Services)
COBOL APPLICATIONS DEVELOPER/PROGRAMMER
4/99 to 12/99

* Modified billing programs (COBOL/CICS/DB2) in order to incorporate new pricing requirements.
* Used File-aid to produce input data for use in testing coding changes.
* Created and Modified JCL/Procs that were used for testing and production.
* Performed Unit/System testing on modified programs, and evaluated test results.
* Used Xpediter to locate and correct abends and incorrect logic.
* Controlled the installation of new programs, and new versions of existing programs using Change man.
* Created system flow charts using Visio.

C.M.A. - C.G.M. (America) Inc., Secaucus, N.J. (Owners and operators of cargo ships)
CUSTOMER SERVICE SUPERVISOR
12/97 to 1/99

Supervised personnel who booked cargo, negotiated ocean freight rates, and handled questions and problems related to import and export shipments between the U.S.A., and South America, Europe, Australia, Africa.

Norton Lilly International Inc., Secaucus, N.J (Operators of cargo ships on behalf of their owners)
BUSINESS ANALYST & LOGISTICS MANAGER
9/88 to 12/97 & 2/82 to 2/85

* Analyzed the systems and procedures used by our Logistics personnel, and implemented improved methods.
* Worked with our I.T. department to create new programs for our IBM AS/400, which unified our different departments.
* Spent nine months in Norfolk and Miami training employees to use PCs and our AS/400 to develop more efficient methods of servicing customers.
* Supervised personnel who used our IBM AS400 to track over 13000 containers and chassis, which were continuously moving by truck and railroad throughout the U.S.A. and Canada.
* Negotiated volume rates with trucking companies and railroads, and arranged for the movement of cargo
* Performed customer service functions and coordinating between truckers and our piers employees.
* Created marketing reports from U.S. Custom's database that identified companies that imported or exported.
* Created a wide variety of reports from our IBM AS/400 using Query.

Interpool Ltd., New York, N.Y. (Leased equipment used by operators of cargo ships )
CUSTOMER SERVICE MANAGER
11/86 to 9/88

* Coordinated between our customers and our equipment storage depots in order to lease containers and chassis.
* Enforced M. & R. procedures, directed surveyors, and authorized container and chassis repairs.
* Regulated equipment inventory levels by repositioning equipment in and out based upon marketing needs.
* Identified companies that were in possession of equipment owned by my present employer and leased to my former employer U.S. lines, which had filed for bankruptcy. I then negotiated with them for the release of the equipment.

United States Lines Inc., Cranford, N.J. (Owners and operators of cargo ships)
EQUIPMENT UTILIZATION ANALYST
2/85 to 11/86

* Developed worldwide equipment budgets based on projected import/export activity at each port and container pool.
* Analyzed worldwide container inventories, and designed strategies to bring pool levels in line with marketing needs.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NJ-Springfield »
View all resumes in US-NJ »

View other ORACLE PL/SQL APPLICATIONS DEVELOPER/PROGRAMMER resumes