Databases
Steven's strongest technical work is with relational databases used by ERP and related business applications. Application DBA skills of schema, queries, procedural code, and application performance are the focus, more so than operational concerns such as storage management and replication.
PostgreSQL (~20 years experience)
Schema design, SQL, PL/pgSQL, transaction/concurrency behavior, indexing, and application performance. Also backups, SQL/MED, full text search, and PostGIS where the engagement required them.
Significant Projects- Item/BOM conversion programs (source → transform → stage/validate → deploy)
- Retail chain data migration/merge
- Medical pricing search database
- Inventory costing/valuation overhaul
- ERP Dual Unit of Measure enhancement
- Shipping container fulfillment module
- Customer product catalog module
- Sales order product configurator module
- Multi-ERP SQL/MED integration
- Legal/financial services client-portal database
- Data integrations (Pentaho PDI, Boomi)
Oracle (~10 years experience)
Oracle was once Steven's primary database, covering OLTP performance, PL/SQL, administration, and chain retail-scale batch work.
Significant Projects- Retail chain data migration/merge
- Emergency database server replacement
- Batch style mass data maintenance
- Performance analyses
- Install & configure (Solaris & Linux based environments)
Other Databases
Occasional Microsoft SQL Server and MySQL work — installation, configuration, and project-duration support. Also managed teams operating MS-SQL applications.
ERP Applications & Integration
xTuple ERP, Qt, and C++
Steven has spent many years extending xTuple ERP: PostgreSQL on the server, a Qt Widgets desktop client, QtScript for forms and new functionality, and C++ where core product changes were required. Recent manufacturing work continues on that stack, including conversion programs, custom UI for lot quality status, inbound EDI staging, and warehouse relocation forms that had to remain usable at thousands of locations.
Significant Projects- Item/BOM restructuring conversion (PostgreSQL)
- Lot quality status management (custom UI over warehouse locations)
- Inbound EDI 810 sourcing-staging-import
- Inventory relocation UX (QtScript)
- Shipping container fulfillment module (QtScript)
- Customer product catalog (QtScript)
- Enhanced user defined fields and form builder (QtScript)
- Sales order product configurator enhancement (C++)
- Dual Unit of Measure enhancement (C++)
- Inventory costing/valuation refresh (C++)
ExamplesQtScript examples are provided; Steven does not hold rights to redistribute the C++ product work. Screenshots of the sales order product configurator forms appear in the training documentation.
NetSuite, ETL, and integration
NetSuite customization (SuiteScript/SuiteFlow) and integration between ERP and bespoke PostgreSQL systems, including Boomi and Pentaho Data Integration. SQL/MED has also been used to span more than one ERP database in place.
Other Languages & Tools
Steven has worked with a variety of other languages and tools over the course of his career. His experience and recency varies by each technology.
- JavaScript (Node.js, other)
Outside of QtScript, occasional Node.js tooling and lighter application or client support work.
- Java/Groovy
Internal utilities in Java, and Groovy in Boomi integration mappings.
- Boomi
Implemented and maintained integrations between NetSuite and bespoke client-portal PostgreSQL databases.
- Pentaho Data Integration
Multiple implementations including SaaS-to-on-premise ERP feeds and end-user data upload.
- Web / Hugo
Author of this site's theme and content, and of the Muse Systems marketing site — Hugo, HTML, CSS, and Tailwind CSS.
- Elixir / Phoenix (R&D)
The Muse Systems Business Management System is a small ERP-class system in Elixir, Phoenix, and PostgreSQL. It is a work in progress used as a playground and proving ground, not a production client system.