Experience Summary:

7+ years of experience as Business Objects Developer

3+ years of experience as Xcelsius Developer
Experienced in Data Modeling, Star/ Snowflake schema modeling, Fact and Dimension Tables,
Physical and Logical data modeling using Erwin 7.2/4.0/3.5, Toad Data Modeler, Microsoft Visio.
In depth knowledge of designing Entity Relationship and Data Flow Diagram for Business
processes. Strong understanding of data modeling and dimensional modeling concepts like
Slowly Changing Dimensions.
Sound Experience in designing, development and deployment of complex Universes.
Migrated existing BO universes and reports to BOXI using Import Wizard
Sound Knowledge in SAP Integration
Experience in creating Universes with measures and dimensions objects, Join conditions, Filters,
LOV, Cardinality, Aliases, Contexts, and Aggregate Awareness usingBusiness Objects Designer.
Worked on of new features of Business Objects XI including Index awareness, Derived tables
and Central Management Console(CMC)
Performance Tuning and Optimization of BO reports at all levels.
Worked with Crystal Reports 2008/XI for creating complicated reports including sub-reports,
parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports,
analysis reports and data reports.
Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph
Reports by using Chart expert of Crystal Reports.
Worked extensively on various Business Objects functionalities like Queries, Slice and Dice,
Cross Tab, Master Detail, Breaks, Alerts, Filters, Sorts, Ranking, Prompts, and Calculations.
Worked in both ad-hoc and complex report environments.
Technical proficiency in creating interactive dashboard and scorecards using Xcelsius and
Performance manager
Used Live Office and QaaWS (Query as a Web Service) to feed live data into Xcelsius 2008 to
show product portfolio.
Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and
XML files.
Expertise working with Data Integrator 6.5.1/XI Designer creating DI Workflows and Jobs and
executing them in Dev and Test Environments.
Technical Skills
BI Tools

ETL Tools
Databases
Programming
Data Modeling
Operating Systems

Business Objects XI3.1/XI3.0/XIR2/6.x/5.x, Universe Designer, Web Intelligence,

Desktop Intelligence, Infoview, CMS, CMC, Live Office, Import Wizard, Report
Conversion Tool and QaaWS, Crystal Reports 2008/XI/X, Xcelsius 2008,
Dashboard Builder, Predictive Workbench 3.1/3.0,Bex Query Analyzer,
Broadcast Agent Server
Data integrator XI, SAP BW 7.0, 3.5
Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, MySql 5.1, IBM DB2, MS
Access
C, C++, JAVA, VB.NET,SQL, PL/SQL, HTML, UML, XML, SQL*Plus
Erwin, Microsoft Visio, Toad Data Modeler
Windows XP/NT/2000/98/95, Windows 2003,Solaris 10,UNIX

Professional Experience
Union Bank of California, San Francisco, CA
Business Objects Developer
Union Bank of California is one of the 30 largest commercial banks in United States with over 230
branches spread across the states of California, Washington and Oregon. I was part of Credit Portfolio
Information Services (CPIS) team working out of San Francisco. The job of our team was to provide
customer credit performance information to various users which included many of the senior executives
and higher management.
Responsibilities:
Part of Credit Portfolio Information Services (CPIS) team directly coordinating with high-end user
to gather the new requirements and working with existing issues.
Responsible for the System Study & Business Requirements Analysis & Documentation.
Actively worked with the end users in finalizing the Functional Specifications. Created detailed
Technical Specifications for each mapping based on these Functional Specs.
Worked directly for Chief Credit Officer (CCO) and given solution of complex Analysis in shape of
Rating Agency and Board Materials.
Projects successfully implemented in production under ICRS are Non-Performing Analysis,
Homebuilders and Credit Management Package.
Designed & Implemented security architecture for Credit Reporting System.
Involved in Data Modeling and Oracle Database
Designed Universes for Integrated Credit Reporting System.
Created various User defined objects including Dimensional, Detail, and Measure objects and
tested them to ensure correct mapping of data.
Improved the performance and reduced the coding with the use of @functions (@aggregate
aware, @select, @prompt, @where).
Resolved Chasm, Fan traps and Loop problems.
Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results
are retrieved.
Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins
parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after
any modifications to them in terms of structure, classes, and objects.
Prepared complex reports like Financial reports, HR reports, Standard and Ad-hoc reports using
Web Intelligence 3.1, Desktop Intelligence 3.1 and Crystal Reports 2008
Created reports based on General Ledger, Credit Product Group and Market Segment
categories
Created many reports according to the loans, commitments and outstanding to know the exact
amount of change in each loan
Created reports like Residential and Business Customers reports.
Created reports like Reports by Period, Demographic reports and Comparative Reports.
Generated various reports on Daily, Weekly, Monthly and Yearly basis.
Used Xcelsius to Visualize and to enhance the data presentation along with developing dynamic
charts and graphics.
Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the
users reporting needs.

