Professional Journey
Senior Software Engineer - Contract
Avacend Inc
Dec 2024 - Present
Remote
- Built Python data pipelines with OAuth2-authenticated WorxHub API integration, automatic token refresh, and three-tier extraction strategy (cumulative, delta, on-demand) for incremental data synchronization
- Designed ClickHouse analytics schema with ReplacingMergeTree engine, 100K-row batch inserts across 8 parallel threads with exponential backoff retry logic
- Implemented text-to-SQL generation pipeline using GPT-4o converting natural language queries to ClickHouse SQL, with AI-powered result interpretation for human-readable work order descriptions
- Built ML pipeline using SentenceTransformer embeddings, HDBSCAN clustering, and UMAP dimensionality reduction for work order pattern analysis with Pinecone vector database integration
- Developed 4 production dashboards with 10+ KPIs including SLA compliance tracking, shift-based analytics with dynamic ClickHouse query generation, and DragonflyDB caching with extraction-date-aware invalidation
- Architected multi-tenant FastAPI backend with three-tier RBAC, JWT authentication, and async ClickHouse operations using ThreadPoolExecutor to prevent event loop blocking
Senior Software Engineer
Constient Global Solutions
Nov 2022 - Dec 2024
- Founding engineer of the startup project; designed and implemented scalable REST API backend microservices using GoLang, optimizing for high performance and efficiency
- Architected a distributed log management system using StarRocks DB and Kafka, improving troubleshooting efficiency by 40%
- Implemented high-performance gRPC communication protocols between services using Python and GoLang
- Created SDKs and integrated OpenAI APIs for advanced AI-driven backend features
- Managed deployment infrastructure using Docker and Kubernetes for microservices architecture
- Optimized database performance across PostgreSQL, ClickHouse, and StarRocks implementations
- Developed and maintained robust CLI tools with GoLang for streamlining backend operations
- Architected responsive front-end for the log management system using Next.js and TailwindCSS, with real-time data visualization and AI-recommended filters
- Established frontend testing practices using Jest, achieving 90% test coverage
Technical Arsenal
A comprehensive toolkit for building scalable, high-performance applications.
Backend Engineering
PythonNode.js (TypeScript)GoLangPostgreSQLClickHouseStarRocksMongoDBNeo4jRedisDragonflyDBKafkaRabbitMQRESTgRPCWebSocket
Frontend Development
TypeScriptJestTailwindCSSRedux ToolkitReact NativeNext.jsReact.jsFigma
Infrastructure & AI/ML
DockerKubernetesGitHub ActionsFluxCDTrivyGCPAWSCloudflareSentenceTransformersPinecone
Selected Works
Amour - Dating App
- Microservices — 16 gRPC proto services with hexagonal architecture across 68+ NestJS services
- Database — 68-model Prisma schema with 141 BTREE indexes and denormalized chat caching for 50x faster rendering
- Auth — Dual strategy — GatewayHelper (10-30x faster) + SuperTokens with AES-256-GCM encryption
- Notifications — 4-tier priority queuing with presence-aware routing and circuit breaker pattern across 16 RabbitMQ exchanges
- Real-time — Horizontally-scalable WebSocket gateway with Redis pub/sub and Agora RTM messaging
- DevOps — FluxCD GitOps pipeline with multi-arch Docker builds, Kubernetes rolling updates, and Trivy scanning
React NativeNestJSTypeScriptgRPCPrismaRabbitMQRedisSocket.ioKubernetes
Ready to Collaborate?
I'm currently available for freelance work and full-time positions. Let's build something extraordinary together.