Jason Ballantyne

Badges

jason_ballantyn2 has not earned any certificates yet.

Cyber Security Data Engineer
Dell• June 2022 - Present
Data Analyst
Charles River Development• February 2019 - September 2020
• Created and Validated SQL automations to improve data coverage by over 25%. • Developed over 20 macros to automate client reporting to increase accuracy and make reporting 90% more efficient. • Communicating with cross-functional teams including our Product and Operations department in order to troubleshoot and resolve data gaps/issues. • Validated solutions/alerts to monitor 10+ million sets of raw data coming in from vendors daily, identifying issues early to provide accurate data to clients. • Analysing data coverage and client data requirements for new and existing clients.
Product Analyst
Centaur Fund Services• September 2017 - December 2018
• Created, monitored, and maintained SQL Server Agent Jobs and SQL Server Integration Services (SSIS) packages to store raw data from vendors to increase accuracy and reduce overhead. • Developed and implemented Excel macros used in conjunction with SQL and a Bloomberg terminal to save colleagues 10+ hours in reporting each quarter. • Maintained our FTP (File Transfer Protocol) Server from clients and brokers. • Investigated and resolved data quality exceptions on a variety of fixed and equity type instruments using external data vendors such as Bloomberg and IDC. • Diagnosed and resolved data corruption, locking, security, and connectivity issues.

University College Dublin
Computer Science, MS• September 2020 - January 2022
Relevant Coursework: Machine Learning with Python, Data Analytics, Big Data Programming, Data Programming with R
National University of Ireland, Maynooth
Business Administration, BS• September 2013 - June 2017