Cognos Consultant

Requirements:

84 Months Demonstrated hands-on experience in IBM Cognos BI solution design, administration, installation, server configuration, and technical support including all components of the IBM Cognos Business intelligence suite of tools.

 

84 Months Demonstrated hands-on experience implementing IBM Cognos BI application security using Active Directory (AD), Lightweight Directory Access Protocol (LDAP) ,or Java Based Authentication.84 Months Demonstrated hands-on experience implementing complex data, object, and cube security with the IBM BI Cognos Framework Manager and Transformer tools

 

72 Months Demonstrated hands-on experience in designing, building, and maintaining report solutions using all functions of the IBM Cognos BI 8.4 or higher suite of tools (Report Studio) supporting reports, score-carding, and analysis using relational, dimensional, data marts and transactional databases.

 

72 Months Demonstrated hands-on experience using IBM BI Cognos Framework Manager 8.4 or higher using best practices to model reporting packages. 84 Months Demonstrated hands-on experience using IBM Cognos Transformer 8.3 or higher using best practices to create data cube models against existing data marts. 84 Months Demonstrated hands-on experience Java scripting, writing code (.NET,JAVA, JavaScript) to support Cognos SDK and Web-Service. SQL, Unix ScriptingBachelors Degree in business intelligence, information science, criminal justice, health science, computer science, mathematics, or public/business administration with an analytics or communications background (e.g., math, statistics, quantitative methods coursework).IBM Cognos BI 8 or higher CertificationDescription:This position is required to maintain a complex IBM Cognos reporting infrastructure supporting an operational user base of 7000 end users of which 750 report authors. This infrastructure supports the operational needs of the Office of Temporary and Disability Assistance (OTDA), Office of Children and Family Services (OCFS), Department of Labor (DOL) and an additional 5 State agencies, 58 Social Services Districts (SSD) and 298 Voluntary agencies providing direct services. This project also supports the Commissioners Dashboard for LSSD Commissioners and Executive staff consuming performance and mission critical data from the Welfare Management System (WMS) myBenefits, CONNECTIONS, and the DOH data warehouseThis position will participate in a team approach to:-Install and configure the IBM Cognos Business Intelligence (BI software in a multi-tiered Cognos server environment; Web, App and LDAP Windows servers;-Install and configure IBM Cognos BI Transformer software on Unix Server.- Maintain scripts between the IBM Cognos BI install on Windows and Unix Servers.- Maintenance of the Cognos BI architecture, including troubleshooting and problem resolution.-Contribute to the design and implementation of the metadata and/or reporting components of the solution (building and/or modifying Cognos data structures) to insure implementation of best practices. This includes testing and deployment of the components- Provide troubleshooting and end user support and problem resolution.- Participate in sessions to develop requirements for the reporting projects in Cognos Reporting.- Participate in joint sessions defining security in all levels of the Cognos Reporting environment.- Create scripts for maintaining the Servers, Portal and LDAP, and application support.- Provide technical documentation for the Cognos reporting environment, including but not limited to Server architecture, Cognos Connection configuration settings, and security of all levels of the Cognos deployment- Create and support the Reporting Web Service using Service Oriented Architecture (SOA) principles-Create models using best practices with IBM Cognos BI Framework Manager tools-Create Cubes using IBM Cognos BI Transformer-Create Work Requests with other NYS ITS units to support Cognos Reporting.- Ensure that development activities adhere to the HSC architectural strategy so that overall business intelligence data integrity is maintained.