Manager Project

Saravanan Subramanian.

***********@*****.***, *********@**************.***, +91-996*******

Professional Summary

. Cognos Certified and Over 10 years of working experience in Cognos

Business Intelligence reporting. Cognos Report Net1.1/Cognos 8.x/10.x.

Report Studio, Query Studio, Framework Manager, Analysis Studio, Event

Studio, Active Reports, Business Insight/Workspace, Workspace Advance

and Dashboard Reporting.

. Experience in Full Life Cycle Project Development including

Requirement gathering, Proof of Concept, Estimation, Design,

Development, Testing, implementation, Quality documentation, Knowledge

Transfer and customer support activities.

. Experience in Design and implement technology best practices,

guidelines and repeatable processes, Domain knowledge of

Manufacturing, Real estate, Banking and Pharmaceutical industry.

. Proven experience in projects, proposals, presentation and training

Experienced in Development, Support & Maintenance Projects.

. Expertise in developing and testing Complex reports (List, Cross tab,

Charts, Drill through, Master-Detail and Cascading) and Dashboards

using Report studio.

. Involved with complete SDLC processes including Requirement Analysis,

Documentation, Prototypes, Development, Testing, Implementation and

Maintenance.

. Involved in quality process and managed the team effectively. Ability

to work effectively in a team as well as individually.

. Experience in developing report templates, Cognos coding standard

documents, Report and Framework manager templates and guided the

teams.

. Proficient in Framework manager modeling, Reports development,

deployment in different environments, performance tuning &

optimization, team management and knowledge transfer.

. Worked with major clients like Merck, Baxter, Deutsche Bank and

Extreme Networks.

Skills

Cognos Certification:

. Cognos ReportNet Product User (Reference number - 41297)

. Cognos ReportNet Authoring Product Professional (Reference number -

41916)

Education Master of Computer Applications (MCA)

Databases Oracle, Microsoft SQL Server, MySQL

Data warehousing-Business Cognos 8.x, 8.4 & Cognos 10.2

Intelligence

work experience

Designation Company Period

Cognos Consultant iNoble Solution May 2012 - Till

date

Cognos BI Technical Lead HCL Technologies Sep 2007 - Apr

2012

Cognos Report Developer Extreme Networks Sep 2006 - Sep

2007

Cognos Report Developer VM Technologies Jan 2004 - Sep

2006

PROJECT experience SUMMARY

Project Name Technologies Role Period Team

Cognos BI Reporting for Cognos 10.2 Consultant 9 Months 4

Planist

Precisemetrix Restaurant BI Cognos 10.2 Project Lead 3 Months 2

Reporting

PEP Servicelink Reporting Cognos 8.4 Project Lead 5 Months 3

Global Safety Integration Cognos 8.4 & Technical 1 Year 7

Programme (GSIP) Cognos 10.1.1 Lead

Asia Core Management Reports Cognos 8.4 Technical 9 Months 4

(ACMR) Lead

Sales Processing and Incentive Cognos 8.4 Developer 2 Months 2

Computation (SPICA)

Managed Care Claims DSS Cognos 8.4 Developer 9 Months 4

USHH FACTS DSS Migration Cognos 8.4 Developer 4 Months 4

Baxter - Customer Analytics Cognos 8.3 Developer 1 Year 16

Financial Systems Renewal Cognos 8.2 Developer 5 Months 47

(DB-FSR)

Extreme Networks Cognos Cognos Development 1 Year 3

Reporting Reportnet 1.1 & Support

& Cognos 8.1

Land Management System for Cognos Developer 2.5 5

City of Dallas Reportnet 1.1 Years

* Currently working on few other projects and also providing Training in

Cognos BI.

PROJECT DETAILS - (In Reverse chronological order)

Client Name: Precisemetrix

Project Name: Restaurant BI Reporting

Operating Software Windows

Business Cognos 10.2

Intelligence

Databases Microsoft SQL Server 2012

Tools Used Framework Manager, Report Studio, Active Reports

Role Project Lead

Team Size 2

Project Description:

Providing Reports for small business owners, Restaurants owners to make

informed decisions. Reports are created in the area of Sales & Marketing

Management, Finance Management, Web site hit tracking, Front of House

Management, Bar & Cellar Management, Staff & Employment and Kitchen

Management. In a way the users can access the reports and their Dashboards

24/7 from anywhere on phone, Tablet and Notebook to measure KPIs

Responsibilities:

Involved in overall requirement Analysis, System study, detail design,

installation and implementing security in the reports.

Acquiring the functional & technical knowledge from the business users.

Installation of Cognos Components and creation of Framework Manager DMR

