Roman Nikolaychuk

Experienced software developer and architect with
solid background of information solutions implementation

Proven record through years of experience involved in projects requiring design and programming of multitier database-oriented information solutions for commercial and government organizations. Responsible for analysis, design, development, testing and maintenance of mission critical applications and services with strict requirements for security, reliability and scalability. Building the enterprise data warehouses with massive, wide range data integration. Implementation the enterprise-scale reporting solutions to meet effective business analysis and decision-making demands.

Professional Competences

Web Software	√ ASP.NET WebForms	√ WCF Data Services SOAP Web Services	√ ASP.NET AJAX AJAX Control Toolkit	Team Foundation Server 2010 Visual Studio 2010 ASP.NET 4.0 / 3.5 / 2.0 IIS 7 / 6
	√ PHP			EasyEclipse 1.2 Zend Framework 1.10
	√ Javascript		√ AJAX	jQuery 1.9
	√ HTML 5 XHTML	√ Microdata	√ CSS 3 / 2.1	YUI 3 CSS Framework YAML
Desktop Software	√ .NET WinForms	√ .NET PInvoke WinAPI		Team Foundation Server 2010 Visual Studio 2010 .NET 4.0
Databases	√ SQL Server	√ XML XQuery	√ SMO CLR Extensions	SQL Server 2012: Database Engine Integration Services Reporting Services
	√ PostgreSQL			PostgreSQL 8.2 pgAdmin III
	√ mySQL			mySQL 5.2 mySQL Workbench 5.2
Data Access	√ Entity Framework ADO.NET	√ LINQ XML JSON	√ Stored Procedures
Reporting	√ Data Analysis	√ Data Integration		Reporting Services .NET Report Viewer Control .NET Chart Control Excel Pivot Tables itextsharp
Application/Service Integration	√ Excel Outlook Word	√ Facebook YouTube	√ Paypal	MS Office 2008 Office PIA Google API
Programming	√ C# / VB.NET C++ VBA	√ PHP Javascript	√ Transact-SQL PL/pgSQL
Software Design	√ Design Patterns	√ OOA / OOD / OOP	√ UML	Visio 2007

Professional Experience

Software Developer	Jan 2011	2 years 5 months
ProSales Europe Media, software solutions provider Microsoft Certified Partner
Berlin, Germany

Software Developer	Oct 2009 – May 2010	7 months
Innovapps, software solutions provider Microsoft Certified Partner
Wiesbaden, Germany

Implemented online shop web interface for ALSTA Architekturefoils web site, including appropriate extensions of the re-used business logic of backend application, sophisticated XML-based communication interface between business logic layer and Flash-frontend as well as online shop checkout GUI using C#, ASP.NET 3.5, XML, DHTML, CSS, jQuery and SQL Server 2008.
Implemented dynamic data-based PDF documents generation using C# and itextsharp.
Implemented image transformations functionality using C# and imagemagick.
Enabled the next release of the backend application for ALSTA Architekturefoils web site after bug fixing and several improvements using C#, ASP.NET 3.5 and SQL Server 2008.
Implemented backend functionality for The 4-th Star for Germany web campaign of Mercedes-Benz to attract Football Fan Society for support of national team in World Cup 2010, including performance-optimized database architecture (co-author) bearing over 100,000 users, business logic using stored procedures and communication interface between business logic layer and Flash-frontend using mySQL 5 and PHP 5.
Implemented routines for XML-based fallback data source population using PHP 5.
Performed quality assurance and bug fixing for The 4-th Star for Germany web site.
Implemented communication interface between business logic layer and Flash-frontend for the web campaign of Sony Ericsson in its Expert Training Portal, based on YouTube integration, including FTP communication, using C#, ASP.NET 3.5, XML, Google API and SQL Server 2008.
Developed T-SQL scripts for database structural changes and data migration to a new version of Sony Ericsson Expert Training Platform using SQL Server 2008.
Developed both new and already existing software products, worked both in teams and independently.

Software Developer	Oct 2008 – Sep 2009	1 year
Outsourcing / Learning of German as a foreign language
Stuttgart, Germany

Software Developer / Architect	Apr 2004 – Sep 2008	4 years 5 months
Senator Company, business travel consulting services provider
Moscow, Russia

Participated in in-house software development projects, resulting in the medium-scale enterprise software package of the Customer Relationship Management Windows / Web applications with client-server architecture, as solution architect, database designer, backend- and frontend-developer using C# 2.0 and SQL Server 2005.
Architected the software solutions using object-oriented analysis and design with UML notation.
Designed databases architecture, implemented business logic using stored procedures under SQL Server 2005.
Coordinated implementation of numerous improvements of enterprise software, reflecting changing business requirements.
Developed ASP.NET Web Services using C# to provide secure and reliable access to corporate customer-related data for relative authorised external users.
Developed CLR Extensions using C# for querying web, sending e-mails, file operations and regular expressions string operations under SQL Server 2005.
Designed and implemented a number of analytical / statistical plain / cross-tab reports querying SQL Server database with stored procedures using C# desktop application, SQL Server Reporting Services Viewer Control and Excel.
Planned and implemented migration of large enterprise database from SQL Server 2005 to PostgreSQL 8.2 using SQL Server Integration Services.
Designed company policies and implemented procedures for database backup and recovery.
Worked in team of 3-4 software and database developers and supervised work of 2-3 persons in a team meetings policy regulated environment under control of eGroupWare as project management and TortoiseSVN as revision control software.

Software Developer	May 2003 – Aug 2003	part-time
Auriga, software outsourcing services global provider world's #15 in 2010
Moscow, Russia

Database Developer	Aug 2002 – Apr 2004	1 year 8 months
Rosinter Restaurants, catering trade national wide operator
Moscow, Russia

Software Developer / Architect	Feb 1995 – Jun 2002	7 years 4 months
SOFT, computer systems integrator
Ashkhabad, Turkmenistan

Developed medium-scale enterprise financial, accounting and resource management applications.
Designed, implemented and maintained asset management application with client-server architecture using Visual C++ and SQL Server 2000.
Designed, implemented and maintained bookeeping application with client-server architecture using Visual FoxPro and SQL Server 7.0.
Designed, implemented and maintained human resources management application with file-server architecture using Visual FoxPro.
Performed both conceptual data modeling and physical database design and implementation.
Implemented middle-tier using stored procedures.
Implemented entity, domain and referential data integrity with complex business rules using user-defined functions and triggers.
Performed the software coding as well as quality assurance.
Implemented a number of installations of developed software products, including sophisticated client-specific customization and after-sale support in dozens of firms and government organizations.

Education

Bachelor of Science	Mathematics
Turkmen State University, Applied Mathematics Department	1991	1995
Ashkhabad, Turkmenistan

Certification

	Microsoft Certified Solution Developer C# / .NET	2005
	Microsoft Certified Database Administrator SQL Server 2000	2004

Human Languages

German	Zertifikat Deutsch / B1
English
Russian
Ukrainian

Additional Information

Work Permit	Germany	20/11/2014
Citizenship	Russia
Birth	Ukraine	27/04/1974

Contact Information

Email	Nickolaychuk@Gmail.com
Mobile	+49 177 964 72 97
Private	+49 30 896 287 32
Residence	Leibnizstr. 72, 10625 Berlin

Links

Microsoft	MCP Profile (Transcript ID = 756419, Access Code = NikolaychukMCP)
Google	Google+