Operational records
Related business data that supports listings, invoices, account information, and internal workflows.
Technology in practice
Databases & Integrations.
SQL Server, MySQL, T-SQL, REST APIs & OpenAPI
Data and integrations connect the parts of a business system. A reliable workflow needs understandable records, clear rules for reading and updating them, and predictable communication between applications.
- Business recordsTables · Relationships · State↓
- Queries and APIsRead · Validate · Update↓
- Application workflowsInterfaces · Services · Integrations
SQL Server
MySQL
Swagger / OpenAPI
The business context
Follow the information from source to result.
An incorrect value on a screen may come from the query, an API response, a mapping decision, or a later update. Understanding that path helps isolate the cause and define the behavior a fix should preserve.
Connected applications
APIs and data flows that let business systems exchange information through defined boundaries.
Content discovery
Queries, relationships, filtering, and pagination that turn stored information into useful results.
The layers of the stack
The tools and how I use them.
SQL ServerRelational business dataSQL Server
SQL Server organizes structured information in related tables and supports application queries and updates. A change needs to account for relationships, constraints, and the workflows that use the affected records. I consider the application caller and the database behavior together.
MySQLRelational web dataMySQL
MySQL is a relational database system used in web application environments. Table structure, joins, and query behavior determine how stored information becomes an application result. Maintenance work starts with understanding the schema and the data paths already in place.
T-SQLSQL Server queries and logic
T-SQL
T-SQL is the SQL language used with SQL Server, including procedural features. It supports the queries and database logic behind application workflows. Clear joins, conditions, and update rules help make the intended result easier to inspect and explain.
Stored proceduresDefined database operations
Stored procedures
A stored procedure packages database operations behind a callable interface. Inputs, result sets, side effects, and failure behavior are part of its contract. Before changing one, I examine the callers and how they interpret the result, alongside the records the procedure affects.
REST APIsSystem-to-system boundaries
REST APIs
HTTP APIs allow applications to exchange requests and responses through defined endpoints. Input validation, authentication, error handling, and response consistency are practical integration concerns. A successful response should be assessed against the business operation it is meant to represent.
Swagger / OpenAPIDescribing API contractsSwagger / OpenAPI
OpenAPI describes HTTP API interfaces in a structured format; Swagger tools help work with those descriptions. A documented contract makes requests, response shapes, and available operations easier to understand. Documentation still needs to agree with the application’s actual behavior.
My approach
Make the contract and the resulting state explicit.
I trace the input, query, response, and resulting record to find where information changes. Clear ownership of each record and a concrete example make integration failures easier to isolate.
Experience in context
Related project work.
Stack’s Bowers Galleries
My contributions include enterprise application interfaces, APIs, SQL Server, and operational workflows, as well as complex custom WordPress plugins connected to backend business services through APIs.
Read the case study
Get Network Visibility
Custom WordPress REST endpoints, PHP filtering queries, content relationships, and pagination support resource discovery. My work spans those paths alongside React listing modules, within the FINNPartners-credited theme and framework.
Explore connected contentOfficial documentation
Let’s talk about your project.
Tell me what you’re building or what needs fixing.
Start a conversation