SUMMARY:

• Overall,19 years of professional experience, which includes around 15 years of Oracle EBS Functional Consulting experience in providing solutions for Implementation, Support, Enhancements, Upgrade, Rollouts of Oracle SCM Applications Releases 11i, Release 12 and Oracle Fusion SCM.
• Well versed with all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Implementation Cut - Over and Project Coordination activities.
• Functional work experience onOracle SCM Modules (INV, PIM, OM, WMS, Shipping, Advance Pricing, Purchasing, BOM, WIP, MRP, Quality, Engineering, Configurator, AME), Oracle Fusion SCM applications (Distribution Order Orchestration (DOO)).
• Extensive implementation experience with Order to Cash and Procure to Pay Business flows.
• Good functional work experience on Oracle Discrete and Oracle Process Manufacturing modules.
• Good functional knowledge in Oracle Finance Modules (GL, AP, AR) and Oracle CRM Modules (CRM Foundation, Installed Base, Field Service, Depot Repair, Service Contracts, CHRM).
• Good document experience with AIM Standards (BP80, BR100, MD50 and TE50).
• Excellent leadership, communication, client facing and presentation skills and understanding business applications.
• 4 years domain experience in IT Business Development, Customer Relationship, Sales and Services.

TECHNICAL SKILLS:

Technologies: Oracle EBS Release 11i & Release 12, Oracle 9i, PL/SQL, Toad, Data loader, Web ADI.

Functional Expertise: Oracle EBS: INV, OM, WMS, Purchasing, Advance Pricing, BOM, WIP, MRP, Quality, Engineering, Configurator, AME, Oracle Fusion SCM modules: DOO.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS SCM Functional SME

Responsibilities:

• Gather the Requirements for new enhancements and projects and document the As-Is and To-Be process flows.
• Enhanced the PO Inbound and outbound EDI changes for new suppliers.
• Designed the new alert notifications for AM and Quality approvals in Oracle OPM
• Customized the inbound and Outbound interfaces for return order (RMA) process with 3PL system (DHL)
• Designed interfaces for Order Shipment, Goods Receipts and lot status updates as part of DHL integration.
• Implemented EDI order process for US customers with custom rules for reservation and booking the orders.
• Defined WMS Put Away Rules to meet the Swiss HQ warehouse requirements.
• Defined required setups in INV, PIM, Manufacturing, OM, Pricing, Shipping, WMS, Purchasing as part of the enhancements and projects.
• Configured new organizations in Oracle EBS as part of acquisitions and rollouts.
• Created new OM order types, OM defaulting rules, GRC rules and Picking rules.
• Enhanced the existing reports and custom forms to meet the business requirements.
• Create test cases, execute and document the results within HP ALM tool.
• Create and update the design documents (URS, FS, DS, RTM, RA) with version controls and upload to internal document repository site with approvals.
• Work with Developers, Admin, DBA, Support, ITQ teams to complete the design, testing and migration activities.
• Create functional documents BR100, MD 50, Process flows, test cases and get it approved with business, IT, Quality teams.
• Log the Change Requests in Service Now and track, execute and implement them with all the documentation, testing approvals.

Confidential

Oracle EBS SCM Functional lead.

Responsibilities:

• Conduct Requirements gathering workshops and document the As-Is and To-Be process flows with solution design for new enhancements.
• Monitoring and working with Business for the day to day Oracle Production issues faced and resolving them as Per SLA.
• Enhanced the Order Import process for EDI and E-commerce customers.
• Resolved the issues with Order Scheduling, Reservation process and workflows.
• Designed integration with 3 PL Warehouse (PKMS) with inbound and outbound interfaces for automation of picking, shipping and Invoicing process.
• Designed Custom process to cancel and backorder lines based on business rules.
• Defined Custom process to apply and release holds on sales order lines.
• Designed new alerts to users on customer order price variance
• Resolved issues on Pricing and modifiers.
• Co-ordinate with onsite/offshore team members for all development activities based on MD50 and MD70.
• Weekly reporting of project activity and issue tracker to FOTL Leadership demonstrating overall project health report and highlight risks and mitigation plan to customer.
• Provide post Go Live support, analyze the repetitive issues with root cause for permanent fix.
• Work with Oracle Corp on SRs and Patches to resolve the production issues.

