{"id":6,"date":"2026-01-12T23:25:29","date_gmt":"2026-01-12T23:25:29","guid":{"rendered":"http:\/\/timallan.uk\/index.php\/curriculum-vitae\/"},"modified":"2026-01-15T22:07:53","modified_gmt":"2026-01-15T22:07:53","slug":"curriculum-vitae","status":"publish","type":"page","link":"http:\/\/timallan.uk\/index.php\/curriculum-vitae\/","title":{"rendered":"Curriculum Vitae"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" style=\"font-style:normal;font-weight:700\">Tim Allan<\/h1>\n\n\n\n<p style=\"font-size:clamp(0.875rem, 0.875rem + ((1vw - 0.2rem) * 0.531), 1.3rem);\"><strong>Senior Data Engineer &amp; BI Architect<\/strong><\/p>\n\n\n\n<p>Bromley, London \u00b7 <a href=\"https:\/\/www.linkedin.com\/in\/timallanbi\/\">LinkedIn<\/a> \u00b7 <a href=\"https:\/\/github.com\/TimGAllan\">GitHub<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Profile<\/h3>\n\n\n\n<p>Data engineering leader with over 20 years of experience architecting enterprise-scale data warehouses, building ETL pipelines, and delivering business intelligence solutions that drive strategic decision-making. I specialise in transforming complex, disparate data sources into unified, high-performance analytics platforms that serve thousands of users.<\/p>\n\n\n\n<p>Throughout my career, I have built and led high-performing data teams, implemented modern DevOps practices for data infrastructure, and delivered solutions processing millions of transactions across global operations. I combine deep technical expertise in SQL Server, Python, and Power BI with strong business acumen in financial and operational analytics.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Technical Expertise<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Data Engineering &amp; Warehousing<\/h4>\n\n\n\n<p>SQL Server \u00b7 T-SQL \u00b7 SSIS \u00b7 Kimball Methodology \u00b7 Star &amp; Snowflake Schema Design \u00b7 ETL Pipeline Development \u00b7 Data Modelling \u00b7 Informatica<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Analytics &amp; Visualisation<\/h4>\n\n\n\n<p>Power BI \u00b7 DAX \u00b7 SSAS \u00b7 Cognos \u00b7 Advanced Excel \u00b7 Real-time Dashboards \u00b7 Self-Service BI<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Development &amp; Automation<\/h4>\n\n\n\n<p>Python (Pandas, NumPy, Scikit-learn) \u00b7 Git &amp; GitHub \u00b7 Azure DevOps \u00b7 CI\/CD Pipelines \u00b7 VBA \u00b7 PL\/SQL<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Platforms &amp; Tools<\/h4>\n\n\n\n<p>Microsoft Azure \u00b7 Salesforce &amp; SOQL \u00b7 PeopleSoft \u00b7 SQL Server Management Studio \u00b7 Azure Data Studio \u00b7 VS Code \u00b7 Jupyter Notebooks<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Career History<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Sprint Enterprise Technology<\/h4>\n\n\n\n<p><strong>Senior Data Engineer<\/strong> \u00b7 November 2022 \u2013 Present<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h4 class=\"wp-block-heading\">Adecco UK &amp; Ireland<\/h4>\n\n\n\n<p><strong>Business Intelligence &amp; System Accounting Manager<\/strong> \u00b7 August 2014 \u2013 October 2022<\/p>\n\n\n\n<p>Led a team of 9 data professionals delivering enterprise BI and data warehousing solutions for one of the world&#8217;s largest recruitment companies. Reported directly to the Group Finance Director with responsibility for all data infrastructure across UK &amp; Ireland operations.<\/p>\n\n\n\n<p><strong>Key Achievements:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Architected a Salesforce data warehouse<\/strong> integrating CRM data with multiple business systems, enabling analysis of 40+ KPIs to identify high-value sales pipelines and optimise team performance<\/li>\n\n\n\n<li><strong>Delivered near real-time Power BI analytics<\/strong> to 1,900 users with hourly data refreshes, drill-down functionality, and direct Salesforce record linking<\/li>\n\n\n\n<li><strong>Engineered a global ETL pipeline<\/strong> feeding CRM data into Informatica-based global data warehouse, supporting operations across 60 countries<\/li>\n\n\n\n<li><strong>Implemented DevOps practices<\/strong> using Git and GitHub, enabling collaborative development and reducing deployment downtime<\/li>\n\n\n\n<li><strong>Built the business case for Power BI Premium<\/strong>, successfully securing executive investment to modernise the company&#8217;s analytics capabilities<\/li>\n\n\n\n<li><strong>Designed payroll and billing data warehouse<\/strong> enabling detailed client analysis to identify and re-engage lapsed accounts<\/li>\n<\/ul>\n\n\n\n<p><strong>Business Intelligence Manager<\/strong> \u00b7 July 2010 \u2013 August 2014<\/p>\n\n\n\n<p>Managed the BI function through a major organisational restructuring, rebuilding the team from the ground up while maintaining service delivery.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Rebuilt the entire BI team<\/strong> after restructuring\u2014recruited, trained, and developed 6 analysts while reducing headcount through strategic automation<\/li>\n\n\n\n<li><strong>Delivered HMRC legislative reporting<\/strong> on schedule with zero budget through innovative resource allocation<\/li>\n\n\n\n<li><strong>Consolidated 9 disparate data sources<\/strong> into a unified ETL framework using SQL Server and Cognos<\/li>\n<\/ul>\n\n\n\n<p><strong>Systems Accountant<\/strong> \u00b7 November 2006 \u2013 July 2010<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Served as Subject Matter Expert<\/strong> for PeopleSoft 9.0 implementation, leading data migration and reconciliation of 44 million transactions<\/li>\n\n\n\n<li><strong>Developed automated margin accrual system<\/strong> for multiple brands with combined annual turnover exceeding \u00a3400 million<\/li>\n\n\n\n<li><strong>Built P&amp;L reporting solution<\/strong> using Cognos and SQL Server, transforming financial reporting capabilities<\/li>\n<\/ul>\n\n\n\n<p><strong>Earlier Roles<\/strong> \u00b7 January 2003 \u2013 November 2006<\/p>\n\n\n\n<p>Progressive career growth through Assistant Management Accountant, Commissions Analyst, Senior Payments Co-ordinator, and Electronic Data Manager positions\u2014building foundational expertise in payroll systems, financial processes, and data management.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Education<\/h3>\n\n\n\n<p><strong>BSc (Hons) Natural Sciences: Physics and Astronomy<\/strong><br>The Open University \u00b7 First Class Honours \u00b7 2011\u20132015<\/p>\n\n\n\n<p style=\"font-size:clamp(0.875rem, 0.875rem + ((1vw - 0.2rem) * 0.094), 0.95rem);\">Advanced coursework in quantum mechanics, astrophysics, and general relativity. Final year project: computational analysis of co-orbiting exoplanet detection methods.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Certifications<\/h3>\n\n\n\n<p><a href=\"https:\/\/www.credly.com\/badges\/f114de60-7727-4935-ada9-e150f9d17ed2\"><strong>Microsoft Certified: Azure Fundamentals (AZ-900)<\/strong><\/a> \u00b7 2022<\/p>\n\n\n\n<p><a href=\"https:\/\/www.coursera.org\/account\/accomplishments\/verify\/VTF7CC8SPZRM\"><strong>Stanford University Machine Learning<\/strong><\/a> \u00b7 Coursera \u00b7 2021<\/p>\n\n\n\n<p><a href=\"https:\/\/courses.edx.org\/certificates\/0ba95b5c160c4434be3379f566cc3d7c\"><strong>Introduction to Programming in C++<\/strong><\/a> \u00b7 edX \u00b7 2021<\/p>\n\n\n\n<p><strong>Microsoft Office 2013 Master Specialist<\/strong> \u00b7 2015<\/p>\n\n\n\n<p><strong>edX Data Science &amp; Analytics Track:<\/strong> Power BI \u00b7 Python for Data Science \u00b7 Data Analysis with Python \u00b7 Transact-SQL \u00b7 Excel for Data Analysis \u00b7 2015\u20132019<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Leadership &amp; Soft Skills<\/h3>\n\n\n\n<p>Team Leadership &amp; Development \u00b7 Stakeholder Management \u00b7 Executive Communication \u00b7 Requirements Analysis \u00b7 Agile Project Delivery \u00b7 Technical Documentation \u00b7 Training &amp; Mentoring \u00b7 Vendor Management<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tim Allan Senior Data Engineer &amp; BI Architect Bromley, London \u00b7 LinkedIn \u00b7 GitHub Profile Data engineering leader with over 20 years of experience architecting enterprise-scale data warehouses, building ETL pipelines, and delivering business intelligence solutions that drive strategic decision-making. I specialise in transforming complex, disparate data sources into unified, high-performance analytics platforms that serve [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-6","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/timallan.uk\/index.php\/wp-json\/wp\/v2\/pages\/6","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/timallan.uk\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/timallan.uk\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/timallan.uk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/timallan.uk\/index.php\/wp-json\/wp\/v2\/comments?post=6"}],"version-history":[{"count":4,"href":"http:\/\/timallan.uk\/index.php\/wp-json\/wp\/v2\/pages\/6\/revisions"}],"predecessor-version":[{"id":14,"href":"http:\/\/timallan.uk\/index.php\/wp-json\/wp\/v2\/pages\/6\/revisions\/14"}],"wp:attachment":[{"href":"http:\/\/timallan.uk\/index.php\/wp-json\/wp\/v2\/media?parent=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}