Матвій

MATVII HONCHARENKO
SQL / BI Developer · Backend Engineer
Kyiv, Ukraine · [відкрити контакти](див. вище в блоці «контактна інформація») · [відкрити контакти](див. вище в блоці «контактна інформація») · github.com/matttttty
PROFESSIONAL SUMMARY
Backend and data-focused engineer with 2.5+ years of commercial experience working with relational data in Oracle and PHP. Strong SQL foundation - complex queries, PL/SQL stored procedures, and transactions - applied to both business logic and production debugging. Currently building RAG systems in Go within a team project. Recently delivered an end-to-end Power BI analytics solution on the same stack modern BI roles use: SQL Server / Azure SQL, star-schema data modeling, DAX, and Row-Level Security. I turn a solid SQL background into working BI deliverables and learn new tools fast.
TECHNICAL SKILLS
Databases & SQL: Oracle, PL/SQL, complex queries, CTEs, stored procedures, transactions, data modeling (star / snowflake schema); PostgreSQL; SQL Server / Azure SQL (project)
BI & Analytics: Power BI (Desktop & Service), DAX (measures, time-intelligence, filter context), Power Query, semantic data models, Row-Level Security (RLS); Pentaho ETL
Backend & APIs: Go, PHP, REST API design, JWT authentication, chi router, HTTP/HTTPS, JSON
DevOps & Tools: Docker, Git, Linux administration (Debian, Rocky), nginx, Apache; AI-assisted development (Claude) in daily workflow
Security & Networking: JWT / role-based access control, API security, cybersecurity fundamentals, CCNA-level networking
Languages: Ukrainian (Native), English (B1, improving)
PROFESSIONAL EXPERIENCE
Backend Developer & Support Engineer - Oracle / PHP / Pentaho 2023 – Present · ~2.5 yrs
• Work extensively with relational data in Oracle for both business processes and production issue resolution - writing and optimizing SQL to trace root causes and fix data-level bugs.
• Develop PL/SQL logic and stored procedures, and administer Oracle databases including session management.
• Designed and built 3 REST APIs; implemented JWT-based authentication in PHP, replacing legacy session storage.
• Investigate and resolve complex bugs across the codebase, including reviewing and debugging other developers' code.
• Build ETL pipelines with Pentaho Data Integration for data transformation and automated job scheduling.
• Manage production web infrastructure (nginx, Apache, SSL) and perform Linux administration across environments.
Go Developer - Team Project (open-source style, volunteer) ongoing
• Contribute to a team-built Go project on a volunteer basis to gain hands-on Go experience - building RAG (retrieval-augmented generation) systems.
• Work on REST services, data handling, and integration as part of a development team.
PROJECTS
CPG Sales Analytics - Power BI personal project
• Designed a star-schema data warehouse (fact + dimension tables) in SQL Server / Azure SQL with foreign-key relationships driving the model.
• Built the semantic model in Power BI and authored DAX measures, including time-intelligence (year-over-year via SAMEPERIODLASTYEAR) and margin calculations.
• Implemented Row-Level Security with regional roles and validated access with “View as role”.
• Delivered an interactive dashboard published to Power BI Service: sales by month / category / channel, region slicer, and margin analysis. github.com/matttttty/cpg-sales-analytics
Helpdesk API - Go personal project
• REST API in Go (chi router, PostgreSQL, JWT); role-based access (client / agent / admin), layered architecture (handler → service → repository), unit + integration tests, Docker Compose, Swagger. github.com/matttttty/helpdesk-api
EDUCATION
Bachelor of Science - Information and Cybersecurity
State University of Telecommunications, Kyiv