Apr 2019 – Oct 2019

Office Add-ins + Azure AD ↔ AWS Cognito Identity Federation

FlowFact GmbH · Backend Engineer

3

Office Apps

2

Cloud Providers

SSO

Cross-Cloud Auth

0

Context Switches

Growth & Stability

~60%

API Response Time Reduced

30+

Manual Workflows Eliminated

1000s

Real-time Synced Users

Overview

At FlowFact GmbH, I developed Microsoft Office add-ins integrated with CRM systems, while implementing cross-cloud identity federation between Azure Active Directory and AWS Cognito. The solution enabled seamless access to CRM data within Office applications with secure, unified authentication.

The Problem

Users had to switch between CRM and Office tools

No seamless access to CRM data within Office applications

Complex authentication across Azure and AWS ecosystems

Lack of unified identity management

Security risks in handling cross-platform authentication

The Solution

Developed Office add-ins for Outlook, Word, and Excel

Integrated CRM data directly within Office workflows

Implemented Azure AD ↔ AWS Cognito federation using OAuth/OIDC

Built secure API communication with token-based authentication

Designed unified identity experience across platforms

Architecture

Core Components

Office Add-ins (Office JS API)CRM backend services (AWS-hosted APIs)Identity federation layer (Azure AD + AWS Cognito)Secure API gateway with token validation

Technical Design

OAuth 2.0 / OpenID Connect flows
Token exchange between Azure AD and Cognito
Role-based access control across systems
Secure API calls using short-lived tokens
AWS (Lambda, RDS, S3, IAM)
Azure Active Directory for identity
CloudFormation for infrastructure

My Role: Backend Engineer & Solutions Architect

01

Developed Office add-ins across multiple applications

02

Designed and implemented identity federation (Azure AD ↔ Cognito)

03

Built secure API integration layer

04

Implemented OAuth/OIDC authentication flows

05

Integrated CRM data into Office interfaces

06

Ensured secure token handling and access control

07

Delivered consistent UX across Office applications

Key Achievements

🔥

Built multi-app Office add-in suite (Outlook, Word, Excel)

🔥

Implemented cross-cloud identity federation (Azure + AWS)

🔥

Enabled seamless SSO across platforms

🔥

Integrated CRM data directly within Office workflows

🔥

Delivered secure, enterprise-grade authentication system

Impact

📊

Eliminated context switching between CRM and Office tools

📊

Improved productivity through in-app data access

📊

Simplified authentication with unified SSO experience

📊

Strengthened security across multi-cloud systems

📊

Enabled scalable identity management architecture

Tech Stack

Frontend

JavaScript, TypeScript, Office JS API

Backend

Node.js

Cloud

AWS (Lambda, RDS, S3, IAM)

Identity

Azure Active Directory, AWS Cognito, OAuth, OIDC

DevOps

CloudFormation

Other

Office365 APIs

What I Help With

Scalable Backend Systems

High-performance APIs and microservices

Complex Integrations

Stripe, Shopify, Microsoft Graph, telecom

AI & Automation

LLM workflows, document processing

Identity & Security

OAuth, Entra ID, Cognito

Let's discuss your system or project

Get expert input on your architecture, integrations, or scaling challenges.

Book a Call to Discuss Your Project