model, Report Studio reports, Active Reports, Dashboards capable of

viewing in mobile and tablet devices.

Providing estimates and current status to the client on periodic basis and

timely reporting on issues and its workarounds.

Responsible for delivery of reports and maintenance of overall Cognos

environment.

Client Name: PEP Station

Project Name: PEP Servicelink Reporting

Operating Software Windows

Business Cognos 8.4.1

Intelligence

Databases Oracle

Tools Used Report Studio

Role Project Lead

Team Size 3

Project Description:

Cognos Reports are created for monitoring the Electric Vehicle Charging

Station know as Plug in Electric Power (PEP) stations. All the reports are

based on the activities, usage of the PEP stations installed over various

locations. For example Reports like usage reports based on customer,

location are created and scheduled to the corresponding PEP support teams

for billing and maintenance.

Responsibilities:

Creation of reports and updating existing reports based on requirement

changes.

Providing estimates and current status to the project manager on weekly

basis and timely reporting on issues and its workarounds.

Working as a freelancer support.

Client Name: Merck

Project Name: Global Safety Integration Programme (GSIP)

Operating Software Windows

Business Cognos 8.4.1 & Cognos 10.1.1

Intelligence

Databases Oracle, Argus Safety application.

Tools Used Report Studio, Framework manager

Role Technical Lead

Team Size 7

Project Description:

Merck & Co Inc. is established in 1891, is one of the world's largest

pharmaceutical companies, manufacturing and marketing a wide range of

prescription drugs in many therapeutic classes.

The Global Safety Integration Program is a multi-year transformational

program that will integrate the processes and systems of legacy Merck and

legacy Schering-Plough pharmacovigilance (PV) and Clinical Risk Management

(CRM) businesses. This in creation of thirty three report studio reports

and Framework manager which different divisions like case processing,

clinical, metrics, contract management etc.,

Responsibilities:

Involved in Analysis, Requirement Gathering, System study, designing, work

allocation, scheduling & execution, detail design, project review meeting

and documentation.

Acquiring the functional & technical knowledge from the business users.

Coordinate and assign task for internal and external resources to meet

project objectives.

Providing feedback to project management on project status including

milestones, risk & exceptions and timely reporting on issues and track

these issues.

Preparation of templates for coding standards, subversion repositories and

Project Quality Analyst (PQA) activities.

Client Name: Merck

Project Name: Asia Core Management Reports (ACMR)

Operating Software Windows

Business Cognos 8.4

Intelligence

Databases Oracle

Tools Used Report Studio, Framework manager

Role Technical Lead

Team Size 4

Project Description:

This project Asia Core Management Reports involves in change request for

already developed reports and development of new reports and Framework

manager which deals with the field activity, call analysis and sales based

on the sales representatives and managers. New summary reports are

developed based on the existing reports with more user friendly charts,

crosstabs and dashboard views.

Responsibilities:

Involved in system study, project review meeting, daily communication with

client for report

validate and verify the requirements

Design Framework manager package

Development of Cognos Reports, charts and dashboards

Testing and fixing issues in the reports

Verifying & validating the deliverables before releases.

Providing knowledge transfer to the support team.

Client Name: Merck

Project Name: Sales Processing and Incentive Computation (SPICA)

Operating Software Windows

Business Cognos 8.4

Intelligence

Databases Oracle

Tools Used Report Studio

Role Development

Team Size 2

Project Description:

This project involves in modification and development of reports of Asia

pacific region on fourteen reports for Philippines and development of

eight new reports for China country is carried out. This project is for

short duration of two months.

Responsibilities:

Change request and new requirement Analysis

Development of Cognos Reports in short period.

Testing the reports and fixing the issues

Client Name: Merck

Project Name: Managed Care Claims DSS

Operating Software Windows

Business Cognos 8.4

Intelligence

Databases Oracle

Tools Used Report Studio

Role Development

Team Size 4

Project Description:

The main development on this project is to construct new reports in Cognos

8.4. This system is built to meet the needs of New Commercial Model -

Director of Commercial Operations to make timely and appropriate

decisions. It involves in creation of fifteen reports.

Responsibilities:

Validate the Design with the Customer, regular communication with client

for report requirement and change request

Design and development of Complex Cognos Reports

Unit testing the reports and fixing the issues

Client Name: Merck

Project Name: USHH FACTS DSS Migration

Operating Software Windows

Business Cognos 8.4

Intelligence

Databases DB2

Tools Used Report Studio, Framework manager

Role Development

Team Size 4

Project Description:

The Field Activity and Customer Tracking System (FACTS) application is a

reporting tool providing customer information & field sales promotional

information. Currently USHH (United States Human Health) uses Natural

