1552 S 1100 East, Salt Lake City, Utah 84105
Highly analytical and process-oriented professional, with hands-on experience in data analysis, database and software tools development, data extraction, filtering, and importation process automation, as well as computer programming
Growth-driven individual, seeking a challenging position to fully utilize knowledge and skills honed from continuous educational pursuits and work experiences. Capable of utilizing programming languages in creating codes to deliver accessible data to support organizational decision-making and strategic planning. Armed with in-depth knowledge of statistical techniques, along with critical thinking and problem-solving skills in translating research data to formulate and recommend cutting-edge plans and solutions to consistently achieve project goals and objectives. Equipped with solid interpersonal skills in building positive and long-term relationships with all levels of professionals.
Areas of Expertise
Algorithm Development | Data Collection and Processing | System Administration | Trends Visualization
Linear and Non-linear Regression Analysis | Team Leadership and Training | Database Management
Risk Management | Financial Market Estimation
Doctor of Philosophy in Geology, 2019
University of Utah | Salt Lake City, UT
Master of Science in Geological Sciences, 2009
The University of Texas at Austin | Austin, TX
Geology Department Best Master’s Thesis Presentation Award
Bachelor of Arts in Near Eastern Studies, 2003
The Johns Hopkins University | Baltimore, MD
Phi Beta Kappa Distinguished Military Graduate
University of Utah | Salt Lake City, UT
Graduate Teaching and Research Assistant August 2009 – May 2021
-Led efforts in increasing lab sample throughput and enabling analysis of non-traditional samples through development and validation of new geochemistry lab techniques
-Designed various Excel and Visual Basic-based products to streamline geochemical data importation, filtering, and processing that allowed extensive data distribution among laboratory clients
-Capitalized on knowledge of inversion and optimization theory in creating novel data processing algorithms to obtain information from the measured geochemical data as well as to enable the following processes:
-Deblurring of low signal-to-noise ratio time series data;
-Deconvolution of chromatography data for high-precision isotope ratio measurements; and
-Calibration of non-linear mass spectrometer detector behavior without the use of costly calibrated standard
-Initiated the preparation and analysis of geological and biological samples for elemental composition and heavy isotope ratios
-Demonstrated effectiveness in conceptualizing new chemical, analytical, and mathematical techniques for problem identification and resolution
University of Texas at Austin| Austin, TX
Graduate Teaching and Research Assistant August 2007 – August 2009
United States Army | Fort Hood, TX 2003–2007
Battalion Intelligence Officer (S2)
Battery Executive Officer
Field Artillery Platoon Leader
Deblurring Laser Ablation Mass Spectrometry Data
Main Objective: Development of a deblurring algorithm for the elimination of measurement-based blurring in spatially-resolved Laser Ablation Inductively Coupled Plasma Mass Spectrometry (LA-ICP-MS) elemental and isotope ratios.
Software Used: MATLAB to solve iterative, regularized linear inversion problem. Improved efficiency of overall program by using an adaptive algorithm to automate model selection for a series of sub-problems based on the relevant selection criteria (Akaike Information Criteria and Unbiased Predictive Risk Estimator).
Strontium (Sr) Isotope Ratio Measurement Automation
Main Objective: The adaptation of a commercially-available automated chromatography sample introduction system to drive automation of Sr isotope analysis on a Thermo Neptune ICP-MS, as well as improvement of sample throughput and data accuracy by processing chromatographic data with a deconvolution algorithm.
Software Used: Excel and Visual Basic to import data while facilitating outlier filtering, iterative mass-bias isotope ratio correction, and data visualization of routine samples. MATLAB for filtering and non-linear inversion of blanks, samples, and standards for non-typical sample sets (High Rubidium and/or large variations in Sr isotope ratio).
Mass Spectrometer Ion Counter Calibration
Main Objective: Creation of an improved method for the calibration of a dead-time and non-linearity correction for the Thermo Neptune ICP-MS ion counters.
Software Used: MATLAB to filter measured data and fitting to an existing theoretical model using non-linear inversion.
Uranium-Thorium (U-Th) Radiometric Dating for “Dirty” Samples
Main Objective: Formulation of a sample preparation approach and computational scheme for the application of U-Th radiometric dating to samples with high detrital Th, along with measurable hydrogenous Th, which were previously undateable.
Software Used: Excel and Visual Basic to import and filter data. Visual Basic to estimate the projected blank correction for continued Th rinse from the mass spectrometer by non-linear regression as well as to solve the transcendental age equation.
Uranium-Lead (U-Pb) Detrital Zircon Geochronlogy
Main Objective: Establishment of both analytical and computational methods for U-Pb radiometric dating of detrital zircon with high throughput.
Software Used: Visual Basic to solve transcendental age equations and for Monte Carlo simulation of uncertainty for strongly non-normally distributed variables.
Automate Geochemistry Data Processing Main Objective: Implementation of Excel and Visual Basic-based products for the automation of geochemical data import, filtering, and processing for a wide range of laboratory clients.
Software Used: Visual Basic to batch import and process tens-to-hundreds of data files from each analytical session, as well as solve non-linear data corrections unique to each chemical system.
Courses Google, 2021
- Python Course
- IBM Data Science Professional Certificate, In Progress
United States Army, 2001-2004
- Jump School | Field Artillery Officer Basic | Environmental Coordinator
Iowa State University, 2007
- Geology Summer Field Camp
Thesis and Dissertation
Mackey, G.N. (2009). Provenance of the South Texas Paleocene-Eocene Wilcox Group, Western Gulf of Mexico Basin: Insights from sandstone modal compositions and detrital zircon geochronology [Master’s thesis, University of Texas at Austin]. Texas ScholarWorks. http://hdl.handle.net/2152/ETD-UT-2009-08-206
Mackey, G.N. (2019). Refining geoanalytical data with inverse theory [Doctoral dissertation, University of Utah]. Digital Library. https://collections.lib.utah.edu/ark:/87278/s6v6wagq
Mackey, G.N. (2010, April 13). Provenance of the South Texas Paleocene-Eocene Wilcox Group, Western Gulf of Mexico Basin: Insights from sandstone modal compositions and detrital zircon geochronology [Section talk]. American Association of Petroleum Geologists, New Orleans, LA.
Mackey, G.N. (2011, December 7). High throughput Sr isotope analysis using an automated column chemistry system
[Poster presentation]. American Geophysical Union, San Francisco, CA.
MATLAB | Python | Pandas | NumPy | SciPy | Requests | LaTeX
Statistics Programs (R and Stata) | Microsoft Office Suite (Word, Excel, PowerPoint, VBA) | Google Sheets