Manager Reports

Sravani Chalavadi

Summary

Having *+ years of Experience in Data Warehousing with strong knowledge and Development experience in tools like Cognos Report Studio, Analysis Studio,Query Studio,Wrokspace,workspace advanced, Power Play Transformer, Framework Manager and Oracle PL/SQL,Unix shell scripting

Extensive experience in Cognos 8.3,8.4,10.1.1, 10.2.1 suit, ETL/OLAP Tools OWB 10gR2

Designing the Relational, Dimensional Data Model using Cognos Frame Work Manager .

Object, Data and Package level Security implementation in framework Manager

Creating Cross tab, List, Chart reports, Dash board and Complex reporting(PageSets,PromptPages,Query,Calculations,Bookmarks,Drill Reports, conditional Formatting, Rendering, Bursting) using Cognos Report Studio.

Creating Cognos 10.1.1, 10.2.1 Active Reports

Involved in Performance Tuning of Reports to reduce report execution time.

Development of Power play Transformer models and building of cubes.

User class wise and dimension categories wise ‘Security Implementation’ in power play cubes using custom views and developed Drill through Reports for cubes using Report Studio.

Experienced in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, Cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.

Experienced using scheduling tools like CRON tab, Control-M, and AUTOSYS.

Created Ad-Hoc Reports using Query Studio based on user requirements

Working Knowledge on Preparing Test Cases and Unit Testing.

Extensive experience with Oracle 11g, SQL Server,DB2 as the database and Involved in advanced data handling techniques like performance tuning,partitioning tables, Dynamic query, query optimizing.

Expertise in Creating SQL Loader Scripts,External Tables to load data from flat files into database and exporting data to flat files using UTL_FILE package.

Good knowledge on Dynamic Cubes and IBM Cognos 11 Analytics

Experienced in working with SDLC, Agile, Waterfall, and Scrum methodology.

Proficient in Performance Optimization of reports and Multidimensional Cubes.

Involved in providing complex Regulatory reports for TRAI(Telephone Regulatory Authority of India)

Hands on experience on ETL (Extract-Transform-Load) applications development and testing.

Zeal to Learn, adapting New Technologies, having excellent trouble shooting skills, communication and interpersonal skills, hardworking and result oriented as an individual and in a team.

Have good problem solving and analytical skills. Highly motivated, quick learner.

Professional Experience

Working as a Senior Developer for Capgemini from Nov’12 to Till date.

Worked as Developer for TCS from Oct’08 to Oct’12

Educational Qualification

Bachelor of Electrical Applications from Nagarjuna University in the year 2008.

Technical Skills

OLAP/BI Tools

Cognos 8.3,8.4,10.1.1, 10.2.1 Framework Manager, Report Studio, Cognos Power play, Power play Transformer, Query Studio, Analysis Studio, Event Studio,Workspace,Workspace advanced.

ETL Tools

Oracle Warehouse Builder 10gR2

RDBMS

Oracle 9i, 10g,11g,SQL Server,DB2

Languages

C, C++, Visual Basic, Java, HTML, and XML

Scripting

Unix Shell

Utilities

MS Word, MS Excel, MS PowerPoint, Edit Plus, Putty, Shell Script, XML and MSPS,, Share point Portal, EMC Documentum, Team Track, Pulse,IBM Remedy

Project Profile

#1. Project Costing Tool

Client: Johnson and Johnson Mar 2015 – Till date

Environment : Cognos 10.2.1 FM, Report Studio, Query Studio, Power Play Transformer,Analysis Studio, Informatica 9.1, Oracle 11g

Role : Senior Cognos Developer

Project Description:

Project Costing Tool captures all the project related information like new project details and revenues, cost, duration for the year. It involves developing Cognos multi-dimensional cube and canned reports which helps in analyzing the revenue generated across years and months for a given project. The reporting application will be powered by Frame work Manager Modeling, Cognos Power play, and Report Studio technologies to provide relational, Dimensional and analytical reporting.

Responsibilities:

Working with the customer to gather and document business analytics requirements including: data, layout, and delivery requirements to interpret functional requirements into report specifications.

