SUMMARY:

• Oracle Professional with 17 years of experience in IT and 13 years of functional experience in Procurement, Manufacturing, Confidential modules.
• Project Management experience following SDLC and PMP methodology.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, UAT, Cut - Over and Project Coordination activities.
• Strong communication & leadership skills with an ability to interact with all the stakeholders and lead business projects.
• Work well in high pressure situations and strict deadlines. Adept in team building through leading by example and knowledge sharing.
• Strong Business acumen in analytical, problem-solving, and conceptual skills in hi-tech manufacturing industry, distribution industry and Pharmaceutical.
• Well versed with weekly status reporting, service request management, change management, incident management, problem management, project management and knowledge management.
• 12Yrs Experience in Implementation and Production Support of Oracle Application 11i&R12.

TECHNICAL SKILLS:

ERP: Oracle EBS 11i, R12, Ebizframe.

GUI: Oracle Forms/Reports 6i, Workflow, Oracle Designer9i, Discover 4i

Tools & Utilities: TOAD, PVCS, KINTANA, Work Flow, APPWORX, Vista plus.

Industry Experience: Service, Manufacturing, Pharmaceutical, Telecom.

Software Engineering: SAD, CASE Tools with Oracle Designer9i, ER Diagram.

PROFESSIONAL EXPERIENCE:

Business Analyst 

Confidential, Menomonee Falls, WI

Responsibilities:

• Defined and implemented new or improved IT system solutions in Order management, Confidential, supply chain, manufacturing, and distribution functional areas, which includes the following modules: OM, PO, ASCP, INV, BOM, ENG and WMS.
• Provided hands-on functional and technical business system process and configuration expertise to IT and Actuant’s businesses.
• Worked with business management and users to solve problems and translate business requirements into functional specifications and designs, and then take approved solutions through their respective implementation cycle.
• Acted as a key liaison between the business user community and IT staff both on a regional and global basis, and effectively report out the progress and status on any activities.
• Research and analyze new software solutions whether it is for new modules or bolt-on’s, and present such findings to the pertinent business and IT communities, like Demantra.
• Setup procurement hierarchy for requisition and purchase orders.
• Worked with manufacturing engineers to change BOM structure, costing and routing.
• Worked with MDM team for mass update of Items and BOM.
• Defined rules, strategies in WMS application to improve the performance of the equipments and pickers.
• Setup routing logic for best picking route for pickers and equipment.
• Support ASCP Confidential run, sourcing rule, ASL, ATP on daily basis.
• Post production support for INV, BOM, ENG, WIP, OM, ASCP, WMS, and PO

Sr. IS Business Analyst 

Confidential 

• Conducted workshops for gathering user requirements, perform gap analysis, configure and workarounds in Procurement & Confidential processes.
• Design architecture to consolidate the historical data and interface to Demantra.
• Create and design data model, levels, worksheets, series, workflows and user security in Demantra to meet the business requirement.
• Work closely with business user to configure Confidential and Supplier work bench.
• Worked with business user to setup sourcing rules & Approved Supplier Lists. Auto-Creation of Purchase documents and Releases according to Confidential methods.
• Work closely with various departments and IT Analysts to gather an in-depth knowledge of business processes and procedures.
• Setting up of buyer less procurement process for frequently procured items through the internal catalog for iProcurement requisitions.
• Set up of ASL's for iProcurement-requisitioned items with release generation method "Release using Create" enabling auto generation of Blanket Releases, Standard Purchase Orders against the Blanket Agreements and Catalog Quotations.
• Responsible for documentation using Oracle AIM methodology or using company standards.
• Setup Rules, Strategies and workbench for Wave picking in WMS application.
• Perform on-call application support as necessary.

Sr. Functional Consultant 

Confidential 

• Analysis of current business processes and definition of new processes within Oracle Application.
• Business requirements gathering, mapping, gap identification and workarounds using BR100 and MD50 documents.
• Responsible to trainee IT personal and implementers within modules of ASCP, Confidential, MFG, and Forecast.
• Conducted Workshops for gathering user requirements, perform GAP analysis and configure user requirement to Oracle Confidential modules.
• Fixed the Lead time issues in assemblies and schedule the process.
• Set up of Buyer less procurement by generation of Automatic Releases and Purchase Orders for iProc requisitions.
• Automate the sales order release process for Software and Media Orders, which required setup of new Order Type, Sub-inventory and Pick Release Rule.
• Setup Approved supplier list and sourcing rule for Confidential modules.
• Restricting the Desk Top receiving for iProcurement requisition (expense) items by User Departments. All items are received at Stores and then issued to User Departments outside the system.
• Design Demand at Risk report to provide the demands which need attention.
• Define and worked on the process to streamline the reservation process and auto pick-slip generation.
• Define the process to address the BOE (custom clearance issue) in Middle East Operations.
• Resolved issue in Order management, service contract, Receivable, Purchasing, Inventory modules.
• Production support for INV,BOM, WIP, ENG, ASCP, PO, OM modules.

Oracle Onsite Lead 

Confidential 

