New York University, New York, NY
Master of Science in Management and System (concentrate in Database technologies), May 2016
Pace University, New York, NY
Bachelor of Business Administration in Marketing, May 2013
• President’s scholarship
Computer: Proficient in Microsoft Business Intelligence and analytics technologies suites, both on-premise and in the Microsoft Azure cloud, including Microsoft Power BI, Power BI desktop, Advanced Excel skills (Power Query, Power Pivot, Power View, Power Map, Vlookup, VBA), Microsoft SQL server, Reporting services and Analysis services, Microsoft Dynamics CRM, Office 365, MS Word, PowerPoint, Publisher, Project and Adobe Photoshop; Familiar with Adobe Illustrator and basic HTML, Google doc/excel/drive, Learning SQL, Oracle, Apex, Mule software, Mongo, PHP, Python.
Social Media: Experience with Facebook, LinkedIn, and Weibo.
Language: Fluent in Chinese and English.
Quantitative Models for Decision-Makers Data Mining and Data Warehousing
Project Management in the Information Age Information Technology & Data Analytics
System analyze and design
City Harvest, Inc., New York, NY Sep. 2014 – present
Business Operational Analysis Associate
•Developing traditional PowerPivot based Excel Pivot reports to analyze business operational data and share with various business units.
•Being responsible for regular scheduled report generation and ad-hoc reporting requests.
•Improving performance of the existing PowerPivot based reports by 10 times through rebuilding and upgrading from Excel PowerPivot embedded data model to SSAS Tabular services.
•Analyzing and developing new reports according to business requirements.
•Researching and developing multiplatform Cloud solutions by using Office 365 to transform some on-premise reports to Microsoft Power BI dashboards.
•Documenting clear operation instructions for reference uses
Jeffery Charles Inc., New York, NY Aug. 2013 – Aug. 2014
•Developing sales reports by using Excel PowerPivot weekly to analyze the KPI of each agencies in the office and compare to the other agencies across the country.
•Assisting manager to use territory management system to assign territories (5 boroughs in New York) for 30 agencies.
•Increasing the company’s revenues by door to door sales & client consumption from 40 to 60 doors per day.
•Increasing market share by 50%s and build up customer loyalty for our partners (Quill.com and T-Mobile).
•Being one of the top 3 salesperson in the country (25 applications per week).
•Interviewing and training new hires.
•Holding morning meeting (for sales report and motivation) and crew nights (for entertainment & team building).
Jeffery Charles, New York, NY Aug. 2012 – July. 2013
•Increasing vendor’s reordering rate by using Salesforce CRM.
•Increasing 500 followers on the social media by various promoting events and interaction.
•Making sales decisions and marketing strategy with head manager once a week with recorded visits and results.
•Increasing customer satisfaction by 40% by processing customer orders through company’s UFG Tools, responding to phone calls and emails, and following up with customer feedback through Zendesk.
•Assist IT manager to maintain and upgrade company’s database.
•Accelerating and ensuring delivering speed by contacting manufactures and delivery companies to track orders for customers and managers.