PROFESSIONAL SUMMARY: ROLES:

**.* Years of experience in full application Business Objects /

life cycle Analysis, Design, Development, Crystal Reports

Testing and Delivery, which includes 32+ Months Consultant

of Onsite experience (in USA and Dubai).

Comprehensive experience on BI technologies like Project Lead

Business Objects, Crystal Reports & BRIO

(Development and Testing). Onsite Coordinator

Excellent interpersonal skills, proactive,

detail oriented. Works well in mitigation

situations. BOE XIR2, 3.1, 4.0

Provides innovative solutions to problems. & BI4.1

Flexible and adaptable to latest technology Administrator

trends.

Wide experience as a team player, project

leader, configuration manager, defect prevention

representative and Application Testing.

Innovative in Approach, Enjoys learning new

methods and ideas and putting them into daily

practice.

EDUCATION SUMMARY:

o Master of Computer Applications, Periyar University, India

o Bachelor of Science (Physics), Madras University, India

o Trained in Data Warehouse concepts, Business Objects XI-R3, BI4.0, BI4.1

& Crystal Reports

o Certified in Crystal Reports

TECHNICAL SKILLS:

Reporting Tools Business Objects 5x, 6x, XI-R1, XI-R2, XI-R3 and BI4.1

(CMC, Supervisor, Designer, Reporter, Info

view, Web Intelligence, Broadcast Agent), BRIO

6.6 and Crystal Reports 8.5, 9.0, XI-R2 and

CR2008.

BOE XI R2(CMC/Server) Admin.

Operating Systems Windows - 9x/NT/2000/XP/Vista

Languages Microsoft Visual Basic 6.0

Databases Oracle 10g, MS-SQL Server 2000 & 2005, Sybase 12.5

People Skills/Processes/Best Practices Requirement gathering, Continuous

Integration, Client Interaction, Peer Reviews,

Rapid Application Development process, Testing,

Managing mid scale (5- 12 employees) team

WORK PROFILE:

Tata Consultancy Services Jul 2010 - Till Date

Tata Consultancy Services (TCS) is one of the world's leading information

technology companies. Through its Global Network Delivery Model Innovation

Network, and Solution Accelerators, TCS focuses on helping global

organizations address their business challenges effectively.

Cognizant Technology Solutions (I) Pvt. Ltd., Oct 2004 -

May 2010

Cognizant Technology Solutions is a PCMM SEI-CMM Level 5 company a

Leading provider of IT services. Focused on delivering strategic

information technology solutions that address the complex business needs of

its clients, Cognizant provides applications management, development,

integration, and re-engineering, infrastructure management, business

process outsourcing and a number of related services such as enterprise

consulting, technology architecture, program management and change

management through its onsite/offshore outsourcing model.

Net Kraft Pvt., Ltd, Bangalore Mar 2004 - Oct

2004

Net Kraft is a CMMI Level 5 Bangalore Based IT Services Company

providing enterprise wide software services to customers around the world

through the offshore delivery model. Net Kraft offers a comprehensive set

of software services and products that supports the Health care, Retail

software development life cycle. The company is developing and testing

advanced Products and services that care to the rapidly changing needs of

the business community.

REPRESENTATIVE PROJECT EXPERIENCE SUMMARY

Client Project Technology Roles and Duration

Responsibilities (In

Months)

Cargill Inc CFS BI4.1, Oracle Administration, 7

10g, BMC application support &

Remedy Project Lead.

BOA ER511 BO3.1, BI4.1, Administration and 18

Oracle 10g Application Support

BI4.1, Migration

coordinator.

Du Telecom Du-MSP BOXI-R2, BOXIR2, BI4.0 23

BI4.0, Administration and

Informatica Application Support,

8.6, Oracle Project Management,

10g Onsite Coordinator,

Migration support.

Motorola EIM-EDW BO XI-R2, BO Report enhancement 6

Separation WebI & Testing

Oracle 10g

BCBS-LA BCBS-Claims Crystal Requirement gathering, 13

Datastore Reports analyzing, Report

XI-R2/2008, development and

SQL Server Testing

2005

Aetna ADA-Corpora Business Requirement gathering, 13

te SRS Objects, Offshore coordination,

Crystal BO XI R2 Server

Reports XI-R2 Administration,

Production support -

Report/Universe

deployment to

different environment

and resolving

production tickets

Aetna Callidus-SR Brio 6.6, DB2 Report development and 4

1415 Testing

WellPoint AMMS Business Requirement gathering, 4

Shutdown Objects 6.5 analyzing, report

development and

testing

Group eWatson Business Requirement gathering, 6

Health Co Reporting - Objects 6.5, Co coordinating

operative Pilot Informatica Offshore/Onsite team,