Documenting the design of reports and tracing the design solution to the initial requirement.

Creating data modeling solutions to support business analytics required

Created models and packages in Framework Manager.

Troubleshooting and tuning of FM Relational Models, DMRs and reports for better performance.

Package level Security implementation in framework Manager

Development of Power play Transformer models and publishing into Analysis Studio.

User class wise and dimension categories wise ‘Security Implementation’ in power play cubes and developed Drill through Reports for cubes using Report Studio

Created different kinds of reports including List, Cross-tab, Charts, Conditional Block, Prompts, and Bookmarks, Dash Boards, Master Detailed Reports, Drill Through Reports, Page Sets, Prompt Pages in Report Studio

Conditional Formatting using the conditional variables to highlight the data and Rendering the objects.

Created custom prompted reports in Report Studio, Bursting reports to different user groups

Developed hide and show reports by using Conditional blocks.

Developed a report which involve in creation of single select and multi select cascading prompts

Worked on the Active Reports to provide the interactive behavior outputs to the users

Involved in Performance Tuning of Reports to reduce report execution time.

Involved in user training to Business Authors in creating Ad-Hoc reports using Query Studio and as well in preparation of Training materials for the same.

Experience in using Cognos Connection to organize and schedule reports based on the user requirements.

Prepared complex reports using Query calculation, Layout calculation and joins.

Validated the Reports and cubes with database and review the Reports and unit testing.

Prepared Test Cases and Unit Testing.

#2. Pharma Data Laboratory Information Systems

Client: Johnson and Johnson Feb 2014- Feb 2015

Environment : Cognos 10.1.1 FM, Report Studio, Query Studio,SQL Server

Role : Senior Cognos Developer

Project Description:

Pharma Data Laboratory Information Systems (PDLMS) is the reporting solution was built on Crystal Report for Johnson and Johnson’s (JnJ) ‘quality control division’ in order to maintain all laboratory analysis results. The intent of the PDLIMS project was to migrate all existing Crystal Reports to IBM Cognos 10.2.1 Reporting solution as fresh development.

Responsibilities:

Working with the customer to gather and document business analytics requirements including: data, layout, and delivery requirements.

Documenting the design of reports and tracing the design solution to the initial requirement.

Creating data modeling solutions to support business analytics required.

Creating models and packages in Framework Manager.

Building reports combining list, cross-tabular, and chart displays to replace Crystal reports.

Used Page sets to render the data between pages.

Created Multi paged reports including prompt pages to meet the requirement.

Developed hide and show reports by using Conditional blocks.

Developed a report which involve in creation of single select and multi select cascading prompts

Validated the Reports with database and review the Reports and unit testing.

Involved in user training to Business Authors in creating Ad-Hoc reports using Query Studio and as well in preparation of Training materials for the same.

#3. IKEA

Client: IKEA Nov 2012 – Jan 2014

Environment : Cognos 10.1.1 FM, Report Studio, Query Studio, Informatica 9.1,BMC Remedy,

DB2

Role : Senior Cognos Developer

Project Description:

IKEA is a most successful furniture providing store which is spread across different countries as the business grows the data has to be analyzed to forecast the revenues generated across different regions and products. This is a maintenance project which involves supporting reports and creation of new canned reports which helps in analyzing the revenue generated across years and months. The reporting application will be powered by Frame work Manager Modeling, Cognos Power play, and Report Studio technologies to provide relational, Dimensional and analytical reporting.

Responsibilities:

Working with the customer to gather and document business analytics requirements including: data, layout, and delivery requirements to interpret functional requirements into report specifications.

Documenting the design of reports and tracing the design solution to the initial requirement.

Created different kinds of reports including List, Cross-tab, Charts, Conditional Block, Prompts.

Conditional Formatting using the conditional variables to highlight the data and Rendering the objects.

Prepared complex reports using Query calculation, Layout calculation and joins.

Validated the Reports with database and review the Reports and unit testing.

Maintaining the existing reports and migrating the new changes to the production environment.

Involved in user training to Business Authors in creating Ad-Hoc reports using Query Studio and as well in preparation of Training materials for the same.

