[pic]

Spandan K Yemmela

@ abmva2@r.postjobfree.com

Sr. Business Objects Consultant

845-***-****

SUMMARY :

. Over 7 years of IT experience in Business Objects XI R3.1/R3/R2/ 6.5,

Designer, Desktop Intelligence, Web Intelligence Rich Client, Crystal

Reports2008/XI/10.0/9.0, Crystal Xcelsius.

. Industry experience includes Insurance, Healthcare, Banking, Retail,

Energy and pharmaceutical sectors. Extensively worked on designing and

developing complex universes, which has several hundreds of objects,

contexts, and aliases, aggregate aware functions and cascading prompts.

. Experience in Designing, Building and Maintaining the Universes,

resolving issues like loops and Traps using Alias and Context, designing

complex objects using @prompt, @Aggregate aware function.

. Experience in creating Universes with Measures and Dimensions Objects,

Join conditions, Filters, LOV's, Aliases, Contexts, Aggregate Awareness

using Business Objects Designer.

. Extensive experience administrating and supporting Business Objects

servers and services.

. Very good understanding of Data Warehousing Design Methodology, Data

Warehouse Concepts.

. Well experienced in working with Data Warehousing using ETL, FACT

Tables, Dimension Tables, OLTP, OLAP, MS SQL Server 2005, MS Access

2000/97, Erwin 4/3.x.

. Worked with End-To-End implementation with Data warehousing team and

Strong understanding of Data warehouse concepts Star Schema, Snowflake

Schema and Multi-Dimensional Models for query and analysis requirements

. Optimized performance issues for the reporting after the migration.

. Good knowledge of dimensional modeling concepts like Star and Snow flake

schemas to fit query, reporting and analysis requirements.

. Excellent communication, interpersonal, written, analytical and problem

solving skills.

. Approach all projects with passion, diligence, integrity, and exceptional

aptitude.

TECHNICAL SKILLS

Reporting Tools : Business Objects XI 3.1/R1/R2/6.5.1/6.1b/5.0

(Designer, Reporter), Web Intelligence/ Infoview

2.x, Crystal Reports (9.0/ 10.0/ XI/ 2008), Xcelsius 4.5/2008.

ETL : Data Integrator, Informatica

6.0(Power Mart & Power Center)

RDBMS : Oracle 10g/9i/8i/7, MS SQL Server 2000,

2005, DB2, MS-Access.

Languages : C, UNIX Shell Scripting, XML, SQL, PL/SQL.

Middleware : Weblogic 10.1, 10.3g

Operating Systems : Sun Solaris UNIX, Windows NT/2000/2003/XP.

Tools : ERwin 4.1/4.0, Toad 8.5.1, OLAP and

SQL Navigator 4.1

PROFESSIONAL EXPERIENCE

Citigroup, New York, NY

March'09 - Till Date

Role: Sr. Business Objects/Crystal Reports Developer

Citigroup is today's pre-eminent financial services company with over 200

million customer accounts in more than 100 countries.The scope of this

project is limited to the mortgage sector. Our day to day work was to

assist financial analysts in making critical business decisions. Generating

reports, resolving issues that come in the way .

Responsibilities:

. Created prototypes of the reports for user presentation in the process of

requirements gathering.

. Installing, upgrading and troubleshooting the Business Objects

Enterprise.

. Interacted with Business community to gather and analyze the Business

Requirements in developing and modifying Universes and building the

reports.

. Resolved Chasm traps, Fan Traps & Loop problems by using contexts and

aliases to reduce the complexity of the universes.

. Organized data in the reports by using Filters, Sorting, Ranking and

highlighted data with the Alerter.

. Extensively used the @functions, worked on back end functions,

procedures, tables, views required by the business objects universes

. Created Dynamic Filters and Dynamic Conditions in universe level as per

Business rules.

. Improved the performance and reduced the coding with the use of

@functions like @Prompt (for user defined queries), @Where (for creating

conditional filters), and @Select to create duplicate objects in the

process of building the Universes.

. Created custom List of Values (LOVs) for better understanding of prompts

