Praveen Pati

abl71u@r.postjobfree.com

815-***-****

PROFILE SUMMARY:

. Over 8 years of experience in Business Objects Development using

various Business Objects (BOBJ) Product Suite including Webi,Deski,

Xcelsius Dashboards, Universe Development and Crystal

. Experience in BOBJ Development through versions Business Objects XI

3.1(R3.1) / XIR2/R1/6.x/5.x/5i/4.x and Xcelsius 2008 / 4.5

. Around 3 years in building dashboards using Xcelsius 2008/4.5 using

QaaWS, Web service connections, Live Office, XML, flash variables and

SAP BW Net weaver connections.

. Expertise in developing Universes for Customized Metrics and Goals to

Create Metric Analytics and Goal Analytics.

. Major responsibilities include gathering requirements from the end

user and developing Desktop Intelligence Reports, Crystal Reports and

Webi Reports.

. Extensive database architecture and design skills working on high

performance solutions in large corporate environments.

. Developed BOBJ 3.1 using advanced features including Database

Delegated (Smart Measures), Hyperlinks, Delegate Search, Data

Tracking, Input Controls and Merge Dimensions

. Strong Integration skills between External Portals with SDK and

Xcelsius Dashboards.

. Server Intelligent Agent (SIA),Central Configuration Manager, Central

Management Console, Business Objects Enterprise, BO Performance

Management, Auditor, Crystal Reports, Crystal Xcelsius, Query as a Web

Service (QaaWS), Voyager, Live Office, Dashboard Manager.

. Proficient in design, development, coding, implementation and

Support.

. Handful of experience in SQL Development and SQL tuning

. Worked with various teams including Business Owners/ Users, Database

and Front end Teams

. Designed and linked Universes for query, reporting, and analysis

using the Designer Module.

. Expertise in gathering, analyzing and documenting business

requirements, functional requirements, and data specifications for

Business Objects Universes and Reports.

. Experienced in developing complex reports using Business Objects Webi

Rich Client & Crystal Reports Enterprise having Parameter/Formula

Fields and Selection Formulas, Grouping and Sub reports.

. Performing Migrations from earlier versions 5.x, 6.x to XI R1/R2

architectures and recreating security Models in XI.

. Implemented both Single Pass Method and Incremental Method for

Migrations.

. Expertise in dimensional data modeling, Star Schema Modeling, Snow

Flake Modeling, fact and dimensional table design, physical and

logical data modeling.

. Good understanding of all the architectural differences between all

versions of Business Objects.

. Solid Experience in writing SQL queries, stored procedures, stored

functions, packages, database triggers, exception handlers, Cursors,

PL/SQL records & tables.

. Expertise in databases to include Oracle 10g/9i/8i/7x, MS SQL

2005/2000/7/6.5, DB2, and MS Access.

Technical Summary:

OLAP/DSS Business Objects XI 3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x, SDK,

Tools Crystal Reports, SIA, Central Management Console, Central

Configuration Manager, Designer, Desktop Intelligence,

Web intelligence, Webi Rich client, Report Conversion

Tool, Translation Manager, Crystal Xcelsius 2008/4.5,

Query As A Web Service (QaaWS), Performance Manager,

Deployment Tool, Auditor, Crystal Report Explorer,

Dashboard manager, Scorecards, Tomcat 4.0.6, Apache

1.3.x, Business Objects JAVA SDK

RDBMS Oracle 10G/9.x/8.x/7.x/5.x, DB2/400, SQL Server

2000/2005, MS Access 2000

Languages .net, ASP, VB Script, HTML,JAVA,JSP, PL/SQL, SQL, Shell

Scripting

Utility Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader

Tools

Operating MS-DOS, Windows 2003/XP/NT/2000/98/95, Unix, HP- Unix,

System Sun Solaris

Web VBScript, HTML 3.2/4.0, IIS 4.0/5.0

Technologie

s

[pic]

EXPERIENCE:

S&P 500 Jun 09 -

Present

Sr. Business Objects Consultant

Responsibilities:

. Gathered the requirements using JAD sessions, provided the related

Mock-ups for the particular Reporting Scenarios and documented them

properly for future references.

. Involved in designing Functional / Technical Specification documents.

. Created Web Intelligence Reports based on Portfolio and Financial

level for Risk Analysis

. Developed reports specific with these Delegated Search, Database

Delegated, Open Document and Data tracking new functionalities.

. Installed Crystal Xcelsius 2008 SP3 and developed dashboards using

various components.

. Developed Xcelsius 2008 Dashboards on top of QaaWS and Live Office

connections.

. Created Universe for Ad-hoc and Canned Reporting purpose based on DDL.

. Used dynamic visibility and Excel functions to control and manipulate

the data.

. Implemented Open Doc to drill down to detail webI report from Xcelsius

Dashboard.

. Exported Xcelsius to repository to make it available for users through

info view.

. Used relative path URL to migrate Xcelsius Dashboards from one

environment to other Environment.

. Created WSDLs using Query As a Web Service (Qaaws) from different Data

sources.

. Designed, developed, deployed and maintained universes used Business

Objects designer.

. Created Web Intelligence Rich Client reports with Metadata using

Metadata Universe

. Created Dashboards with Metadata Reporting

. Used Aggregate Navigation with compatibility filters in universe to

restrict the hierarchy.

. Written SQL queries and matching the data with database and reports.

. Tuned and Enhanced Universes with SQL Queries for the Report

Performance.

. Generated Reports from Different Data Providers in Business Objects

using a Normalized Schema Database.

. Created Web Intelligence Ad-hoc and canned reports.

. Tuning the queries to improve the performance of the report refresh

time.

. Created dashboards with multiple hyperlinks to various reports using

Open Document Syntax.

. Worked closely with DBAs to create aggregate tables to support

Universes and dashboard.

. Developed Webi Reports based on ETL Audit tables to track Record

submission, loaded records, Errors in records and Error details.

. Deployed Business Objects Universes and Reports in a Secure

Environment from One Server to Other Servers using Import Wizard.

. Written Training manuals on S&P Reporting Application

Environment: Business Objects XIR3.1 (Designer, WEBI, Web Rich Client,

Crystal Xcelsius 2008, QAAWS), Data Services, Oracle 10g, SQL Server 2005,

Teradata, Toad, Windows Server 2003.

[pic]

Booz Allen Hamilton Oct'07

- Jun'09

Sr.Business Objects Consultant

Responsibilities:

. Documented user requirements, translated Functional requirements into

Technical Requirements and develop implementation plan and schedule.

. Developed Report Mock-up samples before User interaction to analyze

the business requirements.

. Worked in the Team closely with Functional Architect, DBA and Analysts

to get a clear understanding on the Application.

. Creating Derived tables at universe level to resolve report level

complexity.

. Developed dashboards using Xcelsius 4.5 using live office and Qaaws as

the data sources.

. Developed universes to accommodate complex database design approaches.

. Tuned and Enhanced Universes with SQL Queries for the Report

Performance.

. Streamlined SQL generation from Universes by implementing Aggregate

Aware functions and @Variables.

. Created highly formatted reports to visually represent data.

. Created Webi Reports using all the BO functions like Drill Down,

Prompts, Dimensional and Measure variables to show accurate Results.

. Created live reports in a drill down mode to facilitate usability and

enhance user interaction.

. Developed Dashboards using Crystal-Xcelsius with data source as Live

Office.

. Developed and maintaining of two Projects with individual

responsibilities.

. Developed customized Webi reports as a source data for Live Office.

. Collecting report & Visual requirements from users/business owner.

. Enhanced the Performance of the Dashboards by manipulating and using

complex formulas on the Universe and Excel.

. Troubleshooting and rectifying Universe, Webi & Live Office errors.

Environment: Business Objects XI R2,Crystal Reports, Crystal Xcelsius 4.5,

Live Office, Oracle Database, PL/SQL, SQL scripting and Windows 2000

server.

[pic]

M&I Bank Jul'05 -

Sep'07

Business Objects Administrator/Developer

Responsibilities:

. Installed and Configured Business Objects on Both Client and Server

Installations.

. Deployed Business Objects Universes and Reports in a Secure

Environment from One Server to Other Servers using Import Wizard.

. Converted reports from 6.5.1 to XIR2 using the report conversion tool.

. Worked on the WEB.XML file on the application server to enhance auto

user logout from infoview with the parameter customization and then

users are redirected to a custom JSP page.

. Changed the infoview page layout by adding new features like the

company details instead of the Business Objects logo by using the

customization methods.

. Created user defined @prompts and complex conditions at Universe level

for better performance.

. Created Reports using all the BO functions like Drill Down, Prompts,

Dimensional and Measure variables to show accurate Results.

. Generated Reports from Different Data Providers in Business Objects

using Oracle Database.

. Created Compound Analytics, Charts and Goals on the Dashboard Manager.

. Created Universes for Customized Metrics and Goals to Create Metric

Analytics and Goal Analytics.

. Scheduled Metrics and Analytics to refresh for a scheduled time.

. Created Analytics on top of Metrics for the Performance Manager.

. Opened tickets in the Tracker for Reporting purpose to track all the

Report statuses purpose.

. Created Derived Tables in the Universe using views and stored

procedures to meet the Reporting Requirements.

. PM repository development and Metrics development.

. Created Cascading Prompts on the Reports.

. Implemented Filters, conditions in the Universe to the run the Reports

quickly.

. Created single sign-on for many reports using the URL functionality to

access them directly for upscale users.

. Created Analytic Dashboards for upscale users on the Financial Actual

Budget and Target Budget.

. Created Metrics, Metrics lists and used different analytics.

. Written SQL queries have been used on the Universe and created as

Derived Tables.

. Wrote Complex SQL Queries for Data validation purpose.

. Tuned and Enhanced Universes with SQL Queries for the Report

Performance.

. Created Views, Stored Procedures and validated data for the

Performance.

. Created hundreds of reports in thin client and full client using all

the functionalities

. Used the Export option for the Reports to schedule them in Broadcast

Agent Server and sent the scheduled reports via Email, Text and Excel

formats.

. Used the Broadcast Agent Server to Schedule and Monitor the Reports.

. Prepared Documentation to understand how the reports will work and how

to use the functionality with step by step.

. Prepared universe for Ad-hoc query functionality to educate users.

Allowing them to run queries to create some reports using objects in

the universe.

. Audit reporting system implementation on UAT and Production

Environments.

. UAT was one of the important processes that we had developed during

this project.

Environment: Business Objects 6.5.1, XI R2, Oracle 10g, Essbase Hyperion

Analyzer, DB2, Sun Solaris and Web Logic.

[pic]

Tata InfoTech

June'02 - May'05

Business Objects Consultant

Responsibilities:

. Documented user requirements, translated Functional requirements into

Technical Requirements and develop implementation plan and schedule.

. Supported Business Objects Environments as a Primary Role.

. Worked in the Team closely with Functional Architect, DBA and

Analysts.

. Created Derived Tables in the Universe to meet the Reporting

Requirements.

. Tuned and Enhanced Universes with SQL Queries for the Report

Performance.

. Created Stored Procedures and validated data for the Performance.

. Installed and Configured Business Objects on Both Client and Server

Installations.

. Created Default users using Central Management Console for the

Application to verify the Reports.

. Worked with User Interface (UI) Developers to create Urls for Single

Sign-on, passing the Required Parameters to run the Report.

. Deployed Business Objects Universes and Reports in a Secure

Environment from One Server to Other Servers using Import Wizard.

. Created user defined @prompts and complex conditions at Universe level

for better performance.

. Created Reports using all the BO functions like Drill Down, Prompts,

Dimensional and Measure variables to show accurate Results.

. Generated Reports from Different Data Providers in Business Objects

using a Normalized Schema Database.

. Created few Crystal Reports to Email and Ipage to the Customers.

Environment: Business Objects XI R1, Crystal Reports XI, Oracle 9i, LDAP,

Vitria, Sun Solaris and Web Logic.

Contact this candidate