- Personal blog about technology topics with the focus on home IoT and smart home - https://blog.vyoralek.cz (🇨🇿 language)- "Wikipedia" pages about smarthome and Home Assistant - https://jirkovynavody.cz (🇨🇿 language)

• Build and led a team of young data enthusiasts with technical and business backgrounds, guiding professional growth and sharing best practices.• Responsible for data, quality assurance, DevOps and release management processes within the company• Implemented a system to address the increasing number of data processing issues and improve visibility into problems.• Collect, process, and analyze data for marketing platforms using Microsoft Azure MSSQL and Azure Storage.• Developed automated/semiautomated problem-solving scripts and views using Dash/Plotly and Python, resulting in faster issue identification and resolution.• Deliver custom data projects for clients using Jupyter notebooks, Django scripts, and Power BI reports.• Consolidate internal data, create reports using MySQL, Dash/Plotly, and Power BI.• Established a local data storage solution and created an API using Django REST framework to provide access to the stored data.

• Implemented project-specific development for the Liquidity database.• Pre-processed trade transactions data and processed it for regulatory risk liquidity and stress reports.• Conducted data analysis and quality validations.• Specified user stories based on business requirements.

Integration between Vendavo EPS and customers ERPs according to project-specific requirements.Technology: Oracle DB, JBOSS/Netweaver App server, Jenkins CI, Linux systems, Java, XML, and Vendavo specific languages (VSL).

PCDE department - product catalog data entry - filling and maintenance Oracle database for Telco system Foris NG. Cooperation with others modules (Ordering, Rating Engine, Billing, CRM, Reporting)Analytics on Module detail design level for PCDE module - output: technical specification for programmers.Analytics on Solution overview general level - output: business specification.Price estimates for businessmen or analysts.Component, integration and sanity testing. The whole process of ordering base telco services, generating usage records and final invoices.Main customer: Vodafone Czech - Vodafone One NetOthers customers: Warid Uganda and Congo, Calax GermanyTechnology: DB Oracle 10 (SQL, PL/SQL)

MSSQL server 2008, C# .NET 3.5, XML & XSLT technologies:- importing e-shop data from remote sources (direct connection to DB via linked server and XML)- exporting e-shop data to remote destinations (direct connection to DB via linked server and generate XML)

author and webmaster for company web ism-nike.cz

Projects:- Sitronics TSDetails are above.

Project Capitol for Stock Trading - system implementation and support (connected to Burza cenných papírů Praha (Czech stock market).Preparation and installation system Capitol at the client, troubleshooting, and consultation.Analytics new and update current functionalities based on client requirementsMain customer: BH SecuritiesOthers customers: Patria Finance and CommerzbankTechnology: MSSQL Server 2000/2005 (SQL, T-SQL), Power Builder

Project Shopcentrik - system implementation and support for e-shops connected to external ERP systems.Customers: Varied (etc. Alza, Mironet, Helap, Rubena ...)Technology: MSSQL Server 2000 (SQL, T-SQL)Marginal technology (connected to): Interbase/Firebird DB, Sybase Anywhere, MS Access), XML