We provide IT Staff Augmentation Services!

Sr. Business Objects Resume

Whitehouse Station, NJ

SUMMARY:

  • I have almost 6 years of experience in Business Intelligence industry with intensive focus on Business Objects XI R3/R2/6.5, Universe Designer, Desktop Intelligence, Web Intelligence, Info View, Dashboard, Scorecards, Central Management Console, Crystal Reports/XI,10,9,8, Xcelsius 4.5/2008, Oracle 10g/9i, SQL Server 2000/2005/2008 and Access
  • Experience using SQL, PL/SQL, TOAD Developer
  • Expertise in gathering the business requirement and building Universes, free hand SQL methods and creating complex ad-hoc reports
  • Performed Business Objects administration tasks including user creation and assigning user rights and permission to Universe, connection, reports and folders
  • Installed, maintained and administered Business Objects XI 3.1 in clustered environment with high volume of concurrent users
  • Performed migration of universes, reports and users security between environments
  • Deployed BO 4.0 in test environment
  • Worked on several projects from Requirement gathering to Training End-User
  • Extensive Data warehousing experience and implemented dimensional model using Star and Snow Flake Schema
  • Designed various Universes, Ad-hoc/Canned Reports and Dashboards
  • Articulate with Excellent Communication skills with the ability to work under Tight Schedules
  • Created Analytics and performance management dashboards using Xcelsius to perform comparative analysis of current and historical performance against established targets
  • Built Xcelsius Dashboard using both Qaaws, BI Services and Live Office

EXPERIENCE:

Confidential, Whitehouse Station, NJ Sep 10 - Present
Sr. Business Objects Developer

Responsibilities:

  • Gathered requirements from business users and built the detailed design document, functional requirement specification documentation, mapping document and UAT scripts
  • Designed and developed universes as per the requirements by carrying out the dimensional data modeling for the data warehouse
  • Designed, developed, modified and maintained Business Objects universe using Designer for ad hoc and canned reports
  • Created joins, indicating cardinalities, checked integrity of the universe and resolved loops and traps using aliases and contexts
  • Created Hierarchies, complex objects using various @functions, Aggregate objects in the universe.
  • Designed cascading prompts in the universe to filter the list of account names based on the business units.
  • Extensively used Report Conversion tool to convert DeskI reports to WebI reports
  • Created users, users groups and maintained user access rights for BO universes and reports
  • Scheduled various reports using InfoView
  • Created variables using complex formulas at report level
  • Generated reports using prompts, filters and conditions and testing these reports with all possible data for consistency
  • Created and maintained Business Objects reports in Web Intelligence Info View
  • Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality
  • Created Complicated Formulas and Running totals on summarized totals for Business Measure Calculations based upon various End-User Requirements.
  • Worked on various backend Procedures and Functions using TSQL
  • Created Parameter driven reports to restrict volume of data and to make the report user friendly so that user can retrieve data according to their needs
  • Created multiple complex canned reports and ad-hoc reports using DeskI and WebI
  • Used import wizard to migrate the Business Objects contents between environments from Dev to Test to Stage to Prod server
  • Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
  • Created Universes by defining connections and retrieving data from database
  • Performed Report data validation using free hand SQL
  • Setting up object level and row level securities on the universes to various groups and users
  • Resolved issues like loops by creating aliases and contexts as required to remove the cyclic dependencies
  • Worked closely with Infrastructure groups to identify and resolve system problems.
  • Created New Users in CMC as per the Business requests.
  • Involved in creating the Security model for the Business User's
  • Used QaaWs (Query as a Web Service), Live office and BI Services as a data source to create Xcelsius dashboards
  • Used Erwin as a Data modeling tool
  • Provided training to the business users for basic and advanced reporting skills

Confidential, New York, NY Aug 09 - Sep 10
Role: Business Objects Developer/Administrator

Responsibilities:

  • Created universes using Business Objects Designer & Created reports using Web Intelligence Rich Client and Java InfoView
  • Installed and configured Business Objects XIR 3.1 in a clustered environment
  • Created a wide variety of advanced reports of varying complexity including slice and dice, drill down, cross tab, multiple data-providers, multiple table/section and master detail type reports
  • Extensively used the @Functions, and Aggregate Awareness feature
  • Import and Export the Universe in various Universe Domains
  • Created Users, User groups and assigned privileges to access and work with Universes and Reports
  • Implemented row and column level security in the Universe & Reports for confidentiality
  • Used Migration Tool / Import Wizard to migrate the Universes, BO Reports, WebI Reports and Users from BOXI R2 to BO XIR3 and also resolved the Issues that resulted from the Migration
  • Created Classes, Objects and also tested them to ensure the accuracy of the data model
  • Created List of Values in the Universe Dimension Objects for specific report requirements
  • Resolved loops in the Universe by creating Aliases and Contexts
  • Created reports using @Prompt Function and defined various Formula Variables
  • Schedule the Reports by mapping to the Production Server, using the Business Objects XI R3, CMC
  • Worked with End Users/ Analyst to gather the requirements for Universes & Reports Development.
  • Translated the requirements into high level design documents. Also prepared granular technical design documents.
  • Created annual and quarterly finance reports of the Client in Crystal Reports 2008
  • Developed several Complex Reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
  • Worked on complex reports that require sub-reports, multiple groups and conditional display of sections, fields, and messages
  • Involved in ETL Process using Data Integrator.
  • Created Metrics and Dashboards using Application Foundation.
  • Designed and Developed Xcelsius dashboards / analytics and exported to several formats.
  • Created Xcelsius dashboard used single value, selector, mapped, chart, background, collaboration and text components
  • Created powerful presentation using Xcelsius tool with Live Office and Qaaws as data source

Confidential, New York, NY May 08 - Jul 09
Role: Business Objects consultant

Responsibilities

  • Created templates for standardizing reports using company logo, header and footer settings, color coding, fonts and maintained consistency in viewing cross-tabs, blocks in report
  • Created complex objects to manipulate the data by using database specific functions to fulfill the reporting requirements
  • Synchronized reports using data from multiple data providers in Web Intelligence by merged dimensions functionality
  • Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports
  • Suggested modifications in Universe in existing objects or creating newer objects which are necessitated from Reporters perspective.
  • included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports
  • Created highly formatted Web intelligence reports
  • Used @Functions such as @Prompt- to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
  • Distributed documents inside and outside of the business using CMC and administration for scheduling the reports (like REP, PDF, EXCEL, TEXT and HTML format)
  • Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters

Confidential, New York, NY Jun 07 - May 08
Role: Business Objects Developer

Responsibilities:

  • 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 incorporate business logic into the Universe
  • Organized data in the reports by using Filters, Sorting, Ranking and highlighted data using Alerter
  • Created aliases, contexts and short cuts joins to resolve loops
  • Performed cardinalities and integrity checks of the universe
  • Set up Aggregate Awareness to improve performance
  • Tuned the reports for better performance using SQL
  • Defined Business Objects and database structure based on the functional specifications and user requirements
  • Created, maintained and performed enhancement of Universe using Designer
  • Created various universe using Linked universe feature to answer various business questions
  • Created users and assigned them rights and privileges using Central Management Console
  • Analyzed Erwin Data Model to identify the relationship
  • Extensively used CMC Module for managing user and group security
  • Created several Webi reports, Deski reports and Dashboard reports for graphical presentation
  • Conducted Business Objects and Web Intelligence training session to train the users.
  • Interacted with Latin America Support team members and database administrators to coordinate updates and upgrades in repository and databases

Hire Now