Sr. Oracle Consultant Resume
4.00/5 (Submit Your Rating)
Cleveland, OhiO
EXPERTISE SUMMARY:
- 5+ years of experience in Oracle apps SCM Functional which includes Design, Documentation, I mplementation and Application Support.
- Expertise in the entire System Development Life Cycle and experienced with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Go - live and Post-Implementation Support.
- Utilized AIM methodology for Business Flows in different phases of the project including Requirement Gathering, Solution Design and User Training.
- Involved in understanding the business process, to study and analyze the business requirements and delivered process mapping with standard application.
- Coordinated with technical team for custom extension development as per functional design and involved in testing the application.
- Involved in handling the integration with other modules and user acceptance testing. Provided training support to end users.
- Involved in application implementation and worked on application support both onsite and offshore.
- Good knowledge on preparation of SQL statements.
- Involved in preparation of Applications Implementation Methodology (AIM) documents including: RD050, MD020, BR100, MD050, TE-40 etc.
- Ability to grasp new technologies quickly and adapt to the same. Good Communication, collaboration & Team building skills with proficiency in grasping new concepts quickly and utilize the productive manner.
- Good knowledge on Procure to Pay (P2P) and Order to Cash (O2C) Business flows.
- Involved in Implementation of Self-Service modules iProcurement and iSupplier.
- Proficient in Oracle Supply chain modules Inventory, ASCP,WMS,BOM, WIP, Costing, Purchasing, Order management, Advance Pricing, iSupplier and iProcurement. Good knowledge in Finance modules (AP, AR and GL).
- Performed numerous designs for Conversions and interfaces from legacy systems/third party systems into Oracle Applications.
- Coordinated with Oracle Support, creating SRs, attending OWC sessions, providing 24X7 support for quick resolution of high prioritized issues.
- Coordinated with offshore / Onsite team to fix other modules issues.
- Involved in resolving day to day Oracle product issues faced by end users. Fixing the basis of tickets raised by them in ticket tracking tool.
- Worked on different tools like Toad, Data loader, Visio and Discoverer etc.
TECHNICAL SKILLS:
Languages: SQL, PL/SQL
Tools: Toad, Visio, Data Loader and Discoverer.
Operating System: Windows and XP.
Software Package: Microsoft Office 2016(word, Excel and PowerPoint)
PROFESSIONAL EXPERIENCE:
Confidential, Cleveland, Ohio
Sr. Oracle Consultant
Responsibilities:
- I was responsible for Purchasing, iProcurement and iSupplier modules.
- Involved in Requirement gathering and design process mapping with standard oracle application for above modules.
- Preparation of setups in application for Purchasing, iProcurement and iSupplier for CRP and UAT application Instance.
- Worked on Functional Design Documents (FDD’s) for designing various RICE Objects.
- Setups for purchasing: defining Purchasing options, Receiving Options, Approval Hierarchy, Profile options, Document types, Responsibilities creation, Defining Buyers, Suppliers creations etc.
- Setups for iProcurement: Defining iProc Responsibilities, creation of Stores, creation of Content Zone, Smart forms creations, Punchouts etc.
- Setups and Testing End to End process flows for Purchasing, iProcurement and isupplier.
- Coordinated with technical team to Configure AME setups for Purchase Requisition approval and testing.
- Coordinated with technical team to develop Interfaces for receiving data from legacy systems to ERP.
- Creation of Employees in HRMS, Defining Jobs and Positions of employees.
- Worked with Oracle team on SRs for patch related Issues and data fix issues.
- Involved in Preparation of Process flows, BR100, MD50, Test scripts, process breakdown templates, functional specification docs and user manuals.Clear Orbit
- Worked with tech team to develop customization on budget control at purchase requisition level using Project code.
- Worked with tech team for developing Interfaces with other legacy applications.
- Coordinated with Oracle Support, creating SRs, attending OWC sessions, providing 24X7 support for quick resolution of high prioritized issues.
- Involved in weekly status calls with Project manager and client for updating the progress of work.
Confidential, California
Functional Consultant
Responsibilities:
- I was responsible for Purchasing, iProcurement and iSupplier Modules.
- Involved in new requirement gathering and designed process mapping with standard oracle application.
- Running respective upgrading programs for purchasing in Oracle 11i.
- Preparation of setups in application for OM, Purchasing, iProcurement and iSupplier for CRP, SIT1, SIT2 and UAT application Instance.
- Involved in Testing End to End process flows for P2P, iProcurement and isupplier.
- Worked with technical team on development on custom form / reports and Workflows.
- Involved in AME setups for Purchase Requisition approval and testing.
- Configure and Testing Consigned Inventory flow .
- Involved in Providing user training & conducted practice session.
- Supported production environments and users on a daily basis by responding to emergency requests.
- Make sure all the Open purchase requisition and purchase order approval notifications are closed before upgrade take place.
- Data Loaded from excel sheet to oracle application using data loader tool.
- Log, view, access, monitor, follow up and close technical assistance requests (TARs) online-Oracle Metalink and Oracle Applications Patch Management.
- Involved in preparation of MD.50, BR100 and User Manuals and test scrips.
- Coordinated with Oracle Support, creating SRs, attending OWC sessions, providing 24X7 support for quick resolution of high prioritized issues.
- Worked on Brazil Integrated receiving.
- Post go-live support.
- Involved in weekly status calls with Project manager and client for updating the progress of work.
Confidential
Functional Consultant
Responsibilities:
- Responsible for Supporting Purchasing, OM, INV, Manufacturing and Finance Modules.
- Coordinated with Offshore team to fix Issues related to Finance /Manufacturing Modules.
- Involved in Integration of Oracle with third party software (Road Net Software) to improve the Sales Process and reduce the delay in customer delivery.
- Worked with technical team to develop new custom to capture the sales details daily from HHT devices at end of every day.
- Coordination with Technical Team and Developed Vending Receipts, Export Load outs custom forms.
- Custom form to track Passport details using barcode scanner.
- Worked with technical team to develop business reports with help of Discoverer tool.
- Worked with technical team in developing custom reports on Purchasing and reports for custom sales process.
- Worked on Encumbrance concept to reserve the budget allocation for each account.
- Solving day to day Issues based on issues assigned under Issue tracker.
- Involved in preparation of SQL statements to check Issues from back end data base.
- Weekly calls with project manager on status of Issues and workload.
- Involved in helping end users for periods to be open and Closing for Inventory and purchasing.
Confidential
Functional Consultant
Responsibilities:
- I was responsible for Core Inventory, Purchasing, iProcurement and Order Management modules .
- Requirement gathering, Business process mapping with standards application.
- Preparation of setups in application for Inventory, Purchasing and Order management for CRP, SIT and UAT application Instances.
- Involved in Preparation of Process flows, BR100, MD50, Test scripts, process breakdown templates, functional specification docs and user manuals.
- Worked with technical team to develop custom forms and reports based on user requirements.
- Coordinated with Oracle Support, creating SRs, attending OWC sessions, providing 24X7 support for quick resolution of high prioritized issues.
- Involved in weekly status calls with Project manager and client for updating the progress of work.
- Post go-live support.
