SUMMARY

• Oracle SCM Applications consultant with over 15 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, Test scripts 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 toanalyze information needs and functional requirements and deliver the followingartifacts 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/SQLTools 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: ,, tRational, OLAP and ETL Concepts

PROFESSIONAL EXPERIENCE

Confidential, St. Louise, MO

Oracle EBS Supply Chain WMS Function Lead

Environment: WMS, INV, OM TOAD

Responsibilities:

• Roll-Out Project for WMS.
• Created various WMS rules, strategies, pick release rules, grouping rules, Material statues etc.
• LPN, Advance task frame work
• Pull replenishment, Opportunistic cycle counting, Planned/opportunistic cross docking

Confidential, Temple, TX

Oracle EBS Supply chain techno-functional

Environment: WMS, INV, OM TOAD

Responsibilities:

• Worked as an implementation techno-function consultant of reimplementation project for MO, INV, WMS implementation.
• Designed the M50 and MD70’s for the project
• Write the AS-IS process maps
• Did CRP pilot for the OM, INV, WMS.

Confidential, Lancaster, OH

Oracle EBS Supply chain techno-functional Implementation & Support Lead

Environment: PO, OM, INV, WMS, BOM,WIP, ASCP TOAD. Oracle Applications 11i and 12.2.4

Responsibilities:

• Implementation lead for WMS, OM and PO
• Post Implementation Production Support for (WMS, PO and OM,).
• Set up complete WMS configurations.
• Advance Task Framework design and Setup
• Pull Replenishment
• Opportunistic Cross Docking Setup
• Planned Cross Docking Setup
• Rules and strategies design and setup
• Business Process Study, Defining solution premises, Solution Design, CRP, UAT and Production instance setups.
• Prepared User manuals, Test Scripts.
• EDI integration of oracle MO.
• Provided training to end-users.
• Designed reports and add-ons and coordinated with the technical team to monitor development progress, interfaces prepared MD50 and MD70 and data migration activities Coordinate testing/verification of all application solutions.
• Production support for Manufacturing modules BOM and WIP.
• Worked on Business reports of ASCP, Inventory, order management and WIP modules.
• Resolving functional issues related to SCM Modules.
• Update/Modify master data as required.
• Analysis of any functional issues reported from current Oracle E-Business Suite solution and providing suitable resolutions/workarounds for the issues wherever feasible.Implemented Loftware label middle ware for the printing of the label in the enterprise.
• Working with support technical resources to resolve problems and optimize their daily deliverables and ensure that the correct project / support priorities are determined.
• Implemented Loftware label solutions and phased out the Zebra legacy labels.
• Vendor selection for MSCA and network for the hand held computers.

Confidential

Oracle EBS techno-functional

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

Responsibilities:

• Primary contact for implementation of SCM modules
• Involved in implementing the SCM modules (WMS, PO and OM)
• Business Process Study, Defining solution premises, Solution Design, CRP, UAT and Production instance setups.
• Prepared User manuals, Test Scripts.
• Developed the rules and strategies or the inventory allocations.
• Complete configuration of WMS system set ups.
• Advance Task Framework design and Setup
• Pull Replenishment
• Opportunistic Cross Docking Setup
• Planned Cross Docking Setup
• Opportunistic Cycle counting
• Rules and strategies design and setup, build complex rules for specific business case.
• Implemented Loftware label solutions and phased out the Zebra legacy labels.
• Vendor selection for MSCA and network for the hand-held computers.
• Provided training to end-users.
• Designed reports and add-ons and coordinated with the technical team to monitor development progress, interfaces and data migration activities
• Participated in the review meetings
• 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.
• Coordinate testing/verification of all application solutions
• Participated in the review meetings

Confidential, Irving, TX

Oracle EBS Implementation Lead

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

Responsibilities:

• 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.
• Advance Task Framework design and Setup
• Pull Replenishment
• Opportunistic Cross Docking Setup
• Planned Cross Docking Setup
• Rules and strategies design and setup
• 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.

Confidential, Hanover PA

Oracle EBS Applications Lead

Responsibilities:

• Gathering Business Requirements from business users and preparing Business Requirement, Functional Design, BR100, Test Scripts, Test Scenarios documents.
• Oracle WMS configurations and rules, strategies, ATF, pick wave.
• 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

Confidential, Arlington TX

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.

Responsibilities:

• 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.

Confidential, San Diego, CA

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.

Responsibilities:

• 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

Confidential, Napa, CA

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

Responsibilities:

• Involved in upgrade of Oracle EBS 11. .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

Confidential, Miami, FL

Oracle e-business suite consultant

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

Responsibilities:

• 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.

Confidential, Phoenix, AZ

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.

Responsibilities:

• Participated in Full Life Cycle Implementation of Oracle Warehouse Management (WMS),Inventory (INV), Order Management (OM),Mobile Supply Chain Applications (MSCA) in Multi-Org, Multi-Currency environment for Leviton’s Canada warehouse.
• Involved in consolidation of multiple Distribution Centers into an Automated Distribution Center with Oracle WMS with estimated annual savings of more than $8M in transportation and maintenance expenses. This including facility infrastructure remodeling, Item transfer, building labeling, documentation and communication policies and procedures, etc,
• Setup of directed picking and directed put away.
• Automated task assignments, picking methodologies and work flow.
• Cross docking and License plating (LPN).
• Material handling and equipment integration.
• GTIN compliance configurations.
• Generated cycle counts and physical inventory.
• 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.