PROFESSIONAL SUMMARY:

• 9+ Years of strong experience as Oracle Procure - To-Pay and Order-to-cash Functional Analyst
• Experience in Implementing, Customizing, Configuring and post production support of Oracle Applications versions R12.
• Extensive Functional expertise in Purchasing (PO), Accounts Payables (AP), General Ledger (GL), Cash Management, Account Receivables(AR), FA, E Business Tax modules.
• Experienced in documenting Functional Design Documents and Unit test scripts following Oracle Application Implementation Methodology (AIM).
• Efficient work experience in leading on-site and offshore teams in implementation and support projects. Extensively worked with business users.
• Experienced in developing test cases to meet the system objectives and involved in System and Integration Test Plans (SITP) and User Acceptance Testing (UAT).
• Technical expertise in Implementation and Support of Oracle EBS using SQL, PL/SQL, Oracle Reports, BI/XML Publisher Reports, Oracle Form Personalization, Oracle Application Framework(OAF)
• Responsible for functional support and ad-hoc training in respective oracle modules and act as a liaison between technical team and users.
• Proven track record of demonstrating strong analytical and problem-solving skills, proficiency, and ability to follow through with projects from inception to completion.
• Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint, Visio) and preparing End-User training documentation using UPK-Universal Productivity Kit Oracle tool.
• Superior communication, organizational, and interpersonal skills.
• Knowledge of converting legacy data into Oracle Applications using SQL Loader and PL/SQL.
• Expertise in SQL, PL/SQL, Stored Procedures, Oracle Reports in XML Publisher 5.6.2.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12.1.3, 12.2.2

Databases: Oracle 8i/9i/10g and 11g

ERP Functional Modules: PO, AP,GL,CM,FA & E business-Tax

Oracle Tech Stack: Web- Adi, XML Publisher 5.6.2

Programming Languages: SQL, PLSQL, HTML, XML

Operating Systems: Windows and UNIX

Test Management & Defect Tracking Tools: Quality Center, QC ALM

Defect Tracking Tools: Quality Center, QC ALM

Version Control: Serena PVCS

Tools: TOAD, SQL-Navigator, and SQL Loader

PROFESSIONAL EXPERIENCE:

Confidential, Austin

ERP version: R12 e-business Suite

Responsibilities:

• Involved in testing Multiple integrations along with outbound and Inbound Interfaces from different platforms like RMB & Metavance based on the design.
• Performed the end to end regression testing along with the new organization.
• Worked on end to end testing for P2P & O2C Processes for 12.1.3 upgrade (from 12.2.2) and resolved few upgrade issues.
• Worked on CPU Patch Testing.
• Provided Production Support to resolve issues for P2P & O2C modules.
• Worked on AP Invoice Interface and Reverse Feed of Payment through SFTP and other Processes.
• Involved in changing the process for Journal Approval Workflow & Attachment
• Set up EB-Tax as per Tax requirement including the testing of the entire cycle.
• Helped in Developing BI Report for reporting Tax Variance between Tax Amount Interfaced and calculated Tax Amount according to EB Tax setup.
• Worked on Rolling out the P2P Sub-Ledgers process to newly created Operating Units including Setting up iProcurement and Catalog Punch out process.
• Configured, tested and deployed the complete punchout process from Office max to Office Depot.
• Helped User to resolve the Bank Reconciliation Issue.
• Worked on Requisition Change Order Process (RCO) - Custom Process impacting PR, PO&AP, AME, Approvals/Notifications and Reporting.
• Worked on Enhancements covering P2P and O2C modules.

Confidential

ERP version: R12 e-business Suite

Responsibilities:

• Preparing Detailed Test Scripts as per AIM Methodology in accordance with the business flows for User Acceptance Test (UAT)
• Worked on configuring the Approval Management Engine for different levels of approval hierarchies.
• Designed the flow of P-Card for I procurement requisition forms.
• Configuring the CRP2 instances in accordance with the Configuration Documents.
• Studying the Existing business practices of the client as part of As Is Study.
• Presenting the overview of the Oracle General Ledger and Oracle Payables modules to key users
• Designing the solution to meet the business requirements as part of To Be Flows.
• Exhaustive training on the GL and AP modules to key users
• Collecting inputs and providing the specifications to technical team to develop the reports for the client.
• Collection of the necessary master data and setting up Oracle Financials in Production, Test and Dev instances to meet the requirements of the client.
• Designing the conversion strategy for Data Conversion from legacy systems.
• Facilitating the Testing of the solution (designed as a part of To Be) by users in Conference Room Piloting.
• Conversion of Data from Legacy system to GL, AP and AR.
• Segregation of Responsibility to the different levels of users.
• Post Production Support.

