Engineering & CAD Automation

Automated CAD Flow Simulation Tool

VB.NET SolidWorks API Standalone Application

This standalone executable interfaces directly with the SolidWorks API to programmatically automate thermal flow simulation setup. Design engineers who previously spent hours manually configuring simulation parameters for each assembly can now trigger the entire process with a single click. The tool scans assemblies, queries a material database, applies the correct flow simulation properties to each component, and handles edge cases like fasteners and missing data — all automatically.

4 h → 10 min
setup time per assembly
~96%
less manual prep time
1 click
to launch a full simulation setup
System Architecture
Designer's View
  • Open SolidWorks Assembly
  • Run Automation Tool
  • Ready-to-Simulate Model
VB.NET Logic Engine
  • Assembly Scanner (Part Numbers)
  • Database Query → Material Mapping
  • Assign Flow Sim Properties
  • Handle Bolts/Nuts → Defaults
  • Log Warnings for Missing Data
SolidWorks Flow Sim API
  • Update Component Materials
  • Apply Simulation Parameters
Cloud Architecture & Data Pipelines

BOM Pipeline & Product Configuration

Python Azure Functions XML SQL

A serverless data pipeline triggered by massive XML file exports from the Bluestar product configurator. Python scripts running on Azure Functions parse the raw XML, fully reconstruct complex 150% Bills of Materials, and load the structured output into SQL databases for downstream reporting. The system includes real-time monitoring through Microsoft Teams notifications for errors, validation issues, and data integrity checks — and feeds directly into Power BI dashboards.

5-person team
of full-time manual effort replaced
600+
products with live, nested BOMs
0
manual hours — runs fully in the background
Pipeline Architecture
Source
  • Bluestar Configurator
  • XML Generation
  • Azure File Storage
Azure Functions: ETL
  • Blob Trigger → XML Parser
  • Transformation Engine
  • BOM Reconstruction
Data & Analytics
  • SQL Database (Insert/Update)
  • Power BI Reports (DirectQuery)
Cloud Architecture & Data Pipelines

Scalable Medallion Data Pipeline

Python Notebooks Microsoft Fabric Delta Parquet Power BI

A strict Medallion architecture implementation where data flows sequentially through Bronze (raw JSON ingestion), Silver (cleansed and validated Delta Parquet tables), and Gold (business-level star schema aggregations) layers. The entire pipeline is orchestrated using Python Notebooks within Microsoft Fabric, with the Gold layer feeding Power BI reports via Direct Lake mode for near-instant query performance.

1 FTE
full-time data role eliminated
1
source of truth across all tools
0
manual imports, exports or de-duplication
Medallion Architecture
Source
  • Palma API
  • Scheduled Extraction
Bronze — Raw
  • Raw JSON Ingestion
  • No transformations
Silver — Validated
  • Cleansed & Filtered
  • Delta Parquet Format
Gold — Analytics
  • Star Schema Aggregations
  • Direct Lake → Power BI
System Integration & Modernization

Centralized Engineering API Portal

REST API Internal Tooling Enterprise

An internal web application and REST API built for a global lighting manufacturer. The system serves as a centralized hub for engineering data, providing programmatic access to retrieve, convert, and manage critical technical specifications and component data. It eliminates manual lookups across disconnected spreadsheets and legacy systems, giving engineering teams a single source of truth accessible from any internal tool or script.

1
source of truth for engineering data
0
spreadsheet sync errors or stale records
~2 h/wk
recovered per engineer (estimated)
AI-Augmented Automation

Deal Aggregator Platform

FastAPI Claude AI WordPress Web Scraping

An automated deal-aggregation platform for Canadian parents, built on FastAPI. Scheduled scrapers collect product promotions across multiple retailers, then an AI layer writes bilingual (English/French) product descriptions, filters out items that aren't relevant to the target audience, and curates a daily selection of the best deals. Everything is published automatically to a bilingual WordPress storefront — with no manual copywriting or editorial work.

100%
AI-written bilingual product descriptions
0
manual copywriting or translation hours
Daily
AI-curated top-deals selection
Pipeline Architecture
Automated Scraping
  • Multi-Retailer Scrapers (FastAPI)
  • Scheduled Daily Extraction
  • Price & Availability Parsing
AI Processing Layer
  • Bilingual Description Generation (EN/FR)
  • Audience-Relevance Filtering
  • Daily Featured-Deal Curation
Bilingual Publishing
  • WordPress + Polylang
  • Consumer-Facing EN/FR Storefront
AI-Augmented Automation

Claudette — Internal AI Assistant

Claude API MCP Python Docker

An AI assistant we built and use internally at Drakarian — proof of the same approach we design for clients. Claudette connects a large language model directly to our day-to-day tools (calendar, task lists, email, and a knowledge base), so it can take instructions in plain language and act on them: planning the day, drafting emails, logging work, and recalling project context across sessions. It runs as a self-hosted service that exposes its tools through the Model Context Protocol (MCP) — the same architecture we build for clients who want AI wired into their own systems.

12+
routine workflows turned into one-command skills
1
assistant across calendar, tasks, email and notes
0
new dashboards — operated in plain language
System Architecture
Conversational Interface
  • Plain-Language Requests
  • Chat-Based — No UI to Learn
AI Agent Core
  • LLM Reasoning Loop (Claude)
  • Autonomous Tool Selection
  • Project Memory & Context
Connected Tools (MCP)
  • Calendar, Tasks & Email
  • Knowledge Base & Notes
Other Projects

Additional work

Carbon Footprint Calculator

A full-stack Django web application with user authentication and custom forms for dynamically calculating CO2 emissions based on user-input data.

PythonDjangoFull-Stack