Johnothan Rears

Colonial Beach, Virginia, United States

jrears@hotmail.com (208) 550-3168

Summary

Operations research and technology are my favorite areas to use and develop methods in solving problems. Let’s change this world to something better than how we found it. We get to decide together what better means.

Experience

Technical Lead; Management & Program Analyst, Operations Research Analyst, Certified Data Scientist

Federal Aviation Administration, Air Traffic Services

Sep 2016 - Present (5 years 8 months +)

Transferred to Air Traffic Services in October 2019. Now a Technical Lead on numerous projects.

Advisor and developer of tools, data, analysis, with some IT and web support roles.

Active role as a Mentor and a Mentee in the DOT program.

Active on numerous working groups to build on the frameworks for data governance and standards, AI/ ML standards with other Agencies, some cloud and data center initiatives.

Admin for KSN Share Point, Public and Internal Web Sites, Tableau Server, and support for ArcGIS and other application platforms for our division.

Working on developer projects throughout the FAA on collaborative teams. Current projects include Data Management frameworks for governance, standards, metadata management, integration of tools, building analytical training sets, robotics process automation, cloud development on Azure and AWS cloud with some administrative duties as well. Preparing for migration of web sites to Drupal while maintaining current cold fusion based systems. Creating User, Admin and Developer Guides for the tools we use, and lots of fun, engaging, empowering teams. The work environment is changing rapidly for the better.

Past in Des Moines, WA for Aircraft Certifications:

System Analysis and Decision Support.

Learning the Aviation Industry, assisting leaders in decision making, empowering and being empowered creating cultural and functional transformation.

Developing options for data driven and risk based initiatives.

Creating standards and governance for data systems. Working on complete data inventories, metadata, etc. to better use these sources.

Working several initiatives for cultural transformation.

Transforming data into analytical sets.

Using data science methods to inspire innovation.

IT Specialist (Data Management)

USDA Animal and Plant Health Inspection Service (APHIS)

Feb 2015 - Sep 2016 (1 year 8 months) Projects:

1. Staffing, Inventory, and Maintenance Databases: Updating /

Fixing Interface for Multiple Users. Added tracking / auditing functionality.

Added time keeping elements.

2. Sample, Survey, and Regulatory Databases: Creating Global VBA libraries of common elements,tweaking and fixing code. Adding and creating new elements and objects.

Creating documentation. These are Access Front End and SQL Server Back End based.

3. Using Microsoft SQL Server Management Studio and Reporting Services tools for work with SQLServer Databases.

4.Using IBM Cognos with Oracle for Global APHIS IPHIS Database.

5.Group Participation: Data Governance Working Group;

Data Manager Work Group;

Apple iDevice & Mobile Testing;

Data Analysis and Reporting;

And several IT Improvement Programs.

Summary:

Maintaining current databases and creating documentation.

Updating and maintaining User Requirements and finding innovative ways to improve these and other IT related functions.

All Data Sets: Cleaned up and created validation rules.

Standardized error checking and other Visual Basic for Applications (VBA) modules libraries and some Macro parts.

Most Macros converted to VBA to extend capabilities.

Created numerous Forms for Input of data, filtering by form, formatting, etc. Similar libraries made for Reports.

Created numerous standard procedures in SQL Server.

Mathematical Statistician

U.S. Department of Transportation

Oct 2011 - Feb 2015 (3 years 5 months) Projects & Teams:

1. Data Analysis and Report Team (DART): Provide information to our clients through this web interfacesystem.

2. Analytical Support: Develop data user and analytical guides, develop scripts for Oracle 11gR2 databases and SAS data sets. Work on several policy and regulation projects in various support roles. Participate in Research projects, Participate in the development of the Business Intelligence Tools, Create and maintain libraries and documentation. Provide numerous reports and presentations for management.

3. Geographic Information Systems (GIS): Create templates and numerous map solutions formanagement. I am the key representative in this area for FMCSA. Participate in GIS related events. Provide any and all GIS related support.

Co-Author: Safety Analysis and Industry Impacts of the Pre-employment Screening Program (PSP)

Highlights - Summaries of Projects:

. Produce numerous ad-hoc Analysis Reports.

. Research Study on Exemption Ruling for Farmers.

. Business Intelligence Tools and Performance Metrics Development.

. Assist in IT Installs, Configurations, and Updates for SAS Enterprise and TOAD for Oracle products. . Data Information Development for MCMIS, CSA/SMS, EMIS, and other databases.

. Developing Arc GIS Server Web Applications using Microsoft Silver Light API's, Visual Studio 2010, DOJO Java Scripts, and Adode FLEX API's. Resident Expert in Arc GIS tools and creating visual insights from these. Develop map sets, layers, presentations, and other Literature for MCMIS and FARS data.

Operations Research Consultant

Rears Consulting

Aug 2008 - Oct 2011 (3 years 3 months)

Freelance Consultant using methods of operations research to solve problems.

Primary areas:

1. IBM SPSS Statistics

2. Telecommunications systems.3, Microsoft SQL Server.

4. General Networking.

5. Programming scripts for automation tasks.

6. Supply Chain Management.

7. Math Programming Models.

8. Discrete Optimization and Simulations.

9. Transportation and Scheduling Models.

