Job Seekers, Please send resumes to resumes@hireitpeople.comShort Description: Crystal Reports Developer
***Local candidates STRONGLY preferred***
Complete Description: Virginia State Police is seeking highly experienced Crystal Reports Developer with excellent knowledge of Crystal Reports Design/Development and Strong Oracle/SQL background.
***Applicant must be eligible for hire in the U.S. without visa sponsorship.***
***This is a contract position and the consultant will be eligible to apply for a full time employment if/when an FTE position is advertised.***
- Gather requirements for developing reports, analyze new/existing report requirements. Develop quality reports to meet user requirements.
- Review existing reports built in COBOL or Crystal Report environments. Quickly understand the domain and underlying data structure to develop the new reports.
- Understand the design aspects of Crystal Reports with a working knowledge of Oracle.
- Develop Complex Crystal Reports using Sub reports, Parameters/Prompts, Formulas, Report Alerts, OLAP grids objects, Cross-Tab objects, OLE objects, Charts/Maps, Running Totals, Linking tables
- Automate scheduling of reports on a daily/weekly/monthly basis to deliver reports by email to target audience.
- Monitors report execution to determine if reports are still being used or if the run time of the reports is becoming too long and needs optimization
- Performs extensive testing of reports before handing off to users.
- Thorough understanding of relational databases, query optimization, performance tuning, process automation
- Able to manage their own individual projects efficiently and to schedule with little oversight.
- Experience using source control software, deploying reports, and using defect tracking tool such as BugZilla to manage defects.
- Production support experience in multiple QA and Prod environments.
- Good working knowledge of authentication and access control using Active Directory
- Good understanding of SDLC framework
Skill | Required / Desired | Amount | of Experience |
Crystal reports design and development (SAP Crystal 2008 or higher versions) | Required | 8 | Years |
Oracle database (Oracle 11g) | Required | 8 | Years |
building SQL queries, including creating sub-queries, minus/union, and inline queries and performance tuning of SQL | Required | 8 | Years |
Data mapping experience in implementation and design | Required | 6 | Years |
Crystal Reports / BO XI administration experience desirable. | Desired | 3 | Years |
Knowledge of crystal report server configuration desirable, including performance tuning and capacity planning | Desired | 3 | Years |
Knowledge of Crystal Reports / BO architecture and security desirable. | Desired | 3 | Years |
COBOL development experience | Desired | 3 | Years |
