SUMMARY

• Over 9 years of experience, as an Oracle Apps Financial Functional Consultant, handling financial projects and multiple versions of Oracle E - Business Suite.
• Extensive experience in all phases of full life cycle of Oracle Application Implementation i.e requirement gathering, Analysis, Configuration of Application, Implementation, Testing, Post Go-Live Support, Production Support, User Training and Documentation
• Experience in working on multiple versions of Oracle E-Business Suite 11i & R12
• Professional expertise in Designing, Implementation, Customization and Testing of Oracle Financial including General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax),Procure to Pay (P2P Cycle), Order to Cash (O2C Cycle), Sub-Ledger Accounting (SLA), .
• Worked on multiple Global implementation, Up gradation, and Post production Support projects
• Multiple on all the phases of life cycle, experience Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering, Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Go-live, GAP Analysis, and post-implementation support.
• Played key role in providing manual work around solutions for critical business scenarios
• Perform regressive testing on process and functional testing
• Extensive knowledge in General Ledger(GL), Advance Global Intercompany System(AGIS), Involved in Multi-Org & Multi-Currency, re-valuation, translation and Global Consolidation System(GCS), Designed and developed Financial Statements (FSG’s).
• Excellent knowledge in preparing and maintaining Oracle AIM methodology documentation including BR100, RD20, MD50, TE40, CV40 and Change Management Process documentation
• Worked on AS-IS,TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing
• Expertise in AGIS and GL, AP Modules.
• Given wide range of functional training to end users, Co-ordinated CRP and UAT.
• Worked extensively on API’s in Finance area of GL, AP and AR
• Create SR’s with Oracle Technical Support, coordinate and follow on multiple issues based on priority including identifying bugs and follow-up with Oracle Development
• Communicate with technical team on design and development of enhancement
• Strong problem solving, and analytical skill with good written and verbal communication skill

TECHNICAL SKILLS

Oracle Financial: GL, AP, AR, CE, FA, SLA, E-B.Tax, PO, Sys P2P, O2C and Oracle Financial R12&11i

Other Tools: SQL Loader, Data Loader and MS Office

Other Software’s: Microsoft Office Project, Access; PVCS Tracker

O/S: Windows 7/XP/2000/98/95.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr. Oracle Apps Financial Functional Consultant

Environment: R12 and is responsible for GL, AP, CE, Procure to Pay (P2P Cycle), Order to Cash(O2C Cycle)

Responsibilities:

• My core responsibilities involved with trouble shooting in the area of AR, AP, and GL modules
• Create and follow-up on multiple SEV1 & SEV2 SRs for speedy resolution explain business team with cause of issue
• Followed up with Oracle team to fix errors while conducting sql code writing, upgrading, manipulating, editing, and inserting using SQL Developer for Oracle DBS.
• Created Users and modified the privileges for the Users, Rollup group and Summary Accounts
• Coordinate with DBA team to apply patches proposed by oracle after following up on existing issues
• Defined and generated FSG’s for Balance Sheets where rollup groups are considered for aren’t/child relationship.
• Activities in System administrator to assign user accounts, assigned responsibilities, menu selection, reports, etc.
• Immensely worked on AGIS, GL and AP modules.
• Prepare custom financial reports for month-end process using FSG
• Resolve month end reconciliation issues in GL Reporting standard and FSG reports
• Worked on API’s of all Financial modules
• Set-up Multiple Organization Access Control (MOAC) and Multiple Reporting Currencies
• Configured the Multi-Organization Access (MOAC), Ledger Setup, and Legal Entities
• Interact with Technical team on design and development of enhancement
• Provide detailed root cause analysis on all assigned issues with reproducing the same in latest cloned copy of test environment
• Being a Techno functional has written MD.050 and BR 100 documents
• Provided Users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi-Operating Units through Security Profile in a secured environment
• Perform testing on process and functional testing
• Created Customized responsibilities, customized menus, customized request groups.
• Resolved any month end related issues involving and data fixes or configuration changes
• Responsibility to manage: Creating & Administering Users, Responsibilities, Profile Options, Application Menus and Forms, User and Role Configurations.

Confidential, Columbus, Ohio

Sr. Oracle Apps Financial Functional Consultant

Environment: Implémentation & Post-Production support on GL, AR, AP, CE, Procure to Pay (P2P Cycle), Order to Cash (O2C Cycle), (version R12)

Responsibilities:

