IV
Igor Vilghelm Full-Stack & Team Lead
Case Studies & Systems

Projects & Architecture

Key enterprise, mobile, SCADA, and AI systems designed and delivered over 10+ years. Filter by domain or search for specific technologies below.

Download Full CV (PDF)

Backend service powering an intelligent assistant for the Web Energy Management System with local/hosted LLM integration.

Key Deliverables & Responsibilities:
  • Developed a backend service using Node.js (Fastify) to power an AI assistant for the Web Energy Management System, enabling users to analyze system events and receive actionable recommendations via a dedicated 'Ask AI' interface.
  • Integrated LLM-based solutions (Ollama / LM Studio) to provide contextual explanations of system behavior and assist in decision-making.
  • Designed scalable APIs and integrated AI capabilities into the existing system architecture.
#Node.js#Fastify#Ollama#LM Studio#LLM#REST API#Microservices

Field engineer cross-platform mobile solution for real-time monitoring and offline data access.

Key Deliverables & Responsibilities:
  • Designed and developed a mobile energy management application using React Native (Expo) for field engineers, enabling real-time monitoring and data access on the go.
  • Focused on performance optimization, offline-first capabilities, and seamless integration with existing backend services.
#React Native#Expo#TypeScript#Offline-First#Mobile UX#REST API

Ensuring high availability, resilience, and horizontal scaling of 24/7 mission-critical energy management infrastructure.

Key Deliverables & Responsibilities:
  • Maintained and evolved a high-load energy management system, ensuring scalability, performance, and reliability in production environments.
  • Worked with high-volume relational databases and complex data models.
#High-Load#Oracle#MariaDB#Relational DBs#Performance Tuning

Flagship smart metering & automated commercial energy accounting platform with real-time SCADA scheme viewer.

Key Deliverables & Responsibilities:
  • Led the design and development of a smart metering system for automated commercial energy accounting.
  • Designed and implemented system architecture (frontend & backend), including reusable component libraries and scalable module structure.
  • Built a custom component system using React and Redux, enabling consistent UI development across the application.
  • Implemented robust Content Security Policy (CSP) rules and hardened IIS security headers to secure frontend assets against client-side injection and cross-site attacks.
  • Integrated Redis / Garnet for login rate-limiting and server-side session invalidation, safeguarding databases from brute-force lockouts and enforcing global token revocation.
  • Conducted security testing and vulnerability remediation with OWASP ZAP post-cybersecurity audit, resolving critical backend security flaws.
  • Developed and maintained backend endpoints for communication with Oracle and MariaDB databases and data acquisition systems (REST APIs).
  • Implemented real-time data visualization, including SCADA-like SVG-based interactive scheme viewer & editor with live data binding.
  • Worked with large-scale data processing, including Big Data and IoT integrations, data analysis, and data visualization pipelines.
  • Optimized application performance and query execution, including analysis and tuning of complex database queries, procedures, and functions.
  • Integrated and adapted third-party npm components (charts, grids) to meet specific business requirements.
  • Set up and maintained CI/CD pipelines using Jenkins, including custom automation workflows.
  • Contributed to cloud adaptation, SSO integration, and infrastructure improvements.
  • Provided technical guidance to team members and participated in architecture decisions.
#React#Redux#SCADA SVG#REST APIs#Redis#Garnet#OWASP ZAP#CSP#IIS#Oracle#MariaDB#Jenkins#IoT#Big Data#SSO

Support and progressive modernization of legacy web systems ensuring business continuity.

Key Deliverables & Responsibilities:
  • Maintained and supported a legacy web application, ensuring system stability and resolving production issues.
  • Worked on bug fixing, performance improvements, and gradual refactoring of legacy codebase.
#ASP 2.0#Flash ActionScript 2#Refactoring#New features#Performance#Legacy Migration#Troubleshooting