SUMMARY:

• Over 14 years of implementation experience in Information Systems
• 9 plus years of experience in Oracle ERP e - Business Suite on Supply Chain modules
• Extensive experience as a functional consultant for Oracle EBS(R12/11i) in Manufacturing and SCM modules
• Experience in business cycles, P2P(Procure to Pay) and O2C(Order to Cash)
• Proficient in implementation process mapping, user training, functional design specifications and configurations
• Ability to handle full life cycle implementation going through Development (DEV), Conference Room Pilot (CRP), User Acceptance Test (UAT) and Go-live and post production support in Multi-Org Environment
• Expertise in Fit-Gap analysis and providing solutions in coordination with Oracle Support
• Development of data conversion strategy, master data and transaction data conversion from legacy systems or old releases, manual records using data loader, SQL, manual methods, handling errors in interface tables
• Experience with 3PL material movement and Consigned Inventory and VMI
• Expertise in Business/Configuration/Implementation of Manufacturing modules as per business and system functional requirements and ERP architecture, and integration with custom objects
• Transition plan to Go-live, Cutover planning. Month end closing process and procedures
• Experience organizing status meetings, preparing and presenting project status reports
• Ability to effectively coordinate with multiple end-users and lead and manage 7 - 8 member teams

TECHNICAL SKILLS:

Oracle ERP Modules: Inventory, BOM, ENG, WIP, PO, CST, OM, PIM, QP, WMS, MSCA, Quality

Oracle Tools: Data Loader Pro, SQL * Loader, TOAD

Programming Languages: Java, C/C++, Visual Basic, X-Windows

Databases: MS Access, SQL Server, PL/SQL, Oracle 8i

QA Tools: Test Director, Win Runner

Scripting: ASP, VB Script, Java Script, VBA

Operating Systems: WINDOWS, Linux/Unix

Others Tools: Visio, Microsoft Project, Rational Rose, MS Word/Excel/Power Point, UML

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Team Lead/Jr. Project Manager

• Responsible for managing onsite and off-shore resource deliverables
• Managing work load and expectations of all team members
• Responsible for monitoring and tracking of progress of all change requests in the track
• Responsible for analyzing and understanding the current business process
• Responsible for capturing new requirements from Business Users
• Responsible for providing solution to on-going issues in the existing system through system or process changes
• Responsible for preparing and reviewing Functional Design documents for changes and enhancements
• Responsible for developing test scenarios and test cases for various testing cycles

Confidential, Charlotte, NC

Senior Oracle Supply Chain Consultant

• Responsible for configurations in INT, FIT instances for Inventory
• Responsible for developing test scenarios and test cases for testing cycles
• Responsible for capturing new requirements from Business Users and creating new or change requests
• Responsible for creation of MD050 and TE020, along with functional testing for assigned Change Requests
• Supported Static and Dynamic data conversion activities for business users as well as conversion team
• Designed and supported new 3PL material transfer solution for IR with added security and visibility for 3PL providers
• Conducted and lead Recon and Process confirmation sessions with Business users
• Responsible for Capturing and assessing requirements for new WMS Sites
• Assist support team on Inventory/WMS issues if required

Confidential, Torrance, CA

Oracle Supply Chain Consultant

• Understanding As-Is business processes
• Provide on-going support to business users for Manufacturing, SCM and WMS issues
• Understanding the customizations and troubleshooting day to day issues
• Providing solutions and enhancements for on-going issues
• Suggesting changes to improve efficiency through business process and technical enhancements

Confidential, Danbury, CT

WMS/SCM Functional Consultant

• Understanding current business processes
• Responsible for business review sessions and identifying change points
• Responsible for conducting user training workshops, Integration testing, UAT support and Production support
• Responsible for setting up Handheld scanner and labeling system for scanner interface
• Responsible for setting up WMS lags, Label formats, Warehouse rules
• Responsible for defining and loading up new Collections Plans
• Responsible for internal testing for current and new business processes such as IR/ISO, Demand to Build, Shipping using WMS
• Provide on-going support to business users for Manufacturing,O2C and WMS issues
• Responsible for Purchasing, Inventory, Order Management, BOM, WIP and WMS modules

Modules: Oracle 11.10.2 INV, PO, OM, BOM, WIP, WMS, Quality

Confidential, Plano, TX

Project Manager

• Managed the entire project from requirements analysis phase to post Production support
• Managing a team of 5 off-shore and 3 on-site resources
• Understanding current business processes and determining the scope of the Integration
• Managing project schedule and deliverables such as BR-100, BP-080, MD-050, TE-040, CV-040, CV-010
• Responsible for planning resource requirements and managing off-shore and on-site resources
• Understanding the customizations and providing optimal solutions per business needs
• Responsible for providing solutions and coordinating data migration activities
• Responsible for planning and tracking activities for SIT, UAT and Go Live
• Responsible for Purchasing, Inventory, Order Management, BOM and WIP modules
• Responsible for providing guidance on approval Hierarchies for POs and Requisitions
• Conducted CRP and training sessions with key users
• Managing process review sessions with stake holders across globally spread departments
• Setup Oracle Quoting flow and Advanced Pricing parameters to meet the business requirements
• Provide Post Production support to REFTEK users for Manufacturing,O2C and P2P issues

Modules: Oracle 11.10.2 INV, PO, OM, BOM, WIP, AR, AP, CST, QP, MRP, Quality

Confidential, Sherman, TX

Lead SCM Functional Consultant

• Understanding current business processes
• Provide on-going support to business users for Manufacturing,O2C and WMS issues
• Understanding the customizations and troubleshooting day to day issues
• Responsible for providing training and handling issues for iSupplier and iProcurement
• Understanding and preparing MD-050 for enhancement/interfacing requests
• Responsible for analyzing root cause and providing solutions for recurring issues

Modules: Oracle 11.10.2 INV, PO, OM, BOM, WIP, WMS, iSupplier, iProcurement

Confidential, Miami, FL

Lead SCM Functional Consultant

• Understanding current business and requirements for inventory warehouses
• Configuring Inventory and Purchasing for various warehouses
• Identifying and defining approval hierarchies for Purchase Orders and Requisitions
• Responsible for developing a project plan and implementing the solution at each warehouse
• Responsible for conducting user training workshops, UAT support and Production support
• Responsible for setting up Handheld scanner and labeling system for scanner interface

Modules: Oracle 11.10.2 INV, PO

Confidential, Plano, TX

Sr. SCM Functional Consultant

• Provide on-going support to business users for P2P, O2C and Inventory
• Understanding the customizations and troubleshooting day to day issues
• Responsible for supporting issues for Month-end close, Average Costing, Period Reconciliation
• Responsible for providing solutions for enhancements to current business practices
• Provided implementation and training support for iSupplier and iProcurement
• Responsible for analyzing root cause and providing solutions for recurring issues
• Responsible for preparing MD-050 and reviewing MD-070 for new enhancements
• Responsible for conducting business review sessions for POC of new ideas
• Setup WMS Rules, Process and Labeling for POC of WMS
• Involved in decision making process for implementing WMS, reviewing and analyzing vendor quotes

Modules: Oracle 11.10.2 INV, OM, PO, WMS, CST, iSupplier, iProcurement

Confidential, Hartford, CT

Inventory and PIM Functional Consultant

• Work closely with primary stake holders to develop proof of Concept
• Interact with business users to understand and gather requirements
• Responsible for developing a work plan, executing and configuring instances for PIM
• Responsible for business review sessions and identifying change points
• Responsible for training users and support staff on PIM configurations
• Responsible for setting up Product Lifecycles, Item Catalogs, Attributes and Attribute Groups
• Designed interfaces for interaction of external systems to the Product Data Hub (PDH)
• Designed and setup approvals for progressing through various Item Phases
• Responsible for defining business rules and validation dependencies for attribute groups
• Prepared BR-100, Design and Data Mapping Documents for external interfaces
• Conducted several design and discussion sessions with the technical team to communicate business needs and customizations

Modules: Oracle R12 PIM, Inventory, BOM

Confidential, Alpharetta, GA

Inventory and PIM Business Analyst

• Analyzed current functionality and understood the clients’ need to propagate data from Mobility to CFAS
• Conducted several review sessions with key business users to gather detailed requirements and gaps
• Responsible for developing and maintaining BR-100, MD-050 and TE-040 for all RICE components affected
• Conducted technical discussion and review sessions with technical development team to communicate requirements and change requests on custom programs from the business
• Responsible for all INV and PIM RICE Components
• Responsible for enhancements to Audit transactions sent to CATS
• Responsible for executing functional, integration and performance testing of INV, PIM and Audit RICE components
• Setup Attribute Group and catalog for new CFAS Attributes in PIM and assessed business rules required for validation of those attributes
• Responsible for designing the interfaces that interact from PIM to other modules

Modules: Oracle 11i Inventory, PIM, PO interfacing with Oracle R12

Confidential, Seymour, IN

Lead SCM Functional

• Performed AS IS Analysis for the 11.5.8/11.5.9 setup and Identified GAPs with 11.5.10
• Provided detailed understanding to the users on change points and impact of moving to a Multi-Org environment through extended key user sessions
• Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology
• Responsible for developing and maintaining documentation like BR-100, CV-40, test scripts and results
• Implemented FIFO/Standard Costing for the Companies based on their business needs of MRO and Stock-cage Items
• Responsible for validating and ensuring accurate Cost Updates, Cost Rollup and Inventory Valuation
• Responsible for providing the technical team with data mapping and communicating requirement changes from business users for Items, Bills, Routings, Purchase Orders and system setups etc
• Worked with Custom Development team for analyzing the custom programs interfacing with Virtual Factory, Data Match, Custom Min-Max and Production Reporting and AS400 system
• Responsible for providing specifications, and test custom reports and programs
• In charge of all SCM and Manufacturing Modules INV, BOM, WIP, Purchasing, iProcurement, Mobile Supply Chain, Costing
• Gathered and analyzed current setups for iProcurement and Purchasing
• Responsible for setting up Oracle Purchasing and iProcurement for all employees in various units
• Responsible for validation of data and coordinating data conversion activities with conversion team
• Provided extensive user support during UAT and Post Production phases

