SUMMARY

• Around 9 years of experience in Oracle ERP Implementation, Upgrade, Enhancement, Testing and Support of Oracle Applications using 11i and R12
• Strong functional knowledge on Oracle Financials modules - R12i/11i Versions
• Exposure to all phases of software development life cycle (SDLC).
• Exposure to multinational implementations.
• In-depth experience in Oracle Implementation Methodology (AIM) including solution design, requirements gathering, functional gap analysis, application configuration, module setup, prototype presentation, training guide preparation, testing, training, data migration, conversions, financial data analysis, reporting and production support.
• Excellent Business Analytical skill and Business Process Design capability.
• Expertise in integrating Oracle ERP with multiple Non Oracle ERP applications
• Extensive experience in planning, managing, and coordinating offshore custom development, integration and testing efforts.
• Expertise in Procure to Pay and Order to Cash life cycles
• Expertise in designing and customizing reporting dashboards and financial data analysis tools using OBIEE.
• Excellent communication, interpersonal skills and presentation skills and ability to interact with people at all levels
• Good understanding of Data Conversion and Data Migration process including vast expertise in Global implementations and working with large group of business users and Onsite & Offshore model projects
• Experienced in developing and implementing test strategy for functional testing environments (Unit, Integration & UAT) includes providing functional impact analysis as part of Change Management Process
• Conduct Oracle Web Conference (OWC) with Oracle Technical Support for all high prioritized and time sensitive issues
• Expert in System Administration in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities

TECHNICAL SKILLS

Databases: Oracle Database Version 10g/9i/8i, MS SQL Server 2000

Languages: C,SQL,PL SQL

Oracle Applications: E - Business Suite- 11.0.3/11.5.7/11.5.8/11.5.10/ R12.1.1/R12.1.3

Oracle Apps Modules: GL, AP, AR, FA, CE, iExpense,iProcurment, Ebtax, PO,Inv and OM

