Brion Mallon, Developer in Dublin, Ireland
Brion is available for hire
Hire Brion

Brion Mallon

Verified Expert  in Engineering

Mainframe Developer

Location
Dublin, Ireland
Toptal Member Since
June 18, 2020

Brion has 20+ years’ experience as an IT professional working as an analyst, SQL/database developer, and mainframe developer. He recently returned to fulltime education and was awarded a Higher Diploma in Science and Data Analytics. Brion's experience includes working in different business areas such as banking, retail, airlines, and insurance as well as providing database/DBMS support and in-depth SQL knowledge.

SQLIBM Db2SQL Server 2012COBOLWindowsMicrosoft SQL ServerTeradataOracleSybaseUnixC#.NETLinuxAgileC#Python

Availability

Part-time

Preferred Environment

COBOL, Oracle RDBMS, Teradata, IBM Db2, Microsoft SQL Server

The most amazing...

...experience was being part of an IBM team developing a customer application.

Work Experience

SQL Developer

2016 - 2017
BNP PARIBAS DUBLIN
  • Supported SQL development within an agile work environment.
  • Created PL/SQL scripts to import data into Oracle 11g.
  • Designed complete SQL queries to support the generation of reports.
  • Built T-SQL scripts to export data from SQL Anywhere.
  • Provided SQL/Database support during the development of a Customer Fund Management Application including writing and testing complex SQL queries, creating views, functions, and stored procedures.
Technologies: Sybase, Oracle

Software Developer

2014 - 2014
Bottletop Media (clickonline.com) DUBLIN
  • Provided SQL/Database support, created tables, and stored procedures and functions.
  • Used C# .Net to code a batch application to extract TV listings data from an XML file published by Associated Press. The listing data was loaded onto a SQL Server database.
Technologies: C#.NET, Microsoft SQL Server

SQL Developer

2008 - 2009
S1 Banking Software Solutions DUBLIN
  • Providing SQL/database support to application development teams. This included installing DB2 on various machines, building test databases for different schema configurations, creating test data, and providing support for general SQL questions.
  • Contributed to database related actions like analyzing, testing, and preparing and implementing any changes to the schema.
  • Created a presentation which provided a detailed documentation of the S1 retail bank database schema. I subsequently gave this presentation to S1 application development teams in Bangkok.
Technologies: Microsoft SQL Server, Unix, Windows, IBM Db2

Developer

2007 - 2007
AIB (Allied Irish Bank) DUBLIN
  • Enhanced the bank's warehouse by changing the ETL process to capture and load data from new functionality added to the banking operational application.
  • Wrote and updated Teradata scripts to load new data onto the bank's warehouse including writing scripts and creating complex SQL queries.
Technologies: SQL, Teradata, IBM Mainframe

Application developer / SQL developer

1997 - 2006
Bank of Ireland DUBLIN (various contracts during this time)
  • Supported the bank's B365 online application including day to day support, coding, testing, and implementing any changes to this application.
  • Provided DB2/SQL support to developers working on an upgrade of software during the bank's transition to the Euro currency.
  • Analyzed and mapped the legacy banking application to banking package. This involved mapping the legacy application functionality to the new application then customizing the new application.
  • Designed, coded, tested, and implemented a new customer credit enchantment to the B365 online application.
  • Contributed to redevelopment of the Banks Batch Paper Payment system. This new application allowed the bank to process paper transactions multiple time a day (instead of a single overnight run).
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer

1998 - 2003
IBM DUBLIN (various contracts during this time)
  • Coded some of the central components of the application. This gave me a deep understanding of the whole package.
  • Adapted the application to meet the specifications of IBM customer.
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer

1997 - 1997
CEDEL Bank LUXEMBOURG
  • Developed and maintained the CEDEL Bank fund management application.
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer / sql developer

1996 - 1996
Amadeus ANTIBES, FRANCE
  • Built an ETL process to extract data from multiple sources on the operational Amadeus airline reservation system. This ETL process load data onto a newly created Data-warehouse.
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer

1995 - 1996
London Electricity, LONDON
  • Coded and tested modules for a customer accounting application.
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer

1995 - 1995
NPI Insurance LONDON
  • Participated in the coding testing of modules for a customer's Mutual Funds Reporting application. This application provided annual customer statements required by legislation changes.
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer / SQL developer

1994 - 1995
Kindle Banking Solutions DUBLIN
  • Maintained and developed a retail banking application.
  • Changed the banking application to make it DBMS independent; this entailed making sure the SQL adhered ANSI standards.
Technologies: COBOL, SQL, Ingres, IBM Informix, Unix

Application developer / SQL developer

1990 - 1993
Ansett Airlines Australia MELBOURNE
  • Contributed to an application developers support team providing technical support and expertise to the application development teams.
  • Assisted developers with mainframe and COBOL issues. Our team would create standardized application software used by developers to swiftly build applications with minimal errors.
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer / SQL developer

1989 - 1990
Hertz Car Rental LONDON
  • Designed and coded a large number of programs for the extraction process (ETL).
  • Coded the SQL required for the reports.
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer

1988 - 1989
Sedgewick Insurance LONDON
  • Coded and tested an on-line banking system using the development software APS.
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Application developer

1986 - 1988
Safeways LONDON
  • Contributed to management and development of all software relating to the store ordering system .
Technologies: SQL, COBOL, IBM Mainframe, IBM Db2

Various Items From Data Analytics Course

http://github.com/brion101/brion101.github.io
I have added a link to a git repository that contains various project items from a Data Analytics course I attended 2016-2017.

This was my first experience using Python.
2016 - 2017

Higher Diploma in Science and Data Analytics

Dublin Business College - Dublin, Ireland

2015 - 2015

Continuing Professional Development Course in Database Development and Cloud Technologies

Dublin Business College - Dublin, Ireland

2014 - 2014

Continuing Professional Development Course in Microsoft .NET Web Developing

Techelevate - Dublin, Ireland

OCTOBER 2017 - PRESENT

Higher Diploma in Science

QQI Ireland

Languages

SQL, COBOL, C#.NET, C#, Python

Storage

SQL Server 2012, IBM Db2, Microsoft SQL Server, Teradata, Oracle RDBMS, Sybase, IBM Mainframe, IBM Informix, Ingres

Other

COBOL Batch, Mainframe, Software Development

Paradigms

Agile

Platforms

Oracle, Unix, Windows, Linux

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring