Data Analyst

William Joseph Horgan

*** ********* ******, *******, *** Jersey, 07030

201-***-****, *******.******.******@*****.***

Experience

GLG (Gerson Lehrman Group) June 2019- Present

Data Analyst

Using advanced SQL to create complex queries to extract data sets from Microsoft SQL Server

Helped create Marketing Attribution Model to determine Marketing Influenced Revenue

Creating B.I. dashboards in Looker for CMO and other members of GLG Leadership Team

Creating data visualizations using Python and Jupyter Notebook

Writing complex Excel Macros (VBA) to automate tasks

Using Salesforce to create advanced reports and dashboards Business Operations Analyst June 2018 – June 2019

Leading Global Lead Generation Efforts

In charge of creating and maintaining all Sales Dashboards in SalesForce

Tasked with uploading all new data and updating existing data in Salesforce

Writing complex SQL queries to pull and analyze data (Case, Partition By, Joins, Pivot, and CTEs)

Member of GLG’s data governance committee to maintain data integrity across all platforms Terrapinn Inc. February 2016-June 2018

Accounts Receivable Manager

Posting all journals to the General Ledger

Creating and maintaining all dashboards and reports in SaleForce

Preparing weekly cash flow statements

Writing all inter-company Journal Entries between US and UK offices

Writing monthly Depreciation and Foreign Exchange journals

Bank Reconciliations for Barclays and Citi accounts

Performing all incoming and outgoing Cash Entries

Posting all payroll and commission journals

Forecasting annual revenue

Issuing and posting all Sales Invoices in Salesforce

Extracting data using SQL queries

Young and Rubicam June 2015 - December 2015

Junior Business Manager

Education

Manhattan College School of Business

Finance and Business Analytics Double Major August 2011- May 2015

3.3 GPA

Dean’s List

2014-15 Student Government Vice President of Finance Skills

SQL

Looker

Proficiency in Microsoft Excel (VBA, Index Match, etc.)

SalesForce

Python

Agile Methodology

Contact this candidate