BI DWH specialist

Data scientist.

name: Jurij Usenko

Prague, Czech Republic

Teradata certify master, Brainbench MS BI tools certification.

Summary :

No EU visa or EU work permit sponsorship required.

Over 20 years of IT experience

Primary skill : BI SME, BI technical lead, ETL Technical Lead.

Senior business intelligence developer, Senior DWH developer.

Industries : Financial, Telecommunication, Automotive, Airline

Oraganization skill : Software lead, Technical lead, Team leader

Primary DWH platform : Teradata, MS SQL Server

Primary BI platform : SSIS, SSRS, Qlick View, MS Excell, SAP BO

Hands on programmer experience for the various databases. (procedures, triggers, ...)

Specific DB system skills and knowledge: British Telecom DWH, Global Airline tickets reservation system, DB2, Call Center system (Nortel).

PROFESSIONAL EXPERIENCE:

Lufthansa

www.lufthansa.com/ (fully remote ) 03/01/2022 – 02/01/2023

Position: Operational DBA

Project: Lufthansa managed service.

Tools: TASM. Teradata tools and Viewpoint.

Manage data migration process.

Monitoring of the ETL processing on the daily base.

System workload analysis.

Create and maintain related documentations.

Allianz

www.allianz.cz/ (Prague, Czech Republic) (part-time, fully remote, fix price) 09/15/2021 – NOW

Position: BI analyst - Oracle 19, MS Reporting Services 2019

Project: Oracle DWH support. Reporting support and development.

Reporting system migration from SAS reporting environment to the MS Reporting services.

Create project related documentation. (business analysis, architecture, technical specification)

Tools: MS Reporting Builder 2019, MS Visual Studio, PL/SQL Developer, MS SQL Server management studio.

WIZ-TEAM SA

www.wiz-team.com (Kyiv , Ukraine) (fully remote, fix price) 05/15/2021 – 08/31/2021

Position: System architect, business analyst

Project: Visitor system DWH.

Create project related documentation. (business analysis, architecture, technical specification)

Technology : MySQL, ORACLE.

Tools: SQL Developer, Toad. 

VTB Group.

www.vtb.ru (Moscow, Russia) (fully remote) 01/02/2021 – 02/01/2022

Position: System analyst.

Project: Data processes daily monitoring. DWH, ETL optimization.

Tools: TASM. Teradata tools and Viewpoint.

Monitoring of the ETL processing on the daily base.

System workload analysis.

Create and maintain related documentations.

TELE2 (Teradata).

www.tele2.ru (Moscow, Russia) (fully remote) 10/01/2020 – 12/18/2020

Position:.Technical lead of the Systems Analysis Group.

Project: Data processes daily monitoring. DWH, ETL optimization.

Tools: Azure DEVOPS. Teradata tools and Viewpoint.

Monitoring of the ETL processing on the daily base.

System workload analysis.

Create and maintain related documentations.

TELE2 (Teradata).

www.tele2.ru (Moscow, Russia) (fully remote) 07/15/2020 – 09/30/2020

Position: Business analyst.

Project: New extensions for the existed DWH. Data quality solution.

Tools: Azure DEVOPS. Teradata tools and Viewpoint.

Collect business requirements.

System workload analysis.

Create and maintain related documentations.

NPOWER . 0,5FTE

www.npower.com (Swindon, United Kingdom) 07/01/2020 – 08/31/2020

Position: Teradata SME.(fully remote)

Project: Teradata DWH support. (Teradata 15.10)

Tools: JIRA, BTEQ, SQL Assistant, Viewpoint.

DWH and BI solution support, daily data flow tasks monitoring.

DBA daily tasks.

ETL tasks optimization.

Create and maintain related documentations.

Unicredit Bank (Teradata).

www.unicredit.ro (Bucharest, Romania) 06/01/2020 – 07/01/2020

Position: BI technical lead.

Project: Pre upgrade assessment Teradata DWH support. (Teradata 15.10 to 16.20)

Post upgrade optimization. (Teradata 15.10 to 16.20)

Position: Data analyst. Teradata SME.

Tools: BTEQ, SQL Assistant, Viewpoint.

DWH and BI solution post upgrade support, daily data flow tasks monitoring.

ETL tasks optimization.

Create and maintain related documentations.

Vodafone (IBM).

www.vodafone.cz (Prague)

Position: DWH technical lead.Data processing analyst. 01/01/2020 – 03/31/2020

Project: Teradata DWH support. (Teradata 16.20)

Create new BI extension for the current solution. New data flow analysis and development.

Data modelling

Contract position: Teradata SME. Data analyst. Teradata 16.20 SME.

