Abhishek Reddy Chamakura

Email : ab8u44@r.postjobfree.com

Cell : 405-***-****

Office : 703-***-**** x132

PROFESSIONAL SUMMARY

> Over 8 years of IT experience in Business Intelligence and Data

warehousing Technologies.

> Diversified Experience in implementation of Business Objects in

Finance, Insurance, Telecom, Manufacturing and Pharmaceutical sectors.

> Extensive exposure in Dimensional Data Modelling, Physical & logical

Data Modelling using Erwin.

> Complete Life Cycle Knowledge including Architecture, Capacity

Planning, Installation, Administration, Change Management and

Upgrading Business Objects Enterprise XI 4.0/3.1/ 3.0/XI R2/6.5 in a

Distributed and Clustered Environments

> Design, Implement and Maintain Business Objects Security Models and

configuring Business Objects Enterprise, LDAP, Windows Active

Directory, and Windows NT authentication

> Strong Experience in migration of Business Objects 5.X/6.X to XI/XI

Release 2, XI 3.0, XI 3.1

> Extensive experience in Migrating Universes, Folders, Report Objects,

User Objects using Import Wizard and LCM (Life Cycle Manager).

> Hands on experience in using Publishing Wizard, Broadcast Agent,

Report Conversion Tool.

> Extensively Worked on Oracle 7.x/8.x/9i/10g/11i and MS-SQL Server

7.0/2000/2005/2008,Teradata V2R6.2/12.0.1 and IBM DB2.

> Extensive experience writing complex SQL's and stored procedures using

PL/SQL programming.

> Expertise in Tuning of SQL Queries leading to significant improvement

in system response time and efficiency using Explain Plan, TKPROF and

Auto Trace.

> Excellent Knowledge in Extraction, Transformation and Loading process

using Informatica, Data Stage and Microsoft SQL Server Integration

Services (SSIS).

> Extensive experience working with SAP BW. Involved in upgrade of BW

3.5 to BI 7.0.

> Expertise in SAP BI/BW components like Data source, User Exits, ETL

activities like OLTP data extraction, loading (Full/Delta Up-Load),

Scheduling, Monitoring, Process Chains, Remote Cubes, Open Hub

Service.

> Worked on integration of SAP BW in planning, reporting and simulation

based on the user requirements.

> Good Knowledge of SAP BW Security Performed positive and negative

security testing.

> Expertise in Performance Tuning of SAP BW Systems. Evaluated

statistical performance and improved data load and query performance

using Compression, Aggregates and Partitioning techniques.

> Extensively Worked on BEx Analyzer, Query Designer, Web Application

Designer, BEx browser.

> Good Knowledge to work with SAP BW BEx Queries and creating

connections from SAP to BO Systems.

> Extensive Experience Designing, Maintaining & Modifying Universes

using BO Designer.

> Extensively used Multiple Data Providers such as Universe, Free-hand

SQL, Stored Procedures and Personal Data Files for generating reports.

> Strong experience in creating complex reports using Business Objects

and Crystal Reports functionalities Such as Queries, Slice and Dice,

Drill Down, Cross Tab, Master Detail, @Functions, Custom sorts,

Formulae, Summary, Form and Sub-Reports.

> Analyzed and Created the data in charts(pie charts, bar graphs, line

graphs) using various metrics & formats using slice/dice, drill

up/drill down, Hierarchies, Scope of Analysis etc.

> Extensively used Xcelsius and Live Office in Creating simple to

complex Scorecards and Dashboards.

> Good Working knowledge of BO Dashboard Manager and data

visualization using Crystal Xcelsius.

> Expertise Developing Canned/Ad-hoc Reports, scheduling Reports and

administering the BO activities.

> Extensively worked in converting Crystal and Tableau Reports to

Business Objects Reports.

> Experience in creating macros in Business Objects and Excel.

> Strong experience in writing Test plans, Test cases, Unit testing,

System testing & Integration testing.

> Involved in Documenting Processes, Business Objects Environment

Architecture, Server Configurations, Sizing Specifications, Training

End Users and Preparing Training Material

