Oleksandr

Oleksandr Viriaskin
Date of birth: 20 Feb 1977
Location: Kyiv/Lisbon
Relocation:
Phone number(s): [открыть контакты](см. выше в блоке «контактная информация»)
E-mail: [открыть контакты](см. выше в блоке «контактная информация»)

SQL/Access/VBA/VB Script Developer

Summary:
∙ More than 10 years of working experience in the MS SQL Server.
∙ My major experience is in T-SQL, VB programming languages.
∙ Team player with the ability to work productively in a team as well as individually.
∙ I have vast experience in projects in various industries (such as trade, transport, education,
manufacturing, etc.)
∙ Current employment status – employed but willing to consider contributing to interesting projects

Experience
SQL Developer
May 2019 - till present
(DWH, T-SQL, JavaScript, SSIS, SSRS, SSDT, Git, AWS, Azure DevOps)
Project: Development and support of credit unions.
Work on the development and maintenance of a database application for the prevention and analysis of
fraudulent activities. Supporting and improving the structure of credit union databases and additional tools for
them.
Development of the database architecture, creation of mechanisms for quick recording of a large number of
user actions in the database (Service Broker, partitioning, SQL stored procedures, UDF, ETL). Development of
daily reporting, notifications, urgent alerts, aggregates for uploading, aggregates for AWS QuickSight
dashboards, development of reporting using SSRS, creation of mechanisms for extracting, transforming,
loading and processing data from various sources (SSIS, t-sql, Power Shell, AWS DMS).
Created several database projects for development and rapid deployment (SSDT, Git, t-sql, Power Shell, Azure
DevOps).
Participated in a successful Data Lake implementation project in the company (AWS S3, DMS, DynamoDB,
Athena, QuickSight, RDS, EC2).
I have developed a web application with my colleagues to manage the processes of daily operations of
workers, time tracking and customer requests. (MS SQL, ASP.Net, Java Script, Azure DevOps, XAML, SSDT)

SQL Developer
Sept 2017 – May 2019
“Fozzy Group”
Project: DWH of Retail Company
Write code and queries to process raw, planning and development of calculations, development of data
aggregates, code refactoring, creating solutions for database projects, developing reports, modification and
development of cubes, preparation of data for transmission to external consumers.
(DWH, T-SQL, SSIS, SSRS, git)

SQL Developer
Jul 2015 – Aug 2017
“Rational Soft”
Project: DWH of international vehicles manufacturer
Developing reports, developing stored procedures and user-defined functions for synchronizing data among the
servers, data clearing, and data consolidating. Taking part in the database design.
 (SSIS, SSRS, T-SQL, DWH)

Head of IT Centre and technical support
Nov 2013 - Jun 2015 (1 year 8 months)
"Ukraine" University (http:/www.vmurol.com.ua/)
(over 500 employees, Education sector)
Managing the department, supporting and administrating databases of the university, initiating and taking part in new IT projects,
merging the databases of subsidiaries into one single structure

Head of information and analytical systems department
Feb 2008 - Oct 2013 (5 years 9 months)
"Ukraine" University (http://www.vmurol.com.ua)
Support and maintenance of ERP-systems of the main and branch offices of the University
• support and enhancement of databases for payroll
• implementation of a remote users access to the main database of the University
• developing a global system of management of the University

Database Administrator
Mar 2007 - Feb 2008 (1 year)
"Ukraine" University (http://www.vmurol.com.ua)
Administrating the databases of the University (MS SQL, Access)
• support and maintenance of ERP-systems in the main and branch offices of the University
• support and completion of databases for payroll
• automation of the Admissions office
• development of the complex module on: Academic orders concerning students, fee accounting, social groups perks accounting,
reporting

Head of "Accent" Software Maintenance department
May 2004 - Mar 2007 (2 years 11 months)
"Impact Center" Ltd. (http://accent.ua)
(up to 20 employees, Development of software for enterprise management)
department personnel management, maintenance and implementation of software
• taking part in solutions designing process,
• participation in training users to work with solutions of the company
• tasks assignment to the staff related to correcting errors and revisions

ERP systems programmer
Aug 2003 - Apr 2004 (9 months)
"Impact Center" Ltd. (http://accent.ua)
Programming, testing, user training, demonstration of the software

Education

'Kyiv Polytechnic Institute' National Technical University of Ukraine (Kiev)
End date 2003
Engineer, Department of Cybernetics specialist degree

Language skills

English – Upper-Intermediate
Ukrainian - Native
Russian – Native

Courses, Trainings, Certification

Microsoft Certified Professional SQL2012/2014 (2017
https://1drv.ms/b/s!Ak5lCH-Z-0cBjipkkPZPnDDWVxzQ)

NT-SPS Portal Solutions: Microsoft SharePoint 2013(Kyiv)
End date 2015
 "Сетевые технологии" (Network technologies) school
NT-SPS Portal Solutions: Microsoft SharePoint 2013
http://1drv.ms/1Ps7jHA

Additional Information

Computer Skills
• MS SQL 2000-2022;
• t-SQL, SSDT, SSRS, SSIS
• AWS (S3, Athena, RDS, EC2, DMS)
• ETL
• Azure DevOps
• VB Script, VB, VBA;
• Java Script
• MS Access;
• Microsoft SharePoint 2013
• MS Windows 3.11-Win11; Win Srv 2000-2019;
• MS Office 97-2016 (Excel, Word, PowerPoint, Outlook, Visio);
• GoogleDocs, MS Office 365;
• XAML, XML, HTML, js;
• Dynamics CRM 2011;
• Accent (ERP-software for the automation of accounting and business management);
• Accent Payroll (software to automate the payroll)

Personal Qualities
communicative, pro-active, able to learn quickly