Post Job Free

Resume

Sign in

cognos developer

Location:
United States
Posted:
February 09, 2016

Contact this candidate

Resume:

Kartheek Reddy

actgs5@r.postjobfree.com

302-***-****

Professional Summary

9+years of IT Experience in Design and Development of relational database applications, Data

Warehouse/BI Applications. Business Intelligence Reporting, design development, Performance Tuning, Application Development and product support on various platforms.

Hands on experience on Cognos SDK

More than 4 years of extensive work experience on Cognos Suite 8, with strong experience in Report Studio, Query Studio and Framework Manager.

Expertise in Cognos Enterprise Suite including Cognos8.4,Cognos Report Net, Impromptu Reports,

Impromptu Administration, Impromptu Web Reports (IWR), Power Play, Access Manager,

Transformer, Upfront, Power Play Enterprise Server

Skilled in the installations and environmental setups for with multi servers .Have very good experience in setting up the trusted signon, dashboard installation using the latest features of the cognos SDK

Profound knowledge in Transformer model design and Power play Cube building

Extensively worked on understanding the business requirements and designing Cognos applications

Created complex statistical and financial reports, trend over time reports, ranking and forecast reports, Extensive Dashboards using Report Studio.

Expert in creating publishing packages in the Framework Manager from various data sources in Report Net. Generated different kinds of reports in Report Net, created templates and multilingual reports

Extensively worked on Transformer for Data Modeling of the corporate data for building up of

Multidimensional Cubes.

Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources

Implemented Tree Prompt and MDX commands in Cognos

Proficiency in Report Authoring using Cascading prompts, conditional formatting, drill-through

Reports, bursting and Tabular SQL’s Security implementation among Cognos applications using access manager.

Experience on warehouse management in I Series.

Strong knowledge on Internet based reporting and strong Analytical skills and attention to detail

Strong experience in Client interaction and understanding business applications, business data flow and data relations for them

Excellent understanding of Software Development Life Cycle and dimensional modeling techniques using Star and Snow-flake Schema Modeling

Expertise in Modeling data with modeling tools like Erwin

Expertise in SQL Server 2003/2005, oracle 9i,10g, Db2,Tera data and SAP BW

Worked on Informatica (ETL) and Data stage

Proven problem solving skills with excellent analytical, communication and interpersonal skills

Excellent team player and Superior organizational and time management skills

Administration of Access Manager to implement Security among Cognos applications

Provided extensive End User Training and Support.

Technical Skills

Hardware

IBM PC Compatibles and NT servers

Operating Systems

Windows, Unix/Linux, MS-DOS.

OLAP tools

Cognos 10.x,8.x(Report Studio, Frame work manger, Analysis Studio,

Business Workspace, Business Workspace advanced), Transformer 8.3, Impromptu Administrator, Powerplay Transformer, Powerplay,

ReportNet, Oracle

Database

Oracle 7.x/8.x/9.x/10g, SqlServer 2008,2012sql* loader, Teradata

RDBMS

Stored Procedures, Database Triggers, and Packages.

Technologies

C,C++,JAVA,Cobol,.net, PHP,Vb,Assembly Language

Multimedia

Adobe Photoshop, Flash, Dreamweaver

Tools

Autosys, Clear Case, Toad, BTEQ

Version Control

Git, CVS

Professional Experience

Client: Bank of America New York, New York

Role: Senior COGNOS Developer Aug 2014 - Present

Responsibilities:

Involved in Requirement gathering from Business Users

Analyzing the source data from different databases.

Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.

Designed and Developed the Framework Manager models and Published into the Cognos Connection.

Installed and Configured Cognos10.2.1/10.2/10.1 Suite in multi-server environment on Windows and UNIX environments.

Migrated Reports, Upfront Content from Cognos series 7.4 to Cognos10.2.1/10.2/10.1

Upgraded all Cognos10.2.1/10.2/10.1 Packages, Reports and Folders from 10.1 to 10.2.1.

Created Metadata Modeling by using Multiple Databases in Cognos10.2.1/10.2/10.1 BI Modeling.

Created and Published Packages from Cognos10.2.1/10.2/10.1 BI Modeling.

Created Complex Reports using Cognos10.2.1/10.2/10.1 BI Report Studio and Ad-hoc web based reports using

Cognos10.2.1/10.2/10.1 BI Query Studio.

Developed various Complex report types ranging from simple Lists, Cross-tabs through complex

dashboards, drill-through, Master-detail & conditional formatting reports.

Created Region Cubes Using IQD’s which were built in Framework Manager.

Created Member based security, Custom/ Dimension views, Apex custom views and cloak.

Created Scheduled Jobs by (Triggers) and scheduling multiple reports a job.

Publishing to Cognos connection and implemented securities for the packages.

Performance tuning on power-cubes to reduce Query time and partitioned Cubes.

Tested and validated the report output against the database to measure performance of reports.

