Xxxxxxx Xxxxxxx
SAP CRM Functional Consultant


Email-id: xxxxxxxxxxxxx@xxxxx.xx.xx                                                Phone: +xxxxxxxxxxxx (India), xxx-xxx-xxxx(US)

Experience Summary
Total experience 7-1/2 years in which 4-1/2 Year with TCS as SAP CRM Functional Consultant involved in SAP CRM CIC, Sales and SFA Production support-ADOBE US/India, CRM Service Roll out at Singapore, Australia, Indonesia, New Zealand-ABB, SAP CRM Duet -Test Lead –SAP India, CRM Sales Production support and BI- Philips Netherlands, SD and VBA tool L2 support- SAP AG Walldorf, SD L1 and L2 Support Production support- Delphi).
2 year of Oracle DBA and PL/SQL/Java development and database administrative experience.
1 years of Functional Experience in IT Product Marketing as Customer Relationship Executive.
Knowledge in SAP (SD,MM,CS,PM,QM,FI,CO,BI,ABAP ).
Certified in CRM 4.0 E- Commerce and Oracle DBA 9i.
Trained in Six Sigma Green Belt, ITIL V3 and PMP.

Career Profile
Dates
Organization
Role
May 2005 till date
Tata Consultancy Service Limited (www.tcs.com)
SAP CRM Functional Consultant

June 2003 – April 2005
IES Consulting Bangalore(www.iesconsulting-india.com)
Oracle DBA ,Java ,VB developer
July 1999 – June 2000
iGlobal Software Bangalore (www.iglobal-software.com)
Customer Relationship Executive


Qualifications
Degree and Date
Institute
Major and Specialization
Master in Computer Application (MCA )
(Aug 2000- June 2003)
Mysore University with 70%
Computer Application, Oracle, ERP.
Bachelor in Commerce (B.Com)
(Aug 1996 - June 1999)
Purvanchal University
Marketing and Finance   
Project – SAP CRM Sales and Service, SFA Production Support Project

Project
CRM 5.0 and CRM 5.2 CRM Sales and Service ,SFA Production Support Project
Customer
ADOBE US –San Jose (Hi-tech Industry)
Period
Dec 2008 to Till Now
Role
Roles and Responsibility:
Status meeting with Client and TCS Management.
Issue management preparation and updating to senior management.
Weekly meeting with Team.
Training and Knowledge transfer to Team.

As a Module Lead , was responsible for
Understanding of ADOBE Sales and Service Business Process.
Analyzing of the ADOBE IT landscape and SAP and Non SAP system integration information.
Analyzing of ADOBE Incident Management, Releases Management, Service Support Architecture and Customer support Architecture.
Gathering of ADOBE Sales organization structure, Customer support structure and IT Support structure.
Analyzing of Sales Force Automation and CRM CIC, WCD, DQXI.
Gathering of the Master data of ADOBE.
Handling Onsite Production support lead role.
Providing Transaction support for ADOBE Activity Management (Customer Service), Technical Service case, Sales Order, Contract Order, Free of Charge order, Return Order, Credit management order.
Providing Support for Sales Force Automation (Magic carpet, Lead, Opportunity, Territory management, Activity management).
Troubleshooting Dylan order with SAP CRM System.
Scheduling CRM Sales and SFA job and rescheduling.
Providing L2 (Bug fix) and enhancement report or job support.
BP Master data address related issue
Deletion of error Bdoc from Queue.
VAT Id and tax related issue with BP.

Solution Environment
CRM 5.0 and CRM 5.2 (SFA),ADOBE Portal, Worldwide customer database(WCD),DQXI, SAP ECC
Other Tool
Incident Management/Release management – Infra,
Content Management – Eroom, Documentem

Project – SAP CRM Service Rollout Project

Project
ABB Singapore SAP CRM 5.0 Service Rollout Project
Customer
ABB Singapore (Manufacturing Industry)
Period
June 2007 -  Nov 2008
Role
Roles and Responsibility:
Status meeting with Client and TCS Management.
Issue management preparation and updating to management.
Weekly meeting with Team.
Training and Knowledge transfer to Team.

