Kouame Franck

With 10 years of experience in IT project development, mainly in : • .NET application development (Web, Desktop, Mobile, etc.) • Business Intelligence solutions (ETL engines, Dashboards, Reports, etc.) • Audit & consulting / Project management / Assistance to project ownership I offer my services and expertise to support you in various IT solutions, tailored to your needs. To learn more about my skills, I invite you to check the "About" section or contact me directly : • By LinkedIn messaging • By email: [email protected] • By phone: +33 7 80 32 88 24 • Website: ibexpertise.net

PROJECT : • OSCAR MISSIONS : Oscar is a desktop application allowing periodic payment (monthly, quarterly,...) of commissions on savings and insurance products sold by BPCE Vie's partner providers. It is a WPF application mainly using input files and relying on large stored procedures to subsequently generate billing slips, disbursement files, and accounting entry lines for its partner banks. My mission consisted of :  On one hand, taking charge and managing all technical aspects of the project, namely maintenance and development of new features.  And on the other hand, ensuring communication with various business actors and clients consuming the application or its data.. MISSION DETAILS :  Project planning under MS SharePoint and Excel, organizing meetings and gathering requirements from business teams (accounting team)  Functional and technical analysis of needs and transcription in the form of Devops tickets  SQL Database and Stored Procedures: • Design and optimization of the database in SQL Server, creation of tables, relationships and constraints to ensure data integrity. • Development of T-SQL stored procedures for common operations (CRUD) and complex data processing to display in commission statements. • Optimization of existing SQL queries (updating and improving transaction performance).  Backend : • Design and implementation of the Backend logic of the application (methods querying stored procedures and managing functional constraints) using C#, .NET Framework 4.7, and especially the object-oriented concept to simplify calls between classes. • Writing/Rewriting LINQ queries for data processing; Some LINQ queries were completely removed and transcribed as stored procedures to transfer the load to the database server to accelerate querying and homogeneity of accounting results.  Frontend: • My intervention on the interface was limited to adding some controls developed in XAML and connected via properties, commands and data bindings to the backend according to the MVVM model.  Source Code Control : • Source code management and teamwork of 3 developers. Creation of Git development branches from Devops tickets selected after our SCRUM meetings. Code review pushed by other developers before merging and moving to staging deployment for business testing.  Deployment and Maintenance : • Also responsible for supervising the production deployment procedure: o The first step was to write database migration scripts and make a request to database administrators to perform a prod database backup and execute provided scripts. o Once the database deployment step was completed, I was responsible for deploying a new version of the WPF application and writing the deployment email to the business team and all key project stakeholders. o Then came the step of supervising the proper functioning of the application. A business feedback in the production environment was an urgency to be resolved in priority 1. ENVIRONMENT : • PROJECT MANAGEMENT : DEVOPS WITH AGILE SCRUM METHODOLOGY • COMMUNICATION/COLLABORATION : MICROSOFT TEAMS, OUTLOOK • IDE : VISUAL STUDIO 2019, SQL SERVER 2018 • SOURCE CODE CONTROL : GIT

