SparrowTech — Kompleksowe wsparcie IT
pl

SparrowTech

Projects

Systems that actually save time and money — deployed in production, not just on slides. From logistics automation to AI and websites that sell.

Portfolio

Project preview

Click a tile to expand

Featured project

Wasteland Runner

Your steps write the story — a step counter with RPG, XP and real-map quests

An Android mobile game that turns daily movement into gamification. Your phone counts steps in the background while you earn XP, level up your character and follow a post-apocalyptic story. Quests sit on a real map — you walk there in the physical world. Freemium: free core with optional purchases and ads.

  • —Steps = progress — daily movement becomes XP and character growth, no fake indoor grinding
  • —Wasteland lore — a post-apocalyptic narrative that unfolds as you explore the real world
  • —Map quests — real-world objectives: reach the pin, claim the reward, unlock the next chapter
  • —Gamification — levels, rewards and motivation to move: game mechanics, real footsteps
AndroidGamificationGPS / MapsStep counterFreemium
en/wasteland-runner/ →I want a similar system →
Portfolio

Project preview

Click a tile to expand

Featured project

Invoice Hub

One dashboard instead of jumping between inbox, FakturaXL, ITCube and Excel — from detected invoice to ready customs, goods receipt or sales dispatch documents

A production system for B2B organizations importing medical equipment with many document sources. Unifies corporate mail (Maildir, read-only), a FakturaXL cache and offers/orders from legacy ITCube CRM (MySQL, read-only) in one view. Automatically detects and deduplicates invoices from 11 mailboxes, matches them to accounting, and on the same database runs a warehouse and customs document wizard: SAD (customs clearance), PZ (goods receipt) and WZ (sales dispatch). The system evaluates which emails qualify as sources (green rows only after server-side data verification), fills fields from PDF/XML/ZC429, OCR or API — and warns when the user picks the wrong document type (e.g. customs email instead of PZ). Dockerized, behind Nginx SSL, with shared company login.

1 131
invoices detected
1 415
attachments
79 197
Maildir files
11
company mailboxes
  • —Three-layer invoice detection STRONG / WEAK / ANTI — rejects newsletters and notices, catches DHL, KSeF and unusual file names
  • —SHA-256 deduplication + number|vendor key
  • —Background FakturaXL sync (SQLite cache, API throttling) + auto status "booked" / "paid"
  • —SAD/PZ/WZ wizard with four sources: email, FakturaXL, ITCube, uploaded PDF — ZC429/ZC291/WinSAD/JDA parsers, line items from invoices, NBP exchange rate
  • —Smart source highlighting — green row only when the backend confirms real data
  • —WZ with ITCube offer suggestions + purchase invoice panel for verification
  • —Tesseract OCR (Polish+English) for PDF scans, editing existing documents, built-in instructions panel
  • —Security: bcrypt + HttpOnly sessions, brute-force lockout, read-only mounts, controlled Docker network
PythonFastAPISQLiteDockerMaildirFakturaXLITCubeTesseract OCRNginx SSL
I want a similar system →
Featured project

Parcel Mail Aggregator

One dashboard instead of searching ten different mailboxes

A production system for organizations with many mailboxes. Reads courier emails directly from Maildir (read-only, no IMAP passwords), detects DHL, DPD, InPost, FedEx and UPS tracking numbers, groups dozens of messages per shipment, and gives teams FTS search, operational statuses, notes and PDF export — in Docker, behind Nginx SSL.

249
trackings
10
mailboxes
2 364
shipping emails
5 min
auto-scan
  • —False positives reduced from ~5,500 to 249 real tracking numbers
  • —No courier API integrations — full data control on your own server
  • —Incremental scan every 5 minutes across 87,000+ Maildir files
PythonFastAPISQLite FTS5DockerMaildir
I want a similar system →
Featured project

AI + CRM + n8n — automated service diagnostics

Forward the email to a dedicated address → diagnosis lands back in your inbox

