Pedro Manzanares Lozano

During my time as a Freelancer, I had the privilege of collaborating with a diverse range of both large and small companies, serving as a Functional and Technical Consultant. Primarily, I held the role of Technical Leader, specializing in Microsoft Dynamics 365 and Microsoft Power Platform technologies, and actively engaging in the analysis, design, development, and implementation of solutions. Here's a breakdown of some of the activities and projects I was involved in:

Activities:

• Execution of projects involving server, client, and Power Platform extensions, including PowerApps, PowerBI, and Microsoft Flow.
• Seamless integration with external systems utilizing Azure Data Factory, Dynamics 365 CRM, and Power Platform.
• Creation of applications using PowerApps to complement Dynamics 365 functionalities.

Notable Projects:

Magic Costa Blanca:

• Oversaw the migration from Dynamics CRM 4.0 to Dynamics 365, necessitating the adaptation and enhancement of existing logic and business processes.
• Facilitated integrations with the booking engine.
• Achieved seamless integration of Customer Service with a customized survey engine.
• Led BackEnd and FrontEnd development efforts.
• Created various Model-Driven and Canvas Apps applications.
• Implemented different Business Process Flows to replace outdated processes.
• Adapted and modernized existing code to align with the new version.
• Conducted customizations and configurations on form views and fields.

Colegio General de Farmacéuticos de Vizcaya:

• Transferred functionality from a proprietary application to Microsoft Dynamics 365 technology.
• Utilized Microsoft Power Platform for process interconnection and automation.
• Executed projects involving server, client, and Power Platform extensions.
• Ensured seamless integration with external systems, including Azure Data Factory, Dynamics 365 CRM, and Power Platform.
• Developed PowerApps applications to complement Dynamics 365 functionalities.

Colegio General de Farmacéuticos de Guipúzcoa:

• Adapted the solution to the client's specific requirements, managing the project from start to finish.
• Conducted various projects involving server, client, and Power Platform extensions.
• Ensured smooth integration with external systems.
• Created PowerApps applications to enhance Dynamics 365 functionalities.
• Leveraged Artificial Intelligence capabilities using Microsoft Power Virtual Agents for front-line services.

Implantation Forecasting de Suelos - Landco:

• Gathered requirements, conducted analysis, and executed development and training.
• Managed the project from initiation to completion.
• Engaged in projects involving server, client, and Power Platform extensions.
• Orchestrated integrations with various systems, including ERP and custom systems, as well as public APIs.
• Provided training to junior team members and offered support during challenging situations.

Audit - Ticketing and Fraud Forecasting Tool – Iberdrola España (Spain):

• Responded to the client's need for a consolidated data platform with tailored security and notification features.
• Developed multiple FrontEnd and BackEnd solutions with a focus on data security and extensive security testing.
• Created custom Model-Driven interfaces for different user profiles.
• Utilized Azure Functions to replace Excel-based data loading tools.
• Interconnected with SAP for data retrieval.
• Developed custom Plugins to meet specific business logic.
• Implemented JavaScript functionalities for notifications and Business Process Flow controls.
• Leveraged Power Automate for notifications via Teams and email.
• Established a user-friendly ticket entry portal with various customizations and profiles.
• Integrated with public APIs.
• Mentored junior team members, monitored their learning progress, and provided support when needed.

Iberdrola UK – Pexis Financial Tool:

The Iberdrola UK project involved assisting a client who relied on an Excel-based tool for project forecasting and custom graph visualizations, known as SCURVE. At the project's inception, the client had limited knowledge of the technology landscape, so my role encompassed guiding them towards standard solutions to prevent significant development delays. Additionally, I assumed project management responsibilities, managing English-language communication with the client and carefully managing expectations to prevent misunderstandings. Here's a detailed breakdown of the project activities:

