Garnik Giloyan

Fractional CTO | Backend and Database Architect

Global Manufacturing Enterprise - Multi-Tenant Customer Portal

• Architected enterprise-scale backend for large-scale multi-tenant customer portal enabling industrial clients to view coil inventory, manage orders, and track fulfillment in real time
• Led database design & optimization | Architected and reviewed complex Oracle database schemas, ensuring data integrity, scalability, and high-performance querying across multiple tenants
• Conducted in-depth code reviews for NestJS and Redis-based microservices, enforcing best practices in caching, async processing, and error handling
• Collaborated on designing the application's cloud infrastructure, focusing on security, scalability, and integration with existing enterprise systems
• Coordinated communication among backend developers, DevOps engineers, and frontend teams to maintain delivery alignment
• Worked directly with client leadership and product teams to translate complex business requirements into robust technical solutions
• Ensured performance benchmarking, logging, and monitoring systems were established for proactive issue detection

Tech Stack: Oracle Database, Node.js, NestJS, TypeScript, Redis, Docker, Microservices, Cloud Architecture (AWS/Azure)

Enterprise RFQ / Quotations Platform

• Led cross-functional delivery | Directed backend, frontend, and QA to deliver a production-grade RFQ/quotations platform
• Owned product roadmap & sprint planning | Defined and prioritized engineering workstreams in collaboration with product managers
• Designed and implemented core features for PDF/Excel export, AI/NLP-assisted item extraction, import/matching UX, and vendor/email workflows
• Established best practices in code reviews, CI/CD pipelines, automated testing, and performance monitoring
• Defined and tracked KPIs (time-to-quote, error rates, vendor response metrics) to quantify feature effectiveness

Tech Stack: Node.js, NestJS, TypeScript, React, ORM, PDF/Excel generation, NLP-assisted text extraction, Docker

Leading North American FinTech Company - Rutter API Integration Module

• Designed and implemented robust module integrating Rutter API into existing financial transaction systems
• Integrated multiple financial APIs including Rutter, Stripe, and QuickBooks Online for seamless data synchronization
• Built background job workers for periodic synchronization, error retries, and real-time update handling
• Implemented OAuth-based authentication, validation middleware, and structured logging for auditability
• Designed and optimized PostgreSQL schemas and queries for efficient transaction record storage

Tech Stack: Node.js, NestJS, TypeScript, PostgreSQL, Rutter API, Stripe API, QuickBooks Online API, BullMQ, Docker

RSearch AI – Statistical Analysis & Research Microservice

• Built AI-powered research microservice | Developed FastAPI application for automated academic research with OpenAI GPT-4o-mini
• Implemented 30+ statistical methods including Pearson/Spearman correlation, multiple/logistic regression, PLS-DA, ANOVA, chi-square
• Integrated Server-Sent Events (SSE) for real-time progress updates during long-running AI operations
• Built PDF/DOCX parser with NLP capabilities for hypothesis extraction from academic papers
• Containerized with Docker and deployed to Fly.io with auto-scaling and health checks
• Created natural language interface allowing users to request statistical analyses in plain English

Tech Stack: Python, FastAPI, Pandas, SciPy, scikit-learn, OpenAI API, NLTK, Docker

Logoom - Logging & Analytics Platform

• Led product direction, roadmap planning, and full-stack engineering execution in logging & analytics SaaS
• Built scalable backend architecture | Oversaw development of REST/GraphQL APIs using Node.js / NestJS
• Managed team of engineers, defined sprint goals, oversaw code reviews
• Defined, scoped, and executed features for log ingestion, real-time query, filtering, alerting, and analytics dashboards
• Designed efficient database schemas, indexing strategies, query optimizations, caching, and load balancing
• Built alert infrastructure (thresholds, anomaly detection) tied to user notifications (email, Slack, SMS)

Tech Stack: Node.js, NestJS, TypeScript, PostgreSQL/MySQL, TypeORM/Prisma, Docker, Kubernetes

Engineering Manager, Lead Software Developer

Leadership & Team Management

• Led cross-functional development team of in-house and offshore developers to deliver enterprise-scale legal referral platform serving multiple bar associations across North America
• Drove technical architecture decisions and established coding standards, ensuring scalability across 40+ interconnected modules

Data Migration & ETL Pipeline

