Experience

Fish trader webshop
The commercial website based on ASP.NET 4 (web forms) and MS SQL 2008 technologies. This is a web solution for UK fish trader that allows retail customers to buy a fish online with delivery.


Role: Developer, DB and application designer.
Technologies: ASP.NET 4, C#, MS SQL 2008, .Net Local Reporting Services, MS Ajax, Css, Xhtml, Jquery, integration with Paypal (own shopping cart).
Project development: April 2011 (1st phase completed) 

Client: UK company

Online marketing professionals community
The project was developed for Australian customers. The main idea of website itself is to offer full-range of services for marketing professionals: different reports (markets research, statistical data, etc.), training (online and offline), events announcing, blogging, forum, jobs posting and search, forum, members database. The commercial side of project is: membership registration, reports purchase and registration to events and training.

Website is the ASP.NET 4 (web forms) based application with MS SQL 2008 DB as data storage and Linq-to-Sql data tier. Project itself is a sort of own developed CMS system that meets client requirements where for every front-end page the display, navigation, content can be managed. Application offers wide range of email alerts, notifications, and subscription services. The website functionality can be divided into 3 parts: 


1. CMS (admin backend). Content management, events/training/reports/services/blog/pages, navigation, pages display settings (graphic and video banners, RHS content, etc), members’ database – to maintain all membership accounts and their users, financial/statistical reports. Security settings based on roles and permissions for every specific side of a website. For wysiwyg editor CKEditor was considered for which a set of plugins were developed additionaly.

2. Client back-end. Account information, email settings, subscriptions, members information, job postings, activity reports (orders, payments).

3. Fron-end. Events/Training announcements, services for marketers, free and paid reports, blog, forum, members database, forum, searching facilities.


Role: Software developer.
Responsibilities: DB and website architecture design, development, testing – i.e. full project development cycle.
Technologies: .Net Framework 4.0, ASP.NET 4, MS SQL SERVER 2008, C#, ADO.NET, Linq-to-Sql, Linq-to-Xml, XHTML, CSS, Jquery, Integration with Paypal and Eway payment systems.
Project development: Sep 2010 – till now 

Client: Company from Australia


