PROFESSIONAL SUMMARY
Over ** years experience as a Software and Database developer for Windows
Extensive experience in software development using C#, .NET, Java, Visual
Basic.NET, C/C++ and SQL.
Expert in DB development (data modeling, ER-modeling, transforming,
normalizing etc) Proficient in coding, testing and documenting software.
Proficient in development of multi-tier database applications.
Full software development lifecycle expertise. Expert in software
deployment (InstallShield, WISE, MSI and SMS)
Expert in SQL (T-SQL, Watcom SQL, PL/SQL). Expert in reports creating
(Report Builder, Crystal Reports).
TECHNICAL SKILLS
Languages: C#, VB.Net, Java(Android Java SDK), Delphi, C/C++, Assembler
(x86), SQL (T-SQL, PL/SQL), Java Script, XML, UML
Technologies: .NET4, MVC, WCF/Web.Api/REST Web Services, OOA/OOP, SQL,
COM/DCOM/COM+, DHTML, ActiveX, HTML5, JQuery, ASP.NET, Android SDK,
Xamarin, Winforms/GUI programming, Win API, OLAP, DTS, TCP/IP.
Client/ser MS SQL Server 2012/2008/2000, Sybase SQL Anywhere, Oracle 8/9,
ver: Borland InterBase.
CASE Sybase Power Designer 8/9, ER/Studio 5.5, ERWIN 3/4, Rational Rose
tools:
CERTIFICATIONS
C# 5.0 (2015, Brainbench) Brainbench transcript id=4471578
.NET Framework 4.5 (2015, Brainbench)
JavaScript 1.8 (2015, Brainbench)
MS SQL Server 2012 Programming (2015, Brainbench)
MAJOR SKILLSETS
Databases: MS SQL Server 2012/2008/7, ORACLE 9/8.i, DB2, Sybase SQL
Anywhere 5/8.0, Interbase 5.x/6, Access 97/2000/XP, DBASE, Paradox
Database connectivity: ADO.NET, ADO, ODBC, OLE DB, DAO, RDO, JDBC, BDE
Distributed technologies: .NET, COM/DCOM, COM+, MTS, HTTP, TCP/IP sockets,
Web Services
Teamwork tools: MS Visual Source Safe, PVCS, CVS, Borland Team Source
Operating Systems: Windows 98/NT/2000/XP, Windows CE 3.0, MAC OS, Novell
Netware 5, UNIX (Linux)
Management Technologies: Install Shield 7/8, Windows Installer (MSI), Wise
4/5, Symantec PC Anywhere, VNC, SMS 1/2.0, Active Directory, Group Policy
(GPO), DBA experience (MS SQL, Sybase)
Networking: TCP/IP, SMTP/POP3, network administration (Windows NT/2000,
AD),
Report tools: Seagate Crystal Report 7/8/9, ReportBuilder 5/6, Quick
Report, MS Excel (OLE)
Other tools and technologies: SDLC, MVC, Jquery, Ajax, knockoutjs, SOAP,
IDL, MIDL, CSS, XML, IIS 7, Citrix
Industry Experience: Manufacturing, Financial consulting, Publishing,
Industrial Distribution, Home Health Care
PROFESSIONAL EXPERIENCE
Feb 2008 (contract) - September 2008 - May 2015: Senior Programmer
Isagenix Chandler, AZ
Sofisticated website similar to amazon
I developed an application for sales through the internet. Application have
several parts: web, windows and web, and app for Android cell phones, all
parts are connected to business layer through web services (WCF/Web.api
REST). For storing data MS SQL 2008 and Microsoft Commerce Server 2007 are
used. Web part use .Net 4.5, cell phone part use MVC 4 Razor. Jquery, ajax,
T4MVC, knockout, node.js also used. Windows parts use win forms and
partially translated on WPF/MVVM. Xamarin/Android SDK used. I developed all
parts of these applications.
Environment: Windows 7/8, Web (Chrome, MS IE9 and another browsers),
iPhone/Android/Tablet PC.
Tools and technologies: MS Visual Studio 2010 Ultimate, C#, .Net 4.5,
ASP.NET MVC 3/Razor, MS SQL 2008, Microsoft Commerce Server 2007, WCF,
LINQ, MVC/WPF/MVVM/Jquery/Knockout js/T4MVC etc.
August 2006 - January 2008: Programmer Analyst
Dallas County Dallas, TX
Database driven website for county & police
It's MS SQL 2000 application, connected to mainframim through Biztalk, with
web (asp.net) interface.
Environment: Windows 2003/XP, MS Visual Studio 2005, C#, .Net 2, MS SQL
2000.
Tools and technologies: MS Visual Studio .NET 2005 (C#), ASP.NET, ADO.NET,
XML, XSLT, HTML, JavaScript, Query Analyzer, UML, MS SQL 2000.
September 2004 - July 2006: Programmer Analyst
The Aircraft Group, Inc http://www.theaircraftgroup.aero/ Phoenix,
AZ
Database driven website
I do web database driven application that is and represent information over
the Internet. It consist from Web part and Windows part. Web services are
used for uploading information over the Internet. C# is used for creating
all parts of application. I developed database for this project (MS SQL,
tables, stored procedures), Web and Win applications. Project include some
features as Encrypted security system, logging, statistics. It's also was
designed and developed by me.
Environment: Windows 2003/XP, MS Visual Studio 2005, C#, .Net 2, MS SQL
2000 Enterprise.
Tools and technologies: MS Visual Studio .NET 2005 (C#), ASP.NET, ADO.NET,
XML, XSLT, HTML, JavaScript, Query Analyzer, UML, MS SQL 2000.
Wed based Scheduler of technical services and parts exchange (Web project)
I developed .Net web application. I was a senior software developer and
architect for this app and did whole software development life cycle
(SDLC): From business design to reporting. All made on C#, JavaScript(.Net
2003). Class library. MS SQL used as backend server. Password encryption.
Query optimization. Full text search. Huge database. Architecture
development, Specifications development, Database design, hands-on
development, and implementation, including Schema, Tables, Views, Stored
Procedures and Triggers and Coding.
Also I developed bunch of WinForms utilities (C#) for database
update/recalculate etc.
Environment: Windows 2000/XP, MS Visual Studio 2003, C#, .Net 1.1, MS SQL
2000 Enterprise.
Tools and technologies: MS Visual Studio .NET 2003 (C#), ASP.NET, ADO.NET,
MS DOM, SAX, XML Spy, XSLT, XPath, XFD, XFT, HTML, JavaScript, Query
Analyzer, UML, MS SQL 2000, MS Analysis Services, OLAP.
September 2003 - August 2004: Programmer Analyst
Ameriquest Mortgage Company Orange County, CA
Loan Origination Projects (Web project)
Tools and technologies: MS Visual Studio .NET 2003 (C#), ASP.NET, ADO.NET,
MS DOM, SAX, XML Spy, XSLT, XPath, XFD, XFT, HTML, JavaScript, PVCS VM and
Tracker 7.5, Query Analyzer, WinSQL, UML, MS SQL 2000, MS Analysis
Services, OLAP.
Tools and technologies: Borland Delphi 6/7, Java, JSP, Borland JBuilder X,
ASP, ADO.NET, MS Visual Studio .NET (C#), MS DOM, SAX, XML Spy, XSLT,
XPath, XFD, XFT, HTML, JavaScript, PVCS VM and Tracker 7.5, Sybase Power
Designer 9, SQL+, PL/SQL Developer, TOAD, WinSQL.
July 2003 - September 2003: Programmer Analyst
National Labor Relation Board www.nlrb.gov Washington, DC
Project Case Activity Tracking System (CATS)
Tools and technologies: MS Visual Studio .NET, ASP.NET, ASP, ADO.NET, XSLT,
Xpath, XML Spy, JavaScript, PVCS 7.5, Erwin 4, Crystal Reports 9.
January 2003 - June 2003: Sr. Software Developer
Digital Research Labs Cincinnati, Ohio
The ASP.Net application "Micmac" (Jan-June)
Tools and technologies: MS C#, MS Visual Studio .NET, XML Spy, ASP,
ADO.NET, XSLT, HTML, JavaScript.
June 2001 - December 2003 Sr. Software Developer
Euregon AG, software development company http://www.euregon.de
Augsburg, Germany
Sr. Software Developer.
Projects: Development of the application for ambulance organizations. 3-
tier application (with GUI looks like MS Outlook). Business layer supported
different databases (MS SQL, Sybase SQL Anywhere and Oracle). I developed
the database, business objects, client applications (COM+ objects,
schedulers, reports, graphics, drag and drop, messages system).
Tools and technologies: Delphi 6/7, MS SQL 2000, C#, Oracle 9 (another
version of mid-tier), COM+/MTS, ADO, C#/Visual Basic 6/.NET, Install
Shield, WISE, Dream Calendar, MS Office XP Developer, ReportBuilder, PVCS,
JBuilder, Excel VBA, Sybase PowerDesigner 8, Rational Rose where used for
development.
Administration of databases (MS SQL 2000). Managing Security (Creating
policies, user groups). Importing and exporting data (DTS), bcp. Created
tables, stored procedures, views, triggers. Managing Backups, Automating
Administrative Tasks (Job, Alerts etc). Monitoring Server Performance and
Activity, index tuning.
April 1998 - February 2002 Sr. Software Developer
TV-park publishing company Kiev, Ukraine
Projects: Development and introducing of databases for marketing,
bookkeeping and other divisions.
Environment: Delphi 4/5, MS VSS, Visual Basic 6, MS SQL Server 2000/7,
Windows NT, 9x - for clients. Sybase DataArchitect 5.5, Sybase
PowerDesigner 7, Citrix (deployment), Windows NT Server, UNIX (Linux, BSD)
- for server.
March 1997- April 1998
Programmer, system administrator
Topaz-Inform company, UOIP
Kiev, Ukraine
Projects: Development and introducing the databases (Delphi 3, Access 97).
September 1995- February 1997 Engineer
Kiev International University of Civil Aviation Kiev, Ukraine
Projects: Development applications for education and research processes.
The software environment for education. Laboratory study and research of
antinoise code, coders and decoders.
Environment: Delphi 1, Borland Pascal, Visual/ Turbo Basic, ANSI C,
Windows 95. Assembler (8086) for ATS.
EDUCATION
September 2011 Dynamic Worldwide Training www.dwwtc.com Phoenix, AZ
Developing Web Applications with Microsoft Visual Studio 2010 (Course
10264A)
January 2004 Santiago Canyon College www.sccollege.edu Orange, CA
English language training.
1991-1997 Kiev International University of Civil Aviation (KIUCA) Kiev,
Ukraine
Master of Science. Diploma with excellent marks (Computer science).
LANGUAGES
English, German
KEYWORDS
C#, JavaScript, Visual Basic.Net, JavaScript,MVC, WCF, REST, Web.api, Java,
Delphi, C/C++, Empower script, Visual FoxPro, SQL (T-SQL, PL/SQL, Watcom
SQL), VBA, HTML, Java Script, VB Script, XML, UML, OOA. OOP, OOD, COM,
DCOM, COM+, .NET, DHTML, ActiveX, HTML, ASP, ASP.NET, JSP, J2EE, WinForms,
GUI programming, Win API, c sharp, dot net, help-compiler, Client/server
technologies, MS SQL Server 2000, Oracle, Sybase SQL Anywhere, Web Forms,
Win Forms, WinForms, Borland InterBase, replication, Windows 98/NT/2000/XP,
MS Exchange Server, MS Outlook, IIS, ASP, ASP.NET, CASE tools, Sybase Power
Designer, ER/Studio, ERWIN, Rational Rose, MS SQL Server 2000/7, ORACLE
9/8.i, Sybase SQL Anywhere, Interbase, Access 97/2000/XP, DBASE, Paradox,
DBA, ADO, ADO .NET, Empower script, ODBC, OLE DB, DAO, RDO, JDBC, BDE,
Distributed technologies, COM, DCOM, COM+, MTS, ASP, XML, XSL, TCP/IP
sockets, Web Services, XML, Teamwork tools, PVCS, Visual SourceSafe, CVS,
Borland Team Source,, MAC OS, Unix (Linux), Install Shield, Windows
Installer (MSI), Wise, Symantec PC Anywhere, VNC, SMS, Active Directory,
AD, Group Policy, GPO, DBA, TCP/IP, SMTP, POP3, network, AD, Seagate
Crystal Report, ReportBuilder, Quick Report, MS Excel, OLE, Financial
consulting, Banking, Publishing, Insurance, Home Health Care
Serge Klokov
E-mail: *******@*****.***
Chandler, Arizona
My code examples: https://github.com/sergeklokov
http://examples.20m.com