Data Analyst Accounting Assistant

JACKIE BACON

Fairfax, VA · 703-***-****

*****.******@*****.*** · linkedin.com/in/jackie-bacon-708b1886 SQL • Python • AWS • Snowflake •. Gitlab • Pendo • Metabase • Chartio • JIRA • Office Suite • Spark • Hive EXPERIENCE

OCTOBER 2017 – MARCH 2020

DATA ANALYST, REMINE INC.

• Generated python scripts to extract, transform, and load data from Postgres and MySQL databases, CSV files, s3 buckets, and APIs into the reporting Postgres database or Snowflake warehouse

• Generated complex SQL queries to extract data for ad hoc data exports and dashboard visualizations in Metabase and Chartio

• Managed the reporting pipeline using Gitlab and Visual Studio Code to push changes and review merge requests

• Used Datadog for logging and monitoring health of the reporting database

• Created, updated, and loaded tables, indexes, views, and materialized views for the reporting database

• Queried large datasets using Spark and Hive by spinning up EMR clusters

• Implemented user analytics tool, Pendo and BI tools, Chartio and Metabase

• Investigated support tickets and data bugs to improve data quality in the application

• Tagged features and pages in Pendo and created guides to update customers on new features and scheduled maintenance

• Collaborated with teams across the company including C-suite, sales, marketing, and engineering to meet ad hoc reporting and visualization requests for user and feature data across multiple platforms

• Performed project management duties for two data teams by maintaining JIRA boards, creating tickets, coordinating with managers for priorities, organizing sprints, and facilitating standups in an agile manner JULY 2017 – OCTOBER 2017

IT AUDIT ASSOCIATE, GRANT THORNTON

• Performed internal control quality assurance for the National Science Foundation (NSF)

• Tested the NSF Travel Systems to assess compliance with internal control standards

• Organized crosswalks, created risk control matrices, and tested workbooks using Excel

• Created supporting documentation using Nitro Pro and provided recommendations to improve the efficiency of NSF’s internal control processes

AUGUST 2015 – JUNE 2017

ACCOUNTING ASSISTANT, CALKAIN COMPANIES LLC

• Assisted the Accounts Payable and Accounts Receivable departments by paying bills and processing invoices in QuickBooks

• Created journal entries and performed monthly bank reconciliations for eight properties under the Asset Management department using Peak Property Management System

• Reconciled company credit cards using QuickBooks EDUCATION

MAY 2017

B.S. INFORMATION SYSTEMS AND OPERATIONS MANAGEMENT, GEORGE MASON UNIVERSITY B.S. ACCOUNTING, GEORGE MASON UNIVERSITY

Contact this candidate