> Strong time management and project coordination skills with

simultaneous projects.

> Excellent Technical, Analytical and Problem Solving Skills. Ability to

rapidly learn new Technologies.

> Experience in conducting small and large group presentations and

proven to be highly effective in interfacing across business and

technical groups.

> Experienced in Training & Supporting End-Users.

> Flexible & versatile to adapt to new environment with strong desire to

keep pace with latest technologies.

TECHNICAL SKILLS

BI Tools : Business Objects 4.x/5.x/6.1/6.5.1/XI

R1/R2/3.0/3.1,Crystal Enterprise

XI /9.0/8.0/6.0, SAP BW 3.5, Tableau 5.1/6.0

ETL Tools : Informatica PowerCenter 6.x/7.x/8.5/9.1.0

(Repository Manager,

Designer, Work flow Manager), SSIS (SQL Server

Integration

Services), Data Integrator (BODI), Data Stage

Data Modelling Tools : Erwin 4.0/3.5, MS Visio

Databases : Oracle7.x/8.x/9i/10g/11g,MS-SQL Server

7.0/2000/2005/2008, Teradata

V2R6.2/12.0.1,DB2 UDB, MS-Access.

Web Technologies : HTML, DHTML, Dream weaver, Photoshop, MS

FrontPage.

Web/Application Servers : Apache, Tomcat, JBoss, Web logic.

Tools / Packages : TOAD, Oracle Enterprise Manager, SQL

Navigator, SQL Loader,

SQL*Plus, SQL

Developer, MS Office suite (Word, Excel, Power Point)

Languages : SQL, PL/SQL, T-SQL, XML, Java, ASP, JSP, .NET,

Visual Basic

Operating Systems : MS-DOS, Windows

95/98/2000/NT/XP/Vista, Linux, UNIX, SUN

Solaris

EDUCATION

> Bachelors in Computer Science Engineering, Madras University Chennai, India

> Masters in Computer Science, Governors State University Illinois,USA

PROFESSIONAL EXPEREINCE

U.S. Environmental Protection Agency (EPA)

OCFO - Office of Chief Financial Officer

Washington, DC

09/10 - To Date

Sr. Business Objects & Informatica Consultant

The replacement of EPA's Integrated Financial Management System (IFMS)

possessed significant challenges for many EPA feeder systems, consumer

systems, and most importantly for the Superfund User Community.

EPA-OCFO proposed to create a Superfund Consolidated Data Source (SFCDS) to

meet the Superfund Community Requirement. The Superfund Consolidated Data

Source provides Repository of Comprehensive Superfund Cost Recovery Data

including legacy data. It has Detail-level, post Momentum go-live Superfund

Data, converted and non-converted data within Functional Data Warehouse.

Responsibilities:

> Involved in Gathering, Interviewing and Analysing the Superfund

Community Requirements from Business Users.

> Extensively worked with the SFCDS team to analyse the Legacy and New

Applications to design the Superfund Consolidated Data Source (SFCDS).

> Created the Scope Documentation for the implementation of Superfund

Consolidated Data Source (SFCDS).

> Assisted in creating Data Mart to support Superfund Consolidated Data

Source and various other Projects.

> Extensively involved in Dimensional Data Modelling, ETL Design and

Universe Design for SFCDS.

> Interacted with the various Data Source Teams involved and gathered

the Data.

> Developed strategies for data extraction from various source systems,

transformation and loading into SFCDS target system.

> Worked with functional analyst to Document the Source-Target mappings

with the business logic.

> Extensively used Informatica to Create Mappings, Workflows and Jobs

for data extraction and Loading.

> Build the XML's for deployment of the code from development to staging

to production.

> Verify the logs to confirm all the relevant jobs are completed

successfully and timely and involved in production support to resolve

the production issues.

> Provided Solution to Automate Superfund Consolidated Data Source

(SFCDS) process using Business Objects Reporting Tool.

> Created Universes based on Reporting Requirements and modified

existing universes to cater the Reporting Needs.

> Extensively worked on BO Web Intelligence and Full Client Canned and

