Upgrade Post project
Profileimage by Anonymous profile, BI Manager , SQL Datawarehouse, SAP BI, VBA, Python, E-Rechnung im XML-Format
Nettetal
partly available

Last update: 17.01.2024

BI Manager , SQL Datawarehouse, SAP BI, VBA, Python, E-Rechnung im XML-Format

Graduation: Industrie Meister
Hourly-/Daily rates: show
Languages: German (Native or Bilingual) | English (Full Professional)

Keywords

Attachments

PeterHoegel-DE_070823.pdf

Skills

SAP BI 
MS SQL 
PostgreSQL
MYSQL
Oracle
Data Warehouse
ERP SAP, AX Navision
Excel VBA
Python
E-Rechnung im XML-Format

Project history

01/2021 - 02/2021
Tool to send from scheduled reports
(Consumer goods and retail, 500-1000 employees)
User can configure the setup for each report. Setup is saved on database. Reports can have multiple data sources.
Excel Report can have multiple sheets.
Output: Excel Text or HTML Reports
Report destination:  Email, FTP or sFTP
Email body can contain SQL data formated as table.
Setup tool Excel
Send reports was realized with python
10/2020 - 01/2021
Build Excel reporting Tool VBA + SQL
(Consumer goods and retail, 1000-5000 employees)
Build Excel reporting Tool VBA + SQL. Tool with table or field based security. User can select tables and fields and define user filters. User can select multiple reports to create a new  Excel report.User can add Pivote tables and formulas. Report can be updateed dynamicly. Base on securety settings, different users will see specific data in the same report.
03/2020 - 09/2020
Build data warehouse for Accounting
(Consumer goods and retail, 1000-5000 employees)
Build MS-SQL Data Warehouse
Auto Load from sources: SAP reports, SAP-BI ExcelFiles, Salesforce REST API, OpehHab exports, Oracle database.
Tools to convert and load data: Python
Reports in Excel by using VBA to load data.
Used Excel + VBA to read and write Parameter files to SQL

Local Availability

Only available in these countries: Germany, Austria und Switzerland
Profileimage by Anonymous profile, BI Manager , SQL Datawarehouse, SAP BI, VBA, Python, E-Rechnung im XML-Format BI Manager , SQL Datawarehouse, SAP BI, VBA, Python, E-Rechnung im XML-Format
Register