Senior Expert Access/Excel/VBA/SQL Server Developer/Dot.Net Web/MVC/EF/Azure, Troubleshooter, Optimizer, UI Enhancements, etc... I have 34+ years of experience working with Access, Excel, and then integrating them into harmonious fluid applications, whether it be for the Desktop, or on a WAN. I have developed using every version of Microsoft Office and SQL Server since inception. I specialize in Finance and Manufacturing, including CRM, Inventory and Work Order Management, Job Costing, AR, AP, Purchasing and Sales Forecast Automation, etc. I feel those environments are structurally synonymous with most any other scenario. My current experience involves Loan Origination and Servicing. Working in Finance and Manufacturing, I could not afford to make mistakes. My work ethic developed beginning with my father and being in the Military, in the field of Aviation, where a tiny mistake could cost lives. I am detail oriented with an eye for efficient user friendly complete, from the ground up, to the most custom application imaginable. I have proven complex methods that are far more efficient than the conventional developer, regardless of how well they score on a test; I am the person that goes the extra mile(s) to adhere to the rules of development while maintaining a fluid user friendly interface. I develop from the ground up or customize pre-existing systems. Whether I am developing in Access or Excel, I always structure the data for easy possible future migration, regardless of the interface. An interface can be easily replicated, but carelessly stored data can be very costly. My interfaces are fluid and user friendly. They utilize as much as the available functionality permits, by using Drop-down and List Boxes, and applying Event Code to link to related data without having to return to a menu or dashboard. I am extremely fluent in VBA, using various Object Models, i.e. Access, Excel, DAO, ADO, SQL, Class Modules, SQL Server T-SQL, Stored Procedures and Custom Functions and Triggers, SSMS, SSRS, and SSIS, etc. I write code that a lay person can understand. Where this is not possible, I comment the purpose and flow of the Code. I do not implement limitations, as a lot of developers do, that force the Client to always call on the developer every time a little change is needed. I develop in such a way that considers future expansion. The only time I would ever need to be called upon is to implement new functionality. I prefer to teach Clients the basics so that they can make the subtle physical design changes to the interface that they want, without destroying the integrity of the system. Because I follow the rules of development, the system is straight forward and easily understood. Core Skills, Software, and Framework are Microsoft Access, Microsoft Excel, VBA programming, SQL Server, Stored Procedures, Azure SQL Db, Aure Data Factory, M365, PowerAutomate, Dot Net Web Applications, Custom Business Application.

I'm a Mechanical Engineer (MSc.) with over 10 years of experience in software development and process automation. Since 2018, I've been running Smartcode Builders, a small development team of 5 people focused on automation, web applications, and data solutions. Most of my work involves understanding a client's operational problem, designing a solution, and coordinating my team to deliver it. I handle the communication, the project planning, the quality review and the technical execution together with my team. It's a setup that has worked consistently well: 343 completed projects and a 100% Job Success Score on Upwork since 2017. What we work on: Before starting Smartcode Builders, I spent 10 years as a Project Manager and Project Leader at Indesca, a Venezuelan industrial company, working on polymer processing, production optimization, and data-driven process improvement. That background gives me a practical understanding of industrial and engineering problems that most software developers don't have. At Smartcode Builders, we currently work on: - Automation of business processes (data pipelines, report generation, workflow optimization) - Web application development (custom business tools and dashboards) - Algorithm design and data analysis for engineering and financial applications - API integrations connecting existing systems What I'm looking for: I work best on projects with some complexity — where clear thinking, good communication, and reliable delivery matter more than just writing code fast. I enjoy both one-time projects and longer engagements where I can understand the full context of a client's business. If you have a problem that needs a structured solution and a team that delivers reliably — I'm happy to discuss it.

