Oleg Kolesnyk, Software Developer
English | Deutsch

MS Word Version

PDF Version
 
Personal details

Contact

Oleg Kolesnyk
Munich

Cell phone: +49 (0)1522 95 83 107
E-mail: oleg.kolesnyk@gmail.com
Web: https://olegkolesnyk.tripod.com/english/resume.html
XING: http://www.xing.com/profiles/Oleg_Kolesnyk
LinkedIn:  http://de.linkedin.com/in/olegkolesnyk
Photo
Born August 4, 1973 in Kiev, Ukraine
Family married, two children
Nationality German
 
Objective

Performing consulting services in the following areas:

  • software development (C#, .NET, C++, Perl, Python, Java)
  • database development
 
Summary of Qualifications
 
  • Extensive experience in programming in Windows and UNIX environment: C#, C++ and C (12 years), Perl (6 years), Java (3 years), Visual Basic (3 years), Python (2 years)
  • In-depth understanding and hands-on experience in Object Oriented design and coding, developing client-server applications and creating Windows GUI applications using C#, C++, Visual Basic; UNIX and Windows batch/shell scripting
  • Comprehensive expertise in database development, SQL, PL/SQL and T-SQL programming, developing database front-ends and applications that communicate with SQL databases using C#, C++, C, Visual Basic and Perl (10 years)
  • Strong knowledge of Oracle, MS SQL Server, MySQL databases (database design, management, performance, optimization of complex SQL queries etc.); solid background in DB administration and DB developer tools (10 years)
  • Thorough knowledge of UNIX clones including Solaris, Linux, FreeBSD (3 to 5 years each) and extensive experience in UNIX system administration; practical skills in Windows OS family administration
  • Ongoing experience in using various development tools and source control systems; wide full project life cycle experience and broad experience in working for big and distributed projects
 
Professional Experience
01/2014 – present Freelance work in IT-Consulting area (IT-consulting and services, software development, database development)

Projects:

  • Pirelli, Munich [Reference (.pdf)]
    Duration: 3.5 months
    Tasks:
    • C#-Development, Database-Development (MS SQL Server); creating a database-based client-server application (WCF) including server and client parts and complete design of the underlying database
    • Development of WPF-based WCF clients and database front-ends
    • Developing a database access library using ADO.NET Entity Framework
    Environment: .NET, C#, WCF, WPF, ADO.NET Entity Framework, SQL und T-SQL, MS SQL Server, Visual Studio 12-13, Windows 7

  • BayernGas GmbH, Munich [Reference (.pdf)]
    Duration: 8 months
    Tasks: SQL und PL/SQL Development (Oracle); creating database-driven (Oracle) dynamic reports; extensive SQL and PL/SQL programming; various Oracle database administration tasks (export/import scripts etc.)
    Environment: SQL, PL/SQL, Oracle, IIS, Windows 7, Windows Server
11/2010 – 06/2013 UniCredit – HypoVereinsBank, Munich [Reference (.pdf)]

Software Developer

  • Member of the Integration and Release Team responsible for the continuous integration of the internal software product and its components. The end product was a complex distributed system for evaluating various financial instruments and estimating financial risks used in 24/7 mode by multiple bank traders simultaneously. The most modules were implemented as C++ programs that heavily communicated to the Oracle database
  • Created tools for automation and monitoring of the software integration and test process. These were C++ and C# programs (with GUI written with use of WPF technology) that intensively interacted with the Oracle database as well as a number of complex Windows batch scripts
  • Developed all kinds of SQL scripts and PL/SQL programs used in group’s daily work. Regularly performed Oracle database administration tasks such as database monitoring, performance analysis, optimization of complex SQL queries etc.
  • Took over responsibility for the project continuous integration. Subversion (SVN) and Trac were used for code and project management and Buildbot as automated build system. Executed every sort of code management tasks (primarily for C++, C# and SQL or PL/SQL code): branching, resolving conflicts, fixing build breaks etc.
Environment: C++, C#, PL/SQL, SQL, Oracle, MS Visual Studio 2005/2008, STL, Boost, .NET, WPF, Python, Subversion, Trac, Buildbot, Incredibuild, Toad, PL/SQL Developer, Windows XP, Windows Server 2005/2008
08/2008 – 10/2010 Freelance work in IT-Consulting area (IT-consulting and services, software development, database development)

Projects:

  • UniCredit – HypoVereinsBank, Munich [Reference (.pdf)]
    Duration: 2+ years
    Tasks:
    • Implementation of database based (Oracle) applications using C++ and C# for use in the integration environment
    • Extensive SQL and PL/SQL programming (Oracle)
    • Development of a number of Python and Perl scripts as well as wide range of Windows batch scripts for data processing, monitoring database activity or disk space etc.
    • Execution and maintenance of the automated regression tests, performance tests etc.
    Environment: C++, C#, SQL, PL/SQL, Oracle, MS Visual Studio, STL, Perl, Python, XML, Subversion, Trac
02/2005 - 06/2008 Teradyne GmbH, Munich [Reference (.pdf)]

Software Engineer

  • Member of the European Design Center, an engineering team responsible for designing new components for Teradyne's automatic test equipment. The instruments designed by EDC are used for testing electronic devices (such as semiconductors)
  • Worked on the software drivers required to support hardware components and to provide programming interface to the operator. The drivers were sets of high-level and low-level packages usually realized as COM components and deployed as DLL. They were written in C++ (VC++ 6.0) using ATL
  • Created software for driver's functional units in C++ (for example internal cache memory or hardware calibration module): developed concepts for software implementation, implemented and supported it using COM interfaces, ATL, STL
  • Developed test algorithms for the software quality control. Created and supported automated test suites to verify driver's functionality and performance and to reveal possible errors. These were programs written in VBA with automated logging facilities; a Perl wrapper was used to launch and control them
Environment: Visual Studio 6.0, VC++ 6.0, VB 6.0, COM, ATL, Perl, Rational ClearCase, Rational ClearQuest, Rational Rose, MS Excel, XML, Windows
02/2003 - 01/2005 Syntegral GmbH, Abensberg, Germany [Reference (.pdf)]

Software Developer

  • Was part of a team that worked on the Case-XP project – a large multi-featured Case Management tool based on the database server solution (Microsoft SQL Server 7.0/2000) client side of which was originally written in Visual Basic 6.0
  • Took over ongoing development of the Case-XP project, designed and programmed new modules and features using C++ and VB; developed the entire database-interaction process, client side data processing and presentation; created and improved complex GUI elements using C++ and VB
  • Designed and implemented a password encryption-decryption algorithm, completely rebuilt the application authentication process, resolved major security issues. Initiated and developed the group’s error handling strategy and standards (for C++, VB and T-SQL), designed and implemented all necessary procedures, modules and classes
  • Planned database logical design and structure: tables, relationships, constraints, indexes and other database objects. Programmed stored procedures, triggers as well as numerous SQL-scripts needed to actualize and correct database structure and data. Wrote a number of tools to perform controlling of SQL Server and database export tasks, fulfilled all sorts of MS SQL Server administrative tasks
  • Investigated and successfully solved application and database performance problems. Verified and tested the program in close collaboration with the management team and customers, localized and fixed bugs, substantially improved reliability. Wrote technical papers and product documentation
Environment: Visual Studio 6.0, VB 6.0, VC++ 6.0, Visual Source Safe 6.0, MFC, MS SQL Server 7.0/2000, Transact-SQL (T-SQL), XML, Windows
03/2002 - 01/2003 Burkart GmbH, Munich, Germany [Reference (.pdf)]
RQL Ukraine, Kiev, Ukraine

Software Developer, Project Coordinator

  • Participated in the e-GIP project (a complex web based system for innovation- and process management): development and support of Web applications using Perl, Java, Java applet programming; development and redesign of web based database administration tools (Oracle, MySQL) using Perl and JavaScript
  • Coordinated a team of software engineers working on e-GIP project; responsible for planning, coordinating and controlling development process, software testing and error fixing, communication between the customers and the developers
  • Designed and implemented an automated Update Service – a SOAP based client-server mechanism consisted of the server written in Perl and the client written in Java
  • Participated in creating a web based interactive system responsible for parsing XML files and generating custom reports based on the XML data
Environment: Java (J2 SDK 1.4), JBuilder 5, VC++ 6.0, VB 6.0, Visual Studio 6.0, Visual Source Safe 6.0, CVS, MFC, Perl 5, Javascript, SOAP, XML, XSL, Unix shell scripting, MySQL, Oracle 8, Windows
08/1995 – 03/2002 Different Jobs in the Software Development and System Administration areas in Kiev, Ukraine

After I graduated from the Kiev State University (July 1995) I worked for various companies in Kiev, Ukraine as a software developer, database developer or system administrator. The most important project experience includes:

  • Software Development using C++, C, Perl and Visual Basic
  • Database Development, creating database-based applications as well as Database Administration (Oracle, MySQL)
  • Design and implementation of GUI front-ends and dynamic web sites using Visual C++, Perl, Visual Basic, JavaScript, VBScript
  • UNIX (Solaris, FreeBSD, Linux) and Windows System Administration, 24x7 support, maintenance and troubleshooting; installation, configuration and administration of web, e-mail, DNS, FTP, firewalls and other system and network services
Environment: C++/C, VC++ 6.0, VB 6.0, Visual Studio 6.0, Perl, Javascript, PHP, HTML, Apache, Unix shell scripting, MySQL, FreeBSD, Solaris 7, Linux, Windows
 
Education
1990 - 1995 Taras Shevchenko Kiev State University, Kiev, Ukraine

Master of Science in Mathematics
Specialization: probability theory and mathematical statistics
(diploma: translation, original; transcipt: translation)
Diploma thesis
(June, 1995)
On averaging principle for Wiener heterogeneous process with membrane at point
Grade: excellent
State examination
(June, 1995)
Mathematics
Grade: excellent
 
Certification
2002 Java 1 Brainbench Certification
2000 UNIX System Administrator Brainbench Certification
(original)
1990 Successfully completed "Programming in BASIC" class with the grade Excellent
(translation, original)
 
Languages
  German - fluent
English - very good knowledge
Italian - basic level
Russian, Ukrainian - fluent
 
Personal characteristics
 

Strongly self-motivated and enthusiastic. Equally effective working individually or collaboratively in a team effort. Strong communication, intuitive, technical, analytical and problem solving skills.

Quick study with an ability to easily grasp new technologies, software and IT architecture.

I spend a great deal of time reading and improving my skills, including interpersonal skills, foreign languages and so on. I am a citizen of Ukraine, single, willing to relocate for the right job. I have a great attitude and a strong desire to succeed.


Please feel free to email me if you have any questions
MS Word Version PDF Version