Sql Server Python Excel
Resume:
*** *.**** ******, **, NY *****
Wes (Li-Yang) Chen
********@*****.***
SUMMARY
* Experienced analyst with MS-SQL Server and Python programming language certifications.
* Data-driven decision mentality, strong analytical thinking.
* Proven success in visualizing analysis results and creating interactive reports.
CERTIFICATIONS
* SQL Server 2012 (MSCA 70-461) from Microsoft
(Create DB objects, Query/Modify data and Troubleshoot/Optimize)
* An Introduction to Interactive Programming in Python from Rice University on COURSERA
* Principles of Computing using Python from Rice University on COURSERA (Expected Aug 2014)
SKILLS
* Database: T-SQL DDL/DML/Table Expressions and Routines (Stored Procedures/UDFs/Triggers)
* Data Analysis and Visualizing: PowerPivot in Microsoft Excel (interactive reporting)
* Market Analysis and Trend Prediction: NPD PowerView, NPD DecisionKey, Gap Intelligence Reports
* Programming: Python, VBA in Microsoft Excel, VB.net, ASP.net
* Microsoft Office Suite: Word, Excel, PowerPoint, Project, Access, Visio
* CRM: SaleForce.com
WORK EXPERIENCE
Acer America Corporation, San Jose, CA. June 2012 – Mar 2014
Business Manager – Stationary Business Unit
* Influenced company strategic moves based on US retail market analyses results.
* Managed and released financial forecasting report and post-shipment financial analyses for US desktop market.
* Transferred transactional data to accounts performance analyses and product portfolio analyses.
* Presented and released above analyses results to executive management team.
* Managed, executed and improved revenue/margin outcomes for US regional and online retailers.
* Planned and budgeted advertisement funding for US regional and online retailers.
* Monitored advertisement funding spending and tracked the effectiveness with sales account managers.
* Collaborated with product management team and logistic team to ensure on-time customer delivery.
* Allocated products to customers when inventory is insufficient.
Gracenote, Emeryville, CA. January 2012 - April 2012
Intern – Department of Professional Services
* Revamped customer engagement processes for music integration products.
* Built Excel/VBA macros to automatically illustrate SalesForce.com reports.
* Renewed the structure and content of Professional Service Wiki pages.
Acer Inc., Taipei, Taiwan. September 2009 - March 2011
Product Manager – Display Business Unit
* Re-negotiated and reduced Bill of Material costs by 6% to 9% on a number of products.
* Built competitive analysis data to help define and create new brand/product strategies after Acer’s brand acquisitions in US and Europe.
* Used Product Life Cycle Management (iterative, Agile-like) methodology to introduce 12 new products to the market and met initial launch date.
* Led a cross-functional team of Research& Development, Industrial Design, Mechanical Design and
Quality Assurance to build Product Requirements Documents for new projects.
* Coordinated and managed different opinions from stakeholders.
* Managed panel venders’ production plans and allocated ODM partners’ resources to optimize qualification schedules.
* Managed critical field issues and resolved 90% of the issues within 2 weeks.
Yahoo! Taiwan, Taipei, Taiwan. July 2008 - September 2008
Intern – Department of Search, Community and Communication
* Designed an online system with a team of seven people for Yahoo! Taiwan users to schedule and plan events with other users. This community service was introduced in Taiwan in November 2008.
* Analyzed business revenue models and use cases to revamp and enhance social network services of Yahoo! Taiwan.
* Managed and edited Yahoo! Life Plus content – Yahoo! Life Plus is a Yelp-like service that allows users to share, recommend and rate activities, restaurants or scenic spots.
AWARDS
* iF Product Design Award for 2011 (Product: Gateway FHD2303L)
* Good Design Award 2011, Japan (Product: Gateway FHD2303L)
EDUCATION
UC Berkeley Extension:
Business Administration; Marketing, December 2011
National Taiwan University – Top Tier Business School
MBA (Information Management), June 2009, Taipei, Taiwan
Master’s Project – Online questionnaire website, using VB.Net, ASP.NET and MySQL
National Chengchi University – Top Tier Business School
BS (Management Information Systems), June 2005, Taipei, Taiwan
Senior Project – Online Hospitality and Property management system, using VB.NET, ASP.NET, SQL Server and Crystal Reports
LANGUAGES
Mandarin Chinese
English
Contact this candidate