SUMMARY:

• Extensive professional experience in IT industry focused on Web and Database development using Oracle technologies.
• 14+ years of direct practice experience using ORACLE technologies with extensive experience in Oracle E - Business Suite release 11i and 12.1.x personalization, extension and custom application design and development utilizing Oracle’s Core Java/J2EE based web framework Oracle Application Framework (OAF), Oracle Mobile Supply Chain Application/Mobile Wireless Applications (MSCA/MWA) and Oracle iStore Framework (IBE) and custom Servlet development for payment gateway.
• 4+ years of progressive experience using core Java/J2EE.
• Experience in Oracle E-Business Suite’s modules, System administration and Application developer tasks
• Hands on experience in creating custom Oracle HRMS fast formula.
• Working knowledge in Oracle LogicalApps configuration.
• Experience in Oracle EBS r12 modules: GL, AP and AR.
• Extensive knowledge on utilizing Oracle EBS APPs database schemas and public APIs.
• Working Experience in Payment Gateway integration with Oracle iStore and Authorized.Net Payment Gateway API using Java Servlets.
• Working experience in developing modules utilizing Microsoft Bing Maps RESTful Service.
• Experience in Oracle PL/SQL, SQL*Plus, SQL*Loader, IMP/EXP, External Tables, custom Web ADI Integrators, DBMS, OWA, UTIL and HTP Oracle built-in API packages, Data Extraction, Transformation and Loading, Data conversion and interface development.
• Experience in working with Oracle bulk collections, varrays and etc.
• Experience using SQL Trace, TKPorf and Explain Plan for sql tuning and optimization.
• Experienced in using source/version control such as PVCS, SVN Subversion, TurtoiseSVN client, IBM ClearCase and MS Visual SourceSafe.
• Working experience in Microsoft Visual Basic 6 and ASP development.
• Working experience in static/dynamic web development using HTML, DHTML, Javascript, AJAX and JQuery.
• Working experience in Oracle Database creation and management in a development/Test environment (Instance and Schema), maintenance (Tablespaces, Datafiles and Indexes) and data loading and migration (Exp/Imp, SQL*Loader, External Tables, SQL*Plus Copy command).
• Experience in working for large organizations with SDLC and Quality methodologies.
• Been involved in all phases of software development Life Cycle.
• Provide client with technical input, estimates and mentoring on Oracle EBS extension and customizations for OAF based modules.
• Familiarity with Oracle Apex & Oracle Enterprise Asset Management (eAM).

TECHNICAL SKILLS:

Languages: Oracle Application Framework (The underlying J2EE technology used by the web-based portions of the Oracle E-Business Suite (EBS) product family), Java (J2EE, OAF Framework, iStore JSP, MSCA/MWA), Oracle PL/SQL, Forms and Reports, Oracle BI Publisher, Oracle Workflow Builder, Unix BASH Shell Scripting, Microsoft Visual Basic, Microsoft Active Server Pages (ASP), JavaServer Pages, JavaScript, JQuery, DHTML and HTML.

Oracle Software: Oracle E-Business Suite rel 11i/12.1.x, JDeveloper 9i/10g/11g, SQL Developer, Forms, Reports, BI Publisher, Workflow, SQL*Plus, SQL*Loader, IMP/EXP, DBA Studio and OEM.

Databases: Oracle Server 10g, 9i, 8i and 7.3.4, Microsoft SQL Server, MySQL, MongoDB and MS Access.

Other Tools: Apache Ant build tool, Apache Commons Beanutils, SEER SETTLE ETL Tool, Toplink Essentials, TOAD, IBM Websphere Studio v5.1, Eclipse, DreamWeaver, Jasper iReports, Crystal Report, JIRA and Confidential Compare.

Web/Application Server: Oracle Containers for Java (OC4J) part of the OAS Suite, Oracle Enterprise Manager, Apache Tomcat, IBM WAS, Microsoft IIS.

Hardware: IBM Netfinity Server, AcerAltos Server, IBM PC Compatibles and Barcode Readers, VMWARE and Oracle VM VirtualBox.

Source/Version Control:: Perforce/Piper, Confidential Critique(CL), Confidential Code Search(CS), HP PPM, GIT, PVCS, SVN Subversion, TurtoiseSVN client, Visual SourceSafe, IBM Rational ClearCase.

PROFESSIONAL EXPERIENCE:

Business Suite Technical Consultant

Confidential,California Duration

Responsibilities:

• Developed and support various Business Applications (BizApps) for Confidential 's Accounting and Controls Department under the Global Accounting and Compliance Team.
• Worked on Confidential gCore User Security Provisioning Tool, a custom OAF application for provisioning responsibility based roles for users in Oracle eBusiness Suite, Essbase and HFM applications.
• Developed Confidential Common File Upload Utility. An OAF based custom application that uploads using OAF built in upload component and consumes uploaded files with pre-defined concurrent based pl/sql packages.
• Developed the Confidential 's User Security Provisioning Access Request's Oracle Workflow approval process.
• Configure Responsibility based control using LogicalApps for the Confidential common File Upload.
• Modify Confidential 's existing custom SOX Audit Report and Workflow objects, to cater for gCore User's existing access controls in EBS.
• Authored and presented Technical Design Document for Code Reviews
• Participant on Confidential 's brown bag lectures on Oracle Security and Performance tuning
• Experience in using Perforce/Piper and HP PPM for source control and deployment.
• Experience in using Confidential 's Piper, Minority Report and Critique for submitting developed codes for review and deployment.
• Participated in Code Reviews.

Environment: s: Unix, Oracle E-Business Suite release 11, Oracle Application Framework (OAF), Oracle Database 11g, Oracle JDeveloper 9i, Oracle XML Publisher, JAD, SQL Developer, TOAD, SQL*Loader, LogicalApps, IMP/EXP, Perforce/Piper, Confidential Critique(CL), Confidential Code Search(CS), HP PPM, GIT.

Business Suite OAF Developer

Confidential,Washington

• Developed Supplier to Supplier Mapping utility Concurrent Program using PL/SQL scripting.

• Build Confidential Relationship Master (ARM) from the ground up by utilizing Oracle Application Framework (OAF) Technology stack.
• Extended Oracle Vendor maintenance dashboard to have the functionality to view ARM Supplier Relationships.
• Extended Oracle Golden Tax Adaptor for mainland China Concurrent program that interfaces with the Aisino Golden Tax System to cater Confidential .com’s requirements in generating VAT invoices for China.
• Build Confidential .com’s Returned Vendor Return Screens utilizing Oracle Application Framework (OAF) Technology stack.
• Provides Production Support via Trouble ticket assignment.
• Utilized Oracle seeded PL/SQL APIs related to Trading Community Architecture(TCA) for Party/Relationship DML operations.
• Utilized SVN for Source/Version Control.
• Authored MD070 for Confidential Relationship Master Project.
• Utilized advanced features in Oracle 11g for performance tuning, i.e: Collection, VArray and etc.

Environment: s: Unix, Oracle E-Business Suite release 12.1.x, Oracle Application Framework (OAF), Oracle Database 11g, Oracle JDeveloper v10, Oracle XML Publisher, JAD, SQL Developer, TOAD, SQL*Loader, IMP/EXP, PVCS, SVN Subversion and TurtoiseSVN client.

Oracle Database Developer

Confidential,Portland, Maine

Responsibilities:

• Development and modification of new and existing PL/SQL packages to satisfy user enhancement requests

• Provides production support and maintenance.
• Utilized features in Oracle 11g, i.e: Collection, VArray and Data Pump enhancements.

Environment: s: Oracle Database 11g, SQL Developer, TOAD, SQL*Loader, IMP/EXP and UNIX.

Business Suite OAF Developer

Confidential,Eastwood, Quezon City

Responsibilities:

• Develop custom Web ADI Integrators used for data conversion.

• Identify what Oracle public APIs to be used for each data conversion tasks.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Build the PL/SQL package wrappers being invoked by the custom Web ADI Integrators.
• Optimize and tune sql queries whenever possible.
• Communicate with the client on what data to be carried over to the new system.
• Mentor the user on how to use Web ADI for the actual conversion.
• To reduce performance overhead, utilized bulk collection features for optimization and easy retrieval of data and limit context switching between sql and pl/sql engines.
• Build custom OAF screen that utilizes OAF MessageLovChoice, MessageInputText and MessageCheckBox and displays the search result in Advance Table Region all mapped to a View Object referenced in the Application Module.
• Used Oracle workflow for the transition from one OAF page to another.
• Developed custom Entity Objects that invokes Oracle seeded API, View Objects and Application Module.
• Develop workflows approval process for Employee self service absence request.
• OAF Page Extensions done for Self Service Absence Module.
• Write fast formulas for Payroll ei: Hazard pay, Allowance, Representation and Transportation etc.
• Knowledgeable in AME setup and configuration of Approvers for absence approval requests.
• Ability to author DS-140 document.

