Charles Bernando Los Angeles, CA • 213-***-**** • acwsf7@r.postjobfree.com

Analyst

Ph.D. in physics with a background in data analysis, quantitative analysis, and statistical analysis

Top-performing graduate student developing coding language and algorithms to provide research, analysis, planning, case study, and performance measurement

Effective analyst, utilizing data mining, modeling, migration, regression analysis techniques to discover critical data

Expert MS Excel user with over 10 years of experience utilizing pivot tables, vlookup, macros, and power view

Education

Doctor of Philosophy, Physics, University of Southern California, Los Angeles, CA (2016)

Cumulative GPA 3.74, Provost’s PhD. Fellowship (2014)

Related coursework: Statistical Mechanics, Mathematical Finance

Bachelors of Science, Physics, University of Indonesia, Depok (2009)

Cumulative GPA: 3.69 (cum laude)

Technical Skills

Operating Systems: Windows, Mac OS X, UNIX, Linux

Software/Programming Languages: MS Office (Excel, VBA, Visio, Word, Outlook, PowerPoint, Access), LaTex, C++, MATLAB, MathCAD, R, SAS, SQL/MySQL, Origin, Adobe Illustrator, Tableau, HTML, XML

Data Analysis Projects

Utilized Monte Carlo simulations to build a sales forecast model and estimate the monthly profit using Excel

Developed a multiple linear regression model and variance analysis to forecast house prices using Excel

Explored the survival rate of Titanic passengers based on class and gender using Python

Designed relational databases utilizing one-to-one and one-to-many relationships in SQL and MS Access

Developed 20+ MATLAB codes to process and analyze 500+ X-ray scattering image data

Professional Experience

University of Southern California, Los Angeles, CA August 2012-Present

Data Analyst

Analyze and interpret trends or patterns in complex data to find relations between parameters using statistical packages such as MATLAB and SAS

Expert in querying, reporting and interpreting large data from spreadsheets and databases using Excel and SQL

Secured $200,000 funding from NSF by providing recommendations to advisors in writing research proposals

Led a team of 3 in developing statistical data analysis to collect 4000+ meaningful data from 100 TB+ large data sets under tight deadlines (good organizational, multi-tasking, time-management and project management skills)

Create charts, graphs, plots and dashboards for data reporting and visualization using Tableau

Gather/document weekly/monthly reports and present statistical analysis of experimental data in group meetings and 4 international conferences

Develop and maintain databases and perform data cleaning, extraction, processing, storage, and manipulation

University of Southern California, Los Angeles, CA August 2010-July 2012

Laboratory Assistant

Taught over 200 students in laboratories, analyzed their performance and their laboratory reports

Provided consultations for 100+ students/clients during office hours

PT Kandel, Tangerang, Indonesia January 2010-August 2010

Product Analyst

Proposed and designed 12 experimental modules and educational tools for students

Analyzed the cost, sizes and materials of the educational tools

Reduced the manufacturing cost by 20% and achieved business objectives by conducting quantitative analysis and providing data-driven insights and recommendations to supervisors

Contact this candidate