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 ERP: Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, iExpense, Sys Admin, SLA, P2P, O2C and A2R.

Other Tools: Web ADI, Toad, Data Loader, Discoverer, OBIE, SQL*Loader, SQL*Plus and MS Office.

PROFESSIONAL EXPERIENCE

Confidential - Tacoma, WA

Oracle EBS Financial Functional Consultant

Responsibilities:

• 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.
• 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, Portland, OR

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.
• Designed and implemented Revenue recognition contingencies for client specific requirements
• Worked on integration of Payments with Wells Fargo bank.
• Implemented solution to handle point of sales/Disti revenue & cogs with a custom bolt on for third party system ‘ Azerity’

Confidential - Fond du Lac, WI

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 validationrules 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.
• 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)
• 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, Richmond VA

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, Herndon VA

Financial Functional Analyst

Responsibilities:

• 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).
• 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, Baltimore, MD

Oracle Financial Functional Analyst

Responsibilities:

• 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
• 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