Vlad Gonchar Email & Phone Number

Toronto, Canada Area

I have been developing software for tax assessor/collector/auditor offices of half California counties. I used extensively and in depth WinForms with DevExpress components and SQL server. I created about a hundred applications (out of 600 in the system) for serving the offices activities. Some of the applications have very complex algorithms and data structure, to name just few: • Personal and business property information collecting and maintenance. It uses multidimensional cube data structure and has very sophisticated processing to facilitate complex UI. It works fast with huge amount of data - about 100GB, collected during 35 years. • Assessments splitting and merging. It employs complex data tree traversing algorithms. It has very complex UI handling.• Projecting price of personal properties. It calculates a property price basing on features of comparable properties. This application is very large and complex. It has huge number of files/objects, in few places - subtle multithreaded UI processing. • Data communicating transport. This project stays apart in terms of technologies used. I wrote it in VS20012 for 4.5 dotnet framework. It consists of few WCF services running as Windows services on remote computers. The services use TCP/IP and allow a program, for example, to issue an SQL command, send it over Internet to remote router that eventually routs the command to a host service that has local access to a SQL Server database, get result data (result set) and send it back in the same way to the program to handle and/or display this data on the screen.In few projects I used multithreading and other advanced technologies. A programmer, in order to create a good program, has to know the business his program will work with. So I worked with end user as an analyst figuring out their requirements and coordinated work of few other people to make sure practical output of the projects. Tools used: C#, SQL Server, WCF, WinForms, multithreading.

Toronto

I actively participated in developing 8 major releases of BIRT Performance Analytics - a world-class, leading software solution for Performance Management and Balanced Scorecard Applications. Main focus was on back end and server side of the application.• Got advanced experience in C#, .NET Framework 3.5, ADO.NET, SQL, XML, .NET Remoting… • Worked on data access layer using ADO.NET low-level interfaces to interact with SQL Server and Oracle; participated in relational database design; did complex SQL coding. • Developed UI for configuring data access and managing databases within the application; used Winforms with Infragistics and other third party components.• Worked with Microsoft Enterprise Library 5 (logging and unity Application Blocks)• Worked on resolving complex customer support issues.• On rotating basis with all other developers was fully responsible for doing and maintaining nightly, weekly and release builds of the application; did “smoke” tests of the builds; in this context closely worked with MSBuild, CruiseControl.NET and WISE installer. • Used MS Visual Studio 10, JIRA issue tracking system and Perforce revision control system• Did requirements analysis, research, prototyping and technical design; was involved in full SDLC (Software Development Life Cycle)• Worked in fast paced Agile environment (SCRUM) • Aside, participated in development of Enterprise Resource Planning system (ERP) for large bakery factory in Toronto; used Delphi, then C#, WPF and WCF.• Recently discovered new passion - development for mobile devices (Motorola, running Windows Mobile 6.1 with .Net Compact Framework 2.0, used wireless connection to SQL Server). The software allows to do wireless real-time inventory in warehouses.• Created video about Actuate Scorecard development team: http://youtu.be/VzE_mqmJHjg

As a member of the back-end development team, actively participated in developing 6 major releases of the company’s main application – pbviews, which is a performance measurement tool used by over 500companies around the world. I worked collaboratively with other members of the team developing first Delphi and then C# .Net based releases of the application during many years.• Did significant contribution making the application able working with SQL Server and Oracle databases; implemented entire layer of data access to new databases using ADO technology. • Participated in development of an asynchronous multithreaded XML reader and writer classes for handling really large XML documents. Years later the same technology has appeared in .Net (XmlReader/XmlWriter classes).• Participated in re-writing back end code in C#.NET and using ADO.NET.• Got working knowledge of TCP/IP network and sockets programming• Had a profound involvement in developing an object-oriented environment and interpreter to execute various tasks specified in batch files or XML scripts apart from the main application.

Participated in the development of one of the major software projects used by the City of Mississauga formanaging GO Transit.• Designed a wide variety of complicated reports using Quick Report classes in Delphi 5.• Created numbers of stored procedures and sophisticated optimized SQL queries to access data and perform various tasks in Oracle and MS SQL Server database systems.• Developed a real-time system for data collecting from remote terminals; used asynchronous TCP/IP sockets; coded in C, created Windows services, used ADO to store the data in MS SQL database.• Participated in the design and implementation a data warehouse using Microsoft SQL Server 7.