Stephen Flammer
Verified Expert in Engineering
Database Developer
Stephen is a talented senior data and SQL architect, developer, DBA, and strategist; senior Azure/AWS cloud and BI/ETL/AI systems architect, developer, and strategist; and senior VB/.NET/Office/VBA/Access web and desktop full-stack solutions architect, developer, and engineer. He has over 18 years of experience designing and developing intuitive, feature-rich, user-friendly solutions. Stephen is a senior QA engineer, author, documentation specialist, and English–Spanish translator.
Portfolio
Experience
Availability
Preferred Environment
Visual Basic, SQL Server DBA, T-SQL (Transact-SQL), Amazon Web Services (AWS), Windows, Azure, SQL, ETL
The most amazing...
...software solution I've designed and developed is a custom ERP system for an international wholesaler, distributor, and retailer.
Work Experience
Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL, QA/Documentation Engineer
Quest Labs SPC
- Led data and cloud architecture and development for original virtual reality HR employee training suites for Starbucks Coffee and collaborated with owners and executives.
- Architected, developed, and deployed data tiers for original 3D VR HR training suites and integrated BI/ETL subsystems, comprehensive data tiers, and applets API reductions.
- Completed all phases ahead of schedule and under budget, reducing 12+ months' plans to 6 months' releases.
Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL, QA/Documentation Engineer
Dentsu Aegis Network - Carat
- Led development and optimizations for legacy systems refactorings and new modules deployments originations for multinational marketing analyses portals suites and collaborated with owners and executives.
- Worked on senior MSSQL development and database administration, Azure cloud and BI/ETL engineering, applications streamlining, and reductions.
- Eradicated all system issues, reduced waits from hours/minutes to fractions of seconds, and completed all phases ahead of schedule and under budget.
Senior MSSQL Developer, DBA, and Senior Azure, Office/Access, QA/Documentation Engineer
Kavak
- Led the architecture, development, and deployment of an original full-stack fintech services automobile lending platform, a customer account management solution, including customer relationship management, loan account administration, and performance modules.
- Collaborated directly with owners and executives to create and deploy original automobile lending account management systems, complete with SAP/ERP interfaces and VBA/office extension modules.
- Released an original solution ahead of schedule and under budget, with significant efficiency improvements and cost reductions across organization-wide and departmental efforts and expenditures.
Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL, QA/Documentation Engineer
Bespoke Solutions Consultancy Limited
- Led the architecture and development of an artificial intelligence-based analytical pharma sales data processing ETL and BI platform, upgrading and migrating existing SSIS BI systems into Azure via Data Factory, Azure SQL Database, and SQL Server C#.NET applets.
- Collaborated directly with owners and executives, full-stack original applications generation, design concept, systems development, and deployment, including mentoring university graduate trainees and cross-departmental team members coordination.
- Released the platform ahead of schedule and under budget, providing suites of self-aware SQL architectures automatically processing billions of records of GB file blobs through efficient scalable few-minute periods.
Publications and PaaS/SaaS Consultant, Creative Designer, and Technical Writer
Swiss Re
- Created brand new customer-facing PaaS/SaaS IT publications genre and styluses guides. Wrote original PaaS/SaaS sales/technical manuals/brochures for multinational corporate insurance reseller IT platforms/applications product launches.
- Collaborated with owners and executives to define original creative publication genre concepts, designs, and procedures relating to innovative insurance industry PaaS/SaaS platforms/applications.
- Created an original genre of proprietary PaaS/SaaS marketing and technical brochure publications, successfully branded and released client-facing sales and technical documentation, and instituted internal procedures and protocols for technical writing.
Senior MSSQL Developer, DBA, and Senior Cloud Applications Security Consultant
Data Masons
- Consulted and led full-stack SQL Server/C# security analyses, optimization, and development endeavors relating to enhancements for existing financial data systems architectures.
- Collaborated directly with owners and executives, analyses/improvement for security and performance concerns relating to clienteles logins and access protocols architectures for fintech products.
- Eliminated security breaches and login accounts discrepancies, allowing for daily ongoing real-time automated login account protocols standardizations and efficacies.
Senior MSSQL Developer, DBA, and Senior BI/ETL, Office/Access, QA/Documentation Engineer
Greenwood Associates, Inc.
- Led the development, redesigns, and optimizations for existing ERP-integrated SQL Server and Microsoft Access full-stack applications suites for multinational food suppliers conglomerates.
- Collaborated directly with owners and executives to analyze and overhaul existing elements of the systems and to introduce new modules as per business development phases.
- Optimized systems and reduced waits and down-times from hours/minutes to fractions of seconds with 100% up-time.
Senior Applications, VBA, and Office Solutions Architect and Developer
Rylan Grady Associates
- Led the architecture and development for an original Microsoft Office/VBA/JSON solutions framework of one-click fully automated ETL/BI JSON to Excel and PowerPoint interface data analytics and visualizations.
- Collaborated directly with the CEO of an HR business consulting firm to design/develop executive- and board-review data visualization materials of customized preorganization HR statistical analyses.
- Completed the solution ahead of schedule and under budget, including features and specifications beyond the original project requirements and parameters.
Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL/AI, Office/Access, QA/Documentation Engineer
Foresight Environmental
- Led cloud and full-stack architecture/development for online multinational environment management data and BI analytics portals and collaborated directly with owners and executives.
- Worked on the original and upgraded OLTP, BI/ETL dashboards/reporting/analytics systems and distributable Microsoft Access/VBA mid-tier and front-end applets.
- Completed each phase on schedule in coordination with marketing/business development plans, successfully onboarding several hundred percent of new users per newer features capability.
Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL/AI, Office/Access, QA/Documentation Engineer
Fundu
- Led data systems architecture and development for the infancy-through-production-release lifecycle of an original European regional multinational online automated B2B/B2C lending decision platform portals suite.
- Collaborated directly with owners and executives to design, develop, and implement integrated data tiers/mid-tiers/BI-tiers for a machine learning-based lending decision engine for an online lending portal wholesaling/retailing/reselling.
- Reduced budget and time quantities and completed phases ahead of schedule, allowing for the inclusion of expansions above/beyond originally intended features.
Senior MSSQL Developer, DBA, and Senior AWS, BI/ETL/AI, Office/Access, QA/Documentation Engineer
Rapaport
- Led the optimization, administration, and development of large production SQL servers that were experiencing performance issues running high-transaction OLTP commodities portals.
- Served as a senior Microsoft SQL Server developer, DBA, and senior cloud and BI/ETL engineer and collaborated directly with owners and executives.
- Eradicated database and application crashes/downtime, from 60,000+ timeouts daily to zero issues, with 100% up-time, and reduced waits from hours/minutes to fractions of seconds.
Senior MSSQL Developer, DBA, and Senior Azure, Office/Access, QA/Documentation Engineer
Fast Growing Trees
- Handled optimizations, enhancements, and additional module development for an international eCommerce ordering, invoicing, and inventory/shipping management applications suite that was experiencing performance issues.
- Consulted refactoring for upgrades from on-prem to cloud and Microsoft Access VBA to ASP.NET and led the development of enhancements and optimizations for SP, API, GUI, and reports operations.
- Eliminated all errors and timeouts and reduced waits from hours/minutes to fractions of seconds.
Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL/AI, Office/Access, QA/Documentation Engineer
Online freelance agency
- Completed short- to long-term contracts for consultation and analysis, design, development, optimization, enhancement, validation, and administration of original and legacy data, desktop, cloud, and BI solutions.
- Served as a senior Microsoft SQL Server developer and DBA, senior Azure, desktop, Office/Access solutions engineer, senior BI/ETL engineer, and senior QA/documentation engineer.
- Maintained a five-out-of-five star rating with online workspaces consistently throughout my tenure.
Senior MSSQL Developer, DBA, and Senior Office/Access, QA/Documentation Engineer
Reed Group, Ltd.
- Led solutions architecture, design, development, deployment, enhancement, and administration of official US government-sanctioned MDACM (Medical Disability Advisor—Case Manager) software applications suites.
- Optimized, enhanced, refactored, and upgraded existing modules, including .NET upgrades and the administration of DB architecture for in-house/clientele data systems.
- Doubled the solutions clientele, annual software and services sales and revenue grew 65%+, and customer satisfaction indexes increased 45%+.
Senior MSSQL Developer, DBA, and Senior Office/Access, QA/Documentation Engineer
Metropolitan State College of Denver
- Led the origination of executive accounting and BI RDBMS solutions to automatically archive departmental college expenditures and analyze periodic, repetitive costs, collaborating directly with executive management.
- Architected, designed, developed, tested, deployed, and provided ongoing enhancement, administration, and QA. Validated full-stack solutions, including BI reports and dashboards, business analyses, and development lifecycle admin.
- Increased departmental efficiencies by 35% while institution-wide annual revenues increased by 28%.
Experience
CV and Addendum
https://www.dropbox.com/s/rz5pawx2cmvzxh8/Stephen_Flammer_CV.docx?dl=0Desktop, Data Solutions, and Documentation Portfolio
https://www.dropbox.com/sh/32dz9dap208w85y/AABIR9n-6K_0SkCdaLa-63yTa?dl=0Skills
Languages
Excel VBA, Visual Basic 6 (VB6), C#.NET, SQL DML, Data Manipulation Language (DML), SQL DDL, Visual Basic .NET (VB.NET), Visual Basic for Applications (VBA), Stored Procedure, VBScript, VB, SQL, T-SQL (Transact-SQL), JavaScript, VB.NET, Java, Python, Visual Basic, C++, C#, XML, HTML, CSS
Libraries/APIs
REST APIs, Office API
Tools
SQL Server Profiler, Azure Logic Apps, Microsoft Access, SSAS, Microsoft Excel, MongoDB Atlas, Tableau, Microsoft Dynamics, Microsoft Dynamics CRM, Microsoft Dynamics NAV, Microsoft Power BI, Amazon Elastic Container Registry (Amazon ECR), Amazon EBS, Amazon Elastic Container Service (Amazon ECS), Erwin, Microsoft Word, Microsoft PowerPoint, Visual Studio, Visual Studio 2012, Dundas BI
Paradigms
ETL, Business Intelligence (BI), Management, Microservices, Test-driven Development (TDD), Scrum, Agile, DevOps, Data Science, Testing, Requirements Analysis, Rapid Application Development (RAD), Object-oriented Design (OOD), OLAP, ETL Implementation & Design, Feature-oriented Programming, RESTful Development, Desktop App Development, Entity-relationship Diagrams, Database Design, Azure DevOps, Role-based Access Control (RBAC)
Platforms
Azure PaaS, Windows, Azure, Amazon EC2, Windows Server 2012, Windows Server, Kubernetes, Amazon Web Services (AWS), Linux, Oracle
Storage
Databases, Data Pipelines, SQL Server 2017, SQL Server Agent, SQL Stored Procedures, SQL Architecture, ANSI SQL, Azure Cloud Services, Database Security, Database Backups, Database Testing, Data Definition Languages (DDL), OLTP, Azure SQL Databases, Azure Blobs, Azure Queue, Data Validation, Database Performance, SQL Performance, SQL Injection Protection, SQL Server 2014, Database Administration (DBA), SQL Server DBA, RDBMS, Database Replication, SQL Server 2016, SQL Server 2008 R2, SQL Server 2012, SQL Server 2005, Database Management, Database Management Systems (DBMS), Database Modeling, Database Lifecycle Management (DLM), Relational Databases, SQL Server Integration Services (SSIS), Microsoft SQL Server, Database Architecture, SQL Triggers, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Service Broker, SQL Server 2008, SQL Server Management Studio, Azure SQL, Data Lakes, Data Lake Design, MongoDB, PostgreSQL, MySQL, Amazon S3 (AWS S3), NoSQL, SQL Server Data Tools (SSDT), JSON, PL/SQL, DB
Industry Expertise
IT Security, Retail & Wholesale, Accounting, Project Management, Insurance
Other
Data Warehousing, Azure Data Factory, Analytics, Analysis, Compliance, Project Analysis, UX Analysis, Project Planning, Project Lifecycle, Project Tracking, IT Projects, Projects, Project Reporting, Project Timelines, Project Design, Project Scoping, Project Finance, Supervisory, Leadership, Entrepreneurship, Startups, Data Analytics, SSIS Custom Components, Microsoft Data Transformation Services (now SSIS), SQL Server Administration, SQL Server 2019, Data Engineering, Consulting, IT Consulting, Technical Consulting, Technology Consulting, Management Consulting, Project Consultancy, Business Consulting, IT Systems Architecture, SaaS, Platform as a Service (PaaS), CI/CD Pipelines, Message Queues, ELT, Architecture, Administration, IT Administration, Server Administration, SQL Administration, System Administration, UI Development, Technical Design, Quality Assurance (QA), QA Leadership, Design, Static Analysis, UI Engineering, Engineering, Data Virtualization, Business Analysis, IT Business Analysis, Business Logic, Business Rules, Design Specifications, Requirements & Specifications, UI Specifications, Computer Engineering, Engineering Software, Computer Science, Cloud Computing, Code Architecture, Document Design, Publication Design, Translation, Linguistics, Intelligent Networks, Reports, Financial Reporting, BI Reports, Data Reporting, IT Project Management, Project Design & Management, Project Administration, Project Coordination, Coordination, Project Development, Project Evaluation, Project Leadership, Project Management Operations, Software Project Management, Technical Project Management, API Documentation, UX Documentation, Design Documentation, Technical Documentation, Test Documentation, Articles, QA Testing, UX Testing, UI Testing, Front-end, Front-end Design, Front-end Development, Front-end Architecture, GUI, Cloud, Microsoft Azure Cloud Server, Risk Management, Migration, Standardization, UX Engineering, Usability Engineering, Requirements, Business Requirements, User Requirements, System Requirements, Excel Macros, Scalability, Libraries, Relational Database Design, Backup & Recovery, Data Recovery, Business Continuity & Disaster Recovery (BCDR), Azure Portals, Validation, Code Validation, Business Validation, Large Data Sets, Big Data, Deployment, Performance, Security Policies & Procedures, Import/Export, CSV Import, Blob Storage, Server Configuration, Application Configuration, Network Configuration, Configuration Management, Monitoring, Systems Monitoring, Indexing, Diagrams, Flow Diagrams, Workflow Diagrams, Technical Diagrams, Business Process Flow Diagrams, Finance, Construction, Technology, Aerospace & Defense, Hotels & Lodging, Food & Beverage, Sales & Marketing, Data Warehouse Design, Azure SQL Data Warehouse (SQL DW), eCommerce, Back-end, Back-end Development, ETL Development, ETL Tools, UX Architecture, Feature Analysis, Systems, System Design, CRM Systems, Decision Analysis, Big Data Architecture, Operations, Operations Tools, IT Operations, Applications, Database Applications, Scripting, Shell Scripting, Languages, Coding, Debugging, Charts, Full-stack, QA Test Plan Management, Software QA, QA Automation, Team Leadership, Troubleshooting, Documentation, Relational Data Mapping, Data Modeling, Real-time Operating System (RTOS), SSRS Reports, Data Analysis, Query Optimization, Data, Data Migration, Data & Backup Management, Data Architecture, Macros, Software Consulting, Writing & Editing, Dashboards, Interactive Dashboards, Engineering Design, Systems Engineering, DevOps Engineer, Art Design, Entity Relationships, Dashboard Design, Web Dashboards, Dashboard Development, Analytical Dashboards, Data-driven Dashboards, Financial Reporting Dashboards, BI Reporting, System Improvements, Art, Data Strategy, Data Governance, Data Management, Microsoft 365, Machine Learning, Data Visualization, APIs, Optimization, Enterprise Design, GUI Design, Security Design, Security Testing, Reporting, Operational Streamlining, Security Analysis, Publishing, Systems Analysis, Collaborative Design, Graphic Design, Legal, Creative Concept Development, System Migration, Upgrades, Artificial Intelligence (AI), Serverless, Software
Frameworks
.NET
Education
Post-graduate Degree in Sociolinguistics and Music Performance
University of Colorado at Denver - Denver, Colorado, USA
Bachelor's Degree in Computer Science, Photography, and Music Performance
University of Colorado at Denver - Denver, Colorado, USA
Associate's Degree in Computer Science, Psychology, and Music Performance
Brigham Young University - Provo, Utah, USA