JOMON PHILIP

E Mail: accf23@r.postjobfree.com

Mob:046*******

Actively looking for assignments in Business Intelligence in an IT industry

SYNOPSIS

Offering 5.9 years of experience in Business Intelligence with Cognos 8x and Cognos 10x as reporting tool .

Worked On Report studio,Framework manager,cognos cubes,Query studio,Business Insigts,Analysis studio,Event

Studio.

Having Good exposure to Cognos Admin activities.

Having 3 years of experience in ETL with Informatica as ETL Tool Netezza and Oracle as databases.

Efficient at using oracle Database and Netezza Database.

Gained sufficient experience of working on end to end implementation.

Insightful experience in System Analysis activities for gathering requirements from clients.

IT EXPOSURE

Operating Systems: MS Windows.

DBMS: Oracle 9i,Oracle 11g,Netezza

Applications: Cognos 8.2,Cognos 8.3,Cognos 8.4,Cognos 10x, Informatica 8.6,Informatica 9,

VISA Details

Holding a State (New South Wales) nominated (Subclass 190) skilled Australian PR VISA valid from August 5 2013.

th

PROFESSIONAL EXPERIENCE

JUL’2013 –Jan’2014, Tech Mahindra, Bangalore BI Project Lead

About Organization:

Tech Mahindra is major global Software service provider across the globe. It was listed among the Top service provider in

India as well as in overseas. It has covered most of all business domains such as

healthcare,banking,insurence,securities,telecome,manufacturing,media and communication etc.It has many development

centres across the globe including Australia.

PROJECTS EXECUTED

Sun Corps (Insurance and Banking Domain),Australia

Title:

Description Working as a Business intelligence developer with Cognos 10x as reporting tool for the complete

project cycle from the source system till the report generation.

Role BI Project Lead Duration: July 2013 Jan 2014

Operating System(s) Windows XP Team size: 3

Skills Cognos 10.1.1, Netezza as DB.

Environment Data warehousing

Roles:

• Development and enhancement of DMR cubes as per the business requirement .

• Development of the reports by using Cognos 10.1.1.

• Creating Technical documents for the Cognos Report generation.

• Development of FM relational model.

• Model deployment and other admin activities.

• Enhancement of existing Cognos reports.

APR’2011– JUL’2013 Yellow book (Yellow pages)pvt Lmt, Bangalore Senior Software Engineer

About Organization:

Yell Adworks is majorly known as YB (Yellow book), which functions as one of the leading media and communication service

provider across the globe.The major Software developement centres are in India and Unites states apart from other departments.

The key Objective of the Software department is to develop and support own business application to meet the challenging,time

bound business needs of the customers across the globe.

KEY Contribution Areas:

Conceptualizing project execution plans after discussion with US Counter parts. Gathering requirement and preparing

functional requirement and system requirement specifications.

Defining best ETL Approach for the Source Data.

Creating Technical documents for the ETL modeling for Dimension and

Fact table.

Deciding the table structure for facts, dimensions and staging tables.

Development of Informatica Mapping after the approval of Technical Documents from the US Counter Parts.

Creating Technical documents for the Cognos Report generation.

Development of FM relational model and scorecard reports.

Model deployment and othew admin activities.

Development and enhancement of Cognos reports.

PROJECTS EXECUTED

BNW (Media and Communication Domain)

Title:

Yellow Book (KOP,Cedar Rapids) United States.

Client:

Description Involved in an application called BNW,where we are working as a Business intelligence developer

with Informatica 9 as ETL tool and Cognos as reporting tool for the complete project cycle from the

source system till the report generation.

Role Senior Software Engineer Duration: Apr 2011 – July 2013

Operating System(s) Windows XP Team: 3

Skills Informatica 9,Cognos 10.1.1,Oracle and Netezza as DB.

Environment Data warehousing

Contribution: Currently involved in development of mapping for the source data to convert it into our business

requirement using informatica and generation of the reports by using Cognos.Also involved in creating

technical documents as per the business requirements gathered from the Business Analyst from US

counterpart.

Mar’2008– Mar’2011 Wipro Technologies, Bangalore Software Engineer

About Organization:

Wipro Technology is a major Software service provider across the globe.It was listed among the Top service provider in India

as well as in overseas.It has covered most of all business domains such as

healthcare,banking,insurence,securities,telecome,manufacturing,media and communication etc.It has many development

centres across the globe including Australia.

KEY RESULT AREAS

Conceptualizing project execution plans after discussion with clients, gathering requirement and preparing functional

