Stephen Johnson
214-532-9788
sjohnson@rsj-services.com
|
Software Developer
|
Visual Basic Instructor
|
SUMMAY:
- 1974
- Extended HP
2100 operating system to provide utilities not provided by the TODS (Test
Oriented Disk System), including:
- Print, Copy,
Sort, System Date and Time clock, and logical Read/Write (sequential and
Indexed) utilities written in FORTRAN II.
- Created Bill of
Material Utilities
- Created
Point-to-Point Wire List Generator rescuing the time from 7-10 days to 1
day to create a Wire List for building Uninterruptable Power Machines
(Large scale Battery Backup system from 10K 10 300K)
- 1979
- Created the
DIRTBOL language (in macro assembler) that helped reduce programs
(written in Datapoint Databus Language) taking up to 24 hrs. to run to 30
minutes or less.
- 1980
- Wrote a complete
Operating System for the Z-80 Microprocessor (in Assembly Language),
complete with Interrupt processing, including all hardware drivers and
the System Clock. Using the HP 64000 Microprocessor Development System in
4 months.
- 1984
- Converted
Inventory Control System written on a Datapoint System to a DEC VAX
system, 18 months ahead of the schedule.
- 1986
- Wrote Several
Hardware Diagnostics for a Datapoint repair company in DIRTBOL.
- Wrote a complete
Help Desk system (on the IBM System 38 in CL and RPG) and was later
re-written for the AS/400 with many enhancements.
- 1990
- Wrote Program
generator (on the AS/400 in CL and RPG) to create programs that would
reduce the processing time for reading tapes from 72 hours to process to
less than 1 hour
- 1995
- Rewrote and
enhanced two purchased utilities for a Property Management Company in
Visual Basic 3.0:
- Anycall – Help
Desk System
- Preventive Maintenance Planner
- Created a
Communication Utility for the Company to communicate with remote offices.
- Created Software
Distribution Utility for distributing company software to the branches.
- 2010
- Completed a new
(Extendable) utility that would replace Microsoft SSIS (SQL Server
Integrated Services) with a much simpler and user-friendly interface and
features not found in SSIS.
- 2014
- Create a
configurable SOAP Universal Web Service (UWS) that can be used to access
any Server, Database, and Procedure that the company has access to with a
utility to configurating the UWS.
- 2000 – 2006
- Taught Visual
Basic 3.0 thru VB 6.0 and VB .Net 1.0 thru 10.0 and the NT PC Users
Group, and VB 5.0, OOP at Richland collage.
- Taught AS/400 CL
and IBM Technical Services.
Most of the above was written with no help and no experience.
EXPERIENCE:
Independent Software Consultant - 03/2012 to Present
Primarily
performing software development and maintenance as requested by various clients
including, but not limited to, RealPage, Inc.; Riverstone Residential Group;
and Probity Advisors, Inc.
Project types
include updating existing Web Site for Probity Advisors and migrating SQL
Server and Web Host from a local installation to a Cloud Based installation.
I specialize in the
creation of Programmer Productivity Tools, and Data Transfer and Conversion
Utilities, and SQL Server Database Administration.
Most programming is
performed using Visual Basic .Net (2005, 2008, 2010, or 2015); SQL Server
(2005, 2008, or 2012); HTML, CSS, VBScript, JavaScript, jQuery.
RealPage Inc. - 07/2010 to 03/2012
(RealPage
acquired the Riverstone Residential IT Department)
Title: Software Developer IV
Primary job was to
develop Yardi Reports and system utilities and tools so that Clients could
provide financial information to owners, banks, and service providers. The
primary client was Riverstone Residential, Dallas Texas.
I created many specialized
Web Applications that interfaced with the Client Databases via Web Services and
created Microsoft Excel formatted reports including:
·
A Password
Reset Utility where users could reset their own System and Application
passwords, after registering with the utility Authentication information that
only they know and registering each Applications. The Utility communicated
with the Applications via Web Services.
·
A Web
Application used by the Cloud Services Group to maintain whether properties
were signed up for Desktop Support or not and providing additional information
not available in their Property Management Software. The Utility communicated
with the Probity Management Databases via Web Services.
·
Several reports
were written as Excel Worksheets (some using Templates and others did not).
These applications (written in VB .Net) by executing an SQL Query (with
multiple result sets) and created one or more Excel Worksheets populated from
the result sets.
All applications
were written in Visual Basic .Net (using Visual Studio 2008/2010) and/or SQL
Server (2008), with some reports using SQL Server Reporting Services.
Riverstone Residential Group, Dallas Texas - 10/2007 to 07/2010
Title: Software Developer
Primary job was to
develop Yardi Reports, and system utilities and tools so that Riverstone
Residential could provide financial information to owners, banks, and service
providers.
Accomplishments:
- A Data Transfer Utility used to retrieve information from
the database, convert and/or format the data, and transmit the data,
through the internet, to the companies that requesting the data, or
receive, format, and insert the data into the database. This Utility performs
many of the functions that SQL Server Integration Services (SSIS) does but
in a much Easier-To-Use and more dynamic User definable tool.
- A UROCK System (Later changed to YouROCK). An online
Application, in which, employees recognize other employee’s accomplishments
and to thank employees for their help. E-mail messages would get sent to
the appropriate employee as well as their supervisor, so the supervisor
will know how other employees appreciate their subordinates. System
interfaces with the HR system to retrieve employee information.
- A System Monitoring Utility, used to monitor all Scheduled
Jobs and to e-mail the appropriate person in the event of job failure, or
if the job did not start as scheduled.
All applications
were written with Visual Basic .Net using Visual Studio 2005 or 2008 and/or SQL
Server, with some reports using SQL Server Reporting Services.
Probity Advisors, Dallas Texas - 07/2006 to 09/2007:
Independent Consultant
Accomplishments:
- Helped in developing,
(database design, visual design, programming and implementation) of their
Customer Management System.
- Developed many Utilities to
transfer information to and from their SQL Databases for Vendors and
Services.
All applications and tools
were written with Visual Basic .Net using Visual Studio 2005 or 2008, and/or
SQL Server 2005.
Prentiss Properties Limited, Inc./Brandywine Realty
Trust. Dallas Texas - 9/2003 to 06/2006
(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:
Prentiss Properties Limited, Inc./Brandywine Realty
Trust. Dallas Texas - 9/2003 to 06/2006
Accomplishments: continued…
Software Consultant - 11/2001 to 9/2003
- 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)
Prentiss Properties Limited, Inc. Dallas Texas -
2/1999 to 11/2001
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.
- For the North Texas
PC Users Group I was the
Advanced Visual Basic, Special Interest Group Leader.
- Visual Basic
Programming (70%), AS/400 Programming (30%)
- 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.
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
ADDITIONAL INFORMATION:
01/2000 to 06/2006: Part Time Programming Instructor
During this time, I taught classes in Visual Basic 5.0 and
6.0, and Visual Basic .Net Through VB 2001 thru 2005), C, C++, OOP, SQL Server,
Web Services and many other subjects relating to programming at:
- Advanced Visual Basic Special Interest Group (as Leader)
– North Texas PC Users Group
- Richland College (Continuing Education Section)
Education
- Graduated Tech Hi School, Ft Worth Tx with Diploma in
Radio and TV Servicing - 1965
- USAF Electronics School, Biloxi MS, graduated in top 1%
- 1967
- Control Data Institute Computer Hardware School, Dallas
TX, 93% - 1973
- Control Data Institute Computer Programming School,
Dallas TX 99.4% - 1974
- Attended College courses at University of Alaska at
Anchorage, UT Arlington TX, UT San Antonio TX, and Eastfield Jr College
Mesquite TX. (No Degree due to being a single parent with 2 kids and
closest Full College was 2 hours away and working full time)