Resume Programmer

Mykola *******

Ternopil,Ukraine, GMT+02

Mobile: Show contacts

E-mail

***************** (mailto:*****************)

*******@gmail.com (mailto:*******@gmail.com)

skype: mykola.*******
yahoo mess.: mykola*******

EXPERIENCE SUMMARY:

1. 20 years of programming experience
2. Solid background in Object Oriented Programming and Development

Programmer/Analyst with eight years of experience and solid background in analysis, design,

development and implementation of RDBMS applications in Windows (C#, Asp .Net MC, PowerBuilder,
sql, t-sql, Sybase Adaptive Server, DBA, MS SQL server, Oracle) based Client/Server environment, data
modeling, object-oriented modeling and design. Full system life cycle hands-on experience: coding, testing,
performance tuning, installation, documentation, end user training.

TECHNICAL SUMMARY:

OPERATING SYSTEM:
Ubuntu, Windows NT/*******************/*************.************.30 – 6.22
SOFTWARE:
Hadoop, Spark, Pow************* – 12.****************.0 -5.0, FoxPro, Clipper , .NET, C#, Entity
Framework, ASP.NET MVC
PowerDesigner
DATABASE::
Hive, Sybase (Sybase SQL ************ – 5.04, Adaptiv Server), ******* - 12.0, Informix, MS Sql
Server 2000,, MS SQL Server 2005, Ms SQL Server 2014, Oracle, MS Access Dbase, Foxpro
LANGUAGES:
PowerScript, HTML, Clipper, Foxpro, SQL, JavaScript, Visual C#.Net, ASP.NET MVC
OTHERS:
MS Office *********/XP/2003,

EMPLOYMENT HISTORY:

********** - - Arhitector database, DataWarehose, DataLike, Hadoop, Hive, Spark.
********** – ********** – developer tasks use .NET, C#, ADO.NET, EF, MS SQL SERVER to company
ViknarOff

********** – today - Freelancer in odesk.com/upwork.com (PowerBuilder, .NET)
link profile:

https://www.upwork.com/freelancers/~***********0789000?viewMode=1 (https://www.upwork.com/freelancers/~***********0789000?viewMode=1)

********** - today - Development of the project: Python, .NET, C#, ASP.NET MVC, PowerBuilder,
PowerDesigner, ASA, MS SQL Server, MySQL.

********** – ********** – company «Galactica Alianca». Project: Auto download prices (xml, xls, csv, ...)
with url, files and auto import to database MS SQL. WinForms App (C#, ADO.NET, EF) for search
products in database.

********** – ********** - company Luxoft department in Kiev, Ukraine. Programmer PowerBuilder,

**********

********** – ********** Projectc Arhitect (Ms Sql Server 2005, 2000, Pow**************, PowerDesigner
12.1, C#, ADO.NET) – company “Kameo”, Moscow.
********** – ********** Programmer and DataBase designer on contract in Moscow firm (MS SQL
Server 2000 + Pow************** + C#, DataBase Designer, Powe**************, ) – company “Kameo”
********** – ********** Consultant in company TRK “Satelit”

********** – ********** - Programmer/ Consultant (contract) in company Centaursoftware in you
Moscow office (analiz code in project Dental for Windows on freeze and write resize for project objects. ). 
Use PowerBuilder , PowerDesigner and *******
********** – ********** – edit error in billing system write on ********** for company in USA. (Worked 
through the intermediary).
********** – ********** developer project “Obligatory civil liability” for insurance company Universalna 
in Lviv of Ukraine . Use Pow**************, PowerDesigner, ******* and use replication sql remote. As 
the program will work in each area and in each area of Ukraine, there are branches of the company.
********** – ********** Programmer/Analyst, Consultant 
Company Name: “TernopilGas”, City: Ternopil
Project “Subscriber”

Purpose: Registration of used natural gas by subscribers and registration of payment for it. I am 

working on the arrangement and the beginning of working up the project.
 

The system based on proprietary framework and the problem domain, designed and 

implemented extensively using object-oriented concept and the most advanced programming techniques. 
Operational database (implemented in Sybase SQL Anywere) consists of over 250 database tables and 
based on highly sophisticated logical design.

As a conversion programmer was responsible for conversion of complex

business data from multiple legacy (PC based) data sources to the designed system
Created generic framework classes for data retrieval from multiple, vendor independent data sources upon 
runtime loaded input specifications. Designed and created conversion program, extracting business entities 
from legacy databases and then submitting appropriate entities to the Problem Domain after business 
defined manipulations. (PowerBuilder)

 Designed, created and managed conversion databases. Created stored

procedures and scripts providing business related validations and corrections of
legacy data. Implemented reverse and forward engineering, wrote complex
balancing reports using PowerBuilder.

Performed conversion of existing databases from Dbase and Paradox to Sybase Sql Anywere.

********** – ********** Programmer, Consultant
 Company Name: Main Department, Industrial Investment Bank , City: Ternopil
Accompaniment and writing small programm to already available programs.
Program working place of leader and chief accountant of a decorating a bank. (**********, Dbase, Dos)
Written program on account of deposit and credit agreements (Clipper, Dbase, Dos).

Programs written by me on request of other companies

1.

“Register”

Purpose: Automation of the work of independent register of securities of joint – stock companies 

which independently take stock of securities of joint – stock company.

The application consist of over 40 windows and 70 database tables. Designed the applications 

ancestor objects, based classes and global functions, that comprised the framework of the application, 
utilizing object-oriented concepts.
The Complex allows to do all necessary operations with securities due to legislation.
This complex also allows to form all necessary acccounts for register’s work.

This complex has been exploited for one year already.
I designed project, programmed. The work was started *****************, ended **************, tested 
from ****************.

2. “Library”

Purpose: This complex is used for automation registration library fund and automation work of librarian.
The application consist of over 25 windows and 45 database tables. Designed the applications ancestor 
objects, based classes and global functions, that comprised the framework of the application, utilizing
object-oriented concepts.
The program allows to registrate entries into library fund. It also allows to help automatic giving literature 
to subscriber and automatic taking over literature from subscriber.
There is an opportunity to work with personal particulars of subscriber in this program. 
Automatic formation of different starting forms both on subscribers and on literature due to parameters 
indicated by subscriber has been worked up in program complex “Library”. This complex has been 
exploited for seven months.
The work was started *************, ended *************, tested from ************.

3. "Account of abonents of cable tv"

For the company which concerns with a cable tv is written program on the account of abonents 

which use services of cable tv, as well as account of payment by abonents for the service. In given program 
complex marketed functioning with abonents which have debts on the payment.

Their printed list, at the option of user for they are formed and haves something published a report 

on need to conduct a payment. In this message be also date on which abonent is made payment and its 
biographical data. When receiving a payment are formed and have something published a receipt cash 
warrant. At The End of account period are formed all necessary reports.

Searching abonent is executed on any one parameter or immediately on any several parameters 

from the questionnaire anketa abonent.
Task is designed at a period with ********** on **********.
Tested on length with ********** on **********.
Put Into Effect with **********.

4. "Account of policies by insurance company "

For insurance companies written program complex on the account of sale insurance policies.
Company has a number of branches in country. Central base is used on the company. From 

branches enter neogone given at the end of each month. Program with provision for functioning a real-time
together with branches. But on time moment does not work in this mode from - for incomplete technical 
equipment company (are absent modems on branches).

Data on the central base enter with 5 operator computers, which situated in the office. 10 users 

work with db which have enterred in the base from operator places. Task is put into effect with **********.

5. The system for insurance group Universal is developed. The company totals 20 branches and central 
office. The synchronization of a database of branches on the central base is developed.

The system is developed in view of job in a part of realization of the policies, in a part of 

settlement and in a part of the main manager of base.
The means Sybase Anywhere **********, Pow*************, Powe************* are used.

6. “Counter” – 2002 - 2003

For laboratory on check gas counter marketed project on account 

and motion counter from gas company before plant of the producer or in 
gosstandart and back. Also account of the checks counter.
Project marketed with use *******, PowerBuilder, Powe*************

7. “Gasmain” - 2003

For technical subdivisions of the gas services of the area 

marketed project on account of the gas equipment in abonent. The 

Description of the gasmain , who the construction , who and when 

received a visit at usage. The Account of the briefings abonent 
conducted workman of the services. The Description of the technical 

equipping of the gasmain. The Unattended operation on undertaking the 
annual planned repair. Lead the calculation of the production losses at 

transportation of the gas.
Project marketed with use *******, PowerBuilder, PowerDesigner

8. “Communal service” - mart – august 2003

Prekt on account abonent communal of the service. Account наданых 

services and reception of the payment for give facilities Project 
marketed with use *******, PowerBuilder, PowerDesigner

9. Settlement for insurance company – November 2003 – may 2004 years.

EDUCATION: 

1983-1990

Ternopil State University, Physic-Mathematic department,
Ternopil, Ukraine.

COURSES:

The Ternopol financial academy:

1. The quarter fiscal accounting and its automation. (1999)
2. Document circulation. Organization of its management. (1999)

Industrial Investment Bank:

1. Annual balance of bank and its automation. (1996)
2. Automation of formation of the reporting for auditor check.(1996)
3. The financial analyst of bank (1997)
4. Transition to the new schedule of the scores and automation of the financial bill 

discounting (1998)

5. Sybase SQL ************, ASA – 7.0 , Pow************* – 8.0, I*************, 

PowerDesigner (1997, 1998)

6. The credit and deposit bill discounting and its automation (intrusion of a unified system) 

(1998)

PERSONAL DATA: 

Date of birth: ***************** 
Marital status: Maried 
Children: 2 children
Driving license: Yes

FOREIGN LANGUAGES:

Native Ukrainian 

English – read, write.

Fluent Russian