Integration of legacy ITCube CRM (Java/MySQL) with AnythingLLM and n8n — but technicians never log into any dashboard. When a client request arrives, they simply forward the message to a dedicated mailbox, wait a moment and receive an HTML preliminary diagnosis: diagnostic steps, suggested parts, knowledge-base sources. RAG analysis on 114 service manuals and 230+ documents in AnythingLLM; CRM and automation run in the background, with no changes to the core system code.

114
service manuals
<60s
diagnosis via email
0
dashboards for staff
  • —The entire workflow lives in email — staff never touch n8n or AnythingLLM
  • —RAG on 114 service manuals + 230+ documents in the AI knowledge base
  • —Read-only CRM in the background — AI uses data without modifying the legacy system
  • —Anti-loop filters and TLS — production deployment, not a demo
E-mailAnythingLLMn8nRAGCRM
I want a similar system →
Featured project

Cybersecurity & infrastructure hardening

Defense in depth on a production server — from firewall to SIEM

Real multi-layer Linux/Docker protection for a B2B organization: ~25 containers (mail, CRM, WordPress, AI), all behind UFW, Fail2ban, ClamAV + Maldet, Wazuh SIEM and OpenVPN. Not a one-off hardening — a continuous process: audit, script automation with rollback, pre-reboot verification and documentation.

25+
Docker containers
11+
Fail2ban jails
7
mail filter layers
100+
audit checklist points
  • —7-layer mail pipeline: Postscreen → Rspamd/ClamAV → Amavis → Fail2ban + custom anti-phishing rules
  • —Wazuh SIEM — FIM, rootcheck, SCA; dashboard localhost/LAN only, no WAN exposure
  • —Cloudflare-only firewall + custom Fail2ban filters (.env/.git scans, sshd-ddos, 7-day recidive ban)
  • —Docker security: socket proxy instead of docker.sock, localhost binding, iptables per-bridge, read-only mounts
  • —AI DevSecOps: read-only CRM, n8n credential vault, deliberate legacy ↔ AI integration boundaries
WazuhFail2banClamAVUFWDockerOpenVPN
I want a similar system →
Portfolio

Project preview

Click a tile to expand

merad.pl — medtech corporate website

From concept to maintenance — professional online presence

Official website for a medical-sector company: built from scratch, deployed, SEO-optimized and maintained. Consistent branding, responsive design and content tailored to regulated industry requirements.

  • —Full cycle: design, development, hosting, maintenance
  • —Content and structure optimized for SEO and B2B image
WordPressCMSSEOMedtech
merad.pl →I want a similar system →
Portfolio

Project preview

Click a tile to expand

Wedding portals — Next.js in action

Elegant event apps that impress guests

Demo web apps for the wedding industry: RSVP, event schedule, gallery and info sections. Modern stack (Next.js, TypeScript, Tailwind), fast loading and design matched to the event character.

  • —Mobile-first — most guests open invitations on their phone
  • —Ready template for quick client personalization
Next.jsTypeScriptTailwindVercel
razemnawieki.vercel.app →I want a similar system →
Portfolio

Video showcase

Click a tile to expand

Video production — marketing & YouTube

Content that sells — from script to publish

I translate tech journalism experience into video: hardware reviews, product tests and marketing content for brands. 1000+ articles in the past — today the same storytelling in video format.

  • —IT hardware reviews and tests — expert credibility
  • —Content tailored for YouTube and product campaigns
YouTubeContent MarketingRecenzjeVideo
I want a similar system →

OpenVPN portal — internal company panel

VPN setup in the browser instead of manual terminal work

Internal web portal for a company using OpenVPN: administrators create and manage config files (.ovpn) and keys through a panel — no SSH sessions or manual certificate generation in the terminal. PHP 8, PostgreSQL, secure authentication.

  • —Self-service for the IT team — fewer errors, faster onboarding of new VPN users
  • —PHP 8 + PostgreSQL — stable backend for daily operational use
PHP 8PostgreSQLOpenVPNInternal tools
I want a similar system →

Have a similar challenge?

Describe your project briefly — I'll prepare a concrete proposal and timeline.

Book a consultation