SUMMARY

• Over 7 years of professional experience and IT experience in ERP Implementation, Customization and Production Support of Oracle E - business Suite Financial Modules which include General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA) and Cash Management (CE).
• Extensive work experience on the Full Life Cycle Implementation of Procure to Pay cycle (P2P).
• Hands on experience with Oracle R12 and Oracle 11i Implementation.
• Hands-on experience in General Ledger(GL), Account Payables(AP), and Account Receivables(AR), iProcurement, Purchasing, SLA (Sub Ledger Accounting) and Cash management modules.
• Prepared business process flow documents for the key processes in General Ledger (GL) Accounts Payable (AP), Accounts Receivables (AR) and Fixed Assets (FA).
• Providing and related support to users, earning a solid reputation for productivity, complex problem resolution and professionalism.
• Progressive end-user experience providing greater understanding of user needs/requirements during implementation or upgrade Process.
• Experience in using Oracle AIM (V.3.0) of project implementation methodologies particularly Gather Business Requirements (BR.100), Functional Documents (MD.050) deliverables and Test Cases (TE.040) for GL, AP,FA and AR,CE modules.
• Provided consulting services delivering comprehensive set of value-added services for developing and implementing Oracle E-Business Applications.
• Experience in Oracle Forms, Oracle Reports, XML Publisher Reports.
• Possess technical skills in Oracle Application Interfaces, System Administrator.
• Experience includes functional, implementations/upgrades, and projects with exposure to technical aspects.
• Experienced on Multi Org Access Control (MOAC) .
• Experience in Onsite-Offshore delivery model in Production Support, Enhancements and Development environment.
• Good Knowledge of Inventory, Purchasing, Order Management, Bills of Material and Work in Process Oracle shipping execution and advanced pricing.
• Experience in all phases of Full Life-Cycle Oracle E-Business Suite Financials implementation i.e. Requirements Definition, GAP Analysis, Process Modeling and implementation.
• Exposure in Oracle R12 Financial Modules and SLA, MOAC, EB TAX.
• Experienced on EBTAX configuration (Regime to Rate flow ) like Tax regimes, Tax Jurisdiction, Tax Recovery Rates, Tax Rates and Tax Rules.
• Worked on expanding its ‘Controls and Defaults’ Region and Configure like Allow Tax Recovery, Allow Tax Exemptions and Allow Tax Rounding Override and so on…
• Worked on E-Business Tax Profiles Options.
• Defining System Profile Values.
• Specifying System Profile Values Options at various levels like Site level, Application level and User level.
• Experienced in implementing Multiple Sob’s / Ledgers, Multiple Reporting Currencies and Multi Org setups.
• Participated with Business / Functional users in set-ups.
• Team player and self-starter with good communication skills and ability to work independently and as part of a team.
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation, Resource Planning, Project Tracking.

TECHNICAL SKILLS

ERP & Applications: Oracle Applications 11i & R12 (GL, AP, AR, FA, PO, OM,INV,Cash Management, i-Expense, i-Procurement and Alerts).

Operating systems: UNIX, Windows NT / Windows 2000 / Windows XP/Vista

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

Language: SQL, PL/SQL

Job Functions: Design, Coding, Testing, Documentation.

PROFESSIONAL EXPERIENCE

Confidential, Southfield MI

Sr. Oracle Consultant

Responsibilities:

• Principal lead for General Ledger Multi-org on an R12 implementation through initial Conference room pilot. Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
• Assisted/reviewed Payables and Cash Management.
• Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
• Setup instance for new acquisitions.
• Developed the new chart of accounts.
• Provide post upgrade support.
• Work with the developers to develop conversions, interfaces, reports (MD50’s).
• Involved in the Functional implementation of Oracle Applications Financial including GL, AP, AR and CM modules.
• Involved in Functional analysis, understood limitations of existing database (data tables) and proposed solution for implementation Oracle Applications modules.
• Involved in requirement gathering and analysis and design of the application.
• Gap Analysis & Mapping the business process with the standard functionality of Oracle Application.
• Documented custom processes by using AIM Methodologies.
• Designed Auto Invoice Import process and documented the import process in AR.
• Corrected wrong currency problem in AR Invoice, Dr Memo & Cr. Memo.
• Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
• Involved in Setting Up Oracle Advanced Collections and also involved in preparing Implementation Check list.
• Performed implementation tasks like set up scoring, Create scoring components, Creating new score engines.
• Entering parameters for Functional Variables, Set up Delinquency Status score ranges.
• Set up Dunning plan aging bucket and setting up Collections Dunning level and creating Dunning plans.
• Creating strategy level and its template and updating the template.
• Set up Oracle Advanced Collections Profile Options.
• Wrote functional specification for reporting requirements in AP.
• Developed month end procedures under changed environment.
• Designed organization structure, territory / location flex field structure.
• Defined Customers, Payment terms, Customer profiles, Statement cycle, Dunning Letters, Banks, lock box etc.
• Created Responsibility and Assigning to users, Set the Profile Options.
• Performed system integration testing and user acceptance testing.

Environment: Oracle Applications (R 12) GL, AP, AR, FA and CE.

Confidential, Charlotte, NC

Oracle Apps Functional Consultant

Responsibilities:

