PROFESSIONAL SUMMARY
Over * years experience as a Software and Database developer for Windows 7/2003/XP and Web.
Extensive experience in software development using C#, .NET, Java, Visual Basic, Borland Delphi, 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#, Java, Delphi, Visual Basic, C/C++, Empower script, Visual FoxPro, Assembler (x86), SQL (T-SQL, PL/SQL, Watcom SQL), VBA, HTML, VB/Java Script, XML, UML, Empower script
Technologies: .NET4, MVC, WPF, WCF/Web Services, OOA/OOP, SQL, COM/DCOM/COM+, DHTML, ActiveX, HTML5, Java Script, ASP.NET, JSP, J2EE, Winforms/GUI programming, Win API, OLAP, DTS, CORBA, TCP/IP, help-compiler and other
Client/server technologies:
MS SQL Server 2008/2000, Sybase SQL Anywhere, Oracle 8/9, Borland InterBase.
Worked with physically distinct databases (Sybase, MS SQL replication). Windows 98/NT/2000/XP, MS Exchange Server + MS Outlook, IIS, ASP, JSP.
CASE tools:
Sybase Power Designer 8/9, ER/Studio 5.5, ERWIN 3/4, Rational Rose
CERTIFICATIONS
C# (08/28/2006, Brainbench) Brainbench transcript id=4471578
.NET Framework (07/21/2004, Brainbench)
SQL (ANSI) (02/20/2000, Brainbench)
MAJOR SKILLSETS
Databases: MS SQL Server 2000/7, DB2, ORACLE 9/8.i, 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, SOAP, IDL, MIDL, XML/XML, MIDAS, IIS 4/5, Citrix
Industry Experience: Manufacturing, Financial consulting, Publishing, Industrial Distribution, Home Health Care
PROFESSIONAL EXPERIENCE
September 2006 – Present: Senior Programmer
Internet sales company Chandler, AZ
Website similar to amazon.com
I developed an application for sales through the internet. Application have several parts: web, windows and web for cell phones, all parts are connected to business layer through web services. For storing data MS SQL and Microsoft Commerce Server 2007 was used. Web part use .Net 4 & Winforms, cell phone part use ASP.Net MVC 3 Razor, windows parts use win forms.
I developed all parts of this application except database design.
Environment: Windows 7, Web (all browsers), iPhone/Android.
Tools and technologies: MS Visual Studio 2010, C#, .Net 3.5, ASP.NET MVC 3/Razor, MS SQL 2008, Microsoft Commerce Server 2007 .
September 2004 – 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
Project #1 Loan Origination Projects (Web project)
I developed 2-tier business application for Loan Origination. I was a senior software developer and architect for this app and did whole software development life cycle (SDLC): From business design to reporting. Input WebForms were made on C#. Class library was created for this project. MS SQL used as backend server. Empower system was used as a core. Transformation form Oracle to MS SQL Server database. OLAP cubes development. MS Analysis services, DTS packages development. Query optimization. Architecture development, Specifications development, Database design, hands-on development, and implementation, including Schema, Tables, Views, Stored Procedures and Triggers and Coding.
Environment: Windows 2000/XP, Citrix 6.0, MS SQL 2000 Enterprise, Empower v24.
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.
Project #2 Empower Loan Origination
I developed 2-tier business application. Delphi, Java (JSP), Empower script and C# with Oracle as backend server were used for development. I redeveloped the core of Empower system (Delphi, PL/SQL, DB modeling, Sybase Power Designer, stored procedures, Documents Tools), created version control system for it, applications for internet credit report distribution (Java, JSP, PL/SQL), made bunch of production enhancements (Empower script v24.xx (business rules, function items, dynaforms ) etc.
Environment: Windows 2000/XP, Citrix 6.0, Oracle 8.2, Empower v24.
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)
It is 2-tier business application with MS SQL 2000 as backend server. C# (web part) was used for development. Integration with Accelio Capture Designer forms (a lot of XML, Xpath, MS DOM) Created tables, stored procedures, views, triggers in the backend database using T-SQL. GUI, Reports (Crystal Reports, Accelio). Some utilities (C#, WinForms).
I developed installation (merge module) for my part of a project (+ third-party Accelio software) in InstallShield.
Environment: Windows 2000/XP, MS SQL Server 2000, MS Office 2000/XP, MS DOM 3.0.
Tools and technologies: MS Visual Studio .NET, ASP.NET, ASP, ADO.NET, XSLT, Xpath, XFD, XFT, HTML, Adobe Accelio Capture Designer 4, 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 application “Micmac” (Jan-June)
Application for scheduling of specific business processes. Created .NET server-side objects using C#. Created tables, queries, stored procedures in MS SQL Server backend database.
Environment: Windows 2000, IIS 5.0, ASP, .NET, MS SQL Server 2000, XML.
Tools and technologies: MS C#, MS Visual Studio .NET, XML Spy, ASP, ADO.NET, XSLT, HTML, JavaScript.
Additional responsibilities: Technical support and deployment. Managing Backups, Automating Administrative Tasks (Job, Alerts etc). Monitoring Server Performance and Activity, index tuning (MS SQL 2000). MS SMS 2.0 and AD was used for software deployment (more then 200 client computers).
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). Was developed standalone “salary engine” (bookkeeping) It was so successful, so another software company bought it. 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). InstallShield was used for creating installation packages. Web part for status checking (C#)
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.
Environment: PCs, Windows 2000/NT/Me/9x - for clients. Java 2 for processors of the mobile phones.
Windows 2000 Server, MS SQL Server 2000, Oracle 9.2 - for DB and business layer.
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.
Borland Delphi, Visual Basic, MS SQL Server and Sybase SQL Anywhere are used for development. Main application consists of 100 tables, triggers and stored procedures. There are more than 30 users with different access levels simultaneously working in database. There are two client parts (developed in Borland Delphi 4 ambience). I was a team lead for this project. “Photo base” project (Delphi, DB2) I was a coder in this project. Administering of network (Windows 2000/NT), DBA (MS SQL, SQL Anywhere), administering of MS Exchange Server 5.5 (connect between Access 2000 and MS Exchange Server). Also, for this task were designed special forms in MS Outlook 2000 on VBA. Design of database was made in the Sybase DataArchitect/PowerDesigner.
I have organized the computer courses for specialists. http://www.chat.ru/~study_kursi
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).
Designed and introduced database on organizations, people and projects, which these people and organizations took part in.
Applications “Mortgage Calculator” and “Loan” were designed for accounting department.
Created a network of circulation of documents on the base MS Outlook + Exchange Server.
Environment: Borland Delphi 3, Windows NT, 9x - for clients. Windows NT - for server. Microsoft Access 97 and VBA are used for development, InstallShield Express 3.0.
Tools and technologies: Delphi 3, MS Visual Basic 5, Access 97, Excel 97 VBA, DAO, ODBC, HTML.
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.
September 2003 ExecuTrain www.executrain.com and FNIS www.fnis.com Santa Ana, CA
Trainings of Empower programming.
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, 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