Deployed Reports, Packages and Folders from DEV to UAT and from UAT to PRODenvironments.

Developed and implemented the coding of Informatica Mapping for the different stages of ETL.

Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.

Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map source to the target.

Created Informatica Mappings with different transformations including Source Analyzer, Lookup,Filter, Expression, Rank, Aggregator, Stored Procedure, Look up Transformations and more.

Developed mapping to implement type 2 Slowly which changing dimensions.

Extracted the data from Relational Database, Flat Files and Loaded into the target Data

warehouse.

Environment:Cognos10.2.1/10.2/10.1 BI Report Studio, Cognos10.2.1/10.2/10.1 BIQuery Studio, Cognos10.2.1/10.2/10.1 BI Analysis Studio, Cognos10.2.1/10.2/10.1 BI Modeling, Framework Manager, Cognos Connection,ReportNet1.1,Cognos Series 7.4, Power Play Transformer, Migration Utility Tool, Oracle 10g, DB2, PL/SQL, UNIX andWindows 2000.

Client: Apple Inc. Cupertino, California

Role: Senior COGNOS Developer/ Admin March 2013 – July 2014

Responsibilities:

Worked on complete life cycle of Cognos 10 Administration and Cognos BI (Installations,Security, Configurations, Migration and deployment).

Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.

Worked on Cognos 10 (Business Insight and Active Reports) for two demo projects to demonstrate the End-User the new features available in Cognos 10.

Also created active report variables to allow controls in a report to interact with each other.

Active report variables pass information from one control to another control.

Worked on technical design specs for Framework manager, and reporting per the

Requirements.

Created project, namespace (Database View, and Business View), and folders and imported

Required metadata in Cognos Framework Manager.

Provided cardinality, check data usage, identifiers in the database view.

Created model query subjects, Data source query subjects, stored procedure query subjects as

per the business requirements in the Framework Manager

Provided version control using CVS for FM Packages, and reports.

Created schema prompts, required, optional prompts, parameter files, parameter mappings

for automation using macros.

Worked on multiple database, and multiple data source in Framework Manager to generate

Reports.

Created standard reports in Cognos Report Studio, and Analysis Studio.

Responsible to build the Framework Manager Models and packages as per the business

Requirements.

Published the Packages, and provided security in Framework Manager.

Worked on various reports like, List, Crosstab, drill-thru, multi-query, master/detail, prompted,

Dashboards, portlets, and tabular reports.

Designed complex reports with union queries, and SQL queries

Improved long running reports performance thru writing SQL queries, resolving complex joins in

Framework manager, filters, and using stored procedures.

Wrote java scripts for report prompts automation.

Expertise to understanding, analyze, Cognos, data warehouse(OLAP), and OLTP data

Designed transformer models, and powerplay cubes using powerplay transformer.

Worked on powerplay studio to slice/dice Cognos cubes,

Worked on performance tuning to maintain fast performance of the cubes and Transformer

Models.

Provided customer training in Report Studio, and Query Studio.

Developed number of prototypes for the business users. This project was bases of star schema,

OLTP data.

Responsible to provide tech support for Abbott customers, and also leading offshore team.

Strong knowledge on data warehousing methodologies, and best practices.

Environment:Cognos 10/8.4, Report Studio, Framework Manager, Query Studio, Event studio,

Powerplay Studio, Analysis studio, Powerplay transformer8.4, Teradata12.0, and Oracle10g,

Informatica, Unix and windows.

Client: Verizon Dallas, Texas

Role: Cognos DeveloperJuly 2011- Feb 2013

Responsibilities:

Gathering functional requirements from business customers, analyzing and transformingthem into business intelligence reporting specifications.

Developed Technical Design Documents.

Developed logical & physical modeling as per business requirements using ERWIN 3.

Designed and developed snow flake /star schemas for better understanding of models using ERWIN.

Designed DMR models in Framework Manager

Created and published packages for different functional areas and assigned security rules to them in Framework Manager.

Created list, crosstab and drill through reports for departments like claims, billing, members/subscribers in Report Studio

Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.

Created Burst Reports and Multilingual Reports based on groups of users & Preferences for our Asian, African and European partners

Created Drill Through Reports & Master Detail Reports for Accounts Department.

Used Union, Intersection for creating queries.

Created dashboards, portlets for various HR and payroll related reports. E.g. investments related to 401K plan were displayed as dashboards showing their investments, returns, losses, dividends earned, etc.

Developed various HR reports – MTD, QTD, YTD, last fiscal year, current fiscal year reports, employee taxable, paid time offs, holidays, sick leaves, workers compensation report (WCR) etc. These reports were mainly on employee level but I also developed scorecard and dashboard reports which were mainly developed for the departmental heads and regional heads.

Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.

Created complex reports in Cognos mainly dealing with Member Data, Claims data and Provider Data.

Created score cards using Metric Studio.

Wrote Procedures and triggers in Oracle for file handling, data validation, Inserting data etc.

