Sql Server Software

Vitaliy Fursov

**** ***** ***

Mississauga, Ontario L5L 2H6

Residential: 905-***-****

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

OBJECTIVE

Talented, experienced software developer, team player, broad-minded person with good

mentoring skills looking for a position of Sr. Data Architect, Sr. Systems Architect, or

Sr. Software Developer with Technical Lead and/or Project Management roles.

COMPUTER SKILLS

OPERATING SYSTEMS:

Windows XP - 1 year; Windows 2000 - 2+ years; Windows NT (3.51, 4) - 5+ years;

Windows'95, 98 - 6+ years; Novell NetWare (3.11, 3.12, 4, 5) - 3 years; UNIX/Sun Solaris -

2 years; Linux - 2 years.

PROGRAMMING LANGUAGES:

C# - 1 year; Delphi - 6+ years; C/C++ - 5 years; Java - 3 years; Visual Basic - 5 years;

SQL - 10 years; PHP - 5 years; Perl - 2 years; Pascal - 10 years; FoxPro - 5 years;

JavaScript - 3 years; ASP - 2 years.

DATABASES:

MS-SQL 2000 - 1 year; MS-SQL 7 - 2+ years; Oracle - 2+ years; Informix 7.2 - 2 years;

Sybase - 5 years; InterBase - 2+ years; MySQL - 2 years; MS-Access - 5 years; Paradox - 5

years; SQL/DB - 2 years, ADO/OLE DB - 4 years, ODBC - 6 years.

INTERNET / INTRANET:

Member of Microsoft Web Developers Group; TCP/IP (sockets programming, internet protocols

design and implementation) - 7 years; HTML/DHTML - 5 years; XML/XSL - 3 years;

ISAPI/CGI/NSAPI - 5 years; COM/DCOM - 4 years; MIDAS - 3 years; CORBA - 2 years; SOAP - 1

year.

SOFTWARE:

VS.NET, Empower, Sybase Power Designer, ErWin, MS Office, MS Project, Visio, Lotus Notes.

EDUCATION

1992

Master's Degree in Computer Science from Ukrainian University

CERTIFICATIONS

Name

Date

Authority

Delphi 6.0

2002-08-26

Brainbench, Chantilly, VA

Delphi 5.0

2001-11-21

Brainbench, Chantilly, VA

Delphi 3.0

2001-10-13

Brainbench, Chantilly, VA

PHP4 Master

2002-01-16

Brainbench, Chantilly, VA

MS Project 2000

2001-12-25

Brainbench, Chantilly, VA

RDBMS Concepts

2001-10-09

Brainbench, Chantilly, VA

Erwin 3.5.2 Administration

2000-11-14

Brainbench, Chantilly, VA

SQL (ANSI)

2002-01-19

Brainbench, Chantilly, VA

E-Commerce Concepts

2000-09-04

Brainbench, Chantilly, VA

EMPLOYMENT

Mar'2003 ? to date

Programmer Analyst, Consultant

Ameriquest Mortgage Company, California

Playing programmer analyst role in implementing multi-tier Loan Origination System using

Borland Delphi 6, Oracle 9i, ADO, Empower v.26. Designed and implemented various solutions

for interfacing with third-party financial services.

Major Projects:

1. Loan Origination System (Delphi 6, Oracle 9i, ADO, Empower)

2. Loan Genius (Delphi 6, Oracle 9i, ADO, Empower, .NET)

3. Integration of Empower to Epiphany CRM system

Database: Oracle 8i, Oracle 9i, MS SQL Server 2000, ADO

Operating systems and software: Windows 2000, .NET

Oct'2002 ? Feb'2003

Programmer Analyst, Consultant

Manulife Financial, Ontario

Playing programmer analyst role in implementing client/server financial application using

Borland Delphi 7, IBM DB/2, ADO, MS SQL Server 2000. Designed and implemented various

solutions for Group Benefits data processing. Designed logical data model and implemented

numbers of custom forms based on business requirements document.

Major Projects:

1. ASO Billing System (Delphi 7, IBM DB/2, Vital Objects, MS SQL Server 2000, ADO)

Database: IBM DB/2, MS SQL Server 2000, ADO

Operating systems and software: Windows NT, IBM OS/390

Jan'2002Aug?2002Programmer Analyst, ConsultantIBM, Pasadena, California

Playing programmer analyst role, and participating in IBM?s client in-house software

development project. Implementing multi-tiered financial application using Borland Delphi

6, Microsoft SQL Server 2000, Microsoft Visual Studio .NET, and C#. Designed and

implemented various solutions for Loan Approval And Monitoring System. Implemented numbers

of custom forms, based on designs suggested by Business Analysts. Designed and implemented

Fields Inventory Tool, that allows client to perform inventory of usage database fields in

multiple applications and services. Designed and implemented Fields Inventory Browser, the

tool, that allowed users to browse through Fields Inventory database, as well as to run

numerous reports against this database. Designed and Implemented XML Engine, and Object

Editor, that allows user to design structure of business object, generate DTD packages,

generate and marshal XML documents based on custom definitions. Customized Empower system

adding advanced business logic in Impounds and Escrow, Funding Adjustments.

Major Projects:

1. Fields Inventory Tool (Delphi 6, SQL Server 2000, Windows NT-4, Windows 2000 Server)

2. Fields Inventory Browser (Delphi 6, SQL Server 2000, Windows NT-4, Windows 95/98,

Windows 2000)

3. Empower custom screens: Impounds and Escrow; Escrow Breakdowns, Funding Adjustments

4. MISMO XML Engine

Database: MS SQL Server 2000, ADO

Operating systems and software: Windows 9x, 4, 2000; Delphi 6, IIS, .NET

Feb'2001 - Dec'2001Technical Lead Programmer/Analyst, Manager of Software Development

Club Essential, Inc. (www.clubessential.com)

Playing team leader and manager of software development department role at the well know

software solution provider in the spa/golf clubs industry. Building corporate software

development standards. Organizing change requests processing for two versions of software

(designed for Delphi 4, Delphi 5, and Delphi 6). Designing a corporation document flow

standards for software development process. Playing active role in establishing quality

assurance department, and organizing communication channels to it from software

development and customer support departments. Establishing numerous improvements into

existing development processes. Designing a multi-tier architecture using latest

technologies from Borland, Microsoft, Sybase, and some other Delphi Groups partners.

Implementing new internet technology based on TCP/IP and Borland MIDAS. Multi-threading

processes design and implementation.

Managing various projects from estimation to detailed design, development, code review,

and quality assurance stages.

Major Projects:

1. SpaWin ver.1 for Windows (Delphi 4)

2. SpaWin ver.2 for Windows (Delphi 5, and Delphi 6)

3. Integration of SpaWin to Epani Golf System (SpaWin ver.2.3)

4. Various customization projects.

Database: Interbase 5, Interbase 6, MS SQL Server 2000, ADO.

UDM Tools: Rational Suite, Rational ClearCase, Sybase Power Designer 8.

Operating systems and software: Windows 9x, 4, 2000; Seagate Crystal Reports 7, 8.5; IIS,

ISAPI; Apache, Linux; dbExpress.

Jul'2000 - Jan'2001Data Architect, Database Architecture & Support

RBC Dominion Securities, Inc. (www.rbcds.com)

Played lead architect role at a major bank, in the reverse engineering of multiple

overlapping sources of Customer information to form an integrated business model as a base

for future CRM. Data sources included customer, sales and profitability applications

across different tiers of the bank?s market.

Developed and implemented a methodology using Sybase?s Power Designer product to abstract

a common business model based on actual data resident in the source applications.

Designed and implemented multiple customizations to an existing reporting system

(Empower).

Major Projects:

1. e-Client.

2. Empower Reports improvement and customization.

Database: Sybase Enterprise Server v.11.xx, SQL Server 2000.

UDM Tools: Sybase Power Designer 7.0, PLATINUM Erwin 3.5.2

Operating systems, software: HP Unix, Tibco TIB/Active Enterprise, Sybase Application

Server, Business Objects, Empower, Windows NT.

Jan'2000 - Jun'2000Programmer/Analyst, Sr.DeveloperInteractive Media Group (www.interactivemedia.com)

Played lead systems analyst role in the reverse engineering of multiple overlapping

sources of reference data to form an integrated business model of RDT (reference data

tables) for existent CRM. Data sources included customer, sales and product development

applications. RDT were used as a staging area for interoperating CRM applications.

Performed multi-tier database system design and implementation in Sybase (Sun Solaris)

using Borland Delphi 5 and MS-VB-6.0. Determined system requirements and specifications.

Designed and developed class library reflecting the business model. Designed and

implemented business specific internet protocols based on TCP/IP and UDP standards.

Staff training.

Major Projects:

1. RDT database system.

Software: Borland Delphi-5 (Enterprise), Sybase Enterprise Server v.11.01, ADO

CASE: PLATINUM Erwin 3.5.2

Operating systems: Sun Solaris, Windows NT, Windows'95/98, IIS, ISAPI, Business Objects,

dbExpress, Developer Express.

