We provide IT Staff Augmentation Services!

Sr. Cognos Developer Resume

Pennington, NJ

SUMMARY

  • 8 years of IT experience in analysis, design, development, deployment, testing and support of Business Intelligence Applications.
  • Over 6 years of working experience with Cognos 10, 8 BI Suite (Framework Manager, Cognos connection, Report Studio, Metric Studio, Analysis Studio and Query Studio)
  • Expertise in gathering business requirements and creating models &reports to meet the requirements.
  • Handling complete range of BI capabilities: reporting, analysis, dashboards and business event management.
  • Expertise in developing and testing Complex reports (List, Crosstab, Charts, Maps, Drill - through, Master-Detail, Cascading prompts, Filters, Calculations) using Report studio
  • Experience building interactive Workspaces(Dashboards) using Cognos Workspace (formerly Business Insight) by bringing together report components and using Widget features to interconnect them.
  • Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
  • Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications.
  • Extensive experience in Multiple Relational Databases including SQL Server, Oracle & DB2
  • Experience with writing SQL queries, Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers.
  • Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development
  • Involved in training end users and providing technical support and documentation
  • Ability to adapt and learn new technologies and to get proficient very quickly with them
  • Experienced in PowerPlay Transformer and client to design models and analyze the Power Cubes.

TECHNICAL SKILLS

BI tools: Cognos 10.2/10.1/8.4/8.2 (Report Studio, Framework Manger, PowerPlay Transformer, Analysis Studio, Query Studio, Business Insight\Workspace, Business Insight Advanced\Workspace Advanced, Data Manager, Administration, SDK), SAS 9

ETL Tools: Data Stage 8.7, SSIS, DMExpress

Databases: Oracle 9i/10g/11g, SQL Server 2000/2008/2014 , DB2 V9, Teradata 12

Languages: C#.NET, VB.NET, VB 6, C++, COBOL, PL/SQL

DB Tools: SQL *Plus, SQL *Loader, BTEQ, SQL Assistant, TOAD

Other Tools: CA Easytrieve, ASG ViewDirect, DocumentDirect, VPSX, IBM File-Aid

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Sr. Cognos Developer

Responsibilities:

  • Involved in business requirements gathering, data modeling and database design, report development, performance tuning, and data delivery mechanisms
  • Created Metadata Models using Framework Manager with relational data and deployed packages to Cognos Content Store
  • Worked jointly with the data management team members to understand data domains, values, cardinalities and other dimensions of data, needed to support BI solutions
  • Designed and developed Dimensionally Modeled Relational models (DMR) from a relational data source by creating regular & fact dimensions, specifying scope relationships in Framework Manager
  • Implemented data level security filters, object level and package level security in framework manager to achieve highly complex security standards
  • Implemented Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between dimension query subjects and fact query subjects in Framework Manager
  • Created advanced Workspaces/Dashboards in Cognos Workspace/Business Insight for commercial loan line of business users, by adding report objects authored in Report Studio to present critical company data in a single view
  • Developed list, crosstab, drill-through, master-detail, chart and complex reports which involved multiple prompts, calculations, filters, HTML items in Report Studio
  • Created JavaScript solutions in Cognos reports to enhance the capabilities like doing post validations on prompts, dynamically change report content
  • Designed Reports using Boolean and String variables to conditionally format and conditionally render report items
  • Implemented Report Bursting by defining burst groups, report recipients and specifying master-detail relationships to distribute segments of reports to different users
  • Developed dimensional models in Transformer, built and published PowerPlay cubes to Cognos Portal, created batch scripts to automate cube refresh process
  • Worked with Session parameters, parameter maps and macros to add dynamic behavior to metadata models in Framework Manager
  • Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
  • Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support

Environment: Cognos 10.2/10.1.1 (Framework Manager, Transformer, Report Studio, Query Studio, Business Insight/Workspace, Business Insight Advanced/Workspace Advanced, Cognos Connection and Administration), Oracle 11g, SQL Server 2008, TOAD, PL/SQL, IBM Datastage 8.7, Korn Shell Scripting,VSAM, IBM File Manager, ASG Document Direct

Confidential - Gaithersburg, MD

Cognos Developer

Responsibilities:

  • Worked with business users, functional lead to understand and document the Business requirements
  • Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager
  • Migrated reports built in SAS to Cognos by building metadata models and authoring report specs using Report Studio
  • Created Metadata Models by using multiple data sources in Cognos Framework Manager, published Packages to Cognos Content Store
  • Created Dashboards using Business Insight to bring together report components and linking them together using widget control features.
  • Created Complex Reports in Report Studio using Cascading prompts, Dynamic columns, Conditional rendering and master-detail relationships
  • Extensively used PowerPlay Transformer to build Dimensional Models and created PowerPlay reports using Analysis Studio
  • Developed List, Crosstab, drill-through and complex reports which involved multi-queries
  • Deployed Packages and Reports from DEV Environment to UAT and PROD Environments
  • Did Unit Testing for all reports and packages validating report outputs by comparing against query outputs from database
  • Creating report views with saved prompts and schedule according to the business requirement
  • Personalized Cognos Connection, Specified display options, regional options and personal information
  • Created ETL mapping documents and built SSIS, DMExpress jobs to migrate data from Mainframe platform to AIX

Environment: Cognos 10.1 (Transformer, Framework Manager, Report Studio, Query Studio, Metric Studio), Oracle 11g, DB2, SQL Server, Erwin 4.0, TOAD, PL/SQL, UNIX (AIX), DMExpress, SSIS

Confidential - Minneapolis, MN

Cognos Developer

Responsibilities:

  • Developed and implemented information management solutions as a part of Business Intelligence Organization
  • Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance
  • Collaborated with business to develop high-level designs including logical models and functional specification documents
  • Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements
  • Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks
  • Designed and developed Powerplay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users
  • Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data
  • Created BTEQ scripts to extract data from warehouse for downstream applications
  • Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data
  • Administered Cognos BI Server Environment, managed Package Migrations and Deployments from one Environment to another, defined Data Sources, run activities, user accounts and permissions

Environment: Cognos 8.4 (Framework Manager, Transformer, Report Studio, Query Studio, Administration), Teradata 12, Oracle 10g, DB2 v9, Erwin 4.0, TOAD, UNIX, Cognos 8 SDK, SQL Assistant, BTEQ, Data stage 7.5

Confidential

Cognos Developer

Responsibilities:

  • Analyzing the specifications provided by the client and developing the specification document for the reports as per client requirements
  • Designed and Implemented metadata models in Framework Manager and PowerPlay cubes in Transformer
  • Collaborated with business to develop high-level designs including logical models and functional specification documents.
  • Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks
  • Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship
  • Designed and developed PowerPlay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users
  • Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data
  • Scheduled reports using Cognos scheduler and emailed to various recipients as required
  • Worked on TOAD for Oracle database systems for creation of ad-hoc queries and for improving various performance issues

Environment: Cognos 8.4 (Framework Manager, Transformer, Report Studio, Query Studio), Oracle 10g, PL/SQL, TOAD, AIX, Korn Shell Scripting

Hire Now