• Architected and implemented comprehensive ETL data migration pipeline for 6+ entity types processing 100K+ records
• Engineered batch processing system with transaction management, chunking (1,000 records/batch), and automatic rollback mechanisms
• Developed automated migration scripts with proper error handling and logging for database restructuring

Architecture & System Design

• Designed modular microservices architecture using NestJS framework with 40+ separated modules following SOLID principles
• Implemented repository pattern with TypeORM supporting multiple database operations and optimized N+1 query prevention
• Built scalable service layer with dependency injection, enabling clean separation of concerns

Technical Implementation

• Integrated multiple third-party APIs: Stripe payment processing, Twilio SMS, HubSpot CRM, Google/Outlook/iCloud calendar synchronization, and AWS S3
• Developed sophisticated lawyer matching algorithm with 15+ filtering criteria using optimized SQL queries
• Implemented real-time calendar availability system processing lawyer schedules across multiple time zones
• Built complex TypeORM queries handling 10K+ concurrent user searches and filtering operations
• Designed transaction-based workflows ensuring ACID compliance for critical operations

Tech Stack: TypeScript, Node.js, NestJS, TypeORM, MySQL/PostgreSQL, Stripe API, Twilio, HubSpot, AWS S3, Docker

Independent Consultant

SOW Insights: AI-Powered Project Pricing Microservice

• Built standalone Python microservice analyzing historical project documents to automatically estimate pricing for new submissions
• Integrated with existing .NET platform through RESTful APIs for seamless interoperability
• Implemented document intelligence pipeline with parsing, vectorization workflows to extract structured data
• Applied NLP and regression models to correlate new requirements with historical datasets
• Enabled rapid project-cost estimation and reduced manual analysis time by over 70%

Tech Stack: Python, FastAPI, Pandas, OpenAI API, NLP libraries, Docker, REST APIs, .NET integration

AI Quote iOS App: Personal Wisdom & Motivation Generator

• Conceived original idea, designed wireframes, and defined technical roadmap reaching ~300 organic users on iOS
• Built backend using NestJS and OpenAI API integration to generate context-aware motivational quotes
• Designed and developed native SwiftUI application; published on App Store
• Integrated Apple StoreKit for monthly premium subscriptions and AdMob banners for non-premium users
• Architected REST API security layers and backend middleware to ensure data privacy

Tech Stack: SwiftUI, StoreKit, AdMob SDK, NestJS, TypeScript, OpenAI API, Docker

Smart Study – Web-Based Learning Platform

• Gathered business requirements, converted them into technical tasks, created sprint plans
• Designed detailed workflow diagrams using UML and documented system configurations
• Led architecture design for backend and frontend using Node.js, NestJS, TypeScript, and React.js
• Oversaw MySQL database design, schema optimization, and data modeling
• Integrated third-party APIs for document processing, voice-to-text transcription (AWS Whisper), and content generation
• Implemented payment integration using Stripe for premium users
• Built responsive React components ensuring compatibility across desktop, iPad, and iPhone

Tech Stack: Node.js, NestJS, TypeScript, React.js, MySQL, AWS Whisper, OpenAI API, Stripe, Docker, GitHub Actions

Scheduling Web App – Appointment Management Platform

• Designed and developed web platform for practitioners to manage appointments and handle client bookings
• Built backend using Node.js and NestJS framework, creating secure REST API architecture
• Implemented user authentication and authorization using JWT for session-based access control
• Integrated Nylas API for calendar synchronization, availability management, and meeting scheduling
• Added payment processing through Stripe's custom API for booking fees and recurring billing
• Secured environment configurations using Azure Key Vault and deployed on Azure cloud infrastructure

Tech Stack: Node.js, NestJS, TypeScript, React.js, Nylas API, Stripe API, JWT, Azure, Azure Key Vault, GitHub Actions

BeeChintzy – Mobile and Web Platform for Local Deals

• Led full-cycle engineering for cross-platform consumer and merchant system (iOS app, Android app, REST API, merchant dashboard)
• Developed BeeChintzy iOS app using SwiftUI and MVVM architecture pattern, integrating Apple, Google, and Email login
• Implemented Apple Maps for location-based offers and push notifications for real-time customer engagement
• Designed dynamic theming that automatically adjusts colors, accents, and logos based on user's location or merchant site
• Ensured multilingual support (English and French) for diverse user base
• Managed backend and API development using Node.js and NestJS, with MySQL and TypeORM
• Coordinated daily with offshore developers, defining tasks and sprint timelines for web and mobile teams
• Designed cloud infrastructure using AWS ECS Fargate, Secrets Manager, and CI/CD pipelines
• Integrated Stripe for payments, MapBox for address autocomplete, and Shutterstock API for merchant images

