SANDEEP KATARIA

SAP SCM Consultant (Techno-Functional)

Certified SAP SCM-Order fulfilment Consultant

Certified SAP CRM Consultant

Certified OCA consultant

SAP ABAP/4 Consultant

E-Mail: sha50o@r.postjobfree.com,

sha50o@r.postjobfree.com

Objective

Assignments as techno-functional in SAP SCM/CRM & ABAP Module with a high growth oriented project which would help me learn to harness technology and business to achieve the goals of the organisation.

Experience Summary

I am an associate with Total 5.9 years of experience and currently working as SAP Analyst with NDC (ADNOC Group), Abu Dhabi, UAE and 3.6 years of work experience with Tata Consultancy Services. My area of experience includes software, ERP Package e.g. SAP MM/SD Module, CRM, ABAP developer, and Total SAP & sales experience is of 4.7 years in SAP and 1.2 year in software development with Java, Oracle9i, SQL, and PL/SQL.

Gained exposure in SAP SCM, CRM and ABAP Module, adept in analysing information, system needs, evaluating end-user requirements, custom designing solutions, and troubleshooting problems in the process and assisted in SAP for other project.

Qualifications

Degree Institute Major and Specialization

Bachelor of Engineering Govt. College of technology & engineering, Udaipur Computer Science & engineering.

Certification & Awards:

SAP SCM-Order fulfilment Consultant

CRM (Customer Relationship management) Consultant in Sales (SAP).

ORACLE Certified Associate (SQL, PL/SQL).

Certified Performance level test engineer (TCS).

Program or Course Conducted by Coverage

SAP Tech ED-09 SAP Labs Bangalore SAP Advance Concepts

SAP Tech ED-08 SAP Labs Bangalore SAP R/3 Workshops

SAP Sales & Distribution, Materials Management Career development and Training, TCS SAP Sales & Distribution

Materials Management

SAP ABAP Programming Inset InfoTech, Bangalore SAP ABAP training

Summer internship in SAP ABAP WIPRO InfoTech

Delhi ERP SAP with ABAP & Hands on

BASIC FORTRAN & C,C++ Aptech Comp Ed.

Udaipur Basic Concepts of programming

Current Designation:

SAP Analyst (MM & SD) with Techno-functional role.

My Materials Management Exposure:

Key Exposure Areas:

 Business process study and analysis to design solutions (As-Is and To-Be Analysis and Freezing).

 Conducting gap analysis, assess scope of studies & suggest solutions through ERP.

 Preparing Requirement Documents for customer approval.

 Troubleshooting any problems arising in the process.

 Define new plant, storage location, purchase organisation, and purchasing group & assignments.

 Lead MM Master Data conversion, configure & assign purchase value keys..

 Configuration of Material Master and Vendor Master Documents for Account groups.

 Configure terms of payment, price marking for vendors, document types and assign number ranges to all purchase documents.

 Handling the configuration of various purchase documents, BOM, G/ L documents, split valuation, pricing procedure, dynamic availability check for goods movements and configuration of Vendor Master for different accounts and assigning users to the accounts.

 Guiding the set up and customisation of Release Procedures for classification of various Purchase documents i.e. Purchase Requisition, Quotation & Purchase Order.

 Configure pricing procedure. Inventory Management & types of procurement.

 Customisation of material types as per business requirements.

 Implementation of procurement processes with interfaces to FI module and integration for maintaining material master, vendor master and info record.

 Automatic determination of G/L accounts, mapping valuation classes to GL accounts.

 Preparation of test scenarios and support during testing.

 Client interaction, end user training and documentation for power users and end-users.

My Sales & Distribution Exposure: ¬

Key Exposure Areas:

 Defining & assigning Business Organization Structure such as creation of company, company code, plant, sales organization, distribution channel, division, sales office, and sales group.

 Credit & Risk Management functionality including credit control area, Risk category, Credit group.

 Reporting Sales information system [SIS], SAP Query

 Realization of diverse change requests. Conducting unit testing and integration testing.

 Preparing a detailed Process Flow for functional requirements.

 Configuration and validation of the Pricing Master, Output Master Data, Partner determination Procedure, and Incompletion procedures. Customization of the Customer Master, customer material information records, Material Determination, Material listing and Exclusion.

 Generating & modifying the existing data and defining the prices, credit & sales discounts and free goods. Facilitate copy control for Sales, Delivery and Billing documents

 Configuring the Item category determination in sales orders and deliveries, free goods determination procedures, billing process for smooth processing of sales orders.

 Document type's configuration to handle makes to order, make to stock (MTS), scheduling agreements, and consignment Orders and 3rd party order processing.

 Full training and know-how-transfer of a new internal employee for a key support role

 Adopting continuous improvement methodology based on exploration of SAP standards, inputs from users, consultants, identifying & taking up the projects of improvement in new area;

 Identifying control weakness in the system and plugging it through the prevention, detection and reporting mechanism.

 Prepare and assisted in As-Is and To-Be Documents.

My SAP CRM Knowledge:

• SAP CRM Internet Sales: Creation of Web Shops, Product Catalogs, Sub Areas, Product Proposals, Top n Products, Cross Selling, Up Selling and Down Selling.

• Middleware: Client Set up, Creation of Logical Systems Maintaining the RFC Connections between the CRM and R/ 3 systems, Creation of the Bdocs, Bdocs Flow Context, Bdocs Monitoring, Error Handling, Creation Of Replication Objects, Creation Of Publications, Creation Of Subscriptions, Creation Of Sites, Monitoring of Initial Load and Delta Downloads.

• Base Customizing: Business Partners, Business Partner Relationship, Field Groupings, Screen Configuration, Organizational Model, Organizational Data Determination, Maintaining the Categories and Hierarchies for Products, Maintaining Copy Controls between the Sales Documents, Transaction Processing, Actions and Partner Determination.

• Marketing: Marketing and Campaign Management, Segmentation of Business Partners, Creating Profile Sets, Target Groups, Data Sources, Allocation Planning, Personalized Forms, Opportunity Management, Lead Management.

• Sales: Activity Management, Lead Management, Opportunity Management, Quotation and Order Management.

Assignments

The details of the various assignments that I have handled are listed here, in chronological order.

Project In- house SAP Implementation

Exclusive Company National Drilling Company(ADNOC Group)

Period July 2010 to still continue ….

Description • SAP MM/SD processes to meet business needs of NDC.

• Industry business processes(Purchase requisitions, Quotations, Outline agreement including contracts & scheduling agreements, Purchase-to-pay scenarios, purchasing, Inventory management, Logistics invoice verification, order-to-cash scenarios)

• Release strategies, Pricing procedure, Account determination, Message determination, Material and purchasing documents configuration and customized set-up.

• Various Reports i.e.

Open tender/Bidder analysis Report

Rig Stock details Report,

List Of Purchase Orders,

PO Release Analysis Report,

Material and Purchase text Report,

Expiry Contract Notification Report,

Liquidity damages report

• Setting up the Release strategy and their modifications.

• Preparing unit test cases and integration test cases.

• Actively helping in the developments like MM/SD Forms, Enhancements, and LSMW.

• Cross-functional OR linking with other modules(MM, PS, FI, CO, and PP)

Role SAP Analyst (MM & SD) with techno-functional role.

Solution Environment ECC 6.0

Project Project PRIDE SAP Implementation

Exclusive Customer ABB UK

Period July 2009 to June 2010

Description • Configuration of SAP SD/MM processes to meet ABB business needs

• The Whole Sales Cycles in SAP including O2C(order-to-cash, P2P(Purchase to-Pay), MTO, MTS, Consignment order processing, Inter Business Unit sales Processing, Third Party order, Back-to-Back, Complaint Processing, Return order processing)

• Enterprise Re-structure of the existing on-going business.

• Working on Interfaces like OMS, AMF, and PRISM implementation

• Various Reports i.e. VAT Change Report, List Of Sales Orders, List Of Billing Documents, Sales Order Line Item Variation Report, Milestones Report, Outstanding Sales Document report

• Hands on experience in setting up the SD reports.

• Preparing unit test cases and integration test cases.

• Actively helping in COORDINATING the developments

• Unit testing of forms, Reports and conversion programs

• Batch jobs

• cross-functional OR linking with other modules(MM, PS, FI, CO, and PP)

Role SAP Lead Techno-functional Consultant.

Solution Environment ECC 6.0

Project OsA WEAVER SAP implementation

Exclusive Customer ABB South Africa

Period Sept 2007 to July 2009.

Description • Handled Sales processes and its management with complete cycles.

• Working closely with the team for Capturing of Business process in AS IS condition and Re- Engineering the Business process to SAP system to reduce/ eliminate Configuration / Customization.

• Gathering & analysis of requirements and preparation of Business and System Requirements Specifications.

Preparation of Business Blueprint.

• Completely involved in unit testing, Integration Testing and Regression testing.

• Evaluate the various business cycles for sales and marketing to address the requirements, with respect to product features and requirements.

• Realization and customization of Software module for Business needs and meet objectives.

• Conducted Level 1 and Level 2 Training to the officials of client and End User Training. User Acceptance testing (UAT) and System Integration Testing (SIT).

• Leading the Support process and tracking the change requirements.

• Conducting and organizing in-house and external trainings for the project requirements and Organization level training requirements.

• Identification and capturing of business pain points/ issues in relation to the system as well as additional improvement opportunities

• Development of a To-Be system landscape taking into account dependencies, risks and future business strategy and needs

• Design of a deployment plans and roadmap illustrating the entire implementation effort

• Functional and Technical documents for the Objects.

• Actively helping in COORDINATING the developments.

Role SAP Techno-functional Consultant

Solution Environment ECC 6.0

Project SAP Roll-out and support

Exclusive Customer WABCO

Period Jan 2007 to Aug, 2007.

Description • Various business processes with complete sales cycle and document flow

• Created as-is, to-be, and implementation models for

Migration to SAP R/3 from legacy applications. Master data Conversion and Import (customer, material and vendor master) inventory and accounting data to SAP R/3.

• Conducted customer-side Conceptualization, specification and preparation of all required customizations for SAP R/3 (MM, SD).

• Hands on experience in setting up the SD reports.

• Preparing unit test cases and integration test cases.

• Maintaining customer master/ pricing masters to be uploaded into the system using BDC

• Customized the Customer Master data and customer material information records

• Developed FS for MIGRATION Objects i.e. BDC, LSMW

• Developed FS for classical, Interactive, ALV Reports

• Developed FS for i.e. Order acknowledgement ,Invoice layouts with SAPSCRIPTS/ SMARTFORMS

• Developed FS for Enhancements and standard Reports

• Functional & Technical specifications for the Objects

• Actively helping in Coordinating the developments

• Imparted training on sales & distribution sub modules

Role SAP SD Consultant

Solution Environment ECC 6.0

Project In-house ERP implementation

Exclusive Customer Sterlite Industries, India's largest non-ferrous metals (AL, CU, and ZN) and mining company and are one of the fastest growing private sector companies.

Period Dec 2005 to Dec. 2006

Organization KACOSE Con. Services

Description • Design, Development & Testing of the objects

• Function specification reviews

• Runtime analysis / Calculation of the quantity model / Proposal for improvements

• Worked on Data migration objects, BDC, BAPI, and LSMW.

• Extensive Worked on SAPSCRIPTS/ SMARTFORMS ,layouts, Enhancements and Reports

• Tech. Specifications for the Development Objects

• Actively helping in COORDINATING the developments

• IQA and EQA(External Quality assurance)

• Imparting Training

• Data Migration & it's error log analysis

• Unit testing of reports, forms, conversions and enhancements

Reporting

Extensively worked on ABAP Reports.

• Program to display Sales Turnover for different Combinations to list Sold-To Customers and Ship-To Customers based on selection criteria of Plant, Sales-Org, Distribution Channel, Sales-Office, Dispatch details , Customer wise Sales Order Information using both list and Interactive Reports..

