My picture

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.

Download CV

Work

M-OnSite

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

M Events provides project management and state-of-the-art technology for congresses and events.

Visit Homepage
M Events Projects

Project management solution for SharePoint

The solution allows project managers at M Events to create and archive their projects and was created using SharePoint lists and workflows.

To make the data available offline, an Excelsheet has been created that gets its data from SharePoint.

Client Information

M Events provides project management and state-of-the-art technology for congresses and events.

Visit Homepage
CryptoXL

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.

Technologies used: HTML5/JS with AngularJS, VBA with Crypto.js and VBA-WEB.

Client Information

WhizzyTools creates Apps & Tools for Microsoft Office and SharePoint.

Visit Homepage
Carl GmbH

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

The CARL GmbH runs several guest houses in Munich.

Visit Homepage
M Events Intranet

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.

Client Information

M Events provides project management and state-of-the-art technology for congresses and events.

Visit Homepage
Excel Time Tracking

Excel Time Tracking

A complete time tracking solution in Excel. Designed for individuals and small teams. Fully extendable, runs in 22+ languages. Includes a mastersheet that aggregates the team members worktime data.

The solution runs in high security environments because it is 100% plain Excel, without macros and Add-Ins.

Client Information

WhizzyTools creates Apps & Tools for Microsoft Office and SharePoint.

Download
DesktopTracker

DesktopTracker Design & Programming

Design and programming of a web application with focus on usability. The design takes into account various UX features of the Vaadin framework.

The application was implemented in Java. The final results are remarkably close to the original design.

Client Information

Avalain is a small startup company based in Budapest, HUNGARY.

Portfolio Monitor

Position Keeping Solution

The Portfolio Monitor was developed for several years. It is a position keeping tool for hedgefunds and overlays trading derivatives like futures, options and fx fowards.

It features the real-time valuation of positions, Value-At-Risk calculations, trading, future roll assistants, inventory checks, and an instrument database.

It has been developed entirely in C#, using the .NET Framework 3.5 and uses the Bloomberg Terminal API (.NET and COM)

Client Information

Vescore is an asset management boutique based in Munich.

Download Reference Card

Market Navigator

Market Navigator

The goal was to create an easy-to-use application that visualizes global return forecasts based on a risk factor model.

It was programmed in Java and delivered from a server via Java WebStart. The database and calculation engine were accesses via SOAP.

Client Information

Vescore is an asset management boutique based in Munich.

Download Reference Card

Download Specification (Partial)

Factsheet Engine

Factsheet Engine

The goal was to create an Excel-based calculation and visualization tool that can be used to semi-automatically create monthly fund factsheets.

Client Information

Vescore is an asset management boutique based in Munich.

Bencer Web 2012

Bencer Web 2012

Relaunch of website with focus on mobile and high-resolution devices. The website was tested on 12+ browsers.

The menu functionality was programmed in JavaScript.

Client Information

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

View Online

Bencer Construction Web 2011

Bencer Construction Web 2011

Webdesign and programming of a website for Bencer's new 'Construction' division.

A custom-made slider box at the right hand side was programmed in JavaScript.

Client Information

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

View Online

Bencer Web 2010

Bencer Web 2010

Design and programming of the company website.

Client Information

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

FUTOP ID Generator

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.

Inventory Check

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

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.

WhizzyTools CD Manual

WhizzyTools Corporate Design Manual

Corporate Design Manual for WhizzyTools.com: Logos, Icons, Color Themes and Fonts.

Client Information

WhizzyTool.com develops Apps for Microsoft Office.

View on Behance
Bencer CD

Bencer Corporate Design

Corporate design toolkit consisting of company logo and several design elements.

Client Information

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

Bencer Flyer

Bencer Services Flyer

Design of a 12 page flyer that features the companies services. Made using Adobe Illustrator.

Client Information

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

Download
Osyon 1

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.

Osyon 1

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.

Web Design & Development

Responsive websites using HTML5, JavaScript, CSS3, ASP.NET, MVC4, JQuery and frameworks (Bootstrap, Foundation, Ember, Knockout, AngularJS). Complete Web-Design.