Tech Stack: SwiftUI, UIKit, MVVM, Node.js, NestJS, React Native, TypeScript, MySQL, AWS ECS Fargate, Stripe, MapBox, Shutterstock API

Thib iOS App

• Designed and developed mobile application for insurance form submission, document management, and client communication
• Built app using Swift and UIKit, integrating local database storage with secure REST API
• Implemented email-based authentication for user login and session handling
• Created dynamic form generation using arrays to efficiently render multiple input fields
• Enabled users to submit completed forms via email or upload to Dropbox using Dropbox API
• Added built-in document signing feature allowing users to sign and view PDF files using EPSignature library

Tech Stack: Swift, UIKit, REST API, Dropbox API, EPSignature Library, Local Storage, JSON

Medical iOS App – Skin Health Detection Platform

• Designed and developed mobile application to help users analyze skin lesions and identify potential health concerns
• Built app using Swift, integrating secure Google login for user authentication
• Implemented image capture and scanning functionality for skin lesion analysis
• Used Apple's Core ML framework to process images through pre-trained model classifying lesions
• Connected app to REST API for optional result submission and remote consultation requests

Tech Stack: Swift, UIKit, Core ML, REST API, Google Login, Image Processing

Senior iOS Developer

Key Responsibilities

• Worked on existing HandHeld iOS app developed in Objective-C
• Focused on fixing bugs and implementing new features
• Managed local database interactions using SQLite and connected app with external APIs

Contributions to ProjectKickStart Desktop App

• Played major role, developing 80% of ProjectKickStart Desktop application using C# and .NET
• Utilized DevExpress for UI components
• Managed local data storage using XML files

Tech Stack: Objective-C, Swift, SQLite, C#, .NET, DevExpress, XML

Team Lead

Key Responsibilities

• Established the Armenian branch of Dixon Walther PSC in Yerevan, Armenia
• Developed various experimental network-related iOS apps for RHub using Objective-C
• Interviewed and hired web developers
• Coached and trained junior developers
• Determined the right technology
• Spearheaded end-to-end development of Rick's Deal e-commerce platform
• Crafted robust back-end solutions using ASP.NET MVC (C#)
• Developed responsive client-side pages using HTML, CSS, jQuery, and ReactJS
• Engineered database structures using MS SQL Server 2014, including jobs, stored procedures, and T-SQL queries
• Authored and maintained efficient TypeScript code
• Championed development and deployment of Roof911 web platform
• Developed back-end code using ASP.NET MVC (C#)
• Designed SQL database, including creation of essential stored procedures
• Produced client-side pages leveraging HTML, CSS, and jQuery for interactive user experiences

Tech Stack: Objective-C, ASP.NET MVC, C#, MS SQL Server, HTML, CSS, jQuery, ReactJS, TypeScript

Software Engineer

Key Responsibilities

• Developed plugins tailored for Archicad and Revit to enhance user capabilities
• Utilized combination of languages and frameworks, including C/C++, AC API, C#, and .NET Framework
• Engineered specialized C++ dynamic link libraries (DLLs) to facilitate seamless interactions with web services

Tech Stack: C/C++, AC API, C#, .NET Framework, DLLs

Full Stack Developer

Key Responsibilities

• Led development of new features of medical web app using PHP
• Authored and optimized stored procedures in PostgreSQL
• Crafted dynamic functionalities utilizing JavaScript

Tech Stack: PHP, PostgreSQL, JavaScript

Software Developer

Key Responsibilities

• Developed new functional features for SharePoint websites using VB.NET
• Addressed and resolved bugs in e-Business websites and MAS 90 systems using ProvideX
• Developed new modules and enhanced functionality for MAS 90 systems leveraging ProvideX

Tech Stack: VB.NET, SharePoint, ProvideX, MAS 90

Full Stack Developer

Key Responsibilities

• Oversaw complete lifecycle from development and implementation to support
• Crafted robust back-end solutions using Classic ASP (VBScript)
• Designed and managed databases utilizing MS SQL Server 2005
• Authored and optimized Jobs, Stored Procedures, and T-SQL queries to facilitate efficient data operations

Tech Stack: Classic ASP, VBScript, MS SQL Server 2005, T-SQL