10. Documentation of all processes from setup of systems to Standard Operating Procedures forAdministrators and End Users.

Adding SAS and Oracle Certifications soon as well to enhance my OR toolbox. Expanding my use and abilities with Microsoft Share Point Services and other great collaboration tools.

Consultant, SPSS, Operations Research

MSA Group

Dec 2010 - Jan 2011 (2 months)

Updating to IBM SPSS Statistics 19 Server. Porting all data to new system. Assisting end users on using the new system. Providing strategy and decision support. Finished with this project, now onto others.

Telecom & PC Technician

Comport Communications, LLC

Feb 2009 - Dec 2009 (11 months)

PC, POS, and telecommunications systems repair, diagnostics, install, updates. Regularly install networks and telecommunications systems around the area.

Onforce Service Professional

Data Shaping Analytical Professional

Dell Certified Wireless (WiFi) Service Technician

Service Live Professional for Sears

Operations Research Analyst

Navy Recruiting Command

Jul 2003 - Apr 2006 (2 years 10 months)

Assisted leaders in making hard decisions. Delegated as Web Master and Database Administrator for the Demographic, Geographic, Statistical Data Sets used by the command in analysis. Worked on numerous projects, including realignment of Recruiting Districts, population and demographic statistics, project lead on the Enlisted Forecasting and Goaling Models, etc. Received numerous monetary and other awards for achievement and providing quality service.

Operations Research Analyst

Army Maneuver Support Center

Jul 2000 - Sep 2002 (2 years 3 months)

Developed simulations, databases, requirements documentation and analysis. Assisted in the decision making process for Military Police, Combat Engineers, and Chemical Corp.

Completed numerous Operations Research / Systems Analysis courses provided by the Department of Defense. These include:

Operations Research / Systems Analysis - Military Applications Course (ORSA-MAC), ORSA-TAC, Risk Analysis, Decision Analysis, Multi-Objective Decision Analysis, Combat Developments, Leadership, and others.

Chemist

Navy Fleet and Industrial Supply Center

Jul 1992 - Oct 1995 (3 years 4 months)

Performed quality control testing of petroleum products.

Developed a hazardous materials and waste site.

Automated lab.

Created a Laboratory Information Management System (LIMS) using DBASE and Clipper. Created a quality assurance standard operations procedure manual.

Certified HAZWOPER 1995

Mathematician

Army National Guard

Jan 1991 - Jan 1992 (1 year 1 month)

Created numerous graphical user interface routines for SGI IRIX environments. This included several modular precursor object oriented design methods before these languages were readily available. Almost all of this work was done in ANSI C and compiled using standard UNIX command line compiler and make files.

Created machine translation routines for communications between different operating systems and hardware platforms.

Created standardized math libraries in Fortran and C.

Wrote hundreds of UNIX OS scripts in C and Borne forms. Created JCL Batch Files for Gould / Encore Mainframes. Created DOS Batch Files for PC's.

Used primarily for translation and conversions from one type of field system and another.

Lab Aide, Tutor, TA

Lewis-CLark State College Jan 1985 - Dec 1990 (6 years) Tutor in math and science in Chemistry, Physics, and Geology. Lab aide in Mathematics, Computer Science, Chemistry. TA in Mathematics.

http://www.lcsc.edu/

Unit Supply Specialist

US Army

Aug 1980 - Aug 1983 (3 years 1 month)

Unit Supply Specialist & Small Arms Repairman with B Co 2/22 Infantry.

Education

Florida Institute of Technology

MS, Operations Research

2001 - 2007

Mathematical Statistics

Deterministic OR Models

Stochastic OR Models

OR Practica

Mathematical Programming

Theoretical Stochastic Processes - Probability Models

Discrete System Simulations

Discrete Optimization - Integer Programming

Quality Assurance

Reliability Analysis

Applied Statistical Analysis - Advanced Stats

Army Logistics Management College

ORSA Certifications, Operations Research / Systems Analysis

2000 - 2001

Operations Research / Systems Analysis - Military Applications Course (ORSA-MAC)

Operations Research / Systems Analysis - Technical Applications Course (ORSA-TAC)

Decision Analysis Course

Risk Analysis Course

Combat Developments Course

Multi Objective Decision Analysis

Technical Writing

Intern Leadership Development Course

Action Officer Development Course

Joint Conflict and Tactical Simulation (JCATS)

One SAF Simulations

Terrain Mapping for simulations using ArcGIS, AutoCAD, and Micro Station formats

University of Idaho

None, Engineering, Education

1978 - 1991

Subjects focus: Engineering and Education (Teaching)

Lewis-Clark State College

Bachelor of Science - BS

Jan 1985 - Dec 1990

One of the best small colleges in the world.

Lewis-Clark State College

BS, Mathematics, Chemistry, Education

1985 - 1990

Research Projects:

Nuclear Magnetic Resonance (NMR) Spectroscopy Simulations on the Mac. Assisted on Chemistry Grant for two HP Gas Chromatography Machines.

Tutor: Math, Computer Sciences Lab, Chemistry Lab, Physics, and Reading.

Licenses & Certifications

Certified Data Scientist - Data Science Central

Skills

Operations Research • Analysis • Business Process Improvement • Data Analysis • Business

Intelligence • Statistics • Database Administration • Web Development • Web Analytics • Business

Strategy