7521 Camp Alger Ave.
Falls Church VA 22042
703-573-6044 / 703-863-4329
awarnold @ lastnamesoftware.net
Broad technical knowledge spanning applications ranging from large, enterprise-wide, multi-function mainframe systems down to small, departmental PC-based applications.
Possess creative problem solving skills acquired from designing software and databases in a large production banking environment. Considered to be an effective communicator with the ability to explain complex concepts to non-technical individuals.
| Infinite Computer Solutions |
2004-Present |
Business Analyst sub-contracted to IBM on a U.S.
Postal Service contract supporting USPS customer satisfaction measurement
initiatives. Design, code, test, debug and install programs into
production and maintain production databases and software that support the
IBM contract. Code in SAS, with heavy use of SAS MACRO, under
Windows XP; some use of Microsoft Excel and VBA macros. Most
output is to Excel workbooks rather than conventional paper reporting.
Specific Accomplishments
- Designed and coded more than 40 original programs in SAS on the IBM PC;
maintained and enhanced 200+ existing SAS programs and macros that process
customer satisfaction survey data to produce several graphic and text analyses.
- Use complex algorithms to identify both geographic and business areas
where the client is meeting their customers' needs and areas that need improvement.
- Streamlined existing SAS Macro programs and, in one case, cutting
processing time from 4 hours to less than 1, a 75% reduction.
- Simplified the existing processing by reducing the number of discrete
steps and the number of required run-time parameters. This action
minimized the possibility of running steps out of sequence and user entry
errors for the parameters.
- Streamlined or created more than 50 Microsoft Excel workbooks and VBA
macros by reducing the level of user interaction required to produce the
deliverable workbook; user interaction was frequently eliminated altogether.
|
First Virginia Services, Inc |
1982-2003 |
| Information Technology & Communications subsidiary of
First Virginia Banks, Inc. |
| Project Leader, Information Technology Applications Development |
(1985-2003) |
Design, code, test, debug and install programs in production for various banking applications including commercial & consumer loans and document image management.
Maintain various third party banking software including Marshall & Isley, Charter, Task Technologies.
Use a 7 phase, structured life cycle methodology akin to Yourdon and DeMarco.
Code in Delphi on the IBM PC under Windows and COBOL, SAS & SAS MACRO on the IBM mainframe under MVS.
The programs access and update VSAM files, Oracle and the IMS databases.
Code both run stream JCL and procs. Serve on call for production.
Resolve abends, code job step overrides and restart jobs.
Use an in-house system for program version control.
Use both TSO/ISPF and ROSCOE as text editors.
Serve as a technical lead and evaluate the workload, and determine schedules and deadlines for the team.
Report project status to management.
Use Corel products including WordPerfect, QuatroPro.
Other productivity tools used include Abend-Aid, Expediter, FileAid, SQL*Plus, SyncSort and various IBM utilities.
Also, coded several Command Level CICS programs and used BMS to generate the online screen. Coded and maintained several assembler (ALC) and SAS programs.
Specific Accomplishments
- Maintained and upgraded a document management system written in Delphi on an IBM PC under Windows, accessing an Oracle database running on the IBM RS6000 under AIX.
- Converted a stock exchange application from Clipper to Delphi. The application helped the Corporate Secretary's staff manage the exchange of stock certificates related to an acquisition.
- Pioneered the use of controlled compiling. Designed and implemented procedures to manage the compile process. This saved hundreds of hours of re-compiling and re-testing by preventing the use of incorrect parameters and improper libraries.
- Designed and implemented a COBOL reporting system, which is a modular process that produces multiple reports with a single pass of the input file. Savings derived from this is that a new report can be added to the process without changing existing programs.
- Designed and implemented a SAS reporting system, including the conversion a large hierarchical file (35+ million records) into a SAS database consisting of several smaller sequential files. This process reduced both processing time for daily report production and turn-around time for ad-hoc reports because unneeded records in the hierarchy were not processed.
- Initiated the use of segmented/concatenated parameter files. Segmentation enabled re-use of portions of the parameter files. Re-use saved several hours of programmer time because a change to one segment would effect several jobs.
|
| |
Potomac Electric Power Company (PEPCO) |
1973-1982
|
Programmer Analyst |
| Coded in COBOL on an IBM 360/370 under MVS. |
| |
| Also served as a computer operator in the U.S. Air Force. |
| |
Virginia QSO Party Software |
2001-Present |
- The Virginia QSO Party is an amateur (ham) radio contest, whose object is
to contact as many ham operators in as many Virginia counties as possible within
the time limit of the contest. Scoring is more complex than in most
other state QSO parties. Other logging programs have minimal support
for the Virginia QSO Party.
- Developed and released software to track contacts in the Amateur Radio contest
using Delphi and Topaz, an X Base database. Initial release was in 2001,
and updates have been released annually.
- In 2006, redeveloped the software in Visual Basic .Net using MS Access as the database.
- Developed web pages using HTML and PERL to support an internet distribution mechanism.
- The software is avaiable on the web at http://www.lastnamesoftware.net
|
| |
Updated on ... November 10, 2003