Lingyan Zhou
**** ******** ***. #***, **** Valley
CA, 93063
B ac0w7i@r.postjobfree.com
lingyanzhou
Highlights
Personal Skills { Attention to detail { Quick learner { Problem solving Data Analyst Skills { Experienced in ETL jobs in Spring Batch and Pentaho Kettle.
{ Experienced in OLAP, OLTP schema design and performance optimization (MySQL and Orable).
{ Advanced Tableau
{ Intermediate Apache Spark
{ Functional knowledge in statistical languages like Scala, R Software
Development Skills
{ Agile development and bug tracking with JIRA.
{ Software documentation with Javadoc, Doxygen, Markdown, Latex.
{ Version control with SVN, Git.
{ Test driven development with JUnit, Mokito, Jenkins.
{ Maven, Gradle build-automation tool and common plug-ins
{ Container based applications development / deployment with Docker. Software Skills { Intermediate Spring framework,JSF, JPA (Hibernate), MyBatis, JAX-RS.
{ Intermediate CSS, Javascript, Bootstrap, D3JS,ReactJS, JQuery,HTML5 Education
M.S. in Computer Science, California Lutheran University, California. B.S. in Electronic Engineering, The Chinese University of Hong Kong, Hong Kong. Course Work
OLAP, OLTP design. Big data with Hadoop, Business analyticsïijŇ Agile developmentïijŇ Data mining techniques. Experience
February., 2016–
September., 2016
Intern, Westlake Financial Services, Los Angeles, USA.
{ Developed Python scripts and Java Spring Batch jobs to pre-process unstructured data, and generate summary reporting emails for their respective representatives for the impending annual audit.
{ Developed lender-status-tracking and representative-workload-distribution website. Specifically responsible for database schema and query optimization, back-end data ETL with Pentaho Kettle, and Spring Batch jobs.
Sept., 2014–
Nov., 2014
Intern, Sichuan Guanxiang Electronic, Chengdu, China.
{ Developed a 3D home design software prototype in C++ with two other developers
{ Implemented the 3D object manipulation modules and part of the UI
{ Implemented the Java JNI port for Android
July, 2014–
Sept., 2014
Intern, UEI program, Chengdu Meishi International School, Chengdu, China.
{ Migrated up a company website from Wordpress to Joomla
{ Implemented the database adaption layer in PHP
{ Maintained the website
June, 2012–
Aug., 2012
Intern, Chengdu Sino Microelectronics Technology Co. Ltd., Chengdu, China.
{ Translated some design specifications from English to Chinese
{ Wrote Verilog HDL testbenches on existing designs
{ Redesigned errorous modules
Honors & Awards
May, 2010–
July, 2010
Selected Student of Chong Chi College as a summer school student in University of California, Berkeley