Wrote and executed the test cases for various reports that were developed in Cognos.

Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.

Created models in Transformer, built cubes and published cubes to Analysis Studio

Carried out performance tuning of reports.

Interacted with ETL team to gather the requirements for the reporting.

Involved with the Solutions Architect and the QA team for validation and verification of the development.

Exceptionally good and experienced in handling the problem and troubleshooting.

Trained End users to operate the reports.

Environment:Cognos8.4, Transformer, Report Studio, Query Studio, Metric Studio,

Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX.

Client: Aflac Incorporated Columbus, Georgia

Role:Cognos Consultant Nov 2010 – June 2011

Responsibilities:

Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.

Managed Core Project, Responsible for delivery and resource allocation etc.

Creating Teradata views and imported views and employed relation between views.

Developed DMR modeling using Cognos 8 Framework manager.

Enhanced the model, Tested and Created replacement IQDs’ using Framework Manager.

Created Dimension IQD’s and Fact queries in Frame work Manager.

Created Projects, Models, and Packages using CognosFramework Manager and deployed packages on Cognos Connection.

Installed and configured Cognos 8.4 BI and worked with Cognos 8 BI modeling, Report Studio.

Responsible for Access permission and administrating the server.

Created highly Customized reports in Cognos 8.2 Report Studio and some of the Ad-hoc reports in Query Studio.

Used HTML and Java Scripts for Advanced reporting purpose.

Gathered information like attempted calls, type of call (long distance, local), length of call, originated number, destination number, rates, time of call for creating report for billing of a customer.

Implemented security in reports according to employee groups and roles according to the requirement.

Involved in Creating Content store, installation and Configurations of the ReportNet.

Implemented Tree prompt and MDX Commands in Cognos.

Developed Portlets and dashboards reports according to the user requirements.

Tuned cube builds Impromptu Reports and ReportNet reports and servers for better performance.

Implemented Data Security using LDAP in Framework Manager 8.2.

Environment:CognosReportNet 8.1/8.2,8.4,Framework Manager, Report Studio, Query Studio, Analysis Studio), Transformer, PowerPlay Enterprise Server, Cognos Impromptu, LDAP, Access Manager, IIS, Informatica, PeopleSoft, server 2005, Oracle 9i, TOAD

Client: OPTUM Insight Indianapolis, Indiana

Role:Cognos Developer Aug 2009 – Oct 2010

Responsibilities:

Interviewed business community to identify business, data, and delivery requirements.

Designed models in Framework Manager.

Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.

Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and PROMPTS depending on user requirements.

Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio

Created models in Transformer, built cubes and published cubes to Power Play server.

Scheduled reports using Cognos scheduler and emailed to various recipients as required.

Involved in monitoring Data stage jobs and generating reports aftersuccessful job scheduling.

Optimized and modified the triggers, complex store functions, procedures, user base data type.

Environment:Cognos 8.2, Transformer 8.3, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 RTM SDK.

Client: TATA Steel, India

Role:JrCognos Developer June 2008 – July 2009

Responsibilities:

Created the Stored Procedures, tables, Views depending upon the project requirement.

Created the deployment scripts after the development is done for every project.

Developed and customized Impromptu Reports and PowerPlay Reports.

Used Cognos Impromptu tool to create standard and ad-hoc reports.

Customized catalogs and created user profiles to grant user permission for accessing data from different database tables.

Customized data by adding Filters, Prompts, Calculations, Summaries, and Functions.

Developed Multi-dimensional Cubes using PowerPlay.

Environment:CognosReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Cognos Transformer 7.x, Impromptu 7.x, PowerPlay 7.x, Cognos Upfront, Cognos Script Editor, Microsoft Excel, Oracle 9i and MS SQL Server 2000

Client: IDBI Bank, India

Role:JrCognos Developer Jun 2006 – May 2008

Responsibilities:

Involved in Installation and configuration of COGNOS ReportNet and Framework Manager.

Developed various packages using Framework Manager in ReportNet, using different data sources, established relationships in a model, Created IQDs, Created different layers (Database/Business).

Implemented Star Schema Grouping and Dimension Hierarchy in Model.

Involved in converting catalogs into ReportNet packages using migration utility. Implemented Framework Manager security for Data access, Object and Package level access.

Designed the Model according to the Business Requirements by creating a Presentation Layer.

Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations.

Created Cascaded prompts, drill through (from report to report, cube to ReportNet report).

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.

Customized data by adding Filters Prompts, Calculations, Summaries and Functions.

Performed Scheduling and Bursting of reports according to user requirements in COGNOS connection.

Environment:ReportNet 1.0(Framework Manager, Report Studio, Query Studio), Impromptu 7.0, Power Play 7.0, PowerPlay Transformer, Impromptu Web Reports, Upfront, PeopleSoft EPM, Access Manager, Power Play Enterprise Server, Windows NT/2000, Oracle 9i



Contact this candidate