SUMMARY:

• Accomplished Consulting professional with 18 years of distinguished performance and performed role of Lead Consultant and Project Manager for Oracle EBS Implementation, Application Maintenance & Support projects.
• Hands on experience with Oracle Cloud Service, R12 and R11i Implementation, Upgrade and Support ofOracle Applications supply chain, Manufacturing.
• Oracle Supply Chain Management, Manufacturing, planning consultant with Strong Techno - Functional knowledge on Oracle OM, PO, Inv, BOM, WIP, iSupplier, Advanced Pricing, Release Management - Customer scheduling (Planning/Shipping) (RLM).
• 10 Years of extensive PROD supporting experience in oracle apps with more than 5 end-to-end project implementations.
• Experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Purchasing (PO), Bill of Materials (BOM), Work in Process (WIP), ASCP, Accounts Receivable (AR), Accounts Payables (AP), and Purchasing (PO), HRMS (Core HRMS and Payroll). Experience in Order to cash (O2C) life cycles and Custom Shipping and receiving process for automobiles project in US.
• Worked in multiple vendor environments and managed/lead large teams across different geographies (USA, Australia, Middle East countries) in onsite-offshore model.
• Experience in working in Multi- org, Multi Currency implementation across North America, Asia Pacific and EMEA.
• Excellent exposure in designing system Integration and Interfaces. Experience with RICE components and Technical Design.
• Experience in working with Oracle Support for SR management, patching, enhancement request and resolving issues.
• Core competencies include: Business requirement and transformation, application setup/configuration, business process re-engineering, Program and project management,business system analysis, customsolutiondesign, business requirements gathering, business requirements mapping, systems testing (CRP's, SIT's, UAT's), end-user and post implementation support.
• Have worked as Lead consultant and Project manager for several projects.
• Hands-on experience in 11i and R12 implementation and rollout, Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Experienced in client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, modified the formats using XML publisher for customizations as per client specification. Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Interacted with users, fixed the bugs, developed test plans and provides daily production support. Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS, STATSPACK.
• Implemented R12OracleEBSSupply chain systems globally for American Axle Manufacturing and Confidential .
• Extensive experience with all phases of Software Development Life Cycle (SDLC) including requirements definition, GAP analysis, fit-gap analysis, system configuration and testing, user, and post-production support.

TECHNICAL SKILLS:

ERP Applications: Oracle E-Business Suite R12, 11i

ERP Modules: OM, PO, INV, iSupplier, BOM, WIP, Advanced Pricing and ASCP

ERP Tools: Toad, XML Publisher, Service-now, Data Loader, BI Report, Forms and Reports.

Program/Project management MS Office, MS Project

Languages: SQL, PL/SQL

Databases: Oracle 11g,10g/9iOperating Systems: Windows, UNIXSCM(12 years),Advanced Pricing (3 years),HRMS (3 years),WMS (5 years) Oracle(18+ years)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Support Lead

Responsibilities:

• Configured Inter Company transaction flow between Luxembourg US operating unit for material transfers from Luxembourg and statutory report changes for Mexico tax reforms.
• Implemented Rest API for 6 organization to pull container application information from Integrated plant floor to Oracle EBS.
• Supported Techno-Functional testing for OM, INV, PO, MRP, BOM, WIP, Customer scheduling (Planning & Shipping) as part of Converged instance migration.
• Address SCM, manufacturing, customer planning, shipping related incident and issues for users from different regions across globe and maintaining SLA timeline.
• Propose and implement productivity improvement initiatives using RPA and chatbot.
• Design functional solutions for new plant rollout, identify impact, enhancements to be considers and conversion to be planned.
• Elaborate monthly reporting to get insight into cost of support and split across nature of support issues.
• Created custom Shipping module form and Reports as per AAM Manufacturing shipping requirements.
• Creating Unix shell script for making automate process for Dealer order shipment.
• Created custom alerts and report to reduce the work load and reduce the tickets from service now.
• Responsible for quarterly business review with Client leadership team to share value added services provided and explore future business opportunities.
• Ensure critical systems such as Order Management, Shipping & Receiving, advanced shipment notice (ASN), customer EDI are up and running 24x7. Manage and co-ordinate with business users and off-shore team and third parties to enable smooth execution. Single point of contact for all priority tickets in critical application. Provide root cause and permanent countermeasure and reporting to AAM management. Expertise on heavily customized AAM environment including 3rd party application for EDI, Scanning, Label printing and integration.
• Reduced 20% of high priority issues in Ordering and shipping & receiving area. Implemented 10 permeant countermeasures in last 1 year which resulted in stabilization of applications. Single point of contact for 9 areas/applications across 15+ global plants. Working as subject matter expert which resulted in getting many development projects like GST, Customer EDI to retain LTI. Working independently with third party clients such as ANX (B2B Integration), ICC, Covisint for customer EDI mapping and Supplier Logistics. Implemented various SIP (System Improvement Plan) in last 4 years. Set goals for the team and monitor progress to achieve them and mentor/guide the offshore team.
• Support AAM to Implement Oracle EBS R12 for MPG (25 Sites) by 2020. Additional ERP production support of 25+ new MPG sites. I will be guiding new team members on the planned implementation for processes, application process knowledge. Plan and prepare new team member to support new MPG sites. Plan for integrating support for AAM and MPG Sites. Implementation will be done 5 phase wise globally in countries in North America and South America, Europe and Asia.
• Providing production support for American axle’s and involved in Shipping, Receiving and customer EDI area which is always critical and priority part of AAM business process. This benefitted American Axle to get customer rating of A+ and no penalties to AAM for last 4 years. My SME knowledge/Hands on experience on EBS R12 upgrade in shipping and receiving area benefiting AAM-MPG ERP system integration and implementation. This will result in getting additional 25+ MPG sites integration projects to LTI. Ensuring 15+ global sites are up and running with no priority issues.
• Managing risks (EBS Production support critical & issue). Immediate solution for all P1 and P2 priority tickets. Avoid PRR from all Customer for all ASN issues (GM, Chrysler, Ford and Nissan). Informal communication from user for getting their request and requirement. Customer EDI process - Daily monitoring inbound and outbound customer EDI file and related issues. Communicate with Outside processor customer (CROWN, HITACHI). Co-ordination between third party with client (ANX, ICC, GXS and connection with AAM). Providing production support for American axle’s and involved in Shipping, Receiving and customer EDI area which is always critical and priority part of AAM business process. This benefitted American Axle to get customer rating of A+ and no penalties to AAM for last 4 years.
• Co-ordination between IPF team. Communication with Third Party Logistic supplier and processing supplier PO. Support for all label printing related issue. Enhancement work from shipping area and customer mandated requests as per client expectation. Manage file transfers through MFT (Managed File Transfer) - Customer and Supplier EDI related inbound and outbound files. Co-ordinate with DBA team for system and database issues. Communicate with external parties, suppliers and outside processors like CROWN / HITACHI. Smooth Month End Support. Managing offline shipping, during Production system down. Support AAM to Implement Oracle EBS R12 for MPG (25 Sites) and production support thereafter. Prepare team for readiness for support of new MPG locations. Worked on the setups of the Logistics Process and Reverse Logistics using the Return Material Authorization (RMA) process. Worked on the setups of the Advance Pricing Module and INV Modules. Worked on the configurations of the RMA process in oracle OM - RMA with Receipt, RMA w/o Receipt, RMA for Repair, RMA for Replacement, etc. Worked on the Functional Mappings for data conversion from 11i to Release 12 for PO, Costing, Advance Pricing, INV, BOM, WIP modules.
• Nissan EDI automation process. Metal Market Purchase and Sales Automation process. Automate OTL implement Process. Automation process for sending Supplier ASN, Order and Release files to Logistics. Creating automate (Metal Market sales and purchase process, Scanner and shipping, supplier ASN file transfer process). AAM Build RLM Setups - Complete Trading Partner setup, Customer Ship to Location and Forecasting Designator for customer site, RLM Processing rule. AAM Shipper ASN Transmission Report - Created report in EBS, avoid access report from ANX portal and pay cost. AAM Bank of America Flat File process - Process flat file process between Bank of America and AAM. Customer EDI pre-process logic - Customer Planning and Shipping schedules. AAM Daily JIT Requirement Summary - Customer Past due, current and future requirement details. AAM Process PLEX Material Transactions to EBS - Process WOLC details from PLEX to oracle EBS. AAM Dealer Direct Orders Load Program - Load Dealer order into Oracle EBS. AAM Enable/Disable Offline Shipping - Enable Shipping process in test instance during PROD system down or maintenance.

Confidential

Oracle Support Lead

Responsibilities:

• Designed functionaland Technical solutions as per industry standard for WMS, Pricing, Order to cash and Procure to Pay transformation process with high performance, easy to maintain and minimal chance of functionality break after regular patching.
• Identify Feasibility, Impact analysis and Gaps in current system for Special project and new mergers and propose optimal Functional and Technical solutions.
• Work with Confidential SME’s to review and sign off requirements proposed custom solutions and functional design.
• Setup Configuration - BR100 Preparation & EDI Mapping of Business Process & Testing the new developed components and custom objects as per the business need.
• Understand current AS-IS design and propose future design on oracle apps with fit and gap analysis.
• Implemented Rest API for 2 organization to packing information from 3rd party server to Oracle EBS.
• Co-ordination and communication with Confidential business owners for functional testing, system integration testing and co-ordinate support UAT and other testing events.
• Worked to formulae Implementation and data migration approaches from legacy to Oracle.
• Settings for maintaining organizational structure and organizational data determination and Master Data management.
• Designed Cross module integration- oracle - SOA- Siebel, Oracle to Gains Planning, Manufacturing execution system and third party vendor integration using interface.
• Application Support Management and end to end support for Oracle WMS, SCM, Manufacturing modules & Financial modules.
• Designed Custom shortage report and Clear to bill report for New Zealand Manufacturing org.
• Configured OM defaulting rules for specific customer, order types and cascading rules, Processing constraints for orders.
• Troubleshoot and assist accounting team for period close issues during month end.
• Involved in retrofitting of custom objects.
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions).
• Conversion for customer, supplier, employee and fixed assets.
• Configuration changes in INV, OM, BOM, WIP, Pricing, WMS and as part of requirement for new Org and legal entity.
• Configured separate picking rules to be used for sales order and different order types.
• Created custom program and report and helped warehouse team on Annual Physical inventory counting for Audit.
• Configured Cartonization for selective Parts for automatic packing and shipping based on Physical attributes.
• Configured Move order Picking in WMS to Pick to drop all the item in a single LPN using dummy LPN.
• Automated Complete shipping solutions from Awaiting Shipping to Interface in WMS using custom solution for McDonalds Orders.
• Configured WMS Rules and strategies for Pick, Load Drop and Task assignments.
• Configured WMS Rules for strategies to honor Min max replenishment based on locator capacity Picking order.
• Configured Forecast sets and Forecast and enabled those in ASCP plan for recommendations and effective Production Planning.
• Configured both MRP and Non MRP planned safety stock for Manufacturing parts based Forecast user defined percentage and Service Levels.

Confidential

Senior Project Lead - SCM

Responsibilities:

• Managed Discovery and requirement gathering phases, Prepare blue print for business transformation and fit gap analysis details and get approvals.
• Solution lead for Order to Cash Transformation conducted Oracle EBS to familiarize Levitation users to oracle.
• Prepared Blueprint to Migrate Quote to Cash Business process from Legacy Mainframe to oracle and Presented Global Implementation Framework and phase of execution of project.
• Act as a single point of contact for interactions with AI Shirawi Program Managers and PMO.
• Responsible to work closely with PMO and ensure project is progressing on time and stakeholders Management.
• Overall responsibility for meeting agreed-upon deliverables, timeframes for Discovery and Design Phase.
• Formulated solutions for gaps identified and presented To- be process from As-Is process.
• Conducted Challenge workshops and Question from requirements that are not-standard oracle Fit.
• Provided Justification on no-standard oracle solutions to be considered for Design Phase.
• Status reporting to leadership team and present operational documents.
• Identified L1, L3 Level requirements and classified those as Business essential, statutory and Legal.
• Analyzing existing setup and extending the same to the New-operating unit.
• Developing new solution as per the change in the Business.
• Designing to be business process and GAP identification, BR-100 preparation and Mapping of business process.
• Conducting CRP 1 Testing and CRP 2 Testing to super users & Conducting UAT - End to End Integration testing.
• UPK preparation and Module owner .
• Functional Business support and resolving day-day critical issues.
• Worked on Inbound & Outbound Interfaces in Oracle shipping and 3PL Logistics Carriers
• Designed Ship and Debit Solutions for Price protection Solution for Al-Shirawi.

