Fachlicher Schwerpunkt dieses Freiberuflers

Business Objects, Visual Basic, VBA and Excel development

verfügbar ab
31.07.2019
verfügbar zu
100 %
davon vor Ort
100 %
PLZ-Gebiet, Land

D6

Kontaktwunsch

Ich möchte bevorzugt für Projekte in diesen Einsatzorten kontaktiert werden.

Kommentar

Deutschland: Hessen bevorzugt

Position

Kommentar
  • Business Objects architecture and implementation including installation, clustering, universe and report development
  • Microsoft Office development and automation
    Quality Assurance and Testing

Projekte

04/2018 - Heute

1 Jahr 2 Monate

various projects

Kunde
Baltsch IT Consulting
Einsatzort
Frankfurt, Brussels, UK
Projektinhalte

After previous collaboration, invited to join this small IT consultancy to develop reporting and database solutions. Recent projects include - 

  • Data warehouse proof of concept design and build based on Microsoft Azure SQL database and Cosmos DB, leveraging both relational database and NoSQL design, PowerBI reporting frontend
  • For a financial client, designed Excel/VBA tool to automate multidimensional data aggregation from several sources including BO. Versioning/workflow code for multiple users to model concurrently
  • For a Central Securities Depository, developed tactical reporting solutions in Excel and VBA, Access, including reporting on mainframe DB/2, simulating multi-user aware tools in Excel/VBA
  • A financial client third-party database change broke billing reports but no budget or local skills were foreseen. Proposed and negotiated low impact solution, performed remedial work
  • For a health client database migration, resolved reporting system instability, created VBA-based automated audit tool for impact analysis of database changes. Amended Business Objects universes for database changed, created reports for new UK Government requirements
  • Business Objects complete universe and report design in BO XI R3 and BI 4

04/2017 - 03/2018

1 Jahr

Head of IT implementation of distributed ledger technology (DLT), blockchain-based playground and proof-of-concept environments

Kunde
European Central Bank
Projektinhalte

After a previous successful project, was invited to lead the IT implementation of Distributed Ledger Technology (DLT), blockchain-based playground and proof of concept environments. 

  • To investigate reliability and performance of a DLT network, the project needed to compare multiple DLT systems, across arbitrary distances, e.g. how does a two-node network with all components in Frankfurt perform, versus a two-node network between Frankfurt and Tokyo, versus a ten-location network, versus twenty locations, etc. These installations were completed manually, with significant effort.
  • Automated complete DLT system installation, including deployment of smart contract code, execution of tests and gathering results, and devised an automated method to simulate physical distance by injecting network latency between nodes, allowing significantly faster build times, and more tests across more simulated locations 
  • Design and build of a separate DLT network, hosted across Europe by several European institutions, including complete automation. Some institutions elected to install their own network node, co-ordinated their activity, network connectivity and testing
  • Design and build of a development environment for those institutions to write and test smart contract code, including pure internet browser-based access since many institutions’ security restrictions did not allow connecting directly to machines outside their own network, single sign-on within the environment

03/2015 - 03/2017

2 Jahre 1 Monat

develop the reporting strategy

Kunde
European Central Bank
Einsatzort
Frankfurt
Projektinhalte

Returned to the ECB to develop the reporting strategy for a risk management data warehouse, including data mart design, Business Objects universes and reports. 

  • Complete analysis of the business area regular and ad-hoc reporting requirements, along with the business processes leading to those requirements, advised the Business Area on reporting best practice, including translation from detailed technical specifications to clear language
  • Completed negotiation with the business area and IT management of timescales and resources, specification of the work organisation, including progress and issue tracking, for complete transparency with both the business area and IT management 
  • Definition of data mart design standards and end-to-end specification of data marts, including best practice design for subsequent exposure through Business Objects universes and ad-hoc querying 
  • Definition of database loading procedures and all technical documentation; lead technical workshops with the external ETL vendor, validated specifications provided by the vendor 
  • Business Objects BI4 universe and report design
  • Excel and VBA reporting automation

01/2011 - 03/2015

4 Jahre 3 Monate

various projects

Kunde
Baltsch IT Consulting
Einsatzort
Frankfurt, Brussels, UK
Projektinhalte

