SUMMARY:

• Around 8 years of IT experience as a Functional, Technical & Management Consultant using Oracle Applications (11i and R12) in Manufacturing and Financial modules.
• Experience in Client Management, Guiding Users, technical teams and Strong Oracle Applications Gap Analysis, implementation, Upgradation, Customizations and support experience in Manufacturing and Supply Chain modules.
• Experience in Manufacturing Modules Inventory (INV), Bill of Material (BOM), Work in Process (WIP), Mobile Supply chain module (MSCA), Manufacturing Execution systems (MES), Advanced Planning and Scheduling (APS), Purchasing (PO), and Order Management (OM), Costing,Quality, Oracle Process Manufacturing (OPM) and organizational assessment, WMS (Oracle Warehouse Management), Supply Chain Management and business process improvement, Oracle Approval Workflow (AME).
• Experience in scoping and supporting Oracle Applications 11i. Areas of expertise include: General Ledger(GL), Global InterCompany System, Accounts Receivables(AR), Fixed Assets(FA), Accounts Payables(AP) and Oracle iExpenses, iPayments, iReceivables,iProcurement, Purchasing, Order Management, Cash management, EAM, Advanced Pricing, Advanced Collections, Service Contracts, Renewals, Inventory, iSupplier, FSG Reports, AGIS and EB TAX, Trade Management modules for (B2B, B2C,B2B2C)Oracle Accelerator.
• Expertise in Preparation of Process Documentations, Training Materials & User Trainings like BR100, MD50, etc using AIM Methodology.
• Completed full life cycle Oracle Manufacture implementations of Inventory (INV),MRP, Bill of Material (BOM), Work in Process (WIP),Advanced Supply Chain Planning (ASCP ),Purchasing (PO), Order Management (OM), Material Requirement Planning (MRP).version, 11.03 and 11i (latest version 11.5.10.2)&R12 using AIM, FFRM (Fast Forward Rapid Implementation) and R2i methodology.
• Responsible for maintaining and improving the Manufacturing and Purchasing business processes, Oracle Configuration and data reporting while ensuring regulatory compliance.
• In depth knowledge of Order to Cash and Procure to pay business cycles.
• Highly organized. Ability to work under pressure in fast - paced environment. Excellent interpersonal skills with an ability to interact with individuals Confidential all levels and to mobilize and lead a team.

TECHNICAL SKILLS

Databases: Oracle Database Version 10g/9i/8i, MS SQL Server 2000

Languages: C,SQL,PL SQL

Internet Technologies: JSP, JDBC and Servlets

Oracle Apps Modules: Inventory(INV), Bill of Materials (BOM), Costing

Oracle Tools & Other Tools: SQL*Loader Developer 6i/2000 and PVCS Version Manager

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

Oracle Apps Functional Consultant

Responsibilities:

• Requirement gathering and Implementing Advanced supply chain planning (ASCP) in OPM Manufacturing environment.
• BR100 and forecast mapping documents to integrate the legacy system to Oracle.
• ASCP proof of concept and user training.

Confidential,Minneapolis, MN

Oracle Apps Functional Consultant

Responsibilities:

