VBA Experts in Switzerland
, matched in minutes from over 15,000 CVsHire experts who build reliable Excel automation, connect Office applications and modernize complex reporting workflows. FRATCH matches you quickly and precisely with vetted, available freelancers for projects across Switzerland.
Meet FRATCH Experts in Switzerland, who have recently used VBA
Thorsten O.
Last position:
Program / Project / IT Controller (ICT Controller) at Federal Department of Defence, Civil Protection and Sport
Project Management Office: analysis and setup, master plan, standardized project planning (generic work breakdown structure according to HERMES), earned value management, milestone trend analysis.
Finance management at portfolio, program and project level.
Resource management and single point of contact for resource procurement (human resources / operating costs / investments).
Process management.
Implementation of a program management tool for unified program and project management.
Program controlling: finance management, earned value management, milestone trend analysis, consolidation of project budgets, actual costs and forecasts at the program level.
Variance analyses at program level.
Transition from total cost view to commitment credit view (federal administration terminology).
Calculation of available reserves (rolling), forecasts and scenarios.
Monthly, quarterly, half-year and annual reports, preparation of annual planning at program level, special analyses / ad-hoc reports.
Project controlling: support for project managers in project planning, earned value management, milestone trend analysis.
Review of projects for budget compliance, adherence to phases and schedules, deliverables, resource planning and deployment.
Variance analyses at project level, special analyses / ad-hoc reports.
Resource management: resource planning based on program and project plans, review of timesheets.
Supply chain (until April 2022): single point of contact for resource procurement (human resources / operating costs / investments).
Change management: involvement in change management for cost-relevant changes (change requests), tracking of service contract price for contract-related changes, participation in change control boards / decision boards at management level.
Establishment of controlling structures in a new Swiss federal agency (becoming a federal office as of January 1, 2024) since April 2022.
Credit monitoring with validation of actual costs and commitment values.
Resource management: cross-project resource planning (HRP).
Earned value analysis and milestone trend analysis for key ICT projects of the federal government.
Participation in the introduction of the JIRA Tempo module.
Tools & methods: HERMES 5.1 / Agile HERMES, Sciforma 7, JIRA, Confluence, Tempo, Signavio, Microsoft SharePoint, Microsoft Office Prof., Excel-VBA.
Jakob F.
Last position:
Core Team Member at Jafa Consulting
- SME for operational processes, contract negotiation and product design for the implementation of a SaaS contact center solution & carrier services
- Definition of several operational processes, organizational setup, ITSM application integrations, creation of contract schedules and advising contract negotiation
- Scrum Master with agile tooling (processes & automation)
- Commercial manager to create business cases and closing the sales process
- Increasing impact, trusted relationship, and key team member within a short time
Piotr S.
Last position:
CTO Program Manager, Theme Owner / Senior Project Manager at Avaloq Group AG
- Clients: Central banks of the most developed economies in the world, German, Swiss, Luxembourgish, Monegasque, Singaporean, Japanese wealth managers and universal/private banks, world’s largest investment banks
- Accountable for managing the delivery of a portfolio of digital wealth and consumer relationship management initiatives
- Project managing portfolios of projects within CTO product and technology business area (cyber security, architectural changes, re-organisational transformation, 3rd party apps)
- Products: Kernel & Parametrisation for Core Avaloq Banking Platform; modules: CRM, client data management, wealth management, portfolio management (generating over 90% of company revenues)
- Key responsibilities:
- Reporting to Head of Disruptive Innovation Division; stakeholder to five product owners & two domain owners
- Accountable for delivery of annual themes and quarterly key deliverables
- Managing demand vs supply via QBR process: book of work, execution, reporting, risk management
- Directly managing around 40 external consultants (front-end/back-end engineers, BAs, designers)
- Hiring and managing resources in eight countries
- Running quarterly divisional closure meetings presenting achievements and challenges
- Resolving cross-team dependencies and internal/external conflicts
- Owning and controlling maintenance budget; planning, forecasting, execution; ensuring demand matches supply
- Identifying and staffing key roles with chapter leads
- Approach: Agile, Scrum of Scrums, QBR/OKRs
- Technology: Angular, PL/SQL, JavaScript, Confluence, JIRA (JQL)
Philipp S.
Last position:
Equity Portfolio Manager - Digital Wealth Management at Interactive Brokers LLC
- Solely responsible for two portfolios totaling USD 1 million with an average monthly performance of 2%
- Responsible for the investment strategy, specializing in US equities and ETFs (exchanges: NASDAQ and NYSE)
- Market, trend, data, and technical chart analysis
- Risk management – diversification, daily/weekly risk mitigation measures (rebalancing) to ensure optimal portfolio profitability
Reinhold S.
Last position:
Senior Software Developer at Hitachi Energy
- Support and further development of the Leegoo Builder
- Handling ad hoc requests
- Definition of rules/attributes and their rules
- Optimizing and managing SQL queries
Károly A.
Last position:
NIS2 & Risk Strategy Consultant at RRC power solutions GmbH
- Developed a compliant information security management system (ISMS)
- Advanced a modern risk management framework based on NIST for NIS2 compliance
Max R.
Last position:
ICT Solution Architect Senior at ewb, Energy, Water
- Questioning and discussion of technical requirements and coordination with the team
- Contributing to objectives of the Digital Transformation Services unit and implementation of objectives
- Analyzing, specifying, updating and delivering architecture models to implement digital solutions in line with business, data infrastructure and requirements
- Selecting suitable technical options for application design considering interoperability, reversibility, scalability, usability, accessibility and security and optimizing cost/quality ratio
- Creating and maintaining concept documents, architecture models and other technical documentation
- Reviewing services to be provided and other documents for solution development
- Collaborating with IT enterprise architect, business analyst, project manager, developers, testers and process owner in design and documentation of technical specifications for new and further developments
- Communicating and supporting concepts to relevant stakeholders
- Participating in enterprise architecture activities and ensuring compliance with principles, standards and guidelines
- Monitoring compliance with defined design at application, solution and enterprise level
- Developing and testing existing and new solutions as required
- Supporting and guiding development teams in implementation of new projects or maintenance of existing products, assuming product manager role if required
- Establishing and ensuring best practice in implementation, documentation, testing and packaging for distribution
- Contributing to handling of reported incidents and requests assigned to third level support and follow-up actions as required
Frank G.
Last position:
Project Lead at Flamingo Med Solutions
- Led the founding of a startup for AI-based consulting products for dental practices.
- Developed and launched PraxisScore, a data-driven consulting product for economic analysis and corporate consulting of dental practices.
- Held full responsibility for technical implementation, AI integration, and structured startup setup from product idea to public launch at IDS 2025 in under three months.
Jürgen A.
Last position:
Requirements Engineer / System Engineer at CCC Systems Engineering Suisse GmbH
- Supported design, setup, maintenance and enhancement of IBM Rational DOORS (9.6 and DNG) and IBM Rational Publishing Engine
- Conceived IT solutions and implemented them, including acceptance tests, considering customer-specific requirements
- Ensured functionality of tools and systems in scope
- Identified needs and advised departments and projects, designed single solutions when necessary
- Monitored and maintained central requirements engineering systems (servers, software, subcomponents)
- Advised on tool selection, features and application use cases for engineering applications
- Handled support requests from employees, customers and development teams autonomously
- Created system documentation and user guides
- Participated in cross-departmental IT projects and led subprojects
David B.
Last position:
External Project Manager in the Supply Chain Network at DEUTZ AG
- Project management (SAP BN (Ariba) onboarding, support for SAP ECC and SAP TM for supplier topics)
- Standardization of global value creation processes
- Basic training as well as central contact person for suppliers and support for planners
Reto B.
Last position:
Managing Director at Atsoft GmbH
- Consulting in ICT, business processes, system architecture, web integration, client-server computing, cross-platform development, responsive web design, social media integration, GUI
- Custom and specialized solutions
- Applications for small and medium-sized enterprises
- Web services, web applications, portals, application extensions (add-ins, plug-ins)
- Database design, interface solutions
- Outsourcing in various industries
- Solutions for other software houses
- Project management and project support (software engineering, coding)
Csaba K.
Last position:
ServiceNow Consultant at DXC
- Worked in mixed teams with several clients
- Performed requirement engineering, proposal and time estimation
- Developed ACLs, business rules, flows, workflows, catalog items, various scripts, UI actions, policies, scoped applications
- Customized mobile apps: Now Agent and Now Mobile
- Implemented integrations using the Integration Hub
- Coordinated continuously with clients during development
- Performed testing and helped clients with testing
- Deployed to production and applied main version upgrades and patches
- Managed CMDB, domain separation and asset management
- Integrated between instances at different clients
- Developed GlideScript: business rules, scripted REST endpoints, extension points, fix scripts, background scripts
Oliver S.
Last position:
Managing Director and Employed Actuarial Consultant at ARCS Actuarial and Risk Consulting Stoll GmbH
- Advising insurance companies on modeling, reporting, valuations, risk management and acting as the responsible actuary
- 2023–2025: Improving Solvency II software, annual financial statements (HGB, SII), process optimizations, pricing, SQL and Python-based reports for AXA Germany, Cologne
- 2022–2023: Support for portfolio transfer (RAFM optimization; impact on HGB balance sheet, SII, reinsurance; migration to msg.Life Factory) for Zurich Germany, Cologne
- 2021 and 2024: Redesign of Solvency II model, implementation in Python and model extensions; testing and documentation for PK Rück, Zurich
- 2021–2023: Control calculations for maturity benefits of contracts; specification and testing of policy administration system for product launch at Youplus, Liechtenstein
- 2021: a) Support in preparing a reinsurance treaty: project management and analyses; b) assistance with Solvency II reporting and multi-year planning for Allianz Leben, Stuttgart
- 2020–2021: Further development and optimization of models with Risk Agility FM (RAFM), integration into IFRS 17 reporting process using Unify for Allianz Slovakia and Bulgaria
- 2017–2023: Quality improvement of the RAFM model; methodology development; documentation; process optimization in reporting and planning; automation with Excel and Oracle SQL (on COR-Life); implementation of a life reinsurance treaty; validation of numerical results in the policy administration system for SV Versicherung, Stuttgart and Mannheim
- 2015–2017: Project management and senior actuary in developing an actuarial projection tool and in the IMAP process with the regulator; guiding the reporting team; analyses; methodology development; process design; coordination with IT, asset and risk management for Allianz Leben, Stuttgart
- 2016–2020: Review of cash flow models for investment projects for B Capital, Zurich
- 2015: Redevelopment of MCEV calculation methodology based on MVBS; weakness analysis and collaboration on fixes for Allianz SE, Munich
- 2014: Solvency II risk capital reporting project: validation of data deliveries; analyses for management and regulator; tool development; process and documentation improvements; training of team members for Aegon Group, The Hague, Netherlands
Beat Z.
Last position:
SAP Test Manager at E.ON Grid Solutions GmbH
- Responsible for IT integration test and user acceptance test for SAP S/4 Hana and BDO BO Customer Financials Management
- Led the test team (business testers and IT testers)
- Resource planning and control within the test team
- Created test concepts and test plans
- Performed test risk analysis
- Coordinated test execution and defect tracking
- Ensured test progress
- Generated and visualized reports
- Summarized test reports and reported to management
- Prepared and conducted user acceptance tests
- Managed SIGMA and JIRA/Confluence at project level
Daniel L.
Last position:
SQL, .NET and VBA Developer at Postfinance AG
- For the internal MIS, which gathers data in a complex, comprehensive system landscape and loads it into a central database via ETL, existing processes and packages had to be maintained and new KPIs analyzed, specified, and implemented.
Discover over 15,000 top freelancers
Statistics of experts using VBA
Aggregated from the professional profiles of matched freelancers.
Experience
25 years
Position duration
2 years
Positions per freelancer
18
Top business areas
Information Technology, Project Management, Business Intelligence
Top industries
Information Technology, Professional Services, Banking and Finance
Certification focus areas
Information Technology, Project Management, Product Development
Bachelor's degree or higher
71%
Master's degree or higher
64%
Doctorate
7%
Certifications per freelancer
7
Most common languages
English, German, French
Speak two or more languages
100%
Based on our profile pool as of 19 Sep 2026.
Daily rate distribution
The chart shows how the daily rates of freelancers in this technology in Switzerland are distributed, based on recent contracts on our platform. Each bar covers a rate range — its height shows how many freelancers charge within that range.
Average rates of experts in Switzerland using VBA
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 19 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
VBA experts industry focus
See which industries our matched freelancers work in most often — every figure is calculated live from the freelancers on FRATCH.
- Information Technology (90%)
- Professional Services (75%)
- Banking and Finance (65%)
- Manufacturing (60%)
- Government and Administration (60%)
- Insurance (50%)
- Telecommunication (50%)
- Automotive (35%)
Please note that freelancers can work across multiple industries, so percentages overlap.
About the technology
What VBA does
VBA, or Visual Basic for Applications, is Microsoft’s programming language for automating tasks inside Excel, Access, Word, Outlook and other Office applications. Companies use it to turn manual spreadsheet work into repeatable processes, while preserving familiar Office-based workflows. It is especially useful where business rules, structured templates and user input must work together.
Typical solutions
VBA specialists create tools that support finance, operations, sales, procurement and reporting teams. Common deliverables include:
- Excel models with automated calculations, imports and validations
- Reporting workbooks that consolidate data from multiple sources
- Access applications for forms, records and operational workflows
- Outlook routines for document generation, mail handling and scheduling
- Office templates with controlled inputs and repeatable outputs
Ecosystem and skills
Strong VBA work involves more than writing macros. Professionals work with Excel formulas, PivotTables, Power Query, Power Pivot, Access databases and the wider Microsoft Office object model. They may also connect VBA to SQL databases, CSV files, APIs, shared folders and enterprise systems through carefully designed interfaces.
When companies need help
Freelance expertise is useful when a workbook has become business-critical, difficult to maintain or dependent on one person’s knowledge. Companies also bring in specialists to replace manual copying, stabilize fragile macros, migrate legacy Access tools or connect Office processes with other systems. In Switzerland, clear documentation and collaboration across German-, French- and English-speaking teams can matter as much as technical delivery.
Quality signals
A capable VBA professional separates business logic from presentation, uses meaningful structure and handles errors consistently. They protect sensitive data, account for different Excel environments and test realistic user scenarios instead of relying only on a successful demo. Good documentation, maintainable modules and clear handover materials make the result usable after the engagement ends.
Remote delivery and scope
VBA projects often work well remotely because source files, requirements and test cases can be shared securely. On-site collaboration may help when the workflow depends on local processes, restricted systems or close work with business users. Before starting, define the Office applications involved, data sources, security constraints, expected outputs and who will own the solution after delivery.
Frequently asked questions
Everything clients usually want to know about VBA, in one place.
VBA is mainly used to automate tasks and workflows in Microsoft Office applications, particularly Excel and Access. Companies use it for data transformation, reporting, document creation, validation, custom forms and connections to databases or other business systems.
VBA is well suited to interactive Office workbooks, desktop automation and processes that depend on Excel’s object model. Power Query is often preferable for repeatable data preparation, Power Automate for cloud-based workflow orchestration and Python for broader data processing or application development. The right choice depends on the existing Microsoft environment, governance needs and long-term maintenance plan.
A strong VBA specialist often understands advanced Excel formulas, PivotTables, Power Query, Access, SQL and data modeling. Experience with APIs, file formats, Outlook automation, version control and information security can also be valuable when the solution reaches beyond a single workbook.
The required level depends on the risk and reach of the solution rather than the size of the macro itself. A simple personal workbook may need focused automation skills, while a shared financial model or operational Access tool calls for expertise in architecture, testing, error handling, permissions and handover.
Yes, VBA work can often be delivered remotely when files, requirements and test data can be shared securely. On-site sessions may still help when specialists must observe local processes, work with restricted systems or train users directly. Agree on communication language and documentation expectations early, especially across Swiss teams.
Review whether the VBA solution is structured, tested and understandable to someone other than its author. Ask for examples of error handling, input validation, documentation, performance tuning and compatibility across the Office environments your team actually uses.
Yes, VBA can read and write files, query databases and interact with compatible applications or web services through suitable interfaces. A specialist should assess authentication, permissions, data protection, failure handling and whether a direct connection is appropriate for your IT environment.
Keep VBA when the workflow is closely tied to desktop Office use and can be made stable, documented and secure. Consider another solution when the process needs broad browser access, high-scale concurrency, centralized deployment, strong audit controls or integration that exceeds what Office automation can reliably support.
The average hourly rate of freelancers in Switzerland who have used VBA in their recent projects is 124 €, which corresponds to a daily rate of about 995 € based on an 8-hour working day.
Of the freelancers in Switzerland who have used VBA in their recent projects, 71% hold at least a Bachelor's degree, 64% hold at least a Master's degree, and 7% hold a doctorate.
On average, freelancers in Switzerland who have used VBA in their recent projects have 25 years of professional experience, with a single engagement typically lasting around 2 years.
The most common languages among freelancers in Switzerland who have used VBA in their recent projects are English (100%), German (95%), and French (45%).
The most common industries among freelancers in Switzerland who have used VBA in their recent projects are Information Technology (90%), Professional Services (75%), and Banking and Finance (65%).
The most common business areas among freelancers in Switzerland who have used VBA in their recent projects are Information Technology (95%), Project Management (85%), and Business Intelligence (75%).
Main locations of FRATCH Experts, who have recently used VBA
Our freelancers and interim experts are at home across the DACH region — available on-site in the major business hubs or fully remote. Choose a location to discover matched specialists, local market insights and up-to-date availability.
Zurich Request a free demo
Get in touch with the FRATCH team and we will get back to you within 4 hours.
Would you rather directly get in touch?
We always have the time for a call or email!
Philipp Thomaschewski
FRATCH CEO
