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, DB 2, 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 ) 0 3/ 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/ на Jobs.ua/ 15/ 2023
Technologies used: Abinitio,ExpressIT.
Lufthansa
www.lufthansa.com/ (fully remote ) 0 3/ 01/ на Jobs.ua/ 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 – 0 3/ 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) 0 5/ 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/ на Jobs.ua/ 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.
TELE 2 (Teradata).
www.tele 2.ru (Moscow, Russia) (fully remote) 07/ 15/ на Jobs.ua/ 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/ на Jobs.ua/ 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/ на Jobs.ua/ 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/ на Jobs.ua/ 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/ на Jobs.ua/ 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/ на Jobs.ua/ 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/ на Jobs.ua/ 15/ 2018
Project: Data migration from Oracle, DB 2 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/ на Jobs.ua/ 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. (DB 2, Oracle, Sybase, MS SQL Server)
Hudson Global Resources 7/ 1/ на Jobs.ua/ 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/ на Jobs.ua/ 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 на Jobs.uafor intranet.
BSP Group (Microsoft Certify Partner)
www.bsp.cz 2/ 1/ на Jobs.ua/ 1/ 2004
Prague, Czech Republic
Programmer, System Developer
SYSCOM ltd 7/ 21/ на Jobs.ua/ 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/ на Jobs.ua/ 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/ на Jobs.ua/ 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 на Jobs.ua
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
