Arkadiy

ARKADIY TEPMAN
Senior Database Engineer (SQL, DWH, ETL)

CONTACT PROFILE SUMMARY
📞[open contact info](look above in the "contact info" section) Senior Database Developer with 30+ years in IT, including 25+
years focused on database development, SQL optimization, and
📧 [open contact info](look above in the "contact info" section) data systems. Extensive experience with MS SQL Server, MySQL,
and Oracle, building reliable and high-performance database
[open contact info](look above in the "contact info" section) solutions.
arkadiytepman Strong background in ETL, data integration, and Data Warehouse
environments, including work with SSIS and BI tools. Over the last
8 years also involved in back-end development of data-driven
SKILLS applications.
Hands-on experience working with large-scale databases, query
tuning, stored procedures, and performance optimization in
Databases: MS SQL Server,
production systems.
Oracle, MySQL
Experience optimizing high-load production databases and
SQL: T-SQL, PL/SQL, Query resolving complex performance issues.
Optimization
CORE EXPERTISE
ETL: SSIS, Pentaho
SQL Performance Optimization
DWH: Data Warehouse, Data Warehousing (Star Schema, ODS)
ODS, Star Schema ETL & Data Integration
Large-Scale Databases
BI: SSAS, SSRS, Qlik Query Tuning & Troubleshooting
BI & Analytics Systems
Programming: C#, Java

Version Control: Git, SVN
PROFESSIONAL EXPERIENCE
1 World R & D Center 2020 — 2025
Business Automatics JSC 1998 — 2020
EDUCATION Institute of Social Progress 1993 — 1998

1988-1993
Kharkiv National University
SELECTED PROJECTS
Master’s Degree in
Mathematics WellnessLiving Inc. — High-Load SaaS Platform
Role: Senior Database Engineer | Period: 2022–2025

WellnessLiving develops an all-in-one business management
platform for wellness studios, including scheduling, payments, staff
management, reporting, and marketing tools.
●​ Designed and improved database architecture for a
large-scale production system
LANGUAGES ●​ Optimized complex SQL queries and resolved performance
bottlenecks
Ukrainian — Native​ ●​ Analyzed execution plans and tuned slow queries
Russian — Fluent​ ●​ Refactored database schema and improved table
English — Technical / structures for better performance and scalability
Working proficiency ●​ Worked with large-scale transactional databases and
high-volume workloads
●​ Implemented an existing database sharding strategy to
support system scalability
●​ Resolved deadlocks and performed database performance
COURSES troubleshooting
●​ Improved indexing strategy and overall query performance
•​ Author's course by
●​ Collaborated with backend developers to improve system
Bogdan Chupika Java stability and efficiency
at Wellnessliving Inc. Technologies: MySQL
December 2024.
•​ Author's course by
Visimore — IoT Data Platform / Asset Tracking System
Bogdan Chupika
Role: Lead Backend & Database Developer | Period: 2017–2021
Microservices 101 at
Wellnessliving Inc. Visimore is a platform that collects and processes IoT sensor data
December 2024. to improve asset tracking and operational efficiency.
●​ Acted as the main developer responsible for backend and
database architecture across multiple pilot and early-stage
projects
●​ Designed database schema and data models from scratch
●​ Developed backend components and database logic for
processing incoming sensor data
●​ Implemented complex SQL queries, indexing strategies,
and stored procedures
●​ Integrated external data sources using RabbitMQ as a data
ingestion layer
●​ Processed and stored streaming IoT data from multiple
sources
●​ Performed database performance tuning and query
optimization as data volume increased
Technologies: MS SQL Server, C#, LINQ, RabbitMQ

PLS — Logistics Analytics & BI System
Role: BI Developer | Period: 2015–2017
PLS RTI Manager is a logistics and asset tracking system that
supports transportation operations and analytics based on RFID
tracking data.
●​ Developed BI reports and dashboards using Qlik
●​ Worked with logistics and operational data for analytical
reporting
●​ Built visualizations to support business monitoring and
operational insights
Technologies: Qlik
Clickfuel — Analytics Data Platform
Role: Database Engineer | Period: 2011–2013

Clickfuel is a SaaS platform that aggregates marketing data from
multiple services and provides analytics and performance insights
for marketing campaigns.
●​ Designed database architecture and data models for an
analytics data platform
●​ Implemented a data warehouse using star schema for
analytical workloads
●​ Designed and implemented data pipelines from staging
layer to the data warehouse
●​ Optimized complex SQL queries and analyzed database
performance
●​ Designed indexing strategies and developed stored
procedures
●​ Worked with large volumes of marketing and analytics
data
●​ Performed database administration and performance
tuning
Technologies: MySQL

NameMedia — Data Warehouse & BI Platform
Role: DWH / ETL Developer | Period: 2009–2011

NameMedia is a domain marketplace platform that integrates and
analyzes data from multiple corporate systems and domain trading
services.
●​ Designed and implemented a data warehouse integrating
data from several corporate systems
●​ Developed ETL processes and data integration workflows
●​ Implemented a star schema data model for analytical
reporting
●​ Built staging layer and data pipelines for loading data into
the data warehouse
●​ Implemented regular batch data loads and data
consolidation processes
●​ Performed data transformations, cleansing, and mapping
across multiple source systems
●​ Developed analytical reporting solutions using the
Microsoft BI stack
●​ Later participated in transition of ETL processes from
Microsoft BI tools to Pentaho
Technologies: MS SQL Server, SSIS, SSAS, SSRS, Pentaho
Accounting System — Financial & Inventory Management System
Role: Database Developer / Backend Developer |
Period: 1998–2005 (active development), later support and
maintenance

Internal financial and inventory management system used to
support company operations and business processes.
●​ Designed and developed database architecture for a
transactional system
●​ Implemented database schema, stored procedures, and
business logic
●​ Optimized SQL queries and improved database
performance
●​ Developed reporting and calculation logic for financial and
operational data
●​ Provided long-term support and maintenance of the
system
Technologies: MS SQL Server, Oracle, Delphi