• Project Phases: Led the project through requirements gathering, analysis, development, and training phases.
• Comprehensive Development: Executed numerous FrontEnd and BackEnd developments to prioritize data security, involving a dedicated security testing team to ensure robust security measures and detect vulnerabilities.
• Custom Model Driven Solutions: Created distinct Model-Driven interfaces for various user profiles, customizing forms, fields, and views to enhance user experiences.
• Azure Functions: Developed Azure Functions to facilitate the export of Audit and Forecasting Projects, seamlessly integrated into the Canvas App.
• User-Friendly Canvas App: Crafted a user-friendly Canvas App to streamline the creation of project forecasts, improving user interactions.
• Integration with SAP: Achieved seamless interconnection with SAP, both in asynchronous and synchronous data retrieval.
• Business Logic Plugins: Developed Plugins to align with specific business logic requirements.
• Complex Calculations: Performed complex calculations through custom Plugin developments to address unique project needs.
• JavaScript Functionality: Implemented JavaScript functionalities for notifications and Business Process Flow controls.
• Power Automates: Utilized Power Automate to send notifications through Teams, adhering to predefined logic, and dispatched customized email templates.
• User Access Portal: Created a ticket entry portal with multiple customizations and profiles to facilitate user access to relevant data.
• Junior Team Support: Provided training to junior team members and monitored their learning progress, offering support during challenging situations.

Prosegur – International Implementation:

The Prosegur – International Implementation project involved providing support to the client's team for a multi-country implementation within a unified system. This required adapting processes to accommodate legal compliance and user workflows across various countries. Here are the project details:

• Project Phases: Guided the project through requirements gathering, analysis, development, and training phases.
• User Engagement: Conducted meetings with users to understand their unique business challenges and develop tailored solutions.
• Azure Functions: Developed Azure Functions to enhance system capabilities.
• Integration: Integrated the system with other critical systems to ensure seamless data exchange.
• Model-Driven and Canvas Apps: Created both Model-Driven and Canvas Apps for diverse functionality requirements.
• BackEnd Development: Executed BackEnd Plugins and Actions developments to enforce critical business logic.
• Custom JavaScript: Implemented custom JavaScript functionalities within Business Process Flows.
• PowerApps Portals: Customized PowerApps Portals, with a specific focus on JQuery for form rules and user experience enhancements.
• Power Automate: Utilized Power Automate for notifications and simplified workflow processes.
• Custom Actions: Designed and implemented Custom Actions to centralize logic and prevent duplication in PowerBi developments for advanced data analysis at the management level.

Enhancing Protocol Efficiency for His Majesty the King:

Under His Majesty the King's initiative, the primary objective was to significantly enhance the efficiency and day-to-day operations of the protocol team. This involved addressing several challenges that the protocol team had encountered in organizing events, including the fragmentation of vital information across multiple systems, reliance on outdated and manual processes, and deficiencies in functionality and performance. Here's a detailed breakdown of the project:

• Streamlined Event Management: Our central responsibility was to develop a comprehensive application that would streamline and oversee all events hosted at His Majesty the King's residence. The application encompassed the following crucial functions:
• Guest Management: Efficiently managed the titles and honorifics for each guest.
• Protocol Classification: Determined the appropriate protocol category for each guest, ensuring adherence to established norms.
• Guest Experience Oversight: Oversaw the complete guest experience, from their arrival at the event to their departure, including aspects such as seating arrangements, parking assignments, proper etiquette for greeting the king and other dignitaries, and the order of greetings for protocol adherence.
• Event Venue Identification: Identified the venue for each event.
• Automated Invitations: Automatically generated personalized invitations for each event, simplifying this previously labor-intensive task through a dedicated system that leveraged the application's data.
• Technology Stack: The development of this comprehensive application leveraged a robust technology stack, which included:
  
• Dataverse and Dynamics 365: Utilized these platforms as the foundation for data management and storage.
• Azure Function: Employed Azure Functions to handle specific functionalities efficiently.
• Javascript Plugins: Developed custom Javascript Plugins to enhance the application's capabilities.
• PowerApps Canvas and Model Driven: Implemented both PowerApps Canvas and Model-Driven components for a seamless user experience.
• Power Automate: Integrated Power Automate to automate various processes and notifications.

This project aimed to revolutionize event management within the royal residence, ensuring precision, efficiency, and adherence to protocol for all royal events.

