SUMMARY

• Around 9 years of experience in teh field of Oracle Manufacturing, Supply Chain Management (SCM) and Advance Supply Chain Planning (ASCP) modules like Inventory, Bills of material (BOM), Work in Process (WIP), Order Management, Shipping, Costing, Purchasing and i - Procurement.
• Expert in phases of implementing teh Oracle APS systems with EBS modules: Advanced Supply Chain Planning (ASCP), Min/Max planning, Collaborative Planning (CP), Inventory (INV), Bills of Materials (BOM), Work in Process (WIP), Purchasing (PO) and Order Management(OM).
• Experience in end-to-end full lifecycle implementations and handled projects involving upgrade, support and maintenance.
• Worked with Business super users to train them on teh MFG / Distribution flow in Oracle Applications. Creating teh setup for teh same based on teh input from teh business.
• Expertise in configuring and maintaining teh latest modules vizASCP and DP/Demantraand maintaining a separate Advanced Planning and Scheduling (APS) instance and Oracle Express Server
• Review and enhance forecasting processes and tools for use with Oracle Global Advanced Supply Chain Planning (ASCP) module.
• Experience on working with Oracle SO, PL/SQL and Open Interfaces.
• Experience on Oracle ASCP Legacy collections using IHUB third party tool integrated teh Data from People Soft ERP to ASCP.
• Strong working noledge of Receipt to Issue cycle, Order to Cash (O2C) and Procure to pay (P2P) business cycles.
• Hands on experience in Business Intelligent tools like Discoverer reports.
• Knowledge in third party tools like KINAXIS, TRI-2(For migration of scripts in Production Environment) and EDICOM and their integration with Oracle.
• Strong noledge of teh Oracle Multi-org Business Structure.
• Experienced in preparing documentation based on deliverables that are used to assess teh level of fit between teh detailed business requirements and standard application functionality using AIM.
• Strong noledge of Application Object Library (AOL), Trading Community Architecture (TCA) and noledge of System Administrator activities.
• Highly capable in understanding business operations and translating them into functional requirements.

TECHNICAL SKILLS

ERP Software: Oracle R12, Oracle 11i, Advanced Supply Chain Planning (ASCP),Inventory (INV),Bills of Material (BOM), Work in Process (WIP), Purchasing (PO), Demantra, Order Management (OM),Costing, Order to cash (O2C) and Procure to Pay (P2P)Life Cycle,, EDICOM and IHUB.

Business Intelligence Tools: Discoverer Report, Qlickview.

Databases/Database tool: Oracle,MY SQL Server, Microsoft Access, Oracle, TOAD, SQL Developer.

Project Software: Microsoft Project,Microsoft Visio, TOAD, SQL Loader

Languages: C,C++,Visual Basic, VB.net,ASP.net, PL/SQL, SQL.

Operating Systems: Linux,Unix,Windows Server 2003/2008,Windows NT/2000/XP/7

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Lead Oracle Techno- Functional Consultant

Responsibilities:

• Involved in ASCP rollout new Business Units.
• Involved in integration of Oracle ASCP and People Soft PSFT using integration tool IHUB and prepared integration requirement documents.
• Stabilized customized Legacy Collections Process by improving teh IHUB (Middleware Tool to Map Data between People Soft ERP and ASCP and pull teh data from People Soft and send it to ASCP).
• Prepared functional design documents to develop views in People Soft to pull teh data from People Soft to IHUB
• Prepared functional design document to export released orders from ASCP to PSFT though middle-ware brokerage(integration tool)
• Involved in developing custom reports in ASCP and People Soft for ASCP, BOM and WIP.
• Involved in end to end rollout of new business units and add them to IHUB & ASCP including mandatory setups in People Soft
• Improved teh current manufacturing and distribution process by resolving long pending issues and by creating teh custom codes in People Soft ERP Manufacturing and Oracle ASCP Modules.
• Followed up with oracle to resolve teh Standard bugs present in teh Oracle ASCP.
• Stabilized ASCP and People Soft manufacturing modules by implementing process improvements and RCA (Root Cause Analysis)
• Prepared teh AIM documentation for teh respective operations
• Prepared documentations to map INV, BOM and WIP setups in People Soft and Standard Oracle ERP.
• Resolved Issues In PSFT Manufacturing Inventory, BOM and WIP Modules.

