SUMMARY:

• Programmer/Analyst with over 12 years of progressive experience seeking Oracle developer position
• Key strength in analysis, coding and testing of Oracle Forms, Reports and PL/SQL to deliver efficient customized applications
• Sharp skills in unit and system testing to ensure seamless conversion
• Strong technical writing skills, co-developing requirements documentation and generating program specifications
• Detail-oriented, highly productive and results-driven in team and individual projects
• Driven to maintain cutting-edge technology knowledge and technical skills through sponsored and independent training

TECHNICAL SKILLS:

Language Oracle Designer 10g/6i (Forms 10g/6i, Compiler 6i, Reports 10g/6i, Graphics 6i, SQL*Plus 10.1.0.5.0, PL/SQL 10.1.0.5.0), Procedure Builder (PL/SQL stored Procedure, Function and Package, Trigger), PHP, HTML 5, Javascript 1.7, AJAX, Crystal Report V4.0
Operating System Windows XP, Red Hat Linux 6.0/Shell Scripting, Internet Explorer 8.0, Novell Netware 4.01, Citrix
Database Oracle 7.3, 8i, 9i, 10g
Tools/Utilities SQL*Loader, T.O.A.D, Export/Import, PLSQL Developer v7.1, Explain Plan, Ultra Edit v14.00b, Dreamweaver 8

PROFESSIONAL EXPERIENCE:

Confidential
Edison, NJ
Application Programmer/Analyst
August 2004 - Present

Description: MOL is a publicly held global shipping company with corporate office in Japan. The Intermodal Group, based in USA, is responsible in maintaining, enhancing and automating Truck and Rail Legs, Routes, Contracts, Transport PO’s and Invoices. Applications developed by the group are deployed in North America for use by its domestic and international branches. Coordinates requirements with the Global Support Group and projects with Functional Group.

Responsibilities:

• Designed and developed Invoice maintenance screens with imbedded validations and common functions using Oracle Forms 10g
• Developed stored procedures, functions and complex packages extensively using PL/SQL and fine-tuned SQL to optimize performance
• Involved in the analysis, design, and implementation of Oracle Forms/Reports applications complying with development standards
• Involved in the conversion of various modules from Oracle Forms 6i/Reports 6i to Oracle Forms 10g/Reports 10g following the Migration 10g Checklist
• Reviewed coding completed by peers and highlight codes needing improvements
• Analyzed, troubleshoot and resolved SATS tickets opened by business users
• Prepared a QA Test Plan after performing unit testing of functional and technical requirements

Environment: Oracle Developer 10g (Forms 10g, Reports 10g, SQL*Plus 10.1.0.5.0, PL/SQL 10.1.0.5.0, PL/SQL Developer 7.1, TOAD) and Oracle DB Server 10.1.0.5.0, Windows XP, Internet Explorer 7.0

Confidential
Lawrenceville, NJ
Senior Oracle Developer/DBA
July 2001 - November 2002

Description: Peterson Asbestos is a subsidiary of Navigant Consulting, Inc., a world renowned consulting firm specializing in integrated solutions assisting companies and their legal counsels. Peterson is the central asbestos claims processing unit. Processing claims for defendants includes new filings, settlements and integration to the in-house accounting system. The application is capable of multi-client sharing of information up to the subsidiary level. It also has web based remote access facility to update and browse claims information.

Responsibilities:

• Gathered and documented user requirements to developed scalable technical solutions
• Coded, tested, debugged and enhanced existing Asbestos System Oracle Forms and Reports to ensure data integrity
• Conducted and participated in requirement/analysis sessions
• Implemented changes after user conformed and signified acceptance
• Uploaded new Claims in text file format by creating back-end PL/SQL stored procedures, functions and packages
• Created database triggers to audit and track all record modifications made by internal and external users
• Created complex Unix Shell Scripts and deployed in Unix Server machine
• Performed other duties that align with the position as delegated

Environment: Oracle Developer 6i (Forms 6i, Reports 6i, SQL*Plus 8.0, PL/SQL 8.0, SQL Loader), SQL Navigator, Oracle DBA Studio and Oracle DB Server 8.1.7.0.1, Novell Netware, Red Hat Linux 6.0 and Windows 2000

Confidential
South Plainfield, NJ
Oracle Developer/Consultant
July 1997 - June 2001

Description: Sequel is consulting company that has placed talented contract and permanent IT professionals at top-notch organizations throughout the USA, ranging from Fortune 50 to small IT shops.

Assigned to various clients and delivered high-quality solutions across multiple industries ranging from finance, chemical manufacturing and public health safety. Worked and completed by target deadlines on a variety of projects ranging in both size and scope.

Responsibilities:

• Involved in the Y2K project renovating and testing programs to expand the year into four-digit format on the screens and procedures
• Converted character based oracle into oracle developer 2000 forms and reports
• Converted reports SQR and pro-fortran to oracle developer 2000 reports
• Converted and uploaded data using SQL Loader into Oracle staging tables
• Developed LIMS reports based on Production specifications which are sent to clients including test results
• Wrote database PL/SQL stored procedures, functions, packages and triggers
• Planned and developed test cases performed in parallel testing subject for approval
• Debugged and troubleshoot system problems to resolve issue

Environment: Developer 2000 (Forms 5.0, Forms Compiler 5.0, Report 3.0, SQL*Plus 3.3, PL/SQL 2.33, SQL Loader), Visual Interdev 6.0, HTML, ASP, Javascript, DHTML, VB Script and Oracle Server 8.0, 8i, Novell Netware and Windows 98

Confidential
Makati City, Philippines
Systems Analyst/Programmer
April 1993 - January 1997

Description: NESIC provides full turnkey engineering services for both public and private business networks, covering telecommunications infrastructure and information management network systems. Employed and assigned in Information Technology that developed applications for engineering, accounting and marketing departments. Applications developed were Payroll, General Ledger, Asset Management, Project Tracking, Project Costing and Invoicing.

Responsibilities:

• Participated in all phases of full life-cycle development working independently or with other team members to analyze, design, develop, test, implement, and document system requirements based on business objectives
• Involved in the conversion of screens and reports from Clipper programs to Oracle Forms 4.5 and Reports 2.5
• Performed parallel testing of develop applications between Clipper and Oracle
• Debugged Oracle Forms and Reports to resolve break/fix issues and to close complaint tickets
• Created database triggers to monitor and track all record modifications made by users
• Contributed in creating Information Technology policies and procedures for ISO 2000 compliance

Environment: SQL*Plus 3.1, PL/SQL, Forms 4.5, Reports 2.5, Oracle Designer 2000, Procedure Builder, SQL Loader and Oracle Server 7.3, Windows 95 and Novell Netware 4.01

Confidential
Makati City, Philippines
Senior Analyst/Programmer
August 1991- April 1993

Responsibilities:

• Directly interacted with clients to customize and complete requirements
• Planned and analyzed project, established schedules and project parameters
• Developed programs to accomplish system implementations within planned budgets, resources, and timeframes
• Wrote detailed technical design documents of custom screens, functions and operations
• Performed unit testing of screen maintenance, data process and reports generation
• Wrote detailed user’s manual of system developed.

Environment: Clipper 87, Novell 3.11.

Confidential
Manila, Philippines
Programmer
January 1991 - August 1991

Responsibilities:

• Analyzed, designed, developed and maintained Loan and Savings System that monitors loan and contribution balances of about 200 members
• Responsible for installing the application on the network and daily backup
• Performed parallel testing of the automated system and manual records
• Guided and trained system users in order to improve productivity and efficiencies
• Developed system summary reports used to match against manual collections and disbursement records

Environment: Clipper 87, DOS 3.0

Education:

• BS Commerce – Accounting