WORK EXAMPLES

 OF

ERIC DAHLENBURG

  

This is a simple demonstration website for prospective clients or employers of Eric Dahlenburg. The links below are representative of Websites, Databases, Projects and Programming performed by Eric Dahlenburg. The links are either projects developed for employers or assignments for college.

 

 

 

DATABASE PROJECTS

 

 

ILMF PARTS PORTAL- This is a comprehensive Parts Database that I developed for United Space Alliance using Cold Fusion and Oracle 10g. Note: Some links on the Front-end are behind the USA intranet and may not be accessible to the general internet community.

 

ILMF PARTS DATABASE- This is the original Access database developed for managing repair parts for the ILMF, a repair facility within United Space Alliance. Please note: Your security settings may require you to save this file locally, rather than run it over the internet. In addition, some links on the Front-end are behind the USA intranet and may not be accessible to the general internet community. You may be prompted that the file is outside of your intranet/un-trusted site. This is a security feature in Access. Simply, right click on the file, select properties, and “unblock”.

 

ILMF PARTS DATABSE SUPPORTING DOCUMENTS-

The Initial Justification and Proposal for the parts database can be viewed  as a Microsoft Word Document.

The Project Schedule  and Budget can be viewed as a power point presentation.

The Interim Project Progress Report can be viewed as a power point presentation.

 

 

Oracle- Here are some examples of Oracle PL/SQL, including creation of a Range-partitioned Table, a range-partitioned table with Hash Subpartitioning, and an example of a stored procedure using an implicit cursor FOR loop.

 

MySQL- Here is an example of database queries written for a MySQL database. Unfortunately, my web host does not run a version of MySQL (5.0) that allows the use of stored procedures. Otherwise, you would see my actual MySQL database and front-end.

Here is an example of queries executed on my MySQL server. More Examples

 

SQL Related Papers- A Data Warehouse Overview  and  An Overview of SQL Server Reporting Services

 

 

WEBSITES

 

 

SPACECOASTHOMES.NET- This is a site that supports my rental business. It includes actual contracts, pictures tours of apartments that are currently available, and a hidden password protected link for remotely viewing the business financial information.

 

SPACECOASTSALES.NET- This is an example of a Macromedia Flash site. Some of the highlights include the initial loading ad, the opening shuttle animation, custom menu bar, the contact us/e-mail form, and the info/about us audio-visual map.

 

My Supplemental Ebay site- This was a supplemental commerce site to my Ebay auctions, offering the same products without the Ebay transaction fees. It was primarily for repeat customers, but had a pretty healthy view count from word of mouth. I never promoted this site, but made over $8000.00 in just the one year that I used it.

 

Tables Site example- Here is an example of a website developed for a college class that uses Tables.`

 

ColdFusion/Dreamweaver Site- This is a comprehensive Parts Database that I developed for United Space Alliance.

 

Formal e-Business Proposal

 

 

 

VISIBLE ANALYST

Visible Analyst is a software tool for engineering and developing applications. It enables developers to perform and share Data Modeling, UML Modeling, and Process Modeling.

 

Diagram 0- This is the overall Entity Relationship Diagram for a medical office automation project viewed as a JPEG image.

 

Diagram 1- This is the Entity Relationship Diagram for the Appointments subsystem viewed as a JPEG image.

 

Diagram 2- This is the Entity Relationship Diagram for the Payroll/ Accounting subsystem viewed as a JPEG image.

 

Diagram 3- This is the Entity Relationship Diagram for the Insurance Claims subsystem viewed as a JPEG image.

 

Diagram 4- This is the Entity Relationship Diagram for the Patient Record subsystem viewed as a JPEG image.

 

 

VISUAL BASIC.NET

 

 

VB Temperature program- This is an executable Visual Basic program developed using Visual Studios. This program graphically converts Fahrenheit to Celsius using standard windows controls. In addition, temperature displays change colors when they move outside of a range of 0- 4 C or 200-212 F. This is an executable program, so some browsers may not allow you access due to security settings.

 

Source Code – The source code for this program may be viewed as a Microsoft Word document.

 

 

Labview Measurement Acquisition Development

 

 

Temperature VI- This is an example of a VI that measures the  temperature from a thermocouple displayed as a Microsoft Word document.

 

Waveform VI- This is an example of a VI that plots a user generated Sine wave with timestamps displayed as a Microsoft Word document.

 

Shift Register VI- This is an example of a VI that displays the value of data at different iterations as the it loops through the input shift register.

 

Frequency Response VI- This is an example of a VI that measures the frequency response of a unit under test with user selected frequency ranges and steps.

 

 

 

 

 

 

Software Proficiency

                                            

Microsoft- SQL Server

Microsoft- SQL Server Data Mining

Microsoft- SQL Server Reporting Services

Microsoft- SQL Server Analysis Services

Microsoft- C# / ASP.NET

National Instruments- Lab view

MySQL

HTML- CSS

Windows

MS- DOS

Linux

ColdFusion

Dreamweaver

Oracle- Oracle 10g

Microsoft- Excel

Microsoft- Word

Microsoft- Access

Microsoft- Power Point

Visible- Visible Analyst

 

 

 

My Current Resume

 

 

Kaplan University – Graduated Summa Cum Laude with a GPA of 3.95

College Transcript, Kaplan Page 1

College Transcript, Kaplan Page 2

College Transcript, Kaplan Page 3

College Transcript, Oracle Page 4

College Transcript, NMA Page 5