Confidential

Oracle EBS Functional Consultant lead.

Responsibilities:

• Initiated business meetings for requirements gathering and business issues then identify the gaps.
• Prepared functional specification documents (MD50) and other documents like BR100, BR3080, TE 40, CM10, MD120 for the desiredcustomizations and gaps.
• Involved in designing of custom solution for order import process to EBS from legacy systems.
• Implemented various sales order cycles like Standard Orders, Internal Orders, RMA Orders, Bill Only Orders, Quote Orders, EDI Orders and Drop Shipment Orders with custom workflows.
• Defined OM defaulting rules and Process Constraints to meet the business rules.
• Designed custom pricing and qualifier attributes to support Modifiers for discounts and promotions.
• Defined Promotions with custom Pricing attributes and subscription items as a promotional Get Items.
• Designed custom pricing process to default the Order line level Payment terms from price List and Modifiers.
• Designed custom pricing attributes for Delivery, Service, Restocking and Refusal charges.
• Designed custom pricing process to track the Order and Pricing changes and data quality reports.
• Developed Custom process to generate the daily pricing extract with list prices for all models and customers and integrate with legacy pricing systems (MML, DDT, Web Commerce, Sales Force).
• Involved in Pricing integration with legacy Purchasing systems for Home delivery models.
• Configured custom pricing attributes used in formulas to support TCA, Retailer, Distributor Pricing.
• Designed Custom Web ADI integrator to maintain Price lists and modifiers.
• Enabled Pricing Security for specific price lists, modifiers and responsibilities.
• Created item relationships, Custom attributes, Item Categories in Oracle Inventory/PIM and maintained using WebADI process.
• Worked on CHAIN SYS Apploader for data load, migration activities with Inventory/PIM, Sales Agreements and Advanced Pricing data.
• Integrated Oracle WebCenter with Oracle Advanced Pricing for uploading and publishing the Pricing documents to communicate with Customers and vendors.
• Designed Custom Attribute Mapping, Pricing APIs, Price Books, and other Advanced Pricing Setups and Configurations like Price Lists, Modifiers and Qualifiers, Custom Pricing Attributes.
• Prepared Functional specifications for custom reporting objects for XML and OBIEE (Adhoc, Dash boards and Analysis) reports in OM, INV/PIM and Pricing modules.
• Working effectively with business, vendor/partner resources and various IT teams such as Infrastructure, Sysadmin, SOA, Support and DBAs.

Confidential

Oracle EBS Functional Consultant lead.

Responsibilities:

• Implemented the Oracle Quality module for Receiving (POs: Receiving Transactions and Receiving Inspection), Returns (RMAs: Field returns and Customer Returns) and Floor rejections (WIP Jobs: Move Transactions and Job Completions).
• Automated the Quality Nonconformance, Disposition actions, updates, notification alerts with customizations.
• Designed Quality custom reports (MRR and Dispositions) to print automatically based on transactions.
• Defined Quality plans and elements with Specifications, conditions, rules and actions to meet the business requirement.
• Designed Quality automation process based on Disposition actions to create POs, WIP jobs, Shipments, Sub inventory Transfer, Repair Orders, RMA lines.
• Implemented Quality Auditing functionality for Inter and External audit processes.
• Enabled DFFs at Purchasing, Depot Repair and WIP module to capture Nonconformance and Disposition details.
• Implemented Engineering module for different Engineering Change Orders (ECO).
• Customized the workflow approval process for each change types: SCR, ECO, ECN and DCN.
• Provided business process solution for mass Bill changes with ECO approval notifications using client approval matrix for multiple departments.
• Customized the ECO approval hierarchy with organization hierarchy propagation.
• Provided the best solution to derive Use-Up dates from ASCP for ECO revised items with customization based on business requirements.
• Analyze the users’ requirements & making the documents for mapping the AS-IS & to TO-BE scenarios with process flow diagrams (Visio’s).
• Setup Configuration - BR100 Preparation & Mapping of Business Process.
• Solution Design to map existing business process with Oracle and identify the gaps that need work around and customization for implementation.
• Functional Design Documentation (MD.50) for custom reports, forms, personalization, alerts and interfaces.
• Co-ordination with offshore technical team for custom objects development.
• Preparation of unit & integrated test cases (TE.40) for CRP & UAT.
• Configure the CRP, UAT, Production systems with cutover implementation tasks.
• Delivering the of the key users and the end users.
• Provide Post production and enhancements support and resolved production issues.

