Stephen Johnson

Software Developer

Visual Basic Instructor

EXPERIENCE:

9/2003 to Present: Prentiss Properties Limited, Inc. / Brandywine Realty Trust. Dallas Texas

(Brandywine Realty Trust purchased Prentiss Properties Limited as of Jan 5, 2006)

Title: Programmer/Analyst

Responsible for all programming tasks on AS/400 and PC based programs.

Accomplishments:

· Conversion from AS/400 based CTI Property Management system data to MRI. Accomplished by taking AS/400 database files to SQL Server then using stored procesures to combine and translate data then extracting data to MRI Import formats.

· Conversion from Building and People database (Lotus Notes) to SQL Server and Web Application using ASP.Net and Visual Basic .Net 2003

· Conversion from Excel based Meeting Notes to SQL Server and Web Application using ASP.Net and Visual Basic .Net 2003

· Created utility to copy data from Corrigo data export to AS/400 CTI A/R Import and back to Corrigo. Written in Visual Basic .Net.

· Created and modified many Excel routines for many company employees to use.

· Maintained and created many AS/400 programs using CL, RPG/400, RPG 4 (ILE RPG), and UIM.

11/2001 to 9/2003: Software Consultant.

Worked with client (www.hausertech.com) in Web Site and Web Page design and Maintenance using ASP and Microsoft Content Management Server (MCMS).
Worked with client (www.hausrtech.com) developing a Video Capturing Application for upload to Internet for dating service.
Worked with client (www.hqglobal.com) performing AS/400 to SQL Server 2000 migration. Created Applications to convert from CTI Property Management System (AS/400 data) to PeopleSoft System (SQL Server 2000). Conversion was completed in two parts. 1) Extract the AS/400 data to SQL Server 2000; 2) Convert the data to PeopleSoft Format using VB6, ADO, and SQL Server Stored Procedures.
Worked with client (www.na.cfs.com) performing AS/400 to SQL Server 2000 migration. In addition I converted a few of their Custom Inventory Control programs from RPG to ASP Pages for Historical lookup.

The Applications were written with Visual Basic 6.0, ASP, HTML, DHTML, VB Script, and/or JavaScript and data access was via SQL Server 97/2000 on the PC, and using RPG III and/or IV, CL, and UIM Manager on the AS/400.

Worked with Visual Studio.Net Versions 1, 2003 and 2005 (including Beta’s)

2/1999 to 11/2001: Prentiss Properties Limited, Inc. Dallas Texas

Title: Programming Manager

Responsible for all programming tasks on AS/400 and PC based programs. I was the Supervisor of AS/400 and PC programming staff.

Accomplishments:

A rewrite of 16 bit A/P Transmittal Manager Application written in Visual Basic 3.0 to 32 bit version written in Visual Basic 6.0 which includes a General Purpose Class Library (usable by multiple applications), a Database access DLL, an Internet Access DLL. Application links to AS/400 databases to download latest GL Chart of Accounts at predetermined and periodic times. Includes 'Context Sensitive' Help. Application installation procedures were written using Installshield.

I wrote several PC Desktop Applications written in Visual Basic 6.0 and AS/400 Utilities written in RPG III/IV.

I was responsible for all special PC and AS/400 application design and implementation.

I am the current Advanced Visual Basic, Special Interest Group Leader for the North Texas PC Users Group.

Visual Basic Programming (80%), AS/400 Programming (20%)

My programming languages include RPG/400 (RPG III) and ILE RPG (RPG IV), AS/400 Control Language (CL) and User Interface Manager/400 (UIM), Visual Basic 3.0, 4.0, 5.0, 6.0 and .NET, Visual C++, C, Installshield 3.0, 5.0, 5.5, 6.0 and 6.22, and RoboHelp for Windows help development., HTML, DHTML, ASP, VBScript, JavaScript.

4/95 to 2/1999: Prentiss Properties Limited, Inc. Dallas Texas

Title: Sr. Programmer/Analyst

Provide programming services including, but not limited to A/P, GL, Financials Reporting on the AS/400, and Client/Server and Standalone Applications for Windows 3.1 and Windows 95/98.

Accomplishments:

ANYCALL - Tenant Work Order Tracking System written in Visual Basic 3.0

A/P TRANSMITTAL - AS/400 Dial-up A/P Upload Utility, Linking 60+ Locations to Corporate Support Center., written in Visual Basic 3.0

Download Resume in Microsoft Word Format