SUMMARY

• Over 8 years of experience in IT consulting as an ERP Oracle E - business Suite business/functional analyst in multiple business domains in analyzing, implementing and training of Oracle applications.
• Extensive experience in implementing and testing Oracle Financial Modules including Order to Cash (O2C) Procure to Pay process (P2P) cycles.
• Sound knowledge of Oracle EBS Suite Release 12.x.x and 11i. Modules include GL (General Ledger), AR (Account Receivable), AP (Account Payable, Cash Management (CM), PO (Purchasing).
• Experience with process analysis, mapping, gap analysis, troubleshooting and issue resolution with Oracle Applications module implementation and use, user training programs, post-implementation support documentations.
• Performed System Administration activities.
• Forms personalization, reports customization,
• Well experienced in Multi-Org setups, Multi-Currency setups in Global Oracle Applications environment. Good Knowledge in Revaluation, Translation Strong knowledge working on Trading Community Architecture.
• Experienced in 3 full life cycle implementations from requirements gathering to post production.
• Experienced in GL balances conversion using translation and revaluation process for final balances in reporting currency.
• Created functional design documentation to assist the technical team in developing centralized functionality. Have great exposure to Oracle AIM methodology.
• Experienced in Sub-ledger Accounting (SLA), Accounting Setup Manager, Multi Org Access Control (MOAC) and creating Financial Statements and ad hoc reports using FSG (Financial Statement Generator). Global Intercompany Accounting System, Global Consolidation System, Multiple Reporting Currencies and Flexfield setups.
• Solid understanding of the Business Processes across various business domains, and strong track record for developing innovative solutions and effectively interacting with people at all organization levels from the CFO/CEO to Business Owners to the final End User.
• Ability to diagnose and solve system problems while working under pressure to meet aggressive deadlines with limited resources environment.

TECHNICAL SKILLS

Financial Applications: GL, AP, AR, PO, CE

ERP Versions: Oracle Applications 11i (11.5.8, 11.5. X ) and R12 (R12.1.3)

Methodology: Oracle Application Implementation Methodology (AIM)

Programming Languages: C, C++, SQL, HTML, XHTML,CSS

M.S. Office Packages: Word, Excel, Power Point

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Oracle Applications Functional Consultant

Responsibilities:

• Developed functional documents on 5 Day close OTC and P2P Reports, and provided assistance in end to end implementation and requirement gathering for these reports.
• Onsite facilitation with the business managers and played a vital role in requirement gathering and communicating the requirement to the offshore technical team
• Performed hand in hand Unit Testing with the Technical Team and UAT with the business users.
• Direct reporting to Director of IT and Finance
• Worked closely with the business and the offshore team in building new reports and modifying existing Finance and OTC reports. These reports were custom built to smooth out the period end close activities at Confidential Corp.
• Facilitated, Online - Payment Process for multiple operating units, Auto-Lockbox Set ups and Bank Reconciliation
• Functional set ups on Order Types and AR Transaction Types and end to end UAT testing
• Provided help for the offshore team in report migration process and CVS issues
• Unit testing on the reports before the UAT migration
• Provided assistance in migration of these reports from DEV-UAT-PROD

Confidential, Denver, CO

Oracle Applications Financial Analyst

Responsibilities:

• Accounts Payable, General Ledger and PO modules.
• Design detailed Process Flow for Invoice to Payment
• Establish Security And Control Requirements
• Perform Conversion Data Mapping
• Map Requirements to Application Processes
• Develop Functional Specifications
• Conduct Security Testing
• Functional configurations - setting up the applications
• Conducted Training for the end users
• Functional Issue resolution for custom and conversion components

Confidential, Milwaukee, WI

Oracle Functional

Responsibilities:

• Develop / Review Functional specifications.
• Setup and System Configuration of Oracle Financials
• Conduct CRP (Conference Room Piloting), System Integration Testing (SIT), and UAT sessions
• New features like Sub Ledger Accounting (SLA) and functionality changes in various modules are reviewed with CFO, Super users and Users of various business areas.
• Train technical team in R12 concepts of Ledger, SLA, MOAC and GL, AP and PO.
• Present the identified gaps and work with business owners/users in the design sessions. Mapped the future state process requirements in GL, AP and PO.
• Setting up Finance options, Payable options, Suppliers, sites, Banks, Payment terms, Payment formats, Payment documents.
• Design the AP payments process for Global Implementation.
• Set-up, facilitate and assist client in carrying out User Acceptance Testing (UAT), including assisting with creating and executing UAT test cases as requested

Confidential, Chicago, IL

Oracle Applications Financial Analyst

Responsibilities:

• Presented requirements definition, gap analysis, configuration related to General ledger, and Accounts Payable. Worked with business owners/users in the design sessions. Mapped the future state process requirements in GL and AP
• Train technical team in R12 concepts of Ledger, SLA, MOAC GL, and AP modules.
• As a Finance super user my job involves creating the Invoices, make payments and reconcile with Cash Management to test the functionality.
• Setting up Finance options, Payable options, Suppliers, sites, Banks, Payment terms, Payment formats, Payment documents.
• Performed end to end testing for the entire process flow for AP, and GL module and documented the test results
• Preparation of user training documents - prepared the training document (AP, and GL modules) for the users, specific to the clients’ business and covering their critical business process flows.

Confidential, Mahwah, NJ

Financial Functional Analyst

Responsibilities:

• System setup audit was done to ensure the system setups in R12 to meet the requirement in GL, AP, AR, CM modules.
• New features like Sub Ledger Accounting (SLA) and functionality changes in various modules are reviewed with CFO, Super users and Users of various business areas.
• Cash Management system has been tested to the bank file reconciliation process.
• Developed test cases on various functional scenarios and provided to user and user training has been provided on new system.
• Help provided for Financial Statement Generation in GL module
• Security setups done for the users and managers
• Features explained to the client. Features such as; Data Access Set, SLA, MOAC, HTML Dashboard in R12 etc.

Confidential, NYC, NY

Oracle Functional Analyst

Responsibilities:

• Involved in current system analysis and GAP analysis system configuration and testing in GL module implementation. Organized workshop for the end users for requirement gathering, limitations of existing system and proposed the solutions.
• Designed Key Accounting Flex field structure with Multi Org and Multi Currency setup. Defined rollup groups, security rules, journal sources, journal categories, budgets and budget organization, intercompany accounts, cross validation rules, summary accounts, account aliases, currency translation, conversion, and revaluation to meet the requirements in GL modules. GL setups created such as; creating users, responsibilities, and assigning profile options.
• Configure setups for Global consolidation, Multi reporting currency and FSG reports.
• Configured the setup for batch invoices and batch payments, multi-currency invoices and multi-currency payments to meet the requirements in AP.
• Developed AIM documentation BR-20, BR-100, and MD-50 for business requirements, system setups, conversions, customizations and functional testing respectively.

Confidential, Atlanta, GA

Oracle Financials Functional Analyst

Responsibilities:

• Involved in the post production support phase for trouble shooting issues and helped development team in bug fixing. Followed a strict change management process involving user tickets followed by problem analysis, development or bug fixes, unit testing and user acceptance testing with thorough documentation maintained at all stages. Raising TAR's and working with oracle support for escalating issues and finding resolutions
• Supporting Oracle Applications finance modules (AP, PO, AR, Cash Management and GL) in Power Services to ensure smooth closure of their books.
• Supported in AR system setups. Also involved in master data setups like new customer setups
• Setups of Transaction types, Auto-Accounting, Accounting and invoicing rules, Approval limits, Payment terms
• Working knowledge of Cash management, Multi Organization structure, Multiple Reporting Currencies, Key and Descriptive Flexfield, System Administrator
• Involved in setup for Payables/Inventory /Purchase/Receivables/ General Ledger based on deep understanding of the functional processes
• Prepared end user training material with specific business cases and conducted end-user training
• Conducting Oracle Apps. Knowledge sharing sessions in Financials modules -- AP, AR, PO & GL
• Modifying the approval limits of users and disabling the limits of old users, modifying the custom lookup codes defining tax codes in both AP and AR.
• Defining the natural account segment values and legal entity and management entity segment values and defining consolidation modifying cross validation rules.
• Setup security rules to restrict access of users for only few fixed responsibilities.

Confidential

Functional Consultant

Responsibilities:

• Coordination with consultants for Business requirement study, Gap analysis and Process flow.
• As a Functional Consultant involved in the implementation of various modules like GL, AP, Purchasing and AR.
• Involved in the implementation of Procure-to-Pay and Order-to-Cash functionality of Oracle 11i
• Setting up Cross Validation Rules & Security Rules, Mass Allocations,
• Mapping the client requirement and giving them the best possible solution.
• Analyzing the current & Future requirement & critically analyzing them and suggesting recommendation
• Activation of various accounting Flexfield in the forms to gather the additional information
• Preparation of documentation relating to modules, Test Scripts, user manual for Key Users and End Users
• Conducting training for Key Users.
• Providing inputs for setting up templates and documentation.
• Involved in configuration in test and production instance
• Post implementation support and maintenance - performed successful three month end and period close activities in the newly implemented modules.

Confidential

Oracle Apps Functional Analyst

Responsibilities:

• Performed current system analysis, business process designing System configuration and testing.
• Setup Financial Options, and Payable Options.
• Setting up the system for Purchasing Module.
• Developed documentation Functional Documents
• CRP sessions
• System Testing
• UAT performance