Resume

Priya Vanaraj

Objective

To acquire proficiency in the field of Business Intelligence and Data Warehousing and in order to

leverage my academic knowledge and professional experience. To use my skills in the best

possible way for achieving the company's goals.

Roles and Responsibilities

Previous Role : Senior Technical consultant

Role Responsibilities: Quality Consultant (OEDQ)

Working on Requirement Analysis, Design, Development, Implementation of OEDQ

Technical Skills

Tools:

Oracle Enterprise Data Quality.

Comprehensive experience in data management / ETL/ PLSQL

Oracle Database

Experience in writing UNIX shell scripts.

BI Reporting Tools

Previous : Senior Technical consultant

Role Responsibilities:

Working on Requirement Analysis, Design, Development, Implementation of Cognos Reports, Cubes, events, interactive dashboards by establishing Best Practices and plan for continuous improvement of process using IBM Cognos BI tools (Cognos 10x Report Studio, Framework Manager, Power Play Transformer, Powerplay Studio, Event Studio)

Lead a development team, developing plans, managing and tracking the project execution

Provide training on the tools and the process

Technical Skills

Tools:

Comprehensive experience in IBM Cognos BI tools like Cognos(10.2.1, 8x Series)Cognos

Framework Manager, Cognos Powerplay

Transformer, Report Studio, Query Studio, Analysis Studio, Event Studio, Powerplay Studio.

Experience in Database Tools like Oracle, Teradata.

Experience in Data Model and Metadata design.

Experience in Performance Tuning and using JavaScripts to handle diverse Client needs.

Extensive Experience in multidimensional modeling using Powerplay Transformer.

Extensive Experience in designing highly complex and interactive Reports and Dashboards.

Experience in JavaScript/JQuery to animate and handle highly complex and diverse reporting

needs.

Experience in writing UNIX shell scripts to automate the cube build.

BI Reporting Tools

Domain Experience: Banking

Key Projects Executed:

Project Name: GDM Portfolio Review Reporting

Environment: Cognos Report Studio, Cognos PowerPlay Transformer, Cognos Framework

Manager, UNIX, Teradata.

Client: CITI Bank USA.

Project Description:

The objective of this project is to capture the performance of the key metrics across the portfolios on monthly basis and managing the cubes with new dimension/measures.

This data will be used by the Global Decision Management Team to make BI Decisions

Developed 20 cubes and 10 dashboards which captures the trends of the metrics.

Responsibilities:

Analysis of the business requirement and came up with the cube design handling huge volume of data.

Developing SQL and model design to achieve the business expectations.

Developed complex dashboard which involves Javascript, cube functions, drill throughs.

Developed UNIX shell scripts for extracting the data and automating the cube.

Prepared test case plan and did the Unit testing.

Project Name: Retail Bank Branch

Environment: Cognos Report Studio, Cognos PowerPlay Transformer, Cognos Event Studio,

Cognos Framework Manager, UNIX, Teradata.

Client: CITI Bank USA.

Project Description:

The objective of this project is to track the performance of the Retail Bank Branch Portfolios and

send the report to Global Decision Management team by email

Responsibilities:

Developing model design as per the business requirements

Developed a dashboard based on the cube based package

Developed a event studio event to check the necessary event condition run the report weekly

and send it by mail to the Decision management team

Project Name: Sales Growth

Environment: Cognos Report Studio, Cognos PowerPlay Transformer, Cognos Framework

Manager, UNIX, Teradata.

Client: CITI Bank USA.

Project Description: The objective of this project is to track the Sales Growth performance metrics

Developing a report with indicators of the performance

Responsibilities:

Developed Bteq scripts to extract and load data to the summary table

Developed SQL and model design to meet the requirements

Developed the OLAP cube model

Experience Details

Total experience: 6 Year(s), 2 Month(s)

Certifications

IBM Certified Designer Cognos 10 BI Metadata Models

IBM Certified Developer Cognos 10 BI Reports

IBM Certified Developer Cognos 8 BI OLAP Models

Education

Bachelor of Engineering (2004 – 2008)

College of Engineering Guindy, Anna University, Chennai CGPA: 8/10

Personal details

Date of Birth : 25th March 1987

Nationality : Indian

Sex : Female

Marital Status : Married

Declaration

I do hereby declare that the particulars of information and facts stated herein are true, correct and complete to the best of my knowledge and belief.

PRIYA VANARAJ

Contact this candidate