Stephen Mcleod Email & Phone Number

Ft. Belvoir, Virginia

Design, build, train, and maintain decision support applications for the acquisition directorate at a DoD agency. These are built using Microsoft Office Excel and Access with both imported data and user input.

Designed and built decision support database and reporting for acquisition and contracting directorate in DoD agency. Data imported from production computer systems and imput by users. Application built using MS Excel and Access with considerable VBA code.

Currently doing web site development using Ajax and application development using Microsoft Office Excel and Access.

• In support of Air Force Long Range Plans, I 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. I added new data structuring and option building tools

• In support of the Space Intelligence Community, I redesigned and rewrote 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.• In support of the Space Intelligence Community, I completed a proof of concept demonstrating that Cost Estimating Relationships (CERs) can be stored in a Relational Data Base Management System (RDBMS), retrieved and executed.• I designed and built a Contracting Officer Task Representative (COTR) contract management application which provides the current status of contracts and also tracks the changes to the contracts over time. This application uses linked list in an RDBMS to give the user the capability to move back and forth in time via navigation buttons. Planned, obligated, committed, and expended funds are tracked by appropriation and Contract Line Item Number (CLIN).• I took over maintenance of an existing time-keeping application and made significant changes to reporting and data validation.• I took over maintenance of an existing generic cost model and made several significant new features and improvements.

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.

• I 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.

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. he 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. 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.

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.

My primary duty was to canvas for new business. In addition I worked on a variety of projects in a technical capacity.

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.

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.

M.S.T.M., Computer Systems, Information Science

Activities and Societies: Working full time at Department of Agriculture. Bicycle to work and school.

A.A., Computer Systems

B.A., History, Political Science

Activities and Societies: Tau Kappa Epsilon, Debate Team