Confidential

ERP version: Oracle Fusion R11

Responsibilities:

• Responsible for configuring Fusion Accounts Payables module
• Responsible for preparing Configuration documents, Test scenarios and testing standard functionality.
• Worked very closely with the Business Users and Finance team for on-demand requirements and User Acceptance Testing.
• Conducted end user training in Fusion Accounts Payables.

Confidential

Responsibilities:

• Analyze existing business systems for the Order to Cash cycle and document ‘AS-IS’ Business processes
• Analyze future process flows mapping business requirements to the functionality provided by Oracle for the following modules - Oracle Order Management, Shipping & Accounts Receivable
• Conducted CRP’s UAT’s and User Trainings
• Identify gaps that cannot be accommodated using standard Oracle and suggest alternatives or workarounds
• Document high-level & detailed specifications for the customizations identified
• Present CRP sessions to the client for user sign off
• Provide training to the core team users
• Model the customer structure/hierarchy using Trading Community Architecture
• Integration of shipping with custom mobile applications built for hand-held devices.
• Develop specifications for complex pricing formulas to be used in Pricing modifiers
• Coordinate with the technical team for conversion of customers, customer item master cross reference, Open Orders in OM & Open Invoices in AR
• Set up and configure Order Management, Shipping & Accounts Receivable modules
• Wrote and modified functional documents for converting data from Legacy to Staging tables and Staging tables to base tables according to business rules and validation using Oracle AIM Methodology.
• Configured for event-based revenue management.

Confidential

Functional Anlyst

ERP version: R12 General Ledger and R12 Account Payables

Responsibilities:

• Production support for any functional issues faced by our client.
• Taking care of the escalated issues from other Teams Members relevant to Fin modules.
• Actively involved in supporting Month End closing activities and ensure month end close is done within stipulated time
• Raising SR & following up with the Oracle Support.
• Undertaking all steps necessary to satisfactorily closure of the tickets raised by clients after confirmation of the users.
• Raising the Change Request for new client requirements, obtaining the client approval & getting the same developed from the Technical Team.
• Carrying out the testing on the UAT instance & finally passing on the same to the Production.
• Supporting and solving day-to-day end Users problems and Performing Week/Month end Reconciliation activities.

Confidential

Responsibilities:

• Support activities like bug-fixes, patch analysis, user training for Oracle sourcing and iProcurement.
• Production support for any functional issues faced by our client.
• Taking care of the escalated issues from other Teams Members relevant to Fin modules.
• Actively involved in supporting Month End closing activities and ensure month end close is done within stipulated time
• Raising SR & following up with the Oracle Support.
• Undertaking all steps necessary to satisfactorily closure of the tickets raised by clients after confirmation of the users.
• Raising the Change Request for new client requirements, obtaining the client approval & getting the same developed from the Technical Team.
• Carrying out the testing on the UAT instance & finally passing on the same to the Production.
• Supporting and solving day-to-day end Users problems and Performing Week/Month end Reconciliation activities.

Confidential

ERP Version: R12 Purchasing, Payables

Responsibilities:

• Used form personalization to customize forms including form validations, defaulting values, providing user messages etc.,
• Worked with Oracle Support to resolve inconsistencies in Accounts Payable Trial Balance & Purchasing Accrual Reconciliation Report.
• Worked on designing the payment templates and processes for different methods including EFT, WIRE & Clearing.
• Enabled the Approvals for invoicing based on the approval rules and limits.
• Trained users on creating the prepayments Invoices as a workaround for petty cash Expenses.

Confidential

ERP Version: R12

Responsibilities:

• Trained in accounts and Oracle Financials
• Trained in SQL/PLSQL
• Trained in creating Oracle Deliverables (BR100, TE040, MD050)
• Worked as a Associate consultant with clients in designing the functional specs for their business requirement
• Trained in raising SR & following up with the Oracle Support.
• Trained in Month end close process in all the financial modules like GL, AP, AR, CM, FA