PROFESSIONAL SUMMARY:

• Confidential is a skilled IT Consultant possessing 14 years of Oracle Consulting experience, which includes 11 years tenure working with Oracle E - Business Suite. His strong Oracle technical background includes experience in business requirement gathering, integration, utilizing customer facing skills and consulting with multiple levels of staff within small and large organizations. He has worked in a variety of industries both in Australia and overseas.
• He has implemented, customized and provided post production support for Oracle EBS Release 11i/12.2.4 on Supply Chain Management, Oracle Financial and Oracle HR as well as implemented Single Sign On solutions using OAM, OID, Microsoft AD and ESSO
• He has extensively worked on development, customization and extensions using Oracle PL/SQL, Oracle Jdeveloper, Oracle Workflow Builder, AME, Oracle Forms and Reports, Discoverer Reports, Linux Shell Scripts, Sql-Loader, Oracle BI Publisher and Oracle Alerts.

TECHNICAL SKILLS:

Technology and Tools: Oracle Apps Framework OAF, ADF Oracle Internet Developer Suite 6i/10g (Forms and Reports) PL/SQL, SQL+, Linux Shell script Oracle Workflow Builder and Customization Oracle BI Publisher Desktop XML Publisher Web ADI OAF Personalization and Customization Forms Personalization and Customization Oracle 9i jDeveloper Export, Import, SQL * Loader Toad, Pl/Sql developer, Sql Developer Oracle Discoverer 4.0 (Administration & Desktop Edition) Oracle 9i, 10g,11g Oracle Alerts WinCVS, Config Snapshot OAM, OID, Microsoft AD,ESSO

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Logon Manager Console
• Logon Manager Agent
• Password Reset Server
• ESSO Reports
• Credential Synchronization with Active Directory.
• Windows Logon Self Service Password Reset.

Solutions Architect

Confidential, Perth WA

Responsibilities:

• Developed Transition Framework methodologies for EBS to upgrade from 11. .2.4 with no business down time using change data capture CDC with Oracle Golden Gate.
• Requirement gathering, documentation and effort estimate.
• Technical guidance for development team and monitoring various objects for completion to meet project deadline.
• Developed various components for Transition Framework
• Sequence ID synchronization between custom module and EBS.
• Development various EBS APIs for transition
• Major contributions in interface development
• Inventory Material Transactions
• Sales Order
• Shipping
• Warehouse Management
• Cycle Count
• Payable Invoices
• Requisitions
• UAT testing and issue fixing.
• Developed remittance advice delivery to vendors with Excel attachment, E-Text output for vendor electronic payment, check printing, bank transmission using payment process profile and business events.
• Technical support for various custom modules.
• Performance tuning.
• OAF Personalization.
• Upgrade support.

Confidential

Responsibilities:

• Invoice interface from OTL/Project Expenditure and invoice print for RCTI.
• Developed project client extension overtime process.
• Developed workflow for invoice and distribution approval using invoice hold feature

Confidential

Responsibilities:

• Oracle E-Business Suite Release 12.1.3 implementation.
• E-Text EFT outbound payment file generation for ANZ Bank Domestic and International
• Account generator workflow modification for Projects - Expense destination. i-procurement
• Invoice distribution
• Purchase Order
• Account generator automation for Work Order and shop floor requisition - EAM.
• Writing accounting rules for Projects.
• OAF page extension and personalization for Work Order -- EAM.
• Supplier/Supplier bank conversion.

Confidential

Responsibilities:

• Repository Creation Utility for Oracle Internet Directory.
• Oracle Access Manager
• Oracle Identity Management
• Oracle WebTier/WebGate
• Oracle EBS AccesGate
• Windows native authentication using Kerberos
• Integrating Oracle E-Business Suite Release 12 with Oracle Access Manager 11gR1 (11.1.1.7.0 ) using Oracle E-Business Suite AccessGate

Confidential

Responsibilities:

• Oracle E-Business Suite Release 12.1.3 implementation.
• Invoices Interface/GL Interface/Credit Card Interface/PO Approval, PO Auto Create work flow customization.
• Bank Statement Loader/E-Text EFT outbound payment file generation for Bank
• Form personalization
• Payables/Receivables sub-ledger setup for integration with general ledger.
• Creation of AME Approval groups and Rules for i-Expense and Payable Invoices.
• Report Development using BI Publisher for PDF/Excel output.
• Integration and Automation between
• EBS payment system and Bank
• EBS cash management and Bank
• EBS i-expense and Visa credit card.
• EBS employee creation and Alesco Talent2 payroll.

Confidential

Responsibilities:

• Oracle E-Business Suite Release 12.1.3 implementation.
• Invoices Interface/GL Interface/Credit Card Interface/PO Approval, PO Auto Create work flow customization.
• Bank Statement Loader/E-Text EFT outbound payment file generation for Bank
• Development of restricted cash process and Cash flow Reports using Microsoft Excel Templates.
• OAF Page/form personalization
• Creation of AME Approval groups and Rules for i-Expense and Payable Invoices.
• Report Development using BI Publisher for PDF/Excel output.
• Preparation of MD70 and MD120.
• Invoice Automation with scanning.

Confidential

Responsibilities:

• Development, customization and support in E-Business Suite 11.5.10.2
• Developed e-mail notification for vendors using XML publisher for batch payments using XML- Bursting solution
• Developed custom OA Framework page for uploading and updating organization hierarchy from SAP HR system for time-sheet application.
• Developed custom allowance claim module and integration with payment system.
• Maintenance of custom time-sheet module.
• Developed Visa Credit card interface to internet expense.

Confidential

Responsibilities:

• Patch impact analysis on customizations for finance, purchasing and inventory.

Confidential

Responsibilities:

• Customization development.
• Conducting on forms6i/workflow/reports6i/XML Publisher
• Code/Document Reviews
• Co-ordination between offshore team and onsite consultants.
• Preparation of MD50,MD70,BR100
• Requirement gathering with the business users and suggesting alternative solutions
• Developed Concurrent Programs AP interface, Sales order line cancel, receipt interface for vehicle and Spares
• Development using form6i
• Landed costing calculation
• Sales order accessorization
• Item on hand availability / Sales history
• Vehicle assessment and Pre-assessment
• Vehicle finder for creation of sales order
• Vehicle installment order
• Customization of standard COGS account Generator
• Custom work flow for order management approval
• Development of XML publisher reports
• Invoice Reports - Trading/Vehicle/Used Car, Gate pass, Pick slip, and Check printing.
• Alerts development
• Form personalization
• Customization using custom PLL.
• Performance tuning/post production support.

Confidential

Responsibilities:

• Upgrade of custom pll for purchasing, finance, inventory, iProcurement.
• Upgrade of customized requisition and PO workflow.
• Upgrade of alerts.
• Post production support.

Confidential

Responsibilities:

• Developed extract of sub ledger transactions of receivables (revenue), order management (cost of sales), marketing (discount and promotions), payables (promotions), manual (adjustments) to OFA staging tables.

Confidential

Responsibilities:

• Developed drilldown view for invoices, payments, receivables, purchase, inventory, project Revenues.
• Developed interfaces for projects, tasks, key members, classifications, budgets and budget Lines, agreements and funding.
• Upgrade activities for EBS.
• Post production support.

Confidential

Responsibilities:

• Developed payment confirmation extract, GL budget interface, AP invoice interface, supplier and supplier site interface

Confidential

Responsibilities:

• Upgrade of customized PO account generator workflow.

Confidential

Responsibilities:

• Upgrade of customized project expense report account generator workflow.

Confidential

Responsibilities:

• Project status management report optimization - Weekly report, Work In progress, Standard cost by contract, Cost forecast report by contract

Confidential

Responsibilities:

• Impact analysis on Oracle discoverer reports for upgrade

Confidential

Responsibilities:

• Upgrade of EBS Suite to 11.5.9
• Modules: Finance, Purchasing, Inventory, Legacy System
• Upgrade of school IFAS solution to forms9i/reports6i.
• Bug fixing and enhancement.
• Query optimization.
• Developed AP invoice interface, bank statement upload.
• Application support after upgrade.

Confidential

Responsibilities:

• Modules: Finance, Purchasing, Inventory
• Developed PO interface, PO receipt interface, Return to vendor interface, GL interface.
• Developed custom check printing and remittances advice report, EFT outbound file as per bank format.

Confidential

Responsibilities:

• Developed reports using developer 6i, PL/SQL procedures and discoverer.

Confidential

Responsibilities:

• Developed custom screen and screen to check stock at different location.
• Packing slip: This form/report is used to scan the finish goods while packing for stock transfer from factory Inventory to other locations, using this automatically invoice are prepared.
• Customized the sales invoice screen for the purpose of custom tax calculation.

Confidential

Responsibilities:

• Installation of application Ebizframe and database Oracle 8i at client site,
• User .
• Interaction with client new requirement and customization.
• Developed new forms in Sales, Purchase and Inventory as per the requirement.
• Developed custom solution for export cycle containing Export sales order, Performa invoice, stuffing details, Commercial invoice, bill of exchange.
• Preparation of technical design document, unit test case and testing.

Confidential

Responsibilities:

• Developed Schedule 6 - Screen for report output layout
• Bank reconciliation - Screen for bank Statement.
• Repots developed using reports6i
• TDS Contractors - Form 16A
• TDS returns Form26A/C/J/K
• Debit note/credit Note to supplier and customer.
• PDC voucher
• Bank reconciliation related reports
• Trial balance/ sub ledger trial balance
• Prepare unit test case and testing.
• Performance tuning of consolidated reports using temporary table and pls/sql.