After previous collaboration, invited to join this small IT consultancy to develop reporting and database solutions. Recent projects include - 

  • Data warehouse proof of concept design and build based on Microsoft Azure SQL database and Cosmos DB, leveraging both relational database and NoSQL design, PowerBI reporting frontend
  • For a financial client, designed Excel/VBA tool to automate multidimensional data aggregation from several sources including BO. Versioning/workflow code for multiple users to model concurrently
  • For a Central Securities Depository, developed tactical reporting solutions in Excel and VBA, Access, including reporting on mainframe DB/2, simulating multi-user aware tools in Excel/VBA
  • A financial client third-party database change broke billing reports but no budget or local skills were foreseen. Proposed and negotiated low impact solution, performed remedial work
  • For a health client database migration, resolved reporting system instability, created VBA-based automated audit tool for impact analysis of database changes. Amended Business Objects universes for database changed, created reports for new UK Government requirements
  • Business Objects complete universe and report design in BO XI R3 and BI 4

06/2013 - 11/2013

6 Monate

multinational BO XI R3 migration

Kunde
UBS (Investment Banking)
Einsatzort
Zürich
Projektinhalte

25000-user multinational BO XI R3 migration. Invited back for audit programme reporting.

  • Negotiated and performed XI R3 migrations for 25 separate BO applications
  • During the migration, a critical incompatibility with Internet Explorer was noted. Found cause, interfaced directly with Microsoft and SAP for resolution, suggested amended project approach to keep within timescales and budget 
  • VBA with BO COM SDK tool development to automate BO administration tasks, Excel with VBA development for automated BO system audit reporting
  • VBA tool to automate Internet Explorer, to help with a complex, repetitive administrative task
  • MS Access database development for IT audit data, including automated import of new data, automated data validation and quality checking, automatic dashboard generation, trend analysis

03/2012 - 12/2012

10 Monate

multinational BO XI R3 migration

Kunde
UBS (Investment Banking)
Einsatzort
Zürich
Projektinhalte

25000-user multinational BO XI R3 migration. Invited back for audit programme reporting.

  • Negotiated and performed XI R3 migrations for 25 separate BO applications
  • During the migration, a critical incompatibility with Internet Explorer was noted. Found cause, interfaced directly with Microsoft and SAP for resolution, suggested amended project approach to keep within timescales and budget 
  • VBA with BO COM SDK tool development to automate BO administration tasks, Excel with VBA development for automated BO system audit reporting
  • VBA tool to automate Internet Explorer, to help with a complex, repetitive administrative task
  • MS Access database development for IT audit data, including automated import of new data, automated data validation and quality checking, automatic dashboard generation, trend analysis

03/2004 - 12/2010

6 Jahre 10 Monate

develop the reporting strategy

Kunde
European Central Bank
Einsatzort
Frankfurt
Projektinhalte

Returned to the ECB to develop the reporting strategy for a risk management data warehouse, including data mart design, Business Objects universes and reports. 

  • Complete analysis of the business area regular and ad-hoc reporting requirements, along with the business processes leading to those requirements, advised the Business Area on reporting best practice, including translation from detailed technical specifications to clear language
  • Completed negotiation with the business area and IT management of timescales and resources, specification of the work organisation, including progress and issue tracking, for complete transparency with both the business area and IT management 
  • Definition of data mart design standards and end-to-end specification of data marts, including best practice design for subsequent exposure through Business Objects universes and ad-hoc querying 
  • Definition of database loading procedures and all technical documentation; lead technical workshops with the external ETL vendor, validated specifications provided by the vendor 
  • Business Objects BI4 universe and report design
  • Excel and VBA reporting automation

12/2004 - 05/2005

6 Monate

various projects

Kunde
Baltsch IT Consulting
Einsatzort
Frankfurt, Brussels, UK
Projektinhalte

