We provide IT Staff Augmentation Services!

Senior Cognos Developer Resume

2.00/5 (Submit Your Rating)

Tampa, FL

PROFESSIONAL SUMMARY:

  • Close to 8 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.
  • 7+ plus years of working experience in Cognos BI tools using Cognos Framework Manager, Report studio, Query studio, Analysis studio,Transformer,TM1, Cognos BI for Microsoft office (Go office) and CAFE
  • 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.
  • Experience in development of TM1 rules, TM1 installation and maintenance
  • Exposure to ETL technologies such as Informatica, DataStage,Pentaho 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.
  • Experienced in installation/migration from Cognos 10 to Cognos 11 (Analytics)
  • Prepared Business requirement and Technical specification documents
  • Experienced in developing Dashboards Reports in Cognos 8,Cognos 10,Cognos 11 and Tableau
  • Experienced in report validations and version control using Cognos Life Cycle Manager and Motio CI
  • Created and published packages in Framework Manager from various data sources.
  • Have knowledge on Microstrategy,SSAS,Business Objects,QlikView,Spotfire and OBIEE
  • Have knowledge on Cognos Architecture,Cognos SDK and Cognos Administration
  • Have knowledge on Microsoft Visual Studio, SharePoint, Oracle Hyperion and Python
  • Have basic knowledge on Amazon web services
  • Have knowledge on ERWIN Data modeling tool
  • Have knowledge on JIRA
  • Provided training and support to users on reporting and Cognos functionality, ensuring customer satisfaction
  • Preparing test cases and also involved in unit testing, System Integration Testing, bug fixing and UAT.
  • Worked with Different Databases like Oracle8i/9i/10g/12c, Teradata, SQL Server 2000, SQL Server 2008, PLSQL, T-SQL,MySQL
  • Experienced in writing SQL queries.
  • 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), Cognos TM1 10.1,10.2, Tableau 8,Tableau 10.1

ETL Tools: Informatica, DataStage, Autosys

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:

Confidential

Senior Cognos Developer, Tampa, FL

Responsibilities:

  • Involved in Requirement gathering and offshore team handling
  • Preparing Business Requirement,High level and Low Level Design documents.
  • Involved in preparation of stored procedure and functions
  • Design Framework Manager Projects, Model & Packages by importing the Metadata from various Data Source tables, Views,stored procedures
  • Created list reports, cross tab reports and dashboards using Cognos Analytics 11.0.10,10.2
  • Created custom prompted reports in Report Studio, Bursting reports to different user groups.
  • Involved in working with Cascading Prompts, Conditional Formatting, and Conditional Blocking.
  • Used javascript for validation and customization
  • Involved in writing Complex SQL queries and stored procedures to improve the performance of the report
  • Used Cognos Event Studio to manage report runs and notifications. Was able to achieve dynamic subject line when scheduling report

Environment: Cognos Analytics11,Cognos 10, Frame Work Manager, JavaScript, Sybase

Confidential

Senior Cognos Developer, Charlotte, NC

Responsibilities:

  • Involved in Requirement gathering and offshore team handling
  • Preparing Business Requirement,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 and dashboards using Cognos 10.1,Cognos 10.2,Cognos Analytics 11.0.6,11.0.10
  • Created PowerPoint and excel reports for audit and regulatory reporting using Cognos BI for Microsoft office (Go office) and CAFÉ
  • Created Macros using Microsoft Visual Studio for Cognos BI reports.
  • Developed Cognos architectural framework based on business needs.
  • Validated database views and tables of architectural frameworks.
  • Worked on upgrading reports from Cognos 10 to Cognos Analytics 11
  • Used Cognos Life Cycle Manager (LCM) /Motio CI for report validations
  • Design and build successful technical solutions that involve TM1 cubes, dimensions, TI processes and rules
  • Maintenance of TM1 users, roles, and security.
  • Development of TurboIntegrator(TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
  • Created rules to transfer data between cubes.
  • Used TM1 rules editor to create and edit rule to create various calculations.
  • 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.
  • 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 and QlikView
  • Used some advanced features like Conditional Formatting and JavaScript in cognos reports.
  • Used Toad/Teradata/Oracle databases to debug and fix data issues
  • Performed Unit Testing and User Acceptance Testing
  • Used HP Quality Center for Bug Tracking, Reporting and Analysis.

Environment: Cognos 8 & 10 BI, Cognos Analytics11, Cognos Connection, Cognos office ConnectionCognos TM1 10.1/10.2,Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, ToadJavaScript, Microsoft Visual Studio, C#,Informatica, Tableau 10.1,QlikView,Erwin 9.6,Oracle 12c

Confidential

Senior Cognos Developer, Hartford, CT

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 studioFrame Work Manager, Teradata, Javascript, Tableau 8.1

Confidential

Cognos Developer

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 StudioAnalysis studio, Metric studio, Frame Work Manager, SQL Server 2000/2008, T-SQL, XML,Windows 7/8/XP/2000Informatica

We'd love your feedback!