Wayne Fillis Email & Phone Number

United Kingdom

- Team Lead- Agile delivery (KANBAN)- SQL Server, Azure, ADF, BLOB Storage- Python- Databricks

London Luton Airport, England, United Kingdom

- Mentoring, evaluation and training of permanent, 3rd party and offshore colleagues- Recruitment and interviewing of new staff- Development of Best Practices & How-To Guides for Data Science and Analytics teams- Decrypting, demystifying & documentation of complex internal easyJet processes re Data Governance, Vulnerability scanning, Data Protection, etc- Working closely with Data Governance and Data Cataloguing department- Working closely with the Data Protection Office and Data Protection Officer with regard to Personal Data and other Restricted data- Working closely with Business Analysts, Design Leads, Technical & Enterprise Architects, QA Engineers, and Data Engineers- Documentation and education of the use of Personal Data (PD) and restricted data to easyJet colleagues- Onboarding of Data Scientists to the Databricks data platform- Supporting the delivery of a big-data migration project from Cloudera to Databricks Data Lakehouse (data acquisition, ingestion, and curation into medallion layers (bronze, silver, gold)- AWS Glue was used in the form of a framework to pull data from source systm and convert to parquet files on S3 – ready for Databricks to ingest into the Bronze Layer- Line manager responsibilities including performance reviews- Working with 3rd party suppliers re staff resourcing and allocation to Data Science Product Teams- Contributing to the delivery workstream of the Customer Data Project (Databricks data ingestion and curation)- Certified Agile Scrum Master- AWS data ecosystem- Part of the team designing the new Product Teams Ways of Working / Operating model

London, United Kingdom

- Specialist in the Retail Solutions and Digital teams to deliver Data Engineering solutions, mentoring, training, documentation, hands-on mentorship and advice- Worked with various clients using Oracle, some Python and especially SQL Server (T-SQL / Azure SQL)- Hands-on technical leadership- My last project (4 years long) was a combined Lead & Principal role to support and build the data pipelines for 3 Retail products across 10 clients (approx. 60-100TB data), this included working in SQL Server (T-SQL) and more recently, involvement in the architecture & design of the migration to a more scalable solution with Azure Databricks (using ADF, Python and SQL with Spark Dataframes)o The department was 80 strong, and made heavy use of Airflow (running in Docker), Agile and JIRAo Jenkins was the main CI/CD toolo Oliver Wyman stored client data on Azure so Data Governance and Security was a critical aspect of my role in order to secure and protect the data• Hands-on 3-month project in Python with AWS EC2 and Auto Scaling Groups• I have some experience with panda, numPy and Jupyter Notebooks (Anaconda) as those skills have been used in several consultant projects- Mentoring and Training- Working with 3rd party suppliers re staff interviews, resourcing and allocation- Working with global internal and external teams – at one time I was leading a resource planning meeting which had 15 staff from 10 time zones.- Documenting of processes and procedures- Security and Data Governance recommendations- ETL/ELT, Architecture design and advice- Data Modelling (Kimball)- Migration of SQL Server data warehouses to Azure Databricks with Delta Lakehouse and Unity Catalog using a Data Mesh Architecture- Azure Data Factory was used in the form of a framework to pull data from client data sources and convert to parquet files on BLOB storage – ready for Databricks to ingest into the Bronze Layer- Medallion Layers – Bronze, Silver, Gold was used for the Delta Lakehouse

London, United Kingdom

- Scrum Agile methodology, JIRA, scrum boards, standups, sprint development- SQL 2012- SSIS, SSRS, TSQL (stored procedures, views, functions) development- ETL of paper contracts/agreements to normalized database using SSIS and stored procedures- XML, XPATH, XQUERY- C# in SSIS packages

London, United Kingdom

- Finance IT, Regulatory Control, Liquidity reporting- Performance tuning and testing of multi-region/country ETL data feeds and stored procedures- Hands on T-SQL, Views, Functions, Stored Procedure, Powershell, SSIS and SSRS Development and code reviews, test-driven development and unit testing including partitioning and table compression- Database and application design- Training and mentorship of offshore and graduate employees- Dev lead for an offshore project team (India), which was part of a much larger development team- Dev lead for the France and Latam regional project, as well as leading Global, Performance Testing and Integration development work- Responsible for development work project planning, daily stand-up and task allocation, QC's, and problem solving- Reported to team project managers and development manager- Interfaced with large testing team, and test managers, as well as several business analysts- Complete life cycle – Planning, Design, Development, Unit Testing, SIT Testing, Integration and Regression, Production Release, Production Support, BAU- Documentation- Merging of code using RTC between 6 parallel development streams- Environment is enterprise level, with 21 development/SIT servers, UAT, OAT and PROD database servers, including multiple application servers and a dedicated build team- Project is an ETL project including consumption of thousands of files using SSIS, transformation using Stored Procedures and file output using SSIS and C#. Reporting is via SSRS and back-end report rendering to CSV. Scheduling is via ControlM. FinArch and bespoke databases are used for staging and transformation, using compression and partitioning to improve performance and concurrency. Data volumes 120GB daily and growing.

SQL Server 2005/2008, SSIS, SSRS, performance tuning, design and development, agile, full lifecycle

Onsite at UBS in London

Worked via DataInc

T-SQL and SSIS development

T-SQL and SSIS development of bespoke BI applications.

Database design and development of Trading and Front Office applications, including SSRS, SSAS and SSIS.

Database migration from SQL2000 to SQL2005, including T-SQL development and SSIS

Database development of e-commerce web bases 24/7 high traffic applications

SQL Server development for high availability and high traffic e-commerce platform

COBOL IBM Mainframe developer for Direct Marketing product

COBOL development for insurance department

COBOL development for various Life Assurance and annuities products

It, It

UK degree compatible

Education record

Education record