Stephen Flammer, Writing & Editing Developer in Makati, NCR, Philippines
Stephen Flammer

Writing & Editing 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)
    MS Office/VBA(Excel/PowerPoint/Access) 2016, JSON, XML, Data Visualization
  • NDA (via Toptal)
    Windows Server 2012-2016, Azure, MS SQL/Azure SQL 2016-2017, .NET, HTML/CSS...
  • NDA (via Toptal)
    Windows Server 2012-2016, Azure, MS SQL/Azure SQL 2016-2017, .NET/Kubernetes...

Experience

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

Location

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

  • Lead VBA/Office Solutions Architect/Developer

    2019 - 2019
    NDA (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 JSON data store architecture and designed/developed corresponding VBA data ingestion/parsing modules.
    • Automated actions using VBA for advanced/tailored Excel sheets/tables/charts data visualization generation per detailed formatting specifications stored in JSON source format, including conditional array/non-array relative/offset formulas, pivot tables/charts, shapes/text boxes, text/cell/row/column formatting options, etc.
    • Created VBA automations for translation of Excel sheets/charts/tables data visualizations into matching PowerPoint presentations, including master-slides/templates/custom-layouts, smart-arts/shapes, images/boxes, charts/tables, range-copies, etc.
    • 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: MS Office/VBA(Excel/PowerPoint/Access) 2016, JSON, XML, Data Visualization
  • Project Manager, Lead Data Architect/Developer, BI Engineer

    2018 - 2019
    NDA (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 support and deliver customized user-specific 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, 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 on-boarding several hundred percent in new users per additional feature/capability, with seamless upgrade/enhancement rollouts, and error-free end-user applications performance.
    Technologies: Windows Server 2012-2016, Azure, MS SQL/Azure SQL 2016-2017, .NET, HTML/CSS, MS Acces/Office, Dundas BI, Power BI, SSIS, SQL, TSQL, C#, VBA, JSON, XML
  • Freelance Lead Data Architect/Developer, BI Engineer

    2018 - 2019
    NDA (via Toptal)
    • Led data systems architecture and development for the infancy-thru-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 designing, developing and implementing integrated data tiers/mid-tiers/BI-tiers for machine-learning-based lending decision engine for online lending portals wholesaling/retailing/reselling.
    • Developed multi-data-source points 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 design/development ahead of schedule, allowing for inclusion of significant expansions above/beyond originally intended data tier module features.
    Technologies: Windows Server 2012-2016, Azure, MS SQL/Azure SQL 2016-2017, .NET/Kubernetes, Machine Learning, SSIS, Power BI, SQL, TSQL, C#, JSON, XML, HTML
  • 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 (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 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, Azure, 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, Azure SQL, 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 & Editing
  • 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
I really like this profile
Share it with others