CURRICULUM VITAE

PERSONAL DETAILS

NAME: Robert Burns

Mobile Number : 078********

Email: admc7z@r.postjobfree.com

QUALIFICATIONS

**** ******* ********** *** ************

****- **** *****rsity of Glamorgan, Pontypridd - Postgraduate Diploma in computing

1992 – 1996 University of Glamorgan, Pontypridd - Upper Second BA (hons) English and History

1987- 1990 A Level Politics and Government, A Level English Literature, A Level History

1987 O Level Maths, English Literature, English Language, French, Chemistry, History, Scripture

COURSES

ISTQB-BCS Certified Tester -Software Testing -2017

ITIL Foundation course - 2005

TRAINING

March 2014 SAS Introduction to ANOVA, Regression AND Logistic Regression

September 2005 SAS ETL Studio & Management Console

SAS Institute

September 2003 UNIX Fundamentals

QA Training

August 2003 Introduction to Oracle

Learning Tree

September 2002 SAS Macro

SAS Institute

June 2002 SAS Base Programming

SAS Institute

Ensemble (Protagona)

DoubleClick

SKILLS SUMMARY

EXPERIENCE SUMMARY

I have spent over 10 years as a SAS Programmer working for Centrica and the AA.

I have also contracted in the private and public sector

I know SAS Base and Macro modules very well, and have used DDE

I have used my skills for building and modifying SAS Datamarts, and creating ad-hoc feeds for

business requirements. I also have extensive use of SAS for investigating and resolving data issues.

Analysis Skills

Technical Knowledge

Requirement Definition

Technical Design

Software Testing and Quality Auditing

Data Analysis

Training and Knowledge Transfer

Data Warehousing & CRM

SAS Programming (v8, v9)

SAS ETL Studio (v3.3)

SAS Management Console (v9.1)

Ensemble v5.5 & 6.5

Unix/Citrix/Windows NT and XP

MS Project

Microsoft Access

SQL (Access, Oracle)

Microsoft Excel (Intermediate level)

Business Objects (Designer and User)

EMPLOYMENT SUMMARY (KEY ROLES)

October 2020 to February 2021

Company: Credit Agricole, Dublin (working through ISX4 consultancy)

The role involved taking SAS Base actuarial code from Paris that had been migrated to SAS Enterprise Guide jobs in Dublin. The projects were rewritten to be more efficient, maintainable and meet best practice standards.

March 2020 to July 2020

COMPANY: Swansea University

Converting SAS Enterprise Guide academic performance reports into SQL Server scripts. The job involved creating stored procedures to make the code more maintainable and modular

December 2019 to February 2020

COMPANY : Legal and General, Cardiff

I worked on a data quality framework to ensure the data structures were understood and adhered to; the business was confident in the accuracy and timeliness of the data and new data sources could be applied to it. The process focused on integrity loss, duplicate keys, data mapping and lineage through SQL queries

May 2018 to October 2018

COMPANY: Open University, Milton Keynes

Working to provide synchronisation of consent & preference data between the Open University and its chosen system of record “The Preference Centre”, hosted by Syrenis, to ensure that the data available to the OU teams via SAS is updated in an accurate & timely manner and information updates to TPC, from the OU, are carried out in the same way. This provides the most accurate view of the overall position. The process has involved understanding the processes, documenting them in Microsoft Visio and implementing and testing the processes in SAS Enterprise Guide

May 2017 to November 2017

COMPANY Office of National Statistics, Newport

Using SAS and SQL to build and modify applications for methodologists

Creating test plans and peer reviewing colleagues’ code

2015 TO 2016

COMPANY: DWP, Blackpool

Using SAS Base and Enterprise Guide to maintain and write code to discover internal fraud and inappropriate staff behavior through audit data

Writing technical sign-off documents for code

Upskilling more junior members with SAS coding

2011 TO 2014

COMPANY: Barclays Direct (Formerly ING Direct Bank),Cardiff

Rewriting old Excel Daily and Annual Mortgage MI reports into SAS .Using DDE to output results from SAS into Excel

Developing and maintaining MS Access incentive database agents, team manager and CSM

Producing monthly campaign analysis results on campaign selections using SAS

General ad-hoc analysis on our Oracle data warehouse using SAS

Using SAS to produce monthly incentive results for over one hundred staff

2009 TO 2010

COMPANY: Postgraduate Medical School, Cardiff University

POSITION: Microsoft Access Developer

Building an MS Access database for Postgraduate Medical School’s Performance Unit

Designing (using normalization techniques) and documenting the database

Arranging regular meetings with management and end users for requirement gathering, resolving issues and knowledge transfer

The database was used to produce reports and graphs in Microsoft Excel for performance analysis

2008 TO 2009

COMPANY : Entire Marketing, Bristol

POSITION: SAS Developer

Maintaining and refreshing the company’s three main databases which drove most of the campaigns

Responsible for updating and refreshing the suppression feeds . It was imperative that they were kept up-to-date for legal and business reasons

Running regular and ad-hoc campaigns. I also looked for ways of improving the efficiency of some of the regular campaign and database build code.This was important because a client–based marketing environment has tight deadlines and all of clients were external and could go to rival marketing firms

Assisting peers with SAS code queries

Creating dedupe reports in Microsoft Excel

2006 TO 2008:

COMPANY : GIANT UMBRELLA COMPANY

POSITION: SAS Programmer

I worked as a SAS programmer for a number of companies including HBOS, Cardiff and Derbyshire Building Society, Derby.

COMPANY: HBOS, Cardiff

The role involved redesigning and programming in SAS the monthly Risk Analysis datamart.

The Risk Analysis datamart code used pass-through SQL because the source data was in an oracle datawarehouse. The task consolidated my Oracle knowledge that I gained at Centrica and the AA

I also improved the efficiency of the scorecard and performance code used by the Risk and Decision Science teams.

COMPANY: Derbyshire Building Society, Duffield, Derbyshire

The role involved building the extract, staging and enterprise layer for HML mortgage datamart

The task also involved writing code to update MS Access control tables which hold formats for staging and load data, and subsequently sending out web reports to end users to notify them of the changes.

2005 –2006

COMPANY: The Automobile Association (The AA)

POSITION: SAS Developer

Splitting my time between Basingstoke and Cardiff, my main responsibility was for the Customer Insight SAS data warehouse and Oracle data marts. However, I was often resourced for internal SAS\Oracle development projects.

Key Projects:

Developer - Campaign Data Mart (SAS/Oracle):

Worked as a developer on the project team to provide a new data mart to support lifting of suppressions through opt in activity and the over-riding of suppressions where a more recent suppression status is received. Simplifying the structure for campaign selections, increasing the marketable base through more granular customer matching, and optimise to improve campaign response rates.

1SAS ETL build of all Oracle publish processes

2SAS ETL build for campaign mart loading reports

3Administration of users, defining levels of authority for Oracle Mart

Developer – Insurance MI project (SAS):

The implementation of an Insurance Historical Data Store making improvements to the provision of the Insurance business management information in the most cost effective way at an operational, financial and analytical level. Creating a single structured data, metrics and KPI source for analysis by the many insurance teams, resulting in improved governance of the MI quality, quantity and timeliness of data.

Business-as-Usual:

1Managing the support process for 2 production data warehouses

2Validating & loading of data feeds into the data warehouse, ad-hoc data loading, data extraction, manipulation and data analysis

3Responsible for all Customer Insight database responsibilities – tasks for database maintenance. Undertake these tasks where necessary; manage others when they are undertaking these tasks. Act as the main point of contact for database queries

4Delivering fixes and operational changes to SAS systems, including analyzing, fixing operational issues, and delivering small business changes to these systems

5Using SAS Management Console to create and deploy SAS job flows

6Involvement in release planning, QA & UAT

7Weekly reporting & Data archiving

8Main point of contact for data extract requests and data queries

2002 – 2005

COMPANY: Centrica

POSITION: SAS Programmer

1Implementing changes to SAS and Oracle data warehouses and subsequent data marts, responsible for documenting and testing these changes. Requirements gathering were often carried out through workshops involving the business analysts to ascertain and clarify their requirements. Communication was a key element to this role to ensure that requirements were clear and implemented correctly

2Responsible for unit testing of colleague’s code to ensure quality before released into the live environment. The role demanded an awareness of Service Level Agreements and Operational Level Agreements

Contact this candidate