Tool to send from scheduled reports
(Konsumgüter und Handel, 500-1000 Mitarbeiter)
Schlagwörter
Skills
SAP BI
MS SQL
PostgreSQL
MYSQL
Oracle
Data Warehouse
ERP SAP, AX Navision
Excel VBA
Python
E-Rechnung im XML-Format
MS SQL
PostgreSQL
MYSQL
Oracle
Data Warehouse
ERP SAP, AX Navision
Excel VBA
Python
E-Rechnung im XML-Format
Projekthistorie
01/2021
-
02/2021
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
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
(Konsumgüter und Handel, 1000-5000 Mitarbeiter)
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
(Konsumgüter und Handel, 1000-5000 Mitarbeiter)
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
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
Reisebereitschaft
Verfügbar in den Ländern
Deutschland, Österreich und Schweiz
