SUMMARY

• 7 years of strong Data Warehousing experience in SAP Business Objects XIR4, XIR3, XIR2/6.x/5.x (Designer, Desktop Intelligence, Business Objects Developer Suite, Web Intelligence XIR2/ 6.x/ 2.x, Broadcast Agent).
• Expertise in planning, designing, developing, distributing and maintaining Universes.
• Using Designer developed SAP Business Object Universes on top of Star and Snowflake schema data models.
• Extensively used Web Intelligence, Infoview for querying, reporting and analysis tasks.
• Involved with a team in creating Dashboards using various visual analytics, themes to meet corporate standards using XCelsius.
• Created multiple Crystal and Web Intelligence reports and transformed into a single dashboard using Xcelsius.
• Used Broadcast Agent for scheduling and batch processing of Business Objects and Web intelligence document.
• Strong knowledge in building queries on different types of Data Providers Universes, Personal data files, Stored Procedures, Free - hand SQL and Web connect.
• Very good experience in both developing as well as testing of OLTP Business intelligence applications.
• Proficient in migration of Business Objects 6.5 to Business Objects XIR2 Enterprise and migration of the Content (User, Groups, Universes and Reports etc) using Import Wizard.
• Proficient in working on development environment in different RDBMS (Oracle, SQL Server, DB2 etc.
• Expert in working with databases - Oracle10g/9i/8.x, MS SQL Server, Sybase, MS Access.
• Excellent Performance tuning technique from Business Objects and Database perspective.
• Implemented row level and object level security using the Business objects tool.
• Strong testing and debugging skills and strategies to extract data from different source systems.
• Expertise in Designing FACT Tables, Dimension Tables, Summary Tables.
• Installation & Configuration of Business Objects XIR2 with CMS.
• Experience in Import wizard & publisher for migrating reports & universes.
• Worked with complex scheduling features in CMC including calendars and event based scheduling.
• Strong experience in SAP Business Objects Administration/ CMC to create and manage the Users and Groups, applications, Security and rights to the Users.
• Strong knowledge in using aggregate awareness functions, developing complex reports using multiple data providers in Business Objects.
• Expertise in using functions like @aggregate aware, @prompt, @select and creating custom hierarchies.
• Expertise in resolving fan traps and chasm traps using aliases and contexts in Universes.
• Experience in creating complex filters such as pre-defined conditions, report filters, prompts and drill filters.
• Providing User-based training to all corporate customers about creating their own Adhoc reports.
• Experience in various domains such as Sales, Financial, SCM and Asset Management.

TECHNICAL SKILLS

DSS/OLAP Tool: Business Objects 5.x/6.x/XI.x,CMC / Supervisor, CCM, Designer, Full Client / Desk-I, Web Intelligence, BCA, ZABO, BO Auditor 1.0 & BO SDK. Crystal Reports /XI/2008, Business View Manager, Crystal, Xcelsius, Data Insight and Infoburst.

Databases: Oracle: Oracle 7.x/8.x/9.x/10g,MS SQL, SQL Server 2000/2005, MySQL, MS Access 2003.

Operating Systems: Windows 9.x/2000/NT/XP/2003

Programming Languages: SQL, T-SQL, PL/SQL,C, MATLAB

PROFESSIONAL EXPERIENCE

Confidential, MA

SAP Business Objects Developer

Responsibilities:

• Installed SAP Business Objects XIR3.1 Designer and Import Wizard tools.
• Created ODBC database connections to the Planview transactional database and to the Planview Datamart database.
• Created and maintained Secured, Shared and Personal connections according to the Security level required.
• Responsible for gathering the user requirement; prepare the requirement specifications document, design, development, analysis and testing.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies, Strategies.
• Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Created SAP Business Objects reports, enhancements and fixes using Web Intelligence and customizing BO universes.
• Created Web Intelligence documents and published them to corporate documents using Infoview.
• Linked different reports and also linked to the internet using the hyperlink option in the Infoview.
• Assist in ensuring all existing SAP BO reports work appropriately during the PVE10.2 upgrade project.
• Performed report analysis to ensure existing documentation is accurately depicting the report information.
• Provide guidance to I.T. team members in relation to Universe items or best practices for report promotions and/or report documentation.
• Generated SAP Business Objects Reports involving complex Queries, SubQueries, Unions and Intersection.
• Created complex XCelsius dashboards and generated reports using Crystal Reports.
• Used Crystal Management Console for scheduling the reports which are saved in different format like Excel and PDF Format and then e-mailed to the Users.
• Created Users and Groups and assigned access levels to BO content as well as applications.
• Extensively used Designer to design various universes for different business groups.
• Created and maintained universes on OLAP (Online Transaction Analytical Processing) databases.
• Created various classes and objects with different object qualifications such as measure, dimension and detail objects.
• Used @ functions like @aggregate aware, @prompt and implemented custom hierarchies for Multi-dimensional Analysis.
• Created complex reports using cascading prompts, variables and calculation context.
• Created different types of reports such as Master/Detail, Cross Tab, Chart and Tabular using universe as a main data provider.
• Created different types of charts and graphs for analysis of data and formatted their properties such as font, color etc.
• Worked extensively with the major functionality of SAP BO like Breaks, Alerter, Variables, and Formulas.
• Created filters such as drill filters, Query prompt and sorted data in the WebI reports according the user specifications using sorts.
• Inserted free standing cells and used functions and prompts to change the title of the report dynamically according to the value selected in the LOV for easier analysis of data.
• Synchronized various queries in Web Intelligence using Merge dimension according to the user specifications.
• Performed unit testing, system testing and user acceptance test (UAT) for universe and reports.
• Interacted with Co Developers, Business Support Analysts and Business Users in gathering the requirements for the Report Requests.
• Attended PVE-Team meetings and Weekly Status meetings and documented each stage of Implementation.
• Created documentation for users to access and analyze data using SAP Business Objects.
• Provided support and training for business users in using Infoview and WebI.

Environment: SAP Business Objects XIR4, XIR3.1, CMC/Supervisor, Designer, Web Intelligence, Crystal Reports, Oracle 10g, MS SQL Server 2005, Windows 7.

Confidential, OR

SAP Business Objects Consultant

Responsibilities:

• Configured Web Intelligence using Configuration tool.
• Responsible for setting up the Users/Groups, database connections, assigning privileges to the users using Supervisor.
• Assigned Broadcast Agent to various groups using Web I Admin Console.
• Defined categories of documents for different level of groups.
• Involved in gathering functional requirements from the business users.
• Design and Development of Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Generation of Xcelsius Dashboards using SAP Business Objects LiveOffice and Query as a Web Service as Data Sources.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Created derived tables to reduce the complexity of the universes and also created prompts to force the users to restrict the data in the process of building the universes.
• Involved in the troubleshooting of universe schema with Loops, Chasm and Fan traps and Cardinality problems by creating Aliases and Contexts as required.
• Exported and Imported Universes to and from CMS.
• Created custom List of Values (LOVs) for better understanding of prompts by the end user.
• Created Adhoc and Canned reports and fine tuning them for faster execution.
• Created custom Hierarchies to support drill down functionality for in depth analysis.
• Extensively used Calculations, Variables, Breaks, Slice and Dice and Alerts for creating Business Objects reports.
• Linked Universes to share the common components using Kernel and Component approach.
• Generated complex reports using the various data Providers like Universes, Personal Data Files and Free Hand SQL.
• Created some of the reports using Crystal reports and created Xcelsius dashboards.
• Used Crystal Reports for sales tracking and billing purposes.
• Involved in day-to-day Business Objects Server maintenance.
• Optimized systems with load balancing with distributing components on different servers.
• Worked with DBA for creating the aggregate tables to improve the performance of the SQL transactions and used Aggregate Awareness (@Aggregate Aware) in select statements to run a query against the aggregate tables in the database instead of base tables.
• Created users/groups and defined privileges using Central Management Console. Migrating Business Objects 6.5 version reports to new version XIR2 and X1R3.
• Converted the existing full client reports to Web I reports using Report Conversion Tool.
• Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment.
• Actively involved in giving demos to the users and prospective users about the functionality available in Business Objects.

Environment: SAP Business Objects 6.5.1 (Supervisor, Designer, Reporter), Business Objects X1R2/XIR3, Web Intelligence, ZABO, Info View, Broadcast Agent, Oracle 9i, DB2 UDB, SQL, TOAD, Sun Solaris, Windows 2000/NT.

Confidential, MI

BO/Crystal reports Developer

Responsibilities:

• Gathering the user requirement and prepare the requirement specifications document. This involved interaction with the business users and understanding the current reporting system.
• Installed & configured BCA Scheduler & Publisher BCAP.
• Created centralized Repository with all three domains (security, universe and document) and distributed the BO Main key among the enterprise.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Worked in creation of multiple universe and document domains for development, test and production Environments.
• Created users, groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module.
• Good experience in creating and maintaining Secured, Shared and Personal connections.
• Involved in designing and developing of Universe for reports generation.
• Checked the integrity function for existence of loops and resolved them by using aliases and contexts.
• Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc.
• Manipulated the data by creating user defined objects using advanced database functions.
• Involved in setting up of Aggregate awareness to enhance the performance of SQL transactions.
• Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.
• Trained users to Use Crystal Reports, Modify and enhance Crystal Reports, Save Crystal Reports.
• Formatting the Reports based on the user requirements using all the functionalities in Business objects like Slice and Dice, Drill Down, Alerter, User response, and Formulas etc.
• Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way and Hierarchies to provide the drill down functionality to end-users.
• Created Full Client reports using different Data providers like Oracle, Excel sheets, SQL server.
• Created report level contexts in Web Intelligence and Desktop Intelligence reports.
• Used Broadcast Agent for scheduling and distributing the documents.
• Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications.
• Trained business users in creating web intelligence reports.

Environment: Business Objects 6.5.1,X1R2(Supervisor, Designer, Reporter),Web Intelligence 6x, Broad Cast Agent, ZABO, Crystal 9, Oracle 9i, MS SQL server 2000, Sybase 12.0,TOAD,ERWIN,Windows 2000/NT,UNIX.

Confidential, PA

Business Object Report Developer

Responsibilities:

• Responsible for Designing the Universe. Created Aliases and Contexts for resolving the loops to increase the performance.
• Extensively used filters, conditions, LOV’s and calculations in DeskI and WebI.
• Linked the Universes to share common objects. Updated and maintained Universes based on changing user rents and data source changes.
• Designed the Universe based on ER Diagram using Visio.
• Created different types of reports such as master /detail cross tab and charts.
• Created complex reports using user defined functions, condition objects and used aggregate awareness, short-cut join functions for Query performance enhancement.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
• Worked extensively on Dashboards and scoreboards while developing the reports.
• Created reports using Performance Manager.
• Created report development using Crystal Reports and XCelsius.
• Created cross-tab, conditional, drill-down, Charts and sub reports using Crystal Reports.
• Applied Oracle hints, Aggregate awareness, Object Hierarchies, Query optimization, linking for the Universes.
• Developed & Tested complex reports (combining data from multiple Data Sources) for various groups and published them to the Corporate Documents. Developed complicated reports like Orders by Customer/Product/Region, Billing Booking & Backlog reports, Revenue & Commission reports.
• Configured Broadcast Agent /Scheduler for scheduling the reports and accessing the reports through thin client..
• Experience in writing stored procedures using PL/SQL to validate reports.
• Exported the Business Objects reports to WebI to be viewed by all users on the Internet.
• Part of the team for implementing and testing of reports from Business Objects 6.5 to Business Objects XI R2.

Environment: Business Objects 6.5.1, XIR2 (Supervisor, Designer, DeskI, Reporter, Web Intelligence and Infoview), oracle 10g, Toad, Informatica, PL/SQL, Crystal Reports XI, Oracle 9i, Unix.

Confidential

Business Object Report Developer

Responsibilities:

• Interacting with report users and Business Analysts to understand and document the requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
• Developed Business Object Universes using Designer and Business Objects for the reporting solution for Operational reporting system.
• Potential usage of alias, context, and shortcut join concepts to overcome the loops.
• Created reports that limit the reports to display information for particular measures by designing complex Filters.
• Created reports like, Reports by Category, Reports by Plan, and Reports by Time (Year, Quarter, and Month Date).
• Created complex reports like Master Detail and Cross Tab reports to view and analyze the data.
• Developed Adhoc reports using Business Objects.
• Formatted Reports as per the user requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Involved in Importing/Exporting the Universes to repository to make available to the end user.
• Used Web Intelligence for web based query and reporting and published reports.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, @Functions and Formulas, Filters & Alerts for creating Complex reports.
• Used the Broadcast Agent for Scheduling and monitoring the reports. Validation of the data by creating different test reports on warehouse tables and on base tables.
• Tested the report data, performance of data retrieval against the Warehouse data with TOAD.

Environment: Business Objects Designer 6.5.1, Business Objects Reporter 6.5.1, Web Intelligence 6.5.1, TOAD, ZABO, Broadcast Agent, Dashboard Manager, Oracle 9i, SQL, PL/SQL, SQL*PLUS, Windows XP.