My very first job after schooling was as an information officer serving a small intelligence unit tracking ammonia shipments around the globe.
In those days the work was done using pen, paper and a revolutionary piece of software called 'Lotus 1-2-3'. Tools and technologies may have changed but my fundamental role has remained the same. Taking data, extracting information, imparting knowledge and disseminating truths.
Every industry has seen an increase in the volume of data that it handles. In many ways however, the challenges presented by that data remain the same; deriving meaning, finding truth. That is what I do. Be it devising new KPIs or challenging established metrics, I use data to create evidence.
Whether it is a simple MySQL database schema or a complicated columnar database based, star-schema warehouse - whether it is a locally hosted MongoDB instance or an Amazon EC2 Spark cluster, it is all data and I help people arrange, re-arrange, reduce, extrapolate, interpolate and integrate it.
And then onto the analysis of the data – to make sure the assumptions that have been made stand up. That is what fully functional business analytics is; data collection, KPI reporting, metrics analysis and forecasting. It is the rigour of the scientific method applied to the business environment, making it the 'evidence based business'.
I like to work in an agile fashion. Small bursts of work that create metrics themselves - metrics that we can learn from and feedback into the next round of tasks. All the time iterating, all the time improving.
It may be a truism that hard fact is at the root of every good decision. It follows that to be able to make good decisions, you need solid data. I help people gather, store and interpret that data, and so it follows that I can help you make the right decisions.
Senior Big Data Engineer @ Data engineer and developer -- pulling together structured and unstructured data using the Spark / Hadoop eco-system to provide the business with insight, context and clarity.
Working with data collected from mobile clients, web sites and 3rd party collection points to facilitate business dashboards, self service repositories and the basis for machine learning applications.
Working across B2B and B2C domains and processing data for advertising, research and personalisation, as a big data engineer I look after the collection point, the data processing pipeline, the storage and the transformation of event or log type data coming from embedded analytics clients.
The technology stack consists of, but is not limited to the likes of Spark, Clojure, Python, Kafka, Hadoop, Hive, Amazon (AWS) based tools, MapReduce and DAG technologies, data processing DSLs and good old fashioned relational databases. From April 2014 to Present (1 year 8 months) Senior Analytics Developer @ Lead developer and architect for a next generation business data project. Intended as a replacement for a standard data warehouse, this project takes components from across the Hadoop ecosystem and the world of big data to create a solution that is scalable, agile and well placed to meet the needs of a company growing at hyper speeds.
Hosted in the cloud, the product is Amazon based but independently structured, Utilizing a mix of traditional SQL along with cutting edge Clojure / Scala and Java based Hadoop transformations, as well as more familiar approaches like Hive and relational databases. We have taken a very eclectic approach and selected the best tools for the job - whilst remaining true to our vision of an minimal and open design pattern.
Briefly promoted to 'Analytics Lead' before moving on to a new position outside of Rovio. From January 2013 to April 2014 (1 year 4 months) Business Intelligence Developer and Manager @ Part of a four man team that re-engineered the legacy data warehouse implementation with new components, one layer at a time. The rebuilding covered everything from working with product developers to creating ETL jobs, through to fact / dimension star schema and on to reporting and analysis.
Work carries on as we face new business challenges / requirements and continue to refine and refactor our existing development. We are also working to include qualitative data measures and more sophisticated analysis components to enable predictive components for forecast data.
Accomplishments
- Developed end to end solution using multiple vendors, including SAP, Pentaho and Infobright / MySQL.
- Moved entire warehouse dataset to columnar database
- Implemented bespoke reporting solutions.
- Automated warehouse loads and report building with Jenkins CI.
- Introduced SVN and later git as source management for warehouse
- Developed advanced analysis tools in Python to reduce query time and overheads.
- Managed the uptake of Business Intelligence tools within the company. From January 2009 to December 2012 (4 years) Data Architecture Consultant @ Worked as part of the architecture team in Blyk mobile operator. Devised and implemented schema for the advertising service manager and user database. Designed and built billing ticket routing systems utilising Python and Oracle. Created an API for serving data from the central database to other Blyk components. Worked with consultancy team to create interfaces (via Talend Open Studio components) between central database and archives.
Designed, developed and implemented ‘Home Zone’ database for the HZL server from Tema Networks, which was deployed across millions of users in Russia.
Accomplishments
- Database design for large telco startup operating in UK
- Using Java and Oracle database technologies.
- Worked with all parts of the company to ensure data disseminated to those that required it via APIs From 2008 to 2009 (1 year) Database Developer - Oracle @ Worked in the core and payment team as a database developer creating APIs for access to data and data services. The API was typically utilsed by online gaming applications, games of chance such as dice, fruit machines etc. Acted as scrum master for two teams and provided architectural support for new game development and odds calculation.
Accomplishments
- Developed numerous APIs for the Oracle database layer.
- Worked with third party developers to create necessary odds calculator
- Worked on development of database schema update mechanisms
- Worked to create a GUI for database schema modifications
- Worked with developers to ensure security with online payments From 2007 to 2008 (1 year) Senior Systems Architect - Databases @ As senior systems architect for the Next Generation Messaging database servers, I was responsible for designing the data model, ensuring consistency and implementing failover within the service.
The database schema was designed specifically, from the start to accommodate connections to ETL jobs for warehousing and downstream reporting.
Accomplishments
- High availability database server built on MySQL
- Automated data and server recovery using consistency checks
- Working with Java developers to ensure integrity of data From 2005 to 2007 (2 years) Data Warehouse Consultant @ Worked as a consultant for a small team in the Singapore office of MTV to develop and build a version of the MTVNE data warehouse for use in the Asia market.
Work was once again done with Sybase, MS SQL and Business Objects / SAP reporting. From 2004 to 2005 (1 year) Revenue Systems and Data Warehouse Manager @ I was in charge of a five man team that managed, administered and developed advertising sales systems in MTV Networks Europe using Microsoft, SAP, Sybase and in house developed software. As well as the ratings, sales and broadcast automation systems, we also developed from scratch, a data warehouse solution for the Ad Sales group and later implemented a similar solution in MTV Networks Asia, Singapore.
Accomplishments
- High profile position in large international television company
- Maintained and developed mission critical advertising sales systems
- Developed, built and implemented data warehouse and reporting solutions based on Sybase, MS SQL and Business Objects platforms From 2001 to 2004 (3 years) London, United KingdomTechnical Services Engineer and Analyst @ Engineer and analyst responsible for mail, advertising sales, ratings and desktop services and various back office systems.
Accomplishments
- Installation, deployment and maintenance of corporation wide mail systems
- Deployment and maintenance of mainframe based advertising sales systems.
- Ratings systems and databases From 1998 to 2001 (3 years) London, United Kingdom
Foundation degree / Vocational Qualification, Social Sciences @ Wolverhampton Polytechnic From 1988 to 1990 Matthew Wooller is skilled in: Databases, Data Warehousing, Scrum, Agile Methodologies, MySQL, Database Design, Python, ETL, Business Objects, Analytics, Data Analysis, Linux, Java, MongoDB, Hadoop