Statistics Intern Resume
Alameda, CA
SKILLS & ABILITIES:
Statistical Analysis: A/B Testing, ANOVA, Linear Regression, Logistic Regression, Survival Analysis
Machine Learning Models: Decision Trees, Neural Networks, Support Vector Machines and K - Means Clustering
Programming Languages: R, SAS, Python, Java, JavaScript and Visual Basic
Data Visualization Tools: Tableau, Power BI, Plotly, R, SAS and Microsoft Excel
Relational Database Management Systems: Oracle, MySQL and Microsoft SQL Server
Data Warehousing: Ralph Kimball dimensional modeling
Big Data: Hadoop, HDFS, MapReduce, Pig, Hive and HBase Version-control of programs using Git with GitHub and GitLab
Microsoft Office: Microsoft Word, Excel, Outlook, PowerPoint, SharePoint, Lync, Publisher and Access
Microsoft Excel: Vlookup, macros, functions using Visual Basic, pivot tables, pivot charts and statistical analysis
Enterprise Resource Planning Software: Oracle and SAP
Writing: AP, APA, Turabian, CMS and MLA style
WORK EXPERIENCE
Confidential, Alameda, CA
Statistics Intern
Responsibilities:
- Worked closely with the statistics team to automate repetitive SAS processes.
- Built the global and local SAS macro library for the statistics team.
- Created, edited, tested and debugged SAS macros.
- Wrote documentation detailing description, purpose, parameter definitions, execution requirements and expected output for each macro.
- Version-controlled SAS macro programs using Git with GitLab.
Confidential, San Francisco, CA
Economic Policy Intern
Responsibilities:
- Created complex structured datasets from raw unstructured datasets.
- Data wrangling, cleaning, validating and analyzing using R.
- Created raw unstructured datasets from GIS raster and shape files.
- Resampling, spatial joining and calculating zonal statistics using ArcGIS.
- Graphically represented GIS raster and shapefiles with data visualizations.
- Performed test runs to ensure no defects in the columns, rows or values in the datasets.
- Maintained version-controlled and thoroughly documented R notebooks.
Confidential, Pleasanton, CA
Data Science Student Assistant
Responsibilities:
- Helped the predicative analytics and modeling team with the implementation of a new actuarial data mart through user acceptance testing.
- Performed UAT test runs on the claims payment aging by date of injury table.
- Debugged SQL source scripts and target scripts to verify data matching test case between two different database schemas for all claims.
- Used pass through queries in SAS to use proc compare to compare the SQL source script and target script tables.
- Solved all defects with exact match between the tables.
- Performed sanity checks in Microsoft SQL Developer to verify valid mathematical relationships between the facts in the claims payment aging table for all claims.
- Documented test runs of test cases with version-controlled SAS programs in HP Application Lifecycle Management for possible review by the internal audit team.
Confidential, Los Angeles, CA
Student Records Technician
Responsibilities:
- Processed undergraduate and graduate application materials for admissions review for national and international students.
- Sorted, filed, labeled, indexed and barcoded applications, transcripts, degrees, letters of recommendation, test scores, passports, correspondences, resumes, financial statements and statement of purposes.
- Troubleshooted application materials for potential mistakes in sorting, labeling, indexing and barcoding.
Confidential, Los Angeles, CA
Responsibilities:
- Read and scored student SAT essays by rubric.
- Completed 16 hours of holistic scoring training in scoring reading, writing and analysis.
Confidential, Los Angeles, CA
Accounting Specialist
Responsibilities:
- Accounted for payments, invoices, accounts receivable, and accounts payable using Quickbooks.
- Received payments for services from customers and paid bills to vendors.
- Completed monthly bank reconciliations to accounts.
- Created daily, monthly, and yearly sales reports on Microsoft Excel.
- Created sales receipts for items purchased by customers.
Confidential, Los Angeles, CA
Engagement Management Coordinator Support
Responsibilities:
- Provided accounting, analytical, administrative and informative support for the tax, audit, and advisory engagements of the firm using the company’s SAP enterprise resource planning software.
- Accounted for the payments, invoices, accounts receivable and accounts payable of the firm’s engagements.
- Financial analysis with the different financial data of engagements.
- Set up, approved, and closed out engagements for the engagement team.
- Served as an information reference for firm related accounting and risk management systems.