SUMMARY:

• 20 years of analysis, design, development, testing, training and support experience in Oracle Applications.
• Extensive technical knowledge of the Confidential / Confidential components and its associated development tools.
• Good functional exposure in the Financials and Procurement modules.
• Solid understanding of the Oracle AIM Methodology and related documents such as CV.040, MD.050, MD.070, MD.120.
• Excellent troubleshooting, analysis and problem - solving skills.
• Ability to multi-task and prioritize.
• Can learn new technologies quickly and be able to coach others.
• A team player that can work independently with minimal supervision.
• International work experience

PROFESSIONAL SKILLS:

Oracle EBS Modules R12, 11i: Accounts Payables(AP), Accounts Receivables(AR), General Ledger(GL), Fixed Assets(FA), E-Business Tax(EBTax), Internet Expenses(iExpense), Inventory(INV), Purchasing(PO), iProcurement, Order Management(OM), Advanced Pricing, Human Resources(HR), Time and Labor(OTL), Advanced Benefits(OAB), Self-Service Human Resources(SSHR), Payroll, Bills of Material(BOM), Process Manufacturing(OPM), Projects

RDBMS: 11g, 10g

Oracle Development: SQL, PL/SQL, SQL Loader, Oracle Forms 6i/4.5, Custom PLL, Forms Personalization, Oracle Reports 6i/2.5, BI Publisher, Oracle Discoverer, Oracle Business Intelligence Enterprise Edition(OBIEE), Oracle Alert, Oracle Workflow, Oracle Application Express(APEX), jDeveloper, OA Framework

Others: TOAD, DataLoad, WinSCP, Putty, PVCS, Project and Portfolio Management(PPM), Oracle Beehive, JIRA, HTML, CSS, JavaScript with AJAX, Java, IBM Sterling B2B Integrator, WebWise, Advantage Architect, SAP Crystal Reports, Noetix, MS Office

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Consultant

Responsibilities:

• Discuss business requirements with users.
• Reviews functional specifications, performs code review and unit test, debugs/fixes issues, provides technical assistance to developers and prepares PPM requests for deployment.
• Prepared the CV.040, MD.050, MD.070 and MD.120 documents.
• Created RTF/eText templates for check, invoice, positive pay, electronic payment and aging report.
• Developed a program to set all customers as tax-exempt.
• Supervised conversion programs for supplier, customer, employee, project and open invoice.
• Managed the integration of data from Great Plains, Sage and Oracle EBS to provide a single source in Qlikview dashboard.

Environment: Windows 7 Professional, Oracle RDBMS 11g, Oracle Applications R12(AP, AR. GL, FA, EB Tax, iExpense, OM, PO, INV, HR, Projects), BI Publisher, Oracle Discoverer, PL/SQL, SQL*Plus, TOAD, WinSCP, Putty, Oracle Beehive, JIRA, PPM

Confidential

Systems Analyst

Responsibilities:

• Provided technical and functional assistance to users in the USA, Chile, Colombia and Mexico.
• Data maintenance for supplier, customer, salesperson, employee, user, responsibility and account.
• Created/modified programs, alerts, reports and RTF templates.
• Implemented EBTax for Mexico.
• Converted codes from 11i to R12.
• Main support during month-end close.
• Prepared technical documents and promotion scripts.
• Ad hoc requests required for SOX compliance.

Environment: Windows 7 Professional, Oracle RDBMS 11g, Oracle Applications R12(AP, EB Tax, iExpense, AR, GL, HR, OTL), BI Publisher, Oracle Reports, Oracle Discoverer, Oracle Alert, PL/SQL, SQL*Plus, TOAD, WinSCP, Putty, A-PDF Content Splitter

Confidential

Technical Analyst/Test Analyst

Responsibilities:

• Resolved problem tickets.
• Created forms, pages, reports and programs.
• Test analyst during the R12 upgrade and provided support to business users during user acceptance testing.
• Main developer for HighJump application.
• Main support during month-end close.
• Monitored errors in Electronic Data Interchange(EDI).
• Prepared technical documents and promotion scripts.

Environment: Windows 7 Professional, Oracle RDBMS 10g, Oracle Applications 11i and R12(PO, iProcurement, AP, HR, GL, Inventory), DataLoad, jDeveloper, OA Framework, Oracle Forms, Oracle Reports, Oracle Discoverer, IBM Sterling B2B Integrator, GHX, WebWise, Advantage Architect, SAP Crystal Reports, PL/SQL, SQL*Plus, TOAD, WinSCP, Putty, PVCS, PPM

Confidential

Technical Leader/Technical Analyst

Responsibilities:

• applications in Oracle and APEX.
• Prepared the project scope, timeline and ensure that projects are designed and delivered according to requirements.
• Alerted manager to potential risks and issues of importance.
• Mentored colleagues and consultants to improve productivity and efficiencies.
• Developed the functional, technical and installation specifications using AIM templates.
• Managed promotion requests and scripts between development, test and production environments.

Environment: Windows NT, Oracle RDBMS 10g, Oracle Applications 11i(OPM, PO, OM, AP, AR, GL), Oracle Developer 6i(Forms and Reports), Custom PLL, Forms Personalization, APEX 4.0, HTML, CSS, JavaScript, BI Publisher, OBIEE, Noetix, PL/SQL, SQL*Plus, SQL Loader, TOAD, WinSCP, Putty, PowerSteering