Ad-Hoc Reports.

> Converted the existing Full Client and WEBI Reports as part of the

Migration.

> Created simple and complex Dashboards using Xcelsius and Live Office

> Performed Report Scheduling, Publication, Report Bursting Setup.

> Created Package Build Forms for deployment from one environment to the

other.

> Developed Test cases/scenarios with concerned users and obtaining

necessary sign offs.

> Interacted with Business users to understand the issues and action the

support tickets.

> Scheduled the Reports as per requirement and distributed it to

different Functional Groups.

> Created Documentation for the whole scenario of the project.

Environment:

Business Objects XI R3.1, Informatica 9.1.0, Windows 7 Professional/2003

Server, AIX, Linux, Erwin/Visio, Oracle 10g / 11g, Microsoft Share point

Portal, XML, Tomcat, Apache, Toad 10.6, SQL Developer.

FormFactor Inc

Livermore, CA

07/10 - 09/11

Business Objects & Informatica Consultant

Responsibilities:

> Involved in Gathering and Analyzing the Requirements from Business

Users and Engineers.

> Understanding the Manual Process used for tracking the Lead Times on

the Probe Cards Manufacturing.

> Documented the Manual Process Involved in Tracking the Lead Times to

Build a LTM Reporting Tool.

> Created the Scope Documentation for the implementation of Lead Time

Management Reporting Tool.

> Provided Solution to Automate Lead Time Manual Process using Business

Objects Reporting Tool.

> Interacted with the various Data Source Teams involved and gathered

the Data.

> Documented the Data Source Mapping for the different Source Systems

involved.

> Data Modelling, ETL Design Semantic layer/Universe Design and

Dashboard Design.

> Created a Data Mart to support the Lead Time Management Tool and

various other Projects.

> Extensively used Informatica to Create Mappings, Workflows and Jobs

for data Extraction and Loading.

> Installed and Configured Business Objects XI R3.1 on clustered

environments of Windows and UNIX.

> Configured BOE with Windows Active Directory (AD) with SSO (Single

Sign On).

> Created the BIAR files to backup the Content in Business Objects XI

R2.

> Migrated Business Objects XI R2 to Business Objects XI R3.1 using

Import Wizard and LCM.

> Provided Complete Support to entire Business Intelligence environment

right from software installation, configuration, upgrades and

enhancements.

> Extensively Worked with CMS and CMC components to configure and

maintain BO environment.

> Installed Service/Fix packs, critical hot fix and monthly hot fix.

> Configured Audit Database on all the servers and created the Audit

Reports.

> Created Universes for Reporting Requirements and modified existing

ones to cater the Reporting Needs.

> Extensively worked on BO Web Intelligence and Full Client Canned and

Ad-Hoc Reports.

> Created Hyperlinked Web Intelligence (WEBI) Reports using Open

Document Functionality.

> Converted Existing TABLEAU Reports to Business Objects as part of the

Workflow Migration.

> Created simple and complex Scorecards and Dashboards using Xcelsius

and Live Office

> Performed Report Scheduling, Publication, Report Bursting Setup.

> Created Tasks, CCB (Change Management) and PMF (Production Migration

Forms).

> Developed Test cases/scenarios with concerned users and obtaining

necessary sign offs.

> Interacted with Business users to understand the issues and action the

support tickets.

> Scheduled the Reports as per requirement and distributed it to

different Functional Groups.

> Created Documentation for the whole scenario of the project.

Environment:

Business Objects XI R3.1/XI R2, Windows XP/2003 Server, Unix, Sun Solaris,

Informatica 8.5, Oracle 10g, Salesforce CRM, Oracle Applications, Agile,

Erwin/Visio, Microsoft Share point Portal, JAVA, XML, Tomcat, Apache, Toad

9.7.2, SQL Developer.

Toyota Motor Engineering & Manufacturing North America

03/10 - 07/10

Erlanger, KY

Business Objects & Informatica Consultant

Toyota Motor Engineering & Manufacturing North America (TEMA) is an

automobile manufacturing and research and development company owned by

