|
February 9, 2009
|
Stephen D. McLeod
6472 Georgetown Road
Broad Run, Virginia 20137
|
cell: 540–622–4444
land: 540–347–1865
smcleod@broadrunit.com
|
Summary:
I am a Vietnam Veteran
with special qualifications in
Cost and Economic Analysis using
financial and
statistical modeling.
I am also experienced in general ADP system design and development
using a variety of tools including database design and development
and building
interfaces between legacy and new client server systems.
These are complementary skills as the enterprise data and applications
provide the source of historical data for the business model.
The ability to mine enterprise databases, subject that data to
statistical analysis, and present the results in an easy to use format
are critical factors in the success of a
financial or business model.
A model begins with an understanding of the business system that is
the target of the model. Next an automated model is developed to prove
the concept. Finally, the model is iteratively modifed and augmented
to respond to new knowledge gained from the model’s use and development.
I am looking for clients who recognize the value of sophisticated business
planning models that accurately represent the business processes of the
enterprise. In a period of business contraction accurate forecasting of
cash flow and sales can be critical to the health of the enterprise.
Accurate modeling of business processes can highlight areas where
cost reductions or profit improvement can be made.
Broad Run IT, LLC also has
special qualifications in DoD procurement
and in designing and building
integration between legacy ADP systems and newly acquired ADP systems.
Firstly such integration requires detailed mapping of data and data
flows to identify data commonality, discontinuity, and transformations.
Secondly, interfaces are built possibly using tools such as webMethods.
Lastly, the system is tested and monitored for unintended behavior and
new requirements. I am also experienced in general ADP system design
and development using a variety of tools including database design
and development.
I am looking for clients who recognize the value and risks of integrating
otherwise separate ADP applications and databases. Value comes from
eliminating operational bottlenecks, breaching organizational walls,
and providing a clearer window into the operation of the business
processes of an enterprise. Many integration efforts fail due to
unrealistic expectations of the complexity of the task. Risk is
mitigated by first creating a detailed assessment of the systems
proposed for integration then building an integration plan based
on a realistic assessment.
I have been in the computer industry now for over 25 years. Most of this time has been as a
designer and writer of software. I also worked for five years on a commission as a
technical representative where I was responsible for teaching clients the company software,
providing on site and telephone support, growing the revenue from existing customers, and
supporting the sales team in closing new business. Of these two areas, I am probably better
suited to software development but I was quite successful at the sales job as well and look
back at that now with some nostalgia. It was fun and challenging to combine the technical
with the personal.
Education:
M.S.T.M., Computer Systems and Information Science, American University, Washington, D.C., 1975
B.A., History and Political Science, Davis and Elkins College, Elkins, West Virginia, 1967
Representative Accomplishments:
security clearance
Hardware and Software experience is at the end of this resume.
work experience:
STR, LLC June 2008 to February 2009
Planning and Budget Analyst specializing in developing automated tools using Microsoft Excel, Access, and Visual Basic for Applications (VBA).
-
In support of Air Force Long Range Plans, Mr. McLeod maintained and expanded the Extended Tradespace Tool (ETT). ETT provides the Air Staff with an automated mechanism to collect and combine budget and planning data from several sources into a single database. From this database using ETT tools, developed in MS Excel and Access, the Air Staff can quickly explore budget and force plan options projected out to 2040. Mr. McLeod added new data structuring and option building tools.
Wyle Laboratories, Aeronautics Group March 2004 to June 2008
Cost Analyst specializing in developing automated cost models using Microsoft Excel, Access, and Visual Basic for Applications (VBA).
-
In support of the Space Intelligence Community, I redesigned and wrote a cost modeling application that adds significant new capabilities and features that improves the efficiency and effectiveness of the cost analyst. Significant improvements include: unlimited estimate excursions with version control and audit trail; database storage of CER formulae and processes that are dynamically assigned to estimate line items; a business rule base that is used to assess the completeness and reasonableness of contractor supplied data; automated data import from and export to Excel workbooks; a reference database that may be shared by all analysts in a group; an estimate database that may be shared by all members of an estimating team; and automated export of data to an Excel cost model.
-
Completed a proof of concept demonstrating that cost estimating relationships (CERs) — parametric equations relating cost to independent variables — can be stored in a RDBMS, retrieved, and executed. This proof of concept also demonstrated that processes can also be stored into and retrieved from a RDBMS. These processes consist of a series of independent equations that can be linked so the results can be chained where the dependent variable of one can feed an independent variable of the next. This application uses persisted objects to contain CERs and processes in a RDBMS or text file.
-
Designed and built a COTR’s contract management application that provides the current status of contracts and also tracks the changes to the contracts over time. This application uses linked lists in a RDBMS to give the user the capability to move back and forth in time by clicking navigation buttons. Planned, obligated, committed, and expended funds are tracked by appropriation and CLIN.
-
Took over maintenance of an existing time keeping application making significant changes to reporting and data validation.
-
Took over maintenance of an existing generic cost model. Several significant new features have been added and fixes have been made to existing features.
Broad Run IT, LLC, November 2001 to February 2004
I am the owner and the only employee of Broad Run IT, LLC
-
Completed work in March 2003 on the
SPS / SAMMS interface developed while an employee
of AMS. This application required personal services that could not be accommodated under
the AMS contract with DoD. There was a need for flexibility in tuning the
application’s requirements to get the total application system up and running in
the client’s working environment. The work required knowledge of the DoD procurement
process in general and the processes at the Defense Logistics Agency in particular. The
technical environment included HPUX, Sybase ASE, Windows 2000, and Microsoft network
infrastructure. The development tools used were UNIX C and Shell Scripting, and Sybase
ASE database, SQL, stored procedures, host language interface, and PowerBuilder.
Knowledge of the DoD Standard Procurement System (SPS) was key to accomplishing
this work.
American Management Systems, Inc., January 1987 to October 13, 2001, full–time member of Federal Consulting Group, Arlington, Virginia
- Legacy to Client/Server System Integration –
Designed and built a two way interface between The DLA SAMMS procurement support system and
the DoD Standard Procurement System (SPS). This work was a pioneering effort
that became part of the Defense Logistics Agency’s BPR effort.
This application provides for mapping of DoD legacy data with the newly
acquired SPS. The legacy SAMMS system is a large mainframe based
batch system. The SPS is a distributed, on–line, client/server system. The interface
processes include data mapping and translation requiring the developer to have an intimate
understanding of DoD procurement data and processes. This process was implemented using UNIX
(HPUX), ANSI C, Sybase esql and ct–library, Sybase stored procedures and triggers, and UNIX
utilities and system functions.
- White Paper on Mobile Computing – Researched and wrote a White Paper on
Mobile Computing and emerging wireless data communication technologies along with software
development tools and middleware to support application development for wireless
applications. Paper was written for the Corporate Technology Group of AMS. This paper
reviews the current state of the art in wireless data transmission and describes a set of
characteristics that determine a successful wireless mobile application.
-
Lotus Notes Database – Designed and implemented in Lotus Notes a
retrospective project database for AMS. This database stretched the technical capabilities
of Lotus Notes to provide some relational database like features. This database is in use by
AMS to support marketing and improve corporate communication and service to clients with
common requirements.
-
Lotus Notes Database – Designed and implemented a business process
re–engineering report data base using Lotus Notes and LN:DI imaging for the Defense
Information Systems Agency. Education and experience in Information Science provided the key
knowledge to provide a high quality product. This database provides DoD with a database of
BPR reports that is usable by a geographically disperse audience and provides many entry
points into the database so that previous BPR projects with similar characteristics can be
accessed and used by current projects. This was an early effort to provide a DoD wide
enterprise architecture repository.
-
Business Process Re–engineering – Participated on the AMS/Navy team
doing a business process re–engineering of the Navy Shipyard planning and production control
processes. A prototype effort has demonstrated considerable cost savings improved quality
and schedule performance.
-
Client Server Production Tracking System –
I designed and implemented a two way interface for a new client server
production support system for waterfront supervisors at the U. S. Naval
Shipyards. This interface provides a two directional interface between
existing Honeywell mainframe–based shipyard accounting systems and
the new on–line UNIX and network–based production support system.
The software for this interface provides for guaranteed data
delivery and audit and is central to charging time and paying employees.
This DSS saves considerable supervisor time formerly spent doing paperwork
and planning activities and provides job accounting controls. It is
designed to use UNIX servers running Informix with over 500 PC
Workstations connected through a TCP/IP network over a three mile
waterfront industrial area. The database is both distributed and
replicated.
- Assisted with the design of automation for the ship alteration planning and
funding request process for the Navy. The automated system will allow quicker
reaction to changes in budget and plan and provide added controls and data validity checks.
- I developed a
quick reaction cost model
for the U. S. Army Cost and Economic
Analysis Center. Analysts are able to change the budget or the quantity
of items being purchased and see the effect on production and contractual
obligations.
This is an example of business simulation from the Zachman Framework.
The specific purpose was to validate the reasonableness of
budgets (POM) produced by Army Programmers for procurement of M1A1 Abrams
tanks. An anaylist can enter the number of vehicles required and produce
a total budget and unit cost or enter a total budget and produce a unit
cost and number of vehicles. The model distinguishes between fixed and
variable costs and accounts for threshold production levels where the
cost structure changes. CERs were developed using regression on data
from five years of budget requests. The raw regressions exhibited both
heteroscedacity and multicolinearity requiring the models (CERs) to be
incrementally adjusted. The statistical calculations were done with Systat
and the operating model was built using Encore! Plus from
Ferox Micro Systems.
- Provided technical oversight and consulting to the AMS team designing and
building a prototype to allow military cost analysts to validate cost estimates, generate
independent cost estimates, and to parametrically estimate future ADP hardware costs
for non–tactical information systems for the U. S. Army Cost and Economic Analysis
Center.
-
Wrote the technical section of a successful proposal
to the U. S.
Army Cost and Economic Analysis Center for a task order contract to do cost analysis
research for Armament, Munitions, and Chemical weapons programs. This contract was valued at
one and one half million dollars.
-
I was the project leader for the development of Cost Estimating
Relationships (CERs) for weapon, munition, and chemical systems
for the U.S. Army Cost and Economic Analysis Center. CERs provide a
parametric method of estimating the cost of a weapon system. These
were based on cost data collected from Army program managers at
various arsenals. The data was used in regressions to create models
used to validate the reasonablness of research and development, and
procurement cost estimates. The statistical calculations were done
using Systat.
- Project Leader on the Information Management Resource Center (IMARC)
specification and design for the Office of the Director of Information Systems for
Communications, Command, Control, and Computers (ODISC4) which is a staff agency of the U.S.
Army. In this project, I coordinated the work of managers and individuals in three teams
from different AMS sections.
- Member of the design team for the Army Suggestion/Model Installation
Program/Standard Installation Organization (Army Suggestion/MIP/SIO) automated suggestion
tracking system. Responsible for the SIO portion of the system. Interviewed Army action
officers who handle SIO exception requests, designed a tracking system, and wrote the
application in dBASE III to execute on a Wang PC.
Moshman Associates, Inc., February 1986 to October 1986, Senior Associate, Bethesda, Maryland.
- Programmer, using a WANG 2000, on a two week project to write a Basic program
which produces several reports from data contained on floppy disks created on another Wang
2000 computer. This project was part of the preparation for Dr. Moshman’s appearance in
court as an expert witness in a government suit against an issuer of student loans.
- Programmer on a four week project to write a Model 204 user program to paint
about fifty data entry screens, perform data consistency checks, manage several possible
paths through the screens, and update the Model 204 data base.
- Project leader for Agent Orange computer based military personnel records
abstracting system for the Veterans Administration. Moshman Associates' contract with
the VA required the abstracting of selected military personnel records and a study of the
long term effects of exposure to agent orange in South East Asia during the Vietnam
conflict.
- Project leader for development of a micro based system to automate the
"Metropolitan Washington Hospital Utilization Report" for the Metropolitan Washington
Area Council of Health Planning Agencies. Fifteen monthly summary reports which are
published and distributed by the Council, were programmed for production.
- Wrote responses to U.S. Government RFPs.
Control Data Corporation, September 1975 to January 1986. Senior Systems
Marketing Representative with the Business Information Services Division (February
1985 – January 1986).
- Project leader for the design and installation of a home
health agency prospective payments system funded by the Health Care Financing
Administration. The Control Data contract required the development of an automated invoicing
system that would: 1) Produce invoices to be paid by HCFA, 2) Collect data needed to test
the three prospective payment methods [there were four different methods of calculating the
amount to be paid on each invoice], 3) Do an automatic medical record screening to determine
eligibility for Medicare coverage and 4) Produce query records for Social Security to
retrieve Medicare historical data on the individual.
- Consultant Development Programmer with the Business Information Services
Division (1981 – 1985).
- National technical support contact for the Control Data field marketing
and technical staff for health care industry applications from September 1983 through
February 1985. Software and documentation was developed to aid the field technical and
marketing staffs to understand hospital management analysis applications. Data bases
consisting of more than 3 million hospital discharges per year were built and organized for
efficient retrieval and reporting.
- Lead programmer for writing a communications program for the IBM PC to
communicate with the Business Information Services Call/370 time sharing system through the
Control Data communications network from October 1982 through August 1983. This task
required building a state machine to emulate an Anderson Jacobsen 510 ASCII terminal.
- In 1981 and 1982, I developed training materials on the use of 3270 terminals,
TSO, Session Manager, and a set of TSO Command Lists (Clists) used to provide functions
unique to the Control Data Call/370 and Call/Plus environment. I developed a set of TSO
Clists to control the use of Session Manager and a Clist to automatically archive all on–line
files in a TSO user’s directory. Also, during this period, I participated on a Control Data
Service Bureau Company team set up to bid on U.S. Government RFPs for remote computer
services. My tasks were to write technical responses and to set up and run benchmarks using
the software required by the RFP. One benchmark required building a System 2000 data base
and running two COBOL programs which updated the S2K data base. Also, during this period, I
attended a class in the use of the Inquire data base system.
Project Administrator (1980 – 1981).
- Provided product support to the field technical and sales staffs for a
government budgeting package and a data base of U.S. Government grant and loan programs and
software used to access the data base.
- Represented Control Data in dealing with product vendors.
- Researched new business opportunities.
- Built an administrative system to be used by state and local CETA
offices. This application was intended to determine the eligibility of an individual for one
of several entitlement programs and track that individual through the program.
Systems Marketing Representative (1975 – 1979).
- Project leader for the development of a computer system to produce the monthly
detail budget tracking report for the United States Postal Service. This application
system produced comparisons of budget, actual, forecast, and same period last year for about
500 cost codes for each cost center in the Postal Service.
- Project leader, from January 1979 to June 1979, for the development of a
computer system to manage and track employee grievances through the union mandated
procedure at the United States Postal Service. About 200 new grievances were submitted each
week with about 5,000 grievances pending at any one time. There were about five levels of
appeal in the grievance procedure. This application was installed at postal headquarters and
in each of the postal regional headquarters.
- From 1975 to 1978 I provided technical support to the Service Bureau Company’s
Call/370 time sharing customers. The primary application areas were budgeting, cash
management, financial modeling,
small data bases and graphics.
Application packages used for
these purposes were Mini–MIS (similar to dBase), Prophet II
(similar functions to Lotus
1–2–3), and Picture Pak for graphics. These are proprietary products of Control Data
Corporation. Some example applications are: 1) Financial model of the Pentagon Federal
Credit Union, 2) Budget tracking at TRT Telecommunications, 3) Graphing data for computer
center management reports at the Association of American Railroads, 4) Linear programming
modeling at McCormack and Co., 5) Budgeting at Commercial Credit Company, and 6) Cash
management at Washington Gas Company. At any one time I had about 40 customers assigned
to my territory.
- In 1976, I converted Financial General’s IBM System 3 over to
the Service Bureau Company’s Call/370 system. Financial General had run out of capacity on
its System 3. The problem was that this machine used the "Basic Operating System" which IBM
estimated was used in less than six locations world wide.
- Taught classes in the use of Service Bureau Company Software and systems.
United States Department of Agriculture, August 1972 to September 1975, full–time programmer with the Washington Computer Center.
- Edited computer center user guide and wrote a set of formatting macros for
the ADR Extended Text Compositor text formatting system.
- Developed short courses in the use of computer center software and taught
classes. Developed training materials for and taught classes in Pansophic Systems Easytrieve
and ADR’s The Librarian. Also, taught classes in TSO and JCL.
- Wrote COBOL programs for clients of the computer center.
- Provided training and assistance to clients of the computer center.
National Bureau of Standards, August 1971 to August 1972, full–time indexer and abstractor in the Fire Research and Safety Office in Gaithersburg, Maryland.
- Indexed and abstracted literature on fire research and safety.
Bank of Bethesda, February 1971 to August 1971, full–time bank teller, Bethesda, Maryland.
Auchincloss, Parker and Redpath, March 1970 to November 1970, full–time back office clerk, Washington, D.C.
United States Army, June 1967 to June 1969, Infantry training, Company Clerk, 101st Division, Bronze Star.
Projects on Personal Computers at Home.
- I wrote a text formatting program in Janus/ADA on a CP/M 2.2 8 bit
machine (Teletek System Master) that recognizes tokens imbedded in the text and formats the
text accordingly. This technology was a dead end but the lexical parser and state machine
concepts I used are right in step with current technology implementations.
- You are viewing my resume on my personal web site. I began work on this web
site in the last half of August, 2000. What you see here has been accomplished on the odd
weekend or evening when I can rend time from three children, wife, scouts, church, etc.
Before starting on this, I had only a vague understanding of HTML and did not know what
DHTML meant or anything about JavaScript.
specialized experience and knowledge:
I’ve had some experience with everything listed here. The experience ranges from a few months
to five or more years. Those items with three or more years experience are highlighted. Those
items with experience within the last five years are underlined.
Analysis and Design Methodologies
- Yourdon Methodology Seminar training and practice
- Familiar with Gane and Sarson, deMarco, Merise, Warnier, etc.
- Have used decision tables and state tables extensively
- Business Process Redesign
Computer Hardware Expertise:
- IBM 360, 370, and 303x series
- IBM PC, XT, AT and clones
- Unisys 5000/50, 5000/80
- HPUX on HP9000 series minicomputers
- IBM System 3 (Basic Operating System)
- Wang 2000
- AT&T 3B2/600G
- S100 bus (IEEE – 696) micro computer with Z80 and CP/M 2.2
- Macintosh
Computer Software Expertise:
IBM large scale machines:
- Operating Systems: OS/MVT, SVS, MVS, Call/370
- Operating Support: HASP, JES 2, Session Manager, VSAM, TSO, SPF, OS JCL
- Languages: COBOL, Fortran, Basic, 370 Assembler
- DBMS: Inquire, System 2000, Model 204, X/L
- DMS: Mark IV, Easytrieve, Mini–MIS
- Other: Syncsort, Panvalet, Librarian, Script/VS, Extended Text Compositor,
Prophet II, SAS
Minicomputers:
- Operating Systems: Unix, Wang OS
- Languages: Basic (Wang 2000), C (UNIX), Informix 4GL, Bourne
Shell Script
- DBMS: Informix, Sybase
- Other: Word 11, JYACC JAM, SORITEC
Microcomputers:
- Operating Systems: CP/M 2.2, PC DOS 1.1 through 5.1 (MS DOS), MS Windows 3.1,
MS Windows 95, 98, MS NT 4.x
- Languages: Basic, Janus/ADA, 8088 Assembler, Z80 Assembler, Clipper, C, C++,
PowerBuilder, JavaScript, HTML, CSS, Java
- DMS: dBase III Plus, VP–info, Sybase, Lotus Notes v3, MS Office Access
- Other: MS Word, MS PowerPoint, MS Excel, VEDIT, JYACC JAM, Encore! Plus, MicroPROPHET, Project Workbench, SYSTAT,
MacDraw II, Excelerator, TurboCADD, ERwin/ERX, XCase, LOTUS 1–2–3, WordPerfect
