Stephen Dobbs Email & Phone Number

High Wycombe, Gb

Bourne End, Bucks, Gb

SAS contractor specialising in data warehousing and ETL. Primary tools are Base/Macro, DI Studio, Enterprise Guide, Management Console and LSF Scheduler.

Swindon, Wilts, Gb

Main Duties * Create new DI Studio processes, and revise existing ones, in order to implement an automated process capable of generating a monthly PRA110 regulatory report.* Convert existing undocumented SQL Server code into a robust, documented DI Studio process.* Produce technical and user documentation around new processes.* System test new/revised processes and support analysts with UAT.* Support BAU team with change requests.Responsibilities* Review new business rules and provide feedback, highlight potential issues, timescales etc.* Implement robust, schedulable load processes in DI Studio based on new and revised business rules and input files.* Write user written code macros for DI Studio ETL jobs.* Write SIT test scripts based on business rules and log defects.* Promote development work to test environment and ultimately production environment.Achievements* Implemented efficiencies that reduced the run time of NBS Savings data load by 2 hours, freeing up computation time for PRA110.* Successfully migrated ABS Lending Inflows report from legacy SQL to SAS DI Studio and enhanced to provide input data for PRA110.* Completed a number of various Change Requests for the BAU team.

Swindon, Wilts, Gb

Main Duties * Migrate Treasury Department’s regulatory reporting SAS DI Studio processes to run off the new balance sheet risk platform, Murex. * System test new/revised processes and support analysts with UAT.Responsibilities* Review new business rules for each reporting stream and provide feedback, highlight potential issues, timescales etc.* Implement robust, scheduled load processes in DI Studio for each reporting stream based on new and revised business rules and input files.* Write SIT test scripts based on business rules and log defects.* Promote development work to test environment and ultimately production environment.* Help co-ordinate development, testing and production deployment among team of developers, testers and analysts.Achievements* Successfully delivered all Murex work on time for Murex go-live.* Knowledge transfer to BAU team.

Swindon, Wilts, Gb

Main Duties * Productionise IFRS9 models across the different portfolios in DI Studio according to modelling specification and draft SAS code.* Support UAT process and handover of models to BAU.Responsibilities* Review requirements for each IFRS9 model and provide feedback, highlight issues etc.* Run draft SAS code for each IFRS9 model. Fix bugs and raise non-trivial code issues with modelling team.* Implement robust, configurable monthly load process in DI Studio for each portfolio incorporating the relevant models.* Co-ordinate development amongst team of six developers and share processes, knowledge etc.Achievements* Implemented and delivered all Personal Loans portfolio models to UAT within given timelines* Implemented and delivered various Specialist Mortgages portfolio models within delivery timelinesCore skills used and developed* SAS DI Studio* Base SAS* Enterprise Guide* Stakeholder management

Swindon, Wilts, Gb

Main Duties * Build historical datasets containing monthly snapshots of customer account data for various portfolios, based on business and modeller requirements, in order to support the development of balance run-off and customer attrition models and IFRS9 regulation* Design and implement a robust monthly process that maintains the historical datasets and monitors model performanceResponsibilities* Liaise with business users to gather requirements and ascertain potential data sources* Create data quality reports of potential data sources to support decision for primary source* Adhere to the agile/scrum methodology and provide daily updates to the team on progress* Carefully manage space constraints on file server and develop space-saving efficiencies for processing multi-billion row datasets* Design, build and test the historical load process for the savings and commercial account data* Design, build and test the prototype monthly process for the savings account dataAchievements* Developed an automated process to generate data quality reports in PDF format for a given dataset* Handed over the commercial portfolio historical process to the in-house BAU team whilst the modelling team continued to develop their model* Handed over the prototype savings portfolio monthly process to the in-house BAU team for them to fully implement in DI StudioCore skills used and developed* Base SAS* Enterprise Guide* DI Studio* Management Console* LSF Scheduler/Process Manager* Stakeholder management

London, Gb

Main Duties * Develop and maintain existing SAS Risk Management For Insurance (RMFI) solution to support Solvency II regulations using SAS DI Studio and the SAS 9.2 Suite* Develop new SAS processes to automate and enhance business user functionalityResponsibilities* Run the monthly investment data load process and provide first line support for errors and issues around RMFI* Liaise with business users to gather requirements and translate these into technical requirements* Draw up and implement functional and logical designs, test plans, deployment plans and user documentation* Manage the deployment/promotion/change process across four environments: DEV, SIT, UAT and PROD* Develop standard documentation, naming conventions and coding standards within the SAS teamAchievements* Implemented automated file copy process from sFTP to data store, using DI Studio* Successfully gained knowledge transfer of RMFI and financial investments from previous contractor* Enhanced RMFI solution to support additional investment funds without further hard-coding, using DI StudioCore skills used and developed* SAS DI Studio* Base SAS, Macros* SAS Enterprise Guide* SAS Management Console* LSF Scheduler/Process Manager* Stakeholder management

London, Gb

Main Duties* Provide technical direction and design for datamart/datawarehouse architecture to support customer analytical solutions* Develop standardised documentation templates for the Global Data Services team* Design, develop and maintain ETL processes to load client source dataResponsibilities* Design, implement and maintain the multi-client insight metadata model (relational database) for the Clear Cell Cloud (C3) data platform. Hosted in cloud-based Amazon Web Services MySQL DB instance.* Manage and mentor off-shore junior developers* Gather business requirements from internal clients* Provide technical expertise on the design and implementation of ad-hoc, non-standard (non-C3) solutionsAchievements* Oversaw our first client, a US retailer, use the C3 platform that I helped design and implement* Implemented the ETL process to load client dimension data for the above client in Base SAS within tight deadline* Designed the API to allow our web-based client insight portal to obtain report and KPI metadata from the C3 modelCore Skills* Base SAS* MySQL Workbench/Data Modelling* Amazon Web Services* Global team/line management & mentoring* Scrum methodology

London, Gb

see above

Brook Green, London, Gb

Main Duties* Technical lead for Tesco China SAS data warehouse solution* SAS DI Studio developer for Tesco International solutions* Base SAS developer for Tesco UK solutionResponsibilities* Maintain and develop the Tesco China solution using DI Studio* Run the weekly transaction and dimension data load for Tesco China* Train/mentor junior developers on Tesco International SAS solution implementations* Liaise with internal and external clients on business queries around DW/reporting dataAchievements* Extended the generic solution for all Tesco International clients to read-in, process and publish store promotions data* Enhanced the Tesco UK transaction data published on a daily basis to be promotionally adjusted* Received ‘Values In Action Award' for playing a key role in a tight-deadline project to implement Tesco Price Promise (price comparison versus Asda)Core Skills* SAS DI Studio* Base SAS, Macros* Unix command prompt and scripting* Redwood Cronacle Explorer Scheduler

Cary, Nc, Us

Main Duties* SAS Consultant for DI Studio/Base SAS client workResponsibilities* Act as professional face of SAS consultancy at various client sites* Provide technical SAS support for clients* Participate in Scrum project work and develop ETL processes to support SAS Marketing Automation solution development* Design and implement job flows using SAS Management console and LSF SchedulerAchievements* Received extensive training in all SAS Suite tools and gained Advanced Base SAS certification* Worked on two Marketing Automation projects for two large companies and participated in the Agile/Scrum development cycleCore Skills* Consultancy* SAS DI Studio* Base SAS* SAS Enterprise Guide* SAS Management Console* LSF Scheduler/Process Manager* Stakeholder management