We provide IT Staff Augmentation Services!

Oracle Apps Techno Functional Consultant Resume

3.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY

  • Over all 8+ Years of experience in Information Technology, involved in Requirement gathering, Business Process Analysis, GAP Analysis, Solution Design, Functional setups, Functional Testing, Development, and Production Support of Oracle Application modules, Oracle PL SQL, XML Publisher Reports in Windows and Unix environment.
  • Involved in SDLC and Agile methodology development projects. Working experience in SCRUM meetings and War rooms. Working experience in Jira to record works in SPRINT and Subtasks
  • Experienced in the implementation, designing customizations and extensions in Oracle Financials, and Supply Chain Modules
  • Extensive experience in preparing MD50 and MD70 documents.
  • Experienced in Data Conversion, Interfaces, Extensions, Customization and new development in Oracle Application including Oracle Payables, Cash Management, iExpense, Oracle Receivables, Fixed Assets, Oracle General Ledger, Purchasing, and Order Management.
  • Expertise in AOL, System Administration, XML Publisher/BI Publisher, Workflow, Alerts, and Trading Community Architecture (TCA).
  • Extensive experience in Oracle backend objects like Database Tables, Views, Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
  • Extensive experience in EDI functional setups and XML Publisher Administrator.
  • Developed Interfaces in e - Commerce Gateway EDI 810 and 850 to interface AR invoices and Sales Orders.
  • Experienced in Interfacing wif third party systems using ftp, sftp, MFT and TIBCO.
  • Experienced in managing the service requests (SR) and escalating wif Oracle as needed for oracle standard resolution.
  • Flexible team player wif good analytical and problem solving skills.
  • Working noledge of SQL, PL/SQL, XML Templates, Shell Script, Forms Personalization and OAF Personalization. Working and Analytical Knowledge on Oracle Reports, Oracle Workflows, SOA and OSB.

TECHNICAL SKILLS

ERP: Oracle Applications R12/11i.

ERP Technical Modules: XML Publisher, AOL, Alerts, and SYSADMIN

ERP Functional Modules: AP, CM, iExpense, AR, FA, OM, PO, and GL.

Operating Systems: Windows XP/7/8

Languages: Shell Script, SQL, PL/SQL

Databases: Oracle 8i/9i/10g

Tools: /Utilities: TOAD, Clearcase, PL/SQL Developer, Kintana, HP Quality Center, Doors, BMC, TFS, MS Office Suite, and BI Publisher

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle Apps Techno Functional Consultant

Environment: Oracle Apps R12 (12.2.4), PL/SQL, Shell Script, XML Publisher, AOL, OM, Inventory, CPQ, AR, PO, AP.

Responsibilities:

  • Analyzing existing COF and AR applications for APX products business and identifying the GAP in Oracle applications R12.
  • Preparing MD50 and MD70 for RICEW components.
  • Extensively working on the RICEW components in PO, AP, OM, AR, and CPQ.
  • Extensively working on AP, AR, FA, and GL reports development using XML Publisher and bursting concepts.
  • Extensively working on AP Payment file generation using XML templates.
  • Intensively working on OAF Personalization and changed CPQ pages.
  • Actively attending Agile Scrum meetings and recording daily tasks in JIRA.
  • Actively working on EDI810 AR outbound interfaces for list of EDI customers.
  • Preparing mapping sheets to map AR fields in Oracle R12 and GXS.
  • Involved in end to end testing of Quote to Order and Order to Cash.
  • Involving in end to end testing of EDI810 files from R12 to customers through MFT and GXS.
  • Documented the proof of concept, solution design and reviewed wif Business Leads.
  • Changed codes based on the technical design documents.
  • Created test plans, Walk through, Integration approach and strategy document, test cases, scenarios. Worked wif testing team for executing the Test scripts, investigating and Logged Variances/defects and Change Control Requests.
  • Assisted in creating the End to end Scenarios and scripts for the CAT users.
  • Involved in Production readiness including RRP, Roll-out Plan, IT/Business Certification support

Confidential - Cincinnati, OH

Oracle Techno Functional Consultant

Environment: Oracle Apps R12 (12.2.3), PL/SQL, Shell Script, XML Publisher, Inventory, PIM, AP, CM, iExpense, FA and GL

Responsibilities:

  • Actively worked on Finance Migration project, where Finance application data is migrated to different database.
  • Developed SQL queries and views to extract reports on Invoices, Assets, and Payments from the new database.
  • Developed Interfaces to load Prescribers and Products from various third party systems into Oracle applications using sql loader.
  • Converted all ftp interactions wif third party systems in sftp connections as part of security changes.
  • Extensively worked on the RICEW components in Inventory, and PIM modules.
  • Worked in security remediation project, in which security vulnerabilities were identified and resolved in Oracle PIM/Prescriber modules.
  • Intensively worked in OAF Personalization and changed PIM and Prescriber pages.
  • Documented the proof of concept, solution design and reviewed wif Business Leads
  • Prepared Development Requirements Documents and technical design documents
  • Changed codes based on the technical design documents
  • Created test plans, Walk through, Integration approach and strategy document, test cases, scenarios. Worked wif Testing team for executing the Test scripts, investigating and Logged Variances/defects and Change Control Requests
  • Assisted in creating the End to end Scenarios and scripts for the CAT users
  • Involved in Production readiness including RRP, Roll-out Plan, IT/Business Certification support
  • Created and modified MD50 and MD70 design documents for the customization and extensions.

Confidential, Cincinnati, OH

Oracle Techno Functional Consultant

Environment: Oracle Apps R12 (12.2.3), PL/SQL, Shell Script, XML Publisher, AP, CM, iExpense, FA and GL

Responsibilities:

  • Analyze business requirements and propose technical solution in Oracle Financials.
  • Extensively worked on the RICEW components in AP, FA, GL and iExpense
  • Documented the proof of concept, solution design and reviewed wif Business Leads
  • Prepared Development Requirements Documents and technical design documents
  • Changed codes based on the technical design documents
  • Create test plans, Walk through, Integration approach and strategy document, test cases, scenarios. Worked wif Testing team for executing the Test scripts, investigating and Logged Variances/defects and Change Control Requests
  • Assisted in creating the End to end Scenarios and scripts for the CAT users
  • Involved in Production readiness including RRP, Roll-out Plan, IT/Business Certification support
  • Developed data template based BI Publisher reports
  • Created and modified MD50 and MD70 design documents for the customization and extensions.

Confidential, Schaumburg, IL

Oracle Techno Functional Consultant

Environment: Oracle Apps R12 (12.1.3), PL/SQL, Shell Script, PO, AP

Responsibilities:

  • Functional analysis for Separating and deploying new Org structures, involving configuration for Purchasing Track
  • Analyze business requirements and segregate them into Use Cases. Created Use case diagrams, activity diagrams using Microsoft Visio, PowerPoint
  • Documented the proof of concept, Solution design and reviewed wif Business Leads
  • Participated in data modeling, planning, designing, and implementation of the final system. Produced data mapping and data definition documentation
  • Prepared Development Requirements Documents and technical design documents
  • Developed plsql codes and shell script programs based on the technical design documents
  • Create test plans, Walk through, Integration approach and strategy document, test cases, scenarios. Worked wif Testing team for executing the Test scripts, investigating and Logged Variances/defects and Change Control Requests
  • Assisted in creating the End to end Scenarios and scripts for the CAT users
  • Involved in Production readiness including RRP, Roll-out Plan, IT/Business Certification support
  • Followed BMC Change Management process for correcting software bugs and deficiencies based on the testing results and released to the Production environment

Confidential, Schaumburg, IL

Oracle Techno Functional Consultant

Environment: Oracle Apps R12 (12.1.3), PL/SQL, Shell Script, XML Publisher, AP, CM, iExpense, and AR

Responsibilities:

  • Functional and Technical analysis for enhancements in existing R12 system in Oracle Finance Modules.
  • Involved in design documentation and functional setups for AR EDI 810 and implemented in an Oracle R12 application.
  • Coordinated wif GXS/FMW team to identify proper EDI mapping based on the business requirements for various MSI customers.
  • Involved in requirements gathering, design documentation and functional setups for AP Payments for various Operating Units.
  • Coordinated wif GXS/FMW and Real time Bank IT team to identify proper fields required for payment files that needs to be sent to make payments to MSI suppliers.
  • Interfaced the Payment files and AR Invoice EDI files to third party systems using sftp connection.
  • Review the codes developed by developers and provide comments if any changes needed. Developed codes and Helped developers to complete development on time.
  • Assisted in creating the End to end Scenarios and scripts for the CAT users
  • Involved in Production readiness including RRP, Role-out Plan, IT/Business Certification support
  • Followed BMC Change Management process for correcting software bugs and deficiencies based on the testing results and released to the Production environment
  • Worked wif oracle support team through Oracle SR’s to release patches and upgrades in R12.

Confidential

Oracle Applications - Developer

Environment: Oracle Apps R12 (12.1.3), PL/SQL, Shell Script, XML Publisher, AR, AP and iExpense

Responsibilities:

  • Technical analysis for Implementing Finance Transformation project in Oracle R12.
  • Involved in design documentation and technical documentation for various Finance modules interfaces and extensions
  • Involved in Proof of Concepts and identified technical solutions for various business requirements
  • Involved in SQL/PLSQL, UNIX Shell Script coding to deliver RICEW components based on customer requirements in Accounts Payables, Accounts Receivables, Purchasing and Order Management.
  • Developed XML Publisher Reports for various customer facing reports
  • Involved in customising Oracle Invoice Printing and Statement Printing using XML Publisher
  • Created unit test documents, executed unit testing and documented test results.
  • Provided Knowledge Transfer to End Users and Support Team
  • Involved in Production readiness including, Role-out Plan, IT/Business Certification support
  • Followed BMC Change Management process for correcting software bugs and deficiencies based on the testing results and released to the Production environment

Confidential

Oracle Applications - Functional Tester

Environment: Oracle Apps R12 (12.0.1), PL/SQL, HP Quality Centre, OM, and AR

Responsibilities:

  • Interacted wif clients and BSA’s to understand the custom requirements
  • Prepared test cases and scenarios based on custom requirements
  • Prepared Standalone and End to End test scenarios to test standard OM and AR functionalities
  • Executed test cases, test scenarios and reported the defects in HP Quality Centre
  • Organized war room meetings between implementation team and testing team and discussed issues identified and possible functional solutions

Confidential

Oracle Applications - Tester

Environment: Oracle Apps 11i, PL/SQL, HP Quality Centre, OM, and AR

Responsibilities:

  • Prepared test cases and scenarios based on custom requirements
  • Prepared Standalone and End to End test scenarios to test standard AP, iExpenses, AR and GL functionalities
  • Executed test cases, test scenarios and reported the defects in HP Quality Centre
  • Tested end to end scenarios for Procure to Pay functionalities
  • Tested end to end scenarios for Order to Cash functionalities.
  • Involved in Regression testing.

We'd love your feedback!