Resume

CURRICULUM VITAE

P. Sai Prasad

BO Report Developer

Email Id : bco2ly@r.postjobfree.com

Mobile: +91-903*******

Professional Summary:

Having around 3 years and 10 months of IT experience as a Business Objects Report Developer using Desktop Intelligence, Web Intelligence and Web Intelligence Rich Client Tools.

Good exposure to Business Objects XI R2, XI R3, Cognos 8.4 Report Studio, Query Studio.

Involved in Universe Design by modifying the Universe by adding classes and objects to the Universe, resolving the loops by creating aliases and contexts and creating Ad-hoc and Interactive Reports for the End Users using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @functions, @Prompts etc.

Experience in Creating Hierarchies for providing drilling options for the end user, working with multiple data providers, Drill Down, Cross Tab, Chart, Master Detail, Alerter, Filter, Ranking and Formulae etc. Creating User Objects, variables, formulas etc. using Desktop Intelligence tool and working with Merged Dimensions using Web Intelligence tool.

Extensive knowledge in Business Objects Tools and Datawarehousing concepts.

Excellent written and verbal communication in corporate environment and the Ability to perform independently as well as in team environments.

Strengths:

Good communication and strong interpersonal skills with ability to interact with the end-users, managers and technical personnels.

Have the ability to learn things quickly and can work under pressured atmosphe-

res.

Educational Qualifications:

MCA (Master of Computer Applications) from Madurai Kamaraj University.

Bachelor of Science Degree(B.Sc) from Sambalpur University at Ispat College, Rourkela (Orissa) in the year 1998.

Professional Experience:

• Working as a BO Report Developer with Ness Technologies Pvt., Ltd, Bangalore from July 2010 to till date.

• Worked as a BO Report Developer with Keane International Pvt., Ltd., Bangalore from May’2008 to June’2010.

Technical Skills:

OLAP TOOLS: BOXI R2, BOXI R3, Cognos 8.4

OPERATING SYSTEMS: Windows 98/NT/XP/2003 Server, MS-DOS.

NATIVE LANGUAGES: C++, Java (Core).

DATABASES: MS Access 2000, Oracle 10g, Oracle 9i,MS SQL Server

MS-Tools: MS-Office

Project Details:

Project#1 :

Project Title: Universal Reporting System (URS)

Client: Universal Gaskets, Australia

Role: Report Developer

Duration: September 2011 –till date

Organization: Ness Technologies Pvt., Ltd.

Team Size: 6

Environment: Database: Oracle 10g, SQL Server 2000.

Tools: Business Objects XIR3

Description: Universal Gaskets is a Car Parts Manufacturing company in Australia. The Universal Gaskets Sells its products Nationally and Internationally. Universal Gaskets has a stock of around hundreds of different materials. The URS Reporting is used for a Basis to do high level design and cost estimation of the products. As the Universal Gaskets Sells its products across the world, so our job is to calculate the sales profit earned by selling the UG products in different branches and apart from this we have to estimate the Invoice details, shipping details of the stock of the materials, customer details, product model details etc.

Responsibilities:

Involved in Universe Designing by adding classes, dimension objects, measure objects and creating the joins between the tables, checking the cardinalities, creating Universe Level Filters by using designer module in Business Objects XIR3.

Involved in resolving the loops by creating aliases and contexts.

Developed the reports using Web Intelligence through Info View.

Created the reports using Business Objects functionalities like combined queries, slice and Dice, Drill Down, cross tab, Master Detail and formula etc.

Project#2 :

Project Title: SFDC (Sales Force Data Communication)

Client: Business Objects

Role: Report Developer

Duration: July 2010 -September 2011

Organization: Ness Technologies

Team Size: 6

Environment: Database: Oracle 10g, SQL Server 2000.

Tools: Business Objects XIR2.

Description: The SFDC reporting project reports on operational data, which is pulled from salesforce.com. Salesforce.com is a CRM tool http://www.salesforce.com/ used by Business objects to manage their sales; It contains different modules like Opportunity, Leads, Contacts, Campaign, Forecast, Accounts. This tool is used by Sales Representatives to enter their sales & marketing related details. The Business objects have subscribed the SFDC data & these data are moved from SDFC to BO staging area on a regular interval of time then to SFDC HUB Database. The Sales & Marketing Universe is built on HUB database & reports were generated in XI R2 version.

Responsibilities:

Studying the domain and gathering requirements.

Created and analyzed reports on SalesForce.com CRM tool.

Analyze and Debug customer issues.

Understand customer requirements and translate them to work flow.

Provide timely solutions for critical Business issues

Process Development

Project#3:

Project Title: Marketing Information System

Client: Bank Of America

Role: Report Developer

Duration: April 2009 to May 2010

Organization: Keane International Pvt., Ltd.

Environment: Database: Oracle 9i

Tools: BOXIR3

Team Size: 5

Description: Marketing Information Systems project is designed for the Insurance & Banking department of Bank of America for forecasting decisions on budgeting and marketing. Populated reports using various Data Marts which enables customer profiling for target marketing, target customer groups and analyzing profitable schemas for various branches in US.

Responsibilities:

Requirement Analysis and Universe Design.

Development of more than 25 webI and DeskI Reports.

Providing the reporting solutions for the dynamic business requirements using the Business Objects.

Worked with various functionalities of BO like Filters, Breaks, Ranks, Alerters, Variables, Formula’s and Drill Filters based on the End User’s Requirements.

Created the Reports using Multiple Data Providers.

Creating the Charts for particular reports. (Bar, Pie and column chart).

Project#4:

Project Title: Supply Chain Analysis

Client: Unisys Global Services Pvt., Ltd.

Role: BO Report Developer

Duration : May 2008-March 2009

Organization: Keane International Pvt., Ltd.

Environment: Database: MSSQL Server 2005

Tools: BOXIR2

Team Size: 8

Description: This project is implemented if Supply Chain Process of organization as request from customer by sales organization that are given for cost estimation .once cost is approved by customer that send it for production ,quality and manufacturing.

Responsibilities:

Understanding the existing business model and user requirements.

Adding the classes and objects to the Universe Schema.

Created Aliases and Contexts for resolving loops. Used formulas, Variables, Filters, Alerters and other BO functionalities in reporting.

Development of WEBI reports.

Analyzed the reports using drill through and scheduled to end users.

DATE:

PLACE: PRATA SAI PRASAD

¬¬______