Profileimage by Peter Schmidt Developer from Worms

Peter Schmidt

available

Last update: 13.01.2017

VBA Developer

Company: KIB-IT Peter Schmidt IT-Beratung
Graduation: not provided
Hourly-/Daily rates: show
Languages: German (Native or Bilingual) | English (Full Professional)

Attachments

aviva-saradump.docx
eib-gems.docx

Skills

09/2008                  CEO / Developer, KIB-IT Peter Schmidt IT-Beratung, Worms, Germany
  • Software Development (MS-Access, MS-Excel, VBA, VisualStudio, C#)
  • IT Development
  • Defining and providing IT solutions for clients
  • Software, Hardware & Networks
  • Customer service & management
 
01/2008 – 08/2008   Freelancer
  • Developer (MS-Access, i-System GmbH, Osthofen, Germany)
  • Administrator (Windows-Network)
    •  i-System GmbH, Osthofen, Germany
    • KHB-Handel, Guntersblum, Germany
    • SDS, Worms, Germany

08/2001 – 12/2007   IT-Consultant, i-System GmbH, Osthofen, Germany
  • Developer (AS/400 - DB2, MS-Access, WinDev, MS-Excel)
  • Administrator (Windows-Network)
  • Customer training
MS Office
MS Access
MS Excel
VBA
.NET
VB
C#
SQL-Server
MySQL

Project history


Projects

MS-Access:                 

09/2015                  Volkswagen Financial Services (Bank), Braunschweig, Germany
                              AIM – Project (Access Identity Management)                          
                              AIM Management Software incl. approval workflow
 
                              Access 2013 / VBA, Excel, Oracle, SQL, Oracle SQL Developer, SQuirreL

05/2015 – 06/2015   WIGOL GmbH (Chemical industry), Worms, Germany
                              GS1-EAN 128 Label printing Software (checksum calculation, generating label incl. barcodes)
 
                              Access 2013 / VBA, SQL, DB2
 
03/2015 – 05/2015   DESTAG GmbH (natural stone products), Reichenbach, Germany
                              Ticket-System, (Collecting Data from Firebird)
 
                              Access 2010 / VBA, ODBC, SQL, Firebird, Binary
 
10/2012 – 12/2013  Samulewitz (natural stone products), Rheinbach, Germany
                             ERP, PPS, CRM, POS, EDI and billing (Google geocoding API)
                                        
                             Access 2010 / VBA, SQL , API
 
02/2012 – 08/2012  EIB (investment bank), Luxembourg, Luxembourg
                             GEMS Database enhancement (risk management) validation template rebuild, created various excel applications.
 
                             Access 2003 / Excel 2003, VBA, SQL
 
04/2010 – 07/2010  AVIVA Inverstors (asset manager), Luxembourg, Luxembourg
                             Software interface, data im- and export, data validation, reporting (SQL)
                                        
                             Access 2003 / Excel 2003 / VBA, SQL
 
03/2009 – 04/2009  DESTAG GmbH (natural stone products), Reichenbach, Germany
                             Export delivery status (Data exchange ERP-System, Data export to MySQL database via FTP using PHP files.)
                             Online delivery status (PHP data access MySQL database incl. logon-function)
                             Used xampp (Windows) for local testing purposes!
 
                             Access 2003 / VBA, ODBC, SQL, MySQL, PHP, xampp
 
01/2009 – 02/2009  DESTAG GmbH (natural stone products), Reichenbach, Germany
                             Offline Stock book (Offline data recording incl. pictures with MS-Access,
                             Data export to MySQL database via FTP using PHP files.)
                             Online stock book (PHP data access MySQL database incl. logon-function)
                             Used xampp (Windows) for local testing purposes!            
                                        
                             Access 2003 / VBA, ODBC, SQL, MySQL, PHP, xampp
 
02/2008 – 10/2008  Dalbergerhof Strauch (Winery), Osthofen, Germany
                             Webbased POS System for 16 branches (Online data transfer AS/400, daily
                             Updated prices and offers, debit cards, every information available in every branch (customers, sales etc.)
 
                             Access 2003 / VBA, ODBC, SQL
                                        
01/2003 – 04/2003  Zimmermann Tankschutz GmbH (Oil tank cleaning), Mannheim, Germany
                             Ordersoftware for external sales staff (Customer data collection, creating offers, change offers to orders, data                                  transfer AS/400)
                                     
                             Access 2000 / VBA, ODBC, SQL, DB2, RPG
 
08/2001 – 10/2001  FOX-Filling-Service-GmbH (Chemical bottlings), Weinheim, Germany
                             GS1-EAN 128 Label printing Software (Collecting Data from AS/400, checksum
                             calculation, generating label incl. barcodes, data transfer AS/400)
                                        
                             Access 2000 / VBA, ODBC, SQL, ZPA, DB2

SQL:                                
                                        
08/2015 - 09/2015   M. M. Warburg & CO, Luxembourg, Luxembourg
                             Transaction Reporting
 
                             SQL, Oracle, IBSY (TOAD for Oracle)
 
Java:
 
01/2015 – 03/2015  DESTAG GmbH (natural stone products), Reichenbach, Germany
                             Migrated stock book to Android-Devices for external sales staff.
 
                             Java
 
MS-Visual Studio:
                                        
01/2014 – 10/2014  PCP (Clinic for physiotherapy), Worms, Germany
                             ERP, CRM and billing (reading health insurance cards, automated invoice and
                             dunning run, scanning and mapping of x-rays)
                                        
                             VisualStudio C# & MS SQL, SQL
 
WinDev:
                                        
10/2001 – 10/2002  Herrmann & Laux (Temporary employment agency), Ludwigshafen, Germany
                             HR Software (Planing, management and accounting)
 
                             WinDev

Local Availability

Only available in these countries: Germany, Austria und Switzerland
International
Profileimage by Peter Schmidt Developer from Worms VBA Developer
Register