Data engineer

Data scientist.

name: Jurij Usenko

Prague, Czech Republic

Teradata certify master, Brainbench MS BI tools certification.

Summary :

EU citizenship

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 : Project manager, 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:

BANK Misr.

www.banquemisr.com// (New Cairo, Cairo, Egypt on-site hybrid) 09/01/2024 – 11/30/2024

Position: Test Engineer, Team lead. Teradata SME.

Project: Project: Central DWH data migration.

Tools: Teradata TTU, SQL Assistant, Informatica(DEI 10.5.4), CLOUDERA.

Analysis, creating and maintain test case scenarios. Test cases automation.

Collaboration with business analytics team.
Creating and maintain all necessary documentation.

Data mapping, data source analysis, test case analysis and reporting.

Swedbank

www.swedbank.com/ (fully remote) 02/01/2024 – 05/01/2024

Position: System Analyst. BI Developer / Analyst (Teradata 17.20).

Project: SPSS(IBM) data processing. ETL and data mining optimization. SPSS reengineering.

Tools: Teradata SQL Assistant, IBM SPSS Modeler.

Database and ETL optimization.

Monitoring of the ETL processing on the daily base.

System workload analysis.

Create and maintain related documentations.

Unicorn

www.unicorn.cz/ (fully remote, part time ) 03/01/2023 – 12/31/2023

Position: System Analyst. SQL Developer (ORACLE 19, MS SQL Server 2019)

Project: Campaign Management System.

Tools: Oracle Developer, MS SSIS, MS Management Studio.

Database and ETL optimization.

Monitoring of the ETL processing on the daily base.

System workload analysis.

Create and maintain related documentations.

Crédit Agricole (France) (fully remote)

Position: ETL developer 03/01/2023 – 10/15/2023

Technologies used: Abinitio,ExpressIT.

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 – 03/01/2023

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) 07/15/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.

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) 2/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

Teradata 10/6/2008 – 11/1/2017

www.teradata.com/

GCC Prague, Czech Republic.

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

Senior DWH Developer. Business Intelligence Consultant.

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