We provide IT Staff Augmentation Services!

Bi Cognos Consultant Resume

Manhattan, NY

SUMMARY:

  • Over 16 years of experience in analysis, design, development and implementation of Business Intelligence and maintaining Applications of Cognos Analytics 11.4,11.5 and 11.9, 11.11, 11.12, Cognos 10.2 BI, IBM Cognos, 10.1 BI, Business Objects 4.0, Tableau 8.1 Cognos TM1, Cognos 8.4, Cognos 8.3, Cognos 8.2, Cognos 8.1, Cognos ReportNet, Cognos Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay Transformer, PowerPlay Client, PowerPlay Enterprise Server, Architect, Access Manager, Upfront, Configuration Manager.
  • Installed, configured and supported all versions of Cognos in multi - server environment.
  • Installed, Configured and supported Business Objects 4.0
  • Well versed with developing of OLAP cubes for the database applications.
  • Managed Server administration and fine-tuned dispatchers and services, executed load balancing, created jobs & scheduled reports.
  • Managed Cognos Connection Portal and assigned users, roles and groups for authentication and authorization. Edited Governor Settings in FM to reduce resource requirements and improve performance in SQL execution.
  • Highly Familiar with Access Manager Implementations - users, groups, classes and security.
  • Strong experience in Cognos Administration: Security, Content Administration and Deployment, Load balancing, Migration Planning.
  • Implemented object-level and package level security in Framework Manager Models for restricting access to metadata across Cognos environment.
  • Experienced in design, development and testing of Cognos Powerplay cube models. Developed Measures, dimensions, levels, categories, special Categories and alternate drill down paths in Transformer Model. Implemented Cube Security and worked on Confidential . Enhanced performance of the Power Cubes. Performed end to end design including derivation of calculations and ideal precision/scale determination.
  • Experience with Cognos Report Studio and Analysis Studio in development of financial, analytical and operational reports on operational and data-mart sources in Cognos 10, Cognos 8 and Cognos ReportNet.
  • Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports.
  • Mentored junior developers and business users in Report Studio, Query studio and Analysis studio report authoring and Cognos Connection Portal Administration
  • Experienced in Publishing the Reports onto the Web using Cognos Distributed Shuttle Builder and Report Administrator.
  • Experienced in developing reports using Cognos Impromptu
  • Extensively used RDBMS like Oracle and SQL Server for developing different applications.
  • Ability to work under stringent deadlines with teams as well as independent

TECHNICAL SKILLS:

OS: Windows NT/2000/XP/ 2003/2008/2012 R2, HP-Unix, Mainframe

BI & ETL Tools: IBM Cognos Analytics 11.5, IBM Cognos Analytics 11.4,Cognos 10.1, Cognos 10.2, Business Objects 4.0, Cognos 8 series (8.1-8.4), Cognos ReportNet 1.1, Cognos TM1, PowerPlay Studio, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio, Framework Manager, Cognos Impromptu and Impromptu Web, Cognos PowerPlay and PowerPlay Web, Cognos PowerPlay Server, Cognos Transformer (Multi-Dimensional OLAP Cube Design and Implementation/Distribution, Automation and Tuning), Informatica, DataStage, Business Objects, IIS (Config for Web Reporting)

Languages: SQL, PL/SQL, HTML, DHTML, VB

Reporting: Microsoft SQL Server, Oracle 8i/9i/10gx, Sybase, DB2 7.1/8.1, Teradata, Concur XMS T&E System, Computron (FOCUS, etc.), SAP/SAP Financials/SAP Business Warehouse, Oracle Financials, PeopleSoft, MS Access

Data Modeling: ERwin, Star-Schema and Snowflake-Schema Modeling

Scheduling Tools: SQL*Plus, SQL*Loader, SQL Assistant, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, NY

BI Cognos Consultant

  • Responsible in the setup of IBM Cognos Security. Setup of User Groups, Roles, ETC
  • Load Balanced the IBM Cognos BI Multi server environment for performance issues
  • Set up the new Cloud IBM COGNOS 11.11 environment with IBM
  • Resolved Cloud Connectivity issues with IBM (VPN Tunnel, AD Authenticaiton, SFTP setup)
  • Installed and Configured Cloud Frame Work Manager.
  • Migrated framework packages from CQM to DQM, fixed the migration issues, and published to cloud
  • Resolved and supported Premise and Cloud admin and report issues on all existing and Legacy Cognos applications..
  • Researched in house and vendor delivered technical references to help locate solutions for a variety of reporting related bugs. .
  • Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports
  • Tested the reports with various testing methodologies like Report Functionality testing, Admin Functional testing, Application/Report User behavior tests
  • Partner with the DBA, Systems, Networking, and Middleware teams, Data Architecture, Business Intelligence team to facilitate issue resolution.

Confidential, TX

BI Cognos Consultant

  • Installed, configured and supported IBM Cognos 11.5 Cognos Analytics
  • Responsible for the setup of IBM Cognos Security. Setup of User Groups, Roles, etc.
  • Load Balanced the IBM Cognos Bi Multi server environment for performance issues
  • Investigated and resolve issues with system, reports, and log errors
  • Implement auditing and usage monitoring of production Cognos application
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning
  • Worked on Report Studio and work space advanced to develop Multi-Dimensional reporting.
  • Developed cubes using Transformer
  • Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the report

Confidential, Nashville, TN

BI Lead

  • Installed, configured and migrated Reports, dashboards and Cubes from Cognos 10.2 to IBM Cognos Analytics 11.5
  • Responsible for all server monitoring maintenance, upgrades, configuration, and performance tuning
  • Responsible in the setup of IBM Cognos Security. Setup of User Groups, Roles, etc.
  • Load Balanced the IBM Cognos BI Multi server environment for performance issues
  • Developed CUBES Using Transformer
  • Worked on Report Studio and work space advanced to develop Multi-Dimensional reporting.
  • Designed and built new TM1 enhancements for the existing TM1 model. Also maintained data management and relationship with ERP system
  • Process improvements of the existing TM1 model and maintain an automated process to update dimensions within models (daily meta-data and weekly hierarchy updates). ;
  • Troubleshoot and research issues in TM1 application landscape. Support end-users with TM1 Perspectives. ;
  • Setup the Cognos TM1 Security for new users and helped the finance stakeholders to set up new users or modify existing user access in the TM1 Model.
  • Followed Change Management Process and Procedures to perform production migrations from Test
  • Researched in house and vendor delivered technical references to help locate solutions for a variety of reporting related bugs.
  • Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports
  • Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT
  • Partner with the DBA, Systems, Networking, and Middleware teams, Data Architecture, Business Intelligence team to facilitate issue resolution.
  • Delivered the assigned work within the time set by department

Confidential, Seattle, WA

BI Cognos Consultant

  • Installed, configured and upgraded beta reports from Cognos 10.2 to IBM 11.4 Cognos Analytics
  • Installed, configured, managed and supported IBM Cognos 10.2 BI and TM1
  • Monitored the server Activities of Cognos TM1 and BI
  • Managed and administered TM1 and BI datasources, users and roles.
  • Troubleshoot and research issues in TM1 application landscape. Support end-users with TM1 Perspectives. ;
  • Setup the Cognos TM1 Security for new users and helped the finance stakeholders to set up new users or modify existing user access in the TM1 Model
  • Installed, Configured and developed IBM Cognos 10.2 Dynamic Cubes
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning
  • Extensively worked on Motioto Deploy version content, scheduling, Promotion to Multiple Cognos environments and Traceability & Reporting on all Cognos Changes
  • Developed and automated Multidimensional models in Cognos transformer
  • Extensively worked on Analysis Studio to develop Multi-Dimensional reporting.
  • Followed Change Management Process and Procedures to perform production migrations from Test
  • Researched in - house and vendor delivered technical references to help locate solutions for a variety of Admin, BI and TM1 related bugs.
  • Closely worked with data warehouse designers to refine data and metadata.
  • Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.
  • Logged cases when needed with IBM Cognos for issues that have been identified in the environment and worked with the support center to resolve these issues.
  • Provided on-call services and treated on-call duties with a sense of urgency. Escalated to management as needed.
  • Provided clear and concise root cause and remediation descriptions using business language in all documentation.
  • Worked closely with IBM/Cognos on troubleshooting and analysis of environmental and reporting issues. Escalated to second level of support as needed.
  • Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports
  • Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT
  • Delivered the assigned work within the time set by department

