Information
YouTeam is now part of Toptal. You now have access to a complete range of world-class talent and services.
Close
YouTeam Logo

Summary

Expertise

Project Highlights

Education

Agency

VS

English:

Upper Intermediate

Viktor S.

vetted by Youteam

Vetted by YouTeam

Ukraine

UTC +02:00

Ukraine/Kyiv

English:

Upper Intermediate

Software engineer with 13+years of experience in development and designing database solutions.

Engineer with 10+ years experience. 8 years experience working with DBMS (Oracle(PL/SQL), MS Access(VBA), MSSQL(T-SQL), DB2). Modeling, development, testing, supporting program units. 2 years experience using C#/Java 2 years experience in programming for Oracle Forms/Reports. 2 years Informatica Power Center

Want to hire this engineer?

Check if Viktor is available

Expertise

Years of commercial development experience

13 years of experience

Core technologies

AWS 3 years
SQL 5 years
Ruby
JavaScript 10 years
Data Modeling 5 years
PostgreSQL 5 years

Other technologies

ETL
JIRA
MySQL
Oracle
SQL
Visual Studio
IntelliJ IDEA
JDBC
JMeter
Web Services
Postman
Toad
DataGrip

Project Highlights

icon
Data Engineer

Data management platform

Jun `19 - Mar `21

2 years

NDA

Data management platform

Responsibilities & achievements

I was responsible to orchestrate data between numerous source/target systems. Data volume up to 1 GB S3 file. Gather requirements Coordinate the dataflow model Implement ETL jobs Deployment Performance improvements for existing ETL workflows

PostgreSQL
S
Postman
RESTful API
icon
Database Engineer

drug delivery systems

Jul `18 - May `19

10 months

Medical Technological Company from S&P 500

Medical Technology Company that develops and manufactures medical devices and instrument systems.

Responsibilities & achievements

company consists of business segments: Medical -consists of Medical&Procedural, Pharmaceutical, Diabetes Care Life Sciences -consists of Preanalytical, Diagnostic, Biosciences Systems Biosciences Unit Medical&Procedural unit develops drug delivery systems, which I was focused on. Gathering requirements Implementation of new version of software for Infusion pumps system Building team structure (technical interview, onboarding)

SQL Server
Visual Studio
Git
TFS
icon
Database Performance Engineer

Reporting system

Jul `17 - May `18

10 months

CompanyWorld’s leader in digital agriculture delivering

A company focus on precision agriculture. The main products are: FarmCommand -a complete farm management platform (all in one) Daily Satellite Imagery Weather stations -gets weather information from where it matters most Company’s data volume is 1-10 TB (depends on product).

Responsibilities & achievements

Performance monitoring Database health check Proposal performance improvements Provide fixes for critical issues Database optimization

PostgreSQL
PgAdmin
icon
ETL Engineer

Business loans aggregator

Jul `16 - Jun `17

11 months

NDA

Online marketplace that allows business owners to find small business loans

Responsibilities & achievements

BI: database maintenance. Support of existing functionality. Development of new features ETL: Proposal and comparison of ETL approach. Database: performance tuning of both operational database and bi database. Optimization DB architecture (index, constraints, heavy queries) Code review. Deploy to Staging and PROD

MySQL
Confluence
Trello
icon
DB/DWH Architect, ETL engineer

Social Network

Sep `15 - May `16

8 months

U4G.com

U4G.com is a social network, with a gamification strategy. It rewards people for acts of kindness

Responsibilities & achievements

DWH: Proposal preparation. Architecture presentation. Realization on DevEnvironment. Deploy to PROD. Support ETL: Choosing the software stack. Agreement of BRD and FR. Implementation of ETL process Update with version 2.0 (after increasing of data volume and changing FR) Database: performance tuning of the main project. Optimization DB architecture (index, constraints, heavy queries)Implement 2 new projects (ER model, implementation, deploy)

AWS
MySQL
Python
JSON
Bash
icon
Back End Developer

Enterprise Content Management, Storage, and Archiving

Jan `15 - Aug `15

7 months

ASG (www.asg.com) US company

The ASG-ViewDirect® Suite is a scalable ECM system that delivers fit-for-purpose ECM solutions. It manages all content regardless of type, volume, platform, storage device or viewing client in distributed and mainframe environments

Responsibilities & achievements

To learn the system To define bottlenecks To propose solution for solving To elicit requirements from business analysts and product owner, To discuss activities with a development team. To be sure that changes does not modify existing conformance To functional requirements Move core logic from the back end layer to the RDBMS Optimized specific heavyweight queries Set up a scalable model according to functional requirements

C#
Java
Oracle
SQL Server
Redmine
icon
DWH Engineer

Regulatory&Control(Dodd-Frank)

Feb `12 - Nov `14

3 years

Top Investment Bank

The Depository Trust & Clearing Corporation (DTCC, www.dtcc.com) is the world’s largest posttrade financial services company, authorized by The U.S. Commodity Futures Trading Commission (CFTC, www.cftc.gov, an independent agency of the United States government that regulates futures and option markets) to gather ongoing financial, operational and regulatory reports. The project mission is to furnish regulatory reporting for DTCC. The solution allows loading data from different source systems, consolidating it in data warehouse, validate data, calculate financial indicators and populates specific data marts, generate reporting and send financial data to DTCC CIB London, UK Division

Responsibilities & achievements

Physical and Logical data modeling Data analysis Development of ETL processes Development reporting (Rates/Credits OTC Derivatives) Post-production system support 11 team members, 100+ project members

Informatica
JMS
Oracle
PL/SQL
CollabNet TeamForge
Erwin
Jenkins
Bash
Quality Management
icon
DataOps

Retailers data management platfrom

May `11 - Present

14 years

IT Company

The company is the provider of solutions to help retailers to understand and act on their data

Responsibilities & achievements

to gather raw data from retail customers; validate and clean the data; transform data into a common format; calculate basic metrics, and customer-specific measures; provide prescriptive analytics to customers, and help retailers easily understand and act on their data. My responsibilities:1. To migrate the ETL process (steps 2 -5) from legacy (on-premise) system to cloud (GCP Warehous)2. To maintain the existing on-premise solution

Salesforce
SQL Server
Git
Google Cloud Platform
icon
ETL Engineer

Cash Equities Data Management

Sep `10 - Dec `11

1 year

top Investment Bank (hq Zurich)

Development, Implementation of ETL system for JP EDS project

Responsibilities & achievements

Migration of JP EDS to new unified and stable platform (24/7), which allows to receive input files of different formats and consolidate all calculated data To develop ETL process To implement of ETL process Communication with business analysts and Product Owner To consult the Business on various instrument static data issues To participate in post-production release verification To elicit requirements from business users

Informatica
JIRA
Oracle
PL/SQL
Bash
icon
ORACLE database developer / Oracle Application Server developer

Billing system for commercial banks

Nov `09 - Jul `10

8 months

EU Company

SmartVistais a platform, which handles all aspects of ATM management, billing, mobile and contactless payments, settlement, point of sale, card issuing and acquiring, microfinance, and electronic payments processing

Responsibilities & achievements

To implement and support the SmartVista Back-Office for the clients To elicit requirements from business users Development of various reports To consult the Business users on platform issues Fixing bugs

PL/SQL
J2EE
Oracle Application Server
icon
Senior Software Specialist

OJSC bank

Mar `06 - Oct `09

4 years

EU Company

Scoring system - consumer credits Calls calculation -calculation of telephone calls cost based on avaya logs system development for the Bank’s Treasury Car loans register -system development and support Credit insurance -system development and support

Responsibilities & achievements

Creating and launching of the following projects: Scoring -Development of the decision-making scoring system (consumer credits) Roster collateral-system development and support Prolongation and restructuring -system development and support «Sbercard» -system development and support Consultation with the business department Defining requirements and logic Preparing project documentation Testing of the one functionality Bugfixing

Oracle
PL/SQL

Education

Higher education in Computer Science

Agency

Web application & Azure Cloud agency #2633

50-100

GMT+2

Lviv, Ukraine

Core Expertise

AngularJS
ASP.NET
ASP.NET MVC
Azure
C#
Ionic
JavaScript
Kubernetes
.NET
React.js
React Native
TypeScript
QA Management
Unit Testing
Angular 2x
Test Planning
ASP.NET Web API
Test estimation
.NET Core

Industries

Information services & Technologies, SaaS

Want to hire this engineer?

Check if Viktor is available