Jun'1999Jan'2000Data Architect/Systems Architect

Beef Improvement Ontario (www.biobeef.com)

Played lead business analyst and systems analyst roles in the reverse engineering of

multiple overlapping sources of operational data to form an integrated business model for

BIO scientific system. Performed data analysis, data warehousing, data modeling,

architectural modeling, logical design, database design, definition of system

requirements. Selected development tools, appropriate to the purpose and the budget.

Designed and implemented multi-tier database systems in MS SQL Server 7 and Borland Delphi

5 based on Microsoft ADO/OLE DB platform. Converted database from MS-SQL to Oracle.

Determined systems requirements and specifications. Designed and developed class library

for intranet database connectivity based on TCP/IP standard.

Performed staff training.

Major Projects:

1. BIO software system.

Software: Borland Delphi-5 (Enterprise), Interbase, MS SQL-7, Oracle-8, ADO

CASE: S-Designor, Erwin, ObjectStudio, Systems Architect.

Operating systems and software: Windows'95/98, Windows NT, BackOffice Server 4.5, IIS,

ISAPI, Developer ExpressMay'1998 - May'1999

Programmer/AnalystLife Path Systems, Inc.

Writing custom applications using Delphi (32 bit versions) and MS-VB-5. Programming

applications for the Internet using TCP/IP, UDP, FTP, HTTP, SHTTP and HTTPS protocols

standards. Determine system requirements and specifications. Performing Object Oriented

Design and data models based on business requirements and business model analysis.

Analyzing possibilities of integrating Life Path solution with Empower financial software.

Performing staff training.

Major Projects:

1. Life Path Financial Planning Software (Trademark "VisionWorks")

Software: Borland Delphi-3, Delphi-4 (Professional), Empower, Paradox-7, Interbase,

InstallShield-5.5-Pro

CASE: S-Designor, Erwin.

Operating systems: Windows'95/98, Windows NT

Internet: Microsoft Internet Explorer 4.0, Netscape Communicator 4.03, MS Front Page

Express, IIS, ISAPI

Jun'1997 - Jul'1998Programmer/Analyst, Systems Development and Support

KITIMAT Systems Inc. (Mississauga, Ontario)

Database systems development and support for transportation institutions, data

warehousing, data modeling, architectural modeling, and logical design.

Web-design, Internet domain administration, LAN administration. Installation and support

of MS Proxy Server 2.0.

Design and implementation of library of utilities for internet/intranet traffic tracking

based on TCP/IP and IPX/SPX traffic analysis.

Major Projects:

1. Computerised Shipping System for Angelo Brothers Company (Philadelphia, US);

2. Computerised Shipping System for AutoZone, Inc. (Memphis, US).

Software: Borland Delphi-3, Delphi-2.0 C/S, Informix, Oracle, MS-SQL, ADS, Clipper 5.2.

CASE: S-Designor, Erwin, Systems Architect.

Operating systems: Windows'NT-4.0, Windows'95, DOS-7.0, Windows 3.11

Internet: Microsoft Internet Explorer 4.0, Netscape Communicator 4.03, MS Proxy Server

2.0, Internet Information Server, DNS, WINS, TCP/IP, TCP/IP under IPX/SPX for the LAN.

Apr'1993 - Jan'1997

Technical Team Lead

DEKART Ltd. (Kharkiv, Ukraine)

Leading software development company, that performed database design for financial

institutions using MS-Excel 7.0, Visual Basic 4.0, Delphi-1.

Operating systems: DOS 7.0, Windows'95, NT, NetWare 3.11, 3.12. Software sales. Customer

support and consulting.

Major Projects:

1. Enterprise Database for Insurance Company SATURN (Kharkiv, Ukraine).

2. Enterprise Database for Kharkiv Branch of National Bank.

3. Shareable Database for Passport Check-in Systems (Customer: Kharkiv Region

Customhouse).

4. Enterprise Database for Glass Plant MITOS (Kharkiv, Ukraine).

MEMBERSHIP

1997 - PresentToronto Delphi User Group (www.tdug.com)

ACTIVITY

Oct?2001 - PresentProject Administrator

Disaster Control Management System (www.sourceforge.net/projects/disastersys)

Leading the open source software development project founded by Source Forge, the member

of OSDN community. Designed logical and physical data models. Created databases for MS SQL

Server 2000 and for MySQL.

Environment: Win32 (MS Windows)

License: GNU General Public License (GPL)

Operating System: Windows NT/2000

Programming Language: Delphi/Kylix, Object Pascal

Databases: MS SQL Server-2000; MySQL

SECURITY CLEARANCE

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate