Richard Franchuk

Senior Full-Stack, Data, Machine Learning & AI Systems Engineer

Executive Profile

Senior software engineer and systems architect with 20+ years of experience delivering full-stack applications, data platforms, integrations, infrastructure, and business-critical operational systems from scope through production validation.
Machine learning and AI-focused builder with hands-on capability in Snowflake ML, Snowpark, Cortex, feature and data-model design, model evaluation, monitoring, and integrating explainable AI outputs into real operating workflows.
Deep full-stack background across Node.js, TypeScript, React, Python, JavaScript, SQL, APIs, cloud integrations, Supabase/Postgres, Snowflake, and secure system design.
Quality-minded delivery owner who builds custom test harnesses and layered validation across unit, integration, API/database, end-to-end, security, performance, and production acceptance testing.
Advanced AI-assisted engineering practitioner using Codex and Claude Code with multi-agent workflows, high-signal prompt design, scoped decomposition, rigorous review, and verifiable release gates.

Snowflake-native AI/ML: Snowflake ML, Snowpark, Cortex, governed training/scoring datasets, feature engineering, experiment and model-output versioning, evaluation criteria, and lifecycle monitoring.
Applied AI systems: anomaly detection, forecasting, classification, semantic search/retrieval, LLM-enabled decision support, and human-in-the-loop operational workflows with auditability and explainability.
ML data foundations: schema and grain design, source-of-truth rules, late-arriving data handling, data quality/reconciliation controls, security boundaries, lineage, retention, and feedback loops.
Agentic engineering: Codex/Claude Code orchestration, prompt engineering with explicit context and acceptance criteria, multi-agent task decomposition, generated-code review, and test-driven verification.

Full stack & services: Node.js, TypeScript, React, JavaScript, PHP, Laravel, REST APIs, webhooks, microservices, asynchronous workflows, authentication/authorization, observability, error handling
Data & databases: Snowflake, Snowflake SQL, data ingestion, Snowpipe-style loading, streams, tasks, MERGE/upsert patterns, serving views, Postgres, Supabase, relational schema design, data quality, query performance
Supabase platform: Postgres, database migrations, Row Level Security, Auth/MFA, Edge Functions, Realtime, Storage, secure client/privileged operation boundaries
Python & PC/edge: Python, Windows/PC applications, services and scheduled tasks, PyInstaller packaging, SQLite/local state, networking, sockets, file systems, retry/idempotency, health telemetry, self-healing
Quality & release: Custom test harnesses, simulators, fixtures, golden datasets, replay tools, contract checks, fault injection, Playwright, unit/integration/E2E testing, release and acceptance validation
Cloud & infrastructure: AWS, Docker, Linux/Unix/Windows, S3, Lambda, SFTP, GitHub/GitLab, CI/CD, backups, monitoring, DNS, VPN, network security, infrastructure automation

2015 - Present

Consumer Attorney Marketing Group | Woodland Hills, CA

Lead end-to-end development of full-stack applications and data-intensive operational systems supporting national legal lead-generation and call-center operations, from technical scope and architecture through production release and validation.
Design and deliver Node.js/TypeScript, React, Python, PHP/Laravel, API, webhook, CRM, telephony, and third-party marketing integrations with secure service boundaries, robust error handling, and operational observability.
Build Snowflake and Supabase-backed data capabilities, including production schemas, ingestion and transformation patterns, serving layers, Row Level Security, Auth/MFA, Edge Functions, Realtime workflows, and governed application access.
Develop production AI/ML foundations and use cases: Snowflake ML/Snowpark/Cortex workflows, analytics-ready feature data, model evaluation and monitoring, anomaly detection, forecasting, semantic retrieval, and decision-support experiences.
Create fit-for-purpose test harnesses and full validation plans spanning unit, integration, API/database, browser E2E, security/permission, performance, and production acceptance checks; document release evidence and operational handoffs.
Modernize legacy systems through containerization, framework upgrades, Salesforce/Apex migration projects, and AI-assisted development workflows using Codex/Claude Code with multi-agent review and verification gates.

2012 - 2015

Newscrafted LLC | Woodland Hills, CA

Designed and implemented infrastructure for an online, on-demand printing and publishing platform, including scheduling, billing, production management, data workflows, and resilient operational support systems.
Developed genetic algorithm-based layout optimization for automated advertisement placement, establishing practical applied-ML/optimization experience connected directly to business outcomes.
Managed server administration, network security, backups, and deployment processes; improved QA discipline and release stability for a high-throughput production environment.

2008 - 2012

Broker's Helper | Woodland Hills, CA

Architected and led a workflow automation platform for real-estate professionals, delivering interactive web interfaces, automated onboarding, contact/task management, website generation, billing, production, and customer-service capabilities.
Built end-to-end integrations for automated DNS and domain registration and contributed to the system design, schemas, backend services, and operational tooling across the platform.

2004 - 2007

ITVN | Canoga Park, CA

Developed core systems for an innovative streaming-video-over-broadband set-top platform, including customizable user interfaces, backend subscriber services, content management and delivery, support, warehouse/RMA, and billing systems.
Designed and implemented platform components across product, customer operations, data, and systems infrastructure; the platform was recognized as PC Magazine's Most Innovative Product at DigitalLife 2005.