Confidential, Fort Worth, TX

BI Cognos Lead consultant

  • Installed, configured IBM Cognos 10.2 Cube Designer and Query Analyzer
  • Developed and administered the Dynamic cubes; created OLAP style reports from Dynamic Cubes
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning
  • Created and developed dynamic cubes in cube Designer upon requests from business Users
  • Designed Cognos Framework manager Model from the Data Marts.
  • Implementation of Data Level, Object Level and Package Level Security in Framework Manager Model.
  • Writing of stored procedure in Oracle PL/SQL to import and use that as
  • Query Subjects in Framework Manager Model to fulfill specific purpose.
  • Creation of Model Query Subjects Embedded and Model Filters.
  • Developed FM Model against STAR, SNOWFLAKE and Fact Constellation data Models.
  • Tested the cubes and OLAP reports with various testing methodologies like Functional testing, Regression testing and UAT.
  • Followed Change Management Process and Procedures to perform production migrations from Test to production

Confidential, Fort Worth, TX

BI Cognos Lead Consultant

  • Installed, configured and supported IBM Cognos 10.1; DEV, QA, UAT and PROD
  • Migrated the reports from Cognos 8.4 to Cognos 10.1
  • Responsible in the setup of IBM Cognos Security. Setup of User Groups, Roles, etc.
  • Load Balanced the IBM Cognos Bi Multi server environment for performance issues
  • Installed Configured Business Objects 4.0; DEV, QA, UAT and PROD
  • Migrated the Business objects reports from Dev to QA and then to Prod
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning
  • Responsible for maintaining User and Group permissions across servers and dashboards for tableau.
  • Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making
  • Migrated cubes and reports from old versions to Cognos 10 series
  • Extensively worked on Motio tool to Deploy version content, scheduling, Promotion to Multiple Cognos environments and Traceability & Reporting on all Cognos Changes
  • Created Ad-hoc reports using Query Studio
  • Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio
  • Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports
  • Followed Change Management Process and Procedures to perform production migrations from Test
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning
  • Coordinated Onsite and Offshore resources
  • Logged cases when needed with IBM Cognos for issues that have been identified in the environment and worked with the support center resolve these issues.
  • Provided on-call services and treated on-call duties with a sense of urgency. Escalated to management as needed.
  • Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.
  • Work with Vendor to rapidly resolve report issues or new incidents
  • Diagnose system problems, trends, and determined necessary corrective action
  • Delivered the assigned work within the time line set by Various Departments
  • Progressive experience implementing and supporting enterprise systems on Windows server operating systems in a production environment that includes
  • Installation and maintenance
  • Capacity planning and disaster recovery
  • Performance tuning
  • Enterprise security concepts, e.g., zoned network, and
  • An understanding of client/server network architectures (e.g., general TCP/IP, HTTP/S, DNS).

Confidential, Raritan, NJ

Cognos Architect

  • Designed, Installed, configured and Managed Cognos 10.1 and TM1 for four different sectors (Consumer, Corporate, Pharmaceutical and Medical Diagnostics Division)
  • Responsible in the setup of Cognos Security. Setup of User Groups, Roles, etc.
  • Load balanced the Cognos 10 Bi Multi server environment for performance issues
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning.
  • Migrated all the cubes and reports from old versions
  • Created Ad-hoc reports using Query Studio
  • Created and developed new reports in Report Studio upon requests from business users
  • Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio
  • Researched in house and vendor delivered technical references to help locate solutions for a variety of reporting related bugs.
  • Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.
  • Followed Change Management Process and Procedures to perform production migrations from Test
  • Coordinated Onsite and Offshore resources
  • Closely worked with data warehouse designers to refine data and metadata.
  • Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.
  • Logged cases when needed with IBM Cognos for issues that have been identified in the environment and worked with the support center resolve these issues.
  • Provided on-call services and treated on-call duties with a sense of urgency. Escalated to management as needed.
  • Provided clear and concise root cause and remediation descriptions using business language in all documentation.
  • Trained to provide 1st level of support for Cognos development environment for internal and external Cognos development and applications. Worked closely with IBM/Cognos on troubleshooting and analysis of environmental and reporting issues. Escalated to second level of support as needed.
  • Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports
  • Modified and developed the queries used in the Ad Hoc environment used to access data from Oracle
  • Delivered the assigned work within the time line set by the Opcos