Oracle Tools: SQL*Loader, Toad, Developer 6i/2000 (Forms 6i/4.5, 8.0, Application Object Library

Operating Systems: IBM/AIX, HP UNIX, Sun Solaris, Red hat Linux, Windows XP, Windows 2K

Other Tools: PVCS Version Manager, Kintana, Mercury Test Director, Quality Center, MS Word, MS Office, MS Excel, MS Power Point, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

Oracle Financial Functional Consultant

Responsibilities:

• Analyze, design, and configure the Oracle applications and modules including GL, AP, AR, PO, iProcurement, iExpense and OTL modules
• Participated and documented the requirement gathering sessions and analyzed the impact of the changes.
• Fully Involved in Conversions of old legacy system data in Oracle (Open Purchase Orders, Requisition’s, Receipts etc.)
• Individually contributed for entire setups of AP, Image Processing Management (IPM), ODC and OFR, in route approvals for requisition and Invoice Approval for AP Invoices.
• Worked with Third Party vendor and integrate the Invoice processing system with IPM through Oracle and Import the invoice automatically in Oracle
• Close worked with the Business and Catalog vendors to set up the Catalog and Punch-out for multiple vendors
• Developed AR Invoice interface and Customer interface from Sale force system to Oracle
• Fully Involved in Account Receivable on all set up end to end
• Design and Develop the Approval work flow for Requisition, Purchase order and Invoices using AME
• Conversion of data from the external systems to the Oracle EBS.
• Completely customize the iProcurement responsibility and provide Search functionalities for Invoice, Purchase orders and requisitions with drill down functionality to payments, Bank accounts
• Payables: Suppliers conversion, inbound and outbound interfaces, Data conversion of Invoices
• Customize the Contingent Requisition process and integrated with Oracle Time Labor to enter the time sheet and retrieve the invoices in AP
• Customize the account generator to generate the charge account based on employee records automatically
• Purchasing: Setup like Document Types, Line Types, Approval Groups and Assigned Approval Assignments to the Jobs, Purchasing Options, Receiving Options, Financial Options, Lookup Codes, Payment Terms, etc. and successfully created PO’s, Receipts, etc.
• Implemented iSupplier portal Setup includes assign responsibilities to internal user, applying securing attributes to custom responsibilities, enable function security, enable Profile options and manage deliverables functionality
• Implement supplier management includes Flag External Responsibilities, Set Default Application Responsibilities, Set the Web Server URLs, Assign Supplier User Administrator Responsibility implemented Prospective vendor registration and profile management includes Plan and Creating supplier management groups, Create customized responsibilities to buyer and assign customized responsibilities to users, create contact directory for existing supplier, migrate account assignments for supplier bank accounts, Assign Supplier Profile Manager Responsibility to Appropriate Supplier
• Defined the Functional specifications for set ups and reports and transformed the specifications to the Technical Team.
• Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Maintained the regular interaction with the Client, End users, Technical team, participated in the meetings on regular basis and followed up the progress of work.
• Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.
• Tested the interfaces, reports, and processes to ensure that all the functionalities are working correctly.
• Worked with the users and businesspersons in designing and defining the new Reports and Customizing the existing Reports.
• Training to super users and users
• Coordinated Set up activities in UAT and Production Environment of all the modules
• Supported the Team as Subject Matter Specialist in Financial Modules and business Process

Environment: Oracle Applications Oracle Apps R12 (12.1.2) S2S (Source to Settle), Inventory, iExpense and iProcurement

Confidential, Los Angeles, CA

Oracle Financial Functional Analyst

Responsibilities:

• Involved in requirement gathering, analysis and design of the existing and future application for Oracle EBS R12 General Ledger and sub ledger modules.
• Analyze, design, and configure the Oracle applications and modules including GL, AP, AR, PO, iProcurement, iExpense and OTL modules
• Assisted in defining and reviewing the functional requirements for the RICEW objects, for instance, existing interface specifications
• Performed preventive and scheduled maintenance activities pro-actively to ensure high availability.
• Worked with the business architect and other planners to assess current capabilities and identify high-level requirements.
• Configured Oracle EBS 11i General Ledger and sub ledger modules.
• Involved in configuring the GL set of Books for new Companies and performing the unit testing to make sure the customizations works for the new companies.
• Involved in developing a new custom tool for GL Chart of Accounts.
• Worked in Mark view Up gradation and performed the unit testing.
• Worked in PeopleSoft to HR interface for employee load program to resolve the existing issues in both 11i and R12.
• Configured new AP Tax codes and Tax Groups for Global Project
• Involved in developing new custom AP VAT reports for Global Project
• Configured new banks for Canada Organization.
• Involved in developing my MY BILLING for AR for Auto receipt process.
• Involved in generating interfaces to sync the AP suppliers and bank details in both 11i and R12
• Recommend solutions and document findings.
• Client and business interactions.
• Develop new utility application, workflow, interfaces and support tools using SQL and PL/SQL tools.
• System Testing and Regression Testing.
• Production and UAT support.
• Helped the business in the month end closing process.
• Helped the business to close the periods and open the new periods
• Preparation of user manual and user training materials.

Environment: Oracle Applications Oracle Apps R12 (12.1.2) - GL, AP, AR, EBTAX and iExpense (P2P) and iProcurement

Confidential, Atlanta, GA

Oracle Financial Functional Consultant

Responsibilities:

• Analyze design, customize, configure and test implement detailed Oracle applications and modules including AR, AP, GL, iExpense, CE, PO, etc.; Gather, manage and document functional requirements for technical customization including reports, forms, workflows and scripting;
• Perform system analysis, requirement studies, specifications generation, system setups and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
• Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
• KBD57 Task - Setup AR, AP for 4 agencies (SWE, TPO, SGB, and SGF) to keep them separate as per Govt. regulation also involved in conversion of Customers and Suppliers for the agencies using Data loader. iExpense Setups: Expense Report Templates, Expense Types, Payment Terms, Pay Group, Payment priority
• Validate DFF Setups for iExpense in AP, GL reports and AP reports in prod and other instances
• Involved in creating Responsibilities with appropriate menus and functions for specific job roles in GL, AP, AR
• Involved in Regression testing for AR, AP, GL, Pay Terms in AP
• Working on production support issues (24x7) for iExpenses, AP, AR, GL and PO.
• Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.
• Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, FA, AP and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
• Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
• Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
• Review computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing systems; Study existing systems to evaluate effectiveness and develop new systems to improve efficiency and workflow.
• Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.

Environment: Oracle EBS R12, iProcurement,OM,AP, PO, GL, AR, FA, Quality Center, TOAD

Confidential, Chicago, IL

Oracle Financial Functional Consultant

Responsibilities:

• Provided analysis, design, installation, and rollout of Oracle 11i General Ledger, Accounts Payable, and Purchasing for onshore projects.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.
• Worked on defining responsibilities of management for the procedures in financial reporting.
• Assessed the current use of Oracle applications and the mapping of new features and functionality of 11i to the functionality required in the present company environment.
• Gathered requirements for the different types of journals and budgets the company uses in the current system and made system setup using AIM BR100, BR110 documentation.
• Setup Payable options and financial options in AP and System options in AR to generate Set of Books details from General Ledger.
• Discussed with the SMEs and end users to setup chart of accounts with currencies and calendars.
• Determining accounting needs, designing accounting segments, and defining accounting structure and making assignments to the existing Chart of Accounts.
• SMEs meetings arrangements for defining Summary account templates and setting up of summary account budgetary control options.
• Assigning the COA to Set of Books and assigning the SOBs in AP financial option to integrate GL and AP.
• Design the (Oracle E-business Suite 11.5.9) AP, AR, PO system to integrate with GL using process flow swim lane diagramming using ProVision tool.
• Setup of financial modules AP, AR and GL and testing.
• Designed interface/conversion mapping, pre-production testing, and related documentation and deliverables.
• Involved in configuring end to end financial modules.

Environment: Oracle Applications 11i GL, AR, AP, AOL, Forms 6i and Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts.

Confidential

Oracle Apps Functional Consultant

Responsibilities:

• Study of the current Business Process and GAP Analysis using AIM documents,
• Preparation of BR100, Common Set-ups doc, Sys Admin Set-ups documents.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Gathered application requirements and provided design recommendations.
• Assist in functional design with respect to custom data models that integrated with Oracle Applications.
• Involved in Sarbanes-Oxley (SOX) compliance testing process by including paper-based evidence, e.g., invoices, delivery receipts, purchase orders, bank statements and expense receipts
• Defined period types, calendars, Distribution sets, Tolerances, bank accounts payables documents, payment terms, approval groups and approval assignments.
• Participated in customization and personalization of iExpense pages.
• Configure complete GL including Org Structure, Rollup groups, parent child accounts, CVR’s & Value sets.
• Defined Ledgers and Ledger sets, Journal sources and categories.
• Defined Legal Entities and Operating Units for AP configuration. Configured Financial, Payable and Payable System options.
• Created Payment terms and Payment Process Profiles.
• Participated in setting up of tax users and profile option values in EB Tax.
• Configured GL Tax options and Ledger options for E-Business Tax functionality.
• Involved in setting up of Tax Configurator in EB Tax. Defined Tax defaults and Tax rules.
• System Administrator skills - user creation, defining responsibilities, profile options and securities.
• Defined roll up groups to provide the customize reports to the top management with drill down features.
• Involved in regression testing and UAT.
• Configured the setups for prepayments and adjustment to payment to suppliers
• Coordinated and monitored Month End Closing process.
• Generated various reports in GL, AP and SLA. Changed the submission instructions on the iExpenses page
• Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules.
• Involved in the production support of AP and CE modules and support Month End close process as well

Environment: Oracle Applications 11i GL, AR, AP,iExpense, AOL, Forms 6i and Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts.