Mark Seidelin

Experience

• 

  Fraser Williams Group

  Jan 1984 - Jan 1987

  Lead Programmer
• 

  IBJ International

  Jan 1987 - Jan 1993

  Senior Analyst Programmer
• 

  National Bank of New Zealand

  Jan 1993 - Jan 1994

  Contractor
• 

  IBJ International

  Jan 1995 - Jan 1998

  Contract Senior Analyst Programmer
• 

  GIS / SunGard Treasury

  Jan 1998 - Jan 2001

  Software Engineer
• 

  Infinity Solutions

  Jan 2001 - Jan 2003

  Consultant
• 

  Grosvenor Financial Services Group

  Sept 2003 - Aug 2004

  Senior IT Developer
• 

  Bear Software

  Jan 2004 - now

  Independent Information Technology and Services Professional
• 

  Eagle Technology

  Feb 2005 - Nov 2005

  Contract Developer

  IRS (Incursion Response System) Development.Project to enhance the IRS system (a c# web-based GIS application for the management of disease/pest incursions in NZ).Role included• Standardising existing Crystal Reports and generating new reports• Creation of .Net XML Web Services as data providers for a rich Jscript based client application• Maintenance and enhancements to existing system• Development of Windows Forms applications for the upload and download of application data Show less

• 

  Pharmacybrands

  Nov 2005 - May 2006

  Contract Application Developer

  Development of a new system for the maintenance of store product and store promotion details.Role included • Requirements gathering• Solution design• Windows Forms development• Middle tier business layer development• Data access layer development (including T-SQL stored procedures)• Testing and implementation (using ClickOnce)• Development of SQL CLR stored procedures• Development of reports using SQL Reporting Services• Development of a DataWarehouse cube for reporting using SQL Analysis Services Show less

• 

  Mercury Projects

  May 2006 - Sept 2006

  Contract Developer

  Development of a bespoke Windows Forms based Contract Management system

• 

  Self-employed @ Bear Software

  Jun 2006 - Jun 2022

  Out-of_hours work

  in addition to the "full-time" roles listed, i have also done several out of hours roles includingPharmacyBrands in Auckland - on-gong Dev and support, including Support and maintenance of the in-house FlyBuys processing applicationCanterbury District Health Board - Design and Development of SSRS Reports for Workforce Management applicationCentral Region Technical Advisory Services - Working on migration project to upgrade an ETL / workflow system solution (mainly SSIS)QV - Working on migration project to upgrade ETL solutions (SSIS – 2005 / 2008) and migrate to an AWS location Show less

• 

  Institute of Environmental Science and Research Ltd (ESR)

  Oct 2006 - Apr 2007

  Contract SQL / BI Developer

  Migration of data from existing databases (Access) to new SQL2005 database using T-SQL stored procedures and SSIS 2005• Analysis of data in existing database• Design of schema in new databaseDevelopment of reports using SSRS 2005Development of cubes for reporting using SSAS 2005Toolsets used - SQL 2005

• 

  Datacraft

  Jan 2007 - Jun 2011

  Contract BI / .Net Developer

  Design: Analysis and design of DataWarehouse schema and processing changes required for new order types to be transferred across from the OLTP database, including• Data sampling• Data modellingAnalysis and design of new schema for BssDW database• Requirements analysis• Database designSSIS: Maintenance and enhancements to SSIS solution for transferring data from the OLTP database. Creation of new SSIS solution for transferring data to BssDW database.SSAS: Maintenance and enhancements to the OLAP solution• Addition of new Fact and Dimension tables • Updating the DataSourceViews with new viewsImplementation of forms-based security as part of the DataSeparation project.SSRS: Maintenance and enhancements to reports• Developing new reports Reporting off Warehouse database using T-SQL  Reporting off Warehouse cube using MDX• Report deployment (via ReportManager)SQL:• Maintenance and enhancements to view and stored procedures in both the OLTP and OLAP databases Performance tuning.Net Role responsibilities:• B2B Web Services:• B2B schema and processing changes required for existing and new order typesBilling engine:• Development of in-house billing engine using WPF Toolsets used - SQL 2005 C# Show less

• 

  Hague Consulting

  Apr 2007 - Jun 2007

  Contract SQL / BI Developer

  Migration / consolidation of data from several local databases into one central database using SSIS 2005 and T-SQLToolsets used - SQL 2005

• 

  Pivot Software Ltd

  Jun 2007 - Jun 2007

  Contract Reports Developer

  Migrating reports from Crystal Reports XI to SSRS 2005Toolsets used - SQL 2005Crystal Reports XI

• 

  ING Australia

  Jun 2007 - Aug 2007

  Contract Senior Analyst Programmer

  Reports development .• Report data extraction using T-SQL Stored Procedures• New report generation us ing Crystal Reports XI• Develop Report web Interface using ASP.Net / C#Toolsets used - SQL 2005 C#

• 

  Ministry of Health New Zealand

  Jul 2011 - Dec 2012

  Contract BI Consultant

  Design and creation of 3 new data mart databases from OLTP applications (Oracle) using the Microsoft BI/DW Toolsets.• Star-schema Datamart Database design• SSIS ETL processing from Oracle database(s)Reports development .• SSRS Reports development for Screening applicationToolset used - SQL 2008 R2

• 

  Animal Health Board

  Jun 2012 - Oct 2012

  Contract Datawarehouse Specialist

  Design and creation of a new data mart database from OLTP application using the Microsoft BI/DW Toolsets.• Data mart Database design (Star schema)• ETL processing using SSIS• Creation of OLAP cube and BI Semantic Model• Extraction of source data using CDC• Data Cleansing• Development of stored procedures / functions as requiredToolset used - SQL 2012

• 

  Inov8 Limited

  Nov 2012 - Jun 2013

  Contract Business Intelligence Developer

  Senior Developer on first project (for a Utilities company) involved uploading data into SQL database from a variety of sources and formats• ETL processing using SSISBI Tech lead on second project (for a Govt department) importing data from XML files into SQL database and then into Presentation Layer data marts• Design and construction of databases• ETL processing using SSIS• Development of stored procedures / functions as required

• 

  CTAS / DHB Shared Services

  Feb 2013 - Mar 2016

  Contract Senior BI Designer / Developer

  Maintenance and enhancements to existing SQL2008R2 Reporting databases.• ETL processing using SSIS• VBA programming in Access• SSRS Report generationCreation of a new Reporting database and OLAP Cube for a SQL2012 Pharmacy database.• ETL processing using SSIS• User requirements gathering and analysis (for Cube)• OLAP Cube design• Cube construction and processing using SSAS• SSRS Report generation• Development of stored procedures / functions as required Show less

• 

  Relationships Aotearoa

  Feb 2014 - Jun 2015

  Contract SQL Developer

  Design of a cloud-based reporting solution using SQL2012• Design new datamart• ETL data with SSIS from various sources using ODBC connections, Web services• Transfer data from Landing through Staging to Presentation layer• Create SSRS reports• Build SSAS Tabular Model

• 

  Earthquake Commission (EQC)

  Apr 2016 - Jun 2016

  Senior Reporting Analyst (Contract)

  Provide ad-hoc reports & data, from EQC’s Oracle-based Claims Management System (CMS)• T-SQL extracts• T-SQL development

• 

  Youtap

  Jul 2016 - Sept 2016

  BI Specialist (Contract)

  Creation of a new DataMart on new SQL 2016 installation• Design new datamart• ETL data from Oracle DB via Linked Server• Transfer data from Landing through Staging to Presentation layer• Create SSRS reports• Build SSAS OLAP Cube• Build SSAS Tabular Model

• 

  The Treasury

  Aug 2016 - Jan 2017

  BI Consultant (Contract)

  BI Consultant at The Treasury for Stellar ConsultingWorking as part of Debt Management Office BAU team, supporting existing systems• T-SQL extracts• SSIS ETL processingWorking as part of the TIC project, developing new data importation capability for Treasury users• T-SQL development• SSIS ETL processing• SSAS Tabular Model development• Power BI (Desktop version)Agile Development MethodologyTeam Foundation Server

• 

  Stellar Consulting

  Aug 2016 - Sept 2017

  BI Consultant
• 

  Royal New Zealand Plunket Society, Inc. (RNZPS)

  Jan 2017 - Apr 2017

  BI Consultant

  BI Consultant at Plunket for Stellar ConsultingMain task was using SSIS to bring source data into the "loading" stage from different sources.• T-SQL extracts• SSIS ETL processing• BIML processingEnvironment was SQL2014 / Wherescape Red

• 

  The Treasury - New Zealand

  Aug 2017 - Aug 2018

  Contract Data Developer at The Treasury

  BI Consultant at The TreasuryWorking as part of Debt Management Office BAU team, supporting existing systems• T-SQL extracts• SSIS ETL processingWorking as part of the TIC project, developing new data importation capability for Treasury users• T-SQL development• SSIS ETL processing• SSAS Tabular Model development• Power BI (Desktop version)Agile Development MethodologyTeam Foundation Server

• 

  Ministry of Education

  Sept 2018 - May 2019

  BI Developer

  Working as part of the DSW team, developing new data importation, validation and automation capability using • T-SQL (Stored Procedures)• SSIS ETL processing• SSRS Report developmentEnvironment Microsoft SQL2016

• 

  Fire and Emergency NZ

  May 2019 - Jul 2019

  SSRS Report Writer (SQL Developer)

  Updating of existing T-SQL scripts to reflect changes in the Organisation structure.Environment:Microsoft SQL2016

• 

  Bank of New Zealand

  Jul 2019 - Jul 2022

  .Net / SQL Developer at BNZ

  Development of T-SQL scripts / stored procedures for the Credit Risk Weighted Assets part of the BNZ BS11 project.Environment:Microsoft SQL2016 / Azure VMs / DevOpswith Agile Development (and JIRA)

• 

  Chubb Life New Zealand (was Cigna Life)

  Jul 2022 - now

  Contract - Analytical Data Engineer

  Initial project working on team for development of T-SQL scripts / Stored procedures for a new business focused sales domain data model / data-lake. This was centered around using SCD-0, SCD-1 and SCD-2 “merging” when creating the data-stores from disparate data-sources.Then working on a project to “Lift and Shift” the existing SQL Processing from the current locations up to new Azure location. This involve reviewing / standardizing / updating the SSAS, SSIS and SSRS objects to the new environment(s) on Azure VMs.Now working on more “BAU” projects. Currently designing and building a new star-schema data-mart for a new product about to be released. Show less