MARK J. TENNENHOUSE

Troy, MI *****

248-***-**** ● adw2ys@r.postjobfree.com

Certified Project Management Professional with over twenty years of experience in software engineering and information technology. Fifteen years of experience programming VBA code for MS Office suite. 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, Deltek Acumen Fuse, WelcomHome, Oracle Essbase, Planisware, Visual Studio, Adobe Acrobat, Adobe Dreamweaver, Acumen Fuse, Oracle, ParaSoft C++ Test, Mindjet MindManager, Resource Standard Metrics, DOORS

Languages: C, Visual Basic, VBA, HTML, SQL, ProC, Pascal. Training for Java Certification.

EXPERIENCE

SCHEDULER AND RISK SPECIALIST: August 2021 – present

American Rheinmetall Vehicles, Sterling Heights, Michigan

· Perform the critical project schedule development process in the execution of large complex combat vehicle development programs.

· Prepare and maintain program schedules in Open Plan involving Earned Value Management.

· Lead the risk process within the product development team to include risk identification and the development of risk mitigation strategies.

· Maintain the program risk and issue register and provide updates to both internal and external stakeholders.

· Utilize Acumen Fuse in the execution of Risk and Issue Management process for a USG contract.

· Ensure the risk mitigation plan is fully implemented in the Open Plan program schedule.

· Work in conjunction with Project Finance to create meaningful reports and provide analysis.

BAE SYSTEMS

Sterling Heights, Michigan: June 2019 – April 2021

EVMS SCHEDULE ADMINISTRATOR AND RISK BUSINESS ANALYST

· Served as software administrator and subject-matter expert for Deltek products, including Open Plan and Acumen Risk.

· Implemented data forensics and troubleshooting skills for up to twenty projects at once.

· Served as first-level support for the Deltek end-user community at multiple branches of BAE Systems.

· Supervised conversion process of MS Project schedules into Deltek Open Plan format, and vice versa.

· Performed Open Plan regression testing during rollout of PM Compass software.

· Invented time-saving algorithm to consolidate multiple Open Plan schedules to enable compatibility with PM Compass.

· Generated EVMS compliance metrics reports from Acumen Fuse.

MASTER SCHEDULER

· Created Open Plan schedules for multiple BAE programs to monitor the status of their projects.

· Created one-touch VBA algorithm to automate financial reports, saving time and money for the company.

· Developed VBA algorithm to track Earned-Value Type classification errors.

· Created Milestone Reports to assess expected Finish dates trend directions, and “float” for each program.

· Completed Deltek Acumen 3-Day Training Seminar.

· Completed Humphreys & Associates 3-Day EVMS Training seminar.

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: November 2013 - April 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: October 2006 - October 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: June 1997 - August 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, August 1995 - April 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, June 1994 - June 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, May 1990 - December 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