Sign in

Tableau, Python, MS-SQL, Mysql, Ssrs, R, Microsoft Power Bi, Spss, Ccn

New York, New York, United States
August 28, 2017

Contact this candidate


Joseph .Y. Yang

*** **** **** ******, # * New York, NY, 10036 347-***-**** H1B Visa Holder EXPERIENCE

Pax Ventures LLC New York, NY

Business Data Analyst 3/2015- Present

Revenue Analysis:

• Create Ad Hoc Reports on Microsoft Power BI and SSRS by using SQL and aggregate data from various platforms, rPower, Amazon Web Service, and Restaurant365 in order to achieve timely, accurate and transparent reporting

• Utilize dynamic funnel models for omnichannel, locations, time interval, and products on Tableau and Excel VBA to isolate trend activities - 20 stores with over 50 million annual sales

• Analyze P&L (COGS) for Europa Café, Pax Wholesome Food, and Roast Kitchen to build benchmarks and review the performance of business units

Operation Analysis:

• Establish inventory and purchase forecasting project by using SQL and Python– combined the data between both inventory and item consumes in order to help the managers to enhance procurement efficiency –reduced 20% of weekly food cost

• Analyze the cost fluctuation of inventory items to maximize the profitability – over 140 recipes and 4,000 purchased items

• Compile and consolidate sales data from iOS Mobile App for Roast Kitchen to largely improve the efficiency of store operation

• Analyze daily payment status from PayPal to minimize financial risk System Analysis:

• Identify the systematic error and transaction data anomalies and solve these inaccuracies (~40,000 records)

• Guided and Implemented ChefTec and Restaurant365 in 6 months to support and optimize supply chain with over 30 vendors and 20 stores

• Cleaned the database on Power BI and ChefTec in 3 months and intergraded the database between Restaurant365 and QuickBooks MaxDelivery LLC New York, NY

eCommerce Assistant 11/2014-3/2015

• Built the pricing models for over 10,000 machine products in E-commerce B2C environment, competing with the Food Emporium and Fresh Direct

• Analyzed the sales models, customer behavior, and SEO by using Google Analytics, targeting the valued customer and reducing the spending on online advertising

• Collected the web-based information includes Item categories, products, and prices by using Python (Beautifulsoup) and HTML Taiwan Fixed Network Co., Ltd Taipei, Taiwan

Product Manager 8/2009-3/2011

Project management:

• Integrated Taiwan Mobile and Taiwan Fixed Network enterprise billing systems

• Relocation of Centralized Data Center; Guided more than 10,000 clients through changes; Coordinated 12 departments

• Performed financial analysis for Standard Chartered Bank Network Infrastructure Plan - US$ 3.5 million per year Product management:

• Managed Product for IP VPN, a product with US$ 15 million of sales, growing 2010 sales by 21%

• Monitored and analyzed product for IP VPN, Fiber-optic Line, ADSL VPN, and Frame Relay EDUCATION

New York University, Polytechnic School of Engineering New York, USA Master of Science, Executive Management Technology (GPA 3.3) 08/2014 National Chung Cheng University Chia-Yi, Taiwan

Master of Science, Information Management (GPA 3.9) 07/2008 National Kaohsiung First University of Science and Technology Kaohsiung, Taiwan Bachelor of Business Administration, Minor in Information Management (GPA 3.8) 06/2006 CERTIFICATES CERTIFICATE BUREAU DATE

BS7799/ISO 27001:2005 Lead Auditor BSI Management Systems 08/2007 SKILLS

Tableau, Python, MS-SQL, MySQL, SSRS, R, Microsoft Power BI, SPSS, CCNA, Amos, Azure, Google Analytics, Confusion Matrix, SharePoint, QuickBooks, C++, Excel VBA, Project Management

Contact this candidate