Toronto,Canada

Sai Reddy

SAP BO/BI consultant

•Have over 6 years of Experience in Information Technology SAP

BO/BI Consultant in designing and development of Data-Warehouse

solutions using Business Intelligence, SAP Business Objects Suite

and Software applications.

•Expertise in gathering requirements, analyzing existing data

store, designing data warehouses and data marts, planning Extract,

Transform and Load (ETL) routines, designing end-user reports.

•Experience in ETL using SAP Business Objects Data Services

Designer to source/load schemas. Excellent knowledge of Data

warehouse, BW/BI components and ETL Processes like creating Info

cubes, Multiprovider, InfoSource, DataSource, InfoObjects, DSO.

•Experience utilizing data marts, stored procedures, and/or cubes

as the source for reporting.

•Expertise in SAP Business Objects XI Suite (4.0/3.1), CMC,

Designer, Desk I, BI Launch Pad (Info view), Rich Client,

Interactive Analysis (Web Intelligence), Import wizard, Report

conversion tool, Performance Manager, Live Office, QaaWS, Life

Cycle Manager, Xcelsius, Crystal reports.

•Developed Custom Queries in BW front-end using BEx Analyzer.

Created Queries using BW- Reporting Variables, Navigational

attributes, Calculated Key Figures, Restricted Key Figures &

Filters.

•Hands-on experience in Advanced analysis for OLAP Reporting, BO

Explorer to retrieve data from various corporate datasets,

designing, analyzing the universes, Creating and Maintaining

various complex Ad-hoc reports using Web I & Desk I.

•Unit testing of the real-time Dashboards and Business Objects

reports by data validations by comparing data against the BEx

queries using BEx Analyzer and WebI reports.

•Expertise in Migration of reports from various BO versions using

import wizard and tested them thoroughly after migration.

•Built real-time operational dashboards using Xcelsius and SAP

Netweaver BW Connection (BICS) with detail level drill-down Web

Intelligence reports.

•Created Crystal Reports using Crystal reports formulas, Grouping,

Parameters, Selection criteria to handle the end user requests

•Extensive knowledge in SQL and coding PL/SQL Packages, Stored

Procedures, Views, indexes, Function and database Triggers.

•Experience in Performance tuning of Queries maintaining

Aggregates, Compression, partition, indexing.

•Experienced in designing and developing web applications using

.Net Framework, Telerik Rad Controls, XHTML, CSS, JavaScript,

Visual Studio 2010, Team Foundation Server and SQL Server 2008.

•Solid understanding of Software Development Life Cycle (SDLC)

methodologies like Planning, requirement gathering, design &

development, testing and maintenance.

•Hands-on desktop management with the tasks like software

installations, troubleshooting and maintenance. Exposure to

translating business requirements into IT Deliverables.

•Participated in Installing, Configuring and upgrading Business

Objects Enterprise Suite of Products.

•Ability to effectively communicate ideas to team members with

varying levels of technical expertise.

•Excellent problem solving, communication, time management and

Organizational skills.

Work Experience

Sr. SAP BO/BI consultant

Allstate Financials & Insurance

Schaumburg, IL

April 2012 to Present

The Allstate Corporation is the nation's largest publicly held

personal lines insurer. Allstate sells major lines of insurance,

including auto, property, life and commercial etc and offers

services.

Responsibilities:

•Involved in Full life cycle design and development of Business

Objects Enterprise Applications.

•Interacted with Business Analysts & Business Users to understand,

gather & document requirements according to functional

specifications.

•Developed Test plans, Test cases/test scripts and executed Test

Cases as in business requirements & required rules.

•Worked on and maintained different ETL solutions using BO Data

Services.

•Resolved join problems like loops by creating Aliases and

Contexts as per the business logic in the Universe.

•Involved in developing, designing and maintaining new and

existing universes by creating joins and cardinalities responsible

for Creation of the universe with Classes, Objects and Condition

Objects.

•Created simple & complex reports using Dynamic Calculations,

Hierarchies, list of values (LOVS), local Variables, Functions,

Alerts, Ranking, Merge Dimensions, and Drill Filters.

•Customized LOVs in Universes for quicker performance of reports.

•Used Variables, User defined objects, Scope of analysis, Drill

mode, Slice and dice mode, Prompts, and Conditions to make reports

accurate and easier for analysis.

•Developed Ad-hoc Reports using Business objects Universe as the

Data source in Web Intelligence.

•Deploying Business objects contents in production environment by

using Import wizard.

•Full lifecycle project focusing on surveys, including Data

Services and Designer (universe) components.

•Strong exposure to Dimensional modeling techniques Star and Snow-

flake schemas.

•Involved in designing dashboard using Xcelsius 2008.

•Created interactive Dashboards and Business Presentations with

Crystal Xcelsius using QaaWS.

•Scheduled Crystal Reports and Implemented dynamic cascading

prompts.

Environment:SAP BI 7.0, Business Objects XI 3.1/4.0 suite, Oracle

9i, SQL navigator, Xcelsius, Crystal Reports,Client Duration

Position Environment.

SAP BO-BI Developer

Allergan Orange County CA

December 2010 to March 2012

Business Objects 4.0

Allergan is a global, technology-driven multi-specialty health

care company pursuing therapeutic advances to help patients live

life to their fullest potential. In making this commitment, we

work to develop an unparalleled level of insight into patients'

wants and needs - and into the priorities and concerns of the

medical specialists who treat them. To this end, we employ more

than 50 percent of our work force in either research and

development (R&D) or sales, ensuring our efforts are focused on

innovation and our customers.

Responsibilities:

•Involved in all phases of Software Development Life Cycle

(SDLC).

•Involved in identification of Business and Data requirements and

converting them into conceptual and data models.

•Involved in Working with Erwin tool in Data Modeling (both

Physical and Logical Design).

•Involved in Installation, Configuration, and Deployment of whole

BI 4.0 SP4 on Windows environment

•Involved in the Designing and Building of Universes which had

custom objects and conditions with complex functions.

•Designed, Developed and Maintained Universes by defining joins,

cardinalities between tables applying contexts and alias tables to

remove cyclic dependencies.

•Used various functions such as @agregateaware, @execute @prompt,

@select, LOV's, Index Awareness, Custom Hierarchies etc., in

Designer.

•Created several Ad-hoc, Canned, On-Demand, Standard Reports using

tools such as Info view, WEBI Rich Client.

•Analyzed the relationship between fact and dimension tables in

the data warehouse while designing Universe.

•Created stored procedures in PL/SQL for derived tables and used

them as source for BO reports.

•Connected to SAP BW source using BI 4.0 while designing Universe

using Information Design

•Created Ad-hoc and standard reports using functionalities such as

Multiple Data Providers, Merge Dimensions, Master/Detail, Cross

tab, Multi-Dimensional Analysis, Drill Analysis, Scope of

Analysis, Filters, Charts, Alerts, Breaks, Ranking, Sorting, LOV,

Formulas, Variables, Sub Queries, Combined Queries (Union,

Intersection, Minus).

•Created reports in Crystal 2011 using formulas, Grouping,

Parameters, cross-tab, sub reports, parameter values etc.,

•Created dashboards using Dashboard Designer using Excel data

source with Combo box, List box, Selectors, Alerts, Drill Down,

What-if presentation, Filtered Rows and Dynamic visibility.

•Visualized Data and enhanced reports using different types of

charts like Histogram charts, Bar charts and Funnel charts.

•Migrated reports and objects from development to production

environment using import wizard.

•Exported the Business Objects reports to Webi to be viewed by all

users on the Webi server.

•Created and published reports through Web Intelligence Infoview.

•Generated SQL scripts for validating and testing reports.

Environment: BI 4.0, UDT, IDT, CMC, Launch Pad, BI Mobility, BO

XI 3.1, Xcelsius, BI Explorer, SAP BW 7.0,7.3, BEX Query Designer

3.x,7.x, Analyzer 7.x, Analysis, Dashboard, Interactive Analysis,

Windows 2008 Server, Unix, Solaris.

Client Duration Position Environment

SAP BW/BI Technical Associate

CONSOL Energy Inc

Canonsburg, PA

March 2009 to Nov 2010

CONSOL Energy is America's leader in underground coal mining and

the largest exporter of coal. It has evolved from a single fuel

mining company into a multi-energy producer of both high-BTU coal

and gas.

Responsibilities:

•Worked as a part of the BW Implementation team, and participated

in gathering user requirements and data modeling using ERM and

star schema concepts.

•Uploaded master and transactional data from files and SAP as the

OLTP source.

•Developed technical specifications based on the functional

specifications to meet business requirements.

•Created Info Objects, Data Sources, Info Sources, Data targets,

Info Packages and Info Providers to load Master and Transactional

data from SAP R/3 system into BW system.

•Developed Portal iViews involving BI reports by publishing the

reports from BEx web application designer.

•Developed Universes using SAP BI/BW Queries as Source Data.

•Created Objects and prepared Reports like financial reports, HR

reports, standard and ad-hoc reports, and universes.

•Worked extensively with SAP BI functional/technical developers to

design and develop the SAP BI Info cubes and multiproviders

utilized in Business Objects Web Intelligence reports.

•Built analytical dashboards based utilizing the QaaWS and Live

Office connections with detail level drill-down Web Intelligence

reports.

•Developed universes and reports based on SAP BEx queries and non-

SAP data sources using advanced/new features including Database

Delegated Measures, Hyperlinks and Merged Dimensions.

•Developed various complex ETL packages and cubes using ETL tools

such as Business Objects Data Services, Data Integrator.

•Imported/ Exported the Universes from/ to repository to make them

accessible to end-users.

•Developed test cases and performed UAT as per the

specifications.

•Implemented needed changes in BO designer including adding

tables, creating derived tables, basic and complicated objects.

•Performed Query Optimization using aggregates to improve the

performance of the Query.

•Created queries (BEX Queries) using Business Objects Explorer on

the SAP BW for the queries to be used for Universe Design.

•Created Crystal reports by directly connecting to the ODBC to the

database.

•Created Crystal Reports using Crystal reports formulas, Grouping,

Parameters, Selection criteria to handle the end user requests.

Environment: Business Objects XI R2, SAP BI 7.0, SAP BW 3.5, SAP

BO Data Services, Crystal Reports, SQL Plus, PL/SQL, Windows 2003

Server.

Business Objects Consultant

Prudential GI Systems, NJ

May 2007 to Feb 2009

Project: Multiple Projects (Customer One, Life Enrollment &

Small Business)

Role: Sr Business Objects Consultant/Lead

The Prudential Insurance Company of America, a Prudential

Financial company, is among the

largest group life and disability insurance carriers in the

nation, and has a strong, ongoing focus

on long-term care insurance.

Customer One: The newly established product and service governance

teams have established

objectives that require a "Customer Needs" focus and a "Consistent

Servicing Experience" across

products. A need has been established for a "Right Touch" customer

centric model.

Life Enrollment: Life Enrollment is to define the systems

enhancements necessary to support the

creation of a Life Enrollment Data mart. Life Enrollment data,

including both Case Level and

Individual Web Enrollment, Sales Reporting and Adjustments data

and Pricing Assumptions will

be received into GIDW at various times during the month.

Small Business Reporting: The purpose of this requirement is to

define the data elements for

Small Business which will be received from SPARC system and the

data will be further passed

to GIDW via GIS application.

Responsibilities:

•Involved in all phases of Software Development Life Cycle such as

Development, Testing,

Administration and Production.

•Worked as Business Analyst in providing information to end users

with their day to day data

requirements and designing BRDs (Business Requirement Documents).

•Debugging Stored procedure in SQL for performance tuning of

reports in BO

•Worked on Triggers, referential integrity, Storage migration,

Partitioning, Indexing,

Materialized views, Purging, overlapping processes and security

for performance tuning.

•Created Dimension Model for the reporting system by identifying

required Dimensions and

facts using Erwin

•Conducted design discussion and meeting to come out with

appropriate data mart at the lowest

level of grain for each of the dimensions involved.

•Optimization and Formatting of the Existing Universes for easy

understanding for the Users.

Implemented Standard Naming convention across Universes and

Reports.

•Helped users in solving adhoc query issues, building adhoc

reports, setting up report schedules

in Info view.

•As a part of Universe development, created Classes, different

kinds of Objects, cardinalities,

Strategies, resolving loops using Aliases and Contexts.

•Conducted Design reviews with analyst and content developers to

create POC for the reports.

•Created views in SQL and derived tables in the universes to meet

the BO report design

requirements.

•Modified and corrected many existing reports/universes as per the

change requests from users.

•Created a large number of Full Client and Web Intelligence

reports. Functionalities such as Slice and Dice, Drill mode and

Ranking, complex IF statements, Where Clauses were used for

Multidimensional Formatting.

•Reports were created using multiple data-providers. Reports

involved Current Date-Prior Date,

Weekly, Monthly, Quarterly comparison.

Environment: Erwin r7.1, Business Objects XIr2, Oracle Sql

developer, Toad db2, Import

Wizard, Team track, PVCS.

Education:

Bachelors of Computers in Information Technology

Osmania University -

India

Skills

SAP BI BO

Additional Information

Technical Expertise:

BI Tools

SAP BO Xi 4.0/3.1/ XI R2 (SDK Java, .Net), (CMC, CCM, Designer,

Desk I), Import Wizard, Interactive Analysis (Web Intelligence),

BI Launch pad, BCA, Performance manager, Life cycle Manager, Live

Office, QaaWS, Report Conversion Tool, BI 7.0

Reporting Tools Business Objects, Crystal Reports, XCelsius

Front-end Tools SQL Plus, Toad, SQL navigator

ETL Tools SAP Business Objects Data Services, Data Integrator, SAP

Net Weaver BW

Databases Oracle 10g/9i, SQL Server 2008/2007, MS Access,

Teradata

Programming languages: .Net Framework, C, C++, Java, XML,

HTML/DHTML, XML, PHP, JavaScript, CSS

IDE: Visual studio 2010, Adobe Dream Weaver, Eclipse, Jcreator

Operating Systems: Windows (NT, XP, Vista, windows 7), Windows

2004/2005 server, LINUX

Software Applications: MS office suite 2008 & 2010, MS Project.

Address for Communication:

119 Cherrylawn Avenue,

Toronto, On, Canada

M9L2B6

Phone:647-***-****

Email Id:acb72v@r.postjobfree.com

Contact this candidate