project 7.1, Pega preparing functional

and technical document

for BO report

development, BO

Universe and Report

Development. Performed

Unit Testing for

Universe and Reports

Managed MHN - DWH SC Warehouse Project Initiation, 1

Health Builder, Resource Estimation,

Network AS/400, SQL Requirement gathering

Server & Analysis, Preparing

Analysis document

Group eWatson Business Requirement gathering, 2

Health Co Reporting Objects preparing functional

operative XI-R2, and technical document

Informatica for BO report

7.1, Pega development

Aetna ADS - Brio 6.6 Report development and 3

Calidus Testing

Premera Knowledge SQL Server Database Testing. 4

Blue Cross Services 2000

BAT

Aetna ADS BSD PMO Business Universe Designing, 18

Reporting Objects 6.1b, Report Development in

Crystal Business Objects and

Reports 8.5 & Crystal reports.

9.0 Migration of reports

from Crystal Reports

to Business Objects.

Mellon MHIRS BO Business Report Development in 3

Objects, Web Business Objects and

Intelligence Testing the Reports

6.0, SQL which have been

Server 2000 migrated from Crystal

Reports

3M 3M VIP Business Analysis, Design 3

Objects &Development of Data

5.1.5, Erwin Modeling, Universe

Designing and Reports

Development

HomeBase AIRRA Business Requirement gathering, 5

Corporation Objects Project planning,

UK 5.1.5, MS Universe design,

Access, SQL created ad-hoc reports

Server 2000 and data migration.

HomeBase PIPPA Business Created and maintained 8

Corporation Objects payroll datamart

UK 5.1.5, BCA, universe, created

Oracle 8i reports, performed

testing and scheduling

the reports.

Project Details:

1. Cargill Inc

Duration From Jul 2014 - Till Date

Location Chennai

Technology Business Objects BI4.1, Oracle 10g, BMC Remedy.

Project The purpose of this engagement is to provide application

Abstract support to existing system and enhancing the reports and

universe as per the user requirement and administrating

central management console.

Role Requirement gathering, Leading the team and managing

deliverables.

Application Support and development of new reports.

Involved in development of existing Universes and reports in

Business Objects 4.1 environment.

CMC Administration.

2. ER511(Non Banking)

Duration From Mar 2013 - May 2014

Location Hyderabad

Technology Business Objects 3.1 and BI4.1, Oracle 10g.

Project The purpose of this engagement is to provide application

Abstract support to existing system and enhancing the reports and

universe as per the user requirement. Testing the

BI4.1environment's migrated reports and universe.

Role Application Support and development of new reports.

Requirement gathering and understanding the scope of the D2D

operations.

Migration coordinator for lower to BI4.1 environment.

Provided support in testing for new BI4.1 environment and

report performance tuning.

3. Du-MSP

Duration Mar 2011 - Feb 2013

Location Dubai & Hyderabad

Technology Business Objects XI-R2, BI4.0

Project Du-MSP is Providing production support to existing

Abstract application and focusing on resolving production issues on

timely basis and migrating reports and universes to other

environment and administrating Business Objects servers and

CMC.

Requirement gathering, Offshore coordination, Production

support - Report/Universe deployment to different environment

and resolving production tickets. CMS connection monitoring

and resolving cluster issues.

Role CMC and Server Administration (BOXIR2 & BI4.0).

Requirement gathering and understanding the scope of the D2D

operations.

Onsite coordinator and leading offshore team

Provided production support for existing environment and

deployment.

Content Migration from lower to higher environment.

4. EIM-EDW Separation

Duration Aug 2010 - Feb 2011

Location Hyderabad - India

Technology BOE XI-R2, WebI, Oracle 10g

Project Motorola has been divided into Mobility and Solutions.

Abstract Current system has been replicated for Mobility and the

existing EDW system will be retained by solutions.

The purpose of this engagement is to test the BO reports

against existing and newly separated environment.

Role BOE XI R2 Report enhancement & WebI Reports Testing.

5. BCBS-LA CLAIMS DATASTORE

Duration Apr 2009 - May 2010

Location Chennai /Hyderabad - India

Technology Crystal Reports XI-R2/2008, SQL 2005, SSIS & C#

Project The purpose of this engagement is to assess the BCBS-LA's

Abstract in-house Claims Payment System in order to improve the

operations from reliability, accuracy, efficiency &

scalability aspects and provide agility to scale up to future

growth in the membership.

Role Requirement gathering with respect to reporting side and

analyzing the existing reports and deployment strategy.

Involved in report development, Report and database testing.

6. ADA-Corporate SRS

Duration Feb 2008 - Mar 2009

Location Connecticut - U.S.A

Technology Business Objects, Crystal Reports XI-R2

