We provide IT Staff Augmentation Services!

Business Objects Data Analyst Resume

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

Responsibilities:

  • 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.

Hire Now