*Hiring: SQL Server Developer / Harrisburg, PADirect ClientJob Title: SQL Server DeveloperLocation: Harrisburg, PADuration: 4 monthsDirect Client PositionDescripation: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.SQL Developer Required 1 Years SQL *Plus Required 1 Years SQL Server Management Studio Required 1 Years Microsoft Word Required 5 Years Ability to develop data extraction routines between Oracle and SQL Server Environments Required SQL Server Reporting Services (SSRS) software Required 1 Years XML Highly desired TOAD Highly desired Please send resume to alb...@cncconsulting.com <alb...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
