• Relevant Courses: Business Analysis with Structured Data, Business Statistics, Data Management & SQL, Python for Data Analysis, Computational Data Analytics with Python, Luxury Marketing, Behavioral Economics.
• Head of Learning & Development at Hult Consulting Club San Francisco. Shared significance of SQL and statistics in CRM consulting with colleagues.
• Accounting Report Automation SQL programming: Developed an SQL-based accounting report automation program as a school project, providing Income Statement, Balance Sheet, and Cash Flow Statement with yearly, quarterly, and monthly options.
• Stock Investment Simulator: Programed an SQL based stock portfolio simulator procedure that can perform investment report with selected period RoR, Risk, Correlation, Covariance, and Alternative stock performance.
• Air France Keyword Marketing Case: Analyzed Air France’s search engine keyword marketing campaign data using R, defined six most important KPI, such as CTR, CPC, PCR, CPP, ATV and Net Income, suggested four actionable to-be model strategies.
• Whole Foods Market Case: Designed structured RDBMS model through Whole Foods Market’s eCommerce system data crawling, then built a regression model to figure out “Do healthier food cost less?”, as a result, suggested three actionable insights from data analysis.
• Machine Learning: Implemented regression and classification model to predict factors which can impact on revenue and cross-selling success using scikit-learn ML library, resulting in generated source code which can automatically run ML model and compare result to select the best fitted model to report.
• IBM HR Case: Engineered MongoDB and Hadoop data pipeline to analyze IBM HR case, employee attrition case analysis, deployed Apache Spark on local server, created pipeline from Mongo DB to Hadoop using python, built predictive classification ML model via pyspark, at last, proposed five business insights to prevent employee attrition.
더보기