SAP SD CONSULTANT

Rabindra Aryal

SAP SD Functional Consultant

PROFILE

• Over 10 years of industry experience. Hands on experience of working in 6 SAP projects of which 3 full life cycles implementation using ASAP methodology: from Business Blueprint, Realization, Finalization, to Go-live & Support.

• Nearly 7 years of experience in SAP Sales and Distribution (SD) module and integration of SD with FI, CO, MM, WM and PP modules as a functional consultant.

• Expert knowledge on order to cash (OTC) processes.

• Functional expertise: Pre-sales activities such as inquiry and quotation, and major business activities such as Pricing, Billing, Shipping, Transportation, Availability check (ATP), Credit Management, Partner Determination, Output Determination, Bill of Materials and Variant Configuration.

• Technical proficient on debugging and user-exits. Good understanding of ABAP codes.

• Proficient in customizing different Sales Orders such as Standard sales order, Rush sales order, Cash sales order.

• Expert in Shipping Point Determination, Route Determination, Transport and Delivery Scheduling, Backward Delivery Scheduling, Partial and Complete Delivery, Subsequent Outbound Delivery Split and Grouping of Deliveries.

• Expert resource for customizing allocation of Free-of-charge items, and customization for Free of charge delivery, Invoice Correction Request, and Return Orders, Credit Memo, and Debit Memo.

• Expert in the customization of customer master data, material master data, and data sharing among sales organizations.

• Variant Configuration: hands on experience on Super BOMs, Super routings, Configuration profile, Object dependencies, Constraints, and Pricing.

• Pricing Experience: Configuration of Condition Types, Condition Tables and Access Sequences, Determining and Maintaining Pricing Procedure, Creation of Condition Records, Special Pricing Functions such as Condition Exclusion and Analysis of Pricing.

• Billing Experience: Configured Billing Documents based on Billing Types and Item Categories, Customized Invoices. Expert in integrating billing to Accounting and Controlling.

• Credit and Risk Management: Sound knowledge in the configuration of Credit Control Area, Credit Data and Credit Groups. Direct experience of customizing Dynamic credit check process and payment guarantee procedure. Deep understanding of credit card processing.

• Worked on time related and service related revenue recognition procedures. Expertise in configuring Billing Plans, Rebate agreement and Inter-company billing.

• Advanced knowledge on third party sales process and intercompany sales. Good understanding of intercompany pricing and billing procedures.

• Production support: experienced in unit testing, system integration testing, performance testing and user acceptance testing, and regression testing

• Experience in data cleansing and data conversion using tools like LSMW, BDC, CATT, and eCATT, interfaces including EDI/IDOC, RFC and BAPIs.

• Excellent communication, time management, and interpersonal skills.

TECHNICAL SKILLS:

ERP Systems SAP R/3 4.6C ECC 5.0 ECC6.0

Operating systems Windows NT, Windows 2007, Vista, XP, 95

Project tools SOLMAN, SharePoint, MS Office Suite, Ms-Project, Ms Outlook, Mercury Load runner, HP Quality Center 10.0, Manual Testing Techniques

PROJECT EXPERIENCE:

FUJIFILM Medical Systems, Inc., USA, Stamford, CT June 2011 to present

SAP Consultant – Sales and Distribution

ECC 6.0 implementation

• Conducting workshops to gather the business requirements.

• Meeting with business process owners and departmental heads to identify the business requirement.

• Analyzing the client’s as-is business process and mapping it to to-be business processes by identifying the gaps.

• Preparing business process documents for the sales and distribution activities.

• Drafted functional requirement specifications (FRSs) for customer master, quotation processing, sales order processing, consignment processing, billing, returns processing, contract processing, rebates processing, and backorder processing.

• Prepared dataflow diagram for all of the business processes to be included in FRSs.

• Drafted user requirement specification (URS) for sales and distribution.

• Identified RICEFW objects to meet the client specific requirement.

• Prepared functional specification for the development of Reports, Interface, Conversion, Enhancement, and Forms. Prepared unit test scripts and checklist to be included in the functional specification. Tested RICEF objects.

• Configured customer master and partner determination. Added customized partners in the customer master record.

• Designed customer master and customer account group.

• Worked in customer master conversion. Analyzed legacy customer records to map properly to the SAP systems and successfully migrated the customer master records using LSMW.

• Successfully worked on pricing conversion, material listing conversion, open sales order conversion, contract conversion, and CMIR conversion.

• Worked on designing the pricing procedure.