• Responsible with requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
• Reviewed current business process and documented the business procedures for Procure to Pay and Project Invoicing to Cash Receipts
• Designed Key Accounting Flex field structure (COA) for Ledger and configured with Multi Org and Multi Reporting Currency setup. Defined system controls, intercompany accounts, journal sources, and journal categories. Defined various currencies for multi-currency operations and currency translation, conversion, revaluation has been done to meet the requirement, Cross validationrules, Configured Sub-ledger accounting process to GL. Defined Security rules at segment level.
• Configured and setup for Financial option, Payable system option & Payable option) to meet the requirements such as batch invoices, batch payments, employee expense report process, withholding tax.
• Worked on AGIS, GL and AR modules
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• Testing the process and do functional testing
• Changes in Workflow process, monitored CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, feedback integration.
• Written MD.050 and BR 100 documents
• Streamline the Payment process, Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks. Involved in Post-Production support.
• Worked on API’s in Finance
• Responsibility to manage: Creating & Administering Users, Responsibilities, Profile Options, Application Menus and Forms, User and Role Configurations
• Work closely with technical team on design and development of the enhancement
• Resolved any month end related issues involving and data fixes or configuration changes, created/Maintained Business process Documents BP80,RD-20,BR-30,BR-100,MD-50,TE-40,CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology.

Confidential, Chicago, IL

Sr. Oracle Apps Financial Functional Consultant

Environment: Implémentation & Post-Production support on GL, AR, AP, CE, Procure to Pay (P2P Cycle), Order to Cash (O2C Cycle), (version 11i)

Responsibilities:

• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications to finalize the solution.
• Identifying standard functionality, analyze gaps document and design solution for GL & AR depending on Business requirements
• Coordinated with Project Manager, Business team for system updates and deadlines for the implementation
• Configured Chart of Accounts structure, Segment Values, Value Sets, and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar & Currencies. Setting up Consolidation Ledgers, AGIS for intercompany Transactions
• Set-up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defined FSG’s, and Open and Close Accounting Periods..
• Set-up AR System options, payment terms and Auto accounting.
• Created and setup customers and its profile class.
• Trouble shoot on AGIS and GL modules
• Set-up receipt class, receipt methods, receivable activities and accounting information for revenue recognition
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
• Involved in CRPs, UAT and Go-Live, Providing post Go Live Support
• Created/Maintained Business process documents BR-100, MD-50, TE-40, and CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology as part of project implementation task.

Confidential, Michigan, Indiana

Sr. Oracle Apps Financial Functional Consultant

Environment: Upgrade Project on GL, PO, AP, AR, FA, CE Order to Cash (O2C Cycle), Procure to Pay (P2P Cycle), (version 11.5.10.2 )

Responsibilities:

• Implementation and support of Accounts Receivables and Account Payable Modules.
• Implementation of iExpenses Module.
• Created a base template to gather country specific localization requirements.
• Managed team in India to implement the P2P Business flows including GL, FA, iProcurement, PO, AP, iExpense, EB-Tax modules, Cash Management and Bank Integration.
• User training and CRP, UAT successfully.
• Configurations and setups for Ledger, Legal Entity, Operating Unit and Locations for new countries.
• Worked on setting up the new tax rates including VAT and withholding taxes as localization requirements, iExpense templates (parking, per diem, corporate cell phone and mileage rates), Approval Hierarchies in Purchasing Module, and Fixed Asset Books and Categories.
• Procurement/Purchasing: Setup the approval hierarchy, approval groups and approver assignment and designed workflow customization. Prepared the custom PO Print Program - MD050 and worked on custom PO Detail Report.
• Involved in the Item Master Setups in Inventory module including setting up of Item templates.

Confidential, Syracuse, NY

Oracle Apps Financial Functional Consultant

Environment: Implémentation & Postproduction support on GL, PO, AP, AR, CE, P2P, O2C (version 11.5.10.2).

Responsibilities:

• Interaction with Business Users to understand better their main points and Key requirements
• Understanding current Chart Of Accounts and propose a future design to enhance the way Atrium does Business currently with a new Chart of Accounts in R12
• Discuss and analyze handling of Project Capital Assets As-Is and To Be Process
• Define Scoring models and Credit checklists for validated/ Approved customer list
• Gathering Business Requirements for Upgrade considerations and documenting them
• Capture and upgrade all the Custom Processes and Reports
• Actively involved in implementation of E-business suite including gathering the requirements from the user and understanding their business model the modules worked on includes AR, AP, FAH, GL and FA Modules
• Provide a Demo environment to show the Intercompany (AGIS) Future transactions in R12
• Upgrade and modify the current Revenue Recognition schedule in AR to reflect R12 changes and Future Business needs
• Develop Unit (TE.020) and System Integration Test Scripts (TE.050)
• Designed chart of accounts to meet the client’s business requirements
• Set-up accounting period types and accounting calendars

