add photo
Stephen
steveflammer@yahoo.com
303-800-4108
Denver, CO 80299
FREELANCE SENIOR DATA, BI, CLOUD, ETL, DESKTOP ENGINEER; SENIOR SQL DBA; QA ENGINEER; TECHNICAL WRITER
29 years experience C2C
0
Recommendations
Average rating
176
Profile views
Summary

  • 25+ years SQL Server DBA & developer & migration & upgrade
  • Azure DBA/developer/migration/upgrade
  • SQL Server 2008/2012 to Azure
    • Instance install/config
    • Validation/testing
    • Data prep/migration
    • Schema validation/scripting
    • DBA/developer/optimization
    • VM config/administration
    • Active directory
    • Powershell
    • Terraform (indirect)
  • Comprehensive solutions profiles: cloud, enterprise, medium & small organization, distributed, home/single-user 1-/2-/n-tier architectures
  • Wide variety of industries & environments: aerospace, fintech, wholesale, retail, medical, manufacturing, e-commerce, transportation, etc.
  • Windows/Azure AWS MSSQL 6.5-2019 (SSIS/SSAS/SSRS) VS 6.0-2019 (SSDT) .NET Access/Office 1995-2019; Power BI Oracle MySQL Postgre SAP
  • SQL T-SQL PL-SQL NoSQL VB (COM, .NET, Script) VBA (Access, Excel, Word, PowerPoint, Outlook) C++ C# Python, Javascript XML JSON Powershell

Professional Competencies

  • Team leadership & project management: interviewing & hiring supervision & mentoring training & instruction performance review
  • Original & legacy data, BI, cloud, ETL, desktop solutions architecture, analyses, development, optimization, administration, migration, upgrade
  • Concept design & infancy to post-production full development life cycle planning, management, lead, administration & consulting
  • Business analyses & solutions requirements definition & interpretation design consultation & applications architecture planning
  • Cloud & Full-stack engineering & consultation: Azure/AWS cloud SQL & data tools networking active directory VM web apps Powershell
  • ETL engineering: data points & BLOB interface API's inter-layer op's database & applications self-aware monitoring & reporting warehousing
  • SQL & applications artificial intelligence: code-writing-code SQL & applications real-time self-aware modules, smart diagnostics, logs & alerts
  • Back end engineering & consultation: web & desktop paradigms relational, OOD & mixed OOD diagram-relational, data flow, entity-relationship
  • SQL & T-SQL advanced coding: cloud, web, desktop & administration paradigms SP, query, dmv, trigger, assembly, job & batch script, applets
  • MS SQL Server advanced features: Azure query & column store in-memory optimistic locking data masking temporal tables trace flags
  • Senior SQL DBA: advanced analyses, optimizations, features & coding 24/7 on-call VLDB hardware security RPO/RTO & HDA/DR Cloud/ETL/BI admin.
  • BI engineering & consultation: cloud dashboards desktop (GUI only/full-stack) services (SSIS/SSAS/SSRS) ETL data warehousing/mining business analytics
  • Front end & GUI architecture, layout, design & coding mid-tier layer design & coding 2-/n-tier inter-layer architectural mapping & design
  • VB/VBA/Access engineering & consultation: advanced architectures & coding solutions simulation client-server scalable architectures sub-classing RAD
  • Office automation (Excel, Word, PowerPoint, Outlook): VBA/GUI development Word & PowerPoint automated formatting & publishing SAP integration
  • QA engineering & leadership: test planning automations & scripting proprietary QA systems design & deployment QA reporting
  • IT documentation & leadership: administrative & presentation technical, user & process - support & guide QA publication
  • Translation & IT conference & seminar presentation & instruction: English-Spanish Spanish-English corporate internal user academic public

Experience
Education
Sociolinguistics, Music Performance, Photography
University of Colorado at Denver 2012
Computer Science, Music Performance, Photography
University of Colorado at Denver 1996
Computer Science, Music Performance, Psychology
Brigham Young University 1991
Skills
Oracle
2022
25
Quality Assurance
2022
25
SQL
2022
25
T-SQL
2022
25
JavaScript
2022
24
PL/SQL
2022
24
DBA
2022
23
Business Analysis
2022
22
Microsoft Excel
2022
22
ETL
2022
20
MySQL
2022
20
Python
2022
20
Windows
2022
16
Visual Basic
2022
15
Solutions Architecture
2010
13
Artificial Intelligence
2022
12
Azure SQL Database
2022
12
Data Warehousing
2022
12
Database Upgrades
2022
12
Devops
2022
12
MongoDB
2022
12
MS Active Directory
2022
12
MS Azure
2022
12
MS Power BI
2022
12
PowerShell
2022
12
SAP
2022
12
Scripting
2022
12
Spanish
2022
12
SQL Developer
2022
12
SSAS
2022
12
System Architecture
2022
12
System Design
2022
12
Systems Integration
2022
12
Test Planning
2022
12
Translation
2022
12
SQL Server
2002
5
.NET
2002
2
Data Mining
2002
2
QA
2000
2
C#
2002
1
C++
2002
1
Applications Architecture
0
1
AWS
0
1
JSON
0
1
Scala
0
1
Software Engineer
0
1
Systems Engineering
0
1
Terraform
0
1
XML
0
1