Oleg Chystyakov - OLVA Design, Inc. home page

Oleg Chystyakov
Experience Summary





Software Developer (Architect / Programmer / Analyst ) with a huge practical experience in IT including
over 16 years of using object-oriented programming languages; Master’s Degree in MIS; US citizen;
Over 16 year experience in Internet projects design, development and deployment ( Web Applications,
Windows Applications and real time console applications running in the background );
Strong skills in .NET (including over 10 years practical experience in C# programming languages,
using .NET Framework, ASP.NET and MVC(Razor); over 16 years practical experience in HTML, CSS,
JavaScript, jQuery, ExtJS, Ajax;
Strong SQL skills using relational databases particularly MS SQL Server and Oracle
Self-motivated, well organized and disciplined to achieve the highest level of success on client projects;
have the ability to rapidly learn and apply new tools and technologies in accordance with Agile Software
Development methodology
Professional Experience
Ohio Department of Transportation (Columbus, OH)
Independent Consultant as a Software Developer & Tech Lead
12/2013 – 02/2014
Project: Tag Revenue Apportionment ( Web Application)
Responsibilities
 Performing analysis and designing the system requirements, business rules definitions, database objects,
software architecture and graphical user interface mockups
 Developing and testing source code; creating an application patterns and prototypes, creating the project
documentation, participating in code reviews; Performing the software versions deployment and on-the-fly fixing;
Environment:
.NET Framework 4, XML, C#, ASP.NET, ADO.NET,
HTML, CSS, JavaScript, Ajax, ExtJS 4.0, jQuery, MS Visual Studio 2012, MS TFS,
MS SQL Server 2012, ORACLE 11
Ohio Department of Development (Columbus, OH)
System Analyst /Architect / Software Development Specialist
10/2005 – 10/2013
Project: Ohio Community and Energy Assistance Network (OCEAN)
OCEAN is a Web Application, containing a number of projects including HEAP, PIPP, EPP, HWAP, etc.
The Home Energy Assistance Program (HEAP) is designed to help eligible low-income Ohioans meet the high costs
of home heating. Home Weatherization Assistance Program (HWAP) is a no-cost energy assistance program
designed to increase the energy efficiency of dwellings owned or occupied by income-eligible Ohioans, reduce
participants’ household energy expenditures, and improve participants’ health and safety. Percentage of Income
Payment Plan Plus (PIPP Plus) is an extended payment arrangement that requires regulated gas and electric
companies to accept payments based on a percentage of the household income. All the code is being written in C#
and running under ASP.NET management on a servers farm.
2
Responsibilities
 Performing analysis and designing the system requirements, business rules definitions, database objects,
software architecture and graphical user interface mockups
 Developing and testing source code; creating an application patterns and prototypes, creating the project
documentation, participating in code reviews; Performing the software versions deployment and on-the-fly fixing;
Performing the ongoing maintenance (including UAT and live production versions support)
 Performing server-side programming using ASP.NET technology with C# as a code-behind language and
ADO.NET classes with SQL; developing the ETL tools aimed to perform data import and export (from /to
the external IT systems )
 Performing client-side programming using HTML, CSS, JavaScript, Ajax, jQuery, Telerik, Silverlight
Environment:
.NET Framework 4, XML, C#, ASP.NET, ADO.NET, MVC 4.0, LINQ, HTML, CSS, JavaScript,
Ajax, jQuery, Telerik, Silverlight 4.0, MS Visual Studio 2010, MS TFS, SQL Server 2008 R2,
SQL Server 2012, SQL, SSIS, SSRS, SSMS
Ernst & Young, LLP (Cleveland, OH)
Senior Consultant (contractor ) / Programmer
02/2005 – 09/2005
Project: Global Audit Methodology system (GAMx)
The system implemented as a Virtual Office for over 60,000 auditors all around the world. It is based on the
Groove’s safe data share technology. It’s a kind of highly secure corporate Intranet. The project architecture is
composed of two major tiers – Presentation Tier and Data Tier. The Presentation Tier is implemented as an embedded
rich client application using .NET Win Forms (View & Controller linked pairs). The Data Tier is an XML-based
encrypted safe data-store system (GAL).
Responsibilities
 Creating business objects, business rules and their relations (Data/Business Tiers) based upon ‘Use Case’ specifications
 Developing and testing embedded (through GDK API) .NET Win Forms (Presentation Tier) according to the
‘Use Case’ and ‘Screen Description Document’
 Implementing and testing source code, updating Use Cases, SSD and Test Cases documentation, participated in
code reviews and QA builds.
Environment:
.NET Framework, XML, C#, WCF, WCF, ADO.NET, SQL, Groove Virtual Office GDK,
Visual Studio 2003, MS Enterprise Library 2005, MS SQL Server 2000,
MS Source Safe 6.0, Windows XP, MS Virtual PC
Sallie Mae Corporation (Indianapolis, IN)
Senior Consultant (contractor ) / Programmer
06/2004 –01/2005
Project: USA Funds Debt Manager (DM) and Result Based Prevention (RBP)
The project architecture is composed of three major tiers – Presentation Tier, Server Tier and Data Tier.
DM and RBP have separate code in Presentation Tier: DM is a web application using .NET Web Forms, RBP is a rich
client/server application using .NET Win Forms. Both of these projects use the same common domain (business objects,
stored procedures and database structure). All code is being written in C#.
Responsibilities
 Designing and implementing dynamic rich-client screen forms (UI) communicating with the Server tier using .NET
Remoting classes and multi-threading techniques.
Oleg. Chystyakov
2
3




Constructing business entities (heavily dependent on ADO.NET DataSets), business types, business interfaces (using
Reflection techniques) and business activity rules for domain part of the project.
Developing and testing source code; creating an application patterns and prototypes, maintaining Use Cases and Test Cases
documentation, participating in code reviews
Developing and testing SQL stored procedures for Data services and Service Factory supporting data tier
Developing classes for automatic overnight batch process executing activity and correspondence rules to create voice
messages (Auto Dialer via FTP), e-mail messages and letters sending to the borrowers
Environment:
.NET Framework, ADO.NET, SQL, XML, C#, ASP.NET, JavaScript,
Visual Studio 2003, SQL Server 2000, Windows 2000, Novell NetWare
Ohio Department of Job and Family Services (Columbus, OH)
Consultant (contractor) / Programmer / System Analyst
08/1999 –05/2004
Project: Intermediate Care Facilities for the Mentally Retarded (ICF-MR) Individual Assessment Forms (IAF)








Performing analysis and designing the system requirements, graphical user interface and database structures.
Performing data analysis and business rules definitions.
Developing and testing source code; creating an application prototypes and production versions.
Performing server-side programming using ASP.NET technology with C# as a code-behind language and ADO.NET
classes for dynamic Web pages and XML Web Services using SOAP for data exchange.
Developed 3-tier ADO.NET data access using SQL stored procedures and software components written in C#
and used Web Services to access a dedicated databases. The Web Services use stored procedures to retrieve
data and send it to a rich client that uses all the visual features of a Windows interface.
Installing and administrating MS Windows 2003 Enterprise Edition and IIS 6.0 with UDDI service in order to
develop Service Oriented Architecture (SOA) including internal and external XML Web Services usage.
Designing and implementing automatic data transfer module using TCP/IP and FTP, automatic massaging
subsystem based on SMTP usage.
Performing client-side programming using HTML, CSS and JavaScript.
Environment:
- Version 3 (2003): C#, ASP.NET, ADO.NET, SQL, MS Visual Studio.NET 2003,
HTML, JavaScript, CSS, XML, Crystal Reports, Crystal Enterprise, MS SQL Server 2000, Oracle
8i, Microsoft Windows 2003 Enterprise Edition, .NET Framework
- Version 2 (2002): C#, ADO.NET, SQL, MS Visual Studio .NET, XML, Crystal Reports,
MS SQL Server 2000, MS Windows XP Professional, .NET Framework.
- Version 1 (2001): Object Pascal (Delphi 6), embedded DBMS, Oracle 8i, PL/SQL, Quick Reports,
MS Windows NT 4.0, Novell NetWare
Project: Claims Imaging Storage System (CISS).
This system reads scanned Medicaid claims as a binary images and stores them in Oracle database as BLOB for the consequent
search of the particular set of claims in database by numerous keys for the viewing and printing by request. (Multi-user database
application built on Client/Server technology. Database size is about 1.2Tbytes).
 Designing and implementing an automatic images recognition and transfer module using ActiveX (ImageXpress package)
and Delphi 7 graphical components.
 Designing and implementing automated file downloading / uploading subsystem using FTP and TCP/IP.
 Designing and implementing an intellectual search by criteria module using dynamic SQL procedures for images retrieving
by demand.
 Performed the scripting needed for data to be integrated for the new system
Environment: Object Pascal (Delphi 7), Oracle 8i (PL/SQL), Crystal Reports
Oleg. Chystyakov
3
4
Project: Drug Utilization Review (DUR) System
This provides an automated mechanism for generating and tracking letters to be sent to pharmacies regarding a recipients usage
of drugs. (Multi-user database application built on Client/Server technology)
 Designing system requirements, user interface and database structure.
 Performing data analysis
 Developing and testing source code.
 Creating online help files and teaching end-users.
 Implementing the automatic real-time statistical and analytical graphical charts.
 Designing and implementing automatic messaging subsystem using HTML, FTP and SMTP.
 Designing and implementing DataCheck application that runs in the background on a server transparent to users and
performs data check, and transfer involving IBM DB2 mainframe database and Oracle DBMS on Windows 2000 Server
using SQL.
Environment: Object Pascal (Delphi 6), Oracle 8i (PL/SQL), Crystal Reports
Amerisoft, Inc. (Cleveland, OH)
10/1998 – 07/1999
Programmer/Analyst
Responsibilities
 Development and maintenance of the integrated software complex for a bookstore computerized control system
including inventory, sales, provider contacts etc.
 Developed and maintained company’s website using HTML, JavaScript, CSS and ASP.
 Installed and administrated MS Windows NT Server 4.0 and Oracle 8 for NT.
Environment: Borland C++ Client/Server, Visual FoxPro 5; Windows 95/98/NT, Oracle 8 DBMS
National Institute of Justice (US DOJ)
(Washington, DC)
07/1997 - 09/1998
Software Programmer & Webmaster/ Technical Director of the Internet Studio
Technical Lead of the Internet Studio
Responsibilities
 Development, deployment and maintenance of several Web sites for Rule of Law Online Internet Studio of the
National Institute of Justice (US DOJ).
 Development, deployment and maintenance of several Web sites for UNOJUST (the United Nations Online Crime
and Justice Clearinghouse) installed in US, European and African branches.
 Installed and administrated MS Windows NT Server 4.0 and Oracle 8 for NT.
Environment: HTML, CSS, ColdFusion 3.0 (CFML), JavaScript, ASP, Visual Basic; Windows NT 4; MS Access
Black Sea Shipping Company “BLASCO” (Odessa, Ukraine)
10/1987 - 06/1997
IT Department Manager / Senior Software Programmer-Architect
Responsibilities
 Development of comprehensive proprietary corporate application system for 100,000-employees shipping company
 Developed requirements, integrated data from old systems to new systems.
 Designed the systems in line with the business strategy.
 Set technological vision and implemented technological infrastructure
 Developed code, tested and implemented applications; performed extensive data analysis
 Personnel administration, analysis and forecasting of labor resources and wages accounting
 Management of material and technical supply, repair of fleet, ports and company buildings
 Management applications for book keeping, accounting of the incomes and charges in a real time mode that supported
the consolidated balance of 300 vessels and thousands of containers in operative tracking and movement control
Environment: Borland C/C++, Clipper, PL/1, Assembler; IBM OS/370, MS-DOS, Windows 95/NT, NetWare; DBMS:
ADABAS, MS Access, Sybase, Oracle 7.3; IBM 4381 mainframe, PDP-11M minicomputer, PC-based LANs
Oleg. Chystyakov
4
5
Kiev Central IT Design Bureau (Odessa, USSR)
10/1985 - 09/1987
Senior software engineer / Project Manager
Responsibilities
 Development, testing and deployment of the integrated real time signals processing software for the fueling control
system of the Russian space shuttle BURAN
 Development of complementary tools modeling programs that emulate fuel system's behavior and generates signals
in order to test and fully debug built-in software; cross-compiler allowing programmers to use C and Assembler to
develop modeling and main programs on different hardware, to produce the final binary code
Environment: Assembler, ANSI C; Intel 8086 based PC and PDP-11 minicomputer
Odessa Sea Port Computer Center (Odessa, USSR)
09/1977 - 09/1985
Software Engineer / Senior Software Engineer
Responsibilities
 Design, development and support for the real-time computerized system
 Computer creation of cargo documents set and transferring them over telecommunications media to destination
ports and clients
 Multi-user distributed access to database (in real time round the clock)
Environment: FORTRAN, Assembler, ANSI C; OS: RSX-11M; DBMS: ADABAS-M, Minicomputer PDP-11M
Oleg. Chystyakov
5