CheckMyClient
Commercial web project (based on ASP.NET 4, C#, MS SQL 2008) that offers information about customers’ business partners. The information includes and not limited to: credit story, financial details and results, subsidiaries, CEO, have strong analytical services that results in suggestions in dealing with those customers.

Hightlighs: Sagepay integrations with proceeding orders on website using SSL security connection.
Role: Developer, DB and application designer.
Technologies: ASP.NET 4, C#, MS SQL 2008, .Net Local Reporting Services, MS Ajax, Css, Xhtml, Jquery, integration with Paypal and Sagepay (own shopping cart).
Project development: September-November 2010 

Client: UK company


Ascentric
Web, own cms based project for company specializing in investments. In general own cms was designed and developed to meet all customer requirements.

Role: Software developer 
Responsibility: Database design, coding, new features implementations, communication with customer.
Technologies: MS Visual Studio 2008, MS SQL Server 2005, .NET Framework 3.5, C#, ADO.NET
Environment: MS Visual Studio 2008, MS SQL Server 2005 Enterprise Management Studio
Project development: Septmeber 2010 – December 2010. 

Client: UK company


A set of projects and tasks for car leasing company in UK
CRM projects to maintain, store information about existing custemrs, customers database management, communication with customers, reports and documents flow.

1. CRM project – ASP.NET 2, .Net Framework 3.5, C#, MS SQL 2005 – application to view/edit/maintain clients database/orders made/quotes.
2. CRM reports – project to generate and build all possible reports using MS SQL 2008 Reporting Services and Local Reporting functionality (PDF, Excel). Mainly project is integrated with MS Dynamics CRM.
3. Range of winforns and console appications to manage information about vehicles including import/export.
4. www.carnoisseurleasing.com – front-end project to show available vehicles for leasing information, quotes/prices, vehicles in stock,branches information and other important information for customers.

Responsibility: Development, new features implementations.
Technologies: MS Visual Studio 2008-2010, MS SQL Server 2005, 2008, .NET Framework 3.5 - 4, C#, ADO.NET, Linq-To-Sql
Environment: MS Visual Studio 2008-2010, MS SQL Server 2005-2008 Enterprise Management Studio
Participated in project: Septmeber 2009 – till now.
Client: UK company


HR ERP/CRM system
Windows forms/Web based enterprise resource planning tool for HR department that automates employees’ career appraisal processes: meetings scheduling, tracking the documentation, maintaining and analysis of interview results, personal achievements, salary and personal planning. I had joined this project on Phase 4. The key objectives of this phase were reviewing, refactoring and code optimization, application performance improvements, new features implementation and bug fixing.

Windows forms application was designed for backend users – administrators, top-management, HRs. Web application was a front-end part for end users – company employees.

Role: Tech Lead
Responsibility: Database design, coding, new features implementations, communication with customer.
Technologies: MS Visual Studio 2008, MS SQL Server 2005, .NET Framework 3.5, C#, ADO.NET
Environment: MS Visual Studio 2008, MS SQL Server 2005 Enterprise Management Studio, Visual Source Save
Participated in project: Nov 2009 – Jun 2010.
Client: Ukrainian IT company


Profitability and cost management software and services
These are a commercial web based Silverlight/WPF projects to manage company’s profits and cost flows basing on a financial model that offers many analyzing tools, reports. For server part an ASP.NET web application was used and on client side a SilverLight 4. 
All communications with data storage and web application were developed based on ADO.NET Entity Framework functionality. WCF RIA services were considered as middle tier to connect SilverLight client side and web part.
The other important aspects of projects are close integration with MS SQL 2008 Reporting and Analysis Services.
SCRUM methodology was followed for this project.

Role: Tech Lead
Responsibilities: participated in development of server (ASP.NET web) and client (Silverlight) sides applications accordingly to SCRUM stories and items, participated in bug fixing, SCRUM meetings conducting, team management, was responsible for communications between team and customer and QA team (that is located in Mexico). I was involved into coding of T-SQL stored procedures, database design, queries development, reports design for MS SQL 2008 Reporting services, Cube development for MS SQL 2008 Analysis services. During iteration overview meetings was making a presentations of completed scrum stories.
Technologies:, MS .Net Framework 4.0, C# 4, ASP.NET, Silver Light 4, WPF 4, Silver Light Toolkit, ADO.NET Entity Framework, WCF RIA services, WCF service, MS SQL 2008, MS SQL 2008 Reporting and Analysis Services.
Environment: MS Visual Studio 2010, MS SQL 2008 Enterprise Manager, Team Foundation Server, MS Expression Blend 4
Participated in project: Dec 2009 – Nov 2010
Client: USA Company


Email Campaigns and Subscriptions Service
Commercial web project to create/store/modify and send emails to a managed list of subscribers. Application offers excellent services to hold and maintain subscribers database by various criterias. Software allows customers to create different email campaigns including email, fax and sms facilities. 
The other important side is comprehensive reports to monitor emails views, clicks, sharing to social networks, displays and clicks from Facebook/Twitter, data overlays to maps, visualization of email links clicks, integration with google maps.

Other parts of project are 2 windows services that send emails and analyze of non-delivered emails. Very important points of application - is a high workload on DB since it operates with huge subscriber’s database (millions of records). To achieve best results in performance different best practice were used, vertical/horizontal partitioning, indexes/queries optimization, full-text indexes, indexed views, latest MS SQL 2008 Server features. To provide the latest statistics 3 windows services were developed to collect statistical information offline and provide it with the first user requests in milliseconds delays.
The commercial components is connected with different user accounts and payment per different services.

Role: DB and software architect, DB/software Engineer.
Responsibilities: Request analysis, development, db design and optimization. Agile development methodology was used there.
Technologies: MS Visual Studio 2008-2010, MS SQL 2005-2008, MS .Net Framework 3.5-4.0, C# 3.5-4.0, ADO.NET, LINQ to SQL, ASP.NET Ajax, CSS, XHTML, Jquery, Paypal integration, FAX and SMS services integration.
Project development: May 2009 – till now
Client: UK company

E-monitoring labs
Complex web solution (that is currently under development) – to monitor/collect network resources work status / availability and accessibility statistics. Possible tests to be performed are: HTTP/ HTTPS/SMTP/ESMPT/POP3/IMAP – connection availability, Web content, tracing routes, TCP/UDP ports connection availability.

Project consists of 3 parts:

- Web application (ASP.NET 4.0 – web forms) – to display monitored resources statistics, create and manage/tests, sending alerts (email, sms).
- Web services that are running on different hosts over the world to perform tests.
- Windows service – that is executing tests accordingly to specified parameters, notifies users about failed tests or tests that restored work after several unsuccessfull attempts.

Role: DB and software architect, DB/software Engineer.

Responsibilities: Request analysis, development, db design and optimization. Agile development methodology was used there.
Technologies: MS Visual Studio 2008-2010, MS SQL 2005-2008, MS .Net Framework 3.5-4.0, C# 3.5-4.0, ADO.NET, LINQ to SQL, ASP.NET Ajax, CSS, XHTML, Jquery, Paypal integration, FAX and SMS services integration.
Project development: November 2009 – till now (currently project is holded)
Client: UK company

Car Leasing Services
This project is for vehicles leasing company. Project includes three front-end public websites for clients where different data is represented and three back-end projects (one of them is a CRM system) that are used by managers, accountants, brokers and administrators to keep and maintain information about proposed services, customers, etc. Each project has role divided security policy: administrator, supervisors and managers. Generally depending from assigned role users can create/view/modify proposed vehicles, their options, configurations, discounts and promotions. Managers are also allowed to access and modify financial settings of different contract types, vehicle manufactures and so on. Administrators can manage list of users, financial settings. Supervisors are able only to view all user submitted data, track changes. One of those back-end projects is windows forms application.

Role: Software Engineer, DB architect
Responsibilities: Design and development of 2 back-end projects from scratch, coding, testing, debugging and maintenance. Implementing business logic based on Stored Procedures. Existing projects support. In this project participated as team member. Scrum methodology was followed for this project.
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.5, VB.NET, ADO.NET, ASP.NET Ajax, JQuery, CSS, HTML.
Client: Company in UK



BrokerMate
Internal project for car leasing company in UK. Project purpose is to form up the prices for car leasing deals depending on manufacturers, clients, promotions, company brances.

Role: Software developer
Responsibility: Database design, coding, new features implementations, communication with customer.
Technologies: MS Visual Studio 2008, MS SQL Server 2005, .NET Framework 3.5, C#, ADO.NET
Environment: MS Visual Studio 2008, MS SQL Server 2005 Enterprise Management Studio
Participated in project: Septmeber 2009 – November 2009.
Client: UK company


Catalyst2 
This is hosting company website. Website support, new features implementation, bug fixing.

Technologies: Classic ASP, Jquery/Mootools javascript frameworks, Css, Xhtml
Participated in project: from time to time 2009-2011
Client: UK company


Food and Grocery Web Shop
Commercial web project based on ASP.NET 2.0 is web shop where any user from UK can buy delicious food, drinks and groceries. Web project has 2 user security role types: customer and administrator. Customer is any client that has made an order. Customer can manage his delivery addresses, view/edit personal information, view previous orders. Administrator is responsible for managing products, discounting coupons and also able to create/modify customers list and their personal data, create/modify product categories/subcategories, view different reports, releasing news. As payment system – “WorldPay” was used.

Role: TL, DB architect
Responsibilities: Distributed team (of 4 developers) coordination: involving new programmers to project development, job distribution, consulting with customer. Implemented website functionality from html template. Database design, stored procedures coding. I was also involved into testing, debugging, maintenance and system support. Scrum methodology was followed for this project development.
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.5, ADO.NET, LINQ to SQL, ASP.NET Ajax, CSS, HTML, Sybase Power Designer, TinyMCE. Integration with WorldPay UK payment system.
Client: UK Company
Project development: May 2009 – July 2009



Mallorca Estate Properties
Commercial web project used by estate agents to promote properties for sale or rent. Every visitor of website can search desired property there by various criteria: by one or more locations, distances in km, price and etc. There are 3 security user roles: administrators, estate agents and private sellers. Administrator can manage users and submitted properties, setup service using fee, create/view/modify dictionaries, view different reports. Estate agents and private sellers can submit their properties to website (by paying different prices for company or estate properties promotion). “Paypal” was considered as payment module there.

Role: Software Engineer, DB architect
Responsibilities: Database design, planning, writing all business logic in T/SQL stored procedures and functions, coding, defects tracking and test results analyzing, development and execution of test cases. Participated in development as a team member. Team consisted of 4 developers. I was responsible for business logic development on application side and based on db side as well. RUP methodology was followed for this project development.
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.5, ASP.NET Ajax, CSS, HTML.
Project development: March 2009 – May 2009, supporting and maintenance till now
Client: Dutch-Spain Company

Voice File Management and Audit
Service that is used by call-centre of cellular service operators to manage voice recorded messages between customers and operators and to audit their work.
Solution is represented by several applications to store, manage and processing data and files (voice recorded messages). Complexity of this solution is in high system requirements to developed software, DB and file system. Over 20 thousand messages are recorded and processed daily. Average message size over 1 Mb.
Follow-up optimization of DB was performed when messages count reached 20 millions records. Files and data processing is performed by windows service.

Web interface consists of 3 applications:
- Voice Server Config – Service tuning and administrating to access voice servers.
- Voice File Management – access to new and archived voice messages, their processing (estimating, control, short audit) by auditors and super visors.
- Audit – follow-up more detailed audit to monitor call-center operator’s work based on estimated messages, customer complaints, remarks and etc. Scheduling planed events – such as meetings, operator’s trainings.

Role: TL, DB Architect, Software Engineer
Responsibilities: Coordination of development team of 3 people: distributing tasks, gathering and analyzing customer’s requirements and feedback, testing. Scrum development methodology was followed there. Every week we had a general meeting to discuss current tasks with customer and hear his feedback. Beside team leader responsibilities my duties were: database design, planning, writing all business logic in T/SQL stored procedures and functions, coding, defects tracking and test results analyzing, development and execution of test cases. I was also responsible for testing, db queries optimization, client support, writing technical documentations and functional specifications. Test Plan creation; preparing test scenarios; testing according test scenarios/design specification; tailoring the feature/change requests procedure in order to meet the customer need and expectations; registering defects in defect tracking system with the further validation.
Technologies: MS Visual Studio 2005, MS SQL 2000, MS .Net Framework 2.0, C# 2.0, ASP.NET Ajax, CSS, HTML.
Participating in project: 2007-2009
Client: Czech Company


Voice Mail
Real-time service based on Oracle db and developed under MS .NET Framework 2.0 to run in MS Windows environment to support voice messages recording, sending, storing and maintenance. The other parts of project are 2 web sites used to configure service working environment by administrator. Project development was lasting for 2 years.

Role: TL, Software Engineer
Responsibilities: On the first iteration phase I was as a team leader of 5 developers. My duties were but not limited to: communication with customer, approaching of new developers to project, discussing with them new features and requirements, distributing work tasks among team members, writing technical specifications. Project development was following RUP methodology. Participated in development of real-time service using databases Oracle 10g and MSSQL 2000 RDBMS (my duties was to develop and support stored procedures and etc for service). Participated in development process of web applications. Test plan creation; preparing test scenarios and test cases; testing according test scenarios/design specification; registering defects in defect tracking system with the further validation; technical documentation writing.
Technologies: MS Visual Studio 2005, MS SQL 2000, Oracle 10g. MS .Net Framework 2.0, C# 2.0, ASP.NET Ajax, CSS, HTML.
Participating in project: 2007-2009
Client: Czech Company


PRBT (Personal Ringing Back Tone)
System to change and customize standard ringing back tones to different melodies or voice records. Our part of project consisted of 2 parts. Web applications for system operators to administrate and configure service, web application for cellular network users that allows them to setup their ringing back tones by uploading their own records, customize accordingly to some schedule, phone numbers or events, see billing reports. The third web application is for media content providers – which allowed them to upload media files, categorize content, setup pricing, see detailed financial reports and statistics.

Next part is real-time service based on stored procedures. Real-time service was used to determine customer from outgoing call phone number, and retrieve a personalized ringing back tone. The other purpose of real service was to handle billing events, gathering statistics.
Web applications were built on ASP.NET 1.1 platform, C# 1.0. As database storage Oracle 9g version was used. Real time service logic was developed using PL/SQL statements and stored procedures.

Role: TL, Software Engineer
Responsibilities: During all development process I was in role of team lead and coordinated a team of 4 developers (including me). My duties were communications with customer and project manager, tasks estimation, participation in system and DB architecture design, coding (C# and PL/SQL as well). Also I was responsible for task distribution to team members, writing technical and functional specifications. Had a business trip to customer (to Czech republic) were I had presentation of project and discussion of all feedbacks.
Project participation: 2006-2008
Technologies: MS Visual Studio 2003, Oracle 9g. MS .Net Framework 1.1, C# 1.0, ASP.NET, CSS, HTML.
Participating in project: 2007-2009
Client: SITRONICS Telecom Solutions Czech Republic


Telemarketing
Real-time service for mobile telephony network providers in Czech Republic and Germany to perform surveys and quizes over phone.
Project consists with 3 parts:
web part – called configurator, to manage surveys, answers, reports, voice files;
service part – with logic based on db stored procedures
real-time service – running on telephony hardware to perform calls.
Participated in developlemt of web-part and db as well.

Technologies: MS Visual Studio 2003, Oracle 10g. MS .Net Framework 1.1, C# 1.0, ASP.NET, CSS, HTML.
Participating in project: 2007-2009
Client: SITRONICS Telecom Solutions Czech Republic


Freephone
Call distribution service for call centers. Call distribution configuration by various parememers: average load, according to callers location, zone, day/time, etc.
Project consists with 3 parts:
web part – called configurator, to manage call distribution settings, reports management;
service part – with logic based on db stored procedures
real-time service – running on telephony hardware to perform call distribution.
Participated in developlemt of web-part and db as well.
Project participation: 2006-2008
Technologies: MS Visual Studio 2003, Oracle 10g. MS .Net Framework 1.1, C# 1.0, ASP.NET, CSS, HTML.
Client: SITRONICS Telecom Solutions Czech Republic

Search engines statistics collector
Windows service and line of web services to gather search statistics from www.yandex.ru / www.rabler.ru / www.google.com. System consists of 3 levels:
1) Local web service that is deployed on server and is responsible to send requests using different proxies. By the way each request was sent from different IP (selected from list). For every sent request IP address of network adapter was changing to avoid ip blocking by search engines.
2) Windows service – that sends requests to a list of registered web services, collects, analyses and stores to DB retrieved statistics.
3) Web application – to configure web and windows services. To configurewindows service Named pipes API was used.

