SQL Developer

R Systems; Kuala Lumpur; Presencial; MYR 90 000 - 130 000; Tempo integral

Resumo da oferta

R Systems is seeking an SSRS Migration Developer to convert Crystal Reports 2008 reports to SSRS 2019 for a large-scale migration project. You will work on approximately 211 reports, potentially consolidating up to 77, and integrate the results into an existing ASP-based CNS application on Windows Server 2019.

You will collaborate with VB.NET backend and batch programs, configure SSRS across SIT/UAT/DR/Prod, and prepare comprehensive technical documentation while upholding OWASP standards and

Qualificações

• Strong hands-on experience with SSRS 2019.
• Strong experience with Crystal Reports, preferably 2008 or similar.
• Proven Crystal Reports to SSRS migration/conversion projects.
• Solid knowledge of Microsoft SQL Server and SQL queries.
• Experience with ASP / Classic ASP integration.
• Good VB.NET development skills and integration experience.
• Experience configuring IIS and ODBC.
• Experience integrating SSRS with existing enterprise apps.
• Competence in report performance, formatting, parameters and datasets.
• Familiarity with OWASP standards and security scanning tools (Veracode preferred).
• Experience operating in SIT, UAT, DR and Production environments.

Responsabilidades

• Convert Crystal Reports 2008 reports to SSRS 2019 preserving functionality and look.
• Handle about 211 reports, with possible consolidation of up to 77.
• Develop reusable SSRS components for headers and common elements.
• Integrate converted SSRS reports with the CNS application without building a new reporting app.
• Expose report links/endpoints for CNS to call and publish from ASP frontend.
• Work with VB.NET backend and batch programs as required.
• Configure and support SSRS, MS SQL, IIS and ODBC across environments (SIT/UAT/DR/Prod).
• Create technical docs: FSD, TSD, SSRS diagrams, setup guides; ensure OWASP/security compliance.
• Perform unit testing and prepare SIT test scripts; support post-deployment issues.

Conhecimentos

SSRS 2019

Crystal Reports

Crystal Reports migration

SQL Server

ASP Classic

VB.NET

IIS

ODBC

OWASP standards

Veracode

Ferramentas

Veracode

OWASP security tools

MS SQL Server Management Studio

IIS Manager

Descrição da oferta de emprego

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:
• Address
• 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
• Deployment and setup procedures
• Testing and validation results
• Windows Server 2019
• SQL Server / SSRS 2019
• Crystal Reports 2008
• Classic ASP
• VB.NET
• IIS
• ODBC
• 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.