Summary of Qualifications 1. Specialist on Mainframe Z/OS, AS/400 iSeries ,Windows Server 2019, UNIX and Linux systems. 2. Mainframe Development COBOL, JCL, VSAM, CICS 3. Development on AS/400 RPG/400, RPG ILE, CL/400, COBOL/400, SQL/400 4. Micro Focus Development COBOL, NetCOBOL, PeopleSoft 5. Data Migration on Mainframe and AS/400 to SQL Server and other Database 6. Development on Visual Studio 2022 - C#, VB.NET, ASP.NET 7. Development on Visual Studio - VB6, Visual FoxPro 9 8. Php/ MySql, ,HTML, XML, JavaScript, jQuery 9. Specialist Implement, maintain and customize ERP Systems (JD Edwards, Baan ERP) 10. Implement and maintain backend and Database of JD Edwards, Baan ERP System - BPCS, JD Edwards, Baan ERP Systems in AS/400 11. Open source Programs (Joomla, Zencart, Magento, Drupal,) 12. SAP/R3, SAP Business One Education: 1. Bachelor of Science in Information Systems - 1991, ACTON University – UK 2. Diploma in Computer System Design National Institute of Business Management (NIBM), Sri Lanka 3. Diploma in Computer System Design DMS Computer Center 4. Diploma in Advance Programming IDM Computer Studies Colombo, Sri Lanka 5. Advance Diploma in Computer Hardware Engineering 6. Advance Programming in JAVA Languages Career History 2009–2014 Acentria Solutions, Dubai, UAE Information Technology Manager- Habitat Hotel, Jeddah. KSA  Implement and maintain backend and Database of JD Edwards, Baan ERP System  Customize of JD Edwards, Baan ERP System reports in AS/400  Development Implement and maintain backend and Database of JD Edwards, Baan ERP System  Customize and Implement Application Software for organization ( RPG/400, RPG ILE, CL 400, Visual Basic .NET 2005, C#)  Monitoring & maintaining the internal network , WLAN & FIBER OPTICAL , Enhancing and operating on WIN 2003 SERVER , ISA SERVER 2006,MAIL EXCHANGE SERVER  Hardware and software maintenance.  MSSQL 2000, ORACAL 9i Servers Maintained and troubleshooting  Developed and enhance PAYROLL System – Developed in Microsoft Visual Studio 2005  Installation and support of systems, networking, devices, software and hardware equipment.  System support on technical and programming solutions. TECHNICALSKILLS  Php/ MySql, ,HTML, XML, JavaScript, jQuery  Open source Programs (Joomla, Zencart, Magento, Drupal,)  Microsoft Visual Studio 2005, 2008 ( VB.NET, C#.NET)  Microsoft MQL Server 2005, 2000  RPG/400, CL/400, COBOL/400, SQL/400  Oracle 9i  SAP/R3  Java  ASP

I am Senior .NET Developer with 10+ years of experience building scalable SaaS platforms, enterprise applications, REST APIs, cloud-native systems, and AI-powered business solutions using C#, ASP.NET Core, SQL Server, and Microsoft Azure. I help startups and enterprises build secure, high-performance applications with clean architecture, modern cloud infrastructure, and scalable backend systems. ## Core Skills ✔ C# / .NET 8 / ASP.NET Core ✔ REST API Development & Microservices ✔ Microsoft Azure (App Services, Functions, Service Bus, Storage) ✔ SQL Server Optimization & Database Design ✔ Entity Framework Core & Dapper ✔ Angular, React, JavaScript & TypeScript ✔ JWT Authentication, OAuth2 & OpenID Connect ✔ Docker, CI/CD Pipelines & GitHub Actions ✔ Clean Architecture & SOLID Principles ## AI & Automation Expertise ✔ OpenAI / ChatGPT API Integration ✔ AI Chatbots & AI-powered Applications ✔ Semantic Kernel & AI Automation ✔ RAG Pipelines & Vector Search ✔ Prompt Engineering & Structured Outputs ✔ AI-assisted Development using Claude, Copilot & ChatGPT ## What I Can Help You With • Build scalable SaaS applications • Develop secure REST APIs & microservices • Migrate legacy .NET Framework apps to .NET 8 • Optimize APIs, SQL queries, and backend performance • Deploy and scale applications on Azure • Integrate AI/LLMs into existing systems • Improve architecture, maintainability, and scalability ## Why Clients Work With Me ✔ 10+ years of professional software development experience ✔ Strong communication and reliable delivery ✔ Clean, maintainable, production-ready code ✔ Experience with startup and enterprise environments ✔ Long-term collaboration mindset If you need a reliable .NET Developer, Azure Expert, or AI Integration Specialist, feel free to invite me to discuss your project.

