Nikolaus Jäger-Grassl
Data Magician
Erfahrungen
Data Magician
CECIL
Developed a solution leveraging Salesforce Marketing Cloud's WhatsApp integration, enhanced with custom automations, journeys, SSJS scripts, and a supplementary Azure app. This innovative approach allowed CECIL to send out WhatsApp channel invitations to their email list. Accepting the invitation through a QR code or link automatically linked the customer's phone number with their email address in Sales Cloud. This ensured a seamless data sync, creating an omnichannel view of the customer. The system also accommodated public sign-up links on platforms like Facebook, significantly widening CECIL's engagement reach and streamlining customer communication while enriching their overall data insights.
Data Magician
CEWE Fotobuch
Facilitated the integration between Salesforce Data Cloud and Marketing Cloud. Optimized the use of Salesforce's built-in connector to streamline data flows and ensure that the most relevant, actionable insights were at the marketing team's fingertips. This strategic approach transformed their data into a dynamic asset, enabling targeted marketing campaigns that resonated deeply with customers and significantly improved engagement.
In a separate project, engineered a Server-Client Framework utilizing Typescript, React, and Salesforce's SOAP and REST APIs for launching Salesforce Marketing Cloud across 100 countries and franchise parties. The framework enabled nearly full automation of the rollout process with an automation rate of about 95%. Developed a suite of multi-tenancy web apps, allowing for customized functionalities tailored to the unique requirements of different stakeholders. This comprehensive solution streamlined the deployment process and empowered CEWE Fotobuch to maintain and enhance their marketing operations globally, with minimal external support.
Data Magician
Dr. Ausbüttel
Implemented Salesforce Marketing Cloud and Data Cloud as greenfield projects. This integration leveraged data from Salesforce Cloud sources, legacy CRM and ERP systems, and website behavior data. The implementation enabled the use of multiple communication channels, including email, SMS, WhatsApp, app push notifications, custom fax journey activities, and print. Optimized data flows and ensured seamless integration of diverse data sources. Utilized Salesforce's built-in connectors and custom solutions to provide actionable insights and enable precise targeting. This strategic implementation transformed Dr. Ausbüttel's data into a valuable asset, supporting highly personalized marketing campaigns and significantly enhancing customer engagement.
Data Magician
Egger OG
After one year of requirements engineering, identifying data sources and reflecting the current fragmented architecture in design documents, designed an on-premises Data Warehouse hosted in MS SQL-Server Enterprise Edition, replicated across multiple failover clusters with high availability. The design pattern concludes of three layers, a few dozens of data sources and a SQL Server Analysis Tabular Cube for reporting and Data Analytics purposes. During implementation, migrated a handful of Reports from SSRS to Power-BI, as most reports will be migrated by the customer itself.
Data Magician
VTU engineering
Took over the project to build an Enterprise Data Warehouse (EDW), migrate all relevant reports to Power-BI, and create new sophisticated dashboards for each department. Maintained, improved, and refactored current stored procedures, functions, pipelines and reports as well as built the required Azure infrastructure. Implemented several dozen data sources (SQL-Server, Azure SQL, MS Dynamics, Salesforce, API), some cloud based, most of them on premise, scattered across Europe. The implementation followed a two layered DWH concept, implemented in Synapse Analytics and Azure Analysis Services on top. Kept reports alive during migration and then replaced them with Power-BI. Completed the implementation of the most important parts in a few months. In addition to the DWH itself, leveraged several use cases for automating daily processes in different departments.