SUMMARY

• Highly experienced wif 9 years as an Oracle Financial Functional Consultant.
• Experience in R12 and 11i end - to-end full cycle Implementations, Upgrade and Productions support projects.
• Strong experience in General Ledger(GL), Receivables(AR),Payables(AP), Cash Management(CE) and Fixed Assets(FA),Purchasing(PO),me Expense.
• Worked in multiple projects in environment of Multi-Org and Multi-Currency.
• Good Knowledge and experience in Oracle AIM Methodology of implementation and documentation
• Managed CRP Sessions wif users providing training and getting UAT Approvals.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports (RICE)
• Excellent knowledge of Oracle Financial Modules functionalities, P2P, O2C and their interplay wif overall accounting structure
• Expert in Functional Analysis, Requirement Analysis, Process mapping, Functional specification preparation, application configuration, Testing, Data migration and user training. Rich experience in working wif multi location technical resources and offshore team to complete deliverables
• Highly Quality oriented, self driven and motivated for timely target achievement, TEMPEffective oral and written communication skills, presentation skills, strong analytical problem solving capabilities, planning and organizational skills.
• Extensive hands on wif using AIM Methodology including BR100, TE40, BP80, MD50, etc.
• Worked extensively wif development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support).
• Familiar wif system development life cycle (SDLC).

TECHNICAL SKILLS

ERP: Oracle Financials Release 11.5.8, 11.5.9, 11.5.10, R12

Financial Modules: General Ledger, Accounts Receivables, Accounts Payables, Cash Management, Fixed Assets, Purchasing

Business Analysis Tools: MS Visio, MS-Office (Excel/Access/Project/Word/PowerPoint).

Database: Oracle 7.3/8i/9i/10g

Languages: SQL, PL SQL, C, C++, JAVA, Unix shell scripting

Tools: Forms and Reports 2.4, 4.5, 6i and 10g, Toad, SQL*Plus SQL* Loader, FTP, Test Director

Operating systems: DOS, Windows NT/98/95/2000/XP, SUN Solaris, UNIX

Web Technology: HTML, DHTML, XML, XSL, XSLT, VBScript

Java Technology: JSDK, J2EE, Servlets, JSP, Applets, JavaScript, JDBC

PROFESSIONAL EXPERIENCE

Confidential, Hightstown, NJ

Oracle Financials Functional Consultant

Environment: Version 12.1.3 (GL, AP, AR, Procure2Pay, CE)

Responsibilities:

• Team member on a project implementing Oracle Financial Modules like AR, AP, FA, CM, GL in Multi-Org Environment.
• Managed and executed all aspects of as-is analysis, requirements gathering, solution design, testing and UAT cycles, go-live and post go live support.
• Authored all AIM documents for BR100, MD050, TE020 components for Oracle Projects and associated for dis R12 implementation.
• Involved in configuration of CRP1, UAT and Test instance.
• Designed, configured and implemented GL and AR modules.
• Reviewed existing interface designs and made modifications to fit R12 specifications.
• Preparing documents for Setup configuration, Training Manuals for all the modules as per AIM methodologies.
• Perform functional testing and working wif offshore teams to resolve the issues.
• Experience on configuring accounts Receivables, General ledger,and accounts payable modules like Invoice Attributes- Payment Terms, Distribution sets, Pay groups, Special calendars for Recurring Invoices, Entering Vendor and Site Information as per project requirement.
• Updated the setups for the Account Receivables such as collectors, customer profile class, Bank accounts.
• Define Payment Attributes- Payment formats, Bank Accounts and Payment Documents.

Confidential, Greenville, Wisconsin

Oracle Financial Functional Consultant

Environment: Implementation in 11.5.10 (GL, AP, AR)

Responsibilities:

• Set-up of financials options, payables and payables System options in AP
• Set-up of system setup options in AR
• Configured employees and expense report templates and travel policy.
• Worked on R2R/O2C Process mapping in Oracle.
• Involved wif migration of historical data for Accounts Payables and Accounts Receivables.
• Set-up of invoices, debit and credit memos, guarantees, transaction types
• Set-up receipt class, receipt methods, receivable activities
• Created the supplier, supplier sites, banks and bank account
• Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes.
• Participated in CRP and UAT
• Prepared the MD 50 and worked wif technical team for reports development
• Prepared and executed test scripts (TE 40)
• Created user-manuals and trained the end users

Confidential, Atlanta, GA

Oracle Functional Consultant

Environment: Oracle Applications 11i (AP, FA), Oracle 10g (SQL, PL/SQL), TOAD, SQL*PLUS.

Responsibilities:

• Mapped client business requirements to Oracle functionality and identify the gaps based on the study and preparation of the setup documents (BR100) and setup application in development and production environment.
• Preparing RD20 Requirement documents, BR100 Setup documents, BR150 Business Gap documents for AP, FA modules as per Oracle AIM methodology
• Implementation of Oracle Payables which includes AIM methodology which includes Payment Options, Payment terms, Distribution Set, Payment Format, Internal Banks, Recurring Invoices, Prepayments, Expense Report Templates, Interest on Invoice report, Matching options.
• Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depreciation methods, security profile, asset calendar, fiscal year, quick codes and system controls.
• Worked on cash management module that included designing bank statement interface, which needs customization for Receivables-Cash-management integration and Payables-cash management.
• Conducted CRP, UAT sessions for implementations.

