Otis Francis

07913 800 841 • otisfrancis1@gmail.com

Personal statement

An experienced Data Warehouse Architect/SQL Developer with a decade of experience in Business Intelligence, across a variety of business sectors. This experience has been invaluable in honing an acute ability to adapt to any business environment easily and deliver value swiftly. Currently seeking an exciting new Data Warehousing or SQL Developer opportunity.

Key Skills

Employment History

Data Modeler/BI Developer, Claire’s Accessories (Retail), Birmingham

(Jun 2017 - Present)


Modeling and developing a Global Data Warehouse, using the latest Azure technology (ADF/ADW) & WhereScape software. Data sources include but are not limited to Google Analytics, YouTube Analytics, SalesForce and SQL Server E-commerce platforms. Creating dashboards using Power BI desktop and deploying to Power BI Cloud Server.

Senior Data Architect, Police Mutual (Financial Services), Lichfield

(Nov 2016 – Jun 2017)


Providing data warehousing consultancy and data architecture services. Design and overseeing the implementation of an ISA data mart. Managing to turn around a failing project by developing relationships with key stakeholders and extracting business requirements from the business in order to ensure the data mart was “fit for purpose”.



SQL BI Developer (Technical Lead), RAC, Walsall

(Aug 2016 – Oct 2016)


Responsible for project planning for migration from SQL Server 2008 R2 to SQL Server 2016. Successfully embedding coding standards, Kimball methodology and TFS usage across the development team.


Lead BI Developer/BI Manager, Midland Heart, Birmingham

(Nov 2015 – Aug 2016)


Embedded an Agile data warehouse development lifecycle, within a green field project. Designed and implemented code platforms from Development through to UAT and Production. Created business processes for code promotion between environments. Implemented Kimball Data Warehouse to deliver enterprise level KPIs, HR and IT data marts. Developing KPI dashboards and scorecards with SSRS.


Data Architect/SQL Developer, PwC, Birmingham

(May 2014 – Nov 2015)


Created a data warehouse that provided a complete overview of both past and future staff timesheet data and integrated this with financial data to generate actual and forecast revenue reporting. This allowed the business to perform full end-to-end analysis of their Human Resource pool for the first time in the Firm’s history. This has also resulted in a significantly more efficient Business Intelligence solution, saving many hours of staff time, that were previously wasted pulling together reports from various systems, often with varying degrees of accuracy and consistency.


Lead SQL Developer, British Gymnastics, Newport

(Mar 2012 – May 2014)


Created a Kimball data warehouse and suite of dashboards using Oracle (PL/SQL) and Qlikview. The Business Intelligence solution offered a single overview of the business, available for the Senior Leadership team right down to Operational Team Managers. This allowed business decisions to be made much more easily and with a lot more confidence than ever before, as the figures were consistent, accurate and timely.


Data Quality Manager, NHS, Birmingham 

(Oct 2009 – Mar 2012)


Responsible for moving the West Midlands Cancer Registry’s data quality ranking from 6th to 2nd in the national league tables, within 18 months. This was accomplished through a series of data quality enhancements, such as utilising electronic feeds to supplement the manually keyed data, using automated routines to validate data entry and performing data audits through the creation of data quality test scripts. The significant improvement of data quality resulted in my appointment to oversee data quality KPI’s for the UK Association of Cancer Registries.




University of Wolverhampton

(Oct 2002 – Oct 2006)


Available upon request.