London Area, United Kingdom
Over twenty years experience with SQL Server (2000, 2005, 2008, 2012, 2014, 2019) development, 7 years in consulting. Particularly interested in Data Warehousing & Business Intelligence. Three years experience in Lloyd's of London Insurance Market. Specialties: SQL Server development, SSIS, SSRS, Data Warehousing, BI, SSAS
• SQL Server T-SQL development, performance enhancement, & trouble-shooting • Power BI report analysis, creation, development, deployment, & performance improvement • Improved report execution times from 45 minutes to 2 minutes.
• SQL Server (2017) T-SQL development & deployment • Kimball Data Warehouse enhancement, QA, and bug-fixing, report-writing • ETL Development with T-SQL and SSIS
Architected, developed, and implemented various phases of two data warehouses. Worked closely with stakeholders: users, project managers, business analysts, ETL, SSRS, and SQL developers. Technology used: SQL Server 2012 & 2014, SSRS, Embarcadero ER/Studio, SVN, Redgate SQL Compare, Visual Studio. Main Roles: • Data Modelling • SQL Server (2014 & 2012) design, build and deployment • Inmon Data Warehouse design • Database Architecture • Mentoring team members on SSRS Main aspects: • Delivery of New company data warehouse, phase 1 to phase 3. With a budget over $4million, this involved: • Liaising with stakeholders: Business Analysts, ETL development team, QA, Operations, power users, mentoring team-members, etc. • Gathering requirements, analyzing & implementing changes, design documentation, QA support, deployment support, bug fixing, database analysis • analyzing disparate source data, T-SQL Source control & version control (Redgate & SSMS) • Subsuming and replacing legacy systems & processes • Data migration & transformation from old data stores • SSIS development for data migration • T-SQL Scripting: Stored Procedures, Rolling Partitions, deployment scripts, data interface layer
• T-SQL development • SSRS (2012) design and build • ETL: SSIS (2008 & 2012) design, development, logging, and documentation • SQL Server database development • Insurance premium (EPI) movement history tracking.