SUMMARY

• Seven years of experience with Business Objects suite of tools. Well versed in RDBMS and Business Intelligence with Data Warehousing Concepts.
• Excellent experience in Desktop Intelligence, Web - Intelligence, Info View, Universe Designer, CMC
• Excellent data-analysis skills and ability to translate specifications into a working Universe and/or Report.
• Expertise in planning, designing, developing, distributing and maintaining Universes generating complex reports.
• Expertise in Universe designing, developing and Experience in creating Adhoc reports using Business Objects Web Intelligence tools.
• Experience in installation and configuration of Business Objects, Creation of repositories and security domain with user groups and security implementation.
• Experience in creating users/user groups in CMC (Administration module).
• Knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts.
• Experience in tuning the performance of SQL queries and ETL process.
• Experience in retrieving data using Business Objects Universes, personal data files, stored Procedures and free hand SQL methods, query processing algorithms.
• Proficient knowledge on BO XI Architecture and new features.
• Extensively used Business Objects Reporting functionalities such as Master Detailed, Slice and Expertise in using Import Wizard to Migrate reports and universes between different environments like development, testing and production.
• Knowledge in Quality Assurance Testing and facilitation of User Acceptance Testing
• Created a relationships diagram within Access to show relationships between tables and queries.
• Worked on creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe.
• Experience in creating users and user groups, restricted access of the users as needed using Central Management Console (CMC). Involved in managing users, groups, folders and published reports using Central Management Console.
• Good understanding of Data warehousing tools like Informatica and Business Objects Data Integrator (BODI).
• Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling using Erwin tool.
• Ability to handle multiple tasks and work independently as well as a team member.

TECHNICAL SKILLS

BI Tools: Business Objects 5.x/ 6.x/ XI/ XIR2/XIR3/4.0 (Supervisor, Designer, Reporter, Desktop Intelligence, Web Intelligence, Central Management Console, Info View & Broadcast Agent), Crystal Reports

Databases: Oracle 8i/ 9i/ 10g, SQL Server 2005/2008, Teradata, SAS, MS Access 2002

Languages: PL/SQL, SQL, C++

Platforms: Windows NT/ 2000/ Server 2003/ XP, Windows 7, Linux/UNIX, Solaris

PROFESSIONAL EXPERIENCE

Business Intel Engineer

Confidential, Columbus GA

Responsibilities:

• Interacted with Business Users and gathered Business Requirements and involved in Analysis & Documentation.
• Experience in documenting the functional requirements, High level documents, Business Required Documents.
• Modified the existing Universes by adding tables, Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Handled Embedded Functions like @Prompt, @Select and @Where in the Designer to handle
• User requests for report generators.
• Created Derived Tables, use Aggregate Awareness concept to increase the performance of the universe.
• Created ad-hoc reports using various Business Objects functionalities like alters, sorts, ranking, filters, breaks, sections, c and charts.
• Created Various Crosstab Reports with complex Calculations in Business Objects 4.0 .
• Created Complex Crosstab Reports with 20 tabs in it And Used multiple Queries to meet the Business Requirements.
• Performed Various complex Calculations Like Standard Deviations, Variance etc. and also used Calculation context Operators like For Each,For all and IN.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode.
• Linked Summary report with Detail report in Web I using Info view in order to obtain detail information about an object contained in summary report.
• Used parameters, Formulas, running totals and Crystal Functions to Convert Data according to the specification of the report.
• Worked on the Master, Kernel and Component approach during the linking of universes.
• Used Report Conversion Tool to convert the Deski reports into Webi and maintained the folders in the Info view.
• Defined various row and object level security for the Business Objects Users.
• Developed Complex Security set up for end users with Supervisor.
• Trained super users how to create Webi reports using Business View Manger and also trained the users on using the Alerter, Prompts, etc.

Environment: Business Objects XI 4.0/XI R2, Buisness View Manager, Information Design Tool, Desktop Intelligence XIR2 Report Conversion Tool, SQL Server 2005/2008R2, Windows XP, and Windows 7

BO Consultant

Confidential, Harrisburg, PA

Responsibilities:

• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and universes.
• Involved in joining the tables by creating aliases to resolve the loop
• Modified reports according to the investment deals, facility and outstanding to know the exact
• Amount of net investment in each deal.
• Created new Objects (Measure, Dimension &Detail), classes and sub classes to meet the needs of end user requirements.
• Formatted the reports as per the business requirements.
• Prepared reports for deals, facility and outstanding for the information of expiry date and effective date of each category
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user
• Created BO reports containing multiple data providers and complex charts to present the end users with a better graphical representation of the data.
• 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, Unions and Intersection.

Environment: Business Objects XI3, Desktop Intelligence XI3, Designer, Oracle 10g/11i

BO Consultant

Confidential, Richardson, TX

Responsibilities:

• Interacted with Business Users and gathered Business Requirements and involved in Analysis & Documentation.
• Exposed the newly added columns for Business Objects Ad-Hoc reporting purpose.
• Created new Objects (Measure, Dimension &Detail), classes and sub classes to meet the needs of end user requirements.
• Involved in testing the developed Universes and Reports for final deployment.
• Interacted with end users and gave production support.
• Created reports for various Portfolios using the Universes as the main Data Provider.
• Used the Broadcast Agent console for auto scheduling of Business Objects Documents to perform tasks like refresh, print and save.
• Created BO reports containing multiple data providers and complex charts to present the end users with a better graphical representation of the data.
• Developed canned reports/Ad hoc Reports which run on weekly and monthly basis/User defined reports respectively.
• Extensively Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and Formulas etc and developed Hierarchies to support drill down reports.
• Trained the end user in basic and advanced Ad Hoc reporting as well as create queries, format results, and share them with others within the enterprise and beyond using Web Intelligence.
• Experienced in writing SQL * Plus Queries to test the Reports.
• Migrated several reports/universes/Security from BO XIR2 to XIR3 using Import Wizard and converted them to WEBI reports using Report Conversion tool.
• Generated web intelligence reports using business objects web intelligence to pop up in java server pages.
• Involved in migration and deployment of the universes and reports across different environments.
• Extensive Experience in Migration of reports, Universes, users, domains and groups from version 6.5 to XIR2 using Import Wizard.
• Thoroughly tested all the reports after migration as the calculation engine has few changes. All the contexts used in the reports were evaluated again after migration.
• Developed all kinds of reports such as, detail reports, cross-tab reports, sub reports and reports with charts.
• Involved in requirement gathering and specification modifications with Business Analysts.

Environment: Business Objects 6.5/ XIR3, Import Wizard, Sybase, Web Intelligence 6.5/XIR2, Crystal Reports, Designer, Supervisor, Informatica, Oracle 11i.

BO Consultant

Confidential, Baton Rouge, LA

Responsibilities:

• Installation, configuration, maintenance, technical support and troubleshooting of Business Objects
• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Managed existing Universes, created Classes, Objects and applied Hierarchies based on Business logic.
• Created Repository for BO development, created Universes and Complex Reports.
• Designed complex Web Intelligence and Desktop Intelligence Reports.
• Formatted the reports as per the business requirements.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Created complex reports using reporter module in Desktop/Web Intelligence functionalities like
• Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulae.
• Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard.
• Updated and maintained Universes based on changing user requirements and data source Changes.
• Extensively used designer to design various universes for different business groups.
• Worked extensively with the major functionalities of BO like Breaks, Sections, Group values
• Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Alerts in various reports according to user requirements.
• Involved in Importing/Exporting the Universes to repository to make it available to the users.
• Designed Universe for Ad-hoc reporting.
• Created users/user groups in CMC (Administration module).
• Upgraded Business Objects XI R2 to Business Objects XI 3.1.
• Implemented the ETL process and business logic by using PL/SQL.
• Developed universe user documentation guide for end users reference.
• Provided training for end users to generate their own reports including complicated reports.

Environment: Business Objects XI 3.1/3.0/R2, Designer XI, Crystal Reports, Web Intelligence XI, Desktop Intelligence, Designer, CMC, Xcelsius 2008, OLAP, BO Live office, MS Access, Windows 2003/XP, TOAD, RDBMS, VBA, SQL Server 2005/2008 Oracle10g, Data Modeling, SAP Business Objects suite.

Business Objects Consultant

Confidential, Collegeville, PA

Responsibilities:

• Involved in-group meetings to analyze business requirements by close interaction with the business analyst team, attending meetings with business sponsors.
• Expertise in gathering the business requirements and creating Universes in the Designer.
• Knowledge in resolving loops while designing the universe in Business objects universe designer.
• Created prompts for User-defined conditions, predefined conditions, which allow the Users to select a pre-select condition value when they are running the Queries.
• Interacted with the end users and developed reports as per user requirements
• Created Multi Dimensional analysis using Slice/Dice and Drill methods to organize the data along combination of “Dimension” and “Hierarchies” giving the ability to the end-users to observe data from various viewpoints
• Extensively used Decode statements and Designer Functions like @Aggregate Awareness, @prompt, @Date, @select, @where etc.
• Extensively used Calculations, Variables, Breaks, Sorting, alerts for creating Business Objects reports Automated Document Scheduling, Publishing and Distribution for WEBI and Info View clients, using the Broadcast Agent.
• Involved in performance tuning of reports/Universes, Confidential report level and Universes level respectively, that were running slowly.
• Involved in writing detailed level documentation for reports and Universe design.
• Interacted with the end users and provided Production Support.

Environment: Business Objects 6.5/XI R2 (Designer, Reporter, Broadcast Agent, Central Management Console (CMC), Desktop Intelligence, Import Wizard, Repository Migration Wizard, Web Intelligence, Oracle 9.0, PL/SQL, and Windows NT, BODI

Business Objects Developer

Confidential, NYC, NY

Responsibilities:

• Involved in all phases of Software Development Life Cycle (SDLC).
• Involved in working with Erwin tool for dimensional modeling such as star- schema and Snowflake schema.
• Migrated several reports/universes/Security from BO XIR2 to XIR3 using Import Wizard and converted them to WEBI reports using Report Conversion tool.
• Tested the universes and reports after migration and fixed migration issues related to universes and reports
• Involved in developing, designing and maintaining new and existing universes by creating join and cardinalities responsible for Creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Handled Embedded Functions like @Prompt, @Select and @Where in the Designer to handle
• User requests for report generators.
• Created Derived Tables, use Aggregate Awareness concept to increase the performance of the universe.
• Created Custom LOV’s (List of Values) and Custom Hierarchies for drilling down to lower levels in the reports
• Created ad-hoc reports using various Business Objects functionalities like alters, sorts, ranking, filters, breaks, sections, crosstab, and charts.
• Created complex reports using Calculation context operators like For Each, For All, and IN.
• 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 reports from multiple data providers like Universes, Free Hand SQL, Personal data files.
• Linked Summary report with Detail report in Web I using Info view in order to obtain detail information about an object contained in summary report.
• Used performance manager to build Dashboards and Score cards to provide the users with Visual representation of corporate data.
• Designed and developed various Metrics, Analytics like speedometer, Interactive Charts, Alerter and Goals for creating Dashboards using Dashboard Manager.
• Used parameters, Formulas, running totals and Crystal Functions to Convert Data according to the specification of the report.
• Worked on the Master, Kernel and Component approach during the linking of universes.
• Used Report Conversion Tool to convert the Deski reports into Webi and maintained the folders in the Info view.
• Built queries to retrieve data in SQL Server through a universe and set up query conditions.
• Managed the User Security Using the CMC.
• Defined various row and object level security for the Business Objects Users.
• Assigned broadcast agent to various groups using WebI Admin Console
• Created repository and security domain with user groups and security implementation.
• Developed Complex Security set up for end users with Supervisor.
• Trained how to create Webi reports using Info view (Java Report Panel) and also trained the users on using the Alerter, Prompts, etc.
• Providing Users Support to create ad-hoc reports on Webi and Excel (using Live Office).

Environment: Business Object XIR2/6.x/5.x Crystal Reports 2008/XIR2, Designer, Desktop Intelligence, Web Intelligence, Info View, CMC, CMS, Oracle 10g/9i/8i, SQL, PL/SQL, SQL Server 2008, TOAD, Erwin 6.1

Business Objects Reports Developer

Confidential

Responsibilities:

• Involved in report requirement gathering.
• Actively involved in the creation and modification of user/user groups and maintained user profiles using Supervisor.
• Designed and maintained Universes and exported them to the repository.
• Created Classes and Objects (Measure, dimension and detail) in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created reports using standard company templates. A few of them were created based on the department requirements.
• Extensive use of Business Objects functionalities in formatting reports.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Creating the reports in Web Intelligence using WebI Java Report Panel.

Environment: Business Objects (Designer, Business Objects, Supervisor) 6.1, Oracle 8, Windows NT.