Michal Macek

Designing, creating and execution of test cases. Mostly develop pure SQL scripts with scope for specific DWH/BI issues regards of amount, and complexity of data (have to be in scope performance tuning). Designing & defining of System Design Specification concept. Analysis of issues including cross checking data and re-engineering of delivered SW for data flow to look for possible issues over business definition of solution

Design test cases ,SQL to verify Dimensional and Fact tables., Defect Analyze, Analyze, design, develop DBA/SQL steps for cloning DWH environment

Teradata DB, ODI middleware, UC4 job management Operation, maintenance, performance tuning, application administration of production and pre- production test environments

Operation of Central DWH application for RBI Oracle DB, ODI - Datastage middleware, UC4 job management Operation, maintenance, performance tuning, DB administration and architecture ,application administration of production and pre-production test environments

Project managment and organization of music events and festivals with scope on bring culture of Central and Eastern Europe to UK. For example http://www.sms-2010.com or http://www.pulse-festival.com/en/

Project managment of movement of industry facilities from Sweden to Slovakia

Migration of DWH from MS SQL Server to ORACLE platform, Analyse of DWH and developing of presentation layer (Business Objects) for Auditing and Controling Authority, User selection and segmentations of user (Clementine)

GDP - BASEL II specification DWH of ERSTE BANK Group. 1,5 TB raw data loading per month, cca 1 400 000 000 rows processing per month. Analyse, developing and performance tuning DWH on ORACLE 10g. Developed generator of PL/SQL code for project

Development of datamart due to specification BASEL II for Slovenska Sporitelna bank on ORACLE platform. Analyse, definition, developing and performance optimisation of datamart on ORACLE 10g.

Development of extraction layer of DWH of Slovenska Sporitelna on ORACLE platform. Analyse of change request in core bank system, build up functional and technical specification, developing PL/SQL procedure, support testing team. Check data integrity in DWH due to core system

Implementing of MIS for Prima Zdroj, a.s. (provided by U-Sluno a.s.). Responsibility for implementation of MIS from side of customer. Definition of requests, management of implementation, testing of deployed parts. Support for all departments during migration of data. Creating and customization of reports for sales and marketing department.

Thesis - Utilization of data warehouse in bank sector (cooperate with SAS Systems)