Environment: Oracle E-Business Suite release 12.1.x, Oracle Application Framework (J2EE), Oracle Database 11g, Oracle JDeveloper v10/v9, JDK 1.5, Oracle XML Publisher, JAD, SQL Developer, SQL*Loader, Oracle ETL Tool.

Business Suite Developer

Confidential

Responsibilities:

• Develop the custom Java Servlet module used for the payment gateway integration between Oracle Payments and Authorized.Net Payment System.

• Utilized Authorized.Net Card Not Present API.
• Create custom table, views and PL/SQL objects in the Oracle Database.
• Co-authored the creation of the MD70.
• Created deployment scripts used on all the instances.
• Knowledgeable in configuring Oracle Payments and iStore for credit card transactions.
• Provided post Production support.
• Developed and customized existing iStore JSP pages to cater for new user request/enhancements.
• Configure environment for MSCA/MWA Framework for development and testing.
• Build and delivered MSCA/MWA Object extensions based on the functional specification (MD70).
• Developed extensions for the Ship Confirm Module.
• Utilized JAD to downloaded and decompile WMA Java packages for analysis.
• Created design solution (technical) document (MD70) for reuse and process adherance.
• Created deployment scripts used on all the instances.
• Provided support for printing barcode in thermal printers.
• Provided post production support.
• Develop the Java classes that communicates with Microsoft Bing Maps Service by utilizing the Bing Maps REST Service API.
• Develop the user interface inside Oracle EBS where user can enter the address to be validated.
• Customized OAF Search screen that utilizes OAF MessageLovChoice, MessageInputText and MessageCheckBox and displays the search result in Advance Table Region all mapped to a View Object referenced in the Application Module.
• The Entry screen utilized the OAF MessageFileUpload and MessageDownload webbeans to provide the users an upload/download facility of the vendor License documents.
• Build custom Entity Objects that invokes PL/SQL API, View Objects and Application Module.
• Develop PL/SQL packages used for transaction processing.
• Created deployment scripts for personalizations, OAF Java object customizations using Oracle XMLImporter for turnover to the client’s DBA for installation on production instance.

Confidential

Oracle Learning Management Tracking Application Extension

Responsibilities:

• Oracle Application Framework (OAF) personalization and extension of the OLM Learner Home Screen to display additional information for the status details.

• Decompile seeded oracle java classes to understand and trace program flow.
• Population of Learner(employee) levels using Concurrent PL/SQL Program invoking Oracle API calls.
• Created the Java deployment scripts, Apache OC4J bounce scripts to be turnover to the client’s DBA for installation on production instance.
• Created the import file the OAF Personalization settings to be turnover to the client’s DBA for installation on production instance.
• Offsite production support.

Confidential

Oracle Performance Management Review System OAF Page Extension

Responsibilities:

• Extends the functionality of existing Manager/Employee self service and CWB pages which support the Oracle Performance Management Review System.

• Extended several seeded OA Pages to make some fields write or read only using SPEL basing the condition for predefined non-metrics and metrics based objectives.
• Added validations on some OA Pages submit action event.
• Updated the MD70 for the OAF extension part.
• Created the Java deployment scripts, Apache OC4J bounce scripts to be turnover to the client’s DBA for installation on production instance.
• Created the import script the OAF Personalization settings to be turnover to the client’s DBA for installation on production instance.
• Created the FNDLOAD scripts for the menu, function and messages to be turnover to the client’s DBA for installation on production instance.

Confidential

Oracle Financials OAF Page customizations

Responsibilities:

• Develop custom OAF screens for the Confidential ’s Oracle rel 12 .1.3 rollout. The iExpense Cash Advance form allows the capture of employee’s cash advances and transform it into a pre-payment invoice in Oracle Payables.

• Developed custom OAF screens to capture Employee’s cash advance details and stored it in a custom staging table.
• Invoke oracle workflow approval in OAF application module (AM).
• Invoke RCBC Cash Advance Interface Concurrent Program that insert validated data into the standard AP interface table.
• Initiate Payables Open Interface Import Concurrent Program.
• Perform error handling by displaying corresponding error messages in the concurrent program request Log File.
• Co-authored the creation of MD70.
• Created the deployment and OC4J bounce scripts (java classes and xml files) and Oracle Database objects then deployed to the development and test instances and to be turnover to the client DBAs for installation on production instance.

Environment: Oracle E-Business Suite release 12.1.x and 11i, Oracle Application Framework, MSCA/WMA Framework, J2ME 1.1.8, Oracle Database 10g, Oracle JDeveloper v10/v9, JDK 1.5, Oracle XML Publisher, JAD, TOAD and Unix scripting.

Business Suite Developer

Confidential,Ortigas City, Philippines

Responsibilities:

• Involved in ADB Oracle E-Business Suite personalization, extension and custom development utilizing Oracle Application Framework.

• Created pl/sql stored procedures and packages, views, snapshot/materialized views and triggers.
• Used Oracle XML Publisher for report generation.
• Utilized Oracle Workflow for sending approvals via email notifications.
• Build, compile and deploy java classes on Oracle EBS Application Server.
• Installing applicable functionality, as needed, using Applications Object Library, Personalization, OA framework etc
• Developed concurrent programs.
• Troubleshoot PL/SQL packages and database procedures
• Migrate and upload data using API's, and performing data conversions
• Used SVN for source and version control.
• Used JIRA for tracking issues and posting resolved QA and Production issues.

Environment: Oracle E-Business Suite release 12.1.3, Oracle Application Framework, Oracle Database 10g, Oracle JDeveloper v10, JDK 1.5, Oracle XML Publisher and TOAD, Unix Scripting.

Confidential

Java/Oracle Developer

Responsibilities:

• Involved in the migration of Smart Inventory module from Client/Server (Visual Basic/MS SQL Server) to web-base (J2EE/Oracle Server) application.

• Defined new custom Tag Library Descriptor files(TLD) when needed.
• Used Servlet, JSP, DHTML, HTML & Javascript for the front-end(UI) design.
• Used AJAX Technology in developing front-end(UI) design.
• Used Oracle Explain Plan to optimize existing SQL Queries and Views.
• Used Dynamic SQL to generate SQL statements inside Stored Procedures and Packages.
• Optimize and tune existing queries.
• Generated SQL and PL/SQL scripts to install, create and drop schema objects. iReports was used in creating Jasper Reports to cater the requested reports of the user.
• Added and modified Java and Java Server Pages (JSP) files in correcting existing bugs and for adding new functionalities.
• Used Eclipse 3.1 as the main IDE in developing Java and JSP files.
• Used Microsoft Visual SourceSafe for source code control and versioning.

Environment: OC4J Standalone, Oracle Enterprise Manager(OEM) 10g, Java Connectivity Objects (JCO), Oracle 9i (9.2), TOAD, SQL Navigator, SQL*PLUS, PL/SQL, Windows 2000, Javascript, Dynamic HTML, Oracle Classes12 (JDBC), MS ADO, Crystal Report 8.2, Microsoft Visual SourceSafe, Jasper Reports, iReports version 2.0.

Confidential

Java/Oracle Developer

Responsibilities:

• Involved in the development of new user change requests/enhancements for BibDemand, Michelin Order Tracking System and Michelin Import Management System

• Added and modified Java and Java Server Pages (JSP) files in correcting existing bugs and for adding new functionalities.
• Use Oracle Explain Plan to optimize existing SQL Queries and Views.
• Used Dynamic SQL to generate SQL statements inside Stored Procedures and Packages.
• Developed the transformation and loading modules using Oracle Packages, Triggers and Materialized Views.
• Use Oracle Explain Plan to optimize existing SQL Queries and Views.
• Wrote SQL*Loader scripts for pumping csv and fixed width form Confidential ed data files into the temporary tables.
• Create scripts that use Oracle EXP/IMP tools for deploying from the development database to production.
• Implement the business rules using Oracle Packages, Triggers and Views.
• Optimize existing stored procedure by using oracle bulk fetch features, dynamic SQL, indexes and Materialized views.
• Help create guidelines on the coding standards to be used throughout the development phase
• Mentor and Assist novice Oracle developers.
• Participate in Maintenance and Technical Support as part of SLA (Service Level Agreement)

Environment: Oracle 8i (8.1.7), TOAD, SQL, SQL*PLUS, PL/SQL, Windows 2000, ASP, Javascript, Dynamic HTML, Visual Basic 6.0, MS ADO, Crystal Report 8.2.