Data Analyst

Andrew Yen Lin

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

Cell: 949-***-****

** ****** ***, ****** ** 92618

Professional Experience

Intuit – San Diego CA July 2015 - February 2016 Technical Database SAS Programmer

Worked closely with the email marketing managers to evaluate the customer target audience criteria and apply their understanding of both direct marketing best practices and Client's available data to recommend business needs.

Cleaned and performed data audits on permanent SAS data sets using SAS/BASE and SQL to ensure accuracy of the customer list generated.

Created and managed an automated a SAS program that converted and merged two different data sources to generate a daily list of customers who have their W-2 forms available.

In addition to creating documentation on SAS process and data pull instructions, identified and implemented process improvements that result in execution efficiencies, higher-impact segmentation strategies, stronger test plans and easier access to customer data.

Henry M. Jackson Foundation, Naval Health Research Center – San Diego CA July 2014 - April 2015

Data Manager

Created and managed monthly deployment reports with basic graphs using SAS/GRAPH and SAS/BASE.

Focused on defining source variables and helped consult data management team identifying key data quality issues by validating data sets, programming requirements and data dictionaries.

Transformed and cleaned healthcare data from outside sources to assist Senior Epidemiologists with their health research and help publish papers in the medical community.

Northrop Grumman, Defense Manpower Data Center – Seaside, CA November 2010 – July 2014

SAS Programmer and Analyst

Business Analyst

Served as the Point in Contact for Weekly Ad Hoc Data Requests by gathering data requirements and collaborating with clients to realize expectations and solve potential report irregularities.

Liaised with key military service point in contacts to create an annual fiscal year end snapshot report of the status of the medical manning for the DoD. Report is used as a reference document for responding to questions from the Congress, Office of the Secretary of Defense and the White House.

Data Analysis

Analyzed raw data to build custom data queries for clients helping them draw conclusions and develop recommendations for congressional level decisions using proc SQL for population pulls and SAS ODS to create tables in excel with custom layouts.

Well versed in using SAS procedures, merging data sets, SAS arrays and using SAS functions and formats.

Regular use of multimillion record level data bases with multilevel use requirements.

Leadership and Training

Motivated and deadline-oriented self-starter who takes on a leadership role in important projects with minimal supervision.

Experienced Toastmaster with strong and effective communication skills.

Technical Skills

SAS Tools: SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS.

Operating Systems: Windows/XP/7, DB2/TSO, VM, z/OS

Office Tools: Word, Excel, PowerPoint, Visio, Sharepoint, R

Education

University of California, Santa Barbara June 2008

B.S. Statistical Science with Actuarial Statistics Concentration

Membership: VP of Alumni Affairs Alpha Kappa Psi, UCSB Actuary Club

SAS Certified Base Programmer for SAS 9 December 2013

University of California, Irvine

Online Predictive Analytics Certification February 2016-Present

Contact this candidate