Manager Data

Swapna

(Senior Business Objects Developer)

Ph: 408-***-**** E-mail:

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

Profile:

* ***** ** ** **********

* ***** ** ******** ******* Experience

* ***** ** **** *********on Experience

5 years of Database Experience

Summary

* SDLC: 7 years of IT experience in Analysis, Design, Development and

Implementation of Data Warehousing and other applications using Object

Oriented Analysis, Design and Methodologies

* Business Intelligence: 6 years of Business Intelligence experience

with complete life cycle Implementations using Business Objects

XIR3/XIR2/6.5/6.1/6.0/5.1 (Supervisor, Designer, Info view, Business

Objects Reporting Business Objects SDK, Xcelsius, Web-Intelligence

3.2/2.7/2.6/2.5, Web-I SDK, Broadcast Agent, Publisher, BO Set

Analyzer, Data Integrator, Application Foundation & Dashboard Manager)

* Business Objects: 6 years of Extensive experience in Business Objects

full client & thin client environment. Created complex reports by

linking data from multiple sources, using functionalities like

Combined Queries, Slice and Dice, Drill Down, Master Detail, etc. Used

Stored Procedure Data Provider for frequently running tasks. Trained

Users in report development and running ad-hoc queries in business

objects. Tested business objects reports for data validation and

compared results with TOAD. Set up Broad Cast Agent and Configured the

Broad Cast Agent.

* ETL: 2 + years experience in loading huge amount of data into data

warehouse using ETL tools like Informatica, DTS and SSIS. Development

of mappings in Informatica to load the data from various sources using

different transformations like Source Qualifier, Expression, Look up

(connected and unconnected), aggregate, Update Strategy, Joiner,

Filter and Router.

* Databases: 5 years of solid database experience in Oracle

10g/9i/8i/8.0/7.x, Teradata V2R5/V2R4, DB2 8.0/7.0/6.0, MS SQL Server

2000/7.0, (database triggers, materialized views, In-line views,

Packages, stored procedures, functions, and database constraints), SQL

Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied

utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), TOAD, Rapid

SQL.

Education & Certifications

* Masters Of Computer Applications.

Technical Skills

Business Business Objects XI R2/XI/6.5/6.1/6.0/5.1 (Supervisor,

Intelligence Designer, Info view, Business Objects Reporting Business

Objects SDK, Web-Intelligence 3.2/2.7/2.6/2.5, Data Integrator

XI, Xcelsius, Web-I SDK, Broadcast Agent, Publisher, Designer,

Supervisor, Auditor, Application Foundation Dashboard Manager,

Report Writer, BO Set Analyzer, Application Foundation &

Dashboard Manager), Informatica Data Analyzer (PA 8) & Power

Analyzer 5.X/4.X, Xcelsius, Crystal 2008.

Business Functional Requirements Gathering, User Interviews, Business

Analysis Requirements Gathering, Process Flow Diagrams, Data Flow

Diagrams, Data Analysis, Requirements Analysis, Design, Data

Modeling, Data Architecture, Data Flow, Data Cleansing

Dimensional Dimensional Data Modeling, Data Modeling, Star Join Schema

Data Modeling Modeling, Snowflake Modeling, FACT and Dimensions Tables,

Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2,

Oracle Designer, Visio and Sybase Power Designer.

ETL Informatica Power Center 8.1/8.0/7.1.2, Power Mart 6.2/5.1.1,

Workflow Manager, Work flow Monitor, ETL, ETI, Data mart, OLAP,

OLTP, Mapplet, Transformations, SQL*Plus, SQL*Loader

Databases Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server

2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x,

MS Access.

Programming Unix Shell Scripting, Kernel Programming, Perl Programming,

SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, Java, C, C++

Environment Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS

6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat

Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000,

RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

Professional Experience:

Genentech Pharmaceutical. SFO, CA

Jan'09 - Till

date

Sr.Business Objects Developer.

Genentech is among the world's leading biotech companies, with multiple

products on the market for serious or life-threatening medical conditions.

Using human genetic information to discover, develop, manufacture and

commercialize bio therapeutics that addresses significant unmet medical

needs.

Responsibilities:

* Interacted with Business Users to gather the requirements and Business

logics/Rules.

* Designed Functional Specification for report creation.

* Created Xcelsius reports for presentations.

* Worked closely with the management to assist in the project status.

* Analyzed the warehouse Tables to design Universes by creating Classes

and Objects.

* Designing the Universe, created Contexts and Aliases for resolving

Loops in the Universes.

* Designed architecture & set up for development, production & test

repositories.

* Designed Universe, Reports using SAP-BW as source System.

* Updated and maintained Universes based on changing user requirements

and data source changes.

* Conducted Performance tuning of Universes for time management purpose

by creating alternate views and indexes.

* Created templates for standardizing the structure of corporate

documents.

* Worked on major functionalities like Breaks, Filters, Sorts, Query

prompt and Drill filters.

* Created mappings for extraction, transformation and loading of the

data from various sources into the dimensions and the fact tables in

the data warehouse.

* Created Universes on Teradata database.