💻 Full Stack Developer | MS Access, VBA, SQL Server, Excel, Azure, React, Firebase 🌟 Professional Summary With over 25 years of experience, I specialize in building and maintaining applications that help businesses operate more efficiently. My expertise ranges from legacy desktop systems to modern web and mobile solutions, always focused on solving real business problems through automation, scalability, and reliable support. 💡 How I Can Help ✔ Workflow Automation: Streamline operations using MS Access, Excel VBA, and SQL Server ✔ Legacy System Modernization: Upgrade VB6, VB.NET, and ASP applications to modern platforms ✔ Database & System Integration: Build and integrate ERP, CRM, and APIs for seamless workflows ✔ Web & Mobile Development: Develop responsive applications using React, Next.js, and Firebase ✔ Business Intelligence: Create dashboards and reports using Power BI for actionable insights ✔ Enterprise Tools Support: Enhance productivity using Azure, SharePoint, PowerApps, and Dataverse 💼 What I Do Best ✔ Microsoft Access Database Development (Forms, Queries, Reports) ✔ VBA Automation (eliminating repetitive manual work) ✔ Order Management & Inventory Systems ✔ Data Cleanup, Normalization, and Optimization ✔ SQL Server Integration & Backend Scaling ✔ Fixing slow or broken Access databases ✔ Workflow Automation for real-world business processes 🔥 Real Business Impact I don’t just build databases—I solve business problems. I’ve worked with clients for 4+ years on long-term engagements, helping them: Reduce manual data entry by up to 70% Improve order processing speed Eliminate duplicate and inconsistent data Maintain reliable and scalable systems ⭐ Client Feedback (5.0 Rating) “Roy has been great to work with in providing a monthly service for our company. He has worked with us on several projects over the last four years. He is very knowledgeable and responsive despite the time difference.” “Our company has worked with Roy for 4 years on various projects. He consistently understands requirements and delivers results as expected.” “Roy is easy to work with and highly skilled at solving application-related issues. He quickly understood my challenges and provided effective solutions.” “Roy is very responsive and easy to work with. He completes projects quickly and efficiently.” “I had the pleasure of working with Roy on an existing Access application. His expertise, patience, and clear communication exceeded my expectations. He explained complex concepts clearly and ensured the system worked exactly as needed.” 🚀 Proven Results ✅ Designed an accounting system used by 158+ active clients since 2006 ✅ Delivered mission-critical systems including POS, HRIS, payroll, hotel, and restaurant systems ✅ Developed AQUABIZ, a water refilling business app with real-time inventory and sales tracking 🧠 Why Clients Choose Me ✔ Specialized in Microsoft Access (not a generalist) ✔ Strong understanding of real business workflows ✔ Clear communication and dependable delivery ✔ Focus on long-term, scalable solutions ⚙️ Typical Projects I Handle Food / Retail Order Management Systems Inventory Tracking Systems CRM & Data Management Tools Reporting Dashboards Legacy Access System Optimization Access + Website / API Integration 💬 Let’s Work Together If your current system is: ❌ Slow ❌ Manual ❌ Error-prone ❌ Difficult to manage I can help you transform it into a fast, automated, and reliable system. Let’s discuss your project 👍

