E-mail: adjwbk@r.postjobfree.com

Skype: dyatlova.ekaterina

Phone: +375-**-*******

Dyatlova Ekaterina

Over 15 years of IT experience in Data Design and Development on Microsoft SQL Server 2016/2012/2008R2/2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.

Skills

PROGRAMMING LANGUAGES

T-SQL, VB, R, Java, MDX

DBMS

MS SQL Server, MySQL, PostgreSQL, MongoDB, DynamoDB

VCS

Git, TFS, SVN

WORKFLOW

Agile, Gitflow

TOOLS

MS VisualStudio\MS SSMS, SSIS, DTS, SSAS, SSRS, SAS, R, Crystal Reports, JIRA\Axosoft, Wiki

OS

Windows

FINANCIAL

Zuora

SPOKEN LANGUAGES

Russian (Native), English (technical, intermediate)

Education

UNIVERSITY

DEGREE/SPECIALITY

GRADUATION

YEAR

BSU, Faculty of Radiophysics and Computer Technologies, Minsk

Bachelors in Electronics and Communication Engineering

2005

Professional Experience

OCT, 2011 - NOW

ENTREPRENEUR

JOB POSITION

DBA

PROJECT ROLES

Database Developer, Database Architect, Database Administrator

CUSTOMER

Gracenote, Inc.

PROJECT

The Studio System

PROJECT DESCRIPTION

Web representation of film and TV database for industry professionals. A set of subprojects includes:

1.AJAX-enabled web application with advanced and instant contextual search plus a set of personalization tools (notes, watches, custom lists, etc.) allowing to aggregate, filter and watch for film and TV industry information a user interested in.

2.Web services for iOS\iPad mobile application

3.Customized application versions with hybrid data for third-party companies for internal use (white-label).

4.Customized CMS for editing industry data (projects, people and companies).

5.Advanced User Management system including integration with Zuora and Salesforce.

PARTICIPATION

Databases architecting \developing, optimizations, data migration, db servers upgrading, deployments, documentation:

Involved in the analysis, design, development, testing, and deployment. Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well. Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL. Used indexes to enhance the performance of individual queries and enhance the Stored Procedures. Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent. Designed, developed, and tested stored procedures, views and complex queries for Reports distribution. Tuned SQL queries using execution plans for better performance. Created DTS/SSIS packages for transforming data from various data sources. Involved in the upgrading process of MS SQL Server 2008 to MS SQL Server 2012, from MS SQL Server 2012 to MS SQL Server 2019 (AWS RDS). Performed data extraction and migration activities for populating test (or non-production) and customer databases. Creation Java packages for migration data from DynamoDB ( NoSql amazon DB) to MS SQL Server.

TEAM

1 PM, 1 Team Lead, 6 Developers, 2 QA Engineers

DATABASES

MS SQL Server 2008/2012/2016/2019

TOOLS

MS Visual Studio, Git, JIRA, SSIS, DTS, SSRS, R, SAS, Java

TECHNOLOGIES

ASP.NET MVC 5 (C#\Razor), ASP.NET Web API 2, Entity Framework 6.3, TDD (NUnit, Moq), DI\IoC\AoP (Ninject, Castle.Core), Elasticsearch, ADFS 2.0\OAuth 2.0, jQuery, foundation, Zuora, log4net\Kibana, T-SQL

SEP, 2012 - AUG 2014

TUla Consulting

JOB POSITION

DBA

PROJECT ROLES

Database Developer

CUSTOMER

Internsushi/Careersushi

PROJECT

Internsushi/Careersushi

PROJECT DESCRIPTION

Career Sushi is a job-finding site for workers seeking entry and mid-level opportunities.

Intern Sushi is a website that changes the way interns land internships and companies hire interns in the hardest-to-break into industries.

PARTICIPATION

Database Development:

Configured and monitored database. Created tables, stored procedures, indexes and etc. Designed and implemented several complex reports. Appropriately tuned database applications and monitored their performance for achievement of efficient database access. Performed data backup, recovery, and transfer operations. FTS indexing to search data.

TEAM

1 PM, 1 Architect, 1 Team Lead, 3 Developers, 1 Testers

DATABASE

MS SQL Server 2008 R2

TOOLS

MS Visual Studio 2012-2013, SVN

TECHNOLOGIES AND COMPONENTS

Scrum, DDD, ASP.NET MVC,.NET, C#, Entity Framework, Spring.NET, SpecFlow, log4net, jQuery(+UI & plugins), T-SQL

DEC, 2017 - JUL 2018

TULA CONSULTING

JOB POSITION

DBA

PROJECT ROLES

Database Developer

CUSTOMER

Trendyol

PROJECT

trendyol.com

PROJECT DESCRIPTION

Turkish successful e- commerce startup.

PARTICIPATION

Database Development/SSIS packages Development:

Involved in development of new MS SQL Server database schema (tables, views, functions, procedures) and migration data from old schema to new one via complex self-developed SSIS packages.

TEAM

1 PM, 1 Architect, 4 Developers, 1 Testers

DATABASE

MS SQL Server 2016

TOOLS

MS Visual Studio 2015, Git

MAR, 2008 - OCT, 2011

NETOLOGIC

JOB POSITION

Database Developer

PROJECT ROLES

Database Developer

PROJECT

Investars Insight

PROJECT DESCRIPTION

Tool to provide investors with innovative means to measure the value of research through a robust set of research performance measurement tools.

PARTICIPATION

Database development:

Created calculators of analyst performance. Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data. Created schema objects such as tables, views, clusters, indexes, procedures, triggers. Developed scripts to migrate data from multiple sources. Worked with the other IT associates to design, implement, test, and enhance stored procedures and other applications necessary to support systems and file processing. Designed, added, eliminated, and maintained indexes, organized tables, recommended changes to application development team. Reports development for clients by Crystal reports tools.

TEAM

About 10 Developers, 4 Testers

DATABASE

MS SQL Server 2005-2008

TOOLS

MS Visual Studio 2010, MS SQL Server Management Studio, Crystal reports

TECHNOLOGIES AND COMPONENTS

T-SQL, VBA

JUN, 2005 - MAR, 2008

NETOLOGIC

JOB POSITION

Database Specialist

PROJECT ROLES

Support Team member, Database Developer

PROJECT

Investars Data

PROJECT DESCRIPTION

Data import. Research data anomaly

PARTICIPATION

Database development, data analysis:

Created schema objects such as tables, views, procedures and data upload DB scripts. Did research of data anomaly. Developed scripts to migrate data from multiple sources. Transparency reports investigation.

TEAM

3 Support Members, 4 Developers, 2 Testers

DATABASE

MS SQL Server 2005-2008

TOOLS

MS SQL Server Management Studio

TECHNOLOGIES AND COMPONENTS

T-SQL

Contact this candidate