N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

SUM MARY:

Total Around 3 Years of I T Experience which includes SAP BO, Business

Objects Data I ntegrator & Data services Experience along with SAP BODS

3.2,4.0,SAP BO 3.2.SAP BI.

Self starter with good understanding and goal oriented approach to Problem

Solving issues and extremely detail Oriented.

Excellent Analytical Skills, Oral, Communication skills, Interpersonal skills and

documentation skills.

An enthusiastic and project-oriented team player with solid Communication and

leadership skills and the ability to develop creative solutions for challenging client

needs.

Good experience in Install & configured SAP Integration K i t w ith Business

objects, i ntegrated c rystal with SAP BW and build reports based from BW Cubes,

I nfo sets, R/3 tables.

experience on SAP BO Administrator CMC,SAP BODS Admin Creating

Repository,Access Server,job server.

created Info Objects and Info Providers with Data Flow,Extraction from R/3,and

Monitoring Process chain generate reports.

Created Objects and prepared Reports like financial reports, HR reports, standard

and ad- hoc reports, and universes.

Created Views to extract data from data sources.

Defined crystal reports and Webi reports and published to corporate documents and

v iewed by info view.

Created Universes from SAP BW Data (Cubes) .

Creating Universe from SAP and NON SAP Database.

Experience in SAP/BI data modeling, data staging and data extraction expertise

Prepared many other reports by using master details, in Webi Reports SAP BO

4.0 C ross-Tabs, Slice and Dice and Drill mode as per the requirement of the end-

user .

N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

Creating reports on " Deski " "in SAP BO " Desktop In telligence "", "Webi", Web

I n telligence,Crystall.

Designed Calendar, Metrics, analytics & Dashboard reports (IMT, Speedometers,

Pareto Charts, Alerter, t raffic lights etc,), and using Performance Manager.

Generated the Business Objects reports involving complex queries, sub queries,

U nions and Intersection.

Converted Desktop Intelligence Reports to Web In telligence using Report

Conversion Tool.

Experience in Tuning E TL Jobs and C DC using Timestamp, and also set up

validation rules.

Customized the Rapid Mar ts (SAP Sales and Oracles Sales) using Python Script

and created multiple configurations for the given data source.

Prepared ETL f lows, data cleansing, parsing, matching, and auditing.

Extensively worked with Repository manager, Job server, Admin console,

Metadata Integrator in generating ETL Project, Business Intelligence, Data quality

w ith Heterogeneous data sources including XML,R3, BI with Full load and

I ncremental load capabilities in a Batch or Real time data f low.

Experience with cleansing and profiling data in Data Services and experience

t roubleshooting issues with data type mismatches and formatting.

EXPOSURE ON SAP BO BI UDT,IDT,WEBI Creating Report.

Experience with BI/Portal and Web Reporting, Open Hub and other SAP business

intelligence solutions.

Trouble shooting on BI - BO connectivity Data Source and Target .

Extracting the data from f lat files which are dynamic in structure using BODS.

Abili ty to create Workflows using object library and tool palette to execute data

f lows.

Education:

Bachelors Degree in Information technology ( B.Tech) from JNTU,Hyderabad

I ND IA.

N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

Technical Skills:

SAP BODS 3.2,4.0. SAP BO Data services/Data In tegrator,

OLAP Tools

Data Quality,

O peration System Windows Server 2008

Databases Oracle 10g/9i/8i, SQL SERVER 2008.

Professional Experience : A3 Soft Tech pvt ltd,Bangalore.

P roject Description :

Forest has well-established franchises in the therapeutic areas of the central nervous and

cardiovascular systems. Forest identifies, develops, and delivers pharmaceutical products

t hat address a range of health conditions.

Client :FOREST LAB,

Period:Feb12-Till Date

P roject: F OREST LABORATORIES,INC,NEW YORK.

Solution Environment : SAP BO 3.2,Deski,Webi.

E nvironment: B usiness Objects Enterprise XI R3, Web In telligence, Info View, Desktop

I n telligence, Oracle 10g.

N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

Responsibilities:

• Involved in system analysis and design of the Data warehouse.

• Designed Universes for Financial Billing system and Order processing.

• Created Objects and prepared Reports like financial reports, HR reports, standard

and ad- hoc reports, and universes.

• Created Views to extract data from data sources.

• Defined crystal reports and Webi reports and published to corporate documents and

v iewed by info view.

• Created Universes from SAP BW Data (Cubes) .

• Created many reports according to the investment deals, facility and outstanding to

k now the exact amount of net investment in each deals

• Designed Calendar, Metrics, analytics & Dashboard reports (IMT, Speedometers,

Pareto Charts, Alerter, t raffic lights etc,), and using Performance Manager.

• P repared many other reports by using master details, cross-tabs, slice and dice and

d rill mode as per the requirement of the end-user

• Converted Desktop Intelligence Reports to Web In telligence using Report

Conversion Tool.

• Implemented Security Features of Business Objects like row level, object level and

report level to make the data secure.

• Generated the Business Objects reports involving complex queries, sub queries,

U nions and Intersection.

•

Project Description: I MAPS ( Integrated Motorola Advanced Planning System)

N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

Motorola is a global leader in wireless, automotive and broadband communications.

I MAPS aims at providing demand/supply reports to the customer to view the ONE

V IEW database. I t provides customer the information to view forecast/demand ratio in

Mobile Devices. This project is mainly to make as a single system to manage demand

and supply for different regions. Source is ODP and Data ware house is EDW, main

a im of this project is to deliver reports to users based on which they can take decisions

Regarding Demand and Supply.

Client: Motorola

Period: May 2011

Project: I MAPS (Integrated Motorola Advanced Planning System)

Solution Environment: SAP BODS

Roles & Cont ributions

• Gather and understanding the requirements from the client

and act as a sole functional resource.

• Involved in creating the database model along with the

solution management team.

• Resolved ETL / Database performance issues during pre-

implementation at customer sites, which helped meet the scheduled targets.

• Devised different load strategies for the ETL Ini tial Load

w hich significantly reduced the processing t ime for the staging area.

• Created ETL design and ETL mapping documents.

• Extracting the data from f lat files which are dynamic in

structure using BODS.

• Wrote scripts for creating dynamic tables based on the

structure of the f lat file.

N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

• Created batch scripts for handling dynamic file formats, for

creating dynamic data stores and for importing and exporting the BODS jobs in

.xml format.

• Used various DI t ransformations like Pivot, Reverse pivot,

Table Comparison, Map Operation, etc.

• DQ t ransformations like Address cleansing, ISO count ry

code, Data cleansing, Match, etc.

• Review of Mappings that are developed by the team.

• Used Central Repository to check in and check out of the jobs

to maintain version history and for multi user development.

• Extensively worked on performance tuning of the programs

and processes by using concepts like linked data stores, parallel execution,

recovery mechanism, degree of parallelism (DOP), etc.

• Worked with different sources like Oracle & Flat files.

• Debug the sessions by utilizing the logs of the sessions.

• Designing the ETL process and all Mapping Documents for

Source and Target.

• Development of PL/SQL for loading data warehouse tables.

• Scheduling all Procedures through Data In tegrator(BODI

11.5)

• Unit Testing, In tegrated testing and System testing for all

modules.

• Involved in L ive data testing and Production Support.

• Prepared Design doc, Mapping doc and operational doc.

Project Summary:

Project: D ata Init iative deals with maintaining the Insurance data which is coming from

d ifferent sources. The project involves in developing the ETL mappings using SAP BO

D I/DS to load the data into ES creating universes on top of ES for projecting the Agent

M aster Information. I have worked with SAP BO DI/DS(SQL Server In tegration Services)

to develop the mappings and then worked with BO to create the universes.

N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

Client: National Life Group

Period: Nov 2010

Solution Environment: SAP BODS.

Roles & Cont ributions

• Gather and understanding the requirements from the client

and act as a sole functional resource.

• Configured SAP Data f lows and created SAP R3 Data store,

SAP BW Source data store, SAP BW Target data store.

• Worked as a Solution architect for SAP BO BI/R3 Integration

scenarios in the areas of Cleansing, Abstraction, and Extraction & Generating

B usiness In telligence.

• Designed Business objects semantic layers(Universe, Business

v iew manager & Voyager) with SAP Warehouse and Non SAP warehouse

• Hands on Experience in In tegrating Business objects both

w ith SAPBI & R3 System using Data & Co-files using In tegration kit

• Involved in DQ Process and Data Profiling along with

Performance Tuning

• Involved in creating the database model along with the

solution management team.

• Created ETL design and ETL mapping documents.

• Developed complex batch jobs using BODS.

• Used various DI t ransformations like Pivot, Reverse pivot,

Table Comparison, Map_Opration, etc. and DQ t ransformations like Address

cleansing, ISO country code, Data cleansing, Match, etc.

• Involved in the In tegration Testing and Bug fixing.

• Review of Mappings that are developed by the team.

• Scheduled the ETL Jobs Daily in UAT environment and

generate the error log files.

N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

Project Description: Provident Bank.

Provident bank provides full-service retail and commercial banking operations

regionally and nationally. This project is intended to develop a customer data

warehouse to understand customer behavior to marketing programs and identify

c ritical customers in support of improved decision making across the organizations and

development of reports for the management.

C lient: Provident Bank

Period: Feb 2010

Project: Provident Bank.

Solution Environment: B usiness Objects XIR3, Desktop Intelligence, Designer, and Web

I n telligence, Oracle 10g, Info view, X-Celsius .

Roles & Cont ributions

• Importing Metadata from various sources data ware house systems.

• Created and managed Universes of different sources and linking them in the

Designer.

• In teracted with the Business analyst and the Manager in gathering the business

requirements to design and develop reports.

• Involved in I nstallation, Configuration and Deployment of Business Objects Suite.

N ame: RasooL Software Engineer

SAP BW,BO,SAP BODS.

Mobile: +91-903******* Mail I D:

dsvdr3@r.postjobfree.com

:+91-974*******

• Mapped existing data source components (stored procedures, reports and data

components) to cater to the new reporting requirements for the new application.

• Involved in designing and building of Universes, Classes and Objects by resolving

complex loops by defining contexts and aliases. C reated XCelsius dashboard repots.

• Created Ad-hoc reports using Web I/ Deski reports.

• Creation of different types of reports, such as master/detail, cross tab and chart.

Use of fil ters, conditions, calculations, etc.

• Created various Analytics and metrics using the Dashboard Manager and

Performance Manager and also worked on Crystal Xcelsius to develop POC.

• Modifying the existing universes, adding new objects editing joins mapping the

existing objects with renamed tables.

• Fine-tune the existing universes to enhance their performance.

Contact this candidate