• Prepared documentation like Business requirements, Functional and Technical specifications, test cases, and data flow mapping.
• Defined value sets, profile options, executables & concurrent programs.
• Developed interfaces to load purchase orders and receipts using Purchasing Documents Open Interface and Receiving Open Interface.
• Involved in implementation of Oracle 11i specifically GL, AP and AR.
• Set up the complete Procure to Pay business flow starting from requisitions creation in iProcurement, using Auto create functionality to create purchase order or Sourcing Event, visibility of PO in iSupplier portal, ASN creation in iSupplier portal, Receiving in iProcurement and payment in AP. Most of the items were set for Auto Sourcing.
• Responsible for Purchase Order and Item Conversions.
• Auto creating Purchase Orders once the Requisitions are approved set ups were done using PO Create Workflow document type.
• Worked with the functional department to design and implement new business processes around requirements.
• Participated in providing Procure-to-Pay (P2P) life cycle support.
• Setup and Configured GL, AP, CM, ADI, version R12.
• Implemented Oracle Cash Management for bank reconciliation
• Involved in processing a credit card payment, bank EFT payment and collection activities.
• Involved in Invoice letter template and various dunning letters.
• Participated in setting up of MOAC for managing multi-org setups.
• Defined Sub Ledger Accounting Methods.
• Creating a New Expense Report, Itemizing an Expense Line, Withdrawals, Updating an Existing Report
• Delete an expense report.
• View the Approval Status of an existing Expense Report
• Responsible for internal travel and expense reports.
• Defined currency translation, conversion, revaluation and set the profile options for GL.
• Defined GL budgets and budget organization.
• Defined the approval limit for new employees.
• Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.
• Setting up FSG reports and custom views.
• Participated in interacting with all concerned end users to achieve proper guidance to design customized forms, reports and to perform interfacing.
• Provided operational to staff and prepare material for major oracle processes of GL, PO, AP, CM and AR.

Environment: Oracle Application (R 12) GL, AP, AR, FA and CM.

Confidential

Oracle Functional Consultant

Responsibilities:

• Involved in implementation and testing of Oracle Applications Financial 11i AR and GL modules
• Defined currency translation, conversion, revaluation and set the profile options for GL.
• Defined GL budgets and budget organization.
• Defined the approval limit for new employees.
• Modified PO requisition workflow, AR notification workflow as per business requirement.
• Involved in requirement gathering and analysis and design of the application.
• Worked with the client team to understand the current Business Process.
• Developed test plans and scripts and conducted testing for quality assurance.
• Setting up of suppliers and supplier sites by defining payment terms, distribution sets and tolerances.
• Developed the customer invoice, statements and dunning letters.
• Supported and modified existing purchasing and receiving interfaces in PO and Auto Invoice in AR.
• Performed set up GL, AP, AR modules for 11i.
• Designed Auto Invoice Import process and documented the import process in AR.
• Corrected wrong currency problem in AR Invoice, Dr Memo & Cr. Memo.
• Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
• Corrected customer Profile class setup & statement to avoid multilingual statement printing.
• Configured and scheduled Standard Request Submission for standard APIs 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 and maintained User Menu objects.
• Created responsibilities assigned to users and set profile option.

Environment: Oracle Application (Ref 11.5.10), AR and GL.

Confidential, Scottsdale, AZ

Financial Functional Analyst

Responsibilities:

• Preparing Central GL setup document applicable for more TEMPthan 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 set up new account combinations and cost centers in the Oracle application.
• Developed new chart of accounts.
• Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency. structure vis-à-vis Legacy systems
• Interacting with different teams / Users for resolving issues
• Attending and conducting Oracle Apps. Knowledge sharing sessions in Financials modules -- AP, AR, FA & CM
• Providing post production Support for GL module
• Preparation of materials
• Resolved functional queries of client.
• End user .

Environment: Oracle Applications (Ref 11.5.10), AP, AR, FA and CM.

Confidential

Functional Consultant

Responsibilities:

• Designing and implementing various tests, debugging the software and providing post-live support.
• Managing a team for functional implementation of Oracle Financials GL, AP and AR modules across the organization.
• Configuring the modules, designing reports and add-ons and coordinating with the technical team to monitor development and implementation progress.
• Studying the requirements, performing risk analysis and mapping the business processes.
• Defining best practices in controlling and auditing the implementation and production usage of Oracle Applications.
• Facilitating end-user and developing the various user manuals.
• Created general settings and completed specific configuration related to Company Code, Bank transaction codes, Bank ‘N’ Bank accounts and bank reconciliations.
• Matched the AP Invoices (2-way) & (3-way) to the Purchase Order in Payable modules.
• Leading an eight member team, building their skills and facilitating their development.
• Analyzing the gaps and recommending the necessary customizations.
• Monitoring & controlling resources and ensuring completion within budget & schedule.
• Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
• Integrated invoices and payments data from AP/AR to General Ledger.
• Providing production support for approving and correcting Accounting entries from Payables to cover receipt accruals, invoice distributions (expense, inventory and work in process), payables liability & disbursements as well as from Receivables to cover receivables, receipts, and invoice distributions (revenue, unbilled receivables, unearned revenue, tax, and freight).

Environment: Oracle Application (Ref 10.2.0.5), AP, AR.