by the end users.

. Developed Dashboards using Performance Manager, Dashboard manager (XI

R3.1) and Crystal Xcelsius (Standalone format).

. Migrated the documents and reports using the Repository Migration Wizard

. Designed and Developed WEBI reports, created charts and graphs for quick

analysis.

. Created Report Level Variables, Objects and Formula to create new columns

based on the result set.

. Preparation of Critical, Master Detail, Sub Reports, Cross Tab and

Summary reports using Crystal Reports, features includes functions, running

totals, parameters and conditional formats.

. Created users defined objects, make use of variables, breaks, sorting,

drill down, slice and dice, alerts.

. Used command level restrictions, set object-level security, row level to

restrict sensitive client information to concerned departments only.

. Applied User and Group Restrictions in selected objects in universe level

based on User and Group.

. Created new users in XI R3 using Central Management Console and set

restrictions, assign privileges based on their profiles.

. Used Business Objects SDK to suppress "no data to fetch" using macros.

. Created Dashboards using Crystal Xcelsius for senior management for

business decision making.

. Created Daily weekly monthly, annual and forecasting sales and

distribution Reports for fiscal and calendar years

. Created IMT and Speedometer Dashboards for better understanding of

reports.

. Provided user support and training in using Report Designer for creating

Adhoc reports.

Environment: Business Objects XI R3.1, CMC, CMS, Designer, Admin Console,

Infoview, Crystal Reports10.0/11.0/XI/2008, Xcelsius, Toad, SQL, PL/SQL,

Oracle 10g,WebLogic 10.3g, SQL Server, Windows NT .

Aclara, Richmond, VA

July'07 -Jan'09

Role: Sr.Business Objects Consultant

Description:

Aclara is a utility communications company with end-to-end data capture,

transfer and processing capabilities. Aclara integrates advanced, proven

technologies to capture, analyze and apply utility data to meet needs of

today and tomorrow.

This is a Data Warehousing project. Aclara's customers are mainly utility

companies which use integrated systems to provide the customers an insight

of their utility usage. I was working with a support team which maintains

and troubleshoots unprecedented amounts of data.

Responsibilities:

. Directly coordinating with user to gather the new requirements and

working with existing issues.

. Designed, developed and maintained Universes for supporting Adhoc and

canned reports.

. Coordinated with ETL, Data warehouse team to implement the Star Schema

modeling.

. Created various classes and objects in the Universe.

. Created user objects to enhance the reporting needs.

. Measure objects and User objects were created keeping in view of the end-

user requirement.

. Created Filters (Condition Objects) to improve the report generation.

. Created Hierarchies from providing drill down options for the end-user.

. Created Context, Alias to resolve the Loops in the universe.

. Modifying the existing universes, Adding new objects editing joins

mapping the existing objects with renamed tables.

. Creating new Connections and editing existing to run the report in

different database test, development.

. Created the Derived and Aggregate Tables.

. Resolved the fan and chasm traps.

. Detected cardinalities and checked the Integrity of Universes.

. Created variables, @prompt (Interactive objects), formulas etc.

. Created the stores procedures and functions at the back end.

. Fine-tune the existing universes to enhance their performance.

. Exported the universes to the Repository making resources available to

the users.

. Experience in Optimization and Performance tuning of new and existing

Business Objects universes.

. Worked extensively on distribution, maintenance, and optimization of

universes for Business Objects and Web Intelligence deployments.

Environment: Business Objects XI R2, Oracle10g, PL/SQL, Web I, Crystal

Xcelsius, DESKI, Broadcast Agent & Windows 2000.

Aetna, Hartford, CT.

Dec' 05 -May' 07

Role: Business Objects /Crystal Reports Developer

Aetna offers a wide range of traditional and customer-directed health

insurance and related services. These include medical, pharmacy, dental,

behavioral health, group lifelong-term care and disability plans and

medical management. Our customers include employer groups, individuals,

college students, part-time and hourly workers, health plans and government-

sponsored plans.

The aim of this project is to provide detailed information about their

various health plans provided to various groups, the claims made and the

