SUMMARY

• 7+ years of professional experience in Information Technology in Oracle Applications R12,11i(11.0.3,11.5.X) with expertise in GL,AP,AR,FA and CM modules
• Extensively involved Oracle Applications 11i implementation, enhancement, Support& customization in various modules including General Ledger (GL),Accounts Receivables (AR), Accounts Payables (AP), and Purchasing (PO),Fixed Assets and Cash Management(CE).
• Successfully implemented full life cycle projects, hands on process and design implementation experience in Order - to-Cash (O2C) Process, and Procure-to-Pay (P2P) Process.
• Exposure in General Ledger(GL), Purchasing (PO), Inventory(INV), Order Management (OM)
• Involved in requirements gathering, prepared As-Is, To-Be, GAP analysis, configuration, Functional design documents and Conducted CRP, SIT, UAT sessions and user .
• Hands on experience with Oracle R12 and Oracle 11i Implementation
• Experienced on RICE, SQL PLUS, Toad, Discoverer Reports.
• Has worked on conversions, interfaces, data migration, and RICE customizations.
• Experience in SYSADMIN tasks in Oracle applications with mapping application user setup’s, defining responsibilities etc and providing support to end-users for any sysadmin issues.
• Experience on importing data from Sub-Ledger Modules( AR, & AP).
• Configured DFF’s for PO Distribution, Invoice Distribution to enter AR Number (EGS recognizes Assets based on AR number) and bring it over to Asset Key Flexfiled using a Custom Concurrent Program.
• Configured Multi-Org, MRC, Intra-Company andInter-Company setups for USA, Mexico, Canada and France locations. Created Custom Profile Options.
• Worked on Customization and Development Reports under Oracle Apps.
• Collaborated closely with customer teams to accelerate the speed of knowledge transfer and drive the highest value from the successful deployment of the Oracle E-Business Suite.
• Configuring the Oracle iSetup, which can do the setups automatically in client’s targeted instance.
• Designed, developed a Custom Trigger to update theAccounts for France Employee type Suppliers
• Preparing TE040 Documents for GL, AP, FA and E-Business Tax which are helpful to test the application functions in R12.Testing of various test scenarios of Requisition to Purchase Order cycle in Oracle Purchasing.
• Captured high level additional requirements Future Business Model (BP 080) for GL, AP and FA modules, and done the Impact analysis in current business process due upgrade changes/enhancements

TECHNICAL SKILLS

ERP: Oracle Applications 11i (11.5.10/11.5.9/11.5.6 ), 11.0.3 and R12

Modules: Inventory, Purchasing, Order Management, Fixed Assets, Cash Management, Account Receivables, Account Payables, General Ledger.

Self Service Apps iProcurement, iReceivables, iAssets and iExpenses.:

Methodology: Oracle E-Business Suite Application Implementation Methodology (AIM)

Operating Systems: WINDOWS XP/2000/NT/9x, UNIX, Windows 2003 server.

Interface Tools: Forms 6i/4.5, Reports 6i/4, Data Loader, MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

Financial Functional Consultant

Responsibilities:

• Involved in Support production environments of PTP and RTR .
• Supported production environments users on a daily basis by responding to emergency requests
• Developed test plans and scripts and conducted testing for quality assurance.
• Performed set up for GL, AP, AR,CM,EBTax,I-procurement, modules for R12.
• Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
• Mapping the Client requirements with Oracle standard functionality and finding the gaps and then prepared the setup Documents (BR 100) and delivered the solutions in terms of Customizations, workarounds, reengineering and form personalization.
• Work with the developers to develop conversions, interfaces, reports (MD50’s).
• Corrected wrong currency problem in AR Invoice, Debit Memo & Credit Memo.
• Perform the month end scheduled jobs and created new approvals
• Defined Payment Options, Payment terms, Distribution Set, Payment format, Internal Banks in AP.
• Corrected customer Profile class setup & statement to avoid multilingual statement printing. Wherever required.
• Corrected the revaluation of cash/clearing accounts on PL and SL.
• Configured the setups for prepayment to employees and defined employee expense report.
• Created new Web ADI Templates to load Journal Entries and Assets.
• Created new AGIS relationships.

Environment: Oracle Application (R12.1.1), GL, AP, AR, CM, PO, INV, OM, iProcurement, iExpenses, PA, Reports Manager, Alerts, Applications Developer,SLA,E-Business-Tax

Confidential, IL

Financial Functional Consultant

Responsibilities:

• Involved in Implementation and testing of Oracle FinancialR12 GL, AP,AR and CM modules
• Involved in requirement gathering and analysis and design of the application.
• Developed test plans and scripts and conducted testing for quality assurance.
• Performed set up for GL, AP, AR modules for R12.
• Principal lead for General Ledger Multi-org on an R12 implementation through initial Conference room pilot (CRP).
• Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
• Managed the Oracle Advanced Collections implementation project, working closely with the business to identify requirements, gaps and potential performance issues.
• Mapping the Client requirements with Oracle standard functionality and finding the gaps and then prepared the setup Documents (BR 100) and delivered the solutions in terms of Customizations, workarounds, reengineering and form personalization.
• Prepared a detailed flowchart explaining the business flow for the legacy system and Oracle Accounts Receivables. Developed the functional specifications for moving a custom collections system developed on Oracle Financials to Oracle Advanced Collections
• Cash Management was implemented for 255 Bank Accounts across various countries and for various banks. Mapping the Bank statements in multiple BAI formats with Cash Management Modules
• Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
• Configured DFF’s for PO Distribution, Invoice Distribution to enter AR Number (EGS recognizes Assets based on AR number) and bring it over to Asset Key Flexfiled using a Custom Concurrent Program.
• Work with the developers to develop conversions, interfaces, reports (MD50’s).
• Designed Auto Invoice Import process and documented the import process in AR.
• Responsible for configuring GL, AP, FA and E-Business Tax modules. Created Secondary Ledgers to support the Local Government Accounting standards for France, Mexico and Canada.
• Wrote functional specification for reporting requirements in AP
• Corrected wrong currency problem in AR Invoice, Debit Memo & Credit Memo.
• Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
• Defined Payment Options, Payment terms, Distribution Set, Payment format, Internal Banks in AP.
• Corrected customer Profile class setup & statement to avoid multilingual statement printing. Wherever required.
• Configured the setups for prepayment to employees and defined employee expense report.
• Developed FSG Reports in GL like (Income statement, Dept Expenses, Inter Company Summary).
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
• Created responsibilities assigned to users and set profile option.
• Created new Web ADI Templates to load Journal Entries and Assets.
• Full CRP1, CRP2, UAT1 and UAT2 testing cycles, with issue trackers and SME’s sign of.
• Supported production environments and users on a daily basis by responding to emergency requests
• Provided, Conducted Practice & Additional Business Requirements sessions.
• Design test scripts of all sub-process identified in assessment phase. Unit testing execution for each business process.

Environment: Oracle Application (R12), GL, AP, AR, CM, PO, INV, OM, iProcurement, iExpenses, PA, Reports Manager, Alerts, Applications Developer,SLA,E-Business-Tax

Confidential, sandeigo, CA

Oracle Apps System Analyst

Responsibilities:

• Preparing Central GL setup document applicable for more than 120 legal entities / sites and configuring of same in the new Oracle instance
• Preparing GL setup documents for assigned sites and do setups in the instance using Data loader & Oracle Web ADI tools
• Defining PREPRO Mapping logic & Mapping values set-ups for Oracle Accounting Flex field structure vis-à-vis Legacy systems.
• GL: Setting up the Journal Batches, Creating Account FlexFields.,Web ADI, Creating COA( Chart Of Accounts)
• Worked on with iexpenses and the configurations
• Involved in designing the functional specifications
• Developed of functional specifications for customer import program which runs daily to add the new customers from legacy systems and to update the customer profile classes / collectors, etc
• Resolving the issues (SR) raised during the Project implementation life cycle.
• Interacting with different teams / Users for resolving issues.
• Attending and conducting Oracle Apps. Knowledge sharing sessions in Financials modules AP, AR, GL,FA & CM
• Involved in post production Support for GL,AP,FA and AR Module.
• Preparation of materials(SOP’s)
• Provided End user sessions.
• Identifying, Reproducing & Analyzing Product Defects based on problem reported by customer. Logging a Bug with appropriate details with Development team & helping them in analyzing these issues.
• Internal Patch Set Testing Initiatives before releasing Patch sets through Metalink.
• Delivering Product for New Team members.
• Mentoring New Team member about Support Process & overall Service request resolution

Environment: Oracle Application (R12), GL, AP, AR, FA and CMiProcurement, iExpenses,Projects Costing and billing, Alerts

Confidential, Trumbull, CT

Oracle Financials Consultant

Responsibilities:

• Involved in data migration, form’s conversion, and report conversion.
• Created many custom reports, custom forms as the part of the re-engineering project.
• Used standard user exits and Application Object Library routines to write the reports and forms.
• Migrated the data from the Oracle Payables, Oracle General Ledger, includes the information about the vendors, invoices, payments, and the balances from the Oracle General Ledger.
• Added cross validation rules to the new accounting structure.
• Implemented Advance Recovery Project with minimum customizations to Oracle Payables with the discount accounting.
• Incorporated discount accounting as part of the Advance recovery process.
• This project is to collect the advances paid to the vendors depends on the date ranges andThe percentages.
• Implemented Inter Company accounting, which balances at multiple segments.
• The standard Intercompany program generates the transactions only to specific accounts(Balance at only one segment). The new process creates the transaction which balances atTwo segments.
• Implemented interest calculation project for the delayed Claims. This project calculatesThe interest on the delayed claims based on the Complex business rules including charity Amounts and the percentage of interest depending on the legal entity and the date ranges.

Confidential

Functional Consultant

Responsibilities:

• Requirements gathering
• Study of the current Business Process, Suggestion of future Processes and GAP Analysis using AIM documents
• Preparation of BR100, Common Set-ups doc, SysAdmin Set-ups documents
• System configurations and Set-ups configuration in the new environment
• Resolving Client/User issues during Testing Phase
• Preparation & running of Test scripts
• Interaction with Client / Users
• Preparation of Reports
• Validation of Data Migration and data loading
• Preparation of materials
• End user

Environment: Oracle Application (Ref 11.5.10), GL, AP & FA

Confidential

Oracle Developer

Environment: Oracle Application (Ref 11.5.10), GL, AP, CM&AR.

Responsibilities:

• Working out Oracle solution in relation to specific business requirements
• Preparation and Implementation of Oracle AP set-ups
• Carrying out functional sanity checks
• Preparing test scripts, running test cases validating set-ups
• Interacting with Users explaining the results of test cases / resolving any queries related to same, etc.
• Preparation of materials
• End user