Patrick Leddy

Experience

• 

  Datapac

  Jan 2012 - May 2012

  IT Support Technician

  Worked as a support technician (as part of my university work placement) in the Datapac call support centre and workshop to resolve hardware and software issues for customers.Main duties included:● Providing first level support to diagnose and resolve technical issues reported by users.● Using help desk call logging system to record all reported issues.● Performing hardware and software installations on customer machines.● Ordering replacement equipment when required.

• 

  Fidelity Investments

  Jun 2012 - Aug 2012

  Technical Intern

  Worked as a technical intern within the Fidelity Center for Applied Technology on a fantasy investing game called Fidstreet. Fidstreet was developed in HTML5 using the open source LAMP stack. In the course of working on the game I was given the opportunity to try different areas including front end Web Development (HTML, JavaScript and CSS), Web Services in PHP & Relational Databases with MYSQL. I also took on a QA role near the completion of the project prior to its release. This involved me writing and executing test plans.Main duties included:● Creating site pages using PHP, MySQL, HTML and CSS.● Writing queries and updating MySQL database tables.● Providing technical support for players.● Creating QA test plans and analyzing code for potential bugs.● Carrying out various testing processes such as Unit Testing, Integration Testing and Acceptance Testing.● Networking with UAT testers to report issues.● Delivering project status report to senior management. Show less

• 

  Certus

  Nov 2013 - Oct 2014

  SQL Developer

  Employed as a SQL Developer in the Certus MI Department. Assisted in the creation and amendment of financial reports that were provided to clients.Main duties included:● Creating and amending stored procedures, tables, etc. using SQL Server.● Updating reports within SSRS using Visual Studio.● Creating Excel macro files that produce automated datasets through coding in VBA.● Dealing with Service Change Requests from clients. This involved writing up change proposals and technical specifications as well carrying out development and testing of the changes themselves and finally rolling them out into production. Show less

• 

  Trintech

  Jan 2015 - Aug 2015

  Account Manager

  Reported to the Team Lead in the Dataflow Services Department. Held responsibility for technical management of customer accounts to ensure automated processing of daily financial data.Main duties included:● Daily data retrieval and processing of data for customers.● Properly identifying and resolving data-related problems such as out-of-balance bank statements and invalid data mappings, and ensuring delivery of complete data.● Communicating data issues to relevant parties: customer, team lead, or bank representatives.● Creating, updating and closing customer issues in Salesforce Agent Console.● Troubleshooting internal scripting configuration issues.● Implementing work around processes for data retrieval when processes failed. Show less

• 

  Bloomberg PolarLake

  May 2016 - Jul 2017

  Data Operations Analyst

  Assist with the operational support of managed service clients by undertaking the daily operational tasks of handling the acquisition and cleansing of data from the many multi-vendor sources.Main duties include:● Monitoring the receipt of financial data feeds from vendors, as well as client’s proprietary data.● Investigating and resolving exception issues on a variety of client activities such as Security Master, Price Master, Index Master, Legal Entity Master and Corporate Actions.● Responding to ad-hoc queries from customers and ensuring that a high quality service is provided to Bloomberg PolarLake clients according to defined Service Level Agreements (SLAs).● Researching data quality issues, identifying resolutions and updating system outputs as required.● Identifying and implementing solutions that improve the operations of systems and processes.● Participating in user acceptance testing during initial on-boarding of managed service clients.● Various ad-hoc projects. Show less

• 

  Sojern

  Aug 2017 - Jun 2019

  Remotely managed two associate analysts based in London and given responsibility of ensuring optimal campaign performance for all Enterprise and SMB clients within EMEA.Main duties include:● Delegating allocation of campaign management amongst team, and organising regular catch ups with each analyst to review performance against client KPIs.● Leading weekly brainstorming session with team to discuss techniques and tools that could help improve performance for under-performing campaigns.● Organising video calls on a frequent basis with Enterprise and SMB Account Managers to discuss campaign performance, upselling opportunities, reporting, and product training.● Informing analyst manager of any challenging issues experienced by the team, mostly performance of specific client campaigns, resource management, and product limitations. Show less Drive operational efficiency throughout the company and tasked with supporting multiple teams along the way. Ensure campaigns are structured in an optimal way, data feeding decision making is accurate and build out improved ways to ensure data quality throughout Sojern systems.Main duties include:● Using problem solving and analytical skills to ferret out the techniques necessary to optimize campaign performance.● Create best practice documentation and rollout to relevant teams.● Take learnings to the Product, Engineering and Data Science teams to create repeatable rules, processes and data models that scale.● Communicate insights to multiple internal stakeholders through Tableau Dashboards, built using SQL queries from first and third party datasets.● Intelligently combine the audience segmentation, bidding, delivery and pricing strategies, to extract optimal conversion based performance for our travel advertisers by leveraging Sojern’s exclusive travel intent audience.● Various ad-hoc projects and presentations. Show less

  • Senior Analyst

    Dec 2018 - Jun 2019

  • Analyst

    Aug 2017 - Dec 2018
• 

  CarTrawler

  Jun 2019 - now

  Product Insights & Revenue Manager

  Supporting CarTrawler Mobility by building a comprehensive picture of product and revenue performance across our partner and customer base in a responsive, flexible and collaborative manner.Main duties include:● Develop and maintain product performance reporting within Tableau, driven by SQL queries within our DBMS Snowflake.● Work with P&T and Data Intelligence teams to scope analytical requirements related to new and existing products and their key components, for the purpose of performance insights.● Build or modify structure of database objects (tables/views) in snowflake that enables the most optimal method for querying product data.● Work with product managers to identify areas of commercial opportunity and/or improvement based on user behaviour analytics throughout the product funnel, and also through analysis of pricing strategies.● Empower partner/supply managers through data visualization (tableau dashboards) to share information and KPIs with airline partners and mobility suppliers.● Collaborate with the finance department on the development of our financial plan (EBITDA) by assessing current airline partner performance, optimisations and sales pipeline, as well as investigating market trends sourced from third-party data vendors.● Along with the Mobility Director, Commercial Leads and P&T team, carry out strategic planning that is based on revenue estimates of current partner optimisations, sales prospects and product improvements. Show less