Stephen Flammer, Database Developer in Makati, NCR, Philippines
Stephen Flammer

Database Developer in Makati, NCR, Philippines

Member since August 4, 2015
Stephen is a talented senior data systems engineer and consultant, senior desktop solutions full-stack engineer and consultant, and senior SQL DBA. He has over twenty years of experience designing and developing SQL Server, VB, and MS Access systems. He designs and develops intuitive and feature-rich user-friendly solutions. Stephen is an expert MS SQL database administrator, QA engineer, documentation specialist, and English/Spanish translator.
Stephen is now available for hire

Portfolio

Experience

Location

Makati, NCR, Philippines

Availability

Part-time

Preferred Environment

Visual Basic, SQL Server DBA, T-SQL, AWS, Windows, Azure, SQL Developer, ETL

The most amazing...

...software solution I've designed and developed is a custom ERP system for an international wholesaler, distributor, and retailer.

Employment

  • Artificial Intelligence ETL Engineer, Lead Systems Architect, and Developer

    2020 - 2020
    NDA Client (via Toptal)
    • Created 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 DB, SQL Server 2017, and a C#.NET framework.
    • Collaborated directly with the CEO and CIO to design and develop an intelligent real-time pharma sales analyzer via automated ingest and processing of big data marketing flat-file stores into BI tier intelligent reporting applets GUI portals.
    • Led the full-stack original applications generation' design concept and architectural definitions phases, as well as systems development and deployment including mentoring university graduate trainees and cross-departmental team members coordination.
    • Migrated and upgraded existing partial ingest systems built with SSIS and SQL Server 2014 into new architectures with Azure, Azure Data Factory, Azure SQL DB, SQL Server 2017, and the C#.NET framework.
    • Created an SQL artificial intelligence via a coding system that automatically analyzes flat file structures and seamlessly writes SQL coding to clean and transform big data into final BI systems layers using integrations of Data Factory and SQL.
    • Released an original platform ahead of schedule and under budget providing a pipeline-based suite of self-aware SQL architectures automatically processing millions of records of GB files blobs through efficient scalable few-minutes time durations.
    Technologies: Leadership, SQL Server 2017, Azure Data Factory, ETL, Data Architecture, SQL Server DBA, SQL Developer, System Migration, Upgrades, Optimization, Stored Procedure, Artificial Intelligence (AI), Business Intelligence (BI)
  • Publications and PaaS/SaaS Consultant, Creative Designer, and Technical Writer

    2020 - 2020
    NDA Client (via Toptal)
    • Created brand new customer-facing PaaS/SaaS IT publications genre and protocols and styluses guides. Wrote original PaaS/SaaS sales/technical manuals/brochures for multinational corporate insurance reseller IT platforms/applications product launches.
    • Collaborated directly with the CIO and executive/middle management to define a set of original creative publication genre concepts, designs, and procedurals relating to innovative insurance industry PaaS/SaaS platforms/applications rollouts.
    • Analyzed technical and logical aspects of, and literarily defined, ground-breaking multinational insurance reseller IT collaboration applications suites including cross-borders international insurance platforms and underwriting/communications tools.
    • Defined original publications design concepts and graphics/style guides, as well as publications protocols and methodologies including the creation of an original IT documentation genre combining PaaS/SaaS proprietary sales and technical elements.
    • Wrote sales and technical manuals and brochures, combining IT products' profiles, and marketing purposes and styles, as well as inter-/intra-national legal/compliance.
    • Created an original genre of proprietary PaaS/SaaS marketing and technical brochure publications, successfully branded and released client-facing sales and technical documentation, instituted internal procedures and protocols for technical writing.
    Technologies: Publishing, Writing & Editing, Systems Analysis, Insurance, code analysis, Testing Analyses, Collaborative Design, Graphic Design, Consulting, Legal, Compliance, Creative Concept Development
  • Systems and SQL Security Consultant

    2020 - 2020
    NDA Client (via Toptal)
    • 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 the CIO and executive management to analyze and improve security concerns relating to financial services clienteles logins and system access protocols and architectures.
    • Designed and led the development of automated login accounts and systems access controls scripting, reporting, and real-time auditing.
    • Optimized SQL and back-end tiers including stored procedure redesigns and enhancements, as well as ongoing SQL Server DBA consultation and instruction.
    • Architected and completed enhancements to full-stack integrations including .NET framework automation together with SQL APIs real-time security and login accounts reporting, auditing, and alerts modules.
    • Eliminated security breaches and login accounts discrepancies allowing for daily ongoing real-time automated login account protocols standardizations and efficacies, including intelligent reporting and analyses.
    Technologies: SQL Server DBA, SQL Server 2017, SQL, Stored Procedures, Security Design, Analytics, Security Testing, Role-based Access Control (RBAC), Optimization, Reporting, Leadership, Operational Streamlining, Security Analysis
  • Lead Systems Architect | Developer

    2019 - 2019
    NDA Client (via Toptal)
    • Led the development, redesigns, and optimizations for existing ERP integrated SQL Server and MS Access full-stack applications suites for multinational food suppliers conglomerates.
    • Collaborated directly with the CEO, CIO, and executive management to analyze and overhaul existing elements of the systems and to introduce new modules as per business development phases.
    • Added significant new modules to accommodate European regional expansions including currency analyzers, transport enhancements, and remote management suites.
    • Optimized and enhanced existing portions of the applications including stored procedures re-engineering, design flow pipelines, and GUI reductions simplifications.
    • Consulted with industry corporate partners and introduced streamlined architectural redesigns so as to properly integrate cross-platform APIs relating to shipping and receiving endeavors.
    • Optimized system and SQL errors, wait times and downtimes, and reduced business procedurals overheads including sales orders through delivery schedules, performance costs, and durations improvements.
    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
  • Lead VBA/Office Solutions Architect and Developer

    2019 - 2019
    NDA Client (via Toptal)
    • Led the architecture and development for an original MS Office/VBA/JSON solutions framework of one-click fully automated application for Excel sheets/tables/charts, data visualizations, and matching PowerPoint presentations generation.
    • Collaborated directly with the CEO of an HR business consulting firm to design/develop executive- and board-review data visualization materials of customized per-organization HR statistical analyses.
    • Defined a JSON data store architecture and designed/developed corresponding VBA data ingestion/parsing modules.
    • Automated actions with VBA for advanced/tailored Excel sheets/tables/charts data visualization generation per detailed formatting specifications stored in JSON source format including array/non-array relative/offset formulas, and pivot tables/charts.
    • Created VBA automations for Excel sheets/charts/tables data visualizations' translation into matching PowerPoint presentations, including master-slides/templates/custom-layouts, smart-arts/shapes, images/boxes, charts/tables, range-copies, and more.
    • Completed the final solution within the beta-phase projected time allotment, error-free and requiring no follow-up debugging/enhancement, and including features and specifications above and beyond original project requirements and parameters.
    Technologies: Data Visualization, XML, JSON, Visual Basic for Applications (VBA), Microsoft 365, Microsoft Access, Microsoft PowerPoint, Microsoft Excel
  • Project Manager | Lead Data Architect and Developer | BI Engineer

    2018 - 2019
    NDA Client (via Toptal)
    • Managed projects and led full-stack architecture/development for online multinational waste management data and BI analytics portals.
    • Collaborated directly with the CIO/CEO to upgrade and enhance legacy Dundas/SSIS waste data reporting/analytics systems to customized user row-level access and individualized real-time consumer BI dashboards/analytics report design/development/usage.
    • Integrated application tiers and modules, including multi-data-source points ingestion/transformation, an automated SQL-tier data archival/retrieval framework, and the web app data-ingestion framework.
    • Designed and developed new in-house administration and performance tracking/analysis modules.
    • Designed and developed standalone distributable MS 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 in new users per newer features capability, seamless upgrade/enhancement rollouts, error-free performances.
    Technologies: CSS, XML, JSON, Visual Basic for Applications (VBA), C#, T-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
  • Lead Data Architect and Developer | BI Engineer

    2018 - 2019
    NDA Client (via Toptal)
    • 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 the CIO/CRO and upper management 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.
    • Developed multi-data-source point ingestion/transformation/consolidation of financial corporate and consumer data, including in-house and third-party FTP flat-file, Azure BLOB, and remote SQL Server/Oracle.
    • Developed and integrated BI modules, including statistics/metrics/analytics data funding for reporting systems tiers.
    • Developed data tier self-monitoring/self-validation modules, including stored procedures and Azure/.NET C# real-time data processing self-check validations/reports/alerts for ongoing ETL/BI/SQL op's processes.
    • Completed/implemented each phase of the design/development ahead of schedule, allowing for the inclusion of significant expansions above/beyond originally intended data tier module features.
    Technologies: HTML, XML, JSON, C#, T-SQL, SQL, Microsoft Power BI, SQL Server Integration Services (SSIS), Machine Learning, Kubernetes, .NET, SQL Azure, Microsoft SQL Server, Azure, Windows Server
  • Senior SQL DBA, SQL Developer, Optimization Consultant

    2016 - 2017
    NDA Client (via Toptal)
    • Provided consultation support for optimization, administration, and development code for large mission-critical production SQL servers that were experiencing serious performance and stability issues running high-transaction OLTP commodities portals.
    • Collaborated directly with the CEO and upper management as a team lead for twelve-month intensive BE/BI optimization/enhancement and administration projects.
    • Led DB/BI administration, including comprehensive optimizations and implementations of standardized procedures for efficient performance/administration.
    • Consulted and trained for applications and BI development teams to improve SQL/BI coding techniques and architecture.
    • Provided administration/coding support for implementations of large/complex data modules as per rollouts of substantial new web applications platforms.
    • Helped bring the system from a weekly service and DB crashes/downtime, ~50k+ timeouts and ~12k+ deadlocks daily. Within the first two weeks, saw 100% uptime through the year’s end, and reduced timeouts to 0-15 daily and deadlocks to 0-5.
    • Completed all planned projects four months ahead of schedule, allowing the completion of three additional enhancement projects within the twelve-month contract term.
    Technologies: Amazon Web Services (AWS), SQL Server Data Tools (SSDT), Visual Studio, SQL Server Integration Services (SSIS), Microsoft SQL Server, SSRS, SSAS, Erwin, VBScript, T-SQL, SQL, Windows Server 2012, AWS
  • Senior Desktop Solutions Engineer, Web-based Upgrade Consultant, Senior SQL DBA

    2015 - 2016
    NDA Client (via Toptal)
    • Handled optimizations, enhancements, and additional module development for an international eCommerce ordering, invoicing, and inventory/shipping management applications suite that was experiencing serious performance issues.
    • Consulted on code refactoring for upgrades from MS Access VBA to ASP.NET.
    • Led the development of enhancements and optimizations for SP, API, GUI and reports operations which had serious issues with response times/crashing.
    • Developed and implemented substantial new full-stack modules, including comprehensive RMA (returned merchandise authorization) invoicing modules.
    • Consulted and provided coding support to refactor the existing Access VBA and SQL Server coding modules for a seamless upgrade to ASP.NET architectures.
    • Led DBA, including optimizations and implementations of standardized procedures and protocols for efficient performance/administration.
    • Eliminated all crashing and reduced response times for SP, API, GUI, and reports operations from 30-90+ seconds to 0-3 seconds per call/operation.
    • Completed all planned projects ahead of schedule and under budget, allowing the completion of several standby projects and optimizations.
    Technologies: Microsoft SQL Server, Visual Basic for Applications (VBA), T-SQL, SQL, Microsoft 365, Microsoft Access, Visual Studio 2012, Windows Server 2012
  • Senior Data/Desktop Solutions Engineer and Consultant, Senior DBA, Lead QA Engineer/IT Documenter

    2011 - 2015
    Freelance
    • Completed short- to long-term contracts for consultation and analysis, design, development, optimization, enhancement, validation, and administration of original and legacy data, desktop, and BI solutions.
    • Architected, designed, developed, deployed, validated, optimized, upgraded, and provided administration for original and legacy solutions.
    • Architected SQL databases, provided reports and BI solutions, performed QA, and wrote and edited IT documentation.
    • Consistently maintained a five-out-of-five star rating with online workspaces 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, SQL, Oracle, Microsoft 365, Microsoft Access, .NET, AWS, Windows
  • Partner in Charge of Data and Desktop Engineering

    2002 - 2010
    Startup IT Consulting Firm
    • Completed a variety of short- to long-term on-site contracts for consultation, analysis, design, development, optimization, enhancement, validation, and administration of original and legacy data, desktop, and BI solutions.
    • Generated contracts, handled initial consultations, led teams and projects, and implemented business analysis and development lifecycle processes.
    • Architected, designed, developed, deployed, validated, optimized, upgraded, and provided administration for original and legacy solutions.
    • Architected SQL databases, engineered reports and BI solutions, performed QA, wrote and edited IT documentation, and presented or spoke at IT conferences and seminars.
    • Remained consistently ahead of schedule and within/under budget, garnering excellent clientele reviews and frequent repeat/referral contracts.
    Technologies: Amazon Web Services (AWS), Visual Studio, Microsoft SQL Server, Erwin, JavaScript, C#, C++, Visual Basic for Applications (VBA), VB, PL/SQL, T-SQL, SQL, Oracle, Microsoft 365, Microsoft Access, .NET, AWS, Windows
  • Lead Systems Architect and Developer

    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.
    • Led DB architecture for in-house/clientele data systems.
    • Oversaw the full life cycle of new and original modules, from leading the development team and managing projects to supervising the QA team and IT documentation team.
    • Built reports and BI, including executive/head office reports and dashboards, desktop (GUI/full-stack), data mining/warehousing, and business analytics.
    • Liaised with clientele, including Ford, Aetna, and AIG, among others, speaking at national conferences/seminars, and providing on-site/remote customizations and support.
    • Doubled the solutions clientele during my tenure for substantial optimizations/enhancements and new features/functionality rollouts. Annual software and services sales and revenue grew ~65%, and customer satisfaction indexes increased by 45%.
    Technologies: Visual Studio, Microsoft SQL Server, Erwin, JavaScript, C#, C++, Visual Basic for Applications (VBA), VB, PL/SQL, T-SQL, SQL, Oracle, Microsoft 365, Microsoft Access, .NET, Windows
  • Partner in Charge of Data and Desktop Engineering

    1998 - 2000
    Startup IT Consulting Firm
    • Completed a variety of short- to long-term contracts for consultation and analysis, design, development, optimization, enhancement, validation, and administration of original and legacy data/desktop solutions.
    • Generated contracts and attended initial consultations, led the team and managed projects, provided business analysis, and implemented the development life cycle.
    • Architected original and legacy solutions and designed, developed, deployed, validated, optimized, upgraded, and provided administration for them.
    • Architected SQL databases, designed and optimized reports, provided QA services, and wrote and edited IT documentation.
    • Consistently ran ahead of schedule and within/under budget, generating excellent clientele reviews and frequent repeat/referral contracts.
    Technologies: Visual Studio, Microsoft SQL Server, Erwin, JavaScript, C++, Visual Basic for Applications (VBA), VB, PL/SQL, T-SQL, SQL, Oracle, Microsoft 365, Microsoft Access, Windows
  • Lead Developer and DBA

    1997 - 1998
    Metropolitan State College of Denver
    • Led the original executive accounting and BI RDBMS solution consultation, architecture, design, development, deployment, validation, and administration to automatically archive departmental college expenditures and analyze periodic repetitive costs.
    • Collaborated directly with the executive management, lead developer, and DBA (two subordinates) to provide business analyses and implement the development life cycle.
    • Architected, designed, developed, tested, deployed, provided ongoing enhancement, administration, and QA, and validated full-stack solutions.
    • Generated BI reports and dashboards, DBA for existing/new DBs, interfaces/transformations for the existing SQL Server, Oracle, and spreadsheet, and IT documentation.
    • Directly eliminated tens of thousands of dollars per year in operating and software licensing costs, and hundreds of labor hours (particularly in management bloat) per year.
    • Increased departmental efficiencies by 35%; institution-wide annual revenues increased 28% compared with previous yearly trends.
    Technologies: Microsoft PowerPoint, Microsoft Word, Microsoft SQL Server, Microsoft Excel, Visual Basic for Applications (VBA), VBScript, T-SQL, SQL, Oracle, Microsoft Access

