William Wu Email & Phone Number

Minneapolis, Minnesota, United States

• Generate after-action reports for 6 recurring client ad campaigns, providing highlights on performance to drive decisions• Update legacy reporting processes, scheduling SQL stored procedures and transitioning to visualization tools like PowerBI• Provide ongoing support for clients by creating adhoc reports and deep dive investigations to answer data questions• Identify and resolve data irregularities to verify statistical methodology and validate incremental revenue results

Minneapolis, Minnesota, United States

• Connect with 5-7 customers weekly to troubleshoot, and resolve escalated issues identified in their Anaplan models• Lead support processes for API and data integration pipelines between Google Big Query, PowerBI and Informatica• Recreate and test bugs in data visualization platform to reallow customers to seamlessly visualize their data• Liaised with Product Engineering teams to remedy platform bugs and update customers and support team on developments• Built dashboard and alerting system using Splunk and SQL that identified 4 security breaches in internal environments

Minneapolis, Minnesota, United States

Minneapolis, Minnesota, United States

(Formerly Revel Health)• Monitored, diagnosed, and repaired frequent incidents in daily ETL processes using SQL to identify problematic data• Developed a project with engineering to tune ETL processes in SQL procedures and reduce incident frequency to weekly• Collaborated with Client Experience teams to deliver ad hoc research and reporting with Redshift and Tableau• Spearheaded efforts to create and organize documentation for team duties and processes from scratch in Confluence

Minneapolis, Minnesota, United States

Greater Minneapolis-St. Paul Area

Client: Local Government Institution (Data Warehousing)• Coordinated tasks, planned sprints, and tracked project goals progress using JIRA as Scrum Master of a 10-person team• Communicated with clients to deliver a scalable NoSQL Neo4j Database product based on requirements and feedback • Collected data from numerous publicly available sources and defined relationships for ingestion into database• Presented analytical insights based on NoSQL database data to demonstrate new capabilities and inform policy decisionsAdditional Projects:Client: Leading Hospitality and Entertainment Business (Exploratory Analytics)• Performed clustering analysis on over 100 GB of customer data to drive headcounts and raise coupon redemption rate• Generated visualizations with PowerBI and recommended potential incentive structures based on identified insightsClient: Mall of America (Descriptive Analytics)• Cleaned, analyzed, and presented insights from client’s call data using Python and R to provide staffing recommendations • Visualized call data with respect to time and location in Tableau to create a dynamic activity heat map over the Mall area• Facilitated discussion of questions and concerns between team and case staff in addition to assuring deliverable quality

Richfield, Mn

• Delegated and managed Incident Response Ticket queue based on team member skill set and availability• Championed change management effort from ITSM system to Serivce now, communicating up-to-date changes from management to team during transition• Provisioned or deactivated 1000+ company user accounts for Skype, Lotus Notes, and UNIX Active Directory

Woodbury, Minnesota

Master Of Science - Ms, Business Analytics

Bachelor Of Science In Business, Management Information Systems

Minor in Business Analytics