PROFILE:

• I am a contracting Techno - Functional Architect/Developer with over 14 year experience in Oracle Applications, Oracle Database development and Administration with substantial experience on implementation and support of Financials, Oracle Purchasing, Oracle Projects, Oracle Fixed Assets, Oracle Order Management, Shipping Execution and Manufacturing.
• Oracle E-Business Suite 12.1.2, 11.5.10, 11.5.3
• Oracle SOA Suite 12.1.3
• Over 10 years Oracle Development (Oracle Forms, JDeveloper, Oracle Reports, SQL, PL/SQL, Oracle BI Publisher/XM Publisher, Forms Personalization, OAF Framework, SOAP/REST Web Services).
• Expert level skill on Oracle Applications Development.
• Expert level skill on Linux/Unix scripting.
• Senior level skill on Java development
• Experience as an Oracle DBA.
• Working Knowledge of JSP, Javascript, ANGULARJS, Node.js.
• Training and working knowledge of Apple IOS development.

EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Presented of a Proof of Concepts and a design for an SOA based integration using XML and Oracle Business Event.
• Designed and developed an XML Contract Invoice message to send all relevant Oracle Payables Invoice Header, Lines, Distributions, matched Purchase Orders and Receipts to the ORACLE SOA Middleware for transmission to Unifier.
• Designed and developed an XML Payment Details message to send all relevant Oracle Payment Check and Invoice information to the ORACLE SOA Middleware for transmission to Unifier.
• Designed and developed an XML Oracle Projects Actuals and Accruals XML message to send all Oracle Project Expenditure and Cost Distributions to the ORACLE SOA Middleware for transmission to Unifier.
• For each of these three integrations, I also designed and developed the initial data conversion program.
• Supported the three testing cycles, Product Testing, SIT and UAT.

Confidential

Oracle DBA

Responsibilities:

• Designed and developed Items Integration from Info EAM to Oracle EBS.
• Designed and developed GL Journal Entries Integration from Info EAM to Oracle EBS.
• Designed and developed Contract Invoices Integration from Oracle EBS to Info EAM.
• Designed and developed Approved Suppliers Integration from Oracle EBS to Info EAM.
• Designed and developed Oracle PCARD Expenses Integration from Oracle EBS to Info EAM.
• All of these integrations were implemented using Oracle EBS Open Interface, Oracle EBS Business Events, XML and Oracle SOA 12.1.3 Suite.

Confidential

Responsibilities:

• Functional and technical support of the first implementation of Oracle Inventory for Confidential .
• Setup of Oracle Inventory Configuration
• Creation of Master Item Org and a Child Inventory Org.
• Creation of Item Import Template for default Item attributes.
• Setup of Custom Item Statuses.
• Design and developed Conversion programs for initial loading of the following Oracle Inventory data:-
• All Purchasable and Inventory Items.
• Item attributes and Tracking Methods.
• Item Categories and Sub Categories.
• Unit of Measure, their Standard and INTRACLASS Conversions.
• Supported the three testing cycles, Product Testing, SIT and UAT for this module.
• Gathered the requirements, designed and developed a generic file comparison tool to be used during conversion projects to compare Pre and Post conversion files.
• Gathered the requirements designed and developed an XML and Bar chart based Project Spend Analysis report.

Confidential

Responsibilities:

• Integration SAP FieldGlass invoices.
• Integration of Oracle Projects and Tasks
• Designed new Payment Process Profile for Confidential
• Payments based on Standard 820 Format and XML template.
• Integration Vendor and Vendor Site data.
• Integration of Banks and Branches.
• Integration of Vendor Banking Details.
• Designed and developed Employee Bank Account interface from Workday to EBS.
• Designed and developed Employee Project Tasks assignment interface from EBS to Workday.
• Designed integration based on REST web services.
• Leveraged existing ADF java classes to create service classes.
• Amended attachment classes to include all attachments and replace attachment binary data with URL.
• Amended Expense Report classes to include multiple project account code allocation.
• Designed and developed a process to encrypt sensitive data using Oracle Wallet based encryption key and encryption Java classes.
• Designed and developed daily currency exchange rate data sourcing by integrating EBS with Openlink Treasury and Risk Management application.
• Installation and customization of Oracle Integrated SOA Gateway for deployment of SOAP and REST Web Services.
• Converted multiple reports from pure Oracle Reports to Microsoft Word and Excel template based.
• Made a presentation: An overview of SOAP and REST Web Services.

Confidential

Responsibilities:

• Performed the extraction and loading of all Security Matrix data including application Users, Responsibilities, Menu Exclusions, Request Groups, Profile Options and their values.
• Performed the extraction and loading of all Value Sets and Lookup data.
• Coordinated environment refreshes and other tasks with the DBAs.
• Coordinated and supervised offshore EBS Payable development team.
• Developed all Payments (IBY) related changes.
• Designed and implemented multiple payment cheques for multiple organizations.
• Installed and implemented MICR font for payment cheques.
• Performed the extraction and loading of AP Suppliers and Supplier Sites.
• Performed the extraction and loading all data for PO Groups, PO Rules, PO Approval Assignments, PO Item Locators, PO Cross References, Item Sub Inventory and Service Approval Groups.
• Performed the extraction and loading all Receivable Receipts.
• Applied Confidential customizations to R12 iExpense and PO Approval workflows.
• Proposed a parallel job execution Framework based on Oracle Advance queue (AQ). This was never used.
• Made a presentation: RICE migration framework for use during the implementation of E-Business Suite R12.
• Developed and amended many Excel Oracle Project and Oracle Fixed Asset reports using PLSQL.

Confidential

Responsibilities:

• Production support of multiple Oracle modules; AP, AR, PO, GL, INV, Internet Expense, Mobile Expense, FA, PA, PM.
• Directly support Users and Functional Analysts in four locations; Houston, Calgary, Edmonton and Toronto.
• Designed and developed Confidential Gas SAP to Oracle EBS Interface for third party payables using Oracle Payable Import program.
• Designed and developed Confidential Gas SAP to Oracle EBS Interface for third party receivables using Oracle Autoinvoice.
• Designed and developed interfaces between EGD Municipal Property Tax applications (LAMPS) and Oracle EBS Payables using Oracle Payable Import program.
• Customization of Oracle Project Approval (PAPROWF) and Oracle iExpense (AEXP) workflows.
• Customization of PO and PA account generator workflows.
• Development and customization of various reports using Oracle Report 10g and Oracle BI Publisher.
• Personalization and customization of various Oracle Forms 10g and OAF Forms.
• Made a presentation: Using XML Gateway for inbound and outbound interfaces.
• Customized Purchase Order report with multiple “Terms and Conditions” applicable to different Organizations.
• Made a presentation: Using E-commerce Gateway for standard Format based data exchange.

Confidential, Melbourne FL

Developer/DBA

Responsibilities:

• Implemented EBS Receivables as an Enterprise Customer data hub.
• Designed, mapped and loaded all existing Peoplesoft Customers into Confidential .
• Designed, mapped and loaded all existing Siebel Customers into Confidential .
• Designed and developed XML Gateway based programs to propagate customer data and their changes from EBS to Peoplesoft and Siebel.
• Integration of Shipping Execution with Confidential ShipManager
• Gathered the requirements, designed and implemented an integration of Shipping Execution with Confidential ShipManager.
• Branding of Order Management Reports
• Implemented the branding of multiple outbound Order Management reports like Purchase Order report, Order Acknowledgment, Packing Slip.
• Added Multiple Logos and Terms and Conditions for multiple organizations.