Nathan Holmes Email and Phone Number

• Manage a team of 5-10 ETL/BI developers.• Interpret high-level business requirements down to technical design, working directly with business stakeholders to gather requirements/resolve ambiguities and assisting developers as necessary to specify and estimate changes. Develop SSIS packages and complex T-SQL stored procedures, functions & views for ETL processes and BI reporting.• Provide query tuning advice to developers, and continuously look for solution design-level changes to improve overall system performance.• Assist Project Manager in prioritising feature requests, establishing release timelines and creating project plans.• Mentor to Junior Team Lead.• Provide 3rd line support for ETL processes and data queries arising from report usage.

• Prioritised and managed workload for SQL development team (5-10 staff), suggesting revisions to both local and departmental processes to improve customer outcomes.• Responsible for mentoring of SQL developers and review of their output.• Provided SQL query tuning and optimisation expertise both within SQL development team and to developers in other teams working on reporting and transactional systems.• Technical lead for all SQL Server Data Warehouse development (SQL, SSIS, SSAS).• Designed dimensionally-modelled (Kimball) data mart and ETL process for operational and compliance reporting, to replace decommissioned systems.• Project managed technical aspects of major project to replace legacy compliance systems. Took on project under crisis conditions, engaged with business stakeholders to reshape solution and built collective ownership within the technical team to ensure delivery within very tight timescales.• Subject matter expert on Basel compliance, providing guidance to business users.• Managed stakeholder expectations to effectively compromise between functionality, cost and time to deliver where necessary.

• End-to-end responsibility for technical aspects of Basel compliance: defined systems based on business requirements; led team of 5-15 to develop and implement new data marts and transactional systems; developed SSRS reports based on those systems.• Designed and built complex ETL routines in T-SQL, DTS and SSIS to cleanse, validate and combine data from many sources into data-marts for risk management and operational use.• Developed statistical models to assess customer and collateral risk for use in both day-to-day risk management and for regulatory compliance.• Upgraded SQL Server databases from 2000 to 2005, including rework of DTS into SSIS. Despite complex links between systems and the lack of an end-to-end test environment, this was achieved without any implementation issues.• Managed relationship with and provided business expertise to external consultants to pilot Advanced Basel compliance within Lloyds TSB Group.• Worked with board-level stakeholders to define requirements for CF Basel programme and liaised with Group-wide programme teams to implement common customer ratings and group-wide notification of defaults.• On-going responsibility for support and maintenance of data marts and compliance-based applications, achieving significant year-on-year reductions in system downtime.

• Defined standards for SQL and Visual Basic coding, software architecture and user interface design.• Designed and led development of data mart to support operational reporting and improved customer risk management (SQL Server 2000, T-SQL, DTS).

• Managed redevelopment of customer-facing web application, providing extra functionality while substantially reducing response times.• Designed new application to import customer data for take-on, reducing set-up time from up to a week down to a few hours.• Assisted in development to application using ESB technology (BizTalk) to interface with 3rd party suppliers to provide customer credit ratings.• Management of 3rd line technical support team.

• Member of a five-person development team.• Assisted in Development, testing and implementation of customer-facing web application.• Provided 3rd line technical support for customer- and staff-facing systems.