SUMMARY

• Substantive 9 years of experience as an Oracle Functional Consultant with expertise in both 11i and R12 versions.
• Practical experience in analyzing, developing, customizing, implementing and testing Oracle Apps solutions with rich knowledge of the Financial Modules.
• Worked in different roles such as a Functional Consultant and Support Analyst with mid - size team of analysts to successfully deliver tasks in a timely fashion.
• End-to-End Implementation experience on the following Oracle Application modules - AP,AR,FA,GL, CM, PO,iExpenses,iAsset,EB Tax.
• Direct interaction with end users for requirement gathering and architecting the To-Be processes
• Extensive experience in conducting Conference Room meetings and end user trainings
• Sound knowledge of Sub Ledger Accounting (SLA) in Release 12.
• Good understanding of Order to Cash (O2C),Procure to Pay (P2P) and Acquire to Retire business life Cycles
• Interaction with Oracle support to resolve application issues through SR/TAR.
• Excellent communication skills with leadership qualities and open to innovative ideas to develop a creative solution for challenging client needs.
• Experience in using Application Implementation Methodology(AIM) documentation(BR100, TE40, RD20, MD50, BP80, and CV40)
• Good understanding of Accounting Principles, US GAAP and business flows.
• A clear understanding of the functionality of the core Oracle Financials modules and their interplay in the overall accounting structure of an organization.
• Worked on Data Conversions from Legacy system to Oracle using Web ADI and standard interface.
• An enthusiastic and project-oriented team player

TECHNICAL SKILLS

• Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, iExpense, Sys Admin, SLA, P2P, O2C and A2R.
• Web ADI, Toad, Data Loader, Discoverer, OBIE, SQL*Loader,
• SQL*Plus and MS Office.

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Financial Functional Consultant

Responsibilities:

• Working extensively as part of requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing in the P2P and O2C cycles.
• Responsible for GAP and FIT GAP analysis, creation of Setup Documents and Functional Design Documents. Conducted CRP and UAT Sessions.
• Responsible for creation of MD050 for custom objects, and BR100 setup documents.
• Working on an offshore model, as part of a team of 9 members.
• Implementing Payables, Receivables and iExpenses for Tacoma, Portland and Temecula.
• Responsible for designing various custom interfaces outbound and inbound between Oracle and Legacy systems/Third Party/Banks inclusive of Invoice Interfaces, Customer and Supplier Outbound, Bank Statements, Remittance Advices.
• Designing Custom ACH CTX format for Corporate Card Program, worked on EDI 810 Invoice Outbound program, 820 Inbound Remittance Advice, worked on Custom Process for Cancellation of Journal Workflows and resubmissions and custom notification for iExpenses related to Compliance Issues.
• Working Extensively on Custom Templates for ACH payments, Checks, Positive Pay files with several customizations on these templates.
• Creating design documents for Form personalization, AR SLA customization and WF customizations.
• Working on integration with Document Imaging Services like Docuware. Integration of Invoices, Transactions, Customer Statements, Remittances into Docuware.
• Providing active support for modules including AP, AR, GL, CE, iExpenses on a daily basis.
• Working on Service Now for Incident Handling, Creation of Enhancement requests, Stories and Scrum Tasks.
• Raising SR’s with Oracle Support, involved in OWC and resolved issues. Prepared BP 040, BP080, test scripts and BR 100 documents
• Responsible for customer data conversion, customer interface, open invoice conversion, report customizations.

Confidential

Oracle Financials Consultant

Responsibilities:

• Defined systems’ strategy, developed systems requirements, designed and prototyped, tested and trained users.
• Provided solution design to R12 Project implementation.
• Designed, developed and documented functional specifications for reports, interfaces, conversions, extensions and workflows related to Inventory, Order management COGS
• Mapped and validated conversion data. Utilized More4apps tool for AP conversion.
• Evaluated the current business processes and advised on new R12 features and functionalities that could be implemented.
• Part of solution for EDI external facing documents design.
• Raised issues and worked resolutions as they came up to ensure adherence to the project schedule.
• Participated with the respective client functional lead throughout system testing. Provided guidance to the respective client functional lead in the preparation of training materials and class agendas.
• Designed and implemented Revenue recognition contingencies for client specific requirements
• Worked on integration of Payments with Confidential bank.
• Implemented solution to handle point of sales/Disti revenue & cogs with a custom bolt on for third party system ‘ Azerity’
• Worked on integration of Payables Processing with ‘Accelim’ tool. Accelim tool is a third party system capable of using the Optical recognition technology to process supplier invoices.

Confidential

Oracle EBS Financial Functional Consultant

Responsibilities:

