Summary

• Business Intelligence Consultant with over 7 years of experience in Business Objects 4.1/4.0/XI R3.1/R2/6.5.
• About 7 years of experience in Business Objects tool such as Designer, Desktop Intelligence, Web Intelligence Rich Client, Info View, Performance Manager, Dashboard Manager, Central Management Console, Crystal Xcelsius 4.5/2008, Query as a Web Service, Data Source Migration Wizard, Central Configuration Manager, Report Conversion Tool, Live Office, Oracle 10g/9i/11g, SQL Server 2000/2005
• Experience in Installing and Configuring Business Objects XIR2/3.1 on Dev, Prod and Test servers
• Knowledge of Informatica ETL tool and development of Informatica mappings to extract, transform and load data
• Experience in Designing, Building and Maintaining the Universes, resolving the issues like loops and Traps using Alias and Context, designing complex objects using prompt, Aggregate aware function
• Worked on Web Intelligence to develop and publish thin client reports.
• In-depth knowledge in creation of WEBI reports and Dashboards using Crystal Xcelsius
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods
• Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live
• Good analytical and documentation skills with ability to communicate at all levels.
• Experience in creating Universes with Measures and Dimensions Objects, Join conditions, Filters, LOV's, Aliases, Contexts, Aggregate Awareness using Business Objects Designer
• Diversified experience in implementing Business Objects reporting applications.
• Ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly
• Experience in training Business Objects end users
• Efficient team player with excellent communication skills good interaction with users
• Excellent technical, logical and problem solving capabilities

TECHNICAL SKILLS

• BI Tools: Business Objects 6.5/XIR2/XIR 3.1/XI 4.0, BI Launchpad, Information Design Tool, Web Intelligence, Designer, Desktop Intelligence, InfoView, CMC, CCM, Import Wizard, Report Conversion Tool, Xcelsius 4.5/2008, QaaWS, Live Office, Data Services, Informatica 8.6.
• Database: SQL Server 2000/2005, Oracle 9i/10g/11g
• Operating Systems: Windows 98/2000/XP/NT/Vista, Linux, UNIX
• Languages: SQL, PL/SQL
• Other Tools: Microsoft Office, Toad 10.0/11.0, Teradata SQL Assistance, Atana.

Professional Experience

Confidential

Business Objects Data Analyst

Responsibilities:

• Create Web Intelligence reports using BI Launchpad.
• Worked on Web Intelligence rich client to modify reports locally.
• Resolved defects in the existing Web Intelligence reports.
• Used Assembla ticketing portal for tracking the defects in Webi reports.
• Created objects in the Universe in order to build new Webi reports and update the existing reports.
• Communicated effectively within the team to accomplish joint tasks.
• Used complex functions in the Webi reports to achieve the required data.
• Moved reports from one environment to another using promotion management tool.
• Worked with complex formatting such as hiding columns, alerters etc.
• Conducted unit testing as well as regression testing on reports.
• Update universe schema by adding tables and joins and updating the contexts.
• Used oracle analytical functions in the SQL queries to verify the data.
• Used multiple queries, sub-queries and rank functions to restrict the data on the reports and achieve the desired results.
• Used Atana tool to run queries against Teradata database and debug SQL code.
• Gathered requirements and created Adhoc reports for the business users.
• Distributed reports in the PDF format manually and also schedule reports for recurring requests.
• Communicated effectively on timely manner with the team and the end users.

Environment: Linux, Business Objects 4.1, Teradata, Informatica 9.0

Confidential

Business Objects Lead Developer

Responsibilities:

• Created .unx Universes using Information Design tool on a single source.
• Created relational and database connections for the universes.
• Created Cardinalities, Contexts, Joins, and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created Universe and reports based on Oracle data mart and data warehouse.
• Modified universe parameters to support data in multiple languages.
• Exported the business layers to the Repository to make resources available to the users.
• Worked with admin to make necessary changes on the BO server in order to support Multilanguage data in BI Launchpad and PDF.
• Created complex WEB Intelligence reports with multiple queries and variables.
• Participated in analysis and creation of data mart for Notices project.
• Used Promotion Management tool to migrate objects from one environment to another.
• Used formatting rules to highlight changes based on data.
• Inserted and modified data on Oracle database in Dev environment for unit testing.
• Worked as a team with external applications Curam, Connecture and ESB for integration with business objects application.
• Worked on CMC in creating users, groups and setting limits on instances etc.
• Managed Business objects Dev sever on Linux platform by running various scripts to shut down and restart the services.
• Regularly took backups of the objects by creating LCMBIAR files using promotion management tool.
• Created users and groups in CMC and assigned securities based on their role.
• Cleared logs regularly on the server and restarted tomcat server and other BO services whenever required.
• Cleared memory cache on timely basis on Linux server.
• Involved in sizing of BO server with BO admin and Business analyst.
• Worked on HP ALM and BMC remedy ticketing software to resolve defects.
• Mentored team mates, reviewed codes, assigned tasks and maintained the quality of work.

Environment: Linux, Business Objects 4.0, Oracle 11g, Informatica 9.0

Confidential

Sr. Business Objects Developer

Responsibilities:

• Involved in the designing and building of Universes, Classes and Objects for various projects.
• Created Cardinalities, Contexts, Joins, and Aliases for resolving Loops and checked the Integrity of the Universes.
• Exported the Universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created Derived tables in the Universe in order to do complex calculation.
• Created Universes by retrieving the data from various data sources, defining the connections necessary.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report
• Developed and deployed complex Webi reports
• Used various Webi functions for eg. ForceMerge, Foreach, In operators etc.
• Created links between Master and detail report for Drilling purpose using Opendoc function.
• Used Alerter in order to highlight the rows dynamically upon changes in the data.
• Interacted regularly with BA's and ETL team to develop Universe and reports.
• Worked under pressure and resolved UAT issues from power users.
• Used Import Wizard to move the Universe and Reports from Dev to Test.
• Regularly took back up of all the Universe and Reports by using Import Wizard.
• Updated views in the Oracle Database.
• Created new reports as well as updated complex reports in Web Intelligence.
• Worked on IMANY Contractsphere to validate data in the reports after completion of ETL process.

Environment: Linux, Business Objects 3.1, Oracle 11g, Informatica 9.0

Confidential

Business Objects Developer /Admin

• Provide technical support to resolve Production issues involving Web Intelligence Reports.
• Interaction with the Business Analysts, users and business leads to understand Business needs.
• Constant Interaction with users in going over the use cases for new Business needs and validation of the existing implementations.
• Creation and testing of complex reports and documentation of test cases and report specifications.
• Drill down the Analytics to the detail level data by a Web Intelligence Report.
• Involved in the extensive standards guidelines documentation.
• Created Derived tables in the Designer in order to avoid complex calculations at the report level.
• Created Aliases and Context to resolve loops, defined the cardinalities as defined in data model.
• Worked extensively with functions select, prompt, where to overcome the problems with database when integrating with business objects.
• Set up Aggregate Awareness to enhance the performance of SQL transactions.
• Updated Universes based on changing user requirements and data source changes.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts.
• Resolved issues related to RDBMS flaws such as Fan Trap, Chasm Trap using BO multi parse SQL functionality.
• Used OpenDoc function in WEBI to create a Parent-Child relationship for drilling into the detail data.
• Created WEBI Reports with multiple variables at report level to get , Average, variance etc values.
• Created Cascading List of values in the Universe to assist users in selection of parameters.
• Created Hierarchies according to the business rules for viewing data at selected level of detail.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc.
• Extensively worked with alerts, filters and conditions in Business Objects.
• Created templates to generate different styles of reports, which are not, belong to Business Objects standard documents.
• Tuned the reports for better performance using SQL.
• Created various 3D pie charts, Pie charts, Bar Charts, Line Charts.
• Regressional Testing of the reports in Dev and Test environment and Scheduling of reports in info view.
• Check the integrity of the Universes and export the universes to Repository for making available to users.
• Involved in Moving Universes and report from Dev to UAT and UAT to Pre-Prod using Import Wizard.
• Regularly took back of reports and Universe using Import Wizard and creating BIAR files.
• Interacted with Business Objects technical team to get the resolution of problems / bugs in Business Objects.
• Production support for Web Intelligence reports and Business Objects Universes.
• Validated the data and the joins in the Universe by running BO reports and exporting the output to the Excel Spreadsheets and again testing it against the data that was fetched from backend tables using TOAD/ PL SQL Developer/ Teradata Client.
• Created Users and Groups in CMC and also applied Row level Security in the Universe.
• Suggested implementation of security in CMC as per the requirement in one of the project.
• Migrated reports from one environment to another using Import wizard.

Environment: Business Objects 4.0/XIR 3.1, Crystal Reports 2008, Teradata, Oracle 10g.

Confidential

Business Objects Developer

Responsibilities:

• Worked on Business objects XI R2 and Oracle 10g
• Created specification documents for new reports and wrote test cases.
• Resolved defects in the existing Web Intelligence reports.
• Created Web Intelligence reports from scratch using Infoview.
• Created objects in the Universe in order to build new Webi reports.
• Communicated effectively within the team to accomplish joint tasks.
• Complex functions used in the reports and various logics built to assist the report integration with the portal.
• Moved reports from one environment to another using Import wizard tool.
• Used Query Builder tool to identify the CUID's in order to compare the reports within different environments.
• Worked with complex formatting such as hiding columns, sorting as per user input etc. Conducted unit testing's as well as integration testing's on reports.
• Provided intensive training to the onsite developers on Designer and Webi Infoview in XI R2.
• Used subqueries and analytical functions in the Universe objects to bring the required data.
• Used Derived table in the universe for complex calculations.
• Identified problems within the environments and suggested solutions to resolve them.
• Explained the best practices to be used in developments of Universes and reports.
• Created multiple queries in a single report to avoid Fan trap.
• Used Toad 10.6 to run queries against the database.
• Created Users, Profiles and User groups and implemented security.
• Updated server properties to fix the issues with the reports.

Confidential

Business Objects Specialist

Responsibilities:

• Worked on SAP's Business Objects 6.5 version and XI3.1.
• Generated reports using Business objects full client, Deski and Webi tool.
• Created reports for the users in the production environment for various departments such as Finance, Accounting and Purchases etc.
• Interacted continuously with the end users in understanding the requirements of the report and provided them with the best solutions to fit the need of the time.
• Properly managed time to complete the tasks to accomplish the targets as needed.
• Resolved issues in relation to the complex reports and made necessary changes wherever required.
• Used complex functions in the report to resolve the issues to meet the demand.
• Received appreciation on completion of the tasks from users on satisfaction of the end results.
• Worked with user defined objects and used them in the reports for analysis.
• Generated reports using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Migrated reports from Full client to Deski.
• Provided user training with respect to CMC and Infoview in XI3.1.

Confidential

Business Objects Developer

Responsibilities:

• Involved in the designing and building of Universes, Classes and Objects for investment management system.
• Created Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes.
• Exported the Universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Interacted with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Created Universes by retrieving the data from various data sources, defining the connections necessary. Generating various numbers of reports on a daily, weekly and monthly basis.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report
• Addressed Chasm trap and Fan Trap using Multi Parse SQL.
• Scheduled reports through CMC and InfoView.
• Developed and deployed complex Webi reports

Confidential

Business Objects Developer

Responsibilities

• Involved in Full project life cycle requirement gathering to implementation phase
• Involved in deployment of Business Objects XI R2.
• Created several Webi, Deski, Crystal Reports and Dashboards based on user requirements.
• Created Universes from scratch using Designer for various departments.
• Interacted with end users, regularly in order to generate the reports required. Various Business Object reporting functionalities were used such as Slice and Dice, Master/detail, User Response function and different Formulas.
• Responsible for designing and developing Universes for reporting purposes. Universes were created for post and pre analysis of the marketing data through in-house Structure Business Objects methodology.
• Created new Business Objects users and User Groups using Business Objects CMC Module.
• Worked on using the import wizard in moving reports and universes from Dev to UAT and to Prod environments
• Extensively used Designer to design various universes for different business groups, created classes, aliases, help text, simple reports and complex reports using cascading prompts
• Implemented row and object level security in Business Objects Designer module
• Familiar with Dimension modeling using Star Schema
• Managed the scheduling of reports, also involved in changing the document descriptions
• Created Slice and Dice, Drill down and Cross Tab reports
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.

Confidential

Business Objects Consultant

Responsibilities

• Created dashbords visualisations applications using Xcelsius.
• Extensively used Designer to design various Universes for different business groups.
• Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Developed reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers.
• Worked extensively with select, aggregate aware, where, and prompt to overcome the problems with database when integrating with Business Objects.
• Creating aliases, contexts and short cuts joins to resolving loops, cardinalities and integrity checks of the universe.
• Create User groups, Users, Database connections Manage user privileges, import/export of universes in Production environment
• Responsible for managing the Development, Testing and Production repositories
• Develop universe for the Sales and Marketing department to analyze sales and enable Marketing Team to make informed decisions
• Extensively worked with Web Intelligence InfoView and reporter for querying, reporting and analysis tasks.
• Used merge dimension, combined queries, multiple queries to bring multiple result sets into reports from multiple data providers/data sources.
• Resolve loop and cyclic dependencies with aliases and contexts
• Define aggregate SQL functions on measures to improve performance
• Address Chasm Trap and Fan Trap using Multi-Parse SQL
• Work on database connections, views, parsing of objects and hierarchies
• Design and develop standard reports and summary reports
• Generate List of Values LOV's from lookup tables
• Create restrictions on objects and classes based on universes privileges