IT Specialist Cognos Reports Writer/Developer Cognos BI Framework Oracle Microsoft SQL Server

Profile

HBITS-04-12477
Under the supervision and guidance of the PMO and Project Manager, the Cognos reporting specialist will work with technical staff, Business Analysts and members of the program/business office to perform the following: Work with business teams to document and prioritize incoming business reporting requirements/requests and respond to periodic report requests and issues from various program offices/projects.
Analyze requirements, seek necessary clarifications, develop/configure, test and deploy Cognos BI model/module, reports and dashboards.
Convert/configure existing EZSpec reports into Cognos reports.
Setting-up and facilitating meetings with the business teams to understand reporting needs (As-Is and To-Be) and pain points.
Create and maintain a periodic reports distribution calendar to monitor and publish appropriate reports for all stakeholders.
Prepares charts, tables and diagrams and develops Key Performance Indicators (KPIs) and performance scorecards
Demonstrate commitment to data quality and integrity by developing appropriate job aids, internal control processes, testing etc. over Cognos BI reporting.
Conduct deep dive sessions with teams with a problem-solver attitude.
Performs historical reports and data mining to provide insights to support improved decision making.
Analytically apply knowledge of design concepts in database management, data warehousing, data modeling, data quality, business reporting and dashboards.
Contribute to developing reporting standards and best practices for different projects.
Collaborate with other teams to prioritize reporting needs
Perform report rules and parameters reviews to ensure high quality and that standards are being met.
Ensure business intelligence training needs are identified and met.
Assist and train team members in developing reports and dashboards and also develop help guides.
Evaluates business/operational needs and make recommendations for enhanced or additional applications of reporting solutions.
Develop complex reports and dashboards including different sets of formulas and calculations, relational and multidimensional data structures and logic.
Uses various database scripting and software programming languages to extract, transform and load data.
Understands different data models like normalized, de-normalized, stars, and snowflake models and can optimize performance by refining data queries and reports.
Enhance visual presentation of current reporting solutions
Ensure production issues and tickets within Cognos environment are resolved in a timely manner.
Manage time effectively and efficiently to work on multiple projects.
Ensure optimum performance and minimal downtime of Cognos supported reports.
Operate in a hybrid (Agile/Waterfall) environment and actively manage reporting requirements, change requests and user assistance needs.
Contribute to design and architecture discussions, daily stand-ups, sprint planning sessions and other meetings.
Become a reporting subject matter expert (SME) and business advisor.
Support QA/Testing by developing timely reporting test plans, writing and executing test cases, done/acceptance criteria, end-user testing and reporting deliverables validation.
Willingness and aptitude to learn new tools and support other data/BI solutions and data analytics efforts of NYSED.
IT Specialist
Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Expert 84 months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. 72 months experience as a Cognos Reports' Writer/Developer, working with multiple cross-functional teams analyzing existing reports, developing future reports and designing/configuring models/modules using Cognos BI Framework Manager and Data Module. This includes design, development and management of multi-dimensional reports, models, dashboards and ETL data structures.
60 months experience in end-to-end Cognos BI (version 11.1.7 and higher) model/module configuration, security, architecture design, administration and maintenance.
84 months experience in database management systems, such as Oracle, Microsoft SQL Server SSRS, SSIS integrations and PL/SQL for creating, updating and deploying reports, packages, and writing/troubleshooting T-SQL statements, creating stored procedures, views, triggers, and SQL functions.
84 months of experience with analytics, API integrations and dashboards delivery using Cognos, EZSpec, Power BI, SSIS, SSAS and SSRS, with ability to work in waterfall, agile and hybrid frameworks.
72 months of experience in all types of reports testing (including functional, regressions, integration, etc.), model/module testing, business process validations reporting needs and data sanity checks. This includes writing and executing test plans, various types of report test cases, report testing procedures & cycles, testing of manual and automated reports, defects tracking, reporting bugs resolution, periodic testing results communication and requirements-based validation/testing for final deliverables sign-off.
60 months experience in supporting cross-functional technology solutions such as Client Agile Business Suite, Cognos BI, MS Power Automate & Power BI, Salesforce, Databridge, Tableau, and Talend.
60 Months experience in delivering Cognos BI training to end-user and IT staff in Cognos Reports Authoring, Dashboard Creation and Data Modules Configuration, and developing user/help guides, toolkits and SOPs.
36 months of reports creation and maintenance experience in Crystal Reports, Talend, Tableau, or similar reporting, data visualization and dashboard analytics tools.
Obtained at least one of the following certifications along with their verifiable certification numbers, where applicable. Submit certification copies; IBM Cognos BI Certification, MS Power BI certification, Any Microsoft SQL server, data visualization, database fundamentals certifications, and Cloud/CRM Reporting certifications such as MS Dynamics, Salesforce, Tableau, etc.
****
Local:
518-218-1700
Map
& visit our office
Corporate - Albany NY
435 New Karner Rd, Ste 202
Albany NY 12205
Chicago
63E Lake Street, Ste 201
Chicago, IL 60601
Florida
17258 SE 121st Ave
Summerfield, FL 34491
© 2018 MVP Consulting Plus. All Rights Reserved.

Company info

Sign Up Now - WritingCrossing.com