PROJECT : • OSIRIS MISSIONS : Osiris is a Web platform for managing sports clubs' grant requests to the Ministry of Sports. Grant requests are in the form of files initially created in an external web application called LCA (Association Accounts Software) and transmitted to Osiris via APIs before going through an entire approval workflow until rejection or payment of the grant request by the state. The mission consisted of maintenance and development of evolutions within this platform. MISSION DETAILS :  Functional and technical analysis of tickets and effort point estimation under Jira  SQL Database and Stored Procedures : • Creation/Update of tables and T-SQL stored procedures, relationships and constraints to ensure data integrity. • Optimization of existing SQL queries via SQL Server Profiler and transaction management.  Backend: • Implementation of authentication and authorization to secure APIs via Microsoft Identity Server • Design and development of internal APIs for processing grant requests via .NET Core Web API MVC, Entity Framework Core,... • Development of our internal APIs to query external APIs of the LCA platform to retrieve sports clubs' grant requests and process them in Osiris (asynchronous calls to avoid blocking the user interface during exchanges with external systems) • Code review via Sonar Lint and Cube, Development best practices focused around the SOLID principle, exception handling, logging,... to ensure API resilience.  Frontend (ASPX and Razor (CSHTML)) : • Development of dynamic and interactive views and pages with ASPX and Razor (CSHTML) using JavaScript and jQuery for API binding • Use of ASP.NET controls for forms and user interactions, and application of client-side and server-side validations for data reliability. • Creation of .rdl activity reports and publication to the SSRS report server  Source Code Control : • Use of Git for version management, following the Git Flow model to organize branches (feature, release, hotfix). • Version tracking with pull requests to ensure code quality, and push review from other team members before deployment to staging then production.  Study and development of an electronic signature module (C# Framework .Net 4.7) via YouSign (Gembox.Document Framework). This module allowed integration of electronic signature of grant request documents to affix a signature validation certifying request approval.  Testing, Deployments and Maintenance : • Unit and functional tests via XUnit. • Deployments of database, APIs and web interface on different Windows Server 2019 staging servers for more thorough business testing. • Implementation of fixes and improvements based on user feedback and external API evolutions and deployment on production servers • Maintenance of a C# .Net 4.7 application for generating XML files useful to another business team in their daily operations. ENVIRONMENT : • PROJECT MANAGEMENT : JIRA WITH AGILE SCRUM METHODOLOGY • COMMUNICATION/COLLABORATION : MICROSOFT TEAMS, OUTLOOK • IDE : VISUAL STUDIO 2019, SQL SERVER 2014 • SOURCE CODE CONTROL : GIT, SONAR SQL, SONARQUBE

PROJECT : • DEMIX (DALKIA ENERGIES MIX) - DEVELOPMENT OF AUTOMATION WEB APPLICATIONS MISSIONS : EDF (Electricité de France) initiated an energy management project throughout France (Biomass (wood boiler), Electric boiler, Gas, Electricity,...). The goal was to optimize energy production and minimize consumption per site. To do this, they have powerful calculators, interfaced by Web applications to provide users with a control solution based on weather forecasts, modeling and customized energy calculation in new buildings, energy optimization in existing buildings. MISSION DETAILS :  Requirements gathering, organizing client meetings, planning and costing of different project modules.  Writing functional and technical specification documents (Confluence, Jira)  Leading a team of 2 developers for the development of a new calculator (Back and Front) - DEMIX CONCEPTION o Database : Modification/Addition of SQL Server database objects (tables, functions, stored procedures,...), SQL Server Profiler optimization, Indexing, ACID transaction management o Backend : Development .Net Core 5 Web Api MVC, EF Core 6, Swagger, Code review (SonarLint, SonarQube), Application SOLID principles, Logging & Monitoring (Serilog, ELK Stack, exception handling), Database First,... o Frontend (Vue.js & UI/UX) : SPA Development (Vue.js 3, Composition API, Vue Router, Tailwind CSS), API Communication (Axios/Fetch), Error handling & loading states, State Management (Vuex for data synchronization), Performance optimization (Lazy loading, caching, code splitting) o Tests & Source Code Management : Unit & functional tests (MSTest, xUnit, Moq, CI/CD with GitHub Actions/GitLab CI), Git version management (Git Flow strategy, branches (master, develop, feature), pull requests, merge requests). ENVIRONNEMENT : • PROJECT MANAGEMENT : JIRA WITH AGILE SCRUM METHODOLOGY • COMMUNICATION/COLLABORATION : MICROSOFT TEAMS, OUTLOOK • IDE : VISUAL STUDIO 2019, VISUAL STUDIO CODE, SQL SERVER 2019 • CONTINUOUS INTEGRATION PLATFORM : TEAM CITY • SOURCE CODE CONTROL : GIT, SONAR SQL, SONARQUBE

PROJECT : • INTEGRATION OF THE CLIENT PORTAL IN THE ITM SYSTEM (ASP.NET) • EVOLUTIONARY AND CORRECTIVE MAINTENANCE OF BORROWER SPACE APPLICATIONS MISSIONS 1 : VERLINGUE uses a variety of computer applications to meet the management needs of its insurance client portfolio. These applications, both WEB and Windows-based, benefited throughout their lifecycle from evolutions and maintenance to offer increasingly qualified services to its clients. Our mission was to develop these evolutions in addition to ensuring third-party application maintenance. DETAILS :  Maintenance of Winforms applications with specific Firefly developments  Maintenance and development of WPF functional components with MVVM pattern  Creation of WCF web services (Framework .Net 4.7) ensuring communication between the WPF application service and different databases through stored procedure calls  Creation and modification of stored procedures and Oracle 11g functions under Oracle SQL Developer  Creation and modification of reports under Crystal report 2011 ENVIRONNEMENT : • PROJECT MANAGEMENT : MANTIS BUG TRACKER (MAINTENANCE TICKETS) • COMMUNICATION/COLLABORATION : OUTLOOK, SKYPE FOR BUSINESS • IDE : VISUAL STUDIO 2015, ORACLE SQL DEVELOPER • SOURCE CODE CONTROL : SVN, SONAR SQL, SONARQUBE PROJECT : ALOADI PROJECT BENCHMARKS - DEVELOPMENT OF INSURANCE CONTRACT BENCHMARKS MISSIONS 2: In its vision to remain a competitive company in the insurance field, VERLINGUE initiated a vast project to digitize its IT system. The ALOADI project was thus born, and one of the applications that needed to be developed with this new architecture was the "Insurance Contract Benchmark" application. We therefore resorted to the latest .Net concepts in terms of software architecture, namely "dockers". DETAILS :  Design and Database • DDD Modeling, Hybrid SQL/NoSQL storage (PostgreSQL for relational data (contracts, benchmarks,...), MongoDB for logs, audits,...) • Database migrations/versioning with EF Core migrations (PostgreSQL, MongoDB Migrations), Query optimization (indexing/partitioning), PostgreSQL (ACID Transactions, Backup and restore pg_dump, high availability replication), MongoDB Backups via mongodump and sharding for scalability  Backend • Design/development of microservices architecture (.NET Core 3.1, Docker container, orchestration with Docker Compose for system scalability and resilience) • Development of authentication API (ASP.NET Core Identity and JWT), allowing VERLINGUE managers to connect to the Benchmarks application • Implementation of Domain-Driven Design (DDD) to structure microservices around well-defined business domains (Contract Management, Guarantee Comparison, Client Recommendations) • Inter-service communication : RabbitMQ, gRPC  Unit/Integration Testing and Deployment • Unit/Integration Tests : (xUnit, Moq), (TestServer, Postman), E2E Tests : Selenium, Methodology: TDD • Continuous integration/deployment (CI/CD) : GitLab CI, Docker Hub, Log management and monitoring with Serilog and Elastic Stack (ELK : Elasticsearch, Logstash, Kibana) ENVIRONNEMENT : • PROJECT MANAGEMENT : JIRA WITH AGILE SCRUM METHODOLOGY • COMMUNICATION/COLLABORATION : MICROSOFT TEAMS, OUTLOOK • IDE : VISUAL STUDIO 2019, VISUAL STUDIO CODE, ORACLE SQL DEVELOPER • CONTINUOUS INTEGRATION PLATFORM : TEAM CITY • SOURCE CODE CONTROL : GIT, SONAR SQL, SONARQUBE

PROJECT 1: AUTOMATION OF CREDIT REQUESTS FOR INDIVIDUAL AND CORPORATE MARKETS OF BRIDGE BANK GROUP IVORY COAST MISSIONS : Platform composed of a "scoring" tool for evaluating the client's eligibility level for the requested loan and a Workflow engine for the approval chain.. MISSION DETAILS :  Design and creation of the database, writing views, functions and packages : • DB [Oracle 11g], IDE [PL/SQL Developer]  Development of data access layers, business service logic and presentation : • Language [C#], Technology [.Net MVC 3], IDE [Visual Studio 2015]  Project Management and Implementation monitoring of a Workflow engine for validating credit requests from the "scoring" web application : • Portal [MS SharePoint Server 2010], IDE [Workflow Designer] and Web parts developed under [Visual Studio 2012] ENVIRONMENT : PATTERN MVC / C# / .NET MVC 3 / PL SQL DEVELOPPER / ORACLE 11G / ORION, MS SHAREPOINT SERVER 2010, WEB PARTS DEVELOPPES SOUS VISUAL STUDIO 2012 PROJECT : PROCESSING OF CLIENT FINANCIAL STATEMENTS FOR "TIERING" RATIO PRODUCTION MISSIONS : Corporate clients of Bridge Bank Group Ivory Coast annually provide their financial statements in various formats. These formats are standardized by the bank into a unique Excel format filled in by credit analysts (Balance sheet assets, liabilities and income statement). A routine then takes care of retrieving this Excel data, transforming it and integrating it into a ratio calculation engine. Subsequently, risk analysts and commercial officers, with appropriate rights, can visualize through a report the various summary ratios automatically generated by the platform for analyzing client credibility before possible loan granting. MISSION DETAILS :  Design and creation of the data warehouse : • DB [SQL Server 2008 r2]  Creation of periodic extraction engine for data from Excel sheets : • ETL [SQL Server Integration Services 2008 r2], Routine under [SQL Server Agent 2008]  Creation of table functions executed in a Web application to serve as calculation base for ratios from warehouse data : • Base [SQL Server 2008 r2]  Development of a graphical interface for consulting ratios : • Technology [ASP.Net MVC 3], Reporting tool [Microsoft reporting available under Visual studio and integrated into the C# application code] ENVIRONMENT : SQL SERVER 2012, SQL SERVER INTEGRATION SERVICES (SSIS 2008 R2), ASP.NET MVC 3, VISUAL STUDIO 2015, C# PROJECT 2: MIGRATION OF SHAREPOINT SERVER 2010 PLATFORM TO 2016 MISSIONS : Project manager on this mission that started 1 month ago (December 14, 2018), meant to last 3 months and aimed at migrating the current SharePoint platform to version 2016, then migrating all business applications with process optimization and Power BI integration for decision-making. MISSION DETAILS :  Project scoping, Identification of all Orion data views that were to serve as data sources for business processes. These views were replaced by Web APIs to have a much more flexible architecture interoperable with several other platforms including Microsoft Dynamics CRM 2016 : • IDE [Visual Studio 2015], Technology [MVC Web API]  We are currently at the stage of integrating these APIs into the components of the new SharePoint 2016 platform. ENVIRONMENT: MICROSOFT DYNAMICS CRM 2016, VISUAL STUDIO 2015 (MVC WEB API), C#, (REST/JSON)

PROJECT : CUSTOMER MANAGEMENT FOR CIE, SODECI AND SDE FOR GS2E (WATER AND ELECTRICITY SERVICES GROUP) -- ABIDJAN, IVORY COAST MISSIONS : GS2E is ERANOVE group's organ in charge of developing new IT products serving CIE, SODECI and SDE. These companies delivering Water and Electricity to Ivory Coast and Senegal expressed the need to acquire a new customer relationship management platform to remain competitive in this competitive market. We therefore worked on a common platform including a Dynamics CRM Web application and a mobile application. (.Net Development, Reporting and Database Optimization) DETAILS :  Customization of Microsoft Dynamics CRM 2013 tool by integrating Web plugins  Each plugin is composed of a Web frontend (HTML/CSS/JavaScript/JQuery) integrated into the CRM page and a backend (WCF .Net Web Service) ensuring business logic and communication with SQL Server 2012 database and other external data sources  Development of a "Web Form ASP.Net" application managing bill payments  Development of a mass billing Windows service (Windows Services under Visual Studio 2015)  Team development with source code control : [Team Foundation Server 2015]  Report creation : [Report Builder 3.0] and integration into MS Dynamics CRM 2013  Optimization of information system performance given the very large customer population to bill throughout the country : • SQL Server 2012 DBMS (Profiler, Query plan analysis, queries via transactions, index definition, stored procedures,) ENVIRONMENT: (HTML/CSS/JAVASCRIPT/JQUERY), SGBD SQL SERVER 2012, MS DYNAMICS CRM 2013, WCF AND WEB FORMS ASP.NET, VISUAL STUDIO 2015,TFS 2015, REPORT BUILDER 3.0

PROJECT 1: COLLABORATION AND COMMUNICATION INTRANET PORTAL FOR THE PRESIDENCY -- ABIDJAN, IVORY COAST MISSIONS : The PRESIDENCY of Ivory Coast requested QuinTsens Consulting (Audit, Consulting and IT Solutions Integration Firm) to develop its internal communication and collaboration platform. After analysis, Microsoft's Intranet solution was chosen. We had to develop this portal for information sharing and business process management such as leave and absence management, mission request management, ... MISSION DETAILS :  Design and creation of entities and associated business processes : • Lists and workflows via [SharePoint designer 2013]  Development of Web parts components : • IDE [Visual Studio 2012] Technology [.Net / SPMetal / LINQ Queries], Language [C#]  Configuration of SharePoint services (Excel services, reporting services and performance Point services) for rendering ENVIRONMENT: SHAREPOINT SERVER 2013, SHAREPOINT DESIGNER 2013, VISUAL STUDIO 2012, (SPMETAL / REQUÊTES LINQ /.NET / C#) PROJECT 2: ELECTRONIC DOCUMENT MANAGEMENT (EDM) PLATFORM AND MAIL MANAGEMENT FOR ANSUT -- ABIDJAN, IVORY COAST MISSIONS : ANSUT requested QuinTsens Consulting to lead its project of implementing an electronic document management platform to more effectively control document flows and mail that continuously circulate in the company. The main goal was to be able to move away from physical paper documents, benefit from the power of SharePoint's document content search engine, facilitate and track document approval mechanisms by hierarchy, and especially have flexible archiving to be able to quickly retrieve an archive. MISSION DETAILS :  Scoping then replication of the production environment under Hyper-V virtual machine  SharePoint server 2013 Intranet portal under Windows Server 2012 r2, with Active Directory and Exchange Server for mail delivery  Development via SharePoint Designer 2013 of the EDM Workflow (document type list, content type modification, notifications at each validation step, archiving ...)  Creation, modification, deletion of SharePoint accounts and deployment of the .wss solution ENVIRONMENT : HYPER-V (PORTAIL INTRANET SHAREPOINT SERVER 2013 SOUS WINDOWS SERVER 2012 R2, AVEC ACTIVE DIRECTORY ET EXCHANGE SERVER POUR DELIVRER LES MAILS), SHAREPOINT DESIGNER 2013 PROJECT 3: BUSINESS INTELLIGENCE PLATFORM FOR ANSUT RELATING TO ELECTRONIC GOVERNANCE PORTAL MANAGEMENT FOR THE IVORIAN GOVERNMENT -- ABIDJAN, IVORY COAST MISSIONS : - QuinTsens Consulting proposed to ANSUT to experiment in its environment the use of a new business intelligence platform (pilot site) to monitor activity performance and be able to anticipate in making critical decisions for managers. We therefore developed this platform in collaboration with client teams until the validation of different presentations. DETAILS :  KPI validation and mockups (reports & Dashboard) in project team  Selection of the most suitable "BI" solution (SQL Server 2012 Business Intelligence)  Warehouse design and identification of data sources (csv files and Sql Server data tables)  Development via (SSIS 2008 r2) of the ETL engine, report creation via (Report Builder 3.0) and dashboards via (MS Performance Point Services and PowerPivot) then integration into SharePoint Server 2013 ENVIRONMENT : (SQL SERVER 2012 BUSINESS INTELLIGENCE), REPORT BUILDER 3.0, (MS PERFORMANCE POINT SERVICES ET POWERPIVOT), SHAREPOINT SERVER 2013

PROJECT : DEVELOPMENT OF NSIA GROUP'S NON-LIFE EXTRANET PORTAL FOR MANAGING THE NON-LIFE INSURANCE PORTFOLIO -- ABIDJAN, IVORY COAST MISSIONS : NSIA Technologies, a subsidiary of NSIA Group, initiated a project to implement a Web portal for managing its insurance customer portfolio. MISSION DETAILS :  Assistance in the business intelligence project scoping study and specifications writing  PU/UML modeling, use case elaboration and class diagrams, database design and Web application development with class generation via Entity Framework, (Asp.Net MVC, Telerik)  Configuration, deployment and development of operating manuals ENVIRONMENT: VISUAL STUDIO 2012, ENTITY FRAMEWORK, (ASP.NET MVC, TELERIK) PROJECT : BUSINESS INTELLIGENCE SOLUTION FOR NSIA GROUP SECURITY SYSTEM MANAGEMENT -- ABIDJAN, IVORY COAST MISSIONS : The Security Division of NSIA Technologies initiated a project to implement a business intelligence tool allowing the monitoring of security incidents for analysis and forecasting purposes regarding the risks of new anomalies occurring. MISSION DETAILS :  Scoping and KPI validation  Comparative study between the Talend open source solution and the proprietary MS SQL Server BI solution  Design of the data warehouse (SQL Server, .csv Files, SCOM, SharePoint data lists), development (for comparison purposes) of 3 data extraction engines using Pentaho Data Integration 5.0.1, Talend Open Studio 5.3.0 and SSIS 2008 r2 then loading into the data warehouse  Report creation and deployment via SharePoint Server 2010 portal (Jasper report 5.1.0, SSAS 2008 r2 and SSRS 2008 r2) ENVIRONMENT: PENTAHO DATA INTEGRATION 5.0.1, TALEND OPEN STUDIO 5.3.0 ET SSIS 2008 R2, REPORT BUILDER 3.0, (JASPER REPORT 5.1.0, SSAS 2008 R2 AND SSRS 2008 R2)