Vadym

VADYM HAMZA
PERSONAL PROFILE
Database Software Engineer with more than 7 years of experience in the IT
and Data Analytics field. I have 5 years of experience as a Database Software
Engineer developing and maintaining MS SQL Database with T-SQL for
desktop and web applications. Additionally, I have 2 years of experience as
a Data Management Specialist generating reports and dashboards using
Power BI and Google Data Studio. I am skilled in working within
Agile/SCRUM environments and following SDLC best practices. I am results-
driven, reliable, and detail-oriented, with a strong commitment to
CONTACT ME AT delivering high-quality solutions.

WORK EXPERIENCE
[open contact info](look above in the "contact info" section)

[open contact info](look above in the "contact info" section)
Database Engineer
SoftServe, Lviv | Apr, 2021 - May, 2026
SKILLS & Gather requirements from stakeholders and translate business needs into
TECHNOLOGIES scalable database solutions.
Design and maintain database schemas, including tables, relationships,
Programming Languages/Technologies: indexes, and constraints.
T-SQL, PostgreSQL,
Develop and maintain T-SQL database objects, including stored procedures,
Azure Cloud, Azure Data Lake Storage,
Azure Data Factory views, functions, triggers, jobs, and deployment scripts.
SQL Server Integration Services Deliver database enhancements and schema changes within Agile/Scrum
UML/ ERD/ Reverse environments.
Engineering/Technical Troubleshoot production and test environment issues, perform root-cause
Documentation
analysis, and implement SQL-based remediation.
dbt
Python Optimize queries, indexes, execution plans, and transaction handling to
improve performance and scalability.
RDBMS: Support database releases, deployments, incidents, and technical
MS SQL Server, Azure SQL database, documentation.
BigQuery
Develop ad hoc SQL scripts for data validation, cleanup, correction, and
Query tuning: execution plans,
indexing, Query Store
migration activities.
Extended Events, SQL Server Profiler; Build and maintain reporting datasets, analytical queries, and support ad hoc
SQL Server Agent jobs reporting and data analysis requests.
Plan analysis tooling (SolarWinds Plan Perform data profiling and ensure data quality and consistency across
Explorer / SentryOne) reporting and operational systems.
Support MS SQL Server to PostgreSQL migration initiatives, including schema
Version control and Development tools:
SSMS, pgAdmin mapping and syntax conversion.
Visual Studio Collaborate closely with developers, QA, DBAs, and release teams throughout
GitLab the software delivery lifecycle.
Jira Contribute to the continuous improvement of database architecture,
Cursor AI
development standards, and best practices to ensure maintainable, reliable,
and scalable data solutions.
Leverage AI-assisted development tools to accelerate development,
refactoring, and legacy code analysis.

Personal DW project:
Designed and implemented a relational data warehouse, including dimension
tables and fact tables normalized from raw source files
Built ETL pipelines using SSIS and Azure Data Factory to ingest raw files into
staging tables, cleanse and transform data (date/time consolidation, lookups
through reference tables, window-function-based summaries), and populate
warehouse layers
Implemented data quality rules and validation logic (date ranges, duplicate
detection and removal, referential checks, standardized text fields) with
supporting logging tables for imports, errors, and run history
Worked with Azure SQL Database and Azure Data Lake Storage for cloud-based
storage, staging, and warehouse processing
 WORK EXPERIENCE

Worked with Azure Data Factory triggers for scheduling automated pipeline
executions
Optimized and operated the solution using appropriate indexing, transactions
and isolation levels, and scheduled and restartable loads in SQL Server Agent
and Azure Data Factory

Data Management Specialist
Data Analysis Nestle Business Service, Lviv | Oct, 2018 - Apr, 2021
Detail Oriented Data Collection and Quality Assurance: Conducted thorough analysis of data
supplied by the Agency/Markets.
Data Collection
Report Generation: Created periodic data reports and dashboards for
MS Power BI (DAX, Power Query)
management and clients utilizing Excel, Power BI (including Power Query and
MS Excel
DAX), and Google Data Studio.
Google Data Studio Timely Data Availability: Ensured data was accessible within the approved
MS Office Suite timeframe and effectively consolidated from various sources.
Google Suite Follow-Up with Data Providers: Communicated with data provider contacts as
Google Analytics, Google AdWords, CM, needed to ensure data readiness for timely report generation.
FB Manager, DV360, Social Studio User Support and Consultation: Assisted and advised users on report-related
matters, providing additional instructions as necessary. Investigated and
resolved data discrepancies alongside troubleshooting teams and conducted
deeper data analyses upon request (Ad-hoc).
LANGUAGES Process Improvement: Implemented enhancements for data management
Ukrainian processes.
English
Accounts Payable Accountant
Nestle Business Service, Lviv | Mar, 2016 - Sept 2018

Ensured timely and accurate posting of vendor invoices, debit and credit notes
through manual or automatic processes (EDI, e-invoice, etc.).Handled the daily
processing of hundreds of invoices and related documentation.
Reviewed invoices and requisitions for satisfactory payment approval and
obtained proper information and/or data regarding invoice payments.
Responded to markets queries and according to the agreed resolution
turnaround time. Coordination with internal stakeholders (purchasing, business
units, etc.) providing efficient and fast resolution.
Prepared and performed quality checks and supported, collaborated with other
departments to improve processes and efficiencies.
Consistently maintained accuracy throughout out all accounting practices.

EDUCATIONAL HISTORY

Lviv Institute of Banking University of Banking of the National Bank of
Ukraine

Master of Finance and Credit | Sep, 2008 - Jan, 2014
Graduated at the top of my class.
Honors bachelor's degree

EXTRA EXPERIENCE

Upwork, Freelancehunt
Freelancer | Sep, 2019 - Mar, 2021
Skilled freelancer with experience to work with foreign clients (US) for Data
entry, consolidation, scrapping, managing web reports and web research
projects.