Manager Customer Service

BI Tools Business Objects XI R*/R*.*, Business Objects

6.5.1/5.6, Desktop Intelligence, CMS, Web Intelligence

XI, BO Server E 6.5.1, Broadcast Agent Scheduler

(BCA), Reporter, supervisor, Designer, Business

Objects, Auditor, Admin Console, Supervisor over the

Web, ZABO, Crystal Reports 7.0 / 8.0, Crystal

Xcelsius.

ETL Tools Informatica 7.x.

Databases Oracle (7x/8i/9i/10g), DB2, SQL Server 2000 and

MS-Access

Oracle Tools/Utilities SQL Plus, SQL Loader, IMPORT, EXPORT, Oracle

Enterprise Manager, SQL Navigator, SQL LAB

Languages PL/SQL, Java2.0, JSP, Visual Basic Application and C

Internet Technologies HTML, DHTML, XML, XSL, JavaScript, Applets, JAVA,

JDBC, Servelets, JSP, J2EE, JSP 1.0/1.1/1.2, Servlets

2.0, JDBC 2.0, JNDI, STRUTS.

Operating Systems Win NT/XP/2K/98/95, Unix - Solaris 8 /9.

Name: Bharadwaj

Contact: Cell: 937-***-**** Email:

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

Education: M. S in Computer Applications from JNTU, India.

Experience in Years 8+ Years

Roles Senior Business Objects Developer /Analyst

EXPERIENCE SUMMARY

Over 8 Years of experience in developing reporting solutions for Financial,

Insurance, Manufacturing, Retail, Telecom, Health Care industries in Oracle and

Teradata environment.

Expertise with Business Objects XI R2 Product Suite (Deski, Designer, Web

intelligence, CMC, CMS, Infoview, Import Wizard, Migration Tool, Crystal

Reports), Dashboard Manager, Business Objects 6.5.1 and Business Objects 5.1.6.

6+ years of experience in developing universes in Business Objects in versions

5.1.6,6.5.1,BOXIR2 and BOXI R3.1

Experience Migrating reports & Universe from Business Objects E 6.5.1 to BO XI

R2.

2+ experience with data modeling (Dimensional & Relational) concepts using Erwin,

including: star-schema modeling, snowflake modeling, and fact and dimension

tables.

2+ years of experience implementing Xcelsius Dashboards and Scorecards using

Dashboard manager.

Involved in all Analysis, Development, Testing, Tuning and Maintenance, as well

as resolved problems during implementation of Xcelsius Dashboards.

Extensively used Live office in dash Board creation.

Expertise in creating rules and goals in the Performance Manager and later used

them in creation of required analytics in Dashboard Manager.

Created Multiple Dashboards for various user groups using BO XI R2

Excellent Universe Building skills using Business Objects Designer XI R2, 6.5.1.

Excellent skills in using Report Conversion tools for Converting Full Client

Reports.

Developed various Ad-hoc & canned reports using Universes with Complex filters,

Cascading Prompts, Scope of analysis, sorting, Ranking, conditions.

Experience with Business Objects Supervisor to create Repository with multiple

document and Universe Domains.

Created Complex Reports in Desktop/Web Intelligence using functionalities like

Slice and Dice, Drill Down, Cross Tabs, Master/Detail, and Formulae.

Articulate with Excellent communication Skills. Ability to work under tight

schedules

WellPoint, Inc.

SEP 2009 - Current

Role: IM Business Objects Lead Developer

Project Description:

In order to facilitate Part C program administration, contractor

monitoring and oversight, and performance assessment, CMS has developed a

set of reporting requirements for Part C contractors. Part C contractors

will be required to collect and report information beginning in 2009. CMS

has requesting this self-reported information under regulatory authority at

42 CFR 422.516 (a).

Data from various systems across the WellPoint Enterprise will be fed into

the repository to allow for one centralized location in which all Senior

reporting needs could be met.

Medicare Part C SR Reporting SEP

2009 - FEB 2010