Experience

  • Now

    • timeline photo

      JUL 2019 - DEC 2020

      Freelance SharePoint Consultant @ Vattenfall, Berlin

      SharePoint Online & Office 365 administration, 3rd level support, development & implementation of governance guidelines, reporting on tenant level, SharePoint training (Videos & OnSite).

    • timeline photo

      Sep 2017 - Jun 2018

      Freelance Developer @ Deutsche Post DHL Group AG, Bonn

      Maintenance, development and performance improvement of Excel/VBA/SharePoint solution for Information Security Self Assessment (ISSA) and internal reporting.

    • timeline photo

      Sep 2016 - Apr 2017

      Freelance SharePoint Consultant @ Orbit GmbH, Bonn for Telekom Digital Division

      UX Design / Programming of Product Inventory System. Development of SharePoint site provisioning solution (Provider Hosted App, CSOM, C#, ASP.NET).

    • timeline photo

      Oct 2015

      Freelance Software Architect @ m|events, Munich

      Development of a mobile app (iOS & Android) that enables the use of mobile onsite checklists for the setup of congresses with SharePoint backend.

      View Project
    • timeline photo

      Sep 2015

      Freelance SharePoint Consultant @ AUC Akademie der Unfallchirurgie GmbH, München

      Initial rollout of SharePoint with migration of existing fileshares to Office 365 / SharePoint Online.

    • timeline photo

      Jun 2015 - Aug 2015

      Freelance SharePoint Consultant @ m|events, Munich

      Development of a project management tool for SharePoint/Office365 using workflows. Creation of a cloud-synced Excel solution for offline scenarios.

      View Project
    • timeline photo

      May 2015

      Freelance Developer @ WhizzyTools, Dresden

      Development of End-To-End AES256 encryption solution with SharePoint backend for Web-Apps and Excel-based solutions using Crypto.js and VBA-WEB.

      View Project
    • timeline photo

      Apr 2015

      Excel Consultant @ Carl GmbH, Munich

      Development of Excel-based Solution for mobile time reports with Android tablets and export for tax advisor.

      View Project
    • timeline photo

      Jan 2015 - Mar 2015

      SharePoint Consultant @ m|events, Munich

      Structuring and redesign of the intranet with Office 365 / SharePoint Online.

      View Project
    • timeline photo

      May 2014 - Jun 2014

      Freelance Excel Consultant @ WhizzyTools.com

      Design and development of an Excel-based time tracking solution.

      View Project
    • timeline photo

      Jan 2014 - Feb 2014

      Freelance Designer

      Corporate Design Manual for WhizzyTools.com: Logos, Icons, Color Themes and Fonts.

      View Project
    • timeline photo

      Jan 2013 - Dec 2013

      Freelance Front-End Designer/Developer @ Avalain, Budapest

      UI design and programming of DesktopTracker in Java using Vaadin framework.

      View Project
    • timeline photo

      Jun 2012 - Dec 2012

      SharePoint Consultant @ Communardo, Dresden

      Design, specification and customization of large-scale SharePoint intranets for customers like Axel Springer AG and Voestalpine Group.

    • timeline photo

      Jan 2012 - Mar 2012

      Freelance Web Designer/Developer @ Bencer, Shanghai

      Refresh of corporate design and redesign of website with focus on mobile and high-resolution devices.

      View Project
    • timeline photo

      Oct 2011 - Nov 2011

      Freelance Software Architect @ Osyon GmbH, Berlin

      Design and prototyping of a cloud-based task management utility.

      View Project
    • timeline photo

      Apr 2011 - Jun 2011

      Freelance Software Architect @ Osyon GmbH, Berlin

      Concept for an open cloud-based table storage and joining website.

      View Project
    • timeline photo

      Feb 2011 - May 2011

      Freelance Web Designer/Developer @ Bencer, Shanghai

      Webdesign and programming of a website for Bencer's new 'Construction' division.

      View Project
  • 2010

    • timeline photo

      Nov 2010 - Dec 2010

      Freelance Designer @ Bencer, Shanghai

      Design of a flyer that features the companies services.

      View Project
    • timeline photo

      Jan 2010 - May 2010

      Freelance Web Designer/Developer @ Bencer, Shanghai

      Design and programming of the company website. Development of an automated photo upload tool.

      View Project
    • timeline photo

      Mar 2009 - Apr 2009

      Freelance Developer @ financial.com, Munich

      Customization of a custom Excel Add-In (VBA) that retrieves data from a Thomson Reuters terminal.

    • timeline photo

      Nov 2009 - Jan 2010

      Freelance Software Architect @ Vescore, Munich

      Design and specification of the next generation portfolio management tool.

    • timeline photo

      Aug 2006 - Aug 2008

      Head of Application Services & Support @ Vescore, Munich

      Design & programming of portfolio management tools in C# (WinForms) and Excel (C#, C++, VBA).

      View Project
    • timeline photo

      Jan 2004 - Jul 2006

      Junior Portfolio Manager @ Vescore, Munich

      Management of 4 global investment funds. Development of several Excel-based trading-tools using a Bloomberg Terminal.

  • 2004

    • timeline photo

      Jan 2001 - Dec 2003

      Developer @ vescore.com

      Design & programming of a web-based Java (Swing, WebStart) application that visualizes complex model data.

      View Project
    • timeline photo

      Mar 2000 - Dec 2000

      Developer @ Dr. Grob & Partner, Winterthur

      Prototyping of a bridge and tunnel management system based on the swiss bridge and tunnel database in Visual Basic.

  • Want to know more?
    Download CV

Contact

Karsten Held
Rothenburger Strasse 32
D-10099 DRESDEN

+49 176 70861679
karstenheld3@gmail.com