Praveen Asthana
SAP CRM Functional Consultant
Email-id: praveenasthanasapcrm@gmail.com
Phone: +919004131229 ,+919379073919(India), 408-372-2298(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-ADBOE 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 Nederland, SD and VBA tool L2 support- SAP AG Walldorf, SD L1 and L2 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
MCA (Aug 2000- June 2003) Mysore University with 70% Computer Application, Oracle, ERP.
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 – SAP SD Production Support
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
Place of Birth Azamgarh ,India
Nationality Indian
Linked In ID http://in.linkedin.com/in/praveenasthana
Skype ID praveen.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
ASTHANA PRAVEEN KUMAR SELF E8345465 05/04/2004 04/04/2014
LUCKNOW