Mykola Vasyliv
Ternopil,Ukraine, GMT+02
Phone: +38 0352 247332 (private)
Phone: +38 0352 247332 (work)
Mobile: +38 068 198 20 73
E-mail vmv_gaz@yahoo.com
vasyliv@gmail.com
skype: mykola.vasyliv
yahoo mess.: mykolavasyliv

EXPERIENCE SUMMARY:
•	15 years of programming experience
•	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 (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:
Windows NT/2000/XP, Windows 95/98, Windows 3.11, MS-DOS 3.30 – 6.22
SOFTWARE:
PowerBuilder 5.0 – 11.5, PFC,  DELPHI 2.0 -5.0, FoxPro, Clipper , .NET, C#
PowerDesigner 
DATABASE::
Sybase (Sybase SQL Anywhere 5.0 – 5.04, Adaptiv Server), ASA 6.0 - 10.0,ASE,  Informix, MS Sql Server 2000, MS SQL Server 2005,Oracle,   MS Access Dbase, Foxpro
LANGUAGES:
PowerScript, HTML,  Clipper, Foxpro,  SQL, JavaScript, Visual  C#.Net 
OTHERS:
MS Office 7/97/2000/XP/2003, 

EMPLOYMENT HISTORY:

2008.01.18 – today - Freelancer in odesk.com (PowerBuilder)
2007/11/23 - today - Development of the project with my group: .NET, C#, PowerBuilder, PowerDesigner, ASA, MS SQL Server, Oracle. 
2006/12/06 – 2007/11/23  - company Luxoft department in Kiev, Ukraine. Programmer PowerBuilder, Oracle 9.2 

2006/09/15 – 01.12.2006 Projectc Arhitect (Ms Sql Server 2005, 2000, PowerBuilder 10.5, PowerDesigner 12.1, C#, ADO.NET) – company “Kameo”, Moscow. 
2005/06/01 – 01.12.2006 Programmer  and DataBase designer on contract in Moscow firm (MS SQL Server 2000 + PowerBuilder 10.5 + C#, DataBase Designer, PowerDesigner 12.1, ) – company “Kameo”
2004/02/01 – 06.12.2006 Consultant in company TRK “Satelit”

2004/02/01 – 2004/09/01 - 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 ASA 9.0
2004/04/15 – 2004/04/27 – edit error in billing system write on foxpro 2.6 for company in USA. (Worked through the intermediary).
2004/09/10 – 2005/03/28 developer project “Obligatory civil liability”  for insurance company Universalna in Lviv of Ukraine . Use PowerBuilder 10.0, PowerDesigner, ASA 9.0 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.
1999/03/10 – 2004/02/01 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.

1993/09/22 – 1999/03/10 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. (Foxpro 2.0, 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 11 September 1997,  ended 1 January 1998, tested from 18 Desember 1997.

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 10 March 1999,  ended 20 April 1999, tested from 1 April 1999.

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 22.03.2000 on 09.05.2000.
Tested on length with 10.05.2000 on 25.06.2000.
Put Into Effect with 01.07.2000.

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 01.09.2000.
  
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 Studio 8.0, PowerBuilder 8.0, PowerDesigner 7.5 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 ASA 8.0, PowerBuilder, PowerDesigner 9.0

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 ASA 7.0, 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 ASA 8.0, 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 Anywhere 5.0, ASA – 7.0 , PowerBuilder 5.0 – 8.0, InforMaker 5.0, PowerDesigner (1997, 1998)
6.	The credit and deposit bill discounting and its automation (intrusion of a unified system) (1998)

PERSONAL DATA: 
Date of birth: November 27, 1965 
Marital status: Maried 
Children: 2 children, 9 year, 6 year
Driving license: no

FOREIGN LANGUAGES:
Native Ukrainian 
 English – read, write. Speak English – bad.
Fluent Russian