SAS Consultant
Milton Keynes, United Kingdom
- Past
-
- SAS Contractor at Jaywing
- SAS Contractor at Abbey
- SAS Contractor at Egg
- SAS Contractor at Jaywing
- SAS Contractor at Barclaycard
- SAS Contractor at Abbey
- SAS Contractor at Tesco
- SAS Contractor at Xansa
- SAS Contractor at Zurich Financial Services
- SAS Contractor at Liverpool Victoria
- SAS Contractor at Liverpool Victoria
- SAS Contractor at AGF
- Senior Database Development Officer at Statistics New Zealand
- Recommended
-
1 person has recommended Steve - Connections
-
47
connections
- Industry
- Information Technology and Services
- Websites
Steve Mosen’s Summary
Steve is an accomplished analyst-programmer with over fifteen years experience of data analysis, extraction, reporting and modelling, primarily using the SAS System in a variety of operating environments.
Steve Mosen’s Specialties:
SAS
Steve Mosen’s Experience
-
SAS Contractor
Jaywing
(Privately Held; 51-200 employees; Marketing and Advertising industry)
April 2008 — August 2008 (5 months)
Working on the Credit Risk team on-site at Egg.
-
SAS Contractor
Abbey
(Public Company; 10,001 or more employees; ANL.L; Banking industry)
November 2007 — April 2008 (6 months)
Working in the Risk team to incorporate Santander's new IT systems.
-
SAS Contractor
Egg
(Public Company; 1001-5000 employees; EGG; Banking industry)
November 2006 — November 2007 (1 year 1 month)
Working on the Credit Risk Team.
-
SAS Contractor
Jaywing
(Privately Held; 51-200 employees; Marketing and Advertising industry)
November 2006 — November 2007 (1 year 1 month)
See above for details (Egg).
-
SAS Contractor
Barclaycard
(Public Company; 10,001 or more employees; BARC; Financial Services industry)
May 2005 — November 2006 (1 year 7 months)
Management Information Reporting Team.
-
SAS Contractor
Abbey
(Public Company; 10,001 or more employees; ANL.L; Banking industry)
July 2004 — April 2005 (10 months)
Credit Risk Division
Basel II Team
* Reviewed the team programs and advised on SAS efficiency techniques for data extraction and manipulation.
Scorecard Team
* Developed financial scorecard functions in SAS in order to reconcile against the source system and allow detailed MI analysis.
Management Information Team
* Designed and developed a method for incorporating a new data feed into Credit Risk MI reporting.
* Trained team members in various aspects of SAS programming (Base & Macro).
* Automated existing mainframe reporting suites - implementing data uploads to PC-LAN and dynamically creating Excel spreadsheets (using DDE).
* Provided ad hoc technical assistance to team members.
* Renewed 5 times. -
SAS Contractor
Tesco
(Public Company; 10,001 or more employees; TSCO; Retail industry)
August 2001 — June 2004 (2 years 11 months)
Management Alert System (MAS) Team.
* Developed and implemented a Knowledge Transfer plan for training offshore staff.
* Automated and enhanced the data feeds into Tesco's Staff Scheduling System.
* Seconded to PC Data Warehouse Development Team to analyse the data and functionality gap between MAS and the PC-DW and produce a plan for the eventual decommissioning of MAS.
* Implemented control files to optimize overnight batch processing, improving schedule run times and business SLAs.
* Created a number of databases and integrated them successfully into MAS, in good time and within budget.
* Developed and implemented a number of Rexx programs for repetitive MAS Support tasks.
* Provided Help Desk and on-call support of MAS.
* Renewed 7 times. -
SAS Contractor
Xansa
(Public Company; 5001-10,000 employees; XAN; Information Technology and Services industry)
August 2001 — June 2004 (2 years 11 months)
See above for details (Tesco).
-
SAS Contractor
Zurich Financial Services
(Public Company; 10,001 or more employees; ZURN; Insurance industry)
April 2001 — August 2001 (5 months)
Database Marketing Team.
* Provided a hierarchical data file for proprietary reporting software (Viper) from three legacy systems, making use of postcode validation and client matching techniques.
* Installed and evaluated SAS Enterprise Guide. -
SAS Contractor
Liverpool Victoria
(Privately Held; 1001-5000 employees; Financial Services industry)
March 2000 — February 2001 (1 year)
Management Information Systems.
* Developing and maintaining programs for building and reporting on a dimensional data warehouse (DDW).
* Designed, developed and implemented a reconciliation system for monitoring the data feed from an external call center. -
SAS Contractor
Liverpool Victoria
(Privately Held; 1001-5000 employees; Financial Services industry)
June 1999 — December 1999 (7 months)
Management Information Systems Team.
* Undertook development and maintenance of programs to build and report on the DDW.
* Converted a monthly snapshot data mart to a daily append, saving 8 hours on the month-end schedule.
* Identified production data problems, implemented code changes and applied data fixes to the fact and dimension tables of the DDW.
* Developed and implemented an optimisation routine for multivolume SAS datasets, saving DASD resource and improving access times.
* Developed a TSO messaging application (run from SAS Display Manager). -
SAS Contractor
AGF
(Privately Held; 10,001 or more employees; AGF; Insurance industry)
1996 — 1998 (2 years)
Management Information Team.
* As part of a management information team, designed and developed insurance data warehouses and delivery systems, following client standards on production change control and implementation.
* Designed a multi-dimensional data model as the basis for implementing a claims data warehouse.
* Investigation of legacy systems for extraction to existing data warehouses.
* Design and development of key components (including reconciliation to source systems) on both claims and policy data warehouses.
* Production data fixes applied to DB2 systems using SAS and SQL.
* Design, implementation and provision of production data files for analysis and reporting for the purpose of product pricing. -
Senior Database Development Officer
Statistics New Zealand
(Government Agency; Government Administration industry)
1989 — 1995 (6 years)
Database Development Team
Responsible for the accurate and timely supply of Government Statistics and Census information to both internal and external customers, maintaining data quality standards and ensuring the integrity of Statistics New Zealand's "Information Network for Official Statistics" (INFOS), New Zealand's largest public access information delivery system.
