# Dylan Calin (Dylan Călin) **Senior Database Administrator & Mobile Software Engineer** Bucharest, Romania • [dylan_calin@yahoo.com](mailto:dylan_calin@yahoo.com) • [Unified Portfolio & Live Hub](http://localhost:8094/) --- ## Professional Summary Database Administrator and Software Engineer with over 6 years of experience managing departmental relational database architectures at **Ministerul Afacerilor Interne (MAI) – IGPR**, alongside a prolific engineering portfolio of **30+ Flutter mobile applications, Flame engine games, and data automation systems**. Specialized in MySQL/PostgreSQL schema design and index optimization, high-throughput Python automation pipelines (interfacing with national registries), and production mobile app development with Flutter, SQLite, and cloud synchronization. --- ## Technical Competencies - **Database Engineering & Administration:** MySQL, PostgreSQL, SQLite, Oracle SQL, Schema Design, Compound Index Optimization, Query Execution Plans, High Availability, Automated Backup Workflows & Disaster Recovery. - **Languages & Frameworks:** Python (FastAPI, Flask, Pandas, NumPy, PyQt6), Dart / Flutter (iOS, Android, Web), SQL, HTML5/CSS3/JavaScript, VBA. - **Data Engineering & Automation:** Web Scrapers (Selenium, Requests), Institutional Registry Integration (**DEPABD**, **SII**, **Cazier Judiciar**), 112 Emergency Call Analytics, Dispatch Telex Parsing, Data Sanitization (CNP, CUI, Phone, Address Parsing), Automated Word/Excel Executive Reporting. - **Mobile Development & Architecture:** Cross-Platform Flutter, BLoC, Provider, Offline-First SQLite Architectures, Drift DB, Supabase, RevenueCat In-App Subscriptions, Syncfusion Analytics. - **Game Development:** Flame Engine, Forge2D Physics, 2D Canvas Graphics, Game Physics, Sprite Sheet Animations, Audio Management, Level Editors. - **Security & Hardware Integration:** Role-Based Access Control (RBAC), Hardware Biometrics (local_auth FaceID/Fingerprint), AES-256 Cryptography, Accelerometer/Compass Sensors, Camera APIs. --- ## Professional Experience ### **Ministerul Afacerilor Interne (MAI) – Poliția Română / IGPR** *Database Manager & Systems Engineer* | Bucharest, Romania **Dec 2020 – Present (5+ Years)** - **Relational Database Administration:** Administer departmental relational databases (MySQL, PostgreSQL, Oracle SQL, SQLite), managing schema migrations, complex multi-table query performance tuning, index optimization, automated backup workflows, and security compliance. - **Automation Studio Suite (Data Pipelines & National Registries):** Built high-throughput Python automation architectures (PyQt6 desktop interface and FastAPI web engine) featuring automated scrapers for national databases (DEPABD - Evidența Persoanelor, SII - Sistemul Informatic Integrat, Cazier Judiciar), automated analysis and filtering of SNUAU 112 emergency calls, dispatch telex parsing, data sanitization (CNP, CUI, phone numbers, addresses), and automatic generation of executive Word/Excel reports. - **Popota DGPMB (Institutional Deployment):** Designed and deployed the mobile (Flutter) and backend (MySQL) meal logistics and portion reservation system for staff canteen operations at Direcția Generală de Poliție a Municipiului București. - **SMART Platform (EGFP):** Developed an internal web application (Python Flask, MySQL, PyMySQL) for operational crime records management, suspect identification criteria matching, and analytical reporting across police subunits. --- ### **Independent Mobile Software Engineer & App Architect** *Lead Mobile Developer & Architect* | Remote / Romania **2019 – Present** - Architected, developed, and launched **30+ mobile applications and games** on iOS & Android using Flutter & Dart. #### 🟢 Production & Published Applications: - **GriLEX • Grile Admitere MAI (Production):** The primary exam preparation mobile application for police and law enforcement candidates. Features timed exam simulations, AI legal explanations, offline SQLite storage, Supabase synchronization, and RevenueCat subscription monetization. (Currently expanding to integrate medical admissions / Grile Medicină). - **Minesweeper: Pure Logic (Store Ready):** Modern Minesweeper engine featuring a deterministic deductive SAT solver guaranteeing 100% solvable, guess-free boards, nostalgic Windows 95/98 & Dark themes, daily calendar challenges, 3BV telemetry, and AdMob integration. - **TILT: The Equilibrium Puzzler (Production):** Physics-based equilibrium puzzle game on App Store & Google Play built with Flame & Forge2D, featuring locked layout gravity puzzles, rising deluge survival mode, and custom in-game level creator. - **Popota DGPMB (Production):** Institutional mobile canteen booking application for Bucharest Police staff. - **Flip Rush (Production):** Fast-paced 60 FPS mobile arcade reaction game built with Flame Engine. #### 🟡 In-Development & Beta Products: - **BailOut: Stealth Escape Call:** Discreet social exit utility simulating hyper-realistic incoming and active phone calls across iOS and Android with native CallKit UI, touch-free pocket proximity & shake sensors, disguise calculator mode, and AI voice alibis with live teleprompter. - **Underwater Camera:** Touch-free marine action camera app using accelerometer gestures and compass heading sensors for hands-free photo and video recording. - **Toolbox (SensorKit):** Mobile hardware diagnostics suite offering magnetic compass, sound decibel meter, lux light meter, sensor telemetry, and flashlight tools. - **AegisVault:** Zero-knowledge offline encrypted mobile storage vault incorporating hardware keystore encryption, FaceID/Fingerprint biometrics, and AES-256 cryptography. - **MenuVerse:** Modern digital QR restaurant menu and ordering management platform featuring Supabase cloud sync and PDF menu export. - **Nautix AI:** AI maritime weather forecasting and coastal navigation app integrating Google Gemini AI and Flutter Map. - **Flame Games Suite:** 14+ 2D arcade, action, and physics games (*Scrap Riders*, *Kinetic Catapult*, *Warriors Evolution*, *Bubble Battle*, *Imposter Who*, *Mafia Party*, *LevelTroll*). --- ## Selected Projects Overview | Project | Status | Tech Stack | Type | Key Highlights | | :--- | :--- | :--- | :--- | :--- | | **GriLEX • Grile MAI** | 🟢 Production | Flutter, SQLite, Supabase, RevenueCat | Published App | Official subjects (2016-2024), AI legal assistant, timed simulations, expanding to Grile Medicină | | **Minesweeper: Pure Logic** | 🟢 Store Ready | Flutter, Dart, Deductive SAT Solver, AdMob | Store Game | 100% solvable guess-free boards, retro 95 styling, daily challenges, complete store compliance suite | | **TILT: Equilibrium Puzzler** | 🟢 Production | Flame Engine, Forge2D, Flutter, Drift | Published Game | Balance physics, gravity puzzles, deluge survival, custom level editor (App Store & Google Play) | | **Popota DGPMB** | 🟢 Production | Flutter, MySQL, Supabase, FCM | Institutional App | Bucharest Police canteen meal reservation and inventory logistics system | | **Flip Rush** | 🟢 Production | Flame Engine, Flutter | Mobile Game | 60 FPS arcade tap mechanics, high-score tracking, obstacle physics | | **BailOut: Stealth Escape Call** | 🟡 Active Beta | Flutter, CallKit, Sensors Plus, Audio Synth | Social Utility | Native CallKit UI, touch-free proximity/shake triggers, calculator disguise, voice alibis & teleprompter | | **Underwater Camera** | 🟡 In Development | Flutter, BLoC, Camera, Sensors | Marine Camera | Touch-free underwater photography using accelerometer and compass gestures | | **Toolbox (SensorKit)** | 🟡 In Development | Flutter, Sensors Plus, Geolocator | Hardware Utility | Mobile diagnostics: compass, sound decibel meter, lux light meter, flashlight | | **AegisVault** | 🟡 In Development | Flutter, AES-256, Biometrics | Cryptography Vault | Zero-knowledge security, local hardware biometric encryption, media capture | | **MenuVerse** | 🟡 In Development | Flutter, Supabase, QR Flutter, PDF | Restaurant Platform | Digital restaurant menu catalog, QR code generation, PDF export | | **Nautix AI** | 🟡 In Development | Flutter, Gemini AI, Flutter Map, Riverpod | Maritime Utility | AI nautical route weather forecasts, coastal navigation, interactive map layers | --- ## Contact & References - **Email:** [dylan_calin@yahoo.com](mailto:dylan_calin@yahoo.com) - **Location:** Bucharest, Romania - **Apps & Compliance Hub:** [http://localhost:8094/apps/](http://localhost:8094/apps/)