Database applications | Data analysis | Reporting | Programming | Access, .NET, VBA, Excel, SQL

• Stand-alone database applications in the Access VBA and MS SQL environment, precompiled solutions running with free Access Runtime engine
• Projects based on Excel sheets currently used by the customer
• Compiled programs Windows .NET / C#, that significantly increase data security, speed and reliability
• Online databases accessible as web sites on the LAN or Internet (ASP.NET applications)
• Applications development for offices, sales departments, warehouse management, inventory management systems, order management, programs for calculating the demand of raw material, production planning, financial applications, service support, customer registration, schedules, transport management databases, CRM etc.
• Automation of business processes (e.g. loading data from files or from a database, consolidation, analysis, visualization, reporting, mailing)
• Modules for converting and importing / exporting data, creating summaries, reports, generating pivot tables and dynamic charts based on information collected from many different files and data sources (SQL databases, text files, csv, Excel, XML, webservices, API interfaces, SOAP, MQTT, IoT devices etc.)
• Specialized MS Office VBA macros, functions, automations, COM extensions etc.
• Multi-user applications connected to SQL databases (client-server)
• Label printing solutions, generating and reading barcodes

Experienced freelance developer

• Analysis, presentation and reporting of data collected with PLC industrial automation modules etc.
• Integration of new solutions with programs, files and documents used currently by the customer
• Desktop and web forms for entering data in an organized and controlled way
• File database programs that run without external database server installation
• Programming of other applications according to the customer's needs / description of functionality