We provide IT Staff Augmentation Services!

Oracle Techno-functional Consultant Resume

Versailles, OhiO

SUMMARY:

  • 14 years of experience in IT industry in the areas of Analysis, Design, Development, Testing Implementation of business applications with special emphasis on Oracle Applications E - Business suite of products.
  • Working as a Oracle EBS Techno-Functional Consultant and performed on various roles involving solution architecture, design & development and well-versed in all areas of the implementation life-cycle including Planning, Requirements Gathering, Gap Analysis, Configuration, Confidential Development, Testing, User Training and Production Support.
  • Worked in implementation, Upgrade and Support of Oracle ERP Applications/EBS (12i/11i /11.0.3) across various modules which includes Order Management, Inventory, Purchasing, Quoting, Advanced Pricing, BOM (Bill of Material), Oracle Configurator, Oracle iStore, Receivables, General Ledger, Payables, AOL and System Administrator modules.
  • Hands-on involvement in business requirement, GAP analysis, POC (Proof of Concepts), process mapping, solution design, configuration, setups, work arounds, interfaces, user training.
  • Depth experience on converting a Quote(Oracle iStore and Oracle Quote) to an Order, integrate advanced pricing and configuration solution, re-designing the order entry and upfront validation process for fulfilling their order life cycles using Oracle R12. And also having good experience in day to day operation/application site support experience in B2B Transactions process like, Deliveries(Oracle ASN -Advance Shipment Notice and Ship Stage), RMAs - Return Material Authorizations, Purchase Orders and Receipts and Inventory Sync between Warehouse Management (3PL/ RedPrairie and Oracle WMS) and Oracle R12 Application systems.
  • Hands-on involvement in Oracle iStore, iReceivables and iSuppliers integration with Oracle Portal. And worked on Oracle iStore new user registration process and integrating the custom applications for E-Contact, e-Licensing and eSoftware applications in order to perform quote to Order cycle.
  • Extensive experience with Quote to Order to Cash, Warehouse Management and Procure-to-Pay modules.
  • Having the experience on integration between Oracle ERP and Supplier Collaboration Tool (E2OPEN) to communicate the Net Demand, Booked Sales Orders (BOC), Purchase Orders, PO Receipts, On-hand balances from the ERP system to the Suppliers in Forecast to procure process.
  • Developed functional and technical specifications as well as test plans and test scenarios using AIM Methodology.
  • Extensively worked in Confidential components (Reports, Interfaces, Conversions, Extensions and Workflow) using Oracle Forms, Oracle Reports, XML-Publisher, Confidential ustom PLL's, Form Personalization, OAF Page Personalization, PL/SQL, SQL, SQL* LOADER and Workflow builder.
  • Experience in various development tools like SQL Developer, Toad, SQL*Loader,10g/9i, Forms 10g/6i, Reports 10g/6i.
  • Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, EXPLAIN PLAN and etc.
  • Substantial development experience in creating Oracle stored procedures, PL/SQL Packages, Triggers, Functions, Indexes and Views.
  • Expertise in various Import and Export utilities like SQL LOADER and UTL FILE.
  • Good at sysadmin and AOL activities including creation of KFFs, DFFs, Lookups, users, responsibilities, menus, concurrent programs, request sets, request groups, value sets.

TECHNICAL SKILLS:

Oracle Applications: (R12/11i /11.0.3) Modules like OM, Inventory, PO, BOM, Pricing, Shipping, Oracle WMS, Quoting, Configurator, iStore, GL, Payables, AR AOL, Sys Admin.

Exposure: SQL/PLSQL, RDF Reports, XML, Customization of Forms, Interfaces, Conversions using Standard Oracle APIs, XML/Java based Interface Programs, Order Management, Advanced Pricing, Inventory, OAF

Tools: Oracle Developer 2000(Forms 6i /10g, Reports 6i/10g), Oracle Workflow builder, SQL*Loader, SQL*Plus, SQL Developer, Toad, XML Publisher, IBM Rational Confidential, HP Quality Center 11, HP Portfolio and Project Management and Clear Case

Programming Languages: Oracle SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Versailles, Ohio

Environment: Oracle Applications R12, OAF, forms, Reports and workflow.

Oracle Techno-Functional Consultant

Responsibilities:

  • Involves on process mapping, configuring applications, technical design, development and customizations of Confidential Components.
  • Authoring various documentations - MD70 and MD120 using Oracle AIM Methodology.
  • On time delivery of Confidential Components using oracle development tools and utilities such as Oracle Forms, Reports, Workflow, SQL, PL/SQL, Data Loader, XML, BI Publisher and UNIX.
  • Verify assigned 11i extensions are R12 compliant and remediate where required.
  • Working on Confidential components (Reports, Interfaces, Conversions, Extensions and Workflows).
  • Involves in various unit, functional, system integration and customer acceptance testing phases.
  • And responsible for cutover activities for Go-Live and post production support.

