Project Manager Air Force

MR JORDAN GOLDMEIER

contact

**** ***** ** ********* ***** MVP

Dayton OH 45419

aca8fy@r.postjobfree.com profile

+614-******* Seasoned analyst and creative software developer with experience in the successful execution

of business tools, models, and data visualization products.

• Subject matter expert for data visualization, data communication, and

decision support tool development.

• Strong background in the application of mathematical methods, heuristics,

linear programming, statistics, and computational methods.

• Software developer with experience in web technologies (e.g. jQuery, PHP,

HTML 5, MVC) and application development (.Net, Java, C

• Recognized Microsoft Excel MVP, Excel blogger, and book author.

Expertise

Visual Basic for Applications analytical/decision support tool development data

visualization, presentation, and communication software development

work experience

Business The Perduco Group Dayton, OH Feb 2012-Present

Analytics Project manager responsible for execution and delivery across defense, commercial,

Developer and health care markets. Technical lead in data visualization and implementation of

operations research methods to support senior-level decisions.

Selected Contributions

• Delivery of decision support web application for Navy Explosive Ordinance

Disposal. Year-long effort provided data analytics and visualization of 70

metrics to United States Joint Services.

Operations Booz Allen Hamilton Dayton, OH May 2009-Feb 2012

Research Analyst Key role as VBA Expert and software developer for the Center for Operational

Analysis at the Air Force Institute of Technology. Transitioned university research

into interactive applications and authored studies for Department of Defense clients.

Presented research to high-level personnel in US government.

Selected Contributions

• Coauthored study on effects of proposed FAA rule changes to flight-duty

periods for fatigue mitigation on military missions using chartered

commercial aircraft. (see studies)

• Developed Personnel Assessment Management System, Excel-based tool, for

NATO Training Command-Afghanistan to track transition progress from US

forces to capable Afghan military. Traveled to Kabul, Afghanistan to brief then

Commanding General of NATO Air Training Command.

Student Auditor Air Force Audit Agency Dayton, OH May 2007-April 2009

Conducted fieldwork, interviewed client, aggregated data, outlined findings,

proposed recommendations, and authored reports. Applied data mining and

databases experience to test for over purchases, verify accuracy of million-dollar

contracts, and assess operating security and effectiveness. Acted as technology

administrator, providing computer and MS Office support.

Selected Contributions

• Discovered over $60 million in savings to Air Force due to overpurchasing

through data analysis.

• Developed new agency-standard toolbar for Office 2007 for over 700 users.

Presented to Auditor General and traveled to operations directorate in

Washington DC to personally work with information officer.

Internship Profound Logic Inc Centerville, OH Dec 2006

Coded and developed web-based emulator of IBM iSeries AS400 terminals.

education

Bachelor of Science Wright State University Fairborn, OH June 2009

in Business Double Major Accountancy, Finance

Minor Computer Science

p ublications and speaking engagements

Dashboards and Decision Tools with Excel

Apress Publishing, Planned release in Feb 2014

Currently writing a book on developing dashboards and decision support tools with

Microsoft Excel.

Introduction to Data Visualization

Dayton Regional STEM School, Mar 2013

Volunteer speaker on the science, importance, and effective communication of data

visualization for students in technical writing.

CRAF Crew Rest Study: Proposed FAA Changes, Jan 2011

Study received wide distribution on Capitol Hill, presented in senate subcommittees

and cited in HR 1540: National Defense Authorization Act. Referenced by the

Associated Press and Bloomberg BusinessWeek

Advanced Excel for Analysts Workshop

Analysis, Assessments, and Lessons Learned (A2L2) Symposium in Dayton, Ohio.

Oct 2010

Workshop on developing advanced components and dashboards with Microsoft

Excel. Delivered workshop to several other organizations, including the Air Force

analytics community at the Pentagon, but not as an official conference speaker.

awards

Oct 2013 Microsoft Most Valuable Professional (MVP) in Excel

Microsoft

Recognized as part of a highly select group of Excel experts who share a

commitment to community and a willingness to help others.

ModelOFF Financial Modeling World Championship

Top 20%, Round 1

May 2011 Performance and Team Award

Booz Allen Hamilton

In recognition of developing an automated transition prototype for the Combined Air

Power Transition Force used for the transition of the Afghan National Security Force.

Apr 2009 Air Force Notable Achievement

Air Force Audit Agency

Awarded for analysis and data-mining resulting in audit savings to Air Force of over

$60 million.

Mar 2009 Air Force Notable Achievement

Air Force Audit Agency

Awarded for development of new macro toolbar.

High School Business Profesionals of America

First in Ohio (Sixth in Nation) Visual Basic Programming Competition.

Fourth in Ohio Java Programming Competition.

developer skill set

Theory Semantic Code, Data Structures, Algorithms, Abstract Data Types, Graph Theory,

Computational Complexity, Information Visualization, Dashboard Design

Programming Java, C++, C#, .Net, Visual Basic, RPG, L TEX, HTML 5, SQL, XML, Javascript/jQuery,

A

Languages PHP, some Ruby on Rails

Data Visualization HTML Canvas, SVG, Raphael, HighCharts, Tableau, JMP

Servers Unix, Linux, Apache, IBM iSeries AS/400

certifications

May 2008 United States Security Clearance (Active)

Certified Microsoft Office Specialist

Mar 2004

2

p ersonal endeavors

Option Explicit VBA Blog

Owner, started Oct 2010

http://optionexplicitvba.com

A blog of Excel, dashboards, Visual Basic for Applications, data analysis, operations

research, and visualizations.

Data Visualization Products

• Minding the Gap: A portrait of American capital disparity

http://www.visualizing.org/visualizations/minding-gap

From the description: Behind the numbers, America’s per state homeless

population is hiding the unreported story of a vast inventory of unoccupied

homes.

Static infographic created mostly with Microsoft Excel.

• The Personal Fabric of Global Crisis: Weaving individual stories into

national snapshots

http://www.visualizing.org/visualizations/personal-fabric-global-crisis

From the description: Our goal is to provide an equally-immediate reflection

of the attitudes in each of these countries, using the Global Pulse’s data. You’ll

see a patchwork of lines that weaves together how individuals feel about the

changing economic situation in their country with how difficult it is for these

individuals to meet their needs. Each line is an individual, and each cluster is

a shared feeling.

Uses Canvas, Raphael, and AJAX calls to Google spreadsheets.

October 30, 2013

3

Contact this candidate