Confidential

Oracle EBS Functional Lead.

Responsibilities:

• Key team member of Oracle EBS 11i to R12.2.4 upgrade project.
• Participate in client workshops and meetings to understand the current business processes.
• Performed Requirement analysis, fitment, gap analysis, POC and solution design.
• Present the Proof of Concepts (POCs) with R12 solutions on OM, iStore, Shipping, Advanced Pricing, Inventory, Purchasing, Demand Class ATP, GOP.
• Responsible for publishing content, new minisites and new catalogs for iStore in R12.
• Presented and trained the users on key process changes and new features of Oracle EBS Release 12 with documentation.
• Help business users to complete the high-level business process testing with R12.
• Work with key business users to identify the process gaps and recommend the alternative solutions.
• Provide out-of-box solutions to eliminate customizations using new R12 features.
• Prepare Upgrade Assessment and Impact analysis of current business process due to upgrade changes/enhancements.
• Preparation of the environment for Conference Room pilot (CRPs).
• Resolve all functional issues during testing with R12 instance.
• Worked on Oracle Service Requests (SRs) with Oracle to resolve the issues encountered in Production Environment.
• Act as a single point of contact for all production issues for Rochester, NY manufacturing site·
• Resolve hanging Oracle Production issues at the shop floor with Oracle Distribution (Inventory, PLM/PIM, Purchasing, Order Management, Advance Pricing, Shipping, MSCA, Configurator), Manufacturing (WIP, BOM, Engineering, Quality), Service (IB, Depot Repair, Service Contracts) modules·
• Liaison between Business and IT to identify process gaps, setup, Testing, design issues·
• Involved in custom interface design between Oracle EBS and external WMS (Kewill).
• Configured new Sourcing Rules, Assignments, Approved Supplier Lists (ASLs) in Purchasing.
• Configured Purchasing with ASCP module for automatic Blanket Releases and Forecast data.
• Resolved production issues on ASN shipments, Supplier returns, Supplier item configurations.
• Modified OM Order Types (Workflow) for return orders (Depot Repair) and Service Contracts.
• Defined custom Subscription Templates for Subscriptions items.
• Configured the Bills (BOM) to support Service items to default in Order Entry Process.
• Functional design of alerts to notify customers and users uponcertain events like Return Material Receipt, Warranty, Subscriptions expiries and renewals.
• Implemented Inbound and Outbound EDI automation process for Suppliers and Customers (EDI 850, EDI 855, EDI 856, EDI 830, EDI 810).
• Implemented Supplier Scheduling process to meet customer/suppliers forecast demands and configured with EDI 830.
• Fixed the integration issues with Enovia PLM/PIM while update the model status, NPI introductions.
• Resolved Item Costing related issues during the WIP work order process.
• Resolved the error transactions in Installed Base interface with Depot repair orders.
• Provided solutions on parts Ownership, RMA line status, RMA line price issues.
• Defined manual modifiers and updated the qualifiers with bulk data using Data Loader.
• Designed a new pricing context attributes for ATO item price calculation.
• Successfully completed the first Oracle Physical Inventory Counting process as per schedule using Data Loader and external tools.
• Resolved the pending/stuck transactions to enable smooth Month/Quarter/Year closing.

Confidential

Oracle Order to Cash Functional Consultant

Responsibilities:

• Responsible for evaluating existing business processes, gather and understand new requirements, resolving existing business issues, and deliver a comprehensive solution within the Oracle Applications 12i framework.
• Responsible for Order to Cash flow production issues in Oracle OM, Advance Pricing and AR modules for Expedia Hotel Collect business.
• Worked on the scheduled job/process production issues in Control-M tool and Config Snapshot tool for the customization impact analysis.
• Defined new pricing formulas and modifiers with promotional goods.
• Streamlined the process of Order Management by customizing the workflow for smooth closure and invoicing for Hotel Collect business.
• Worked on Conversions to import orders and invoices from legacy system.
• Resolved production issues on bulk orders data import custom process.
• Designed a custom process to automate Expedia Group Hotel invoice creation and sales order closure.
• Created and updated MD050s to provide functional design of the outstanding issues and new enhancements related to Order Management and Receivables modules.
• Involved in month-end and quarter-end activities: Processing all closed Sales Orders, Accounts Receivable Closing and posting transactions to General Ledgers.
• Coordinated and worked with Technical, DBA and Offshore teams to resolve the production issues and to complete the new enhancements.
• Worked on Oracle Service Requests (SRs) with Oracle to resolve the issues encountered in Production Environment.

Confidential

Oracle OM and Purchasing Functional Consultant

Responsibilities:

• Participated in Oracle boot camp meetings and demonstrated the oracle OM and purchasing functionalities at high level.
• Gathered information through interview sessions with key users in order to understand the existing business processes, current issues and challenges of the business with Quote to Cash business process and purchasing divisions.
• Visited Client sites to understand the client business flow and systems process.
• Participated in Workshops with client business and IT leads to gather the initial requirements for Oracle R12 implementation project.
• Involved in meetings with other Oracle teams and client business and IT teams to study and understand the client legacy systems.
• Prepared the requirements for Oracle OM module implementation.
• Identified the process gaps between business and Oracle Application.
• Prepared AS - IS and TO-BE documents with the solutions
• Conducted CRPs with client IT and business leads for Procure to Pay and Quote to Cash custom flows.
• Functional design for EDI order validation and interfacing the same to order import interface.

Confidential

Oracle EBS SCM Functional Lead

Responsibilities:

• Responsible for all SCM (INV, Purchasing, OM, Pricing, WMS), Manufacturing (BOM, MRP) modules and Oracle AME for AP module upgrade activities of the project from R11 to R12, planning the pre-upgrade tasks, inline and post upgrade tasks with documentations.
• Implemented Oracle AME for Purchasing documents and AP invoice approvals.
• Upgrade Assessment and Impact analysis of current business process due to upgrade changes/enhancements.
• Worked closely with business key users to gather the functional inputs and requirements for Oracle AME implementation.
• Defined new AME rules with conditions and attributes for invoice matching, validation, holds, messages, escalations and approvals.
• Designed the complete custom Oracle AME Business Rules, Attributes, Conditions to simplify the Purchasing, AP invoice workflow approval process with.
• Resolved WMS issues on picking, label printing and move order allocations.
• Defined new WMS rules for US orders.
• Unit and Integration testing execution for each business process of SCM, Manufacturing modules and Oracle AME Business Rules.
• Effective to the client end users on R12 SCM modules (Oracle INV, Purchasing, OM, WMS, MRP, Pricing), AME giving special emphasis on changed features.
• Resolved
• Effective interaction with offshore technical team to developing, testing and migration of custom components (Forms, Reports and Workflows).
• Execute processes to validate data before and after Migration, creating comparison sheets (XLS).
• Defined new Approval Groups and Hierarchies for Purchasing and Payables departments.
• Logged Service Requests (SR) and worked with Oracle Corporation to get the fix on the Upgrade issues.

Confidential

Oracle SCM Functional Consultant

Responsibilities:

• Worked on Oracle Application SCM (INV, OM, Shipping, Advance Pricing, WIP) modules of Release 12.1.3 and Oracle Fusion SCM (DOO) as a functional consultant.
• Extensively involved in Client Requirement Gathering, Identifying the business processes, Discussions on future enhancements by various interactions with key business users and business communities.
• Participated in all CRP meetings at client facility (TN, USA) with demonstrations.
• Defined new price lists, modifiers and qualifiers for items.
• Defined Orchestration Processes with steps and tasks.
• Defined Jeopardy priorities, constraints for user actions.
• Implemented order flows like Standard, Internal for Standard, ATO items and customized the workflows accordingly.
• Implemented the Batching logic to group the sales order lines as a batch for streamline the Production Process (WIP).
• Customized the Order Sourcing as per the Sourcing logic based on the order quantity of order type.
• Implemented the customizations on Inventory locators to enable the availability of the locator with quantity for sales order demand.
• Customized Advance Shipment Notifications (ASN) with tracking numbers to customers.
• Implemented Inbound and Outbound EDI automation process for Suppliers and Customers (EDI 850, EDI 855, EDI 856, EDI 830, EDI 810).
• Customized the Customer creation and update process along with Order Import Process.
• Done the Data Mapping between the current and future systems and identified the gaps.
• Developed functional design documents (MD.050), System setup configuration documents (BR 100) and Test Case documents (TE.040) with business process scenarios for Oracle INV, OM, WIP, Pricing, DOO modules.
• Worked with offshore technical team on technical components and customizations to provide the functional inputs and test results.
• Worked on the R12 production issues and resolved them with priority by providing solutions.Worked as Onsite functional lead and took the complete responsibility of Symmetricom Production issues.
• Co-ordinated and guided the offshore team to get the quick resolutions on Oracle production issues.
• Closely worked with business users and client manager and reduced the escalations from client business.
• Prepared BR100 (Setup) and MD.50 documents on distribution modules (INV, OM, Pricing, WSH, Purchasing, WIP, BOM) as per the changes suggested by Client.
• Provided effective to the client end users with documents on distribution modules.
• Implemented the alerts for sending acknowledgements to customers upon Order booking and updates.
• Resolved production issues on Inventory Cycle Count and Physical Count process transactions.
• Implemented approval processes to view and approve the PO documents.
• Customized the Pick Slip, Packing Slip Reports as per business requirements.
• Implemented the new picking rules and defaulting rules to meet the requirement.
• Initiated weekly and Bi-weekly conference meetings with client BSAs to understand the priority of the issues and assign the tickets to offshore team as required.
• Worked on Oracle Service Requests (SRs) with Oracle to resolve the issues encountered in Production Environment.

Confidential

Oracle SCM Functional Lead Consultant

Responsibilities:

• Responsible for upgrade activities of the project from R11 to R12, planning the pre-upgrade tasks, inline and post upgrade tasks with documentations
• Preparation of the environment for Conference Room pilot (CRP) sessions and demonstrating the R12 product overview sessions to users at different geographies (USA, Singapore, Taiwan, Japan)
• Effective to the client end users across geographies on R12 distribution modules (Oracle INV, PO, iproc, OM, Advance Pricing) giving special emphasis on changed features.
• Customized the form to capture the allocation changes in Transact move order form.
• Defined new Sourcing Rules for new suppliers/items.
• Designed custom process to import quotes from external systems.
• Resolved Inbound and Outbound EDI transaction issues (EDI 850, EDI 855, EDI 856, EDI 860, EDI 830).
• Effective interaction with off shore technical team members to deliver the migration of custom components.
• Prepared BR100 (Setup) and MD.50 and user documents on distribution modules (Oracle INV, PO, OM, Advance Pricing) and Services (IB and Depot repair) of R12 release.
• Implemented business flows for item types like ATO Model and Standard items.
• Implemented new custom workflow for Quote to Cash order and Depot repair orders.
• Implemented new Price lists with modifiers and formulas.
• Customized the inventory allocation process for Lot controlled items in Transact Move Orders Form.
• Implemented form personalizations for Purchasing Buyers and Inventory Transact Mover Orders forms
• Closely worked with technical team to fix the reports, upgrade, and customization issues.
• Defined custom process for closing return orders in Depot Repair.

Confidential

Oracle SCM Functional Lead Consultant

Responsibilities:

• Worked as a functional team lead for Enhancements, Supporting of Oracle OM, Advance Pricing, PO, INV, BOM, WIP, ASCP modules on Oracle EBS R12 environment.
• Implemented business flows like Intercompany, Drop Shipment, RMA and ISO with different order types.
• Resolved production issues on Oracle Installed Base, Field Service and Service Contracts.
• Worked on Oracle iStore Admin activities like: Catalog Management, Content Management, Item Maintenance, Pricing Maintenance, Store Maintenance, Customer Inquiry, Order Inquiry, User Maintenance
• Worked on new UI design and publication in iStore module.
• Customized the forms to meet Intercompany and ISO process requirements.
• Designed new workflows for Quotes with new order types.
• Defined custom process for Quote to Cash business flow with alerts.
• Resolved production and design issues on Pricing (Price list, Formulas and pricing attributes).
• Customized the inventory receipt form to meet the client requirement.
• Resolved production issues on Inventory Costing, Cycle Count and Physical Count process transactions.
• Resolved Inbound and Outbound EDI transaction issues (EDI 850, EDI 855, EDI 856, EDI 860 and EDI 830) and ASN shipment issues.
• Customized the OM reports like SOA, Pick Slip and Packing Slip reports.
• Implemented new procedure for Clopay Testing process with new templates and approvals.
• Successfully completed the Clopay Archiving Project for the data till 2008.
• Initiated and Involved in daily Client meetings/calls with Client Manager and onsite team to update the progress of the testing activities and status of the issues.
• Developed new functional documents (MD.050) and test case scenarios (TE.040) as per the client business requirements and prepared issue-based test scripts.
• Logged Service Requests (SR) and worked with Oracle Corporation to get the fix on the Production issues.
• Provided the effective support for Inventory month end close process by clearing all pending transactions.

