Software Engineer

MARK TENNENHOUSE

Troy, MI *****

248-***-**** ● ********@*******.***

Certified Project Management Professional with over twenty years of experience in software engineering and information technology. Ten years of experience programming VBA code for MS Excel and Access. Experience in software administration, scheduling, reporting, development, V&V, and quality assurance. Involved in every stage of the software life-cycle, from requirements gathering and software design to validation and verification. Prepared test plans, cases, procedures, and traceability matrixes for manual and automated testing. Supervised teams of engineers to complete project tasks on schedule and under budget.

TECHNOLOGY

Operating Systems: MS Windows, UNIX, MS-DOS, Macintosh

Software: MS Office, MS Word, MS Excel, MS Access, MS PowerPoint, MS Project, MS Outlook, MS Visio, Deltek Open Plan, Deltek Cobra, WelcomHome, Oracle Essbase, Planisware, Visual Studio, Adobe Acrobat, Adobe Dreamweaver, Acumen Fuse, Oracle, ParaSoft C++ Test, Mindjet MindManager, Resource Standard Metrics, Telelogic DOORS

Languages: C, Visual Basic, VBA, HTML, SQL, ProC, Pascal

EXPERIENCE

SOFTWARE APPLICATION SPECIALIST: April 2017 - December 2018

General Motors Propulsion Systems, Pontiac, Michigan

employed as Optimal Engineering and Staffing contractor

· Recipient of GM High Performance Recognition Award, Jan. 2018.

· Created one-touch VBA algorithms to save time & money generating Excel reports.

· Developed algorithm to generate weekly reports from Engine and Transmission Schedule data.

· Created application to process Global Development Test Allocation data and simulate GANTT charts.

· Developed a tool in Excel VBA to help measure throughput on the build floor.

APPLICATION DEVELOPER: 2013 - 2017

Ford Motor Company, Dearborn, Michigan

employed as Advantage Technical Resourcing contractor

· Fixed errors in VBA in-house software that facilitated Oracle Essbase operation within MS Excel 2010.

· Prepared upgrade package to allow Windows XP clients to use Essbase software in the Windows 7 environment.

· Created one-touch algorithm in Excel VBA to generate a Skill Team Investments report.

· Developed database in MS Access with accompanying front-end graphic user interface.

· Automated GANTT-chart simulation of IE Work Load program schedule in Excel.

· Developed VBA macros to automate preparation of Excel spreadsheets for import into Planisware database.

· Updated and maintained financial models in Excel VBA.

· Created algorithm to populate Pivot Table with Planisware data, and gave team presentations to demonstrate how to use it.

· Fixed errors in Excel VBA chart application for client in Venezuela.

GENERAL DYNAMICS LAND SYSTEMS

Sterling Heights, Michigan: 2006 - 2013

employed as G-TECH contractor until direct hire on August 20, 2007

TECHNICAL SPECIALIST, INTEGRATED PROGRAM PLANNING & ANALYSIS

· Improved efficiency by converting the weekly executive summary report from a four-hour task into a one-touch VBA process that took five minutes.

· Developed VBA macros in Excel and Access to automate analysis of schedule information.

· Created VBA application in Excel to automate graphical update of the "Dashboard Dials" report.

· Audited schedules using Excel VBA algorithm to automate the "check filters" of the program schedules.

· Maintained and analyzed project schedules for General Dynamics.

· Performed ad hoc reporting as needed.

· Corrected errors and inconsistencies in Future Combat Systems’ project schedules.

· Monitored time sheet accuracy of co-workers as a member of the "Army of Auditors" team.

· Attended "Deltek Insight" technical conference and software expo in 2009, 2011, and 2012.

TECHNICAL SPECIALIST, EARNED-VALUE MANAGEMENT SYSTEM

· Developed Smart Charge Code Generator (SCCG) in VBA for MS Access to automate the selection of Charge Codes.

· Created Excel VBA process to calculate DCMA 14-point Metrics in five seconds.

· Developed Excel VBA macro to evaluate company-wide compliance for Estimates to Complete (ETC).

· Served as the EPM administrator for the Deltek suite of scheduling and finance software.

· Managed the upgrade of the Deltek Cobra and wInsight software.

· Automated the update of the Schedule Health Metrics Report for all GDLS programs.

· Updated the EVMS Finance web portal using HTML code in the Dreamweaver environment.

REQUIREMENTS ADMINISTRATOR

· Developed DXL scripts to convert Telelogic DOORS files into Microsoft Word documents.

· Served as direct liaison to the Reconnaissance Surveillance Vehicle (RSV) division.

· Generated requirements documents for departmental use at General Dynamics Land Systems.

SOFTWARE ENGINEER: 1997 - 2006

CriTech Research, Inc., Ann Arbor, Michigan

Management:

· Led a team of five engineers assigned to update and execute software system tests for medical documentation software. Completed project $25K under budget and on schedule.

· Supervised staff in unit testing of neurological stimulation software. Completed project $35K under budget and two weeks ahead of schedule.

· Managed full validation & verification of wireless electrocardiogram software.

· Created project management plan at the outset of each project describing the intended scope, milestones and deliverables.

· Created master test plan and test design to outline the processes involved in software system testing, integration testing, and unit testing.

· Traveled to client sites nationwide to gather software and project requirements.

Development & Engineering:

· Developed in-house application that formatted and baselined customer documents.

· Analyzed system specifications and functional requirements to gather test requirements.

· Retroactively developed software requirements, design, and architecture per ISO standards.

· Created traceability matrix to link requirements to designs, test procedures and log files.

Quality Assurance:

· Performed software testing on mobile meteorological system under direct supervision of U.S. Department of Defense. · Completed test efforts significantly ahead of schedule.

· Created test scripts in C++ for use with the ParaSoft automated testing tool.

· Performed formal inspection of C/C++ code to evaluate adherence to quality standards.

· Created test cases and procedures for portable defibrillator embedded software.

· Developed, executed and logged software system tests to validate software requirements.

· Executed multiple rounds of regression testing on wireless electrocardiogram software.

LEVEL III PROGRAMMER, 1995 - 1997

Rouge Steel (contracted by Entech), Dearborn, Michigan

· Created representation of Liquid Metal Management System in Windows graphics interface.

· Developed ProC application involving C and SQL code to organize and classify outgoing steel mill orders.

· Developed algorithm to determine time schedule of the Liquid Metal Management System.

· Provided system support on-call 24 hours a day, 7 days a week.

SOFTWARE ENGINEER, 1994 - 1995

DataViz Inc., Trumbull, Connecticut

· Fixed errors in DataViz file translation software.

· Tested newly developed software to ensure that it satisfied quality requirements.

· Solved problems of DataViz customers via phone support.

· Assisted with the installation and maintenance of network hardware and software.

ASSISTANT IN RESEARCH, 1990 - 1992

University of Michigan EECS Department, Ann Arbor, Michigan

· Developed FORTRAN software which computed the optimal design of experiments for statistical prediction.

· Researched capabilities of optimization software and studied results of fitting a linear equation to a quadratic model.

· Discovered that the optimal 5-point design for fitting a parabola was asymmetric, improving upon previously published results.

EDUCATION

PROJECT MANAGEMENT INSTITUTE

Project Management Professional (PMP)

Certification received December 2006, renewed through December 2019.

THE UNIVERSITY OF MASSACHUSETTS, Amherst, Massachusetts

Master's Degree in Engineering, Computer Systems Engineering

Degree received May 1994.

THE UNIVERSITY OF MICHIGAN, Ann Arbor, Michigan

Bachelor of Science in Engineering, Computer Engineering

Bachelor of Science in Engineering, Electrical Engineering

Degrees received December 1992.

PUBLISHED WORK

Co-authored paper on the optimal design of experiments, published and presented at the 10th International Symposium on Computational Statistics (Neuchâtel, Switzerland, August 1992).

Created an original, six-panel comic strip published in multiple Massachusetts publications.

Contact this candidate