Toyota Motor Company. It is the result of a merger of Toyota Motor

Manufacturing North America (TMMNA) and Toyota Technical Center (TTC)

U.S.A., and has its headquarters at the former TMMNA headquarters in

Erlanger, KY.

Responsibilities:

> Involved in Functional and Technical Requirements gathering from

Business Users & Divisions.

> Coordinated with the Design Team to create Datawarehouse and Data

Marts.

> Installed and Configured Business Objects XI R3.0 Server and Client

components.

> Integrated Business Objects environments with Lightweight Directory

Access Protocol (LDAP) SSL.

> Installed and Configured Business Objects Integration kit for SAP.

> Migrated Business Objects XI R2 to XI 3.0 using Import Wizard and Life

Cycle Manager (LCM).

> Extensively Worked with CMC to Manage Servers/Server Groups,

Users/User Groups, Folders and File-based Events.

> Configured BOE Job Servers E-mail and FTP destinations for scheduled

reports.

> Extensively worked on Informatica to Create Informatica Mappings,

Sessions and Jobs for data Extraction and Loading.

> Created complex Universes for Reporting Requirements and modified the

existing ones as part of enhancing the universes to satisfy the new

and existing reporting requirements.

> Linked the Universes to shared common objects. Updated and maintained

Universes based on changing user requirements and data source changes.

> Created Complex Desk I and Web I (Web intelligence) Reports and

modified existing Reports.

> Created Reports from Multiple Data Providers each of the Data Provider

being on a different Database Platforms as part of integrating the

Data from the Plan View and People Soft Application.

> Created On Demand, Ad-Hoc, Summary, Cross-tab, Conditional, Drill-

down, Charts, Sub and Graphical Reports using Business Objects and

Crystal Reports.

> Extensively used Business Objects SDK to customize look and feel of

Business Objects Reports.

> Provided recommendations on performance enhancements in Pre/Post

Production environments.

> Involved in Production support for fixing the issues pertaining to

Business Objects Environment.

> Scheduled the Reports and Distributed Reports in multiple formats such

as Excel, word, HTML & PDF.

> Provided Technical support to Power/End Users

> Created Documentation for knowledge transfer (KT).

Environment:

Business Objects Enterprise XI R3.0/XI R2, Crystal Enterprise XI, IIS,

Tomcat, Apache, Informatica 8.0, Plainview Portfolio Management, People

Soft HR System, Windows XP/2003 Server, Oracle 9i, MS SQL Server 2005/2008,

TOAD 8.5.1.

WellPoint Precision Rx Inc., Express Scripts Inc.

10/09 - 03/10

Indianapolis, IN

Lead Business Objects Consultant

Precision Rx Specialty Solutions (PRxSS) is a full-service specialty

pharmacy based in Indianapolis, IN that is backed by the nation's leading

health benefits company. Designed to more effectively manage and monitor

the distribution of specialty drugs, PRxSS offers a robust support program

including a team of personal care coordinators, pharmacists and nurses to

help people taking specialty medications achieve the best possible outcomes

from their treatments. It offers condition-specific member care

coordination-through a dedicated team of health professionals-to help

promote quality, safety and clinical effectiveness in the treatment of

complex, chronic diseases. Express Scripts Inc, one of the Nation's largest

Pharmacy, recently acquired WellPoint NextRx.

Responsibilities:

> Interacted with Business Analysts, Business Users and Managers in

gathering Business Requirements.

> Understand the business requirements and come up with High-level

Reporting Requirements, Semantic Design, Dashboard Design and Report

Mapping Design Documents.

> Estimated High-level project effort and resource requirements.

> Extensively Worked with CMC to manage the BOE environment.

> Used Import Wizard for migrating Folders, Groups, Objects, and

Universes from Development to Test to Production Environments and

create BIAR files for back up.

> Extensively used SQL Server Integration Services (SSIS) to extract and

load data.

> Used Report Conversion Tool to convert Desktop Intelligence reports to

Web-I reports.

> Created Simple and complex universes to meet the Reporting

Requirements.

> Performed linking of the universes, and applied hierarchies based on

