Project Manager

ESAN RAY

****,*-*****,********** ********,

Akurdi,Pune-411035,India.

CONTACT NO: +91-844*******

E-MAIL: *******@*****.***

CAREER OBJECTIVE

To be a self motivated next generation leader with the ability to adapt to

rapidly changing technologies and environments with a strong desire to

undertake challenging jobs and to work with the team to achieve the goals

of an organization.

SKILLS

. Around 8 years of total IT experience with 6 years of expertise in

developing Business Intelligence and Data Warehouse applications.

. More than six years of experience in business data analysis, model

design and building reports using Cognos 8.3, 8.4,10.1 and Cognos TM1.

. Experience on reporting tools like Cognos & Sound knowledge ETL tools

like Informatica & OWB.

. Extensive experience in building models, cubes & complex report in

Framework Manager, Report Studio, Query Studio, Analysis Studio,TM1

and Transformer.

. Sound knowledge of installation, configuration, administration,

security of Cognos 8/10 suite of tools on Windows environment.

. Understanding the business requirements and designing applications to

meet their needs.

. Successfully managed onsite-offshore model for various projects.

. Strong knowledge and use of full lifecycle development methodologies,

standards and procedures.

. Strong in datawarehousing concepts, leadership skills, effective

communication skills etc and having onsite experience in Australia.

. Good Financial service, Manufacturing and Airline domain knowledge.

. Good team player with excellent communication and presentations

skills.

TECHNICAL SKILLS:

OPERATING SYSTEMS : WIN9X/XP/VISTA, UNIX

PROGRAMMING LANGUAGE : C, C++, VISUAL BASIC, Oracle, PL/SQL

TOOLS : COGNOS, Business

Object, INFORMATICA,

OWB

DATABASES : Oracle, SQL server, DB2

PROFESSIONAL QUALIFICATION:

> DEGREE: B.E. IN COMPUTER SCIENCE ENGINEERING (2003)

> INSTITUTION: KRUPAJAL ENGINEERING COLLEGE

> UNIVERSITY: BIJU PATNAIK UNIVERSITY OF TECHNOLOGY, INDIA

(ORISSA)

CURRENT COMPANY:

Name of the organization : Capgemini.

Designation : Sr. Consultant.

Period : July 2012 to till date.

Current Project :

Client : First Data Corporation Germany.

Title : BO to Cognos Migration.

Role : Model Design & Report Developer.

Environment : Cognos 10.1, SQL Server

Team Size : 4

Duration : July 2012 to June2013.

Description:

This is a migration project. The objective of this project is migrate the

existing Business object 5.1 universe and reports to cognos 10.1.1 Model

and reports.

Responsibilities:

. Worked extensively with offshore team members and demonstrated

teamwork leading to results, effective communication, and sense of

urgency.

. Developed various type of model by using Framework manager, Similar as

existing Business Object Universe.

. Developed multilingual models in Framework to display the cognos

report in English & German language.

. Migration of existing Business Objects reports in to cognos reports.

. Successfully testing all the Migrated Business Objects reports in to

cognos report.

. Carried out UAT by developing test scenarios, test cases, test data to

be used in testing based on business and user requirements.

. Involved in the Testing of the reports and updating the Bug Tracking

Tool

. Implementation of report bursting in reports.

PREVIOUS COMPANY -1

Name of the organization : NIIT Technologies.

Designation : Technical Analyst.

Period : December 2010 to June 2012.

Project #1:

Client : Cathy Pacific.

Title : Cathy WOS.

Role : Analyst, Model Design & Report Developer.

Environment : Cognos 10.1, Oracle10g

Team Size : 1

Duration : Oct 2011 to June 2012.

Description:

This project provides the detailed processing logic for calculation of data

for generation of management reports for real time monitoring of various

activities in the Cathay Pacific Cargo terminal.

Responsibilities:

. Analyze data from operational database and create model by using

Framework manager.

. Designed various types of reports according to end user requirements.

. Create complex chart reports.

. Experience in writing with HTML/Java Script in Cognos report studio

reports. Using java script to auto refreshing, superimpose one above

the other chart and display more information in prompt page if the

user enter a wrong value.

. Resolved issues resulting from User Acceptance Testing (UAT).

. Installation and Configuration of Cognos BI Server on Windows

environment

. Apply data level & package security to the reports.

Project #2:

Client : Virgin Australia.

Title : Virgin Blue DWH.

Role : Analyst, Model Design & Report Developer.

Environment : Cognos 8.3, Cognos TM1 9.5.1, OWB, Oracle10g

