SUMMARY

• Subject matter expert in General Ledger (GL), Accounts Receivables (AR), Accounts Payable (AP), Fixed Assets (FA), Order Management (OM), Advanced Collections, E Business Tax and Cash Management (CM). iExpenses, iReceivables, R12 Federal Financials, Subledger Accounting, E - Biz Tax and AGIS.
• 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.
• Led Patch Management, Tar Management (TAR), Instance Management, Change Control Management (CR), Risk management processes.
• Recommended process improvements through best practices and collaborative Conference Room Pilots to successfully implement and support the Oracle R12 and R11i E-business Suite
• Experience in preparing test scripts for using in CRP and UAT for testing and developing Training documentation and HP Quality Center.
• Experience in Application Object Library, OA Framework, Concurrent Manager, Flex fields Management, and Trading Community Architecture to get a deep insight of product.
• Experience in Customizations, Personalization of Forms and Reports in oracle e-business suite applications.
• Supported end users in the organization in their use of software programs and processes to more efficiently and effectively fulfill business objectives.
• Supported the design, delivery, and improvement of in-house applications/process training programs and related courseware.
• Planed, designed, developed, and launched efficient business, financial, and operations systems and processes in support of core organizational functions and business processes.
• Analyzed, specified, and validated the business needs of project stakeholders. This includes interviewing stakeholders and gathering and compiling user requirements to conveying them to development teams throughout the application lifecycle.
• Designed and implemented software and systems, including integration wif databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing, and rolling out solutions to end users.
• Ensured high levels of systems availability through support functions and in-depth testing.
• Developed and assisted execution of test cases and expected outcomes for unit tests, string tests, system tests and user acceptance tests.
• Ensured high level of data quality across the enterprise through the creation and management of sound data management processes.
• Standardized data naming, establishing consistent data definitions, and monitor overall data quality.
• Coordinated the development and implementation of a data quality assurance program for the EBS procurement functionality. The program will focus on defining problems wif data, analyzing/identifying causes and improvements, and developing action plans for resolution.
• Research, gather and analyze data in support of business functions, proposed projects, and process knowledge and systems requirements.
• Oracle Applications of Functional modules (GL, AP, AR, FA, CM) along wif working experience of Release 12 of Oracle ERP.

TECHNICAL SKILLS

Tools: /METHODS

Oracle Applications Modules: GL, AGIS, SLA, AP, AR, FA, EBTAX, CE, PO, AME, Adv Proc Self Service Apps Iprocurement, iReceivables, iAssets and iExpenses.

Oracle Application Releases: Oracle Applications 11i (11.5.10/11.5.9/11.5.6 ), 11.0.3 and R 12/12.0.3/12.1.3

Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM)

Productivity Applications: MS Visio and MS Project

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

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

PROFESSIONAL EXPERIENCE

Oracle Financial Functional Consultant

Confidential, Houston, TX

Responsibilities:

• Lead Functional Consultant for O2C, AP, AR and GL.
• Business study and Prepared Process Analysis Questionnaire.
• Led the blue printing sessions and documented the processes; identified gaps from the Global design where applicable.
• Prepared the RD50, BR100, MD50and performed the set ups.
• Actively designing solutions wif emphasis on implementing Global design as much as possible.
• Designed and created new CHART OF ACCOUNTS and set of books.
• Performed GL, AP AR set ups in US, France and Mexico.
• Worked on the enhancement and customizations and production support issues related O2C, AR, AP,GL in R12.
• Provided production support for day to day business issues on R12.1.3 and worked on SRs wif Oracle and applied patches as and when required to resolve the Application issues.
• Log, view, access, monitor, follow up and close Service Requests (SRs) online through Oracle Metal ink and Oracle Applications Patch Management.
• Involved in the tokenization testing.
• Worked on P2P CYCLE PROCESS
• Provided daily user support for Financial modules and applied patches as and when required to resolve the Application issues.
• Log, view, access, monitor, follow up and close Service Requests (SRs) online through Oracle Metal ink and Oracle Applications Patch Management.
• Resolved all the functional and technical issues for AR, AP, GL, PO, and me-expenses Modules.
• Preparation and modification of documents like MD050, BR100 as part of project Deliverables for the change requests for functional and technical configuration changes.
• Post production support and maintenance of the Application and resolved user queries.
• Involved in the month end closure and reconciliation activities to close the periods on respective financial modules.
• Active part of Advance Procurement implementation and Leading Oracle Internet Expenses implementation.
• Worked on the setup & administration of iExpenses wif Credit card functionality and AME.
• Conducted user meetings to gather requirements for the implementation of OIE and AME.
• Conducted CRP’s for Advance Procurement as well as participated in Unit Testing of Account Payables and as well as other Financial Modules.
• Worked wif Purchasing and iProcurement team for the approval access and other user requests.
• Worked on User Productivity Kit UPK to document and create training models for the Users.

Environment: Oracle R12 (12.1.3) (Financials- GL, AP, AR, Purchasing, Adv Procurement, AME and OIE)

Oracle Financial Functional Consultant

Confidential

Responsibilities:

• Prepared Functional Specification Documents, AS-IS and TO-BE workflows
• Assist in defining and reviewing the functional requirements for the RICEW objects, for instance, existing interface specifications.
• Full cycle implementation of Oracle ERP E-Business Suite Release 12.1.3 (Finance).
• My focus areas was finance modules implementation (AP, AR, GL, Cash Management)
• Lead the complete implementation lifecycle including, requirements gathering, global esign workshops, Conference Room Pilot testing, Vertex - Oracle EBS integration testing, User Acceptance Testing (UAT), User Training and Go-live/Month end close.
• Prepared Gap Analysis for new modules
• Re structured approval hierarchy based on company new policies and Prepared Current Business Baseline.
• Developed test plans and scripts and conducted testing for quality assurance.
• Performed set up for GL, AP, AR, CM, EBTax, me-procurement, advance collections modules for R12.
• Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
• Mapping the Client requirements wif 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 wif 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.
• Performed month end close activities for AP and AR
• 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.
• Created New Credit Card When Making Payment Through Advanced Collections
• Fixed the advance collection payment processing screen not defaulting credit card info
• Helped the technical team in the customer conversion, Open AR invoices and receipts conversion.
• Defined the Funds Capture Setup to process the ACH payments.
• Helped the business in the month end closing process.
• Helped the business to close the periods and open the new periods.
• Preparing TE040 Documents for GL, AP, and FA which are halpful to test the application functions in R12. Testing of various test scenarios of Requisition to Purchase Order cycle in Oracle Purchasing and from Projects and grants.
• Personalized the Payment Batch Process suitable to the user Requirements.
• Created new Web ADI Templates to load Journal Entries and Assets.
• Full CRP1, CRP2, and UAT testing cycles, wif issue trackers, HP Quality Center and SME’s sign of.
• Provided Training, Conducted Practice & Additional Business Requirements sessions.
• Design test scripts of all sub-process identified in assessment phase. Unit testing execution for each business process.
• Involved in Support production environments of P2P
• Analyze and test integration wif 3rd Parties and legacy systems.
• Supported production environments and users on a daily basis by responding to emergency requests

Environment: Oracle R12 (12.0.3) (Financials- AP, AR, CM, GL, Internet Expenses and PO)

Oracle Financial Functional Consultant

Confidential, Nashville, TN

Responsibilities:

• Involved in requirement gathering and analysis and design of the existing and future application
• Prepared Functional Specification Documents, AS-IS and TO-BE workflows
• Assist in defining and reviewing the functional requirements for the RICEW objects, for instance, existing interface specifications.
• Full cycle implementation of Oracle ERP E-Business Suite Release 12.0.3 (Finance). Successfully completed implementation rollout at
• My focus areas was finance modules implementation (AP, AR, GL, Cash Management)
• Led the complete implementation lifecycle including, requirements gathering, global design workshops, Conference Room Pilot testing, Vertex - Oracle EBS integration testing, User Acceptance Testing (UAT), User Training and Go-live/Month end close.
• Prepared Gap Analysis for new modules
• Worked on Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges of AR.
• Cash Management was implemented for 255 Bank Accounts across various countries and for various banks. Mapping the Bank statements in multiple BAI formats wif 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 wif 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).
• Re structured approval hierarchy based on company new policies
• Prepared specification for the account generator (Charge account generation) while requisition creation in iprocurement/Purchasing.
• Prepared Current Business Baseline
• Actively participated in ORG and Char of Account discussion in design phase.
• Experience of working on Oracle projects integration wif Fixed Assets.
• Prepared Finance module configuration document (BR100), Business process (BPO110), Gap detail document.
• Work wif the business architect and other planners to assess current capabilities and identify high-level requirements.

Environment: Oracle R12 (12.0.3) (Financials- AP, AR, CE, GL and FA)

Oracle Financial Functional Consultant

Confidential, San Jose CA

Responsibilities:

• Worked as functional lead in GL, AP, iExpenses, iProcurement and FA.
• Actively participated in Acquired company implementations in very tight schedule
• Prepared Requirement Documents and GAPs for newly acquired companies
• Functional flow: Procurement flow including Punchout, Capitalized Assets, Mass Additions, Catalog Bulk load and approval hierarchy
• Functional flow: Global Intercompany Transactions, Expenses Reports using iExp, Payment batch, Electronic Payments.
• Configured intercompany (AGIS) setups
• Preparing GL setup documents for assigned sites and do setups in the instance using Data loader & Oracle Web ADI tools
• Configured Multi-Org, MRC, and Intra-Company and Inter-Company setups for USA, Mexico, Asia- Pacific and Latin America.
• Supported production environments and users on a daily basis by responding to emergency Requests
• Configured the setup for AGIS organizations, customer supplier relationships
• Trained Users in creating non-invoicing AGIS transactions, a taxable intra-country AGIS transaction, AGIS transaction where tax is not expected an AGIS transaction where tax wifholding is expected on the AP invoice, Create and run the netting batch.
• Configured MRC setups and created Journals wif foreign currency.
• Conducted kick off/CRP
• Configured Finance and Procurement Modules in DEV and UAT instances
• Integration testing wif internal and external modules/applications
• Prepared UAT plan and Test Cases
• Acted liaison between IT implementation team and Business Super Users
• Tracked UAT issues wif solutions
• Configured and worked on Assets Tax Books setup and in accordance process wif Tax Book Interface table.
• Worked on request groups of Europe and China.
• Worked on Bank account transfers of Clients Cash Management.
• Defined required Depreciation books and Tax rules of Oracle Assets.
• Prepared rollout production readiness and cutover plan
• Supported Post Go Live issues

Environment: Oracle Applications R12 and 11.5.10 (AP, OIE, FA, GL and AIM, MS Visio)

Oracle Financial Functional Consultant

Confidential

Responsibilities:

• Business Requirement Analysis, Gap Analysis, Set ups, defining functional specs for Oracle Financials Modules include GL, AP, AR and CE.
• Process interviews and documentation; development of organization structure and chart of accounts; software configuration, training, resolution of issues; conversion; and implementation cutover.
• Advised clients in their use of more advanced functionality such as multi-org, multiple sets of books, consolidation, translation, multi-currency, and optimization of flex field structures.
• Developed financial reports utilizing Oracle’s Financial Statement Generator.
• Setup Fixed Assets application wif client-specified custom depreciation methods.
• Implemented AR wif Auto invoice from Order Entry.
• Customized and tested Oracle Workflow for Fixed assets and Order Entry.
• Analyzed financial results for six subsidiaries and internal teams.
• Presented financial results to senior management in monthly meetings.
• Managed annual and quarterly budgeting process, including variance analysis.
• Developed and documented accounting procedures for cash management, AR, AP, overhead allocation, corporate budgeting, and foreign currency transactions.

Environment: Oracle Applications 11.5.3, Finance Modules