MBA in Information System & Business Statistics with six years of experience in IT and data analysis area. Strengths include Data
analysis, database management and analysis, business solution provider in data analysis and IT area, quick learner, coding language
skills, problem solving skills and mathematical and statistical modeling, great teamworker and outstanding communication ability.
Variety Data Analysis by R, SQL, Python and SAS etc, Database Administration,
Product & E-commerce Data Analysis, Multivariate Data Analysis, Time Series Analysis, Datamining and Machine Learning,
ETL, Data mapping, SQL Programming, Business Intelligence, Spreadsheet Modeling and Decision Making.
Data Analysis Tools: R Studio, RapidMiner, Advanced Excel, Tableau, Google Analytics, V-lookup, SAS, VBA, SPSS, Minitab.
Business Software Tools: SAP/ERP System, SAP/SD and FI/CO model, SAP Project Management, MS Office,
Coding & Database software: SQL, Python, C/C++, Java, MS Access.
Research Assistant12/2015 to 03/2017Hofstra UniversityHempstead
Manage and build up the database of all students in IS&BA department by using SQL.
Cleaning and analyzing raw data.
Perform ad-hoc analysis and develop reproducible analytical models in R, Excel and Rapidminer to meet requirements.
Apply machine learning and statistical techniques of large data sets to find actionable insights, using R and Rapidminer.
Data Analyst, Manager12/2013 to 07/2015Tianhong Consulting CoShanghai, China
Conduct data transformation, modeling and validation and data transforming activities.
Data gathering, research and
analytical abilities to develop insightful conclusions and generate solutions for measurement of key metrics by using R, Excel
Perform routine and ad-hoc data analysis, reconciliation and correction of data issues.
Develop visualizations in Excel, R, Tableau, Google Analytics and PowerPoint to illustrate historical and current performance
Performed daily data queries and prepared reports on weekly, monthly, and quarterly basis.
Collect and analyze online and offline industry data and competitor's data for improving marketing plan of our customers.
Report insights of performance in support of in-market tactic and program-level optimization.
Data Analyst, Assistant Manager12/2011 to 12/2013CitibankShanghai, China
Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s).
data from website and internal database, clean and transform the data and build integrated database in SQL or internal
system for business marketing and risk department.
Gathers, analyzes, and normalizes relevant information related to business processes, functions, and operations for
evaluating data credibility and determine relevance and meaning.
Design and build forecast model for automatic data analysis, using R, SQL and Python.
Provide reasonable forecasting for
many business figures, such as loan, deposit, future budgeting of business and other products by utilizing statistical analysis.
Conduct data quality control in all ETL procedures and provide ongoing maintaining and updating of data in database.
Gather reporting requirements for change requests and ad-hoc reports as requested for other teams.
Management Trainee & Data Analyst07/2009 to 12/2011Shanghai, China
Providing on-going analytical support utilizing data analysis and management modeling to address client experience,
behavior and issues regarding new e-bank platform.
Data Integrity by using SQL, then perform routine and ad-hoc statistical analysis to interpret insights on customer
experience and design the cross functional custom reporting solutions.
Conduct and manage the acquisition, cleaning, compiling and formatting process of large volumes of customers' data with
SQL, and statistical analysis, data visualizations and discovering valuable insights based on data by using R, Python, Tableau.
Conduct data mining and information analysis in internal system and SQL to screen and cluster customers according to their
financial and risk ratio situation, business scale, industry and etc, then design automatic model for banking products
suggestion and approval.
Work closely with trade and cash product manager, provide data analysis report of variety products.
Build forecasting model
for the sales amounts of products and complete the visualization for their presentation.
Education and Training
MBA: IS & BA05/2017Frank G. Zarb School of Business, Hofstra University Yanshan UniversityHempstead Qinhuangdao, NY, ChinaIS & BA 3.82/4.0 Dean's Merit Scholarship (STEM Major, Work Visa 36 Months OPT)
Bachelor of Electronic Engineering06/20093.5/4.0
Academic, ad, BA, banking, budgeting, Business Intelligence, business processes, C, C++, client, Data Analysis, data analysis and management, data mining, Database Administration, database, Database software, Decision Making, E-commerce, ERP, ETL, financial, forecasting, functional, Google Analytics, Java, Machine Learning, marketing plan, marketing, market, MS Access, Excel, MS Office, PowerPoint, Minitab, Modeling, optimization, product manager, Coding, Programming, Project Management, Python, quality control, reporting, research, sales, SAP, SAP/SD, SAS, Spreadsheet, SPSS, SQL, statistical analysis, Tableau, validation, VBA, website