Team Size : 10

Duration : Dec 2010 to Sept 2011

Description:

This Project is for Provide analysis for daily transactional data from two

different database. The objective is to generate Intelligent Informational

reports based on the Business Partners requirements daily, weekly, monthly

and annually.

Responsibilities:

. Direct interaction with end user to understand the requirements.

. Responsible for various tasks including user communication, follow

ups, reports development, testing, and moving components into

different environments

. Analyze data and generate reports from multiple databases.

. Create project (Model) by using Framework manager.

. Created dimensions, cubes using TM1 turbo integrator

. Created various Business Rules to load the data from one cube to

another cube.

. Integrating TM1 cubes with Cognos 8.3 BI

. Developing TM1 POC for different business group.

. Giving estimation of efforts required.

PREVIOUS COMPANY -3

Name of the organization : Paceinfosys Solution.

Designation : Cognos Developer.

Period : August 2007 to December2010.

Project #3:

Client : Nilfisk Advance

Title : Nilfisk Advance sales and services

Role : Model & Report Developer

Environment : Cognos 8.4, Informatica, Cognos TM1 9.5.1

Team Size : 6

Duration : Nov 2009 to Dec2010

Description:

The project deals with sales and services of Nilfisk Advance groups. The

sales and services of Nilfisk Advance group has involved in over 43

countries plus distributors in more then 70 countries across the globe.

These business intelligence suites to stream line the collection, analysis

and dissemination of key performance indicators to management.

Responsibilities:

. Develop model in Framework manager and publish packages.

. Crating TM1 Cubes, Dimensions, processes, chores etc and populating

the Cubes.

. Creating TM1 cubes as data sources in cognos BI for reporting and

troubleshooting the issues related to this.

. Performance turning of TM1 rules using Skipcheck and Feeders.

. Deploy from development server to production server.

. Developed user acceptance documentation and placing Screen shots of

actual Report and tested report in documentation.

Project #4:

Client : Chromalloy

Title : Chromalloy sales

Role : Report Developer

Environment : Cognos 8.3, Informatica, Oracle 9i

Team Size : 4

Duration : Jan 2009 to Oct 2009

Description:

The project deals with sales analysis system of Chromalloy. The project is

implemented with the aim of analyzing and estimating the sales trends. The

project includes reports were generated for decision support to sales

departments. The project involved building of business intelligence tolls

for an enterprise wide Data Warehouse.

Responsibilities:

. Produce various reports as for the requirements of the client.

. Create reports by using report studio & query studio.

. Create different type of charts like Column, line & combination

charts.

. Generated various kinds of reports (List, Cross tab, Drill Through and

Master Detail) using Report Studio and Query Studio.

. Developed Prompt pages and Conditional Variables

Project #5:

Client : State Farm Insurance

Role : Report Developer

Environment : Cognos 8, Informatica, Oracle 9i

Team Size : 4

Duration : Aug 2007 to Dec 2008

Description:

This Project is for Providing Solution for daily transactional data for the

State Farm insurance business for their Finance Processes. The objective is

to generate Intelligent Informational reports based on the Business

Partners requirements monthly or periodically.

Responsibilities:

. Create reports by using report studio & analysis studio.

. Created list, cross tab and chart reports with conditional formatting.

. Format reports and apply guidelines provided by the Client

. Create cubes by using Transformer.

. Understand requirements from seniors.

. Enhance existing reports with the changes requested.

. Developed user acceptance documentation and placing Screen shots of

actual Report and tested report in documentation.

PREVIOUS COMPANY -4

Name of the organization : Bio-Soft Technologies.

Designation : Technical Engineer.

Period : Mar 2005 to July 2007.

BIO-SOFT TECHNOLOGIES started as software Development Company in 2002 from

its origin. Today the company has expanded its branches through out India

the company envisioned establishing leadership through premium quality

products & service. Now Bio-soft has its expertise in the field of software

development, web designing, smart card solution, biometrics solutions &

Access control systems.

JOB RESPOSIBILITY:

. Implementation of smart card & Biometrics solution to the customer.

. Involve working with the technical team & modify the software

according to the customer requirement.

. Participate with the sales team & gave presentation of the

software.

. Conduct training after implementation of the solution to the

customers.

PERSONAL DETAILS:

Date of birth : 11th July 1981

Sex : Male

Martial status : Married

Passport detail : H1417215

Visa Detail : Australian Business Visa

Place: Pune

Date: Esan Ray[pic]

Contact this candidate