SUMMARY

• Around 9 years of experience in the field of Oracle Manufacturing, Advance Supply Chain Planning (ASCP) and Supply Chain Management (SCM) modules like Inventory, Bills of material (BOM), Work in Process (WIP), Order Management, Available to Promise(ATP), Shipping, Costing, Engineering(ECO), Purchasing and i - Procurement.
• Expert in phases of implementing the Oracle APS systems with EBS modules: Advanced Supply Chain Planning (ASCP), ATP, Min/Max Planning, Collaborative Planning (CP), Inventory (INV), Bills of Materials (BOM), Work in Process (WIP), Purchasing (PO), Costing (CST)and Order Management(OM).
• Experience in end-to-end full lifecycle implementations and handled projects involving Upgrade, Rollout and Support/ Maintenance of Oracle ASCP, Demantra, Manufacturing and Supply Chain Management Modules.
• Worked with Business super users to train them on ASCP and MFG / Distribution flow in Oracle Applications and creating the setup for the same based on the input from the business.
• Expertise in configuring and maintaining the latest modules vizASCP and Demand Planning/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 the Data from People Soft ERP to ASCP.
• Strong working knowledge 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 knowledge of the Oracle Multi-org Business Structure.
• Experienced in preparing documentation based on deliverables that are used to assess the level of fit between the detailed business requirements and standard application functionality using AIM.
• Strong knowledge of Application Object Library (AOL), Trading Community Architecture (TCA) and knowledge 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), ATP, Inventory (INV),Bills of Material (BOM), Work in Process (WIP), Purchasing (PO), Demantra, Collaborative Planning(CP), Order Management (OM), Engineering(ECO),i-Procurement, Costing, Order to cash (O2C) and Procure to Pay (P2P) Life Cycle, EDICOM, MSCA,Telnet and IHUB.

Business Intelligence Tools: Discoverer Report, Qlickview.

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

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Lead Oracle Application Manufacturing and ASCP Consultant

Responsibilities:

• Involved in Business requirements gathering for ASCP and Manufacturing Modules Inventory, BOM, WIP and Costing implementation, Configuration changes, Technical Specifications, and generating Test Scripts.
• Prepare Fit/Gap analysis document to analyze the level of fit between the business Requirement and Standard Oracle Application.
• Prepared Functional document (SRD), Setups (BR100) and Oracle Responsibilities (BR120). Create ASCP and Manufacturing User Manual for Users Training and end Users references
• Involved in Coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications i.e. Customized Make to Order Process (Daikin Customer Order Process).
• Involved in Conversion of Items, BOM’s and Routings, Analyzed and coordinated with business to correct the legacy Data before converting them in Oracle Base Tables.
• Involved in conducting CRP’s and UAT sessions with Business users to do testing for ASCP and Manufacturing Modules like Inventory, BOM, WIP, Engineering (ECO) and Costing.
• Involved in Conducting Systems Integration Testing with cross functional Teams i.e. O2C, Sourcing and Finance Team to test the complete End to End Process Flow.
• Work with cross functional team (Finance team) to test the complete end to Scrap Process cycle.
• Preformed All the ASCP and Manufacturing related setups in the oracle Application as per business Process.
• Worked on Identifying many Gaps, Oracle Bugs and Enhancements in Oracle Manufacturing and ASCP processes including Scheduling Demand/Supplies Pegging and Optimization engine.
• Setup Constraint EDD ASCP plans for Benshaw Organizations (USA and Canada).This functionality provide the demand/supply view for multiple inventory organizations in single ASCP plan.
• Prepared Functional Document for ATP and configured it the system ad tested end to end ATP flow.
• Involved in Creation of MD50 and coordination with Technical team to prepare customer specific Shop Traveler Report, Component Pick List report, Intranet Production Report etc.
• Worked with Oracle by creating Oracle SR’s to Fix standard Bug and provide resolution of Issues.
• Prepare Test cases for Manufacturing and ASCP Process to Test various business Scenarios like Forecast to Build, Customized Make to Order Process etc.
• Prepared Documents on how to Create Folders, User defined Queries on Planner Work Bench Search Exceptions and Supply demand for Items and Release Planned order from the Planners Work Bench.
• Involved in testing Mobile Application though TELNET to test Shop Floor Transaction like Move order, Scrap Process and Job Completion with serial and non-serial control assemblies.
• Involved in Post Go-Live production Support for ASCP and Manufacturing modules.
• Prepared SOP Document for the Manufacturing Process and end to end ASCP process Cycles for reference for Business Users.

