Summary of Qualifications

. Over *+ years of experience in Information Technology field with

strong emphasis in Business Intelligence (BI) and Data Warehousing

(DW) associated projects.

. Extensive experience in Business Intelligence Tools using

Business Objects 5x/6x/XI/XIR1/XIR2/XIR3/ XIR3.1

Administration(Supervisor/CMC), Universe Design (Designer), Report

development (Desk I/Web I), Info View, Import Wizard, Publishing

wizard, Application Foundation, Performance Manager, Dashboard

Manager, Broadcast Agent, Data Integrator, Data Integrator, Crystal

Reports, and Crystal Xcelsius 4.5/3.5/3.0.

. Expertise in working and implementation of Crystal Decisions, Crystal

Reports 7.0/8.0/9.0/10/XI/XIR2, Crystal Xcelsius

. With Strong Knowledge in all phases of Software Development Life Cycle

(SDLC) such as developing, testing, Migrating, Administrating,

security management and production supporting on various platforms

like UNIX, Windows NT/2000/XP/98.

. Proficient knowledge on BO XI Architecture and new features.

. Trained and qualified in installation, migration, maintenance,

troubleshooting and overall administration of the Business Objects

Suite version 6x (Supervisor) and XIR2/XIR3.1 (CMC).

. Exposed to data warehouse assignments in various domains like Utility,

Insurance, Logistics, Pharmacy, Health Care industry, Financial &

Banking.

. Extensive experience in developing Business Objects Universes, Reports

(Full client/Thin client), Web I, Corporate Dashboards which reflect

business performance.

. Worked with end-to-end implementation with Data warehousing team and

Strong understanding of Data warehouse concepts Star Schema, Snowflake

Schemas and Multi-Dimensional Models for query and analysis

requirements.

. Experience in Building and Managing Repositories.

. Proven abilities in creating complex reports by linking data from

multiple data providers, using free hand SQL, stored procedures and

functionalities like Combined Queries.

. Extensively used Business Objects reporting functionalities such as

Master Detailed, Slice and Dice, Drilling methodology, Filters,

Ranking, Sections, Graphs and Breaks.

. Experience in creating Metrics and Analytics to create Dashboards for

better decision purpose.

. Experience in creating Dashboards, Metrics, Rules, Alerts and Goals

using Performance Manager (EPM) XIR2 for user analysis based on user

requirements.

. Experience in deployment of Business Objects Universes and reports

from various sources like Oracle 8i/9i/10g, SQL Server, MS Access,

Siebel, Excel, Sybase and Teradata.

. Experienced with creation and maintenance of OLAP universes based on

SAP BW data sources.

. Implemented SAP BW concepts in Universe Designer.

. Expertise in creation of simple/complex reports from various data

sources like Universes, Free hand SQL, Stored Procedures, Personal

Data Files, and XML Data Providers.

. Involved in training internal business users and external vendors on

creating ad-hoc queries and reports.

. Expertise in SQL, PL/SQL, My SQL, Stored Procedures, Functions,

Cursors, Packages, Views, Indexes.

. 7+ years of experience in documentation using MS-Office (MS Word, MS-

Excel, & MS-Project).

. An excellent team member with good interpersonal relations, strong

communication skills and ability to quickly adapt to different project

environments, work in teams and accomplish difficult tasks

independently within time frame.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/NT/XP/2000 Server, UNIX, Sun Solaris.

BI/DW Tools: Business Objects XIR3.1/XIR3/XIR2/XIR1/XI/6X/5X (Supervisor,

Designer, Reporter), Performance Manager, Dashboard

Manager Web Intelligence 2.x/6.x/XIR2, Info View,

Broadcast Agent, Application Foundation, BO XIR2 (CMC, CMS,

CCM, Designer, Desktop Intelligence, Web I), Data

Federator, ACTUATE, Data Integrator, Crystal Xcelsius.

Reporting Tools: Business45 Objects, Crystal Decisions, Crystal Reports

