- BI solution from A to Z in cloud environment - communication with stakeholders- Snowflake DB consultation - building ELTs in Keboola Connection, Snowflake DB- Python scripting- Connectors based on REST API- Data manipulation, transformations, pipelines…- various extraction (GA, Adwords, Postgres, Salesforce, FB...)- data manipulating, custom extraction via Python/Rest API- architecture & data deep diving, data modelling for BI tools- visualization and analytics in Tableau and Good DataMarket&Advisory industry – 5 months- Snowflake DB consultation, implementation- other delivery: Snowflake cost audit reporting, Snow-Postgres migration tool, logging function (changes)Secondhand Car industry – 5 months- architecture and development – pipeline for migration hundreds of local DMS (dealer management system) to cloud (Keboola, Python)TV/Telco industry - continuous cooperation for 2 years - creating and maintaining reporting system for whole company (500 reports) - finance, marketing, call centre. - Good data solution - migration from Good data to TableauTravel Agency - 4 months - data solution from scratch (Keboola Connection) - custom Python scripts for collecting data from affiliate partners (Python, Rest API, XML) - financial and online marketing reporting (PnL, Product funnel, RFM...) in Tableau E-commerce - 3 months - 2nd biggest online store in CZ - gathering data from SAP, Oracle - architecture and construction of domain model for key production reports of company - data qualityWarehouse monitoring (boxes in the process) - 1 month - preparing Snowflake DB - creating data pipeline from AS400 to Snowflake database (Python, Snowpipe) - reporting in Tableau, auto refresh every 5 minMigration from Excel - 1 month - gathering of 2 500 excel sheets and enrichment, processing (Python solution)Finance - 1 month - FinTech startup (post-pay service) - data model for production information - viz in BI Tableau

Building up English and customer relationship skills thanks to English classes and working in hospitality.Mission success!

As a member of Integration Risk Management, I have worked with Underwriting, Credit Risk, Business, Collateral, and other teams.- Data mining in the bank’s primary accounting system (MIDAS) and other internal systems and databases- Analyzing banking information about products, ratings, provisions, and production, with focus on customers’ ratings- Ensuring data quality and unifying results (i.e., “One result to rule them all”)- Developing data processes in Microsoft SQL Server Management Studio (T-SQL) and Visual Studio (SSIS, VB)- Creating fully automated reports- Preparing data for Risk and other committees- Providing IT support (VBA, SQL, Excel) to teams within the department

- member of Controlling team, Financial department- many areas of interest- variety responsibilities based on knowledge of data processing, ability to learn, knowledge base, logical thinking, communication skills, effort for quality and proactivity Accounting & Financial - troubleshooting, ad hoc searching information trough laboratory ISs and others ISs - creating processes and tools for reporting, invoicing processing via VBA (CashFlow, invoice for selfpayers, hospitals...) - ad hoc reports and analysis - participating in CFO's projects (data and information support)Datacare and Projects around laboratory ISs - helping ISs to change orders to revenues - audit of data, analysing information - coordination system settings - communication with suppliers - searching for potencial threatsCEO's, Business development and Project managers's projects - analysing information, data modeling - giving advice based on hard information

Data processing- analyzing and reporting on a weekly and monthly basis- administration of local DB- data mining via SAS- data processing in MS Access and MS Excel- creating procedures in VBA- ad hoc analysis- optimizing processes- forecasting costs for a motivational system and competitions- checking correct commissions and plan fulfillment- presenting and distributing informationSales representative's support- support and guide for sales representatives- educating in product processing (technical way)- administrative activities (recruitment of new sales reps)- ensuring corrections errors in global company's system (commissions, plan fulfillment)

- admin of LMS Moodle- developing in Lectora environment (eLearning, videolibrary, new features)- audio video processing- ICT administration- data processing