Kala Tummagunta

860-***-****

acrum3@r.postjobfree.com

Sr Cognos Developer

Professional Summary:

8+ years of experience in Information Technology with expertise in Data Analysis, Data Modeling, Business Intelligence, Cognos reports development, Framework Manager Model and administration.

Experience in designing Logical and Physical data models using ERWIN.

Experience in using Microsoft Visio to design business process models and architecture diagrams.

Experience in writing SQL/PL SQL Scripts and schedule Autosys jobs

Proven ability to deliver output on time and complete detail oriented tasks efficiently

Deployed models and reports from Staging to Production

Design, develop and maintain Cognos Reporting solutions both for client and web versions of software.

Created users/groups/roles and granted permissions. Created security filter using user login information.

Experienced with migration and upgrade of Cognos (reports/models/ frameworks) from one version to another.

Involved into move to Deployment to UAT and Production.

Creation of Relational and DMR models using Framework manager.

Experience in creating cubes using Cognos PowerPlay transformer

Experience with multi-tiered BI environment.

Automated Reports using scheduler.

Hands on experience in converting business requirements to technical specifications

Education:

Master of Business Administration (MBA)

Bachelor of commerce in computers(B.com Computers)

Technical Skills:

Operating System

MSDOS, UNIX, Linux, Windows 2003/XP/Window 7

Languages

SQL, PL/SQL, Unix Shell Scripting, Visual Basic 6.0

Databases

Oracle 9i/10G/11G, SQL server 2007/10, DB2 V10

BI Tools

Cognos 8.1/10.2, Business Objects XI R2

Tools & Utilities

TOAD, SQL *Plus, SQL developer, Microsoft Project 10.0, MS word,

Microsoft Excel

Designer Tools

CA Erwin, Microsoft Visio

Professional Experience:

Hanover Insurance - Worcester, MA, USA Jan 2014 – Present

Cognos Developer

Project Description:

The goal of this entire project was to provide reporting capability to end clients/business users to run reports on customer policy information. The reports were generated to show the details of car insurance and home insurance policy formation by agent/state/year etc. MIS reports were generated to show quarterly/monthly premium information to higher management.

Responsibilities:

Created data flow diagrams and context diagrams to show the business processes using Microsoft Visio

Created development plan to track the reports development using Microsoft project

Used Erwin to create a data model using reverse engineering option and helped business users to understand the data model.

Redesigned reports in Cognos for improving reports performance and dash board report performance

Configured Cognos auditing for reports usage by the users to estimate the resource costs.

Implemented Cognos entitlement frame work for users to see only data based on organization entitlements.

Created business layer using DMR model in Cognos framework manager

Created multiple cubes for business users to slice and dice data in analysis studio

Used Microsoft Visio for business process diagrams to depict data flow of Cognos BI

Used Framework Manager to build models, packages and publish packages to Cognos Connection.

Built models containing query subjects, query items, and namespaces from imported metadata.

