130-A Cosmonavtov st.,Phone:
38
0977667176
Nikolaev,54031, UkraineE-mail:
[email protected]
Vladlen Zenukov
SUMMARY:Over
25 years in Design,
Development, Database Administration & Support of MS SQLOver
21 years in OOPand OOD using C++, Delphi, JScript.
Over 5 years in DHTML development. Hand-on experience with MSSQL and MySQL database
design, query and database construction, performance tuning and optimization.
Strong knowledge of object oriented approach, relational database development,
client/server technology, strong experience in application design.
LANGUAGES:T-SQL, Jscript, C++, C#, Delphi, PHP,
HTML, Java.
TECHNOLOGIES:Microsoft
Windows (API, MFC), CSS, database connectivity (ODBC, JDBC), GUI (API, MFC).
OS:Windows.
DEVELOPMENT
SQL ServerManagement Studio,Profiler, Performance
Monitor, Database Tuning Advisor,MS Visual C++ with
MFC, Fast report, PHP Designer,
TOOLS:Sybase Power
Builder 7.0, Borland C++ 6, Visual FoxPro 7.0.
SOFTWARE:Microsoft
Office, Terrasoft, IT Enterprise, jQuery, CodeIgniter
DATABASES:MS SQL, MySQL, Sybase
EXPERIENCE:
Software engineer
«Sandora»
(Pepsico in Ukraine)
Nikolaev,
UkraineJanuary 2013 – May 2023
Planned, designed and
implemented application database code objects:
stored procedures, triggers, cursors, tables, views, joins and
statements for applications;
Implemented performance
tuning: suitable optimizations and appropriate indexes and keys;
Designed, developed, and
maintained Call Center Data Access Layer in JScript;
Arranged project requirements
in programming sequence;
Created analysis reports
using SQL Server and Fast Report;
Configured transactional replication
with SQL Server Management Studio as well as basic account management and
troubleshooting with connectivity and security issues;
Monitoring of database size
in Production environments.
MSSQL
JavaScript
Terrasoft
Fast
Report
ClickView
Software engineer
& web-master
Freelance & some
small firms
Apr.
2010 – Dec, 2012
HTML/PHP/CSS/JavaScript
Software engineer
«Zaria-Mashproekt»
Nikolaev,
UkraineSeptember 2009 – Mar. 2010
Developed
an application for outer cooperation;
Database development and
management.
Used Software and Technologies:
-MSSQL
-
IT Enterprise
-
C#
Software engineer
«Ukrtelecom»
Nikolaev,
UkraineSeptember 2007 – Jan. 2009
Developed
an application for personal managing – PHP, MySQL;
Administration of web and FTP
sites;
Developed
specific branches of bookkeeping system – PlSQL/Oracle.
Used Software and Technologies:
-PlSQL
-MySQL
-PHP
-HTML
-JavaScript
Software engineer
NikolaevSee Trade
Port,
June
95 – June 2007
Nikolaev,
Ukraine
Developed
an application for managing of the cargo acceptance, loading, transfer,
discharge processes. The application was based on multi-tier architecture, with
MS SQL Server, Sybase and as back-end, and web-oriented GUI application as a
front-endc (VisualFox). The applications accessed MS SQL Server, Sybase using
ODBC. Participated in client GUI application development, using C++, Sun JDK 2
with Swing. Developed an intranet WEB-site for operative interaction of port
departments and enterprise partners using PHP, DHTML.
Used Software and Technologies:
-MS SQL Server 7.0
-Sybase Power Builder 7.0
-ODBC
-PHP
-Java Script
-MS Visual C++ 6.0
-Active X
-Visual Fox 7.0
-Sun JDK 2 with Swing
Responsibilities:
analyzed
system requirements;
produced
high level and detail design specification;
implemented
application migration from local net version to intranet applications;
developed
scenarios for creating database objects and organizing their storage;
implemented
database optimization and tuning;
constructed
SQL queries for data processing;
designed
and implemented client application with Graphical User Interface (GUI);
tested
the database, web-based interface and client application;
developed
intranet web-site concept;
designed
part of intranet site pages;
.
IT Department Chief
Financial-investment
company «MDS»
Nikolaev,
UkraineJanuary 95 — April 95
Selected
department stuff. Set work standards for programmers. Developed common databases
concept. Selected technical equipment.
Responsibilities:
worked
out department development strategy;
designed
basic programming and databases creation principles;
organized
programmers interaction;
Used Software and Technologies:
-MS Fox Pro 2.6
-MS Visual C++
with MFC
-Windows NT, Windows 3.1
Software Engineer
Insurance
company «Divo»October 94 — December
94
Nikolaev,
Ukraine
Participated
in insurance system development. The application provides storing clients data
and processes standard queries. Participated in client GUI application
development.
Responsibilities:
designed
client application with Graphical User Interface (GUI);
tested
the database and the client application.
Used Software and Technologies:
MS
FoxPro
Windows
3.1
Software Engineer
State
pension fund,September
93 — October 94
Nikolaev,
Ukraine
Participated
in client GUI application development.
Developed enterprises pension deductions billing system and retirees
accounts management system using MS Foxpro as back-end and GUI application as
front-end. Developed bookkeeping subsystem for an accounting application using
Borland C++ & dbVista. Developed a document support application for project
management system.
Responsibilities:
analyzed
system requirements;
produced
high level and detailed design specification;
developed
scenarios for creating database objects and organizing their storage;
database
optimization;
designed
and implemented client application with Graphical User Interface (GUI);
tested
the database and the client application.
Used Software and Technologies:
-
MS Foxpro 2.6
-
Borland C++
-
dbVista
-
Windows 3.1
-
DOS 6.22
Software Engineer
Ukrainian-American
joint enterprise «Conto»December
92 — August 93
Nikolaev,
Ukraine
Developed
an application for managing of shipbuilding enterprise outward co-operation
using FoxBase. Participated in client GUI application development.
Responsibilities:
created
high level and detailed design specification;
designed
and implemented client application with Graphical User Interface (GUI);
tested the database and the client application.
Used Software and Technologies:
MS
FoxBase
Windows
3.1
DOS
5
Software Engineer
Fleet
instituteMarch 88 -
November 92
Klajpeda,
Lithuania
Developed
bookkeeping system for institute using Borland C++ & dbVista. Developed a
system of economic planning for branch enterprises using FoxBase. Designed
applications for technical tasks ( for example calculation of ship generators
synchronization currents, calculation of rowing mechanisms oscillations) using
Borland C++.
Responsibilities:
performed
business process analyses;
developed
front-end user interface;
tested
the database and the client application.
Used Software and Technologies:
MS
FoxBase
Borland
C++
dbVista
Windows
3.1
DOS
5
EDUCATION:
BSin Electric Equipment, Diploma
Ship
Building Institute, Nikolaev ,Ukraine1988
BSin Computer Science, Diploma
Financial
and Statistic Institute, Minsk ,Belorussia1992
To test my skills you may visit
https://drive.google.com/file/d/1g-LjR0s8nqg6sIaw07Oace6HWNhDGLnK/view?usp=sharing — T-SQLcode example, Jobs, Triggers,
Foreign Keys, Indexes
https://drive.google.com/file/d/1RpEGXO24YVm6-RDMZM8tkUK2e7LArFFL/view?usp=sharing-New person in department – my DBA skills example in video
https://docs.google.com/presentation/d/1MUgP6ZwG9ZjlPIzIV50hKgbiXwrpG_JL/edit?usp=sharing&ouid=109119953694528836940&rtpof=true&sd=true– Call Center Terrasoft in Pepsico
Ukraine (work features description) Power Point Presentation
https://docs.google.com/document/d/1UT2CGLNU4PgcaLQ7ZTTIkQtQXgXkKemb/edit?usp=sharing&ouid=109119953694528836940&rtpof=true&sd=true– Terrasoft manual (Word / my work)
https://drive.google.com/file/d/1KVvZuaE0NfsfYezMZaX9oI5kUd8SzdOm/view?usp=sharing– fast report example
https://drive.google.com/file/d/1euTarih6IPgNTM30vYAp9Cg7vR1eWS8y/view?usp=sharing
— fast report example