SUMMARY:

• Oracle SCM Applications consultant with over 10 years of experience implementing and managing Oracle EBS applications including 5 Full Life Cycle Implementations/Upgrades of Oracle EBS Suite versions 11i / R12.
• Extensive hands on expertise with the following modules within the Oracle EBS (E - Business Suite,)Purchasing,, INV (Inventory),WMS (Warehouse Management), MSCA (Mobile Supply Chain Apps), WSH (Shipping Execution), BOM (Bills of Material), OM (Order Management),GL, AP, AR, Procurement,
• Worked with team installing and configuring Mobile devices and handheld computers
• Experienced in conducting, Discovery Sessions, and Delta presentations including analyzing, defining, and documenting data requirements, business rules, FIT/GAP analysis, reporting needs and QA testing by following the SDLC, AIM or OUM methodologies.
• Experience in preparing RICE objects including Requirement documents, Technical design documents, Project Analysis and Project Planning docs, Training documents, Testscripts and Fall back plans. (MD050, MD070, BR100, DS030, DS010, RD011, TA040)
• Understands the direction, structure, and requirements for each project from the business and communicate them to the development and testing staff.
• Experienced in the following versions of Oracle Applications: 12.1.3/12.1.1/12.0.6/11.5.10/11.5.9 and11.5.5.
• Oracle Trainer/UPK Tool & Delivering multi medium training to user and super user community.
• Understanding of all the Oracle R12EBS functionalities, Setups, table architectures and dependencies and integration issues among the manufacturing, distribution and supply chain modules in a multi org environment.
• Proactively communicated and collaborated with external and internal customers to analyze information needs and functional requirements and deliver the following artifacts as needed: Requirements Specification, Functional Design, Test Plans, Solution Architecture Design and successfully engaged in multiple initiatives simultaneously.

TECHNICAL SKILLS:

Oracle Applications: 12.1.3/12.0.6 /11.5.10/11.5.9/ 11.5.5: INV (Inventory), WMS (Warehouse Management), MSCA (Mobile Supply Chain Apps), WSH (Shipping Execution), BOM (Bills of Material), WIP (Work in Process), OM (Order Management), Oracle Projects, GL, Federal Financials, PurchasingProgramming Languages:PL/SQL,Tools:Optio, BarTender, EDI, SharePoint, MS Project/Office, Provision, Rational System Architect, Team Quest, Oracle Open Script, OATS (Oracle Application Testing Suite)

Operating Systems:: Windows7, XP/NT/2000, Linux, UNIX, MVS/ESA

Data Warehouse Tools: t:Rational, OLAP and ETL Concepts

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Implementation Lead

Environment: PO, OM, INV, WMS, BOM,WIP, TOAD. Oracle Applications R12.2.3

Responsibilities:

• Worked onsite with the client to study their business processes.
• Involved in implementing the Discrete Manufacturing modules (BOM, WIP, Quality, Planning)
• Business Process Study, Defining solution premises (Deciding on BOM Indentation, Sub - assemblies etc.), Solution Design, CRP, UAT and Production instance setups
• Delivery of all functional documentation (AS-IS Process Maps, Future Process Maps, Functional Design) and appendices for additions to Oracle 11i solution, Test scripts (CRP and UAT script), and Setup Documentation.
• Prepared user manuals.
• Provided training to Subject Matter Experts (SMEs) and end-users.
• Designed reports and add-ons and coordinated with the technical team to monitor development progress, interfaces and data migration activities
• Coordinate testing/verification of all application solutions
• Participated in the review meetings

Oracle EBS Implementation Lead

Environment: Purchasing, OM, INV, WMS, SVN, TOAD. Oracle Applications 12.1.1, Oracle 11g

• As an EBS Implementations Lead, participated in BH’s Multi Org implantation of Oracle EBS applications including WMS, INV, OM, Shipping modules. Involved in guiding and implementing the Oracle OUM (Oracle Unified Method) for migration of their existing documents and current documents and methodologies. This includes the migration of current Oracle AIM documents, SOA and web related SDLC methodology.
• Involved in conducting User requirements workshops for each Oracle Module and worked on creating the FRS (Functional Requirements Specifications).
• Collaborated with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Involved in creating the FDD (Functional Design documents) for INV, WMS, OM, MSCA modules.
• SCM Distribution modules, INV, OM, PO.
• Worked with business and system architects to develop the EBS implementation functional and technical architecture to integrate the FORTE’s system with EBS for their entire wave picking, put-away, replenishment, cycle counting and physical counting processes which deal with Order fulfillment.
• Created various WMS rules, strategies, pick release rules, grouping rules, Material statues etc.
• Worked with development team to build and test the various PL/SQL, SOA packages and Custom Web JSP packages using SVN.
• Worked with QA team to develop test strategies and conduct the User Acceptance testing workshops to do the system and integration testing and to develop the training documents using Oracle UPK.
• Worked on the warehouse floor to conduct the floor training of the new system to super users, inventory planners, receivers and shippers.

Oracle EBS Applications Lead

• Environment: Oracle Apps Functional Consultant in R12 Product Data Hub (PDH), 11i (11.5.10.2) Advanced Pricing, Order Management, Inventory, Purchasing, Account Payables, Account Receivables, BOM
• Confidential is a global leader in providing security, storage and systems management solutions to help businesses and consumers secure and manage their information. Headquartered in Cupertino, Calif., Symantec has operations in more than 40 countries
• Scope: Confidential uses Oracle Applications suite (R12, 11i)as the main system for its business along with the other Custom applications/reports. Distribution and Financial modules have been implemented in Symantec, and it's an ongoing project to integrate other business units and new modules to the existing Oracle ERP. The Modules that are widely used include Product Data Hub (PDH), Customer Data Hub (CDH), Advanced Pricing, Order Management, BOM, Inventory, Purchasing, Account Payables, and Account Receivables.
• Responsibilities:
• Gathering Business Requirements from business users and preparing Business Requirement, Functional Design, BR100, Test Scripts, Test Scenarios documents.
• Working with Development team to built the functionality for the new requirements and testing in DEV / QA instances before migrating it to UAT and PROD instances
• Understanding / Reproducing / Analyzing / Troubleshooting / Resolving PDH functional issues and helping development team to resolve technical issues
• Understanding and identifying the complexity of new PDH business requirements and proposing the solutions / options to accomplish the requirements as a part of implementing PDH SKU 1.2 project
• Extensively worked on PDH and ERP interfaces as a part of daily activity and troubleshooting / analyzing the issues on those Interfaces
• Creating / Updating / Deleting SKU's, SKU Relationships using spreadsheet tool in PDH, pushing the updates from PDH to ERP by running synchronization programs, and Troubleshooting the Synchronization issues between PDH and ERP
• Working on Flexfields- segments, value sets, values and look up codes in PDH, ERP
• Working on File Upload tool for mass updates on Tax Categories, SKU attribute values, Business Rules.
• Working on Autogen tool to create / update SKU's in PDH, ERP at a batch level and troubleshooting the issues while creating / updating
• Restricting / Granting the access to create / update the SKU at different levels - SKU, SKU attributes, SKU catalog by setting up the rules in setup work bench in PDH
• Working on dynamic Mini tables to create / update the business rules using file upload tool in the customized Oracle form
• Extensively worked on Item Search based on different attribute values by creating our own search criteria.
• Extensively worked on Spreadsheet upload, Multi Item Extract form tools to create / update / delete the SKU for various Inventory Organizations.
• Created SKU (Item) setups for Attribute Groups, Attributes, Catalogs, Item Pages, Display Formats in PDH application
• Worked on Parent and Child SKU (exploded SKU) setups and fixed the issues on Auto-explode linking logic which is being used while creating the SKU's using Autogen Tool in PDH application
• Worked on Item Relationships and actively participated to implement the Relationship enhancements for all type of SKU's in PDH- Provided the functionality to create Item Relationships based on the user configurable rules
• Actively participated on Spreadsheet Upload tool enhancements in PDH - Provided the preview functionality to review the staging data before committing it to the PDH
• Understanding the current business process and troubleshooting the Production issues to find the Root Cause and replacing the issues in TEST instances and testing the resolution / work around to fix the issues in Production
• Worked on gathering the business requirements for the NEW SKU releases and mapping into Oracle 11i, identifying the GAPS and providing the alternatives to minimize the GAPS.
• Preparing business requirement, functional design documents to develop the custom reports in various applications in Oracle
• Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules
• Extensively worked on Price Upload, Item Upload, Autogen process to create / update the Items, Prices in Oracle
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules
• Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO
• Extensively worked on Change Requests (CR's) and preparing the BRD's, FD's on OM, Advanced Pricing module
• Extensively worked on troubleshooting the issues on Custom Concurrent Programs in Oracle, providing the workaround and finding the Root Cause of the issues.
• Extensively worked with the development team to build the Oracle custom forms in various applications and testing the functionality before migrating it to the other instances
• Analyzing the issues using TOAD, providing the workaround to fix the issues, testing the workaround in TEST instances and providing the updates to Business.
• Extensively worked on Price Lists, Modifiers, Qualifiers, Pricing Attributes in Advanced Pricing and created the setups in TEST instance
• Monitoring the help requests created by the Business in AdvenNet software and helping them in resolving the issues.
• Troubleshooting the issues while updating / creating the Prices, Items in Oracle using Price Upload, Item Upload, Autogen.
• Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing, Order Management modules
• Worked on creating the Licenses, Certificates for the various SKU's in Order Management, Inventory Application
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application
• Extensively worked on different Inventory transactions and solved the period end issues
• Worked on the different Purchase Order setups, generated the invoices, and resolved the pending transactions
• Worked on RMA Process, importing EDI orders, and Credit Memo process in Order Management, Account Receivables Application
• Extensively worked on Multi Currency conversion setup in Purchasing and Order Management Applications
• Created category sets, category codes, default category sets for the various items in Inventory application
• Troubleshooting the technical issues and preparing analysis on the issues in Oracle applications
• Working on serial controlled items and item reservations against the sales orders based on the scheduled ship date in Order Management
• Support Activities:
• Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Implement various improvised processes to prevent user errors and stabilizing the system.
• Implement major modifications in the application with focus on making the system more user friendly and ease in extracting the required data from Oracle.
• Work on major upgrades of database and application that included testing of major upgrades and releases.
• Co-ordinate with Oracle Support for resolution of TAR's- Worked with Oracle to resolve the issue on maximum number of attributes within the multi-level row attribute group, and the mini table setup issues
• Serves as part of the Transition Project that successfully enabled the Team to start within the specified timeframe
• Responsible for training of end-users and provided the aggressive support to resolve the UAT, Production issues

Oracle Configurations Expert

Environment: INV, WMS, Purchasing, EAM, OM, WSH,, GL, OracleApplications 12.1.3/12.0.6, Oracle 11g,, SSH, OUM, RICE, IBM System Architect, Oracle Testing Suite.

• As a Configuration Expert, led the team to implement the Oracle EBS Applications including P2P (Procure to Pay), O2C (Order to Cash) and P2S (Plan to Stock) End-to-End processes.
• Collaborated with Other E2E teams to meet the Project Schedule,business and functional process flows.
• Involved in Configuring INV, WMS, OM and WSH Modules.
• Conducted the Discovery sessions, R12 Delta upgrade sessions on Latest Oracle R12 functionalities including Multi Org Access, SLA, Process Manufacturing changes, Lot and Grade changes, Material Status control, Inventoryupgrades, rules engine changes, Labeling changes, LPN management, Labor Management, Dual Unit of Measure, Delivery consolidation etc.
• Did Enterprise Setup Analysis for new releases, determine implementation models and accumulate information from setup questionnaire while working with business users and development analysts.
• Defined use cases and performed FIT/GAP analysis against Oracle R12 enterprise business suite platform.
• Performed solution analysis and development for GAPS and integration requirements including mapping AS-IS systems to TO-BE system (Oracle EBS).
• Created automation files/scripts when necessary for items such as menus, responsibilities, profiles, and inventory org access.
• Involved in setup of EBS Test and Production environment builds and upgrades.
• Collaborated with solution, data, and technical architects to develop an integrated application solution and to map ECSS Processes including data analysis, cleaning and migration activities.
• Conducted the CRP and Testing sessions for super users and functional users and prepared the Test Scripts and TrainingDocuments.
• Worked on multiple R12 initiatives including introduction of Ledgers, multi-org access, transition of internal Banks to Cash Management, transition of external banks to Payments, transition of Accounting to SLA.

Environment: INV, OM, RICE, GL, Self Service Purchasing, and Discrete Manufacturing. Oracle Apps 12.0.6, Oracle 10g and Unibar Label Design, Unibar ELS Enterprise, Unibar Director, CrEme, Smart System.

• Defined, documented and transformed high level business requirements into SMART (Specific, Measurable, Attainable, Realistic, Time-Bound) system requirements.
• Involved in configuring Oracle Inventory Module, WMS and Mobile Supply chain Applications (MSCA) for multiple Inventory Orgs including multiple Warehouses.
• Implemented and configured Unibar Director to access additional Oracle fields
• Created the Unibar Director Java scripts
• Configured the Unibar ELS enterprise for windows and Designed the Unibar labels for Material, serial, Locators with UCC 128 and Datamatrix 2D barcode formats.
• Implemented the Mobile GUI interface on the handhelds and CrEme.
• Customized the Miscellaneous receipts and Issue Hand held screens to accommodate the custom 14 segment GL accounting field.
• Training the super users and the warehouse users on the MSCA transactions and procedures
• Involved in implementation and Production support of Oracle 11.5.10 EBS modules including INV and WMS.
• Developed the BR100 documents for Order Management, Inventory and Purchasing Modules.
• Designed all the Material, serial, Shipping Labels, Configured the Intermec CK3 Handheld devices
• Involved in Updating the OS and Scan Engine (SSPG) on CK3 handhelds
• Involved in scripting the handheld patches and developing the cab files to make the hand held customizable
• Training the super users and the warehouse users on the MSCA transactions and procedures

Supply Chain Operations Lead

Environment: WMS, INV, BOM, Discrete Manufacturing, Oracle Projects, WIP, ASCP. Oracle Apps 12.0.6, Oracle 10g, SQL, TOAD, HP-UNIX

• Involved in upgrade of Oracle EBS 11.5.10 to R12.06 and Oversaw the conversion of all Financials legacy data including the integration of government compliance controls into the Order to Cash and financials with Oracle Projects integration.
• Evaluated information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding and distinguish user requests from the underlying true needs.
• Designed, implemented Inbound and Outbound interfaces from Oracle to Shippers Commonwealth for load building using trip creation within Oracle, using the API’s.
• Involved in designing the Discovery Documents and running JAD Sessionsto collect the user requirements in the Phase I Oracle EBS Implementation.
• Prepared the RTMs (Requirement Traceability Matrix) for WMS, INV, BOM,and WIP.
• Lead the Functional team to prepare the Acceleratordocuments for all the Supply chain modules and to setup the Phase I Instance.
• Worked on Order to Cash process in OM module with Configurator and setup the Min-Max and Re-Order point planningmethods (MRP) including setup the ATP Rules and Inventory Planning.
• Configured BOM to use kit-to-stock, kit-to-order, pick-to-order, de-kitting, special packaging/labeling.
• Setup Kitting and De-kitting and BOM for Pre-Packs and Assortments in Phase II
• Worked on establishing project completion timelines, delegated work appropriately across team members, created teamwork schedules for go-live and support

Oracle e-business suite consultant

Environment: WMS, OM,Inventory, Purchasing, BOM, WIP,.Oracle 10g, SQL, TOAD, Linux and Zebra Designer.

• Developed Technical Specification Documents (MD70) based on the Functional Requirement Specifications (MD50).
• Created quotes using standard API’s to convert quotes from legacy to Oracle applications.
• Involved in Order 2 Cash process that also involves in designing and development of Freight interface by using custom API’s in OM module for extracting out bound and in bound transactions.
• Developed a custom interface programs to update part numbers on Service Contracts.
• Design and development of Record of Employment worksheet, Business Payroll Survey statutory reports for the Client’s Payroll.
• Created some custom tables using Toad, developed control files to load the data into the oracle system using SQL*Loader.
• Developed Reports using Reports 6i and customized the Invoices posted to suspense account and Credit on Hold Reports in AR.
• Customized Reports to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the reports in OM, AR, GL modules.
• Worked extensively on Discoverer Admin, Discoverer Desktop and Discoverer Plus. Developed reports using Discoverer 10g...
• Used the System Administrator responsibility to create users, responsibilities and Request Groups.
• Extensively worked on report attributes like Report triggers, Program units, Attached libraries and Built-in packages.

Oracle Applications Functional Consultant/Team Lead

Environment: I nventory (INV), WMS, Transportation Management, Order Management (OM), Purchasing. Oracle Applications 11.5.9/11.0.3 and iStore. Oracle 9i, SQL, TOAD and Optio.

• Setup of new packing stations and produced the UCC-128 barcode labels and formatted them using Optio.
• Involved in Post-production troubleshooting and analysis of business process issues within: WMS, Shipping, INV and OM. Gather requirements, write functional (MD050) and technical (MD070) specifications,
• Provided recommendations for user challenges, and implement process and system modifications. (Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using AIM guidelines.) with BR100 documents.
• Directed a 4-member development team in the gap analysis, architecture, and interface design for integrating the new Oracle INV from existing Legacy Order Management and Warehouse Management systems.
• Developed custom components to interface Service module to Order Entry(OE/OM), Inventory (INV), Accounts Receivables (AR), and Purchasing (PO); data conversion from a legacy system (Natural/ADABAS), JCL, CICS, SQL, PL/SQL, API’s, PL/SQL and SQL* Loader.
• Implemented changes to the custom interface (PL/SQL) that sends pick tickets from the OE/OM module (based on the delivery shipping model; WSH) to a vendor’s warehouse management system (WMS).
• Extensive architectural changes and enhanced the custom ship confirmation process which takes ship confirmations from the vendor’s WMS, and loads them into the standard Oracle Open Shipping Interface, so the data can be populated (via the standard Oracle API) into the OE/OM module.