Job Seekers, Please send resumes to resumes@hireitpeople.com Short 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

SkillRequired / DesiredAmountof ExperienceCrystal reports design and development (SAP Crystal 2008 or higher versions)Required8YearsOracle database (Oracle 11g)Required8Yearsbuilding SQL queries, including creating sub-queries, minus/union, and inline queries and performance tuning of SQLRequired8YearsData mapping experience in implementation and designRequired6YearsCrystal Reports / BO XI administration experience desirable.Desired3YearsKnowledge of crystal report server configuration desirable, including performance tuning and capacity planningDesired3YearsKnowledge of Crystal Reports / BO architecture and security desirable.Desired3YearsCOBOL development experienceDesired3Years