|
Internet Projects
 |
Web Site Publisher
Designed and developed a web site publishing system and implemented several web sites with it.
The publisher allows multiple users assigned various security levels to
maintain a web site's content within a database using web based
forms. The publisher also allows dynamic forms to be created with
user defined fields. A drill down reporting system depicts all site
user form submissions, including user defined submission types and user
defined data fields. The system is based on middle tier COM
components using defined (high speed) ADO command objects to communicate
with the SQL Server database. Server side and client side JavaScript
are used to communicate with the COM components to retrieve/present and
store data in the database.
|
|
Web Site Data Access Layer
Developed a data access layer, with Visual Basic, that provides high speed
access to a SQL Server database for fetching geographically based
cancellation listings for the Cancellations
web site. Assisted the primary contractor with designing the site's
architecture based on Internet Information Server (IIS), Microsoft
Transaction Server (MTS), and Active Server Pages (ASP). |
|
Corporate Intranet Site
Created an Intranet site for a large manufacturing facility. This involved installing and configuring IIS and adding a section to the network login script to configure the client browsers. Also created several generic ASP libraries for database access, program tracing and error handling, and a set of utility functions such as date and string processing. The site is secured using an ASP code fragment in the global.asa file since the site supports the Advanced Data Connector (ADC) for remote database and business object instantiation, and ADC requires that the web server be configured for anonymous access. The site includes links to various multimedia-training programs as well as a
telephone book page that uses a SQL Server database and a client side grid control bound to the database via ActiveX Data Objects (ADO)
vand ADC. This web site is maintained in a Visual SourceSafe database.
Ported this web site to a FrontPage 2000 based site and greatly expanded
it's functionality. |
|
Equivalent Distillation Capacity Intranet Site
Developed a set of ASP scripts that access an ORACLE database to collect and
display refinery EDC statistics. Also used an ActiveX chart control
and client side script to access the ORACLE database to produce a chart for
the EDC statistics over time. The user can select the whole plant or a
specific unit to be charted dynamically. |
|
Energy Intensity Index Intranet Site
Developed a set of ASP scripts that access an ORACLE database to collect and
display refinery EII statistics. Created a set of sub-pages that allow
the user to click on a unit to see how a unit's EII actual energy
consumption data is calculated. Also used an ActiveX chart control and
client side script to access the ORACLE database to produce a chart for the
EII statistics over time. The user can select the whole plant or a
specific unit to be charted dynamically. |
| Galaxy Intranet Site
Developed and intranet site that enables users to access all real-time
and historical data for all process units within several refineries.
Developed middle tier objects that run in MTS that handle security, database
access, and other utility functions. Designed and developed all server
side and client side scripts to manage the presentation of data as well as
process drag and drop functionality between multiple instances of the web
browser. |
| System Utility Object
Created an ActiveX control with Visual Basic that exposes many of the features exposed by the Win32 API such as creating synchronous processes, reading and writing all areas of the registry, attaching and releasing network resources, and writing to the NT event log. This component is used to install components on client machines automatically by running setup processes in the background. The component is also used to map network drives and execute processes, which allows the integration of non-Internet ready applications into the Intranet site. |
| Real-Time Video
Installed and configured Net Show on an IIS server, and configured an NT server to capture real-time video from a standard line level source. Developed an NT service with Visual Basic that manages the Net Show video capture component and sends the feed to the Net Show server. Created a web page with the Net Show viewer ActiveX component and a VBScript that embeds and controls the video on the page. Also used this setup to record several ASF files which allows users to view an on demand video message via the web site. |
|
Performance Goals Site
Created a web site to display process data, expense data, and OSHA incident data that are used to track the performance goals for a refinery. This site is automatically updated via integration into the process data ORACLE database. The data is fetched from the database with ASP scripts using a previously created library of generic functions stored in ASP include files. Designed and created several database tables, and added them to the existing yield accounting database. Created an SQR program that executes under cron (UNIX system) to collect and calculate actual data for the EDC process data goal. This site also contains an ActiveX graph control that is populated via client side ADO/ADC VBScript. |
|
Weight Balance Site
Created a web site that depicts two views of a refinery’s yield accounting data. This web site merges the daily production estimates with the final monthly accounting values for the refinery’s production, inventory, receipts, shipments, and fuel consumption. The different sets of product codes and classifications of the two accounting systems were cross-referenced through the use of several ORACLE tables that were added to the yield accounting database. ASP scripts using ADO access the ORACLE tables to display a main page that summarizes both system’s results side by side for a given period. If the user clicks on a value, then an ASP script creates a detail page depicting all product activity in both systems, again side by side. There are several levels drill down detail available. This site also contains a project management section that details progress and outstanding issues related to the unit and plant wide weight balance modeling effort. |
|
|
