Developer Project

Anand Gupta(Business Objects Professional)

Contact - (0044) 075********

Email - *****.*****@*****.***

DOB - 04-11-1981

Address - Sheffield, United Kingdom

Career Summary

> A diversely skilled Programmer Analyst with over 3.8 years of experience,

in a leading services based Company, on projects related to Business

Intelligence, with specialization in Business Objects

Administration/Architecture and Universe Development (6.x/XI R2/XI R3).

> Experienced in installation, clustering and performance tuning of XI

R2/R3. Also created Disaster Recovery plans for projects.

> Load testing (stress, capacity and performance) of the BO XI Cluster

using tools like JMETER and WAPT for capacity planning.

> Implemented security for projects using user/groups access levels and row

level restrictions/ object level security.

> Experience in migration from BO 6.x to XI R2 and XI R2 to XI R3(3.1).

> Developed custom applications using Business Objects SDKs for

maintenance, scheduling, backup etc. Developed customized JSR 168

compliant infoview portlet (for viewing reports).

> Led a software development team for design and development of critical

reports (showing KPIs) for deployment on PDAs and smart phones to be

viewed by the Top Management. The project was implemented using DOT NET

(Client) and Java (web services).

> Implemented Software based Load Balancing for application servers as

needed.

> Developed webi/deski/performance management/crystal reports and universes

for various projects and used features like drilling, sections, cascading

prompts, aggregate awareness, single pass bursting etc.

> Worked on modules like Qaaws (Query as a web service), Live Office,

Xcelcius, LCM, Webi Rich Client etc.

> SAP BW and BO connectivity using SAP integration kit

Qualification

B.Tech, ICT (Information and Communication Technology) - May 2006

DA-IICT, India

Professional Experience

Organization Role(s) Period

Mphasis Ltd BO Feb 2008 - Till Date

(HP Enterprise Developer/Administrator

Services)

Datastage Developer

Reliance BO Jun 2006 - Feb 2008

Communications Developer/Administrator

Skills

Skill Details

OS Windows 2000/2003/2008, Linux, Solaris 5.8/5.10,

AIX.

Languages/Skills Java/J2EE, PL/SQL, Unix Shell Scripts, VB .Net

RDBMS Oracle 9i/10G, SQL Server 2005, MySql

Web/Application Tomcat 4.x/5.x, Websphere Application Server

Servers 5.x/6.x, Weblogic 8/9, IIS 6/7

BI Tools Business Objects 6.1b/XI R2/R3 (R3.1)

ETL Tools Ascential Datastage 7.5x2

Projects:

Mphasis Ltd. (Feb 08 - Till date)

1. LMS MI Development

Duration : Jun 2009 - Till Date

Environment : AIX, Oracle 9i/10g

Skill/Tools : BO XI R2

Role : Senior BO Developer

Client: DWP (Department of Work and Pensions)

The Department for Work and Pensions leads the UK Government's response to

some of the biggest issues facing the country - welfare and pension reform

- and is a key player in tackling child poverty. It is the biggest public

service delivery department in the UK and serves over 20 million customers.

Summary: This involved universe and reports development for LMS (Labour

Market System). Universe/ Reports were created for various functional areas

like FND, PtW, NINo, ESA etc. Most of the reports used a common hierarchy

which was included in the universe template for ease of development. Builds

were released after testing which was then sent to AMS team for deployment

on production. Star team was used for version control and configuration

management. Backups were taken weekly. Also involved performance tuning of

report SQLs.

2. Migration to BO XI R3.1

Duration : Dec 2008 - May 2009

Environment : Windows 2003/2008, Oracle 10g

Skill/Tools : BO XI R2/R3.1

Role : BO Architect/Administrator

Client: Miller Coors

MillerCoors is a joint venture between SABMiller and Molson Coors Brewing

Company, has the responsibility of selling brands such as Miller Lite,

Miller High Life, Miller Genuine Draft, Coors, Coors Light, Molson

Canadian, and Steel Reserve in the United States, with the purpose of

combining all of their US brewing operations.

Summary: This involved installation, configuration, clustering of XI R3.1

and migration of universe/reports from XI R2. Single sign on (SSO) was

implemented using Windows AD and Kerberos. The system was deployed on

VMware. Also involved installation and testing of Live Office XI R3. IIS

7.0 was used as application server. Load/stress testing was done for

capacity planning. Also created DR plan.

3. Business Information Systems

Duration : Jun 2008 - Nov 2008

Environment : Solaris 5.8, Oracle 9i, MVS

Skill/Tools : Ascential Datastage 7.5x2, Microstrategy 8

Role : Business Intelligence Developer

Client: General Motors

General Motors Company, is a United States based automaker with

headquarters in Detroit, Michigan.

Summary: The project involved:

> Data warehouse for General Motors related to Vehicle Management,

Accounts, Payroll, Financial and Property Tax Management System.

> Yearly/Monthly/Daily loads, CRs and Tickets.

> Automation of manual processes in production support for various

applications.

There were total 15 applications receiving data from diverse systems,

which had to be loaded in datawarehouse/datamarts using Ascential

Datastage(server, parallel and mainframe jobs). In few applications, the

data was loaded using procedures/shell scripts for which ETL jobs were

created later.

4. BI Practice Support

Duration : Feb 2008 - May 2008

Skill/Tools : BO 6.5/XI R2

Role : Business Objects Developer/Administrator

Summary:

As a member of BI Practice, supported various projects having issues on

Business Objects like:

> deski memory leak

> session cleanup problems

> clustering issues

> developing custom scheduler using BO XI Java SDK to enable

monitoring/rescheduling of reports (XI R2)

> Customizing Infoview etc.

Also assisted for POCs, created RFPs and effort estimations for projects in

transition.

Reliance Communications (Jun 06 - Feb 08)

BO XI R3 beta Testing

Environment : Solaris 10, Oracle 10g

Client : Business Objects

Role : Lead BO Developer/Administrator

Summary:

The project involved:

> Testing R3 for new features/performance

> Testing R3 for Bugs that had been fixed

> Evaluation of Webi Rich Client

Migration from Tomcat 5.0.27 to IBM WAS 6.0(Network Deployment)

Environment: Solaris 10, BO XI R2, Oracle 10g

Role : Business Objects Administrator

Summary: The project involved:

> WAS 6.0 installation and configuration

> Deploying BO XI WCA and web modules on WAS 6.0

> Web applications testing.

Migration to BO XI R2 / Custom Applications Development

Summary: This involved installation, configuration, clustering, load

balancing (software based) and migration from version 6.1b. New

functionalities of XI R2 (like single pass report bursting etc.) were

tested. Security was rebuilt in XI R2 SP1 as migration of the same was not

recommended by Business Objects.

Custom applications were developed using BO Java SDKs to help in day to day

activities and maintenance of the XI System. Patches and service packs were

applied as and when released.

Business Intelligence (Decision Support System)

Environment: BO 6.1b/XI R2, Oracle 9i/10g

Role : Business Objects Developer

Summary: Developed reports and universes for various applications like ICC

(International calling card), Customer Acquisition, RWorld, RConnect, LEA

etc. Also implemented drill down, cascading prompts etc. on reports and row

level restrictions on universe for security as there were users with access

to data for one/multiple zones.

Professional Trainings on Business Objects XI:

1. SA210R2

2. SA310R2

3. SA410R2

The session was conducted by Euthenics (Business Objects Education Partner)

Declaration: The above information is correct to the best of my knowledge.

Anand Gupta [pic]

Contact this candidate