Post Job Free

Resume

Sign in

Data Analyst Tableau

Location:
Foster City, CA
Posted:
February 24, 2021

Contact this candidate

Resume:

Sebastian Eccleshall

adkgpd@r.postjobfree.com 650-***-**** 429 Biscayne Ave, Foster City, CA 94404 LinkedIn

WORK EXPERIENCE

Data Analyst – Government Rebates Aug 2018 – Present

Gilead Sciences Foster City, CA

Coordinate with 15+ wholesalers/distributors & state Medicaid/ADAP agencies in the reconciliation process. Review, examine invoice and claims data, identifying and resolving possible disputes, saving $500k+ per dispute.

Develop reports and analysis to support metric tracking statistics. Develop and present utilization trends, invoice data and claims level details in Excel, Tableau and Powerpoint to management and relevant stakeholders.

Design and implement system fixes/enhancements using Model N, Alteryx resulting in department wide process adoption. Utilize Robotic Process Automation (RPA) UAT responsible for designing test cases, documentation, and evaluation, etc.

Data Analyst Aug 2017 – Aug 2018

Accenture for Google San Jose, CA

Supported 50 total employees across 5 departments by creating and maintaining product SKUs using Salesforce CRM, Oracle, and Google Proprietary Tools.

Executed due diligence on product lifecycle management internally and externally to troubleshoot issues, resulting in more efficient data quality, logistics pipelines, and 10% faster purchase to delivery timelines.

Cleaned and mined data using Excel, used reporting analytics with Tableau, fulfilled ad hoc requests to improve data pipeline, & automation for dashboards and reports, leading to reduced turnaround time per report by 50%.

Data Analyst Aug 2016 – Apr 2017

Philips Medical Systems Foster City, CA

Spent 90% of each day data mining, reporting analytics, data models, design, and segmentation using SQL, Python, and Excel manipulations (vlookup, pivot tables, etc).

Assisted in the creation and maintenance of master data files for critical hardware assets.

Forecasted using Tableau analytics for iterative exploration and investigation of past company performance, gaining insights to drive planning resulting in better business decisions.

Data Analyst Dec 2015 – Mar 2016

Merchant e-Solutions Redwood City, CA

Utilized SQL queries and Java to extract, manipulate, and organize large volumes of data for quality assurance and analysis.

Resolved financial engineering and accounting issues by collaborating with multiple teams, which increased revenue by 1 basis point per transaction over approximately 100K transactions per day.

Data Analyst Sept 2014 – Dec 2015

Ooma Inc. Palo Alto, CA

Analyzed call traffic using Excel and R for trend analysis, Bayesian analysis, and self-developed in-house metrics to identify possible business opportunities and targeted marketing campaigns resulting in 10+ new clients.

Validated methods/strategies for obtaining new customers, provided ad hoc analysis and presented findings at monthly staff-wide meetings.

TECHNICAL SKILLS

PROGRAMMING LANGUAGES: Java, C++, R, Python, SQL, Appscript

SOFTWARE: Microsoft Excel, Google Suite, Tableau, Model N, Alteryx, Oracle EBS, Salesforce/CRM, Netsuite

EDUCATION

California State University, East Bay – Jun 2014

Master of Science (MS), Statistics

University of California, Santa Barbara – Jun 2010

Bachelor of Science (BS), Major: Mathematics, Minor: Statistical Sciences



Contact this candidate