SUMMARY

• 13 Years experience in IT System Development Life Cycle. Extensive Experience on Implementation, data Conversion/Migration, Reports, Interfaces/integrations, Customization and Production Support. Responsibilities include analysis, requirements gathering, application Design, Documentations, Support, programming and leading developers.
• Adept at all stages of project lifecycle, from business requirements, functional setups and technical definitions to development, testing, implementation, production support and documentation
• Hands - on experience with Oracle Forms, libraries, Oracle Reports, SQL, PL/SQL, Interfaces/APIs, Workflow, Web PL/SQL, Unix Scripting, Advanced Qeueing, Java, OAF Customizations and Extensions, Forms Personalizations, OAF Personalizations, SQL Loader, XML Publisher reports for Oracle E Business Suite and Web Services (oracle enterprise manager 10g)
• Experience with Streamserve for printing, email and faxing documents from Oracle Applications.
• Experience with CyberSource Credit Card Integration for Tokenization in Oracle r12 and Oracle Integration with 3Delta Credit Card Integration
• Experience with iStore Jsp Customizations
• Hands On Experience with the following integration in oracle: cXML B2B integration, Web order, Siebel Service Orders Integration, Highjump/UPS integration and Plantstar.
• Significant experience in performing day-to-day maintenance and support of existing applications in parallel with the analysis, design, development and co-ordination activities for new applications.
• Experience on the following modules in oracle applications E-Business Suite: Order to Cash, iSupplier, Inventory, Purchasing, MRP, iExpense, Advanced Collection, Financials (AP,AR,CM,GL,FA), Project Accounting, HR, iStore
• Worked on Insurance, telecommunication, Government Sports Council and Manufacturing companies
• Collaborate well with project management, business analysts and department management teams

TECHNICAL SKILLS

Oracle Applications versions: 10.7, 11.5.3, 11.5.9, 11.5.10.1, 11.5.10.2, 12.1.2

Programming Languages: Recital, PL/SQL, SQL, Unix Scripting, web pl/sql, java

Developer Tools/Programming: Oracle 7.x/8.x/9i/10g, Forms6i/4.5/5, Reports 6i/4.5/5/2.5, SQL*Plus, PL/SQL, SQL*Loader, TOAD, Workflow 2.6, Jdeveloper 9i and 10.1.3 for web services, Streamserve 5

RDBMS: Oracle 7.x,8.x,9i, 10g, 11g

PROFESSIONAL EXPERIENCE

Confidential - Oakland, California

Oracle Techno-Functional

Responsibilities:

• Gathers Business Requirements and provide design documentations to Business Management
• Oracle AP Checks integration with Acuprint software.
• ACH Project. Configured Electronic Payments and CUBI Integration for Supplier’s Payments and electronic payment advice
• Plantstar Integration. Automate WIP Job Completion and Resource transactions in Oracle from Plantstar.
• EDI for Japan and Canada for 850,855 and 810
• Host Fax Integration Project. dis project will require Fax integration for all Document Facing Reports via StreamServe. Responsible for coding Oracle Reports in ERP and developing Fax Feature using Rightfax in Streamserve.
• Export Documentation Project. dis project requires the use of UnZExport Software. dis includes generating programs to load master data and transactional data from Oracle Applications into the UN&Z Software for International Documentations.
• B2B - Integration of Sciquest/Ariba orders/invoices via Pebblejet to/from Oracle. dis includes automated booking process which includes Order Holds, Price Adjustments, New Reports (with email notification), Credit Card Integration with 3Delta Merchant. Invoicing Integration with B2B Pebblejet-Ariba Platform.
• 3delta Credit Card Integration. Integrate Credit Card 3delta for outbound and inbound processes in Oracle.
• Oracle Integration with Intershop WebStore (Enfinity) for web order import and Pricelist and customer Datafeed process
• Upgrade from 11.5.9 to 11.5.0.2.
• DB Upgrade from 9i to 11g DB for B2B platform
• Production Support

Environment: Oracle E-Business Suite R11i (11.5.10.2); Oracle (9i): PL/SQL, SQL, Toad, Order to Cash, Streamserve 5, Financials; Oracle 11g DB Upgrade

Confidential, CO

Oracle Developer Consultant

Responsibilities:

• Responsible for developing all pages and their functionalities for Standing Order Program which includes the Summary, New Order and Change Order Pages. Also includes modification to the Shipping, billing, order review/summary, Add to cart and Item detail pages.
• Configure new templates in iStore Administrator
• Fixed Production issue on billing pages for Canada Orders