Confidential, Lincolnshire, IL

Environment: Oracle Applications R12, ORACLE 10g, TOAD 9.0.1, forms, Reports and workflow .

Oracle Techno-Functional Consultant

Responsibilities:

  • Responsible for requirement gathering, Business Process Analysis, Mapping the Business Requirements to the Oracle Applications, doing the POC (Proof of Concepts), writing the development requirements, designing the technical documentations.
  • Implement the complete solution for OM, PO, Inventory, and Pricing on Oracle ERP modules for handling the Net Requirements (Which includes Sales Orders, Purchase Orders, PO Receipts, On Hand Balances, Safety Stock and ASN) and Commit Write back requirements in Forecast to Procure process to integrate the Supplier Collaboration Tool (E2OPEN) with Oracle ERP.
  • Working on Supplier Sourcing Rules, Approved Supplier list setup configuration in PO.
  • Working on Inbound and Outbound Interfaces for Net Requirements and Commit Writeback for Items, POs, ASN, PO Receipts and Booked Sales Orders to have sync with Oracle EBS and Supplier Collaboration Tool called Trading Partner Collaboration systems.
  • Working on GBPA (Global Blanket Price Agreement) Price Update extension.
  • Integrate the legacy system to Oracle EBS by acting as Oracle SME to complete the field mapping between the two systems
  • Participate in workshop meetings for gathering requirements and etc.

Confidential, Keene, NH

Environment: Oracle Applications R12, ORACLE 10g, TOAD 9.0.1, forms, Reports, workflow and SOA 11g.

Oracle Techno-Functional Consultant

Responsibilities:

  • Responsible for requirement gathering, Business Process Analysis, Mapping the Business Requirements to the Oracle Applications, doing the POC (Proof of Concepts), writing the development requirements, designing the technical documentations.
  • Implement the complete solution for OM, PO, WMS and Pricing modules for the factory warehouses of CSWG and integrating EBS with the SOA.
  • Defining the WMS Rules for Picking, Put away and Label Printing.
  • Customization of the WMS Label Printing as per the client business.
  • Developed the program for WMS LPN Reusability using the purging logic.
  • Creating Inbound and Outbound Interface for Items to have sync with EBS and Legacy systems.
  • Automated the complete Pick release to Shipping process using standard APIs in a OTM environment.
  • Worked on PO Receipts creation and correction process for Random Weight and Non-Random weight Products.
  • Integrate the legacy system to Oracle EBS by acting as Oracle SME to complete the field mapping between the two systems
  • Participate in CRP meetings.
  • Coordinate with Oracle support for issues, monitor oracle SRs for any oracle related issues.

Confidential, McAllen, TX

Environment: Oracle Applications 12i, ORACLE 10i, TOAD 9.0.1, forms, Reports, workflow and SOA 11g.

Techno-Functional Consultant

Responsibilities:

  • Assist in creation of processes and procedures for accurate and timely reporting.
  • Actively participate in Daily Cadences to concentrate on the McAllen Delivery B2B Issues.
  • Interface daily with key stakeholders.
  • Working closely with Supply Chain End users and Warehouse Management (3PL/ RedPrairie and Oracle WMS) teams to support in day to day B2B operations.
  • Sync between 3PL/ RedPrairie and Oracle R12 Application systems
  • Assist users with issue resolutions and actively resolves issues independently during the Order fulfillment process (in Oracle Application R12 end).
  • Performs Operations analysis (like Fit/GAP Analysis) on various Business Requirements by using the Oracle AIM Methodology and identifying the gaps and provides the corresponding solutions to develop.
  • Involves in upfront validation process for fulfilling their order life cycle processes to execute the project effectively. And also involves in designing and developing solutions in the enhancements of the current phase of the project.
  • Assist users in closing moth end and Quarter End activities as part of Post Go-Live support.
  • Involves in various Functional, System Integration, Regression and Customer Acceptance testing phases.

Confidential, Schaumburg, IL

Environment: Oracle Applications 12i, ORACLE 10i, TOAD 9.0.1, forms, Reports, workflow and SOA 11g.

Techno-Functional Consultant

