Nicolas Kalns available

Nicolas Kalns

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

Profileimage by Nicolas Kalns Business Data Analyst, BI Developer/Data Modeller, Data Analyst from Whitefield
  • M457YA Whitefield Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates: 80 €/hour 625 €/day
  • Languages: German (Elementary) | English (Native or Bilingual)
  • Last update: 05.11.2019
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
  • 02/2019 - 08/2019

  • Data Engineer/Data Analyst
  • 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.

  • 03/2018 - 01/2019

  • Business Data Analyst
  • 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.

  • 11/2017 - 12/2017

  • BI Developer/Data Modeller
  • 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.

  • 07/2017 - 09/2017

    • TSB BANK
  • Data Analyst
  • 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.

  • 10/2016 - 05/2017

    • KIER PLC
  • Reporting Data Analyst
  • 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.

  • 04/2016 - 08/2016

  • Data Analyst
  • 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.

  • 11/2014 - 04/2016

  • Senior Database Administrator (DBA)
  • 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

  • 06/2013 - 11/2014

  • Solutions Designer
  • 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.

  • 07/2012 - 02/2013

  • Senior Database Administrator (DBA)
  • 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.

  • 06/2010 - 07/2012

    • Zurich Insurance
  • Senior Database Administrator

  • 11/2009 - 06/2010

    • Barclays
  • Senior Database Administrator

  • 07/2009 - 10/2009

    • IBM/Transport for London
  • Senior Database Administrator

  • 05/2008 - 06/2009

    • SSP
  • Data Architect

  • 10/2007 - 05/2008

    • Bankwest
  • Senior Database Administrator

  • 05/2007 - 09/2007

    • OAG
  • SQL Technical Specialist

  • 01/2007 - 04/2007

    • EDS/Telstra
  • Data Analyst

  • 06/2006 - 01/2007

    • Australian Alliance Insurance
  • Senior Analyst/Programmer

  • 09/2003 - 06/2006

    • HBOS
  • Senior Database Administrator

  • 07/2002 - 07/2003

    • Australia Tax Office (ATO)
  • Data Migration Team Leader

  • 01/2002 - 07/2002

    • RBS
  • Data Analyst

  • 06/1998 - 08/2001

    • HBOS
  • Senior Analyst/Programmer

  • 08/1997 - 05/1998

    • Severn Trent Water
  • Senior Analyst/Programmer

  • 10/1996 - 07/1997

    • Experian/MBNA
  • Senior Analyst/Programmer

  • 10/1994 - 10/1996

    • Barclaycard
  • Senior Analyst/Programmer