Dynamics 365 Implementation at the Presidency of Government (Presidencia de Gobierno):

Within the context of the Presidency of Government, the implementation of Dynamics 365 was a pivotal initiative aimed at enhancing efficiency and service quality. Here's a breakdown of the key components of this project:

• Dynamics 365 Customer Services: The project entailed the seamless implementation of Dynamics 365 Customer Services, enabling the government to efficiently manage and address citizen inquiries, concerns, and service requests.
• REST-API Integration Layer: To ensure seamless data exchange and interaction between Dynamics 365 and the government's internal web services, a robust REST-API integration layer was developed. This layer facilitated the secure and real-time transfer of essential information, optimizing overall system performance.
• Microsoft Power Automate Integration: The project also involved the thoughtful design and integration of Microsoft Power Automate Gateway. This integration allowed for the execution of internal automation processes directly from Microsoft's Software as a Service (SAAS) cloud services. By harnessing the power of automation, the Presidency of Government was able to streamline its workflows, improve efficiency, and enhance overall service delivery to citizens.

This comprehensive implementation aimed to empower the Presidency of Government with cutting-edge tools and technologies, enabling them to provide citizens with responsive and efficient services while optimizing internal processes.

Lyntia Networks:

At Lyntia Networks, our engagement encompassed a range of critical activities to enhance operational efficiency and ensure seamless service delivery. Here are the key components of our involvement:

• Platform Management and Administration: We provided comprehensive platform management and administration services for Lyntia's commercial management solution, which was built on the foundation of Microsoft Dynamics 365 Sales. This involved overseeing the day-to-day operations, ensuring system reliability, and optimizing the performance of the commercial management solution.
• Review and Enhancement of Implementation Practices: Our team conducted a thorough review of existing implementation and development practices. We leveraged this review to enhance the deployment of Dynamics 365 CRM and Microsoft Power Automate, introducing evolutionary products and methodologies to improve efficiency and align with industry best practices.
• Data Services and API Management: We assumed the critical responsibility of managing and controlling data services and APIs consumed by the solution. This included data integration, ensuring data quality, and optimizing API performance to facilitate smooth data flows and support Lyntia's operational needs.

Exolum:

At Exolum, our involvement centered around the implementation of a cutting-edge COE (Center of Excellence) Toolkit designed to automate the Microsoft Power Platform Governance Process. This project encompassed several critical components:

• Customization of Canvas and Model Driven Apps: We undertook the customization of both Canvas and Model Driven App solutions to align them with Exolum's specific needs. These tailored applications served as foundational tools within the Power Platform Governance Process, enhancing user experiences and system capabilities.
• Adaptation of Reports in Power Automate: Our team facilitated the adaptation of reports within Power Automate, enabling Exolum to gain deeper insights into their processes and operations. These customized reports were instrumental in enhancing decision-making and optimizing workflows.
• Development of Customized Connector: To facilitate seamless interaction with the Microsoft DevOps Service, we developed a specialized connector. This connector acted as a bridge between Exolum's systems and the DevOps Service, ensuring smooth data exchange and integration.

Inetum Spain:

At Inetum Spain, we embarked on a significant project focused on revolutionizing project procurement management. Our approach involved the development of a powerful internal solution, leveraging the capabilities of the Microsoft Power Platform. Here's an overview of our contributions:

• Comprehensive Solution Development: We created a robust internal solution designed to streamline project procurement management. This encompassed the development of a suite of applications utilizing Microsoft Power Apps, Power Automate, and Power Portals.
• Integration with SAP 4: Seamless integration with SAP 4 was a fundamental aspect of our solution. By connecting with SAP 4, a leading enterprise resource planning system, we ensured that critical procurement processes were synchronized, enabling data accuracy and consistency.

Enagas:

During my collaboration with Enagas, I spearheaded a transformative project focused on implementing and designing a robust governance model. Here's a comprehensive overview of our engagement:

• Governance Model Implementation: I led the implementation and design of a comprehensive governance model for Enagas. This encompassed the creation of a structured framework that ensured efficient management and security of the application environment.
• COE Installation and Customization: As a part of the governance model, I oversaw the installation and customization of a Center of Excellence (COE). This COE was tailored to precisely align with Enagas' unique requirements, guaranteeing optimal functionality and adaptability.
• DLP Security Rules: To bolster security measures, I implemented Data Loss Prevention (DLP) security rules. These rules were instrumental in safeguarding sensitive data and mitigating potential risks.
• Detailed Governance Documentation: In addition to practical implementations, I meticulously documented the governance process for the entire Power Platform platform. This documentation provided Enagas with a comprehensive, step-by-step guide, ensuring transparency and clarity in the governance of their Power Platform environment.

Mutualite Belgium (Sopra): Integration Specialist

During my tenure at Mutualite Belgium Sopra, I played a pivotal role in a crucial project that centered around the integration of Microsoft Compliance API. The objective was to extract audit data from Dataverse systems, a task that required a combination of technical expertise and innovation.

Project Overview: Integration of Microsoft Compliance API

In this project, I significantly enhanced my proficiency in Power BI, leveraging Azure Functions to develop the core logic. Working seamlessly with Azure Data Factory, I implemented a streamlined process to transform the generated files into the efficient .parquet format. This optimization not only reduced data load times but also facilitated data extraction for Power BI reporting. To further optimize efficiency, I implemented incremental updates and harnessed the capabilities of Azure Synapse for handling external tables sourced from .parquet files.

Key Responsibilities and Achievements:

• Power BI Proficiency: I significantly enhanced my proficiency in Power BI to extract and visualize the required audit data.
• Streamlined Data Transformation: Using Azure Functions, I developed the core logic for transforming data, working seamlessly with Azure Data Factory to optimize the data extraction process.
• Efficient Data Format: I implemented a process to convert generated files into the efficient .parquet format, resulting in reduced data load times and improved reporting capabilities in Power BI.
• Incremental Updates: To enhance efficiency, I implemented incremental updates for data extraction and utilized Azure Synapse for handling external tables from .parquet files.
• Precise Data Filtration: I addressed the challenge of precise data filtration based on national identification numbers, bridging the gap between Office 365 Compliance API data and Azure DataLake Dataverse.
• Data Compliance: We ensured compliance with data protection regulations by creating a separate, anonymized data set that retained essential information while safeguarding personal details.

My contributions to this project underscore my ability to tackle complex technical challenges, my proficiency in data integration and transformation, and my commitment to delivering solutions that align with both technical and compliance requirements. This experience has greatly enriched my skill set and reinforced my commitment to achieving excellence in data integration and analytics.

Ricoh: AI Project Specialist

During my tenure at Ricoh, my primary focus has been on spearheading artificial intelligence projects grounded in Microsoft technologies, with a particular emphasis on Azure OPEN AI and Azure Vision AI.

Project Overview: Enhancement of Meat Processing with Azure Vision AI

One of my initial projects involved collaborating with a meat processing company that sought to enhance its production line using Azure Vision AI. The aim was to identify consumer preferences for various meat products, detect any defects in the meat, and pinpoint their exact locations.

Key Responsibilities and Achievements:

• Algorithm Development: I embarked on developing a categorization algorithm and training the model using data from an Excel spreadsheet and associated photographs. This data was used to feed the model, enabling it to make accurate predictions.
• User-Friendly Interface: To visualize this information for the client, I created a Power Apps application where users could upload images, and the system would return the consumer category percentage and identify any meat defects, including their locations.
• Outstanding Accuracy: Remarkably, the accuracy of the system consistently exceeded 95%, ensuring precise identification and categorization.
• Automated Processes: I established an automated process using Azure Functions with Schedule Trigger, Power Automate, and customized Power Apps ribbon controls to ensure seamless and efficient operation.
• Data Management: I designed a model-driven application for the final phase of the project to store critical information, including predictions, images uploaded to SharePoint, and relevant details such as camera location, associated category, accuracy percentage, carcass ID, capture location, model used for prediction, and model iteration used for prediction.
• Alert Mechanisms: I implemented alert mechanisms to notify support in case the accuracy fell below 95%, ensuring prompt investigation into any potential issues affecting data quality.

