Mar `19 – Apr `19
Development and improvement for ETL and analytics/reporting, Design ETL workflows to feed up DWH, Design, build and deploy DWH, Manipulation with data in MySQL
It provides innovative enterprise software to fight corruption and fraud. The system consists of different user roles which perform separate business purposes and have access to the special functionalities in accordance with permissions. The system is used to create a request to the approval department for providing services for submitter (requester).
Technologies Stack:ETL MySQL PostgreSQL Data Warehousing
Healthcare & Medicine
Responsive Web application
Oct `16 – Feb `19
Development and optimization of current database and back-end solution.
Development and optimization of web HR portal. Tool allows hr to follow all company-employee relationship – from getting CV, assigning training, salary review and so on to resigning from the company.
Service & Support
Jan `16 – Feb `17
AWS Schema Conversion Tool
Database optimization. Developing rules for metadata (tables) and parsable (functions, views) objects conversion.
Tool makes database migrations by automatically converting the source database schema and a majority of the custom code to a format compatible with the target database. AWS Schema Conversion Tool https://docs.aws.amazon.com/SchemaConversionTool/index.htm
Technologies Stack:C# SSIS MSSQL
Architecture & Design, Big Data
Oct `15 – Jun `16
Oct `14 – Oct `15
Under NDA. CRM
Developing reporting system which is used by most departments of company. Developing DWH, SSAS, SSIS, SSRS.
Development of a product that our customer will sell to pharmaceutical companies for the sale of medicines and medical equipment. The project is divided into two main pieces: Customer Relationship Management (CRM), Multi-Channel Marketing (MCM). CRM tracks sales of a product (drugs, equipment, etc.) and cooperation with different healthcare providers and healthcare organizations. The MCM product will help marketing departments to track marketing activities and programs at every stage.
Technologies Stack:C# SQL Server SSIS MSSQL
Healthcare & Medicine
CRM, Web platform for marketing campaigns
Sumy State University
Master`s Degree in Finance
Programming in C#
Administering a Microsoft SQL Database Infrastructure