Crystal Reports Developer (20 hrs/week Part-Time)
Sligo Software Solutions Inc. · Albany, NY · 1 mo ago
Information TechnologyPart-time
About the role
The Laboratory Information Management System (LIMS) is used by State Police forensic labs for tracking of all forensic evidence including Toxicology. The design of toxicology functions in LIMS requires upgrades and improvements such as more effective case flow, statistical and epidemiologic reporting and replacement of other toxicology reports.
Responsibilities
- Participate in conducting analysis interviews with users to understand what currently exists and what is needed.
- Gather and document functional and technical requirements as well as create mock reports to be reviewed by the business.
- Develop complex Crystal Reports based on Oracle data.
- Develop and update test cases/scripts and perform system testing.
- Create a User Acceptance Test plan and coordinate User Acceptance testing.
- Provide knowledge transfer to state staff in order to implement and support technical solutions.
- Collaborate with Information Technology Services staff, Forensic lab staff and the LIMS vendor.
- Participate in status review meetings and provide monthly reports.
- Work with end users to review/analyze existing systems, reports and documentation.
- Participate in business user and stakeholder meetings for requirement gathering sessions, including but not limited to the Forensic Investigation Center, Division of Criminal Justice Services, State Police, and several areas within the Office of Information Technology Services (security, networking, workstation, architecture and database).
- Develop, write, and maintain a comprehensive requirements document and assist with use case development when required, with all documents done according to ITS standards.
- Analyze, design, develop and document technical solutions utilizing Crystal Reports and Oracle/SQL queries, including but not limited to creating report designs, data mapping documents and configuration changes.
- Participate in the development and updating of Test cases/scripts, execute tests and record results, including recording and tracking of defects.
- Interact with ITS staff, Forensic Lab staff and the LIMS vendor as necessary to determine and implement functional and technical requirements.
- Work closely with the project manager and functional manager to ensure timely deliverables.
Requirements
- 10+ years of experience creating computer software, specializing in one area of computer software or writing code for many kinds of software.
- 100% Onsite.
- 60 months Crystal Reports development experience based on complex queries (using multiple data sources and defining relationships between different pieces of data) and results.
- 60 months experience supporting user applications and working with clients to identify system issues and improvements for functionality.
- 24 months experience working with a Lab Information Management System.
- 60 months experience in obtaining and writing business, user and functional requirements, use cases, creating mock reports and workflows.
- 60 months experience working with an Oracle Relational Databases.
- 60 months system design experience.
- 24 Months experience using Test Management tools such as ALM/Quality Center.
- Bachelor's Degree in Information Technology, Natural Sciences, or related field.