ZUXIAO SONG

***** **** ***., ********, ** *****, 646-***-****, actpzh@r.postjobfree.com

EDUCATION

New York University, New York, NY

Master of Science in Management and System (concentrate in Database technologies), May 2016

GPA: 3.90

Pace University, New York, NY

Bachelor of Business Administration in Marketing, May 2013

• President’s scholarship

SKILLS

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.

COURSE WORKS

Quantitative Models for Decision-Makers Data Mining and Data Warehousing

Project Management in the Information Age Information Technology & Data Analytics

System analyze and design

EXPERIENCE

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

Account Executive

•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

Marketing Specialist

•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.