Used technologies: C#, MS SQL 2005, multithreading, MS Named pipes, Network API.
Participating in project: February-June 2009
Client: Russia, Moscow


Megapol.ru
Web project for estate agency in Moscow and Moscow region
This is quite complex web project that was developed using ASP.NET 2.0 and C# 2.0 and MS SQL Server 2000 as database storage. Project was developed from scratch, own CMS was developed. The main feature of project is a dynamic database structure of different estate properties. So the database and application allow user to create his own type of objects (flats, apartments, villas, houses, plots, buildings, etc.) with generic properties of predefined type (int, string, decimal, images, lists) with inheritance and override support. So there can be some base (parent objects) and their children.

The next important thing that was developed are reports templates based on excel files.
Logicaly web application separated into 3 levels:
1. Public website, with information available for all visitors
2. Website for estate agents – with additional commercial information available.
3. Local website (running on local computers with separate IIS and DB) for workers that collect/edit/post information.

The own replication mechanism was developed with duplex replication of db from estate agents’ website and local web applications.

Used technologies: ASP.NET 2.0, C# 2.0, MS SQL Server 2000, Multithreading techniques, Javascript, Google Maps API.
Participating in project: September 2008 - May 2009
Client: Russia, Moscow



Small web projects

E-transfer Labs
Website to share and transfer big files.
Technologies: MS Visual Studio 2010, MS SQL 2008, MS .Net Framework 4.0, C# 4.0, ASP.NET, Ajax, CSS, HTML.
Project development: 2011
Client: UK company


Webseif.ru
Website to share and transfer big files for Russian customer.
Technologies: MS Visual Studio 2005, MS SQL 2000, MS .Net Framework 2.0, C# 2.0, ASP.NET, Ajax, CSS, HTML.
Project development: 2009
Client: Russian company


Frowens, estate agency
Website redesign, conversion to ASP.NET 4
Participated in project: 2011
Technologies: MS Visual Studio 2010, MS SQL 2008, MS .Net Framework 4.0, C# 4.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

GYYPO
Online web vynil plates selling store.
Participated in full project development.
Project development: 2009, 2010, 2011
Technologies: MS Visual Studio 2010, MS SQL 2008, MS .Net Framework 4.0, C# 4.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

Car service direct
Is the ASP.NET website that allows car services to store information about them, provided services. For motorists to find a garage, car service by different criteria including distance search.
Project development: 2009
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

Hands and Foot Spa
Online website about spa, massage and other cosmetics procedures.
Participated in project redesign, integration of BlogEngine.Net
Participated in project: 2010
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

MyDnsHosting
A small web application to maintain DNS settings including exporting/importing of DNS zone files.
Participated in project: 2010
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company
Web: internal web project

CheckMyDns.Biz
A website to get information about any DNS, DNS records, etc.
Project development: 2009-2010
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

Dray consultancy
Online consulting and service regarding clouds computing.
Project development: 2009
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

Hunt4Flooring
Estate agency contact page
Project development: 2009
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

UK Recipes
Website to post recipes, recipe reviews, information about ingridients, techniques, blog
Project development: 2009
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

URL snip
Short urls online web service
Project development: 2009
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: UK company

RDISS tracking system
Non-public website for US army in Iraq to store information about spy cams. A short description can be found here: http://rdiss.com/
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0, ASP.NET, Ajax, CSS, HTML.
Client: US customer

Email verification windows service
Windows service to validate the lists of email addresses (in csv format) against email syntax, MX records, email address present.
Technologies: MS Visual Studio 2008, MS SQL 2005, MS .Net Framework 3.5, C# 3.0.
Client: US customer