Martin Lysik

Creation of new Data Mart supporting evaluation of executed promotions by providing KPIs with complex logic based on large tables from DWH. • Design and implementation of core layer, implementation of initialization logic and daily updates • Design and implementation of access layer consumed by new set of Microstrategy reports • Optimization of database tasks performed against large tables in DWH Technologies: Teradata 15.10, Microstrategy, Jira

Synchronization of core database layer to secondary Teradata machine. • Working on this project with 2 colleagues, acting as a tech lead of this team • Initial analysis, preparation of solution design and description of defined design patterns • Implementation of synchronization workflow and equality evaluation mechanism Technologies: Teradata 15.10, Teradata Data Mover, ActiveBatch

I have led DHW Support team, supporting operation of data warehouse and development teams with their projects. • Analyzing issues with loading processes, incorrect data shown in reports, performance issues • Assisting other teams with solution design • Design and implementation of synchronization process for production environment to secondary database machine within dual environment Technologies: Teradata 14.10, Teradata Data Mover, Microstrategy, ActiveBatch

I was leading a small (3-7) offshore team of Teradata GDC Consultants • Analyzing business requirements, preparation of solution designs, effort estimation • Responsible for delivery on time and in expected quality Technologies: Teradata 14.10/15.10, Microstrategy, ActiveBatch

I have worked in team responsible for maintenance and extension of Enterprise Data Warehouse at Lidl Germany • Physical design and implementation of core and access layer • Integration of data from new sources, implementation of ETL jobs in BTEQ • Performance tuning of existing transformations or reports SQL Technologies: Teradata 14.0, Microstrategy, ActiveBatch

Leading small team of DWH consultants at Telefonica Czech Republic. • Preparation of technical parts of offers, high level design description, effort estimation • Preparation of Solution Architecture documentation • Guidance and Support of team members Technologies: Teradata 13.10, Teradata Temporal, Informatica Power Center 9.1.

Development within Enterprise Data Warehouse project at Telefonica Czech Republic. • Design and implementation of database model extensions • Integration of new data sources to DWH, preparation of ETL processes • Implementation of stored procedures and data correction scripts Technologies: Teradata 12/13.10, Informatica Power Center 8.6.1

Implementation of backend/frontend of information systems and various logical modules. * Design and implementation of changes in database on MS SQL 2008, development of stored procedures and functions, optimization, administration tasks * Design and implementation of application logic and frontend functionality in ASP.NET (C# or VB)