Project SRS is Providing production support to more than 45 existing

Abstract application and focusing on resolving production issues on

timely basis and migrating reports, universes and web code to

other environment and IIS servers and administrating Business

Objects servers and CMC.

Requirement gathering, Offshore coordination, Production

support - Report/Universe deployment to different environment

and resolving production tickets. CMS connection monitoring

and resolving cluster issues.

Role CMC and Server Admin

Requirement gathering and understanding the scope of the D2D

operations.

Onsite coordination and leading offshore team

Provided production support for reports/code development and

deployment.

7. Callidus - SR1415

Duration DEC 2007 - Feb 2008

Location Chennai - India

Technology BRIO 6.6

Project To analyze the existing Brio reporting system and to develop

Abstract and test the reports. To enhance and validating the existing

reports.

Role Analyze the scope of the reporting needs and existing reports

from business users and Project Estimation

Developed new reports as per the user requirement and

performed unit testing.

Peer review and Preparation of test case documents.

8. WellPoint - AMMS Shutdown

Duration Sep 2007 - Dec 2007

Location Chennai - India

Technology Business Objects 6.5

Project The purpose of the project is to identify the interfaces,

Abstract business processes and the specific tasks necessary to retire

the Anthem Medical Management System after the migration to

WMDS. The purpose of this project is to migrate IN, OH and

KY member accounts on CR Facets that are currently managed on

AMMS to WMDS. WMDS is the Enterprise Medical Management

application.

Role Understanding the scope of the reporting needs from business

users

Understanding the business process of generating the reports.

Understanding the current business process for easy

development and design of the data model of the application.

9. e-Watson Reporting - GHC

Duration Feb 2007 - Aug 2007

Location Seattle USA & Chennai - India

Technology Business Objects 6.5, Informatica 7.1, Pega

Project GHC-Pega's CPM and SPM framework was implemented as part of

Abstract the eWatson application. Pega uses BLOB (Binary Large OBject)

in many columns of the database to store data that is

structured in forms that cannot be readily stored in the

pre-defined database columns. Cognizant and GHC partnered in

a pilot engagement to retrieve data from BLOBs in Pega,

transform and load this data in a database using Informatica

and generate a sample report using Business Objects.

Role Project Lead

Understanding the scope of the reporting needs from business

users

Understanding the business process of generating the reports.

The process flow of creating and generating these reports.

Understanding the current business process for easy

development and design of the data model of the application.

Universe Design for CSC & SPA Applications and report

development.

Defining the High Level Architecture and the ETL strategy for

the eWatson Reporting application.

10. MHN-DWH - Managed Health Network

Duration Apr 2007

Location Oakland, US

Technology ShowCase Warehouse Builder, AS/400, SQL Server

Project MHN is a subsidiary group to Health Net corporation, having

Abstract it's own IT operation and DWH unit. Analyze the existing DWH

system to give support to ETL and Reporting areas.

Role Project Initiation & Resource Estimation

Requirement gathering & Analysis

Analyze the scope of the ETL & Reporting needs to the

existing DWH system.

11. e-Watson Reporting - GHC

Duration Feb 2007 - Mar 2007

Location Seattle - US

Technology Business Objects XI-R2, Informatica 7.1, Pega

Project GHC-Pega's CPM and SPM framework was implemented as part of

Abstract the eWatson application. Pega uses BLOB (Binary Large OBject)

in many columns of the database to store data that is

structured in forms that cannot be readily stored in the

pre-defined database columns. Cognizant and GHC partnered in

a pilot engagement to retrieve data from BLOBs in Pega,

transform and load this data in a database using Informatica

and generate a sample report using Business Objects.

Role Understanding the scope of the reporting needs from business

users

Understanding the business process of generating the reports.

The process flow of creating and generating these reports.

Understanding the current business process for easy

development and design of the data model of the application.

Defining the High Level Architecture and the ETL strategy for

the eWatson Reporting application.

12. ADS - Calidus

Duration Nov 2006 - Jan 2007

Location Chennai, India

Technology Brio 6.6

Project To analyze the existing Brio reporting system and to develop

Abstract and test the reports. To enhance and validating the existing

reports.

Role Analyze the scope of the reporting needs and existing reports

from business users

Develop new reports as per the user requirement and performed

unit testing.

Peer review and Preparation of Test case documents.

13. Knowledge Services - BAT - BCBS PREMERA

Duration Aug 2006 - Nov 2006

Location Seattle, US

Technology SQL Server 2000

Project To analyze, test, modify the existing source system and

Abstract target DWH database system. Validating the database for both

source and target.

Role Analyze the existing source and target system. Testing the

database by comparing the source and data warehouse database

Preparing functional documents and Test case documents.