• Configured pricing procedure, condition types, access sequence, and built custom pricing tables.

• Configured account determination, and identified account keys to post to the related G/L.

• Prepared test scripts for the Sales and Distribution.

• Trained testers to execute the test steps in SAP and recording the test results in HP Quality Center.

• Designed smart forms for order acknowledgement, invoice, and rebate credit memo

• Defined user roles and security matrix for SD activities.

• Fixing configuration to support testing activities.

• Working on integration testing and mock 2 preparation.

• Working on training business subject matter experts (SMEs) on SAP functionality to train them as trainers.

• Working on cross-functional integration with LE/WM, MM, FI and PS.

• Working with developers to make the RICEF objects fully functional.

Allergan, Inc., Irvine, CA March 10 – May 2011

SD Functional Consultant

Version: ECC 6.0

Responsibilities

• Involved from blueprint preparation stage of the project to realization and go live/support activities.

• Integrated SD with MM, PP, and FI/CO modules.

• Configured order to cash (OTC) processes including sales order to invoicing, and cash application.

• Customized OTC process control elements such as document types, item category, and schedule line category.

• Maintained Copy control rule to ensure proper flow of data and information in sales and billing document types.

• Customized pricing procedure according to the company’s business process.

• Worked on Rebate Agreements, assigning Condition type groups and tables, activating rebate Processing, setting up retroactive rebates.

• Customized contracts and configured contract related business process.

• Worked on automatic determination of shipping points, and routes.

• Customized outbound delivery documents, picking, packing, and transportation.

• Customized transport and delivery scheduling, delivery note, backward delivery scheduling, partial delivery, and grouping of deliveries.

• Configured backward and forward scheduling in deliveries.

• Customizing order reasons, ATP, ATP using product allocation and unit testing the configuration.

• Configured billing documents and maintained copy control rules for billing documents. Worked on collective invoice and invoice split. Also responsible for unit testing in billing.

• Customized and configured Availability Check and requirement processing Checking Groups, checking rules and control parameters through requirement types. Also completed Dynamic Product Proposal and Transfer of Requirements.

• Credit management: Created credit control area, assigned it to sales area, created credit control and risk category, credit group for customers, automatic and dynamic checking.

• Handled and configured reverse logistics (handling customer returns) including Debit/Credit notes.

• Production support: Resolved tickets and worked with business users and developers to solve the issues. Testing: Carried out unit testing, systems testing, integration testing, user acceptance testing and regression testing.

• Worked in data cleansing, data formatting and data upload.

• Worked with ABAPers to generate customized reports and design forms.

• Worked with developers to create user-exits in sales order creation, delivery and billings.

• Involved in Core User and Super User Trainings.

BorgWarner, Frankfort, IL Apr 2009 – Mar 2010

SAP SD Consultant,

Version: ECC 6.0

• Responsible for gathering requirement analysis and development of the application through interactions with business process owners in relation to legacy and current systems.

• Configuration of SD Enterprise Structure and initial customization as per business needs.

• Worked closely with the marketing and account receivable departments along with the ABAP team members to gather and verify requirements for the customer master.

• Configuration of OTC Process: orders, returns and credit/debit memo requests.

• Configured and customized exclusive Pricing Procedures with Price, Costs, Surcharges, Discount, Freight, Profit Margin using Condition Technique.

• Interacted with developers to design reports, Smart forms and User-exits.

• Worked on Variant Configuration, linked classes, items and BOM, configured ‘configurable materials-BOM’, variant pricing and dependencies.

• Worked on rebates, material determination, out-put determination using condition techniques.

• Configured and customized new Sales, Delivery and Billing document types, Number ranges

• Maintained Copying controls for Sales, Delivery and Billing documents.

• Logistics configuration for shipping such as goods issue for outbound deliveries.

• Configured outbound delivery documents, delivery item category, and item category determination rule.

• Configured shipping point determination by customizing shipping conditions, loading groups, and by defining organizational structures in the logistics.

• Configuration of Route and maintaining the Route determination. Configured the delivery processing, picking, packing and goods issue functions. Worked on route determination by customizing the modes of transport, shipping types, connection points, stages, transportation zones, and shipping conditions.

• Revenue account determination: Dependencies for Revenue account determination, assignment of account keys and G/L accounts. Worked with FI/CO team to streamline revenue recognition.

• Worked on customizing ATP and transfer of requirements to MRP. Configured the inward and outward movements of goods for ATP checking.

• Defining all determination procedures with condition techniques.