7.0/8.0/9.0/10/XI/XIR2,

(Business View Manager), Excel 2000/XP, Qlikview, Actuate.

Project Management Software Design Life Cycle (SDLC), Agile, SCRUM, Joint

Tools: Application Development (JAD)

Data-modeling Tools: Erwin 3.5/4.0.

Languages: Shell Scripting, C++, SQL, PL/SQL, C/C++, VBA, JAVA/J2EE,

XML, UML

SQL Utilities: TOAD, SQL* PLUS.

ETL Tools: Informatica Power Center/ Power Mart 7.1/6.2/5.1

Office Tools: MS Word, Power Point, Excel, and Access.

Web Technologies: HTML, DHTML, Java Script, MS front Page, Adobe Dreamweaver

CS3.

Animation Tools: Macromedia Flash CS3 Professional, 3D Max, Autodesk VIZ,

Maya.

Imaging Technology: Adobe Photoshop (CS3 & Elements 6.0), Photo Pos Pro, and

Picasa.

RDBMS: ORACLE 8i/9i/10g, MS SQL Server 2000/2005, MS Access,

Sybase12.0.

Scripting: Perl, UNIX, and Java Script.

EDUCATION: Bachelor's degree in Computer Science (2000).

Masters in Computer Science (2003).

Professional Experience

America Online Inc, Dulles, VA

March'10-Tilldate

My Role: Sr. Business Objects Universe & Report Developer

Site Details: http://www.nationalgrid.com

Email:

ablc5d@r.postjobfree.com

Team/Size: Business Objects Migration Team/31

Description: America Online is an American global Internet services and

media company. In this project my duties involved working with Business

for final Requirement analysis and working with remote Administrators in

upgrading BO XIR2 to XIR3.1. The system is built using Oracle, SQL

Server, MS Access, Sybase and Teradata. Business Objects and Xcelsius

had been chosen for the reporting against the data warehouse database.

Role mainly involved testing, fixing and documenting of migrated R3.1

reports for 60 different teams.

My Responsibilities Involved:

Migration from BOXIR2 to BOXIR3.1:

. Interacted with Business Users, Business Owners, database team to

know their Business views in developing and modifying Universe and

Reports accordingly.

. Involved in migration from existing BOXIR2 systems to BOXIR3.1 in

all four Environments.

. Created User Defined Objects including Dimensions and Measures for

complex Financial Calculations.

. Worked extensively with @Functions, @Select, @Prompt, @Where to

filter the data.

. Created hierarchy and conditions in the universes to enable Drill

Down functionalities and filtering.

. Migrated Users/Groups, documents (Web I and Desk I), Universe,

Document, and folders and objects using Import Wizard.

. Added/deleted, enabled/disabled various BO servers using Central

Configuration Manager.

. Created users/ groups and defined their roles and set privileges

using the CMC

. Tested and fixed migration issues and bugs on all 2900 Reports and

210 Universes migrated from XiR2 to XIR3.1.

. Created complex new Universes, Reports, Linked with existing

Universe, and resolved Loops, Fan Traps, Chasm Traps by using

Cardinalities, Contexts, Aliases to remove the cyclic dependencies

between the tables.

. Used various join methods like Equi-join, Theta-join, Outer-join

in designing the universes.

. Created classes and objects and predefined conditions and also

user defined objects in the process of building the Universes.

. Created queries to extract data from database for multi-

dimensional analysis using Slice & Dice, Master Detail and Drill

up/down/by/through functionality.

. Modified and tested the Universe as per the Production

Environment.

. Interacted with Business Users to understand and document the

requirements and translate these to Technical Specifications for

Universes and Business Object Reports.

. Worked with Business team on the new change requests, fixing

defects in Business Objects reports and enhancements after

migration.

. Created new reports using both Desk I and Web I in Business

Objects XIR3.1 and validated the reports.

. Involved in building, Testing and Tuning Simple and Complex Full

Client and Thin Client Reports using Business Objects

functionalities like Sectioning, Ranking, Filtering, Queries,

