SUMMARY

• Functional Financials Consultant with over 8.5 years of total industry experience including 5 years on core ERP Applications.
• Experience includes execution of 4 full lifecycle Oracle Applications implementations including the exposure to e - Business suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
• Over 6 years of extensive experience on Oracle Financials Applications (AR, AP, GL, e-Business Tax, SLA) Executed critical projects as Business Analyst, Functional Consultant and handled Client interaction skills.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working with Oracle Applications Release 12
• Experienced in working with Project Costing, Projects Billing, Project Management
• Possess strong knowledge of Financials modules of GL, AP, AR, e-Business Tax, SLA
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Experience with Vertex and Sabrix tax ware.
• Trained the clients’ super users on the application and conducted pilot testing, integrated testing.
• Design validation & Setups of AR, GL, AR, e-Business Tax, SLA modules.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.
• Knowledge of SQL, relational database query tools (e.g. TOAD).

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles

Responsibilities:

• As part of the Production Support team - worked on handling the help desk tickets
• Routinely involved with period close and book closure activities.
• Worked on prioritizing the help desk open requests
• Worked on the support of the users for new enhancement requests.
• Supported the users for developing ad hoc reports as part of the reconciliation process
• Supported the interface issues and resolved the errors
• As part of the production support team - worked on resolving workflow issues
• Supported the users for developing of new error reporting alerts (periodic and event)
• Supported the users in resolving performance issues in the system
• Worked on the close process with the users
• Supported the streamlining of closing of the modules in oracle e-business suite
• Worked on the support of the Auto Invoice interface that loaded invoices from external sources into oracle
• Prepare pre & post-upgrade functional and validation tasks for AR, AP, e-Business Tax, SLA GL modules
• Worked on the implementation of AR, AP, e-Business Tax, SLA GL modules
• Understand AS-IS AR, AP, e-Business Tax, SLA GL system and suggest standard R12 features to replace customizations in 11i
• Worked on the implementation of Vertex Quantum and its integration with the financial modules.
• Worked on the Vendor Tax Extension in Vertex to integrate external Tax Calculation with Oracle Applications.
• Worked on the setups of Oracle e-Business Tax module - defining rates, regimes, rate to regime flows, tax codes, tax rules, exceptions, exemptions, etc.
• Created New FSG Reports, using multi currency features including foreign currencies for multi org structures.
• Prepare test cases to test post upgrade AR, AP, e-Business Tax, SLA GL
• Prepared R12 equivalent of the test scripts (TE040)
• Prepared MD050 and performed functional testing for custom report enlisting compensation details along with YTD summaries for each salesperson
• Prepared and implemented smoke test scripts to test each upgraded instance
• Assisted in rigorous testing of the upgraded instance to identify FITS and GAPS
• Assisted in End User Training and conducting Training Workshops
• Actively involved in answering user questions related to R12 environment & differences from 11i
• Actively involved in preparing cut-over activity tasks, practice upgrades & dry runs

Environment: Oracle EBS R12 (12.1.3)/11.5.10.2, AR, AP, GL, e-Business Tax, CM

Confidential, San Jose, CA

Financials Functional Consultant

Responsibilities:

• Involved in the Production Support of AR, AP, e-Business Tax, SLA GL modules.
• Coordinated with the client by providing them onshore Functional support of their daily reported production issues
• Provided 24*7 supports in co-ordination with Onshore/ Offshore model support to the business.
• Delivered excellent service and support to internal business customers, also was responsible for monitoring progress against service level agreements. Also responsible for ensuring each reported problem is resolved in a timely manner, tracked according to standards, and escalated as appropriate.
• Supported the users in AR, AP, e-Business Tax, SLA GL modules
• Worked on e-Business Tax setups including setup of tax users, tax content services, tax determination services, TCA Classifications, Oracle Tax Simulator, etc.
• Worked on a GAP Analysis between Vertex and external Tax system to convert from the existing Tax implementation to Vertex Quantum
• Coordinated activities with testing and the technical team to resolve daily reported production issues. Facilitated discussions with end-users/managers to gather functional requirements on their issues.
• Supported the Interface errors that occurred and resolved them in a timely manner
• Supported the month end and quarter end activities to help the business with the close process
• Supported the tax issues that arose between Oracle e-Business Tax and Vertex.
• Supported the business users for any enhancement requests that were raised.
• Manned the help desk ticketing system, taking ownership for issues and resolving them.
• Worked with Oracle support to open service requests - analyze the read me file, work with the DBA team to apply the patch to the patch instance, certify the patch and work on a schedule of applying it to production
• Worked on the TCA data conversions - Worked on Parties, Contacts, Accounts, Account Sites, Contacts, Contact Points, etc.