* Involved in the design and development of various mappings, mapplets

to implement the business logic using different transformations like

Aggregator, Connected and Unconnected Lookups, Update Strategy and

Stored Procedure.

* Developed PL/SQL scripts for ETL.

* Designed the End user training materials and practice Exercises.

Environment: Business Objects XI R2/ 6.5, Web Intelligence, Crystal Reports

XI R2, Xcelsius, Data Integrator XI, Teradata, Oracle10g, Toad, Citrix

Server.

MasterCard, St Louis, MO

March'06- Nov'08

Sr Business Objects Developer

MasterCard is a multinational corporation based in St Louis Missouri.

Throughout the world, its principal business is to process payments between

the banks of merchants and the banks of purchasers that use its

"MasterCard" brand debit and credit cards to make purchases. MasterCard

Worldwide has been a publicly traded company since 2006. Prior to

its initial public offering, MasterCard Worldwide was a membership

organization owned by the 25,000+ financial institutions that issue its

card.

Responsibilities:

* Identified and road mapped the Business Requirements (functional &

technical) with the Business users, which acted as a base for the

project initiation and implementation.

* Gathered Customer, User and Owner requirements; analyzed and

documented them.

* Created Data Flow Diagrams (DFD) to define the data element flow to

the most granular level to translate data requirements to ETL

processing

* Extensively used Business Objects Designer to design and maintain Data

warehouse Universe.

* Migrate, upgrade and test the Business Object XIR3 content/environment

* Setup, execute, and test the assigned programs utilizing BO XIR3 Webi

and DeskI tools

* Troubleshooting BO XI installation and migration issues.

* Performance tuned Business Objects Data Integrator XI jobs to ensure

optimal performance.

* Extensively used Data Integrator to cleanse and populate target

database.

* Creation of reports like Reports by Product, Reports by Customer,

Reports by Period, Demographic reports and Comparative reports,

Working with database connections, SQL joins, cardinalities, loops,

aliases, views, aggregate conditions, parsing of objects and

hierarchies.

* Created reports using WEBI, DESKI, full client and Xcelsius.

* Developed more than 25 Full client and thin client (Webi) reports for

all modules and update to version 6. Exporting universe to the

repositories to make resources available to the users.

* Responsible for Universe Designing, Hierarchy Building for Data

Analysis and applied conditions in Business Objects.

* Designed, developed, tested and maintained highly complex reports, d-

hoc reports, Hyperlinked reports canned reports.

* Use of BO Designer Module to implement Universes, linkages between

tables, creating prompts and queries, parsing the Universes, applying

contexts and alias tables to remove cyclic dependencies.

* Used Business Objects Data Integrator XI R2 for ETL extraction,

transformation and loading data from heterogeneous source systems

* Created dashboard using crystal Xcelsius..

* Used Complex EXCEL formulae V lookup & H lookup to generate complex

Dashboards.

* Used query as a web services and live office for automation of

Dashboards.

* Worked on importing Excel files in order build the visualization

using Xcelsius Designer.

* Scheduled and monitored reports using Broadcast Agent Console.

* Developed Internal control reports to validate the ETL load and

scheduled it.

* Created, refined and delivered functional test materials collaborated

with test cases, set up test plans, schedules and scenarios.

* Optimized database performance by using shortcut joins. Shortcut joins

provide an alternative path between two tables. Shortcut joins can

improve query performance by using shorter paths and bypassing

intermediate tables.

* Used Business Objects supervisor to create repository, creating and

managing the users, giving access permission for Business Objects

Reports.

* Provided production support by monitoring the processes running daily.

* Deployed the development and QA domains to reduce the server loads and

to increase the performance.

* Trained end users in understanding the reports. Functionalities such

as Slice and Dice, Prompt, Drill mode and Ranking were used for

Multidimensional Formatting

Environment: Business Objects XIR3/XIR2, Crystal Reports, Data Integrator

XI, Informatica Power Center 8.1, Dashboard Manager, Xcelsius, Web I 3.2,

Deski, Windows 2000/NT, SQL, Teradata, Oracle 9i, T-SQL scripts, TOAD

HCA Health Care, Nashville, TN

Aug '05 - Jan '06

Sr Business Objects Developer

HCA is one of the America's best healthcare companies, which has a

continued growth and success. The project involves developing a sales Data

warehouse & Create Reports which collects data related to medical samples

provided to the doctors, its feedback and finally analyzing the data for

those samples.

Responsibilities:

* Requirements Gathering and Business analysis

* Familiarized the business, its strategy and implementation.

* Gathered Customer, User and Owner requirements; analyzed and

documented them.

* Designed and customizing data models for Data warehouse supporting

data from multiple sources on real time.

* Migrated reports from BO 6.5 to BO XI2.

* Setup hierarchies in the Universe for providing drill down options in

the reporting environment.

* Created Sets, Metrics, Rules, using Set Analyzer and Dashboard

Manager.

* Created and customized application dashboards using Application

Foundation and used balanced score cards and speedometers.

* Experience in cleansing data in DI using proper data types and

mappings and to create Workflows using object library and tool palette