Involved in performance tuning and optimization on Business objects Universes by creating

Aggregate tables.
Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
Installed, Configured and Administered Business Objects products.
Carried on Upgradation from Business Objects XI 3.0 to 3.1
Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool
Implemented Security Features of Business Objects like row level, object level and report level to
make the data secure.
Generated the Business Objects reports involving complex queries, sub queries, Unions and
Intersection.
Performed unit testing, system testing and user acceptance test (UAT) for universe, reports and
security management.
Developed universe user documentation guide for the end users reference

Environment: Business Objects XI 3.1/3.0, Crystal Reports 2008 SP3, Import Wizard, Conversion Tool,
Web Intelligence XI 3.1, Desktop Intelligence XI 3.1, Xcelsius 2008 SP3, Designer, Info View, Toad 9.0,
Oracle 10g, SQL, PL/SQL and Windows XP.

Silicon Valley Bank, Santa Clara, California

Business Objects Developer
The Risk Reporting Warehouse (RRW) is one of the major data ware house of the Finance Target
Platform and key to our ability to deliver various Finance Programs. The project revolves around creating
universes and reports for their Online Financial Portal. Reports such as Company Revenue, Department
Revenue, Profit by Year etc. The data was divided into 5 hierarchical sections: Daily, Weekly, Monthly,
Quarterly and Yearly. Final phase is migration from Business Objects XI R2 to Business Objects XI 3.0.
Responsibilities :
Interacted with Business Users and Business Analysts to gather and document the Requirements
and translate these to Technical specifications for Designing Universes.
Created several Universes using Designer according to the Requirement.
Improved the performance and reduced the coding with the use of @functions (@aggregate
aware, @select, @prompt, @where).
Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the
users reporting needs.
Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results
are retrieved.
Exported the universe to the Repository to make resources available to the users.
Scheduled the universes on daily wise, monthly wise and weekly by using Scheduler
Updated and maintained existing Universes based on changing user requirements and based on
changes in data source.
Applied row level and object level securities on different groups and users.
Created several Webi reports, Deski reports and Dashboard reports for graphical presentation.
Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).

Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the
unwanted data to be displayed on the report.
Developed reports by linking different data providers in a single report, and made all possible
incompatible objects as compatible by merging the common objects.
Used multi dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a
combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view
the data from heterogeneous viewpoints.
Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts,
List of values (LOV), Pre-defined conditions, Calculations and Ranking.
Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).
Generated Reports based on time like Year, Quarter, Month, Week based on Geographic and
Comparative reports.
Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
Used features such as functions, running totals, and parameters, conditional formats to develop
highly formatted Crystal Reports.
Used Broadcast Agent Publisher, which enables distribution of information via email using an
easy-to-use, subscription-based mechanism
Created Analytics and Dashboards using Performance Manager to enable executives track
progress and compare current and historical performance against established targets.
Created single or multi line chart for showing tendency over a period of time particularly used in
revenue history using Xcelsius 2008.
Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column
chart, Line chart, Bubble chart using Xcelsius 2008.
Used Xcelsius for presenting dashboards to End users.
Created Revenue Dashboard, Sales figure Dashboard using Xcelsius 2008.
Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business
Objects XI 3.0 environment using the Import Wizard.
Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End
user Notes.

