Scroll To View More
Stephen Flammer, Software Developer in Makati, NCR, Philippines
Stephen Flammer

Software 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. He is an expert MS SQL database administrator, QA engineer, documentation specialist, and English/Spanish translator.
Stephen is now available for hire

Portfolio

  • NDA (via Toptal)
    AWS, Windows Server 2012, MS SQL Server (incl. SSIS/SSAS/SSRS) 2014–2016...
  • NDA (via Toptal)
    Windows Server 2012, SQL Server 2008-2012, Visual Studio 2012...
  • Freelance
    Windows, AWS, SQL Server 2005-2014, VS 2005-2015, .NET...

Experience

  • Writing, 20 years
  • Microsoft SQL Server, 20 years
  • Database Administration (DBA), 20 years
  • Desktop App Development, 20 years
  • SQL Developer, 20 years
  • Oracle, 20 years
  • Full-stack, 20 years
Makati, NCR, Philippines

Availability

Part-time

Preferred Environment

Windows, AWS, SQL/T-SQL, SQL Server, Access, VBA

The most amazing...

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

Employment

  • Freelance Senior SQL DBA, SQL Development, and Optimization Consultant

    2016 - 2017
    NDA (via Toptal)
    • Provided consultation and support on optimizations, ongoing administration, and development coding for large mission-critical production SQL servers that were experiencing serious performance and stability issues running high-transaction OLTP global commodities marketplace platform application suites and portals.
    • Collaborated directly with the CEO and upper management as 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 weekly service and DB crashes/downtime, ~50k+ timeouts and ~12k+ deadlocks daily. Within the first two weeks, saw 100% uptime thru year’s end, reduced timeouts to 0-15 daily and deadlocks to 0-5.
    • Completed all planned projects four months ahead of schedule, allowing completion of three additional enhancements projects within the twelve-month contract term.
    Technologies: AWS, Windows Server 2012, MS SQL Server (incl. SSIS/SSAS/SSRS) 2014–2016, Visual Studio (incl. SSDT) 2012–2015, SQL, T-SQL, VBScript
  • Freelance Senior Desktop Solutions Engineer, Desktop to Web-based Upgrade Consultant, and Senior SQL DBA

    2015 - 2016
    NDA (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 and coding support for refactoring the existing Access VBA and SQL Server coding modules for 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 completion of several standby projects and optimizations.
    Technologies: Windows Server 2012, SQL Server 2008-2012, Visual Studio 2012, Access/Office 2007–2013, SQL, T-SQL, Access SQL, VBA
  • Senior Data and Desktop Solutions Engineer and Consultant, Senior SQL 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, did QA, and wrote and edited IT documentation.
    • Consistently maintained a 5 out of 5 star rating with online work spaces throughout my tenure.
    Technologies: Windows, AWS, SQL Server 2005-2014, VS 2005-2015, .NET, Access/Office 2003-2013, Oracle, SQL, T-SQL, PL-SQL, Access SQL, VB, VBA, C++, C#, JavaScript
  • 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 life cycle processes.
    • Architected, designed, developed, deployed, validated, optimized, upgraded, and provided administration for original and legacy solutions.
    • Architected SQL databases, engineered reports and BI solutions, did 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: Windows, AWS, SQL Server 6.5-2008, VS 6.0-2010, .NET, Access/Office XP-2010, Oracle, SQL, T-SQL, PL-SQL, Access SQL, VB, VBA, C++, C#, JavaScript
  • Lead Software 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 suite utilized by 450+ of the Fortune 500 and most large-/mid-sized orgs in the US.
    • Optimized, enhanced, refactored, and upgraded existing modules, including .NET upgrades.
    • Led DB architecture for in-house/clientele's 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, speaking at national conferences/seminars and providing on-site/remote customizations and support, including Ford, Aetna, and AIG, among others.
    • Doubled the solutions clientele during my tenure for substantial optimizations/enhancements and new features/functionality rollouts. Annual software and servicing sales and revenue grew ~65%, and customer satisfaction indexes increased by 45%.
    Technologies: Windows, SQL Server 6.5-2000, VS 6.0-2002, .NET, Access/Office 1997-XP, Oracle, SQL, T-SQL, PL-SQL, Access SQL, VB, VBA, C++, C#, JavaScript
  • 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: Windows, SQL Server 6.0-2000, VS 6.0, Access/Office 1995-2000, Oracle, SQL, T-SQL, PL-SQL, Access SQL, VB, VBA, C++, JavaScript
  • Lead Developer and DBA

    1997 - 1998
    Metropolitan State College of Denver
    • Led consultation, architecture, design, development, deployment, validation, and administration of a completely original executive accounting and BI RDBMS solution to automatically archive departmental college expenditures and automatically analyze periodic and repetitive cost efficiencies.
    • Collaborated directly with executive management, lead developer, and DBA (2 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 100s 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: MS SQL Server 6.0-6.5, MS Access/Office 1995-1997, Oracle, SQL, T-SQL, Access SQL, VBScript, VBA, Access, Excel, Word, PowerPoint

Experience

Skills

  • Languages

    Visual Basic for Applications (VBA), Stored Procedure, VBScript, VB, SQL, T-SQL, Python
  • Libraries/APIs

    Office API
  • Tools

    Microsoft Access, SSAS, Microsoft Excel, Microsoft Power BI, AWS ECR, AWS EBS, AWS ECS
  • Paradigms

    Desktop App Development, Entity-relationship Diagrams, Database Design
  • Platforms

    Windows, Oracle
  • Storage

    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, MySQL DBA, MySQL, AWS S3, NoSQL, PL/SQL
  • Other

    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
  • 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
I really like this profile
Share it with others