About Earl Leonard McGowen IV
Background
Earl Leonard McGowen IV is a seasoned professional with over 15 years of experience in database programming, AI, and data analytics. He currently serves as a data architect for a mental health organization, combining his technical expertise with a creative approach to building innovative solutions. Earl is also a Navy veteran, having worked as an Avionics Technician on EA-6Bs, an attorney, and a writer.
Experience
- Database Specialist at AllHealth Network (Nov 2021 - Present)
- Database owner monitoring and enhancing performance, troubleshooting issues, and training coworkers on best practices.
- Utilized SSIS, T-SQL, Python, and other tools to create ETL jobs of internal and external sources into the data warehouse.
- Introduced Python into the SQL Server, creating an API ETL engine for systems like Nice, Netsuite, PowerBI, and others.
- Database Programmer at Pacific Premier Trust (Feb 2015 - July 2021)
- Programmed SQL Server and Oracle databases and database objects to transform and analyze data.
- Created SSIS packages and SSRS reports.
- Installed Windows Server 2012 and SQL Server 2014 in development, test, and production environments, and migrated SSIS projects, SSRS reports, and data warehouse objects.
- Legal Analyst at Hudson Legal (July 2014 - Nov 2014)
- Audited and analyzed electronic documents and data for issues pertaining to securities law, banking regulations, and other federal statutes.
Projects
- AI-Powered ETL Engine using Python
Developed an AI-powered ETL engine using Python to integrate data from multiple sources into SQL Server, enhancing data accessibility and reporting capabilities.
- Data Warehouse Implementation
Led the implementation of a data warehouse solution for Pacific Premier Trust, streamlining data processes and improving data analytics.
- Advanced SQL Optimization
Optimized SQL queries and database performance, resulting in significant improvements in data retrieval times and resource utilization.
Skills
- AI and Machine Learning
- Data Analytics and Visualization
- SQL and Databases: SQL/T-SQL/PLSQL, Oracle SQL Server, Microsoft SQL Server
- ETL and Reporting: SSIS/SSRS, MS Access/Excel (VBA), Python/R
- Legal Expertise: Legal Technical Content Writing, Electronic Discovery
- AI Techniques:
- Retrieval-Augmented Generation (RAG): Combining retrieval-based methods with generative models to improve the accuracy and relevance of generated responses.
- Intelligent Agents: Developing autonomous agents that can perceive their environment, make decisions, and take actions to achieve specific goals.
- SQL Chaining: Integrating SQL queries with machine learning models to automate data processing and analysis workflows.
- Natural Language Processing (NLP): Implementing techniques for understanding, interpreting, and generating human language using AI models.
- Machine Learning and Data Analysis: Machine Learning (ML), Model Evaluation and Validation, Time Series Analysis
- Python Libraries: Pandas, NumPy, Matplotlib, SQLAlchemy, Jupyter Notebook, Plotly
- AI Frameworks and Tools: LangChain, TensorFlow, Transformers (Hugging Face), NLTK (Natural Language Toolkit)
Education
- CSU Global - Masters in Data Analytics (In Progress, GPA: 4.0)
- 24 out of 36 credits completed
- Member of the Golden Key Society
- University of Colorado Law School - Juris Doctorate in Information Technology (Graduated 2011)
- Courses in Technology and Intellectual Property Law, contracts, legal writing, litigation drafting, computers in law, constitutional and criminal law.
- Thesis on Governmental Databases: Privacy, Transparency, and the Law; Database Mining and Statistical Analysis of Governmental and Litigation Databases.
- University of Denver - Bachelor of Arts in Literature & Philosophy (Graduated 1997, GPA: 4.0)
Personal
Earl lives in Aurora, Colorado, with his wife, dog, and cat. He enjoys camping and continually seeks to expand his knowledge and skills to stay at the forefront of industry developments, particularly in AI, Data Analytics, and SQL.