Confidential

Principal Consultant

Responsibilities:

• Modified existing objects and created new programs, forms and reports.
• Performed unit testing.
• Prepared the setup in production.

Environment: Windows NT, Oracle RDBMS 9i, Oracle Applications 11i(OPM, PO, OM, AP, AR), Oracle Developer 6i(Forms and Reports), BI Publisher, PL/SQL, SQL*Plus, TOAD

Confidential

Developer

Responsibilities:

• Developed statement of accounts and dunning letters.
• Created extraction programs in GL from Oracle to a subsystem.
• Prepared the technical documentation and promotion scripts.

Environment: Windows NT, Oracle RDBMS 9i, Oracle Applications 11i(GL, AR), Oracle Developer 6i(Reports), BI Publisher, PL/SQL, SQL*Plus, TOAD

Confidential

Senior Oracle Consultant

Responsibilities:

• Developed reports in Oracle Discoverer.
• Prepared the technical specifications.

Environment: Windows NT, Oracle RDBMS 9i, Oracle Applications 11i(Project Accounting), Oracle Discoverer Administrator 10.1.2, Oracle Discoverer Desktop 10.1.2, PL/SQL, SQL*Plus, TOAD

Confidential

Oracle Consultant

Responsibilities:

• Provided support to users in Oracle Financials and Distributions for the companies in Singapore, Thailand, Malaysia and Vietnam.
• Modified existing objects and developed new interfaces, forms, reports and programs based on change requests.
• Prepared the technical document and promotion scripts.

Environment: Windows NT, Oracle RDBMS 9i, Oracle Applications 11.5.9(AP, AR, GL, OM, PO), Oracle Developer 6i(Forms and Reports), Custom PLL, Forms Personalization, BI Publisher, PL/SQL, SQL*Plus, TOAD

Confidential

Oracle Consultant

Responsibilities:

• Main resource in GL and FA to handle change requests and fix production issues.
• Prepared the technical document and promotion scripts.

Environment: Windows NT, Oracle RDBMS 9i, Oracle Applications 11.5.9(GL, FA), Oracle Developer 6i(Forms and Reports), Custom PLL, PL/SQL, SQL*Plus, TOAD

Confidential

Developer

Responsibilities:

• Handled AP and FA data conversion.
• Designed and developed the following major interfaces for the USA operation:
• Converted an EDI 850 into an internal requisition and internal sales order.
• Created an interface from Oracle to UPS/FedEx subsystem to validate and ship confirm deliveries.
• Modified an existing pricing interface with the pricing API(Application Program Interface).
• Built a system to handle RMA(Return Material Authorization).
• Fixed production errors.
• Prepared the technical documentation and promotion scripts.

Environment: Windows NT, Sun Solaris, Oracle RDBMS 9i, Oracle Applications 11i(PO, OM, AP, AR, GL, FA), Oracle Developer 6i(Forms and Reports), Custom PLL, Oracle Alert, PL/SQL, SQL*Plus, SQL Loader, TOAD, PL/SQL Developer, WinCVS

Confidential, Philippines

Oracle Applications Technical Consultant

Responsibilities:

• Handled a custom application which served as entry point for staff receivables, interest calculation and payroll deductions.
• Developed a self-service to display the receivable and loan deductions, credit details and loan entitlement of a staff based on a payroll period.
• Resource person in GL and AR to fix production issues and implement change requests.
• Updated an existing function that is used in fast formulas for new hire, promotion, transfer office, leave of absence and termination.
• Provided support to users for errors encountered in OAB and during payroll run.
• Prepared on-line help and tutor documents for custom forms, technical documentation and LDT scripts for all setup.

Environment: Windows NT, IBX AIX, Oracle RDBMS 8i, Oracle Applications 11i (AP, AR, GL, FA, HR, OAB, Payroll), Oracle Developer 6i(Forms and Reports), Custom PLL, Oracle Self-Service, Fast Formula, PL/SQL, SQL*Plus, SQL Loader, Dataload, Author 11i, TOAD, Hummingbird, PVCS Version Manager

Confidential, Philippines

Consultant

Responsibilities:

• Created a new functionality to monitor the PO fulfillment of vendors.
• Built database triggers that would automatically create a sales order line whenever a purchase requisition header/line is cancelled for drop shipment.
• Developed custom reports in AP and Pricing.
• Prepared the technical documentation and LDT scripts for all setup.

Environment: Windows 98, Sun Solaris, Oracle RDBMS 8I, Oracle Applications(PO, OM, AP, INV), Oracle Developer 6.0(Forms and Reports), Custom PLL, PL/SQL, SQL*Plus, Dataload, TOAD, MKS Source Integrity

Confidential

Technical Analyst/Developer

Responsibilities:

• Conducted a seminar on how to use Designer/2000 to both development and testing teams.
• Analyzed the Information and System Architecture to come up with the detailed design of the system.
• Developed moderate to complex objects for core records including the technical specifications.
• Examined change requests to come up with impact analysis.

Environment: Windows NT, Oracle RDBMS 8, Oracle Designer 2.12, Oracle Developer 6 (Forms and Reports), PL/SQL, SQL*Plus, TOAD, MKS Source Integrity