We provide IT Staff Augmentation Services!

Oracle-revpro Consultant Resume

0/5 (Submit Your Rating)

SUMMARY:

  • Around 15 years of IT experience of which recent 14 Years in Oracle Applications 11i/R12, Revenue Recognition (Revpro 2.4/3.0) and 14 months in Oracle (8i/9i) & Developer 2000.
  • Responsible for various phases of implementing such as analysis, design, coding and documentation.
  • A forward thinking, capable and committed SME with a proven ability to meet agreed deadlines, co - ordinate work and work to defined methodologies within a structured environment.
  • Focused on any task at hand and able to utilize existing Oracle Apps knowledge and experiences to come up with practical solutions and alternatives to ERP processes.
  • Having first class executive leadership, negotiating and communicating skills and capable of providing authoritative guidance and advice to both in house nad third party teams.

TECHNICAL SKILLS:

ERP Oracle Applications: 11i/R12, O2C/P2P cycles Cycles Order To Cash (Quote to order Pocess) Procure To Pay Modules SCM, OM (Service contracts, IB), AP, AR, GL, INV, PO, PA, AOL Oracle pricing &advanced pricing

Databases: Oracle 8i/9i

Languages: SQL, PL/SQL

GUI Tools: Developer 2000 (Forms 6i, Reports 6i)

Operating Systems: Windows NT/98/95, Win 2000

Tools: SOA, BPEL, REVPRO 2.4/3.0 with configuration, VSOEReserve Tool:SQL* Loader, UTL File, TOADDocumentation AIM/Agile

PROFESSIONAL EXPERIENCE:

Confidential

Environment: REVPRO 2.4/3.0 (ASC606) With Oracle Applications 11i/R12 Order To Cash Flow, AP, AR, PO, OM, IB, SERVICE CONTRACTS, GL, INV, Oracle Forms& Reports 6i, SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD, WINSCP and Putty.

Oracle-Revpro Consultant

Responsibilities:

  • Interaction with Business & End user on Daily basis .
  • Analyzing Project Enhancements/CRs.
  • Functional/Technical documentation.
  • Order-Cash To Revpro full Life cycle
  • Revenue Recognization using REVPRO 2.4/3.0
  • Involved in BRD preparation and Revpro Configuration
  • OM and AR Integration with REVPRO 2.4/3.0.
  • Upload events to recognize revenue per new guidance to arrive at retained earnings
  • Load only lines with Def balances from ASC605 to ASC606
  • Upload new lines to ASC606 to account for carve amounts on the lines with carve def balance
  • Upload transactions with def balances to 3.0 in Period
  • Upload events for Revenue and carve lines to get to ASC605 balances.
  • Reconcile ASC605 and ASC606 balances
  • All recognition on conversion lines are controlled manually using events upload
  • Working on Revenue/Waterfall Reports
  • Coding using PLSQL
  • Unit Testing.

Confidential

Environment: Oracle Applications 11i (11.5.10) with SCM AP, AR, PO, OM, IB, SERVICE CONTRACTS, GL, INV, WSH, REVPRO Oracle Forms& Reports 6i, SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD, WINSCP and Putty.

Oracle-Revpro Consultant

Responsibilities:

  • Interaction with Business & End user on Daily Tickets .
  • Analyzing Project Enhancements/CRs.
  • Functional/Technical documentation.
  • Order To Revpro full Life cycle
  • Revenue Recognization using REVPRO 2.4
  • OM and AR Integration with REVPRO 2.4.
  • Coding using PLSQL
  • Unit Testing.

Confidential

Environment: Oracle Applications 11i (11.5.10) with SCM AP, AR, PO, OM, IB, SERVICE CONTRACTS, GL, INV, WSH, REVPRO Oracle Forms& Reports 6i, SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD, WINSCP and Putty.

Techno Functional consultant

Responsibilities:

  • Analyzing Project Enhancements/CRs.
  • Functional/Technical documentation.
  • Order To Cash full Life cycle
  • FireEye Corporate Bookings Cycle
  • Order uploads from OM (Service Contracts, IB) to REVPRO2.4.
  • Revenue Recognization using REVPRO 2.4
  • OM and AR Integration with REVPRO 2.4.
  • Resolving daily tickets and worked on monthly new releases on SCM, OM, modules.
  • Inventory management for fireeye products
  • Coding using PLSQL
  • Unit Testing.

Confidential

Environment: Oracle Applications 11i (11.5.10) with SCM.AP, AR, PO, OM, IB, SERVICE CONTRACTS, GL, INV, WSH, REVPRO Oracle Forms& Reports 6i, Discoverer 4i, XML Publisher, SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD, WINSCP and Putty.

Technical consultant

Responsibilities:

  • Interaction with Business & End user on new Enhancements.
  • Analyzing Project Enhancements/CRs.
  • Technical documentation.
  • Confidential Order Management full Life cycle
  • Techno functional role on Supply chain management (SCM )
  • Order uploads from OM (Service Contracts, IB) and Create-management of new order holds Air-watch account.
  • OM-AR interaction technical support.
  • Resolving daily tickets and worked on monthly new releases
  • Coding using PLSQL
  • Unit Testing.
  • Coordinating with the offshore team with daily status calls.
  • Developed Concurrent Programs, Value Sets & Request Sets based on the business requirements.
  • Unit Testing - Test cases preparation execution .

Confidential

Environment: Oracle Applications (R12 (12.1.3)), SCM,AP, AR, PO, OM, GL, INV, WSH Oracle Forms& Reports 6i/10g, Discoverer 4i, XML Publisher, SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD, WINSCP and Putty.

Responsibilities:

  • Gathering/Analyze Business Requirements.
  • R12 setups and configuration.
  • Prepared CV40 and CV60 documents using AIM methodology.
  • Worked On Item Conversions(INV Module) from PeopleSoft and Agile system.
  • Worked on BOM Conversion from Siebel, PeopleSoft and Agile system.
  • Developed conversion code using advanced PLSQL.
  • Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders in P2P cycle into Production.
  • Designed interface/conversion mapping, pre-production testing, and related documentation.
  • Coordinating with the offshore team with daily status calls.
  • Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables- Order To Cash Full cycle.
  • Worked with interfaces from AP to PA (Project Accounting).
  • Developed Concurrent Programs, Value Sets & Request Sets based on the business requirements.
  • Unit Testing, Test cases preparation execution (HPQC/ALM).

Confidential

Environment: Windows NT, Oracle 9i-PL/SQL, Oracle Applications 11i, SCMOM,INV,PO, Service contracts, IB,VSOE, REVPRO.

Technical consultant

Responsibilities:

  • Interaction with Business And End user on new Enhancements.
  • Analyzing Project Enhancements in SCM, O2C,P2P flow.
  • Order uploads from OM (Service Contracts,B) toVSOE/REVPRO2.4.
  • AR interactions with VSOE/REVPRO 2.4.
  • Reserve linking/de-linking with Orders.
  • OM and VSOE integration with REVPRO 2.4
  • OM to REVPRO2.4 (BYOL) Integration
  • Coding using PLSQL
  • New Requirement Gathering
  • Technical coding and review.
  • Unit Testing.

Confidential

Environment: Windows NT, Oracle 9i- PL/SQL, SCM,OM,VSOE, RAOracle applications 11i. EDW, Oracle Assistant.

SME

Responsibilities:

  • Interaction with Business And End user on requirements and data migrations process.
  • Preparation of Functional/Technical Documents.
  • Prepared Custom API’s (Advanced PL/SQL) for Data Migration.
  • Order Management (OM )mappings and validations.
  • Worked on Data mappings (Source-Target).
  • Test cases preparation & Execution.

Confidential

Environment: Windows NT, Oracle 9i-PL/SQL, OracleApplications 11i, Forms 6i, Reports 6i, OM(ServiceContracts,IB),INV,PO,IB,VSOE, REVPRO.

Onsite SME

