Welcome to Otiro Ltd!

I'm Otis Francis.

SQL/BI Developer Data Architect

More About Me

Let me introduce myself.

Profile Picture

My name is Otis Francis, a SQL Developer and Data Architect of approxmately 10 years. Passionate about delivering business benefits through the intelligent use of data manipulation and process improvement.


Working for over a decade in both Public & Private Sector, as a Business Intelligence professional. Accruing a wealth of experience in Enterprise Data Architecture, Data Warehousing, SQL Development and Data Migration (ETL). Currently seeking exciting contract opportunities..

  • Fullname: Otis R. Francis
  • Profession: Contract SQL Developer/Data Architect
  • Networking: LinkedIn Profile
  • Email: Email Me


After working across various industries I have developed specialist skills in the following areas.

  • 85%
    SQL Server BI
  • 90%
    Oracle PL/SQL
  • 95%
    Data Modelling
  • 75%
    Data Visualisation
  • 85%
    Process Modelling
Curriculum Vitae

More of my credentials.

Take a peek at some of previous work experience.

Work Experience

Lead BI Developer

Nov 2014 - Aug 2016

Midland Heart

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/BI Developer

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

Mar 2012 - May 2014

British Gymnastics

Created a Kimball data warehouse and suite of dashboards using Oracle 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.


BSc(Hons) Computer Studies

Oct 2004 - Jun 2006

University of Wolverhampton

In my first year I covered logic, problem solving, server management, data manipulation, web development and software design as well as some team based projects. Year two studies extended the experience of web development and introduced networking, and databases as well as optional modules in smart systems, embedded technology, human-computer interaction and image processing. By the end of the year, I had a good working knowledge in the core principles of computing.

HND Computing

Oct 2002 - Jul 2004

University of Wolverhampton

Focusing on professional skills within the IT industry, I gained the ability to apply relevant principles and techniques to the analysis, design and development of software solutions. I also developed the academic skills needed to cope with a rapidly evolving IT environment.


What Can I Do For You?

I seek to assist organisations get a handle on their data. Providing consultancy, data architecture, data warehousing solutions and BI development.


Projects Completed


Happy Clients


Awards Received


Crazy Ideas


Coffee Cups



I'd Love To Hear From You.

Get in touch with any questions or queries that you may have. Always happy to hear from those seeking advice or further information regarding data services.

Your message was sent, thank you!
Where to find me

West Midlands
United Kingdom

Email Me At


Call Me At

Mobile: +44 (0) 7913 800 841