Cognos Developer

+1 571-556-1002 |naresh@sapphiresoftwaresolutions.com Hi Folks Please check below JD and share your updated resume JD Cognos Developer 1 year contract-Only W2 Albany NY This role is on site 2-3 times we week in Albany NY. This is an H1 Friendly role and would be open to the person relocating. We have a Cognos Developer. This role for a government or Health and human services project. The candidate must have experience with leaderships as a developer. The ideally would like someone with IBM Cognos development with relational databases. This person would have at least 7 years of hands-on experience writing SQL for querying reports and data analytics. you know is interested, 1. Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer 1. More than (7) years of experience in analysis, design, development, testing and implementation of business intelligence solutions using PL/SQL & relational databases. 1. Five or more years of hands-on experience with authoring and maintaining of reports using IBM Cognos suite of tools with relational databases. Jo b Description D aily activities will include, but are not limited to: Responsible for the design, development and deployment of multi-dimensional reports using the Cognos Business Intelligence suite of products Provides analysis, design, development, testing and implementation of Business Intelligence, Ad-hoc and Operational Reporting. Maintains and curates a central repository of enterprise Business Intelligence assets including dashboards, visualization and interactive reports. Monitor daily reports that identify data inconsistencies, determine the resolution and revise the incorrect operational data. Enables capabilities available in the Business Intelligence technology such as drill-through functionality, KPI and scorecard reporting, advanced visualizations including mapping and geospatial analysis, predictive analytics, and other capabilities as they arise. Communicate and coordinate with members of the development team to work across multiple projects. Explore, actively support and work on new technology initiatives that may be of interest to the organization. Actively participate in troubleshooting any technical issues that the program may have. Other duties as assigned Ad ditional Skills & Qualifications1. Seven years or more of hands-on experience writing complex SQL for querying and development of reports and data analytics. 2 . Seven years or more of demonstrated hands-on experience with PL/SQL writing packages, stored procedures and triggers. 3 . Five years or more of demonstrated hands-on experience developing data models, data mappings, data migrations and assisting in data warehouse design in Oracle environment for Cognos. 4 . Five years of demonstrated hands-on experience with design & development of Cognos cubes for analytical reporting. 5. Seven years or more experience of Oracle architecture and database design. 6. S e ven years or more experience working with different databases structure for OLTP, OLAP & high-volume transaction systems. 7. Seven years or more experience with data visualization tools like Tableau. 8. Se v en years or more experience with business reporting of IES programs like SNAP, HEAP, MEDICAID, PA, TANF. 9. Two years or more experience with Google Big Query. 10. S e ven years or more experience with Health & Human services applications. Employee Value Proposition (EVP)The oppo rtunity to support the largest state government health care project in NYS history and help create a system that will enhance the lives of millions of New Yorkers.Work Env ironmentWorking on-site in Albany plus 50% remote. 50% remote (5 days remote in a 10 day cycle, so 2 days one week and then 3 days the next), but they have to show up for their first day onsiteBusiness Drivers/Customer ImpactCreate a n Integrated Eligibility System to enhance the well-being of new Yorkers by transforming health and human service delivery through coordinated business practices, modernized technology, and strategic partnerships.