Ronan Keane Email & Phone Number

London, United Kingdom

Playing a key part in a project to develop TIDAS, the next generation of the Treïs portfolio management system. The internal system is being completely re-architected and rewritten with plans to market it as a commercial software product. Writing complex T-SQL code running in Azure SQL Database. Integrations to various data feeds (Bloomberg Data License, JP Morgan, Eurotat, IMF) using a combination of Azure Data Factory (ADF), Azure functions (C#) and T-SQL. Building… Show more Playing a key part in a project to develop TIDAS, the next generation of the Treïs portfolio management system. The internal system is being completely re-architected and rewritten with plans to market it as a commercial software product. Writing complex T-SQL code running in Azure SQL Database. Integrations to various data feeds (Bloomberg Data License, JP Morgan, Eurotat, IMF) using a combination of Azure Data Factory (ADF), Azure functions (C#) and T-SQL. Building ELT to import data from external databases, matching to that data and identifying modified data and new data. Processing late arriving dimensions. Designing data models to support the requirements of the system. Migrating data from the legacy portfolio management system. Applying significant transformations so that the data fits into the new data models. Designing and processing tabular models in Power BI. Building reports using Power BI and DAX. Building CI/CD pipelines using Azure DevOps. Code is source controlled using Git. Some experience of Azure Databricks with Python.Managing one team member. Show less

London, United Kingdom

Took over as sole developer for the Treis Partners in-house portfolio management system, which was previously developed by a group of portfolio managers at the company. The system allows in-depth analysis of the existing investment portfolio, and analysis of all potential new investments. Treis Partners invest in a wide range of asset classes and working with the system has given me an understanding of a wide variety of financial instruments.Took full ownership of the system. Learnt the… Show more Took over as sole developer for the Treis Partners in-house portfolio management system, which was previously developed by a group of portfolio managers at the company. The system allows in-depth analysis of the existing investment portfolio, and analysis of all potential new investments. Treis Partners invest in a wide range of asset classes and working with the system has given me an understanding of a wide variety of financial instruments.Took full ownership of the system. Learnt the existing code base in full (SQL Server, T-SQL, a C# Windows Forms application and a legacy ETL process).Handled development of all new features for the portfolio management system. Also rewrote legacy code (T-SQL, C#).Successfully made the case for the building of a data warehouse, an SSAS tabular model and the adoption of Power BI for all new reports for the next iteration of the system.Building a data warehouse applying Kimball methodologies.Building a tabular model in Power BI encompassing a large number of DAX calculations. Gaining a deep understanding of the DAX language through self-study.Moving the entire platform to Azure, making use of Azure SQL Database, Power BI and DAX, Azure Data Factory and Azure Databricks. Show less

London, United Kingdom

Attending meetings and discussions for the majority of large software projects in the company. Providing advice and guidance on how the database side of these projects is to be implemented.Took over responsibility for the OLAP data warehouse and SSAS cubes. Implementing a roadmap of new features. Tuning performance of the SSIS ETL load. Identifying bugs, developing fixes and back-populating incorrect historical data. Identifying the main performance bottlenecks in our system… Show more Attending meetings and discussions for the majority of large software projects in the company. Providing advice and guidance on how the database side of these projects is to be implemented.Took over responsibility for the OLAP data warehouse and SSAS cubes. Implementing a roadmap of new features. Tuning performance of the SSIS ETL load. Identifying bugs, developing fixes and back-populating incorrect historical data. Identifying the main performance bottlenecks in our system. Proposing performance improvements including indexing, query rewrites and schema redesign to speed problem queries. Identifying ways to resolve blocking and deadlocking. Making proposals for scaling our platforms to support a large increase in concurrent users as bigger customers come on board. Show less

London, United Kingdom

Returned to GAN as agreed at the end of the secondment to Aristocrat (I was promoted by GAN the following year).Worked in agile sprint cycles on large projects to add new features to the gaming system. I gathered requirements, designed, developed, wrote test plans, tested and documented my work.Involved in design decisions for major development projects as well as redesign of old schema and functionality. I am proactive in identifying ways old parts of our system can be… Show more Returned to GAN as agreed at the end of the secondment to Aristocrat (I was promoted by GAN the following year).Worked in agile sprint cycles on large projects to add new features to the gaming system. I gathered requirements, designed, developed, wrote test plans, tested and documented my work.Involved in design decisions for major development projects as well as redesign of old schema and functionality. I am proactive in identifying ways old parts of our system can be improved.Support and new development for the ETL processes, data warehouse and SSAS cubes. I completely pulled apart the ETL processes, data warehouse and cubes at GAN and learnt how the whole solution worked so I could support it and develop additions to it. I have delivered a number of enhancements to our OLAP reporting systems. I also taught myself MDX which I am making use of. Out of hours production support on a rota basis involving performance monitoring and troubleshooting as well as third line application support.Involved in the recruitment of all new SQL developers for the transactional DB environments. Show less

Soho, London

Sole database resource on a large project to hand over a modified version of the GAN gaming platform to Aristocrat over a period of 18 months. Aristocrat had purchased the software from GAN.Planned and led the database side of the deployment of the new platform. Built the database aspect of new dev and test environments single handedly and deployed and tested a completely modified code base to production.Set up the existing SSIS ETL load on the Aristocrat platform and made… Show more Sole database resource on a large project to hand over a modified version of the GAN gaming platform to Aristocrat over a period of 18 months. Aristocrat had purchased the software from GAN.Planned and led the database side of the deployment of the new platform. Built the database aspect of new dev and test environments single handedly and deployed and tested a completely modified code base to production.Set up the existing SSIS ETL load on the Aristocrat platform and made modifications to the SSIS packages.Set up the existing C# reporting web application on the new Aristocrat platform. Made modifications to it and deployed all SSRS reports. Documented the system in detail.Implemented the GAN release process at Aristocrat and set up and maintained source control using Tortoise svn and RedGate SQL Source Control.Identified major bottlenecks in the database and built a number of identical platforms to facilitate a go live of the new Product Madness system (online gambling through social media such as facebook). The combined platforms allowed the system to handle 10,000 concurrent users (from 2000 initially).Trained a team in India to take over the system after we returned to GAN.Reviewed junior developer’s code.Worked on a number of cloud environments hosted on VMs in Azure. Conducted interviews remotely for the DBA role based in India.Carried out integrations of third party gaming providers to the system.Set up log shipping on the dev and test systems.Worked on file loading applications in SSIS to handle automated data loads to the platform DB. Show less

London, United Kingdom

Worked on core code for the GAN gaming platform. Wrote stored procedures, triggers, views and functions. Identified and added missing indexes.Developed new SSRS reports and modified existing reports.Did a significant amount of work on the existing ETL package for the company’s data warehouse (SSIS).Worked on a wide variety of relational database projects including bonusing and promotions, new code to comply with regulatory requirements and adding new… Show more Worked on core code for the GAN gaming platform. Wrote stored procedures, triggers, views and functions. Identified and added missing indexes.Developed new SSRS reports and modified existing reports.Did a significant amount of work on the existing ETL package for the company’s data warehouse (SSIS).Worked on a wide variety of relational database projects including bonusing and promotions, new code to comply with regulatory requirements and adding new gambling partners to the platform.Tuned and enhanced the performance of existing stored procedures.Designed new database schema.Database third line application support during office hours on a rota basis.Investigated and resolved issues with service broker and log shipping. Show less

Tunbridge Wells

Wrote complex T-SQL queries to be used in data loading applications at MDSL. My queries transformed the data being bulk loaded to the system, in order to extract meaning from it and condition it for reporting purposes.Developed large and complicated one-off data loading applications in response to specific customer requests and according to defined specifications.Investigated and resolved performance issues with existing T-SQL code and carried out re-writes of existing code… Show more Wrote complex T-SQL queries to be used in data loading applications at MDSL. My queries transformed the data being bulk loaded to the system, in order to extract meaning from it and condition it for reporting purposes.Developed large and complicated one-off data loading applications in response to specific customer requests and according to defined specifications.Investigated and resolved performance issues with existing T-SQL code and carried out re-writes of existing code. Made enhancements to data loading applications in response to new customer requirements.Performed enhancements to the C# code of the MDSL proprietary data loading software which is used to bulk load data from flat files, Excel spreadsheets and Microsoft Access databases to customer’s SQL Server application databases.Developed SSIS packages to load data to customer databases. Show less

Worked in a team of Oracle and Microsoft SQL Server database professionals providing database administration services and consultancy to SMEs, semi-state organizations and large MNCs. Provided remote and onsite administration of Oracle and SQL Server databases on both Microsoft Windows and Unix AIX environments.Responded to support calls from our clients. Investigated and resolved performance issues with customer databases.Developed reports in SSRS 2008, reporting on… Show more Worked in a team of Oracle and Microsoft SQL Server database professionals providing database administration services and consultancy to SMEs, semi-state organizations and large MNCs. Provided remote and onsite administration of Oracle and SQL Server databases on both Microsoft Windows and Unix AIX environments.Responded to support calls from our clients. Investigated and resolved performance issues with customer databases.Developed reports in SSRS 2008, reporting on internal data in our organisation and also data which was being collected about our customer’s I.T infrastructures.Carried out preventative maintenance health-checks and tuned databases for optimum performance.Restored and tested Oracle and SQL Server database backups from tape.Accompanied the consultants during on-site work at customer businesses. Performed SQL Server installations and SQL Server service pack installations.Configured database testing environments at Trilogy Technologies using VMWare.Carried out bulk loading of data to our internal databases using BULK INSERT and bcp.Documented procedures related to the administration and support of customer databases.Played a key part in a project to develop a large web application using C# and ASP.NET to display the company's reports. Show less

Postgraduate Diploma In Business Studies With First Class Honours, Business Studies

Graduated with very high marks and achieved First Class Honours overall in my postgraduate diploma at Ireland's leading business school.

Bachelor Of Science (Honours) In Computing Multimedia Systems With First Class Honours, Computing

Graduated with very high marks and achieved First Class Honours overall in my honours degree.

Bachelor Of Science In Computing Multimedia Programming With Distinction, Computing

Graduated with very high marks and achieved a distinction overall in my degree.

Education record