Havas Media: AI Project Specialist

During my tenure at Havas Media, I spearheaded a groundbreaking project that harnessed the power of Power Virtual Agents and Azure Open AI to create a sophisticated recommendation system for an Ecommerce website. This initiative revolved around implementing an advanced artificial intelligence model, GPT-4, to provide personalized product recommendations.

Project Overview: Development of a Sophisticated Ecommerce Recommendation System

My primary role in this project was to develop the Power Virtual Agents bot responsible for delivering product recommendations. I seamlessly integrated this bot with GPT-4, leveraging the model's immense potential as the cornerstone of our recommendation engine.

Key Responsibilities and Achievements:

• AI Integration: I played a pivotal role in integrating Power Virtual Agents with Azure Open AI, specifically the advanced GPT-4 model.
• Sophisticated Recommendation System: We created a highly sophisticated recommendation system that provided personalized product recommendations to users.
• Client Satisfaction: The project delivered exceptional results, leading to high client satisfaction and immediate interest from prospective customers.
• Innovation: This project highlights my commitment to pushing the boundaries of AI technology to drive business success.

The result of our collaborative efforts was nothing short of exceptional. The client was not only highly satisfied with the outcome but also recognized the project's immense value. Within a mere 24 hours of its implementation, the client received six compelling proposals from prospective customers eager to adopt this innovative solution.

This project underscores my proficiency in AI integration and development, as well as my ability to deliver cutting-edge solutions that exceed client expectations. It is a testament to my commitment to advancing the field of artificial intelligence and driving business success through innovation.

During my tenure at IFR Group, I held the position of Technical Leader, actively contributing to the conceptualization, design, development, and implementation of customer solutions within the Dynamics CRM ecosystem. Here are some of the notable projects in which I played a pivotal role in designing and implementing solutions:

IASO:

• Orchestrated a seamless integration with Dynamics AX 2012.
• Conducted comprehensive training sessions for various departments, tailoring the content to their specific roles within the company.
• Developed custom plugins to automate the creation of Field Service Orders from Orders generated in AX 2012.
• Successfully implemented Dynamics 365 CRM across all departments, including Sales, Customer Service, and Field Service.

MAGIC COSTA BLANCA:

• Spearheaded the Dynamics 365 implementation for a major company with multiple hotels.
• Engineered seamless integration with PMS (Property Management System) along with ClickDimensions (Marketing Solution).
• Conducted extensive training programs for diverse departments, ensuring effective utilization of Dynamics 365.

LedsC4:

• Successfully integrated Dynamics CRM with Dynamics AX 2012.
• Oversaw the implementation of a new Dynamics 365 CRM instance.
• Implemented D365 PowerApps Portals for enhanced user engagement.
• Delivered tailored training sessions for departmental staff to maximize their proficiency with Dynamics 365.

Casa del Fin:

• Seamlessly integrated with Dynamics AX 2012.
• Crafted a B2B portal leveraging Dynamics 365 portals.
• Conducted role-specific training programs for various departments.
• Facilitated Dynamics 365 CRM adoption across the organization.

Casa Schmidt:

• Implemented Dynamics 365 CRM across all affiliated companies.
• Customized security and configurations to align with specific needs.
• Ensured seamless integration with customizable AX 2012 ERP modules.
• Streamlined business processes within Dynamics 365 CRM.

EPSAGROUP International:

• Led an international project, delivering training tailored to departmental roles.
• Successfully implemented Dynamics 365 CRM across various departments, including Sales, Customer Service, and Project Services.
• Automated project services for building operations.
• Introduced Field Service capabilities.

Visan:

• Orchestrated a seamless integration with PrestaShop.
• Developed logistics tracking solutions.
• Designed an order tracking portal for enhanced customer experiences.
• Created customized web services to meet specific requirements.
• Configured Dynamics 365 Chat functionalities.
• Implemented Dynamics 365 CRM across departments, including Sales, Customer Service, and Omnichannel for D365 Customer Service, along with AI-powered Bot integration.