Environment: Business Objects XI 3.1/3.0/R2, SQL Server2005/2008, Oracle 11g/10g/9i, Toad Data
Modeler, Web Intelligence XI R2/ XI, Infoview, Live Office, PL/SQL, QaaWS, Windows XP, Windows 2003
Server
PNC Bank, Riverdale, MD
Business Objects Developer
PNC bank is developing a transaction reporting system for the federal government in Washington DC. We
have deployed an ODS for various government financial trading partners and developed more than
20 Business Objects reports to capture financial transactions and keep track of the money that flows in
and out of the agencies.
Responsibilities
Work with business users and analyze the Reporting Requirements and Metric Analytics to come
up with the technical specifications for the BO Reports from different sources.
Building universes on top of SAP BW Bex Queries using SAP Authentications.
Worked on building Xcelsius Dashboards on top of universes build using SAP Integration Kit.
Used QAAWS and Live office functionalities of BO to pull Data from SAP Universes.

Experience in using QAAWS connections in Xcelsius with Refresh on Load option which enables
pulling of Live Data from Universes as well as Web Intelligence reports on Demand from Data
base.
Design and develop various universes and configure Joins, Cardinalities, Loops, Contexts and
Shortcut Joins
Created Xcelsius dashboards for visual understanding of information and publish to BO
Enterprise
Created Xcelsius components like charts, menus and containers
Mining data and performing statistical analysis using Predictive Workbench
Work on Performance Manager to create various Metrics, Analytics and use Dashboard Manager
to build Corporate Dashboards.
Created different kinds of analytics including Gauge Analytic, interactive Metrics Trend and
Metrics List
Created Rules for Dashboard Manager like Events, Conditions and Actions
Adopting strategies for List Of Values involving customizing the list of values, Cascading list of
values and exporting the List Of Values with the universe
Use LCM (Life Cycle Manager) for exporting BO Objects from one environnement to other.
Use Database Expert, Group Expert, Select Expert, Section Expert to create different Crystal
reports
Use Section Expert with Conditional Formatting to create Hide / Suppress Summary Reports
Developed and Converted Complex DESKI Reports to BOXIR2 WEBI Using Report Conversion
Tool.
Migrated reports from 6.5 to XIR2 using Import Wizard.
Used CMC (Central Management Console) to manage the universes, users/groups, reports and
Security model to objects
Designed Star and Snowflake schemas for Equities, Fixed Income, Client Coverage and Deals
subject areas using Dimensional modeling and Erwin.
Created reports using Business Objects functionalities like Multiple Data Providers (Merging),
Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail Created Complex Queries in
Desktop Intelligence and Web Intelligence including Complex Conditions (wildcard characters, In
List, Different From), Subqueries, and Grouping Conditions
Combine data from different sources and linking data providers (Merging)
Design and deploy the security model for Analytics and Corporate Dashboards
Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerters,
Formulas, Calculated data items, Filters, Sorts, and Query prompt

Environment: Business Objects XI R2/6.5, Oracle 10g/9i, SQL Server 2005, Infoview, Crystal Reports XI,
Web Intelligence XI, Xcelsius, SAP BW, SAP Integration Kit, QaaWS, Predictive workbench, Visio

Abercrombie & Fitch, Columbus, OH

Business Objects Developer
Involved in developing PPRF framework which provides sales and product performance analysis for
companies new products using Business Objects XI Designer, Desktop Intelligence, Web Intelligence,
DB2

