Резюме MSSQL DBA, ETL, SQL Developer, BI – 2 800 $

Summary:
• 10+ years of professional expertise in the Information Technologies (IT) industry;
• 4+ years of experience in database administration;
• 6+ years of Database Development expertise;
• Wide experience in architecture and DB development (MS SQL Server).
• Experience with IT systems in the financial, medicare, trade, oil and gas spheres;
• Development & expertise highlights:
o DB architecture design;
o SQL development;
o Database performance analysis and tuning;
o ETL operations (MS Integration Services (SSIS));
o OLAP;
o Reports development (SQL Server Reporting Services (SSRS)).

Education:
• Master of Science Degree, Information Control Systems and Technologies, Sevastopol National Technical University, Ukraine.

Work Experience:
• Langae, Inc., (www.langate.com), Senior Database Developer/ Database Administrator 2016 – Present
• Acceptic Inc, Senior Database and Business Intelligence Developer 2012 – 2016
• SoftServe Inc, Database Administrator 2008 – 2012
• SoftServe Inc, Database developer 2006 – 2012

Recently Completed Projects:

Data Warehouse system for medical insurance company
Customer: Apex Inc, USA
Description: The database system provides IT services to the healthcare industry. The system has been providing services to skilled nursing facilities and rehab centers nationwide, for over a decade.
Languages: TSQL
Environments: MS SQL Server 2008, 2012, 2014, SSIS, Visual Studio 2010, 2012, 2015
Position: Senior Database and Database Administrator
Role:
• Database design, creating of stored procedures, functions, triggers, views;
• Development and supporting BI (SSIS)
• Design and supporting Data Warehouse;
• SQL code optimization
• Administration of MS SQL Server 2008\2012\2014;


Data Warehouse and Business Intelligence solutions
Customer: Drillinginfo Inc, USA
Description: The database system provides analytical information in whole world for oil and gas traders. The system enables companies to compete and thrive in a dynamic industry environment.
Languages: TSQL, C#, PowerShell
Environments: MS SQL Server 2012, SSIS, SSRS, Visual Studio 2010, 2012
Position: Senior Database and Business Intelligence Developer
Role:
• Database design, creating of stored procedures, functions, triggers, views;
• Development and supporting BI (SSIS, SSRS)
• Design and supporting Data Warehouse;
• SQL code optimization.

Data Warehouse System for Trade Company
Customer: AB InBev Brewery Company
Description: The Data Warehouse and OLAP system was developed for the largest brewery company. This system provides various analytical information and allows making better forecasts for business.
Languages: TSQL, C#, PowerShell
Environments: MS SQL Server 2005\2008, SSIS, SSRS, SSAS, Visual Studio 2008
Position: Database Administrator
Role:
• Administration of MS SQL Server 2005\2008;
• Backup and restore databases;
• Replication support;
• Database design, creating of stored procedures, functions, triggers, views;
• Development, deployment and processing OLAP cubes.

Advertising Management System
Customer: Large advertising company
Description: The developed application provides a single solution to reduce the complexity of advertising business and allow making better and faster decisions.
Languages: TSQL, Visual Basic
Environments: MS SQL Server 2000\2005
Position: Database developer
Role:
• Database design;
• Create stored procedures, functions, triggers, views;
• Create ETL project;


Programming and Markup Languages:
SQL, T-SQL, C#, HTML, CSS, VBA, JavaScript, PHP, Delphi, XML, PowerShell

Databases:
MS SQL Server 2000/2005/2008/2012/2014, Postgresql, MySql

Reporting Tools:
SQL Server Reporting Services, MS Excel

Development Environments:
MS SQL Server Management Studio, MS Visual Studio, SQL Server Business Intelligence Development Studio

Version Control Systems:
SVN, TFS

Operational Systems:
Windows XP, 7, 10, Server 2003, Server 2008

Microsoft Certificate
TS: Microsoft SQL Server 2008, Implementation and Maintenance

Languages knowledge
Russian and Ukrainian - fluent
English – Upper Intermediate