Post Job Free

Resume

Sign in

Data Analysis, SQL, Python

Location:
Orem, UT
Posted:
November 14, 2020

Contact this candidate

Resume:

Li Ge (pronounced Lee Jee)

Orem, Utah

Email: adht5s@r.postjobfree.com LinkedIn: www.linkedin.com/in/lige2015

Summary of Qualifications

Excellent technical skills in system design and implementation, programming, data analysis, databases/SQL, SQL Server, Microsoft Office.

Strong study and research ability. Co-author of article, “Analysis of Virtual Enterprises’ Development Based on Dissipation Theory,” in the peer-reviewed American Journal of Engineering and Tech Research (Vol.11, No. 9, 2011).

Excellent organizational and time management capabilities. Skilled at leading group discussions.

Highly logical thinker. Self-motivated. Detail-oriented.

Good communication ability. Logical and insightful presentations in class and work.

Fluent in Mandarin Chinese (Native) and English.

Technical Skills

Programming Languages: Python, C, C++, Visual Basic, VBScript. Used Python to develop an automatic data analysis system. Used Visual Basic to develop a thesis and a software program, The Subsystem for Older Apartments’ Material Supply Management.

Databases: Excellent skills in JOINS, UNION, AGGREGATE FUNCTIONS, VIEW, WINDOWING FUNCTIONS to solve different kinds of database problems in SQL SERVER.

Visualization: Use of Tableau software to analyze data, including statistical analysis and generation of dashboards with clear report graphs. Designed a dashboard to show USU Students’ Academic Performance.

Analytics: Excellent skills in the design of ER Diagram, Data Flow Diagram for modeling. Skilled in using EXCEL to do data analysis.

Education

Master of Science in Management Information Systems May 2015

Jon M. Huntsman School of Business, Utah State University (USU), Logan, UT. GPA: 3.66

Bachelor of Science in Management Information Systems and International Finance Jun 2012

Tianjin University of Finance and Economics (TJUFE), Tianjin, P.R. China. GPA: 3.68

Work Experience

Design and Implementation Engineer, Caveon Test Security, American Fork, UT, USA. Feb 2017 – Present

•Data processing and analysis using Python and VBScript programming languages.

•Designed and implemented data processing in a distributed environment.

•Designed and implemented extensible and customizable data processing modules.

•Designed and implemented automated data recognition modules.

•Designed and implemented error reporting and correction modules.

•Communicated and cooperated with group members.

Data Forensics Analyst, Caveon Test Security, American Fork, UT, USA. Jan 2016 – Feb 2017

•Data formatting and data processing from various data formats using Python language.

•Formatted data processing outputs into Excel spreadsheets using VBScript language.

•Communicated and cooperated with group members.

Data Systems Analyst Internship, Digital Spectrum, Logan, UT, USA. Jun - Dec 2015

•Websites research and reports writing.

•Data extraction and data formatting from HTML files using C++ programming language.

•Communicated and cooperated with group members.

Administrative Clerk, Tianjin Huanyu Shiye Company, LTD, Tianjin, P.R. China. Jul 2012 - Jun 2013

•Created reports with the tool of SQL in VISUAL STUDIO and SQL SERVER.

•Created Pivot Tables and Pivot Charts to analyze data in EXCEL.

•Communicated and coordinated with different departments to solve issues.

Teaching Assistant, TJUFE Department of Finance, Tianjin, P.R. China. Sep - Dec 2009

•Assisted in teaching Financial Markets and Corporate Finance Practice.

•Led four-member team in evaluating homework of approximately 120 students.

•Selected to present research at 3rd China Enterprise Int’l Private Equity Forum in Tianjin.

•Wrote a paper that was published about the conference.

Research Experience and Publications

The Design and Implementation of Subsystem for Older Apartments’ Material Supply Sep 2011 - Jun 2012

Management, First Prize for Outstanding Undergraduate Thesis and Project, Department

of Management Information Systems, Tianjin University of Finance and Economics, Tianjin,

P.R. China.

•Researched the causes of inefficient Older Apartments Management with Ishikawa Diagram.

•Analyzed and designed subsystem with Data Flow Diagram and ER Diagram tools in

Visio and ERwin software.

•Implemented subsystem using SQL and Visual Basic programming languages.

•Created reports and graphs to show Older Apartments’ Operation Performance with

Crystal Reports and dotnetCharting.WinForms.dll.

•Presented research to professors and students; directed group members on research.

Balancing Work and Family, National Natural Science Foundation, Department of Nov 2011 - Jun 2012

Human Resource Management, Business School of Nankai University, Tianjin, P.R. China.

•Eight-month project analyzing data with SPSS to identify issues that affected work and

family balance.

•Designed databases and user interfaces, as part of project’s improvement system.

Research of Virtual Enterprises, Department of Management Information Systems, Oct 2010 - Jun 2012

Tianjin University of Finance and Economics, Tianjin, P.R. China.

•Independently studied computer modeling and simulation methods; analyzed how

to develop measures and solutions.

•Served as research assistant, creating surveys for some of the world’s top 500

enterprises; organized group discussions; established corresponding databases.

•Researched the boundary of virtual enterprises with K-means Arithmetic tool.

•Designed and built enterprise operation processes with UML.

Analysis of Virtual Enterprises’ Development Based on Dissipation Theory (Zunqi 2011

Yang, Li Ge, 2011).

•Published in peer-reviewed American Journal of Engineering and Technology

Research (Vol.11, No. 9, 2011), Paper ID: N0039 (Indexed by EI Compendex, ISTP).

•Invited as author to the 2nd Network Engineering and Computer Science International

Conference, Xi’an, P.R. China, Sept. 2011.

Awards and Honors

Scholarship in academic year 2014-2015, awarded by Jon M. Huntsman School of Business, USU.

Scholarship in academic year 2013-2014, awarded by Jon M. Huntsman School of Business, USU.

First Prize for Outstanding Undergraduate Thesis and Project, titled, “The Design and Implementation of Subsystem for Older Apartments’ Material Supply Management,” awarded by TJUFE, Jun 2012.

Outstanding University Student in the Department of Management Information Systems, awarded by the Department of Management Information Systems of TJUFE, 2008 – 2011.

National Honor Scholarship, only two of which are awarded each year at each university by the Ministry of Education of China, Oct 2010.

Third Prize Scholarship in academic year 2010-2011, awarded by TJUFE.

Second Prize Scholarship in academic year 2009-2010, awarded by TJUFE.

Third Prize Scholarship in academic year 2008-2009, awarded by TJUFE.

Passed the National Computer Ranking Examination on “C Programming Language in Grade Two,” awarded by the Ministry of Education of China, Sept. 2009.



Contact this candidate