Experience

Ematiq

• Czechia
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior Data Engineer

  • Nov 2023 - Present

  Hlavní město Praha, Česko



blog.vyoralek.cz

• Blogger

  • Aug 2017 - Present

  Česká republika Personal blog about technology topics with the focus on home IoT and smart home.



ROIVENUE™

• Czechia
• Information Technology & Services
• 1 - 100 Employee

• Team Lead Data Engineering

  • Sep 2020 - Aug 2023

  Hlavní město Praha, Česko • 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… Show more • 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. Show less



EPAM Systems

• IT Services and IT Consulting
• 1 - 100 Employee

• Software Engineer

  • May 2018 - Sep 2020

  Hlavní město Praha, Česká republika



Barclays Investment Bank

• United States
• Financial Services
• 700 & Above Employee

• Software Engineer

  • May 2018 - Sep 2020

  Hlavní město Praha, Česká republika • 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.



Vendavo

• United States
• Software Development
• 300 - 400 Employee

• Solutions Engineer

  • Jan 2015 - Jan 2018

  Prague, The Capital, Czech Republic 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).



Sitronics Telecom Solutions

• Senior DB Software Engineer

  • Sep 2007 - Dec 2014

  Hlavní město Praha, Česká republika 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… Show more 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 Net Others customers: Warid Uganda and Congo, Calax Germany Technology: DB Oracle 10 (SQL, PL/SQL) Show less



Internet Stores s.r.o.

• System Integration Specialist

  • Jan 2009 - Dec 2011

  Ostrava, Moravskoslezský, Česká republika 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)



Internation Sports Marketing s.r.o.

• Webmaster

  • Aug 2006 - Dec 2010

  author and webmaster for company web ism-nike.cz



Cleverlance Enterprise Solutions a.s.

• Senior Database Developer

  • Sep 2007 - May 2009

  Prague, The Capital, Czech Republic Projects: - Sitronics TS Details are above.



Capgemini

• India
• Information Services
• 1 - 100 Employee

• Senior Database Developer and Analyst

  • Apr 2006 - Sep 2007

  Prague 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 requirements Main customer: BH Securities Others customers: Patria Finance and Commerzbank Technology: MSSQL Server 2000/2005 (SQL, T-SQL), Power Builder



NetDirect

• Czechia
• IT Services and IT Consulting
• 1 - 100 Employee

• Chief of System Integration

  • Jul 2003 - Mar 2006

  Ostrava 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