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.