Hi, I'm Sarah Morrigan Moore 👋

Relational Database Architecture | SQL & Python Integration

Pizza Ordering System Database Engineering: Engineered a robust relational infrastructure connecting Python application layers to a SQL Server database via the `pyodbc` driver. Programmed transaction-handling logic to safely execute multi-table parameterized queries using strict constraint validation before manually forcing a database commit (`conn.commit()`). Developed an automated looping audit mechanism to dynamically scan and print shifting operational logs across all relational schemas.

# Programmatic SQL Server connectivity and multi-table transactional inserts
import pyodbc

conn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};Server=TopConnor;Database=PizzaOrderingSystem;Trusted_Connection=yes;")
cursor = conn.cursor()

# Define relational transaction data dynamically
cust_id = 7
cust_address = '50 Lenn Road'
cust_phone = '5175155122'
cust_email = 'willybee@hotmail.com'
indiv_name = 'William Beebee'

# Execute multi-table parameterized insert queries to handle database dependencies
cursor.execute("INSERT INTO tbls_Customers (CustomerID, CustomerAddress, CustomerPhone, CustomerEmail) VALUES (?, ?, ?, ?)", (cust_id, cust_address, cust_phone, cust_email))
cursor.execute("INSERT INTO tblm_Individual (CustomerID, IndividualName) VALUES (?, ?)", (cust_id, indiv_name))

# Commit transactions and verify insertions with an optimized relational JOIN query
conn.commit()
cursor.execute("SELECT C.CustomerID, I.IndividualName, C.CustomerEmail FROM tbls_Customers C JOIN tblm_Individual I ON C.CustomerID = I.CustomerID WHERE C.CustomerID = ?", (cust_id))

# Global operational auditing iteration script mapping all system tables
all_tables = ['tbls_Beverage', 'tbls_Newisltem', 'tbls_Corporate', 'tbls_CustomerOrders', 'tbls_Customers', 'tblm_FoodItem', 'tbls_Individual', 'tbls_OrderDetails', 'tbls_PayCash', 'tbls_PayCreditCard', 'tblm_PaymentType', 'tblm_Pizza']

for table in all_tables:
    print("Table: " + table)
    cursor.execute("SELECT * FROM " + table)
    rows = cursor.fetchall()
    for row in rows:
        print(row)

Transactional Systems Engineering | Java

Object-Oriented Stock Portfolio Application: Engineered a modular architecture leveraging core Object-Oriented Programming (OOP) principles, including encapsulation, inheritance, text-based interactive loops, and structured collections (`ArrayList` / `HashMap`). Developed secure data-validation workflows to manage cash positions, track shifting asset distributions dynamically, and verify order executions.

public class PortfolioManager {
    private ArrayList<TransactionHistory> portfolioList = new ArrayList<>();
    private double cashBalance = 0.0;

    // Direct trade execution validation mechanics (Buy Logic)
    case 3:
        System.out.print("Ticker: ");
        String buyTicker = input.nextLine().toUpperCase();
        System.out.print("Quantity to buy: ");
        double buyQty = input.nextDouble();
        double totalCost = buyQty * buyPrice;
        if (totalCost > manager.cashBalance) {
            System.out.println("Not enough cash!");
        } else {
            manager.cashBalance -= totalCost;
            manager.record(buyTicker, "BUY", buyQty, buyPrice);
        }
        break;
}

Embedded IoT & Hardware Logic | Python (IFT 101 Lab)

Single-Board Computer Physical Computing: Programmed low-latency automation scripts running on single-board computer hardware (Raspberry Pi) to manage physical circuit states. Configured native pin communication mapping registries, managed continuous logical execution sequences to cycle LED output arrays, and implemented structural safety listeners (`KeyboardInterrupt`) to execute global pin resource resets safely upon operator termination.