Cognos Developer

Umesh Kumar

*****.********@*****.*** +1-908-***-****

Close to 9 years of experience in Information Technology and a wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation of the business technology solutions.

9 years of working experience in Cognos BI tools using Cognos Framework Manager, Report studio, Query studio, Analysis studio,Transformer,TM1

Experienced in Cognos 11, 10, 8, Report Net with Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.

Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.

Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.

Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.

Experience in Transformer model design and Power play cube building.

Exposure to ETL technologies such as Informatica, DataStage for support of data extraction, transformation and loading process in corporate-wide-ETL solution

Worked on Informatica PowerCenter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.

Involved in a data migration process between different versions of Cognos.

Prepared training documents and teaching COGNOS to clients on the use of COGNOS Query

Experienced in developing Dashboards Reports in Cognos 8,Cognos 10,Cognos 11 and Tableau

Created and published packages in Framework Manager from various data sources.

Strong experience in client interaction and understanding business application, business data flow and data relations from them.

Provided support to users on reporting and Cognos functionality, ensuring customer satisfaction

Monitor the Cognos environment and check the usage of the environment, reports, etc.

Preparing test cases and also involved in unit testing, System Integration Testing, bug fixing and UAT.

Worked with Different Databases like Oracle8i/9i/10g, SQL Server 2000, SQL Server 2008, PLSQL, T-SQL.

Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Business Intelligence Tools

Cognos 11,10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), Framework Manager, Cognos Impromptu, PowerPlay Transformer, ReportNet, Impromptu Web Reports (IWR), Access Manager, PowerPlay Enterprise Server, Scheduler), Tableau 8,Tableau 10.1

ETL Tools

Informatica, DataStage

Databases

SQL Server 2000/2008, Oracle 8i/9i/10g, PLSQL,T-SQL, Teradata

Languages

Javascript, Visual Basic, SQL, PL/SQL, XML

Operating Systems

Windows 95/98/XP/NT/10

PROFESSIONAL EXPERIENCE

Bank of America Jan 2016 till date

Senior Cognos BI Developer

Project: Compliance Risk Analytics

Bank of America is the nation’s largest bank by market capitalization. The Bank serves more than 59 million consumers and 6,100 retail banking offices. Bank of America ranks as the industry leader in global treasury management services, 62% of leading corporate companies use Bank of America for treasury services and products.

The purpose of this new project was to develop various reports which would help the users to analyze the risks associated with various applications, also help them to track the issues and provide executive management with dashboards.

Responsibilities

Effort estimates and impact analysis for the new changes.

Client and Offshore coordination for the project including status meetings.

Preparing High level and Low Level Design documents.

Preparing test cases and also involved in unit testing, System Integration Testing, bug fixing and UAT.

Created list reports & cross tab reports using Cognos 10.1,Cognos Analytics 11

Created active reports

Involved in working with cubes and developed various dashboard reports.

Worked on Analysis Studio to develop multi dimensional reporting

Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio

Experience in developing Framework Manager Models and analyzed those models in analysis studio.

Gathered and analyzed business requirements from users and business community.

Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.

Created mapping documents to outline data flow from sources to targets.

Developed mappings to load into staging tables and then to Dimensions and Facts.

Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Created Dashboards using Tableau.

Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

Environment: Cognos 8 & 10 BI, Cognos Analytics11, Cognos Connection, Cognos office Connection, Report Studio,

Query Studio, Analysis studio, Metric studio, Frame Work Manager, Toad, Javascript, Microsoft Visual Studio

Informatica, Tableau 10.1

Bank of America/ Tata Consultancy Services June 2015 till Dec 2015

Senior Cognos Developer

Project: Deposits

The project objective is to provide Analytical Report Development, Maintenance and enhancements to the Data Warehouse, ‘The W’. The warehouse, The W, is a mainframe-based database, which is designed to handle Bank of America’s Customer Knowledge & Decision Support activities.

Responsibilities

Generated reports and framework models as per user requirement.

Created filters, prompts, calculations and determinants for efficient data retrieval and analysis.

Created parameter maps; stored procedures for importing as data source, checked for corrupted models and restored to original.

Proficient in Report building using Report Studio, and Analysis Studio.

Created List, Crosstab and Drill-Through reports using Report Studio.

Created Ad-Hoc reports using Query Studio.

Dashboard development using Tableau 8.1

Deployed the reports from development environment to test environment.

Tested models and reports, from time to time to remove any inconsistencies. Responsible for Unit testing and System testing of the reports based on the specification.

Reporting testing - creating test cases, scripts and executing them. Tested the fixed reports in Cognos 10 environment as well as the Performance of the reports in Cognos 10 environment.

Environment: Cognos 8 & 10 BI, Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio,

Frame Work Manager, Teradata, Javascript, Tableau 8.1

XL Global Services/ Tata Consultancy Services Dec 2008 till May 2015

Cognos Developer

Project: IDW MI Reporting

Insurance Data Warehouse (IDW) is to capture data on an ongoing basis and use it effectively for analysis and reporting. Raw data including historical transactions from various source systems is staged into the IDW environment and then cleansed. It is then transformed as per business/reporting requirements and loaded into the warehouse. The data is then used as input for various downstream applications like reporting services, ad-hoc reporting etc. Activities performed as part of IDW MI reporting are to provide application technical support, develop and implement the changes required, and assist business for testing.

Responsibilities

Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.

Created multiple Dashboard reports for multiple packages.

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

Involved in extensive use of conditional formatting while developing reports in Report Studio.

Designed ETL specification documents for all the projects.

Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Extensively used workflow variables, mapping parameters and mapping variables.

Initiated training for the users to do ad-hoc reporting using Query Studio.

Interacting with the user to get the detailed information about the issues.

Installed and configured Cognos 8.3,Cognos 8.4 and Cognos 10.1 in Dev Environment.

Preparing and testing the code to fix the issues in Development and QA environment.

Involved in preparing Test scripts and validating the data based on the Scenarios.

Designed and Prepared a Training Material for the Users.

Closely Involved in Requirement gathering and Analysis with the customers.

Implemented Security for Data access, Object level access and Package access

Used Cognos Connection extensively for organizing, security, scheduling and distributing reports

Formalized the reporting process by creating the technical specification and requirement specification.

Involved in production support.

Environment: Cognos 8 & 10 BI, Cognos Connection, Cognos office Connection, Report Studio, Query Studio,

Analysis studio, Metric studio, Frame Work Manager, SQL Server 2000/2008, T-SQL, XML,Windows 7/8/XP/2000,

Informatica.

Contact this candidate