We provide IT Staff Augmentation Services!

Sr Cognos Admin/ Developer Resume

NJ

PROFESSIONAL SUMMARY:

  • 7+ Years of IT Experience in analyzing, designing, developing and implementing Data Warehouse in different Environments with Emphasis on generation of complex reports using data modeling and Business Intelligence reporting tool.
  • Worked on complete Life Cycle Development process (SDLC) which includes Gathering User Requirements, Modeling, Installations, Administering Security, Authoring, Maintenance, Testing and End - User Training.
  • Strong Experience in Cognos 10.1.1/8.4, Report Net 1.1 (Cognos Connection, Query Studio, Report Studio, Metric Studio, Event Studio and Framework Manager), Cognos 7 (Impromptu, Power Play, Transformer).
  • Good experience in creating Presentation/Business Layers in Framework Manager Metadata models and published packages to Cognos Connection.
  • Applied data level, object level and package level security.
  • Developed Framework Manager Models (Joins, Prompt, Filters and Calculations).
  • Expert in designing & developing complex reports (List, Crosstab, Chart, drill-through, scorecards, dashboards & master-detail).
  • Created multiple report pages, prompt pages and cascading reports.
  • Created and ad-hoc reports (Query Studio) and done data mining (Analysis Studio).
  • Experience in Migrating data from Cognos 8.4 to 10(Life-Cycle Manager) and Dynamic Query Analyzer.
  • Experience in developing Scorecards (Metric Studio) and executive dashboards(Business Insight).
  • Developed Active Reports using Cognos 10.1.1.
  • Good Experience in Business Insight and Business Insight Advance.
  • Designed and Developed Transformer Models and Cubes.
  • Developed Dashboard Reports against Cube Data Sources and DMR Models
  • Experience with Scheduling and delivery via e-mail
  • Experience in Data Mining, Multi-Dimensional Data Analysis using Power cubes. Star Schema, Snowflake Schema used in relational, dimensional and multidimensional
  • Strong Knowledge of Data Warehousing, OLTP and OLAP concepts.
  • Sound Knowledge in SQL Queries and Databases concepts
  • Proficient in requirements gathering and analysis, validations, Business Requirements Specification and Functional Specifications and Functional Specification and Use cases
  • Performance tuning of the reports by using more drill-through, reducing SQL queries, using more inbuilt functions and applying star schema where possible.
  • Self-motivated with strong work ethic and skills in time management, client relationship and ability to adapt new things quickly.

TECHNICAL SKILLS

Technical Skills: Cognos 10.1/8.4, Report Studio, Query Studio, Analysis Studio, Dynamic Query Analyzer, Framework Manager, Impromptu, Cognos PowerPlay, Cognos Connection, Cognos TM1 Cognos IWR, Administration, Cognos Transformer, Life Cycle Manager, Oracle 11i, 10g, 9i, Teradata, SQL Server 2008/2005, DB2, IIS, IBM HTTP Server, ERWIN 7.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr Cognos Admin/ Developer

Responsibilities:

  • Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
  • Migrated the Data from Cognos 8.4 to 10.0 using Life Cycle Manager.
  • Developed Business view of the data(Metadata Models) with Namespaces, Folders, Query Subjects and Query Items in Framework Manager.
  • Built relationships between Query subjects, which represent the logical structure of the business and user requirements.
  • Built complex/summary query subjects, reusable filters and calculations based on relational data sources.
  • Created BI Dashboards, charts/graphs, drill through reports, dynamic reports to meet the requirements specification based on KPI’s.
  • Used Cognos connection for organizing the content, enabling security, scheduling and distributing reports.
  • Developed complex reports in Report Studio and ad-hoc reports in Query Studio
  • Developed Reports Using Cognos 10 Active Reports with new features like Active Objects and Active Connections.
  • Created list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations and conditions.
  • Created prompts and cascading prompt pages in report studio.
  • Created reusable templates for creating of reports.
  • Designed customized list reports by usingActive Reports.
  • Created Bilingual Reports. .
  • Created scorecard reports using Metrics studio, and Dashboards using Business Insights.
  • Setup event notifications using Event Studio.
  • Performed SQL tuning to enhance the performance of the reports.
  • Implemented complex SQL Queries to for retrieving the data
  • Implemented performance tuning of the reports by getting rid of extra queries for report generation.
  • Used Conditional blocks/variables and associated them with queries to show data only when the conditions were satisfied.
  • Validated Reports & involved in Productions support.

Tools and Technologies: Cognos 10.1/8.4, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Access Manager, Cognos Planning, Transformer, Word, Excel and Access, SQLServer 2008.

Confidential, PA

Sr. Cognos Consultant

Responsibilities:

  • Updated & administered the security privileges at object level in Cognos connection and data level for the created user profiles in Framework Manager.
  • Created and published packages for different subject areas, using Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
  • Created list, crosstab and Chart reports and implemented drill-though conditions and Master-Detail relationships.
  • Created Burst Reports and scheduled reports, Bilingual Report.
  • Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports. Customized prompts using HTML Items.
  • Used Union, Intersection, joins between queries in report studio.
  • Design scorecards, trends, actions using Metric Studio to monitor the customer satisfaction and performance of organization.
  • Created metric package with customized calendar settings. Defined metric groups, metrics, target values and variance in Metric studio for score carding application.
  • Built power-play cubes in Transformer, for dimensional analysis.
  • Implemented data level security in cubes using user group Custom views.
  • Administered different users with access/revoke and given grants.
  • Worked on scheduling the weekly and monthly auto-rebuild of the cubes. Implemented incremental update.
  • Developed several Dashboard reports using MDX with multiple pages having cube as data source.
  • Implemented Drill-up and Drill-down with advanced options.
  • Worked on Unit testing and data validation of 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.
  • Carried out performance tuning of reports, both on database side and Cognos report and modeling side.
  • Upgraded the Cognos environment by Installing and Configuring Cognos 10 on multi-server.
  • Used Business Insights and Business Insights Advanced to arrange individual reports and dashboards.

Tools And Technology: Cognos 10/8.4/8.3 BI Suite (Framework manager, Cognos Connection, Report Studio, Query Studio) Power Play, Transformer, Access Manager, DB2, SQL server 2008,Oracle 10g.

Confidential, NY

Sr.Cognosdeveloper

Responsibilities:

  • Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
  • Installed & configured the Cognos 8.4 BI Environment, Administering the Servers, Troubleshooting and Performance Tuning.
  • Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models
  • Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
  • Design and Developed the Framework Manager models using stored procedures, Relational tables and published in to server.
  • Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source.
  • Migrated reports from Cognos EP Series 7 to Cognos 8 Environment.
  • Upgraded reports from 8.3 to 8.4.
  • Customizing Cognos Connection Portal based on user specifications.
  • Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
  • Experience in writing with HTML in Cognos report studio reports as per the requirements.
  • Developing the Dashboard reports using Cognos Report Studio and Metric Studio.
  • Worked with Stored Procedure Query Subjects in FM and Reports.
  • Created Drill- through reports and Customized Reports with Prompts.
  • Developed Dash Board reports in Report Studio using MDX Functions.
  • Worked with Analysis Studio to develop multi-dimensional reporting.
  • Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
  • Resolved issues resulting from User Acceptance Testing (UAT).

Tools & Technologies:: Cognos 8.3/8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager), DB2, Oracle 11g, MS SQL Server 2008, Windows 2008, TOAD.

Confidential, Hoboken, NJ

Sr. Cognos Consultant

Responsibilities:

  • Study the existing Cognos Impromptu environment and draft the Design Document for the expansion project.
  • Built Framework Manager Model, and established the cardinalities to suit the business needs.
  • Implemented security for Data access, Object level access and Package access.
  • Developed and Published Packages in Framework Manager
  • Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
  • Developed List, crosstab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases using Report Studio.
  • Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
  • Created List Reports and Cross Tab Reports and Drill Through reports.
  • Created standard and Ad hoc reports using Cognos Query Studio.
  • Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
  • Implemented security for the developed Model and created user roles according to their requirement.
  • Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager.
  • Implemented Data Security, Object Security, Package Security and created user classes as per the requirement.
  • Worked with Cognos 8.2.1 modeling, Report Studio and Analysis Studio.
  • Created custom prompted reports in Report Studio, Bursting reports to different user groups.
  • Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.

Tools & Technologies: Cognos 8.2, Cognos Report Net, Framework Manager, Report Studio, Cognos EP Series 7.4, MS SQL Server 2000, Oracle 9i, SQL/PLSQL, Windows XP.

Confidential, Arlington, TX

Cognos Developer

Responsibilities:

  • Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
  • Extensive interaction with Business Users and gather information and requirements.
  • Migrated Reportnet Models and reports to Cognos 8.2.1 environment.
  • Managing User IDs and User groups like providing privileges to the users and User Groups in Access Manager.
  • Designed and Developed projects, packages, Reports using Framework Manager, Query Studio and Report Studio.
  • Modifying relationship between different databases tables and building models using Framework Manager.
  • Implemented Data Security, Object Security, Package Security and created user classes as per the requirements.
  • Analyzing the existing reports and preparing checklists starting from generating new reports in Report Studio, creating all the query items that match the expressions with the previous reports.
  • Created Dynamic Dashboards to evaluate the business performance based on various KPIs.
  • Developed Templates, Master Detail Reports, Chart Reports and Multilingual Reports using Report Studio and Query Studio.
  • Design, Develop and test new queries with end users.

Tools & Technologies: Cognos 8 BI, Framework Manager, Cognos BI Series 7.3, Cognos Metrics Manager 2.2, SQL Server 2K, Oracle 9i, OPM11i database and Win 2003/XP

Confidential

Jr. Cognos Developer

Responsibilities:

  • Involved in Designing the Entity-Relationship (ER) Diagrams for Data Modeling.
  • Created Framework Manger Models and created and published packages into the portal.
  • Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
  • Developed List, Crosstab, Drill-through, Master-Detail, Charts and complex reports which involved Multiple Prompts, Filters, Pages, Multi-Queries against multiple databases using Report Studio.
  • Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
  • Implemented security for the developed Models, Data and Packages.
  • Involved in logical, physical and relational modeling of data as per the information available in the organization.
  • Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
  • Developed/Modified scripts to create tables, views and executed them using SQL Plus.

Tools & Technologies: Cognos Report net 1.1, Impromptu 7.3, Transformer 7.3, Upfront, Oracle 9i, MS SQL Server 2000/2005