Confidential, Kentucky

Oracle Functional Consultant

Environment: Oracle Applications 11.5.10 (AR, AP, GL and OM), Oracle 9i, PL/SQL, SQL*LOADER, Toad, UNIX.

Responsibilities:

• The Cabinet for Health and Family Services ( Confidential ) is home to most of the state’s human services and health care programs. It manages a multitude of health information such as patient data related to Medicaid, public health (including data stored in state labs, local health departments, and so on), mental health (including data from state-run-facilities) and vital statistics (including birth and death records).The project involved in implementation and support of various Oracle Financials Modules.
• Mapped the future requirements into Oracle Receivables and identified the Gaps and analyzed the gaps and Offered Solutions
• Setup the system to meet the desired business process and requirements based on knowledge about the Oracle Financials applications functionality and oracle Application Implementation methodologies
• Functional design and design review of Oracle Applications data conversions, interfaces, custom reports and custom applications.
• Documented As Is current business process (BP040) and designed To Be process (BP080)
• Designed organization structure, transaction flex field structure (descriptive flex field) and remit to territories and locations in Oracle Receivables.
• Implementation of General Ledger which includes setup of chart of accounts, Mass Allocations, recurring Journals, cross validation rule, security rule, set of books, calendar, Document sequencing, key Flex Fields and descriptive Flex Fields.
• Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depreciation methods, security profile, asset calendar, fiscal year, quick codes and system controls.

Confidential, Detroit

Functional Consultant

Environment: Oracle Applications 11.5.9 (GL, AR, PO), Oracle 9i, PL/SQL, SQL*PLUS, SQL*LOADER.

Responsibilities:

• Gatheird business requirements, prepared gap analysis, conducted CRP, SIT, UAT, and executed production deployment of Oracle Finance modules.
• Implementation of Oracle Receivables including setup of transaction types and sources, quick codes, defined grouping and Line ordering rules for Auto invoice, Auto accounting rules, Receipt classes and Source, customer profiles, Payment terms, Internal banks, lockbox, Transmission Formats, Set the system options and defined Tax Codes and set the Profile Options.
• Implementation of General Ledger which includes setup of chart of accounts, Mass Allocations, recurring Journals, cross validation rule, security rule, set of books, calendar, Document sequencing, key Flex Fields and descriptive Flex Fields.
• Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depreciation methods, security profile, asset calendar, fiscal year, quick codes and system controls.
• Conducted orientation training, CRP, UAT and Rollouts strategies for implementations.
• Data conversion fit and gap analysis, interacting wif both management and users to come up wif functional and technical design.
• Interaction wif users and seeking information as required for resolving the issues. Provide resolution for issues and communicating wif business users.
• Unit/Integration test and review of deliverables Ensuring knowledge building sessions at regular intervals for the team members.

Confidential

Oracle Business Analyst

Environment: Oracle Applications 11.5.7(GL, AR, AP, OM, PO, Sys Admin), Oracle 9i (SQL, PL/SQL)

Responsibilities:

• Defined Split payment terms for invoice installments, that has different due dates and assigned multiple discounts to each payments.
• Updated the setups for the Account Receivables such as collectors, customer profile class, Bank accounts.
• Define Invoice Attributes- Payment Terms, Distribution sets, Pay groups, Special calendars for Recurring Invoices, Entering Vendor and Site Information.
• Define Payment Attributes- Payment formats, Bank Accounts and Payment Documents.
• Provided functional support to business users in payables, receivables, purchasing, Assets, Inventory and general ledger modules.
• Involved in functional issues and setup issues as per Companies specific requirement.
• Involved wif CRP1, CRP2 and UAT and conversion
• Involved in preparation of various documents like MD070 and TE020
• Acted as a member to raise tickets on criticality basis for the client issues and gave resolutions to the priority problems.

Confidential

Oracle Business Analyst

Environment: Oracle Applications 11.5.5 (GL, AR, AP, PO, AOL, Sys Admin) SQL*Loader, TOAD.

Responsibilities:

• Defined new responsibilities, menus, hierarchies, security rules, approval groups for Release 11i users. Also included, restricting users access to certain forms and form functions using function Security. Designed and Developed Forms for tracking the account details of the customer.
• Worked on P2P process flows and developed backend queries as per user requests.
• Designed custom reports of Accounts Payables, Purchasing as per client requirements.
• Responsibilities included discussing MD-50 documents and suggesting modifications.
• Day-to-day basis co-ordination wif Functional users and Oracle Metalink for support, maintenance and issue resolution for Base and Localization functionalities.

Confidential

Cashier / Accounts Assistant

Responsibilities:

• Proficient in accounts receivables and payables.
• Reconciled records of bank transactions.
• Performed debit, credit and total accounts on computer spreadsheets.
• Received, recorded, and banked cash, checks and vouchers.