Business Analyst & Excel VBA Programmer

• Proven track record supporting major pharmaceutical companies, delivering solutions across procurement, engineering, HR, and GxP compliance

• 20+ years of hands-on experience automating complex processes using Excel/VBA, Power BI, and Python, enabling significant productivity boosts and data reliability in cross-functional teams

• Strong background in data migration, process mapping, UAT, and reporting automation across 28+ clients in 10 industries, with a focus on turning fragmented data into actionable insights

• Native English speaker with fluency in German and Dutch and experienced in global project environments. Strong background in stakeholder management across international projects

Team Procurement:

• Creation of automated Project Master Plan and other procurement templates

• Testing of PMP and Web App. Creation and enhancement of Power BI reports

• Intensive interaction with procurement leadership and lead & category buyers

Team Engineering CWM, Creation and automation of:

• Contingent Worker Contract and Allocation Tracker

• CWM Supplier Tracker

• GxP Training Assessment Tracker

• LSO Transition Plan Macro

• CW Demand File

• Candidate Pipeline Macro

Capital Adequacy team:

• Automation of Group AG, AG Standalone, AG Consolidated and CH AG scopes for both RWA and LRD (8 automated dashboard reports). Automation of IRB Equity

• analysis, RWA all scopes and RWA N0001 by BD processes, Power BI

Financial Accounting and Controlling team:

• Process automation of comparison between consolidation platform data (Group Legal Entity Analysis Macro), creation of automated & customised data transfer tool (RAW_DBS_Data Macro)

Regulatory Reporting team:

• Correction and enhancement of FINMA, MONA Variance macro, AO Macro - Drilldown MONA, MIRE_DailyRecon, AO Refresh EURO and CAG01-CAG09 Aggregation macros

Liquidity and Funding team:

• Process optimisation and automation of Liquidity Coverage Ratio (LCR), Liquidity Crisis Template (LCT), Daily versus monthly LCR differences and Risk Based Approach for internal and external models required by FINMA (RBA)

Treasury team:

• Enhancement, automation and daily running of Liquidity Crisis Template (LCT)

LIFT team:

• Support of various automated processes

• VBA Training of a number of colleagues

• SAP Hana Migration Project

• Creation of Assortment Planning, Category Planning and Promotion Planning toolboxes as well as a Language Mapping Tool using Excel VBA

• Querying using SAP BW

• Business Objects. Large scale SAP implementation

• Using Excel VBA to automate 4 Treasury and 4 Finance and Governance processes

• Adaptation of 150 Business Critical and Sarbanes-Oxley Critical EUC’s to make them compliant with PWC requirements

• VBA Automation of Movers Risk analysis to flag toxic accounts

• Using Excel VBA to convert PowerShell downloads from Exchange Server to Target AD compatible data using the Target Active Directory Object Naming Convention Policy

• Data cleanse of Target AD

• Creation of an automated Excel/Access VBA and SQL based Inline WSSI

• Enhancements to and debugging existing Missed Opportunity Excel/Access VBA and SQL based application

• Creation of technical and user guides

• Adaptations to SOX User Profiles Excel VBA application

• Data Migration and reconciliation from Stellent to BWise (Sarbanes Oxley based Risk management systems)

• Creation of macro’s to convert Stellent downloads into compatible BWise uploads