PROFESSIONAL SUMMARY:

• 10+ yearsof experience with multiple EBS projects in Oracle Implementation, Upgradation projects, and Post Production Support in both 11i and R12 versions. Worked extensively on General Ledger (GL) including AGIS, Accounts Payable (AP) including Payments, Accounts Receivables (AR), E - B.Tax, Cash Management (CE), Fixed Assets (FA), Purchasing (PO), Order to Cash (O2C Cycle), Procure to Pay (P2P Cycle) and Acquire to Retire (A2R Cycle) and Sub Ledger Accounting (SLA)
• Functional knowledge on other applications such as i-expense, i-supplier and i-procurement for R12 implementation.
• Experienced with Oracle AIM Methodology including preparing documentation of RD20, BR30, BR100, MD50, CV040, TE40, and BP80, Including preparing documentation for Change Management process with Impact analysis from the function perspective.
• Experience in conducting multiple CRPs and coordinating UATs with tracking issues/open items and resolution of the same, working with technical team and/or oracle support. Created the extensive test scripts to verify the reports; tested, verified and deployed to production
• Experience in supporting/enhancing the Oracle E-Business Suite, Release 11i for Oracle Financials.
• Experience in providing application requirements gathering, designing, development, functional and technical documentation, and debugging. Performing business process mapping, Gap Analysis and User .
• Strong problem solving and analytical skills, fluentin written and verbal communication, great presentation skills, a team player and very comfortable interacting with all levels of business management.
• Extensive knowledge on FSG reports configurations and experience on change management tools such as STAT quest.

TECHNICAL SKILLS:

Oracle Applications: R12(12.0.3, 12.0.5, 12.0.6, 12.1.1 and 12.1.3) GL, AP, AR, FA,CE, e-B.Tax, iExpenses 11i (11.5.8, 11.5.9, 11.5.10 and 11.5.10.2)

Languages and Tools: PL/SQL, Discoverer Viewer, Web ADI, SQL Loader, Data Loader, Oracle 11g; Microsoft Office, MS Visio, MS Project, MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Oracle Financials Functional Consultant

Responsibilities:

• Reviewed and analyzed current business processes for implementation of Oracle Receivables, Oracle Payable’ s, Fixed Assets, General Ledger, SLA, Cash Management.
• Performed complex data analysis, configurations and complex design solutions in partnership with program stakeholders to meet the business requirements.
• Offered industry best practices utilizing AIM Methodology and assisted the client with the road map definition.
• Coordinated with project team for the Monthly Release Regression testing.
• Worked Closely with business for Conducting UAT for Expansion of Cash Card Providers (ePay, Incomm, Blackhawk) to different European Countries.
• Worked closely with the Vendors in Re -designing the Remittance file format.
• Involved in gathering requirements for New Payment methods where Electronic Gaming Expanded.
• Worked closely with the business users on Finance Month End & Year-End close Issues (AP, AR, GL, FA).
• Involved in technical discussions for migrating the code and validated the code by testing in Test and QA before moving the PPM Packages to Production.
• Worked Closely with offshore team for Testing and Development work.
• Working closely with technical teams involved in the conversion process, giving directions on the various approaches to the conversion process and making sure that all conversion items are completed, and balances reconciled with the legacy system.
• Played a lead role for conversion and migration of fixed assets from the Legacy system into Oracle.
• Prepared issues list, Risk plan, change request forms and regular client status reports.
• Prioritized tasks for the team based on feedback from the client meetings, number of defects and project progress.
• Provided support for production issues to include maintenance of incident logs, scheduling and ensuring that issues are resolved and closed out in time, and following up with oracle support for any SR raised.

Confidential, Portland, OR

Oracle Financials Functional Consultant

Responsibilities:

• Defined systems’ strategy, develop systems requirements, design and prototype, test, train,
• Provided solution design to R12 Project implementation focused on client business requirements.
• Designed, developed and documented functional specifications for reports, interfaces, conversions, extensions and workflows related to GL and FA.
• Mapped and validated conversion data; utilized More4apps tool for FA conversion.
• Evaluated current business processes and advised on new R12 features and functionalities that can be implemented to meet future business requirements.
• Raised issues and work resolutions as they came up to ensure adherence to the project schedule.
• Liaised with respective client functional team leads throughout system testing to ensure user participation in the testing process. Provided guidance to the respective client functional leads in the preparation of materials and class agendas.
• Acted as functional team lead for FA implementation; Liaised with client’s offshore functional teams in China and Singapore and coordinated the design, setup and implementation of their asset management requirements in FA.
• Designed and implemented Revenue recognition contingencies for client specific requirements
• Worked on integration of Payments with Wells Fargo bank. Implemented integration solution withclient’s third party systems which included point of sales/Disti revenue &cogs, and“Accelim” (a third party system capable of using theoptical recognition technology to process supplier invoices).