• Maintained all projects documentations following GE standard & program version control. This includes weekly status reporting, service request management, change management, incident management, problem management, project management and knowledge management.
• Worked with Business users in 11i to Scale R12 upgrade project, which includes 11i AS-IS analysis for Inquiry to Order, Order to Revenue and Procure to fulfill processes in 11i.
• Performs systems analysis, design, implementation, maintenance, and enhancement for Oracle Finance, Procurement, Engineering, and Supply Chain & Logistic Modules.
• Involved in Confidential and implementing data conversion methodology and modified the data collection process.
• Configure and test Oracle VCP applications: ASCP, IO, Smoothie ( Demantra).
• Setup architecture for SOA and Time & Labor application for project billing and employee earned hours.
• Automate "transact move order" process. Modify file to SRC to send after move order is transacted vs. current logic at pick release.
• Design new interface data file for invoice data from Oracle to 3rd party (SRC) and modified the existing intercompany invoicing program.
• Design new report to show all released and unreleased discrete jobs and the operations that are left to complete. This report is used to track, update, and prioritize the discrete jobs within WED.
• Fulfilled the iStore enhancements for voice of customer, Shipping date logic, Export compliance screen and new store setup.
• Provided the solution to load legacy data like Purchasing Items, Field Service Items, Install base Items to Oracle ERP.
• Design new report to show all released and unreleased discrete jobs and the operations that are left to complete. This report is used to track, update, and prioritize the discrete jobs within WED.
• Fulfill the Business requirement to store the scanned copies of shipping documents at receipts and then view these documents from AP invoice for Audit.
• Design the process to send the Approved Purchase Orders to Requesters, Service Manager, Project Manager and Buyers every 15 minutes.
• Setup sales order with the associated account information for Engineering Lab, which are placed via i-Store/Order management with Project numbers associated with it for downstream project accounting.

Oracle Sr. System Analyst

Western Digital, CA

Confidential

• Performs systems analysis, design, installation, maintenance, and enhancement for mission critical applications within the Supply Chain & Logistic Modules.
• Developed solutions meeting user requirements, and write functional and technical documents, and worked with technical team for development & testing.
• Worked in As-Is, To-Be, Solution Design, CRP-I, CRP-II, Solution Piloting and UAT.
• Worked in 11i to R12 upgrade in Order to Cash and Procure to Pay processes, which include testing iterations and resolving the issues.
• Designed and implemented Automation of all the Master Data changes (Forecast, Item, BOM, Routings, Resources, Sourcing rules) to Oracle ERP modules and Mass Changes of business entities (Part attributes, Categories, Resource usages, Yields etc).
• Worked with DBA on the performance of various standard collection programs for the Confidential processes.
• Setup processing constraint, defaulting rule, document sequence, pick slip grouping rule, release sequence rule, shipping document set etc.
• Modified the OM workflow to incorporate business requirement for Export Compliance Screening process.
• Setting up REALMS to restrict access to items based on the item category to users based on the business requirements.
• Integration testing iProcurement with other sub modules (PO, INV, AP and GL).
• Implemented the business process for WD Online store project, from on-hand quantity display to fulfill the Orders in Oracle.
• Automated the Internal requisition process based on sourcing rule and Auto substitution process.
• Setup Inventory Organizations and sub-inventories, item attributes and item categories, UOM conversion, ATP parameters, WIP parameters.
• Design and implemented interface process for item and BOM interface from Third party PLM system.
• Setup receiving options for inventory, document approval, sourcing rule in Purchasing.
• Trained user for PO & RMA Receiving, Inspection, Receiving transactions and Deliver to Warehouse.
• Design and implemented the strategy to upload, and update the Standard Cost on daily and quarterly basis using Cost Management.
• Modified ECO Approval workflow, notification system and program to update the Item attribute.
• Design the process to update standard cost and rollup on quarterly basis in Oracle Cost Management.
• Post production support for INV, BOM, ENG, WIP, OM, QP, CST and PO modules.
• Support Period End closing process for Inventory module and FSG reports.

Oracle Sr. Programmer Analyst

Confidential,NY