amount reimbursed, total revenue etc.

Responsibilities:

. Involved in the design and development of Universes, Classes, Objects

and Conditioned Objects for Business Analysis and Report Generation.

. Used different functionalities of Universe such as Cardinalities,

Contexts, Joins and Aliases for resolving Loops and Checked the Integrity

of the Universes.

. Customized hierarchies and List of Values in the Universe for providing

drill down options in the reporting environment.

. Implemented row level and object level security using Supervisor for

different users.

. Used aggregate awareness function to enhance the performance of the

universe.

. Developed various dash boards, Charts and Graphs like Bar chart (Side By

Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of

Crystal Reports.

. Exported the universes to the Repository to make resources available to

the users.

. Created the reports using multiple Data providers like universe, free

hand SQL, Excel etc.

. Develop complex Crystal Reports in a Oracle WebLogic environment for the

Meter Data Management system.

. Created the reports using BO functionalities such as drill down

reporting, slice and dice, @functions, master-detail reporting, sorting.

. Worked with ranks, prompts and variables in designing reports in full

client and thin client.

. Strong knowledge of Data Architecture in Business Objects.

. Created Alerter using Business objects to highlight columns based on

business criteria.

. Used Broadcast Agent to distribute the reports to different users.

. Provided complete documentation and presentation to help users in

developing various reports using different functionalities and methods

used in creation of reports.

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

Crystal Reports 10.0/11.0/XIR2, Weblogic 10.3, Oracle 10g, Windows NT/2000.

P&G Sales Warehouse for Wal-Mart, Kansas

Dec'04-Oct'05

Role: Business Intelligence Developer

Description:

This Project Objective is to generate detailed reports for different

regional sales of P&G products in Wal-Mart and Sam's club. This Project

included both Business Objects 6.1 reports and Business Objects XIR2 Web I

reports.

Responsibilities

. Analyzed the reporting requirements with the business users and come up

with the technical specifications.

. Well-versed in Desktop & WEB Intelligence.

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

the two different levels of Database.

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

checks

. Created Classes and Objects taking the information from the database.

Also created measured objects. Checked the Cardinalities, Contexts, Joins

and Aliases for resolving Loops and Integrity of the Universes.

. Created and maintained Web Based reports using Web Intelligence and

Scheduled through BCA Scheduler

. Exported the universes to the Repository to make the resources available

to the users.

. Exported business object reports to Web Intelligence to be viewed by all

users on the Internet.

. Created reports for various Portfolios using the Universes as the main

Data Providers.

. Created the reports using Business Objects functionality's like Queries,

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

Formulae's etc.

. As a part of report development, created the reports using universes as a

main data provider and using the Powerful business objects functionalities,

and formulae. Involved in trouble shooting of various reporting errors.

. Created Business Objects reports, Queries with constant interaction with

the end users. Trained end users in understanding the reports.

Functionalities such as Slice and Dice, Drill mode and Ranking were used

for Multidimensional Formatting.

. Web Intelligence was used to generate reports on the internet/intranet.

. Extensively used Free hand SQL in reporter so that reports contains the

relevant data.

. Worked with security aspect of Business Objects and data level security

with Universe

. Exporting the Reports to the Broadcast Agent and Used the Broadcast Agent

to Schedule, Monitor and Refresh the Reports.

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

Environment: Business Objects XI R2(CMC, CCM, CMS, Designer, DeskI),

Dashboards, Crystal

Reports11, SQL, Oracle 10g, MS-Access, Windows 2000 Server, WebI XIR2,TOAD.

USF Health, Tampa, Florida

Aug'03-Oct'04

Role: Business Objects /Crystal Reports Developer.

Description:

USF Health IT, the information technology arm of USF Health, supports the

administration of applications for various groups and facilities. With data

scattered across its organization in separately maintained sources, USF

Health needed to consolidate information and provide greater visibility

into financial, physician performance, educational and research data. As a

result, it sought to establish a business intelligence (BI) reporting and

analysis solution.

Main focus of this project is to create performance orientated reports

compared to the slow legacy systems. Reports to track effectiveness of the

personnel and give physicians timely, quantifiable feedback regarding

performance. Develop dashboards that offer at-a-glance views of integrated

information and the ability to drill down into detail.

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.

. Designed and customizing data models for Data warehouse supporting data

from 17 different source systems

. Worked with End-To-End implementation with Data warehousing team and

Implemented its like Star-Schema, Snow-Flake Schema.

. Linked two universes Sales and Patients using kernel approach.

. Created multiple universes and resolved Loops by creating table aliases

and contexts to remove cyclic dependencies.

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

reporting environment to accurately assess the effort Vs the results of

clinical activities

. Worked with database connections, SQL joins, cardinalities, materialized

views, views, aggregate conditions, parsing of objects, LOVs..

. Created reports on development data to test the functionality of

universes with a group of power users.

. Created reports using the business object functionality like queries,

Slice and Dice, Drill down, functions and variables.

. Scheduled reports using Broadcast agent

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

Tab Reports to provide a transformational approach to the way staff members

and clinicians access and report on data

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

@prom pt, condition Objects and Aggregate Awareness Functions for SQL

enhancement.

. 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 Dashboards using Crystal X-Celsius for senior management for

business decision making..

. Developed Dashboards and Scoreboards for detailed analysis.

. Designed and developed Data Integrator (DI) XI scripts for data

transformation.

. Performance tuned Business Objects Data Integrator XI jobs to ensure

optimal performance.

. Extensively used Data Integrator to cleanse and populate target database.

. Performed Server Management Tasks, using Central Configuration Manager

(CCM) and Central Management Console (CMC).

. Created Users, User groups and assigned privileges to access and work

with Universes and Reports.

. Knowledge of Crystal Reports reporting system including Crystal Server

reports distribution infrastructure.

Environment: Business Objects XIR2, Data Integrator, WebI6.1, DESKI, JSP,

SQL server 2005, Erwin, DashBoards, SQL*Loader, Crystal Reports, Windows

2000/NT, ORACLE 10g.

Jhanor Gandhar Gas Power Project, Gujarat, India.

June'02 - June'03

Role: Data warehouse Developer

Jhanor Gandhar is one of the largest power stations operated by NTPC. Our

main job was to provide reports to administration department about gas

consumption, power generated, and utilization of resources etc.All this

data comes to us from different departments who use their own data sources

and different ways of representing data.

Responsibilities:

. Gathering the user requirement, reporting requirements and prepare the

requirement specifications document. This involved interviewing the

business users and understanding the current reporting system.

. Involved in analyzing the source data coming from different Data sources

such as DB2, SQL Server.

. Architected a Metadata Repository / Data Dictionary for a Data Warehouse

Data Migration Project. This included source and target physical field

attributes, "Source to Target" data mappings, data migration rules, and

business data elements and enterprise standard definitions

. Created logical ERwin data models for the following subject areas for ODS

/ Data Warehouse for Sales Portfolio Management

. Developed mappings/Transformations/mapplets by using mapping designer,

transformation developer and mapplet designer in Informatica Power Center.

. Setup the batches, configured the sessions and scheduled the loads as per

requirement.

. Involved in the designing and Building of Universes, Classes and objects

using Business Objects and created Cardinalities, Contexts, Joins and

Aliases for resolving Loops and checked the Integrity of the Universes.

. Created, maintained and modified the business complex reports using the

Business Objects Reporting Module.

. Involved in development of many critical reports like drill down reports,

slice and dice reports and one touch reports.

. Involved in analyzing and suggesting the network requirements for Web

Intelligence 2.5.4 and deploying and configuration of Business Objects, Web

Intelligence, and Broadcast Agent scheduler.

. Deployed reports on Web Intelligence for remote corporate management.

Environment: BusinessObjects5.1, Web intelligence 2.5.4, Oracle9i,

Broadcast Agent, BOSDK, SQLserver, Erwin, Informatica 5.1, MS Office,

Windows NT /2000.

Academic Qualifications:

Bachelor of Engineering in Computer Science and Engineering, Nagarjuna

University, India.

[pic]

Contact this candidate