Experience

Skills

  • 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, 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, Tableau, Microsoft Dynamics, Microsoft Dynamics CRM, Microsoft Dynamics NAV, Microsoft Power BI, AWS ECR, AWS EBS, AWS ECS, Erwin, Microsoft Word, Microsoft PowerPoint, Visual Studio, Visual Studio 2012, SSRS, 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, AWS 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 Developer, 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, PostgreSQL, MySQL, AWS S3, NoSQL, SQL Server Data Tools (SSDT), SQL Azure, JSON, PL/SQL
  • 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 Analyst, 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, Stored Procedures, Data Engineering, RESTful APIs, Consulting, IT Consulting, Technical Consulting, Technology Consulting, Management Consulting, Project Consultancy, Business Consulting, IT Systems Architecture, SaaS, 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, Code 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 Reports, 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, Systems 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, RTOS, SSRS Reports, Data Analysis, Query Optimization, Data, Data Migration, Data & Backup Management, Data Architecture, Macros, Software Consulting, Writing & Editing, AWS, Microsoft 365, Machine Learning, Data Visualization, APIs, Optimization, Enterprise Design, GUI Design, Security Design, Security Testing, Reporting, Operational Streamlining, Security Analysis, Publishing, Systems Analysis, Testing Analyses, Collaborative Design, Graphic Design, Legal, Creative Concept Development, System Migration, Upgrades, Artificial Intelligence (AI)
  • Frameworks

    .NET

Education

  • Post-graduate degree in Sociolinguistics & Music Performance
    2009 - 2011
    University of Colorado at Denver - Denver, Colorado
  • Bachelor's degree in Computer Science, Photography, and Music Performance
    1994 - 1996
    University of Colorado at Denver - Denver, Colorado
  • Associate's degree in Computer Science, Psychology & Music Performance
    1989 - 1991
    Brigham Young University - Provo, Utah

To view more profiles

Join Toptal
Share it with others