• Order Management/Pricing,Shipping(OM): Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules and Successfully created Orders, Attached pricelists, Pick released, Ship confirmed.
• Inventory (INV): Setups for Inventory module like Items Flexfield, Item Categories Flexfield, Item Catalog Group Flexfield, Stock Locators Flexfield, Account Aliases Flexfield, Sales Orders, setups for Inventory Module like. Locations, Organization Calendar, Organizations,setups for Inventory Module like Item Categories, Item Attribute Controls, Item Catalogs, Item Type, Item Cross Reference, Inventory, Parameters, Unit of Measure,Setups for Inventory Module like Transaction Source Types, Transaction Type, Item Templates, Subinventory, Stock Locators, Shipping Network, Shipping Methods, Physical Inventories.
• Manufacturing (MFG/MES/MSCA/WIP/BOM)
• Requirement gathering, gap analysis and wrote BR100 document for implementing Inventory, Work in Process(WIP), Bill of Materials (BOM) (and Routings),Costing, lead times, Shifts, Resource setups (both Labor and Machine setups), Work Order entries and Scheduling (both Manual and Automatic).
• Upper level and sub assembly level work orders/ Items/ Parts Costing and Cost setups.
• Calendar and resource Shifts setups. Also, resource instances setups.
• Wrote Functional Specification documents (MD050) for custom solutions and designs for various process flows in Work in Process (WIP) module.
• Implemented Manufacturing Execution Systems (MES) for discrete manufacturing.
• Worked in manufacturing scheduling module(s) both Resource and Job Workbenches.
• Post go-live support, troubleshooting (techno-functional role).
• Conducted multiple training sessions with the Users in Manufacturing and Scheduling modules.
• Worked extensively on Mobile Supply Chain Applications (MSCA).
• Worked on providing solution and designs for Label printing for business transactions like WIP Issue, Sub Inv Transfer, PO/RMA Receipts and other various transactions, by sending XML data to Loftware system from Oracle Forms and hand held devices.
• Prepared necessary documentation and user manuals and testing the Functionality of application and Validations.
• Designed MES solution for the business by various setups and features provided by Oracle plus OAF customizations and personalization’s, on different levels - Site, Role, Responsibility and Department.
• Worked in Engineering module - Created Items, BOMs, Routings, and Revisions of each under Proto Type before transferring them to Production by Implementing ECO’s.
• Also played Techno Functional role, by developing queries in order to provide various extracts for Reporting or Data conversion issues/solutions/validation purposes for the business.

Environment: Oracle R12, GL, AR, AP, PO, OM, WIP, Costing, BOM, MES, MSCA, Engineering, Planning/Scheduling, data conversion, Quality.

Confidential, Kansas City, MO

Oracle apps Techno/Functional consultant

Responsibilities:

• Prepared the CV040/CV060 Conversion Mapping/program design document for the Customer conversion
• Good understanding of Project Accounting (Costing and Billing) Module.
• Oracle Fixed Assets module organizes asset information in different books. Migrated assets from one organization to other organization.
• Fixed bugs and resolved the issues related to depreciation run
• Worked on Oracle Reports and BI/XML publisher.
• General Ledger (GL)/Fixed Assets(FA): Managed FA GAP Book & Tax Book Setups, Major Minor Categories. Set up locations. Ran ADI uploads for FA. Trained user's on how to perform mass additions, run depreciation, post to GL. Set up Set of Books (Reporting & Functional), Calendars, Currencies, Cross Validations Rules, Key Flex Fields, GL Combinations etc. Associated sub-ledgers with Set of Books. Trained Users on running month end processes, run trial balance, reconciliations, revaluation, reclassification etc.

Confidential, Dallas, TX

Oracle apps Functional consultant

Responsibilities:

• Setups for Data Collection, Instances, Organizations, Profile Options, Item Categories, Item Attributes, Forecast, MPS, Plant-Warehouse using OPM Process Planning, In-transit Lead Times, Assignment Sets, Sourcing Rules, Planning Parameters, Plan Options and Integrated with OPM. Successfully run Collections of source data into ODS, and generated centralized Unconstrained and Constrained plans and successfully released Planned Orders (Purchase Orders and Batches).
• Created items by discrete inventory and assign it to OPM warehouse.
• Customized batch pick list report and customized physical inventory forms in OPM.
• Designed and developed Staging Tables, Conversion Routines and Custom PL/SQL API’s to import OPM Items, Lots, Stock Locators, Onhand Quantities from GE water Legacy system to oracle.
• Developed and customized forms in OPM Process Execution for allocating the material for the batch.
• Streamlined material transactions by lot and serial entry by using Oracle MES.
• Complete Assembly, Move Assembly, Return Assembly, Return from Scrap, Return from Reject, Reject Assembly, Move and Complete, Return and Move, and Scrap Assembly transaction pages in Oracle MES.
• The Candidate list of parts generated using the ‘End Item Substitution’ logic is utilized in fulfillment and planning areas for scheduling and optimization to balance the need to Ship customer most current part configurations while minimizing excess Inventory.
• Experience in Running collections and running plans (Master Production Plan, Distribution Plan, Material Requirement Plan) and its setups for sourcing rules, assignment sets, instances, inventory organizations, shipping networks etc.
• Designed and developed conversion of WIP work orders from ISSESS (legacy system) to oracle.
• Customized WIP outside Processing (OSP) to send email notifications to group of people.
• Worked on preparing Functional Specification (MD050), Conversion Mapping Documents (CV050), user training manuals, test procedures document preparation and CRP. Experienced with iExpense and iProcurement
• Worked in WMS environment for Material handling business process for manufacturing facilities, warehouses and distribution centers.

