Ravindran R.

Ravindran R.

SAP SD/FI/IS-OIL/EDI Consultant

Atlanta , United States

Experience: 15 Years

Ravindran

Atlanta , United States

SAP SD/FI/IS-OIL/EDI Consultant

115200 USD / Year

  • Immediate: Available

15 Years

Now you can Instantly Chat with Ravindran!

About Me

  • Over 15 years of IT experience which includes Nine (9) years in SAP OTC as Functional Consultant specializing in Sales and Distribution and Material management modules in Automobile, Pharmaceutical, Food and OIL & GAS Industries.
  • ...
  • Managed all aspects of SAP solution design through technical implementation.
  • Technical design expertise includes product development, testing, implementation and support of on-line systems. Strength lies in implementing integrated solutions and knowledge of varied functional areas of Sales and Distribution, Materials Management, Logistics Execution and Finance.
  • Good understanding of all phases of system development life cycle across Industries such as Automotive, Food, Distribution, Engineering Products.
  • IS OIL & GAS Downstream.
  • Knowledge in IS-Oil configuration for pipeline, rail, truck and book transfer mode of transports
  • Worked on different Types of Taxes (US Federal Excise Taxes, US state excise Taxes, Environment Fees, Pre-Paid Sales tax, Oil Spill fee, Leakage Under Storage Tax (LUST)etc.
  • Proficient in the use of AGILE/ASAP implementation methodology and SAP Solution Manager.
  • Analyze the Business Requirements, Needs and Objectives and Map them to the SAP processes, solutions and products that are being implemented.
  • Expert in functional analysis, Gap analysis, Business Process Re-Engineering & testing and interacted with client consulting companies for streamlining the business processes.
  • Three life cycle implementations Data collection, Gap Analysis, Business Blueprint, Legacy System Conversion, Realization, Testing, Final Preparation, Go-Live and Support, Training and Documentation.
  • Gather requirements and translate them into Functional Specifications
  • Experience in Europe, North America, and South Africa Sales processes.
  • Expertise in Implementing, Customizing, IMG Configuration, Analysis, Application Design, Testing, User Training, Support in SD module.
  • Knowledge in IS-Oil configuration for pipeline, rail, truck and book transfer mode of transports TSW, exchanges, Hydro carbon product management (HPM), Marketing, Accounting & pricing (MAP) and Transportation and Distribution (TD).  Order to Cash Cycle Sales contracts, orders, pricing, shipping and billing and also Procurement to pay cycle configuration Purchasing, Inventory Management and Invoice Verification of Materials Management module and work flow.
  • Sound knowledge and experience in integration of SD-MM, SD-FI & SD-CRM, LE Modules, Interfaces, EDI / IDOC, Functional Specs for RICEF’s objects
  • Outbound EDI 810 Invoice, EDI856 ASN, EDI855, order confirmation, EDI404 waybill and Inbound EDI 850, purchase orders, EDI 875, multiple PO EDI945 consignment issue order, EDI824/864 message, EDI 860 PO change, EDI 753 Request for Routing Instructions, EDI 870 order status.
  • Debugging knowledge in ABAP.
  • Experience in SD Area: New Sales Order types, Order Entry, Deliveries, Invoicing, Pricing Procedures and Conditions, Creating Output Types, Output Determination, Account Groups, Condition Types, Customer Master, Material Determination, Third Party Processing, Transportation Planning, Billing, Credit Management, Business Process Automation, Customer Material Info Records, Partner Functions, Quotation Processing, Sales Order Pricing, Availability to Promise (ATP), Back Order Processing, etc.
  • Pricing expertise involved configuration of pricing procedure, maintaining various condition types, access sequence for these condition types, maintaining condition records, maintaining routines; Tax Determination procedures; Rebates for International, Domestic Customers and one time customers.
  • Involved in implementation of Order-to-Cash that involves configuration of Availability Check, Transfer of Requirements, Contracts, Schedule Line Agreement, Shipping point determination, Route Determination, Delivery, Invoice generation and Account Reconciliation
  • Delivery processing, Stock Transport Orders, Picking, Packing, Shipment Processing, Route Determination, Load Optimization, Carrier Payments and Warehouse Management.
  • Customization & Configuration of Schedule agreements, Contract Management, Shipping, Billing, Output determination.

Data Migration: Expertise in migrating and converting data from legacy system to SAP using

Show More

Portfolio Projects

Description

  • Design SAP functional landscape and solution, including the functional integration points, applicable standards and governance.
  • Translating business requirements into specific system, application or process designs covering both functional and non-functional aspects.
  • Participating in multiple design activities, from requirements analysis to systems application and process design specification.
  • Collaborate with the business process teams and managed services teams to ensure right solutions are designed and deployed.
  • Act as a center of expertise, staying abreast of developments in the SAP space and continually upgrading functional knowledge.
  • When required, analyze changes necessary to the solution architecture triggered by changes in business requirements, processes or technical requirements, develop options to incorporate the changes and take facilitate the appropriate decisions.
  • Developed and presented high level architecture Design for Military export sales process
  • Collaborated with Proposal teams in proposal development activities from inception through the process. Wrote sections of proposals, help with effort estimations, high level project implementation road map, client Q&A, client presentations etc.
  • Participated in high level strategy documentation for implementing Military export sales process
  • Prepared and delivered deep dive sessions related to FIT/GAP for process GAPS and technical GAPS
  • Developed, configured and documented the Military Export sales process.
  • Impart Knowledge transfer and training to local business team and offshore Application Management Support team on the functionalities of the application and help with troubleshooting.
  • Coordinated and lead in the discussion of the acceptance criteria for the various tollgate process (planning thru build phase)
  • Collaborated with the team and client counterpart to manage the project plan, identify risk, issues, gaps in a proactive manner and implement mitigation plans to minimize the risks and ensure milestones are attained.
  • Resource planning and scheduling of the work to be completed for each phase
  • Developed sample test case scenarios for order to cash
  • Manage project plans for the day to day operations

Interfaces design including EDI 856 ASN, Inbound EDI 850, purchase orders, EDI 810 Invoice

Show More Show Less

Description

  • Working as SAP - Lead consultant and Business analyst to implement GSAP for US to bring all business process in One SAP
  • Worked on design and development on SAP based Tax engine for logistic process to register and report account payable and receivable for volumetric taxes automatically in all states in US. Developed and implemented by Shell and Sap Germany.
  • We plan to use one single scenario Volume tax solution for Calculation of Taxes, Application of licenses/exemptions, Deferral, Liability/claim, Recovery/payment, Tax return preparation, Tax accounting and reconciliation.
  • Creating, configuring, and maintaining the new tax calculation as per federal law.
  • Tax analysis US excise (VTE) Volume TAX related developments / implementation for oil client.
  • Creating, configuring, and maintaining the new tax calculation as per federal law.
  • Contribution of Tax test scenarios for testing and validating the test results.
  • Cutover Activities, Data validation, Support for CAT test, LES1, LES2, Go Live.
  • Defect analysis and resolved the defects during CAT, LES, Cutover activities, hyper care support.
  • Co-ordinate with central development team and Business team integrated with other modules MM, FI, to flow business process smoothly.
  • Worked on SAP OTC Processes, Hydro carbon Management that includes the IS Oil Specific areas such as Transportation and Distribution, TSW Module to enable the system to supply the material to customer based on the Demand and Supply.
  • Generated Data sheets understanding the nature of scenarios and Master data for testing the Business flows such as Sales (OG, OS, DG, DS), Purchase (OK, OP, DK, DP) and Transfer (OX, DX) and Exchange scenarios for Marine, Pipeline, Road and Rail Transports for Refineries, Terminal ling, Depots, 3rd Party depots, and service stations.
  • Pricing and its interface with Account receivable, Tax and Account determination.
  • Created new pricing procedure ‘s for consignment.
  • Analysis pricing and Routines logic.
  • Debugging ABAP code for Root cause analysis. Give solution to resolve the issues.
  • Creating condition types according to federal tax calculation and state wise tax calculation.
  • Creating schema to valid business requirement adding condition type to schemata for the volume metric tax calculation. Include to existing pricing procedure trigger volume metric tax calculation.
  • Volume Tax analysis for preprocessing and post processing for reversal and rebilling.
  • Volume tax analysis to Special ledger generic detail report in BI for GL account posted to analysis the Tax Difference between the movement and invoice to make adjustment.
  • Integration with other functional modules FI/MM/ LE/BI/HM/TSW/TDP
  • Conducting Workshops to collect Business Requirements, Creates High level Design Requirement document, FDD and collaborate with Technical team for developments in RICEF’s.

Show More Show Less

Description

  • Analyzing of existing business processes and supporting applications. Coordinate and meet with business and IT teams to define, gather, and document process requirements. Translate business process requirements into detailed functional specifications for IT configuration/development teams.
  • Coordinating team and training plan development for end-user support. Responsible for leading the development of functional specification, Business Process Procedures, Test Scenarios and Test Scripts.
  • Worked on Integration with R2R, P2P, and I2P business processes.
  • Worked with various RICEF’s –Interfaces design including outbound EDI 810 Invoice, EDI856 ASN, EDI855, order confirmation, EDI404 waybill and Inbound EDI 850, purchase orders, EDI 875, multiple PO EDI945 consignment issue order, EDI824/864 message, EDI 860 PO change.
  • This also includes extension of existing IDOCS, creation of partner profiles and mapping of EDI data.
  • Managed & Coordinated with Off-shore/Onsite development team to develop objects.
  • Integration with other functional modules MM, FI, CRM, LE.
  • Integration with EDI partners Crossgate, BIZ Talk
  • Analyzing and resolution of defects in HPQC.
  • Worked on test script creation and execution FUT
  • FIT of Interfaces setup for Sales processes
  • Developed various mass upload programs.

Show More Show Less

Description

  • Drive the analysis of existing business processes and supporting applications. Coordinate and meet with business and IT teams to define, gather, and document process requirements. Translate business process requirements into detailed functional specifications for IT configuration/development teams.
  • Own deliverables in project life cycle phases and activities for new implementations and support initiatives (including requirements definition, design and process flow documentation, application configuration and configuration rationales, functional specifications, test scenario and test script development and execution, go-live and support,) to meet internal customer business requirements and objectives.
  • Coordinate testing, test and training plan development and end-user support. Responsible for leading the development end-user documentation (Business Process Procedures, Test Scenarios, Test Scripts, etc.).
  • Lead root cause analysis where applicable using knowledge of business process, supporting applications, and interfaces for defect resolution. Comply with JCI established policies, procedures, methodologies and standards in completing assignments/deliverables.
  • Owns and is accountable for the support of assigned OTC business processes through issue identification, resolution and process optimization.
  • Developed new tracking tools.
  • Testing of Interfaces setup for Sales processes
  • Created the integration test plan and testing scenarios for sales related areas of design.
  • Creating /Modifying Smart forms and driver programs for country specific requirements
  • IDOC mapping for Invoices, Self-billing
  • Configured interfaces EDI 810 (invoice outbound). This also includes extension of existing IDOCS, creation of partner profiles and mapping of EDI data.
  • Coordination with ABAP team for technical inputs, Business Focal Point, and End users.
  • Ensure all deliverables from team members are delivered in time with focus on quality
  • Take ownership of integration areas and drive collaboration with other process team and IT analysts (RTR, PTP, and STP) to improve/optimize JCI Automotive Engineering, including Solutions E2E business process solutions.

Configure of Shipping and Transportation activities - Processing Deliveries, Shipping Information & Analysis, Batch Splits, Transportation Planning and Scheduling, Route Determination - route, modes of transport, shipping types, routes and stages, transportation connection

Show More Show Less

Description

  • Coordinating team and training plan development for end-user support. Responsible for leading the development of functional specification, Business Process Procedures, Test Scenarios and Test Scripts.
  • Worked on Integration with R2R, P2P, and I2P business processes.
  • Worked with various RICEF’s –Interfaces design including outbound EDI 810 Invoice, EDI856 ASN, EDI855, order confirmation, EDI404 waybill and Inbound EDI 850, purchase orders, EDI 875, multiple PO EDI945 consignment issue order, EDI824/864 message, EDI 860 PO change.
  • This also includes extension of existing IDOCS, creation of partner profiles and mapping of EDI data.
  • Managed & Coordinated with Off-shore/Onsite development team to develop objects.
  • Integration with other functional modules MM, FI, CRM, LE.
  • Integration with EDI partners Crossgate, BIZ Talk
  • Analyzing and resolution of defects in HPQC.
  • Worked on test script creation and execution FUT
  • FIT of Interfaces setup for Sales processes
  • Developed various mass upload programs.

Show More Show Less

Description

  • Assigned to troubleshoot a backlog of Production Support Remedy Ticketsin areas like Order management, Manual Backorder (Scheduling and ATP problems), Pricing Issues, Invoicing Issues, Output determination issues.
  • Supported business objectives by providing numerous statistical reports by creating and utilizing ABAP queries and maintaining SIS structures.
  • Timely monitoring & quick resolution of the tickets at various priority levels (High to low).
  • Regularly monitored IDOCS issues and guided the IT maintenance team in reprocessing them.
  • Monitoring the Scheduled Jobs of Sales and analyzing the error logs
  • Interacted with analysts, business users and other team members at all times whenever needed to help them understand the existing processes and their complexities related to SD module.
  • Documentation of resolutions provided on complex issues faced to help analysts handling similar issues in future.
  • Provide solutions for Business requirements by designing and implementing new developments and enhancements
  • Creating Functional specifications for the developments / enhancements.
  • Coordinated with the users and Technical team on developing new reports
  • Ensure smooth functionality and works on order management issue OTC.
  • Periodic status reporting and metrics to client management team.
  • Coordination with ABAP team for technical inputs.
  • Supporting and Training End Users in daily business Transactions.
  • Working with the Technical team to identify the User Exits/Functional modules to send data across the legacy system using EDIs and prepare technical specification.
  • Configuration of Basic Functions – Pricing, Account assignment, outputs, partner determination, Text controls, Incompletion logs, Credit management.
  • Analyzed the pricing strategies and customized pricing procedures. Created standard pricing procedure with different discounts, surcharges, and rebates using condition tables, condition types, access sequence and pricing procedure determination.
  • Created the integration test plan and testing scenarios for sales related areas.

Show More Show Less

Description

  • Analysis of existing business processes and supporting applications. Coordinate with business and IT teams to gather business process requirements and prepare functional specifications for development teams.
  • Lead root cause analysis where applicable using knowledge of business process, supporting applications, and interfaces for defect resolution.
  • GAP Analysis and scrub analysis and developing new interfaces, enhancement programs in SAP system.
  • Developing new programs and modifying existing programs according to business needs.
  • Analyzing and providing permanent solution for the defects.
  • Support - Providing solutions for Business requirements by designing and implementing new developments and enhancements. Developing Standard and Nonstandard Interfaces as per customer requirements.
  • Helps to bring smooth functionality and works on order management issue OTC. The order management covers the path of an order from initiation (and even pre-initiation), to order fulfillment. All the different processes of the order life-cycle are linked within Sales and Distribution (SD) and to relevant processes outside SD e.g., Financial Accounting and Materials Management. Configured interfaces to suppliers included EDI 850 (Order Creation-Incoming orders), EDI 855 (Order acknowledgement), EDI 810 (invoice outbound). This also includes extension of existing IDOCS, creation of partner profiles and mapping of EDI data.
  • Configuration of Shipping and Transportation activities - Processing Deliveries, Shipping Information & Analysis, Batch Splits, Transportation Planning and Scheduling, Route Determination - defining route, modes of transport, shipping types, routes and stages, transportation connection points, transportation groups and transportation zones.
  • Testing – Performing FAT, Unit testing, Integration testing and User acceptance testing of B2B related Messages (EDI X12- 832, 850, 855, 810) with Customers and 3rd party providers. Fixing Issues encountered.
  • FAT Approval
  • Preparing Integration testing plan/scripts
  • Testing in QA system along with business
  • Raising defects in HP-Quality Center (HPQC) fixed to get defects, Design, Testing & Implementing Change Request CRQ changes in Development, Quality and Production systems. Creating or updating functional specification for new requirements Unit testing changes in dev system Creating test scripts for integration testing in HPQC.
  • Prepare Test Data, Executing & supporting Integration testing
  • Responsible for Production issues of B2B Sales and SAP Interfaces
  • Monitoring the SAP Interfaces- Idocs, Analyzing and correcting issues.
  • Monitoring the Scheduled Jobs of Sales and analyzing the error logs
  • Creating Functional specifications for the developments / enhancements.
  • Coordinating with the users and Technical team on developing new Interfaces, reports.
  • Developing Functional End user documents.
  • IDOC mapping for Orders, order confirmation and Invoices, (ANSI X-12.
  • Integration with SD-CRM & SD-MM modules.
  • Configured shipment costs processing by defining the shipment cost types, item categories and number ranges for shipment costs.
  • Shipping and Transportation activities - Processing Deliveries, Shipping Information & Analysis, Batch Splits, Transportation Planning and Scheduling, Route Determination - defining route, modes of transport, shipping types, routes and stages, transportation connection points, transportation groups and transportation zones.
  • Worked on Logistics Execution (LE) functions like Delivery Processing (inbound and outbound processes), Picking, Packing and Transportation.
  • Configured the third party tool PUNCHOUT with SAP.
  • Developed new program for accepting the parameters in SAP for third party tool RIO mobile application.
  • Involved in baseline configuration assignment of plants to company code, storage locations to plant and ware house to location.
  • Supported business objectives by providing numerous statistical reports by creating and utilizing ABAP queries and maintaining SIS structures.
  • Working on various tax related issue with the Sabrix interface
  • Analyzing the production issues and making changes.
  • Performed Data Validation,
  • Worked for SD Archiving Objects (SD_VBAK, RV_LIKP & SD_VBRK) and Batch Masters (MM_SPSTOCK).

Show More Show Less

Description

  • Involved in Business Blueprint, As-Is analysis, To-be analysis, Gap Analysis with business Teams.
  • Configured Enterprise structure that includes defining additional Divisions there by Sales Area for newly developed product lines.
  • Pricing expertise involved configuring Pricing procedures for newly added International and Domestic customers, setting up different condition types, access sequence, maintaining condition records, condition exclusion and maintain VOFM routines.
  • Configured Order-to-Cash (OTC) process which included Scheduling Agreement obtained by inbound EDI, created outbound delivery and Invoice generation which was sent back to customers using outbound EDI.
  • Configured interfaces to suppliers included EDI 850 (Purchase order notification), EDI 856 (Advance shipment notification inbound), EDI 810 (Vendor invoice inbound). This also includes extension of existing IDOCS, creation of partner profiles and mapping of EDI data.
  • Output Determination configurations included setting up Exchange servers for emails, printing ports to print Smart Forms (Sales Order and Invoice), Fax Viewer to use Fax and EDI using IDOCs.
  • Sales order management configuration included Direct Sale, Drop Ship Orders, Intercompany sales, Cash Sales, Rush Orders, Consignments, Item Categories for Dispute and Collection process of sales
  • Gathered requirements and designed business scenario for returns order processing, pricing for returns, credits to the customer and free goods determination.
  • Configured order type, new item categories, schedule line categories, incompletion procedure, item category determination, order reasons etc.
  • Wrote functional specifications for custom copy control routine to manipulate pricing procedure on the target document.
  • Configured the system for free goods determination process.
  • Worked on system test script preparation and consolidation of test cases into logical sets for execution.
  • Worked in formulating the Solution frame work, application design, Functional design, configuration documents
  • Worked in End to End SD customizations for Sales order types for consignment fill up, pick up, issue, returns for various business processes, Configured replenishment process, return processes between country Hubs and Regional DC, Trade and IC(Intercompany) orders
  • Created and Configured pricing procedures for PO/SO process, returns process, part reconciliation processes using condition technique
  • Configured item categories, copying control, document flow, availability checks, schedule lines
  • Worked on Stock transport orders (STO) for multi leg shipments
  • Designed picking list, Invoice forms and Configured output types, output determination procedure for Invoice Layout sets
  • Configured billing blocks and modified pricing procedure to store List price in VBAP sub total fields.
  • Worked in SM module for part return process with all Service Notifications related configurations like SN types, code group, activity codes, item tasks etc and integrated process flow with SD OTC process
  • Customized the system for partner determination, incompletion logs, and field status groups in customer master

Configured and customized Logistics module for Deliveries

Show More Show Less

Description

  • Worked on full life cycle implementation of SAP SD module integrating with other warehouse management systems like PKMS and WMS.
  • Analyze company business process and process requirements, identify data conversion requirements, conduct integration testing and go-live preparation.
  • Configured master data for customer and material.
  • Responsible for configuring and maintaining Order-to-cash processes including Order Management, Pricing, Shipping and Billing
  • Responsible for development of unit and integration test scripts as well as execution of integration testing.
  • Involved in design of Variant Configuration solution and responsible for testing SD integration points.
  • Create functional specifications and change requests on approved system enhancements.
  • Design and implement logistics and SD processes, including delivery processing and variant configuration, with consideration of the integration points between SD, MM, WM, QM and APO.
  • Configured and Set up Distribution Channels and Divisions and Sales Groups, Customer Groups, Custom Tables and Maintenance as required
  • Set-up the Customer Master, Material Master and Vendor Master, used LSMW for master data migration from Legacy systems
  • Worked on Order-to-Cash cycle configuring Sales Orders, Deliveries and Billing
  • Extended the existing materials and customers to new company codes & Sales organization, Configured Material Determination to automatically substitute a material with another material, Worked on the Material Listing/Exclusion, text determination and output type configuration
  • Involved in the configuration of Logistics Execution module shipping by defining the basic functions like shipping conditions, loading groups, Transportation groups
  • Involved in configuring Transportation, Route Determination: Configuration for creating route determination based on the shipping point and destination country. Defining mode transport and assigning shipping points. Defining route with its route stages and connection points. Settings country and dept zones, shipping conditions in sales order, Transportation group, weight group
  • Automated the Rebate settlement process by designing a function module providing the facility to the user for entering the amount and Rebate agreement number and run the transaction VBO2 to create a credit memo request and passing the request number through parameter id in transaction VA02 to generate credit memo
  • Performed Data Validation, Data Cleansing and Data readiness. As a
    Validation process generated reports using SE16 and used a lot queries.
  • Formulated functional test scripts to cover every scenario that is to be included in the LIS/SIS to ensure accurate postings on those reports.

Pre-implementation business process mapping, post go-live and end-user training

Show More Show Less