SUMMARY:

• Around 6+ Years of IT experience in SAP SD (ECC 6.0, ECC 5.0, R/3 4.7) and consulting business with hands on experience from Implementation, Enhancements, Support, Testing and providing business solutions in SD, LE and MM areas.
• Hands on experience in Database Design, Development & Support of MS SQL Server 2008/2005/2000 for Production/development.
• Well versed in As - Is, To-Be, GAP analysis, business process mapping, business process reengineering, requirement gathering and validation.
• Proficient in Relational Database Management Systems (RDBMS).
• Involved in multiple implementations using ASAP methodology including business blueprinting, realization, testing, go-live, post-live support and training.
• Proficient in all aspects of Project Systems including Planning, Budgeting and Cost allocation.
• Experience in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• In depth knowledge of Order-to- Cash (OTC) processes in efficiently gathering customer’s business requirements and translating business requirements into easy to use SAP system solutions.
• Configuration experience in SD, Enterprise Structure Definition & Assignment, Master Data such as Customer Master Data, Material Master Data & Conditional Master Data, Order to Cash Cycle such as Order Management, Delivery, Shipping & Billing, intercompany process.
• Extensively worked in Logistics Execution (LE) functionalities including outbound delivery processing, picking, packing, posting goods issue, posting goods receipt, transportation, and warehouse management and worked on material listing & exclusions, transfer of requirements, availability checking, route determination, shipping point determination, delivery due list and delivery blocks.
• Extensively worked on CATT and ABAP Queries with the ability to act as a techno functional consultant.
• Expertise in setting up reverse logistics (returns associated with sales and consignment).
• Sound configuration knowledge in MRP (material requirement planning) TOR (transfer of requirements), ATP (available to promise) material listing and exclusion from sales and distribution.
• Good knowledge of ABAP code debugging.
• Worked on Integration with Third-Party Interfaces.
• Worked extensively on developing functional specifications for custom reports development, Field-Exit, User-Exit, Custom-Functions, Data transfer routines, BDC, LSMW and SAP Query.
• Expertise in creating Packages using SQL Server Integration Services (SSIS).
• Experience in interface technology through IDOC, EDI 850 (Inbound Sales Order), EDI 856 (Advance Shipping Notification) & EDI 810 (Outbound Invoice). Configuration of Partner Profile & SD Output Processing.

TECHNICAL SKILLS:

Sales & Distribution: Organizational elements, Master data, Customer Master, Documents (Billing, Sales, Delivery), Pricing Procedure(Condition table, Access Sequence, Condition Types, Pricing Procedure Determination, Condition Records),Third party Processing, Consignment Processing, Inter-company billing and Inter-company stock transfers, Route Determination, Rebate Processing, Cross selling, Availability check using ATP (Available-To-Promise) and TOR(Transfer-Of-Requirements),Credit card Processing, Contracts, Credit/Risk Management, Variant Configuration, STO(Stock Order),OR(Order Management), Cash Sales, Rush Orders, Text Determination, Output Determination, Item Categories, Scheduling Categories, Number Ranges, CMIR(customer Material Info Record).Outbound Deliveries, EDI(Electronic- Data-Interchange).

Material management: Organizational elements, Master data, Purchasing, Material Valuation, Inventory Management, Physical Inventory, Logistics Invoice Verification, Output Determination.

Logistics general: Material Master, Vendor Master, Batch Management, LIS (Logistics Information System), Outbound Deliveries (Picking, Packing, Shipping, Transportation, PGI).

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, SSRS, SSIS, SSAS

RDBMS: MS SQL Server2005/2008, MS Access

Programming Languages: C, C++, Java, SQL, T-SQL, PL-SQL

Internet Technologies: XML, HTML

Productivity Applications: MS Word, Excel, Access

Reporting Tools: SSRS, SSAS, SSIS, ETL, T-SQL

PROFESSIONAL EXPERIENCE:

Confidential, CA

SAP GTS Trade Support Consultant

Responsibilities:

• Requirement gathering for functional enhancement of Compliance, Customs and Risk Management processes in SAP GTS computer system.
• Defining systems strategy, developing systems requirements, designing and prototyping, testing, training, defining support procedures, and implementing practical business solutions under multiple deadlines.
• Demonstrating expertise in the technologies covered by the SAP GTS practice.
• Identifying offerings for new SAP GTS services and ideas and assisting with the development of these capabilities.
• Worked on Export/Import Legal Control.
• Worked on Sanctioned Party List Screening & Embargo Screening
• Analyzing Trade Compliance and Declarations, data flow and business process flow.
• Creation of Project Requirement Document (PRD), business process flows, solution design flowcharts, etc.
• Provide technical expertise in development of best practice in the area of SAP GTS computer system.
• Product and services development to augment or enhance the SAP GTS and interfaced systems.
• Co-ordinate with ABAP team to them design and test flat files for e-invoicing as per a customer’s request.

Confidential, WA

Sr. SAP SD Consultant

Responsibilities:

• Served as a member of the SAP team responsible for SD, LE and roll out new business processes, business process reengineering in alignment with cooperate strategy, formulate As-Is To-Be analysis, identify GAPS and continuous business process improvement.
• Configured new pricing procedures with new condition types, access sequences and condition tables for new business processes.
• Validating that business processes continuously meet expectations across multiple layers of heterogeneous systems- this reduces the risk of change and enables rapid and agile responses to business demands.
• Provided disaster recovery procedures and policies for backup and recovery of Databases.
• Performance Tuning in SQL Server 2000 using SQL Profiler and Data Loading.
• Created new material and customer account assignment group to assign G/L accounts for revenue determination.
• Developed Standard/Template WBS, Networks & Operative Projects for customer projects, proposals.
• Configured material types and changed the field status of the material master records as per the user requirements.
• Installing SQL Server Client-Side utilities and tools for all the front-end developers/programmers.
• Involved in performance tuning to optimize SQL queries using query analyzer.
• Extensively involved in configuration of Material master record, vendor master record, Master Data for Vendor, Customer, Materials and Bill of Materials (BOM), Recipe management.
• Designed and configured credit card processing in SAP with integration with FI team which included understanding the legacy process, developing new credit card process in SAP, having business sign off on the new process, payment gateway vendor training of users and supporting SAP on custom requirements through various OSS notes.

Confidential

SAP SD Consultant

• Created BPR and participated in detailed design documentation and presentation of design to project stakeholders.
• Configured Warehouse Management System for different placement and removal strategies along with its interface with Materials Management, Production Planning and Quality Management.
• Responsible for determining new Pricing Procedures involving assignment of these Pricing Procedures to the sales areas, mass upload of pricing condition records.
• Well versed in LSMW for data migration & SAP queries for reporting.
• Worked on configuration of Credit management functionality. Acquired knowledge of customer’s risk profile based on the information provided by the Accounts and Sales team of the company.
• Configured a process to carry out credit checks in the sales order save process. The checking rules and risk categories were defined to design System reaction of credit checks under different situations.
• Involved in the configuration of the Sales function with different type of sales documents such as Inquiry, quotation, order, contracts, and scheduling agreements and their assignments to sales areas.
• End user training and development of the end user training materials for the same. User Acceptance Testing (UAT) conducted for the configured processes.
• Involved in configuration of consignment process such as Consignment stocks management that includes Consignment Fill-up, issue, pick-up and return. This configuration was carried out to accounts for the stock maintained at dealers and wholesalers as consignment stocks wherever required.
• Configured Rebate agreement functionality for the authorized dealers with credit memo request and issue. Account determination for rebates.
• Involved in extraction, transformation and loading of master data from third party legacy system to SAP.

Confidential

SAP SD Consultant

Responsibilities:

• Customized IMG activities in procurement and inventory management processes, such as purchasing of non-stock and stock materials, RFQ, Contract, Schedule Arrangements, Inbound Deliveries, GR, GI, reservation and transfer orders.
• Responsible for Download, Upload & Validation Programs for Material Master, Vendor Master, Purchasing Info Records, Source List.
• Responsible for complete SAP SD module solutions wing-to-wing; prototyping, blueprinting, designing, building, testing, documentation and post go-live support including interfaces & cross module integration
• Executed SAP SD configuration against the SAP global solution template in line with functional design and performed unit testing of the configured solution
• Partnered with the user community to ensure successful and timely User Acceptance Testing.
• Data migration from legacy to SAP, customer master, material master, opens sales order, pricing, customer material info records.
• Provide SAP SD knowledge and advice to the Master Data Consultants and Change Management experts when appropriate.
• Assisted with developing SAP SD training material for the business key users & conduct key user training.
• Support the business key users in developing work instructions & conducting end user training
• Actively engage all the different functional teams to improve the suggested solutions and increase the business satisfaction and effectively communicate needs across projects
• Ensure quality and best practices in the SAP SD functional domain by driving and adhering to the SAP global solution template, SAP standards, knowledge base & best practices.

Confidential

Confidential . Chicago, IL

SAP SD Consultant

• Responsible for analysis of customer needs and design of Order Management and Logistics Execution business processes.
• Configured Sales Order Processing/Customer order management component incorporating organizational structures in sales, controlling sales process, Sales document types, Item categories, Schedule line categories, Document flow and copying control.
• Go-LIVE issues related to Sales Order Management Cycle, Delivery & Shipping, Billing.
• Worked very closely with subject matter experts for gathering business requirements and translating them into functional and technical specifications.
• Gathered business requirements, conducted fit-gap analysis, blue printing, functional specifications, configuration, reports, forms, EDI etc.
• Configured Copy Control for different sales scenarios (Inquiry to Quotation, Quotation to Sales Order, Sales Order to Delivery and Delivery to Billing).
• Configured the Inbound/Outbound Interfaces, Partner Determination, Batch Determination, Text Determination, Output Determination, Routes, Shipping, Transportation, and Reports.
• Involved in Order Management: Configured Stock transport orders, Inter-company Sales Orders, Returns (Credit Memo Request &Debit Memo Request) Contracts, Schedule Agreements, and Consignment Process.
• Configured the Transportation Management component which includes, defining Transportation Planning Point, Shipment Types, Mode of Transport, Routes and Stages, Route Determination, Freight Codes/Classes, Shipment execution, Shipment costs processing, settlement, Freight cost estimation and Billing.
• Configured Billing Document, Invoice, Debit/Credit Memo, Rebate Agreements and management of the Billing Due List as background jobs.
• Customized the movement types, inventory control using minimum stock and re-ordering level method for automatic re-ordering functionality.
• Developing custom reports according to the requirements of the business stakeholders.