• Third-Party transactions (Direct ship process) and Rush Orders, and Cash Sales

• Master data customization of customer master data, customer account groups, partner determination, partner types, access sequences and procedures.

• Worked on defining transportation zones, transportation planning points and document settings.

• SD/FI Integration: Revenue account determination, G/L accounts, accounts keys.

• Close interaction with the users and programmers.

• Active participation in workshops and group meeting.

Yamaha Motors USA, Cypress, CA Feb 2008 – Jan 2009

SAP SD Functional Consultant

Version: ECC 6.0

Responsibilities:

• Involved from blue print phase to go-live and support phase of the project.

• Implementation of the customer order management processes, pricing procedures, and billing with integration to the FICO, WM,SM IM,PM and MM modules.

• Configured order to cash (OTC) process flow.

• Configured components related to Sales Orders: Sales document types, Item categories, Schedule Line Categories, Document flow, Copying controls, Contracts and scheduling agreements, Incompletion logs.

• Customized Pricing (Price configuration, Condition technique, Condition types, Access sequence, Condition records, Special functions, customer hierarchy for pricing, special condition types), Taxes, as well as credit/debit notes. Interacted with ABAP team members and providing them with table names for developing user exits for special pricing conditions.

• Maintained copying control from Sales / Delivery / Billing documents for consignment and third party.

• Customized output determination for sales document, Deliveries and Billing documents.

• Created and customized billing documents and billing methods and rules. Added enhancements to the billing plans types and created date determination rule and also configured the date category.

• Provided production support by trouble-shooting problems that were encountered by users and super users.

• Worked on different consignment processes like consignment fill-up, consignment issue, consignment pick-up and consignment return

• Worked on pricing procedures (condition types, access sequence, condition exclusion and pricing procedure determination) and tested the customized pricing procedure.

• Assisted and documented a variant configuration solution. Worked on Super BOM, Super routing, characteristics, values, classes, and preconditions.

• Configured complex surcharges for configurable materials. Worked on preconditions, selection conditions, dependencies and constraints.

• Worked on the ATP check as per the client requirement and configured and tested the ATP Check.

• Worked on automatic credit limit checks according to a range of criteria and in line with company’s requirements. Also defined at what point the system carries out these checks (order, delivery, goods issue, etc.)

• Worked on revenue recognition cycle business activities, such as sales order entry, shipping, billing and collection.

• End user trainings and preparing the user manual.

Sigma Aldrich Corporation St. Louis, MO Jan 2007– Feb 2008

SAP SD Consultant

ECC 5.0

Responsibilities:

• Conducted group workshops & one-on-one requirement gathering sessions with super users and management; prepared a detailed document of AS-IS study and developed the detailed TO-BE processes to suit the company objectives.

• Defined the partner functions for business partners by assigning an account group.

• Configured inquiry-to-cash process including inquiry, quotation, sales order, shipping and billing information system.

• Configured pricing procedure, condition types, access sequences, and tables.

• Customized condition types related with base price, discounts, surcharges, freight costs and taxes.

• Configured and customized transfer of requirements and availability check as per the requirements. Customized requirement types, requirement class, checking groups, and schedule line category for transfer of requirement.

• Configured Availability check with ATP logic.

• Configured delivery processing, picking, packing, automatic batch determination, shipping point determination and storage location determination.

• Customized transportation planning that involved acquiring the services of the forwarding agent, organizing means of transport, specifying route for shipment, and defining the stages for the route in the most efficient way.

• Configured billing documents and maintained copy control rules. Also customized special billing documents such as Performa invoice, debit and credit notes. Carried out testing of billing documents.

• Worked in configuring dunning procedure and credit management functionality.

• Configured inter-company and third party sales order processing.

• Migration of Master data - customer masters, material masters, pricing masters from the legacy system into SAP.

• Worked on Go-live and provided Post-live production support to trouble-shoot problems encountered by power users.

Ranbaxy Pharmaceuticals, South Field, MI Feb 2006 – Nov 2006

SAP SD Analyst

Responsibilities:

• SD was to be configured to support sales and distribution activities. It was also linked to MM and WM to support the sales and contracts. Each of these areas required unique pricing considerations based on volume, account type, commercial vendor, promos and specials.

• Configured OTC process by customized inquiry, quotation, sales order, cash order, rush order, deliveries, transfer orders, post goods issue, billing and release to accounting.

• Worked as a team member in troubleshooting the complex pricing procedures, which was initially configured and was confusing the users causing losses to the company in certain business transactions especially where discounts were involved.

• Configured various credits and debits memo requests for the corresponding billing types and used workflow for credit memo requests based on value.

• Tested sales documents, billing document and credit management functionality.

• Created batch management to schedule billing due list automatically and output determination procedures for billing documents.

• Using the LSMW tools, responsible for loading key cut-over data into system including customer master and credit master.

• Configured the billing plans as per the requirements. Customized the billing dates as per the billing plans - milestone billing and periodic billing.

• Configured basic functions such as output determination procedure, and text determination procedure.

Nestle USA, Glendale, CA Feb 2005– Dec 2005

Role: SAP SD Analyst

Responsibilities:

• Worked in master data for customer master, material master, customer material info record, Master data migration from legacy system to SAP using LSMW.

• Worked on master records for business partners and defined account groups and field selection for customers.

• Worked on order to cash processes including order management, delivery processing, invoicing, and cash application.

• Processed customer master records. Maintained customer hierarchies and determined which combinations of sales and distribution areas are permitted for each customer hierarchy type.

• Worked in billing documents configuration. Customized order related and delivery related billing process.

• Configured material determination using condition technique.

• Worked in pricing procedures (condition types, access sequence, condition exclusion and pricing procedure determination).

• Helped in developing a strict but flexible credit/risk management which the top management was very concerned as they were dealing with small lesser known companies without affecting the trust of their growing markets. Detailed payment card agreements with valid blocking reasons where configured.

Nepal Credit and Commerce Bank Limited, Kathmandu May 2002- Dec 2003

Executive Officer

Responsibilities

• Analyzing balance sheet, income statement, and cash flow statement and other related statements of the customers as a Credit Analyst.

• Analyzing business processes of the borrowers and working with them to implement industry best practices.

• Preparing annual budget (profit plan) of the branch and analyzing costs and variance on timely basis, conducting the business within approved expenditure level, analyzing different scenarios, and conducting what – if analysis.

• Issued Letter of Credit (LC) to foreign banks as requested by domestic importers, finalized terms and conditions of the LC.

• Scrutinized international trade documents such as Bill of Lading, Certificate of country of origin, Transit insurance policy, packaging list, pro forma invoice which were sent by foreign banks to release the payment to foreign exporters.

• Scrutinized export LC documents sent to the local exporter by European and American importers via their banks. Helped negotiating trade terms with the foreign banks and MNEs and collected payments on behalf of the local customers.

• Handled trade finance business of the branches to serve business houses dealing mainly with India and China.

• Used Excel extensively to prepare reports, analyze financial performance, and create scenarios

• Branch level asset acquisition, depreciation calculation and assets management.

• Monitoring daily cash requirement at branch level and making necessary arrangement with corporate office.

• Conducting day-end, month-end, quarter-end and year-end operation in the ERP environment.

• Supervising the preparation of profit loss account, balance-sheet and cash flow statement at branch level.

• Communicating branch’s business plan the CEO and BOD members and addressing their concerns.

• Installed banking ERP software (Pumori) in two branches and implemented successfully.

• Monitoring and addressing customer privacy and account security issues.

Nepal Bangladesh Bank, Kathmandu, Nepal Feb 1997- May 2002

Supervisor

Responsibilities

• Joined the bank as Jr assistant and promoted to assistant and supervisor position successively.

• Analyzed and processed requests for bank guarantee, letter of credit (LC) and other trade instruments and provided trade finance services to exporters and importers dealing mainly with India and China.

• Worked in management information system department on reporting compliance, security and privacy issues.

• Responsible for branch accounting, passing journal entries, conducting periodic end operations, and preparing financial and other reports for financial and managerial accounting purposes.

• Prepared loan loss provision sheet in Excel and recognizing loan loss provision in books.

• Prepared schedules and reports for further reporting to central bank.

• Prepared daily exhibit reports for the use of branch manager.

• Provided frontline banking services, customer services and retail banking such as account opening, auto loan, home loan, mortgages, education loans etc.

Government of Nepal, Ministry of Science and Technology, Kathmandu, Nepal

Jan 1995 to Apr 1996

Senior Assistant (NayabSubba, Non-Gazzetted First class level)

• Worked as Public Relation Officer at the Secretariat of Minster for Science and Technology

• Assisted Chief PRO on office administration

• Liaised with and answered enquiries from media, individuals and other organizations, often via telephone and email.

• Prepared and supervised the production of publicity brochures, handouts, and direct mail leaflets

Education

Master of Business Administration

Contact this candidate