SUMMARY

• IBM Cognos system administrator and Developer with over 8 years of experience in architecture and installation of multi - server distributed cognos environments on different operating systems.
• Having 8 years of experience in Administration and configuration of IBM Cognos application servers, content managers, gateways in Linux, Unix, and Windows environment.
• Over 8 years of experience in managing and supporting the cognos production environments with trouble shooting and problem-solving skills.
• Experience in Performance Tuning and optimizing of the reporting solution
• Experience as cognos developer over 5 years and worked on designing data modelling solutions and complex reports.

TECHNICAL SKILLS

Cognos: 11.1.x, 11.0.x and 10.2.x (Report authoring, Dashboards, Data modules, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace), Tableau 9.1, Motio CI 3.2.X and Motio Report Card.

Modeling Tools: Cognos Cube Designer and Cognos Framework Manger

ETL Tools: Informatica. Analytical/Predictive Tools IBM SPSS 16.0

Languages: SQL, PL/SQL, HTML, XML, MDX, Java script.

RDBMS: Oracle 19c/18c/12c/11g/ MS Excel, DB2, and SQL Server 2017&2012, Horton works Hadoop 3.1&2.6, Toad.

Authentication Providers: AD, LDAP, OKTA

Operating Systems: RHEL Linux 8.x, 7.x, 6.x, 5.x AIX 7.2, Windows Server 2016,2012,2008.

PROFESSIONAL EXPERIENCE

Confidential

Cognos Analytics Administrator

Responsibilities:

• Involved in the cognos architecture design and sizing recommendations based on the input from users.
• Installed and configured sandbox, dev, test, QA, and Production environments
• Upgraded the 10.2.2 cognos dev environment to Cognos analytics 11.0.1.
• Installed, configured, and administered various Cognos components such as the, Framework Manager and Transformer, Cube designer on both Linux and windows operating system.
• Installed and configured CAFÉ (Cognos Analysis for Excel) and IBM Cognos for MS office and packaged in AEP’s Application Publishing Systems (APS)
• Gave the demo to users/new developers on Cognos CAFÉ, cognos report authoring, cognos new dashboarding tool, event studio etc...
• Performed various upgrades of all 5 cognos environments to CA 11.0.3, 11.0.5, 11.0.6 and 11.0.9, 11.1.1, 11.1.5 and 11.1.7.
• Configured all the environments with AEP’s open LDAP authentication
• Set up the SSL for LDAP authentication
• Configured all the cognos gateways to use SSL as part of the Cyber security standards.
• Set up the Single Sign on (SSO) for both QA and Prod environments to enhance the user experience.
• Set up the external file location (Windows shared file server) on cognos configuration to save the report output files
• Worked on Integration of Cognos 10.2.1 and Maximo 7.6.0.9 to publish the content to Cognos from Maximo and to launch the cognos reports from Maximo application.
• Install and configure Motio CI 3.2.2 application for version controlling and automated testing of cognos reports
• Install the Motio active versioning plugins on all cognos environments to make use its version controlling capabilities
• Installed and Configured Dynamic Query analyzer to understand the cognos logs related to query service issues.
• Monitoring the health of servers and system performance in regular intervals to ensure the availability of servers and to improve its performance.
• Setup the automated scripts for restarting the servers every week
• Set up the scheduled backups of cognos content stores on all environments and automated those backups to save it in a shared location.
• Scale the environment to utilize maximum resources during the peak period. It includes the report processor settings and JVM heap size settings for query service.
• Use the Cognos Import and export functionality for content migration between environments and content store backup.
• Set up the printers in cognos environment by deploying them in Linux servers.
• Defined the file system locations for different projects to save their report outputs in an accessible windows shared location.
• Defined and setup the advanced routing in cognos analytics to load balance the resources between application servers
• Use the content maintenance task to check the consistency of the different components of cognos server and to upgrade the reports.
• Set up the scheduling of reports by creating jobs and monitor those jobs regularly
• Set up the trigger-based scheduling using the trigger file generated from Informatica server after the ETL job finishes in Autosys box.

Environment: IBM Cognos Analytics 11.1.x, 11.0.x, 10.2.x (Report authoring, Dashboards, Data modules, Datasets, Framework manager), Motio CI, Motio Report Card, Oracle 18c, 12c, 11g, DB2, SQL, PL/SQL, Toad, Horton Works Hadoop 3.1 and 2.6, RHEL Linux, 8.2 7.5, 7.2, AIX 7.2, Windows Server 2016, GitHub, Jenkins, and MS Excel.

Confidential

Cognos Administrator/ Developer

Responsibilities:

• Installation and configuration of all the suites of Cognos Bl products and setting up Content store database, Active directory configuration, and Mail exchange server.
• Worked with the business users in identifying and defining the product requirements and directions
• Setting up the Cognos BI environment to Client locations by Installing and configuring all the Cognos Bl Components, Query Studio, Report Studio, Analysis Studio.
• Involved in LDAP to Active Directory migration
• Upgraded Cognos from 10.2 FPS to 11.0.1
• Setting up of the backups of all environments with backup and restoring of Content Store Databases, backups of Cognos Configurations, Deployment of Public Folders.
• Installed all the components of Cognos suite of products in all environments with Application and Gateway on a single server and Content Manager in another server
• Setting up the Content store by creating content databases in DB2.
• Set up Audit tables, Audit Report in Cognos Environment to analyze the Report Usage.
• Involved in gathering Business Requirements and prepared the requirements specification document.
• Involved in regularly meeting with the data warehousing team on discussing about the changes in the schemas and Setup Security using Access Manager Administration.
• Used Cognos 8l Framework Manager in building the dimensional/relational Models using different data sources like DB2.
• Extensively worked on performance tuning for existing reports in Report Studio and Testing and improving Report Performance and performing Query optimization.

Environment: IBM Cognos Analytics 10.2.x and 11.0.x (Report Studio, Analysis Studio, Query Studio, Workspace and Framework manager), Oracle 11g, RHEL Linux 5.x, Windows Server 2008, 2012, MS Excel.