Data Analyst / Consultant

Charles Edward (Ed) Alley, Jr

**** ******** *****, ***** *******, Utah 84037 USA

(M) 801-***-****

**.*********@*****.***

http://www.linkedin.com/in/charles-ed-alley-85a9241

Sr Data Consultant

Brillio LLC San Ramon, CA

02/16/2021 - 05/04/2022

Remote in Utah - Office in San Jose CA at eBay, Inc.

First assignment with Global Legal Analytics providing ad-hoc Spark SQL solutions for requests from legal professionals in Europe and the USA. Converted Teradata SQL code to run on Hadoop Spark SQL clusters. Used inhouse data catalog application (ZETA) for documenting existing and newly created code. Second assignment with Data Services & Solutions supporting GMV2.0 project implementation.

Data Analyst

UnitedHealth Group R&D Minnetonka, MN

03/20/2018 - 11/06/2019

Remote in Utah - Office in Draper, Utah.

Supported Data Scientists, Research Directors, and collaborated with Data Analysts by sourcing and providing data sets using a variety of platforms, tools and EMR/EMH clinical data databases in Texas, Nevada, and Colorado.

Accessed claims, subscribers, providers, pharma, labs, Fitbit, CGM, and Medicare identified & unidentified data using:

GCP - Big Query (SQL) & Data Studio (BI).

AWS - Salesforce - SQL Server 2016 – PostgreSQL – T-SQL.

EMR/EMH systems, including CPT-procedures, ICD-diseases, NDC-drugs, HPCPS CPT-4.

GCP Data Studio to convert Power BI dashboards.

Projects:

Depression Analysis with Comorbidities using Salesforce.

Glucose Monitoring Surveys using MS Excel & Access to create input forms and capture patient responses.

Prostate Cancer Analysis using Medicare data.

Wellness Incentive Program-GMP Goals & Rewards- GCP Data Studio converting Power BI dashboards.

Collaborated with US and offshore colleagues.

Consultant

Populus Group LLC Detroit, MI

02/23/2016 - 12/31/2017

Remote in Utah - eBay Inc. San Jose CA

Primary assignment with Data Services & Solutions - Alation (data governance collaborative data catalog) data curator, report developer, trainer. PostgreSQL report development.

Secondary assignment - Create, maintain, and deliver customized Teradata SQL classes in US / Israel. Provide end user ad-hoc Teradata SQL-based data retrievals & reporting.

Manager Finance Analytics Training

eBay International AG Switzerland

10/01/2008 - 08/31/2015

Resident in Fribourg, CH – Office in Bern, CH

Expanded US-EMEA-APAC training and support activities for employees of eBay Inc, eBay Intl, PayPal, eBay Classifieds in IE UK ES FR NL LU DE CZ CH IT AT IL RU IN CN HK US. Averaged 350 internal students per year achieved a Training Net Promoter Score +89%.

Provided ad-hoc Teradata SQL-based data retrievals & MicroStrategy reporting for EU Legal (Litigation & Fraud Detection), EU Indirect Tax (VAT Discrepancies) & European Customer Billing (Bank Reconciliation) Teams.

Senior Business Analyst

eBay Inc San Jose, CA

10/25/2004 - 09/30/2008

End User Support & Training: redirected questions and issues to subject matter experts as necessary. Provided ad-hoc reporting for FP&A and other organizations. Created/maintained/delivered internal Teradata & MicroStrategy technical/business courses worldwide: in classrooms at office locations in UK ES FR DE CH IT AT HK AU US.Teradata SQL programming, MicroStrategy reporting, Business Objects reporting.

SUMMARY

Proven experience querying, designing, and developing data repositories.

Data and reporting curriculum author/collaborator, trainer.

Teradata SQL report developer, trainer.

MicroStrategy report developer, trainer.

Google Cloud Platform (GCP) Big Query dataset designer, report developer.

GCP Data Studio report developer.

Amazon Web Services (AWS) SQL Server dataset designer, report developer.

Salesforce dataset designer, report developer.

PostgreSQL report developer.

Hadoop familiarity and Spark SQL report development.

Alation data governance collaborative data catalog - data curator, report developer, trainer.

Manager and peer Recommendations at https://www.linkedin.com/in/charles-ed-alley-85a9241/

TRAINING

Developed, maintained, and delivered classroom technical-business courses for a variety of subject areas in a variety of foreign and domestic company offices & subsidiaries.

Technical-business SQL courses emphasizing ANSI standards, writing efficient simple & complex SQL queries, documenting, organizing code, and QA/QC of business query results.

INTERNATIONAL EXPERIENCE

Singapore – residence and workplace 15 months

Indonesia – residence and workplace four years

Switzerland – residence and workplace more than six years

VOLUNTEER SERVICE at NASA Ames Research Center, Mountain View, California

The JASON Project (JASON Foundation for Education)

NASA Education Events - Ames Research Center, Mountain View, CA

AWARDS

Eagle Scout - Boy Scouts of America

Outstanding Volunteer Service Award (four) - NASA Ames Research Center, Mountain View, CA

EDUCATION

Colorado State University – Pueblo (Southern Colorado State College / University of Southern Colorado)

Bachelor of Arts (Geomorphology/Geology)

Texas A&M University (Chemistry)

CITIZENSHIP

United States of America (Passport valid until April 2025)

Contact this candidate