All projects on this page are demonstration examples. They show the type of problems SWS solves and will be replaced with real write-ups when published work is available.
Demonstration example
A faster view of stock without gathering several spreadsheets by hand.
Problem: stock is kept in several tables and is lost when they are updated.
Solution: a desktop program with a single list, search and export.
Stack: a Windows desktop application, a local database.
Result: less manual gathering and a clearer picture of what is in stock.
Open for problem, solution and result.
Demonstration example
Clients and the team see status in one place instead of over email.
Problem: requests arrive by phone and email with no shared status.
Solution: a web application with roles, comments and history.
Stack: web interface, server side, database.
Result: faster service and fewer lost requests.
Open for problem, solution and result.
Demonstration example
A clear structure, contacts and an enquiry form.
Problem: services are not described clearly and enquiries arrive incomplete.
Solution: a site with structure, contacts and a project form.
Stack: HTML, CSS, JavaScript, search-engine preparation.
Result: the visitor understands what is offered and how to start a conversation.
Open for problem, solution and result.
Demonstration example
Recurring reports are generated with fewer manual steps.
Problem: the same manual steps are repeated every month.
Solution: a rule that gathers data and writes a finished file.
Stack: scripts, a scheduler, a check of the result.
Result: less manual work and a more predictable report deadline.
Open for problem, solution and result.
Demonstration example
Unique records instead of duplicated names in several places.
Problem: the same clients are stored in different ways in several places.
Solution: a normalised database and reports with unique records.
Stack: a relational database, migration from spreadsheets.
Result: better organisation and fewer duplicate records.
Open for problem, solution and result.
Demonstration example
Orders move across without being retyped by hand.
Problem: orders are copied by hand from one screen to another.
Solution: API integration with error checks and a log.
Stack: REST API, a retry queue, a log.
Result: fewer transfer mistakes and faster processing.
Open for problem, solution and result.