Sign in

Data Digital Marketing

Richardson, Texas, United States
January 19, 2018

Contact this candidate


Yi-Chen Jen



The University of Texas at Dallas May 2018

M.S., Business Analytics - Data Science and IT Tracks Fu Jen Catholic University Jun 2015

B.S., Textiles and Clothing Fashion Marketing GPA 3.6 TECHNICAL SKILLS & CERTIFICATIONS

Programming: SQL, Python, R, SAS

Analytical Tools: R, SAS, SPSS, Hadoop, Excel VBA, Excel Pivot Table, Excel Macro, STATA, Google Analytics Business Intelligence: SAP(including IDT/UDT/Web Intelligence/Crystal Reports/ERP), Tableau Others: Oracle, Linux, MS Office Suite, CA ERwin, MS Visio, Google Adwords Certifications: Certification of eCommerce, Certification of Google Analytics BUSINESS EXPERIENCES

DC International, USA Jun 2017 – Present

Business Analyst

• Managed product information and enhanced website performance and maintained website functionalities through Magento, SQL, ERP and Python

• Optimized revenues by 180%+ and cut costs by extracting data from databases and executing stored procedures and developing reports, auto-dashboards daily by SQL, Tableau and Excel

• Conducted and analyzed in-depth sales conversion analysis and web activities daily with SSIS, SQL, SSRS

• Designed UI, UX of website and built database tables, data flow logic from PIM system to front-end of AJAX framework for business preview tools

Ruentex Materials Co Ltd, Taiwan Sep 2015 – Jul 2016 Digital Marketing Analyst

• Raised 140%+ sales and 200%+ membership growth by analyzing sales and review data by R, SQL and Excel

• Increased 90% visibility of products and brand by accurately applying different marketing and business tactics to target market and potential market daily using Google Analytics and Google Adwords

• Monitored warehouse inventory and flow and maximize business objectives through ERP, IDT, Web Intelligence

Barclays Bank, Taiwan Jan 2015 – Aug 2015

Operation Analyst

• Processed 50+ trades of 4 main financial products and directly impacting business for 100+ clients weekly

• Reviewed $10M of daily transactions and evaluated the foreign currency deposits

• Predicted financial performances based on market trends and directed management strategies using SAS Barclays Bank, Taiwan Jul 2013 – Sep 2013

Business Analyst Intern

• Conducted 30+ trade statements and declared contracts of financial transactions to Central Bank of ROC daily

• Awarded as the most efficient and positive intern among 8 interns by the CEO, CFO and COO PROJECT EXPERIENCES

Airbnb Website Analysis & Design, Data Warehousing & Business Intelligence Jan 2017 – May 2017

Analyzed and deigned Airbnb using CA ERwin, MS Visio, SQL, SAP(UDT/IDT/Web Intelligence), Tableau Student Alcohol Consumption, Big Data Analytics Aug 2016 – Dec 2016

Collected and analyzed data through Hadoop, MS Excel, Crystal Reports

Contact this candidate