Confidential

OracleTechno-Functional Consultant

Responsibilities:

• Finalize on Project plan and phase of execution, project timeline and Cut over plan.
• Identify Master and Transaction conversion in Scope and plan for Mock, SIT and UAT cycles.
• Data mapping for Master and Transaction conversion and share Data Mapping sheets.
• Prepared conversion mapping documents for Order to cash and Procure to Pay modules.
• Spearheaded customer conversion from data mapping to development, SIT, UAT testing and production Go- Live.
• Finalize org structure and operating units to which transaction data needs to be converted.
• Data Validation Configuration and testing business Co-Ordination for data file stabilization.
• Co-ordinate with warehouse team for physical movement of inventory from one warehouse to other.
• Assist business users in Acceptance testing and prepare documents.
• Post Golive transition and support Provide business with Monitoring scripts for validation.
• Conduct weekly status reviews with Arrow Director & Manager - Service Operations.
• FunctionalConsultantforOracleOrder Management,OracleAdvanced.
• Documentation - Prepared the Unit test plan, Unit test procedure and System test procedure.
• Involved in Development of RICE components mostly on financial Areas.
• Developed Gl/ AP/AR interface program for sub ledger processing.
• Pricing,OracleWorkflow,Oracle Purchasing, Inventory, Ship and Debit and Price Protection.
• Involved in gathering requirements and testing for gaps found in the Go-Live system. Successful in reducing production issue and achieving customer satisfaction.
• Provided onsite support and for 12 end users over a period of 90 days.
• Involved in developing pricelists for certain customers using qualifiers/modifiers and price breaks like promotion/discount.
• Implemented Ship and Debit and Price protection process for Arrow unity project.
• Setup Supplier trade profiles and involved in mapping of supplier data to oracle from Legacy.
• Master Data Conversion: Supplier, Customer, Part Master
• Transaction Data Conversion: On hand, Purchase order, Blanket sales Agreement, Sales order, Demand history, Customer Quotes