• Worked extensively as part of requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
• After analyzing the Business processes and workflows, defined various responsibilities for single application and assigned to users.
• Identification of Gaps and providing Workaround solutions for the Gaps.
• Designed Key Accounting Flex field structure (COA) for Ledger and configured with Multi Org and Multi Reporting Currency setup. Defined system controls, intercompany accounts, summary accounts, journal sources, and journal categories. Defined various currencies for multi-currency operations and currency translation, conversion, revaluation to meet the requirement. Cross validation rules were setup for various GL codes. Configured Sub-ledger accounting process to GL. Defined Security rules at segment level.
• Reviewed current business process and documented the business procedures for Procure to Paycycle. Dealt with Buyer Setup, RFQ, and third party custom POs. Also dealt with Outbound POs through EDI.
• Payables process was designed and system 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, 1099 reporting, cross currency invoices and payments.
• Performed manual conversion of Fixed Assets with using Web ADI and review other steps with FA Mass Additions, Asset transfers, Asset depreciation,
• Reconciled FA balances with GL balances at Company and Account level combinations.
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
• Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks. Involved in Post-Production support.
• Developed and tested multiple financial statements generated using Financial Statement Generator (FSG)
• Created/Maintained Business process Documents BP-80,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 as part of project implementation task.
• Involved in preparation of various scenarios on Financial Modules considering different business assumptions.
• Configured complete AGIS (Advance Global Intercompany System). Involved in Multi-Org & Multi-Currency, Re-valuation, Translation, MOAC (Multi Organization Access Control).
• Application Support and troubleshooting of issues on R12 Oracle Financial modules.
• Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10).
• Interacted with Oracle Support whenever needed, and coordinating with Oracle via Metalink for product related issues.
• Maintained and updated issues Log for reporting the status of the issues and conducting issue status meetings with users on weekly basis.

Confidential

Oracle Business Analyst

Responsibilities:

• Worked as part of the Finance team in Upgrade project from 11.5.10.2 to 12.1.3 (Fixed Assets)
• As a Functional Consultant reviewed and analyzed current business processes in 11.5.10.2 and explained new features to business users in R12.
• Coordinated the effort for the Monthly Releases (Release Management).
• 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.
• Prioritized the tasks for the team based on feedback from the client meetings, number of defects and project progress
• Gathered detailed user requirements and educated the users on high level system. Explored alternative ways of meeting user requirements through improving business process & system configurations.
• Worked on Functional Specs (Additional Requirements from Users).
• Configured, Conducted Training sessions and Prepared Training Material for Report Manager in R12.
• Conducted CRP Sessions for the business users.
• Worked closely with the business users for validating the system once the upgrade is completed.
• Helped the business users in taking the key validation reports before and after the Upgrade.
• Involved in technical discussions for migrating the code and validated the code by testing in Test before moving the PPM Packages to Production.
• Performed User Acceptance Test (UAT) & Training for the end user on business process and procedures based on Financials modules.
• Interacted with the client on regular basis to apprise them of the progress of the project activities.
• Coordinated with Off-shore team members.
• Coordinated with other members in the team to resolve the issue through raise a Service request (SR) TAR in Metal ink.

Confidential

Financial Functional Analyst

Responsibilities:

• Oracle Enterprise Business Suite R12.1.3 implementation.Oracle R12 GL, AP, AR, iExpenses, Cash Management
• Complete P2P and O2C cycles including EBTax, iExpenses, AGIS (Advanced Global Intercompany System), Intercompany Procurement/Sales for 6 business units.
• Responsible for implementing Accounts Payables, Receivables, Cash Management, General Ledger, Advanced Global Intercompany System for all 6 business units of K12 from requirement gathering phase to production cutover and support.
• Identified standard functionalities and gaps for Accounts Receivables, Payables, Cash Management and General Ledger including Advanced Global Intercompany System (AGIS) requirements and complete solutions.
• Set up Accounts Payables for PO matching and non-matching supplier invoices, payment profiles for check, wire and ACH, sub ledger accounting of payables transactions and transfer to General Ledger
• Set up AGIS for intra and intercompany transactions operating across 6 business units and 4 ledgers and intercompany journal upload using webADI.
• Integrated Payables and Receivables for intercompany procurement (Purchasing) and intercompany sales orders (Order Management).
• Set of Accounts Receivables for invoice transactions including auto invoicing from Order Management and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting.
• Responsible for complete tax solution and setting up EBTax and integrating with Vertex Taxware.
• Set up General Ledger, consolidation ledgers, AGIS for intercompany transactions, FSG reports
• Imported and auto reconciled of bank statement in Cash Management
• Conducted 3 CRPs, UAT and end user training
• Prepared BP 040, BP080, test scripts and BR 100 documents
• Responsible for customer data conversion, customer interface, open invoice conversion, report customizations.

Confidential

Oracle Financial Functional Analyst

Responsibilities:

• Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from mainframe legacy system using SQL Loader
• Involved in the Functional Setup of GL, AP, AR, and PO
• Month end support in financial modules AR, AP and GL
• Registration of Concurrent Programs and Request Sets in AOL and System Administration
• Identification of master data like Items / Suppliers and setting up the master data in Oracle 11i
• Customized the Invoice Aging and Customer Balance Report in AR
• Used Standard Oracle API’s to check holds on the invoice
• Gathered, analyzed and wrote detailed business requirements, user profile, created workflow processes documents and charts
• Knowledge of Performance tuning of various queries and stored procedure
• Involved in post-production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions
• Developed several BR 100s on required reports to fulfill the business need
• Configuration of new customers, new products in Order Management. Developed High Level
• Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Mass Allocations and Summary Template. Tested features Translation, Reevaluations, and consolidation. Designed FSG Report for Budget Balance, Actual Balance and Funds Available
• Involved in data conversion for data like supplier data, customer data and Address details
• Prepared end user training material with specific business cases and conducted end-user training
• Reviewed the existing reports and collected requirements to develop additional custom reports for engineering change order report, Warehouse summary report etc
• Business process study and creating business process maps using Visio for Oracle E-Business Suite GL, AP, PO and AR modules implementation
• Worked with business users to define their business requirements in preparation for developing program solutions and translated the requirements into 11i Processes
• Identified gaps between system processes and Business processes and documented using Gap Analysis Document. Also analyzed and indicated proposed workarounds and resolutions
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities