I am a Data Engineer & Analyst with 15 years of experience in data analysis, automation, migration, and reporting across production and project environments. I’ve migrated legacy databases to PostgreSQL and automated complex reporting processes, achieving up to 4x efficiency gains. I’m proficient in Python, SQL, VBA, Access, and Excel with strong troubleshooting skills, and I have delivered analytics dashboards using Tableau and Power BI. I’m known for attention to detail, problem-solving, and delivering fast, accurate results. I’m a collaborative team player who can balance competing priorities and consistently deliver quality work on time. In recent roles at UBS in Zurich, I led migrations of data pipelines to PostgreSQL and automated data workflows with Alteryx, Python, and SQL, boosting processing efficiency and data availability for 50+ users. I built dashboards and standard reports, streamlined reporting processes, and contributed to data governance and stakeholder visibility through BA/BI solutions.

Randal Dunkley

I am a Data Engineer & Analyst with 15 years of experience in data analysis, automation, migration, and reporting across production and project environments. I’ve migrated legacy databases to PostgreSQL and automated complex reporting processes, achieving up to 4x efficiency gains. I’m proficient in Python, SQL, VBA, Access, and Excel with strong troubleshooting skills, and I have delivered analytics dashboards using Tableau and Power BI. I’m known for attention to detail, problem-solving, and delivering fast, accurate results. I’m a collaborative team player who can balance competing priorities and consistently deliver quality work on time. In recent roles at UBS in Zurich, I led migrations of data pipelines to PostgreSQL and automated data workflows with Alteryx, Python, and SQL, boosting processing efficiency and data availability for 50+ users. I built dashboards and standard reports, streamlined reporting processes, and contributed to data governance and stakeholder visibility through BA/BI solutions.

Available to hire

I am a Data Engineer & Analyst with 15 years of experience in data analysis, automation, migration, and reporting across production and project environments. I’ve migrated legacy databases to PostgreSQL and automated complex reporting processes, achieving up to 4x efficiency gains. I’m proficient in Python, SQL, VBA, Access, and Excel with strong troubleshooting skills, and I have delivered analytics dashboards using Tableau and Power BI. I’m known for attention to detail, problem-solving, and delivering fast, accurate results. I’m a collaborative team player who can balance competing priorities and consistently deliver quality work on time.

In recent roles at UBS in Zurich, I led migrations of data pipelines to PostgreSQL and automated data workflows with Alteryx, Python, and SQL, boosting processing efficiency and data availability for 50+ users. I built dashboards and standard reports, streamlined reporting processes, and contributed to data governance and stakeholder visibility through BA/BI solutions.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert

Language

English
Fluent
German
Beginner

Work Experience

Project Manager (Data Engineer) at UBS
September 1, 2025 - September 1, 2025
Led migration of 20+ critical data pipelines from Access to PostgreSQL, enabling real-time analytics and supporting 50+ users with 99.99% data availability. Engineered and automated data processing and enrichment workflows using Alteryx, Python, and SQL, reducing processing time by 70% and cutting manual intervention by 80% compared to the legacy Access-based process. Maintained, troubleshooted and reconciled complex data models in Access and PostgreSQL, ensuring high data quality and governance. Developed, deployed, enhanced and maintained interactive dashboards for tracking assets, flows, and activities using Tableau. Produced and standardized recurring business reports to accelerate turnaround time and improve stakeholder visibility. Designed and re-engineered reporting products, eliminating redundant processes and saving 16+ hours monthly.
Financial Reporting Analyst at responsAbility
May 1, 2016 - May 1, 2016
Implemented automation (VBA) of various complex Excel reports, increasing efficiency by 4x. Troubleshot problems with existing reports and created and maintained reporting process documentation.
Financial Reporting Specialist (FTC) at UBS
July 1, 2015 - July 1, 2015
Offshored reports to India as part of the TFF project. Developed new complex Excel reports leveraging VBA and Access, improving reporting accuracy and timeliness. Produced and delivered complex financial reporting in Excel and PowerPoint using Essbase, SAP BO, and manual data sources; supported offshore reporting transitions and training.
Reporting Specialist (FTC) at Experis @ UBS
February 1, 2014 - February 1, 2014
Engineered and automated comprehensive project completion status reports by integrating Excel, Access, and SharePoint data. Consolidated, reconciled, and analyzed datasets from multiple in-house IT inventory systems to improve reporting accuracy and reduce manual adjustments.
Reporting Analyst at Man Investments AG
October 1, 2012 - October 1, 2012
Designed, developed, and deployed a large-scale Access database application (supporting 30+ users) for tracking sales and client transactions, improving data accuracy and reporting speed by 35%. Automated reporting solutions using Excel, Access, SQL, and VBA; produced complex reports for senior stakeholders to support data-driven decisions.
Data Administrator at Man Investments AG
October 1, 2003 - October 1, 2003
Managed data administration, supported reporting, UAT testing, and client servicing to ensure smooth operations and data integrity.
Internet Engineer at Applicare AG - Staufen AG
August 1, 2000 - August 1, 2000
Performed internet engineering tasks and supported IT operations to maintain system reliability.
Various jobs at Sydney, Australia
December 1, 1999 - December 1, 1999
Early career roles across IT and administration, building a broad foundation in data, systems, and problem solving.
Project Manager (Data Engineer) at UBS
July 1, 2018 - September 1, 2025
Led migration of 20+ critical data pipelines from Access to PostgreSQL, enabling real-time analytics and supporting 50+ users with 99.99% data availability. Developed an Access-based helpdesk database for internal funds information requests. Engineered and automated data processing/enrichment workflows with Alteryx, Python, and SQL, reducing processing time by 70% and cutting manual intervention by 80%. Maintained and reconciled complex data models in Access and PostgreSQL, ensuring high data quality. Developed, deployed, and maintained dashboards using Tableau; produced standardized recurring reports; redesigned reporting products to reduce effort.
Business Process Manager at Experis @ UBS
October 1, 2016 - June 1, 2018
Designed, built, and automated Excel/VBA tools to transform after-sales data and automate presentation generation (5,000+ per month). Streamlined document management, providing technical support to resolve issues with websites to ensure 99% uptime. Optimized complex business processes and data flows, driving efficiency improvements. Improved reporting accuracy by creating and troubleshooting Business Objects outputs.
Financial Reporting Specialist (FTC) at UBS
May 1, 2014 - July 1, 2015
Offshored reports to India as part of the TFF project. Developed new complex Excel reports to simplify production. Standardized documentation and automated reporting templates using VBA and Access, reducing manual effort by 40%. Delivered complex reporting in Excel/PowerPoint using Essbase, SAP BO, and other data sources; led offshore transition projects and training.
Reporting Specialist (FTC) at Experis @ UBS
May 1, 2013 - February 1, 2014
Engineered and automated project completion status reports by integrating Excel, Access, and SharePoint data; Consolidated, reconciled, and analyzed multi-source datasets to improve reporting reliability.
Reporting Analyst at Man Investments AG
November 1, 2003 - October 1, 2012
Designed, developed, and deployed a large-scale Access database application supporting 30+ users to track sales and client transactions; improved data accuracy and reporting speed; automated advanced reporting using Excel, Access, SQL, and VBA.
Data Administrator at Man Investments AG
October 1, 2000 - October 1, 2003
Data administration responsibilities in a multi-system environment.
Internet Engineer at Applicare AG - Staufen AG
December 1, 1999 - August 1, 2000
Early career role in internet engineering and related tasks.
Various jobs at Sydney, Australia
January 1, 1991 - December 1, 1999
Early career roles across multiple functions in Sydney.

Education

Higher School Certificate at St Andrews Cathedral School, Sydney, Australia
January 11, 2030 - January 1, 1990
School Certificate at St Andrews Cathedral School, Sydney, Australia
January 11, 2030 - January 1, 1988
Higher School Certificate at St Andrews Cathedral School, Sydney, Australia
January 11, 2030 - December 15, 2025
School Certificate at St Andrews Cathedral School, Sydney, Australia
January 11, 2030 - December 15, 2025

Qualifications

ISTQB/ISEB Software Testing Foundation
January 11, 2030 - December 15, 2025
Advanced Excel
January 11, 2030 - December 15, 2025
Skill Assessment & Application Management
January 11, 2030 - December 15, 2025
Deutsch im Arbeitsmarkt
January 11, 2030 - December 15, 2025

Industry Experience

Financial Services, Professional Services, Media & Entertainment, Software & Internet