Kyle BarnesPersonal Profile

An enthusiastic undergraduate of BSc Computer Science on the path to a 1st with a keen interest in mathematics, cyber security and cloud computing as well as a drive to understand both technology and effective team working practices. Ample knowledge of the various programming languages, MS Office tools specialising in Excel and Access, and a wealth of experience in data analytics.

Technical Skills

Python – Extensive knowledge of the python programming language. 2 years of programming modules and a fully completed Codecademy course.

SQL – Data retrieval using Oracle Structured Query Language and MS Access. Extensive experience using T-SQL to query databases and Data Warehouse structures.

UML – Familiarity with Unified Modelling Language and StarUML through the analysis and code generation of separate projects.

MS Office – Proficient with every available MS Office Application from university projects. MS Excel – Expert Excel data manipulation and analysis skills, demonstrated by work done

with SQL database interrogation, then using the results to create large PivotTable based reports, accompanied by bespoke VLOOKUPS and rounding macros.

OO Programming & Software Development – Taught through modules at university along alongside Agile Development Methodologies strengthened by working in an Agile team during my contract at the SFA.

Java – Self-taught Java knowledge cemented with a foundation of C++. JavaScript – Basic but expanding JavaScript knowledge. HTML & CSS – Passionate about web design with an intermediate knowledge of HTML. Data Analysis – Database modelling and design skills, database implementation skills

including relational databases. Map/Reduce, Cassandra and Hadoop experience. Dimensional Data Modelling – 12 months experience of tailoring Fact tables and associated

Dimensions using Kimball Methodology for BI needs.

Project Experience

During my contacted employment with the Skills Funding Agency, I was brought in to help with smooth implementation of their new BI Tool, Birst, and to stay on as one of the BI system administrators. Within a team of 3, I was involved with the complete project life cycle from the concept to delivery. I was in charge of the following:

Identifying the possible flaws with their chosen BI package, and produce documentation as such.

Data modelling behind the 4 regular Birst space, Development, Test, Pre-Production and Production, as well as any spaces created for specific project needs. (NCS, QAR)

Take lead in the extraction, transformation and loading (ETL) of data from the in house Data-Warehouse to Birst.

Creating hierarchies, and setting the hierarchy level to the Surrogate key on any given dimension, as well as including natural drill-downs, and allowing the tool to accommodate different grains in the FACT tables.

Targeting dimension (attribute) tables within said hierarchies to allow those attributes to be readily available.

Successfully update the model and data behind each space depending on which current data return the organisation was using.

Act as the BI consultant on a number of different projects which would be using Birst to deliver their end-user reporting.

Perform bug-fixes, performance tuning and diagnostic exercises to ensure the tool was running as well as possible.

Email – kbarnes171@gmail.comContact No. - 07427500520

13 ChatsworthBangor

BT19 7WA

Complete individual dashboards as a means of reporting statistics to my Birst Administrator Team such as usage tracking, specific dashboard traffic and showing time-scale history of dashboard development per developer.

Employment History

BI Administrator and MI Analyst Skills Funding Agency (SFA) May 2015 – Present Management of the organisation’s Business Intelligence tool, Birst including: Data Extractions from DEDS into Data Warehouse. Transformation and loading of the data into the warehouse. Testing of data integrity once load and build is complete. Extraction, transformation and loading of warehouse data into the Birst BI tool. Dimensional modelling, using the warehouse’s predefined Facts and Dimensions, within Birst

to suit pressing business and reporting needs. Development of roleplaying dimensions within our Birst Data Model. Copying extracted and processed data from Development and Test spaces to the Pre-

Production and Production spaces. Developing custom measures and attributes, drill maps and saved expressions for use of all

dashboard developers. Creating dashboards to cater to business intelligence needs and provide management

information reports. Handling usage tracking and security precautions to manage access for various providers

across England. Generation of regular Performance & Management Information reports. Gap Analysis documentation. Interrogation of SQL databases and the newly implemented Data Warehouse. Thorough data analysis through various methods in MS Excel on a daily basis.

Supervisor Jack & Jones Oct 2014 – March 2015 Handling store operations with no other members of the management team, making sure

targets were hit and consumer complaints were dealt with in a professional way. This allowed me to hone my problem solving skills in high stress situations.

Dealing with area and nationwide management requests whilst under time and manpower constraints, adhering to company regulations and standards.

Education

Coventry University (Coventry, England) Sept 2012 – PresentModules including but not limited to: Logic and Sets (88%), Computer Architecture and Networks (88%), Designing for Usability (65%), Real World Project (65%), Technology and its Social, Legal and Ethical Context (76%), Programming, Algorithms and Data Structures (92%).

Bangor Grammar School (Bangor, Northern Ireland) Sept 2005 – Sept 2012A-Levels: Mathematics (C), Physics (D) and ICT (C) 10 GCSE’s grade A-C including ICT (A), Physics (B), Mathematics Higher (B), English (C).

Action Cancer Listening Ear Further Counselling Skills November 2011Accredited with: Level 2 by the Open College Network, NVQ Level 2.

Microsoft Excel 2013 Level 2 and Level 3 November 2015Hosted by Decimus Training & Consultancy. Full 3 day training course.

References Available Upon Request