We provide IT Staff Augmentation Services!

Oracle Ebs Techno Functional Consultant Resume

Newington, NH

SUMMARY

  • An Oracle E - Business Suite (R12.1) Supply Chain Management Implementation Specialist (Order Management).
  • 12 years of total IT experience, which includes 9 years of techno functional expertise in Oracle EBusiness Suite Supply Chain Modules and 3 years of experience in Oracle SQL/PLSQL.
  • Played major roles in consulting, project management, estimation, production support and implementation of oracle application components.
  • Handled multiple implementation projects, production support and upgrade projects.
  • Onsite-Offshore coordination experience from multiple geographic locations for requirement gathering, solution design, technical activities, development and testing.
  • Oracle Supply Chain Techno Functional Consultant proficient on SCM modules like OM, Advanced Pricing, INV, WIP, BOM, Shipping execution, IB, PO, Configurator, iProcurement, XML Gateway.
  • Good knowledge onOrder to CashandProcure to paybusiness life cycle.
  • Excellent in preparing business requirement/change document.
  • Effectively communicating functional requirements to developers and assist with unit testing.
  • Create ad-hoc reports, queries, or data extracts, as necessary
  • Experienced in developing various Oracle Reports, Interface, Conversion and Extension components (RICE).
  • Oracle E-Business Suite 12 Supply Chain Certified Implementation Specialist: Oracle Order Management.
  • Oracle Certified Professional in Oracle 9i Developer track (SQL, PLSQL, FORMS)
  • Excellent coding/debugging skills on Oracle SQL, PLSQL (Packages, triggers, Functions, Stored Procedures)
  • Experience developing custom Oracle Application Framework (OAF) pages using Java (J2EE/J2SE) and PL/SQL.
  • Experience with Jdeveloper and Tortoise SVN (Subversion) tools.
  • Expertise in creating and customizing, Oracle XML Gateway Interface programs between Oracle EBS and SAP systems.
  • Worked as Demantra technical consultant for Oracle Demantra Implementation project, developed PLSQL interface programs between Oracle EBS and Demantra.
  • Working knowledge on Oracle WF builder, worked on minor enhancement WF changes.
  • Extensive Interfacing and Conversions between Oracle Applications and Legacy Systems, using SQL loader/UTL File.
  • Excellent knowledge in developing XML Publisher report programs.
  • Strong Knowledge in design and development of interfaces using API’s and Open Interfaces for integrating other applications with Oracle Applications.
  • Experience in supporting the production systems and handling day-to-day issues.
  • Proficient in Oracle Configurator, importing models, creating master template, structure template, rules and publishing the models.
  • Worked with all the above tools in creating full life cycle implementations for development environment.
  • Expertise with Oracle’s implementation methodology documents such as BR-100, CV-10, MD-050, MD-070, MD-120, TE-040 etc.
  • Proficient in HP Quality Center test management tool.
  • Working knowledge on using Panaya tool for R12 Upgradation.

TECHNICAL SKILLS

Oracle EBS Module: OM, Advanced Pricing, INV, WIP, BOM, PO, IB, AR, Shipping Execution, XML Gateway, Oracle Configurator, Oracle iProcurement.

Packages/Utilities Tools: Toad, SQL Loader, Putty, SQL Developer, Remedy.

Oracle EBS Technology: SQL, PLSQL, Forms, Reports, Interfaces, Conversions, Workflow, XML Message designer, XML Publisher, Jdeveloper, Java/J2EE.

Database: Oracle 9i/10g/11g/12c.

Operating Systems: Linux and Windows.

Web Tools: HP Quality Center,Service now, Panaya.

Oracle Demantra: Demand Planning

PROFESSIONAL EXPERIENCE

Confidential, Newington, NH

Oracle EBS Techno Functional Consultant

Responsibilities:

  • Oracle Supply Chain Techno Functional Consultant for implementation project.
  • Impact analysis of Oracle BI publisher, RDF, Discoverer reports for warehouse movement.
  • Code changes, unit testing, migration of Oracle BI publisher, RDF, Discoverer reports for warehouse movement.
  • Implemented Oracle Discrete job routing sheet XML publisher report.
  • Implemented Oracle Parts list discoverer report.
  • Implemented AMP Quad Inventory upload program.
  • CRP and UAT support for Confidential project court implementation.

Confidential

Oracle EBS Techno Functional Consultant

