Aleksey Saychenko

senior

Регистрация: 10.03.2022

Специализация: Database development

Dtabase developer and administrator with 10+ years of practical working experience with industrial leading SQL server databases: MS SQL, SQLite, Postgres, Sybase, Oracle. Deep knowledge of SSIS, SSAS, SSRS, DTS, ETL, UML design, database planning and organizing. Professional experience in SQL programming standards (Transact SQL and PL/SQL), Java, Perl, C/C++ and UNIX shell programming languages. Key Achievements: 2019 - 2020 B2B Card and Consumer loyalty platform development. 2013 - 2015 SQL server and production platform migration (2000 to 2008). 2011 Advanced MS SQL 2000/2008 backup and restoration utility on PowerShell 2.0. 2011 Database schema generations for MS SQL on Java 1.6, Windows. 2010 - 2011 Comprehensive Financial Data Analysis for stocks and derivative products on Oracle 10g, Linux . 2005 – 2007 Database schema generations for Sybase ASE on Java 1.6, Windows.

Oracle database PostgreSQL Programming SQL Server Integration Services (SSIS) MSSQL Sybase SQLite Programming Oracle PLSQL perl C C++ Java T-SQL

Портфолио

MSSQLServerAuditor

MSSQLServerAuditor: audit about issues and problems in MSSQL.

Zabbix template for MSSQL

Collections of Zabbix templates for MSSQL monitoring.

Crypto currency statistics collections

Collect statistics about crypto currency parameters

Скиллы

C++

DTS

LaTeX

Linux RedHat

MS Project

MSSQL

Oracle

Perforce

Perl

Postgres

PowerShell

Salesforce

SourceForge

SQLite

SSAS

SSIS

SSRS

SVN

Sybase

Sybase Power Designer

Опыт работы

Database Application Development | Platform Migration

с 01.2018 - По настоящий момент |Ampol Australia

Visio, Visio, Azure Cloud Platform, MS SQL Azure, Oracle Server, Cloudera Data Hub, Linux, C#, shell

-Analysis and implementations for development (C#, SQL, PowerShell, Unix shell, python), feature upgrade and support business critical retail IT data driven systems. -Technical review, planning, development, and release business features. Migration and maintenance of the existing services to Azure cloud. -Improvement of processes efficiency by replacing and automating manual tasks using Azure Cloud platform. B2B Card and consumer loyalty platform analysis to provide recommendations for migration, upgrade, and business feature development.

SQL Server Database Administrator

05.2011 - 12.2017 |FlexiGroup (“FXL”)

MS SQL Server 2000 - 2016, PowerShell 3.0, SSIS, SSRS, SSAS

-Production and non-production database server administration (> 150 MS SQL instances). -Installation and setup new MS SQL servers, SQL cluster solutions and Data warehouse management. - Development, performance tuning, production release. SQL server migration.

Database Application Developer

11.2010 - 05.2011 |Fairfax Digital

MS SQL Server 2005/2008, SSIS

-Data distribution Framework development for apm.com.au. -Data migration for InvestSMART.com.au. -Setup replication and data distribution across multiply SQL servers. - Data analysis and reports preparation.

Technical IT Consultant

03.2010 - 10.2010 |Taysols

SSIS, MS SQL Server 2008, T-SQL, Oracle 11g, PL_SQL, OWB, ETL, T-SQL

-Oracle and MS SQL database analysis, administration and development. -SSIS and OWB ETL planning and development. - Management consulting, system implementation, business performance management (BPM) and business intelligence (BI).

Database Solution Architect

11.2007 - 01.2009 |Citibank

MS SQL Server 2000/2005 Enterprise, ETL, T-SQL, SSIS, DTS, VBA

-Database modelling, ETL planning, development, optimising and creating complex SQL reports for wealth management. - CRM system, customer behaviour and financial products statistics analysis.

Database developer, UML designer and administrator in Xavex Online project

05.2005 - 11.2007 |Deutsche Bank

Sybase ASE 12.5.x SQL server, UML PowerDesigner, perforce, Eclipse 3.x, MS Project, Perl, UNIX shell, T-SQL, Java, Sun Solaris

-Optimization stored procedures and the structure of database, support ASE Sybase servers for development trading platform for derivative products. - Financial and technical analysis the activity of transactions. Improve system performance and monitoring the trading activity.

Computer–engineer, service supporter, C++/SQL/Oracle Forms developer

10.2000 - 05.2005 |Swisslog AG

MS Visual C++, MFC, Oracle SQL server, Pl/SQL, Ms Visual Source Safe, Oracle Developer, Oracle Forms, Toad, MS Office, Ms Windows 2000, HP/UX, Tru64 Unix

-Development and inculcation of complex control systems of warehouses. -SAP R3 and third-party logistic solutions integration. -Multithread programming. - Database planning, modelling, development and administration.

Образование

Russian Academy of Science, Postgraduate

1996 - 1999

Russian Academy of Science, Postgraduate

Applied Mathematics (Магистр)

1989 - 1995

Moscow institute of physics and technology (MIPT)

Языки

АнглийскийСвободно владеюНемецкийСреднийРусскийСвободно владею