Karel Koutný
Head of Controlling, Data Analyst at Repharm a.s.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
čeština Native or bilingual proficiency
-
angličtina Limited working proficiency
-
slovenština Professional working proficiency
-
polština Limited working proficiency
Topline Score
Bio
Alojz Lacko
Karel is another chap I know from www.wall.cz, the forum focused primarily on Excel/VBA. He belongs to the limited group of my favorite contributors there. Very smart guy with deep knowledge on Excel and VBA, if I may say so. I carefully check all his posts there. He has got his own blog focused on Excel, too. I would recommend anyone interested in Excel to watch this guy's activity.
Alojz Lacko
Karel is another chap I know from www.wall.cz, the forum focused primarily on Excel/VBA. He belongs to the limited group of my favorite contributors there. Very smart guy with deep knowledge on Excel and VBA, if I may say so. I carefully check all his posts there. He has got his own blog focused on Excel, too. I would recommend anyone interested in Excel to watch this guy's activity.
Alojz Lacko
Karel is another chap I know from www.wall.cz, the forum focused primarily on Excel/VBA. He belongs to the limited group of my favorite contributors there. Very smart guy with deep knowledge on Excel and VBA, if I may say so. I carefully check all his posts there. He has got his own blog focused on Excel, too. I would recommend anyone interested in Excel to watch this guy's activity.
Alojz Lacko
Karel is another chap I know from www.wall.cz, the forum focused primarily on Excel/VBA. He belongs to the limited group of my favorite contributors there. Very smart guy with deep knowledge on Excel and VBA, if I may say so. I carefully check all his posts there. He has got his own blog focused on Excel, too. I would recommend anyone interested in Excel to watch this guy's activity.
Experience
-
Repharm a.s.
-
Czechia
-
Pharmaceutical Manufacturing
-
1 - 100 Employee
-
Head of Controlling, Data Analyst
-
Mar 2016 - Present
- applications development and maintenance in VBA (MS Excel, MS Access) and T-SQL (SQL Server) - development and maintenance solutions for plan - system of matching prescribed prescriptions in pharmacies - positive list evaluation system - bonus processing system - monitoring the use of company vehicles - automatic data updating for company reporting - online reporting development in MS Excel using native tools (List Object + Pivot table), power tools and OLAP (SQL server analysis services) - data stored in the database (SQL server) - online reporting development in the intranet using SSRS (SQL server reporting services) - data transfering using SSIS (SQL server integration services) - MS Excel training (basic, advanced) Show less
-
-
-
OKD, a.s.
-
Czechia
-
Mining
-
300 - 400 Employee
-
Controller
-
Feb 2003 - Mar 2016
Drawing up plans and forecasts of economic and production-technical indicators, monitoring and evaluating of their fulfillment, reporting and analysing based on the management requirements The main working tools MS Excel, SAP. Member of team - SAP project - Creation an integrated logistics system on the basis SAP ERP - modules SAP CO, SAP PS Drawing up plans and forecasts of economic and production-technical indicators, monitoring and evaluating of their fulfillment, reporting and analysing based on the management requirements The main working tools MS Excel, SAP. Member of team - SAP project - Creation an integrated logistics system on the basis SAP ERP - modules SAP CO, SAP PS
-
-
Education
-
1990 - 1997
VŠB-Technical University of Ostrava, Faculty of Mining and Geology
Ing., Economics of raw materials extraction -
1986 - 1990
Mining High School
Mining
Community
