Cognos CDM Resource
|Reference # :||17-01160||Title :||Cognos CDM Resource|
|Position Type :||Contract|
|Experience Level :||Start Date / End Date :||11/06/2017 / 12/06/2017|
Must be staffed by a US Citizen and must be able to pass a Criminal Background investigation.
Statement of Work:
The client has a contract with the U. S. Office of Personnel Management (OPM) to develop, maintain, and support their Budget Management System (Client) using Cognos TM1 and Certent Disclosure Manager. The client needs a Certent Disclosure Manager Developer to serve as a consultant to improve the CDM implementation design to be more effective and efficient in obtaining data from TM1 and generating documents with minimal or no manual editing after generation.
Review the current CDM solution developed for OPM and recommend a new design that improves the efficiency of obtaining the data from TM1 with minimal changes required to the TM1 queries with each subsequent version of the documents. Recommend a design that produces the desired fonts and page layout to eliminate rework after the Congressional Budget Justification document is generated. Recommend a design that will prevent document authors from inadvertently changing the style and the layout of the CBJ document and other similar documents. Recommend a methodology for optimize the integration of the Excel tables in the document while maintaining the fonts and producing the desired style.
Provide a written document detailing the recommended design changes to the existing implementation.
Provide a two hour presentation explaining the recommendations.
Required skills/Level of Experience:
OPM Client is looking for a Certent Disclosure Manager (formerly Cognos Disclosure Manager) developer who has expertise in designing MS Word documents using source information queries from Cognos TM1.
- Certent (Cognos) Disclosure Manager Development of MS Word documents with MS Excel embedded tables (5 years)
O Developing and configuring TM1/CDM MS Word documents for CDM generation (1 year)
-Ability to communicate effectively and clearly on CDM design and use topics
-Attention to detail and schedules, ability to estimate tasks realistically and meet schedules
-Experience using CDM with multiple and complex TM1 queries (1 year)
-Experience using CDM with Excel tables populated by TM1 queries (1 year)
-Experience with developing and using Excel pivot tables and formulas for creating tables to embedded in CDM documents (5 years)
Excellent verbal and written communication skills
Excellent customer relationship management skills
Excellent MS Windows OS skills
Nice to have skills:
-Training skills to explain CDM design recommendations and implementation methods.
Job Status: Contract/Temporary