Confidential, Austin, TX

Cognos infrastructure Lead

  • Designed, Installed, configured IBM Cognos 8.4 and Cognos Beta 10.1
  • Installed, configured and supported Active directory
  • Responsible in the setup of Cognos Security. Setup of User Groups, Roles, etc.
  • Load balanced the Cognos 10 Bi Multi server environment for performance issues
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning.
  • Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.
  • Researched in house and vendor delivered technical references to help locate solutions for a variety of reporting related bugs.
  • Migrated all the cubes and reports from old versions
  • Created Score Cards , Dashboards and Key Performance Indicators for decision support using Metric Studi0
  • Followed Change Management Process and Procedures to perform production migrations from Test
  • Extensively worked on Motio Tool for migrating the reports
  • Created and developed the reports in Report Studio (8.4) upon requests from business users
  • Created reports using List, Cross tab, and Chart templates in Report Studio.
  • Developed standard reports, Charts, Drill-through Reports and Master Detail Reports
  • Created query prompts, calculations, conditions and Filters.
  • Created Bursting Reports and Multilingual Reports bases Using Report Studio.
  • Used Event studio to create agents and monitored performance of key business factors
  • Used Analysis studio to drill down on cubes and perform business analysis
  • Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.

Confidential, Temple, TX

Cognos BI Consultant

  • Created and developed the reports in Report Studio (8.1) upon requests from business users
  • Created reports using List, Cross tab, and Chart templates in Report Studio.
  • Developed standard reports, Charts, Drill-through Reports and Master Detail Reports
  • Created query prompts, calculations, conditions and Filters.
  • Created Bursting Reports and Multilingual Reports bases Using Report Studio.
  • Used Event studio to create agents and monitored performance of key business factors
  • Used Analysis studio to drill down on cubes and perform business analysis

Confidential, San Diego, CA

Cognos Infrastructure Engineer Team Lead

  • Designed, Installed, configured most of all Cognos versions (Cognos 7.1 - 8.4 IBM)
  • Migrated all the cubes and reports from old versions (7.4, ReportNet MR3, 8.3) to Cognos 8.4 IBM
  • Installed, configured and Supported LDAP, Access Manager
  • Responsible in the setup of Cognos Security. Setup of User Groups, Roles, Etc.
  • Load balanced the Cognos 8.4 Bi Multi server environment for performance issues
  • Built models containing query subjects, query items, and namespaces from imported metadata.
  • Created Ad-hoc reports using Query Studio.
  • Created and developed new reports in Report Studio upon requests from business users
  • Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
  • Migrated cubes and reports to Cognos 8.4 from old versions.
  • Installed, configured and supported power play enterprise server
  • Worked on performance tuning of all the Cognos Cubes such as decreasing time in build times and published them to enterprise Server
  • Used Framework Manager to build models, packages and publish packages to Cognos connection.
  • Used Cognos Connection to administer and scheduling reports to run at various intervals
  • Closely worked with data warehouse designers to refine data and metadata.
  • Performance tuning of the reports which are on demand reports.
  • Migrated the reports from dev, test and prod
  • Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning.
  • Followed Change Management Process and Procedures to perform production migrations from Test
  • Proactively managed multiple environments to ensure high availability, high performance, and minimization of risk.
  • Researched in house and vendor delivered technical references to help locate solutions for a variety of reporting related bugs.
  • Logged cases when needed with IBM Cognos for issues that have been identified in the environment and worked with the support center resolve these issues.
  • Provided on-call services and treated on-call duties with a sense of urgency. Escalated to management as needed.
  • Provided clear and concise root cause and remediation descriptions using business language in all documentation.
  • Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports
  • Modified and developed the queries used in the Ad Hoc environment used to access data from Oracle
  • Delivered the assigned work within the time line set by the client.
  • Implemented, tested, and documented an upgrade process from an existing Cognos Series 7.1 and 7.4 applications to ReportNet MR3 and then to Series 8 architecture.
  • 24/7 On call for Cognos & weekly once for Data Warehouse
  • Responding to alerts or emergency issues during all times. Work with Vendor to rapidly resolve report issues or new incidents
  • Diagnose system problems, trends, and determined necessary corrective action
  • Progressive experience implementing and supporting enterprise systems on Windows server operating systems in a production environment that includes
  • Installation and maintenance
  • Capacity planning and disaster recovery
  • Performance tuning
  • Enterprise security concepts, e.g., zoned network, and
  • An understanding of client/server network architectures (e.g., general TCP/IP, HTTP/S, DNS).
  • System Administrator supporting server hardware and software in an enterprise environment (e.g., n-tier systems, multi-server, multi-site, clustered, load balanced), in production.
  • Other technologies:
  • BEA WebLogic 8.1
  • VMware, Virtual Center
  • TOAD/SQL Plus for Oracle Account Provisioning

Confidential, CA

Cognos Consultant

  • Designed, Installed, configured and Managed the deployment of Cognos 8 Business Intelligence (version: 8.1) in development, Test and Production
  • Upgraded Cognos versions from Series 7.4 and ReportNet MR3 to Cognos 8.1 BI
  • Responsible for all server maintenance, upgrades, configuration, and performance tuning
  • Used Cognos Connection to administer and scheduling reports to run at various intervals
  • Installed, configured and managed LDAP
  • Set security for individual reports in Cognos Connection.
  • Installed, configured and published cubes and reports through power play enterprise server
  • Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications
  • Interaction with the Management and Development teams for Requirement gathering.
  • Developed new reports in Report Studio upon requests from business users
  • Created Dashboards for a better understanding of the business performance metrics
  • Used Event studio to create agents and monitored performance of key business factors
  • Used Analysis studio to drill down on cubes and perform business analysis
  • Expert in Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio
  • Creating the Framework Packages.
  • Worked extensively on creating Models and publishing the packages on Cognos Connection for reporting purposes.
  • Created the cubes with help of Framework Manager to change the Source Hierarchy.
  • Created filters within the Model for improving performance of the Model.
  • Involved in Designing and Created various Projects in Framework Manager
  • Involved in Designing Models using framework Manager
  • Create various packages using frame work manager in ReportNet
  • Involved in Migrating catalogs into report net using migration utility
  • Created Multi Lingual packages for various Geographic Locations
  • Used Cognos Connection to administer and scheduling reports to run at various intervals as well as the ReportNet Server.
  • Set security for individual reports in Cognos Connection.
  • Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
  • Bursting Reports and Multilingual Reports Using Report Studio.
  • Created list reports, cross tab reports, chart reports and reports with lot of conditional formatting using Report Studio.
  • Created Query Prompts, calculations, Conditions & Filters, Prompt Pages using Report Studio.
  • Created various prompts like value prompt, search prompt, and date etc.
  • Trained power users to use Query Studio for Ad-hoc reporting
  • Involved in migrating Impromptu reports to ReportNet.
  • Involved in the analysis, design, develop, testing of analytical & transactional reporting systems and user training.
  • Involved in setting up Groups/Roles to secure the Models and packages
  • Created standard and Ad hoc reports using Cognos Impromptu
  • Create various packages using frame work manager in ReportNet
  • Involved in Migrating catalogs into report net using migration utility
  • Involved in setting up Groups/Roles to secure the Models and packages
  • Designed catalogs and defined User Classes, Security and Privileges
  • Created Lists, Groups and Cross-tab reports with Drill-through functionality.
  • Developed various mappings using Informatica Mapping Designer like Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

Hire Now