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 architecture team.Responsibilities:• 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.• Share database knowledge with other staff in a collaborative environment; developers, business analysts, support, quality assurance, and managersTechnologies:+ MSSQL(2008 -2016), MS Project, DACPAC+ C#+ Visual studio + TFS+ JIRA

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 of DataFlow Committee)- preparation of lectures on block of Teradata Physical Design, Oracle RDBMS and training colleagues.- interacting with analysts, project managers, architects and departments, participated in development process.- creation, controlling, optimizing and supporting of data workflows using Informatica PC (9.6.1), ESB(Apache Camel, Apache Active MQ) and internal services- coordination of development requirements and tech requirements with customers.- training, mentoring, code-review.- writing technical documentation.- performance troubleshooting (query optimization, optimization of data workloads)- comparative analysis and testing of database solutions(compared Teradata EDW, Oracle Exadata, HPE Vertica) and integration solution( Oracle Golden Gate, Informatica 9.6.1))Skills:+ solid knowledge of Teradata EDW and Oracle RDBMS architecture+ data flow, application and enterprise architecture + building highload solutions+ construction of corporate reporting+ Teradata SQL, procedures, physical design, performance troubleshooting and tuning+ Oracle SQL, PL/SQL, physical design, performance troubleshooting and tuning+ java SE, java EE, integration patterns, JMS, Spring, Maven+ data model developing( Data Vault, Dimensional, 3NF)+ monitoring the workload on the database.+ identification and optimization of highloaded SQL-queries and data workflows.+ training, mentoring, code-review.+ decomposition and assignment of task, timing control.+ writing technical documentation.+ recruiting of java and database developers

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- improving professional and personal qualities of employees- interacting with analysts, project managers, architects and departments, participated in development process.- training, mentoring, code-review.- writing technical documentation.- managing and supporting developed systemsSkills:+ developer's team management+ planning and control+ data flow and application architecture + Oracle SQL, PL/SQL, Performance Tuning+ java SE, java EE, Integration patterns, JMS, + training, mentoring, code-review.+ recruiting of java developers

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 following:- designing DWH architecture- team management - task management- development of professional and personal qualities of employees- development uniform technical documentationSkills:+developer team management+Teradata (developing, tuning, optimization)+Data Warehousing(design and creation)+ETL development and optimization+SQL, PL/SQL, Oracle Performance Tuning+Data Modeling+Informatica PowerCenter+Microstrategy BI+Recruiting of oracle and teradata developers+Training, mentoring, code-review.

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)- designing datamodel architecture(Oracle, Teradata) and prototyping(PowerDesigner)- building datamarts, procedures for filling them, SQL queries- Oracle and Teradata SQL and data model optimization, ETL and BI Performance Tuning- DWH administration(Oracle, Teradata, Informatica)- BI developing (Microstrategy)- requirements analysis- data quality issuesSkills:+Teradata (developing, tuning, optimization)+Data Warehousing(design and creation)+ETL development and optimization+SQL, PL/SQL, Oracle Performance Tuning+Data Modeling+Informatica PowerCenter+Microstrategy BI+Recruiting of oracle and teradata developers+Training, mentoring, code-review.

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 responsibilities were the following:- Workaround developing- SQL and PL/SQL optimization- bottleneck and bugs localization and fixing - system maintenance- installing the new releases- full integration circle, consists from release stabilization to installing on production stands over all Russia regions and CIS countries.- was an oracle administrator for testing standSkills:+ oracle SQL and PL/SQL developing+ oracle tuning(SQL, PL/SQL and instance optimizatioin)+ oracle adminstration+ C# developing and maintenance middleware applications+ bottleneck and bug localization

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 - unix shell scripts- requirements analysis- installing and supporting testing environment- supporting released products- data quality issuesSkills: SQL queries, unit testing, project managment, unix shell scripts, requirements analysis

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.