Mark Johnston Email & Phone Number

Wellington, New Zealand

Wellington, Wellington Region, New Zealand

- Development and optimisation of Meltano taps and targets: - pipelinewise-target-snowflake (mjsqu) - tap-db2 (mjsqu) - tap-oracle (s7clarke10) - tap-dbt (meltanolabs) - tap-mssql (wintersrd) - tap-rest-api-msdk - assisting my colleague Steve Clarke with review of major enhancements- Because of my work on tap-db2, my variant became the Meltano recommended variant of the tap- Testing and optimising tap code using cProfile and other tools to recommend changes to caching of properties- Worked with the Meltano community on tap-dbt, SDK enhancements, and documentation updates - raising issues and PRs and following contribution recommendations while communicating effectively via GitHub and Slack.- Administered Airflow MWAA platform for the Ministry of Health National Collections team - including upgrading between versions- Raised PR and Issue on the Apache Airflow GitHub repository to resolve bugs in apache-airflow-providers-amazon- Worked with several in-house GitLab repositories to develop: - A code generator repository to create dbt models from CSV files (dbt seed files) - A no-code framework for generating Airflow DAGs from YAML files including GitLab CI testing and deployment pipelines - based on https://github.com/ajbosco/dag-factory- Used the following AWS products: - ECR - hosting a docker image containing a meltano installation - ECS - running containerised tasks for meltano ELT pipelines, dbt Cloud job runs and Qlik Cloud Automation updates - EC2 - development instances for testing meltano, taps and targets and updating meltano state database - MWAA - Airflow scheduling tool to run Meltano, dbt, Qlik tasks on schedules - Lambda - running Lambda functions from Airflow to manage the AWS environment - S3 - storing and manipulating objects - setting up the meltano S3 state backend

Wellington & Wairarapa, New Zealand

Wellington, Wellington Region, New Zealand

I was a lead developer in the BNZ Global Data Warehouse team, my responsibilities have included:- Converting COBOL programs to SAS and JCL- Technical lead on a 12-month migration project, moving the BNZ SAS Finance application to a new Windows Server- Lead SAS Platform Administrator (Windows Server)- On-call overnight support for Mainframe jobs- Delivering JCL jobs and OPC applications under the BNZ change control process in ServiceNow- Producing test and design documentation to support changesIn addition to my core responsibilities, I:- Coached colleagues in the use of PowerShell to perform quick Windows Server admin tasks- Optimised and fully documented the Software Development Lifecycle (SDLC) for my colleagues, enabling quicker delivery of jobs- Collated information on metadata and change scheduling from ServiceNow to help the team deliver faster. This also allowed managers to quickly report on our progress.- Automated loading documents to Lotus Notes - saving hundreds of hours development time and producing high-quality consistent documents- Archived old documentation programmatically from Lotus Notes providing a pathway to exit the legacy platform- Developed tools using SAS/REXX/JCL/ISPF, PowerShell and VBA to streamline programming and peer review tasks - including contacting internal BNZ Mainframe teams to learn more about the Endevor code-management application.- Provided clear and concise documentation for all tools I have developed - allowing colleagues to make use of them- Coached other colleagues in the use of advanced programming techniques- Showed a proactive attitude in getting access to resources for our team of developers- Detected problems on a UNIX server and assisted an external team to fix and modify their process to reduce the risk of the incident reoccurringMy colleagues at BNZ have remarked on my collaborative, open nature. I am always keen to help others work more efficiently and smartly.

Wellington, Wellington Region, New Zealand

I was engaged on the Technical Debt workstream which has been implemented to identify and remove Technical Debt, including:- Migrating manually delivered email reports to Visual Analytics and other portal-based systemsFinding processes that produce excessive WARNING and ERROR messages, debug, rewrite, test and re-release with follow up testing- Identifying and eliminating repeated, redundant or needlessly obfuscated code- Rewriting long running programs to boost speed using improved XML parsing techniques, targeted data extracts and removal of redundant logic- Improving documentation with technical documents, flow diagrams and increased code comments- Implementing strategies to apply more standardised, modular programming techniques to the codebase.In addition I used my Linux and SVN skills to assist colleagues in navigating the environment and using the version control system in the correct manner.

Wellington & Wairarapa, New Zealand

Wellington & Wairarapa, New Zealand

Director of a Limited Company specialising in providing SAS, UNIX and SQL related solutions to the Financial Services sector.

Manchester

While providing services to the Co-operative Group, I was employed on a project covering the improvement of MI delivery through the provision of more accurate and relevant data. This involved migrating legacy processes to new SAS 9.2 architecture:- Development of DI Studio ETL jobs and LSF flows encompassing the ODD, Staging, Detail and Mart layers- Improvement of existing processes, in particular, migrating SAS processes into DB2 pass-through- Advising on the data security framework, covering both SAS Metadata and DB2 roles- Providing solutions with comprehensive, lucid documentation enabling skills transfer- Explaining development methods in clear and concise terms, to both technical and non-technical colleagues- Managing timescales of 2 other project resources and overseeing development and testing- Liaising with DBAs and SAS platform administrators- Working with z/OS, DB2 and Oracle data sources

Pendeford, Wolverhampton

This contract encompassed management of a Production SAS Environment and colleagues in the Mortgage Data Mart team, including the following responsibilities:- Management of delivery of the month end batch including allocation of jobs, acquisition and integration of data and end-user communications- Manipulation of SAS metadata using code (OMI), DI Studio and SAS Management Console- Scripting of Unix commands to manage LSF Flow Manager jobs- User and access administration with respect to group SOX commitments- Interfacing with IT teams regarding incidents and upgrades using HP Service Manager 7- Providing technical support to wider teams in SAS, SQL, Unix and VBA- Setting up of email alerting for batch jobs to enable quicker response to incidents and errorsWhile providing my services to the Risk Infrastructure team, I have been remarked upon for my willingness to assist others, work over and above expectations and outside core hours. My supervisors have also commented on my boundless energy and drive to maintain service levels with limited resources.

Leeds, United Kingdom

• Managed 1 onshore SAS contractor and 1 offshore (India) resource to deliver technical aspects of the upgrade from SAS 9.1 to SAS 9.2.• Delivered SAS 9.2 to 200+ users across the UKRB Risk, Wealth and Pricing community (in different sites across the UK, US and India), assisting users in best practice and setup of the new software.• Maintained documentation for SAS software upgrades.• Raised and followed through Change Requests using the HP ServiceNow system.• Consistently met or beat project deadlines.

Leeds, United Kingdom

• Analysed and improved manual Pre-Production process taking it to 99% automation.• Used TWS, SAS and VBA with auto-generated emails to report on the process and flag up errors.• Strengthened SOX controls by allowing only signed off changes into the monthly release and producing simplified reporting for audit purposes.• Provided training courses in UNIX and SQL for colleagues.• Maintained existing reporting and developed new solutions with appropriate documentation• Awarded Barclays Platinum Awards 2010 and 2011 for streamlining two processes that led to significant cost savings.

Leeds, United Kingdom

• Worked for General Insurance on administration of automated batch jobs• Migrated SAS IAB jobs to SAS DI Studio• Provided training in migration of jobs onto a new Netezza server• Designed a number of SAS Macros to interface and upload data to the Netezza server• Maintained and improved an in-house SAS/AF solution