Slice and Dice, Drill down, Prompts, Functions, Formulae and

multiple Data Providers.

. Worked with Complex filters, Alerters and User Defined Objects

(UDO).

. Created reports in Web I from multiple data providers and

synchronized the data using the merge dimensions feature.

. Worked as a team in developing business objects Crystal Xcelsius

Dashboards.

. Installed & Configured Business Objects Enterprise XIR3.1 on

Windows 2000 server and created Repository.

. Created simple and complex reports including dynamic calculations

involving Contexts, Queries, Hierarchies, List of Values (LOVS),

local variables, Alerts, Ranking and multiple data providers.

. Extensively used QAAWS to retrieve the data from the universe

objects.

. Formatted the raw data retrieved from Universe Objects in Xcelsius

spreadsheet using VLOOKUP, IF, AND, OR, CONCATENATE and many other

excel formulae/functions that are supported in Xcelsius.

. Used multi value components like line charts, bar charts, stacked

column charts and combination charts, and single value components

like gauge, slider, dial and progress bars in the development of

the Dashboards.

. Extensively worked on new Xcelsius components like Print Button,

Connection Refresh Button, Refresh Button, and Trend Icon.

. Extensively used slice and dice, filtering and ranking to create

cross tab and master/detail reports.

. Involved in formatting sections, tables, inserting and organizing

multiple breaks.

. Extensively worked on drill mode to view data in different

Perspectives.

. Used the formatting options like cross tab representation, section

breaks, data sort options, calculations, font, colors etc.

. Prepared Test Cases and Test Scripts for Unit Testing.

. Involved in Unit testing, System testing and User Acceptance Test

(Universes and Reports) throughout migration process.

. Interacted with the Administrators in the Performance Tuning of

the Dashboards.

. Implementation of SharePoint and BOXI Portal Integration Kit

allowed accessing all business intelligence resources such as

Crystal Reports, Web Intelligence, OLAP Intelligence, Performance

Management analytics and Microsoft Office documents that are

stored in the Central Management Server (CMS).

. Provided extensive support for the users on application usage and

trained users in the functionality of the software.

Environment: Business Objects XIR2/XIR3.1 (CMC, SIA, CMS, Designer,

DESKI), Web Intelligence, Desktop Intelligence, Info View, Toad 9.0,

Import Wizard, Conversion Tool, Server Intelligence Agent, Crystal

Reports 2008, Xcelsius 4/5/2008, Oracle 8i/9i/10g, SQL Server, MS

Access, DB2, Sybase, Teradata V2R6.0, SAP BW (OLAP/MOLAP), Microsoft SQL

Server 2000/2005, Windows 2000/XP Server.

National Grid, Waltham, MA

Aug'08-Feb'10 My Role: Business Intelligence

(BI) Lead

Site Details:

http://www.nationalgrid.com

Team/Size: Demand Side Management Team /17

Description: National Grid is international Electricity and Gas Company

and one of the largest investor-owned energy companies in the world. In

the US, National Grid delivers Electricity and Gas to approximately 3.4

million customers in Massachusetts, New Hampshire, New York, Rhode

Island, and Long Island. I was working as a BO Lead on Demand Side

Management (DSM) Project. My duties involved Active Admin, Migration,

Development, Testing and Maintenance of Business Intelligence System.

The system is built using Oracle applications and Business Objects has

been chosen for the reporting against the data warehouse database.

My Responsibilities Involved:

Admin, Lead & Migration (BO6.5- BOXI- BOXIR1-BOXIR2 to BOXIR3.1)

Responsibilities:

. Hosted Weekly & Monthly Project planning sessions with Project

Managers, Business Analysts and team members to analyze business

requirements and outline the proposed solution.

. Interacted with Internal Business Super Users to understand report

requirements and translate these to Technical Specifications for

Universes and Business Object Reports development.

. Conducted BO Training Sessions for Internal program Managers,

External Vendors and Auditors.

