Nick Maher, Developer in Pisa, Province of Pisa, Italy
Nick is available for hire
Hire Nick

Nick Maher

Verified Expert  in Engineering

Data Scientist and Developer

Location
Pisa, Province of Pisa, Italy
Toptal Member Since
February 11, 2022

Nick is a data science and analytics professional with over fifteen years of commercial experience across various industries and roles with a tech focus. He's developed dashboards, designed data warehouses, built apps, and has managed teams to do it all too.

Portfolio

Oracle
Oracle BI, Oracle, Microsoft SQL Server, Microsoft Excel, Python, Jira...
TVSquared
Python, R, PostgreSQL, MongoDB, Microsoft Excel, SQL, Pandas...
Jagex
Vertica, Hadoop, Apache Hive, Tableau, MongoDB, SQL, Python, Data Visualization...

Experience

Availability

Part-time

Preferred Environment

Windows, Python, PyCharm, SQL Server BI, MySQL, PostgreSQL, MongoDB, Tableau

The most amazing...

...project I've worked on was building out a data warehouse and all the reporting for a new online game entirely from scratch, including 3D models of the maps.

Work Experience

Business Intelligence Manager

2017 - 2022
Oracle
  • Led the front-end business intelligence team with five direct reports located across five different time zones and three continents.
  • Managed delivery of online (Oracle BI) and offline (Excel) reporting for the finance and the go-to-market teams.
  • Implemented a bespoke data mart for reporting. It improved query performance and reduced data latency from weeks to hours.
  • Delivered data science projects around forecasting future revenue and string-parsing for vertical industry classifications of digital audiences, reducing the need for human input in month-end close processes.
  • Re-designed the compensation calculation system to improve the timeliness of the submissions each quarter and reduce errors.
Technologies: Oracle BI, Oracle, Microsoft SQL Server, Microsoft Excel, Python, Jira, Confluence, Excel VBA, SQL Server Analysis Services (SSAS), Alteryx, SQL, MySQL, Data Visualization, Business Intelligence (BI), Excel Macros, Analytics, Data Engineering, ETL, Data Analytics, Data Modeling, Data Architecture, Data Reporting, Data Governance, Amazon Web Services (AWS), Query Optimization, Data Pipelines, Data Warehousing, Dashboards, Databases, SQL Stored Procedures, SQL Server BI, Dimensional Modeling, Apache Airflow, Data Analysis

Data Scientist | Freelance

2015 - 2016
TVSquared
  • Built a prototype machine learning model to provide recommendations for the placement of TV advertising spots.
  • Developed an econometric model to forecast response rates from TV advertising based on customer verticals, competitor spending, and search traffic.
  • Conducted analysis of the impact of advertising during the 2016 NFL Super Bowl and 2016 European Championships Final, which gained media coverage for the company.
Technologies: Python, R, PostgreSQL, MongoDB, Microsoft Excel, SQL, Pandas, Data Visualization, Business Intelligence (BI), Analytics, Data Analytics, Data Reporting, Amazon Web Services (AWS), Databases, Data Analysis, Data Science

Product Analyst

2013 - 2014
Jagex
  • Prepared and presented weekly KPI packs to the exec team, covering revenue, user metrics, and game balance.
  • Analyzed full user onboarding flow, from an initial website visit to account creation and tutorial completion.
  • Oversaw reporting through the beta launch of the game, selecting users to be invited, and tracking daily changes to metrics.
Technologies: Vertica, Hadoop, Apache Hive, Tableau, MongoDB, SQL, Python, Data Visualization, Business Intelligence (BI), Data Engineering, ETL, Data Analytics, Data Modeling, Data Architecture, Data Reporting, Data Governance, Analytics, Query Optimization, eCommerce, Data Pipelines, Data Warehousing, Microsoft Excel, Dashboards, Databases, SQL Stored Procedures, Dimensional Modeling, Data Analysis

Senior Analyst

2006 - 2012
Sumerian
  • Worked with a national bank on the rollout of new customer-facing systems to determine available day one capacity.
  • Scenario modeled customer Voice over IP (VoIP) systems based on suggested network topologies to determine total user constraints.
  • Analyzed batch processes of a major car leasing company to identify potential optimizations and ways to reduce overall processing time.
Technologies: Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL, Data Visualization, Business Intelligence (BI), Analytics, Data Engineering, ETL, Data Analytics, Data Modeling, Data Reporting, Data Pipelines, Microsoft Excel, Dashboards, Databases, SQL Stored Procedures, SQL Server BI, Dimensional Modeling, Data Analysis

Data Mart for Sales Data

Building a new data mart for sales and revenue reporting dashboards to replace the existing flat table structure. I built the original proof-of-concept, worked with the rest of the team to replace all the current tables, functions, and stored procedures, and updated the dashboards and OLAP cubes. Overall end-to-end processing time was taken down from over 30 hours to 90 minutes.

Tableau Dashboards for Startup

Building out a suite of dashboards in Tableau online for a startup just beginning to scale.

Previous reports had been done in Google Sheets for a single partner at a time, so I was brought in to build a set of reports that would cover the whole business. I worked with stakeholders throughout the company, from sales leads and account managers to product managers and up to the exec team.

The dashboards became a key part of the day-to-day running of the business.

Analysis of TV Ad Winners of Super Bowl 50

https://adtechdaily.com/2016/02/10/amazons-echo-made-most-impact-following-its-super-bowl-advert-says-tvsquared-infographic/
Analysis of the advertising spots shown during the Super Bowl 50 and their uplift on their search traffic for their respective brands.

I managed data collection for the project, ensuring we could scrape the data we needed within the mandated API rate limits and without any gaps in the data.

Languages

SQL, Python, Excel VBA, R

Tools

SQL Server BI, Tableau, Microsoft Excel, PyCharm, Jira, Confluence, Apache Airflow

Paradigms

Business Intelligence (BI), Dimensional Modeling, ETL, Data Science

Storage

Microsoft SQL Server, SQL Server Analysis Services (SSAS), Databases, SQL Stored Procedures, MySQL, PostgreSQL, SQL Server Integration Services (SSIS), Data Pipelines, MongoDB, Vertica, Apache Hive, SQL Server Reporting Services (SSRS), SQL Server Agent

Other

Analytics, Data Engineering, Data Analytics, Data Modeling, Data Architecture, Data Reporting, Data Warehousing, Dashboards, Data Analysis, Data Visualization, Query Optimization, Oracle BI, Google Trends, Excel Macros, Data Governance, eCommerce

Libraries/APIs

Pandas

Platforms

Windows, Oracle, Alteryx, Amazon Web Services (AWS)

Frameworks

Hadoop

2005 - 2006

Master's Degree in Operational Research

University of Strathclyde - Glasgow, UK

2002 - 2005

Bachelor's Degree in Mathematics

University of Warwick - Warwickshire, UK

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