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..
After working across various industries I have developed specialist skills in the following areas.
Take a peek at some of previous work experience.
Nov 2014 - 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..
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.
Mar 2012 - May 2014
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.
Oct 2004 - Jun 2006
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.
Oct 2002 - Jul 2004
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.
I seek to assist organisations get a handle on their data. Providing consultancy, data architecture, data warehousing solutions and BI development.
Assisiting with project planning for implemenation of database solutions within your organisation.
Providing Data Warehouse solutions (Kimball/Inmon), accompanied by data visualisations using tools such as SQL Server SSDT (SSIS,SSAS,SSRS), Qlikview, Tableau etc.
Providing data modelling and design documentation for OLTP and OLAP systems.
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.
Mobile: +44 (0) 7913 800 841