Wave 3 (PHI W2)

. As a part of the release the reports Provider Network Adequacy, PFFS Plan

Enrollment Verification, PFFS Provider dispute appeal were due to CMS.

This is a Full Life Cycle Implementation.

. Interacted with Business Users and Business Analyst to gather the

Requirements and Business logics.

. Attended data model design sessions along with data architects and

business analysts

. Developed Universe technical design documents and Report technical design

documents.

. Involved in re-designing or customizing the existing Views to suit the

business requirement.

. Created Universes by defining connections and retrieving data from

database.

. Created New Classes and User Objects in designing the universes.

. Created Contexts and Aliases to resolve chasm and fan traps in Universes.

. Generated various reports on Daily, Weekly, Monthly and Yearly basis.

. Created Charts to display summary data using universe as main data

provider.

. Extensively used Calculations, Variables, Drill Down and Slice and Dice

for creating Business Objects reports.

. Imported/ Exported the Universes from/ to repository to make them

accessible to end-users.

. Defined Aliases and Contexts to resolve loops in the universes.

. Created User Conditions and Filters to improve report generation &

readability of report and displayed the summary of data by creating

Charts.

. Defined Hierarchies in Universe to provide the users with Drill down

option in reports and Predefined Conditions to use in Business Objects.

. Extensively used Calculations, Variables, Break Points, Drill, and Slice

and Dice for generating reports.

. Involved in creating various reports by extracting data from Data Marts

. Created reports using Teradata Databases and Personal Data File

Providers.

. Generated the Business Objects reports involving complex queries, sub

queries, Unions and Intersection.

. Changed the universe parameter settings to optimize the performance of

universe

. Interacted with the various users for reporting requirements.

. Provided end user support and problem resolution for various issues

related to BO.

. Created and modified the existing Universes by adding new

classes/objects, prompts, hierarchies based on the business requirement.

PHII W1

FEB 2010 - MAY 2010

. Interaction with Business users for requirements gathering

. As a part of this release the reports Agent training and testing, Agent

compensation structure, 108_D950_monthly_ER_utilization_report were due

to CMS. This is a Full Life Cycle Implementation.

. Handled change request for a previously submitted report (Provider

Network Adequacy) to include additional metrics.

. Developed Universe technical design documents and Report technical design

documents.

. Performed Business Objects Universe design and Reports Development and

Testing

. Export of Business Objects report to excel for users to do more analysis

on data.

. Ensured the development and testing environment was setup as per the

needs.

. Created dynamic link between reports through Open Document

SR Risk Adjustment:

SEP 2009 - JUL 2010

. Involved in requirements gathering and developed Universe technical

design documents to meet the requirements

. The scope of this project is to create an adhoc universe for the end user

to perform various business queries. This is a Full Life Cycle

Implementation.

. Performed Business Objects universe design and development to

facilitate ad-hoc reporting.

. Trained end users on business objects Webi on ad-hoc reporting

. Documented the ad-hoc reporting process for user reference.

. Organized the classes as the per the business needs which helped users

during ad-hoc reporting.

. Set up hierarchies as per the business needs to enable drill down.

. Created various predefined filters, measures and additional dimensions

for ad-hoc reporting.

. Trained users regarding the scheduling, Webi variable creation etc...

. Performed unit testing on the universe by running the ad-hoc queries.

. Analyzed the user's usage of the universe and developed additional metric

objects to improve the usability and performance.

. Performed bug fixing during the UAT phase and production implementation.

Medicare Part C SR Reporting

MAY 2010 - CURRENT

PHII WII

The scope of the Phase was to develop Medicare Part C front end tool which

is a one stop portal for source system file upload and end user report

retrieval. The scope of this phase(IM team) is to integrate Business

objects reports with the above mentioned dotnet portal. This is a Full Life

Cycle Implementation.

. As part of this release the following reports were due to CMS as a part

of this release. Grievances and Appeals, Org determinations and

Reconsiderations at CMS contract level. Their corresponding breakup