Environment: Oracle Applications R12, INVENTORY,BOM, MSCA, OM,WMS, Costing.

Confidential,Dallas, TX

Oracle apps Functional consultant

Responsibilities:

• Requirement gathering, gap analysis and wrote BR100 document for implementing Inventory, Work in Process(WIP), Bill of Materials (BOM), ASCP, Order Management (OM), Oracle Purchasing (PO),Costing..
• Inventory (INV): Setups for Inventory module like Items Flexfield, Item Categories Flexfield, Item Catalog Group Flexfield, Stock Locators Flexfield, Account Aliases Flexfield, Sales Orders, setups for Inventory Module like. Locations, Organization Calendar, Organizations,setups for Inventory Module like Item Categories, Item Attribute Controls, Item Catalogs, Item Type, Item Cross Reference, Inventory, Parameters, Unit of Measure,Setups for Inventory Module like Transaction Source Types, Transaction Type, Item Templates, Subinventory, Stock Locators, Shipping Network, Shipping Methods, Interface Manager, ABC Compiles, e ABC Classes, ABC Assignment Groups, Cycle Counts, Physical Inventories
• Wrote Functional Specification documents (MD050) for converting Items, Item Categories, Item Revisions, Stock Locators.
• Work in Process(WIP):Setups for WIP Accounting Classes, WIP Parameters, Production Lines, Repetitive Line/Assembly Association, Schedule Groups, Employees, Employee Labor Rates, Shop Floor Statuses, Job/Schedule Documents, Operations Documents, Report Sets
• Bill of Material(BOM): Involved in defining Bill of Material and Routings for manufactured products and subassemblies for ordering configuration. Created test scripts related to Order Management and BOM.
• Costing: Define System profiles, item category for costing, Cost category codes, Cost types, Activities and activity Costs,WIP accounting class,resources,overheads,Material overhead defaults, overhead sub elements, category accounts, cost group, organization cost group, cost type association.
• Order Management/Pricing,Shipping(OM): Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules and Successfully created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).

Environment: Oracle Applications R12, INVENTORY, BOM, WIP, MSCA, Engineering, OM, PO, AR, MRP, WMS environment.

Confidential, Dallas, TX

Oracle apps Functional consultant

Responsibilities;

• Involved in analyzing the Business and Functional Requirements and mapping it with the features of Oracle Applications.
• Involved with Fit-Gap Analysis, Solution Design Phase.
• Responsible for the preparation of the MD 50 documents as well as Involved in the preparation of the BR 100 setup documents.
• Inventory (INV): Setups for Inventory module like Items Flexfield, Item Categories Flexfield, Item Catalog Group Flexfield, Stock Locators Flexfield, Account Aliases Flexfield, Sales Orders, setups for Inventory Module like. Locations, Organization Calendar, Organizations,setups for Inventory Module like Item Categories, Item Attribute Controls, Item Catalogs, Item Type, Item Cross Reference, Inventory, Parameters, Unit of Measure,Setups for Inventory Module like Transaction Source Types, Transaction Type, Item Templates, Subinventory, Stock Locators, Shipping Network, Shipping Methods, Interface Manager.
• Bill of Material (BOM): Involved in defining Bill of Material and Routings for manufactured products and subassemblies for ordering configuration. Created test scripts related to Order Management and BOM.
• Advanced Supply Chain Planning (ASCP): Setups for Data Collection, Instances, Organizations, Profile Options, Item Categories, Item Attributes, Forecast, Intransit Lead Times, Assignment Sets, Sourcing Rules, Planning Parameters, Plan Options. Successfully Run Collections, Centralized Plan and generated Suggested Purchase Requisitions and Work Orders and Pushed Back to the Source.
• Costing: Define System profiles, item category for costing, Cost category codes, Cost types, Activities and activity Costs, WIP accounting class, resources, overheads, Material overhead defaults, overhead sub elements, category accounts, cost group, organization cost group, cost type association (on WMS environment)
• Order Management/Pricing, Shipping(OM): Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules and Successfully created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).

