Quartux
Software Engineer
➜Serverless APIs, energy analytics, and real-time data optimization.
Built Cloudflare Workers and TypeScript services for energy data processing, using PostgreSQL, Kysely, ETL, Zod, caching, and React PDF reports for consumption, demand, costs, and savings.
- Development of serverless APIs using Cloudflare Workers, focused on processing energy data and calculating consumption, demand, and savings indicators in real-time
- Design and implementation of advanced SQL queries (PostgreSQL) for time-series analysis, including logic based on window functions (LAG, PARTITION BY) to calculate energy deltas (kWh) from cumulative data
- Migration of complex queries to Kysely (TypeScript), ensuring exact parity with native SQL, handling CTEs (WITH), analytical functions, and preventing errors due to aliasing and typing
- Construction of decoupled services such as operation-energy and cost-energy, applying clean architecture principles, layer separation (domain, application, infrastructure), and high cohesion
- Implementation of business logic for calculating complex energy costs, including CFE rates, charges for capacity, distribution, and energy (base, intermediate, peak), as well as savings simulations with BESS systems