• Modified Basic reports in raw materials that give details about the materials and their opening stock, closing stock and consumption on a monthly basis. Month End Inventory reports, purchase order, purchase requisitions, Account Payable information report.

• Print program for sales Documents, Excise Invoices, Delivery Notes Etc.

• Several Reports which are called in SAP Script to fetch data and send through email

SAPSCRIPT/SMARTFORMS

• Designed or Modified Layouts for SD/MM Documents like Sale Orders, Scheduling agreements, Delivery Notes, Commercial Invoices, Purchase order form, Export Invoices, and Credit Notes etc.

• Material Return Delivery, Picking list Printing,

Data Migration using LSMW

• Extensively worked on LSMW to upload master data and other transactions like Customer Master, Vendor Master

• Material Master, Bill of Materials, Open Purchase orders, Sale Orders etc.

Batch Data Communication(BDC)/BAPI

• Extensively worked with both customized BDC Transactions (with Call Transaction, Sessions and Recording methods) and system provided BDC Transactions.

• Developed and implemented Batch Input processes for the business objects like Bill of materials, Routing and other Quality related uploads etc. Developed a Data Transfer program for open Sales Orders, Scheduling agreements in addition with BAPIs.

Role SAP Technical Lead

Solution Environment SAP R/3 4.6C

Project Hotel info. System.

Description Developed a project of Hotel info. System for the related functionalities and process mapping, reservation and booking of suites and the hotel management.

Role Team leader

Project Client/Customer KACOSE Pvt. Ltd.

Period Aug. 2005 to Dec 2005

Technology JAVA, JSP, SQL ,PL/SQL

Back-end MS-SQL Server

Role Software Engineer

Project Jewellery shop information management system,

Description It is a web based an application that allows a gold merchant to completely manage the day to day sales activities in the shop. It facilitates central managers to keep Vendor management, Sales and accounting, Customer management., Graph management This application enables customers to check the latest arrivals, gold rate, etc.

Role Team member

Project Client/Customer KACOSE Pvt. Ltd.

Period Nov. 2004 to July 2005

Technology JAVA, JSP, SQL

Back-end ORACLE 9.0

Role Asst. Software Engineer

Career Profile at a glance

Dates Organization Role

July 2010 to till date National Drilling Company(NDC) ADNOC group SAP Analyst (MM & SD) with techno-functional role.

Jan 2007 to June 2010 TATA Consultancy Services Ltd. SAP Techno-functional Consultant.

Dec. 2005 to Dec. 2006 Sterlite Industries SAP Technical lead

Nov. 2004 to Dec 2005 KACOSE Con. Services Software Developer.

Personal Details

Full Name Sandeep Kataria

Father name Shri. K. L. Kataria

Mother name Smt. Nirmla Kataria

Date of Birth Feb 05,1983

Nationality Indian

Address(Permanent) Sadar Bazaar, Neem Ka chowk,Town –Delwara Dist- Rajsamand, PIN-313202

Address(Temporary) 302,City Seasons Hotels, Abu Dhabi, UAE

Contact Number (Office/ Residence ) +971*********

E-mail Id sha50o@r.postjobfree.com

Language Known English, Hindi, French

Marital Status Celibate

Achievements, Activities and Extra-curricular activities:

Won ‘Beyond performance award’ &‘client appreciation’ for the special initiatives in TCS.

Trained in Preliminary Oral communication in French [Business requirement at TCS]

Selected for NTSE (National level talent search examination) and got scholarship from NCERT and ICAR (Indian council of Agriculture research).

Won the State government scholarship for securing a position in merit in SSC with 85.00 %.

Organized various Intra colleges and inter college techno fest events. Took part in Various cultural activities e.g. singing, poem, essay writing.

Two years actively worked in NSS (National service scheme). Member of Sewa Mandir, an NGO & its various activities.

Passport Details

Passport Holder Relationship Passport Number Date of Issue Expiry Date Place of Issue

SANDEEP KATARIA Self G2951821 16-APR-2007 15-APR-2017 Jaipur

Sandeep Kataria

Contact this candidate