Data Engineer/Data Analyst
ALDERMORE BANK
Keywords
Skills
data analysis, SQL, T-SQL, SQL server environment, data quality, Data Capture, stored procedures, T-SQL scripts, data warehouse, quality assurance, Oracle 12c, data profiling, T-SQL queries, SQL Server 2016, BIML, SSIS ETL code, EDW, SSAS, Data Vault, Teradata, Excel reports, PL/SQL, EBS suite tables, Oracle EBusiness Suite (EBS), OBIEE, Oracle, 12C, SQL queries, data consistency, data extraction, Oracle EBS suite, data visualisation, Oracle 12c data, DW, Database, Enterprise Data Warehouse, script, data model, ETL, Informatica, Business Objects, SAS, Agile, Devops, Scripting Language, change data capture, Data Migration, UNIX/SQL scripts, database utility, application design, OLTP, database design, data modelling, data integration, data security, Cognos, DB2, Informatica advice, IBM, RBS, SQL Server, DB2 10.5, Netezza, SSIS, DataStage, SSRS, Tableau, MicroStrategy, Power BI, Kimball, Dimensional Modelling, Inmon, 3NF, Star Schema, Erwin, ER Studio, Visio, PLSQL, Functions, Java, MDX, DAX, Python, Shell Scripting, COBOL, Analysis, Quality, Migration, Cleansing, Manipulation, Reporting, Masking, SSMS, TOAD, SQL Developer
Project history
02/2019
-
08/2019
Conducted in-depth data analysis of existing SQL scripts to determine current functionality and
identify improvements. Supported marketing teams with the extraction of data for customer mailshots
using T-SQL in an SQL server environment. Meticulously analysed all data to recognise, highlight and
troubleshoot any data quality issues.
* Data Capture: Designed a new generic method to capture events at certain milestones during the
mortgage customer journey using stored procedures.
* Project Management: Independently rewrote and optimised T-SQL scripts with more practical, user
friendly and enriched functionalities.
identify improvements. Supported marketing teams with the extraction of data for customer mailshots
using T-SQL in an SQL server environment. Meticulously analysed all data to recognise, highlight and
troubleshoot any data quality issues.
* Data Capture: Designed a new generic method to capture events at certain milestones during the
mortgage customer journey using stored procedures.
* Project Management: Independently rewrote and optimised T-SQL scripts with more practical, user
friendly and enriched functionalities.
03/2018
-
01/2019
Business Data Analyst
LLOYDS BANKING GROUP
Conceptualised, developed and integrated changes to data warehouse to meet new business
requirements, from capture to delivery, taking into consideration document source and target
mapping. Meticulously tracked data to resolve any identifiable issues with quality assurance.
* Data Architecture: Profiled and analysed data profile for the secured lending system using
advanced SQL skills in an Oracle 12c environment.
* Solution Design: Conducted in-depth analysis to design a new storage solution for new business
attributes to be stored in a risk data warehouse.
requirements, from capture to delivery, taking into consideration document source and target
mapping. Meticulously tracked data to resolve any identifiable issues with quality assurance.
* Data Architecture: Profiled and analysed data profile for the secured lending system using
advanced SQL skills in an Oracle 12c environment.
* Solution Design: Conducted in-depth analysis to design a new storage solution for new business
attributes to be stored in a risk data warehouse.
11/2017
-
12/2017
BI Developer/Data Modeller
BANK FOR INTERNATIONAL SETTLEMENTS
Performed a simultaneous role to carry out data profiling of data sources using T-SQL queries in an
SQL Server 2016 environment. Maximised the use of BIML to generate SSIS ETL code for end-to-end
population of staging, EDW, Kimball Data Mart and SSAS cubes used by-Tableau reporting tool.
* Efficiency & Security Improvements: Lead designer of robust risk data models for Enterprise
Data Warehouse (EDW) using Data Vault.
SQL Server 2016 environment. Maximised the use of BIML to generate SSIS ETL code for end-to-end
population of staging, EDW, Kimball Data Mart and SSAS cubes used by-Tableau reporting tool.
* Efficiency & Security Improvements: Lead designer of robust risk data models for Enterprise
Data Warehouse (EDW) using Data Vault.
07/2017
-
09/2017
Data Analyst
TSB BANK
Built comprehensive profiles of end users to determine the appropriate business measures or
dimensions needed to implement a new data warehouse. Engaged with stakeholder management to capture
requirements, scope and priorities. Enabled security set up and identification of gaps or
inconsistencies by extracting data with Teradata SQL.
* Business Improvements: Minimised delays and costs for the business via data profiling of source
systems for target mapping to the data warehouse.
* Working Methodology: Prioritised data analysis and source target mapping to meet Agile sprint
lead times.
dimensions needed to implement a new data warehouse. Engaged with stakeholder management to capture
requirements, scope and priorities. Enabled security set up and identification of gaps or
inconsistencies by extracting data with Teradata SQL.
* Business Improvements: Minimised delays and costs for the business via data profiling of source
systems for target mapping to the data warehouse.
* Working Methodology: Prioritised data analysis and source target mapping to meet Agile sprint
lead times.
10/2016
-
05/2017
Reporting Data Analyst
KIER PLC
Coordinated workshops to capture business requirements, business priorities and write functional
specifications for Excel reports using SQL and PL/SQL extracts directly from EBS suite tables.
Further extracted data directly from source Oracle EBusiness Suite (EBS) to replace incorrect OBIEE
reports with bespoke SQL extract scripts.
* System Improvement: Produced a key report to senior management, which resulted in driving down
the number of invoices on hold.
* Business Processes: Wrote complex Oracle 12C data profiling SQL queries to confirm quality or
highlight data anomalies, whilst gaining an insight into operational process behaviour.
* Stakeholder Management: Built relationships at senior level to discuss the best course of
action to successfully resolve any data consistency issues.
specifications for Excel reports using SQL and PL/SQL extracts directly from EBS suite tables.
Further extracted data directly from source Oracle EBusiness Suite (EBS) to replace incorrect OBIEE
reports with bespoke SQL extract scripts.
* System Improvement: Produced a key report to senior management, which resulted in driving down
the number of invoices on hold.
* Business Processes: Wrote complex Oracle 12C data profiling SQL queries to confirm quality or
highlight data anomalies, whilst gaining an insight into operational process behaviour.
* Stakeholder Management: Built relationships at senior level to discuss the best course of
action to successfully resolve any data consistency issues.
04/2016
-
08/2016
Data Analyst
UNIVERSITY OF MELBOURNE
Facilitated stakeholder management workshops and discussions to put in place action plans to resolve
critical business issues and anomalies. Performed data extraction to compare Oracle EBS suite with
OBIEE Kimball data warehouse dashboard and reported results. Enabled data visualisation by designing
new informative dashboards in Oracle OBIEE data warehouse.
* Data Profiling: Authored complex Oracle 12c data profiling SQL queries to match DW dashboard
data with source EBS system patterns of data for AP, GL, and HR.
critical business issues and anomalies. Performed data extraction to compare Oracle EBS suite with
OBIEE Kimball data warehouse dashboard and reported results. Enabled data visualisation by designing
new informative dashboards in Oracle OBIEE data warehouse.
* Data Profiling: Authored complex Oracle 12c data profiling SQL queries to match DW dashboard
data with source EBS system patterns of data for AP, GL, and HR.
11/2014
-
04/2016
Senior Database Administrator (DBA)
INSURANCE AUSTRALIA GROUP (IAG)
Administered the Enterprise Data Warehouse for the largest insurance company in Australia, whilst
acting as a database subject matter expert for over 40 developers across seven work streams.
* Board-Level Communication: Implemented a series of corrections to the data population script
for an important dashboard for the Chief Executive.
* Data Modelling: Assigned as gatekeeper for all data model or schema changes to the Data Vault
Enterprise Data Warehouse, in addition to creating consistent approaches.
* ETL/Data Warehousing: Delivered essential support for the ETL/reporting framework using
Informatica, Business Objects and SAS extracts.
* Working Methodology: Positively adapted to clients new Digital transformation using Agile and
Devops approach
acting as a database subject matter expert for over 40 developers across seven work streams.
* Board-Level Communication: Implemented a series of corrections to the data population script
for an important dashboard for the Chief Executive.
* Data Modelling: Assigned as gatekeeper for all data model or schema changes to the Data Vault
Enterprise Data Warehouse, in addition to creating consistent approaches.
* ETL/Data Warehousing: Delivered essential support for the ETL/reporting framework using
Informatica, Business Objects and SAS extracts.
* Working Methodology: Positively adapted to clients new Digital transformation using Agile and
Devops approach
06/2013
-
11/2014
Solutions Designer
NORDEA BANK
Primarily focused on designing value-added solutions for the bank, whilst determining mapping rules
and attributing churn using data analysis of source system files and tables.
* Scripting Language: Wrote the change data capture script in one day where a previous employee
had spent four months on the project.
* Data Migration: Designed generic parameterised data migration and daily data population
UNIX/SQL scripts for 10 countries across customer, accounts and transaction data in an
anti-money laundering (AML) system.
* Efficiency Improvement: Instigated the utilisation of a new database utility client to provide
faster data input and processing to the database.
and attributing churn using data analysis of source system files and tables.
* Scripting Language: Wrote the change data capture script in one day where a previous employee
had spent four months on the project.
* Data Migration: Designed generic parameterised data migration and daily data population
UNIX/SQL scripts for 10 countries across customer, accounts and transaction data in an
anti-money laundering (AML) system.
* Efficiency Improvement: Instigated the utilisation of a new database utility client to provide
faster data input and processing to the database.
07/2012
-
02/2013
Senior Database Administrator (DBA)
INSURANCE AUSTRALIA GROUP (IAG)
Participated in the application design process, OLTP and Kimball database design, whilst increasing
data modelling knowledge to guarantee database best practice. BAU support for production and
development database environments.
* Process Improvement: Reduced the time to open Informatica MDM tool from 5 mins to 5 seconds,
improving data quality, data integration, business process management, and data security.
* ETL Support: Utilised Informatica, Business Objects, and Cognos to support ETL and reporting
apps, whilst providing DB2, SQL and Informatica advice to ETL developers.
data modelling knowledge to guarantee database best practice. BAU support for production and
development database environments.
* Process Improvement: Reduced the time to open Informatica MDM tool from 5 mins to 5 seconds,
improving data quality, data integration, business process management, and data security.
* ETL Support: Utilised Informatica, Business Objects, and Cognos to support ETL and reporting
apps, whilst providing DB2, SQL and Informatica advice to ETL developers.
06/2010
-
07/2012
Senior Database Administrator
Zurich Insurance
11/2009
-
06/2010
Senior Database Administrator
Barclays
07/2009
-
10/2009
Senior Database Administrator
IBM/Transport for London
05/2008
-
06/2009
Data Architect
SSP
10/2007
-
05/2008
Senior Database Administrator
Bankwest
05/2007
-
09/2007
SQL Technical Specialist
OAG
01/2007
-
04/2007
Data Analyst
EDS/Telstra
06/2006
-
01/2007
Senior Analyst/Programmer
Australian Alliance Insurance
09/2003
-
06/2006
Senior Database Administrator
HBOS
07/2002
-
07/2003
Data Migration Team Leader
Australia Tax Office (ATO)
01/2002
-
07/2002
Data Analyst
RBS
06/1998
-
08/2001
Senior Analyst/Programmer
HBOS
08/1997
-
05/1998
Senior Analyst/Programmer
Severn Trent Water
10/1996
-
07/1997
Senior Analyst/Programmer
Experian/MBNA
10/1994
-
10/1996
Senior Analyst/Programmer
Barclaycard
Local Availability
Open to travel worldwide
Flexible