. Developed BO Training Manuals for internal super user reference.

. Installed & Configured Business Objects Enterprise

6x/XI/R1/R2/R3/R3.1 and created Repository.

. Headed the team of BO and Crystal Reports Developers in developing

reports, bug tracking, as well as documenting Sign-Offs from

Business during releases.

. Managed advanced user access restrictions using Central Management

Console (CMC).

. Defined LDAP Groups on Tivoli security and created respective

Enterprise groups on Business Objects to manage Internal and

External user security.

. Implemented Vendor security at Universe & report level, in order

to simplify the security on CMC.

. Implemented "Single Sign on" on application portal to support Web

I report access through portal.

. Designed and Implemented Security Features of Business Objects

like row level, object level and report level to make the data

secure.

. Assisted in developing data models, as well as logical and

physical database designs, with a major focus on dimensional

modeling.

. Developed processes using ETL tools (Data Integrator), PL/SQL and

SQL to support business reporting requirements.

. Designed and developed ETL processes, data flows, and Data Marts

based on business requirement specifications.

. Accessed multiple data sources including Oracle, SAS, Teradata,

Web services, and XML using Data Federator.

. Manage and share 24x7 production support of existing ETL and data

loading processes

. Responsible to synchronize the QA, DEV environments with

Production on every release and upgrade.

. Converted full client documents to Web I documents using Report

Conversion Tool.

. Created templates to support corporation stile and color scheme.

. Responsible to Maintain and Migrate Universe & Reports on Dev,

Test, Pre-Prod and Production.

Designer Responsibilities (Universe and Reports):

. Responsible to talk to business and finalize changes with

Application enhancements/new report requirements/Bug fixes during

releases.

. Created around 15 Universes to support 8 new programs on Gas and

Electric business.

. Logically grouped classes and objects and defined business names

to support Ad hoc reporting.

. Responsible for Universe & Report Testing, Report Conversion,

Query Optimization, and Performance Tuning during upgrade of BO

from 6.5-XI-XIR2-XIR3.1.

. Created 100 + complex reports using the multiple data providers,

multiple prompts and synchronized the data providers to create the

common report for different vendors.

. Generated OLAP universes in Business Objects universe from OLAP

cubes & Query's.

. Modified, saved and exported OLAP universes to the CMS.

. Installed the SAP Integration and configured the SAP Security Plug

In to enable SSO for OLAP Universes on top of SAP.

. Worked as Dashboard / Performance Manager for the Net Investment

and Interest to analyze the investment return

. Worked with Performance Manager to go beyond basic Dash boarding

to provide advanced goal management and score carding

capabilities, as well as guided analysis of metrics.

. Worked closely with Internal business users on report

requirements, report testing and report sign offs.

. Used @functions to create predefined conditions and prompts to

filter the data and dynamic user selection.

. Handled Embedded Functions like @Prompt, @Select, @Variable and

@Where in the Designer to handle User requests for report

generators.

. Used Business Objects common functionalities like Prompts, Breaks,

Report Alerters, Sorts, Filters, Global Filters and Conditions.

. Created default, ad-hoc and complex reports using Business Objects

functionalities like Queries, Slice and Dice, Drill Down,

Functions, Cross Tab, Master Detail and Formulae

. Defined Joins, Cardinalities, Derived Tables, Universe Prompts,

Filters, Contexts, Parsing, and performed Universe integrity

check.

. Resolved loops, fan traps, chasm traps by creating aliases and

contexts.

. Created customized LOV's to support Universe Prompts and Web

Intelligence reports.

. Worked on Microsoft and Business Objects Interoperability using

SharePoint and Business Objects XI Portal Integration Kit thus

helping to View and Manage Information within a Single Interface.

. Implementation of SharePoint and BOXI Portal Integration Kit

allowed accessing all business intelligence resources such as

Crystal Reports, Web Intelligence, OLAP Intelligence, Performance

Management analytics and Microsoft Office documents that are

stored in the Central Management Server (CMS).

. Created interactive Dashboards by importing data from Excel sheets

using Crystal Xcelsius.

. Created reports to visually represent data using Xcelsius 4/5/2008

. Provided extensive support for the users on application usage and

trained users in the functionality of the software.

Environment: Business Objects Enterprise XI/R1/R2/R3/R3.1 (CMC, CCM,

CMS, Designer, Desk I, Web I), Business Objects 6.5 (Supervisor,

Designer, Reporter), Web Intelligence 6.5, Info View, Enterprise

Performance Manager (EPM), SQL, PL/SQL, Oracle 9i/10g, Crystal Reports

2008, Xcelsius 4/5/2008, Teradata V2R6.1, Microsoft SQL Server

2000/2005/2008, SAP BW (OLAP/MOLAP), Apache Tomcat and TOAD and Windows

2000 Server.

MSG Systems Inc, Princeton, NJ

Dec'06-July'08 My

Role: Business Objects Lead

Site Details: www.msg-systems.com

Team/Size: Business Intelligence Team/ 9

Description: MSG Systems solutions include developing of complex and

individually designed application systems as well as the development of

standard software for the automotive, financial services, health care

and insurance industries. In this project I was working as a complete

Business Objects Professional with Supervisor/ Designer/ Reporter

responsibilities. The system is built using Oracle applications and

Business Objects has been chosen for the reporting against the data

warehouse database.

My Responsibilities Involved:

Universe Design and Migration BO6.5.1 to BOXIR2:

. Interacted with Business Users, Business Owners, database team to

know their Business views in developing and modifying Universe and

Reports accordingly.

. Worked on installation and configuration of Business Objects XIR2

Enterprise Suite (Desktop Intelligence, Central Management Server,

and Central Management Console) in the development environment.

. Created complex new Universes, Reports, Linked with existing

Universe, and resolved Loops, Fan Traps, Chasm Traps by using

Cardinalities, Contexts, Aliases to remove the cyclic dependencies

between the tables.

. Used various join methods like Equi-join, Theta-join, Outer-join

in designing the universes.

. Created classes and objects and predefined conditions and also

user defined objects in the process of building the Universes.

. Created queries to extract data from database for multi-

dimensional analysis using Slice & Dice, Master Detail and Drill

up/down/by/through functionality.

. Created User Defined Objects including Dimensions and Measures for

complex Financial Calculations.

. Worked extensively with @Functions, @Select, @Prompt, @Where to

filter the data.

. Created hierarchy and conditions in the universes to enable Drill

Down functionalities and filtering.

. Modified and tested the Universe as per the Production

Environment.

. Involved in migration from existing 6.5/ 6.5.1 systems to BO XIR2

in Development Environment.

. Migrated Users/Groups, documents (Web I and Desk I), Universe,

Document, and folders and objects using Import Wizard.

. Added/deleted, enabled/disabled various BO servers using Central

Configuration Manager.

. Created users/ groups and defined their roles and set privileges

using the CMC.

. Used the schedule manager to schedule reports in the Web I module

of XIR2.

Reporting:

. Interacted with Business Users to understand and document the

requirements and translate these to Technical Specifications for

Universes and Business Object Reports.

. Installed & Configured Business Objects Enterprise XIR2 on Windows

2000 server and created Repository.

. Understanding the existing Business Objects Universes for

efficient report creation.

. Worked in the development team on the new change requests, fixing

defects in Business Objects reports and enhancements from the

business.

. Created new reports using both Desk I and Web I in Business

Objects XIR2 and validated the reports.

. Converted .rep reports to .wid reports using the report conversion

tool.

. Involved in building, Testing and Tuning Simple and Complex Full

Client and Thin Client Reports using Business Objects

functionalities like Sectioning, Ranking, Filtering, Queries,

Slice and Dice, Drill down, Prompts, Functions, Formulae and

multiple Data Providers.

. Worked with Complex filters, alerters and user defined objects

(UDO).

. Created reports in Web I from multiple data providers and

synchronized the data using the merge dimensions feature.

. Worked as a team in developing business objects Crystal XCelsius

Dashboards.

. Exported business object reports to Web Intelligence 6.5.1 to be

viewed by all users on the Internet.

. Worked on Microsoft and Business Objects Interoperability using

SharePoint and Business Objects XI Portal Integration Kit thus

helping to View and Manage Information within a Single Interface.

. Implementation of SharePoint and BOXI Portal Integration Kit

allowed accessing all business intelligence resources such as

Crystal Reports, Web Intelligence, OLAP Intelligence, Performance

Management analytics and Microsoft Office documents that are

stored in the Central Management Server (CMS).

. Also used different data sources like free-hand sql, personal data

files creation of various reports.

Environment: Business Objects XIR2 (CMC, CMS, Designer, DESKI),

6.1/6.5.1 (Supervisor, Designer, Reporter), Web Intelligence, Desktop

Intelligence, Info View, Toad 9.0, Import Wizard, Conversion Tool, 3-

Tier BO, Broad Cast Agent (BCA), Crystal Reports 2008, Xcelsius 4/5,

Oracle 9.1, Teradata V2R6.0, SAP BW (OLAP/MOLAP), Microsoft SQL Server

2000/2005, Windows 2000/XP Server.

UPS, Atlanta, GA

Sep'05-Nov'06 My Role: Senior Business Objects Universe

Designer

Site Details: www.ups.com

Team/Size: Business Solution Team /27

Description: UPS is one of the world's largest package delivery

companies and a leading global provider of specialized transportation

and logistics services. UPS manages the flow of goods, funds, and

information in more than 200 countries and territories worldwide. This

project involved studying the existing BO Environment, Installation of

BO XI R2, identifying and resolving the migration issues; build new

Universes and reports and also tuning the Existing Reports and

implementing best practices.

My Responsibilities Involved:

. Interacted with Business Users to understand and document the

requirements and translate these to Technical Specifications for

Universes and Business Object Reports.

. Installed & Configured Business Objects Enterprise XIR2 on Windows

2000 server and created Repository.

. Created Enterprise Groups, Users and set restrictions using

Central Management Console (CMC).

. Designed and Developed Business Objects universes and applied row

level and object level security to different groups and users.

. Maintained Universes on Dev, Test, Pre-Prod, and Production.

. Created around 8 Universes and 60+ complex reports to support 3

existing and 2 new programs.

. Handled Embedded Functions like @Prompt, @Select and @Where in the

Designer to handle User requests for report generators.

. Used Business Objects common functionalities like Prompts, Breaks,

Alerters, Sorts, Filters, Global Filters and Conditions.

. Resolved loops, fan traps, chasm traps by creating aliases and

contexts

. Used Designer Module to implement Universes, Joins between Tables,

and created prompts and queries, parsing of Universes, and created

Contexts and Alias Tables to remove cyclic dependencies.

. Customized LOVs (Combining Code and Description).

. Created queries to extract data from database for multi-

dimensional analysis using Slice & Dice, Master Detail and Drill

up/down/by/through functionality.

. Created default, ad-hoc and complex reports using Business Objects

functionalities like Queries, Slice and Dice, Drill Down,

Functions, Cross Tab, Master Detail and Formulae

. Created hierarchy and conditions in the universes to enable Drill

Down functionalities and filtering.

. Used Cascading Prompts in the reporter level to create more

logical interactive reports.

. Scheduled Business Objects and Web I reports using the Broad Cast

Agent.

. Tested reports before posting them to the Repository (query

optimization & performance tuning).

. Converted full client documents to Web I documents using Report

Conversion Tool.

. Developed Complex Reports that involved multiple data providers.

. Generated and Published web reports in Info View using Web

Intelligence

. Conducted training sessions for end users about using Business

Objects Full client version and creating ad-hoc Reports.

. Created templates to support corporation stile and color scheme.

. Created new Universes specifically designed for creation of

Dashboards.

. Created various analytics like Speedometers, Interactive Metric

Trends (IMT) and Barometers.

. Responsible for creating Dashboards, Metrics, Rules, Alerts and

Goals using Performance Manager (EPM) XIR2 for user analysis based

on user requirements.

. Created interactive Dashboards and Business Presentations by

importing data from Excel sheets using Crystal XCelsius.

. Created highly formatted reports to visually represent data using

Crystal XCelsius.

. Created interactive Dashboards by importing data from Excel sheets

using Crystal Xcelsius

. Migrated reports in Actuate 5 to Actuate 7 SP2.

. Migrated all reports successfully using the utility AcExport and

AcImport.

. Used alerters to highlight critical data based on business

conditions.

. Provided extensive support for the users on application usage and

trained users in the functionality of the software.

Environment: Business Objects XIR2/R3 (CMC, CCM, CMS, Designer, Desk I,

Web I), Business Objects 6.5.1 (Supervisor, Designer, Reporter), Web

Intelligence 6.5, Info View, Broad Cast Agent, Enterprise Performance

Manager (EPM), Crystal Reports, SQL, Crystal Reports, Oracle 9i, Apache

Tomcat and TOAD, Actuate 5/7.0, Crystal XCelsius and Windows 2000

Server.

Con Edison, NY

Oct'04-Aug'05 My Role: Sr. Business Objects Reporter

Developer

Site Details: www.coned.com

Team/Size: Large Commercial and

Industrial (LCI) Team/12

Description: Con Edison is a major utility company which supplies power

to New York City and is a subsidiary of Consolidated Edison Company,

Inc., one of the nation's largest investor-owned energy companies. Con

Edison distributes natural gas to more than one million customers in

Manhattan, the Bronx, part of Queens, and most of Westchester County.

The project involved developing universes and generating repots to

monitor the sales of the various products as per the region using the

oracle database. Installed and implemented Business Objects enterprise

wide for this leading power utility company and configured the WEBI

servers for optimal performance.

My Responsibilities Involved:

. Involved in gathering, analyzing, and documenting business

requirements, functional requirements and data specifications for

Business Objects Universes and Reports.

. In the Implementation phase, installed Business Objects, created

Repository, administered the Supervisor module for creating users

and user groups and provided security access to users.

. Designed and built Universes according to the user needs, defined

connections and exported universes to the different universe

domains .

. Worked on the Master, Kernel and Component approach during the

linking of universes.

. Exported the universes to the Repository to make resources

available to the users.

. Maintained and did enhancement to existing universes and reports

generated by Business Objects developers.

. Involved in testing Classes, Objects and Connections in Business

Objects.

. Responsible for Resolving Loops using Aliases and Contexts to

remove the cyclic dependencies and also resolved Fan Trap and

Chasm Traps .

. Linked the universes of various functional departments to generate

documents from multiple universes.

. Involved in creating repository and setting up of groups and users

for Business Objects users.

. Created hierarchy and conditions in the universes.

. Created various reports using all types of methods in reporting

technology to represent data on report like (filters, alerter,

breaks, sorts, ranking, master/detail and Drill).

. Involved in translating general reporting requirements into drill-

down/drill-across universe support, and review designs with

business users.

. Created Cross-tab and Master Detail reports in Business Objects.

. Used Broadcast Agent publisher/scheduler for publishing and

distributing the documents.

. Resolved the performance issues in report generation and tuned the

universe for better performance.

. Actively participated in testing and publishing reports to user

community .

. Evaluated reporting environment for performance and efficiency and

presented recommendations to senior management.

Environment: Business Objects 6.5, Web I 6.5, Designer, Supervisor,

Broadcast Agent, ZABO, Info view, TOAD, and Windows 2000.

Celgene, NJ

Dec'03-

Sep'04 My Role: Business Objects Universe Designer

Site Details:

www.celgene.com

Team/Size: Business Objects Team /16

Description: Celgene Corporation provides solutions for unmet medical

needs in cancer and debilitating inflammatory diseases. The objective is

to 'build' a data warehouse for risk and sales management purpose. This

includes set up of the Business Objects environment.

My Responsibilities Involved:

. Involved in production Support and giving training to the users.

. Involved in migration from Business Objects 5.1 to Business

Objects 6.5

. Involved in creating repository and setting up of groups and users

for BO users.

. Exporting the Reports to the Broadcast Agent and Used the

Broadcast Agent to Schedule, Monitor and Refresh the Reports.

. Upgraded Business Objects universes and reports from version 5.1

to version 6.5.

. Constantly worked with Business Users to gather, analyze and

record requirements / specifications.

. As a part of Universe designer team, created Semantic Layer, went

through the two different levels of Database.

. Created reports using Business Objects functionality's like

Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master

Detail and Formulae's etc.

. Resolved loops, chasm traps and fan traps using contexts, aliases

and integrity checks.

. Formatted the reports as per the business requirements.

. Maintained and modified existing universes by creating the

Business Objects data model, selecting/joining tables, indicating

cardinalities, created aliases, contexts to resolve the loops,

used aggregate aware function and created the objects which are

grouped into classes based on Business Functionality.

. Used various join methods like Equi-join, Theta-join, Outer-join

in designing the universes.

. Involved in building, Testing and Tuning Simple and Complex Full

Client and Thin Client Reports using Business Objects

functionalities like Filters, Sorting, Ranking, Alerts, Queries,

Slice and Dice, Drill down, Prompts, Functions, Formulae and

multiple Data Providers.

. Created Master Detail and Cross Tab reports.

. Worked on the Master, Kernel and Component approach during the

linking of universes.

. Scheduling reports from the Broadcast Agent Server to only

requested users.

. Created Web Intelligence documents and published them to corporate

documents.

. Trained the end users in working with the Business Objects user

module provided technical expertise.

Environment: Business Objects 5.1/6.5, Oracle 9i, MS Access, SQL, Toad,

WEBI 6.5.1, Broadcast Agent, Business Objects 5.1.4 (Supervisor,

Designer, Reporter), Web Intelligence 2.x (ZABO, Broad Cast Agent),

Broadcast Agent, Oracle 9i, PL/SQL, SQL Windows NT.

Standard Chartered Bank, India

Oct'01-Sep'02 My Role: Database Analyst

Site

Details: www.standardchartered.com

Team/Size: Database Management Team/7

Description: SCB is the largest retail bank in India. With products that

span from credit cards to corporate loans, it provides the largest

network of banking products under its portfolio. I interacted with the

sales and operations team to elicit business requirements. Defined

business measures partnership with the business, and in conjunction with

the Service Delivery Team.

My Responsibilities Involved:

. Interacted with internal mangers for gathering requirements.

. Responsible for analyzing business processes, products, and

operations to create detailed business requirements and

documenting using formal artifacts.

. Developed procedure and functions using PL/SQL and Developed

critical reports.

. Extensively used PL/SQL to implement cursors, triggers & packages.

. Completed database architecture including developing stored

procedures and functions in order to create shortcuts to

frequently repeated tasks.

. Experience with Business Objects, Test Director, and Win Runner.

. Developed Date entry, query and reports request screens.

. Create record groups for manipulation of data. Perform unit and

system integrated testing.

. Co-Ordination with users and SQL tuning on existing reports.

. Moved data from one database to other database, Used SQL*Loader

for data migration.

. Responsible to the development of information models, and

understanding Entity Relationship Diagrams

. Participates on project teams, application analysis, and process

improvement.

. Working knowledge with tool ERWIN.

. Involved in maintaining data integrity between Oracle and SQL

databases.

. Extensively used Stored Procedures for handling the database

operations.

. Performed coding and testing of the application.

. Developed inquiry, quotation and purchase order reports using

Oracle Reports .

Environment: Oracle 7.3, SQL, PL/SQL, Forms 4.5, Reports 2.5, Windows

95/98, and UNIX.

Contact this candidate