Confidential

Oracle Team Lead

Responsibilities:

• Involved in the development of new Reports
• Updating technical design documents like MD070s
• Day to day status track of issue logs.
• Involved in code review, code migration and code test.
• Design, Code, Test and code review
• Design- Worked with an Architect to get the system design done. Being a part of the review team helped the review process.
• Code Review - Adapted peer-review process.
• Unit testing - Part of the construction phase, came up with Unit test plan, procedures and tested, documented the results. Help the review process.
• Documentation of technical design documents
• Regular meetings with business users with updates on the program and get feedback on services
• Productivity improvement, Automation and address needed for users
• Identify areas of Cost and productivity improvement for Infosys
• Escalation handling, Prepare and communicate Weekly and Monthly status reports
• Impact analysis for new change requests, month end reconciliation
• Provided monthly project metrics to Senior management on the project status update, resource utilization and key risks/issues
• Preparation of Presales Slide deck for new clients and orals
• Assessment and discovery for business transformation Dixcel- Emersion Climate technologies.
• Involved in HIPAA (Health Insurance Portability and Accountability) project
• EDI mapping Code development for multiple EDI transaction like
• EDI Health Care Claim Payment/Advice Transaction Set (835)
• EDI Health Care Claim Transaction set (837)
• EDI Benefit Enrollment and Maintenance Set (834)
• EDI Health Care Eligibility/Benefit Inquiry (270)
• EDI Health Care Eligibility/Benefit Response (271)
• EDI Functional Acknowledgement Transaction Set (997)