Tools: Teardata PT. Informatica 10.2, BTEQ, SQL Assistant.

Data modeling – SAP Power designer 16,5

DWH and BI solution support using daily data flow tasks monitoring.

ETL development and data flow tasks optimization.

Create and maintain related analytical documentations.

Sberbank EU.

www.sberbank.at (Austria) 09/30/2019-12/31/2019

Project: New DWH extension. Short term contract.

Contract position: BI Team Leader. (small team 5-10 members) (on/off site)

Tools: MS BI tools(SSIS, SSRS).

Improve existed development process.
Create and mountain new development standards.
Improve project delivery quality.

KBC Group (CSOB SK).

www.csob.sk (Bratislava, Slovakia) 06/10/2019 – 09/30/2019

Project: New DWH extension. New data flow analysis.

Contract position: DWH architect. Business analyst, Teradata SME.

Tools: JIRA, Informatica, BTEQ, SQL Assistant. Data modeling – SAP Power designer 16,5

Bank Of Ireland (NCL).

www.ncl.com (Dublin, Ireland) 10/15/2018 – 04/12/2019

Project: Teradata EDW support.(Managed service Teradata 15.10).

Contract position: Optimization team leader (on/off site)

Teradata SME. DWH optimization tech lead. Teradata 15.10, Informatica 9,5.

Tools: JIRA, Teradata Studio 15, BTEQ, TPT, SQL Assistant.

Societe Generale Bank (NESS).

www.ness.com (Prague , Czech Republic) 7/1/2017 – 10/15/2018

Project: Data migration from Oracle, DB2 to Teradata 15.10.Operation support production environment(Teradata 15.10).

Contract position: DWH optimization technical lead. Teradata 15.10, Informatica 9,5.

Tools: JIRA, Fastload, BTEQ, TPT, SQL Assistant. Teradata Manta standardization tool.

Data modeling - Power designer 16,5

Societe Generale Bank (NESS).

www.ness.com (Prague , Czech Republic) 2/1/2017 – 7/1/2017

Project: Data migration from Oracle to Teradata 15.10.

Part time Role: ETL optimization technical lead. Teradata 15.10, Informatica 9,5.

Data modeling.

Tools: JIRA, BTEQ, TPT, SQL Assistant. Teradata Manta standardization tool, Power designer 16,5.

Teradata(Prague , Czech Republic) 2/1/ 2012 – 11/1/2017

www.teradata.com/

Role: EMEA area manager. (manage customer support in 10 countries, international team > 25 people)

Follow SLA and KPI for each team.

Create and mountain communication model for the international team.

DWH support, optimization. (BTEQ, TPT, MLOAD, TD SQL Assistant)

Internal data integration projects support. (Maintain and development, MS SQL Server 2008, 2012, SSIS, SSRS)

Telefonica O2. (Czech Republic GSM provider)

www.o2.cz(Prague , Czech Republic) 9/1/2015 – 1/1/2016

Accomplished Project:

E-SAM (licenses software registration system)

Create new application and DB extensions.

Create new reporting environment.

SAP and AD data integration and analysis.

Role: External consultant. BI solution architect.(MS Access 2010 VBA, MS SQL Server 2012)

Ilaid Ltd. (Prestigio, Asus service center, GSM phones and tablets PC repair) 5/10/2014 – 2/1/2015

Accomplished Project:

Create new application and DB extensions.

Create new reporting environment.

Role: BI solution architect.External consultant. DB developer, VBA programmer (MS Access 2010 VBA, MySQL)

Fortum Generation AB. (Energy company)

www.fortum.com 9/1/2013 – 1/1/2014

Accomplished Project:

Mapping existed QlickView BI solution to the new DWH project.

Create new reporting extensions.

Data migration processing.

Role: External consultant.(QlickVIew, Oracle 11, DB2)

Teradata 10/6/2008 – 3/1/2012

www.teradata.com/

GCC Prague, Czech Republic.

Global Delivery Control Consultant (III). Senior Professional Service Consultant.

Senior DWH Developer. Business Intelligence Consultant, ETL Lead.

Accomplished projects:

1) Kyivstar (Ukrainian GSM provider) ADS Project. Churn analysis. Data migration Oracle to Teradata. 08/01/2009 – 10/1/2009

Role: DWH Analyst. BI analyst. Analyze Business Requirements, Data Source analyses.

Tools: BTEQ, TPT, MLOAD etc.

2) Uralsvjazinform (Russian GSM provider) Churn analysis project. Data migration Oracle to Teradata. 10/2/2009 – 1/1/2010

Role: Analyst. Analyze Business Requirements, Data Source, DWH, ETL lead.

(BTEQ, TPT, MLOAD etc)

3) Megafone (Russian GSM provider) Churn analysis. Data migration DB2, Sybase, Oracle to Teradata. 10/2/2009 – 1/1/2010

Role: Analyst. Analyze Business Requirements, Data Source. DB, DWH, ETL Developer. BI analyst.

(BTEQ, TPT, MLOAD etc)

4) VTB24 (Russia. Bank) DWH migration from Microsoft SQL Server and Oracle to Teradata. 2/2/2010 – 7/1/2010

Role: Analyze Data Source (MS SQL Server 2008, Oracle, DB@, flat files). Senior DB, DWH, ETL Developer. BI Analyst. (BTEQ, TPT, MLOAD)

5) Sberbank Russia (Russian Bank. The largest bank in Europe) . 8/20/2010 – 7/20/2011

Projects: Analysis of the corporate loan portfolio. Data migration Oracle to Teradata. (Informatica, Teardata)

Role: Program QA Lead.

6) Unicredit Bank (Rome Italia). Data migration Oracle to Teradata. 8/1/2011 – 10/20/2011

Project: Data Warehouse optimization. (BTEQ, TPT, MLOAD, TD SQL Assistant)

7) CSOB (Prague Czech Republic) 10/21/2011 – 12/01/2011

Project: Data Warehouse optimization. (BTEQ, TPT, MLOAD, TD SQL Assistant)

8) A1 Telecom (Vienna Austria) . Data migration Oracle to Teradata. 1/21/2011 – 3/1/2011

Project: Data Warehouse optimization. (BTEQ, TPT, MLOAD, TD SQL Assistant)

Team Trackers (Air France Group) 1/1/2007 – 10/5/2008

www.team-trackers.com/

Prague, Czech Republic. Senior DWH, BI Developer. C# Programmer

(MS SQL Server 2005, 2008, SSRS, SSIS, SSAS, MS Foundation team server, MS BI)

Accomplished projects:

Create and maintain DWH and reporting environment,

Data integration project,(ORACLE, CSV files, Sybase)

Data migration.(DB2, Oracle, Sybase, MS SQL Server)

Hudson Global Resources 7/1/2005 – 1/2/2007

www.hhgroup.com

www.hudson.com

Prague, Czech Republic. Programmer.

Back – end programmer for web-application (C#, SQL Server 2000, 2005),

C# developer for MS SharePoint Portal Server and MS SharePoint Service,

Administrator MS SharePoint Service.

AAA Auto a.s 5/2/2004 – 6/30/2005

www.aaaauto.cz

www.europeanautosales.nl

Prague, Czech Republic. Programmer. DWH developer.BI developer.

Support, Developing applications, Databases using VB 6.0, ASP, ASP .NET, VB.NET, MS SQL server 2000.

ETL processes from other DB system (Oracle, Sybase) using DTS.

Developing Analytics Report with MS OLAP Server and MS Excel 2000/XP, Crystal Report 8.5.

Deploy application with MS Share Point Portal Server (2003) for intranet.

BSP Group (Microsoft Certify Partner)

www.bsp.cz 2/1/2002- 5/1/2004

Prague, Czech Republic

Programmer, System Developer

SYSCOM ltd 7/21/1998 - 12/23/2001

Kiev, Ukraine

Lead Programmer

Accomplished projects:

Writing project-related utilities Using VC++ 6.0,VB 6.0.

Developing and maintain database using MS SQL Server 7.0.

Newspaper “Interest” IT department. 2/1/1997 - 7/1/1998

Kiev, Ukraine

Lead Programmer/ Project Leader

Accomplished projects:

Developing and maintaining Web pages and WEB related applications

<o:p></o:p></span>

Eltoks Ltd. 8/1/1996 - 2/1/1997

Zsitomir, Ukraine

Programmer / Analyst

Testing, quality assurance, fixing, troubleshooting, documenting

ModernTech Co. 2/1/1994 to 8/1/1996 Zsitomir, Ukraine Programmer / Analyst (Windows)

Developing and maintaining database.

EDUCATION:

Kiev IT University, computer science bachelor degree(2001)

BRAINBENCH CERTIFICATION:

26-Jun-2013: MS SQL Server 2012 Programming (expert level).

12-Aug-2015: MS SQL Server 2014 Programming (advance level).

06-Aug-2016: MS SQL Server 2014 Reporting Services

TERADATA CERTIFICATION:

January 2009: Teradata Master Certified.

LANGUAGES:

Fluent Russian, Fluent Czech, English