Stephen Flammer, Developer in Makati, NCR, Philippines
Stephen is available for hire
Hire Stephen

Stephen Flammer

Verified Expert  in Engineering

Database Developer

Location
Makati, NCR, Philippines
Toptal Member Since
June 18, 2020

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

Quest Labs SPC
SQL, Azure, APIs, Serverless, Databases, Azure SQL
Dentsu Aegis Network - Carat
ETL, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL, DB...
Kavak
SQL Server 2019, Azure, Azure SQL, VB, Visual Basic for Applications (VBA)

Experience

Availability

Full-time

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

2022 - 2022
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.
Technologies: SQL, Azure, APIs, Serverless, Databases, Azure SQL

Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL, QA/Documentation Engineer

2021 - 2021
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.
Technologies: ETL, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL, DB, ETL Development

Senior MSSQL Developer, DBA, and Senior Azure, Office/Access, QA/Documentation Engineer

2021 - 2021
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.
Technologies: SQL Server 2019, Azure, Azure SQL, VB, Visual Basic for Applications (VBA)

Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL, QA/Documentation Engineer

2020 - 2020
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.
Technologies: Leadership, SQL Server 2017, Azure Data Factory, ETL, Data Architecture, SQL Server DBA, SQL, System Migration, Upgrades, Optimization, Stored Procedure, Artificial Intelligence (AI), Business Intelligence (BI)

Publications and PaaS/SaaS Consultant, Creative Designer, and Technical Writer

2020 - 2020
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.
Technologies: Publishing, Writing & Editing, Systems Analysis, Insurance, Static Analysis, Analysis, Collaborative Design, Graphic Design, Consulting, Legal, Compliance, Creative Concept Development

Senior MSSQL Developer, DBA, and Senior Cloud Applications Security Consultant

2020 - 2020
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.
Technologies: SQL Server DBA, SQL Server 2017, SQL, Stored Procedure, Security Design, Analytics, Security Testing, Role-based Access Control (RBAC), Optimization, Reporting, Leadership, Operational Streamlining, Security Analysis

Senior MSSQL Developer, DBA, and Senior BI/ETL, Office/Access, QA/Documentation Engineer

2019 - 2019
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.
Technologies: Leadership, SQL Server DBA, SQL Server 2017, Visual Basic for Applications (VBA), Microsoft Access, APIs, SQL Stored Procedures, Data Engineering, Optimization, SQL, Project Management, Enterprise Design, GUI Design

Senior Applications, VBA, and Office Solutions Architect and Developer

2019 - 2019
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.
Technologies: Data Visualization, XML, JSON, Visual Basic for Applications (VBA), Microsoft 365, Microsoft Access, Microsoft PowerPoint, Microsoft Excel

Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL/AI, Office/Access, QA/Documentation Engineer

2018 - 2019
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.
Technologies: CSS, XML, JSON, Visual Basic for Applications (VBA), C#, T-SQL (Transact-SQL), SQL, SQL Server Integration Services (SSIS), Microsoft Power BI, Dundas BI, Microsoft 365, Microsoft Access, HTML, .NET, Azure SQL, Microsoft SQL Server, Azure, Windows Server

Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL/AI, Office/Access, QA/Documentation Engineer

2018 - 2019
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.
Technologies: HTML, XML, JSON, C#, T-SQL (Transact-SQL), SQL, Microsoft Power BI, SQL Server Integration Services (SSIS), Machine Learning, Kubernetes, .NET, Azure SQL, Microsoft SQL Server, Azure, Windows Server

Senior MSSQL Developer, DBA, and Senior AWS, BI/ETL/AI, Office/Access, QA/Documentation Engineer

2016 - 2017
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.
Technologies: Amazon Web Services (AWS), SQL Server Data Tools (SSDT), Visual Studio, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server Reporting Services (SSRS), SSAS, Erwin, VBScript, T-SQL (Transact-SQL), SQL, Windows Server 2012

Senior MSSQL Developer, DBA, and Senior Azure, Office/Access, QA/Documentation Engineer

2015 - 2016
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.
Technologies: Microsoft SQL Server, Visual Basic for Applications (VBA), T-SQL (Transact-SQL), SQL, Microsoft 365, Microsoft Access, Visual Studio 2012, Windows Server 2012

Senior MSSQL Developer, DBA, and Senior Azure, BI/ETL/AI, Office/Access, QA/Documentation Engineer

2012 - 2015
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.
Technologies: Amazon Web Services (AWS), PL/SQL, Visual Studio, Microsoft SQL Server, Erwin, JavaScript, C#, C++, Visual Basic for Applications (VBA), VB, T-SQL (Transact-SQL), SQL, Oracle, Microsoft 365, Microsoft Access, .NET, Windows

Senior MSSQL Developer, DBA, and Senior Office/Access, QA/Documentation Engineer

2000 - 2002
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%+.
Technologies: Visual Studio, Microsoft SQL Server, Erwin, JavaScript, C#, C++, Visual Basic for Applications (VBA), VB, PL/SQL, T-SQL (Transact-SQL), SQL, Oracle, Microsoft 365, Microsoft Access, .NET, Windows

Senior MSSQL Developer, DBA, and Senior Office/Access, QA/Documentation Engineer

1998 - 1999
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%.
Technologies: Microsoft PowerPoint, Microsoft Word, Microsoft SQL Server, Microsoft Excel, Visual Basic for Applications (VBA), VBScript, T-SQL (Transact-SQL), SQL, Oracle, Microsoft Access

CV and Addendum

https://www.dropbox.com/s/rz5pawx2cmvzxh8/Stephen_Flammer_CV.docx?dl=0
My CV and addendum are a detailed overview of my professional experience and competencies. They summarize 18+ years of expert data, cloud, BI, AI, ETL, full-stack engineering and consultation, QA engineering, and IT documentation.

Desktop, Data Solutions, and Documentation Portfolio

https://www.dropbox.com/sh/32dz9dap208w85y/AABIR9n-6K_0SkCdaLa-63yTa?dl=0
My comprehensive portfolio includes my Toptal profile, publications, documentation, data engineering projects, applications solutions engineering projects, and cloud and BI/ETL/AI engineering projects.
2009 - 2012

Post-graduate Degree in Sociolinguistics and Music Performance

University of Colorado at Denver - Denver, Colorado, USA

1994 - 1996

Bachelor's Degree in Computer Science, Photography, and Music Performance

University of Colorado at Denver - Denver, Colorado, USA

1989 - 1990

Associate's Degree in Computer Science, Psychology, and Music Performance

Brigham Young University - Provo, Utah, USA

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 (ECR), Amazon EBS, Amazon Elastic Container Service (Amazon ECS), Erwin, Microsoft Word, Microsoft PowerPoint, Visual Studio, Visual Studio 2012, Dundas BI

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

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, Azure SQL Data Warehouse, Windows, Azure, Dedicated SQL Pool (formerly SQL DW), 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 Storage, 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), Service Broker, SQL Server 2008, SQL Server Management Studio (SSMS), 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

Retail & Wholesale, Accounting, Project Management, Insurance

Frameworks

.NET

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, Graphical User Interface (GUI), Cloud, Microsoft Azure Cloud Server, IT Security, 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, 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 Management (ITOM), 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

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring