English:
Upper Intermediate
Ukraine
UTC +02:00
Ukraine/Kyiv
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 availableExpertise
Years of commercial development experience
13 years of experience
Core technologies
Other technologies
Project Highlights
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
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)
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
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
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)
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
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
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
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
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
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
Education
Higher education in Computer Science
Agency
50-100
GMT+2
Lviv, Ukraine
Core Expertise
Industries
Information services & Technologies, SaaS
Want to hire this engineer?
Check if Viktor is available