25+ years in Software Development Available for 40-60 hrs./wk. Excellent references from CEOs of the companies. Bringing products to market: inception, spec, architecture, implementation, testing. Seeking for software development projects in the following areas on Windows Platforms: - Recent successful GPT-3/3.5/4 API experience with C#, DALL-E interface, and OpenAI Whisper. - Experience of developing RAG Web Service enabling chatting with private corpus of documents, based on Azure Cognitive Search SDK, Azure OpenAI API and Azure Cosmos Vector DB for vector, hybrid, and semantic search. Segmenting Word/PDF/Excel/CSV/Text documents, embeddings, and ingestion. - Worked with ML.NET in VSTO Outlook Add-In environment for email classification. - Experience with Text-To-Speech and Speech-To-Text using AWS, Azure, Google, Eleven Labs, and other vendors. Experience with Google Voice Services, including Diarization (recognition of different speakers and designation in the transcript), and Medical Transcription. Able to produce STS (Speech-to-Speech) application - interacting with ChatGPT over microphone and speakers. Recent Development Experience of TTS with OpenAI. - AI Training of basic GPT models using fine-tuning, and embedding techniques with vector databases, such as Pinecone, Qdrant, and Milvus APIs. - OpenAI Completion and Embeddings API, GPT-3/3.5/4, Whisper API for Transcribing and Translation - Azure Semantic Kernel, Azure Data Explorer (ADX), Azure Blob Storage, Azure Analytical Services. - AWS Text-To-Speech, AWS Storage - Web Services: REST-API, ASP.NET Framework and Core, WCF Web Services, Microservices - Azure Active Directory Authentication from Desktop Applications in C# - Desktop applications with C#/.NET Framework/.NET Core, WinForms, WPF, DevExpress - Microsoft Office VSTO/COM Add-Ins for Outlook, Excel, Word, and PowerPoint - Client/Server Systems: Sockets and high-level protocols, such as HTTP, FTP, MQTT - Windows Services - Microsoft Dynamics 365 - Hardware Interface: USB/RS232/RS485 Technologies and Frameworks: - Languages: C#, C/C++, Python, MicroPython, XML, JSON - Databases: SQL, SQLite, MySQL, Entity Framework 6/Core and LINQ. - Networking: Sockets (.NET and Winsock), REST API, WCF, HTTP, FTP, MQTT, packet-level TCP/IP, - Serial (RS232/RS485), MODBUS. - IDE: Visual Studio 2010 through 2022 - Office Add-Ins: VSTO Add-ins for Outlook, Excel, Word, PowerPoint. Add-In Express Framework. - VOIP: PJ SIP Stack with DBUS, Asterisk, Open Phone Abstract Library (OPAL) - Active Directory/LDAP/ADSI - Monte Carlo Simulations in C# - Linux: C/C++ and Python with MQTT Development on Ubuntu and Raspbian. - AES256 Encryption, Monte-Carlo Simulations, SHA256, PGP/GnuPG PKI (Public Key Infrastructure) Application binaries signing (Authenticode), Security Certificate generation in code based on CA. - Installers with Advanced Installer, Deployment strategies. - Product Licensing

I am a Senior .NET Architect and full-stack developer specializing in business applications, Blazor, DevExpress XAF, API integrations, and AI-powered workflow automation. I help businesses build reliable software that saves time, automates manual work, improves visibility, and connects their tools into one smooth process. My core expertise includes: • ASP.NET Core Web APIs • Blazor Server and Blazor Web Apps • DevExpress XAF, XPO, WinForms, and reporting • SQL Server, MySQL, SQLite, and Airtable • n8n workflow automation • AI integrations with Claude/OpenAI • CRM and lead management systems • API integrations and backend architecture • Windows Server / IIS deployment • Business dashboards and internal tools Recent AI-focused projects include: • LeadFlowAI: an AI-powered lead automation platform that captures leads from a public website, sends them through n8n, stores records in Airtable, qualifies leads with Claude AI, generates follow-up messages, and provides a secure Blazor dashboard for monitoring leads, workflows, AI logs, messages, and failures. • SignalDeskAI: an AI-assisted business dashboard concept focused on monitoring operational signals, surfacing useful insights, and supporting better decision-making through organized data views and intelligent summaries. These projects reflect the kind of systems I enjoy building most: practical business software with clean .NET architecture, useful automation, AI-assisted workflows, and dashboards that help teams understand what is happening in their operations. I am especially useful for clients who need: • A custom business application • A Blazor or DevExpress XAF system • An AI-powered automation workflow • n8n, Airtable, or third-party API integration • A secure ASP.NET Core API backend • A dashboard for operations, reporting, monitoring, or decision support • Modernization of an existing .NET application I focus on clear communication, reliable delivery, and building systems that are practical for real business use.

35 years of experience in software engineering complemented by solid knowledge of computer science, mathematics and electrical engineering.

