Tony Chan Email and Phone Number

• Assess, capture, and translate complex business issues and solution requirements into structured technical tasks for the data modeling team, including rapid learning of industry standards and development of effective work stream plans. • Create logical and physical data models that reflecting business requirements, and optimally work with all data ingestion and data serving processes based on current and future use cases.• Collaborate with data engineers in the design, optimization, and extension full-stack data and business intelligence solutions spanning extraction, storage, transformation, and visualization layers.• Support build of big data environments that enable analytics solutions on a variety of big data platforms, including designs that are optimal for Power BI and Tableau.• Serve as the primary point of contact for question and escalations related to data architecture and solutions applicable to business problems or use cases.

• Led and coordinated with team in providing data analysis, reporting, support for Finance and Client Operations• Collaborated with client to customize and execute client annual subscription renewal process generating multimillion dollar revenue• Coordinated client exit transition in delivering data in the desired format following data privacy guideline, i.e., PII and credit card encryption

• Designed and Built Data Visualization Dashboard for financial billings, trends, and forecast for client CDN monthly usage activities• Built and Integrated CDN vendor to the existing AWS Data Pipeline and EMR from downloading logs into S3, and parsing data using HiveQL and RegEx to loading data to Redshift• Transformed daily Master Data pipeline in Talend from Redshift to BigQuery taking advantage of BigQuery performance capabilities (partitioned tables, optimized queries)• Manage and maintain daily reporting services that integrated data from numerous data sources (SQL databases, AWS Redshift, excel files) producing client data feeds, and billing information loads• Build and deliver timely adhoc and scheduled SOX compliant reports to internal (Finance, Marketing, Operations) and external clients through comprehensive understanding of the corporate data

• Developed logical and physical data models for common data lake containing company data elements (accounts, customers, products, services, etc.)• Led and managed US and offshore development teams to provide continuous web application development via agile methodology• Designed and implemented UI to provide contacts and accounts supporting sales and marketing following UX design concepts• Trained (Certified Usability Analyst) and Participated in company wide UX initiatives to improve business operations• Developed and Maintained APIs in Python to retrieve data stored in Neo4j • Built Azure Search Service Indexes and Integrated Azure Search Services API to retrieve contacts and accounts from Azure Blob Storage containing over 800,000 records• Developed Azure Function App to orchestrate and deliver contact lists to the individual salesperson

• Developed MDM business solutions based on the requirements across all business areas (adding and removing elements, syndication, ETL)• Worked closely with business to implement and maintain SAP MDM system repository supporting customers and products ensuring data quality and data governance• Technical Developer/Lead for regional production deployments related to SAP infrastructure implementations, upgrades, conversion and disaster recovery• Monitored data flows between user requests, source data (SFDC, SAP ECC, SAP BW, quote system, data warehouses, D&B) and MDM• Documented technical designs and procedures on department wiki to promote ease of information access and team collaboration • Coordinated monthly refresh tasks to support financial reporting

• Coordinated with SAP BASIS, Security, and Development Team to facilitate production rollout• Developed executive drillable reports on enterprise portal allowing c-level management for quick access to company financial performance• Designed and reviewed technical solutions with development team in response to business analytical reporting needs

• Integrated legacy data to SAP BW promoting the single centralized data source• Designed and built Star Schema DWH for companywide operations using SAP BW including reporting & analytics• Developed and managed a corporate worldwide billings data warehouse for delivering monthly financial reports• Architected and implemented data warehouse to reduce financial business processes from 3 weeks to 1 day• Developed internal websites to allow sales and finance team to manage customer information online• Full SDLC experience from monthly production support deployment to companywide high impact project delivery on enterprise-scale data warehouse projects in SAP BW and MS SQL Server