I am a Senior Business Intelligence consultant specialising in the end-to-end project management of business intelligence solutions through a balanced focus on technical best practice, end-user experience and commercial objectives. I currently coordinate multiple high value projects including a complex legacy migration to Power BI dashboards and a billion-dollar reconciliation reporting solution for Shell’s trading division; expanding my already robust technical expertise as well as demonstrating my capability to lead high performing teams operating on an international scale. I have previous experience providing software tools and designing bespoke products for a broad range of established private and public sector clients and now I am looking to progress to a position of increased scope and responsibility that fully utilises my proven technical knowledge, leadership ability and business acumen.
-
Lead Data EngineerShell Apr 2020 - PresentLondon, England, Gb• Multi-Tenant project which digitally transforms finance data to provide periodic reporting and remove focus on manual workarounds and data manipulation.• Introduction of Delta Lake to store data on ADLS Gen2.• Development of Azure Analysis semantic model to connect to Power BI.• Creation of dynamic framework using Azure Data Factory, Databricks, Data Lake and Synapse Analytics.• Handling of tactical and strategic development work streams to absorb technical debt with vigorous controls.• Introduced database governance covering table distribution, optimisation and performance. -
Senior Data EngineerShell Apr 2020 - PresentLondon, England, Gb• Creation of dynamic framework using Azure Data Factory, Databricks, Data Lake and Synapse Analytics.• Harmonisation of data from over 50 source systems including SAP ECC, API’s, Oracle and SQL.• Orchestration of pipelines via ADF. Transformation of data using Databricks via Python notebooks to evoke change data capture and metadata enrichment.• Storage of avro/parquet files on ADLS in delta format.• Dynamic creation of External tables utilising polybase to dynamically merge data on harmonised or curated Synapse Analytics.• Manage and monitor workload levels to identify concurrency or scaling issues.• Audit and capture errors and robust handling of schema evolution.• Creation of DevOps pipelines for CI/CD across 3 environments connected to GitHub repositories.• Liaise with scrum masters along with testers to plan robust unit testing and deployment roadmaps.
-
Senior Data EngineerShell Jul 2020 - Jun 2021London, England, Gb• Project converting complex trading Excel spreadsheet expressions into automated logical workflows on Azure.• Integration of credit rating data from 3rd Party API’s.• Conversion of 600+ DAX expressions into T-SQL optimised to run on Azure SQL Database.
-
Azure - Senior Data EngineerShell Nov 2017 - Apr 2020London, England, Gb• Key member of a skilled group of developers • Required to drive the adoption and integration of Power BI within Shell• Responsible for highlighting issues and opportunities for the service • Liaise with Microsoft to seek resolutions and improvements to the reporting tool• Convert legacy SSRS reports into fully operational Power BI dashboards• Document and approves visualisations to replace deprecated legacy functionality• Create common data models via Power Query and data enrichment via DAX• Orchestrate automation of Azure Data Factory pipelines to feed data into Azure Synapse DWH• Integrate paginated reporting using Power BI Report Builder
-
Bi Report Developer:Royal Dutch Shell Nov 2012 - Dec 2016London, England, Gb• Key report developer tasked with the development and enhancement of business-critical reports • Introduced semantic layers using Universes or Bex queries to generate business ready report data• Deployed dashboards and reports on Webi, Xcelsius, Design Studio and Tableau• Liaised with business stakeholders to determine report requirements and more
-
Ssrs Technical LeadRoyal Dutch Shell Jan 2013 - Nov 2016London, England, Gb• Migrated over 50 SSRS projects • Centralised the run and maintenance of reports on an Enterprise Reporting Platform• Designed the SSRS landscape with multi service tiers, load balancing and infrastructure support• Delivered a security model to allow business driven and self-service report solutions • The above had over 5,000 users• Developed documents and test plans, co-ordinated the migration of reports from legacy systems• Identified and triaged report defects caused by deprecation of functionality • Provided 3rd Level support on issues of security, performance, server administration and more
-
Senior Etl DeveloperRoyal Dutch Shell Sep 2012 - Dec 2014London, England, Gb• Designed and developed data load processes for low to high complexity projects • Utilised BODS and SSIS for the above• Utilised the batch and real-time capabilities of tools to ensure the successful migration of data • Construction of Data Source connections to on premise systems • These include SQL Server, Oracle, HANA, SAP BW and flat files• Integrated cloud-based connections including Web Services, API’s, Amazon S3 and Azure• Custom built PowerShell scripts, generated WADL/WSDL and .xsd files for API’s connectivity • Extracted data from source systems whilst satisfying governance and control guidelines• Use of in-built tools and methods for optimisation and data cleansing
-
R&D Software DeveloperZonal Retail Ltd Jun 2007 - Sep 2012
-
Software DeveloperSnowdrops Systems 2004 - 2007
Alan Miller Education Details
-
MicrosoftMcsa: Bi Reporting -
MicrosoftMcts: Sql Server 2008 Database Development
-
Glasgow Caledonian UniversityInformation Technology
-
Stow CollegeHnd Software Development
Frequently Asked Questions about Alan Miller
What company does Alan Miller work for?
Alan Miller works for Shell
What is Alan Miller's role at the current company?
Alan Miller's current role is Senior Data Engineer.
What schools did Alan Miller attend?
Alan Miller attended Microsoft, Microsoft, Glasgow Caledonian University, Stow College.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial