Developer Oracle
Resume:
JED BACAY
*** ****** ***. ****** ****, New Jersey
*******@*****.***
SUMMARY OF QUALIFICATIONS:
●16 years’ experience in Information Technology as an Oracle Technical Developer. 14 years have been dedicated working as an Oracle E-Business Suite developer dealing mainly with Oracle financial modules (AP Accounts Payable, AR Accounts Receivables, GL General Ledger). I also had the chance to work on other modules with some of my clients like FA Fixed Assets, CM Cash Management, HR Human Resources, PA Projects & PO Purchase Order
●Expertise in database objects, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & full suite of Oracle Tools including development and customization of Oracle Developer (Reports & Forms) and Oracle discoverer, open interfaces, and APIs.
●Focused on performance tuning, testing, and quality assurance.
●Adept at all stages of project lifecycle, from business requirement, design development, technical documentation, functional documentation, unit testing, object development, user acceptance testing (UAT), production support, and implementation.
●Involved in large customization and upgrade projects for various establishments and financial institutions.
●Works well with end user, functional analysts, business analysts, project managers and directors.
●Superior communication skills, highly determined and technically sound professional.
●Detail oriented and self-starter individual
Technical Qualifications:
●Experience in in developing applications using SQL, PL/SQL, Database Triggers, Functions, Stored Procedures, Oracle Forms, Oracle Reports & Oracle Discover
●Experience UNIX Shell scripting and worked extensively on Unix/Solaris/Linux platforms.
●Experience in conversion of legacy data into Oracle Applications using SQL Loader, PL/SQL and other loading methods.
●Experience on Workflow customizations & Form personalization to meet functional/business requirements.
●Great exposure on Software Development Life Cycle (SDLC).
●Worked Extensively in Conversions and Interfaces in most of the Financial Modules. Extensive hands on experience using most of the API’s.
●Experience in XML Reports using XML Publisher and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
●Experience in development and support for Oracle General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Purchasing (PO), Fixed Assets (FA), Cash Management (CM), HRMS
●Experience in creating and integrating custom built Forms with Oracle Applications and in using Custom.pll library.
●Keen focus on performance tuning, testing, and quality assurance.
●Experience in support on month end closing and day to day production issues.
●Experience in creating Technical and Functional documentations.
●Experience in database conversion.
●Experience on Oracle upgrades
●Experience in acquiring new skills, tools, business processes on the job with short learning curve as needed on every project
WORK EXPERIENCE:
R Square Incorporated - Princeton, NJ
May 2013 - Oct 2016
Oracle Technical Developer at New York City Housing Development Corporation in New York
Oracle Upgrade from 10g to R12
Worked as a Developer for NYCHDC Oracle Financial System (AP Payables, AR Receivables, GL General Ledger & MBS (NYCHDC Custom Module)
Learned Oracle Discover Administrator and Desktop on the job without formal training
Learned customizing Crystal Reports on the job without formal training
Maintain/Upload NYCHDC Loan Schedule Amortizations
Modified /Created Forms, Reports, Interfaces, Discoverer Reports
Maintenance of MBS Customization forms and process specifically built for NYCHDC, these involves Oracle Forms, Reports, PL/SQL Packages and processes.
Analyze user requirements to create new interfaces for Bank Statements for Accounting
Modified Reports using visual basic for Development Users Team
Exposure to R12 Extensions used primarily during upgrade with implementing team.
Maintain/Create PL/SQL Packages/Functions/Procedure/Interfaces and Database objects.
Vendor and Customer creation
Database object creation of tables, functions, procedure and concurrent requests.
Enterprise Solutions Group - New York, NY
Dec 2012 – May 2013
Oracle FAH Developer at Marsh & Mclennan, Hoboken NJ
Worked as a Developer for Oracle Financials Accounting Hub
Maintain HUB Components
Customize Form for Custom Schedule Application
Create & Validate WEB ADI Procedures/Packages
RJT Compuquest - Hawthorne CA
Oracle Applications Technical Developer at Parsons Brinckerholf, NY
June 2008 - Dec 2012
Worked as a Technical Developer for Oracle Applications 11.5.10.2
Learned on the job Oracle HR,PA,PO, IExpense technical skills without prior work experience
Converted Oracle Reports into BI Publisher Report by creating XML Codes
Created XML Reports Using SQL Programs
Applied Form Customizations
Applied Form Personalization
Create Interface programs for User Data Upload.
Modified Various Forms and Reports for the following Modules (AP,AR, PA,HR,GL,PO)
Customized several Web Pages for Oracle Internet Expenses
Created an Interface for Parson-FedEx transactions to flow from FedEx Systems to PB Applications
Maintain custom HR Forms, Reports and Processes
Maintain Project Custom Forms, Reports & Processes
Upgrade Oracle 11i to R12
Maintain/Create PL/SQL Packages/Functions/Procedure/Interfaces and Database objects.
Oracle Applications Technical Developer at Rainin Instruments LLC, Oakland, CA
Dec 2007 – May 2008
Worked as a Technical Consultant for Oracle Applications 11.5.9
Worked basically on AR module for day to day transaction primarily on Lockbox.
Modified Cash Application Program for EFT Checks
Worked Primarily on Incentive Compensation Report for Sales
IC worked involves creation of loading scripts for various data needed for IC, It also involves creation of IC Report and IC Data Loading
Used BI Publisher Enterprise to create a RTF Templates using XML output from Oracle Concurrent Reports.
Oracle Applications Technical Developer at Port of San Francisco, San Francisco, CA
Mar 2007 – Dec 2007
Worked as a Technical Consultant for Oracle Applications Upgrade 11.5.9
Worked basically on AR module for day to day transaction primarily on Lockbox.
Modified Cash Application Program for EFT Checks
Worked Primarily on Incentive Compensation Report for Sales
IC worked involves creation of loading scripts for various data needed for IC, It also involves creation of IC Report and IC Data Loading
Used BI Publisher Enterprise to create a RTF Templates using XML output from Oracle Concurrent Reports.
NIIT Technologies, Singapore
Techno – Functional Support at Building Construction Authority, Singapore
Jun 2006 – Dec 2006
Worked on customized forms and reports using form and report builder, and implemented and modified AR interfaces (TTAS) with regards to auto invoice and lockbox interface.
Oracle Developer at Singapore Sports Council, Singapore
Apr 2006 – Jun 2006
Worked on creating functions, procedure, forms and reports using SQL, form and report builder, modifying existing functions and procedures to cater for user requests.
Achieve Technology, Singapore
Nov 2005 – Apr 2006
Oracle Applications Financial (Upgrade) Developer at Singapore Tourism Board, Singapore
●Involved in data, form and report migration from 10.7 to 11i (11.5.10.2). Handled modules handled were: Oracle Payables, Receivables, General Ledger, Fixed Assets and Purchasing.
ColdStorage Singapore Private Ltd, Singapore
Apr 2002 – Nov 2005
Oracle Applications Technical Developer
Maintenance of the following system Oracle Applications 10.7 and 11i (Oracle Financials), CSMS\Welcome System, Fresh System, P2000 System (Cold Storage credit card system
ROCS Technology, Philippines
Oracle Developer at Grepa Life Insurance Philippines
Nov 2001 –Feb 2002
●Involved in creation of modules, analysis and design of agent’s modules that caters to immediate needs of GREPALIFE’S agents.
Oracle Technical Developer at Board of Investments Philippines
Aug 2001 – Nov 2001
●Worked as an Oracle Developer for Special Investor Resident Visa (SIRV) Project.
STSI (Systematics Tech. Services Inc.) Philippines
Oracle Data Warehouse Developer at Metrobank Philippines
Feb 2001 – Jul 2001
●Created Daily/Weekly/Monthly/Annual Reports for transactions of Metrobank and tune existing programs for efficient running of report.
Computer Professionals Inc, Philippines
Oracle Developer at Pioneer Insurance & Surety Corp
Nov 2000 – Dec 2000
Oracle Developer at Headstrong Philippines, Inc. (formerly James Martin) Philippines
Aug 2000 – Nov 2000
Junior Programmer at GENIISYS (General Insurance Information System)
Feb 1999 – Aug 2000
Software Farm International Philippines
Oct 1998 – Dec 1998
Programmer Trainee
COMPUTER SKILLS:
Programming Skills
Oracle BI Publisher Enterprise Release 10,Oracle Devsuite (Forms 10/Reports 10), Oracle Portal, Oracle Developer 2000 (Forms 6i / 6 / 4.5, Reports 6i / 6 / 2.5), Oracle 10.7, Oracle 11i, SQL Loader, SQL Tuning, SQL Navigator, PL/SQL, Pro* C, Unix, Pro Cobol, VMS, Visual Basic, COBOL, MS Access and Turbo Pascal
Customization Skills
Oracle Applications (AP, AR, GL, FA, CM, PA, HR, PO & a bit on Order Management), Financial Accounting Hub (FAH), Web ADI
Other Tools & Software
MS Office, MKS Track Source Integrity, FTP, TOAD, New Visio Enterprise Drawing, Serena PVCS Version Manager, BI Publisher – BI Publisher Desktop 10.1.3.4.2, Oracle 10G Developer Suite, SQL*Plus: Release, Oracle BI Discoverer Administrator,
Oracle Business Intelligence Discoverer Desktop 10.1.2.1, Oracle Discoverer 3.1,
Oracle Applications 11.5.9, Oracle RDBMS 11.2.0.2.0, Oracle RDBMS 9.2.0.4.0,
Oracle Developer Suite 10g 10.1.2.0.2, Oracle Business Suite Forms Builder 6.0.8.26.0, Oracle Business Suite Reports Builder 6.0.8.26.0, Oracle Database 10g Enterprise Edition Release 10.2.0.3.0, Oracle9i Enterprise Edition Release 9.2.0.8.0, Oracle9i Enterprise Edition Release 9.2.0.4.0, Oracle Application Server 10g Release 2 (10, 1.2),
Oracle Applications 12.1.3, Oracle Applications 11.5.10.2, Oracle Applications 11.03, Oracle Developer Forms 6i and Reports 6, Oracle Forms Version 10.1.2.0.2, Developer/2000 for Windows 95 FORMS 5.0, REPORTS 3.0, Oracle Reports 10g(Report Builder 10.1.2.0.2), Oracle Workflow Client Release 2.6.3.4, Quest Software Toad for Oracle 8.0, Quest Software Toad for Oracle 9.0.1, Quest Software Toad for Oracle 10.6, Oracle Jinitiator 1.1.8.16, Rational Clearquest 8.0.1, Print Screen Deluxe 5.0, Serena PVCS Version Manager 8.3.0.0, Oracle BI Publisher BI Publisher Enterprise Release 10.1.3.2, PVCS Tracker I-Net 7.5.1.0, PVCS Version Manager 7.5.1.0, P/L SQL 10g,
Putty 0.67, Oracle Developer Forms 4.5 and Reports 3, Oracle Developer Forms 4.5/5/6i and Reports 2.5/3/6/, ORACLE Applicatios 8.0, Oracle Applications 10.7, Oracle Applications 7.4, GRAPHICS 3.0 O/S - Sun Solaris, VMS, Pro Cobol, Pro- C
EDUCATION:
B.S. Mathematics Major in Computer Science
University of Santo Tomas (1994-1998)
Espana, Manila, College of Science
REFERENCES:
Available on Request
Contact this candidate