Freelancer profile translated to English.
Back to original languageAbout Rolland
🔧 Software Developer | 🚀 API Integrator | 💎 SQL Server DBA | 🌀 VBA Automation Expert
I help companies design, automate, and connect their internal tools.
Thanks to comprehensive expertise in back-end, databases, and API integration, I deliver robust, tailor-made, and documented solutions to increase efficiency and performance.
🎯 Technical Expertise
✅ Back-end Development: C#, .NET, VB.NET
✅ REST API & Inter-application Connectors Creation
✅ Advanced Automation: Excel VBA, SQL Server Agent, Batch Scripts
✅ SQL Server & PostgreSQL Administration: Stored Procedures, Security, Performance
✅ Third-Party Service Integration (Salesforce, ERP, CRM, FTP, etc.)
✅ Deployment: Windows Server, VPS, Hyper-V, VirtualBox
✅ Technical Support & Application Maintenance
🚀 Projects Completed
🔹 API Connector Development (Salesforce ↔️ Internal Apps)
🔹 Excel Reporting Automation + Automatic Sending (Email/FTP) via VBA
🔹 Android Mobile App for Barcode Scanning and Central Database Synchronization
🔹 Full Deployment of Business Applications on Windows Server + SQL
🔹 Complex VBA Macros for Financial and Logistics Management
🔹 Inter-ERP Synchronization via Custom REST APIs
🔹 Oracle → PostgreSQL Migration (Procedures, Scripts, Data)
🔹 SQL Backup and Scheduled Task Automation
🔹 API Development for Sage 100 and Custom Integration
🧩 My Strengths
✨ Dual Technical Expertise: Software Development & Database Administration
🔗 Global Vision of Information Systems (Automation, Security, Integration)
⚙️ Customized, High-Performance, and Sustainable Solutions
📚 Clear Documentation, Skill Transfer, Long-Term Support
📆 Availability
✅ One-off or Long-Term Missions
📩 Have a software project, automation need, or API integration requirement?
Contact me, I respond quickly.
French
Native or bilingual
English
Native or bilingual
Remote only
Primarily works remotely
Experience
- LNSTradeSage 100 Objects DeveloperRETAIL (LARGE RETAILERS)June 2025 - July 2025 (1 month)Strasbourg, France
🛠️ Mission: Design and deployment of a REST API for Sage 100
ContextAs part of a project to integrate Sage 100 with external platforms (B2B), the mission was to design, develop, and deploy a secure REST API to expose the main functionalities of Sage 100 Commercial Management.Objectives- Provide structured and secure access to Sage 100 data via RESTful endpoints
- Facilitate integration with third-party applications (CRM, ERP, e-commerce, etc.)
- Offer clear documentation for technical teams and partners
Deliverables- Development of an API in ASP.NET Core (.NET 8) based on Sage 100 business objects
- Implementation of JWT authentication and a rate-limiting system
- Integration of Serilog logs for traceability
- Exposure of endpoints for key entities: customers, orders, invoices, stock
- Full deployment on IIS (Windows Server)
- Writing of a comprehensive technical guide: installation, configuration, security, Swagger, Postman, best practices
Technical EnvironmentSage 100 v10, SQL Server, ASP.NET Core (.NET 8), Sage Business Objects, IIS, Serilog, Swagger, PostmanRole🔹 Technical design, development, and documentation🔹 Server configuration, security, post-deployment support🔹 Freelance, 100% remote interventions - LNS TradeSage 100 Expert – Automation & Flux IntegrationRETAIL (LARGE RETAILERS)August 2025 - September 2025 (1 month)
🛠️ Mission: Synchronization of Sage 100 data (purchases, sales, and items) with the logistics provider via SFTP
As part of optimizing the flow between the company and its logistics provider, data reliability and process efficiency are essential to ensure operational success. Hence the need to implement a system that ensures the compliance and consistency of data exchanges between Sage 100 and the logistics provider.ObjectiveImplement an automated system for synchronizing sales, purchases, and items between Sage 100 and the logistics provider via SFTP.AchievementsDevelopment of a module to extract orders (purchases and sales) and items from Sage 100, then automatically deposit the files on the logistics provider's SFTP server.Integration of the module into Sage 100 to offer users the ability to send an order with a single click.Development of a second module responsible for scanning the logistics provider's SFTP server folders and automatically updating the order progress status in Sage 100.Technical Environment: Sage 100 v10, SQL Server, C#, SFTP, EDIFACTRole: Design, development, server configuration, post-deployment support – mission carried out 100% freelance and remotely. - NumeriCubeSage 100 & SQL DeveloperRETAIL (LARGE RETAILERS)September 2024 - September 2024Paris, FranceContextTo streamline accounting exchanges between a company using Sage 100 and its external partners (accountants, auditors, etc.), a need for automating accounting entries exports was identified. The objective was to eliminate recurring manual tasks and improve the reliability of accounting data transfers.Objective
- Implement an automated module to:
- Extract accounting entries from Sage 100,
- Format them according to a predefined template (CSV, TXT, or other),
- And automatically transmit them by email and secure upload to an FTP server, according to a custom schedule.
Role- Design and develop a custom module integrated with Sage 100, based on business objects
- Create a dynamic SQL query to extract data based on custom criteria and columns
- Define and implement a flexible scheduling system (daily, weekly, monthly)
- Automate the sending of generated files to different channels (email, FTP)
Adapt the module's behavior according to the fiscal period- January to June: send entries for both fiscal years (N and N-1)
- July to December: send entries only for the current fiscal year
Deliverables- Automated export module integrated with Sage 100
- Generation of formatted files according to the accounting firm's specifications
- Automatic sending of files by email and upload to a secure FTP server
- Technical documentation and configuration guide
ResultThe implemented solution significantly reduced manual processing time, improved the reliability of transmitted data, and secured exchanges with accounting partners. The client now benefits from an autonomous, compliant, and easily maintainable system that effectively supports sensitive fiscal periods.
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master in Computer Science and TechnologyUIA2012Mathématique - Informatique - Statistique - Appliqué