business procedures.

> Created Web-I Reports on multiple universes with Ranking, Filters,

Prompts and Formulas.

> Extensively Worked on Crystal Reports making use of formulas,

parameters, field expressions, special fields, mapping to data

sources, performing linking etc.

> Query Performance Optimization.

> Performed troubleshooting users having problems with B.O. Security,

Access to Applications, Web-I reports, Universe connections, Session

timeouts, and Report schedules etc.

> Experience in Crystal Xcelsius creating Templates, Visualizations,

Charts, Sliders, and Gauges.

> Interact and Delegate work to offshore Team.

> Demonstrate leadership in problem solving and mentorship, in depth

knowledge of business intelligence, Business Objects and data

warehouse technology.

> Provided complete Documentation for the whole scenario of the project.

Environment:

Business Objects XI R2, Crystal Reports XI,IIS, Tomcat, Oracle 10g/ 9i, SQL

Server 2005, DB 2,Remedy Ticketing System, TOAD 9.0.1.8

Sallie Mae, Vangent Inc., Coralville, IA

04/09 - 10/09

Business Objects & Informatica Consultant

Sallie Mae , the nation's leading provider of saving, planning and

paying for education programs. The company provides federal and private

student loans for undergraduate and graduate students and their parents.

Vangent Inc. provides IT support for Sallie Mae Inc. which funds

private education and federally guaranteed consolidation loans to students

and families nationwide. Vangent Inc. is currently dealing with the project

Falcon -- Department of Education Servicing Contract by Sallie Mae Inc. It

involves developing the Data Mart based on FSA Database called CLASS which

is on DB2 and Mainframes and also provide Daily, Monthly and Quarterly

Reports based on the Data Mart to be delivered to Sallie Mae Inc and FSA.

Responsibilities:

> Involved in Client Interaction and Understanding the Requirements

> Created the Business Requirement Document (BRD) and Technical

Requirement Document (TSD).

> Coordinated with the Design Team in defining the data model and its

attributes.

> Performed Analysis of migration content to the New Environment.

> Installed and Configured Business Objects XI 3.O server/client tools,

QaaWS, and Crystal Celsius.

> Configured and Managed Auditor on Business Objects Servers to track

User and System Activity.

> Performed through testing on the content in the new environment

migrated from the previous system

> Configured and Deployed Performance management applications.

> Extensively used CCM to manage various BO servers.

> Used the CMC to secure dashboards and restrict access to performance

management.

> Extensively worked on Central Management Console (CMC) and Info-view

to perform Business Objects Server side Administrator role to manage

users, objects, security both user level and object level.

> Responsible for developing BW data models and designs, configuring

custom and delivered content BW objects, analyzing BW reporting

requirements, developing detailed reporting specifications

> Designed, developed ETL and extracted SAP BW Data for Reporting needs.

> Extensively worked on SAP BW/BI content.

> Identified possible Reports that Department of Education need from

Sallie Mae to service the FSA loans.

> Identified the scope of the Reports and distributed them into Business

Objects or Crystal Reports.

> Designed Universe on data model for three segments Loan Transactions,

Loan Daily, Loan Monthly.

> Designed universes for Reporting and Metric Universes for Performance

Management.

> Created Universes using SAP BI/BW Queries as Source Data.

> Created WEBI and Crystal Reports and deployed them through Info View

with BW Universe as Source.

> Created Contexts/Aliases for resolving Loops and Hierarchies to

support Drill up/down.

> Performed Testing of universes, reports functionalities, reports

performance, Dashboards functionalities in the new environments before

migrating.

> Created Complex Desk I, Web I and Crystal Reports (Loan Servicing,

Financial Transaction and Claim Reports) using universes, free hand

SQL, Stored Procedures and Personal Data Files.

> Created Several Drill Up/Down, Drill through Capable, Hyper-linked

Reports and used Calculations, Variables, Breaks, Sorting, and Alerts

for creating Business Objects reports.

> Added, Modified and positioned analytics and Web I reports in

personal, corporate Dashboards and in compound analytics.

