Position Title : Crystal Reports to SSRS Report Write
Location : Kansas City, MO
Duration : 06 months Contract on W2 (Possible extension)
Position Description :
- The Crystal Reports to SSRS Report Writer is responsible for developing, maintaining, and migrating reports between Crystal Reports and SSRS platforms.
- This role requires expertise in both reporting tools, strong SQL skills, and the ability to collaborate with stakeholders to understand and fulfill reporting needs.
- This role focuses on the design, development, and migration of reports using both Crystal Reports and SQL Server Reporting Services (SSRS). Key
Responsibilities :
Report Development : Design, develop, and modify reports using Crystal Reports and SQL Server Reporting Services (SSRS), adhering to existing standards and documentation.Report Migration : Plan and execute the migration of Crystal Reports to SSRS, which may involve analyzing existing reports, recreating datasets and data sources in SSRS, and building the report layouts.SQL Development : Write and optimize SQL queries, stored procedures, and functions to extract and manipulate data for reporting purposes.Report Optimization : Identify opportunities to enhance report performance and efficiency, potentially by analyzing data, optimizing queries, and leveraging features within both tools.Testing and Quality Assurance : Perform testing of developed reports to ensure accuracy, data integrity, and compliance with specifications and the established branding guidelines for the Missouri.Troubleshooting and Support : Troubleshoot and resolve issues related to existing reports and report delivery.Documentation : Maintain documentation related to report structures, data sources, processes, and any modifications or changes.Technical Skills :
Crystal Reports : Expertise in developing reports, including creating complex reports, utilizing data structures, and applying reporting principles.SSRS : Strong knowledge and experience with SSRS, including creating reports, charts, and graphs.SQL : Proficiency in writing complex SQL queries, stored procedures, and functions; experience with query optimization is beneficial.Database Knowledge : Strong understanding of relational database concepts, design, and data modeling.Data Analysis : Strong analytical skills for interpreting data and translating business needs into effective reports.Soft Skills :
Communication : Excellent verbal and written communication skills for collaborating with stakeholders and documenting report details.Problem-Solving : Ability to identify and resolve issues related to data and report development.Attention to Detail : Meticulous attention to detail to ensure accuracy and data integrity in reports.Teamwork and Collaboration : Ability to work effectively within a team environment and collaborate with others.Experience Required :
Proven work experience (typically 2-5 years or more) in report development, with significant experience in both Crystal Reports and SSRS.Education Required :
Bachelor's degree in computer science, Information Systems, or a related field, or equivalent work experience.Additional Information :
We are in the process of converting 375 of our Crystal report to SSRS reports. on site work only