After previous collaboration, invited to join this small IT consultancy to develop reporting and database solutions. Recent projects include - 

  • Data warehouse proof of concept design and build based on Microsoft Azure SQL database and Cosmos DB, leveraging both relational database and NoSQL design, PowerBI reporting frontend
  • For a financial client, designed Excel/VBA tool to automate multidimensional data aggregation from several sources including BO. Versioning/workflow code for multiple users to model concurrently
  • For a Central Securities Depository, developed tactical reporting solutions in Excel and VBA, Access, including reporting on mainframe DB/2, simulating multi-user aware tools in Excel/VBA
  • A financial client third-party database change broke billing reports but no budget or local skills were foreseen. Proposed and negotiated low impact solution, performed remedial work
  • For a health client database migration, resolved reporting system instability, created VBA-based automated audit tool for impact analysis of database changes. Amended Business Objects universes for database changed, created reports for new UK Government requirements
  • Business Objects complete universe and report design in BO XI R3 and BI 4

Projekthistorie

For brevity, only clients in the last five years are shown. Further details available on request

Branchen

  • Europäische and Staatliche Institutionen
  • Banken
  • Investition Banken
  • Versicherungen
  • Regierung
  • Wohlfahrt

Kompetenzen

Programmiersprachen
Basic
Delphi
Erweiterte Grundkenntnisse
Java
Java Server Faces
JavaScript
Erweiterte Grundkenntnisse
Lotus Notes Script
Makrosprachen
VBScript, Windows Scripting Host
Perl
Erweiterte Grundkenntnisse
RAMIS II
Grundlagen
Rexx
Erweiterte Grundkenntnisse
Scriptsprachen
VBScript, WSH, Kix32
Shell
Erweiterte Grundkenntnisse
SQL
XML

Betriebssysteme
Amiga OS
MS-DOS
Novell
OS/2
SUN OS, Solaris
Gutekentnisse
Unix
Windows
Windows CE

Datenbanken
Access
Business Objects Data Integrator
DB2
Grundlagen
JDBC
Grundlagen
MS SQL Server
Erweiterte Kenntnisse
ODBC
Oracle
8, 10g
SQL

Sprachkenntnisse
English
mother tongue
German
intermediate
Spanish
basic

Hardware
Amiga
Ascii/X - Terminals
Atari
Bus
CD-Writer / Brenner
Drucker
HP
Emulatoren
HP
Modem
PC
Soundkarten
SUN
Erweiterte Grundkentnisse
Video Capture Karte

Datenkommunikation
Ethernet
Internet, Intranet
LAN, LAN Manager
NetBeui
NetBios
Novell
Router
SNMP
TCP/IP
Token Ring
Windows Netzwerk
Winsock

Produkte / Standards / Erfahrungen

Profile

  • Developer of reporting, data and automation solutions, recent work in central banking, investment banking and risk management environments
  • Enjoys challenging environments, identifying and negotiating solutions, bridging the gap between requirements and constraints, while integrating with existing processes
  • Fifteen years’ experience managing small teams and projects, devising strategy, with most projects resulting from repeat requests

Recent Achievements

  • Design and build of a Europe-wide Distributed Ledger Technology network, including end-to-end installation automation, for several european institutions to investigate this new technology
  • Complete design of Risk Management data marts for a european institution, including negotiation for implementation with third party IT provider
  • Microsoft Azure-hosted data warehouse proof of concept, including Azure SQL DB, Cosmos DB, NoSQL design patterns, with Power BI reporting front-end
  • WinAPI/VBA tool for UI to retrieve, parse data from web services, for any MS Office application
  • Complex data validation processing and reporting, automated, for regulatory reporting

Schwerpunkte
  • SAP Business Objects design and reporting, in BO 6.5 - BI4, Universe and report creation, system deployment including end-to-end automation
  • Database and data warehouse design, based on Oracle and Microsoft SQL Server, SQL performance tuning, basic stored procedure development in PL/SQL
  • Expert Microsoft Visual Basic and Office development, focused on advanced Excel coding for process automation, data aggregation, analysis and dashboards
  • ADO and DAO, COM automation, WinAPI usage, Basic C# .Net and Java development
  • Advanced Windows and Unix scripting and automation including PowerShell, DOS batch, Bash
  • Full-lifecycle design - help define requirements, help plan how to meet them, development, user testing, acceptance design and management, production implementation and support

Ausbildungshistorie

  • Microsoft Active Directory Implementation
  • Microsoft Active Directory Application Deployment
  • Microsoft Operations Manager
  • Microsoft ISA Server
  • Visual Basic City and Guilds Levels 1 and 2
  • Lotus Notes 4.5 administration and design
×
×