As a Module Lead , was responsible for
Analyzing of ABB Business unit and Manufacturing Sales process, Customer Service Process, Material Management Process, Controlling Process, Quality Process and local legal statuary Tax information.
Doing Requirement gathering and preparing delta Blue print and getting signoff from Client.
Gathering of SAP Customer service module and Plant Maintenance, Quality Management module, Material Management module, Controlling Module.
Conducing global template Business process workshop for New Zeeland, Indonesia, Pakistan, Vietnam, Australia, Malaysia.
Gathering of the Master data of ABB SG (Customer Master, Product, Sales Order, Service Order, Contract order, Ibase, defect and preparing data migrations strategy.
Gathering of FORM, Report, and Layout of ABB SG.
Testing –Unit Testing, Integration tests, User Acceptance testing.
Creating test case, Test result, and User manual and End user training.
Configuration areas handled:
Creating the Organization Structure.
Tax Configuration.
Forms Requirements:
Service Quotation.
Service Order Acknowledgement.
Service Confirmation Form.
Tax Invoice.

Solution Environment
CRM 5.0 ,SAP ECC
Other Tool
Incident Management- SAP
Release management – Lotus Note
Content Management – Lotus Note

Project – SAP Duet CRM Product Validation

Project
SAP Duet CRM 5.0 with Duet Service Pack 1.0 and 1.2 Product Validation
Customer
SAP Lab India, Bangalore.
Period
Aug 2006 – May 2007
Role
As a Team member, was responsible for

Analyzing of Duet Architecture along with Mendocino server.
Understanding the Requirement document, Design document (Technical/Functional) and Form.
Quality testing –Acceptance test, Integration Test, System Test, Unit Test.
Creating test case, Test script adding to Test Cat log and test plan.
Configuration areas handled:
Creating the Organization Structure, Organization data profile, Organization determination rule.
Creation of Master data (Accounts, Contacts, Activities) along with the relationship with login user and maintaining the relationship with Account and Contact.
Creation of Users, Role management, and assignment to Organization structure.
Creation of Transaction type, Status Profile, Subject Profile.
Configured Partner Determination.
Creating the Organization Structure.
Tax Configuration.

Solution Environment
CRM 5.0 ,SAP ECC, QTP
Other Tool
Incident Management- SAP


Project – SAP CRM Sales Production Support

Project
SAP CRM 4.0 Production Project.
Customer
Philips Semiconductor. (Hi-tech Industry)
Period
Nov 2005 – July 2006
Role
As a Team member, was responsible for
Analyzing of Philips Sales Process.
Gathering of Philips Product and Customer and Service sales information.
Analyzing of Sales Channel information to received the order.
Production Support-Providing Transactional level support to Philips user.
Monitoring Middleware.
Generations of Alert in CRM using Activity Management to proactively inform to User.
Downloading the Customizing Object and Business Object.
Resolving the BDoc Error.
Customized set up for the Data transfer from R/3 to CRM.
CRM Base Customization (Organizational Unit Management).
Tax Configuration and handled dummy the Country Issue.
Solution Environment
CRM 4.0 ,SAP ECC

Project – SAP SD and VBA Application Support
Project
SAP SD and VBA Application Support
Customer
SAP AG, Germany
Period
Aug 2005 – Oct 2005
Description
SAP AG, The Software Vendor of SAP ERP.   
Role
As a Team member, was responsible for
Analyzing of SAP AG all product information
Gathering of all Product pricing, Tax and Sales information.
Gathering on Product bundling and discount information.
Analyzing of VBA Price Tool information.
Uploading information to SAP.
Reporting information.

Solution Environment
Microsoft Excel Too, SAP R/3 4.6,BI
Other Tool
Incident Management- SAP

Project – SAP SD Production Support

Project
SAP SD 4.6C Production Support Project.
Customer
DELPHI AUTOMOTIVE (Manufacturing Industry)
Period
May 2005 – July 2005
Description
Delphi Automotive is Automobile Component Manufacturing Company, having offices world wide. It has a huge clientele base of over 40,000 corporate customers all across the globe.   
Role
As a Team member, was responsible for
Analyzing of Delphi Sales process.
Gathering of Delphi Product, Customer information.
Gathering of Sales channel and Partner Sales information.
Worked on Scheduling Agreement, Mobile Data Entry, and Labels Management.
Creating Requirement doc, Functional Specification and test cases.
Analyzing the customize report and functional module and fixing the bugs.
Troubleshooting the IDOC related issue, and testing them.
Inbound and outbound Idoc monitoring.

Solution Environment
SAP R/3 4.6
Other Tool
Incident Management/Release management – Infra
Content Management - Share point

Project – Java, Oracle8i Development Project

Project
Human Resource Management System (HRMS)
Customer
Internal Project
Employer
IES Consulting-India ,Bangalore
Period
March 2004 – May 2005
Description
The Infinite Enterprise Software Consulting firm is Bangalore based which involved in devolving Application software and enterprise resource Planning.
Role
As a Team member, was responsible for
Business Requirements:
Gathering requirement of Company HR policy, Employee work schedule, number of project allocation and project progress and Employee skill information.
Collecting employee attendance info.
Leave information and approval of leave.
Employee’s promotion and appraisal feature.
Project content information.
Employees pay roll information.

Technical Requirements:
Designed of screen layout field information on HTML.
Designed database on Oracle 8i.
Developed front-end on Java script.
Developed application on Tomcat server.
Developed Reporting information.
Quality tests – Unit Testing and Integrated Testing and deployment.

Solution Environment
Window 2000 Server, Oracle 8i,Tomcat,Java server

Project – Visual Basic, Oracle8i Development Project

Project
School Management System (SMS)
Customer
Internal Project
Employer
IES Consulting-India ,Bangalore
Period
July 2003 – Feb 2004
Description
The Infinite Enterprise Software Consulting firm is Bangalore based which involved in devolving Application software and enterprise resource Planning.
Role
As a Team member, was responsible for
Business Requirements:
Gathering requirement of School selection criteria of Admission.
Marks criteria.
Number of seat, examination.
Student academic information.
Employee (Teacher/Principle) information.
Employee attendance information.
Employee (Subject mater expert) information.
School holidays information.
School event and fair, sports information, test result announcement information.
Class schedule information.
School policy information.
Student attendance information

Technical Requirements:
Designed field information on VB editor.
Designed database on Oracle 8i.
Developed and coding front-end on Visual basic.
Developed Reporting information.
Quality tests – Unit Testing and Integration Testing and deployment.
Solution Environment
Window 2000 Server, Visual basic ,Oracle 8i,
Other Training Attended
Oracle DBA 9i
Oracle Application developer
Sun Advance Java (EJB), Servlet
Java Server page
Dream weaver
Sun Solaris Administration
ABAP
SAP Sales and distribution
Testing
Certification Completed
Oracle DBA 9i.





Marketing Experience
Company
IGlobal Software, HAL Bangalore.
Period
July 1999 – June 2000
Designation
Customer Relationship Executive
Role
As a Team member, was responsible for
Responsible for building Customer relationship.
Gathering of Company Sales channels.
Analyzing of Product and Service information.
Customer Survey.
Giving value addition to customer.
Papering of Customer Satisfaction Index, Data validation report, Request response time report, Request allocation report.


Business Experience
Shop
Homeopathic Retail shop, Azamgarh.
Period
July 1994 - June 1996
Activity
Established Homeopathic Retail shop and full fill local customer requirements.
Understanding of local customer requirements and end customer requirements.
Managing resource.
Visiting the customer to collect the order and shipping the product.
Preparing the Open order, open shipment and open billing report.
Following with customer for account receivable.


SAP Training       
Year
Title
Location
Organised by
2005
CRM ( CR-100) Base Customization
Bangalore
Sap Lab India
2005
CRM ( CR-300) Sales
Bangalore
Sap Lab India
2006
CRM ( CR-800) E-Commerce
Bangalore
Siemens India Chennai
2006
CRM ( CR-500) Middleware
Bangalore
Sap India Education Centre
TCS Internal Training Attended
Year
Title
Location
Organised by
2006
ITIL  V3
Mumbai
       TCS
2006
PMP
Mumbai
       TCS
2006
6 Sigma Green Belt Training
Bangalore
       TCS
2006
BIW ( Extraction ,Modelling ,Reporting )
Bangalore
       TCS

Technical Skills  
Languages
ABAP/4, C, C++, Java, SQL, PL/SQL, VB, Oracle Developer.
ABAP/4 Skills
Report, BDC, Sap Script, LSMW.
Databases
MS-Access, Oracle DBA 9i, SAP BW.
Web Technologies
HTML, Java Script
Operating Systems
Windows NT, UNIX, DOS, Sun Solaris, Linux.

Certification Details       
SAP CRM E-Commerce 4.0
SAP E-Commerce (Sales, Service, Marketing) Certified Solution Consultant.
Certificate id:0004126281
Oracle 9i
DBA 9i (Certified) Data Base Administrator.

Personal Details
Date of Birth
Sep 01 1976
Place of Birth
Azamgarh ,India
Nationality
Indian
Linked In ID
http://in.linkedin.com/in/praveenasthana
Skype ID
xxxxxxx.asthana


Visa Details
US Visa
H1 Visa (I-797C:Rec.No: WAC-09-147-52154 : www.ust.net)

Passport Details
Name as on passport
Relationship
Passport Number
Date of Issue
Expiry Date
Place of Issue
XXXXXXX XXXXXXX KUMAR
SELF
E8345465
05/04/2004
04/04/2014

LUCKNOW