Stephen Flammer
$55/hr
Data & BI & full-stack engineering/development, DBA, technical writer
Stephen Hans Flammer
Denver, USA; Manila, PH; Istanbul, TK
--
Profile
18 years’ data & cloud & desktop full-stack & BI/ETL solutions architect & developer & administrator; senior SQL DBA; senior, lead, mentor collaborations.
Lead/remote & owners/executives & users/customers collaborations; business & cross-departmental comms & liaison; IT & data & SDLC strategist.
Advanced data & cloud & full-stack solutions development & optimizations: all aspects incl. architecture/design/procedural/performance/SQL/coding.
Senior SQL DBA: cloud/VM/on-prem; advanced architectures, optimizations, features & coding; 24/7 on-call; VLDB; hardware/security; RTO/DR/HA.
Advanced data & SQL architecture & modelling: cloud/web/desktop full-stack paradigms; diagram — relational, mixed OOD, entity relationship.
Cloud advanced architecture & development & administration: DB, warehouse, lake, ETL tools; queue, BLOB; apps; containerization, microservices.
BI & ETL & data visualizations & dashboards: warehouse/lake/CUBE/OLAP, ELT/ETL transforms incl. cloud tools, SQL/script, cross-DB, BLOB/files/sheet.
Original solutions concept thru post-production SDLC; legacy systems administration/optimization/enhancement/refactoring/migration/upgrade.
Business analyses & liaison & solutions requirements definition & interpretation: concept & architectural & coding tiers & GUI origination & planning.
Comprehensive solutions profiles: cloud/VM/on-prem, enterprise/small organization, distributed, home/single-user; 1-/2-/3-/n-tier architectures.
All industries: ERP/CRM, aerospace, fintech, wholesale/retail, pharma, insurance, manufacturing, eCommerce, food/beverage, transport, others.
Desktop full-stack architecture & design & coding: front-end & GUI architecture, layout, design & coding; back-end & mid/n--tiers design & coding.
VB/VBA/Access/Office engineering & automations: advanced architectures & features incl. client-server sim., sub-classing, formatting/publishing.
Senior QA engineering: test planning; automations & scripting; proprietary QA systems design & deployment; QA reporting & documentation.
Senior IT documenter: publication; administrative & presentation; technical; procedural & diagram; user & process — support & guide; QA.
Translation & IT conference & seminar presentation & instruction: English–Spanish/Spanish–English; corporate internal; user; academic.
Windows/Azure; AWS; MSSQL 6.5–2022(SSIS/SSAS/SSRS); VS/.NET/VB 6.0–2022(SSDT); Access/Office/VBA-; Oracle; MySQL; Postgre; SAP.
SQL; T-SQL; PL-SQL; NoSQL; Data Factory; Databricks, Synapse; Power BI; Tableau; Redshift; C#; Python, R, Java; BLOB/CSV; XML; JSON; Powershell.
Professional Experience
SENIOR REMOTE DATA, CLOUD, DESKTOP FULL-STACK, BI/ETL ENGINEER; SENIOR REMOTE SQL DBA; TECHNICAL WRITER
Senior software engineer/DBA/technical writer — Top Talent (Toptal.com) senior engineering recruitment platform; remote
2015 – 2023
Toptal.com is premier fully managed senior remote software engineering recruitment platform for top proven 3% professionals world-wide; highly successful variety
of projects; data & cloud & full-stack & BI & ETL & AI solutions architect & developer & strategist; senior SQL DBA cloud/VM/on-prem; concept thru post-production
origination/development/deployment/administration comprehensive/subset SDLC; lead & remote & schedule-flexible/on-call collaborations; legacy & troubled
solutions administration/optimization/enhancement/resolutions/refactoring/migration/upgrade; business analysis & requirements definition & interpretation; user
& customer & cross-department communications & liaison; senior QA engineering; IT publication & article & documentation; SQL & code & writing & QA mentoring.
Senior DBA, lead data/apps/BI/ETL architect/developer — Multinational publisher (NDA), author’s anthologies editors —-
Collaborated directly with owners/execs/users to originate anthologies editing suites for world-class authors who write 100s-1000s+ books/articles.
Analyzed extensive requirements/specifications incl. international/multi-language collaborations to define advanced anthologies editing features.
Delivered complete solution exceeding expectation as sole architect/developer ahead of schedule/under budget via integrated RAD/QA/documents.
Administered/installed/maintained DBs; developed all data/apps tiers; included extra unplanned BI modules and extensive tech/user documents.
500+ independent users; MSSQL 2022 VM/Azure SQL BE; Access/Word/Excel/Powerpoint/Power BI FE; VBA libraries mid-tiers; Adobe/Photoshop.
Senior DBA, lead data/BI/ETL architect/developer, apps coding mentor — Starbucks, EE 3D VR training solutions origination — 2022
Collaborated directly with owners/execs/users to originate employee virtual reality 3D training solutions to fully replace human-based orientations.
Reduced original project plan/budget estimates over 200% by simplifying pre-prototype concepts using streamlined 3-tier SQL/logic/UI standards.
Released production version with zero run-time errors far ahead of schedule utilizing SQL-direct stored proc REST APIs and integrated SQL BI modules.
Administered/installed/maintained DBs; developed all data tiers; mentored team of 12 Unity C# coders to implement simplified cloud frameworks.
Integrated QA/documentation; MSSQL ’17-’22 VM/Azure SQL/Data Factory BE; Unity 3D C#/VS ’22/Power BI/Tableau/Excel FE; SQL/SSIS mid-tiers.
Senior DBA, lead data/apps/BI architect/developer, mentor — Kavak, eCommerce fintech SAP admin modules origination — 2021
Collaborated directly with owners/execs/users to originate VBA/.NET/Office online automobile lending SAP data/BI management/analytics modules.
Significantly reduced project span/budget via robust/simplified design and integrated RAD/QA; led architecture/analyses; developed all full-stack tiers.
Created innovative Access/Office-based sub systems to interface/analyze/manage SAP ERP data for multinational real-time fintech OLTP warehouses.
Administered/installed/maintained DBs; mentored satellite teams of senior/junior office/.NET developers indirectly coordinated with project scopes.
MSSQL ’12-’19 VM/Azure SQL/Data Factory BE; Office/VBA/Access/Word/Excel/Powerpoint/Outlook/Power BI FE; VS/SSIS ’15-’19 mid-tiers.
Senior DBA, lead data/BI/ETL architect/developer, mentor — Bespoke, pharma medicines success prediction AI origination — 2020
Collaborated directly with owners/execs/users to originate ETL-based BI full-stack AI solution to predict UK NHS pharma medicine/device success rates.
Upgraded pre-prototype SSIS/cloud app based ETL to Data Factory/SQL stored proc BLOB-direct ELT design reducing waits hours/days to sec.’s/min.’s.
Simplified project plans releasing full production version ahead of schedule/under budget transforming billions/daily BLOB/CSV rec.’s with zero errors.
Administered/installed/upgraded/migrated DBs; developed all data/BI tiers; mentored one junior DBA, two junior app coders/testers/documenters.
MSSQL ’12-’19 VM/Azure SQL/AWS Redshift/Data Factory BE; Access/Office/VBA/Power BI/Excel FE; VS/SSIS ’19/Synapse mid-tiers; JIRA; MS Project.
IT/data strategist, lead author & tech writer — Swiss RE, IT/data consulting & publications origination/styles formulation — 2020
Collaborated directly with owners/execs/users/customers to consult IT/data strategy for industry-changing innovative insurance B2B platform.
Authored/originated publications/styles for composite hybrid technical/sales/marketing/user/brochure formats reduced to singular pub.’s literatures.
Advised technical teams to architectural and procedural topics relating to data tiers/flow designs, rollout protocols, post-production data administration.
Released publications ahead of schedule/under budget exceeding originally planned formats to include additional sections/features/styles/elements.
MSSQL ’12-’19 VM/Azure SQL/Data Factory/AWS Redshift/MySQL BE; web FE; VS/.NET/SSIS ’19/Kubernetes mid-tiers; Adobe/Word/Photoshop.
Senior DBA, lead data architect/developer, tech writer, mentor — Data Masons, fintech solutions security optimizations — 2020
Collaborated directly with owners/execs/users to enhance security for confidential fintech system and document internal/external manuals/protocols.
Enhanced/optimized/refactored data tiers’ security architectures and protocols for sensitive financial information/invoicing warehouses/OLTP systems.
Completed ahead of schedule/under budget via integrated QA/documentation allowing additional unplanned failover/replication/query optimizations.
Administered/installed/upgraded/migrated DBs; developed all data tiers enhancements; led two junior DBAs, two junior app testers/documenters.
MSSQL ’08-’19 VM, on-prem/Azure SQL/Data Factory/Databricks BE; Power BI/Excel FE; VS/SSDT ’19/.NET/VB mid-tiers; Adobe/Word/Photoshop.
Top Talent (Toptal.com) Senior Software Engineer/DBA/Technical Writer/QA Engineer (continued)
Senior DBA, lead data/apps/BI architect/developer — Greenwood, multinational food supply custom ERP refactoring —-
Collaborated directly with owners/exec’s/users to optimize/enhance custom MSSQL/Access ERP per performance issues and business expansions.
Reengineered existing data modules for simplified/robust architectural enhancements; optimized full-stack layers; developed UI/reporting modules.
All project phases completed ahead of schedule/under budget allowing for additional unplanned phases for European market expansions modules.
Administered/installed/upgraded/migrated DBs; mentored one junior DBA, one junior BI engineer, one junior app tester, one junior documenter.
MSSQL ’08-’17 VM, on-prem/Azure SQL/AWS/Redshift/MySQL BE; Access/Word/Excel/Powerpoint/Power BI FE; VS/.NET/SSIS ’13-’17 mid-tiers.
Lead apps/BI architect/developer, tech writer, mentor — Rylan Grady, data/statistics analytics visualizations automations — 2019
Collaborated directly with owners/users to originate VBA/JSON/XML Office automation solution to process/present statistical HR data interpretation.
Original concept thru post-production rollout and administration design/apps development; mentored two junior apps developers, one junior tester.
Completed project ahead of schedule/under budget allowing for additional unplanned phases incl. post-data visualization interpretive AI modules.
Entire solution incl. AI interpretive modules were highly accurate rendering resolution to various major industrial/social marketing projects successes.
Integrated QA/documentation; developed BI/full-stack tiers; Azure/AWS, BLOB/CSV; XML/JSON; Python; Access/Word/Powerpoint/Excel; Adobe.
Senior DBA, lead data/apps/BI/ETL architect/developer, mentor — Fundu, corporate lending AI platform origination —-
Collaborated directly with execs/users to originate multinational corporate lending AI for fintech risk matrices analyses using innovative data points.
Significantly simplified/enhanced original plans utilizing SQL-direct APIs, stored procedure BLOB/CSV-direct stream, SQL/stored procedure-direct BI.
Completed each phase ahead of schedule/under budget allowing for additional modules incl. SQL AI smart self-monitoring, user/tech manuals.
Administered/installed/upgraded/migrated DBs; developed data/BI/ETL/back-end tiers; led two front-end coders, one tester, one documenter.
MSSQL ’12-’19 VM/Azure SQL/Data Factory BE; web/Access/Excel FE; VS/SSIS/.NET/VB ’19/Kubernetes/Python/R mid-tiers; Adobe/Powerpoint.
Senior DBA, lead data/BI/ETL architect/developer, mentor — Rapaport, commodities portals admin & refactoring —-
Collaborated directly with owners/execs to administer/optimize all DBs and optimize full-stack/BI modules for legacy global diamonds trading suites.
Administered/upgraded/migrated dozens of VLDBs incl. extensive optimizations to administrative routine and schema/procedure/query/function.
Resolved all db/data issues incl. reduced 60k+ locks/timeouts daily to zero in first 2-4 weeks via advanced index/query tuning/maint. techniques.
Reduced OLTP waits min.’s to fractions/sec.’s, BI waits hours to min.’s/sec.’s; led twelve senior/junior web coders, one junior DBA, one junior tester.
Developed data/BI tiers; MSSQL ’12-’17 VM, on-prem/Azure SQL/AWS Redshift BE; web/Access/Excel FE; VS/SSIS/.NET/VB ’17/Python mid-tiers.
Senior DBA, lead data/apps architect/developer, mentor — Fast Growing Trees, eCommerce custom ERP refactoring —-
Collaborated directly with owners/execs/users to optimize & enhance agricultural online sales/shipments ERP apps per substantial business growth.
Architected/developed refactoring to legacy modules and originated enhanced modules incl. sales/shipping features, market expansions modules.
Completed phases ahead of schedule/under budget per integrated QA/documentation allowing for additional BI modules and tech/user manuals.
Resolved all system issues incl. reduced 100s+ run-time errors daily to zero, eliminated data errors, OLTP/BI waits hours/min.’s to fractions/sec.’s.
Led/mentored one junior DBA, one junior coder; MSSQL ’08-’17 VM, on-prem/MySQL/Access BE; Access/Excel FE; VS ’15/VBA libraries mid-tiers.
Senior DBA, lead data/apps architect/developer, mentor — Aerospace multi-national (NDA), custom ERP origination —-
Collaborated directly with execs of venture capital restart to completely replace paper-based aerospace engineering projects mgmt. with custom ERP.
Original concept thru pre-production rollout design/full-stack development; mentored two junior coders, one junior tester, one junior documenter.
Significantly simplified original architecture designs, completing project phases ahead of schedule/under budget, allowing for additional BI modules.
Administered/installed/upgraded/migrated several DBs; developed original DBs/data tiers; developed apps/BI tiers; integrated QA/documentation.
Highly successful 100%+ ROI first 24 mo.’s venture start; MSSQL ’08-’12 VM/Azure SQL/MySQL BE; VBA/Access/Excel FE; VS/SSIS ’13-’15 mid-tiers.
SENIOR REMOTE DATA, CLOUD, DESKTOP FULL-STACK, BI/ETL ENGINEER; SENIOR REMOTE SQL DBA; TECHNICAL WRITER
Senior software engineer/DBA/technical writer — Elance.com (Upwork.com) senior freelancing platform; remote
2012 – 2015
Elance was premier independent remote software engineering freelance platform (merged Upwork.com) for top professionals world-wide; highly successful variety
of projects; data & cloud & full-stack & BI & ETL & AI solutions architect & developer & strategist; senior SQL DBA cloud/VM/on prem; concept thru post-production
origination/development/deployment/administration comprehensive/subset SDLC; lead & remote & schedule-flexible/on-call collaborations; legacy & troubled
solutions administration/optimization/enhancement/resolutions/refactoring/migration/upgrade; business analysis & requirements definition & interpretation; user
& customer & cross department communications & liaison; senior QA engineering; IT publication & article & documentation; SQL & code & writing & QA mentoring.
Senior QA engineer, apps developer, tech writer, mentor — Coffee wholesaler/retailer (NDA), custom ERP deployment —-
Collaborated directly with owners/execs/users of multinational coffee supplier to test mid-sized custom ERP for pre- and post-production rollout.
Supported application/SQL/mid-tiers tiers coding; led one junior tester, two junior documenters to deploy, originate hundreds/pages user manuals.
99%+ defects/errors resolutions; MSSQL 2012 DB; Access 2012 FE; VB.COM mid-tier; 50+ simultaneous users; JIRA; MS Project; Adobe/Word.
Lead apps architect/developer, senior QA engineer, tech writer — Four Winds, realty admin solutions refactoring —-
Collaborated directly with owners/execs/users to reengineer legacy app and architect/develop original replacement solution per business growth.
System improvements reduced staff hours 35%+; integrated QA/documentation; led one junior writer, originated hundreds/pages manuals.
5-15 simultaneous users; Access 2012 BE; ; Access/Crystal/Excel FE; VS/VBA/Access objects/libraries mid-tiers; JIRA; MS Project; Adobe/Word.
Senior DBA, lead data/apps/BI/ETL architect/developer, senior QA engineer, mentor — Krujex, custom ERP refactoring —-
Collaborated directly with owners/execs/users/customers to rebuild/optimize legacy transnational transport systems per business growths/expansions.
Administered/upgraded/optimized ~dozen DBs; eliminated all errors, reduced waits hours/min.’s to fractions/sec.’s, led three junior DBAs/dev.’s.
Integrated QA/documentation; MSSQL ’08-’15 VM, on-prem/Azure SQL BE; VBA/Access/Excel FE; custom Access QA solution; Adobe/Word.
Senior DBA, lead data/apps/BI/ETL architect/developer — Multinational realtor (NDA), investments predictions AI —-
Collaborated directly with owners/users concept thru production to originate realty/marketing investment prediction AI solution for properties ROI.
Profits increased 25%+ within first two years per app usage; completed ahead of schedule/under budget incl. additional unplanned BI modules.
Integrated QA/documentation; MSSQL ’12 VM BE; VBA/Access/Access/Crystal/Excel FE; custom Access QA solution; MS Project; Adobe/Word.
Senior DBA, lead data/apps architect/developer, senior QA engineer, tech writer — Marketer (NDA), ERP origination —-
Collaborated directly with owners/execs/users to originate custom ERP to replace legacy system; completed ahead of schedule and under budget.
Profits increased ~30%+ yearly per application usage; administered/upgraded/migrated/optimized several DBs; developed all data/mid/apps tiers.
Integrated QA/documentation; MSSQL ’08-’12 VM, on-prem/MySQL BE; VBA/Access/Excel FE/mid-tiers; custom Access QA solution; Adobe/Word.
Academic Qualifications
Sociolinguistics, Music Performance, Photography — University of Colorado at Denver; Denver, Colorado, USA
Computer Science, Music Performance, Photography — University of Colorado at Denver; Denver, Colorado, USA
Computer Science, Music Performance, Psychology — Brigham Young University; Provo, Utah, USA
Page 2
Post-Graduate
Bachelors
Associates
StephenHans Flammer
