Hire the Best VBA Developers
in the United States

Does your Excel-based tool keep breaking, or are you building something new and need it done right the first time? I work with businesses that rely on Excel and VBA to run their operations — fixing broken macros, building custom tools from scratch, and creating automated reports that pull from multiple data sources without manual work. Recent projects include a custom CRM in Excel for a training company to manage students and course enrollment, automated invoice and reporting systems for operations teams, and Power BI dashboards connected to live data sources. I bring an engineering mindset to every project: I don't just make it work, I make it maintainable, documented, and built to last. What I can help you with: ✔️ VBA tools and macros — new builds or fixing existing code ✔️ Automated reports pulling from CSV, databases, or multiple Excel files ✔️ Power Query data pipelines and transformations ✔️ Custom Excel applications (trackers, CRMs, invoicing systems) ✔️ Power BI dashboards connected to your data ⭐ "One of the best people I've had the luck of working with on Upwork... I wouldn't even think about working with anyone else for similar work. Seriously, stop looking and just work with Ana." — Verified Client, 5.0

I help businesses automate Excel and Microsoft Office workflows using VBA and API integrations—reducing manual effort, improving reliability, and increasing accuracy. I support both focused one-off projects and ongoing automation partnerships. WHAT I HELP WITH • Custom Excel VBA automation for complex, high-volume workflows • Microsoft Office automation (Excel, Access, Outlook, PowerPoint) to integrate data and streamline end-to-end processes • Integration with external systems and services (databases, SharePoint, QuickBooks, and other web-based platforms/APIs) • User-friendly, point-and-click dashboards (no VBA knowledge required) with KPIs and reporting • Tools for quoting, invoicing, budgeting, pricing, and multi-source / multi-account data consolidation • Improving, refactoring, and stabilizing existing Excel/VBA solutions to boost speed, reliability, and maintainability My focus is on building automation that non-technical users can run confidently—reliable, intuitive, and easy to maintain. EXPERIENCE I’ve delivered 250+ Excel/Office VBA automation projects for a wide range of businesses and teams, from quick workflow fixes to large, multi-phase systems. Many of these solutions support high-volume, data-heavy processes where accuracy, speed, and reliability are critical. A large portion of my work focuses on building and modernizing end-to-end Excel tools—streamlining data entry, validation, transformation, reporting, and document outputs—so non-technical users can run complex workflows with confidence while saving countless hours of manual work and improving accuracy and consistency. Many engagements are ongoing rather than one-off tasks. I often act as an extension of a client’s team, maintaining and enhancing existing automation over time as requirements and workflows evolve. CREDIBILITY Top Rated Plus freelancer with 100% Job Success. Many of the projects I work on turn into long-term client relationships and repeat engagements. GOOD FIT I work well with clients who rely on Excel and other Microsoft Office applications and want clean, reliable automation—whether it’s a small one-off task or something that may grow into a longer-term engagement. I place a strong emphasis on usability, clarity, and maintainable solutions. If you’re looking for an experienced Excel/Office VBA developer who can integrate Excel with other systems—databases, SharePoint, QuickBooks, and web-based services/APIs—in a practical, production-ready way, I’d be happy to discuss your workflow.

I’m a senior Excel VBA developer with 29 years of corporate-level experience automating spreadsheet processes, enhancing productivity, and modernizing legacy applications. My clients have included MassMutual, The Hartford, Pratt & Whitney, Connecticut Children’s Medical Center, CVS/Health, and more than 85 Upwork clients. For Cornerstone Real Estate Advisers (a MassMutual subsidiary), I developed a suite of proprietary budgeting tools that saved the firm over $1 million in commercial software licensing fees. The suite of asset-type-customized workbooks ran successfully for two decades and was widely preferred to commercial software alternatives across a user base of 100+ property management companies in the U.S. and Canada. Excel VBA is my specialty. I build and code robust automation solutions, eliminate time-consuming manual tasks, and stabilize unstable or error-laden workbooks. I also integrate Excel with Word, Outlook, and other MS Office applications for data-driven document generation and communication workflows. With advanced writing skills and an editor’s keen eye, I deliver top-shelf documentation. I write clean VBA code that is easy to follow, maintain, and troubleshoot, using a style refined over nearly three decades—far more readable, efficient, and maintainable than typical auto-generated macro code. I'm experienced collaborating with professionals in finance, accounting, engineering, and actuarial science—delivering tools that streamline operations, enhance decision-making, and stand the test of time. I favor a structured, incremental development process—guided by clear communication and steady progress toward the right solution. My goal isn’t just to deliver working code—it’s to create lasting value, delivered clearly, with precision and purpose.

I build and improve business systems that people actually rely on — data pipelines, approval workflows, reporting platforms, and automation tools built on Excel, VBA, and SQL. My longest engagement is an 8-year partnership with a 15,000-person construction enterprise, where I built their entire analytics infrastructure from scratch. The platform consolidates data across 15 regional branches, 12 project management teams, and their subcontractors — tracking 100+ active projects down to materials, equipment, and personnel. Used daily by 300+ employees across the organization. Most of my clients come back. Construction, real estate, fitness, trading, manufacturing — different industries, same pattern: something wasn't working well enough, now it does. If you have a system that needs to be built right, or one that needs to finally work the way it should — let's talk. What I work with: Excel VBA · SQL Server · Complex reporting · Approval workflows · Data integration · Long-term support

