SUMMARY

• Confidential has over 20 years of experience in all phases of design, development, and implementation of Oracle Ebusiness Suite. He has worked for clients within the financials, manufacturing and banking services. His areas of expertise include Oracle Financials, Projects, Order Management and Inventory modules.
• Confidential is adept at facilitating sessions defining user requirements, developing and delivering technical solutions.
• He has in - depth technical skills, has a sound knowledge of the ERD and data/table structures of Oracle Applications, private/public API’s, open interfaces.
• He has been the technical team lead/lead developer in many assignments and has facilitated requirements gathering, data mapping sessions.
• He has very good experience in gap analysis, requirements definition, functional/technical design for extensions/ customizations and conversions.
• His techno-functional experience along with the breadth and depth of his skill set makes him a valuable addition to any project with wide industry experience.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Responsible for designing and developing interface routines from external systems into GL. Developed a custom routine to create journal entries required for dual reporting as per ASCP 605/606. Created custom routine to restate Oracle AR journals using multiple revenue accounts. Design and developed extraction routines to integrate GL with HFM for financial reporting.
• Designed and developed extract/report for Vendor Spend.
• Designed and developed a routine to extract data to interface to RevPro (Revenue Recognization application).
• Design and developed routines to extract data for Suppliers, Customers, Employees, Purchase Orders, Sales Orders, AR Invoices, Cash Receipts, AP Invoices data.

Confidential

Responsibilities:

• Responsible for designing and developing packages and procedures using PL*Sql and SQL. Extensive use of UTL FILE/SQL*Loader utility to upload data. Generate reports/data extracts using UTL FILE utility. Used bulk processing and global temp tables to enhance performance of validation routines.
• Trouble shoot and debugged custom code for importing AR Invoices and RMAs using standard Oracle AutoInvoice program. Designed and developed a custom routine to extract AR Invoices to integrate with 3rd party software to create 810 invoices.
•  Modified custom code for importing inventory adjustments using standard Oracle Material Transaction Interface table and APIs. Developed custom code to extract items and export to 3rd party Order Booking system. Designed and developed custom code to import Inventory Items into Oracle. Developed custom routine to create inter org inventory transfer transactions.
• Modified custom code to import AP Invoices using standard Oracle Interface tables. Assisted in re-designing custom routine to import and export suppliers/vendors using standard Oracle Interface tables and custom staging tables.
• Trouble shoot and debugged TCA APIs used to create Customer records. Enhanced custom code to generate detailed log file of errors and exceptions encountered during execution.
• Responsible for setting up responsibilities, custom profile options, descriptive flex fields, request groups, concurrent programs, job schedules.

Confidential

Responsibilities:

• Responsible for designing and developing conversion and interface routines from external systems into General Ledger. Developed custom routine to create code combinations using standard APIs. Setup of cross validation rules, Auto Accounting Rules.
• Responsible for designing and developing conversion and interface routines for Invoices, Payments and Suppliers.
• Responsible for designing and developing conversion routines for converting Projects. Developed interface routine for Transaction Import from multiple external systems)
• Responsible for designing and developing interface routines for Auto Invoice, Auto Lock Box and Customer Interface.
• Designed and developed interface routine for ongoing maintenance of Employees and Employee Assignments using standard HR APIs.

Confidential

Responsibilities:

• Designed and developed a custom solution to capture average daily balances for confidential journal entries.
• Developed interface routines to upload Period and Daily rates. Designed and developed a custom routine to generate elimination entries for daily posting.

Confidential

Responsibilities:

• Responsible to gather requirements and do FIT/GAP analysis. Developed functional and technical design documents for several interfaces and conversion routines General Ledger (Journal Import, Daily Rates). Developed a custom routine to invoke revaluation process for multiple currencies using different period rates for specific account ranges.
• Responsible for designing and developing conversion and interface routines for Invoices, Payments and Suppliers, Supplier Banks and Bank Accounts, Expense Reports. Designing and developed a custom routine to format, encrypt and FTP check file.
• Responsible for designing and developing an interface routine to import Bank Statements for reconciliation
• Responsible to review/supervise work done by technical developers. Implemented coding standards and ensured that all codes were developed with detailed description/comments within the code as well as design documents.

Confidential

Responsibilities:

• Developed interface routines to import sales orders from multiple systems. Designed custom routines to integrate with external WMS system. Designed custom routine using standard APIs to captures RMAs.
• Developed an interface routine for capturing purchase orders from external systems. Customized PO print program as per customer specification.
• Design and developed a custom report for Customer invoice printing. Converted customer data from a legacy system using standard Oracle APIs. Developed additional code to synchronize with feeder system for any updates on customer data.
• Technical lead, performed customization impact analysis. Designed and developed scripts to purge data from Oracle Financials Instance. Review and signoff on documentation and code developed by the technical team.

Confidential

Responsibilities:

• Modified custom GL Journal Import code to enhance performance from 16 hours to 45 minutes.
• Developed wrapper code to validate code combinations originating from external systems.

TECHNICAL SKILLS

• Oracle 12.1.2, 11i, 10.7
• General Ledger
• Payables
• Receivables
• Purchasing
• AOL
• Cash Management
• Projects
• Order Management
• Inventory
• Databases
• Oracle 7 and onwards
• Hardware & Operating Systems
• Windows NT
• Windows 2000
• Solaris
• AIX
• Red Hat Linux
• UNIX
• SQL*Plus
• PL/SQL
• XML Publisher
• Oracle Reports
• SQL*Loader
• FTP
• TOAD