Confidential - Chicago, IL

Oracle Apps Financial Functional Consultant

Environment: R11, GL, AP, P2P -Implementation.

Responsibilities:

• Identified Business Requirements & detailed Solution Design for GL, AP and Purchasing Modules.
• Involved in workshop sessions with GL, AP Finance users in detailing out business requirements & map business design with Oracle GL & AP configuration (12.1.3).
• Identify & Document Gap Business Requirements for Oracle GL, Purchasing& Oracle Payables Apps
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data
• Review the setups with the CFO, Manager and users of respective modules/systems and updated the setup as per Business requirements.
• New functionalities like Sub Ledger Accounting (SAL) and functionality changes in various modules are reviewed with CFO, Super users and Users of various Business areas.
• Responsible for preparing upgrade plan for GL, AP & FA
• Responsible for complete functional testing and resolving issues
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration. Coordinated with Oracle support and raised SR for critical issues
• Resolved process issues, period end closing and interface issues in GL, AP, AR, FA, CE, PO and E-Business Tax modules.
• Issue resolution, update functional impact analysis with proposed changes, if any in to Bugzilla issue tracker
• Create and followed up SR’s with Oracle Technical Support, coordinate and follow on multiple issues based on priority including identifying bugs and follow-up with Oracle Development

Confidential, Bradenton, FL

Apps Financial Functional Consultant

Environment: Implementation of R11i and was responsible for GL, AR, AP, FA and Order to Cash (O2C Cycle) from just after CRP1 Phase through to Go-Live

Responsibilities:

• Conducted preliminary study on current asset creation process and system (Access Database).
• Organized shop floor meetings with Users, Accounting and audit person. Established one-on-one interaction with user in requirement gathering, current system analysis and solution designing.
• Current business process in assets creation, assets accounting and asset inventory control have been reviewed and provided as-is and to-be process document on Assets creation and effective Asset Management process.
• Developed Business processes, solution designing to meet the business requirement.
• Designed and configured setups in Inventory, Purchase and Account Payables modules to meet the Purchase Requisition to create asset process.
• Conversion strategy had been developed to migrate the asset data from current system (Access Database) in to Oracle Fixed Assets. ADI had been used to migrate the data. Ensured financial data validation.
• Maintained (AIM) Documents with regards to Requirements, as-is and to-be process, setup document BR-100 and RICE document (MD-50, CV-40) for data conversion and custom reports.
• Provided user training and developed Test Scripts which help the user while testing various scenarios in Fixed Asset module.
• CRP and user acceptance test (UAT) were carried out and resolved the issues during CRP and UAT. Post-production support has been provided.
• Issue resolution, update functional impact analysis with proposed changes, if any in to Bugzilla issue tracker
• Provided production support on GL, AP, AR, FA, PO, and modules and resolved period end closing and interface issues in production...

Confidential, NY

Oracle Apps Financial Functional Consultant

Environment: Implementation of 11.5.10 and was responsible for GL, AR, AP, FA, Procure to Pay (P2P Cycle) and Order to Cash (O2C Cycle)

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document (BRDs) for the financial modules from CRP0 thru CRP1.
• Conducted CRP0, CRP1, SIT, and UAT sessions for the financial Modules namely GL, FA, PA, AP, CM and Purchasing.
• Mapped the future state process requirements
• Setup the AP Module for different Operating Units
• Defined Expense report templates in AP.
• Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source types
• Defined System Options, Accounting Option, Lookups, Payment and Billing term templates.
• Worked with the business users and technical team to enable data conversion from legacy systems to Oracle in CRP1, SIT and Simulation phases.
• Performed and documented systems analysis, validation testing, and development of training documentation (UPK), training of internal staff of enhanced business system functionality.
• Created test documents, performed unit, End to End and User Acceptance Tests for AP, FA, GL, PA and PO
• Defined Rules and Responsibilities per Xylem super users’ guideline.
• Involved in post-production troubleshooting, bug fixes, raising SRs and working with DI and Oracle Support for escalating issues and finding resolutions