Management Data

Rubeena Jabeen

******.***@*****.***

Cell: 917-***-****

PROFESSIONAL SUMMARY

Over 6 years of Experience in Business Objects 5.8x/ 6.5 xs/ XI R3/XIR2/XIR1 (Supervisor, Designer,

•

Desktop Intelligence, Web Intelligence, Info View, Crystal Reports, Xcelsius, Central Management

Console& Broadcast Agent).

Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing,

•

testing, Migrating, Administrating, security management and in production support.

Experience with Data Warehouse Concepts and Methodologies, Strong Knowledge with Star Schema

•

and Snow Flake Schema Data Models.

Experience in creating Universes with Dimensions, Detail & Measure object Join conditions, Filters,

•

LOV, @Prompt and Aggregate Awareness.

Expertise experience in resolving issues like loops and Chasm & Fan Traps using Alias and Context.

•

Extensive experience in Report Conversion projects from Deski to webi 5.8 to XI R3 & 6.5 to XI R3.

•

Extensive experience in Migration of Business Objects Reports, Universes & Users through Import

•

Wizard from 5.1.8, 6.5 to XI R2 /XIR3 .

Identified and road mapped the Business Requirements (functional & technical) with the Business users,

•

which acted as a base for the project initiation and implementation

Extensive experience in Building & managing Universe, Creating Complex Ad-hoc Reports and Canned

•

Reports. Experience in creating Folders, Groups, Users, assigning Privileges to users.

Experience in Creating Applications, Dashboards, Metrics, Rules and Analytics using Performance

•

Management XIR2 and Application Foundation6.5.

Experience in integration of various data sources like Oracle and SQL Server.

•

Involved in performance testing of reports, which helped in analyzing the performance before moving

•

into production.

Extensive Experience in Creating Deski & Webi Reports by various functionalities such as Drilldown

•

Reports, Slice & Dice Reports Sub Reports, Cross-tab Reports, On-Demand Sub Reports, Label

Reports, Chart Reports.

Experience in using multiple Data Providers like Universes and Personal Data Files for retrieving Data.

•

Expertise in Reports Scheduling, Event based Scheduling through Infoview, Central Management

•

Console / Broadcast Agent.

Created Dashboards using Application Foundation/Performance Management & by using Crystal

•

Xcelsius.

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.

Extensive experience interacting with Functional & Business Analysts, and different levels of users and

•

developers.

Able to work on own initiative or as part of a team, backed by excellent organizational and

•

communication skills along with the capability to solve problems as they arise.

EDUCATION

Bachelor’s in Computer Science, JNTU, India.

SKILLS PROFILE:

BI Business Objects 5.1.8,6.5/XI/XIR3(Supervisor, Designer, Reporter, Desktop Intelligence,

TOOLS Web Intelligence, Info View,CMC)Business Objects Live Office, Query as a web service,

Crystal Reports 2008 and Crystal Xcelsius 4.5, 2008.

RDBMS Oracle 11g,10g, 9i, 8i, MS SQL Server 2000, 2005,2008 MS Access, Toad.

Operating System Windows 95/98/NT/2000,2003/XP

PROFESSIONAL EXPERIENCE

Ernst & Young LLP.

Secaucus, NJ.

Business Objects Developer/Administrator. May 2011- Till date

• Involved in Migration & Conversion project, where I was involved in Migration of reports &

Universes from BO 6.5 to BO XIR3. Conversion of 123 reports from Deski 6.5 to Webi XIR3.

• Resolved issues after Migration & Conversion of reports such as # Format, # Error, Hyperlink

Data synchronization, Data type error, Multi-value error, resolved issues related to Invalid Month error.

Report header issues, Break header repeating issue, runtime & page number issues, Cross-tab issue as it

won’t be converted exactly how it is in deski,hidden block, hidden cell issues, Alerter issue, break on

objects won’t be converted,Global Filters issue these are common issues after conversion

• Created & Modified AD-Hoc & Canned Reports both in Deski & Webi .Such as

TAXAUDIT,BIOAUDIT,GLINTER,CASHFLOW,ANNPRFADV,PRFTXADV,TOP-HAT.Created new

reports also such as Global Spend Corp DOC 1- 6,Vendor Summary Spend, Accounting Details Report.

• Interacted with end user to modify the reports based on their requirements.