reports at File name level.

. Involved in requirements gathering and developed the Technical Design

Document for report development.

. Modified the existing universe as per the Technical Design Document.

. Created database views and derived tables to meet the complex

requirements wherever necessary.

. Created classes, subclasses, dimensions and measures according to the

Technical Design Document.

. Created reports based on the modified universe to meet the requirements.

. Created Opendoc links on the existing reports to facilitate the

integration.

. The dotnet tool generates parameters based on the user response which

will in turn create the Opendoc links which contained parameters.

. Various reports and corresponding opendoc links were created which will

retrieve Summary reports which were deliverable to CMS, Detail and Error

reports for UAT validation.

. Performance tuning on the existing reports to meet the requirements.

. Involved in bug fixing during UAT Phase and production implementation.

Environment: Business Objects XI R2,Crystal Xcelsius 2008, Designer, Web

Intelligence, CMS, Teradata V2R6, SQL Assistant, Windows XP.

Cisco, Sanjose, CA

MAY 09 - Aug 2009

Role: Senior Business Objects/ Xcelsius developer

Project: Sales Portal POC

Description: This Project involved in demonstrating a Proof Of Concept

(POC). The concept is to show the capability of a connected dashboard model

integrated in the Life Ray Portal.

. Participated in project planning sessions with project manager,

business analysts and team members to analyze business requirements

and outline the proposed solution.

. Build the new universes as per the user requirements by identifying

the required tables from Data mart and by defining the universe

connections.

. Created Webi (with prompts) reports on the created universes and

performed data analysis to check whether the webi reports were

fetching the accurate data.

. Sourced the webi reports using Live office in Microsoft excel and used

Excel formulae to trim the data to feed into xcelsius.

. Built four complex xcelsius Dashboards sourcing the above mentioned

webi reports.

. Designed UI for the above created dashboards to make them visually

appealing.

. Worked with the portal expert to integrate the dashboards in the Life

Ray Portal.

. Demonstrated to the users a fully connected dashboard model where the

user gets live and refreshed data at every click on the dashboard.

. Created documentation for the above mentioned dashboards and universes

for the later reference and development.

. Deployed the universes, webi reports and the dashboards from the local

machine to the development environment by recreating the webi reports

and updating the connections in the dashboard.

. Created Aliases and Contexts for resolving Loops and checked the

cardinality and Integrity of the Universe.

. Created reports using Business Objects using functionalities like

slice and dice, drill down, @functions, cross tab, master/detail

tables, formulas and etc.

. Designed reports with complex variables, multiple breaks, and sorts

to meet the user requirements.

. Used Prompts in the reports as well as the Universe to create more

interactive reports for the users.

Environment: Business Objects XI R3.1, Crystal Reports 2008,Crystal

Xcelsius Engage 2008, Designer, Desktop Intelligence, Web Intelligence,

CMS, Oracle 9i, SQL, PL/SQL, Windows XP.

Origin Digital, CO

Jan 08 to April 09

Role: Senior Business Objects Developer

The Project was to develop a BusinessIntelligens solution for OriginDigital

- North American Operations, to support effective tracking, targeting and

planning in field Operations. The purpose of the project was to assist

business users in delivering a solution that will increase the efficiency

and productivity of the system.

Responsibilities:

. Migrated the Environment (Reports & Universes) from E 6.5.1 to

Business Objects XI R3.1 - Desktop Intelligence Reports, Web

Intelligence using the Manual and the Import Wizard.

. Converted the 6.5.1 Reports to BO XI-R3.1 Webi Reports using the

Report Conversion Tool.

. Troubleshooted the Issues and Problems encountered while migrating the

reports & universes from Business Objects 6.5.1 to Business Objects XI

R3.1.

. Created Universes for both Adhoc & Canned Reporting users of BOE XI

R3.1 - Deski & Webi.

. Defined classes, objects, Hierarchies, access restrictions,

Conditions, joins, Alias, Contexts.

