Mark Leo-Russell

I rejoined the Bureau of Geology in 2021 as the Database Administrator where I am doing a variety of database migration and support tasks, data modeling, systems management, web development, and GIS projects. While attending NM Tech I was the Student Curator at the Bureau's Mineral Museum for 2½ years so taking the DBA position was a bit of a home coming for me.

I received a B.S. in Geology from NM Tech. After college I held a variety of programmer, systems administrator, analyst, GIS, web development, technical training, and management positions. I spent time working as a contractor for the US Dept of Defense at Kirtland AFB, and with the Indian Health Service In Albuquerque. For 13 years I worked for the Albuquerque Public School District where I was a Systems Analyst, QA Manager, Director of Database Architecture, and Interim Director of Technology Client Services.

Throughout much of that time I attended the University of New Mexico where I took post-bachelors and graduate classes in Geology, Geography, Computer Engineering, Mathematics, and Organizational Learning (OLIT). Since spring '22 I have been taking grad classes at NMT where I am studying critical and industrial minerals, exploration geochemistry, and related topics.

Although I had formally been away from Geology and Earth Science for many years, I kept my hand in the field by traveling extensively throughout the southwest US--hiking, exploring, studying, and photographing most of the National Parks and many other monuments and state parks. Several years ago I had the privilege of co-piloting a Cessna flight over the erupting Pu'u O’o Vent, part of the East Rift Zone of Kilauea Volcano on the Big Island of Hawaii.

Academic

• Graduate studies in Mineral Engineering, New Mexico Institute of Mining and Technology, Socorro New Mexico (2022-present).
• Non-degree program: post-bachelors undergraduate and graduate courses in Organizational Leadership and Instructional Technologies (OLIT), Geography, Geology, Electrical and Computer Engineering, Computer Science, and Mathematics. University of New Mexico (UNM), Albuquerque New Mexico (1985-2009).
• Bachelor of Science (BS) Geology. New Mexico Institute of Mining and Technology, Socorro New Mexico (1981).

Professional

• Transform Architecture, Engineering, and Construction (AEC) Projects with GIS and Building Information Modeling (BIM). ESRI GIS training MOOC course, Mar 2024.
• Going Places With Spatial Analysis. ESRI GIS training MOOC course, Mar 2024.
• Adobe Certified Professional - Adobe ColdFusion. Adobe CFSummit, Las Vegas Nevada, Oct 5 2022.
• Spatial Data Science: The New Frontier in Analytics. ESRI GIS training MOOC course, Dec 2021.
• Imagery in Action. ESRI GIS training MOOC course, Sep 2021.
• Do-It-Yourself Geo Apps. ESRI GIS training MOOC course, Nov 2019.
• Certified Adobe ColdFusion Specialist. Adobe CFSummit, Las Vegas Nevada, Sep 30 2019.
• Using Angular and ColdFusion CFML Workshop. Adobe CFSummit, Las Vegas Nevada, Oct 2018.
• Cartography. ESRI GIS training MOOC course, Jun 2018.
• The Location Advantage. ESRI GIS training MOOC course, Jun 2018.
• Earth Imagery at Work. ESRI GIS training MOOC course, Mar 2018.
• MVC Framework with Framework/1 (FW/1) Workshop. Adobe CFSummit, Las Vegas Nevada, Nov 2017.
• Web Applications Security Workshop. Adobe CFSummit, Las Vegas Nevada, Oct 2016.
• ITIL Foundations. Rio Rancho Public Schools, Rio Rancho New Mexico, Jun 2016.
• Automating Administration With Windows PowerShell. Global Knowledge, Jul 2012.
• Spatial Analysis and GIS. Pre-conference Seminar, ESRI User Conference, San Diego California, Jun 2000.
• Introduction to Fuzzy Logic and Applications in GIS. Pre-conference Seminar, ESRI User Conference, San Diego California, Jun 2000.
• Fast Track to ColdFusion. Allaire, Albuquerque New Mexico, Mar 2000.
• Certified Internet Webmaster Course: JavaScript Fundamentals. New Horizons Computer Learning Center, Albuquerque New Mexico, Apr 1999.
• Certified Technical Trainer - Microsoft Train the Trainer. Franklin College, Albuquerque New Mexico, Jul 1998.

• Database systems including MS SQL Server, Oracle, MySQL, MariaDB, and Access. Extensive experience designing data models, writing queries, performing ETL processing, and data analysis using SQL, especially T-SQL and PL/SQL.
• Versed in web technologies such as ColdFusion/CFML, HTML, CSS, JavaScript and jQuery as well as many Content Management, Instructional Management and Learning Management Systems (CMS/IMS/LMS).
• Experience with Geographic Information Systems (GIS) including ESRI ArcGIS, ArcGIS Online, StoryMaps, ArcView, Arc/Info, ArcExplorer, ArcView Internet Map Server, and RouteMap Internet Map Server. Additional experience with QGIS, Trimble Navigation and Delorme GPS.
• Broad background and experience in “soup-to-nuts” applications development, especially web-based applications including back-end database design and implementation, middle-ware code development, user interface design, usability and accessibility testing, and post deployment management and support.
• Comprehensive experience with numerous versions of MS Windows, Unix and Linux.

New Mexico Geological Society

• Redesigning and reengineering various Access-based data collection systems used throughout the Bureau to web-based applications with SQL Server and MySQL back-end databases. Databases include the Gallinas and Cornudas Mtns REE projects, NM REE/Coal, NM Mines, Wells and Subsurface, and the NMBGMR Bibliography systems are undergoing redesign and redeployments.
• Automating various data handling processes for numerous Bureau databases including NM Maps, NM Wells, GIS Data and Aquifers.
• Support database design and data management for the National Geological and Geophysical Data Preservation Program (NGGDPP), and the Bureau's portion of the national Carbon Ore, Rare Earth and Critical Minerals project (CORE-CM).
• Deployment and support of Bureau's Photo Archive & Document website using Resource Space open-source digital asset management system (PHP application with MySQL back-end database).