Home   Register   Sign In
 
Company Info
Conquest Tech Solutions, Inc.


Willimgton, DE, United States

Phone: 302-356-1423
Web Site: www.conq-tech.com

Company Profile


Peoplefluent : Req Programmer 4 - SSRS for Harrisburg, PA


col-narrow-left   

Job ID:

9706

Location:

Harrisburg, PA, United States 

Category:

Information-Technology

Salary:

per hour
col-narrow-right   

Job Views:

165

Zip Code:

19806

Employment Type:

Full time

Posted:

03.12.2015
col-wide   

Job Description:

Short Description:
Contractor will work with Bureau of Information Technology staff, and Identified program area personnel, to convert existing authorization and facility based document templates to a new platform.
 
Complete Description:
 
DEP is in the process of re-writing its Electronic Discharge Monitoring Report (eDMR), and the National Pollutant Discharge Elimination System Management System (NMS). The eDMR system is currently used to enter monthly, quarterly, semiannual, or annual DMRs as specified by permits issued by PA DEP. The NMS system is currently used by DEP staff to manage the monitoring and reporting requirements on DMRs, as well as managing/generating permit documents and other informational reports.
 
Both of these systems are in the process of being re-written as the Water Management System (WMS). As a result of the new system, various reports and the previous authorization and facility based documents will need to be updated to retrieve data elements from the new data source. New document generation techniques will be utilized to create the new templates; SSRS will be used to create the new reports.
 
Contractor will work with Bureau of Information Technology staff, and Identified program area personnel, to convert existing authorization and facility based document templates to a new platform. The new Document Generator is based on the Open XML standard format, and utilizes Microsoft Word content controls.
 
The data source for the document generation process will be an xml file. The content controls in the document template will contain an xpath statement which points to the xml file, and retrieve a piece of data, evaluate a condition, or select a set of elements to repeat.
 
After successfully converting the old documents, the contractor will transition to developing queries for new internal and external SSRS reports for the Water Management System (WMS) Project. This will be accomplished by reviewing existing reports that are to be consolidated and re-written against the new data structures in the Oracle Database Management System.
 
 
 
Skills                                                                                                                                                   Experience
SQL Developer                                                                                                                                          ??
 
SQL *Plus                                                                                                                                                  ?? 1Years
SQL Server Management Studio 1Years
 
Microsoft Word                                                                                                                                          ?? 5Years
Ability to develop data extraction routines between Oracle and SQL Server Environments                        ??                                                                   
 
SQL Server Reporting Services (SSRS) software                                                                                         ?? 1Years
XML                                                                                                                                                           ??   
 
TOAD                                                                                                                                                          ??          
 


© 2017 Powered by Rootjobs     About Us   Sitemap   Terms and Conditions   Privacy Policy   Mobile Version     Twitter RSS LinkedIn Facebook