Ignacio Sanabria Alonso De Caso

I work on the design and implementation of automation and integration solutions on the Microsoft ecosystem, integrating Microsoft Entra ID, Azure Functions, and Power Platform to improve operational efficiency and process traceability.

User Synchronization Architecture:

Entra ID → Microsoft Graph → Azure Functions → Dataverse → Power Platform

• Backend development in Azure Functions (.NET) for incremental user synchronization from Microsoft Entra ID using Microsoft Graph (/users/delta).

• Data persistence in Dataverse, consumed from Model-Driven for auditing and operational exploitation.

• User lifecycle automation: detection of new hires and departures, automatic license assignment, and related administrative operations.

• Integration with Exchange Online using Azure Functions (PowerShell) to automate operations on mailboxes.

• Process orchestration with Power Automate and Dataverse, including data model design and execution status management.

• Application of architectural best practices: error control, traceability, and governance in corporate environments.

• Participation in technical documentation and governance procedures for the Power Platform Center of Excellence (CoE).

Project developed in collaboration with Telefónica Tech for the Madrid City Council.

During my time at Fujitsu, I worked on the improvement and automation of internal operational processes, developing tools and workflows that reduced manual tasks, improved traceability, and increased team productivity:

• Development of internal tools in Power Apps for user and project management.

• Process automation using Power Automate:

- Onboarding and offboarding of users and projects with approvals and notifications integrated with Outlook and Teams.

- Automatic creation of tickets in Redmine from emails or forms.

• Design and evolution of operational dashboards for external clients (Pentaho + Power BI + DB/Excel + cron), including ETL processes for data extraction, transformation, and visualization.

• Development of a bidirectional synchronizer between ticketing tools (Redmine–GLPI) using REST API in Python, avoiding duplication and automatically synchronizing ticket creation and updates.

• Automation of notifications, data uploads, and recurring support processes using ETL with Pentaho (over 50 flows in production). Some examples:

- Automatic alerts based on ticket status or resolution time.

- Mass permission assignment.

- Time-sheet migrations between fiscal years.

• Development of advanced SQL queries for service control, specific reporting, and operational data analysis.

• Resolution of requests and incidents in internal tools, along with technical functional documentation and user manuals.

• Application of development best practices, technical governance, and modular structure.

These solutions contributed to reducing manual tasks, improving coordination between teams, and increasing the operational efficiency of the service.