Responsibilities:

  • Responsible for requirement gathering, Business Process Analysis, Mapping the Business Requirements to the Oracle Applications, doing the POC (Proof of Concepts), writing the development requirements, designing the technical documentations by using the Confidential tool (Telelogic Confidential 8.3 version), preparing the test scripts and co-coordinating the onsite and offshore team members for developing and testing the objects.
  • Worked on Setup Configurations in OM and Advance Pricing(QP) modules, including Flex Field Values & Value Sets, OM Order Types, defaulting rules & Workflows, Applying & Releasing Holds, Credit Checking Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes Defining Modifiers, Qualifiers, Pricing Formula Defining Standard, Internal, RMA and Drop shipment Orders Define Pick Release, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
  • Involved in designing and developing of Conversions, Interfaces, Forms, Alerts, Reports and extensions for Order Management, Configurator, Advanced Pricing and Quoting/iStore modules.
  • Providing the time estimates and efforts required to design and deliver the objects.
  • Involved in designing and developing of Oracle iStore integration with Oracle Portal process.
  • Worked as a coordinator between onsite and offshore team members in the respective objects for designing, developing and testing.
  • Worked on POC (Proof of Concepts) for business requirements to integrate the legacy systems (MOL and REC) with Oracle Applications.
  • Worked on Sales Order Interface with batch valid configuration process and attaching the short text type notes for header and lines.
  • Worked on Oracle Pricing Engine interface for providing the customer price, discounts, promotion items and pricing agreements from Oracle Application to the MOL legacy system.
  • Worked on E-contract, e-licensing and eSoftware custom applications in order to perform quote to Order cycle.
  • Worked on iPortal Integration for providing the iStore, iReceivables and iSuppliers application access to the external users.
  • Support during various testing phases of the project as System Integration Testing, CAT and regression testing.
  • Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).
  • Involved in coordinating and assisting the users in User Acceptance Testing.

Confidential, Schaumburg, IL

Environment: Oracle Applications 12i, ORACLE 10i, TOAD 9.0.1

Techno-Functional Consultant

Responsibilities:

  • Requirement gathering, Business Process Analysis, Mapping the Business Requirements to the Oracle Applications, doing the POC (Proof of Concepts), writing the development requirements, designing the technical documentations by using the Confidential tool (Telelogic Confidential 8.3 version), preparing the test scripts and co-coordinating the onsite and offshore team members for developing and testing the objects.
  • Involved in designing and developing of Conversions, Interfaces, Forms, Alerts and Reports for Order Management, Inventory, Configurator, Advanced Pricing and Quoting modules
  • Worked on Development Requirements for Oracle Quoting and Order management module at client place.
  • Worked on POC (Proof of Concepts) for business requirements to integrate the legacy systems (MOL and REC) with Oracle Applications.
  • Co-coordinating the onsite and offshore team members for developing and testing the objects.
  • Worked on Sales Order Interface with batch valid configuration process and attaching the short text type notes for header and lines.
  • Worked on Oracle Quoting interface and BOM splitting in quote new version creation process with batch valid configuration and copy configuration.
  • Worked on Oracle Pricing Engine interface for providing the customer price, discounts, promotion items and pricing agreements from Oracle Application to the MOL legacy system.
  • Worked as a backup resource for the Order Acknowledgement Interface.
  • Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Confidential

Environment: Oracle Applications 12i, ORACLE 10i, TOAD 7.6

Technical Consultant

Responsibilities:

  • Worked on PO Documents Interface.
  • Worked on Item Creation Notification Alert.
  • Worked on AR Receipt Form Customization.
  • Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Confidential

Environment: Oracle Applications 11.5.10, ORACLE 9i, TOAD 7.6

Technical Consultant

Responsibilities:

  • Worked on Item Conversion.
  • Worked on AR Customer Maintenance Report.
  • Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Confidential

Environment: Oracle Applications 11.5.10, ORACLE 9i, TOAD 7.6

Technical Consultant

Responsibilities:

  • Fixed Assets Conversion.
  • Vendors Conversion.
  • AR Invoice Conversion.
  • Worked on Interfaces.
  • Payables Expense Report Invoice Interface.
  • AR Lockbox Receipts Interface.
  • Worked in integration support while go lives the project.
  • Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).
  • Involved in peer review, testing and quality delivery.

Confidential

Environment: Oracle Applications 11.5.10, ORACLE 9i, TOAD 7.6

Technical Consultant

Responsibilities:

  • Design and develop Inbound Interfaces.
  • Worked on GL Conversion and AR Customer Conversion.
  • Developed custom form in CRM Foundation Module.
  • The custom form “Sales Team Form” will allow for the assignment of teams and stations to sales manager only when a manager is created as a sales person in the Resource form of CRM Administrator.
  • Developed new Report.
  • Worked on AR Miscellaneous Invoice Report.
  • Preparation of Installation scripts and Documentations (Technical specifications, Unit Test Plans and Migration documents).

Confidential

Environment: Oracle Applications 11.5.8 / 11.5.10 , ORACLE 9i, TOAD 7.6

Technical Consultant

Responsibilities:

  • Design and develop Inbound / out bound Interfaces.
  • Worked on Item Conversion and Blanket PO Conversion.
  • GEPO CHSMSACCESS Out bound Interface.
  • Developed new forms and Customize forms.
  • Supplier Selection Form
  • Customized the PO Form by using Confidential Custom pll.
  • Developed new Reports, Customize Reports, Mailing Reports, XML Publisher Report and shell scripts for ftp.
  • Worked in Enhancements (Based on requirement changes).
  • Preparing Technical Specifications, Unit Test Plans, Unit Test Output data and Migration documents.
  • Involved in peer review, testing and quality delivery.
  • After successful go live, giving the Post Production support.

Hire Now