Joseph Harden, Data Architect and Solutions Developer in Dublin, Ireland
Joseph Harden

Data Architect and Solutions Developer in Dublin, Ireland

Member since April 7, 2021
Joseph is a senior data professional with 14 years of experience working in a range of data-focused and consultancy roles. He brings a broad range of technologies and languages to the table, particularly database and BI, Teradata, Oracle, SQL Server, DB2, Hive, Hadoop infrastructure, UNIX/Linux scripting, SAS, Python, and PowerShell. Joseph has assisted clients in the finance, eCommerce, retail, and compliance spaces.
Joseph is now available for hire

Portfolio

  • PTSB
    SQL, SAS, SAS Enterprise Guide, Teradata, Windows PowerShell, Python...
  • Groupon
    Teradata, SQL, Hadoop, Apache Hive, Unix Shell Scripting, Python...
  • AIB
    Teradata, SQL, NetReveal, Oracle, Unix Shell Scripting, Databases...

Experience

Location

Dublin, Ireland

Availability

Part-time

Preferred Environment

Teradata, SQL Server 2015, SAS, Hadoop, Python, Unix Shell Scripting, Windows PowerShell, SQL, Apache Hive, Excel 2010

The most amazing...

...product I have developed is a new data layer for use across a large organization supported by an automated batch.

Employment

  • Data Architect

    2018 - PRESENT
    PTSB
    • Designed a new data layer and ETL processes for a bank. Built new data models and prototype schemas based on multiple and various system and business requirements, using SAS, Teradata and PowerShell.
    • Assisted in deriving business logic from existing data and processes, and generated insights from the new data warehouse using reports and visualization tools (VIYA).
    • Delivered full end-to-end work, from requirement to development ad testing, as well as implemented audit controls, data lineage management, automation, and reconciliation over the new system.
    • Derived new datasets and complex processes to help build new dashboards, revolutionizing reporting and analytics capabilities for the company.
    • Mentored junior team members and delegated responsibilities to them, ensuring even spread of work and allowing me to focus on more complex/senior activities.
    Technologies: SQL, SAS, SAS Enterprise Guide, Teradata, Windows PowerShell, Python, Databases, Data Architecture, Microsoft Excel, Data Analysis, Power Shell Commands, Automation, SQL Performance, Performance Tuning, DataFrames, Business Analysis, IT Business Analysis, Testing
  • Data Engineer

    2018 - 2018
    Groupon
    • Collaborated with a team to design a GDPR solution encompassing all company data and methods of segregation accessed by multiple users to comply with forthcoming GDPR regulations.
    • Involved in the full lifecycle of project, including requirements gathering with stakeholders, design, development, testing, and implementation across multiple database (Teradata, Hive, SQL Server) and Hadoop environments.
    • Supported the evolving EDW dealing with and providing solutions to ongoing compliance and regulatory challenges, as well as maintenance, process improvements, and efficiencies using a wide range of technologies and environments.
    Technologies: Teradata, SQL, Hadoop, Apache Hive, Unix Shell Scripting, Python, Microsoft Excel, Databases, Data Engineering, Git, Unix, Data Analysis, Automation, SQL Performance, Performance Tuning, DataFrames, Business Analysis, IT Business Analysis, Testing
  • Data Consultant

    2015 - 2018
    AIB
    • Acted as a data consultant and lead analyst for an AML Netreveal upgrade project within AIB, a massive project within the bank requiring interaction with multiple teams and stakeholders in the bank.
    • Defined requirements with the business and analyzed AIB’s core systems to source pertinent data required for the AML system, working with disparate teams to understand and retrieve data from all areas in the bank.
    • Built ETL logic and process to pull data from multiple sources into the AML environment, and worked closely with the data team on implementing in production.
    • Liaised with business on requirements and requests, deriving insights, suggesting improvements, efficiencies, and synergies where applicable, and managing expectations on what was feasible.
    Technologies: Teradata, SQL, NetReveal, Oracle, Unix Shell Scripting, Databases, Microsoft Excel, Data Analysis, Data Architecture, Unix, SQL Performance, Performance Tuning, Business Analysis, IT Business Analysis, Testing
  • Data Analyst

    2014 - 2015
    Musgraves Ireland
    • Contracted with Musgraves to analyze customer loyalty data and provide insight on sales, trends and patterns, and revamped the reporting process using SQL and T-SQL.
    • Rebuilt CRM data warehouse, transforming and modeling data from different source systems to improve data relevancy and integrity, and implemented new processes to increase system efficiency, such as the creation of a new nightly batch process.
    • Assisted with CRM activities for the company, mining existing loyalty data to help identify customers to be targeted and analyzing the impact of campaigns.
    • Transformed underlying data into simple, readable daily/weekly/ad-hoc reports to different departments and senior management to assist in planning and decision making, while also automating several reports to increase productivity.
    Technologies: SQL Server 2015, Microsoft Excel, Databases, SQL, Data Analysis, Computer Science, Automation, SQL Performance, Performance Tuning, Testing
  • Solutions Developer

    2011 - 2013
    TD Bank Group
    • Assisted as part of the IMSS group that supported the shared service platform, with my particular focus on SAS and the data warehouse (AIX/UNIX, space, onboarding, etc.).
    • Guided in-house business users on analyzing and resolving technical issues such as complex SAS/DB2/SQL queries and process improvements. Implemented infrastructure and process enhancements to improve the shared service platform.
    • Managed the SAS environment, utilizing and supporting a range of different SAS applications including Base SAS, EG, DI Studio, marketing optimization, and management console, eventually becoming a SAS subject matter expert.
    Technologies: Teradata, SAS, SQL, Unix Shell Scripting, Databases, Microsoft Excel, Unix, AIX, SAS Enterprise Guide, Computer Science, Automation, SQL Performance, Testing

