Contract SSRS Report Conversion Specialist

Role Overview

• Analyze existing Crystal Reports, including underlying logic, dataset structures, parameters, grouping rules, formatting, and export configurations.
• Identify constraints, risks, assumptions, and technical dependencies that may influence conversion activities.
• Confirm report inventory and provide clarification summaries or follow‑up questions needed before finalizing development tasks.
• Recreate Crystal Reports as functionally equivalent SSRS reports, ensuring consistency across:
• Data logic, joins, and calculations
• Record groupings, summaries, and totals
• Filters, prompts, and parameter behavior
• Layout, formatting, and template structures (as feasible within SSRS capabilities)
• Export formats such as PDF, Excel, and other required outputs
• Deliver reports without redesigning or altering business rules unless explicitly requested through project direction.
• Perform detailed side‑by‑side comparisons of Crystal and SSRS outputs to confirm full functional equivalence.
• Validate record counts, totals, financial or fee‑related calculations, grouping structures, and compliance‑related outputs.
• Document and resolve discrepancies, ensuring all reports meet acceptance criteria before final delivery.
• Prepare clear technical documentation to support long‑term maintenance of SSRS reports by internal staff.
• Conduct knowledge‑transfer sessions or walkthroughs as needed for technical and non‑technical team members.
• Coordinate with IT staff to deploy completed SSRS reports into the designated reporting environment.

Requirements

• Proven experience converting Crystal Reports to SSRS in enterprise, public sector, or complex multi‑system environments.
• Strong SQL skills, including query optimization, stored procedures, joins, and parameterized datasets.
• Hands‑on experience developing paginated reports in Microsoft SSRS.
• Ability to interpret and accurately re‑create complex reporting logic.
• High attention to detail with experience in data validation, regression testing, and quality assurance.
• Experience with permitting, licensing, regulatory, financial, or compliance‑driven reporting environments.
• Familiarity with municipal, state, or governmental reporting structures (or comparable regulated domains).
• Experience working with enterprise permitting and licensing systems or similar operational platforms.
• Deliver complete and accurate report conversions, including validation and documentation.
• Maintain consistent communication with stakeholders and provide timely status updates.
• Uphold security, confidentiality, and compliance best practices.
• Produce high‑quality work within a structured project governance and quality‑control framework.

Tech Stack

• SQL