• Gather business requirements, GAP analysis, Module setup, Configuration, training end users and production support.
• Involved in 11i to R12 upgrade in various modules with business users & support team.
• Performed all functional testing to ensure that the standard and custom processes and reports worked correctly after the upgrade to R12.
• Lead Oracle ASCP module with Demand, Supply, Warehouse & Distribution Managers, understand existing Confidential, scheduling, & fulfillment processes within & outside organizations.
• Perform ASCP setups including Instance, Plans, and Options, executed test scenarios.
• Setup of Inventory, Order Management, BOM, WIP and Cost Management.
• Setup Defaulting Rule, Processing Constraint, Order type, ATP rule and Scheduling.
• Setup Price list, Qualifiers, Modifiers and other advance pricing processes.
• Setup Bill of Material/routing and routing redesign to support outside processing for furniture items.
• Functional Testing of Order to cash, and Procure to pay process.
• Design and implemented order import process using Order Import interfaces for the Web Orders and legacy system orders.
• Design Customer Information form for Customer Services, which enables user to view important information of the Customer, Open/Closed Orders, and aging information and roll up summary of the Customer.
• Design and implemented Product life cycle Inquiry form for Research group and Design team, which enables user to view day-to-day activity of the items.
• Design and implemented on-demand Invoice & Receipt print/fax/email form and customized Invoice creation program to incorporate new requirements.
• Setup address validation process based on Satori Software address management solutions for TCA.
• Design and implemented complete process which uploads the Export/Import information to Integration Point Server.
• Design and implemented the shipping process to interact with the Pitney server to calculate freight charges and tracking information for the deliveries.
• Modified the Mobile Supply Chain Management programs which are used by RF Scanners to scan the bar codes in inventory.
• Design and implemented data migration from legacy system to Oracle Applications for Item import, Order Import, Pricing Import and Customer Import.
• Setup of Inventory, Order Management, BOM, WIP, WMS, Cost Management.
• Month end closing for Inventory and resolve the issues for the unprocessed transactions.
• Production support for Manufacturing and Confidential modules.

Oracle Apps Consultant

Confidential,Fairfield,NJ

• Design Price list Validation process and Preview Form to review and correct errors in Price list Lines.
• Design Concurrent Programs to submit pricelist upload from the above form after the corrections are completed.
• Design Concurrent Programs to Create a New Price List that maintains all Zero Dollar Products of certain type (Option Classes, Option Model, Branding Kit, Software Drivers and others) as Price List Lines.
• Modify the Custom Library, not to copy the Price List from the BOM Header Price list to the Zero dollar Price list items.
• Customized Service Contract Form to obtain the correct price for the combination of Labor item, servicing entity and product category type, and then up lift that price by a percentage uplift factor that is associated to the service zone in which the service was performed for direct service entities.
• Customized workflow process to ‘provide the ability to automatically generate and send notifications and approvals pertaining to sub inventory transfers for various reasons in different stages of the Move order processes’.
• Customized Order Header Workflow to Uplift the price of machine (child items on BOM) items based on the Leased factor.

Oracle Apps Consultant 

Confidential,FL

• Design and implemented Quotation Workbench and integrated with Order Management.
• Design and implemented Data Conversion and Data Migration for Custom Pricing module.
• Design Sales Order confirmation Report, BSA Confirmation Report.
• Design and implemented Concurrent Programs Quotation Into-Plane Report based on Template to be sent to Customer.
• Design and implemented API to Email and FAX the Reports to be sent to Customer and Supplier.
• Design and implemented API to store and maintain the transmission status of the Documents sent to the customer.
• Personalize the PO Receiving Form, which must be priced at the time of receiving as per the date sensitive nature of the transaction.
• Worked with GL Account Balance Inquiry Report in order to report all the Accounts with the PTD and YTD Balances in a particular period.

Oracle Apps Technical Consultant

Confidential,MI

• Developed an interface for Invoice Creation, assigning the purchase sourcing rules for creating the Purchase order.
• Developed Concurrent program Inactive Supplier Report.
• Developed an interface program for doing the manual ship-confirm after receiving the shipping information from AS/400 ADC system.
• Developed and Designed Concurrent Programs HDL Move Results Report to Show the Status on Stage1 and Stage2 as well as Final Status of the Various Move Orders.
• Developed and Designed Concurrent Program to Close to Stage2 Move Orders for which Stage1 is Complete.

Confidential

Oracle Sr. Software Engineer

• Preparation of AS-IS Analysis Document of the existing 10.7 version code.
• Preparation of Technical Design Document from Functional design documents.
• Setup Defaulting Rule, Processing Constraint, and order type and prepare test cases.
• Design and developed ‘EC Order Correction Form’ which is used to correct the sales orders which has been imported from various Ordering Tools.
• Developed Concurrent Programs ‘Cisco Deal Management Report’ to track the deals with the customers
• Design and implemented Form Function ‘Service Form’ through which all the services provided by Cisco are defined, maintained and tender is created.
• Integrated Sales Order data from IC Engine to Order Management tables using API’s.
• Preparation of Unit Test Case for the Customized and New Developed Objects.
• Created end user training manuals and perform end-user training.
• Functional testing of Order Management and Inventory Modules.
• Preparation of Unit Test Case, Unit Test Results for the Custom Objects.
• Developed and deployed international CRP and UAT.
• Setup Alerts to monitor business processes and system performance.

Confidential

Clinical Trial Supply Chain Management

• Worked on Interfaces (IVRS- electronic interfaces to outside systems) Technology, which is the electronic interface to the outside world using the Third Party Software Clinphone.
• Developed on Oracle Advance Queuing for sending messages once a consignment is Shipped Confirmed.
• Design the process to send Emails to the Concerned Authority when a new Formulation is created.
• Design and Developed Form Function for storing Labeling Information.
• Developed Report for the traceability of intermediate inventory and process steps of complex dosage formulations.
• Preparation of Unit Test Case and Unit Test Results.
• Worked in Clinicopia, IVRS, Advance Queuing.