Portfolio
Securitizated Debt Instrument
Lead data expert for a multi-billion euro securitization debt instrument for Irelands leading banking institution. Providing all mortgage data via complex rules-based criteria.
Teradata, R, Python and Excel (VBA) were the main tools used to extract and present the data for the project.
Database and Report Migration
Migrated entire reporting infrastructure from OpenSAS system to an SQL Teradata database. This was for an entire subsidiary bank within the overall bank. Optimized and built efficiencies in the business reporting process by, for example, data extraction automation using Excel (VBA)
Teradata, R, Python and Excel (VBA) OpenSAS were the main tools used to extract and present the data for the project.
High-Value E-Commerce Business leads
Used information on companies that have a social media presences to estimate revenues using their likes count. I crossed referenced this with revenue reported to the Companies House UK to give an estimated range of revenue. This data extraction was automated and segmented by different sectors within the United Kingdom.
Python, Selenium, Excel, Amazon Web Services were the main tools used to extract and present the data for the project.
US Stock Portfolio
Management Tool
Provided data web-scraped from financial website FINVIZ to monitor thousands of stocks for specific criteria. This was turned into a report run nightly and automatically emailed to a portfolio manager.
Python, Scrapy, Excel, Amazon Web Services were the main tools used to extract and present the data for the project.
Cohort Analyzer
Created a cohort analysis report to understand the purchasing activities of customers and automate this process, Stored this information on google Cloud database. Was able to show where time and money were being wasted and this cohort analysis was used to make a difference right away.
Python , Excel , MySql-Workbench were the main tools used to extract and present the data for the project.