Sergi D.

Set up Office 365 as a productivity tool by utilizing Teams, SharePoint, and Outlook, creating a progressive implementation plan for key users to enhance collaboration and efficiency;

Managed system administration through Citrix, ensuring smooth operation and optimized resource usage across systems;

Integrated the Presence Control app with the Navision HR system via a REST API, utilizing Azure Functions (C#) to reduce administrative effort. The API was designed to integrate with any system that supports API consumption, bypassing limitations within Navision;

Migrated SQL data to two separate SQL instances to avoid bottlenecks, utilizing Python for faster data migration and optimizing business load management by distributing data across multiple instances;

Set up the infrastructure for Elasticsearch and synchronized data using a Python Django REST API, ensuring fast data synchronization between SQL and Elasticsearch. The services were triggered by updates, insertions, or deletions in SQL, ensuring real-time data consistency;

Developed a REST API using .NET to address the administrative load between Navision and Office 365 (Azure AD). The solution synchronized key employee data, such as names, roles, and locations, from Navision to Office 365, overcoming the limitations of Navision's inability to synchronize with Azure AD. The API was implemented in an Azure PaaS Webapp for seamless integration.

Developed PowerApps to control expense invoices, leveraging Azure Cognitive Services to extract data from invoices and automatically insert the extracted information into Dynamics 365. Utilized C# to detect the data zones and draw rectangles to highlight the extracted content;

Created a REST API using .NET to integrate SEPE with the Madrid regional employee system that utilizes Dynamics 365. This involved mapping a 4000-character string buffer from SEPE into a class model, applying business rules, and triggering actions within Dynamics 365. Due to the time-consuming nature of the task, an application was developed to automate the process. The API was implemented using a PaaS component called Webapp for efficient and scalable integration.

IT administration, ensuring the smooth operation of the center's technology infrastructure;

Developing a web application for the administration of the center, streamlining internal processes and improving operational efficiency;

Conducting software requirements analysis to understand the needs of the center and translate them into technical specifications;

Designing and implementing SQL databases to manage the center's data effectively and ensure data integrity;

Handling both frontend and backend design and programming, creating a cohesive and functional web application that met the needs of the administration and users.

Installing and maintaining Windows Server 2012, ensuring a stable and secure operating environment for the center's IT infrastructure;

Installing and configuring Active Directory, enabling effective user management and security protocols;

Utilizing Group Policy Objects (GPO) to enforce security policies and configurations across the network;

Configuring DNS and DHCP to ensure proper network communication and efficient IP address allocation;

Managing domain configuration, ensuring seamless integration and access to network resources;

Resolving ransomware incidents, implementing measures to mitigate and prevent future attacks;

Developing and managing an ASP-based web application for administration, streamlining internal processes and improving user experience;

Configuring and maintaining an ASP.NET web server to host and support web applications, ensuring high availability and performance.

Installing and maintaining Windows Server 2012 R2 to ensure a reliable and secure IT infrastructure;

Installing network switches and patch panels, setting up the physical network layer for efficient connectivity;

Crimping UTP cables and RJ45 connectors to establish network connections and ensure proper data transmission;

Installing and configuring client computers, providing essential IT support for staff and students;

Configuring RAID 1 for data redundancy and improved system reliability;

Installing and configuring Active Directory, facilitating user management and access control;

Using Group Policy Objects (GPO) to enforce network policies and security standards;

Configuring DNS and DHCP to ensure proper name resolution and dynamic IP assignment across the network;

Managing file sharing within the network, ensuring proper access controls and data sharing;

Setting up remote administration with a public IP to enable secure and efficient management of the network from external locations;

Configuring a public domain for web hosting and facilitating easy access to the center's online services;

Performing regular IT maintenance to ensure the ongoing reliability and performance of all systems;

Administering web hosting services, ensuring the availability and performance of hosted websites;

Handling SEO (Search Engine Optimization) to enhance the visibility and ranking of the center's website in search engine results;

Providing maintenance and support for ASP.NET-based applications, ensuring they remain functional and up-to-date.