Stephen Flammer

Stephen Flammer

Makati, NCR, Philippines
Hire Stephen
Scroll To View More
Stephen Flammer

Stephen Flammer

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
  • Microsoft SQL Server, 20 years
  • Full-stack Development, 20 years
  • Desktop App Development, 20 years
  • SQL Developer, 20 years
  • DBA, 20 years
  • Software Consulting, 20 years
  • Documentation Writing, 20 years
  • MS Access, 20 years
Makati, NCR, Philippines
Availability
Full-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
  • Senior SQL DBA, SQL Development, and Optimization Consultant
    NDA (via Toptal)
    2015 - 2016
    • 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 mgmt. 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
  • Senior Desktop Solutions Engineer, Desktop to Web-based Upgrade Consultant, and Senior SQL DBA
    NDA (via Toptal)
    2015 - 2015
    • 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
    Freelance
    2011 - 2015
    • 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
    Startup IT Consulting Firm
    2002 - 2010
    • 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
    Reed Group, Ltd.
    2000 - 2002
    • Led solutions architecture, design, development, deployment, enhancement, and administration of official U.S. 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 U.S.
    • 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/functionalities 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
    Startup IT Consulting Firm
    1998 - 2000
    • 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
    Metropolitan State College of Denver
    1997 - 1998
    • 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.
    • Departmental efficiencies increased 35%, and 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), T-SQL, SQL, VBScript, Stored Procedure, VB, Python
  • Libraries/APIs
    Microsoft Office API
  • Tools
    Microsoft Excel, SSAS, Microsoft Access
  • Paradigms
    Entity-relationship Diagrams, Desktop App Development, Database Design
  • Platforms
    Windows, Oracle
  • Storage
    Database Modeling, Database Lifecycle Management (DLM), Relational Databases, SQL Server Integration Services (SSIS), RDBMS, Microsoft SQL Server, SQL Server 2008, SQL Developer, SQL Server 2014, DBA, SQL Server DBA, Database Replication, SQL Server 2016, SQL Server 2008 R2, SQL Server 2012, SQL Server 2005, Database Management, Database Management Systems (DBMS), Database Architecture, SQL Server Service Broker, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Triggers, MS Access, SQL Server Management Studio, MySQL DBA, MySQL, NoSQL, PL/SQL
  • Misc
    SSRS Reports, Data Analysis, Query Optimization, Software Consulting, Documentation Writing, Documentation, Macros, Relational Data Mapping, Data Modeling, Data & Backup Management, Data Migration, Data, Full-stack Development, QA Test Plan Management, Troubleshooting, Software QA, QA Automation, Team Leadership, Data Architecture, MS Office Automation, RTOS, AWS S3, AWS EBS, AWS ECS, AWS ECR
  • Frameworks
    .NET
Education
  • Post-graduate degree in Sociolinguistics & Music Performance
    University of Colorado at Denver - Denver, Colorado
    2009 - 2011
  • Bachelor's degree in Computer Science, Photography, and Music Performance
    University of Colorado at Denver - Denver, Colorado
    1994 - 1996
  • Associate's degree in Computer Science, Psychology & Music Performance
    Brigham Young University - Provo, Utah
    1989 - 1991
I really like this profile
Share it with others