Effectively managed communication through meetings and weekly

status reports.

14. ADS BSD - PMO Reporting

Duration Mar 2005 - Sep 2006

Location Chennai, India

Technology Business Objects 6.1,Web Intelligence 6.1, Info View, Crystal

Reports 8.5 & 9.0

Project Support to the existing system and proposed system viz

Abstract development of new reports in Crystal Reports and in

Business Objects and Migrating reports from Crystal Reports

to Business Objects 6.1b

Role As a Business Objects Universe designer and Report Developer,

The activities include business requirements analysis, design

Business Objects universe & reports, Migrating Reports from

Crystal Reports to Business Objects and coordinate with

Client, and production move. Organizing peer reviews.

Effectively managed communication through meetings, weekly

status reports, and checkpoints. Designed and implemented

Business Objects universe on the Budget and PV data marts and

Budget, Resources categories Business Objects reports.

Created test cases and test data for assigned modules.

Assisted in the Integration & User Acceptance Testing.

Successfully migrated the Business Objects universe & reports

to production.

15. MHIRS-BO

Duration Dec' 2004 - Mar' 2005

Location Chennai, India

Technology Business Objects 6.1,Web Intelligence 6.1, Info view, Crystal

Reports 8.5

Project Mellon Investor Services (MIS) system developed various

Abstract reports for the Employee ownership system to track and

administer stock options granted to their clients, includes

stock issuance, stock trading and settlement, tax collection,

reporting and fund disbursement by using crystal reports and

later it has been migrated to Business Objects. The scope of

this project was to develop new reports and test the existing

reports with the developed reports.

Role As a Senior Developer, my responsibilities Includes

Offshore Coordination and Client Interaction

Preparation of Functional and Technical Specification

Developed Ad-hoc reports in Business Objects and Involved in

verification and validating the Business Objects Reports.

Created Test cases and performed Testing

16. 3M -VIP

Duration Oct`2004 - Dec` 2004

Location Chennai, India

Technology Business Objects 5.1, Teradata, PL/SQL, Erwin

Project 3M unit has around 300 reports that are generated for various

Abstract categories like Compensation, Incentive etc. Currently the

reports are generated from the Ingress database. 3M unit

wishes to build a Logical Data Model which will be created in

GEDW (Teradata) database replacing the existing system so as

to make the reporting faster and more efficient. The logical

data model is arrived at using the Erwin Data Modeling tool.

Role As a Developer, my responsibilities were

Analysis and Development of Data Modeling and Teradata for

mapping the Data

Analysis of Business Objects Reports and Applications,

Development & delivery of Universe and Reports using Business

Objects.

Co-ordination with the team members for Development and

Testing

Client interaction

17. AIRRA - Home Base Corporation, UK

Duration May`2004 - Sep`2004

Location Bangalore, India

Business Objects 5.1.5, MS Access, SQL Server 2000

Technology

Project HB undertaken an exercise to develop a Data Mart to enhance

Abstract the analytical reporting capability based on the

accidents/Injuries recorded in the various locations for

customers, contractors and Employees. The purpose of this

reporting helps to generate the accident enquiries,

generating number of accidents for a certain region for a

certain period based on the database entries. The analysis

is based on area, region, employees, customers and

contractors. This system gives the ability to access, analyze

and share information in the company's database.

Role As a team member, my responsibilities were

Involved in taking requirements from business users and

project planning

Designed universe based on user requirements, using BO

Designer

Development of Ad-hoc reports using Business Objects

Developed Migration plan for business Intelligence components

18. PIPPA - Home Base Corporation, UK

Duration Mar`2004 - Oct`2004

Location Bangalore, India

Technology Business Objects 5.1.5, BCA, Oracle 8i

Project PIPPA is a system with major operations, such as Payroll and

Abstract Personal information, generating reports based on the

Employee number. The payroll data mart was designed and

developed to generate reports to analyze the Employee's

salary details of the store. The analysis is based on store,

area, city and region wise details fo an employee and

similarly for the employee's personal details.

Role As a module lead, my responsibilities were

Participated in the Design phase and created Report Design

documents

Designed Payroll data mart universe and created Reports using

Business Objects

Maintaining Universe and Reports in Business Objects

Developed and delivered static, dynamic reports as per the

user request

Performed Unit Testing for universe and reports

Scheduled the reports using BCA.

PERSONAL DETAILS:

Name : PRAKASH MANICKAM

Father's Name : G. MANICKAM

Date of Birth : 21-JUN-1978

Passport Number : M0448628

Passport Valid till : 27-JULY-2024

Visa Type(s) : 1. H1-B (US Visa Expired)

2. Dubai Work

Permit (Visa Expired)

Contact this candidate