|
Nov
2003 - May 2004 Strategic Mortgage Solutions, Inc. Houston,
TX
Contract MS Access Developer/Analyst.
|
|
Maintain Due Diligence software in Windows XP and Network
Environment. Refined software by improving program flow and
usability. Provided on-site support for server during due diligence
review projects. Designed form to export XML documents for
third-party software. |
Nov 2002 - Jan 2003
Strategic Professional Service, Inc. Houston, TX
Contract MS Access Programmer/Developer
New Process and
System Design.
Imported Data from PeachTree Complete Accounting Database to Access in
order to query information and to present in report formats. Queried
data and exported to excel for storage in client's database.
May 2000 - Jan 2002
Software & Solutions for Enron La Porte, TX
Contract MS Access
Programmer/Developer - Software and Solutions/Meador Staffing
System Redesign.
Conversion of Lotus and Excel Spreadsheets to a fully automated database
system for generating daily reports. Lotus spreadsheets/data imported
from SQL Server and other proprietary systems through ODBC Data Source
and stored to Access tables. Created a new input and processing forms
using Access supported by VBA.
Dec 1999 - May 2000
Xerox Asset Management Houston, TX
Contract MS Access Programmer/Developer - Ajilon
Maintain and
Refine Billing Software.
Immediately assumed responsibility as primary developer/analyst of
billing software for 30 different accounts.
Billing Software
Support.
Responsible for data validation processes, analyzing billing records and
transporting to appropriate SQL tables for billing in PeopleSoft
system.
Billing Algorithm
Development.
Develop queries and modules for new accounts. Determine and develop
necessary data validation for new accounts.
Jun 1998 - Sep
1999 Strategic Professional Service, Inc. Houston, TX
Contract MS Access Programmer/Developer
Maintained Due
Diligence software on Windows NT server.
Refined software for user community. Provided on-site support for
server during due diligence review projects.
Completed
conversion of MS Access version of Due Diligence software to Visual
Basic.
Document and fix code not previously documented.
Created Quality
Control program for mortgage loan review process.
Created event-triggered modules to assign deficiency codes for tracking
the loan review process of underwriters, loan officers and loan
processors through reports.
1998 Lone
Star Inspections, Inc. Houston, TX
Contract MS Access Programmer/Developer
| |
Created Property
Inspection Report System.
The System
allows the inspector to input inspection data and output into format
required by the Texas Real Estate Commission for licensed Texas
Inspectors. I also created a process for transferring individual
reports between company sites through use of e-mail. The system
tracks orders and allows them to be assigned to appropriate
inspectors. The most important task was to create a module to
accept varying comment data sizes and to reformat any amount of data
that the inspector supplied to the inspection form REI7A-0. This
was accomplished by resizing of comment areas and perform page
renumbering as necessary. (Entire software developed using MS
Access. See
www.geocities.com/reformoffice/products.htm
for more
information.) |
1998
ProStaff, IT for Enron International Houston, TX
Contract MS
Access Programmer/Developer – ProStaff
Designed Access
databases and a front-end
for the Asset Management group to collect operation/construction costs.
Programmed queries and code for unique reports necessary to compute cost
estimates for future asset planning.
1997 Harris
Webb & Garrison Houston, TX
Contract MS Access
Programmer/Developer – ProStaff
Designed Access
database and front-end
consisting of forms and reports for collection of equity research data.
Purpose of database was to simplify extraction of comparison data
between specific health companies through data entry and query searches.
1996 – 1997
Certified Pasadena, TX
Contract MS Access Programmer/Developer – FMC
Designed and
maintained Access databases
for plant operation maintenance schedules and part orders. Linked
documents to database for maintenance schedules and work orders
including database translation from scanned Excel spreadsheet formats.
1994 – 1996
Houston Lighting & Power Houston, TX
Forms
Analyst/Programmer
Designed electronic
forms/systems for company's LANs and stand-alone PCs. Established and
implemented procedures for releasing electronic systems. Provided
back-up support and problem-solving for help desk support. Designed
user manuals for software packages. Provided individual and group
training for company-wide clients.
1990 – 1992
British Petroleum Houston, TX
Systems Support -
I/S, Geological Software Programmer
Enhanced "In-house"
geological mapping system (coded
in FORTRAN and Pascal) to provide
users with a more useful lease-block option being otherwise offered by
outside vendors. Collaborated with users to develop a quality,
systematic front-end program for creating seismic maps and reports.
Designed/created user accounts, groups and server environments for UNIX
file servers. Provided group training and presentation to management
using PowerPoint.
|