Environment: Oracle ASCP 12.1.3.9Modules: Advanced Supply Chain Planning (ASCP), Inventory (INV), Available to Promise (ATP), Bills of Material (BOM), Work in Process (WIP), Engineering (ECO), Costing (CST), Mobile Supply Chain Application (MSCA), SQL and PL/SQL.

Confidential, Houston TX

Lead Oracle Apps Techno- Functional ASCP Consultant

Responsibilities:

• Involved in ASCP rollout of 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 the IHUB (Middleware Tool to Map Data between People Soft ERP and ASCP and pull the data from People Soft and send it to ASCP).
• Monitored ASCP plans on daily basis and did troubleshooting in case of Collections and Plan failure.
• Provided training to the Users and make them Understand ASCP functionality, Horizontal/Vertical Plan and ASCP Exceptions and created documents on the same for future reference.
• Prepared functional design documents to develop views in People Soft to pull the 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, PO 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 the current manufacturing and distribution process by resolving long pending issues and by creating the custom codes in People Soft ERP Manufacturing and Oracle ASCP Modules.
• Followed up with oracle to resolve the Standard bugs present in the Oracle ASCP.
• Stabilized ASCP and People Soft manufacturing modules by implementing process improvements and RCA (Root Cause Analysis)
• Prepared the AIM documentation for the respective operations.
• Prepared documentations to map INV, BOM, WIP and PO setups in People Soft and Standard Oracle ERP.
• Resolved Issues In PSFT Manufacturing Inventory, BOM and WIP Modules.

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 the ASCP Rollout for 2 regions South America and Europe.
• Involved in conducting UAT sessions with Business users for testing Business Flow in Oracle Inventory, Order Management, Oracle Purchasing and Advance Supply Chain planning modules.
• Was part of the normal production support for ASCP, Oracle Inventory (INV), Order Management (OM) and Oracle Purchasing (PO).
• Prepared documents such as BR100, MD050, TE40 and TE50 as per AIM methodologies.
• Conducted CRP execution and user training to make users understand the oracle process and Flow and prepare documents in the same for future reference.
• Involved in coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications (Logility-Forecasting Tool).
• Completed the Min/Max Setup as Part of the Europe and South America Region Rollout.
• Involved in the post rollout support.
• 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
• 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, exceptions 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.
• Involved in Data Clean up i.e. PR/PO, PO in receiving and In-transit shipments.
• 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), Order Management (OM), Min/Max Planning, Oracle Inventory (INV), Oracle Purchasing (PO), SQL, PL/SQL, SQL*Loader.

Confidential, San Jose, CA

Lead Oracle Applications Functional Consultant

Responsibilities:

