Previous Job
IT Developer (Crystal Reports)
Ref No.: 17-00688
Location: San Francisco, California
Start Date: 04/24/2017
IT Developer (Crystal Reports)
Duration: 1 to 3 year contract

IT Developer (Crystal Reports)
position will report into the Office of Information Technology. The IT Developer (Crystal Reports) will need to enhance, develop, and performance tune Crystal reports (simple to complex) for the CAFM 10 system. TRIRIGA ad-hoc query creation is also required. This developer will use SAP Crystal Reports and BIRT for report development.
The IT Developer (Crystal Reports) will troubleshoot performance issues and uncover the root cause of performance problems within the TRIRIGA system. Performance problems are often due to inefficient SQL/queries or workflow design.
The IT Developer (Crystal Reports) will also need to lead and coordinate database maintenance activities such as running Segment Shrinks and adding Indexes.
The CAFM Staging and Production systems are hosted at the California Courts Technology Center (CCTC). Thus, the IT Developer (Crystal Reports) will need to write implementation instructions for the staff at the CCTC for system changes.
  • Experience (5+ years) with Crystal Reports development
  • Ability to performance tune Crystal Reports to run faster
  • Ability to write SQL Selects, Inserts, Updates, and Deletes
  • Experience identifying the root cause of system performance issues
  • Experience writing Segment Shrinking SQL scripts
  • Experience with adding database table indices using SQL
  • Write technical documentation for the work that you have completed
  • Experience with Business Objects Enterprise administration and support
  • Experience working in a facility management, lease contract administration, and/or real estate administration business group
  • Experience writing reports in BIRT
  • Experience writing ad-hoc queries in TRIRIGA 10
  • Experience developing and supporting Invoice Reports including Time and Materials
  • Experience working with a hosting vendor
Knowledge of Data Warehouses
Develop and enhance Crystal Reports in a TRIRIGA 10 system.
Create and enhance ad-hoc Queries in a TRIRGA 10 system.
Performance tune Crystal Reports and TRIRIGA 10 ad-hoc queries
Identify bottlenecks for system performance in a TRIRIGA 10 system including analyzing AWR reports, application log files, and system utilization statistics.
Write SQL for segment shrinks, new indexes, updating instance data, and selecting data from a TRIRIGA 10 system.
Provide knowledge sharing to IT technical staff in the administration and maintenance of the SAP Crystal Reports, Business Objects Enterprise, and BIRT.
Perform system administration and support of Business Objects Enterprise.
Provide weekly and monthly status reports.