Environment: Windows Oracle E-Business Suite R11i (11.5.10.2); PL/SQL, SQL, Jdeveloper,Java, iStore Module

Confidential - Utah

Oracle Technical

Responsibilities:

• Created common functions/Java pl/sql to call Cybersource to perform tokenizations for credit card numbers.
• OAF Extensions on Customer Screen to integrate with cybersource credit card payment.
• OE Form Personalization for credit card
• Credit Card Conversion to Dummy numbers

Environment: Oracle E-Business Suite R12 (12.1.2); Oracle (10g): PL/SQL, SQL. Toad, Jdeveloper, Oracle Application Framework (OAF), Order Management/Entry (OM/OE), AR

Confidential, Rhode Island

Oracle Techno-Functional

Responsibilities:

• Gathers Business Requirements and provide technical documentations to Developers
• Full Life cycle from requirements to specifications to testing to deployment using Oracle’s AIM Approach.
• HR Bridge to Oracle HR. Creation of scheduled request set to receive and process the inbound files received from external Application, PeopleSoft, thru evision server to create, update, terminate or rehire employees in Oracle .
• Service Contracts and Accounting Project. dis project was to integrate Siebel System to Oracle using AR Open interfaces, triggers and shell script for email notifications and AQ messages to Websphere .Revenue Recognition api for Concurrent Sales Scheduled Billing and Web Service Agreement Pricing.
• Back to Back Ordering Project. dis project is implement relational business in EMEA and ASEAN to allow orders to be placed in local orgs but items sourced from DC’s, factories or external suppliers using Order Line Workflow Customizations.
• Customer Interface to Middleware Project. dis project is to ensure dat messages gets thru to Middleware when their is an update or creation of customers. Only one message should be sent per customer update/creation.
• HR 2010 Project. In corporate changes to HR Benefits Interface, 401K -Vanguard and Payroll Interface to ADP for 2010 APC’s new health/401k benefits
• Project Accounting . Customized Supplier Invoice Account Generation Workflow to work on Global Chart of Account Structure.
• Form Personalizations in Accounts Receivables and Purchasing.
• OAF Extensions/Personalizations in iSupplier Portal
• New OUs Implementation Projects. dis Project includes conversion of Oracle to Oracle for implementing Global Chart of Account structure and migration of legacy to Oracle for EMEA, Dubai, Costa Mesa, Asean Countries using interfaces/APIs for the following module: AP, PO, Receiving, ASL, Items,QOH,TCA-Customer, FA Tax books. dis also includes modification of existing Reports, Integrations, extensions, customization, autoaccounting triggers and COGS workflows and Created GL Consolidation and created OAF GL Mapping Custom Page.
• Automate CTO Reservations Process. Created Procedures for CTO Reservations (Reservation Interface) to delete and create generic and sales orders specific reservations and provide reports and Email Notifications
• Implement Advanced Collection Module(ACM) . Technical role to implement ACM at APC which includes creation of Dunning letters, statement of accounts using XML Publisher Reports and customized java concurrent program for sending emails and created new custom metric components . Customized Online Invoice Printing in Advance Collections Module thru Bill Presentment Architecture. Created various reports in ACM .
• Sales order Acknowledgment Email Notification. dis project is to enhanced the existing Program to in corporate different email notifications based on Language DFF settings for the Order using Shell Scripts and XML publisher reports. iSupplier Portal. Developed Supplier Forecasts and Video training files using Web PL/SQL (Mod PL/SQL)
• American Express (AMEX) inbound/Outbound. dis project is for corporate’s credit card expense feed to APC and America Express thru EDI using sqlldr, shell scripts and pl/sql procedures
• Production support and Operational AIMs (customization of various Reports, Custom Libraries/Form etc) for the following: Advanced Collections, Cost and Pricing Web Services, Web Orders, Service Orders from Siebel, CMS OAF Page, Web Customers, Other Interfaces such as Item Costing, (B2B) BOM Upload, Item Upload from Lotus notes and customized reports, interfaces across all modules at Confidential WorldWide.

Environment: Oracle E-Business Suite R11i (11.5.10.2); Oracle (10g): PL/SQL, SQL. Toad, Jdeveloper, Oracle Application Framework (OAF), XML Publisher or BI Publisher, Trading Community Architecture (TCA), Service Contracts, Order Management/Entry (OM/OE), AR, AP, GL, Advanced Collection Module, Application Object Library (AOL/FND),Flexfields, iSupplier, iExpense, HR, Supply Chain, Web Customers (AK Developer), Web Services (Enterprise Manager 10g), Application Issue Management System(AIMS)

