Vít Černohouz
Data Warehouse Engineer and Team Coordinator at ZF Engineering Pilsen- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Czech Native or bilingual proficiency
-
English Professional working proficiency
-
French Limited working proficiency
-
German Limited working proficiency
-
Slovak Native or bilingual proficiency
Topline Score
Bio
Ruben Risco MBA, PMP®
Vit is a E-Workbook Developer Expert with high Project Management skills capable to provide operational and development services globally for Novartis Pharma TRD and NIBR in compliance with pharma quality standards and ITIL principles . Vit has very professional project manager, customer focus and issue resolution skills to lead and operate independently Application Support Services globally & develop complex initiatives based on our customer requirements.
Jean Matscher
Vit is a dynamic and proactive guy, ready to dive into new challenges while keeping track of current work streams. He worked as a 1st&2nd level supporter and developer for our Biologics eLN for 2 years now, during which he took the steep ramp in learning the technical skills required to develop the complex logic in our experiment templates. He is one of the key members on our team when it comes to supporting the users, be it in standard tasks as well as debugging issues and enhancing the user experience, and it’s also thanks to him that we are getting close to completion of a very demanding and long-term development activity. As a team member, he is dedicated, conscientious of the open tasks, following up on assigned work… and on top of that a nice guy with lots of insight into the mysteries of Italian coffee making :-)! I can give him my full recommendation.
Ruben Risco MBA, PMP®
Vit is a E-Workbook Developer Expert with high Project Management skills capable to provide operational and development services globally for Novartis Pharma TRD and NIBR in compliance with pharma quality standards and ITIL principles . Vit has very professional project manager, customer focus and issue resolution skills to lead and operate independently Application Support Services globally & develop complex initiatives based on our customer requirements.
Jean Matscher
Vit is a dynamic and proactive guy, ready to dive into new challenges while keeping track of current work streams. He worked as a 1st&2nd level supporter and developer for our Biologics eLN for 2 years now, during which he took the steep ramp in learning the technical skills required to develop the complex logic in our experiment templates. He is one of the key members on our team when it comes to supporting the users, be it in standard tasks as well as debugging issues and enhancing the user experience, and it’s also thanks to him that we are getting close to completion of a very demanding and long-term development activity. As a team member, he is dedicated, conscientious of the open tasks, following up on assigned work… and on top of that a nice guy with lots of insight into the mysteries of Italian coffee making :-)! I can give him my full recommendation.
Ruben Risco MBA, PMP®
Vit is a E-Workbook Developer Expert with high Project Management skills capable to provide operational and development services globally for Novartis Pharma TRD and NIBR in compliance with pharma quality standards and ITIL principles . Vit has very professional project manager, customer focus and issue resolution skills to lead and operate independently Application Support Services globally & develop complex initiatives based on our customer requirements.
Jean Matscher
Vit is a dynamic and proactive guy, ready to dive into new challenges while keeping track of current work streams. He worked as a 1st&2nd level supporter and developer for our Biologics eLN for 2 years now, during which he took the steep ramp in learning the technical skills required to develop the complex logic in our experiment templates. He is one of the key members on our team when it comes to supporting the users, be it in standard tasks as well as debugging issues and enhancing the user experience, and it’s also thanks to him that we are getting close to completion of a very demanding and long-term development activity. As a team member, he is dedicated, conscientious of the open tasks, following up on assigned work… and on top of that a nice guy with lots of insight into the mysteries of Italian coffee making :-)! I can give him my full recommendation.
Ruben Risco MBA, PMP®
Vit is a E-Workbook Developer Expert with high Project Management skills capable to provide operational and development services globally for Novartis Pharma TRD and NIBR in compliance with pharma quality standards and ITIL principles . Vit has very professional project manager, customer focus and issue resolution skills to lead and operate independently Application Support Services globally & develop complex initiatives based on our customer requirements.
Jean Matscher
Vit is a dynamic and proactive guy, ready to dive into new challenges while keeping track of current work streams. He worked as a 1st&2nd level supporter and developer for our Biologics eLN for 2 years now, during which he took the steep ramp in learning the technical skills required to develop the complex logic in our experiment templates. He is one of the key members on our team when it comes to supporting the users, be it in standard tasks as well as debugging issues and enhancing the user experience, and it’s also thanks to him that we are getting close to completion of a very demanding and long-term development activity. As a team member, he is dedicated, conscientious of the open tasks, following up on assigned work… and on top of that a nice guy with lots of insight into the mysteries of Italian coffee making :-)! I can give him my full recommendation.
Credentials
-
Power BI Data Modeling with DAX
Linkedin Learning AppSep, 2022- Nov, 2024 -
Advanced Power BI Desktop
Excel TownNov, 2021- Nov, 2024 -
Duolingo French Fluency: Intermediate (Estimated)
DuolingoOct, 2015- Nov, 2024 -
First Certificate in English
Cambridge English Language AssessmentMar, 2011- Nov, 2024
Experience
-
ZF Engineering Pilsen
-
Czechia
-
Motor Vehicle Manufacturing
-
300 - 400 Employee
-
Data Warehouse Engineer and Team Coordinator
-
Sep 2021 - Present
Mongo DB, SQL Server, Power BI, GIT, Building data warehouse and ETL processes, design of Power BI reporting, Requirement analysis, international team, agile development. Mongo DB, SQL Server, Power BI, GIT, Building data warehouse and ETL processes, design of Power BI reporting, Requirement analysis, international team, agile development.
-
-
-
MSD
-
United States
-
Pharmaceutical Manufacturing
-
700 & Above Employee
-
Data Analyst at MSD
-
Feb 2021 - Jul 2021
Analysed Virtual Events from salesforce in separate analysis, Excel pivot tables, powerpoint presentations, SOQL language Analysed Virtual Events from salesforce in separate analysis, Excel pivot tables, powerpoint presentations, SOQL language
-
-
-
Novartis
-
Switzerland
-
Pharmaceutical Manufacturing
-
700 & Above Employee
-
Business Analyst E-Workbook
-
Jul 2020 - Feb 2021
-
-
E-Workbook support and development
-
Nov 2016 - Jul 2020
Application Support, Project management, Business analysis, E-Workbook spreadsheet development, testing, Migration project, Upgrade project, printers setup, new application deployment project
-
-
-
AIMTEC a. s.
-
Czechia
-
IT Services and IT Consulting
-
100 - 200 Employee
-
DCIx Consultant
-
Mar 2015 - Oct 2016
I work as Consultant of Warehouse Management System named DCIx. This Software is developed by AIMTEC. My role is an interface between customer and Aimtech developers. I am configuring the DCIx system and dealing with customer on delivering quality in the desired time and affordable costs. My role contains estimation and planning the amount of required resources to fulfill the delivery of software projects. Communication is essential in this position. I define tasks to team of programmers internally and design the plans and final solution together with various customer specialists. I try to develop by hard skills. The technologies and tools I use on daily, weekly basis are AIMTEC DCIx, SQL, SQL Management Studio, Jasper iReport, Microsoft Dynamics CRM, Outlook, Onenote, Excel, Windows administration, OS/400 BPCS LX. Show less
-
-
-
Barclays Corporate & Investment Bank
-
United States
-
Financial Services
-
700 & Above Employee
-
IT Support Specialist
-
Nov 2013 - Jan 2015
The role was consisted of 24/7 support of Barclays internal trading community and FX Applications. I was handling day to day incidents generated by various trading applications. I was dealing with day to day questions from traders, operations staff, other IT staff, and other users regarding any issues they face with the application I supported. I became an professional in the use and support of Murex, BARX systems,Traction, QA Book, Qlikview and other trading platforms and support systems. The role was consisted of 24/7 support of Barclays internal trading community and FX Applications. I was handling day to day incidents generated by various trading applications. I was dealing with day to day questions from traders, operations staff, other IT staff, and other users regarding any issues they face with the application I supported. I became an professional in the use and support of Murex, BARX systems,Traction, QA Book, Qlikview and other trading platforms and support systems.
-
-
-
ICZ a.s.
-
Czechia
-
IT Services and IT Consulting
-
300 - 400 Employee
-
Business Inteligence Developer
-
Oct 2012 - Sep 2013
I work on extracting, transforming, loading, calculating and analysing data of czech hospitals. Used technologies were Oracle Business Intelligence Enterprise Edition 10g and 11g, I worked on upgrade of OBIEE 10g to 11g in test environment. Creation of views, and daily SQL usage in Oracle Database. I work on extracting, transforming, loading, calculating and analysing data of czech hospitals. Used technologies were Oracle Business Intelligence Enterprise Edition 10g and 11g, I worked on upgrade of OBIEE 10g to 11g in test environment. Creation of views, and daily SQL usage in Oracle Database.
-
-
-
ZŠ Čechova Rokycany
-
District Rokycany, Czech Republic
-
English and Mathematics teacher
-
Apr 2011 - Jan 2012
Time to time I replaced missing teachers in the primary school. I became quite popular among students and I offer them private lessons up to the present day. Time to time I replaced missing teachers in the primary school. I became quite popular among students and I offer them private lessons up to the present day.
-
-
-
BRUSH Group
-
United Kingdom
-
Appliances, Electrical, and Electronics Manufacturing
-
100 - 200 Employee
-
IT aid in quality department during process changes
-
Aug 2011 - Oct 2011
I discussed unsatiscactory state of data managing in quality dept. A concept was made for transfer data from Excel sheets and ERP system to new quality department's database on the server. The application I developed (in VBA) provided continual data calculation and actualisation. I discussed unsatiscactory state of data managing in quality dept. A concept was made for transfer data from Excel sheets and ERP system to new quality department's database on the server. The application I developed (in VBA) provided continual data calculation and actualisation.
-
-
-
-
Programmer
-
Mar 2010 - Apr 2010
I programmed specific tascs in C# (e.g. database random record generator, GUI for database manipulation and management) I programmed specific tascs in C# (e.g. database random record generator, GUI for database manipulation and management)
-
-
Education
-
2007 - 2012
Západočeská univerzita Plzeň
Master’s Degree, Management Information Systems, General
Community
