Developer Sql Software Server Project Data .Net

TOURISM

Microsoft Certified Professional ID# ****367

Victor Medvedev

e-mail: ***************@****.**

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

Objectoriented 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

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.

October 2003

-

Telephone company "Ural

". Ekaterinburg, Russia.

Web & Database Developer.

ASP.NET, ADO.NET, C#, XML, Transact-SQL

Improving functionality existing internet-billing application.

1) Developed technology for transfer data from Sybase Anyware Server to MS SQL Server with using DTS packages executing in scheduler.

2) Developed new database architecture for MS SQL Server with using MS Visio for Enterprise Architect according additional demands for internet-billing system.

3) Developed architecture and created tunable Web-site interface based on XML-XSD data definition schema on ASP.NET platform.

Environment and tools: MS Visual Studio.NET 2003, MS ASP.NET, C#, MS ADO.NET, MS SQL Server 2000, ODBC, MS Visual SourceSafe, MS Visio for Enterprise Architects, MS Internet Information Server, MS Windows 2000, Sybase Anyware 7.0/8.0.

ASP.NET, ADO.NET, VB.NET, XML, Transact-SQL project

Developed internal Web portal Manage telephone company services and accounting distribute phone cables connection in phone station

Business process analysis: Developed UML diagram based on modeling interaction between departments of company and interaction between company and clients.

Architecture design: developed internal Web portal architecture based on UML diagram and design database architecture.

Data access layer: developed Web-class for uniform data access with ability fire stored procedures on any database server (MS SQL Server, Oracle, Sybase). Developed stored procedure on database server. Developed module for data converting from old data source (dbf, Access, Visual FoxPro)

User interface: developed tunable Web portal interface based on XML-XSD data definition schema. Developed user interface based on Web User Controls with dynamic built in ability to portal Web page by portal administrator.

Security module: check user permissions for portal modules based on Web Form authentication for interaction ability with any clients operation system and any Web browser.

Environment and tools: MS Visual Studio.NET 2003, MS ASP.NET, MS Visual Basic.NET, MS ADO.NET, MS SQL Server 2000, ODBC, MS Visual SourceSafe, MS Visio for Enterprise Architects, MS Internet Information Server, MS Windows 2000.

July 2002

October 2003Cift

(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 2002Technosbyt 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 2002NSA

(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 users 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 companys 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 2001Sverdlovsky Gubernsky bank Ekaterinburg, Russia.

Visual Basic, ASP, XML

Software & Database & Web Developer.

Developed software application for searching information about phone numbers in a large citys phone database.

Data access realized by using server sides 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 banks 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 banks 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 banks cars trip, drivers 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 drivers 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 1999Visual 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 1999VBA, 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, employees 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 1997FoxPro,

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 1997Electric 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

Contact this candidate