Innovations technological

Job Title : MS SQL Server Developer / SQL Server Programmer

Duration : 3 to 6+ Months

Location : Harrisburg, PA

Direct Client : State of PA/ CWOPA/ Commonwealth of PA

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. 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.

Thanks & Regards,

Nilesh Awadhiya

Sage Group Consulting, Inc.

3400 Highway 35, Suite # 9, Hazlet, NJ 07730

Office: 732-767-0010 X 227

Direct: 732-658-5828

Fax:    732-722-5097

Email : nawadhiya@sagetl.com

Website : www.sageci.com

Skype: nilesh_awadhiya | Gtalk: nilesh.awadhiya  | Yahoo IM: n_awadhiya