SUMMARY

• 12 years of IT experience with 7 years of experience in Oracle Applications R12.1.3,R 12.0/11.5.10.2/11.0.3.
• Functional Analyst with experience in leading ERP system implementations in Service provider, Insurance and Telecommunications sectors.
• In depth understanding of Oracle Modules GL, AR, AP, PO, SLA, IProc, Isupplier, Iexpenses, INV.
• Developed Functional documents in support of global system implementations using SDLC/AIM methodology.
• Responsible for business analysis, conversions, design of functional/technical requirements for process improvements, custom requirements and development of Solution Design documents using AIM, RICEW Methodology.
• Experience in conducting Conference Room Pilot (CRP) demos of the proposed solution, and User Acceptance Testing (UAT).
• Experience in post production support for Oracle Financials modules for month end closing, bug fixes, user training and enhancements.
• Experience in working with Oracle Support - TAR/SR management, Enhancement Request and issue resolution.
• Good knowledge of P2P and O2C cycles.
• Knowledge of Oracle Tools such as Toad, SQL Developer.
• Good communication, Presentation and Strong interpersonal skills, ability to interact with people at all levels.

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

Sr. Oracle Functional Analyst (P2P)

Environment: Oracle Apps, R12.0.1, R12.1.3 modules (GL, AP, CE, AR, PO, IProc, Eb-Tax, IBY, SLA, ISupplier, INV)

Responsibilities:

• Worked on as P2P functional Analyst for upgrade project from Oracle Apps R12.0.1 to R12.1.3.
• Analyzing, Designing, Modeling, Testing, and implementation activities within the areas of GL,AP, CE, AR, PO, IProc, Eb-Tax, IBY, SLA, ISupplier, modules.
• Provide guidance and recommendations for process enhancements and efficiencies for the financial modules within the Oracle ERP.
• Understand the business implication of technical solutions and assists in defining and document the technology solution to support any future business needs.
• Focused on a full-cycle P2P testing from iProc, PO, AP, EB-Tax, to Payment.
• P2P:Coordinated with R2R’s testing by flowing data to FA, CM, AP and PO and assisted Finance’s period-closing.
• PO: Prepared BR100 doc deliverables;
• PO: Wrote CRP, UAT Test Cases and Assisted QE’s in automated testing and facilitated production migration.
• PO: Worked New or existing PO and AP report enhancement requirement gathering, report design template submissions;
• Iproc: Reviewed MD050 for customizations;
• AP: Wrote MD50 on PO vendor Automation and helped in MD070 design spec doc.
• AP: Assisted in AP Invoice Automation and Invoice Imaging project’s UAT’s.
• Coordinate, collaborate, and work alongside other IT and business areas to ensure a properly configured and maintained upgraded system.
• Worked on production support after go-live and bug fixing.

Confidential, Portland, OR

Sr. Oracle Functional Analyst (P2P)

Environment: Oracle Apps R12.1.3 modules (GL, AP, PO, AR, I-exp, Iproc SLA, EBtax, FA)

Responsibilities:

• Worked Business transformation implementation project (3millon) from SAP to Oracle Apps R12.1.3.
• Worked on cross function business requirements gathering documents.
• Collaborate with senior management in legal, Risk management, Controllers and Finance to ensure Sarbanes Oxley (SOX) compliance.
• AP: Implemented ACH payment Methods through BOA.
• AP: Implemented and customized remittance advice to vendors about the payments through email.
• AP: Worked on Integration of electronic invoice image with oracle Payables module using Documentum through Form personalization.
• AP: Designed Expenses Templates for employee expenses.
• AP: Designed PPP (Payment process profiles) and PPR (Payment Process Request).
• AP: Developed MD50 and customized NACHA EFT bank formats for several countries for electronic funds transfers as per bank specification.
• AP: Wrote on the MD50 on Invoices conversions from SAP to Oracle.
• CE: Functional setup of internal and external banks.
• CE: Designed and implemented Check, ACH and Wire reconciliation process for AP Payments through Cash Managements.
• CE: Implemented cash transfer process structure for internal banks.
• PO: Implemented sourcing functionality.
• PO: Designed MD50 and develop business flow on the CVMI Process.
• PO: Designed MD50 and worked on the PO Autocreate workflow customization.
• PO: Desined new Inbound interfaces on PO’s with GUI interface for user access.
• Iproc: Implemented punch cards.
• Oracle Support- TAR/SR management.
• Used HP quality center for all tickets and defects.

Confidential, TN

Sr. Oracle Functional Analyst (P2P)

Environment: Oracle Apps R12.0.3 modules (GL,AP,PO, AR, I-exp, SLA, EBtax, FA)

Responsibilities:

• Successfully upgraded from Oracle Apps 11.5.10.2 to R12.0.3.
• Led four CRP sessions, Conducted User training sessions and documented training scenarios for R12 Upgrade.
• AP: Developed and customized NACHA EFT bank formats for several countries for electronic funds transfers as per bank specification.
• AP: Implemented and customized remittance advice to vendors about the payments through email.
• AP: Worked on Integration of electronic invoice image with oracle Payables module using Documentum through Form personalization.
• AP: Designed Expenses Templates for employee expenses.
• AP: Designed PPP (Payment process profiles) and PPR (Payment Process Request).
• AP: CE: Functional setup of internal and external banks.
• CE: Worked on mapping sets, transaction code and system setup.
• CE: Designed and implemented Check, ACH and Wire reconciliation process for AP Payments through Cash Managements.
• CE: Implemented cash transfer process structure for internal banks.
• Eb-Tax: Implemented recoverable tax for CANADA.
• PO: Implemented sourcing functionality.
• PO: Implemented new Inbound interfaces on PO’s with GUI interface for user access.
• IExp: Implemented Offline Speardsheet.
• IExp: Design and Implemented Credit card transactions interface from Chase, BOA.
• Iproc: Functional Setup and support for iproc.
• Worked on Multi-Language and Multi Currency ERP environments.
• Functional Specs BR30, BR100 and MD50 for various modules.

Confidential

Oracle Functional Analyst

Environment: Oracle Apps 11.5.10.2 modules(GL,AP,PO, AR, I-exp)

Responsibilities:

• Gathered requirements and prepared the Business Requirement document, Set up documents (BR100), Conversion documents (CV40), Functional Specification documents (MD50) for all customizations, extensions and reports for GL, AP, and AR.
• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.
• GL: Defined new Ledgers, Calendar and Currencies.
• GL: GL: Customized FSG and RXI reports.
• AP: Worked on implementation of electornic payments
• AP: Created new menu’s, responsibilities and security rules.
• AP: Implemented payment methods for ACH and Wire.
• AP: Worked on Positive Pay file feed to bank.
• FA: Implemented Physical Inventory.
• AR: Worked on Auto accounting on AR invoices.
• AR: Designed and implemented transaction types, transaction sources, Receipts and Remittance.
• I-Exp: Defining new policy rules for meals and accommodation.
• I-Exp: wrote MD50 on the credit card transaction interface.
• Performed core configurations for GL, AP and AR and assisted with other system administrative tasks.
• Provided post go-live support to the Oracle Financials modules.
• Oracle Support- TAR/SR management.
• Conducted User training sessions and documented training scenarios.

Confidential

Jr. Oracle Functional Analyst

Environment: Oracle Apps 11.0.3 modules(GL,AP,PO, AR,INV)

Responsibilities:

• Responsible for configuration, and testing of Oracle 11.0.3 core various modules and all associated documentation using the RICE methodology.
• AP: worked on writing MD50 document for the workflow and send Notification to appropriate managers when employee expense is ready for approval.
• AR: Conversion of existing customer information (customers addresses, contacts and phone numbers) using Customer Interface.
• GL: Implemented Journal approval structure.
• GL: Involved in developing new DFF’s, Value Sets and Values for supporting the reports developed.
• GL: Defined Set of Books, Calendar and Currencies.
• GL: Defined Security rules and cross validation rules.
• PO: Implemented new Inbound interfaces on PO’s with GUI interface for user access.
• Performed various AP/AR configurations.
• Involved in requirement gathering and prepared functional document (MD50) for new extensions and customizations. Also prepared BR100 for setups.
• Experience with SQL*Loader, UTL FILE, Oracle Export and Import utilities.
• Worked in the support role, performed the responsibility of system administration tasks like creating users, setting up the user profile etc
• Oracle Support- TAR/SR management.

Confidential - Louisville, KY

Testing Software Engineer

Environment: COBOL, CICS, JCL, DB2, VSAM, File-Aid, QMF, SPUFI, ISPF. File Manager, JCL/Proc, VS COBOL-II, Xpeditor.

Responsibilities:

• Responsible for designing, writing test scripts and testing of online CICS navigations.
• Responsible for running the test scripts for CICS navigations.
• Maintain quality process in analyzing table matrices for data base.
• Performing unit testing for CICS.
• Impact analysis of JCL programs.
• Involved in user training.
• Working on the production support.

Confidential - Ashburn, VA

Testing Software Engineer

Environment: COBOL, CICS, JCL, DB2, VSAM

Responsibilities:

• Worked for Networx 6.2 and 6.3 release for integrating validations and developing new messages.
• Developed new messages which involves Coding and Unit testing CICS module.
• Executing the test cases.
• Involved in quality processes such as collecting and analyzing the DB2 related table metrics.
• Responsible for designing and running test scripts for online CICS navigations.
• Impact Analysis of COBOL Programs.
• Involved in reviewing, analysis of coding standards.