Exchange Network in Our Enterprise

1
Exchange Network in Our Enterprise

• Department of Environmental Quality
• Commonwealth of Virginia

2
State of the Node

• At DEQ Virginia, we have five data flows in
  production
• NEI
• TRI
• FRS
• AQS
• Chesapeake Bay Program Regional Exchange for BMPs
  
• Automated all the above five data flows in our
  enterprise.
• Different data sources and multi directional data
  flows
• Data from other state agency

3
Automation

• Why?
• To meet the demands of Agile Enterprise
• How much?
• As much as you can. We drew the process flow
  diagrams for all the data flows and automated all
  the paths we could.
• Tools
• Outlook reminders, Oracle jobs, UNIX jobs

4
NEI Data Flow

• NEI Data flow Automation
• Outlook reminder is sent to Business staff and IT
  staff that NEI data is scheduled be sent to EPA
  on May 25

5
NEI Data Flow
Solicit Request Email to Node helpdesk
Email to DEQ Staff
Update Data
May 24 run stored Procedures via DB job
Solicit May 25
EPA NODE
DEQ NODE
6
FRS Data Flow
Solicit Request Email to Node helpdesk
Email to DEQ Staff
Update Data
12/31,3/31,6/30,9/30 run stored Procedures via DB
job
Solicit 1/1,4/1,7/1,10/1
EPA NODE
DEQ NODE
7
Email

• Email to Node Helpdesk
• From node
• Sent Monday, March 31, 2008 102 AM
• To nodehelpdesk_at_csc.com gcarioti_at_csc.com
• Cc Enuganti,Srinivas Eturu,Phani
• Subject FRS Solicit
• This is an automated e-mail requesting FRS
  Solicit to VA Node Production Server
• Email to DEQ Staff
• From node
• Sent Monday, March 31, 2008 102 AM
• To White,Deborah
• Cc Enuganti,Srinivas Eturu,Phani
• Subject FRS Data Upload
• Sussessful data upload

8
AQS Data Flow
Email to DEQ Staff With transaction ID
Nightly Batch jobs
DEQ Air Quality Business Staff
File Server
EPA NODE
DEQ NODE
Archive
9
Email

• Email to DEQ Staff
• From node
• Sent Tuesday, March 11, 2008 203 PM
• To Stevens,Carolyn Sorensen,Crystal
  Gilley,Baxter
• Cc node
• Subject AQS Data Submission Success!!
• The AQS XML va03112008.xml document has been
  successfully submitted and the transactionId is
  f488a3d5-8bad-4e61-b29d-7b6bd5b1d8b3.

10
BMP Data Flow
Email to DCR After the file is received
Email to DEQ and DCR Staff
Nightly Batch jobs
DCR
Solicit
CHESEPEAKE BAY NODE
DEQ NODE
DEQ SERVER
11
Email

• Email to DEQ and DCR Staff
• From node
• Sent Friday, March 28, 2008 134 PM
• To dcrbmp
• Cc Farkas,Bernie
• Subject VADCR XML File
• DCRBMPFile.xml has been successful to sent by
  VADEQ NODE to CBPO.

12
TRI Data Flow
Email to DEQ Staff
Refresh Data Ever 15 Min
JAVA Program
Runs Every Night
EPA NODE
DEQ NODE
Archive
Waste media Business staff
13
Emails

• Two Emails are sent by the program
• 1)An email for each chemical received
• 2)Processing information file with two
  attachments
• First attachment has information about number of
  files received, number of files processed and
  number of files rejected.
• b) The second attachment contains the rejection
  details

14
Emails

• Summary Email with attcahments
• From Node
• Sent Thursday, February 21, 2008 412 PM
• To McDaniel,Nichelle
• Cc Rachagiri,Vineela Enuganti,Srinivas
• Subject TRI Load
• Attached are the information and error logs for
  TRI load.
• Summary File Attached
• ------------------ Summary ------------------
• Total Reports Received 5
• Total Reports Processed 2
• Total Reports Rejected 3
• ------------------ Summary ------------------
• Error File Attached
• It's a duplicate report and reports exist for the
  same key in db 23297DFNSG8000J 2006 353593

15
Emails

• Email for every Chemical
• From Node
• Sent Thursday, February 21, 2008 412 PM
• To McDaniel,Nichelle
• Cc Rachagiri,Vineela Enuganti,Srinivas
• Subject TRI Chemical Report(s) Receipt
  Confirmation
• This is to confirm that Virginia Department Of
  Environment Quality received the following report
  submitted by
• U.S. DEFENSE LOGISTICS AGENCY DEFENSE SUPPLY
  CENTER RICHMOND
• TRI Facility Id 23297DFNSG8000J
• Reporting Year 2006
• Chemical Name Dichlorotetrafluoroethane
• From Node
• Sent Thursday, February 21, 2008 412 PM
• To McDaniel,Nichelle
• Cc Rachagiri,Vineela Enuganti,Srinivas
• Subject TRI Chemical Report(s) Receipt
  Confirmation

16
Enterprise Backup and DR Plan

• All the above mentioned DEQ servers on enterprise
  backup schedule
• All the severs are also included in our Disaster
  and recovery plan