NEED:-Cognos Developer (DE, 6 Months)

Cognos Developer

Location: Wilmington, DE (Face to Face Required)
Duration:  6+ Months

Job Description:
The applicants' duties are to design and author Cognos 8BI dashboards, reports, charts and queries requested by the ALICO actuarial group for the Federal Stress test project. 
The candidate will work closely with O&S staff, Home office MIS, local Cognos administrator and local database administrators to meet the reporting needs for the Federal Stress test project.
 The candidate MUST have prior experience working/ building reports with DMR (dimensionally modeled relational models).
 As a Cognos Report Author the candidate will also be responsible for the successful Portal user training and mentoring of Cognos power users (Query Studio) and Cognos consumers. 

Essential Duties and Responsibilities: Other duties may be assigned.
• Perform analysis of reporting requirements and convert functional specifications into appropriate technical specifications.
• Create DMR using Framework manager with levels and hierarchies.
• Create complex reports with multiple queries, conditional formatting, multiple filters etc.
• Create multiple detail drill through reports with complex formatting.
• Create analysis reports/graphs using a DMR (Dimensionally modeled relational) package.
• Maintain existing reports and perform modifications as deemed necessary.
• Perform changes to the Dimensional Framework Model based on reporting requirements.
• Create YTD, QTD and MTD reports and provide ability to do QTR/QTR, Year/Year comparisons

Required Technical Skills:
The ideal candidate will possess 3-5 years experience in developing management reports and dashboards using IBM Cognos 8BI 8.3, 8.4 and 10.1 enterprise reporting tools. 
The applicant should also have a basic understanding of OLAP cubes and underlying star schema designs. 
The candidate must have a thorough understanding and knowledge of Framework manager and experience with Microsoft SQL Server T-SQL language and database objects, such as stored procedures and user defined functions. 
Along with the Cognos authoring skills our candidate should also possess 1-3 years of Cognos administration skills and will work along side our seasoned Cognos Architect/Administrator as a back up for this position. 
The candidate should be self motivated and able to work with minimal supervision in what can be a fast moving and pressured environment. 
Multi-tasking skills are essential and a pro-active approach to the role is required.  Good written and oral communication skills are a must as the role deals with all levels of management and staff. 

Regards,
Jagdeep Kumar
(Technical Resource Specialist)
Ramy Infotech
--consulting redefined
39120 # 157 Argonaut Way, Fremont CA 94538
Phone : 408-317-9256 Ext-322
Fax : 408-273-6834
Email : jagdeep.kumar@ramyinfotech.com
URL   : www.ramyinfotech.com
Gtalk : jagdeep.ramy
Yahoo: jagdeep_ramy             

In My Absence, Please Contact Rajat Nanda | Phone: 408-317-9256|Ext: 326|E-mail: - rajat.nanda@ramyinfotech.com         

Disclaimer: The information in this email is confidential and may be legally privileged.  Access to this email by anyone other than the intended addressee is unauthorized.  If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.  If you are not interested in receiving mails from us then please forward this mail with "remove" in the subject to remove@ramyinfotech.com. Sorry for any inconvenience