• Point of contact for both onsite and offshore ASCP Manufacturing and SCM Support.
• Conducted team status meetings and issue tracking.
• Lead Oracle ASCP module with Demand, Supply, Warehouse & Distribution Managers, understand existing planning, scheduling, & fulfillment processes within & outside organizations.
• Supported issues related to P2P and O2C cycle and involved in the process improvement and smooth execution of both processes.
• Monitored and supported ASCP/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 the 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 (Rapid Planning Tool) and Demantra.
• Involved in development of Reports according to Business requirements and improve the existing Report by fine tuning the SQL/ PLSQL Queries to improve the Performance of the 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 conducting Training sessions with Business users to make them understand the ASCP/ATP Planning, P2P and O2C process flow.
• Prepare functional specifications for new enhancement and Fixed long pending ASCP custom report/process issues.
• Involved in Client Interaction and attending the project internal review meetings
• Production support for Oracle ASCP, ATP, Demantra, INV, OM and PO modules and did Route Cause Analysis (RCA) and prepare documents on the same for future references.
• Developed custom object to fix ASCP standard bug and Worked with Oracle support to get one-off patch for this 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 and Bugs.
• Involved in Developing and Testing of Scripts in test Environment and then 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), Available to Promise (ATP) Collaborative Planning (CP), Demantra, KINAXIS, Oracle Inventory (INV), Order Management (OM), Oracle Purchasing (PO), I-Procurement, 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 the level of fit between the detailed business requirements and standard application functionality.
• Involved in Business requirements gathering, design, configuration changes, technical specifications, documentation and training for Inventory, Purchasing, Order Management and Advance Supply Chain Planning (ASCP).
• Validation of ASCP plans and explaining output to users by quantifying lead times, order modifiers etc.
• Involved in the setups of ASCP /INV/OM/ PO, configuration, review and approval.
• Involved in Preparation of the Project plans, estimates and other technical documents required during the initial phase. Conducting the Fit- Gap analysis and studying the gaps for smooth integration of legacy systems to the Oracle Applications.
• Prepared the AIM documentation: RD50, BR-100, BR-120 MD-50 and TE40 for the 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 the inventory lead time from 25 days to 18 days with help of directed forecasting methods.
• Worked extensively on Procure to Pay (P2P) lifecycle from the initiating the RFQ(Request for quotation) and quotes to setting up of purchase order and Auto create the documents with troubleshooting of various issues and resolving the exceptions.
• Conducted extensive testing such as unit tests and integration tests for seamless integration of the Oracle system with the business environment.
• Instructed and trained the users & super users to create sales order and Blanket Sales Agreement (BSA) with credit checks and holds. Also trained methodologies to effectively apply discounts to the pricelists, setting profile rules & system parameters, defaulting rules, transaction types and resolving the day-to-day issues.
• Conducted change management initiatives, as a critical part of the process to ensure quick user acceptance. Also encouraged and started Brown Bag meetings for knowledge sharing and better communication to help resolve problems in future.
• Prepared training documentation for future users for reference and conducted training for the users and super users in company on Oracle concepts and carrying out sample transaction.

Environment: Oracle R12, Modules: Advanced Supply Chain Planning (ASCP), Oracle Inventory (INV), Oracle Order Management (OM), Oracle Purchasing (PO), Oracle Shipping and SQL/PLSQL

Confidential, MO

Oracle Applications Functional Consultant

Responsibilities:

• As a Functional Consultant implemented modules: Inventory, Order Management, Shipping and Purchasing of Release 12 of Oracle e-Business Suite.
• Created setup documentation for Inventory, Order Management and Oracle Purchasing.
• Extensively supported other Oracle modules such as Order Management, Oracle Sales, Oracle Purchasing, Procurement and Oracle Inventory.
• 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 the setups for OM, INV and PO including setting up of the expense-reporting template.
• Worked on the integration of WIP with OM and also worked on the functional specifications for customizations to OM module.
• Involved in creating and maintaining BR100 for Setup Updates and BR120 for responsibility updates.
• Defined the AS-IS and TO-BE processes.
• Implemented TCA for AR customer master conversions.
• Implemented the 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 Supply Chain Modules like: Inventory, Order Management, Purchasing and i-Procurement.
• Compared the future business requirement & current version to remap the business data and identify the issues. Also, explore workarounds to application gaps before considering custom modifications or new developments.
• Analyzed the user requirements and their problems to effectively plan strategies to solve the issues and chart out the possible methodologies that can be used for resolve the exceptions.
• Worked on most parts of the Order to Cash (O2C) and Procure to Pay (P2P) process.
• Charted out the steps for up-gradation and prepared the business documentation for up-gradation from 11i to R12 using the AIM Methodology.
• Carried out Unit testing (UT) for the checking the functionality of the implemented modules, Integration testing for the upgraded Oracle version for ensuring the communications between the database and new Oracle version
• Implemented the Receipt to Issue and Procure to pay cycle for the products and setting up workflows for automatic creation of purchase orders to the analysis of supplier performances which resulted in reducing lead time for the client.
• Involved in setting the Pricing strategy by defining pricing rules, deciding and laying out the qualifiers and modifiers since the client is also a wholesale distributor of clothing with a variety of products.
• Imparted training to end-users and the super users to perform the functions as per their responsibility and prepare the customized training documentation.
• Involved in post Implementation support for ironing out the functional issues and resolving the end user problems to ensure smooth working after going live on the Oracle applications.

Environment: Oracle Application Release R12

Confidential

SCM Functional Consultant

Responsibilities:

• 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.
• 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 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.
• Worked on Supply Chain and Manufacturing Modules INV, BOM, WIP, Oracle Purchasing.
• Gathered and analyzed current setups for I-Procurement and Purchasing.
• 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 (INV), Purchasing (PO), Bills of Material (BOM), Work in Process (WIP), Costing (CST) and MSCA.