Confidential, Boston, MA

Finance Functional Consultant

Responsibilities:

• Worked on the entire Financials process including the modules of AR, AP, GL, e-Business Tax, SLA
• Worked on supporting the month end and quarter end activities
• As part of the production support team - managed the help desk queue for AR, AP, GL, e-Business Tax, SLA modules
• Worked on the setups of e-Business Tax module - defining rates, regimes, rate to regime flows, integration with Vertex Q series, defining Geo Codes, Exemptions, exceptions, etc.
• Worked with Oracle Support for managing service requests
• Worked as part of the Production Support team to manage enhancement requests from the business users
• As part of the production support team - managed the interface table errors, tracking errors, fixing them.
• Worked on managing workflow errors as part of the Production Support team
• Supported the users on performance issues as part of Production Support activities.
• Worked on supporting users by resolving workflow errors
• Supported the approval issues that arose around AME
• Supported the FSG report development in GL
• Supported the Auto Lock box interface with 3 banks
• Supported the Auto Invoice interface in AR
• Supported the integration of the Item Master with the PDH module
• Supported the users when they had performance issues with reports, forms and interfaces
• Supported the new development activities - developing enhancement code, migrating it to production, etc.
• Supported the users with developing month end and quarter end scripts for helping with error reporting
• Supported the users with developing AD hoc reports for month end and quarter end reconciliation
• Supported the integration of EDI transactions with Oracle e-Commerce Gateway, resolving issues as part of the production support team

Confidential, Chicago, IL

Finance Functional Consultant

Responsibilities:

• Worked on the entire Financials Process Flow- AR, e-Business Tax, SLA, AP, GL modules
• Worked on supporting the Month end and quarter end activities
• Came up with a close process road map for the users in order to enable smooth closing of the periods
• Fixed interface errors so as to enable smooth closing
• Worked on alerts to inform users of errors so as to proactively fix issues
• Worked on fixing workflow issues as part of the production support team
• Worked on the analysis of new requirement for enhancements from the users
• Worked with the users on prioritizing new enhancement requests for the users as part f the production support team
• Supported the users on a daily basis - managing the help desk queue, analyzing issues, prioritizing the issues, resolving the issues, having status meetings with users to keep them informed of the progress of open tickets
• Worked on customizing the reports Transaction Register (INVTRREG) to change the layout, add parameters to fit in the client requirements.
• Built a new custom report on Inventory Aging showing transaction date, sub inventory, item number, on-hand quantity and transaction type depending upon aging bucket.
• Tested the objects before sending them in for User Testing.
• Supported the GL Interface process to import journals from an external system into Oracle
• Supported the Consolidation Process in Oracle GL
• Supported the developing of several FSG reports in GL for Multi Currency reports
• Supported the Intercompany transactions process, developing the intercompany scripts, etc.
• Supported the consolidation process in GL
• Supported the Invoice Import process in AP module
• Supported the vendor interface in AP module
• AP - Worked on the AR/AP netting process and refund functionality in AP
• AR - Worked on the Auto Lock Box process
• Create the receipts and post the data into standard oracle interface tables. Created a report of records created and rejected.

Confidential

Finance Functional Consultant

Responsibilities:

• Worked on the entire Finance Functional Flows AR, AP, GL
• As a Finance Functional Consultant implemented the following modules: AR, AP, GL
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, GL modules
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in AR, AP, GL Modules.

Confidential

Finance Functional Consultant

Responsibilities:

• SPOC for the Business in resolving their day-to-day issues in AR, AP, GL
• Providing functional Support assistance to OM and AR Internal Customers.
• Actively handling Order Management & Shipping Production issues in areas like stuck SO lines, RMAs, Pick Release, Pick slip & Shipping documents, Adjustments & maintaining setups.
• Extensively worked on Receivables and configured setups for organization structure, Auto invoice, auto accounting, Receivables Activities, distribution sets, Application of Receipts to transactions and invoice printing with remit address
• Creating Service Requests & coordinating with Oracle Metalink Support for issue resolution, bug tracking, requesting back ported patches, testing patches towards defect fixes in OM, Shipping, Inventory, Pricing & Purchasing areas.
• Update the BRD’s manuals/cheat sheets on a regular basis for all the business processes.