We provide IT Staff Augmentation Services!

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.

We'd love your feedback!