Tony Wu

-Designed and led a system integration process using Python, Informatica, and Google Cloud Platform, allowing client to ingest data from 70% of their member network -Built and maintained ETL pipelines using Informatica Intelligent Cloud Services to move data from CRM and ERP systems into Google BigQuery -Migrated legacy reporting processes from Excel and Access into BigQuery using Informatica, reducing processing time from 2 days to minutes -Regularly led client meetings for requirements gathering, training sessions, and business discovery

- Designed and delivered a solution to analyze the Net Promoter Score and gain insights to customer sentiment and actions across the software - Consulted teams across the business on best practices for metric collection and data compatibility - Developed and maintained dashboards in Tableau for teams to track performance and drive corporate strategy - Troubleshoot ETL failures in Tableau and worked with data owners to verify data integrity using SQL - Wrote queries to transform data in Snowflake and SQL Server to be usable in Tableau and self-serve reporting

· Developed a web-app using Flask, reducing data processing time from 1 business day to 10 minutes · Created dashboards and reports in NetSuite for executives to track sales performance and leads · Scrubbed and integrated existing customer base with metadata from third-party sources · Leveraged sales data and customer base to glean insights on emerging markets and sales patterns

- Cleansed existing database and improved data accuracy by 10% - Scrubbed and leverage data sources to complete and load client data - Managed multiple data integrity projects to meet compliance metrics - Performed data validation and generated ad hoc reports using pivot tables - Automated tasks in Excel using Python and VBA macros

- Developed a test plan for ticketing system upgrade - Collaborated with various staff to create a project timeline and identify key features for testing - Created documentation for system usage and future upgrade testing

- Resolved driver issues on employee computers through Device Manager and group policy scripts - Entrusted to format computers containing confidential information - Imaged machines through SCCM and updated user information through Active Directory - Assembled, inventoried, and deployed over 100 computers to upgrade existing computers

- Maintained all lab computers for performance and applied software updates - Diagnosed and repaired student laptops through knowledge and Windows Diagnostics tool

Minor in Computer Science and Informatics