Iulian Serbanoiu

A web-based application with a responsive design for mobiles that helps managers and workers in the railroad infrastructure in Sweden to digitally manage their daily tasks and analyze the risk assessments of working on the rail tracks.

TECHNOLOGIES
• .NET Core 5.0 (initially 3.1)
• EF Core
• Web API
• React
• TypeScript
• SASS
• Semantic UI
• Material-UI
• ASP.NET Core SignalR
• PostgreSQL
• FluentValidation
• Redis
• AWS hosted

The project involved building a new core platform for pension administration for a large financial organization in The Netherlands.

The purpose of building such an extensive financial system was to bring more digital assets, flexibility, maintainability, and adaptability to a core pension administration system, allowing fast delivery of new functionally independent components.

The system is built with a domain-driven architecture and includes new workflows and digital front- and back-end functionality to support around 45 processes for life and work-related events of roughly three million people.

What is special about this particular project is the true partnership and smooth collaboration between all teams involved.

TECHNOLOGIES
• ASP.NET
• Onion architecture
• Domain-driven design (DDD)
• Behavior-driven design (BDD)
• Microservices
• Command query responsibility segregation (CQRS)
• WCF, Service Bus, MSMQ.
• WPF with Prism
• TFS, MsBuild, Microsoft Release Management, XL Deploy
• Coded UI
• MS SQL Server, Entity Framework
• SpecFlow and Gherkin
• Workflow orchestration services
• CI/CD

The application consists of multiple modules integrated to provide underwriters with a dashboard to view KPIs and risk status visualization. The KPIs are common needs across all underwriting teams regardless of the products.

The data for calculating the KPIs is updated daily with the underlying data of all the other systems responsible for managing the submissions, quotes, and policies. Each system pushes its data to a BI Cube, and an SSIS package would be scheduled to read the data from the Cube and populate an SQL DB. The formulas for calculating the KPIs would run on the above mentioned data. Microsoft's PowerBI role is to use the data from the SQL DB to generate reports customized to the clients' demands. Eventually, these reports are embedded in the web portal using the Microsoft PowerBI JavaScript library.

TECHNOLOGIES
• .NET Framework 4.7.2
• Microsoft PowerBI .NET API
• Microsoft PowerBI JavaScript API
• Logging with ELK stack
• IoC - Castle Windsor C#
• Angular 1.7
• jQuery
• MS SQL Server 2016
• SQL Server Integration Services (SSIS)
• Dapper ORM
• CI/CD - Team City and Octopus

The solution is hosted in an Azure environment as an app service. It is a web API synchronizing data between two CRMs, one proprietary Softelligence and the other Hubspot CRM.

By using webhooks called by subscriptions on certain entities in both CRMs, the API integration handles the synchronization process of the entities with custom logic. Hubspot CRM is used as a front-end CRM by the sales team, while the back-end CRM is used by internal staff members of the client for handling the insurance business flows.

Additionally, the Azure Logic app and Function app are used to perform time recurrence and event-driven flows. All Azure services are defended by API management, which is the gateway service and manages the authentication with third-party APIs.

TECHNOLOGIES
• .NET Core 2.1
• Azure App Service
• Azure Logic Apps
• Azure Function App
• Azure Application Insights
• Azure API Management
• Hubspot API

An application used by Tobacco's brand ambassadors to interact with consumers and get feedback on their smoking preferences but also benefit managing based on brand campaigns.

The solution consists of a front-end application developed in the Microsoft PowerApps platform, which Azure Services support as the back-end platform that contains all the business logic and integrations with third-party APIs. Power BI is also used for reporting purposes with an Azure SQL DB as the data source for the reports, which is populated by the platform mentioned above.

TECHNOLOGIES
• .NET Core 3.0
• Entity Framework Core
• Azure Services, including Function App, Logic App, API Management, AD B2C, Key Vault, Application Insights, Azure SQL database, and AD B2C.
• Microsoft Power Platform, including PowerApps and Power BI.

A web-based application that allows brokers and public customers in the UK to apply for mortgages or refinance existing ones developed using ASP.NET MVC together with Angular.

The solution communicated with external services like the UK's anti-money laundering (AML) to have a complete and valid set of data for generating a draft of approval or not for a mortgage.

TECHNOLOGIES
• .NET Framework 4.5
• ASP.NET
• Angular
• Entity framework
• Telerik UI controls
• SQL Server 2012
• Internal Information Services (IIS)

The core business of this client is market-making in options. An option is a derivative since its price is derived from the behavior and characteristics of another instrument.

The application developed is used for entering and managing the parameters for a proprietary pricing model that constructs the implied volatility parameter, one of the most important parameters for determining the value of an option.

Once the parameters are entered by traders, the application performs validations against safety limits and some relatively small calculations to the parameters to prepare an updated set of data that will be exported to a database that stores all parameters.

The application is developed as a client-server one. The client-server approach is used since we need to have synchronization for all changes from multiple users. We use a UI framework for controls from DevExpress and as a serialization mechanism of the data between the client and server, the Google protocol ProtoBuffer. Microsoft SQL Server is used to host a local database for storing the metadata, such as users' settings, safety limits, and workspaces.

TECHNOLOGIES
• .NET 4.0
• WinForms
• DevExpress v12
• SQL Server

This is a solution helping wireless operators quickly analyze their complex operational data and leverage it in their daily decision-making processes.

It incorporates a powerful data analysis engine to model and automate business processes. The results are delivered via a powerful web-based user interface with integrated maps and dashboards. The user interface is mainly architected and implemented using Adobe Flex technology. It is highly scalable and can be easily customized and updated with other data analysis modules. It provides a rich and interactive user interface.

The communication with the server-side is accomplished using WCF for the dashboards and administration modules. The back-end framework has been continuously optimized to improve performance, speed, and memory management.

TECHNOLOGIES
• ASP.NET Framework 3.5, 4.0
• WCF and SOAP Web Services
• ASP.NET Web API
• Microsoft Enterprise Library
• Pex and Moles
• log4net, Aspose Cells, and ExtremeNumerics libraries
• Ant and Jenkins
• SQL Server, Oracle, and Vertica for DB upgrade and maintenance.
• Flex SDK 3.6 and FlexUnit
• jQuery and Kendo UI
• Bing Maps and Google Maps

The application is a complex management console for client network-oriented products like network scanners, antivirus, and network utilities.

It is the central part of an integrated threat management solution to detect vulnerabilities and threats, prevent intrusions, and protect all of an enterprise's essential computing resources. It supports various management control actions like remote deployment and commands and sustains a complex review and reporting system. From a technical point of view, it is a cross-technology application with a strong .NET framework-based core, NHibernate dedicated implementation, and Flex technology as a Graphical Interface approach.

It combines in an efficient manner ActionScript programming and MVC architecture with cross platform communication and ORM data manipulation. The custom reporting mechanism provides a robust and flexible implementation based on the Telerik reporting engine.

TECHNOLOGIES
• Microsoft .NET Framework 3.5
• NHibernate
• Telerik Reporting
• Flex and ActionScript 3.0
• PureMVC
• PostSharp