Blair Franklin Email & Phone Number

Melbourne, Vic, Au

Melbourne, Victoria, Australia

Principal consultant building out the Data, Analytics and AI practice. This involves pre-sales, technical leadership, architecture and delivery.

Melbourne, Australia

Melbourne, Australia

Working across various data and analytics projects in Azure. I have worked as a team lead, techincal lead, data modeller, solution architect and BI developer depending on the requirements of the project.

Melbourne, Australia

Gathering requirements from the business and creating solutions

Wellington & Wairarapa, New Zealand

Bringing the existing systems up to best standards and developing a new star schema Data Warehouse.Working with SQL Server 2014, C#, Kimball Data Warehouse, TSQL, Active Directory.

Wellington

Based at The Treasury working on a large scale agile project covering a Star Schema Data Warehouse, Multidimensional Cube, SSRS Reporting, Integration Services, Data Vault, Application and Relational Databases. The relational databases are feeding Data Vault which is turn feed the Data Warehouse.Working with SQL Server 2014, Kimball Data Warehouse, MDX, TSQL, Multidimensional Cube, Reporting Services, Relational Databases and the Agile methodology.

Wellington

Working with Toyota, NZTA and other various companies to deliver Microsoft Business Intelligence solutions.Working with SQL Server 2008 R2, 2012 and 2014 to deliver Microsoft solutions. This includes following the Kimball Methodology to produce all parts of the solution including ETL (SSIS), Reports, Data Warehouse, Cube and Tabular Models. Reporting has been achieved with SharePoint (Performance Point, PowerView) and Reporting Services.

Wellington

Using an Access 2010 project as a front end with a SQL Server 2008 R2 backend. Reporting Services is used for the reports; Integration Services manges data chains and there is an ASP.Net website in place to act as a dashboard for the reports.Working with SQL 2008 R2 Database, SSIS, SSRS, Visual Basic, ASP.Net and Access VBA.

London

I was Working within Technology with IBM TM1 and Microsoft SQL Server dealing with the different finance sectors within the business. I provided support and implemented changes within TM1 and Microsoft BI. I also rewrote procedures in oracle to fix data inaccuracies so that the BI reports were worthwhile.I provided support and training as well as analysis and development of new projects within the business.

Wellington

Dealing mainly within the Finance department of the companies, I was working as a consultant. My specific role was to provide financial reporting, analysis, design, development and support services to a range of their clients using the TM1 model and VBA excel.