• Performed Report Scheduling & Event based scheduling based on the user requirement through

running batch files weekly, Monthly & Yearly.

• Worked on Installation of BOXI-R3 on UAT & QA & also upgraded service pack from 2 to 3 and

then 5 on all machines.

• Created data for Reports through third party tool POA Application.

• Created, manipulated, and updated crystal reports data using SQL, Access, Excel.

• Worked on Universe by creating Classes, Objects, Derived table, Date prompts, change the object

formats .Identified the issues in reports which were coming as invalid identifier and made the correction

in table names. Worked on user support and made changes as per requirements from Users and made

changes at Universe level.

• Experience in Creating Applications, Dashboards, Metrics, Rules and Analytics using Performance

Management XIR2 and Application Foundation6.5.

• Used TOAD for generating sql through Webi sql queries and running in Toad by which I can get

dummy data for reports.

Environment: Business Objects XIR3/5.1.8, 6.5 (Supervisor, Designer, Desktop Intelligence, and Web

Intelligence, Crystal Reports,CMC & Info view (SQL Server 2008, Oracle11g, Toadand Windows

XP),Xcelsius)

Structure Tone

New York, NY.

Role: Business Object Consultant Oct 2010- April 2011

Responsibilities:

Interacted with End Users regularly, in order to generate the reports required and to resolve the existing

•

issues.

• Provided training to end users in report development and running ad-hoc queries in business objects

• Worked on Migration and Conversion project from Deski 5.8 to Webi XI R3, Created & Modified

Desktop Intelligence 5.1.8 /XIR3 & Web-Intelligence Reports.

• Migrated reports from 5.1.8 version to 6.5 /XIR3 version using Import Wizard.

• Worked on after conversion issues such as # Multivalue error, break issues, header issues,# Format Date

issues,Global Filter,Hidden block and cells issue. Also worked on partially converted and not

converted reports.

• Designed and implemented the new security model for the BO 3.1 environment. Successfully

configured the Windows AD authentication and implement Single-Sign On functionality using Apache

web-server.

• Configured the Single Sign On functionality for the open-doc reports to access BO from third-party

applications.

• Documented the entire Installation and Migration procedure.

• Generated various reports on Daily, Weekly & Monthly Basis.

• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice,

Drill Down, Filters, Ranking, Sections, Graphs, Breaks & Variables

• Created Custom reports like Job Kit, Subcontractors by Job, Vendor Mail –Merge Report, Back Charge

Report, Delinquent Billing Report, Income Statement, Monthly Employee Utilization, A/R & AP

Reports, New Order Analysis Reports in response to user needs. Some of these reports are extremely

complicated and retrieve data from multiple data sources.

• Created custom List of Values (LOVs) for better understanding of prompts by the end users and created

complex reports by linking data from multiple data providers from different databases.

• Created Users, Groups & assign them rights to folders in Supervisor & also in CMC. Prioritize Security

levels for Users & Users Groups.

• Migrated reports, Universes & Users from 5.1.8 Supervisor to XIR3 through Import Wizard.

• Converted Deski Reports to Webi Reports through Report Conversion Tool.

• Created Classes & User objects in designing the universes. Defined Aliases & Contexts to resolve loops

in the universes.

• Performing BO Scheduling - monitoring for scheduled reports & error notification

Environment: Business Objects XIR3/5.1.8 (Supervisor, Designer, Desktop Intelligence, and Web Intelligence,

CMC & Info view (SQL, Oracle10g, OLAP and Windows XP)

AMALGAMATED BANK Dec 2009 – Aug 2010

New York, NY

Role: Business Objects Developer

Responsibilities:

• Created the Financial Risk Management Universe from scratch

• Created several Webi reports and also Dashboards for graphical presentation.

• Created critical visualization using Business Objects Crystal Xcelsius 2008 for the Business users.

• Used Crystal Report’s to feed data to Crystal Xcelsius Visualization and XML file as a data source.

• Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.

• Created a complex filters like YTD, MTD, QTD, @prompt, @where @select in the universe.

• Involved in Performance Testing of new and existing reports through Unit Testing, Integration Testing

and legacy testing of webi reports before sending it to production.

Resolved loops using aliases and contexts. Defined contexts when the loop occurs in the middle of the

•

schema and has several tables on the both sides. Developed objects with aggregate aware functions to

improve performance.

• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab,

Alerter and Formulae etc in rich client. Created several canned and ad-hoc Reports Using Business

objects user module.

• Designed and developed standard reports and summary reports.

• Linked reports in Web Intelligence using OPENDOC functions.

• Scheduled daily, weekly and monthly reports using BO XIR3 Scheduler using Events, creating

Calendars.

• Met with the Business Analyst, users and business leads to understand their needs Modified universes

and created reports for them accordingly.

• Migration of reports from XIR2 TO XIR3 using Import Wizard.

• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central

Management Console (CMC).

• Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web

Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination

Job Server, Program Job Server, and Event Server.

• Involved in the extensive standards & guidelines documentation.

• Involved in Creating Users and User Groups & assigning them Security privileges.

• Worked on Performance metrics, created multiple reports using Crystal Xcelsius.

• Created Multiple KPI (Key Performance Indicator) reports for Crash Analysis and various projects.

• Worked with Business Users and team leads to develop system requirements, analyze data Element and

continuous end-user support.

• Trained users how to work with info view, scheduling, saving document in PDF & Excel and accessing

reports.

Environment: Business Objects XIR2/XIR3, Desktop Intelligence, Web Intelligence, Info View, CMC &

Xcelsius.)

AETNA Feb 2008 – Jul 2009

Hartford, CT

Role: Business Objects Developer.

Responsibilities:

• Involved in Analysis, Requirements Gathering, and Functional & Technical specification, Development,

Deploying, QA Testing, and Training End Users.

• Created Universes from multiple data sources.

• Identified and road mapped the Business Requirements (functional & technical) with the Business

users, which acted as a base for the project initiation and implementation.

• Created Repository with multiple universe and document domains for Development and Test

Environments and distributed the BO Main key among the enterprise.

• Set up groups and users for Business Objects deployment. Managed user profiles using Supervisor and

Set object-level security and row level security restrictions, to restrict sensitive client.

• Created users and groups using Central Management Console (CMC) and assigned privileges to

different groups and users.

• Resolve the complex Chasm Traps by creating the alias. Resolve complex Fan traps by creating the

@aggregate aware functions. Involved in Star Schema customization/Design session.

• Created predefined conditions, prompts and custom hierarchies in the process of building the

universes .Exported the universes to dev, test and prod domains to make resources available to the users.

Created a complex report based on the merged dimensions and combined queries.

•

• Involved in the creation of various report formats including Master/Detail Reports, Sub Reports and

Cross Tab Reports.

• Created canned and ad-hoc Reports Using Business objects user module through Web-Intelligence &

Desktop Intelligence.

• Formatted the reports as per the Users requirements using all the facilities in Business Objects, which

allows the users to analyze the data.

• Scheduled the Reports and sent them in an email to the users in various formats like PDF, Excel etc

• Involved in performance testing of all the reports, which helped in analyzing its performance before

moving into production.

• Applied row level and object level securities to different groups and users in the designer wizard

• Migrated existing BO universes and reports to BOXIR3 using Import Wizard.

• Converted the existing full client reports to Webi docs using report conversion tool

• Created reports using both Deski and Webi with multiple data providers.

• Used QAAWS (Query as a Web Service) to feed data into Xcelsius 2008 to show product portfolio.

• Created dashboard by using Xcelsius retrieved data from Excel file by using Live Office.

• Created complex Xcelsius dash boards to reflect User Adoption Metrics.

• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML

files.

Environment: Business Objects XIR2 (Administrator, Designer, Reporter, Desktop Intelligence, Web

Intelligence, Xcelsius CMC & Info view), SQL Server 2005 & Windows 2003.

SILICON VALLEY BANK Oct 2006 - Dec 2007

Santa Clara, CA

Role: Business Objects developer

Responsibilities:

• Designed universe for the Financial Department to analyze the credit loss and credit recoveries which

helped the business users to make informed decisions.

Worked on conversion project from Deski to Webi from 6.5 to XIR2 .

•

WEBI/DESKI reports involving complex queries, sub queries, Unions and Intersection.Worked on

•

issues which came after conversion on partially converted reports break issues, multivalue error issues

Used Designer Module to design Universes, joining the tables, creating prompts and queries and applied

•

