Rajeev Ranjan

Contact (M) +966-*********

Email: - ptl3en@r.postjobfree.com

Solution Architect, Lead BI Consultant, SAP BI, SAP CRM

Experience Summary

• Solution Architecture, Project Manager & Lead Consultant with 11 years of comprehensive experience in SAP BI and SAP CRM. Responsible for SAP BI Project Design & Delivery.

• Excellent experience as an Architect for SAP BI, SAP BO and SAP CRM solutions, Deep technical strength with excellent knowledge of SAP products.

• Extensive experience in business development, pre-sales and planning of SAP BI and SAP CRM Programs.

• Build offshore Team and executed Onsite-Offshore Model, Responsible for offshore Team engagements and delivery.

• Proven excellence in leadership, customer engagement, project management, team building, and analytical skills.

Academic Credentials

Post Graduate Course in Computer Application

CMC Ltd Hyderabad 1999

Bachelor of Engineering (Civil)

Bhagalpur College of Engineering, Bhagalpur, 1998

12th (I Sc. BIEC)

Gossner College Ranchi, 1994

10th CBSE

D.A.V. Public School, Ranchi 1992

Key Skill Set

- SAP Project Management

- SAP BI Architecture & Design

- SAP CRM Architecture & Design

- Consulting & Research

- Product Development

- Business Development

- Project Estimation & RFP preparation

Technical Skill

SAP BI:-

1. SAP BI

2. SAP BW BPS, BI Integrated Planning

3. Reporting Agent, Broadcasting, Process Chains

4. Extraction, Transformation, Loading

5. SEM BCS, SAP FICO

6. SAP ABAP

SAP CRM:-

1. CRM Analytics

2. CRM Enterprise (Sales and Marketing)

3. CRM Field Sales Applications

4. CRM Middleware & and client Tools

5. CRM Interaction Center

6. SAP Mobile Application Studio

Other Areas of SAP

1. Exposure to SAP WebDynpro Developer Studio

2. Worked on ABAP workbench

3. Good understanding of SAP Repository Objects, DDICs, BDocs

4. SAP Mobile Application Repository

5. SAP MDM, SAP MM

Technical Training Attended

• SAP BW ( BW305, BW310, BW330, BW340, BW350, BW370, BW380 )

• SAP CRM ( CR010, CR310, CR320, CR500, CR205,CR400, CR600, CR900 )

• SAP ABAP ( BC400, BC402, BC410)

• SAP Business Objects ( Universe, Xcelsius, Web Intelligence, Crystal Reports)

Management Training

• Basic Project Management ( Saudi Aramco In house PMP Training)

• QMS ( Quality Management System Training)

• PM Distilled Project Management Preparation Workshop

• Microsoft Project Management.

Key Employment Scan

1. EJADA Systems Company Ltd.

Client – Saudi Aramco, Dhahran, Saudi Arabia

Duration: - Jan. 2009 to till date.

2. Philips IT Applications

Philips Innovation Campus, Bangalore

Duration: - May 2007 to Nov 2008

3. SAP Labs India Pvt. Ltd

Whitefield, Bangalore - 66

Duration: - April 2001 to April 2007

4. Tata Consultancy Services

Pune, Maharastra

Duration: - October 1999 - March 2001

Onsite Exposures: -

Client - Saudi Aramco

2009 (Jan 2009- Till Date) – Dhahran, Saudi Arabia

Client - Royal Philips Electronic

2008 (March & April) – Eindhoven, Netherlands

Client – ARIBA for Philips Corporate Purchase

2007 (Sep – Nov) – Eindhoven, Netherlands

Client – Philips Corporate Purchase

2007 (June & July) – Eindhoven, Netherlands

Client – Siemens AG, Munich through SAP AG

2007 (Jan & Feb) – Walldorf, Germany

Client – For SAP AG

2006 ( Oct – Nov) – Rot, Germany

Client – Holcim Thailand through SAP Labs India

2006 (April), Bangkok, Thailand

Client - Hilti AG

2005 – (Oct & Nov) Rot, Germany

Client – Deloitte & Touche through SAP America

2004 – (July & Aug) Nashville, United States

Client – For SAP AG

2002 (March – May), Walldorf, Germany

Client – For SAP AG

2001 ( July – Sep)– Walldorf, Germany

Experience Detail

Project Manager, Lead BI Consultant (SAP BI & BusinessObject)

Client - Saudi Aramco (Dhahran, Saudi Arabia)

Jan ’2009 – Till Date

Role:- Lead BI Consultant, Project Management, Solution Design & Architecture

• Project Planning and Execution, Requirement gathering, scope study, Business Blueprinting, Project effort and cost Estimation, Application Architecture and Design.

• System Landscape Strategy, Authorization Strategy, Transport Strategy

• High-Level Design (HLD), High Level End-User Training Plan & Test Plan & Strategy

• Status update and Presentation to Management, proponents and SMEs.

Project Experience

• Involved in implementation of SAP BI solution for SAP Healthcare. In Saudi Aramco, industry solution SAP IS-H is installed and there is a requirement to implement SAP BI over it, to address Patient and Bed Management, Hospital Management, Clinical Services, Finance, Material Management & Pharmacy. The project is using standard BI contents delivered by SAP along with need to provide various customizations. The project is using modules like HR, FI and MM of stand ECC 6.0 along with Healthcare Industry Vertical.

• The Clinical Services modules deals with scenarios like Care Doc, Nursing Activities, Orders & Results, Surgery, Radiology, Epidemiology etc. The Pharmacy modules deals with Drug master, Prescriptions etc

• Other scenarios which were part of this project was Medical Designated Facilities system. This system deals with specific Billing, Summarization, Remote Clinical Processing and integration with SAP Core Modules.

• Involved in development of Healthcare Dashboard for SAMSO (HCBI – Healthcare Business Intelligence). The Dashboard is designed with Flex as Framework and BI reports assembled in Web Templates and linked to Dashboard Framework. The KPIs visualization were done using Business Object Xcelsius and integrated with the Dashboard.

Solution Architect, Offshore Delivery (SAP BI & Data Warehousing)

Philips IT Applications

Philips Electronics India Ltd.

May’2007 – Nov 2008.

Role

• Manage Delivery (Projects, Changes & Support) and ensure Team growth in SAP BI domain. Management of all SAP BI related services, introduction of New Solutions and mining for new opportunities.

• Provide Consulting to internal customers (Philips Electronics and Philips Domestic Appliances now called as Philips Lifestyle, Philips Lighting, Philips Corporate Functions and Philips Corporate Technology) and help them set up offshore development centers for SAP BI development. It includes showcasing BI capability, understanding Customer Need, defining engagement roadmap, team structure and governance model for offshore delivery of BI work.

• Providing technical leadership to the team, primarily on SAP BI. Guide the team in all aspects of SAP BI Modeling, Design, Architecture and best practices

• People management and operational planning for all Offshore Team. This involves managing Recruitment, Training, Resource Management and Competency Development for a team size of 15.

• Involved in selling Onsite-Offshore Model. Presented to senior management the various engagements of the BI Team, highlighting offshore Team experiences, exposures, capabilities and achievements.

Key Achievements

• Successfully delivered many Offshore BI projects assignments. Build new account of SAP BI support Team for Philips Domestic Appliances.

• Successfully managed the Transition of vendor TCS with vendor Capgemini as per new contract signed by the organization.

Project Experiences

• BW SMART (Supply Management and Reporting Tool) Application realignment for upgrade of SAP SRM source system from version 2.0 to 6.0. The source system upgrade result in many old data sources either useless or insufficient with respect to necessary data required for the various reports. The various EBP reports, shopping cart query reports etc were not displaying proper data. To address this issue we identified the new datasources available and modified the extraction model by replicating from new datasources, designing corresponding transfer structures and Communication structures for data load to various existing data targets.

• BW SMART application realignment to address R/3 source systems merger. Philips Electronics underwent a merger of its three R/3 sources system. The r/3 system for EMEA Region, North America Region and Asia Pacific Region were merged and because of this we have to do the necessary alignment in BW side for Purchase orders and Account Payable Datasources. This task involves getting data from datasources which is the valid source system after the merger as well as cleaning of redundant datasources referring to old source systems. Also address the long time pending requirement of aligning the data model as per CLIA architecture from two layered architecture namely Acquisition Layer and Reporting Layer to four layered architecture namely Data Acquisition Layer, Data Transformation Layer, Data Container Layer and Data Reporting Layer.

• In Philips, Account Payable data is having huge value under Not Assigned section. This result in reporting having no meaningful information. To address this there was a plan to enrich the vendor information so that Account Payable should have proper Vendor Info.To enrich the data various data enrichment Tools were evaluated with respect to its enrichment capability as well as its ability to integrate with SAP BI Tools. For this third party softwares like ARIBA and Zycus were evaluated. Evaluation were made with respect to these software with the offerings from SAP MDM. Project blueprint was defined with respect to the integration with SAP BI SMART application.

• XI Charging Analytic application using SAP BI. This project was designed to charge the various Team based on there usages of XI Interfaces. Based on volume of messages, size of messages and total quantity of messages, the XI interface being used were charged. The tricky part was to determine the Rate Card Tariff. The Tariff was not fixed but vary based on volume and period. These Tariffs were maintained in SAP XI system and downloaded to SAP BI. The source system for this project was SAP XI. The message size and message volume were aggregated based on Interface Id and 0CALMONTH. Using lookup tables and dynamic price determination the price to be charged were determined. The project involves extensive ABAP coding in various Start Routines.

• BI Analytic based on Peregrine System Data. Peregrine is a ServiceCenter Tool used for Service Level Management. The tool effectively measures service level performance against SLA commitments. Here the Peregrine Data is uploaded to BW System in the designed model using Flat Files data extraction mechanism and various reports were designed as per the business need.

• Involved in Technical Upgrade Project for BI system having BI Application called Peregrine reporting from version 3.0 to 7.0.

• CLIA BCS for Philips Corporate Functions. The project is about BI based financial Consolidation. The consolidation is based on Common layer Integration Architecture (CLIA) followed in Philips. There are two type of consolidations addressed in this project namely Group Consolidation and Country Consolidation. In Group Consolidation the consolidation is done as per Product Groups where as in country consolidation, it is done as per country. The project is designed to replace the old accounting consolidation principles based on COMAR. The BW BCS system receives data from all product divisions. The consolidated data is then used for reporting such as Annual, Quarterly and half yearly Reports.

Lead Consultant (BI & DWH) IMS Netweaver

SAP Labs India

Oct’01 2005 – 30th April ’2007

Role

• Development Lead for SAP BI OLAP Team, responsible for SAP BI offshore engagement & Delivery.

• The Team was responsible for Ticket handling, proposing solutions, fixing issues etc raised by customers through SAP OSS in the area of SAP BI like Reporting, OLAP, Aggregates, and Modeling & Extraction.

• Actively involved in product enhancements and custom development for strategic customers in SAP BI area. Released many SAP Notes for bugs fixed in standard SAP Product.

• Involved in customer Specific development projects for customer Siemens AG (2007).

• Involved in BI development for CRM Analytic applications.

• Took training on SAP BI modules like BI Authorization, BI Aggregates and OLAP.

Key Achievements

• Received training on OLAP Modules of SAP BI from Chief Architect of SAP BI. Build robust knowledge with various OLAP function modules and programs and have ability to debug a Query and report during Query Execution.

• Received training on SAP BPS and BI Integrated Planning from the Architects in SAP AG.

• Delivered SAP BI Trainings to Team as well as externals.

• Initiated and Developed Support Guide for SAP BI to be used by expert consultants and SAP internal developers.

• Propose various fixes to the product bugs and malfunctioning in SAP OLAP modules and released SAP Notes for the fixes as proposed solutions to customers.

Project Experiences

• Maintainability Toolset. This is a BI project which deals with system performance and provides systems load statistic to service managers. In SAP Labs there were many BW systems and their performance, availability for reporting, hardware and memory consumption etc were monitored and it is the responsibility for service managers to make sure that systems are available all the time. To address this there were various reports designed and based on data available through technical Content. The project basically enhances the standard model by adding more meaning to these reports through additional attributes application groups. There were also reports based data available as flat file generated by TIBCO based on Control-M file which triggers the jobs on these BW systems.

• BW Reports based on Clarity system. Clarity system is Budgeting software used for tracking the resource engagements, project for which they book the times. The various reports designed were for Groups like Resource Managers, Project Managers, Service Managers, Finance Controller, Support Team Leads etc. The reports provide details about the resources, Teams, Projects hours booked etc. Also involved in designing authorization for this application.

• BW Reports based on CR System data. CR System is a Tool which is used to manage the change request in the standard applications across the organization. The Tool is having two parts. The Demand module is installed on customer and they raise a CR (change Request) which then appear as BRs (Business Request) to supplier. Based on necessary evaluation of the requirement the request is split up into PRs (Program Request) and SRs (Service request). In Philips based on these Application Change management data are defined various reports. The reports provide detail status to Project managers, Program managers, Business Line Manager about the various CR and there statuses like open, In process, Time booked, resource assigned, effort estimated for the CR etc.

Development Lead (SAP CRM Mobile)

SAP Labs India

July’2004 –Sep ’2005

Role

• Responsible for development of SAP CRM Mobile Sales Data Integration Layer.

• Provide technical leadership to the team, prepare architecture and design for the various new features in CRM Mobile Application as well as in Custom development projects.

• Involved in the migration of SAP CRM Mobile Sales 5.0 to new framework and Architecture. Involved in the Migration of Modules like Export-Import, Reports, Charts, BW Reports, Authentication, Authorization, Inbox etc

• Manage multiple concurrent CRM projects, ensure delivery quality and customer satisfaction.

• Involved in the Project specification, Design and development of CRM Field Sales Solution with Integration to Field Sales Companion Solution for Client HILTI AG Switzerland.

• Involved in the product customization and CRM Middleware go-live activities for client Deloitte and Touche, US (2004). Involved in the product Rollout phase which involves various Go Live activities and software distribution. Handle critical issues with respect to CRM Sites, Publication, Subscriptions and Replication and Realignment.

Key Achievements

• Received appreciations from customer HILTI for project proposals, suggestions for the change in the standard SAP product, design and on time delivery.

• Received appreciations from customer Deloitte and Touché, for the go live activities performed in tight schedules.

• Part of the Team who filed two Patents for the development of deployment Tool used for CRM Mobile Application deployment on client system without user interference. The Tool named CSDM (Central Software Deployment Manager) can deploy any software on client system and monitor the status on the server. The tool is having ability to deploy multiple clients in one go.

Sr. Consultant - SAP CRM Mobile Sales

SAP Labs India

April’ 2002 –Jun’ 2004

Role

• Involved in development of SAP CRM Middleware Tool call INBOX which tracks Rejection, Notifications, Pending Confirmations data during data synchronization between CRM Enterprise and CRM Mobile using CRM Middleware Tool called Contrans.

• Involved in the development and integration of Groupware applications like Microsoft outlook and Lotus Notes with SAP CRM Mobile Sales. The feature is used to provide email access from within CRM Application.

• Involved in the development of CRM Mobile Sales common functionalities like Notes, Attachments, Reports, Charts etc for scenarios like Opportunity Management, products, Sales Transactions, Business Partners in SAP CRM Mobile Sales applications.

• Also involved in the development of many functionalities which are part SAP CRM Mobile System Maintenance. The application is used for various type of Configurations.

• Involved in scenario validation, functionality check, Module Integration for scenarios like Listing and PPR (Partner Product Range).

• Involved in enhancement of MAS (Mobile Application Studio) by adding features like BDoc Explorer.

• Involved in integration of BW Reports designed and developed in SAP BW to SAP CRM Mobile applications like Sales, Service etc.

• Involved in the CRM Field Sales Implementation for client Interbrew (2003). Part of the Team which is responsible for BW reports download from BW system to CRM Mobile laptop and displaying the same in Field Sales Application.

Consultant - SAP CRM Mobile Sales

SAP Labs India

April’02 2001 – 30th Mar’2002

Role

• Involved in Development of Security and Authorization Tool (SAP AMT) using SAP Mobile Application Studio.

• Involved in development of Access Control Manager (ACM, Security Framework Module which takes care of Authorization during runtime). The Module is part of Business Object Layer Framework.

Product Description

In CRM Mobile scenario SAP provides a flexible and extensible role based authorization system to fit the customer requirements regarding authorization. The Mobile Authorization System follows the framework driven development approach of SAP in the CRM Mobile scenario and is therefore delivered as an integrated framework component which can be activated if required. After activation you can choose between various levels of authorization where you are free to define the protected or sensitive objects in the system.

Consultant – SAP CRM

Tata Consultancy Services, Pune

Oct’1999 – Mar’2001

Role

• Involved in development and implementation of SAP ERP for Logistic called CEMPAC & Factor-e for client ACC Ltd and Lafarge. The software has flexibility to customize for other manufacturing Industry.

• Developed Security and Authorization Modules, Configuration Modules, User Maintenance Modules.

• Involved in development of functional Modules like Purchase Requisition, Purchase Order, Goods Receipts, and Order Item, Sales Transactions etc.

General Information

Name Rajeev Ranjan

Father's Name Mr. R. N. Singh

Date of Birth 15th July 1977

Sex Male

Martial Status Married

Nationality Indian

Languages known English & Hindi

Contact Details +966-********* (KSA)

+91-988******* (India)

+91-988******* (India)

Current address #8, Seaview Compound

Al-Khobar, 31952

Saudi Arabia

Permanent Address #7, SJR Eternity, Phase 1

Kodigehalli Road, Hoody

Opp. Krystal Citrine

Mahadevpura Post

Bangalore - 48

I hereby declare that the credentials furnished above are true to the best of my knowledge and belief.

RAJEEV RANJAN

Contact this candidate