Modules: Oracle 11i Inventory, BOM, WIP, Purchasing, iProcurement, MSCA, CST

Confidential, Alameda, CA

Functional Consultant

• Performed AS IS Analysis for the 11.5.9 setup and Identified GAPs with R12
• Analyzed business requirements and performed fit-gap analysis to map user requirements to 11i functionality / transactions utilizing Oracle’s AIM Methodology
• Responsible for developing and maintaining documentation like BR-100, CV-40, TE-40
• Responsible for providing the technical team with data mapping and communicating requirement changes from business for Items, Bills, Routings, Sales Orders, etc.
• Conducted CRP (Conference Room Pilot), integration testing and performed extensive UAT, along with daily conference calls with China users for data validation and clean up
• Designed customized forms based on user requirements
• Prepared TE-40 and executed the key test scenarios which include both inbound and outbound interfaces with external systems
• Responsible for understanding and documenting the O2C process and customizations required
• Suggest processes to streamline quote creating and sales ordering with Quoting
• Set up templates for Oracle Quoting
• Responsible for setting up Customers, Global Pricelists, workflows
• Provided end user training for Purchasing staff
• Provide primary support personnel for P2P issues
• Responsible for data validation and maintaining sanity of data during data conversion of master data as well as transaction data elements

Modules: Oracle R12 upgrade, Inventory, BOM, WIP, Purchasing, Quoting, OM

Confidential, Chicago, IL

Functional Consultant

• Performed AS IS Analysis and Identified GAPs
• Analyzed business requirements and performed fit-gap analysis to map user requirements to 11i functionality/transactions utilizing Oracle’s AIM Methodology
• Conducted extensive business workshops to understand RD-50 and prepare document CV-20 for data conversions
• Configured Order Management, Inventory and Purchasing modules
• Involved in preparation of training material and training setup
• Conducted business workshops/trainings to explain OM and INV modules, workflows and review end-user and super-user feedback for improvements
• Analyzed the business process for O2C cycle and configured the system accordingly
• Responsible for mapping and cleansing of customer data to convert from legacy format to Oracle
• Provided support in raising TARS, applying patches and problem-solving
• Provided Post-Production support remotely

Modules: Oracle 11i Implementation, Order Management, Inventory, Purchasing

Confidential, Fremont, CA

Functional Consultant

• Analyzed user requirements to 11.5.9 functionalities and mappings within the BOM, Inventory, WIP and OM Modules
• Provided manufacturing functional expertise during development of manufacturing execution system
• Setting up the Order Management, Shipping Execution modules after finalizing on the requirements
• Provided Super User and End User support for respective modules
• Provided support and coordinated with the Financial team for O2Cprocess
• Performed bug checking and logging and followed up the TAR resolution process
• Helped continuously adapt OMM’s business process and Oracle ERP System to support a dynamic business environment

Modules: Oracle 11.5.9, Order Management, Inventory, BOM, WIP

Confidential, Annapolis, MI

Business/Implementation Analyst

• As key member of the implementation management office, organized work into discrete projects/releases with input from management
• Conducted Review of existing business process & technology environments
• Responsible for collecting, processing, validation, integration, analysis, and dissemination of data
• Worked with Project Managers to ensure and manage change to scope/requirements with regard to schedule, cost, and quality
• Consulted with end users and business users and gathered business data requirements
• Conducted extensive interviews with developers, operations personnel and application users
• Created test plans, developing test scenarios and executing expected test results for quality assurance, regression, parallel and end-to-end testing
• Authored Project Strategy Document, Use Case Specifications, Reporting Requirements Specification and Graphical User Interface Specification
• Liaison between the clients, operations and software development teams
• Spear headed the implementation and provided maintenance engineering
• Provide development support for any current engineering requirements for existing applications and supporting client requests
• Provide software support for developing and maintaining in-house applications using VB/C/C++
• Conducted System Analysis by interacting with managers and users to gather requirements
• Assisted to generate periodic & accurate report generation to manage MIS activities
• Evaluated, maintained, provided feedback to improve efficiency of operational process
• Developed and implemented new procedures, system automation, policies, paperwork to simplify and improve operations

Environment: UML, Visual Basic, C/C++, Solomon, SQL Server, MS Access, Rational Rose, HTML, UML, JavaScript, Visio, HTML, Java, Linux, X-Windows, C/C++, MySQL, Apache Server, VMWare