Pavel Špejtek ♒
  • @paquary
  • Czech Republic
 Web application developer on various topics:
- financial information (reports, surveys, planning, ...),
- Laboratory data .. collection, processing, form generator for collection, generator set
- TRS, OEE applications
- display of sensor data in graphical form ... ECHARTS, statistics
- application recipes for production
- production planning ... in the development phase
- registration of complaints

MS Office VBA:
- general solution for importing Excel -> MSSQL data, creating tables, filling data .. used in several projects, or as a simple data filler for web applications

MSSQL 2016:
- technical design of the whole data processing system for controlling ... Excel (data input) -> MSSQL -> OLAP (Analysis Services) -> EXCEL (reports)

SHAREPOINT:
- creating small applications base upon XLSX table and create sharepoint list by using FLOW, which is formatted by JSON
- debugging Excel documents with bindings for team collaboration stored on SHAREPOINT => created macros for analysis, fixing problems + powershell script for first detection of why file is slow

Specialties:
- own framework based upon JavaScript and jQuery (90%) , PHP (10%)
- MS SQL 2016, installation, design, SQL optimalization, OLAP 
Read more
Contact Me

Resume

Jul 2019 - Present

Software & Systems support leader , SAVENCIA SERVICES EUROPE a.s.

Portfolio

View All
Since 22.10. I have been worked on a small application to display data from mettler (balances) with the possibility of selecting the period and time grouping ... 25.10. handed over for use
to date... • an application for customer complaints has been created (reprogrammed to the new version of the libraries). • the application for complaints against suppliers is being completed • anal...
• the project for complete redesign of the intranet in one branch in the Czech Republic ... the intranet requires the creation of an application for production planning, people, TRS / OEE, manageme...
I first joined a company that belonged to the parent company BONGRAIN, here were my beginnings of programming web applications .. first in PHP .. over time came the need to implement more and more ...

JS Framework

objects / libraries objects are based on the structure: function $name() { var ...; this.methodA = function() { }; this.methodB = function() { }; this.init = function() { }; this.init() }Possibly i...
Next basic thing is a universal trigger One single HTML file allowing to create a basic structure = layout of the displayed part, its dynamics, creating menus, working with "subpages" without page ...
The basis of the framework 2. As a basis, I needed to divide the workspace into several parts that will have different uses. This division must then accept a change in the size of the display area,...
framework requirements: - split desktop similar to the application - possibility to control the layout on the fly - show, hide, zoom in, zoom out - minimization of client-server communication durin...