freiberufler VBA Consultant auf freelance.de

VBA Consultant

offline
  • auf Anfrage
  • 60316 Frankfurt am Main
  • auf Anfrage
  • it  |  en
  • 11.01.2024

Kurzvorstellung

I have a 40+ year working experience, 25+ of which spent designing and developing VBA solutions in several countries (Afghanistan, Italy, DPRK, Ethiopia, Italy, Austria, Germany) for international entities (UN, CTBTO, European Central Bank)

Qualifikationen

  • Datenbankentwicklung
  • Microsoft Access
  • MS Excel
  • Software Design
  • VBA (Visual Basic for Applications)

Projekt‐ & Berufserfahrung

VBA Developer
European Central Bank, Frankfurt
8/2014 – 11/2019 (5 Jahre, 4 Monate)
Banken
Tätigkeitszeitraum

8/2014 – 11/2019

Tätigkeitsbeschreibung

Design and development of MS Office ad-hoc solutions, supporting the ECB's SSM mechanism. Quite often, I also acted as Business Analyst, collecting requirements from the stakeholders.

Eingesetzte Qualifikationen

Datenbankentwicklung, Incident Management, IT-Support (allg.), Microsoft Windows (allg.), MS Office (Anwenderkenntnisse), ODBC (Open Database Connectivity), Oracle (allg.), Software Design, SQL, User Interface (UI)

VBA Developer
ENEL, Rome
12/2012 – 12/2013 (1 Jahr, 1 Monat)
Versorgungswirtschaft
Tätigkeitszeitraum

12/2012 – 12/2013

Tätigkeitsbeschreibung

I developed several Excel sheets to automate Risk Management models. These models used Excel’s @Risk statistical plugin, which I had to automate through VBA to create a fully automated analytical system. User’s manual and Tech manual were part of the final deliveries.
I was also in charge for the requirement collection, for the final users’ training, for the deployment and for the post-delivery support.

Eingesetzte Qualifikationen

Microsoft Access, MS Excel, ODBC (Open Database Connectivity), Software Design, Softwarequalität, SQL, VBA (Visual Basic for Applications)

Data Migration Consultant
CTBTO, Wien
12/2011 – 4/2013 (1 Jahr, 5 Monate)
United Nations
Tätigkeitszeitraum

12/2011 – 4/2013

Tätigkeitsbeschreibung

Review of existing ICT systems to support current ERP-related processes. Support to data cleansing activities. Definition of new data formats required for migrating data into the new SAP platform. Design and development of VBA solutions for MS Office application integration and office automation.

Eingesetzte Qualifikationen

Datenbankentwicklung, Microsoft Access, MS Excel, ODBC (Open Database Connectivity), Software Design, SQL, VBA (Visual Basic for Applications)

VBA Developer
WFP, Addis Ababa
12/2008 – 12/2009 (1 Jahr, 1 Monat)
United Nations
Tätigkeitszeitraum

12/2008 – 12/2009

Tätigkeitsbeschreibung

1. Design of several databases to manage WFP activities in Ethiopia, and development with MS Access.
2. Design and development of a pilot web-based database to store and analyse security reports from all over the Country.
3. Analysis and optimization of WFP’s business flow
4. Design of a questionnaire to check knowledge and expertise of IT-related job candidates.

Eingesetzte Qualifikationen

Benutzerschnittstelle / Mensch-Maschine-Schnittstelle (MMS), Datenbankentwicklung, Microsoft Access, MS Excel, ODBC (Open Database Connectivity), Software Architektur / Modellierung, Software Design, VBA (Visual Basic for Applications)

VBA Developer
WFP, Pyongyang
8/2008 – 9/2008 (2 Monate)
United Nations
Tätigkeitszeitraum

8/2008 – 9/2008

Tätigkeitsbeschreibung

Design of a database, and development with MS Access, to store and analyse quantitative and qualitative data gathered by the Programme Officers during their monitoring missions.

Eingesetzte Qualifikationen

Application Development, Microsoft Access, Software Design, VBA (Visual Basic for Applications)

VBA Developer
WFP, Rome
9/2005 – 6/2007 (1 Jahr, 10 Monate)
United Nations
Tätigkeitszeitraum

9/2005 – 6/2007

Tätigkeitsbeschreibung

Design of an experimental database, developed with MS Access, within the CMEA project (Common Monitoring & Evaluation Approach), meant to act as a worldwide common platform to store WFP activity data, allowing detailed, reliable and homogeneous reports and statistics.

Eingesetzte Qualifikationen

Microsoft Access, MS Excel, Software Design, User Interface (UI), VBA (Visual Basic for Applications)

VBA Developer
WFP, Kabul
6/2003 – 12/2004 (1 Jahr, 7 Monate)
United Nations
Tätigkeitszeitraum

6/2003 – 12/2004

Tätigkeitsbeschreibung

Re-design of ACORD (Afghanistan Country Office Reporting Database), the database which tracked all WFP activities in Afghanistan, and design of the database used by the Human Resources Unit. Development with MS Access.

Eingesetzte Qualifikationen

Microsoft Access, MS Excel, Software Design, User Interface (UI), VBA (Visual Basic for Applications)

Ausbildung

Computer Science
Laurea (master's degree)
1997
Rome, Italy

Persönliche Daten

Sprache
  • Italienisch (Muttersprache)
  • Englisch (Fließend)
Reisebereitschaft
auf Anfrage
Arbeitserlaubnis
  • Europäische Union
  • Schweiz
Home-Office
bevorzugt
Profilaufrufe
152
Alter
58
Berufserfahrung
36 Jahre und 7 Monate (seit 09/1987)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden