Anson Tyau

About Anson Tyau

MBA Alumni specializing in Advanced Data Science Projects and custom system builds. Anson plays in a the world of Forbes Buzz Words, building BUSINESS INTELLIGENCE systems, designing advanced MACHINE LEARNING Analytics platforms, Real-Time DASHBOARDS, and Fraud Prevention Solutions. Anson has a background in Finance, Accounting, and Business Analysis, blended with an advanced knowledge of SQL, MDX, C#, Java, Python, SSAS, SSRS, SSPS, Cognos, SAP, TABLEAU, HADOOP, Azure.NET, Intelligent OLAP development, database warehouse design, data architecture and Database Administration.Anson is a successful entrepreneur, and currently the owner of Healthcare Data Specialist, CS88, and the co-founder & Sr. Adviser for Wet Shaving Products. He is very active in the Phoenix Software/Big Data community, giving presentation on the SQL Stack, R, and Machine Learning when he gets the chance!• Expert in architecting solution for ETL and Data Analytics, tailored to our business partners needs• Adept at the creation of visual analytics using Power BI, ESRI, R, SSPS, SAS, & Tableau• Oracle, SQL Server, MySQL, and Netezza Database experience/including Administration and SQL Tuning• Proficient in SAS, Cognos, Crystal Reports, Alteryx, SSRS, SSAS and Tableau• Expert level knowledge of Oracle SQL, Microsoft SQL, & Netezza, functions, stored procedures, and complex queries• Expert knowledge of Excel macro creations, VB automation, reports and advanced Excel functions • Expert in Informatica, SSIS, Spoon and other ETL tools• Experienced with IBM MDM, & Watson Analytics Platform.

Experience

1. Sr Technical Product Owner

   PetSmart

   May 2016 — Present

   I currently support the Master Data Management, Customer Relationship Management, and Customer EDW Project\'s and System\'s.We managed the day-day task of four full time contractors, and are responsible for a broad spectrum of systems from on-premises EDW and cloud EDW, to API and Web-based systems-Online Customer Identity Access Management (CIAM)-Product Owner-IBM MDM - Platform Owner-IBM Unica - Platform Owner-SAS - Platform Owner-Oracle - DBA-Netezza - DBA-Azure SQL - DBA-Azure Spark - Developer-Azure Func(tion)- Developer.NET - Developer-Informatica - Developer-Mulesoft - Developer-TIBCO - Developer-Red Hat Linux - Administrator

Education

• University of Phoenix

  Master of Business Administration (M.B.A.), Accounting and Finance

  2010 — 2012

• Hawaii Pacific University

  Bachelor of Science (BS), Pre-Medicine/Pre-Medical Studies

  2003 — 2006

Skills

• Data Modeling
• Visual C#
• Cash Flow
• Mdx
• Management Accounting
• Financial Statement Analysis
• Agile Project Management
• Capital Budgeting
• Ssrs
• Financial Modeling
• Salesforce.com Implementation
• Forensic Accounting
• Financial Analysis
• Erp
• Strategic Financial Planning
• Business Analysis
• Data Analysis
• Tableau
• Sap
• Sql
• Databases
• Data Mining
• Budgets
• Finance
• Tax Accounting
• Systems Analysis
• Business Process Improvement
• Ssis
• Sas
• Risk Management
• Financial Accounting
• Variance Analysis
• Project Management
• Olap
• Financial Forecasting
• Forecasting
• Managerial Finance
• Data Warehousing
• Relational Data Modeling
• Microsoft Sql Server