FACTS DSS Reports and towards standardization of reporting systems (Cognos

8 BI). Since the existing thirty six Natural language reports are

recreated in Cognos. The FACTS DSS reports migration involves reverse

engineering to derive reports specifications from Natural reports and then

construct the reports in Cognos8 environment.

Responsibilities:

Involved in analyzing the existing Natural language reports and the

requirements study, documenting and preparing requirement specification

Validate and verify the requirements and findings of analysis

Involved in creating Framework model

Design and development and testing of Cognos Reports

Project Quality Analyst (PQA) activities.

Client Name : Baxter Healthcare Corporation

Project Name: : Baxter - Customer Analytics

Business Cognos 8.3

Intelligence

Databases SQL Server 2005

Tools Used Report Studio, Framework manager

Role Developer

Team Size 16

Project Description:

Baxter International Inc. is a global healthcare company that, through its

subsidiaries assists healthcare professionals and their patients with

treatment of complex medical conditions including hemophilia, immune

disorders, kidney disease, cancer, trauma and other conditions.

The business intelligence reporting for Baxter Customer Analytics

facilitates effective reporting and analysis of Customer information

through Cognos 8. The business intelligence reports store the business

information corresponding to the Customer Products. It includes

information about Service request, Activities/Calls,

Discrepancy/Discrepancy Items, Quota, Forecast, Inventory, Product

Allocation and Incentive trip. It is redevelopment of existing Siebel

Analytical Reports into Cognos 8.3 with new updates.

Responsibilities:

Involved in the requirement study, design and development of Reports

Developing and testing Cognos Reports

Involved in Quality Process, Defect Prevention Activities (DPA Role)

Client: Deutsche Bank

Project Name: Financial Systems Renewal (DB-FSR)

Business Cognos 8.2

Intelligence

Tools Used Report Studio, Framework manager

Role Developer

Team Size 47

Project Description:

This project involves roll outs for financial systems of Deutsche Bank for

four different countries, namely Singapore, Korea, Indonesia and Hong

Kong. Transactional and cell based reports were created. The reports were

built on the data obtained from the SAP BW BEx queries. It's an

off-shore/on-site project. The off-shore team is residing at Chennai and

Bangalore. The reports were initially developed in the Dev server and then

moved to QA and to production. A share point was maintained from where the

defects raised by the users were taken and then fixed based on the

priority. Versioning of the reports were to be maintained to make sure

that the last updated report was worked upon the defects.

Responsibilities:

Involved in the requirement study and development of Reports

Developing Cognos Reports, Creating Models and Publishing Packages in the

Framework manager.

Customer Support activities

Testing the reports

Change Request for all the regions were handled effectively.

Client: Extreme Networks India Pvt Ltd

Project Name: Extreme Networks Cognos Reporting

Operating Software Windows

Business Cognos

Intelligence

Tools Used Cognos Reportnet 1.1, Report Studio, Query Studio,

Framework Manager

Role Development & Support

Team Size 3

Project Description:

Extreme Networks is the manufacturer of Layer2 and Layer3 switches,

Routers and networking products and software's like EXOS and CentrinAG.

Reports are created in Reportnet in the ERP and CRM packages. Oracle apps

is the ERP package and Siebel is the CRM package used. Operational reports

are created for Oracle apps and Data warehousing reports are created for

CRM packages. I have been involved in creation and Enhancement of packages

in Framework Manager, Operational reports and Dashboard reports using

drill through. All reports and packages are migrated to Cognos 8

environment and are tested in the QA environment.

Responsibilities:

Involved in Production Support and Maintenance activities

Design and Developing Cognos Reports as per the requirements

Creating Models and Publishing Packages in the Framework manager.

Change request activities

Testing and performance improvement of the reports

Client: City Of Dallas, Texas, USA

Project Name: Land Management System for City of Dallas

Operating Software Windows

Business Cognos

Intelligence

Tools Used Cognos Reportnet 1.1, Report Studio, Query Studio,

Framework Manager

Role Development

Team Size 3

Project Description:

The project deals with the development of Reports in Cognos Series7

ReportNet1.1 using Query Studio and Report Studio, for City of Dallas Land

Management System (LMS). Simple ad hoc reports are created using Query

Studio and Complex reports are created using Report Studio and custom SQL.

The database used is Oracle 9i, the database server is in City of Dallas.

We used VPN (Virtual Private Network) to connect. Projectricity (Project

collaboration tool - www.projectricity.com) is used to interact with the

client and maintain the status of the reports. The report is manually

tested using Query Studio, Toad, checklist and the output format given by

the client.

--- End of the Document pic]

CERTIFIED

Contact this candidate