Contexts and Aliases to remove loops.

Addressed chasm trap and Fan Trap using Multi Parse SQL.

•

Used Designer functions like @Aggregate Aware to make use of aggregated table like year to date

•

employee information, Total Funds allotted to employee for Each Fiscal Year (FY) and @Prompt to

allow the users to enter the values like Pay period Number, Fiscal year and calendar year when

refreshing reports.

Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined

•

Conditions to use in Business Objects.

Created various drillable Webi reports.

•

Created ad-hoc reports with multi prompts to retrieve required data for the user and to minimize

•

unnecessary load on the server

Created Reports with heavy conditional formatting and functions to meet user requirement.

•

Customized the reports with custom functions and loops to leverage the user reporting needs.

•

Scheduled recurring daily, weekly and monthly reports (Webi, Deski, and Crystal Reports) in Info View

•

and used Calendar based scheduling for the reports custom dates.

Created various group based publications and distributed reports to the users.

•

• Involved in Testing of Crystal & Webi Reports once it has been exported in to crystal and Webi.

• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the

report.

• Interacted with the users to analyze the changes for improvement they need in existing reports and

develop the reports to satisfy their needs and requirements.

• Created several Cross Tab Reports and Sub Reports.

• Prepared user documentation for hands on training for end user community.

Environment: Business Objects XIR2 (Administrator, Designer, Reporter, Desktop Intelligence, Web

Intelligence, CMC, Info view) Oracle 9i, OLAP, Windows 2003).

BRIGHT STAR Jul 2005 - Aug 2006

Rolling Meadows, IL

Role: Crystal Reports Developer

Responsibilities:

• Created Crystal Reports using Formulas, Grouping, Parameters and Static/Dynamic Cascading

Prompts to handle the customer's requests from Tables, Stored Procedures and Views.

• Involved in Installation, Configuration, and Deployment of whole Crystal Enterprise Suite.

• Published Crystal Reports on Crystal Enterprise - Portal, the Intranet Web and tested their performance.

Involved in performance tuning and Data Quality of Crystal, Business Objects Full Client and Used

Import Wizard for the Crystal and Business objects Migration process to migrated users, universes,

reports, securities in to XI R2.

• Worked with Crystal Enterprise and Management Console for scheduling reports, implementation of

security at Report level, Folder level and object level by assigning rights and required access level as per

business requirement.

• Developed various Charts and Graphs like Bar Chart, Line charts, Pie Charts etc by using Chart Expert.

• Developed Cross Tab Reports, Sub Reports, and Parameters.

• Developed heavy formatted, complex reusable formula reports and reports with advanced features such

as conditional formatting, multiple grouping reports.

• Analyzed and tuned complex Queries, Stored Procedures for faster execution and developed database

structures.

• Several Reports using Parameter fields were developed to let the users enter values to the reports in

order to filter the records based on their needs.

• Created ad-hoc enterprise reports using SQL Reporting Services.

• Gathered user requirements, drafted specifications, designed and deployed reports using Crystal

Reports, Designer and Crystal Enterprise.

Environment: Business Objects XIR2/ (Designer, Web Intelligence, Info View, Crystal Reports, CMC) SQL,

Oracle 9i, Windows 2003)

MARATHON OIL, May2004 - Jun2005

Houston, Texas

Role: Business Object Developer

Responsibilities:

Involved in Full project life cycle (requirement gathering to implementation phase).

•

• Worked very closely with upper management to get detailed information on what information they

require in each report

• Created/Modified Universes and linked with the existing Universes with Oracle backend and exported

to repository.

• Created Users and implemented security features.

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

• Various ad hoc reports were created using User module in Business Objects according to the given

requirements.

• Extensively used Designer to design various universes for different business groups. Created classes,

aliases, simple reports and complex reports using cascading prompts, decode objects, etc.

• Implemented row and object level security in business objects supervisor module.

• Worked with Dimension modeling using Star Schema (ROLAP).

• Managed the scheduling options stored in the repository and also involved in changing the document

descriptions.

• Created Business Objects reports, Queries with constant interaction with the end users.

• Trained end users in understanding the reports.

Environment: Business Objects 5.1.8 (Supervisor, Designer, Web Intelligence, Desktop Intelligence), MS

access, Oracle 9i, SQL, Windows 2000.

Contact this candidate