. Used Business Objects Crystal Xcelsius and Query as a Web

Services(QAAWS) for data access.

. Programmed QAAWS links from dashboard for additional functionality

. Created multiple Xcelsius models using QAAWS to publish in Dashboards.

. Configured Crystal Xcelsius to update a model by using the XML Data

Button to connect to a custom middle tier Link a model to a live data

source using the XML Data Button.

. Created Dashboard Chart and Container Selectors using the Xcelsius

components.

. Extensively involved in the complete implementation of Xcelsius

Dashboards 2008.

. Installed and configured Live office plugins in Microsoft Office

suite.

. Created Xcelsius Dashboards using Live office plugins in MS Excel and

Trained end users on the usage of Live office.

. Developed and designed Xcelsius dashboards for end customers and

provided support

. Used Crystal Report 2008 to feed data to Crystal Xcelsius

Visualization an XML file as a data source

. Developed Xcelsius dashboard for Analysis of various Data Metrics

. Built custom Dashboards using Crystal Xcelsius 2008.

Crystal reports 2008 Development:

. Created crystal reports 2008 by directly connecting through ODBC

to the database.

. Used Crystal Reports 2008 SDK for generating customized reports.

. Customized the user interface to meet the needs of end users

with Crystal Reports 2008 SDK with VBA.

. Customized the user interface to meet the needs of end users

with Crystal Reports 2008 SDK

. Used Crystal Reports 2008 SDK using VBA to automatically refresh

reports and deliver them to the publications.

. Modified existing reports developed in Crystal Reports 9 as per

the user requirement and migrated to Crystal reports 2008.

. Developed reports with parameters, sub-reports based on Stored

Procedures and Queries by using Crystal reports 2008.

. Involving in Account, Content, Server managements managed by

Crystal Enterprise server with Crystal Management Console and

Crystal Configuration Manager by using Crystal Enterprise 2008.

. Installed Crystal Enterprise and Published reports on Crystal

Enterprise Server and got involved in Crystal Enterprise

Administration 2008.

. Experience in Scheduling the Reports using Crystal Enterprise

2008.

. Published Reports in Crystal Enterprise via Crystal Publishing

Wizard and Crystal Management Console.

Environment: Business Objects XI R3.1, Desktop Intelligence, CMC, CMS,

Web Intelligence XIR3.1, 6.5,2.x, Designer, Reporter, Supervisor, BO SDK -

VBA, Business Objects E 6.5.1, supervisor Auditor,Admin Console, SDK,

Info view ZABO,Oracle 9i, SQL, PL SQL, Unix ( Sun Solaris ).

Bank of America

Dec 06 to Jan 08

Project: Internal Control Matrix

Role: Senior Business Objects Developer

The Financial Business Intelligence data warehouse system for Bank of

America was implemented to handle the increasing data volumes generated by

the bank's growing active client base, while improving customer service

levels. The project involves maintenance of warehouse of Bank of

America by means of integrating data from different feeder systems and

Business Intelligence using Business Objects. Data is presented in a user-

friendly format to the higher management

Responsibilities:

. Installed Business Objects Enterprise 6.5.1 & Patches on Client

Machines & on the Server.

. Universes were migrated from E 6.5.1 to Business Objects XI

R2Environment -using the Manual Method and the Import Wizard.

. Involved in Xcelsius Dash Board implementation and design.

. Provided support for Xcelsius dashboard users.

. Created pie charts, bar charts, Map charts etc using Xcelsius

Dashboards.

. Successfully migrated the 6.5.1 Full Client Reports to BO XI-R2 Webi

Reports using the Report Conversion Tool and resolved the issues when

raised.

. Created Universes and Reports using Business Objects XI R2 - Desktop

Intelligence & Web Intelligence.

. Developed the Star Schema data model for this system. Developed the

database and reports with detailed specifications about the various

sources, targets and transformations necessary to obtain the desired

results.

. Created Users, User groups, defined the security and administered the

User community Repository domains, using CMC