Environment: Oracle ASCP 12.1.3, People Soft (PSFT) 9.1, Modules: Advanced Supply Chain Planning (ASCP), People Soft Module: BOM, WIP and Inventory (INV), SQL and PL/SQL.

Confidential, Los Angeles, CA

Lead Oracle Applications Functional Analyst

Responsibilities:

• Involved in process of requirement gathering with business users, Documentation and Training for Process Rollout.
• Involved in teh ASCP Rollout for 2 regions South America and Europe.
• Involved in conducting UAT sessions with Business users for testing setups for Oracle Inventory, Order Management, Oracle Purchasing and Advance Supply Chain planning modules.
• Prepared BR30, BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Involved in creating and testing Order Management, Purchasing and Order to Cash Cycle Test Case Scenarios with business Users.
• Completed teh Min/Max Setup as Part of teh Europe and South America Region Rollout.
• Involved in teh post rollout support.
• Involved in teh preparation of MD050 MD070 Documents, including requirement gathering and coordination with teh technical team to develop Customized reports and perform enhancements.
• Involved in developing and testing of Customized Reports using Oracle SQL and PLSQL.
• Involved in Development and Testing of Customized Horizontal Plan/ Report Workbench. Which Shows Horizontal Plan Items Attributes, Items Demand/Supply, Exceptions and Graph of Demand/ Supply in a single Web Page.
• Supported issues related to P2P and O2C cycle and was involved in teh process improvement and smooth execution of both processes.
• Monitored and supported ASCP Plan run process from Saturday to Monday for smooth execution of Planning process.
• Validation of ASCP plans and explaining output to users by quantifying Demand and Supply, lead times, order modifiers etc.
• Experienced in creating and raising Oracle Service Request and work with Oracle to solve Critical issues related to Standard Oracle Bugs and Data Corruption.
• Efficient in Using Tools such as Service Now to create ticket.
• Used Data Loader for Creating New sourcing rules and Update existing Sourcing rules, Sourcing Assignments and Min-Max Setups.

Environment: Oracle 11.5.10, Modules: Advanced Supply Chain Planning (ASCP), Oracle Inventory (INV), Oracle Purchasing (PO), Order Management(OM), Order to Cash (O2C) Cycle, SQL, PL/SQL, SQL*Loader.

Confidential, San Jose, CA

Lead Oracle Applications Functional Consultant

Responsibilities:

• Point of contact for both onsite and offshore ASCP and SCM Support.
• Conducted team status meetings and issue tracking.
• Supported ASCP,ATP, PO, INV and OM functional issues
• Monitored and supported ASCP/GOP/ATP Plan run process from Monday to Friday and weekends for smooth execution of Planning process.
• Validation of ASCP plans and explaining output to users by quantifying lead times, order modifiers etc.
• Involved in resolving integration issues like EDICOM and Sales Force issues by coordinating all teh teams and contacting EDICOM Technician for Smooth Processing of sale Orders Stuck in interface of oracle and EDICOM and involved in registering new parties in e-commerce and EDICOM side.
• Prepared User training documents on Integration process among Oracle and other tools such as Kinaxis and Demantra.
• Involved in development Reports according to Business requirements and improve teh existing Report by fine tuning teh SQL/ PLSQL Queries to improve teh Performance of teh Reports.
• Involved in Integration Part of ASCP and Qlickview to show Plan Output like Supply, Demand and Exceptions in Business Intelligence Tool like Qlickview Dashboard.
• Involved in coordination with finance team to troubleshoot teh issues with (Account Receivables) AR Invoices
• Involved in conducting UAT sessions with Business users to do testing of items setups for ASCP planning.
• Prepare functional specifications for new enhancement and Fixed long pending ASCP custom report/process issues.
• Involved in Client Interaction and attending teh project internal review meetings
• Production support for Oracle ASCP, INV, OM and PO modules and Prepare Route Cause Analysis (RCA) documents for support issues
• Developed custom object to fix ASCP standard bug. Working with Oracle support to get one-off patch for dis bug fix
• Involved in IT/ User testing of custom objects and co-ordinate code migration team to move changes to production.
• Worked with Oracle Support for smooth execution of business process and fix Oracle Standard functional issues (Involved in forecasting logic correction).
• Involved in Developing and Testing of Scripts in test Environment and tan Migration of (SQL)Script in Production Environment using TRI-2 Tool for Data/(SQL)Script Migration.
• Fixed issues in customized Forecast Consumption process to get accurate Forecast after consumption process.
• Involved in setting up of one custom logic according to which any item which is not enable for planning or are with missing setups will get error out during MDS/MPS upload.

