|
February 9, 2009
|
Stephen D. McLeod
6472 Georgetown Road
Broad Run, Virginia 20137
|
cell: 540-622-4444
land: 540-347-1865
smcleod@broadrunit.com
|
Functional experience: I have special qualifications in, firstly,
Cost and Economic Analysis using financial and statistical modeling. Secondly, I am also experienced in general ADP system design and development in all phases of the Software Development Life Cycle (SDLC) plus participation in a SEI/CMM level 3 certified project using a variety of tools including database design and development and building interfaces between legacy and client server systems. These are complementary skills as the enterprise data and applications provide the source of historical data for the business model. I have special qualifications in DoD procurement.
Professional: Certificate in Dataprocessing (1978).
Software experience: MVS, TSO, CLIST, JCL, COBOL, 370 assembler, Macros, Fortran, Easytrieve, VSAM, Syncsort, Panvalet, Librarian, Script/VS, Extended Text Compositor, SAS, UNIX, Shell Script, C, Sybase, Transact SQL, Embedded SQL, CT-Library, Informix, Windows NT, Windows 2000, PowerBuilder, Visual Studio, dBase, MS Word, Excel, PowerPoint, Access, Excelerator, Visio, Lotus Notes, ERwin/ERX, 8086 assembler, Z80 assembler, SYSTAT, WordPerfect, VEDIT, Encore! Plus, JavaScript, HTML, DHTML, CSS.
Methodologies: Yourdon, Gane and Sarson, deMarco, Merise, Warnier, etc.
Objectives: I am looking, firstly, for an employer or clients who recognize the value of sophisticated business planning models that accurately represent the business processes of the enterprise. I am looking, secondly, for an employer or clients who recognize the value and risks of integrating otherwise separate ADP applications and databases. Thirdly, I am looking for an employer who can use my many years of experience.
I am familiar with HTML, JavaScript, DHTML, etc. as you can note by checking my web site at
http://www.broadrunit.com/ or my church web site at http://www.goodshepherdaoc.org/ You will find detailed information and work examples in my detailed resume as well as
detailed hardware and software experience.
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
security clearance
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 present
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 rewritten 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 present
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 task completed the requirements and made the total application system run in the client's working environment. The work required knowledge of the DoD procurement process and the processes at the Defense Logistics Agency. 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
At AMS I was a member of the professional staff. My assignments varied
considerably depending on the contracts and clients. My duties included:
- Computer system design and development;
- Business Process Re–engineering;
- Financial Modeling;
- General System Analysis;
- Writing reports and technical sections of responses to RFPs; and
- Project management support.
Clients included:
- U. S. Army Cost and Economic Analysis Center;
- U. S. Navy Shipyards;
- Defense Supply Center Philadelphia, Medical ICP; and
- Defense Information Systems Agency.
Moshman Associates, Inc., February 1986 to October 1986, Senior Associate, Bethesda, Maryland.
My primary duty was to canvas for new business. In addition I worked on
a variety of projects in a technical capacity.
Control Data Corporation, September 1975 to January 1986. Senior Systems
Marketing Representative with the Business Information Services Division
The first five years of my ten years with Control Data Corporation were
as a commissioned technical representative. I received the same sales
training as the marketing representatives and supported them in closing
new clients. I was responsible for training client personnel and
growing the revenue in the client base. This I did with some success.
Clients included:
- Banks and other financial institutions;
- Manufacturing; and
- Utilities.
The second five years were as a salaried technical staff. I designed
and developed new applications and supported the marketing people
in finding and closing new business and did training.
United States Department of Agriculture, August 1972 to September 1975, full-time programmer with the Washington Computer Center.
At the USDA I was part of the technical support staff at the main
computer center. I wrote a users' manual, developed and taught
technical courses, wrote COBOL code, etc.
National Bureau of Standards, August 1971 to August 1972, full-time indexer and abstractor in the Fire Research and Safety Office in Gaithersburg, Maryland.
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.