Confidential

Tech Lead

Responsibilities:

• Created various application extension developments using Oracle Reports and sql programs for the following modules: OM, AR and AP.
• Conduct Trainings on Oracle Applications System Development
• Developed programs for Oracle Process Execution using APIs (OPM).

Environment: Oracle E-Business Suite R11i (11.5.10.1); Oracle (9): PL/SQL, SQL. Toad, Trading Community Architecture (TCA),OPM,OM,AR,and AP

Confidential

Oracle Applications Technical Consultant (Lead)

Responsibilities:

• Developed programs for the following Migration: Vendor Master, Customer Master, Quantity On Hand and Inventory Item Master. Open Sales Orders
• Developed various custom reports in PDF and text formats using PL/SQL and Oracle Reports.
• Developed Email Notifications for the Sales Report and Quantity on Hand Report Attachments to Marketing and Management Executives.
• Supported users’ ad-hoc query requests

Environment: Oracle Applications 11.5.10 - Order Management, Inventory, Financials, PL/SQL, SQL*Plus, Oracle Forms 6i& Reports 6i, TOAD, Unix Sun OS 5.9, Unix Shell Scripting

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Provided functional and technical documents using MD.50 and MD.70
• Created various reports and Oracle Alerts in Order Management.
• Customized Project Supplier Account Generator Workflow
• Enhanced workflow notification on PO approval.
• Created program to interface large and small components from B2B portal using Inventory Item Master and Item category Interface and BOM API.
• Developed Receiving Interface Program

Environment: Oracle Applications 11.5.9 - Order Management, PO, INV, Alert, PL/SQL, SQL*Plus, TOAD

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Design and Implement the technical and functional requirements for Fuji Xerox Drop Shipments for OM,AR,PO and AP. Provided Technical and functional Documents
• Created the following Programs: Data Massaging for Item Pricelist before order import, Data Massaging for PR Interface, Procedure to generate supplier receipt confirmation, Created alerts, Receiving Open Interface and AP Interface based on the Supplier’s DSNO file .
• Created Programs and Alerts for Pricing Feed Loading to Custom Pricing Database.
• Post Production Support

Environment: Oracle E-Business Suite R11i (11.5.10); PL/SQL, SQL. Toad, Windows XP, Unix, OM, PO, AR, AP

Confidential

Oracle Technical Consultant

Responsibilities:

• Conversion of various Custom Reports to version 6i (PO, AR, AP, FA, Cash Register and GL)
• Created program for CM interfaces for DBP Bank payment files which includes the use of IDEAL System to decrypt and ecrypt files.
• Designed and developed Custom Form and Reports for AR Recurring Invoices with custom Workflow Notification and Approval routing. Defined Setups in AR and provide User training .
• Created Oracle Alerts for Booked Orders
• Created program for GL interface for processing exchange gains and loss for foreigh currencies.
• Post Production Support

Environment: Oracle Applications 11.5.9 - AR, AP, FA, CM, PO, GL, PL/SQL, Oracle Reports 6i,Oracle Forms 6i, SQL*Plus, Workflow 2.6, Shell Scripting, TOAD, Unix

Confidential

Oracle Techno-Functional Consultant

R esponsibilities:

• Production support and Month end Production support
• Maintains and Supports Integrated Client Management System under DB2 using oracle reports
• Provides support for Oracle Applications Financial Modules such as FA, AR, AP and GL for interfaces and created various reports.

Environment: Oracle Applications 11.5.3 Financials, ICMS under DB2, Report v5

Confidential

Oracle System Analyst

Responsibilities:

• Technical leader; for policy systems
• Designed and Developed various reports, forms using Oracle Reports, Forms, Graphics and Designer for all policy system .
• Production Support

Environment: Novell Netware Environment, Oracle 7/8i, Oracle Developer (Forms v5 & Reports v5), PL/SQL, Oracle SQL+ v8.0.6, TOAD (Tool for Oracle Application Developers), Oracle designer 2000, Oracle graphics v5

Confidential

Programmer

Responsibilities:

• Production Support and developed various reports for Order Entry and Billing System

Environment: Unix (Solaris 2.6, IBM-AIX Ver 3.2.5 RS6000,Windows NT, Oracle v8, Recital V7.1, Oracle Developer v5 (Forms & Reports), PL/SQL