Patrick Wang Email & Phone Number

Seattle, Washington, United States

Seattle, Washington, United States

Seattle, Washington, United States

• Leveraged SQL within the Snowflake database to curate data for ad-hoc analyses and over 80 Tableau dashboards. These dashboards and analyses played an impactful role in shaping various company strategies, contributing to a year-over-year revenue increase of $2.2 million, and streamlining departmental reporting processes.• Executed and project-managed data requests from cross-functional teams including, Sales, Product, Legal, Finance, Loan Servicing, Accounting, Marketing, and Human Resources.• Implemented Tableau and data warehouse logic for automating reseller payouts, saving $50k annually, eliminating 40 hours/month of manual work for Accounting, and identifying inefficient partnerships for strategic termination.• Embedded SQL queries in Excel and connected them to the Snowflake database to streamline the process of servicing legal reports. Successfully passed state audit examinations allowing DigniFi to continue to operate in the licensed states.• Developed a Python SARIMA forecasting model that improved company sales accuracy prediction by 33% – the model now serves as the underlying engine powering the team’s goal-pacing metrics.• Created Tableau alert dashboards to help Account Managers and upper Sales management identify business opportunities.• Gathered requirements for Data Engineering to establish ETL data pipelines including InContact for call center reports and Salesforce Marketing Cloud for email campaigns. Produced dashboards to host the data allowing Leadership access to automated call center activity and customer Net Promoter Score reports.

• Extracted large data sets from Amazon’s data warehouse via SQL. Performed data wrangling and analysis with Python libraries and Excel. Identified $6.8 million in incorrect tax collections per month. Pivoted leadership strategies as a result • Led a project that deprecated the tax location code request process – saving 500+ hours of work across multiple teams including tax and launch teams in the US, Brazil, Mexico, and Canada• Utilized SQL Workbench to assist in creating test cases and extract information to identify regression testing gaps • Orchestrated rule file deployments between teams to support business requests and tax configurationsConfigured Excel rule files and Vertex logic to support tax collection in North America. One of my configurations collected $2.7 million for AWS products in Colorado monthly

Seattle, Washington

• Performed search keyword mining via tools such as Helium 10, MerchantWords, and Amazon Advertising• Identified inefficient campaigns by analyzing sales data via Amazon Advertising dashboards and Excel pivot table• Data Wrangling – formatted raw Amazon customer data to an executable format for Facebook Campaigns in R• Digital campaign creation• Keyword harvesting

Tokyo, Japan

• Created MFC record book, browser, & mail applications with C & C++• Setup virtual environments for server and client PC’s • Performed product installations and complex configurations

Master Of Science - Ms, Analytics

Bachelor'S Degree, Economics

Short Term Summer Language Program, Japanese