Confidential, Mahwah, NJ

Oracle Financials Functional Analyst

Responsibilities:

• As a Functional Analyst, reviewed and analyzed current business processes for Oracle Receivables, Oracle Payables, Fixed Assets, General Ledger, SLA, Cash Management, I-Expense.
• Conduct Demos of oracle Fixed Assets to introduce functionality of system
• Coordinated the effort for the Monthly Releases (Release Management).
• Coordinated with the team for the Monthly Release Regression testing
• Worked closely with the business on Quota Allocation, Claim Research, Claim Settlement.
• Involved in data cleanup for the year end closing (Remittance Account, Cash clearing Account, Prepayment Account, Revenue Account)
• Involved in technical discussions for migrating the code and validated the code by testing in Test and QA before moving the PPM Packages to Production
• Prepared issues list, Risk plan, change request forms and regular client status reports.
• Prioritize the tasks for the team based on feedback from the client meetings, number of defects and project progress.
• Worked on clearing the errors from the AR interface tables
• Worked on Functional Specs (Additional Requirements from Users
• Worked closely with the users in creating a new bank account and setting up the new receipt method for Mobile shops.
• Supported Users to resolve the critical issues for closing the periods (AR, AP)
• Worked on data fixes for the month End activities (Deleting Orphan Records, Refund Accounting)

Confidential, Ada, MI

Oracle Financials Functional Analyst

Responsibilities:

• Worked closely with the business users on Finance Month End & Year-End close Issues (AP, AR, GL, FA).
• Worked closely with Audit Team in Understanding the Cross-Currency Suspense Accounts in R12.
• Worked as an Oracle ERP Analyst Re implementing/upgrading R12 Fixed Assets
• Involved in Redesign of refund process (Refund Issue on returns, Refund Issue on edit cancels, Order entry form, Calculation and display of available AR)
• Worked on the Root cause for the incorrect accounting for Refunds (No accounted amount is being populated in ar distrubtions table for some refunds.
• Worked closely with Banks, Bank Accounts for internal purpose and Payment Formats for Manual Check and Electronic Fund Transfer (EFT) in single and multiple currencies.
• Involved In Accounts Reconciliation for Year-end close
• Involved in Redesign of refund process (Refund Issue on returns, Refund Issue on edit cancels, Order entry form, Calculation and display of available AR)
• Involved in resolving the Currency Translation Issues (Reporting Ledger)
• Perform User Acceptance Test (UAT) & for the end user on business process and procedures based on Financials modules
• Coordinated the effort for the Monthly Releases (Release Management).
• Coordinated with the Development teams, testing teams (offshore) and provide them the functional designs and helped them to understand the design. (Functional Specs)
• Worked on SEV 1 SR’s for critical Month End Production Issues (Receipt Accrual’s, Payment’s, and Upload Journals through -WEB ADI).
• Prioritize the tasks for the team based on feedback from the client meetings, number of defects and Project progress.
• Help the business users in understanding the Key Reports (Accounts Payable Trail Balance Report, Account Analysis report and Depreciation Project Report, Un- Invoiced Receipt Report, Invoice Hold Report).
• Worked closely with Business users in Understanding the Report Manager Functionality.
• Involved in technical discussions for migrating the code and validated the code by testing in Test before moving the PPM Packages to Production.

Confidential, Seneca Falls, NY

Oracle Financials Functional Analyst

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.
• Defined 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 documentation (UPK), 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 Confidential 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.

Confidential, Bethpage, NY

OracleFunctional Analyst

Responsibilities:

• Identified Business Requirements & detailed Solution Design for GL, AP and AR Modules.
• Supported Post-Upgradation from 11i to R12 phase for Oracle Financials Modules.
• Resolved issues being raised by users and reviewed major setups in the financial Modules.
• Involved in post-production troubleshooting exercises, bug fixes, raising SRs and working with Oracle Support for escalating issues and finding resolutions.
• Resolved the issues related to payment processing, payment authorization, and suppliers.
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Configured the Refund process in AR and the Automation of invoices in AP.
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report
• Setup PO module and matching options with AP invoices.
• Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register.
• Ran diagnostic scripts using toad and then gave input to technical team.
• Worked with Oracle Technical Support to resolve the critical issues through SR.
• Configured and implemented the Global Consolidation System (GCS) for the Company.

Confidential, Kansas City, Kansas

OracleFunctional Analyst

Responsibilities:

• Configured the Oracle system financial modules namely Account Payables (AP), Cash Management (CE), and Fixed Assets (FA) according to business needs. Occasionally helped out on other modules namely, inventory, OM, GL, and Receivables
• Working on STAT tool for Change management process and migration of setup data from development instance all the way to the production instance.
• Performed Requirement Analysis - gathering requirements, performing impact analysis and document requirements.
• Attend design meetings for both the client teams and Project Development team; document high level design and detailed design.
• Worked closely with Development team to ensure Implementation of the application as per the requirements and design as discussed with the business users.
• Developed test scripts and test cases for Open invoices, 1099 Invoices, and supplier setups as well as performing testing of the setups done in the system.
• Responsible for conversion and migration of Fixed Assets from the Legacy system into oracle.
• Involved in production and post go live issue troubleshooting process.

Confidential, Harrisburg, PA

Oracle Applications Functional Analyst

Responsibilities:

• Configured Payables System Options, Payable and Financial options
• Defined Payment Terms, Payment Set ups and Distribution Sets
• Setup Suppliers, Supplier Sites, Banks, Bank Accounts and documents
• Setup book controls, corporate book and tax book.
• Setup purchasing for standard functionalities like converting purchase requisitions into standard purchase orders and blanket releases.
• Involved in documentation of Future business (BP-80), present business requirements (RD-20), conversion (CV-40), and Function extension design document (MD-50), Test scripts (TE-40) and System Set up Document (BR-100) as per AIM Methodology.
• Super users & power users before start of CRP
• Conducted to User and super User for AP, and FA
• Conducted CRP’s and trained end users for, AP and FA
• Conducted extensive unit and integrated testing before CRP & UAT
• Did configurations on the i-expense and i-procurement web portal and oracle payments sub module.

Confidential, Princeton, NJ

Oracle Applications Functional Analyst

Responsibilities:

• Provided ongoing systems support and problem resolution to end-users, including data access, query generation, report generation, etc.
• Supported Oracle business users with all business / process (both the procure to pay and the order to cash cycle) related questions and concerns.
• Dealt with Receiving PO issues, item setup issues as well as AP Matching.
• Diagnosed and fixed problems with Oracle Applications configurations and setups.
• Troubleshoot application problems; researched application issues and provided first line support to Oracle end users.
• Raised Service Requests (SRs) and follow up with Oracle support team for resolution.
• Supported new and on-going development efforts on all Oracle modules.
• Automated business user functions and processes where applicable.
• Liaison with technical support team on behalf of end users
• Available for on call support during the critical system-processing period (i.e., month-end and year-end closing, and any Oracle related severity one issues).
• Worked with Oracle users to develop procedures for regular system processing and report generation; includes determining which processes need to be run and developing a schedule for ongoing processing.
• Responsible for diagnosing, analysis and documenting root causes of the support issues observed to avoid re-occurrence of such issues in the future.
• Periodical status updates to Project Manager and follow up with pending business input or issue resolutions as part of status meeting.

Confidential, Hopkinton, MA

Oracle Applications Functional Analyst

Responsibilities:

• Evaluated Business Process implication of system requirements and assessed possible redesign recommendation.
• Involved in identifying the GAP's with the New User Interface\ and reported the business and mapped the requirements with the New User Interface.
• Coordinated with the Development teams, testing teams (offshore) and provide them the Implementation Guides/functional designs.
• Participated in regular client meetings and project team meetings to provide updates on project statuses and activities.
• Wrote test cases and carried outboth unit and integrated testing.
• Involved in data migration from legacy system into Oracle Receivables to suit TCA (Trading Community Architecture).
• Gave extensive to the end users on invoice process, business scenarios and process.
• Worked in the support environment; performed system administration responsibilitiessuch as creating users, setting up user profiles and personalizing user forms.
• Logged Service Requests (SRs) from end-users, prioritized, scheduled and coordinated timely resolution of post-production issues.
• Worked extensively with 11.5.10.2 modules (GL, AP, AR, PO, OM,I-Expence), and exposure to SQL*Plus.