Short Description:
We would like to engage the services of 2 contractors. These contractors will be providing ODI with SSRS report writing services.
Complete Description:
RESPONSIBILITIES
Provide support to Business Analyst(s) in gathering and/or clarifying data and reporting requirements from business owners
Experience designing and developing reports including tabular reports, scorecards and dashboards
Ability to understand business needs and information and translate into a creative reporting solution
Develop reports in accordance with client requirements using Microsoft SQL Server Reporting Services (SSRS) 2008r2
Develop and maintain database stored procedures
Develop SQL queries and support ad hoc requests for data
Identify and troubleshoot business process or data quality issues that show up in the reports and subsequently communicate to resolve and eliminate problems.
Experience writing stored procedures, T-SQL, PL-SQL, functions, and SQL queries
Experience utilizing report writing best practices (optimization, use of joins and sub-queries)
Experience with manual testing to include User Acceptance Testing (UAT)
Ability to use complex expressions to calculate, group, filter, parameterize, optimize and format custom reports
Experience pulling data from ORACLE databases for reports
Experience drill down reports
Qualifications:
3+ years of experience with report development using Microsoft SQL Server Reporting Services (SSRS) 2008r2
3+ years Experience with SSRS Business Intelligence Developer Studio, Visual Studio, SQL Server Integration Services (SSIS), and/or other (non-Microsoft) reporting platforms
1 years Experience with Crystal Enterprise and migrating Crystal Reports to SSRS a plus
Skills:
Skill
Required / Desired
Amount
of Experience
Experience with report development using Microsoft SQL Server Reporting Services (SSRS) 2008r2
Required
3
Years
Experience w/SSRS BI Developer Studio, Visual Studio, SSIS, and/or other (non-Microsoft) reporting platforms
Required
3
Years
Experience with Crystal Enterprise and migrating Crystal Reports to SSRS a plus
Desired
1
Years