Gary Jackson Email & Phone Number

Pretoria Area, South Africa

Jan 2016 - Reserve Bank South Africa, Pretoria - ContractIn charge of migration from legacy AS400 to SQL Server 2012.Using ETL SSIS 2012, stored procedures, triggers, database referential integrity.Transform and clean data, verify correctness. The data is central to all systems and willbe used by the bank economists to make monetary policy. This is a.

Leeds, United Kingdom

SQL developer contract. Short contract where I worked until the company could find a permanent employee. I worked on SQL Server 2008R2 maintaining SSIS packages and doing live support for clients on the data warehouse using the 2008 BI stack. Used some C# SSIS scripting tasks. The methodology used was Agile with SCRUM. TFS was used as the source control.

Pretoria Area, South Africa

Joined a project that is to replace the old mainframe system that enables economists to view timeseries data scenarios and recommend monetary policy.My part of the project was mainframe database Migration from legacy AS400 mainframe to Windows SQL Server. To import Bond and stock data from various exchange sources, including the local Johannesburg Stock.

South Africa

C and SQL database scripting for private websites.

St Albans, United Kingdom

Migrated Fisher's SSAS cubes and Kimball warehouse from SQL Server 2008r2 to 2012, including SSIS ETL. The underlying transactional relational database was migrated from Epicore 9 to Epicore 10. Implemented their new DSPanel business intelligence solution using SQL Server 2012 stack. I worked closely with the financial team to produce the correct.

London

This E commerce company does the bulk of the outdoor billboard type advertising for the underground, buses and railways in the UK. They have to track inventory, work specifications, work carried out, and all finances around this. It is a complicated system of many variables.Developed 2 Kimball star schema warehouses and SSAS cubes mostly from scratch.

London, United Kingdom

The company had built a Kimball data warehouse using the SQL Server 2008r2 BI stack and DSPanel tools built on the Epicor9 relational database to supply data to financial Profit and Loss and Balance Sheet reports that daily track revenue movements of their library of films, TV shows and theatricals from 4 continents. They had spent 2 years on it and it was.

London, United Kingdom

Designing and developing Kimball Star Schema data marts as well as an Inmon style normalized Enterprise Warehouse to provide financial reports in a Cognos layer. Reports include general ledger, payroll and some HR employee data. HR salary data was encrypted using private/public keys and certificates. Data was collected and stored from staging into an Imon.

SQL Server 2005, Analysis Services (SSAS), Integration Services (SSIS). Responsible for doing support from and supplying data to the marketing team in the form of Ad Hoc queries, SSAS cube browsing, and batched SSIS scheduled jobs. The Enterprise Warehouse was a normalized Inmon type design, the local warehouse was Star Schema. Also, used Excel connected.

Geopost have implemented an open source Business Intelligence datawarehouse system from scratch using MYSQL and Pentaho. I was responsible for the design and technical implementation of the warehouse, cubes and interfaces, as well as warehouse training and handed the system over to the IT team at Geopost. The company transports over half million packages.

London, United Kingdom

Room supplies Business Intelligence consulting and services to the Insurance industry. Involved in providing support and development for the BI using OLAP, mainly Kimball Star Schemas, SQL Server 2005 with SSIS and SQL Server 2000 with DTS. Using views, T-SQL and stored procedures to build the warehouses. Developed Cubes using Analysis Services with MDX.

Kent, UK

SQL Server 2000 and 2005 OLAP development, SSAS. Star Schema, cubes, stored procedures, DTS/SSIS, SQL application development. Required to extract data from 2005 database and import into 2000 staging. Clean and transform data. Required to design and populate shared dimensions and fact tables to create Star Schemas using Kimball Methodology. Check and.

London, United Kingdom

Developed an OLAP warehouse Business Intelligence solution from scratch for the BBC, - web front-end with expected 100,000's/millions of views daily.Using open source Linux, MYSQL, JAVA, APACHE, TOMCAT, PHP, Pentaho Mondrian, MDX tools. I was wholly responsible for the databases and warehouse design, development and implementation, and also of the LINUX.

Guildford, United Kingdom

Business Objects 6.5 consultant. Support desk handling BOC user support and trouble tickets for Business Objects. Using Business Objects Broadcast Agent to schedule jobs, WEBi, Infoview, Designer, Supervisor and Business Objects 6.5. and BODI. Business Objects was connected to Oracle 10, DB2 and SQL Server 2005 databases using Data Integrator and DB2 layer.

London, United Kingdom

Private work for internet clients, mainly on databases MYSQL and SQLserver 2005. Database and data warehouses for websites. Work done in SQL embedded in PHP, C, AWK, SED, C-shell, PERL.- Standalone programs and utilities mainly in C. eg. compound interest calculator. Work mainly done on Linux platforms using versions SUSE 10.2, UBUNTU 6, KNOPPIX 5.1.

Milton Keynes, United Kingdom

KPI system for bank employee key performance indicators. SQL Server 2005 database DBA and developer, T-SQL, SQL, database Stored Procedures, Analysis Services( SSAS ) OLAP, Star Schema Warehouse, Oracle, DTS ETL, SSIS, Business Objects Xi and 6.5 reports. Brought on to join team of two others to salvage KPI system that has been a year in development.

London, United Kingdom

Implemented Business Objects (Business Objects 5.1) reports on Sybase data warehouse. Migrated some reports from Excel, created others from scratch. Used Supervisor, Designer, Business Objects, stored procedures, SQL, Windows, UNIX, Clearcase, Sybase ASE.Management reports to measure client trading performance and risk against market benchmarks. Data.

London, United Kingdom And USA

Prior experience as a database developer and DBA. Mainly in the USA and UK. Details upon enquiry.

Bsc, Computer Science, Maths

BSc Computer Science

Bachelor'S Degree, Mathematics And Computer Science