EXPERIENCE SUMMARY:

• 7+ years of experience in Oracle e - Business Suite ERP Release 11i and R12 for projects ranging from Implementation, Rollout, Upgrade and Support. Performed multiple roles like Oracle Apps Techno-Functional Analyst, Oracle CRM Techno-Functional, Oracle Apps Technical Consultant and Oracle Apps Developer.
• Extensive experience in Oracle Modules like: Order Management ( OM ), Inventory ( INV ), iStore, Configurator and Quoting.
• Excellent exposure to Industrial Manufacturing processes and requirements.
• Proficiency in Java/ JSP development in Oracle Applications (CZ CIO APIs, iStore (IBE/ ASO) APIs, MSCA, etc.), Oracle Reports, XML (BI) Publisher
• Strong understanding of R12 MOAC Architecture, business flows, table structure of Oracle E-Business Suite.
• Good experience of working on Workflow Builder and Form Builder. Customized seeded Oracle Workflows for OM and iStore ( IBE ). Customized Depot Repair form, etc. using Form Personalization (FP) and customized standard forms, using CUSTOM.pll
• Extensive experience and focus on performance tuning by using tools like TKPROF , Jmeter and enhancing quality, user experience by designing user friendly UIs.
• Proficient in working on RICE (Reports, Interfaces, Conversions, and Enhancements) objects independently.
• Designed and developed; multiple RICE using Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Vast experience in designing, testing and rolling out of Oracle Enhancements to bridge the gap between end business requirements and the Oracle ERP Package. Strong technical and business knowledge to understand developer/ user terminology and constraints.
• In-depth understanding of Oracle EBS Module structure, Order-To-Cash ( O2C ), Procure-To-Pay ( P2P ) cycle.
• Strong knowledge of Application Implementation Methodology ( AIM ). Proficient at writing Functional design documents (MD50), Setups Details (BR100), Test Scripts (TE20), Technical Design and Installation (MD70 & MD120).
• Collaborate well with project management, business analysts, business users, and development team (offshore and onsite) with effective communication, leadership and interpersonal skills.
• Experienced at using ticketing tools like BMC Remedy, managing ticket queue, assigning tickets within team to appropriate members.

TECHNICAL SKILLS:

Oracle Applications Modules (R12 and 11.5.10):

Functional: Order Management, Oracle iStore, Oracle Configurator, Oracle Quoting

Technical: Oracle iStore, Oracle Configurator, Oracle Quoting, OM, INV, ASCP, AP, AR, MFG, WMS (MSCA), Install Base, Depot Repair

Programming Languages/ Tool: PL/SQL, Oracle Reports, XML Publisher (BI Publisher), Oracle Forms, Oracle Workflows, SQL Loader, Application Object Library, core Java, JSP, HTML/ CSS, Javascript, XML

Project Management Tools: MS Office, MS Excel, MS Visio, MS Project, MS Powerpoint and MS Sharepoint

Testing Tools: HP Quality Center, JMeter, SoapUI

Versioning/ Code Migration Tools: Serena Dimension Express and HP PPM (Kintana)

PROJECT EXPERIENCE:

Confidential

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Team lead for Oracle iStore, Quoting and Configurator.
• Requirement gathering, gap fit process, design, develop, test and implement customizations, writing functional, technical design and installation documents.
• Communicating with business users and end users to understand the pain areas and working on improving the processes.
• Designed and Developed Item Creation Enhancement for Config Items using EGO ITEM PUB API and Item Templates
• Developed Item Match enhancement to ensure no duplicate items are created.
• Designed and Developed Order Import interface from multiple external sources to Oracle R12 via single channel. Made use of OE ORDER PUB and Open Interface Tables, Fusion Middleware to develop the interface.
• Designed and developed single Order Status/ Inquiry interface to work for multiple external sources.
• Designed and developed interface for providing ATP (Availability) data along with the ability to run item search and pricelist in a single call to partner system with help of MSC ATP PUB and sourcing APIs. This helped me gain good understanding of Oracle ASCP.
• Designed and developed Open Order Report, Order Forecast Report.
• Designed and implemented (including setups), multiple defaulting rules for OM processes.
• Modified Standard Order Line workflow process to include customizations for Hold process, Configured Items.
• Created Minisites, Templates, worked on IBE Customer management in iStore.
• Customized Oracle iStore screens (pages) to suit business needs. Added multiple custom pages for various requirements like ATP (Availability) check without having to add item to cart, easy item search, searching for address based on Address lines along with country, etc.
• Added new and modified seeded AK Regions for making changes to iStore region-based pages.
• Created IBE message when customizing pages to maintain the multi-lingual feature provided by Oracle.
• Designed and developed multiple iStore enhancements to improve performance of Cart Checkout, Order Placement, and Order Inquiry. Modified the order placement process to dramatically improve user experience and wait time on place order.
• Modified OE and IBE workflows as per business requirement.
• Updated templates for seeded Oracle iStore pages.
• Worked closely with the team designing iStore catalog, user material.
• Designed and developed Oracle Configurator Extensions using the Oracle CZ CIO APIs.
• Designed and developed reports for Configurator to display the model details including manufacturing cost which is not available in the seeded Model Report.
• Enhancement for invoking run-time Oracle Configurator from Siebel CRM and massaging the output of configurator to cater to Siebel’s needs in IR.
• Created and Published BOM Based Configurator Models, writing Logical Rules and designing UI.
• Implemented Oracle Configurator Simulator to assist Modelers in validating the model development at each step.
• Debugging model rule issues, mapping issues, creating custom folders in Repository for various configurable products
• Creating extension rules
• Publishing models and running model reports
• Developed multiple customer facing documents like Depot Repair Quote, Sales Order Acknowledgement, Order Confirmation report from iStore.
• Added Form Personalization in Depot Repair to restrict new customer creation
• Developed Defaulting rules in Depot Repair to select pricelist, warehouse, etc.
• Developed interface between Oracle R12 Install Base and external systems
• Modifying seeded MWA (MSCA) pages and adding new custom MWA pages to make use of hand-held devices even easier.
• Performance tuning for faster ATP results.
• Code review, documentations
• Handling code migrations between instances using FNDLOAD.

Confidential

Oracle Applications Technical Consultant - Onsite

Responsibilities:

• Developed Order Import Interface using OE ORDER PUB API to import orders from third party tools and was also used for 10.7 - 11i Open Order conversion. Orders imported included Config Lines as well.
• Created consolidated report for all Oracle 11i inbound interfaces for Order Management like Order Import, Order Status, etc.
• Modified the SSD (Schedule Ship Date) logic to suit business needs.
• Developed AP Invoice import using Payables Open Interface Import Program.
• Developed AR Customer Invoice Report, Pack Slip report
• Developed Indented Bills of Material ( BOM ), Bill of Lading report.
• Designed and developed International Shipment report.
• Designed and implemented Flow Schedule cancellation program.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program . Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed PL/SQL packages to validate the data and insert the validate data into Open Interface tables.
• Developed configurator extensions: To populate data into CZ CONFIG ATTRIBUTES table, prepopulate data on the configurator screen based on a custom common selections form, convert text feature to decimal feature
• Developed Config Creation program using CZ CIO APIs. This program was used for Order Import and preconfig creation
• Designed and developed Model data report which gave an extract of all the Rules and UI design. This helped the team of Modellers to design models accurately.
• Developed custom MWA (MSCA) pages for Project Transfer and Material Transactions.
• Customized and personalized seeded MWA pages.
• Performance tuning
• Helped in designing Interfaces, Reports, creating documents and users.
• Testing and performing code review
• Post go-live stabilization activities - Working on tickets, assisting users in using the new system

Confidential

Oracle iStore Developer

Responsibilities:

• Finding gaps between the seeded Oracle iStore solution and business needs
• Creating custom JSP pages for Oracle iStore to accommodate special needs
• Modifying seeded Oracle JSPs as per business requirement and logic
• Oracle Patch merging activity
• Modifying seeded views and AK regions to make changes to certain region based JSPs.
• Modifying templates so they point to custom pages.
• Performance analysis and tuning
• Code review, documentation and testing
• Helping with user access control features by creating new roles and responsibilities and using them in the code

Confidential

Oracle Configurator and JSP Developer

Responsibilities:

• Reading and understanding the GAP documents, MD50 and creating technical design for them.
• Developing Configurator extensions using CZ CIO APIs
• Developed a File-Upload utility using JSP
• Created “Terms and Conditions” page to be displayed before “Sign In” from the external URL used by dealers and distributors
• Testing Configurator extensions and helping with publishing models
• Performance tuning custom code for Oracle Configurator
• Migrating code files and AOLs to higher instances using HP PPM