Crystal Report Developer

SSRS / Crystal Reports Migration Developer

Job Overview

We are looking for an experienced SSRS Developer / Reporting Developer to work on a large-scale reporting migration project involving the conversion of existing Crystal Reports 2008 reports to SQL Server Reporting Services (SSRS) 2019 .

The project involves migrating approximately 211 existing reports , with potential consolidation of selected reports, and integrating the converted reports into an existing ASP-based application running on Windows Server 2019 .

Key Responsibilities

• Convert existing Crystal Reports 2008 (.rpt) to SSRS 2019 while maintaining the existing report functionality, layout, UI and look and feel.
• Work with approximately 211 reports , with up to 77 reports potentially identified for consolidation .
• Develop reusable SSRS components for common report headers and advices, including:
• Client logo
• Address
• SSM/BRN details
• Other common report elements
• Integrate converted SSRS reports with the existing CNS application without developing a new reporting application.
• Provide report links/endpoints that can be called from the existing CNS application.
• Modify existing ASP front-end code to publish and link the converted SSRS reports within the application's report menu.
• Work with existing VB.NET backend and batch programs where required.
• Configure and support SSRS across different environments, including:
• SIT
• UAT
• DR
• Production
• Support configuration of SSRS, MS SQL, IIS and ODBC services within the application environment.
• Prepare technical documentation, including:
• Functional Specification Document (FSD)
• Technical Specification Document (TSD)
• SSRS architecture and flow diagrams
• SSRS environment setup and configuration guide
• Ensure the solution complies with OWASP security standards and successfully passes security scanning requirements such as Veracode.
• Conduct unit testing and prepare SIT test scripts and test results .
• Support SIT, UAT and post-production implementation activities.
• Perform comparison testing between the existing Crystal Reports and newly converted SSRS reports to ensure accuracy and consistency.
• Provide post-implementation support and troubleshooting during the warranty/support period.

Required Technical Skills

• Strong hands-on experience with Microsoft SQL Server Reporting Services (SSRS 2019) .
• Strong experience in Crystal Reports , preferably Crystal Reports 2008 or similar versions.
• Proven experience in Crystal Reports to SSRS migration/conversion projects .
• Strong knowledge of Microsoft SQL Server and SQL queries .
• Experience with ASP / Classic ASP application integration.
• Good knowledge of VB.NET development and integration.
• Experience working with IIS and ODBC configuration.
• Experience integrating SSRS reports with existing enterprise applications.
• Experience with report performance, formatting, parameters, datasets and reusable report components.
• Good understanding of application security and OWASP standards .
• Experience working with Veracode or similar application security scanning tools is preferred.
• Experience working in SIT, UAT, DR and Production environments .

Testing & Deployment

• Perform unit testing for converted reports before SIT deployment.
• Prepare test scripts and documentation for SIT/UAT.
• Support multiple development and production code drops.
• Troubleshoot defects identified during SIT, UAT and post-implementation.
• Validate report output by running Crystal Reports and SSRS reports concurrently and comparing results.
• Support post-production activities and provide warranty support after each deployment.

Documentation

The successful candidate will be responsible for maintaining technical documentation covering:

• Functional specifications
• Technical specifications
• SSRS architecture and report flow
• Environment configuration
• Deployment and setup procedures
• Report migration/conversion details
• Testing and validation results

Project Environment

• Windows Server 2019
• SQL Server / SSRS 2019
• Crystal Reports 2008
• Classic ASP
• VB.NET
• IIS
• ODBC
• Visual Studio Code
• Microsoft SQL Server tools

Important: Development and deployment should use the existing Microsoft technology stack and approved tools. No additional third-party software should be introduced without approval.

Preferred Experience

• Experience in banking, financial services or other highly regulated environments.
• Experience handling large-scale report migration/conversion projects.
• Experience with enterprise application integration and production deployments.
• Strong troubleshooting and analytical skills.
• Ability to work independently and coordinate with application, infrastructure, testing and business teams.

Project Duration

The project is expected to run through September 2027 , with multiple planned development and deployment releases.