Environment: Oracle application 11i.5.10 and R12 (Inventory, WIP, BOM, ASCP, Order Management, Shipping, Purchasing & Costing), OPM, WMS environment.

Confidential, Las Vegas, NV

Oracle apps Functional consultant

Responsibilities:

• Analyzing the purchasing process (Procurement) flows for CNet network business units.
• Interacted with business users to create Solution design documents (BP, MD, CV and PM).
• Mapping the CNet purchasing process to the Standard Oracle purchasing and payables modules (Procure-to-Pay cycle).
• Design - mapping Oracle data model to the third party tool and identifying the customizations as required for the integration.
• Design, Development, testing and User training for the customizations.
• Oracle Inventory and OM setups for O2C (Item definition, Category definition, list price and etc).
• Worked in Manufacturing scheduling and planning modules.
• Data mapping/Integration between Oracle Purchasing, Payables modules and third party software. Approval routing enhancement to meet the business requirement

Environment: Oracle Applications R12 INVENTORY, BOM, WIP, ASCP, OM, PO, Pricing &Shipping.

Confidential, Dallas, TX

Oracle Functional Consultant

Responsibilities:

• Involved in analyzing the Business and Functional Requirements and mapping it with the features of Oracle Applications.
• Inventory (INV):Setups for Inventory module like Items Flexfield, Item Categories Flexfield, Item Catalog Group Flexfield, Stock Locators Flexfield, Account Aliases Flexfield, Sales Orders, setups for Inventory Module like. Locations, Organization Calendar, Organizations,setups for Inventory Module like Item Categories, Item Attribute Controls, Item Catalogs, Item Type, Item Cross Reference, Inventory, Parameters, Unit of Measure,Setups for Inventory Module like Transaction Source Types, Transaction Type, Item Templates, Subinventory, Stock Locators, Shipping Network, Shipping Methods, Interface Manager, ABC Compiles, e ABC Classes, ABC Assignment Groups, Cycle Counts, Physical Inventories.
• Work in Process (WIP): Setups for WIP Accounting Classes, WIP Parameters, Production Lines, Repetitive Line/Assembly Association, Schedule Groups, Employees, Employee Labor Rates, Shop Floor Statuses, Job/Schedule Documents, Operations Documents, Report Sets
• Bill of Material (BOM): Involved in defining Bill of Material and Routings for manufactured products and subassemblies for ordering configuration. Created test scripts related to Order Management and BOM.
• Advanced Supply Chain Planning (ASCP): Setups for Data Collection, Instances, Organizations, Profile Options, Item Categories, Item Attributes, Forecast, Intransit Lead Times, Assignment Sets, Sourcing Rules, Planning Parameters, Plan Options. Successfully Run Collections, Centralized Plan and generated Suggested Purchase Requisitions and Work Orders and Pushed Back to the Source.
• Order Management/Pricing, Shipping(OM): Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules and Successfully created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).

Environment: Oracle application 11i.5.9 and R12 (Inventory, WIP, BOM, ASCP, Order Management, Shipping, Purchase Order).

Confidential

Techno-Functional Consultant

Responsibilities;

• Inventory (INV): Setups for Inventory module like Items Flexfield, Item Categories Flexfield, Item Catalog Group Flexfield, Stock Locators Flexfield, Account Aliases Flexfield, Sales Orders, setups for Inventory Module like. Locations, Organization Calendar, Organizations,setups for Inventory Module like Item Categories, Item Attribute Controls, Item Catalogs, Item Type, Item Cross Reference, Inventory, Parameters, Unit of Measure,Setups for Inventory Module like Transaction Source Types, Transaction Type, Item Templates, Subinventory, Stock Locators, Shipping Network, Shipping Methods, Interface Manager.
• Worked on Oracle MES for Process Manufacturing.
• Setups of BOM- Bill of Materials Parameters, Department Classes, Resources, Locations, WIP Accounting Classes.
• Worked with full life cycle like creation of Items, creation of BOM structure, assembling in WIP, copying to Multi-Org.
• Involved in data mapping and data conversion for Items, Suppliers, Open Purchase Orders, Quotes
• Can Provide more on request