Y. W.

Y. W. Email and Phone Number

Senior Data Analyst at Google (Contract) @ Google
Mountain View, CA
Y. W.'s Location
New York City Metropolitan Area, United States, United States
About Y. W.

• Over 18 years of Experiences in a broad range of industries like Healthcare, Pharmaceutical, Financial, IT, International trade, global supply chain, wholesale and online retail. • Good at developing and implementing efficient technical solutions for real business problems• Proficient in financial analysis, budgeting & forecasting, statistical Analysis and modeling • Years of management experiences within international business environments. Functional areas cover pricing Strategy, supply chain management, Cost control and vendor management. • Solid programming capability and data mining. Expert on VBA scripting, all Excel Formulas, Power Pivot, DAX and MDX. Familiar with Bloomberg terminal,• Advance knowledge of DBMS (Oracle, SQL Server, Teradata, Access). Hand knowledge on SQL queries, Shell scripting, Proficient at Unix, Windows, Linux command line • Fluent in English, Chinese, working knowledge of Japanese. • Chartered Financial Analyst (CFA) Level II Candidate

Y. W.'s Current Company Details
Google

Google

View
Senior Data Analyst at Google (Contract)
Mountain View, CA
Website:
google.com
Employees:
1
Company phone:
916.253.7820
Y. W. Work Experience Details
  • Google
    Data Analyst
    Google Sep 2021 - Present
    Mountain View, Ca, Us
    View
  • Santander Bank, N.A.
    Senior Data Analyst
    Santander Bank, N.A. Jul 2017 - Aug 2021
    Consolidating and Analyzing data through Various Databases and Data Warehouses, (Oracle and SQL Servers)Monitoring and improving data quality by designing and developing rules in Informatica IDQ Converting data into submission ready package for regulatory submissions such as CCAR , DFAST and IFRS9
  • Novartis
    Business Data Analyst
    Novartis Feb 2013 - Jun 2017
    Basel, Baselstadt, Ch
     Work as a contractor on IT Security and Risk Team. Extract and analyze data pulled from difference internal sources regarding IT securities and risks. Create reports and dashboards on risk findings Develop the template to allocate the Global IT security expense data based on latest corporate cost hierarchical structures. Helping budgeting draft and conduct cost variation analysis. Design and modify the financial planning and cost control models for various expenses  Create automated reporting templates under Microsoft Platforms (SQL Server, SSIS, SSAS, SSRS). Automate the ad-hoc reporting process with scripts queries and stored procedures, streamlining the data flow/aggregation/filtering among various departmental systems. Deploy periodical reports on SharePoint Server.
    View
  • Volt
    Manager Of Business Intelligence And Data Analytics
    Volt Jan 2012 - Dec 2012
    Buffalo, New York, Us
    led BI team using Microsoft platform: Windows Server + SQL Server 2008 + Sharepoint. extracted data from proprietary VMS Human Resource Management System. automated data cleansing process with VBA codes. developed and updated data warehouse with SSAS (MDX and DAX/ Power Pivots). designed 3 tiers Dashboard based on the dynamic data sets and flexible dimensional selections.Conducted HR cost and performance analysis with Minatab and SAS scripts, Collected client's requirements,designed and implemented the HR vendor Scorecard and performance Matrix using dynamic Functions and formulas.
    View
  • Bloomberg
    Financial Data Analyst
    Bloomberg Jun 2011 - Dec 2011
    New York, New York, Us
    Contractor Job that Analyzed current and historical financial statements of over 2000 companies listed on Tokyo Stock Exchange. Mined though Bloomberg Terminals by industries; automated data extraction and analysis processes with VBA macros and Excel functions such as : v-lookup, (vlookup) , OFFSET, IF/AND/OR/, MATCH, INDEX, INDRECT, MOD, etc
    View
  • Hic Corp
    Manager Of Internet Sales And Supply Chain Management
    Hic Corp Jun 2007 - May 2011
     Managed the sourcing, warehousing, packing/labeling, shipped and distributed books and audio media published in US to Asian market. Formulated and implemented internet sales strategies and purchasing plans, oversaw P/L and logistic cost control and inventory optimization of the internet Sales..  Co-operate local book store chains with their assortment plans. Operate and manage distributing and order fulfilling system. Implementing store inventory semi-real-time collaboration system.
  • E&E Co.
    Sourcing And Supply Chain Manager
    E&E Co. Apr 2004 - Jun 2007
     Import/wholesale of apparel and textile from Asia. Analyze sales patterns; develop buying plans, making and updating products/price/vendor matrix.  Set up intermodal shipping strategies. Work with warehouse, freight vendors and ocean/air carriers on leading time management and en-route inventory forecast and optimization. Oversee the progress and testing of in house-developed supply chaing management system to Monitor and optimize inventory level, shipping cost variations, and product margins.
  • Business Edge Solutions Ltd
    Software Engineer
    Business Edge Solutions Ltd Aug 2000 - May 2004
    Convert requirements from Financial/Insurance Clients into programming framework. Integrating business processes across departments using Object Oriented Programming language (Java) and relational Database such as Oracle, SQL Server
  • Marubeni Corporation
    Manager Of Textile/Chemical Division
    Marubeni Corporation Mar 1994 - Jun 1998
    Tokyo, Jp
    Lead a team of eight importinh chemical and textile material from US, Japan, Korea, Taiwan, Australia and New Zealand and sell to local textile and plastic companies.
    View
  • Bank Of China
    Analyst Of Foreign Exchange Credit
    Bank Of China Sep 1992 - Mar 1994
    Beijing, Cn
    Collect and analyze financial data, evaluate credit risks and monitor business performance of clients in Petro-chemical and Textile industries
    View

Y. W. Education Details

  • Naveen Jindal School Of Management, Ut Dallas
    Naveen Jindal School Of Management, Ut Dallas
    Information System
  • Shandong University
    Shandong University
    General

Frequently Asked Questions about Y. W.

What company does Y. W. work for?

Y. W. works for Google

What is Y. W.'s role at the current company?

Y. W.'s current role is Senior Data Analyst at Google (Contract).

What schools did Y. W. attend?

Y. W. attended Naveen Jindal School Of Management, Ut Dallas, Shandong University.

Who are Y. W.'s colleagues?

Y. W.'s colleagues are Kristen Dias, Veero Gaming, Dark Lord, Anshu Nishad, Chamikara Jayalath, Osama Dilshad, Kamini Lohani.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.