# Presentation: 489460

## Using Electronic Commerce To Build A Strong Integrated Database

**Mr. Zeke Brehm****DEP EC Project Manager**
**zbrehm@state.pa.us**
**(717) 705-3869**

***Using Electronic Commerce To Build A Strong Integrated Database***

## FIX Phase I (circa 1996)

**EXAMPLE:  BETHLEHEM STEEL CORP**

**Standardization of client/site concept and data elements **

## <footer>

## Electronic Commerce Enterprise Approach

**What do we mean by “enterprise”?**
**What areas in DEP can we think of as being “enterprise”?**
**What are other ways we can think of “enterprise”?**

## The EC Puzzle

## DEP Philosophy

***“******Develop once. Use many times.”***
***“******Don’t reinvent the wheel.”***
**We are interested in technology and application transferability, reusability, and modularity. **
**We are interested in coordination and partnering opportunities.**
**We are interested in leveraging available IT assets, initiatives, existing infrastructures, etc.**

## DEP Philosophy

***“******Multiple options, multiple costs.”***
**A government organization cannot favor one class of citizens over another. **
**In order to attract the largest number of citizens, we must offer different options such as XML, UDF, web forms, and even paper.        **

***“******Build components common to the enterprise so that all can share.”***
**security**
**registration**
**submittal**
**review**
**archive**
**financial**
**outreach, education and training**
**common data warehouse**

## DEP’s Enterprise Approach

**Benefits**
**Avoids “stove pipe,” one use, throw away solutions.**
**Lends itself to data integration.**
**Takes care of security, archival, financial, etc. for the user in a standardized way.**
**“****Levels the playing field.”**
**Forces the program to focus on its business needs and its application.  **
**Reduced marginal cost for each business area/program.**

##  Security            Registration

**User Name and Password**
**Public Key Infrastructure (PKI)**
**Certificate is obtained from a Certificate Authority (CA) prior to registering with DEP**
**What level of certificate?**

**Portal**
**Must have a certificate prior to registration**
**The registration process will verify the certificate with the CA and the company with the legacy database (eFacts)**
**The registration process will capture attributes such as P.E., P.G., etc.**
**The registration process will also capture user preferences**

## Submittal          Review

**Allow submitters several different options**
**XML, UDF, web form, other**
**Give  submitters access to a “work area” to prepare submissions prior to submittal**
**Allow “1st-level” edits on draft data prior to submission**

**Allow submitters to review their submissions after DEP has received and processed it**
**Utilize a secure web site for the review**
**Legal requirement–PA Act 69, Pennsylvania Electronic Transactions Act**

## Other Functions

**Archive*****“Digits to dust.”***
**Financial**
**Automated Clearing House (ACH) Electronic Funds Transfer (EFT), credit card, debit card**

**Outreach, Education and Training**
**Interim Storage Data Warehouse**
**Paper**

## DEP-CTC Partnership

**Concurrent Technologies Corporation**
**DEP’s Oversight Contractor**
**Over 50 individual work orders**
**8+ vendors to implement**

**Independent 3rd party**
**Vendor, product neutral**
**Test, benchmark, pilot and recommend EC products**
**Avoid “adverse interest”**
**EC architect for the enterprise**
**EC resource available for the programs**
**Does not implement**
**Avoid the proliferation of numerous non-interoperable projects**

## Short List of  Projects and Vendors 

**Central Web Presence–**
**Interim Storage/Legacy **
**Database Interfaces–  **
** **
**Security–**
**Discharge Monitoring Report (DMR)–  ****	****	****	****	****	****	****and****	****LMI**

## Short List of  Projects and Vendors (continued)

**Oil and Gas Drilling Permit–**
**Electronic Fee Collection–    **
**General Information Form (GIF)–**
**Lab Sampling–**

##             DEP Electronic Commerce

**Report **

**Drilling Permit**

**            ****DEP Electronic Commerce**

**Form**

**Air Emissions **

**Form **

## Concurrent Technologies Corporation

**Matthew M. Nielsen**
**(717) 796-3194**
**Cell (717) 503-9330**
**nielsenm@ctc.com**
**Lorraine Warwas **
**(717) 705-5413**
**c-lwarwas@state.pa.us**
- http://www.dep.state.pa.us/dep/deputate/airwaste/wm/drfc/info/ecpage.htm