. Developed multiple Universes, Created classes, objects, defined

Hierarchies, defined object access restrictions, Conditions, joins,

Alias, Contexts using the Designer Tool.

. Universes were developed extensively using functions @Aggregate aware,

@prompt, @script, @select, @where and @variable for performance and

portability.

. Developed complex reports with Business Objects 6.5.1 using Drilldown,

Slicing and Dicing, Multiple Sections, Section Conditions, Hidings,

Ranking, Alerts Reports.

. Created Reports using Multiple Data Providers, Free Hand SQL, VBA, and

Stored Procedure Data Providers.

. Defined and created Hierarchies both at the universe level and at

report level to implement drill down developed chart reports with PIE

charts, Line and Area reports.

. Developed and Tuned SQL, for use in Business Objects, used

Materialized Views, Hint Indexes and aggregate table for better

performance of reports.

. Created Microsoft VBA Scripts for customizing the Prompts and for

creating the Input Criteria.

. Involved in Documentation -including Requirement document, High Level

Design and granular level documentation.

Environment: Business Objects XI R2 -Desktop Intelligence, CMC, CMS, Web

Intelligence XI R2, Business Objects Enterprise 6.5.1 - Reporter,

Designer, Supervisor, Supervisor Over Web, Auditor,Admin Console, Infoview,ZABO, Oracle 9i, SQL, PL SQL, Unix ( Sun Solaris ).

Nationwide Insurance

Jan 05 to Dec 06

Project: ECP Data Warehousing & Business Intelligence

Role: BO Developer

This Project has been developed for Claim Data Warehouse system. Business

Customer would like to have front-end tool, Business Objects, to run ad-hoc

queries to access the XY1 data. They would like to have Business Objects

Universe Created on top of XY1 data. The Business Objects XY1 Universe will

sit on top of the CCPS data mart

Responsibilities:

. Developed feasibility / proof of concept reports for the key

stakeholders / data owners

. Gap analysis between standard system and proposed system

. Created, refined and delivered functional test materials collaborated

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

. Implemented Best Practices and Procedures to standardize initial and

further development process

. Designed the EURCP Universe to implement the data security at the User

level, by which only Global Managers can see data for all countries and

the Country managers can see only their country and Office level data

. Created multiple contexts to incorporate Time and Revenue data in a

single universe

. Create Universe functional Spec Documents, and Unit Test Plans and

documented Job Status reports.

1. As a part of Universe development, created Classes, different kinds of

objects, cardinalities, Strategies

2. Responsible for creating & managing the Business Objects repository and

coordinating/performing universe development. Exported the universes to

the Repository to make resources available to the users.

3. Worked with multiple environments such as UAT (Development and QA) and

Production.

. Several simple, complex and Ad-hoc reports were created having Slice and

Dice, Drill Down, Cross Tab, Master Detail, Formulae and resolved the

loops using Aliases and Contexts.

4. Established security/accessibility criteria through BO SUPERVISOR.

5. As a member of Production Support team supported the maintenance of the

Business Objects/Web Intelligence environment 24x7.

Environment: Oracle 9.2, Business Objects Enterprise 6x Suite (2-tier,

Web Intelligence, 3-tier, BCA, Auditor, Application Foundation), I UNIX,

Erwin, Visio, Microsoft Project.

Phillip Morris Group, WI

Nov 04 to Jan 05

Project: Point of Sales (POS)

Role: BO Developer

The project was to develop the POS system, a planning tool that provides

direction to the business managers or Inventory planners to optimize

planning for the production, procurement, storage and distribution of raw

materials, and to help manage the risks associated with the price

volatility. The main objective of the project being to identify the

future Product & Inventory History and deviation reporting requirements

for replacing the existing RMMS system and setting up the environment in

which the reports could be run and maintained.

Responsibilities:

. Installed Business Objects, Created Repository, Users and User Groups.

. Designed Universes and created the reports using the Universes as the

main Data providers.

. Resolved loops, defined contexts and aliases to resolve loops and also