As a freelance developer, I am a specialist in Microsoft Office applications with over 25 years of experience including macro coding with VBA (Visual Basic for Applications). I am also skilled in database design and development with Microsoft Access or SQL Server, and I have very recent experience with Google sheets data management and scripting with Apps Script. Working independently or with your team, I can help you with tasks such as Access database design and development or maintenance, Microsoft Office and Google scripting and automation, creating or modifying spreadsheets with formulas and formatting, and Microsoft Word document organization, formatting and scripting. I can perform conversions such as PDF to Excel with Python and web scraping using Python and libraries such as Beautiful Soup. I am a skilled technical writer and will fully document the work I do, including user instructions, when required. My project portfolio below includes three Access database projects, a Google Sheets project with scripting, two projects with automation for both Excel and Word, two additional Excel and another Word automation project, an Excel design project, an XML conversion project, and a web scraping project. My extensive IT experience includes .NET software development for Windows servers and desktops and SQL databases. In my most recent full time position, I designed and developed an application using OCR to locate key information such as party names on printed real estate and other legal documents handled by city and county clerks. Now in use by many customers, the application facilitates automatic verification of the names submitted electronically with the documents or keyed by a data entry person. The development language was C# and the database is SQL Server running as a service under Windows. The code reads XML output from an OCR process and uses extensive regular expression coding to locate information and format it for database storage. A project in my portfolio below includes automation with Excel of the regression testing for this application. I have developed WPF/XAML desktop applications with C# and with WinForms using C# and VB. I also have developed web applications using JavaScript, AJAX, HTML and CSS with backend database access to SQL server coded using C#. I developed one application with React, a copy of the popular Wordle game, using an external API. Throughout my career I have leaned and applied skills such as software architecture, object oriented design and development, database design, technical writing, and problem solving. If you hire me for your project, I promise that I will always pay close attention to the details and accuracy to make sure that the result meets your requirements. Before starting a project, I will listen or read carefully to make sure I understand those requirements, and my written and spoken communication with you will be in clear and precise English. My hourly rate quoted in this profile is negotiable. If my skills are a match for your needs please send me an invitation and I will respond right away.

🧠 𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰 I help businesses get control over their data, automate repetitive work, and build dashboards that make decision-making faster and easier. If you're stuck with manual Excel spreadsheets, slow reporting, or data that looks "messy", I turn that into clean, automated systems. I work with Excel VBA and Power BI to build practical, real-world solutions that save time, reduce errors, and give teams the insights they need without the headaches. ⚙️ 𝐖𝐡𝐚𝐭 𝐈 𝐃𝐨 𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 I've been building Excel VBA tools for 15+ years, and I love taking a messy, manual process and turning it into a clean, automated workflow. Clients typically see their reporting time drop by 50%–80%, and their teams can focus on analysis instead of fixing spreadsheets. 𝐓𝐲𝐩𝐢𝐜𝐚𝐥 𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧𝐬 𝐢𝐧𝐜𝐥𝐮𝐝𝐞: • Quoting, invoicing, and pricing tools • Inventory and order tracking systems • Automated financial reports • Data cleaning and transformation tools • Workflow automation systems 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝𝐬, 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 & 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 For the past 8+ years, I've been building Power BI dashboards that turn raw data into clear, interactive visuals that teams enjoy using. My focus is on clarity, usability, and helping you get the answers you need quickly—without digging through multiple spreadsheets. I also support the full data workflow behind the dashboards, including data transformation, modeling, and analysis to help businesses make smarter decisions. 𝐖𝐡𝐚𝐭 𝐈 𝐃𝐞𝐥𝐢𝐯𝐞𝐫: • KPI and performance dashboards • Financial and sales reporting • Executive-level summaries • Operational analytics • Power-Query data transformation • DAX measures and KPI development • Data modeling • Trend and performance analysis 🏭 𝐈𝐧𝐝𝐮𝐬𝐭𝐫𝐢𝐞𝐬 𝐈 𝐖𝐨𝐫𝐤 𝐖𝐢𝐭𝐡 Finance | E-commerce | Construction | Retail | Healthcare | Non-profits 🛠️ 𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 𝗦𝗸𝗶𝗹𝗹𝘀 𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 & 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 🔹Excel VBA (Macros) 🔹Excel automation systems 🔹Report automation 🔹Data extraction & processing 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 & 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 🔹Power BI 🔹DAX 🔹Power Query 🔹Power Pivot 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 & 𝐑𝐞𝐩𝐨𝐫𝐭𝐢𝐧𝐠 🔹Data analysis 🔹Dashboard development 🔹Data visualization ⭐ 𝐂𝐥𝐢𝐞𝐧𝐭 𝐅𝐞𝐞𝐝𝐛𝐚𝐜𝐤 "Shai made it easy and had great ideas to simplify our order form. We went from a multi-page, multi tab order system with more than 800 options to a one-line Order form with multiple self-populating fields. We're planning to work with Shai again in the future. Excellent job and thank you again!" — Christian, EcoDomo LLC "Shai is an excellent choice to work with. He delivered Power BI materials on a very tight turnaround for our organization. He really saved the day with his follow-up support and continues to help our materials best reflect our data. I highly recommend Shai for all his listed skill sets and I look forward to working with him again!" — Robert Sanchez, CipherTrace