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.

Excel · MS Access · VBA · SQL · Workflow Automation · Database Design If you are looking for a seasoned technology consultant who builds scalable, professional-grade Access and Excel systems—not just one-off tools—I can help. ✔ 100% Upwork Job Success ✔ 100% Client Satisfaction ✔ Microsoft Certified ✔ 20+ Years of Experience ✔ Founder and Developer of Bid4Build Software (nationwide adoption) Many freelancers can build forms, macros, or basic automation. Very few can architect complete, enterprise-level solutions—solutions that support hundreds of users, sustain business operations, and remain maintainable over time. That is the difference I bring. I specialize in turning fragmented spreadsheets, manual workflows, and complicated business processes into robust, automated, and structured systems using MS Access, Excel, VBA, SQL, and relational database design. What I deliver: • Custom business applications using Access, Excel, and VBA • Database architecture, normalization, and performance tuning • Inventory, quoting, purchasing, financial and operations systems • Workflow design and data automation using SQL and VBA • System modernization — Access to SQL Server migration, structured upgrades • Dashboard and reporting automation using Excel and Power Query • Business process consulting — translating complex requirements into a well-architected solution What sets me apart: I have led both small and large-scale solution builds. I built Bid4Build Software from the ground up—an estimating and operations platform used by thousands of construction businesses nationally. That experience is not just about programming; it is about designing systems that must work for real businesses, at scale, with clear workflows, reliable performance, and user adoption. Clients value my ability to: • Understand their business process quickly • Identify inefficiencies, gaps, and risks in existing systems • Propose better structures—cloud, hybrid, local, or Microsoft-based • Build a clean, scalable database and application layer • Deliver within budget, on time, without over-engineering Whether you have an Access database that needs repair, a spreadsheet that has grown too complicated, or a business process that needs to be structured into a working system, I help bring clarity, structure, and stability. No-cost initial review: I am happy to review your existing files, workflow, or requirements at no cost. You will receive guidance on feasibility, best approach options, and a recommended structure before any commitment. Ready to turn fragmented tools into a well-designed business solution? Let’s connect and start building something that actually works.

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.

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

💻 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 👍

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.

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.