Skills & Technologies
Organized by honest proficiency levels - what I can defend in interviews
🏆 Expert Level (15+ years)
Can pass deep technical interviews, no AI needed
SQL & Data Engineering
SQL Development (18 years)
- T-SQL, PL/SQL, Spark SQL
- Query optimization, execution plan analysis
- Stored procedures, functions, views
- Complex joins, window functions, CTEs
ETL/ELT Pipelines (15 years)
- SSIS (primary tool)
- Custom Python pipelines
- Data validation frameworks
- Error handling and logging
Data Warehousing (15 years)
- Star schema design
- Slowly Changing Dimensions (SCD Types 1-3)
- Fact/dimension tables
- Data mart architecture
- Medallion architecture (Bronze/Silver/Gold)
Business & Requirements
Requirements Engineering (20 years)
- Business-to-technical translation
- Stakeholder management
- Solution architecture design
- From bar owners to state government stakeholders
⭐ Proficient (5-10 years)
Solid hands-on experience, can work independently
Cloud Platforms
- AWS (5 years) - EC2, RDS, S3, Lambda, infrastructure setup, migration projects
- Microsoft Azure (4 years) - Databricks, Data Factory, VM deployment
Data Platforms
- Snowflake (2 years) - SnowPro Core Certified, data modeling, ETL pipeline development
- Databricks (1 year) - Spark SQL, Jupyter notebooks, Medallion architecture
Programming & Scripting
- Python (3 years practical use) - Data processing, automation, Pandas, API integration. Used heavily at Deloitte (2023-2025) and USCG (2020-2021)
- VB.NET / C# (12 years) - Windows applications, database connectivity (foundations strong, syntax rusty)
BI & Analytics
- Power BI (5 years) - PL-300 Certified, dashboard development, DAX formulas
- Tableau - Basic dashboard creation, data visualization
🤖 AI Tools - Expert (2+ years)
Early adopter with deep experience orchestrating AI platforms
AI Development Tools
- ChatGPT (Since November 2022) - First-week adopter, 2+ years daily use, prompt engineering mastery
- Claude (Anthropic) - Claude Sonnet 4, Claude Code, architecture discussions
- GitHub Copilot - Code completion, documentation generation, refactoring
- Lovable Platform - Full-stack application generation, requirements-to-code workflow
AI Orchestration Skills
- Converting business requirements into AI-readable specs
- Iterative refinement through testing and feedback
- Validating AI-generated code for correctness
- Multi-platform evaluation and selection
🎓 Certifications
- Snowflake SnowPro Core (2024)
- AWS Cloud Practitioner (2024)
- Microsoft Azure DP-900 - Data Fundamentals (2024)
- Microsoft Azure AZ-900 - Fundamentals (2024)
- Microsoft Azure AI-900 - AI Fundamentals (2024)
- Microsoft Power BI Data Analyst (PL-300) (2024)
- Advanced Prompt Engineering and Generative AI - Deloitte (2024)
Education
- Professional Certificate in Applied Data Science - Dartmouth Thayer School of Engineering (2021)
- Bachelor of Arts - Psychology, Business - University of Saint Thomas (2001-2005)
What I Can Defend in Interviews
✅ Strong & Confident
- SQL query writing and optimization
- ETL pipeline design and troubleshooting
- Data warehousing architecture
- Cloud platform migration
- Requirements gathering
- AI tool orchestration
⚠️ Can Discuss, Need Documentation
- Complex algorithm implementation
- Advanced React patterns
- Deep PostgreSQL administration
❌ Cannot Defend
- Whiteboard coding from memory
- LeetCode-style algorithm problems
- Reciting syntax details without IDE
How I Actually Work
The Reality:
- I don't code from memory - I look things up
- I use AI tools extensively - ChatGPT, Claude, Copilot
- I iterate rapidly - ship, test, fix, repeat
- I learn by doing - prototype first, optimize later
What This Means:
- Judge me on outcomes (working systems, solved problems)
- Not on process (whiteboard performance, syntax recall)
- I'm a systems thinker who uses AI for implementation
- I'm an experimental learner who ships fast and iterates
Years of Experience by Category
- SQL Development: 18+ years (2006-Present)
- ETL/ELT Pipelines: 15+ years (2008-Present)
- Data Warehousing: 15+ years (2009-Present)
- Cloud Engineering: 5+ years (2020-Present)
- Business Intelligence: 10+ years (2014-Present)
- Python Development: 3+ years practical use (2020-2021, 2023-2025)
- AI Tools & Platforms: 2+ years (Nov 2022-Present)