SAP BO consultant

Prashanth Kumar Thumrugot

Mobile: 009**-*********

Email: *********.**@*****.***

Objective

Having 4.8 years of experience in data warehousing. Worked extensively on all areas of Full Life Cycle Development, Maintenance of Business Objects Modules

Experience in designing and developing the Universe and updating the existing Universes, developing canned/adhoc reports, scheduling the processes and administering the BO activities using Business Objects XIR3/XIR2

Expertise in creating, organizing, publishing and scheduling reports using Central Management Console

Migration of Business Objects XI R2 to Business Objects XIR3 Enterprise

Conversion Desktop Reports to WEBI reports using Conversion tool

Extensive Knowledge on Crystal Reports with Standard, Summary, Cross Tabs, SQL, grouping, sub reports etc

Experience in Developing Crystal Xcelsius Reports (Query as a web service, live office).

Experience in building Dashboards and insightful analytics using EPM and Crystal Xcelsius

Worked in creating the business objects WEBI reports using SAP BW Query

Analytical and Technical aptitude with the ability to solve complex problems;Can work very well in a team as well as independently under minimum supervision

Technical Skill set

Business Intelligence : Business Objects XI R3 /R2, Central Management Console, Central Configuration Manager, Webi / Deski, Designer, Crystal Reports Server XI, Crystal Xcelsius 2008, Import Wizard

DB Technologies : Oracle9i

Query Languages : Sql

Operating System : Windows 2003/XP/7/8

Career profile

Worked as a SAP BO Consultant in Valiant labs Pvt. Ltd, Hyderabad from 01/12/2011 to 31/08/2013

Worked as SAP BO consultant with Al Faisaliah Group, the Client of Prime Gate Company, Riyadh, Saudi Arabia from 23/09/2014 TO PRESENT.

Educational Qualification

B.Tech (Bachelor Degree in Electronics and Communications)

JBIET COLLEGE OF ENGINEERING (JNTU University, Hyderabad, India)

Project Summary

Project #4

Assurant Insurance

Client : Asssurant Health insurance

Role : Sap BO Consultant

Team Size : 6

Duration : May 2013 to August 2013

Environment : Business Objects XI R3, SAP BI7.0, Web Intelligence, Crystal Reports2008, Xcelsius2008, Live Office2007, QAAWS, win2003

Description:

A multi-line business and personal insurance agency Assurant is the 7th largest U.S. commercial insurer and the 13th largest U.S. property & casualty insurer. Assurant provide insurance protection to more than 1 million businesses and professionals in the U.S. and internationally. Assurant products and services are sold by highly professional independent agents and brokers. Headquartered in Chicago, Assurant has offices throughout the U.S., Canada and Europe. Assurant stands for its focus on customers, values and financial strength.

Project #3

RBP

Client : Brand Mart

Role : Sap BO Developer

Team Size : 8

Duration : January 2013 – May 2013

Environment : Business Objects XI R3, SAP BI7.0, Web Intelligence, Crystal Reports2008, Xcelsius2008, Live Office2007, QAAWS, win2003

Description:

This project was mainly developed for Retail Sales Analysis. The client required sales analysis country wise, zone wise, branch wise, product wise, customer wise, bill wise etc. The client gathers the transactional data from different channels like Super Markets, Furniture Showrooms, and Kids wear mart, Garment Stores etc.

Responsibilities:

Created Universes from SAP BW/BI for Ad-hoc users and trained users and explained the different functionalities of business objects and crystal reports and how to use Ad-hoc reporting

Created Dashboards for Top management using Crystal Xcelsius 4.5/2008 using Live Office and QAAWS

Integrated SAP Business Objects Enterprise content into SAP Net weaver portal

Importing the SAP Business Objects IVIEW templates

Created Web Intelligence Documents and Crystal Reports iviews associated with roles and managed portal security

Configured Single Sign on between SAP Net weaver portal, Sap Netweaver Business Warehouse System and SAP business objects Enterprise

Setting up the configurations for publishing process for the Crystal Reports

Created Crystal Reports using SAP Netweaver business warehouse system and SAP ERP systems

Trained the end users in working with the Business Objects user module and provided technical expertise

PROJECT # 2:

Production and Sales

Client : Kroger

Role : Report Developer

Team Size : 7

Duration : June 2012 to October 2012

Environment : Business Objects XIR3, Web Intelligence, Crystal Reports, Xcelsius, Windows Live Office, QaaWS

Description:

This project is developed for Kroger Co. (US), which is one of the organization that sells various numbers of products. Kroger have various stores, which maintains Database has lots of historical data. This project was to create sales Data warehouse and generate reports using Business Objects. The aim of sales data warehouse is to analyze sales of major brands varying with different promotional schemes

The system has a database which stores information about sales, profits and contracts of customers. Using this existing database, the system should analyze the sales and profit and generates reports for Sales and profits in month wise and year wise. The resulting model gives us an idea about growth in profit, prediction about increase in sales

Responsibilities:

Installed & configured SAP Integration Kit with Business objects, integrated crystal with SAP BW and build reports based from BW Cubes, Info sets, R/3 tables

Created Universes from SAP BW/BI for Ad-hoc users and trained users and explained the different functionalities of business objects and crystal reports and how to use Ad-hoc reporting

Created Dashboards for Top management using Crystal Xcelsius 4.5/2008 using Live Office and QaaWS

Integrated SAP Business Objects Enterprise content into SAP Net weaver portal

Importing the SAP Business Objects IVIEW templates

Created Web Intelligence Documents and Crystal Reports iviews associated with roles and managed portal security

Configured Single Sign on between SAP Net weaver portal, Sap Netweaver Business Warehouse System and SAP business objects Enterprise

Setting up the configurations for publishing process for the Crystal Reports

Created Crystal Reports using SAP Netweaver business warehouse system and SAP ERP systems

Trained the end users in working with the Business Objects user module and provided technical expertise

PROJECT# 1

Customer Supply Data warehouse

Client : MYER, Australia

Role : Business Objects developer

Team Size : 5

Duration : Jan 2012 – May 2012

Environment : Business Objects XIR3, Web Intelligence, Crystal Reports, Xcelsius, Windows Live Office, Qaaws.

Project Description:

Myer is retail chain in Australia With 60 stores nationally, to meet their customer needs they decided to build a Data Warehouse to analyze Key factors like the total sales revenue on the monthly and quarterly basis on the region and seasonal wise the sales amount and the decision support system is focused on analyzing the entire business process. In order to provide the critical information like daily revenue, total sales, goals, and new plans, the company developed business intelligence system suite of products. Reports are generated for top management using Hyperion essbase.

Responsibilities:

Installed Business Objects XIR2 version, Migrated Business Objects universes, reports from 6.5 to XIR2 version, enabled Audit functionality in BO

Migrated Business Objects XI R2 content in to Business Objects XI R3 environment using the Import Wizard

Created the User Groups and Users, Set up the privileges to them according to their requirement

Creating users and groups assigning the access levels.

Creating folders and Categories

Designed Business Objects Universes. Used Contexts and Alias to resolve the Loops

Extensively Created Derived Tables in the Universe

Developed reports using various functions, operators, Calculation Contexts, report filters and variables

Restricted the data using the Prompts and filters

Interacted with the Business analyst and the Manager in gather the business requirements to design and develop reports

Involved in Installation, Configuration and Deployment of Business Objects Suite

Involved in designing and building of Universes, Classes and Objects by resolving complex loops by defining contexts and aliases

Created canned and Ad-hoc reports using WebI/Deski Reports

Expertise in creating reports using the Business Objects functionalities like Prompts, Slice and Dice, Open document (Linking Reports), Drill Filters and Aleter

Fine-tune the existing universes to enhance their performance

Converted existing Crystal reports to Business Objects and Web enabled them.

CLIENT : ALFAISALIAH GROUP, RIYADH (SONY, FMS, ALSAFI FOODS,DANONE)

ROLE : BO CONSULTANT

TEAM SIZE : SIX

DURATION : Sept 2013 to PRESENT.

Responsibilities:

Creating the business objects WEBI reports using SAP BW Query.

Created the User Groups and Users, Set up the privileges to them according to their requirement

Creating users and groups assigning the access levels.

Creating folders and Categories

Designed Business Objects Universes. Used Contexts and Alias to resolve the Loops

Extensively Created Derived Tables in the Universe

Developed reports using various functions, operators, Calculation Contexts, report filters and variables

Restricted the data using the Prompts and filters

Interacted with the Business analyst and the Manager in gather the business requirements to design and develop reports

Involved in Installation, Configuration and Deployment of Business Objects Suite

Involved in designing and building of Universes, Classes and Objects by resolving complex loops by defining contexts and aliases

Personal Details:

Name : Prashanth Kumar

Father’s Name : Venugopal Rao

Marital Status : Single

Iqama Status : Transferrable

Iqama Profession : Computer Engineer

Driving License : Obtained Saudi’s valid driving license

Permanent Address : 9-133 badangpet, Hyderabad, India

Hobbies : Reading Books and Sports

Contact this candidate