Mahesh E-Mail: ac5tuc@r.postjobfree.com

Mobile no: +91-986-***-****

Profile Summary

4+ Years of IT exposure in Cognos BI 8.4/10.X (Report studio, Query Studio, Analysis Studio, Framework Manager, Transformer).

Having 1.6 years of experience in Cognos 9.x, 10.x TM1 (building Dimensions, Cubes, Processes, Loading data using TI, Perspectives and web tools).

Having IT experience in Analysis, Design, Modelling, Development and Testing of Cognos TM1 application.

Extensive experience on data loading using TI.

Experience on Cognos TM1 Planning and Analytics.

Proficient in Analyzing and translating business requirements to technical requirements

Experience on Cognos Migration from Cognos 10 to Cognos 11 Analytics.

Creating and Modified Models for Reporting and published packages in cognos connection using Frame Work Manager.

Expertise in developing Complex reports (List, Cross tab, Charts, Drill through, Master-Detail, Conditional Block, Cascading and Dashboards using Report studio).

Experience on Data Warehousing concept like Star Schema, Snowflake Schema and

identifying the Dimension and Fact tables.

Experience in Scheduling the Reports.

Deployment of Packages to Production Environment as well as Test Environment and having excellent working domain knowledge.

Established physical database parameters.

Involved in Unit Testing the Reports.

Experience in creating and designing a Database

Created Packages, Functions, and Procedure by using PL/SQL.

Experience in writing SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.

Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.

Specified which users can access databases and what data can be accessed by users.

Involved in Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.

Tested and corrected errors and refined changes to database.

Professional Experience

Working as a Cognos TM1 Developer for Wipro, Chennai from April 2014 to till date.

Education

B. Tech (Automobile) from JNT University Kakinada.

TECHNICAL SKILLS

Data Bases : Oracle 10g, DB2.

Languages & Tools : SQL, PL-SQL, Toad.

Operating Systems : Windows 7/8/XP.

OLAP Tools : Cognos 8.4, Cognos 10.1,Cognos 9.5 TM1

(Building Dimensions, Cubes, Processes, Loading data using TI,

Perspectives and web tools)

PROJECT PROFILE

Project #2: Nov 2016 –Till date

Project Title : Conversion of SAP BO reports to Cognos reports and CCN Dashboard Reports

Client : State farm (BI tool factory), Bloomington, IL, USA

Role : Cognos Developer

Environment : IBM Cognos BI 11, SQL Developer, Linux, Cognos TM1

Description:

State farm deals with different Insurance verticals like Auto, Health and Fire. ‘BI tool factory’ department handles different IBM Cognos development projects. Among them CCN Dashboard deals with Customer Care Network how well the representatives are performing in each level of employee hierarchy.

Responsibilities:

Requirements gathering, Analysis and Design: Understanding the Requirements, Specifications & Business Logic.

OLAP Reporting : Design and Developed reports using Cognos report studio with Cognos TM1 cube as data source

Involved in Cognos TM1 Planning Analytic Migration

Developed designs using Cognos TM1 application.

Testing of Cognos TM1 application.

Helped the team in understanding logical issues and fixing technical issues.

Loading the data by using TI.

Helped the team in Design, Modelling, Development and Testing of Cognos TM1 application

Prepared Technical Requirement Documents and High Level Design Documents.

Analyzed SAP BO Web and crystal reports and created metadata model using Framework Manager and developed same reports using report studio.

Developed list, cross tab, drill through, drill down, master-detail, chart and various complex reports which involve different types of prompts, conditional blocks, etc. in Report Studio.

Monitored the team about work progress and deadlines.

Daily/weekly status to onsite / users.

.

Project #1: April 2014 – Oct 2016

Project Title : Federal Bank of Malaysia

Client : Federal Bank

Role : Cognos Developer

Environment : CognosBI 10.X, Oracle 10g Database

Description:

This project is involved in the development of data warehouse for Federal Bank of Malaysia on four kinds of data marts such as Accounts Loans, Credit Cards, and Insurance. Each data marts represent a collection of data pertaining to a single business process. In loan data mart involved in disbursal of loan amounts for various purposes like: Personal Loan, Educational Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, etc. The database has lots of historical data, so data warehousing plays a Major role in enabling various Sources to view data at a lowest level and help them to make Decisions to bring more revenue to company with new policies. Cognos BI has been used to deliver the scalable and analytical reports.

Responsibilities:

Created List, Grouped List, Cross tab, Chart reports with simple drag and drop functionality.

Created and managed sections in the reports and also formatted reports as per the need.

Extensively worked with filters and prompts on report data in Report Studio.

Implemented conditional formatting in the reports to highlight the exceptional data.

Used conditional blocks to hide the objects.

Work with complex reports like master-detail and drill through reports.

Developed the specific reports with concept of cascading and value prompts by using Report Studio.

Creating prompt pages and parameters.

Using Framework Manager tool of Cognos, develop the model to fulfil the Business Requirements

Created Dashboard Reports. to display multiple reports in single page.

Developed Standard Reports, List, Cross-tab reports Using Report Studio and Query Studio.

Created Cascading prompts and worked with various prompt controls like Value prompt and Date & Time prompt.

Contact this candidate