Confidential

Oracle SCM Functional Consultant

Responsibilities:

• Worked as a functional consultant at client place (onsite) in Malaysia to study the business processes/Systems and gather the business requirements of Asia Pacific region to implement Oracle Application.
• Implemented the business process flows with customizations to meet the requirements.
• Prepared AS-IS and TO-BE documents for INV, Purchasing, OM and custom modules (DCSS, SDS, SMART, and DEPTs).
• Interacted with key users and technical teams to understand the integration and dataflow of the legacy systems.
• Implemented the new business flows for shippable and non-shippable items.
• Done the Data Mapping between the current and future systems and identified the gaps.
• Prepared the Functional Design (MD.050), Setup (BR 100), Test Script (TE 040) documents.
• Customized the INV and OM Reports like SOA, Item Status, Pick Slip and Bill of lading.
• Implemented a new business flow to meet the ISO requirement.
• Configured the system for Oracle Inventory, Purchasing and Order Management modules.
• Implemented the new sourcing rules and approval groups in Purchasing.
• Customized the forms in Inventory to capture the availability of quantity, status.
• Implemented the form personalization to capture the changes in sales order lines.
• Logged Service Requests (SR) and worked with Oracle to get the fix on the Production issues.
• Was involved in the implementation project as Functional Consultant.
• Done the Configuration Setups related to Distribution Modules (INV, OM, Pricing, Purchasing).
• Implemented the business flows for Intercompany and RMA processes.
• Defined sourcing rules to create Configuration BOM in desired manufacturing organization.
• Customized the reports in OM like Pick Slip, SOA.
• Implemented new price lists, modifiers and formulas.
• Implemented the alerts to send the notifications to user community.
• Prepared all functional documents like BR 100, MD.50 TE.40 for Distribution Modules.
• Configured dev and test instances for user testing and participated in CRPs, UATs with the key users.
• Logged Service Requests (SR) and worked with Oracle to get the fix on the Production issues.

Confidential

Oracle Business Analyst

Responsibilities:

• Worked on all Distribution related issues as a PST (Production Support Team) Member.
• Closely worked and resolved the Order Process web tool (EOM) Functional issues.
• Helped the users by providing User on INV, OM, Shipping, Pricing, PO, WIP, BOM, MRP modules thus reduced the number of issue escalations during the Quarter close by proper interaction and guidance.
• Implemented new process for production migration with proper approvals.
• Implemented INV, OM, Pricing and PO related Solutions into Clarify Solution Database and incorporated all the solutions in solution database.
• Developed functional design documents (CF.250 and MD200), System configuration (BR 100) and Test Case (TE.040) with business process scenarios for Oracle INV, OM, WIP, Pricing.
• Through Continuous monitoring of repeated /new functional issues (Eg. Sales order line status, PBRR, IIP and workflow) on OM, INV Modules and worked with Consultants (TCS) to find out the Root Causes, which resulted in significant case inflow reduction.
• Involved in Inventory Cycle Count and Physical Count Processes.
• Coordinated with Oracle to get solution by logging TARs for SCM and manufacturing issues.
• Coordinated with key users and CSMs (Client Service Manager) for quick resolution of the issues.
• Prepared SOPs and coordinated with users to fix regular issues by themselves.
• Done the incremental setups as per business requirement by getting the approvals from Module Experts (ME) and CSMs.
• Resolved pending transactions to enable smooth Month/Quarter/Year closing.