Aleksei Svitin Email & Phone Number

Toronto, Canada Area

• I develop high-loaded OLTP application with over 70 000 installations, each installation may have up to 300 000 clients.I'm a gatekeeper for all database changes and database optimization.I also participate in an.
• Analyze existing databases, tables, indexes, stored procedures as well as data access/usage patterns and C# code in order to identify bottlenecks to scalability and responsiveness
• Propose and implement changes to remove identified bottlenecks by redesigning tables, introducing indexes, stored procedures, views, table-valued functions, etc. or moving code to a backend.
• Analyze business requirements, design and implement data model changes and data access code.
• Develop and implement scripts to migrate data from existing databases for implementation of proposed database changes
• Assist application developers with writing optimal SQL queries, stored procedures, functions, views, constraints, ETL scripts, migration scripts, etc.

Responsibilities:- building highload software and enterprise architecture- developing, managing and supporting sub-systems- development of architecture and objects of EDW with Teradata (RDBMS 14.10,15.10).- construction of corporate reporting, analysis of large volumes of data (more than 5Tb)- defining and validation enterprise dataflow architecture(head.

The main projects are - Dataflow integration- Enterprise Service Bus- Master Data Management(MDM)- Internal servicesThere are 23 employees in the subordinate, divided into 3 teams. My responsibilities:- developer's team management- planning and timing control- building software and enterprise architecture- defining enterprise dataflow architecture.

The main project was Data Warehouse(DWH). Database size is over 20 TB which stands high load analytical payload from more than 800 active users.I've became the team leader of DWH developing group(consists of 13 persons).My responsibilities and skills were the same as for "Lead specialist in Data Warehouse developing team", described below, plus the.

The main project was Data Warehouse(DWH). Database size is over 20 TB which stands high load analytical payload from more than 800 active users.My responsibilities were the following:- creating ETL processes for data flows in/out DWH(Informatica, PL/SQL, Bash, java, ODI)- developing capturing procedures in source systems for DWH(Oracle, Firebird, MS SQL).

Sitronics Telecom Solutions(was joined into NVision Group in 2012) developed OSS/BSS for MTS mobile operator. I worked in CRM support team and in integration team. DB was over 5TB(hot data) which had high transactional payload by a lot of SOA applications communicated with DB and each other 24/7. The main technologies was oracle 11g and C#(WCF). My.

The main objective was to organize development, testing, integration and support processes for producing the new releases or the new products of telecom software, what provides mobile cost redistribution between employees for European companies, European mobile operators.It is included:- project management- unit test writing and testing team managment.

Msc In Computer Science And Applied Math, Faculty Of Computer Technologies And Applied Mathematics

Awardred red diploma.

Translator In The Professional Sphere, Faculty Of Romance And Germanic Philology

Specialist, Faculty Of Computer Technologies And Applied Mathematics

Awardred red diploma.