Oracle Functinal

Executive Summary

**+ years experience with Oracle.

* ***** ********** **** ****** Applications - Performing functional and technical work with main modules such as GL, AR, AP, FA, CM, PO, OM/DM and Advanced Collections.

Functional responsibilities: business process analysis, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, interfacing with users, training end users and production support.

Technical responsibilities: identifying technical gaps, estimating work, architecting system interactions, designing custom solutions, programming, scheduling, producing documentation and providing production support.

Technical Skills

• ERP : Oracle Applications 11i.5.10.2 and R12.

• ERP Functional Modules : GL, AR, AP, FA, CM, PO, OM, iExpense & AOL.

•

• Oracle tools : Oracle Developer Reports/Forms 6i, BI/XML Publisher 5.6.3, Web ADI, FSG and Discoverer.

• Databases : Oracle database 8i/9i, MS Access

• Tools/Utilities : TOAD

• Support Applications : BMC.

• Languages : SQL, PL/SQL, SQL*LOADER.

• Operating Systems : Windows NT/2k, UNIX

• Other tools : MS Excel, MS Word, Visio

Experience Details:

May 09- Sep 10 Oracle Functional Conslt. Al-Taqnyah Business Solutions - Dubai, UAE

Environment: Oracle Applications R12.1.2 GL, AR, AP, CM, FA and SLA

• Configured AP setups such as financial/payables options, payment terms, suppliers, suppliers site, bank accounts for the supplier, invoice holds and releases etc.

• Validated Setup steps for Purchasing like Financial, Purchasing and Receiving Option, Definition of approval group/ assignments, setting up the approval hierarchy etc.

• Created payment template through payment manager.

• Configured AR System options, Transaction types, Payment terms, Auto Accounting setups as per Business need. Conducted Business Owners meeting to finalize functional setups involved in AR Module.

• Involved with GL workshop to analyze, define and implement the Multi-Org and COA structure.

• Defined Auto Accounting rules and involved in import of invoices into AR using Auto Invoice.

• Defined transaction types and sources for Receivables module

• Implemented Cash Management Module – Defined setups such as System Parameters, Bank Account, Bank Statement Interface Configuration and Auto-Reconciliation.

• Involved with FA setup like KFF, Categories, and Asset Books.

• Extensive involved in Post-Production support and assisted day to day business activities.

Dec ’07 – Feb 09 Senior Oracle Developer Herbalife Inc. Torrance CA

Environment: Oracle Applications 11.5.10.2 OM, GL, AR, PO, AP, AOL, PL/SQL, TOAD9, Forms6i, Report 6i, SQL*LOADER, BI/XML Publisher Reports.

• Developed custom package “HL Global GL Listing Wrapper” to generate custom GL report in Excel/PDF format using Oracle Reports builder6i and XML Publisher.

• Created advanced collections views to limit the scope of a scoring engine and improve system performance.

• Developed PL/SQL Script to validate order records in OM Interface tables and run Order import program.

• Imported the customer, Invoices and Receipts into the AR from legacy systems

• Defined concurrent programs, concurrent program executable, concurrent programs to associated request groups and Request sets.

• Personalized Receive Transactions form to print “HL Print Manual Invoice”.

• Developed a package on generating international XML Invoice (multi-lnguage) and send it to the customer.

• Day to day troubleshooting using support applications to process helpdesk tickets from users to production instance such as SupportMagic, CMR and BMC .

• Raise several Tars for unresolved issues.

Nov ’06 – Sep ’07 Data Analyst Pressure Grout Company, Hayward CA.

Environment: Oracle Applications 11.5.10.2 Order Management, Inventory, Accounts receivable, AOL, PL/SQL, TOAD9, Forms6i, Report 6i, SQL*LOADER.

• Project Description: Using Autolock Box interfaces to import data from old AR system.

• Performed functional setups such as Customer, Banks, Receipts Classes, Payment Methods, and Lockbox.

• Developed PL/SQL procedure to validate and adjust data format.

• Prepared script for Sqlloader control file.

• Performed AutoLock Box processes and designed the Transmission Format.

• Debugged the issues related to AutoLock Box.

• Customized through Custom.pll.in Order Organizer (OEXOEORD), Sales Order Screen and E-Business center Zoom button to pop up a form and get additional data for End User and pass the End_Order_no as a parameter.

• Customized Invoice print batch of invoices, Receivables Aging report.

• Worked on Receivable modules on ACH setups, Receipt Classes, Customer and Bank setups.

• Worked on custom Pack Slip report to resolve issues of duplicate records.

• Customized the Sales Acknowledgment report, which was not displaying the correct order amount.

• Developed control file script for SQL*Loader script to import Order records from legacy system.

• Modified Defaulting Rules as per business requirement

• Created a new custom Discoverer report to display the Sales order information.

• Imported AR Invoices from the Legacy System using SQL*Loader and developed PL/SQL script to validate AR Interface table records.

• Conducted business owner meetings to finalize the required information from the old data and the setups needed for Accounts Receivable.

Sep’92 – Oct ’06 Senior Oracle Developer. Aradet Dubai

Environment: (Oracle 8i/9i) PL/SQL Procedures, Functions, Triggers and Data Base Triggers, Forms 2000 and Reports 2000.

• Created new Finance Management System FMS package using Developer6i Form & Report in client/server on Oracle 8i/9i databases. Designed, implemented and tested security control in various database levels, application and fine grain access control.

• Participated FMS data modeling, prototype design, document preparation; created form templates, object libraries and generic package/stored procedures for standardization of the FMS application.

• Developed stored procedure based forms to integrate with legacy system.

• Designed, created or modified payroll, benefit and human resource applications using SQL-PL/SQL languages Oracle database and Developer.

• Modified and trouble-shooting inventory and process control system with Oracle Developer 6i.

• Installed Oracle 9i and configured Developer on client stations.

• Participated architecture design and migration of enterprise wide multi-tier system with different version of Oracle server back-end.

• Created Oracle databases for development on PC NT-4, W2K based machines and configured instance parameters, storage layouts, rollback segments, database links and Net8 architecture with Oracle Enterprise Manager OEM Importing and mapping data from current systems including EDI legacy system with various tools such as SQL Loader and Import/Export utilities.

• Tuned and optimized current and new applications utilizing SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuilding of indexes and creation of views.

• Assisted Senior DBA with configuring Oracle Name server, load balance and fine-tuning production database parameters and providing assistance for database related errors from individual Clients. Also cooperating with DBAs and production personnel for annual database purge and rollover.

• Created and implemented ad hoc reports using SQL for various users in different environments.

Educational Qualifications:

Master’s Degree. M.Sc Computer Science. Indiana University USA.

Contact this candidate