Responsibilities
Used Business Objects Designer to maintain Universes, identifying Measures, Details and other
dimensional objects
Extensively worked with Business View Manager for developing Business Views, dynamic
Cascading Prompts
Created many reports with Crystal Reports X with Business Views as data source
Involved in creating the repository for Performance Management and creating different
Analytics/Metrics and statistical functions on the metrics (time-rolls ups, moving averages)
Designed the Corporate Dashboard Security on measures/metrics/analytics using the Access
Restrictions in the universe
Created critical visualization using Business Objects Crystal Xcelsius for the Business
Dashboard.
Used Crystal Reports to feed data to Crystal Xcelsius Visualization an XML file as a data source.
Resolved inconsistencies using aliases/contexts to maintain universe integrity and check for
loops and traps including chasm trap and fan traps
Created Crystal Reports using Crystal reports Formulas, Grouping, Parameters, Selection criteria
to handle the customers requests from Tables, Stored Procedures, Views and Command
Objects
Create Hierarchy groups with Group Expert and Group Selection Formulas in Crystal Reports
Use Conditional Formatting, Format Painter, Report Alerts and Suppress features of Crystal
Reports to format the report
Created Sub-Reports (Unlinked / Linked , In-place / On-Demand) with Shared Variables between
the main report and the Sub-report in Crystal Reports
Created cross-tab reports using Cross-tab expert in Crystal Reports
Worked extensively with the major functionalities of Business Objects like Alerter, Group By,
Query Prompt, Drill Filter, Indexes, Breaks, Sorts, Ranking, and Calculation using the Slice and
Dice panel.
Use Changed-Data-Capture (CDC) to extract only new or modified data and update the target
system including handling overlaps and preserving generated keys
Troubleshoot power users reports with errors like ( #Computation, #Multivalue, #Alerter, #Error,
#Err, #Overflow, #Unknown)
Created different types of reports, using Business Objects Reporting tool, such as Master/Detail,
Cross-tab and Bar charts used in analyzing trends
Created Users/Groups, roles and assigned required rights to them. Involved in the administration
of Management Console for implementation of security at Report level, Folder level and Object
level by assigning rights and required access level as per business requirement.
Responsible for Code Migration from development to testing, testing to production including
managing data connections to different databases.
Responsible for ETL extraction transform and loading data from different heterogeneous source
systems such as XML, Flat files using Business Objects Data Integrator XI
Worked with different types of transformations like Query, SQL, Date-generation and validation.
Environment: Business Objects XI R2, Oracle 10g, SQL Server 2005, DB2, Infoview, Crystal Reports X,
Web Intelligence XI, Erwin, Data Integrator XI

Lucent Technologies, IL
Business Objects Developer
Lucent Technologies designs and delivers the systems, services and software that drive next-generation
communications networks. Backed by Bell Labs research and development, Lucent uses its strengths in
mobility, optical, software, data and voice networking technologies, as well as services, to create new
revenue-generating opportunities for its customers, while enabling them to quickly deploy and better
manage their networks. Data from the data warehouse is used to design and develop reports
using Business Objects 6, Broadcast agent server, Business Objects Web I.
Responsibilities:
Created Universes using Business Objects and resolved loops and Join problems by creating
Aliases and Context.
Responsible for analysis meeting with end users and business units in order to define the
requirements.
Experience in translating business requirements in to technical/data element requirements.
Involved in gathering the requirements for reporting from the end users.
Used Broadcast Agent to schedule the reports.
Migration of Universes and reports from development to Production environment.
Modified Universe after analyzing areas of business and user requirements
Use of slicing and dicing for generating master/detail and tabular reports
Experience in creating application schema as tables, view and indexes
Created Full Client Reports making use of Business Objects functionalities, like Multiple Data
Providers, Prompts, Slice and Dice, Drill Down/Up.
Involved in preparing detailed ETL design documents, unit test plans for the mappings.
Scheduled and monitored using Broad Cast Agent.
Created Dashboards based on the requirement.
Environment: Business Objects 6, Web Intelligence, Desktop Intelligence, Infoview, Oracle8i, Ms-Excel
and Windows 2000.

Education
Master of Science in Information Systems