09/06/2022 updated

NK
100 % available

Business Data Analyst, BI Developer/Data Modeller, Data Analyst

Whitefield, United Kingdom
Worldwide
Whitefield, United Kingdom
Worldwide

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

Experience

Professional experience10+ years

Languages

GermanBasic knowledgeEnglishNative speaker

Project history

Data Engineer/Data Analyst

ALDERMORE BANK
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.

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.

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.

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.

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.

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.

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

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.

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.

Senior Database Administrator

Zurich Insurance

Senior Database Administrator

Barclays

Senior Database Administrator

IBM/Transport for London

Data Architect

SSP

Senior Database Administrator

Bankwest

SQL Technical Specialist

OAG

Data Analyst

EDS/Telstra

Senior Analyst/Programmer

Australian Alliance Insurance

Senior Database Administrator

HBOS

Data Migration Team Leader

Australia Tax Office (ATO)

Data Analyst

RBS

Senior Analyst/Programmer

HBOS

Senior Analyst/Programmer

Severn Trent Water

Senior Analyst/Programmer

Experian/MBNA

Senior Analyst/Programmer

Barclaycard

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in