Summary
Microsoft Certified Solution Developer and Database Administrator with more than 11 years in IT industry.
Extremely strong in Visual Basic and Delphi application development, administering MS SQL Server and T-SQL programming, ASP and Web development, administering Pervasive SQL Server, 7+ years in database design and implementation.
Solid analytical & problem solving skills, excellent interpersonal, presentation & writing skills, and strong service orientation.

Technical Skills

Languages:

Visual Basic, VBA, VB.NET	6 years
C#	1 year
Transact-SQL	6 years
XML	2 years
PL/SQL	2 years
Delphi (Pascal)	5 years
FoxPro	7 years
SQL (ANSI)	6 years

Databases:

MS SQL Server, Btrieve	5 years
Oracle, Pervasive SQL, MS Access	2 years
DBase (FoxPro, FoxBASE, Clipper)	7 years

Development tools:

ASP, ASP.NET, Crystal Report	2 years
MS Office (Word, Excel)	5 years
MS Visual Source Safe, COM/DCOM, ActiveX, ADO, ADO.NET	5 years

Case:

MS Visio	1 year
Rational Rose	1 year
Erwin ERX 3.5.2	1 year

Microsoft Certified Solution Developer,
Microsoft Certified Database Administrator,
Microsoft Certified System Engineer
Passed exams:
1. Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0
2. Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0
3. Analyzing Requirements and Defining Solution Architectures
4. Administering Microsoft SQL Server 7.0
5. Designing and Implementing Databases with Microsoft SQL Server 7.0
6. Networking Essentials
7. Internetworking with Microsoft TCP/IP on Microsoft Windows NT 4.0
8. Implementing and Supporting Microsoft Windows NT Server 4.0
9. Implementing and Supporting Microsoft Windows NT Server 4.0 in the Enterprise
10. Implementing and Supporting Microsoft Windows NT 4.0 Workstation

Relevant Skills
• SQL SERVER Database Architecture, Modeling, Design, Administration and Development.
• Program interface design
• Object–oriented programming
• COM/DCOM/MTS/ActiveX object development
• Client-Server applications development
• ODBC/ADO/OLEDB/DTS/DAO/RDO/DB-Library
• Design and administering database
 

Experience

Evening home application
Reducer
Delphi project.
This application is designed for calculate geometrical parameters and strength of bevel and cylindrical gearing as well as drawing table. Application has interface in Russian and English languages. more descriptions ...
Demo version of this application you can download from this link  <download demo version>
Environment and tools: Delphi 6.


Evening home freelance coding application
March 2004 –
Marketing Stat. Oberwil, Switzerland.
Freelance coder
VBA, Excel project
Improving functionality and developing new tools inside MS Excel
Creating Add-In components for building bubble chart for analysis market data. Improving security subsystem and user interface.
Environment and tools: MS Excel 97/2000/2002, VBA, VMware Workstation.

July 2002 – October 2003
Cift (Center of information and financial technology) Ekaterinburg, Russia.
Software & Database Developer.
Visual Basic, Transact-SQL, Excel, XML, XSLT project.
Developed software system "Analysis and design regional budget". (for Ministry of finances Sverdlovsk's region)
Data Warehouse: Analyses business requirements, developed database architecture. Developed OLAP cubes structure, developed user interface for application which convert different data format (dbf, text, Excel, Access  etc.) to universal tables structure MS SQL Server 2000 for automatic processing OLAP cubes. Developed software business logic using  XML, XSLT template and conversions for processing T-SQL query and lunch stored procedures.
Reporting subsystem: developed  user interface and business logic (Active-X DLL) for tuning and processing  MS Excel and MS Word reports which used data from MS SQL Server 2000. Report's data in MS Excel format returned by MS Query which invoked by User Control and Active-X DLL. This DLL used information from registry for interacting with any network protocols (some workstations used TCP/IP, some workstation used IPX/SPX)
Security subsystem: developed  user interface using User Controls, developed  business logic for working with database. Developed Active-X DLL which interact with MS SQL Server stored procedures, get data and return it to user interface.
Environment and tools: MS Visual Basic 6.0, MS Excel XP/2000, MS Word 2000, MS SQL Server 2000, ADO, ODBC, Visual SourceSafe, MS Query, Rational Rose RequisitePro, Rational Rose Clear Quest, Windows 2000.

Teaching students.
Read 5-days course «2073a Programming Microsoft SQL Server 2000 Database»
Read 5-days course «2074a Designing and Implementing OLAP Solutions with MS SQL Server 2000»

February 2001 – July 2002
Technosbyt inc, Ekaterinburg, Russia.
Software & Database Developer.
Delphi, Transact SQL project.
Developed software system for automatic calculated consumptions of electrical energy.
Delphi application lunch stored procedures which receive electricity counters data from different remote MS SQL Server databases and then processing and save it in large MS SQL Server database which control by this Delphi application.
Environment and tools: MS SQL Server 2000, ADO, BDE, Delphi 5.

May 2001 – January 2002
NSA (National Software Associates) Norwood, USA.

Software Developer.
Visual Basic, VBA, Excel, LDAP project
Developed software application to operate with Active Directory through LDAP.
There was developed Visual Basic COM object, which gathered user’s data from Microsoft Excel spreadsheet. Then application used Active Directory Service Interfaces with the LDAP provider for checking existent users and creating new domain account for users.
Environment and tools: Microsoft Visual Basic 6.0, MS Windows 2000 Server with Active Directory, LDAP, Microsoft Excel 2000.

SQL Database designer & Software & Database & Web Developer.
• Designing & Implementing Database on SQL Server 7.0. Designing Physical and logical model of database. Engineering, Implementing Database Integrity. Created Database and database objects, estimating the sizes of various Schema objects like Tables, Indexes, and Store Procedures etc. Modified many of the forms and SQL Server tables to confirm the changing business/application requirements of the end users.
• Performed database tuning. Formulating optimization strategies based on performance, cost and/or business rules.
• Developed inner company web site, which help employees find books that exist in company’s library. There was inserted Microsoft Agent in web pages for speaking short announce about finding books.
Environment and tools: MS SQL Server 6.x/7.0, MS SQL Server 2000, ASP/HTML/DHTML/VBScript, Microsoft Visual InterDev 6.0, Microsoft Visual Basic 6.0, Windows 2000, MS Access 2000, Internet Information Server 5.0.


January 2001 – April 2001
Sverdlovsky Gubernsky bank Ekaterinburg, Russia.
Visual Basic, ASP, XML
Software & Database & Web Developer.
Developed software application for searching information about phone numbers in a large city’s phone database.
Data access realized by using server side’s stored procedures, which return data by two ways. The first way was returned data to Active-X element that had been written on Visual Basic and built in ASP page for browse data from Internet Explorer and Netscape Navigator. The second way of getting required data was used another SQL stored procedures with XML request that returned finding data to Internet Explorer 5.0 or higher.
Environment and tools: Visual Basic 6.0, ADO, Visual Source Safe 6.0, MS SQL Server 2000, ASP, XML.

November 2000 - January 2001
Visual Basic project
Software Developer.
Developed an application tracing few banking technological processes.
The application subsequently generated textual and audible notifications for administrator. The application consisted of two Active-X and COM objects. One of the COM objects was screening a huge log text file, created by another application, and notified an operator in case of any problems. Additional COM object was checking out any unprocessed e-mail in mail “boxes”, designed for receiving mail from distanced bank’s clients.
Environment and tools: Visual Basic 6.0, Visual Source Safe 6.0.

April 2000 – November 2000
Visual Basic, Transact-SQL
Software & Database Developer/ MS SQL Database administrator.
Developed a system for accounting goods in bank’s depository.
Designed the physical and logical model of database by using Erwin ERX 3.5.2 and MS SQL Server Diagrams.
There was a three-tiers client-server application with user interface at the first tier and the business logic, implemented in the middle tier as COM components.
The middle tier includes a few objects (compiled into stand-alone DLLs). DLLs were written in Visual Basic and based on a Microsoft Transaction Server (MTS). Some of these objects make complex reports by using the Crystal Report 6.0.
The third tier contained the implemented database. The third level was realized in MS SQL Server and SQL Server stored procedures, directing data to the application.
Permanent responsibilities included:
• Managed user's level of access to various MS SQL Server resources (views, tables, stored procedures) through the MS SQL and Windows NT accounts.
• Developed stored procedures for Visual Basic programs
• Monitored performance of the MS SQL Server
• Optimized SQL queries.
Environment and tools: Visual Basic 6.0, ADO, Visual Source Safe 6.0, Crystal Report 6.0,MS SQL Server 7.0, Windows NT Server 4.0, Erwin ERX 3.5.2.

December 1999 – March 2000
Visual Basic, Transact-SQL, MS SQL, Pervasive (Btrieve)
Software & Database Developer/ MS SQL Server & Pervasive (Btrieve) Database administrator
Considerably improved performance of the large banking database and make a maintenance plan for the database.
Divided data of a one server, working simultaneously as an on-line transaction, processing server (OLTP) and as a decision support system (DSS) the analytical data base server.
Made DTS package for everyday replication and conversion data from Pervasive SQL Server 2000 with Btrieve 6.15 format to MS SQL Server 7.0.
Used ActiveX Transformation script (VB Script Language) and COM object inside (Visual Basic DLL) for transferring non-standard data type from Btrieve 6.15 to MS SQL. For the night scheduling of this task used MS SQL Server agent and Microsoft Exchange Server 5.5 for subsequent notifying administrator about results.
Permanent responsibilities included:
• Monitoring and tuning the performance of intensive non-stop online transactions of the banking database on Pervasive SQL Server 2000. The monitoring had been carried out by the MicroKernel Communication Statistics, Microkernel Resurce Usage, MicroKernel Active Users information, Pervasive SQL Configuration Utilities.
• Making maintenance plans for backup data from some different MS SQL Servers using jobs
• Notifying trough MS SQL Server agent, when anything happened through Microsoft Exchange Server 5.5.
Environment and tools: Windows NT Server 4.0, Pervasive SQL Server 2000, MicroKernel Communication Statistics, Microkernel Resurce Usage, Pervasive SQL Configuration Utilities, MS SQL Server 7.0, Data Transformation Server, Visual Basic 6.0, MS SQL Server agent, ODBC, Microsoft Exchange Server 5.5.

July 1999 – November 1999
Visual FoxPro project
Software & Database Developer.
Developed software application for calculation bank’s cars trip, driver’s hours of work and consumption of gas.
Developed a software application for the bank's cars routes calculation, driver's hours of work and gas consumption.
Visual FoxPro database consisted of some related tables keeping information about banks cars, drivers, consumption of gas for different type of cars and etc. Application calculated real and planning consumption of fuel for accounting and economic planner banks departments as well as driver’s hours of work for human department. Applications prepared and printed different type of reports and inquiries.
Environment and tools: Visual FoxPro 6.0, Windows 98.

May 1999 – July 1999
Visual Basic, Access project
Software & Database Developer.
Developed software application, which types client's information on envelopes with a different size and shape in a different kind of printers. Database connection implement in class module with using ADO and tools, which help to tuning location text on envelope implement in class module too. This application uses large Access 97 database with service information, information about bank's clients and all Russian banks, which converted from dBase and Btrieve 6.15 databases by using ODBC drivers.
Environment and tools: Visual Basic 6.0, ADO, ODBC, MS Access 97, Btrieve 6.15.

February 1999 – May 1999
VBA, Excel project
Software Developer.
Developed software application for accounting advance on salary.
Design EXCEL table and create same objects and procedures on VBA inside these EXCEL table for preparing special report for banking processing center. VBA procedures scan all employees’ numbers of banking card then calculated additional salary by using special formulas, employee’s hours of work and main employees salary. All of calculated data VBA procedures converted to ASCII text file and put it to banking card processing center.
Environment and tools: Microsoft Excel 97, Visual Basic for Application, Windows NT 4

October 1998 – January 1999
Delphi, PL/SQL, Oracle project
Software & Database Developer.
Team leader and senior developer software application, which make various reports of banking card from Oracle 7 database and design various select, view and reports on PL\SQL for analysis banking private deposit from Oracle 7.
• The first all data with private deposit information were transferred from dBase IV tables to plain text format then converted from ASCII to ISO character set and then loaded to Oracle 7 Server.
• Then were created some views and stored procedures in Oracle 7 Server and was created Delphi 3.0 application which made different reports for economic planner banks department. Using Quick Report 2.0 was created all reports. Database access was implemented through Native BDE drivers.
Environment and tools: Delphi 3.0, Quick Report 2.0, Oracle 7, PL\SQL, Windows 95.

March 1997 – November 1997
FoxPro, Btrieve project
Software & Database Developer.
Team leader and senior developer large non-stop banking system “Private deposit”, which operates with banking private deposit in network with simultaneous work several workstations.
Gathering information from other banking system, processing and sending result to main banking processing system. Print various reports (accounting report, report for client and many other), accounting time of deposit and interest accounting. Permanent daily converted information to main baking Btrieve 6.15 database.
Environment and tools: MS FoxPro 2.6, MS-DOS, Novell Netware 3.12-4.11, pcANYWHERE 8.0, Btrieve 6.15.

February 1995 - February 1997
Electric Locomotive Repair Plant (Ekaterinburg, Russia.)
FoxPro, Quattro Pro project
Software & Database Developer.
Developed system for calculated consumption materials for repair electric locomotive.
This application calculated different type of materials such as paints, tins, electric equipments and so on which needed for different type of repair, different types of locomotives and created lot of reports for all plant departments and workshops. There was lot of related tables with huge database materials, quote of consumption, type of repair and so on. Relation dBase files with Quattro Pro 4.0 electronics tables for processing information in salary and economics planning departments.
Environment and tools: FoxPro 2.0, MS-DOS, Quattro Pro 4.0.

Education
• Masters Degree, Ural State Technical University, 1988 - 1993, Automatize metallurgical machines and aggregates, Ekaterinburg, Russia
• Machine building college, 1981-1985, Operation and tooling machines with programme control, Ekaterinburg, Russia.
• Course "Introduction to Oracle: SQL and PL/SQL Using Procedure Building", Authorized Oracle Education Center, 1998.
• Course, “Securing MS Windows NT Server”, Training Center “Microtest” Authorized Technical Education Center, 2000
 

to begin of resume