|
|
123456789101112131415
Resume 8
SCOTT JOHNSON
Dallas, TX
OBJECTIVE
Software or Database developer
EDUCATION
MS Computer Science
NORTH CAROLINA STATE UNIVERSITY, Raleigh
January 1990 to May 1993
BS Industrial Relations
UNIVERSITY OF NORTH CAROLINA, Chapel Hill
August 1982 to May 1987
LANGUAGES/SYSTEMS
Current languages: LotusScript, HTML and Java Script
Previous languages: C, Visual Basic, SQL
Systems: Windows 95 and NT, AS400, AIX
CERTIFICATIONS/EXAMINATIONS
Passed RDBMS concepts on Brainbench
WORK EXPERIENCE
Total of years Notes Development/Administration/Engineering experience:
Feb 2000 - Present Alles Construction Group ACG , Dallas
Lead Notes Developer
- Released upgrade of ACG s Business Tracker databases, a project and client
management system with Crystal reporting.
- November 7, 2000. Releasing version 2.2 of Centech s IRISDocs Construction
Management system
- Changes include a new R5 GUI for the web, improved workflow between Architect,
Owner, and Project Engineer. Integrated Insurance tracking database into
IrisDocs
- This involves insurance management of Subcontractors .
- Improving the
correspondence applications so that the different companies of Alles
can design
their own correspondence printed letters, Crystal reports, e-mail and
e-fax and new
routing functionality is built in.
- Created P3 Material Expediting Process
which
imports the scheduling of construction materials from the P3 application
on the
AS/400.
- Made enhancements to the Punch List/Palm Pilot application which
exports
punch lists into the construction manager s Palm Pilot.
- Created the Alles Intranet site for Alles Mid-Atlantic which includes a
newsletter.
- Eventually the Alles Intranet site will include a corporate calendar,
links to human
resources databases, the SOP Standard Operating Procedures database
for Alles,
and a catalog for all Notes applications used within the company.
- Continually working with management to define and refine the application
development process for the company. This includes business analysis,
requirements
definition, development and change control, documentation, testing, and
deployment
May 1999 - February 2000 Houston Custom Homebuilders, Irving, TX
Lead Notes Developer
- For CH Mortgage have created an on-line Loan Prequalification Application
Applicants fill out the forms and select the region or loan officer. The forms
are then routed to the appropriate officer and manager. Agents are run to
monitor the statuses of the databases and to generate reports. For the next
release of the database, it will allow applicants the ability to view the
status of their applications on-line. And for the workflow on the back end,
it will interface with the Mortgage package on TMO, where all of DR Horton
mortgage information is kept.
Currently working on a project to move the entire CH Mortgage web site
into Notes. Will release a similar on-line database for DRH Mortgage San Diego soon.
- For DR Horton DFW North, creating their entire web site into Notes.
Previously, when DFW North managers wanted to make the frequent changes to
their site, they would sent the graphics, maps, prices, subdivision and lot
information to MIS which would make the changes. The turnaround time was unacceptable.
This database allows them to create Subdivsions and House Plans, enter the
data and graphics, and have the changes show up instantaneously on their web
site. Also incorporated into this database are Virtual Tour java applets which
are animated tours of the house plans.
- Creating a similar database for Continental Phoenix. New project to convert Milburn Homes to similar design.
- Updated DR Horton corporate manual into Notes. Currently contains the company
org charts, phone directories, corporate roster, employee personnel policy
handbook, soft copies of dental, medical, health care forms, the benefits
plan, the healthcare plan, the profit sharing plan, the stock purchase plan,
and Federal and State legal sign postings linked to respective Government
web sites .
- For Human Resources, have completed a Payroll Submittal database which
allows
remote offices to enter their payroll data which then is accessed by Corporate
Payroll and automatically imported into the ADP Payroll Database.
Created an on-line job application form, which when filled out, notifies appropriate
HR department.
Completed the System Access database, a workflow database which allows division
offices to request, approve, and complete user IDs and passwords for the
following systems: AS400, Lotus Notes, Novell, NT Server, RAS, and Telephone.
- Currently working on a Newhire/Termination database which will incorporate
the System Access database with the other processes involved in hiring and
termination. This information will be imported into ADP.
Working on an On-line sign in sheet for DR Horton Corporate.
Also in the works is incorporating a new HR Performance Management database
with the other HR databases. This will generate periodic performance reports
which will be signed off by manager and employee.
- Developed an Advertisement Job Log for three divisions of Torrey/Hobson
Homes.Rolled out 3 versions of the database to Atlanta, Charleston, and Raleigh.
This tracking database contains all the advertising projects, the materials
involved, and the cost of the project.
- Lot and Subdivision database for Dobson Builders in Newport News. This
allows
managers to create Subdivsion and Lot documents to manage construction information.
- Other projects include a couple Contact Management databases, several
reporting
databases, and spreadsheet conversion projects.
June 1998 - March 1999 ZAON Corporation, Chicago
Notes Developer
- Refined and developed new functionality for a computer asset
requisitioning system in Notes. This system consists of 3 databases, an
authorization database where people and their authorization levels are defined,
the requisition database in which requisitions for computer equipment are
created and where the approval process takes place, and the ordering database
in which vendors are assigned .
- Migrated these databases from 3.3 to 4.6 which
included updating the forms with 4.x features, updating views and eliminating
redundant ones, and adding new automation to the requisition ordering process.
Created the Item Catalog database which held the computer items and kits previously
accessed in PeopleSoft. Created the interface to PeopleSoft transactional
systems using Casahl s ReplicAction tool.
- Developed a Notes database for an Oracle database administration group
to handle database requests and to serve as a reference for departmental and
technical information.
January 1998 - May 1998 KINWA Business Credit Corp
Notes Developer and Consultant
- Migrated Kinwa s Capital Equipment Finance Division sales and marketing
teams
from the ACT! Contact Management software to a Notes version the Salesforce
Tracking application
- Assisted in the migration of another team from Notes 3.3 to 4.5. Did the
functional requirements gathering and prototyping for the rollout of their
Salesforce Tracking databases due in May.
- Created the custom proposal feature which automates the creation of lease
proposals
that salespeople can customize and present to the customer.
- Built the manuals for and assisted in the training of the sales and marketing
teams of
divisions.
September 1995 - December 1997 IBM
Lotus Notes Administrator, Engineer, Database Developer and Manager
- Help manage Galveston s Notes server lab which included Notes mail and database
servers, VM and Internet gateways, and Notes FAX servers. Grew Galveston Notes
domain from 1000 to 6000 seats. Migrated Galveston domain from Release 3 to Release
4.
- Galveston groupware representative for defining NCO Network Computing Offering
requirements for IBMUS Notes monitoring and selecting monitoring tools for
IBMUS domain.
- Department leader for ISO 9001. Defined Lotus Notes processes and procedures,
and
conducted security audits to fulfill ISO 9001 requirements and prepare for
ISO certification.
- Helped recruit and train Lotus Notes screen team 2nd level Help Desk
to support
Galveston and IBMUS customers.
- Created a database in Script to enter server outages and perform trending
analysis.
Includes workflow to present solutions to management and get their approval
in the change control process.
May 1992-September 1995 IBM
System Verification Test Architect
Designed and Managed LAN for multiple Enterprise Management product tests.
Design
test scenarios and LAN configuration for new network management products on
OS/2
and AIX platforms.
August 1991-May 1992 SC State University
Graduate Teaching Assistant
Graduate TA for Operating Systems and AI classes.
January 1991-August 1991 Northern Telecom now NorTel
Cooperative Education
Propogated software to different switch loads for ECORE and NT40 switches.
Tested
and debugged code.
August 1990-October 1990 Integrated Industrial Information
Software Developer
In charge of porting project for CAD software.
123456789101112131415
|
|