Experience

  • New Data Layer for Financial Institution

    I worked on a team as a data architect for a financial institution in Ireland (PTSB) developing a new enterprise data layer for the company. This was built over an existing data warehouse and multiple other disparate sources to pull all data required together and was intended to replace the existing siloed data marts and processes.

    As a part of this process, I helped design the new data layer and ETL processes and built new data models and prototype schemas based on multiple and various system and business requirements, using SAS, Teradata, and PowerShell. This involved working with different areas of the bank on requirements, deriving business logic from existing data and processes, and developing new processes, models, and dashboards for use by the different parties.

    Additionally, I created new insights from the data, writing complex queries to shape it and feed to visualizations. The project itself was a mix of agile and rapid prototyping. I had full end-to-end involvement, from requirements gathering to development and testing, as well as implementing audit controls, data lineage management, automation, and reconciliation over the new system.

  • GDPR Solution for eCommerce Company

    Built a process for an eCommerce company to ensure they met their GDPR regulatory obligations. The process required interaction with multiple systems and technologies, such as traditional RDBMS, Hadoop infrastructure, and file-based systems. The solution involved coding in Teradata SQL, Hive, UNIX scripting, and Python.

  • CRM System for Retailer

    Developed a SQL Server-based system to assist in customer relationship management for a retail company. The existing system was inefficient and ran on an ad-hoc basis. I created a new process and system that ran quicker and nightly, feeding reports and other outputs. This allowed for greater analysis on campaigns and customer analytics, as well automation of many processes that were previously ad-hoc and laborious.

Skills

  • Languages

    SQL, SAS, Python, Stored Procedure
  • Tools

    Microsoft Excel, Excel 2010, SAS Enterprise Guide, Excel 2007, Office 95, Git, Microsoft Power BI
  • Storage

    Teradata, Databases, SQL Performance, Apache Hive
  • Other

    Computer Science, Data Analysis, SQL Server 2015, Unix Shell Scripting, Data Engineering, Data Architecture, Performance Tuning, Business Analysis, IT Business Analysis, NetReveal, GDPR, Power Shell Commands, DataFrames
  • Frameworks

    Hadoop, Windows PowerShell
  • Paradigms

    OLAP, Automation, Testing
  • Platforms

    Oracle, AIX, Unix

Education

  • Bachelor's Degree in Computer Science
    2001 - 2005
    Trinity College - Dublin, Ireland

To view more profiles

Join Toptal
Share it with others