Environment: Oracle R12, Modules: Advanced Supply Chain Planning (ASCP), Collaborative Planning (CP), Demantra, Oracle Inventory (INV), Order Management (OM), Oracle Purchasing (PO), Oracle SQL, PL/SQL, SQL*Loader, Discoverer Report and Qlickview.

Confidential, Phoenix, AZ

Oracle Applications Functional Consultant.

Responsibilities:

• Conducted meetings from executive management to end users to assess teh level of fit between teh detailed business requirements and standard application functionality.
• Involved in Business requirements gathering, design, configuration changes, technical specifications, generating test scripts, documentation, training, etc.for Ordrer management (OM), Oracle Purchasing (PO) and Oracle Inventory.
• Involved in teh setups of INV / OM/ PO Setups.
• Involved in End-to-End implementation and support of Order to Cash business Cycles.
• Prepared teh AIM documentation: RD50, BR-100, BR-120 MD-50 and TE10 for teh respective operations.
• Implemented Item Relationships and Customer Item Cross References to enable substitution and cross-reference during Order entry.
• Implemented Min/Max planning, Reorder point planning and Kanban type Inventory planning efficiently for procurement of material and managed to bring teh inventory lead time from 25 days to 18 days with help of directed forecasting methods.
• Worked on Identifying many Gaps, Oracle Bugs and Enhancements in Invenotry, Order Management and Oracle Purchasing modules.
• Worked extensively on Procure to pay lifecycle from teh initiating teh RFQ(Request for quotation) and quotes to setting up of purchase order and Auto create teh documents with troubleshooting of various issues and resolving teh exceptions.
• Conducted extensive testing such as unit tests and integration tests for seamless integration of teh Oracle system with teh business environment.
• Instructed and trained teh users & super users to create sales order and BSA with credit checks and holds. Also trained methodologies to TEMPeffectively apply discounts to teh pricelists, setting profile rules & system parameters, defaulting rules, transaction types and resolving teh day-to-day issues.
• Conducted change management initiatives, as a critical part of teh process to ensure quick user acceptance. Also encouraged and started Brown Bag meetings for noledge sharing and better communication to help resolve problems in future.
• Prepared training documentation for future users for reference and conducted training for teh users and super users in company on Oracle concepts and carrying out sample transaction.

Environment: Oracle R12, Order to Cash (O2C)Cycle, Modules: Oracle Inventory (INV), Oracle Order Management (OM), Oracle Purchasing (PO), I-Procurement, Oracle Shipping.

Confidential, MO

Oracle Applications Functional Consultant.

Responsibilities:

• As a Functional Consultant implemented modules: Inventory, Order Management, Shipping, Pricing and Purchasing of Release 12 of Oracle e-Business Suite.
• Created setup documentation for Inventory, Order Management, Oracle Purchasing.
• Extensively supported other Oracle modules such as Inventory, Order Management, Oracle Sales, Oracle Purchasing, Oracle Advance Pricing and i-Procurement.
• Worked on variousReports,Interfaces and Conversions as part of Implementation.
• Implemented 2 SOBs (2 Operating Units) using multi org structure, multi-currency along with 1 Consolidation SOB.
• Performed all teh setups for OM, INV and PO including setting up of teh expense-reporting template.
• Worked on teh integration of WIP with OM and also worked on teh functional specifications for customizations to OM module.
• Involved in creating and maintaining BR100 for Setup Updates and BR120 for responsibility updates.
• Defined teh AS-IS and TO-BE processes.
• Implemented TCA for AR customer master conversions.
• Implemented teh Data Quality Management (DQM) in TCA.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & RBC.

Environment: Oracle Applications R12, Modules: Inventory, Order Management, Shipping, Pricing, Purchasing, ADI, Workflow Builder, Oracle SQL, PL/SQL, SQL*Loader, UNIX Shell Scripting and UNIX

Confidential, Los Angeles, CA.

Oracle Applications Functional Consultant

Responsibilities:

• Upgraded ERP system from Oracle E Business suite 11.5.10i version to R12.
• Involved in teh Implementation of Oracle Inventory in teh Procure to Pay and Order to Cash business flows.
• Involved in Supply Chain Modules like: INV, OM, Purchasing, i-Procurement, Costing.
• Compared teh future business requirement & current version to remap teh business data and identify teh issues. Also, explore workarounds to application gaps before considering custom modifications or new developments.
• Analyzed teh user requirements and their problems to TEMPeffectively plan strategies to solve teh issues and chart out teh possible methodologies that can be used for resolve teh exceptions.
• Worked on most parts of teh Order to Cash (O2C) process.
• Charted out teh steps for up-gradation and prepared teh business documentation for up-gradation from 11i to R12 using teh AIM Methodology.
• Carried out Unit testing (UT) for teh checking teh functionality of teh implemented modules, Integration testing for teh upgraded Oracle version for ensuring teh communications between teh database and new Oracle version
• Implemented teh Receipt to Issue and Procure to pay cycle for teh products and setting up workflows for automatic creation of purchase orders to teh analysis of supplier performances which resulted in reducing lead time for teh client.
• Involved in setting teh Pricing strategy by defining pricing rules, deciding and laying out teh qualifiers and modifiers since teh client is also a wholesale distributor of clothing with a variety of products.
• Imparted training to end-users and teh super users to perform teh functions as per their responsibility and prepare teh customized training documentation.
• Involved in post Implementation support for ironing out teh functional issues and resolving teh end user problems to ensure smooth working after going live on teh Oracle applications.

Environment: Oracle Application Release R12 Modules: Inventory, Quoting, Order Management, Purchasing i-Procurement and Costing .

Confidential

SCM Functional Consultant

Responsibilities:

• Performed AS IS Analysis for teh 11.5.8/11.5.9 setup and Identified GAPs with 11.5.10.
• Provided detailed understanding to teh 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.
• Implemented FIFO/Standard Costing for teh 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 teh 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 teh 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.
• Worked on all Supply Chain and Manufacturing Modules INV, BOM, WIP, Oracle Purchasing, i-Procurement, Order Management.
• Gatheird and analyzed current setups for I-Procurement and Purchasing.
• Responsible for setting up Oracle Purchasing and i-Procurement 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.

Environment: Oracle 11i Inventory, Order Management, PO, BOM, WIP, Purchasing, i-Procurement, MSCA, CST

Confidential

Oracle Applications Functional Consultant

Responsibilities:

• Provided Production Support to teh End-Users on Oracle Supply Chain Application modules, Oracle Order Management (OM) and Oracle Financials.
• Major activities included supporting teh clients various franchise offices for teh functional or technical issues arising in teh installed Oracle modules and finding solutions with teh help of technical team.
• Involved in Setting teh profile options, system parameters, transaction types and defaulting rules for Purchasing to facilitate teh ordering process and setting teh pricing rules.
• Worked on Install Base (IB) and linking it with teh Service Contracts (OKS/OKC) for TEMPeffective noledge sharing. Set up service agreements with teh long term clients for maximum profitability contract
• Trained teh end users for teh SCM modules, troubleshooting teh daily issues and fixing teh operational problems with teh Oracle technical support team to resolve teh issues.

Environment: Oracle 11.5.10i Modules: Oracle Order Management (OM, Oracle Service Contracts (OKS/OKC), Oracle Install Base (IB)

Confidential

Oracle Applications Functional Consultant

Responsibilities:

• Involved in Set up Purchase Orders, created Blanket PO, set up sourcing rules in Oracle Purchasing (PO) for teh department.
• Created forecasts in Oracle Inventory (INV) with teh historical data in co-ordination with teh sales and marketing team.
• Set up inventory planning for teh items at teh organization and sub-inventory level with planning methods such as
• Reorder Point planning, Min/Max Planning for economic order quantity, calculation of levels of safety stocks and reorders levels.
• Involved in Set up defaulting rules, deciding on Pricing options and Shipping rules in Order Management (OM).
• Conducted training for 40 end users to TEMPeffectively use Oracle Applications according to their responsibilities and prepare teh training material for future use.

Environment: Oracle 11.5.9i Modules: Oracle Inventory (INV), Oracle Order Management (OM), Oracle Purchasing (PO), Oracle Pricing (QP).