Experience in deploying the Reports as well as Content stores from one environment to another using File Transfer Protocol (FTP).

Experience in using Cognos Connection to organize and schedule reports based on the user requirements.

Providing technical support to the end client and solving the problems.

Tracking, assigning and solving the incidents raised against the team.

Creating new incidents and Change requests using Remedy tool to move new changes to the production.

#4. General Electric Real Estate Asia Pacific

Client: GE Real Estate Asia Jan 2012 - Oct 2012

Environment : Cognos 8.4 FM, Power play transformer, Analysis Studio, Report Studio, Query Studio, Oracle 10g

Role : Cognos developer

Project Description:

GE Capital Real Estate (GECRE) has been present in the Asia-Pacific region since 1997 and originated over $15bn equity investment and over $4bn in debt. GECRE Asia-Pacific has acquired over 1000 properties with a large presence in Japan, Korea and Australia. Business Intelligence Team is the central place for analyzing the various properties Assets. The reporting application will be powered by Frame work Manager Modeling, Cognos Power play, and Report Studio technologies to provide relational, Dimensional and analytical reporting.

Responsibilities:

Working with the customer to gather and document business analytics requirements including: data, layout, and delivery requirements to interpret functional requirements into report specifications.

Documenting the design of reports and tracing the design solution to the initial requirement.

Creating data modeling solutions to support business analytics requirements.

Development of Power play Transformer models and building of cubes using Transformer.

User class wise and dimension categories wise ‘Security Implementation’ in power play cubes and developed Drill through Reports for cubes using Report Studio.

Created different kinds of reports including List, Cross-tab, Charts, Conditional Block, Prompts, and Bookmarks, Dash Boards, Master Detailed Reports, Drill Through Reports, Page Sets, Prompt Pages in Report Studio

Enhancements in the existing reports.

Created models and packages in Framework Manager.

Object level Security implementation in framework Manager

Conditional Formatting using the conditional variables to highlight the data and Rendering the objects.

Developed a report which involve in creation of single select and multi select cascading prompts

Developed hide and show reports by using Conditional blocks.

Validated the Reports with database and review the Reports and unit testing.

#5. TTL Enterprise BI

Client: Tata Teleservices Limited, Hyderabad Oct 2008 - Dec 2011

Environment : Cognos 8 FM, Cognos Power play transformer and Report Studio, Query Studio, Analysis Studio, Oracle 9i

Role : Cognos Developer

Project Description:

Tata Teleservices Limited spear heads the Tata Group’s presence in the telecom sector. Tata Teleservices Limited is the pioneer of the CDMA & GSM technology platform in India and crosses the 60 million subscriber mark with the growing business and competition, Business Intelligence Team is the central place for analyzing the data coming from various operational systems is apparent. The reporting application will be powered by Cognos Power play, OWB and Report Studio technologies to provide both relational and analytical reporting.

Responsibilities:

Documenting the design of reports and tracing the design solution to the initial requirement.

Creating data modeling solutions to support business analytics requirements.

Creating Indexes, partitioning on tables for better performance.

Used dynamic SQL in writing stored procedures.

Developing mappings in Oracle Warehouse Builder for ETL part and Developed SQL queries and stored procedures for data handling.

Creating SQL Loader Scripts,External Tables to load data from flat files into database

Development of Power play Transformer models and building of cubes using Transformer.

User class wise and dimension categories wise ‘Security Implementation’ in power play cubes and developed Drill through Reports for cubes using Report Studio.

Created models and packages in Framework Manager.

Building dashboard-style reports combining list, cross-tabular, and chart displays to give executives an "at-a-glance" look at the health of the agency/organization.

Involved in user training to Business Authors in creating Ad-Hoc reports using Query Studio and as well in preparation of Training materials for the same.

Experience in deploying the Reports as well as Content stores from one environment to another using File Transfer Protocol (FTP).

Experience in using Cognos Connection to organize and schedule reports based on the user requirements.

Shell scripting for automation and scheduling of ETL process in UNIX.

Contact this candidate