to execute data flows.

* Linked two universes sales and customer using kernel approach.

* Created multiple universes and resolved Loops by creating table

aliases and contexts.

* Worked with database connections, SQL joins, cardinalities, loops,

aliases, materialized views, views, aggregate conditions, parsing of

objects, LOVs, and hierarchies.

* The universes were frequently tested for validity and correctness of

inferred SQL.

* Created reports on development data to test the functionality of

universes with a group of power users.

* Scheduled reports to business users and owners using Broadcast Agent.

* Exported the Business Objects reports to Web I to be viewed by all

users on the Intranet using Web I; SDK with JSP plug-in.

* Created reports using WEBI, DESKI, full client.

* Created reports using the business object functionality like queries,

Slice and Dice, Drill down, functions and formulae.

* Knowledge of Crystal Reports reporting system including Crystal Server

reports distribution infrastructure.

* Experience with Crystal Xcelsius dynamic data presentation software.

* Created graphs/charts for the reports, Created Master Detail and Cross

Tab Reports.

* Created complex reports using user-defined functions like @variables,

@prompt, condition Objects and Aggregate Awareness Functions for SQL

enhancement.

* Enabled/Disabled different servers in Central Configuration Manager

and Central Management Console.

* Performed Server Management Tasks, using Central Configuration Manager

(CCM) and Central Management Console (CMC).

Environment: Business Objects XIR2/6.5/6.1, Data Integrator, Dashboard

Manager, Xcelsius, Web I 6.1, DESKI, JSP, SQL, PL/SQL, Erwin, SQL*Loader,

UNIX Shell Script, Windows 2000/NT, ORACLE, PL/SQL, SQL Enterprise Manager

State Compensation Insurance Fund, California

Nov'04 - Jul'05

BUSINESS OBJECTS DEVELOPER

The California State Fund is a non-profit, public enterprise fund that

operates like a mutual insurance procurement applications carrier. State

Fund employees located in office locations throughout California State

provide full services for employers and their injured employees. Data

warehouse for insurance claims system for generating reports based on the

category of employers, vendors, and employees.

Responsibilities:

* Installed and configured hardware for the entire Business Objects

suite of products.

* Managed over 400 users and 30 groups in the entire Business Objects

suite

* Trouble Shooting In Business Objects Enterprise

* Maintained the whole environment (TEST, DEV and PROD) along with 8

main servers.

* Updated and maintained Universes to meet new reporting requirements

* Performed Server Management Tasks, using Central Configuration Manager

(CCM) and Central Management Console (CMC).

* Clustered Central Management Server (CMS) machines

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

* Applying patches, hot fixes, critical fixes, service packs and

testing/applying security patch.

* Requirement Collection, Documentation & high-level design.

* Developed Functional (Business terms) and Technical Design documents

* Imported data from Business Objects 6.x & Crystal Enterprise to

Business Objects Enterprise XI

* Configured BO Server Products like WebI and BCA Publisher & Auditor on

different nodes in Distributed Environment

* Implemented procurement applications to cut down the supply management

cost.

* Designed architecture & set up for development, production & test

repositories

* Worked with database connections, SQL joins, cardinalities, loops,

aliases, materialized views, views, aggregate conditions, parsing of

objects, LOVs, and hierarchies.

* Tested Reports and deploy them over web

* Deployed reports to Repository through Broadcast Agent Server

* Scheduled Business Objects Reports using Broad cast Agent and

scheduler

* Business Objects Installing the Repository.

Environment: Windows XP, Business Objects 6.0,,Crystal 8.5, Designer,

WebI, Publication Wizard, Broad cast Agent, Import Wizard, Crystal

Enterprise, Business Objects 6.5/XI, Reporter, Designer, Supervisor,

Business Query, BO SDK, Web Intelligence 2.x/6 and InfoView. Oracle 8.

NAGARJUNA FINANCE LIMITED

Mar'03- Oct'04

Developer

Public Deposit System: Nagarjuna Finance Limited is one the leading Non

Banking Finance Company in India. The company has two divisions in it

Resources and Lending Division. In the Resources we have the Deposits and

other financial instruments. The Application aims to keep track of fixed

deposit accounts of the customers based on the scheme opted. Deposit System

mainly deals with two kinds of deposits namely cumulative and non-

cumulative. Interest warrants are generated for non-cumulative deposits as

per the scheme period.

Responsibilities:

* Prepare documentation including requirement specification.

* Documented the metadata to capture from the sources

* Created Sessions and batches to extract the data.

* Involved in the creation of jobs using work flow manager to validate

schedule run and monitor the jobs.

* Involved in designing the procedures for getting the data from all

systems to Data Warehousing system.

* Information is stored in table definitions in the repository and is

entered using the Repository Manager.

* Assisted warehouse designer while designing the models.

* Wrote Unix Shell Scripts to automate the process.

Environment: Informatica Power center 1.7, Windows NT, Oracle 8i, SQL,

PL/SQL, SQL*Loader, Erwin 3.5, SQL Server 2000, DB2, Erwin 3.5, IBM AIX 4.

Contact this candidate