Michael Shawn Lockwood

About Michael Shawn Lockwood

Application Database Developer and Data Platform Engineer — I’ve spent my career…

Experience

1. Self-directed and Independent Project Work Data Engineering & Development

   StaffSource

   Jul 2021 — Present · NC, US

   Once Walmart Health\'s acquisition of MeMD finalized in June 2021, I took the opportunity to further my education, informally, and expand my knowledge and experience in modern and emerging data engineering technologies. I’ve self-directed my projects and development work. One outcome is a multi-billion row public data engineering pipeline focused on large-scale data ingestion, validation, and analytics across SQL Server, PostgreSQL, Azure, and Databricks, separately for a number of reasons. I use Python and PowerShell for converting and merging Parquet into PSV (and back), then bulk import into relational tables—extensions make this step unnecessary because of Parquet adoption, but it\'s good to know. I use GitHub and VS Code for version control and development workflow. I use Airflow to orchestrate repeatable pipelines, while Databricks supports heavy lifting, and it\'s slick. I document and publish my work and progress in my GitHub Pages.I\'ve worked in slow, moderate, and fast-paced environments for many years, mostly in healthcare and transaction-heavy industries as a Senior DBA. I\'m a firm believer in mastering core platforms and technologies rather than a generalist. Still, I’ve taken time to learn and experiment with a variety of tech—PostgreSQL, Python, PowerShell, JavaScript, Airflow, Databricks SQL, Power BI, D3.js, Hyper-V, VirtualBox, Docker, ASP.NET Core, Identity Server, Node.js, Angular, CSS/Sass, and even MongoDB. This is more than a laundry list of tech. These explorations help me stay adaptable and give me perspective, many of which I use in my recurring development and deployment cycles as part of my professional roadmap.

Education

• Walden University

  Information Technology

  2014 — 2014

• Kaplan University

  Information Technology Business Intelligence and Analytics

  2014 — 2016

• DeVry University

  Bachelor's, Business Administration, Computer Information Systems

  1996 — 2002

Skills

• Microsoft Sql Server
• Xml
• Power Bi
• Integration
• Etl
• Ssis
• Agile Methodologies
• Transact-Sql (T-Sql)
• Data Integration
• Business Intelligence
• Analysis Services
• Performance Tuning
• Databases
• Software Development
• C#
• Ssrs
• T-Sql
• R
• Database Administration