Hubert Ilcik Email & Phone Number

Netherlands

The Hague, South Holland, Netherlands

technologies: python, pyspark, sql, tableau, azure, databricks, git- building models in python- building dashboards in tableau- carrying out analyses- professionalizing the analytical environment (automation and setting up data pipelines)

Utrecht Area, The Netherlands

Amsterdam Area, Netherlands

Technologies: HP Vertica, Python, SQL, Tableau, Amazong Web Services, Rundeck scheduling, gitMethodology: Data Vault 2.0, Dimensional Modelling● Implemented several analytics projects such as fraud analytics and customer experience. Handling the whole lifecycle of each project (from extracting the necessary data to creating dashboards/analyses).● Integrated 8 data sources and established Data Vault as the main modeling methodology.● Ad-hoc reporting and analyses.My focus:● Built ETL pipelines in Python and SQL (extraction, cleaning, feature engineering, etc.)● Built dashboards and reports in Tableau.● Improved performance of the ETL process.● Supported the business with data analysis and self service BI.

Prague, The Capital, Czech Republic

Technologies: Teradata, PowerDesigner, SQL. Partial focus: Informatica, IBM CognosMethodology: Third Normal Form, Dimensional Modelling● Built a fully working data warehouse from scratch with areas like clients, contracts, transactions, etc. and a mart layer for marketing and sales.● Lead implementation of a major release of 16 new reports/cubes for 12 countries designing and building the data warehouse and data mart extension.● Lead implementation of Electronic Banking into the data warehouse. Successfully implemented data warehouse and data mart extension of 4 new OLAP cubes based on 90 new source objects.My focus:● Analysis and design - strong emphasis on understanding the source system data and the business. Based on the analysis I designed the data warehouse and data marts. Analyzed more than 400 source system objects and designed more than 80 final objects implementing transformation rules and data quality checks.● Team of junior analysts - training, assigning and reviewing work● Main point of contact for the client. Helped define the scope with project managers in France, worked on the architecture with the main BI architect in Czech Republic, organized workshops with end users from the African countries to understand their source systems.● Testing - defining test approach, creation of testing scripts in SQL and simulation of data errors

Bratislava, The Capital, Slovakia