> Performed Ad-hoc query testing on universes, Developed Test scripts

and tested reports data.

> Tested the system before going live by increment users and different

activities.

> Scheduled and Distributed Reports in multiple formats (Excel, HTML,

PDF, Fixed Width Text & CSV).

> Trained Users to build Reports and use the different functionalities

Available in the Reporter Component.

> Created Documentation for the whole scenario of the project.

Environment:

Business Objects Enterprise XI R2/3.0, Crystal Reports XI, SAP BW3.5,

Informatica, Windows XP/2003 Server SP1, Oracle 10g, .NET (ASP), Erwin4.1,

TOAD 8.0, SQL Developer.

Synovus Financial Corp.,

Columbus, GA

09/08 - 04/09

Business Objects Consultant

Synovus Financial Corp is one of the largest Financial Institutions in

the Southeast Region, providing Banking, Investments, Asset Management

Services, Commercial and Retail Banking to customers. It emerged as one of

the strongest and most capable regional banking networks in US. Synovus

Financial Corp has implemented Business Objects as an OLAP tool for

reporting across all the data marts for SFC Loans.

Responsibilities:

> Involved in functional requirement gathering from Business Users &

Teams.

> Prepared Requirements specification documents, Business Objects

environment specifications, Business Objects sizing and capacity

planning documents.

> Prepared Technical specifications for Lender workbench and LLR Data

mart, Universes and Reports.

> Involved in designing\modelling using ERWIN the Data Marts adhering to

the Enterprise Standards.

> Developed ETL Jobs using SQL Server 2005 - Integration Services (SSIS)

from various sources and constructed daily and weekly batch process to

load the LLR\Lender workbench Data Marts.

> Worked with business team in finalizing the Report Design by creating

excel and HTML mock-ups and upon approval involved in designing \

construction of reports.

> Analyzed Existing System and gathered and prepared a list of items

that needs to be migrated.

> Discussed the Pros and Cons with the limitations and Future

consequences of BOXI R2 with the Team.

> Migrated the Existing Version of Business Objects to Newer Version and

customized the system.

> Installed and Configured Business Objects XI R2 on Production,

Development and Test servers.

> Involved in the sizing in BOXI R2 to meet the old system requirements.

> Installed and configured server settings and created server groups.

> Extensively used CCM(Central Configuration Manager) to manage the BO

servers.

> Created New Universes and Applied Row Level and Object Level

Securities.

> Analyzed macros from old system and created an easy work around

process in the new system.

> Tested the system before going live by increment users and different

activities.

> Configured the Web and Application servers for the new Business

Objects server.

> Configured and Deployed Performance management applications.

> Used the CMC to secure dashboards and restrict access to performance

management and used designer to restrict access to metrics.

> Created Universes based on the reporting requirements and modified the

existing ones as part of enhancing the universes to satisfy the new

reporting requirements.

> Designed universes for Reporting and Metric Universes for Performance

Management.

> Added, Modified and positioned analytics and WEB I reports in

personal, corporate Dashboards and in compound analytics.

> Created Complex Full client and WebI Reports and Modified existing

Reports based on Requirements.

> Extensively worked with formatting the reports according to user

requirements

> Performed Ad-hoc query testing on universes, Developed Test scripts

and tested reports data.

> Created several Interactive Web pages in .NET (ASP) and integrated

with Database.

> Migrated Universes, Reports, Folders from Dev to QA to Production

environments using Import Wizard.

> Trained the End Users and Power Users to Create Reports.

> Created Documentation for the whole scenario of the project.

Environment:

Business Objects Enterprise suite XI R2/6.1, Apache, Tomcat 5.0.27, Windows

XP/2003 Server SP1, Teradata V2R6.2, MS SQL Server 2000/2005,.NET (ASP),Erwin4.1,Teradata SQL Assistant, Toad.

JP Morgan Chase

03/07 - 09/08

Treasury & Security Services, Tampa, FL

Business Objects Consultant

JP Morgan Chase has implemented Business Objects as an OLAP tool for

reporting across all the data marts for Treasury & Security Services (TSS).

