Data Manager
Resume:
siraj
********@*****.***
A results-driven, dedicated professional with solid experience in the
Business Objects
Summary
o Business Intelligence Consultant with 7 years of experience in
Business Objects 6.5/XIR2/XIR3.1, Xcelsius 4.5/2008
o Above 6 years of experience in Business Objects 4.0/XI R3.1/R2/6.5,
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
o Experience in Installing and Configuring Business Objects XIR2/3.1 on
Dev, Prod and Test servers
o Worked with SAP Business Objects Data Services XI 3.0 ETL tool
o Developed Business Object Integrator jobs to extract, transform and
load data
o 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
o Worked on Web Intelligence to develop and publish thin client reports.
o In-depth knowledge in creation of WEBI reports and Dashboards using
Crystal Xcelsius
o Expertise in retrieving data using Business Objects Universes,
personal data files, stored procedures and free hand SQL methods
o 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
o Good analytical and documentation skills with ability to communicate
at all levels.
o Experience in creating Universes with Measures and Dimensions Objects,
Join conditions, Filters, LOV's, Aliases, Contexts, Aggregate
Awareness using Business Objects Designer
o Diversified experience in implementing Business Objects reporting
applications.
o Ability to work in groups as well as independently with minimum
supervision and initiative to learn new technologies and tools quickly
o Experience in training Business Objects end users
o Efficient team player with excellent communication skills; good
interaction with users
o Excellent technical, logical and problem solving capabilities
TECHNICAL SKILLS
o BI Tools: Business Objects 6.5/XIR2/XIR 3.1, Web Intelligence,
Designer, Desktop Intelligence, InfoView, CMC, CCM, Import Wizard,
Report Conversion Tool, Xcelsius 4.5/2008, QaaWS, Live Office, Data
Services, Informatica, Information Design Tool.
o Database: SQL Server 2000/2005, Oracle 9i/10g/11g
o Operating Systems: Windows 98/2000/XP/NT/Vista, Linux, UNIX
o Languages: SQL, PL/SQL
o Other Tools: Microsoft Office, Toad 10.0/11.0, Teradata SQL
Assistance.
Education
o Bachelor of Commerce in Business and Accounting.
Professional Experience
Forest Laboratories, Inc New York, NY
June 2012 - Till Date
Business Objects Developer
Responsibilities:
o Involved in the designing and building of Universes, Classes and
Objects for various projects.
o Created Cardinalities, Contexts, Joins, and Aliases for resolving
Loops and checked the Integrity of the Universes.
o Exported the Universes to the Repository to make resources available
to the users.
o Created reports for various Portfolios using the Universes as the main
Data Providers.
o Created Derived tables in the Universe in order to do complex
calculation.
o Created Universes by retrieving the data from various data sources,
defining the connections necessary.
o Created predefined conditions in the universe level to restrict the
volume of data to be pulled in the report
o Developed and deployed complex Webi reports
o Used various Webi functions for eg. ForceMerge, Foreach, In operators
etc.
o Created links between Master and detail report for Drilling purpose
using Opendoc function.
o Used Alerter in order to highlight the rows dynamically upon changes
in the data.
o Interacted regularly with BA's and ETL team to develop Universe and
reports.
o Worked under pressure and resolved UAT issues from power users in no
time.
o Used Import Wizard to move the Universe and Reports from Dev to Test.
o Regularly took back up of all the Universe and Reports by using Import
Wizard.
o Updated Views in the database.
o Provided production support and resolved production issues after go-
live.
o Updated report design documents and uploaded on the sharepoint.
FedEx World Headquarters, Memphis TN
Jan 2012 - May 2012
Business Objects Developer /Admin
o Provide technical support to resolve Production issues involving
Web Intelligence Reports.
o Interaction with the Business Analysts, users and business leads
to understand Business needs.
o Constant Interaction with users in going over the use cases for
new Business needs and validation of the existing
implementations.
o Creation and testing of complex reports and documentation of
test cases and report specifications.
o Drill down the Analytics to the detail level data by a Web
Intelligence Report.
o Involved in the extensive standards & guidelines documentation.
o Created Derived tables in the Designer in order to avoid complex
calculations at the report level.
o Created Aliases and Context to resolve loops, defined the
cardinalities as defined in data model.
o Worked extensively with @functions (@select, @prompt, @where) to
overcome the problems with database when integrating with
business objects.
o Set up Aggregate Awareness to enhance the performance of SQL
transactions.
o Updated Universes based on changing user requirements and data
source changes.
o Prepared different report layouts and blocks like Tables, Cross
Tabs and Charts.
o Resolved issues related to RDBMS flaws such as Fan Trap, Chasm
Trap using BO multi parse SQL functionality.
o Used OpenDoc function in WEBI to create a Parent-Child
relationship for drilling into the detail data.
o Created WEBI Reports with multiple variables at report level to
get %, Average, variance etc values.
o Created Cascading List of values in the Universe to assist users
in selection of parameters.
o Created Hierarchies according to the business rules for viewing
data at selected level of detail.
o Created the reports using Business Objects functionalities like
Queries, Slice and Dice, Drill down, @Functions, Cross Tab,
Master/Detail and Formulas etc.
o Extensively worked with alerts, filters and conditions in
Business Objects.
o Created templates to generate different styles of reports, which
are not, belong to Business Objects standard documents.
o Tuned the reports for better performance using SQL.
o Created various 3D pie charts, Pie charts, Bar Charts, Line
Charts.
o Regressional Testing of the reports in Dev and Test environment
and Scheduling of reports in info view.
o Check the integrity of the Universes and export the universes to
Repository for making available to users.
o Involved in Moving Universes and report from Dev to UAT and UAT
to Pre-Prod using Import Wizard.
o Regularly took back of reports and Universe using Import Wizard
and creating BIAR files.
o Interacted with Business Objects technical team to get the
resolution of problems / bugs in Business Objects.
o Production support for Web Intelligence reports and Business
Objects Universes.
o 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.
o Created Users and Groups in CMC and also applied Row level
Security in the Universe.
o Suggested implementation of security in CMC as per the
requirement in one of the project.
o Migrated reports from one environment to another using Import
wizard.
Environment: Business Objects 4.0/XIR 3.1, Crystal Reports 2008,
Teradata, Oracle 10g.
Standard and Poor's, New York, NY
Aug 2011 - Jan 2012
Business Objects Developer
Responsibilities:
o Worked on Business objects XI R2 and Oracle 10g
o Created specification documents for new reports and wrote
test cases.
o Resolved defects in the existing Web Intelligence reports.
o Created Web Intelligence reports from scratch using Infoview.
o Created objects in the Universe in order to build new Webi
reports.
o Communicated effectively within the team to accomplish joint
tasks.
o Complex functions used in the reports and various logics
built to assist the report integration with the portal.
o Moved reports from one environment to another using Import
wizard tool.
o Used Query Builder tool to identify the CUID's in order to
compare the reports within different environments.
o 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.
o Provided intensive training to the onsite developers on
Designer and Webi Infoview in XI R2.
o Used subqueries and analytical functions in the Universe
objects to bring the required data.
o Used Derived table in the universe for complex calculations.
o Identified problems within the environments and suggested
solutions to resolve them.
o Explained the best practices to be used in developments of
Universes and reports.
o Created multiple queries in a single report to avoid Fan
trap.
o Used Toad 10.6 to run queries against the database.
o Created Users, Profiles and User groups and implemented
security.
o Updated server properties to fix the issues with the reports.
Mckinstry Co., Seattle, WA
April 2011 - Aug 2011
Business Objects Specialist
Responsibilities:
o Worked on SAP's Business Objects 6.5 version and XI3.1.
o Generated reports using Business objects full client, Deski and Webi
tool.
o Created reports for the users in the production environment for
various departments such as Finance, Accounting and Purchases etc.
o 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.
o Properly managed time to complete the tasks to accomplish the targets
as needed.
o Resolved issues in relation to the complex reports and made necessary
changes wherever required.
o Used complex functions in the report to resolve the issues to meet the
demand.
o Received appreciation on completion of the tasks from users on
satisfaction of the end results.
o Worked with user defined objects and used them in the reports for
analysis.
o Generated reports using Business Objects functionality such as Slice
and Dice, Master/detail, User Responses and Formulas.
o Migrated reports from Full client to Deski.
o Provided user training with respect to CMC and Infoview in XI3.1.
UBS Financial Services, Inc Newtown, PA Feb 2010
- March 2011
Business Objects Developer
Responsibilities:
o Involved in the designing and building of Universes, Classes and
Objects for investment management system.
o Created Cardinalities, Contexts, Joins, External Strategies and
Aliases for resolving Loops and checked the Integrity of the
Universes.
o Exported the Universes to the Repository to make resources available
to the users.
o Created reports for various Portfolios using the Universes as the main
Data Providers.
o 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.
o 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.
o Created predefined conditions in the universe level to restrict the
volume of data to be pulled in the report
o Addressed Chasm trap and Fan Trap using Multi Parse SQL.
o Scheduled reports through CMC and InfoView.
o Developed and deployed complex Webi reports
o Utilized Data Service Designer for designing the ETL jobs.
o Developed data integration for batch and real time data movement.
o Defined database stores and file formats to connect to the source or
target design.
o Developed simple and complex transformations in Data flows.
o Created Workflows using object library and tool pallet to execute data
flows.
o Implemented the conversion and mapping rules as per client
requirements.
o Extracted data from various legacy data sources according to the
program specifications transformed the data and properly loaded to the
specified destinations.
Children's Hospital & Medical Centre, Omaha, NE Oct 2008 -
Dec 2009
Business Objects Developer
Responsibilities
o Involved in Full project life cycle (requirement gathering to
implementation phase)
o Involved in deployment of Business Objects XI R2.
o Created several Webi, Deski, Crystal Reports and Dashboards based on
user requirements.
o Created Universes from scratch using Designer for various departments.
o 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.
o 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.
o Created new Business Objects users and User Groups using Business
Objects CMC Module.
o Worked on using the import wizard in moving reports and universes from
Dev to UAT and to Prod environments
o Extensively used Designer to design various universes for different
business groups, created classes, aliases, help text, simple reports
and complex reports using cascading prompts
o Implemented row and object level security in Business Objects Designer
module
o Familiar with Dimension modeling using Star Schema
o Managed the scheduling of reports, also involved in changing the
document descriptions
o Created Slice and Dice, Drill down and Cross Tab reports
o Used the formatting options like cross tab representation, section
breaks, data sort options, calculations, font, colors, etc.
AETNA, Hartford, CT Nov 2007 -
Aug 2008
Business Objects Consultant
Responsibilities
o Created dashbords\visualisations applications using Xcelsius.
o Extensively used Designer to design various Universes for different
business groups.
o Created classes, aliases, help text, simple reports and complex
reports using cascading prompts, decode objects, etc.
o Developed reports using filters, prompts, sorts, groups, subtotals,
free hand SQL and multiple data providers.
o Worked extensively with (@select, @aggregate aware, @where, and
@prompt) to overcome the problems with database when integrating with
Business Objects.
o Creating aliases, contexts and short cuts joins to resolving loops,
cardinalities and integrity checks of the universe.
o Create User groups, Users, Database connections; Manage user
privileges, import/export of universes in Production environment
o Responsible for managing the Development, Testing and Production
repositories
o Develop universe for the Sales and Marketing department to analyze
sales and enable Marketing Team to make informed decisions
o Extensively worked with Web Intelligence InfoView and reporter for
querying, reporting and analysis tasks.
o Used merge dimension, combined queries, multiple queries to bring
multiple result sets into reports from multiple data providers/data
sources.
o Resolve loop and cyclic dependencies with aliases and contexts
o Define aggregate SQL functions on measures to improve performance
o Address Chasm Trap and Fan Trap using Multi-Parse SQL
o Work on database connections, views, parsing of objects and
hierarchies
o Design and develop standard reports and summary reports
o Generate List of Values (LOV's) from lookup tables
o Create restrictions on objects and classes based on universes
privileges
Federal Home Loan Bank, New York, NY June 2006 -
Sep 2007
Business Objects Developer
Responsibilities
o Drill down the Analytics to the detail level data either by another
Analytic or by a Web Intelligence Report.
o Involved in the extensive standards & guidelines documentation.
o Design the dashboard application with multiple dashboards as required
as per the security requirements.
o Extensively involved in using of formula fields, parameter fields,
Group selection and record selection in Crystal reports.
o Created Derived tables in the Designer to enhance performance of the
universe.
o Created Aliases and Context to resolve loops, defined the
cardinalities as defined in data model.
o Analyzed existing database and Designed Universe by using BO 6.5
Designer Module
o Created Classes, Dimension objects, Measure objects and Detail objects
in the universe
o Resolved issues related to RDBMS flaws such as Fan Traps, Chasm Traps
using BO multi parse SQL functionality
o Analyzed data using Slice/Dice and Drill Mode
o Prepared different report layouts and blocks like Tables, Cross Tabs
and Charts
o Combined Budget with actual data Spreadsheet from Oracle using Linking
Feature
o Created and Published Reports through Web Intelligence, Info view
portal
o Checked Universes for Integrity and exported them to the Repository to
make resources available to the users and groups.
o Updated and maintained Universes based on changing user requirements
and data source changes
o Used Alert in various reports according to user requirement
o Created templates to standardize the structure of corporate documents
o Exported universes to repository
Contact this candidate