Executive Summary
- 28 years in IT with a primary focus on data engineering, modeling, ETL, and reporting.
- Experience with SQL Server, PostgreSQL, and many more SQL and NoSQL database systems.
- Proficient in SQL, C#, Python, PowerShell, JavaScript, TypeScript, and many more languages for both backend processing and user interface development.
- Extensive experience with dev ops, using Git, Azure DevOps, and many CI/CD tools.
Projects
- CCSVGit (Python)
- FancyBoxes (Python)
- Provides methods for printing data to the console using structured grids and boxes.
- ClearIO (Python)
- Provides a uniform way of accessing storage systems.
- ClearData (Python)
- Provides a uniform way of accessing database systems.
- BDMPackages (C#)
- A large collection of packages for easing the burden of the C# developer.
- CASM (Various Languages)
- A collection of applications and servers designed to run on small offline hardware to help manage a Search and Rescue operations.
- GarminAGWPEInterface (C#)
- Application for interfacing between Garmin Canine tracking products and Amateur Radio (HAM).
Work Experience
- Sr. Data Engineer (November 2021 - Present)
- Hired as a Senior Data Engineer, my primary task was to manage integrations between the various in-house and third party systems. I was also responsible for developing and maintaining all data dictionaries from ground up. Initially the company was using Informatica for their ETL solution. After some time, I was able to convert all ETL processes to PowerShell, saving the company approximately $100K per year. Additional cost savings were gained by rethinking existing data models to reduce redundant data. Thereby saving significate costs in AWS storage. I also automated several existing processes, freeing the work force to focus on other more important tasks.
- Data Engineer (July 2021 - November 2021)
- Hired as a data developer, I was initially task with stream lining the DevOps processes. I worked to reduce total Git repositories from 43 down to 7 manageable repositories. I also converted the team from a random branching methodology to iteration based branching. I implemented semantic versioning and conventional commits to help automate GHANGELOG and CI/CD. I also refactored code to take advantage of Nuget packaging to eliminate Git submodule linking.
- When not working on the DevOps process, I optimized the SQL database footprint by implementing an indexing strategy. Also worked to migration databases amongst the various instances of SQL Server based on use and required response times.
- Senior Developer (August 2020 - May 2021)
- Working for 180 Medical as a full stack developer, I was tasked with developing stored procedures and application code to support the business’s in-house developed application, MedTrack. This application ran on the Microsoft stack, including SQL Server and IIS. It was developed in C# using MVC.
- Data Analyst IV (December 2016 - August 2020)
- Working for Matrix as a data analyst, I was tasked with developing integrations between various systems using Informatica and PowerShell. To include UltiPro, Active Directory, various SQL databases, and the main ERP application housed in Oracle. Additionally, I also maintained SSRS reports and provided overall support for Microsoft SQL Server. I assisted the team in growing their understanding of PowerShell and many other technologies, as well as developing skills in features of existing software that they were not yet aware of.
- Senior Database Developer (May 2015 - December 2016)
- Working for Verinovum, as a database developer and production database administrator, I was tasked with the design and implementation of multiple data models used to store and process incoming patient data from multiple health care providers. I also managed and maintained production SQL Server cluster.
- Senior Data Architect (October 2011 - March 2015)
- Working for Samson Resources, on a development team, I was tasked with the design and implementation of multiple data models used to store and maintain data concerning all aspects of the company's data. I was placed in charge of developing, implementing, and enforcing data model and database standards and conventions. I also led four application developers in the use of SSIS to convert the data stored in JD Edwards Accounting (AS/400) to SAP (Oracle). I instructed application developers in the proper use of Microsoft SQL Server and proper data model principals.
- Senior Database Administrator (November 2010 - October 2011)
- Working for Relay Health, a division of McKesson, on a team of three production support DBAs I was tasked with the maintenance of 45+ SQL 2005 instances spread across multiple four node clusters which housed the databases for their SaaS insurance claims billing products.
- Senior Database Administrator (September 2007 - November 2010)
- Working in the IT department I was tasked with the management of Microsoft SQL data stores which housed many databases for in-house written application as well as the public facing websites. Upgraded all SQL servers from 2005 to clustered multi-instanced 2008 servers on an iSCSI SAN. Assisted developers with standardizing their database calls, through the use of stored procedures and XML. Performed regular security audits to tighten security and conform to regulation placed on Williams & Williams by their customers in the banking industry. Implemented Microsoft Dynamics CRM 4.0, and supported the associated data stores post implementation. Assisted with upgrade to Microsoft Dynamics Solomon 7.0, and supported the data stores and the application post implementation. Implemented Microsoft SharePoint 2007, and supported the associated data stores post implementation. Led the Business Analytics team and IT resources in the implementation of the Microsoft BI stack, including MOSS, Performance Point and Excel Services. Assisted the Business Analytics team with ad hoc queries and understanding data relevant to customer activity. Led the upgrade of Microsoft SharePoint 2007 to 2010 to support new business intelligence functionality on the improved Microsoft BI stack. Assisted junior level network administrators with network design and layout, as well as improving existing services such as VPN.
- Senior Database Administrator (June 2001 - August 2007)
- Working on the systems support team I was tasked with the management of several Microsoft SQL data stores which housed the Adage ERP system, written by Infor. Also, managed many specialty database, including Dun and Bradstreet's Risk Assessment Manager, OAT Systems (RFID), LabVantage's LIMS, Shop Floor Automation Systems ( Invensys Systems' Wonderware and Rockwell Automation), SolarWinds NPM and in-house written data warehousing databases. Databases were distributed across multiple clustered (active/passive) and stand-alone SQL servers, running SQL 2000 and SQL 2005.
- Database Auditor/Developer (May 2001 - May 2001)
- As temporary database support, reported on enhancements that could be made to improve performance on SQL servers used for Thrifty web site. I also wrote DTS Packages to move and manipulate data for the web development team.
- Corporate Database Administrator (December 2000 - April 2001)
- Working on the web development team I was tasked with the management and development of the corporate data store which housed information gathered throughout the company from various FoxPro based ERP/MRP systems. The data was then made available to the Internet, Intranet, and Extranet.
Volunteer Experience
- President (January 2023 - Present)
- Member (December 2023 - January 2021)
- Vice President (January 2019 - December 2021)
- President (January 2015 - December 2019)
- Vice President (August 2014 - December 2014)
- From January 2015 till December 2019, I served as the President of the Board of Directors. I am currently serving as the Vice President.
- As a Search and Rescue technician I take on multiple duties during an active search as well as during routine training. Duties include building search plans, managing resources, handling a canine, and leading field teams.
- I also instruct and evaluate future SAR technician. I hold many certifications in emergency services. I am a part time instructor for Oklahoma Department of Safety through Oklahoma State University.
Verdigris Valley Search and Rescue
- Director (October 2012 - November 2013)
Lone Wolf Search and Rescue
- Canine Handler (May 2005 - September 2012)
- 1st Lieutenant (November 2015 - December 2019)
Jenks Fire & Rescue, Community Emergency Response Team
- Instructor (April 2014 - December 2018)
Education
- Bachelor of Arts, Pastoral Studies (Fall 2003 - Spring 2006)
- Forty-six credit hours completed.