Accomplished MS SQL database and BI specialist with a successfull track record in creating and implementing analysis tools as well as training people in MS SQL and analytical tools.
MS SQL, T-SQL, PowerBI, PowerApps, SSIS, SSAS, D365, AZURE
Experienced business coach
Good communication skills
Ability to study – continuously qualifications raising in accordance with current needs
English – B2
Polish – fluent (mother tongue)
Conducting comprehensive implementation projects, processes and requirements analysis, system functionalities configuration and adjustment.
ROLES IN THE PROJECTS
Designer / Analyst / Lead consultant / Programmer
- Worked on the Power App using the Dataverse platform and migrated existing marketing dashboards for new data sources.
- Solution building in areas of sales, financial controlling and warehouses. Also in SSIS packages for ETL purpose and Power BI models and reports for final users.
2019 – 2021
RETAIL / MARKETING
- International projects for leading manufacturer and producer of hearing aids Work on defining and building Power BI reports and dashboards for marketing and sales analysis
- Building of Data Warehouse modeling based on data from D365 F&O and D365 CE & Marketing
- Additional worked on building D365 entities for access to cloud data of D365 F&O.
In the legal service department, the structure of the database was created.
Created tools for data migration processes. Creating reports with SSRS – e.g. a legal opinion printout, summaries for example annual, quarterly, monthly according to specific parameters.
The central customer database (in accordance to the RODO rules)
Created the structure of the database. Creating procedures for ETL processes.
ETL. Created procedures collecting data from source systems into Stage Database.
MS SQL Databases – the biggest table over 6 billion records.
Databases of Firebird, Oracle, Excel, Csv.
Created the Stage Database structure.
Created the rules of incremental data loading.
Created principles of metadata for loadings to the Warehouse from the Stage database. Creating SSIS solutions.
- Indicator analysis system. Created Data Warehouse –data collecting from 3 firms and aggregated.
- Created indicator analysis according to finance data – basic dimensions were: client type, production order type, product type.
- Created sales analysis.
- Created reports and analysis – SAP Crystal Reports.
- Created dashboards – PowerBI