Oracle Developer
Resume:
Majda
**********@*****.***
Professional Summary:
Over 18 years of total experience, out of which 6 years in Oracle ERP
Applications mostly in Finance modules.
Very strong in Oracle Financial and Distributions modules, having excellent
functional experience in analyzing Business requirements, gathering
business requirements, providing functional design solutions, procedures
and processes, module setups, writing function design specifications using
AIM methodology BR100 and TE040 for testing, Production support and user
training.
ERP Expertise
Possess strong knowledge in - General Ledger (GL), Account Payables (AP),
Accounts Receivable (AR), iExpense, Purchasing (PO), Cash Management (CM)
and conversant with other modules like Inventory, Payment, Order
Management and Application Object Library. Over one year of experience in
R12 basic setups in AP, AR and GL. Well conversant with concepts like Multi-
Org, COA and MOAC. Basic knowledge of Hyperion System 9.3.3.
Technical Skills
. Oracle EBS : R12, 11i.5.10.2.
. EBS Functional Modules : GL, AP, PO, AR, FA, CM and AOL.
Payment, iExpenses.
. Oracle tools : Reports/Forms Builder
6i, BI/XML Publisher 5.6.3, FSG,
Web ADI, and
Discoverer.
. Databases : Oracle database 8i/9i, MS Access.
. Tools/Utilities : TOAD.
. Languages : SQL, PL/SQL, SQL*LOADER.
. Operating Systems : Windows NT/2k, UNIX.
. Other tools : MS Excel, MS Word,
Visio
Experience Details
May/09-Sep/2010 Oracle Functional Consultant (SMRUSA, Chicago IL)
Environment: Oracle EBS-R12 includes GL, AP, PO, AR and CM.
. 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.
. Extensive involved in Post-Production support and assisted day to day
business activities.
Dec/07- Feb/09 Oracle Techno-Functional (Herbalife Int., Torrance CA).
Environment: Oracle EBS- 11i.5.10.2 includes GL, AP, PO, OM, AR, FA, and
CM.
. Responsible for gathering requirements from Purchasing/ Payables
Unit for designing the custom reports and preparing the functional
documents (MD 50).
Interacted with the technical team to help them resolve the issues
being faced.
Involved in testing the reports and provided the sign off to move
from one instance to another.
. Customizing/Formatting FSG Reports and Discoverer.
. Run Mass Addition program to add assets to FA from AP and follow up
the adjustments/transfers
depreciation and ultimately Retirements.
. In AR, defined System Options Defaults, Customer, Invoice
attributes - Payment Terms, Transaction Types, Accounting Rules,
Memo Items, recurring invoices, Auto Accounting, Invoice Sources,
Receipt Classes and Adjustment Approval Limits.
. Created Month End close documentation for GL and AP.
. Log, view, access, monitor, follow-up and close Technical
Assistance Requests (TARs) online -Oracle MetaLink.
. Conducted user training for O2C and P2P cycles in test instance.
. Involved in Post production support and effectively solved
production issues.
Nov/06-Sep /07 Techno-Functional Consultants (Pressure Grout Company,
Hayward CA)
Environment: Oracle EBS-11i.5.10.2 includes GL, OM, AR, Advance Pricing,
INV, PO, AP, iExpense.
. Initiated and coordinated in O2C cycle implementation.
. Conducted Business Owners meeting to finalize functional setups
that are required for OM implementation. Setups are such as Order
types, drop-ship type, Payment Terms (with various discount
structure), Price Lists (Intercompany, Corporate level and customer
based), Pricing Formulas, Qualifiers and modifiers, Customers,
Customer Profile classes.
. Coordinated with in-house BAs and Order Admin leads to implement
various business scenarios such as withholding Invoice creation for
partial shipments as per customer demand, to bring in customer PO
line info into OM module, to match Invoice details with customer PO
line info, etc.
. Finalized functional setups in Payables such as Bank Accounts,
Financial options, Payables Options. And also involved in creation
of invoice batches and payment batches.
. Customized Check printing program as required.
. Setup of iExpenses like Expense Report Templates, Signing Limits,
Expense Report Options, Defining Policy including Schedules,
Expense Fields, Exchange Rates, Defining Locations.
. Conducted Business Owners meeting to finalize functional setups
that are required for AR. Setups are such as Transaction Types
(Invoice Types), Auto Accounting Setups, and Configured Invoice
Types with Order types, AR Batch sources, Remit To addresses,
Receipt Classes and Payment Methods.
Feb /05-Aug /06 Techno- Functional Consultant (Ablesoft Inc., Santa Clara
CA)
Environment: Oracle EBS-11i.5.10.2 includes OM, AR, TCA, CM, PO, AP, GL and
INV.
. Reviewed the process flow in OM module with Business users and
developed GAP analysis report.
. Interacted with users in developing design document for various
business scenarios such as deferring invoice creation at multiple
stages of the O2C cycle.
. Created multiple Order types to address existing business scenarios
such as Order type of product based to identify pricing and payment
term structures.
. Defined Auto Accounting, Invoice and accounting rules to recognize
revenue in AR Module.
. Defined Receipt Classes and Payment methods in AR Module.
. Involved in importing bank statements into Cash Management.
. Setups in Payables and iExpenses such as Financial and Payable
Options, Bank Accounts, Expense Report Templates, Signing Limits
. Worked on Journals Importing Interface, data conversions from the
legacy system, FSG
. Reports including the trial balance report.
. Managed TARs with Oracle Support to determine the bugs incurred.
Mar/04-Jan/05 Techno-Functional Consultant (Merix Forest Grove OR)
Environment: Oracle EBS-11.5.9 includes OM, AR, PO and AP.
. Involved in Functional setup of Order Entry, Oracle Receivables.
. Imported the customer, Invoices and Receipts into the AR from
legacy systems.
. Assigned in a project to implement Oracle e-commerce Gateway to
maintain transaction with all their customers using EDI files
Conducted business meetings to finalize Functional Setups that are
required for e-commerce Gateway (EDI), OM and AR modules.
. Performed functional setups such as Trading Partner, Mapping Interface
file definition to accept both inbound and outbound EDI transactions,
custom order type, price lists pricing formula, customer address
mapped for EDI location.
. Prepared interface file map spreadsheet for 850 inbound.
. Developed Unix Shell Script to move data flat file from server to Unix
Server and rename the flat file with timestamp.
. Designed and implemented validation (PL/SQL code) strategy to check
for record accuracy of the data residing in the OM interface tables
before importing into Oracle Apps.
. Extensively involved in functional design of outbound EDI files such
as 810 invoices, 855 PO ACK, 856 ASN.
Sep 1992 to Oct 2003 Senior Oracle Developer (Aradet Dubai)
Environment: (Oracle 8i/9i) PL/SQL Procedures, Functions, Triggers and Data
Base Triggers, Forms and Reports Developer 2000/6i.
. Created custom Finance Management System FMS package using Oracle
8i to create custom table and front user end using Developer6i
Forms & Reports in client/server.
. Designed, implemented and tested security control in various
database levels, application and fine grain access control.
. Participated in FMS data modeling, prototype design, document
preparation; created form templates, object libraries and generic
package/stored procedures for standardization of the FMS
application.
. 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.
. Tuned and optimized new applications utilizing SQL Trace utility
and DBMS package, and enhancing performance through regeneration
and rebuilding of indexes and creation of views.
Educational Qualifications:
Certified Program ICDC (AOS), CA USA
Master's Degree. M.Sc Computer Science. Indiana University USA.
Bachelor's Degree. B.Sc Mathematics, Baghdad University Iraq.
Other Qualifications. 3 months Oracle PL/SQL UK
Contact this candidate