Tirupathi.Stirupathi939@gmail.com+91-9494538248.

Roles and responsibilities summary:

Attended Training and learned Cognos, capable of working individually in Cognos development projects.

Attend training for Data warehousing concepts and BI reporting tool Cognos BI. Learned Cognos 10.x BI Suite (Framework Manager, Report studio, Query Studio, Analysis

Studio, Transformer)

Developed Metadata Models using Framework Manager and published packages to Cognos connection.

Developed Multi-Dimensional Cubes using the Cognos Transformer.

Developed reports using features like Conditional formatting, Drill through access, Charts, prompts, calculations etc in Report Studio

Developed reports using various charts like pie, bubble, pareto, Microcharts, Radar charts.

Developed Active reports by incorporating tree map, heat map and bubble visualizations

Developed adhoc reports using Query Studio.

Educational Qualification:

B. Tech (Electrical and electronics engg), AU, Vizag, India, 2016, 7.7CGPA %. Diploma( Electrical and Electronics engg), SBTET,Hyderabad, India, 2013, 71.27%.

Technical Skills:

Reporting Tools : Cognos 10.xDatabase : SQL Server 2008, Oracle 10gOperating Systesms : Windows 7

. Project: Client Project Technology Role Duration Location

Training Project

HeadCount

Cognos 10 Report studio, Framework Manager, Query Studio, Connection Page and SQL Server

Developer

July 2016 to Sept 2016

Vizianagaram

Description of the Project:The project Bank Details deals with providing Development and enhancement of

Cognos reports for their own organization support maintenance. This project contains 4 tables which covers employee, Location, Action and Fact. The primary focus to understand

1

management on people leaving company on what basis and from which location and few other details like DOJ and Termination date etc.

Responsibilities: Created a report studio for Displaying information on employees leaving

company from Hyderabad region.

Created a drill through report.

Responsible for handling, analyzing Development issues and provides quick solutions.

Worked on tables creation which comprises of enhancements in Reporting and SQL server section and deliver on time.

Involved in creating Cognos Events for reports to scheduling the reports to deliver on time.

Involved in handling Active reports for employee information application to show the summarized data in Data Tab control with data deck.

Involved in creating 18 Ad hoc Reports for using Query Studio

Involved in updating the existing Process flow documents or to create the new documents as per the requirement.

Involved in scheduling the Cognos jobs using Cognos Connection Page tools for this we also give support after the successful development.

Assisted the team in resolving various technical queries.

Created different Prompt based report for filtering few report based on City, Designation , Department etc

Responsible for any migration activities of tools such as Cognos for all application that we are support.

Involved in preparing KT Document and present the KT within the team and also to Created Conditional Block report for hide and show List and Crosstab using Value prompt.

2