requirement and specifications and system requirement specifications.

Defining best practices for project support and documentation.

Bug fixing for the existing reports.

Development and enhancement of Cognos reports.

Involving in production support & functional specification preparation.

PROJECTS EXECUTED

SFR (Telecom domain)

Title:

SFR Paris, France.

Client:

Description Involved in two application COFA and COFP,where these applications are built on cubes(power play

transformer).involved in setting up new dev environment at offshore and fixing bugs .

Role Software Engineer Duration: Nov’10 – Mar’11

Operating System(s) Windows XP Team: 1

Skills Oracle,powerplay transformer.

Environment Data warehousing

Contribution: Involved in two application COFA and COFP,where these applications are built on cubes(power play

transformer).involved in setting up new dev environment at offshore and fixing bugs .

Onsite Experiance: Worked from onshore (France) during transition period of project and coordinated with offshore team

to build dev environment at offshore.

Deutche bank (Finance and Banking domain)

Title:

Deutche bank, Frankfort Germany.

Client:

Description Migration of Business Objects reports to Cognos report.Re designing Bo universes and report to

Cognos 8.4.

Role Software Engineer Duration: Apr’10 – Oct’10

Operating System(s) Windows XP Team: 1

Skills Cognos 8.4, Oracle DB

Environment Data warehousing

Contribution: Development of Cognos reports from BO report also Upgradation of cognos reports from cognos 8.2

to cognos 8.4.

WMC Equity Support (Securities Domain)

Title:

Client: Wellington Management Company, Boston US

Description Enhancement and development of Cognos report. Production support during IST.

Role Project Engineer Duration: Mar’09 – Mar’10

Operating System(s) Windows XP Team: 2

Skills Cognos 8.2, Cognos 8.4, Oracle DB / Cognos 8.4, Oracle SQL, Production Support

Environment Data warehousing

Contribution: Development and enhancement of Cognos reports.Upgradation of cognos reports from cognos 8.2 to

cognos 8.4.Production support during IST.

TKO SOD (Segregation of Duties) Cognos Reporting (Securities Domain)

Title:

Client: Capital Group of Companies, Geneva, Switzerland

Role Project Engineer Duration: June ’08 – Feb’09 (9 months)

Operating System(s) Windows XP Team: 4

Skills Cognos 8.3, Sybase Stored Procedure.

Environment Data Warehousing

Description Automating the generation of the monthly client reports for TKO. Currently three different systems are

used to generate the reports. Cognos is replacing the existing reporting system and clubbing the three

together into one.

Contribution Development and enhancement of Cognos report. As a programmer writing and modifying stored

procedures as per the functional requirements.

HIGHLIGHTS

Received Best performer Award from Yellow Book .

Effectively co ordinated from onshore during the transition phase of the project. Helped team to bring up the dev

environment at offshore.

Efficiently monitored up gradation from lower version COGNOS 8.2 to higher version COGNOS 8.4.

Effectively contributed to COE for migration project.

Involved in migration project from actuate to Cognos.

Received client appreciation for:

The quality of delivery from Yellow book,Deutche Bank,WMC Cleints.

Handling offshore responsibilities without any issues.

The quick response for report delivery and bug fixing.

Timely response for production issues.

Overall performance from capital group of company.

Handled complete offshore responsibility for Wellington Management Company, Boston.

TRAININGS ATTENDED

Data ware Housing Architecture, Informatica 8.6, Terradata, Cognos 8x,Cognos 10X (Certified from IBM)

Oracle,Netezza, Core JAVA

Embedded Systems

ACADEMIC CREDENTIALS

Master of Technology (M.Tech). (Information Communication Technology) from J.C Mysore. (affiliated to

VTU) .Secured 78.5% (First Class with Distinction)

Bachelor of Engineering (B.E) in Electrical and Electronics Engineering from J.N.N.C.E Shimoga (affiliated

to VTU.Secured 69%. (First Class)

2001 2003 PUC from Nitte Shankar Adyantaya PU College karkala. Secured 78.3%.

2001 SSLC from Jyothi High School, Ajekar. Secured 78.5%.

Other Qualifications:

2008 Advanced Diploma in Embedded System from Cranes International Software Limited with a grade of B+.

I here by assure you that all informations above mentioned are genuine with full of my knowledge and I shall be

solely accountable for above informations.

Assuring you that I shall prove worthy of choice that is entrusted to me for the entire satisfaction of Organization.

Place: Sydney Jomon Philip

Contact this candidate