Christopher Smith
Sheffield,North Yorkshire
Summary
A highly skilled professional with expertise in coding using SAS, HTML, SQL, and VBA. Demonstrates strong mathematical and problem-solving capabilities, complemented by excellent communication and writing skills. Proficient in SAS Base, including SQL, SAS/CONNECT, SAS/FSP, SAS/GRAPH, and SAS/STAT, as well as advanced tools like SAS Enterprise Guide and SAS Viya. Experienced with Microsoft Office Suite and Windows Server environments. Driven by inquisitiveness and self-motivation to learn new concepts and apply them effectively across various challenges.
Overview
30
30
years of professional experience
2003
2003
years of post-secondary education
1
1
Certification
Work history
SAS Engineer
Sopra Steria
10.2022 - 09.2024
- Large Insurance Group – Phoenix Group From January 2023 to Dec 2023
- SAS Analyst
- From Aug 2023 to Dec 2023
- Project was to transfer of data from one Outsourced services provider (OSPs) to another one.
- Perform a Gap Analysis on the product Features to allow the client to compare with what they had on one OSPs is the same on the new OSPs.
- Changed the legacy SAS code to point towards the new data on the new OSPs.
- Assisted with documenting the control checks to be done by each OSPs before each transfer of the data.
- Assisted in the development and testing of a new data feed into the data warehouse.
- From January 2023 to Jul 2023
- SAS Analyst supporting the Client's BAU reporting process for Q1 and Q2 2023
- Produced a master file with all the unique identifiers from the IFRS17 data as part of the move to include the IFRS17 data into IHUB data warehouse.
SAS Technical Specialist
HCL Technologies Ltd
02.2015 - 08.2018
- Working for the client UKAR looking after the nightly 4 SAS batches for the Data Management team on a call 24/365 days a week working one week on call and one week off call in office.
- Involved in a SAS Optimization project to reduce the real time the nightly SAS batch runs which reduced the run time by 10% and we developed 25 different optimized code which resulted in over 250 change requests.
- I was asked to look into why 3 SAS Contractors hired by HCL Ltd had failed a data exercise by the client.
- After I had investigated and given my advice to the 3 contractors they all passed the data exercise and successfully completed the project. Thus my efforts saved HCL Ltd reputation and saved them the cost of hiring 3 more contractors.
- And a migration project.
SAS Analyst
Wage Day Advance Ltd
09.2014 - 01.2015
- Develop analytical solutions, including management information packs and dashboards to monitor KPI’s which will include; Application stages with volumes and outcomes, Business performance and trends, Acquisition strategies, Customer behaviours and outcomes, Collections/Recoveries activity and outcome.
- I was involved in a looking at Fraud whilst at Wage Day Advance and helped prevent future fraud.
Senior SAS Programmer
Cegedim Strategic Data Ltd
11.2013 - 04.2014
- Line management of two junior members of staff, also supporting a range of data processing and analysis activities which includes transforming raw data into research ready files.
- I was asked to cover the LAN Managers duties for 2 months due to illness.
SAS Online Support Analyst
Lowell Group
08.2013 - 11.2013
- Providing data support to analyst by creating SAS stored process and SAS DI Studio projects and assisting in the duties of the SQL server Administrator.
SAS Programmer
Ogilvy One
01.2013 - 03.2013
- Developed documentation needed to convert an existing Excel VBA system called Retina into a SAS system with addition functions as required by the business.
Project Analyst
Redcats
05.2012 - 12.2012
- Develop code to test the business rules used to extract data from the existing mainframe to migrate the data into a data warehouse (NDW), create new SQL scripts for the NDW to assist analysts and develop new MI and change existing MI to suit the business needs.
SAS Programmer
Data Trial Ltd
07.2011 - 07.2011
- The aim of this project was to do the checks and updates to the document and SAS scripts of a clinical trial which had been put on hold due to lack of patients in order for it to start recruiting patients by the end of July 2011.
- We did find several SAS scripts which had not been written and some which had issues.
Senior SAS programmer
HSBC, Commercial Banking
04.2011 - 07.2011
- Communicating with internal stakeholders and implementing the requirements for changes to existing M.I reports including the underlying AS/400 queries/scripts, SAS programs, SQL scripts, designing, building and maintaining OLAP cubes.
- Completed successfully one change per week.
SAS programmer
Pharm Research Associates UK Ltd
07.2010 - 12.2010
- Liaising with colleagues from the North America and Europe to create CDISC - SDTM datasets from the CRF.
- Initially a 5 week contract which was extended by 5 weeks and then 6 weeks and over the length of the contract I successfully completed 8 studies without any QC issues.
SAS Programmer
Micron Research Ltd
11.2008 - 06.2010
- Creating EDC databases from the CRF, programming validation programs, tables and listings, validation of code, assisting data managers in the verification of data, the Migration and testing of data from a UNIX server to a new UNIX server.
Senior M.I Analyst
HBOS, Performance reporting
11.2006 - 10.2008
- As a senior M.I analyst I am involved in the development and maintenance of the data and tactical M.I reports that supports the Retail Bonus schemes, senior manages and product areas, which involved speaking with senior internal stakeholders to gather requirements, documenting and automating several manual processes via SAS, Excel/VBA and SAS BI tools.
- One of the main projects that I was involved in was to duplicate some reports produced via Business Objects in SAS Business Intelligent software.
Statistical Programmer
PPDi, Bio statistics
06.2005 - 04.2006
- I supported the project managers in the production of SAS datasets for analysis, reports using proc report and graphs using SAS v8.2 and SQL as specified by each client.
- I was asked to remove CDISC code from a SAS macro from the USA office which was developed to QC large listings. Instead I kept the functionality of the CDISC code by inserting a switch.
Senior M.I Analyst
HSBC, Decision Support Unit
01.1995 - 06.2005
- As a senior analyst within the Information management team I had the responsibility of speaking with external and senior internal clients to gather the requirements for new existing M.I using SAS v8.2 and Excel/VBA for the department and for liaising with an external process benchmarking company.
- Within the Strategy Ware team I was responsible for creating credit strategies that effectively balance volume, risk and profit, in addition to automating and streamlining of current operational procedures, for systems such as personal account opening and business account opening.
- My first role with the department was within the Business Team, where I had the responsibility of monitoring existing business scorecards and the development of new credit and behavioural scoring methodologies to support business priorities using SAS.
- From the year 2000 to 2004 I had the responsibility of being the LAN manager for the department in addition to my normal duties. I was responsible for the installation and maintains of the hardware and software which included installing SAS as updates became available.
- I was also the Data Manager for the Bench Marking consortium for Current accounts, Personal Loans, Credit Cards, and Business.
- I was the senior Fire Marshal for the Building and as part of this I had to deal with a Bomb threat.
Education
City & Guilds Visual Basic Pass -
Sheffield College
BSc (Hons) - Systems Modelling
Sheffield Hallam University
Business and Finance Access course - undefined
Loxley college
Skills
- Coding in SAS, HTML, SQL and VBA
- Learning concepts and applying them to other problems
- Mathematical skills
- Problem-solving capability
- Communication skills
- Writing skills
- Inquisitiveness
- Self-motivation
- SAS Base which includes SQL, SAS/CONNECT, SAS/FSP, SAS/GRAPH, SAS/STAT
- SAS Enterprise Guide , SAS Data Integration Studio, SAS Management Console, SAS Viya
- LSF (flow manager)
- Microsoft :-
- Office Word, Excel, Power point, Outlook
- Server 2008 and 2012
Certification
- Training – CDISC introduction course conducted by CDISC [2010], Enterprise Guide V4.2 [2008], Creating Distributing and using SAS stored process [2008], Using SAS Data Integration Studio to build data marts from enterprise data sources [2008], Time Management and Report Writing [2004], Team Leadership I & II [2003], BS5750 Quality Approach [2002], Quality Assurance [2001], SAS advanced programming [1997], Data Manipulation and SAS Macros [1996]
- SSL Data Protection, Information Security [2023], Harassment and Bullying for Employees 2024, Information Security: Vigilant at All Times, SSL Modern Slavery, Scrum: The Basics, Team Workflows in JIRA, Agile & Scrum 101, Microsoft SharePoint, Service Now, Introduction to Python – Module 1 Introduction, Introduction to Python – Module 2 Variables & Operators, Introduction to Python – Module 3 Lists in Python, Introduction to Python – Module 4 Tuples & Maps, JavaScript [2024].
REFERENCES
On request
INTERESTS
I play tennis, badminton, squash and I also enjoy walking. I like going to air shows, the theatre and to the cinema.
Timeline
SAS Engineer
Sopra Steria
10.2022 - 09.2024
SAS Technical Specialist
HCL Technologies Ltd
02.2015 - 08.2018
SAS Analyst
Wage Day Advance Ltd
09.2014 - 01.2015
Senior SAS Programmer
Cegedim Strategic Data Ltd
11.2013 - 04.2014
SAS Online Support Analyst
Lowell Group
08.2013 - 11.2013
SAS Programmer
Ogilvy One
01.2013 - 03.2013
Project Analyst
Redcats
05.2012 - 12.2012
SAS Programmer
Data Trial Ltd
07.2011 - 07.2011
Senior SAS programmer
HSBC, Commercial Banking
04.2011 - 07.2011
SAS programmer
Pharm Research Associates UK Ltd
07.2010 - 12.2010
SAS Programmer
Micron Research Ltd
11.2008 - 06.2010
Senior M.I Analyst
HBOS, Performance reporting
11.2006 - 10.2008
Statistical Programmer
PPDi, Bio statistics
06.2005 - 04.2006
Senior M.I Analyst
HSBC, Decision Support Unit
01.1995 - 06.2005
BSc (Hons) - Systems Modelling
Sheffield Hallam University
Business and Finance Access course - undefined
Loxley college
City & Guilds Visual Basic Pass -
Sheffield College