tested them to ensure that correct results are retrieved.

. Linked universes to work with common objects, developed various

complex Adhoc and canned reports using features like slice and dice,

Drill capabilities, Complex freehand SQL queries, @Functions, Master

Detail, and Cross Tab tables with multiple breaks.

. Created Alerts using Business objects to highlight columns based on

business criteria.

. Publishing reports using Infoview, and Training users for ad hoc

reporting.

. Created various user profiles, set their access permissions to create

the various user groups using Supervisor.

. Created variables, @Prompt objects, formulas created the Stored

Procedures and used those as Data providers, thereby worked with

Multiple data

. Scheduled and processed the reports at the server level using

Broadcast agent server.

. Administered User Security through Business Objects Supervisor.

. Testing of Business Objects and Reports which Includes

a) Database Connectivity

b) Tested objects in the Universe to ensure the correct mapping

of the objects.

c) Tested the Universe s Structure to ensure that tables are

properly uploaded.

d) Tested the aggregate Universe to ensure the query is

pulling correct level of Aggregation.

. Worked closely with business analyst and end users for requirement

gathering and feasibility study.

Environment: Oracle 9.1, SQL, PL SQL, Business Objects Reporter 6.5.1,

Designer 6.5.1, Supervisor 6.5.1, Web Intelligence 6.5.1, Infoview.

Voice Stream Wireless, GA

Oct 03 - Nov 04

Business Objects Developer

Description:

This project was developed for gauging Voice Stream's performance. It

helped to keep track of details including number of customer's using

service, new contracts by month, customer service change requests, billing

cycle end dates, reminding service renewals and also net revenue.

Responsibilities:

. Designed universes with several classes and objects and implemented

row level and object level securities.

. Involved in migration and deployment of the universes and reports

across multiple domains.

. Used various @Functions like @Prompt (for user defined queries),

@Where (For creating conditional filters) and @Select created

Cardinalities, Contexts, Joins and Aliases for resolving Loops and

checked the Integrity of the Universes.

. Reviewed Business Requirements and Technical Specifications for Direct

Accessories, which pays commissions to sales representatives.

. Worked thoroughly on Packages, Stored procedures, Functions, Cursors

and Error handling to implement business logic.

. Extensively tested and debugged the PL/SQL code in various database

environments. Worked on Performance Tuning of the PL/SQL code.

. Wrote Scripts and Promotion package to promote the code into

production.

. Developed Full Client (ZABO) reports and Web Intelligence (Webi)

reports.

Environment: UNIX, Windows 2000/NT, IIS Web Server, Sun Solaris, Oracle 8i,

SQL*Plus, PL/SQL, Business Objects 5.1.7 and Web Intelligence.

Global Trust Bank, India

Jun 01 - Oct 03

ETL Developer & OLAP Reporter

We developed software for keeping track of checking accounts, saving

account, Investment Information, generate reports, loan information, and

for archiving the older transaction. Involved in the design phase and

responsible for creating GUI interface for the Personnel information system

Module. The system includes the software application tools development to

convert data from dBase to Oracle and generation of reports by using Oracle

tools

Responsibilities:

1. Involved in taking report requirements from business users and project

planning.

2. Assisted in developing reports on Branch turnover and profits.

3. Established user groups and users and assigned privileges.

4. Developed Universe using Designer module in Business Objects.

5. Developed and created classes with Dimension, Detail & Measure Objects

and specified the hierarchies.

6. Specified the Joins and checked the cardinalities.

7. Resolved loops by creating Aliases and Context.

8. Ad-hoc reports were used for Business Objects User modules for various

Portfolios using the Universes as the main Data Providers.

9. Created the reports using Business Objects & Crystal Reports

functionalities like Combined Queries, Slice and Dice, Drill Down,

@Functions, Cross Tab, Master Detail and Formula etc.

Environment: Oracle 9i, Informatica 6.1, Business Objects 5.1, Crystal

Reports and Windows NT

Contact this candidate