Sign in

Sales Data Analyst

Lake Forest, California, United States
January 29, 2018

Contact this candidate


Robert Dorrigan


Lake Forest, CA


I'm a highly motivated, responsible, and self driven problem solver looking to expand my experience and apply my skills to new fields.


Quality Assurance, Data Analysis, Java, VBA, SQL, JavaScript, Task & Resource Management & Delegation


Data Analyst, Gear Coop LLC

Costa Mesa, CA March 2015 - Present

Data analysis and quality control on sales and inventory statistics for purchase and profit projections, automation of analysis and business management tasks, training and management of employees.


●Analysis and validation on annual sales and in-stock rates to determine purchase order quantities for ~ 25,000 products per month, accounting for backorders and lead time.

●Automatic upkeep of scheduling department tasks using Java within the Asana platform:

Quality assurance on existing tasks against a set of criteria, automatically correcting errors if possible and flagging task for manual intervention if not.

Creation of new tasks for the entire year, eliminating the need for a lengthy and error-prone manual process, while allowing for dynamic updates when necessary.

●Guaranteed data validation for purchase orders utilizing SQL to connect directly to NetSuite Suite Analytics via ODBC. Since January 2017.

●Automated the sales creation and submission processes, as well as data validation on sales statistics, using VBA in Excel.

●Automated report generation on a brand level for 200+ brands, as well as sending said reports via Gmail API on a brand specific schedule.

●Personally in charge of over five million dollars in purchases per year, as well as the training and management of five employees in the department.


UCSD, Online: Coursera

San Diego, CA October 2017 - Present

I am enrolled in a six course specialization, called Data Structures and Algorithms. Each course is six weeks. Four of the classes emphasize algorithms and the other are two are data structures and bioinformatics.

Certification ~ Fall 2018



●Data Structures

■Class: Algorithmic Toolbox - Certified November 2017.

■Class: Data Structures - enrolled as of November 2017

Contact this candidate