Karsten Held

C# & Web Developer SharePoint Specialist, Freelancer & Contractor

I'm a freelancer and contractor with over 15 years of work experience. Starting with Visual Basic in 1998, I worked with C#, Java, and JavaScript. I focus on the MS Office 365 / SharePoint stack. I help my customers with the migration and integration issues of the Office 356 / SharePoint platform. If required, I build mobile apps and intranet solutions that connect internal systems, different departments and external partners. My area of expertise is business process automation, process optimization and data integration across company and department borders. To achieve first-class modern solutions I also use state-of-the-art open source frameworks. I'm also an Excel and VBA expert.

Work

M-OnSite mobile app

A mobile app for iOS and Android, that helps keeping track of checklists while setting up speaker rooms for congresses. The app is loaded via a QR code and the AppGyver Scanner and works also offline. When online, the checklists status is synched with a server. The project manager overlooks the setup status on his iPad and gives orders via chat.

The solution runs with a SharePoint backend so that all data is also available on the companies intranet.

Created with HTML5/JS/CSS3 using the AppGyver Framework based on Steroids/Cordova.

Client Information

CryptoXL

The goal of the project was to create an end-to-end data encryption for SharePoint. Data is stored in encrypted form within SharePoint and is only de- or encrypted on the client computer using JavaScript for the Web Front-End and VBA for the Excel Front-End.

For the Excel client an AES256 de- and encryption had to be implemented that is 100% compatible to the Crypto.JS JavaScript library.

Client Information

Mobile timesheets with Excel

The goal was to allow the employees to use Excelsheets on their mobile Android tablets to keep track of their worktime and activities. These filled-out sheets are saved on a central Dropbox in the cloud.

The data is imported and reviewed on a daily basis using an Excel Mastersheet. At the end of the month, work data is exported to for the tax advisor company.

Client Information

M Events Intranet

In the beginning of 2015 the SharePoint based intranet of M Events was restructured. A SharePoint branding package was created and deployed. Several apps where developed using SharePoint lists and workflows.

Bencer Web 2010

Client Information

Bencer Project Management, a private owned enterprise, is one of the leading German project management consultants in China.

FUTOP ID Generator

This Excel-based solution was created to provide every future and option that can be traded at international exchanges with an Identifier not unlike the ISIN for stocks.

Thanks to this solution, a fully automated inventory import and check could be implemented for over 20 funds operating across more than 7 banks and financial institutions.

Client Information

Vescore is an asset management boutique based in Munich.

Quick Inventory Check

This Excel-based solution helps a fund manager to quickly check the inventory of dozens of funds. Its simple traffic-light system helps tracking down inventory differences between the investment company and the trading bank.

It features a fully automated inventory and fill import from mailboxes (mails), websites, Excelsheets, CSV, PDF and other formats.

The solution was created in Excel using a custom Add-In. The import is programmed in AutoIt3, a popular task automating langauge.

Client Information

Vescore is an asset management boutique based in Munich.

TODI Attachment Saver

This Microsoft Outlook Add-In saves attachments to disk and compacts your Outlook PST file. It leaves a link at the bottom of every mail aith attachments.

It was programmed in Visual Basic 6 and uses the Outlook COM Add-In API.

Client Information

Osyon Task Management Tool

The goal was to design a simple groupware tool that is cloud-based and helps employees manage and communicate activity on tasks.

Client Information

OSYON is an IT service provider based in Berlin.

Open Data Web Application

The goal was to design a website that stores linked tabled. Those tables can be linked from the web and joined together to gain new results.

Client Information

OSYON is an IT service provider based in Berlin.

Services

Application Development

Application design, prototyping and programming using C#, JavaScript, WPF/XAML and WinForms. Office 365 Apps in the cloud (Office365 App Model) or local Office Solutions using VSTO/COM Add-Ins or VBA.

SharePoint Solutions

Design, configuration and rollout of SharePoint solutions. WebPart and App Development in C# and JavaScript. Integration with other LOB solutions. Upgrading of MS Access and ASP.NET solutions.

Mobile Development

Mobile Business Apps for iOS and Android using the AppGyver Framework with HTML5/JS/Cordova under the hood. Apps are downloaded via a scanned QR code using the AppGyver scanner app or can be published to the official App Stores.