The current deployment of Business Objects allows users of the different

data marts to create and analyze canned as well as ad hoc reports across

various universes and data sources.

Responsibilities:

> Involved in gathering requirement from End Users and translated

requirements to Technical Specifications for the DDA (Demand Draft

Account) and Liquidity Data Mart Universes & Reports.

> Acted as a supervisor and led the execution of reporting projects

across all 7 data marts.

> Administered and Maintained the Business Objects Servers in Production

and Development environments.

> Installed and Configured Business Objects XI R2 on Production,

Development and Test servers.

> Configured the Web and Application servers for the new Business

Objects server.

> Setup single sign on functionality with LDAP.

> Created different CMS clusters and also different server groups to

gain performance.

> Configured the auditing database to track the users and system

activity.

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

> Created User Groups, Users, Categories and Profiles and assigned

privileges based on there roles.

> Created new universes for upcoming reporting requirements and modified

the existing ones as part of enhancing the universes to satisfy the

new reporting requirements.

> Provided support to an existing data mart against the MS SQL Server

2005

> Provided support to the End Users in installing and configuring

Business Objects desktops products.

> Rebuilt and modified the existing universes based on DB2 Database (DDA

and Liquidity) to Oracle Database (Namely DDA ORA and Liquidity ORA)

universes.

> As a measure to improve the performance of the reports we planned to

have constraints on the universe.

> Created and modified Full client and Web I Reports based on the

business requirements.

> Created Complex reports using universes, Personal Data files, free

hand SQL, Stored Procedures and migrated the already existing excel

reports to Business Objects.

> Created Cross-tab, Conditional, Drill-down, Charts and Sub reports.

> Designed and Developed complex reports using Crystal Reports involving

Standard Reports, Mailing Label Reports, Sub reports, Graphs and Cross

Tabs.

> Created Daily and Monthly reports for Bear Stearns Inc a recent

acquisition by JPMorgan Chase.

> Applied Row and Object Level Restrictions to the different user.

> Developed stored procedures, packages and views for use in crystal

reports

> Created Macros using BO SDK (VBA) to generate Excel and PDF files from

business objects reports.

> Scheduled and Published the reports using CMC and Infoview.

> Distributed reports in multiple formats such as Excel, word, HTML &

PDF and monitored the reports daily in Business Objects environment

this was done using the existing Batch Script Files..

> Involved in technical, production support for Fixing issues pertaining

to Business Objects environment.

Environment:

Business Objects Enterprise suite XI R2/6.5.1, Crystal Reports XI/9.0

Windows XP/2003 Server SP1, Oracle 9i, MS SQL Server 2005, IBM DB2 V 7 / 8,

TOAD.

MCKESSON CORPORATION, Richmond, VA

04/05 - 02/07

Business Objects Consultant

McKesson Corp is one of the leading global, broad-based health care

companies providing reliable service and delivering to the customers. The

aim of the eBReporter project was to develop a Reporting System comprising

of different Universes, Canned & Ad-hoc Reports and corporate Repositories

to support decision making for Target executives, managers, and HR

Generalists as the audiences of the tool to effectively communicate and

monitor business results based on different Analysis Techniques.

Responsibilities:

> Involved in functional requirement gathering from Business Users &

Teams.

> Installed & Configured Business Objects XI R2 Enterprise Suite.

> Created Users/User groups and assigned privileges using Central

Management Console (CMC).

> Assigned row level and object level security using Designer in BO

XI R2.

> Converting Desktop Intelligence Documents to Web-Intelligence

Reports using RCT

> Created schemas for the warehouse and BI Analysis Requirements

using ERWIN by designing Logical Datamart Schema and Creating

Physical Data-models.

> Involved in designing and Building Universes from different data

sources (Oracle and SQL Server).

> Linked Universes to share Universes which had common dimension

tables and classes and objects.

> Created Contexts, Joins and Aliases for resolving Loops and check

Integrity of Universes.

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

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

> Created Desk I and Web I Reports based on Business Requirements

from Multiple Data Sources.

> Designed, Developed and tested Reports based on data generated by

