Oracle-revpro Consultant Resume
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.