Updated Framework Manager Model based on the requirements (creating aliases, relationships, shortcuts, calculations, filters, packages, importing metadata, database functions, etc.

Developed Standard Reports, Charts, Master-detail & conditional formatting reports using Report Studio. Working experience with different date functions in Report studio.

Deployed Reports, Folders from DEV to UAT and from UAT to PROD Environments.

Implemented Security for Reports and Packages.

Environment: Oracle 11 g, Erwin 7x, Cognos 10.2.1, Zos /Mainframe, Microsoft Visio and Microsoft Project, Cognos FM 10.2, DB2 Content store.

The Hartford Insurance- Hartford, CT, USA Mar 2012 – Dec 2013

Cognos Developer

Project Description:

Straight through processing is an analytical application which is aimed at analyzing the source systems and extracting Claims data from several sources into enterprise data warehouse to run canned and Ad-hoc reports by end clients.

Responsibilities:

Defined data flow process to migrate Claims data from DB2 to Oracle database.

Used ERWIN to design conceptual, Logical and physical data models for the project.

Performed source data analysis and created source to target data mapping

Done database and query tuning activities to optimize reports performance.

Designed end to end BI platform for internal users to run reports and save data output into XLS, PDF formats. Created FM Model for P&C business line to generate reports in Cognos reports studio.

Used Visio for business process diagrams to depict data flow of Cognos BI

Created Cognos run book which contains the details of Cognos user entitlements and reports information.

Used Framework Manager to build models, packages and publish packages to Cognos Connection.

Created multiple cubes for verifying data multiple times in a day.

Built models containing query subjects, query items, and namespaces from imported metadata.

Created and Modified the Stored Procedures in Oracle and used them as source in Framework Manager and developed Models

Developed filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio for users.

Generated various List Reports, Crosstab Reports, Repeater Reports, Chart Reports, Drill-Down and Drill-Through Reports

Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameter

Environment: Software : Oracle 10 g, Erwin 7x, Cognos 10.2, Zos /Mainframe, Microsoft Visio and Microsoft Project, Cognos FM 10.2, DB2 Content store, Autosys

Liberty Insurance-Boston, MA Jan 2011 – Feb 2012

Cognos Developer/Data Analyst

Project Description:

The purpose of this application is to create predefined reports of customer insurance policy information. Business users wanted to have weekly /monthly/quarterly reports generated using schedulers.

Responsibilities:

Understand business requirements and convert them in to data models.

Created Logical and physical models using Erwin.

Created Meta data layer in Cognos FM and designed custom query subjects in FM layer to resolve complex query needs.

Written Complex SQL/PL SQL packages to load data into data mart tables, source data analysis, data source profiling, Data cleansing and data quality processing. Did database query tuning activities to optimize reports performance.

Extensively used FM layer to import tables and create business layer to create reports in cognos report studio. Implemented security filters for user entitlements.

Export and Import packages using Cognos administration tool

Production support for clients to successfully run the reports in production environment

Created user groups/roles to manage the reports entitlement.

Solved issues in existing Framework Manager.

Created Joins and Relationships in Framework Manager depending on reporting needs and verified them to minimize Cross Joins and data redundancy.

Developed List, crosstab, chart reports which involved multiple Prompts, Filters, multi-page, multiple queries against multiple databases.

Involved in deployment to UAT and Production.

Tested the reports and migrated to UAT for the second level of testing

Environment: Oracle 10g, Erwin, PL/SQL, Windows NT, Microsoft Visio, Cognos 8.1, UNIX

Annapolis tech Baltimore MD Jun 2009 – Dec 2010

Cognos developer

Job Description:

The aim of this project is to design reporting portal for analyzing customer data and generate management reports for sales and inventory department.

Responsibilities:

Created logical and physical data models with 3NF.

Created tables in DEV/UAT/PROD for storing data for reporting

Created functions, packages, procedures to simplify the tasks.

Created data layer and business layer in Cognos FM model, defined facts and dimensions in FM layer

Created package and published into DEV, UAT and PROD environments

Created Cognos predefined reports, ad-hoc reports using business requirements

Defined schedules to run the reports based on a schedule

Performed user administration and code deployments using export and import options in cognos

Created various report types like list reports, cross tab, charts, Dashboards that cover the entire range of enterprise reporting requirements

Used various functionalities in report studio like drill throughs, conditional formatting, parameter displays, Conditional blocks, Bookmarks, Render Variable, applied Java scripts in HTML items.

Environment: SQL server 2007, Erwin, PL/SQL, Cognos 8.1, Windows NT, UNIX

Polaris Chennai India Feb 2007 – Dec 2008

Cognos Developer

Responsibilities:

Involved creating reports using Cognos Report Net to support the TEAM to meet the business requirements and time deadline.

Created standard and Ad hoc reports using Cognos Impromptu tool to support Sr. Cognos developer’s requirements.

Developed List Reports, Cross Tab Reports and Drill through reports for different risk analysis purpose.

Created Dash board reports to get all the information from other reports.

Developed chart and complex reports which involved Multiple Prompts, Filters, multi-page and multi-query reports.

Created list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.

Worked in Scheduling and Deploying Reports according to risk management requests.

Developed Cognos Portal integration& Cognos Portal design according to different users’ requirements.

Environment: Cognos Report Net 1.1 MR1 (Framework Manager, Report Studio, Query Studio, Cognos Connection, Access Manager, Cognos 7.1), Windows NT/2000, SQL andSql Server 2000

Contact this candidate