Резюме: Data engineer (Україна)

Досвід роботи

<p>Data scientist.</p>
<p>name: Jurij Usenko</p>
<p><strong>Prague, Czech Republic</strong></p>
<p>Teradata certify master, Brainbench MS BI tools certification.</p>
<p> <strong> </strong> <br /></p>
<p><strong>Summary :</strong></p>
<p><strong>EU citizenship</strong></p>
<p>Over 20 years of IT experience<strong></strong></p>
<p><strong>Primary skill :</strong> BI SME, BI technical lead, ETL Technical Lead.</p>
<p>Senior business intelligence developer, Senior DWH developer.<strong></strong></p>
<p><strong>Industries :</strong> Financial, Telecommunication, Automotive, Airline<strong></strong></p>
<p><strong>Oraganization skill :</strong> Project manager, Technical lead, Team leader<strong></strong></p>
<p><strong>Primary DWH platform :</strong> Teradata, MS SQL Server<strong></strong></p>
<p><strong>Primary BI platform :</strong> SSIS, SSRS, Qlick View, MS Excell, SAP BO</p>
<p>Hands on programmer experience for the various databases. (procedures, triggers, ...)<strong></strong></p>
<p><strong>Specific DB system skills and knowledge: </strong>British Telecom DWH, Global Airline tickets reservation system<strong>, </strong>DB2<strong>, </strong>Call Center system (Nortel).<strong></strong></p>
<p><br /></p>
<p><strong> </strong></p>
<p><strong>PROFESSIONAL EXPERIENCE:</strong></p>
<p><strong><br /></strong></p>
<p><strong>BANK Misr.</strong></p>
<p><strong>www.banquemisr.com// </strong><strong>(New Cairo, Cairo, Egypt </strong>on-site hybrid) 09<strong>/01/2024 –</strong> 11/30/2024</p>
<p>Position: <strong>Test Engineer, Team lead</strong>. <strong>Teradata SME.</strong></p>
<p>Project: Project: Central DWH data migration. </p>
<p><strong>Tools: Teradata TTU, SQL Assistant, Informatica(DEI 10.5.4), CLOUDERA. </strong></p>
<p>Analysis, creating and maintain test case scenarios. Test cases automation.</p>
<p>Collaboration with business analytics team.<br />
Creating and maintain all necessary documentation. </p>
<p>Data mapping, data source analysis, test case analysis and reporting.</p>
<p></p>
<p><strong>Swedbank</strong></p>
<p><strong>www.swedbank.com/ </strong><strong>(</strong>fully remote) 02<strong>/01/2024 –</strong> 05/01/2024</p>
<p>Position: System Analyst. BI Developer / Analyst (Teradata 17.20). </p>
<p>Project: SPSS(IBM) data processing. ETL and data mining optimization. SPSS reengineering. </p>
<p><strong>Tools: Teradata SQL Assistant, IBM SPSS Modeler. </strong></p>
<p>Database and ETL optimization.</p>
<p>Monitoring of the ETL processing on the daily base. </p>
<p>System workload analysis. </p>
<p>Create and maintain related documentations. </p>
<p></p>
<p><strong>Unicorn</strong></p>
<p><strong>www.unicorn.cz/</strong> (fully remote, part time ) 0<strong>3/01/2023 –</strong> 12/31/2023</p>
<p><strong>Position: System Analyst. SQL Developer (ORACLE 19, MS SQL Server 2019)</strong></p>
<p>Project: Campaign Management System.</p>
<p><strong>Tools: Oracle Developer, MS SSIS, MS Management Studio. </strong></p>
<p>Database and ETL optimization.</p>
<p>Monitoring of the ETL processing on the daily base. </p>
<p>System workload analysis. </p>
<p>Create and maintain related documentations. </p>
<p>Crédit Agricole (France) <strong>(fully remote</strong>) </p>
<p><strong>Position: ETL developer</strong> 03/01/2023 – 10/15/2023</p>
<p>Technologies used: Abinitio,ExpressIT. </p>
<p><strong><br /></strong></p>
<p><strong>Lufthansa</strong></p>
<p><strong>www.lufthansa.com/</strong> (fully remote )<strong> 0</strong><strong>3/01/2022 – 02/01/2023</strong></p>
<p>Position: Operational DBA</p>
<p>Project: Lufthansa managed service.</p>
<p><strong>Tools: TASM. Teradata tools and Viewpoint. </strong></p>
<p>Manage data migration process.</p>
<p>Monitoring of the ETL processing on the daily base. </p>
<p>System workload analysis.</p>
<p>Create and maintain related documentations. </p>
<p><strong><br /></strong></p>
<p><strong>Allianz</strong></p>
<p><strong>www.allianz.cz/</strong> <strong>(Prague, Czech Republic) </strong>(part-time, fully remote, fix price)<strong> 09/15/2021 – <strong>0</strong><strong>3/01/2023</strong></strong></p>
<p><strong>Position: BI analyst - Oracle 19, MS Reporting Services 2019</strong></p>
<p><strong>Project: Oracle DWH support. Reporting support and development. </strong></p>
<p>Reporting system migration from SAS reporting environment to the MS Reporting services.</p>
<p>Create project related documentation. (business analysis, architecture, technical specification)</p>
<p>Tools: MS Reporting Builder 2019, MS Visual Studio, PL/SQL Developer, MS SQL Server management studio.</p>
<p><strong><br /></strong></p>
<p><strong><br /></strong></p>
<p><strong>WIZ-TEAM SA</strong></p>
<p><strong>www.wiz-team.com </strong>(Kyiv , Ukraine) (fully remote, fix price) 0<strong>5/15/2021 – </strong>08<strong>/31/2021</strong></p>
<p>Position: System architect, business analyst</p>
<p>Project: Visitor system DWH.</p>
<p>Create project related documentation. (business analysis, architecture, technical specification)</p>
<p>Technology : MySQL, ORACLE.</p>
<p>Tools: SQL Developer, Toad. </p>
<p><strong><br /></strong></p>
<p><strong>VTB Group. </strong></p>
<p><strong>www.vtb.ru </strong>(Moscow, Russia) (fully remote) 01/02/2021 – 02/01/2022</p>
<p><strong>Position: System analyst.</strong></p>
<p>Project: Data processes daily monitoring. DWH, ETL optimization.</p>
<p><strong>Tools: TASM. Teradata tools and Viewpoint. </strong></p>
<p><strong>Monitoring of the ETL processing on the daily base. </strong></p>
<p><strong>System workload analysis.</strong></p>
<p><strong></strong></p>
<p><strong>Create and maintain related documentations. </strong></p>
<p><strong>TELE2 (Teradata). </strong></p>
<p><strong>www.tele2.ru </strong>(Moscow, Russia) (fully remote) 07/15/2020 – 12/18/2020</p>
<p><strong>Position:.Technical lead of the Systems Analysis Group.</strong></p>
<p>Project: Data processes daily monitoring. DWH, ETL optimization.</p>
<p><strong>Tools: Azure DEVOPS. Teradata tools and Viewpoint. </strong></p>
<p><strong>Monitoring of the ETL processing on the daily base. </strong></p>
<p><strong>System workload analysis.</strong></p>
<p><strong>Create and maintain related documentations. </strong></p>
<p><strong> </strong></p>
<p><strong> </strong></p>
<p><br /></p>
<p><strong>Unicredit Bank (Teradata).</strong><br /></p>
<p><strong>www.unicredit.ro</strong><strong> </strong><strong>(Bucharest, Romania) 06/01/2020 – 07/01/2020</strong></p>
<p><strong>Position: BI technical lead.</strong></p>
<p>Project: Pre upgrade assessment Teradata DWH support. (Teradata 15.10 to 16.20)</p>
<p>Post upgrade optimization. (Teradata 15.10 to 16.20)</p>
<p>Position: Data analyst. Teradata SME.</p>
<p><strong>Tools: BTEQ, SQL Assistant, Viewpoint. </strong></p>
<p><strong>DWH and BI solution post upgrade support, daily data flow tasks monitoring. </strong></p>
<p><strong>ETL tasks optimization. </strong></p>
<p><strong>Create and maintain related documentations. </strong></p>
<p><strong><br /></strong></p>
<p><strong> </strong></p>
<p><strong> </strong></p>
<p><strong>Vodafone (IBM). </strong></p>
<p><strong>www.vodafone.cz</strong><strong> </strong><strong>(Prague) </strong></p>
<p><strong>Position: DWH technical lead.Data processing analyst. 01/01/2020 – 03/31/2020</strong></p>
<p>Project: Teradata DWH support. (Teradata 16.20)</p>
<p>Create new BI extension for the current solution<strong>. </strong>New data flow analysis and development.</p>
<p>Data modelling</p>
<p>Contract position: Teradata SME. Data analyst. Teradata 16.20 SME.</p>
<p><strong>Tools: Teardata PT. Informatica 10.2, BTEQ, SQL Assistant. </strong></p>
<p><strong>Data modeling – SAP Power designer 16,5 </strong></p>
<p><strong>DWH and BI solution support using daily data flow tasks monitoring. </strong></p>
<p><strong>ETL development and data flow tasks optimization. </strong></p>
<p><strong>Create and maintain related analytical documentations. </strong></p>
<p><strong><br /></strong></p>
<p><strong> </strong></p>
<p><strong>Sberbank EU. </strong></p>
<p><strong>www.sberbank.at</strong><strong> </strong><strong>(Austria) 09/30/2019-12/31/2019</strong></p>
<p>Project: New DWH extension. Short term contract.</p>
<p>Contract position: BI Team Leader. (small team 5-10 members) (on/off site)<strong></strong></p>
<p><strong>Tools: MS BI tools(SSIS, SSRS). </strong></p>
<p>Improve existed development process.<br /> Create and mountain new development standards.<br /> Improve project delivery quality.</p>
<p></p>
<p><strong> </strong></p>
<p><strong> </strong></p>
<p><strong>KBC Group (CSOB SK). </strong></p>
<p><strong>www.csob.sk</strong><strong> </strong><strong>(Bratislava, Slovakia) 06/10/2019 – 09/30/2019</strong></p>
<p>Project: New DWH extension<strong>. </strong>New data flow analysis.</p>
<p>Contract position: DWH architect. Business analyst, Teradata SME. <strong></strong></p>
<p><strong>Tools: JIRA, Informatica, BTEQ, SQL Assistant. Data modeling – SAP Power designer 16,5 </strong></p>
<p><strong><br /></strong></p>
<p><strong> </strong></p>
<p><strong> </strong></p>
<p><strong>Bank Of Ireland (NCL). </strong></p>
<p><strong>www.ncl.com</strong><strong> </strong><strong>(Dublin, Ireland) 10/15/2018 – 04/12/2019</strong></p>
<p>Project: Teradata EDW support.(Managed service Teradata 15.10).</p>
<p>Contract position: Optimization team leader (on/off site)</p>
<p>Teradata SME. DWH optimization tech lead. Teradata 15.10, Informatica 9,5.<strong></strong></p>
<p><strong>Tools: JIRA, Teradata Studio 15, BTEQ, TPT, SQL Assistant. </strong></p>
<p><strong><br /></strong></p>
<p><strong> </strong></p>
<p><strong>Societe Generale Bank (NESS). </strong></p>
<p><strong>www.ness.com</strong><strong> </strong><strong>(Prague , Czech Republic) 2/1/2017 – 10/15/2018</strong></p>
<p>Project: Data migration from Oracle, DB2 to Teradata 15.10.Operation support production environment(Teradata 15.10).</p>
<p>Contract position: DWH optimization technical lead. Teradata 15.10, Informatica 9,5.</p>
<p><strong>Tools:</strong> <strong>JIRA, Fastload, BTEQ, TPT, SQL Assistant. Teradata Manta standardization tool.</strong></p>
<p><strong>Data modeling - Power designer 16,5</strong></p>
<p><strong> </strong></p>
<p><strong> </strong></p>
<p><strong><br /></strong></p>
<p><strong>Teradata </strong><strong>10/6/2008 – <strong>11/1/2017</strong></strong><strong></strong></p>
<p><strong>www.teradata.com/</strong></p>
<p>GCC Prague, Czech Republic. </p>
<p>Global Delivery Control Consultant (III). Senior Professional Service Consultant.</p>
<p>Senior DWH Developer. Business Intelligence Consultant.</p>
<p></p>
<p><strong> </strong></p>
<p><strong>Team Trackers (Air France Group) </strong><strong>1/1/2007 – 10/5/2008</strong></p>
<p><strong>www.team-trackers.com/</strong></p>
<p>Prague, Czech Republic. Senior DWH, BI Developer. C# Programmer</p>
<p><strong>(MS SQL Server 2005, 2008, SSRS, SSIS, SSAS, MS Foundation team server, MS BI)</strong></p>
<p> Accomplished projects:<strong></strong></p>
<p><strong> Create and maintain DWH and reporting environment,</strong></p>
<p><strong> Data integration project,(ORACLE, CSV files, Sybase)</strong></p>
<p><strong> Data migration.(DB2, Oracle, Sybase, MS SQL Server)</strong></p>
<p><strong><br /></strong></p>
<p><strong> </strong></p>
<p><strong>Hudson Global Resources </strong> <strong>7/1/2005 – 1/2/2007</strong></p>
<p><strong>www.hhgroup.com</strong></p>
<p><strong>www.hudson.com</strong></p>
<p> Prague, Czech Republic. <strong>Programmer.</strong></p>
<p><strong> Back – end programmer for web-application (C#, SQL Server 2000, 2005),</strong></p>
<p><strong> C# developer for MS SharePoint Portal Server and MS SharePoint Service,</strong></p>
<p><strong> Administrator MS SharePoint Service.<strong></strong></strong></p>
<p><strong><br /> AAA Auto a.s </strong><strong>5/2/2004 – 6/30/2005</strong></p>
<p><strong>www.aaaauto.cz</strong></p>
<p><strong>www.europeanautosales.nl</strong></p>
<p>Prague, Czech Republic. <strong>Programmer. DWH developer.BI developer.</strong></p>
<p>Support, Developing applications, Databases using VB 6.0, ASP, ASP .NET, VB.NET, MS SQL server 2000.</p>
<p>ETL processes from other DB system (Oracle, Sybase) using DTS.</p>
<p>Developing Analytics Report with MS OLAP Server and MS Excel 2000/XP, Crystal Report 8.5.</p>
<p> Deploy application with MS Share Point Portal Server (2003) for intranet.</p>
<p><br /><br /><strong></strong></p>
<p><strong>BSP Group</strong> (Microsoft Certify Partner)</p>
<p><strong>www.bsp.cz</strong> 2/1/2002- 5/1/2004<strong> </strong></p>
<p>Prague, Czech Republic<strong> <strong></strong></strong></p>
<p><strong>Programmer, System Developer</strong></p>
<p><strong>SYSCOM ltd </strong>7/21/1998 - 12/23/2001</p>
<p>Kiev, Ukraine</p>
<p> Lead Programmer </p>
<p>Accomplished projects:</p>
<p>Writing project-related utilities Using VC++ 6.0,VB 6.0.</p>
<p>Developing and maintain database using MS SQL Server 7.0.</p>
<p><strong>Newspaper “Interest”</strong> IT department. 2/1/1997 - 7/1/1998 </p>
<p>Kiev, Ukraine</p>
<p> Lead Programmer/ Project Leader </p>
<p>Accomplished projects:</p>
<p> Developing and maintaining Web pages and WEB related applications</p>
<p>&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;</p>
<p> Eltoks Ltd. 8/1/1996 - 2/1/1997 </p>
<p>Zsitomir, Ukraine</p>
<p> Programmer / Analyst </p>
<p>Testing, quality assurance, fixing, troubleshooting, documenting</p>
<p> ModernTech Co. 2/1/1994 to 8/1/1996 Zsitomir, Ukraine Programmer / Analyst (Windows) </p>
<p>Developing and maintaining database.</p>
<p><strong> </strong></p>
<p> <br /></p>
<p><strong>EDUCATION:</strong><strong></strong></p>
<p><strong>Kiev IT University, computer science bachelor degree(2001)</strong></p>
<p><strong>BRAINBENCH CERTIFICATION:</strong></p>
<p><strong>26-Jun-2013: MS SQL Server 2012 Programming (expert level).</strong></p>
<p><strong>12-Aug-2015:</strong> <strong>MS SQL Server 2014 Programming (advance level).</strong></p>
<p><strong>06-Aug-2016:</strong> <strong>MS SQL Server 2014 Reporting Services</strong></p>
<p><strong> </strong></p>
<p><strong>TERADATA CERTIFICATION:</strong></p>
<p>January 2009: Teradata Master Certified.</p>
<p><strong>LANGUAGES:</strong><strong></strong></p>
<p>Fluent Russian, Fluent Czech, English</p>