enterprise transaction, financial and customer information systems.

> Assisted in migration of crystal reports from R1 to R2-Resolved

Issues related to report distribution.

> Created Crystal Reports based on requirements which included

designing cross tab, summary Reports, Sub-Reports with parameter

passing from tables, views and stored procedures.

> Scheduled and Published the Reports through Schedule manager on a

regular basis.

> Involved in Production Support and trained the end users.

Environment:

Business Objects XI R2, Crystal Reports XI, Oracle 10g, MS SQL Server

2005, TOAD, PL/SQL, TOAD,

Windows 2003 Server, Red Hat Linux 8.0/9/1.

UNITED HEALTH GROUP, Minnetonka, MN

02/04 - 02/05

Business Objects Consultant

United Health Group is a diversified health and well-being company

dedicated to making the health care system work better. This project

involved developing a Centralized Universe for the Enterprise Data

Warehouse and creating a meta-data layer to support their business needs

across different business units like sales, service, and customer and

employee data management.

Responsibilities:

> Involved in gathering requirements from Business Users of different

Departments

> Involved in Installation, Configuration of Business Objects on

Windows 2000 Advanced server.

> Involved in Creating Users/User Groups and assigned privileges

depending on User profile.

> Installed and configured Broadcast agent server, Web Intelligence

6.x server for use with Zero Administration (ZABO) clients and

created interfaces using Web Intelligence 6.x.

> Assisted in Migration from BO 5.1.6 to 6.X including installation

and Configuration.

> Created Users/Groups/Sub-Groups and assigned profiles to restrict

unauthenticated access.

> Extensively tested and migrated the reports from 5.1.6 to 6.1b

Version.

> Designed and Built Universes, Classes and Objects, employing

integrity check.

> Controlled resources like Universes, Documents being a Supervisor-

Designer and also applied command level restrictions to different

users and groups.

> Defined Aliases and Contexts to resolve the join issues in the

Universe.

> Solved the issues during designing such as loops, Cartesian product

due to fan and chasm traps.

> Published the universes to the Repository for making resources

available to the users.

> Created Desk I & Web I Reports for various Portfolios using the

Universes.

> Created the reports using Business Objects functionalities like

Queries, Slice & Dice, Drill down, @Functions, Cross Tab,

Master/Detail and Formulae etc.

> Created Reports using Business Objects functionalities like

Queries, Cross Tab, Master Detail and Formulae and extensively used

Alerts and Filters to highlight data and filter records in reports.

> Brought data from a personal data file into BO and combine it with

data from a BO Universe query.

> Tuned the queries to improve the Performance of the existing

Reports for various functional areas.

> Scheduled Business Objects Reports using Broadcast Agent.

> Created Detail Design Documents & Trained users at different levels

of Report Creation.

Environment:

Business Objects 6.5.1/5.1.6 (Supervisor, Designer, Reporter, Broadcast

Agent, Web Intelligence, ZABO, InfoView, Auditor), Windows NT/2000 server,

Oracle9i, MS-Office, TOAD.

ICICI BANK, India

06/03 - 12/03

Report Developer

ICICI Bank one of biggest Banking & Financial Company with wide range

of Business Areas. The project involved creation of Reports for a Central

Data warehouse for the Debit division of ICICI Bank. This warehouse is

projected to assist Sales and Marketing Department to categorize their

customers based on significant portfolio of services including checking

accounts, savings accounts, personal loans and geographical area.

Responsibilities:

> Gathered the Reporting Requirements from the Business.

> Created Reports using Crystal Reports & Business Objects.

> Created Business Objects Reports for day-to-day Analysis &

Calculations.

> Worked with BO reporting features like Breaks, Alerter, Filters,

Sorts, and Query prompt and Drill filters.

> Analyzed the reports using the Drill Through, Slice and Dice.

> Setup Print Setup & Configurations for all the Reports.

Environment:

Crystal Reports 6.0, Business Objects 4.X, Oracle 8.1, MS Excel, SQL,

PL/SQL, and Windows NT/2000, Sun Solaris.

Contact this candidate