Responsibilities:

  • Oracle Techno Functional Consultant handling production support and enhancements in Order to Cash modules.
  • EDI Techno functional consultant for Toshiba. Implemented various EDI integration components.
  • Implemented EDI 753(Routing Request) and 754(Routing Instruction) signals for Amazon customer.
  • Implemented EDI 860(PO Change Order) and 865(PO Change Order Acknowledgement) for Arrow electronics.
  • Production support for Oracle iProcurement, Purchasing and Order Management modules.
  • Production support for Toshiba to DELL IRIS interface programs.

Confidential, Saint Louis, MO

Oracle EBS Techno Functional Consultant

Responsibilities:

  • R12.2.6 impact analysis for all custom objects using Panaya tool.
  • Solution remediation for the impacted objects.
  • Assessment for new Release tool (objects migration) to support Oracle EBS R12.2.6 version.
  • Document revision for coding standards and naming standards to support Oracle EBS 12.2.6.
  • Script to compare the table changes Oracle EBS R12.1.3 vs R12.2.6 to analyze the impact for OBIEE components.
  • Estimation for impact changes.
  • Presentation of Oracle EBS R12.2.6 technical features to Ameren EBS IT team.

Confidential

Oracle EBS Techno Functional Consultant

Responsibilities:

  • Involved in requirement gathering, preparing business requirement documents for various Ricoh Supply Chain Integration and decommission projects.
  • Getting signoff for the requirement documents from Business.
  • Communicating the requirements to Development and assist them in unit testing.
  • Prepared the setups and configurations as needed in DEV environments.
  • Documented the setups in a BR100 document and handed over to designated setup owners for doing setups in QA and PROD. Keeping BR100 up-to-date.
  • Involved in writing functional requirements around Oracle Supply Chain modules for various Oracle ERP components that includes custom concurrent programs, new form development, QA validation, customizing workflows and configuration setups.
  • Implemented several process improvement ideas that helped business significantly.
  • In depth exposure to Oracle order management setups like Defaulting rules, processing constraints, Transaction types, holds and UDA.
  • In depth exposure to Oracle Inventory, Bill of material and Work in process setups.
  • Hands-on experience on Order Import, Dropship, Back2Back Ordering, and Internal Sales Orders.
  • In depth exposure to Oracle Advanced pricing setups like price list, qualifiers, and modifiers.
  • Implemented Order processing constraints to enforce Order entry restrictions as per business needs.
  • Implemented Order/line defaulting rules as per business needs.
  • Implemented Oracle PO approval Workflow customization.
  • Implemented automatic Order hold release API to improve the Order to cash cycle time.
  • Implemented OAF page order status report.
  • Implemented BOM Conversion.
  • Implemented several qualifier setups in Advanced Pricing based on customer account and customer groups.
  • Implemented several modifier setups in Advanced Pricing for promotions, donations, adjustments.
  • Created custom qualifier and contexts in Advanced Pricing.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

  • Design, Development and Testing of Oracle XML Gateway Interface customizations.
  • XML Gateway Inbound Sales Order interface was developed to create sales order transactions in oracle from the XML files sent from SAP ERP.
  • XML Gateway outbound interface was developed to send AR transactions details from Oracle to SAP ERP.
  • XML Gateway outbound interface was developed to send PO details from Oracle to Suppliers.
  • Preparing technical design document based on functional requirement document.
  • Coding and Unit testing.
  • Preparing BR100 documents for functional setups.
  • Preparing MD120 document for migration activities.

Confidential

Technical Lead

Responsibilities:

  • Design, Development and Testing of Oracle (PLSQL) Demantra customizations used for demand planning.
  • Performance tuning of Demantra custom programs.
  • Knowledge transition to business owners on the technical deliverables.
  • Assisting business stake holders for UAT testing.
  • Preparing end user manuals for Demantra solution implemented.
  • Implemented Sales Order history Interface program (PLSQL) from Oracle Retek to Demantra.
  • Implemented Purge order history program (PLSQL) in Demantra to improve engine run.
  • Implemented upload utility (PLSQL) which will load Financial Sales Plan data to a staging table in Demantra.

Confidential

Module Lead

Responsibilities:

  • Offshore module lead for OM and SCM Development team.
  • Responsible for Oracle application minor enhancement offshore deliverables.
  • Estimation, solution design, reviewing and assisting team members in technical deliverables.
  • Customized the OM Header/Line level workflows for OM to IB interface program for linked orders.
  • Implemented WIP Issue exclusion.
  • Implemented DFF setups to capture additional information about the Bills.
  • Customized WIP Job Resource Report.
  • Implemented Routing and Resources conversion.
  • Implemented DFF to capture comments for WIP Resource Transactions.
  • Developed Advance dealer shipment notification XML Publisher report.
  • Developed Advance pickup notification XML Publisher report.

Hire Now