PEUSA:

• Contributed to the implementation of Dynamics 365 CRM for a company specializing in electric power and gas services.
• Conducted role-specific training sessions.
• Implemented Dynamics 365 CRM across all company departments, including Sales and Customer Service.

JISAP:

• Executed a project for a meat company, focusing on commercial processes.
• Seamlessly integrated with Dynamics AX 2012 and 2009.
• Developed custom plugins to address specific challenges.
• Conducted role-tailored training for departmental staff.
• Successfully implemented Dynamics 365 CRM across Sales and Customer Service departments.

Embamat:

• Integrated Dynamics 365 CRM with Dynamics 365 Finance and Operations.
• Designed custom plugins to prevent errors and enhance user proficiency.
• Implemented workflows to automate repetitive tasks.
• Introduced Dynamics 365 CRM to sales departments across the organization.

Throughout these projects, my role as a Technical Leader was pivotal in ensuring the successful implementation of Dynamics CRM solutions and enabling teams across various departments to harness the full potential of these systems.

During my tenure at Innovar Tecnologías, I had the privilege of working on a diverse range of compelling projects, each with its unique set of challenges and solutions:

Fira de Barcelona:

• Orchestrated a seamless migration from Project Dynamics 2011 to Dynamics 365.
• Implemented JavaScript to streamline event control within forms.
• Developed plugins to mitigate human errors and enhance system reliability.
• Facilitated ERP integration via Microsoft Power Automate (Flows).
• Crafted insightful dashboard reports using Microsoft Power BI.
• Conducted comprehensive training sessions for various departments to optimize their utilization of Dynamics 365, tailored to their specific roles.
• Established integration with the Call Center for improved efficiency.

CaixaBank Consumer Finance:

• Successfully executed a migration from Dynamics 2011 to Dynamics 365, necessitating the reconstruction of numerous internal integration functionalities with their ERP. Simultaneously, ongoing developments in Dynamics 2011 were maintained during the migration.
• Engineered integrations between Microsoft Dynamics and Microsoft Office to enhance productivity.
• Produced impactful reports leveraging the capabilities of Microsoft Power BI.

Foment del Treball Nacional:

• Pioneered the development of a robust consent acceptance and denial process, including the creation of new contacts, contact updates, Web Forms management through Web content, and ClickDimensions (Marketing Solution) integration.
• Established data integrations between Microsoft Dynamics 365 and Microsoft Office 365 for seamless data sharing.
• Designed workflows for automating submissions, modifications to various forms and views, and orchestrated the migration from CRM2011 to Dynamics 365.

IdGrup:

• Spearheaded a project for IdGrup, a service, maintenance, and hardware installation company, aimed at transitioning their incident tool to Dynamics 365 CRM.
• Introduced new fields, forms, and entity relationships to enhance data management.
• Implemented automatic email workflows for streamlined communication.
• Utilized JavaScript to optimize form event control.
• Developed plugins to enhance accuracy and minimize errors.
• Customized the customer service process through the creation of business process flows.
• Created data integrations within Microsoft Dynamics 365 and Microsoft Office, leveraging Microsoft Power BI for data presentation.

These projects not only showcased my technical prowess but also underscored my commitment to delivering innovative solutions that align with each client's unique needs and objectives.

During this period, I was employed at a consulting firm with Caixa Bank Asset Management as its primary client. Our responsibilities encompassed the enhancement of CRM 2016, ongoing maintenance, and the creation of new features to align with evolving business requirements.

Notably, we spearheaded a significant project for this client, involving the encryption of all customer personal data to ensure compliance with data protection legislation. Furthermore, we orchestrated the seamless interaction between Microsoft Dynamics 2016 and Microsoft Office Professional, facilitating automated data exchanges between these platforms.

During my tenure as a Junior Developer, I actively contributed to the evolution, integration, and implementation of Dynamics 365 CRM across various versions, including 4.0, 2011, 2016, and 365, while serving multiple companies.