Responsibilities:

  • Interaction with Business And End user on new requirements and existing issues.
  • Preparation of Functional/Technical Documents.
  • Tickets on OM (quote to order creation process), Service contracts, PA,AP,AR,GL,INV,PO, IB Modules.
  • Project accounting tasks, OM-PA data extractions, data conversions .
  • R12 Config Orders tickets.
  • Tickets on CTO/PTO orders.
  • Working on Tickets in Finance and manufacturing modules. .
  • Leading Offshore team in Business functionality explanation and Development, Technical Support.
  • Analyzing Project Enhancements.
  • New Requirement Gathering
  • KT Sessions to Offshore team.
  • Unit Testing.

Confidential

Environment: Windows NT, Oracle 9i-PL/SQLForms 6i, Reports 6i, Oracle Applications 11i

Onsite TAAC

Responsibilities:

  • Interaction with usiness And End user on new requirements and existing issues.
  • Preparation& Review of Functional/Technical Documents.
  • Leading Offshore team.
  • Interfaces/conversions&Reports in OM, AP, AR, GL, PO modules bu and Data migration-Technical Support.
  • Analyzing Project Enhancements.
  • New Requirement Gathering
  • Unit Testing.

Confidential

Environment: Windows NT, Oracle 9i-PL/SQL, ADF, Forms 6i, Reports 6iOracle CRM, Oracle apps 11i.

Technical Consultant

Responsibilities:

  • Interaction with Business And End user on new requirements and existing issues.
  • Involved in Project Normalization support .
  • Developed Interfaces, Conversions, Reports.
  • Data Migration.
  • Tickets on OM,IB,INV,PO.
  • Leading Offshore team in Business functionality explanation and Development.
  • Handled Change Requests.
  • Worked with Reconciliation Team .
  • KT Sessions to Offshore team.
  • Unit Testing-Test Cases Preparation.

Confidential

Environment: Windows NT, Oracle 9i, Forms 6i, Reports 6i, Oracle CRMOracle apps 11i.

Technical Consultant

Responsibilities:

  • Forms Customization.
  • Workflow Customization.
  • Oracle Report.
  • PLSQL Coding.
  • Interfaces development.
  • Support tickets.
  • Documentation.
  • Unit Testing

Confidential

Environment: Oracle applications R12(OM,PO,IB,AP,AR,GL,WMS), SOA, BPEL.

Technical Consultant

Responsibilities:

  • Interfaces(Inbound/Out bound) in OM,INV,PO Modules.
  • Data Extractions in PA,AR Modules-PLSQL coding.
  • Prepared technical documents for SOA/BPEL interfaces.
  • Techno Functional Role in OM,PO Module Oracle Apps R12.
  • Worked in Mobile Applications.
  • Coding in OM,IB,GL,AP,AR,WMS.
  • RSV,CDDDocumentation.
  • Unit Testing.

Confidential

Environment: Oracle applications R12 (OM,IB,AP,AR,GL,INV), SOA, BPEL.

Technical Consultant

Responsibilities:

  • Analyzing MD50,MD70.
  • Conversions using SQL Loader.
  • Interfaces in OM,AP Modules Oracle apps R12.
  • Data Extractions in PA,AR Modules PL/SQL.
  • Forms Customization.
  • Workflow Customization.
  • Oracle Reports.
  • Worked with OM,INV,AP,AR,GL,IB,WMS.
  • Prepared technical documents for SOA/BPEL interfaces.
  • Advance Pricing (Qualifiers-Modifiers).
  • Unit Testing.

Confidential

Environment: Windows NT, Oracle 9i, Forms 6i, Reports 6iOracle CRM, Oracle apps 11i.

Technical Consultant

Responsibilities:

  • Conversions from BAAN System.
  • Interfaces PL/SQL.
  • Forms Customization.
  • Data Migration.
  • Oracle Reports.
  • Prepared technical documents for interfaces and conversions
  • Unit Testing.

Confidential

Environment: Windows NT, Oracle 9i, Forms 6i, Reports 6iOracle CRM, Oracle apps 11i.

Developer

Responsibilities:

  • Interfaces, Extractions in PA,AR Modules.
  • Project accounting: tasks, projects, labor hour rate calculation, conversions.
  • Oracle Reports.
  • Technical Support PL/SQL.
  • Unit Testing.
  • Documentation.

We'd love your feedback!