Stafford Gray LLC
Technology Delivered.
Contract SSRS Report Conversion Specialist
Location
Michigan
Posted
8 days ago
Salary
Not specified
Professional CertificateEnglishSQL
Job Description
• 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.
Job 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.