I’m a Top Rated Plus .NET Back-End Developer with 14+ years of experience and over $1M in Upwork earnings, specializing in robust, scalable, and high-performance systems built on the Microsoft stack. I’ve delivered enterprise-grade solutions to clients across many countries, helping businesses in e-commerce, SaaS, healthcare, and logistics transform their backends into powerful, efficient engines that drive growth and reliability. My focus is always on your business outcomes in clean code, maintainable architecture, and consistent delivery that enhances performance and ROI. 1. Advanced .NET Technologies: Expert in C#, .NET Core (including .NET 6/7/8), ASP.NET MVC, and Web API for building secure, scalable RESTful APIs and microservices architectures. I ensure your applications are fast, maintainable, and ready for future expansion. 2. Cloud & DevOps Expertise: Architect and deploy cloud-native solutions using Microsoft Azure (App Services, Functions, Azure SQL, Key Vault) and AWS. I design CI/CD pipelines, use Docker containers, and implement microservices and serverless functions to achieve agility and scalability. 3. Database & Performance Optimization: Experienced in SQL Server and Entity Framework, I design efficient schemas, write optimized queries, and use caching and indexing strategies to maximize speed and responsiveness. My focus: applications that run smoother and scale effortlessly. 4. Business-Focused Results: I deliver automation, cost efficiency, and measurable performance gains. For instance, I’ve helped eCommerce clients cut API response times by over 60% and enterprises scale their systems without increasing infrastructure costs through smarter architecture and optimized code. 5. Reliable Communication & Delivery: Native-level English fluency ensures clear communication across time zones. I provide transparent progress updates, honor deadlines, and approach every engagement, whether a sprint or a long-term collaboration, with reliability and professionalism. -------------------------------------------------------------------------------------------------------------------- GoHighLevel Certified Expert Troubleshooting & Automation Specialist 100% ready to TAKE ACTION on all YOUR Go High Level needs | Let’s Connect Now! I love working on challenging GoHighLevel Projects, micro & macros, and looking forward to a video/phone call to assess your needs whenever you need me, seven days a week, 4 hrs a day! Helping businesses scale to their highest level. The true power of GoHighLevel is your business growth. Helping businesses achieve success like you deserve their max potential by leveraging GoHighLevel marketing & automation. QA & Testing Expertise Includes: - Manual Testing (Functional, Regression, Smoke, Sanity, UAT) - Automation Testing using Selenium, Cypress, and Playwright - API Testing (Postman, Swagger, REST Assured) - Performance & Load Testing with JMeter - Test Case Design, Test Execution & Defect Reporting - End-to-End QA Process Setup and CI/CD Integration - Cross-Browser & Cross-Platform Testing for Web and Mobile Apps If you have a troubleshooting need or are interested in automating your operation for further growth, then I look forward to hearing more from you. You’ll appreciate my work ethic, professionalism, and ability to navigate complex tasks with excellent project follow-through. Whether you’re a startup building your next SaaS, an enterprise modernizing legacy systems, or a company scaling your platform, I’m here to deliver a back-end solution that’s secure, fast, and built for the future. Certified GoHighLevel Consultant working remotely, helping brands launch, re-launch & scale online, leveraging the Go HighLevel Software CRM system/tools. Go High Level is constantly updating its software, and my part-time hobby is remaining on the leading edge and testing new features while sharing them out to clients immediately for more effective results. I’m happy to work on any challenging GoHighLevel Projects, micro or macros, and looking forward to a video/phone call to assess your needs whenever you need me, seven days a week, 4 hrs a day! What I Offer: - Platform Setup & Configuration - Marketing Automation - Sales Pipeline Creation - CRM Implementation - SMS & Email Campaigns - Booking & Appointment System If you’re interested in our profile and experience, please feel free to reach out if you’d like to discuss anything further. Available to get hired on a Part-time, Full Time and Dedicated Basis Let’s talk about your goals and explore how I can help you bring your .NET project to life. Message me anytime to get started.

I have developed a wide range of desktop products, using C, C++, STL, Win32, Visual C++, MFC, COM, QT and C#, and Office Addin development. During my work in five Product Engineering teams, I have also created functional requirements, defining the scope of work , proof of concept, software design, software development, and client interfacing. Besides being an Individual Contributor, I have also played Techno Managerial roles - requirement gathering, software design, work breakdown, and end to end implementation of projects within the scheduled time . I also have experience on UML, Software Architecture and creating software roadmaps.