Data Analyst

Zachary Wright

EXECUTIVE SUMMARY

Web Data Analyst with 3+ years of experience working with large, complex data sets. Proven skills in SQL, Tableau, and Adobe Analytics working in web analytics and data operations. Extremely detail- oriented, result-driven, and always looking for and detecting patterns, whether to drive business insight or to detect data abnormalities.

EXPERIENCE

Kalibri Labs, LLC – Rockville, MD Nov 2014 – Present

Manager, Analytics & Data Operations – Hotel Revenue Management

• Architected the data model for the company’s entire multi-billion record data warehouse, used for all BI reporting.

• Oversaw the QA of all loaded client data by scripting complex business transformation logic in SQL.

• Audited raw data of Fortune 500 clients and identified data deformities that clients were unaware of.

• Managed all proprietary data transformation logic, drafting and standardizing business rules to form the foundation of the company’s benchmarking consulting business.

• Led the investigation of an industry-driven inquiry that analyzed the consequences of implementing more complex, but precise costing estimations associated with hotel bookings.

• Scripted the company’s most complex data pulls with SQL for internal business analysis.

• Wrote a data transformation application with Java to parse, clean, and transform all incoming transaction data.

• Constructed an internal web page in JavaScript using React/Redux framework within the existing application.

Capital One Financial – McLean, VA Jul 2013 – Oct 2014

Data Analyst – Digital Web Analytics, US Card Customer Management

• Aggregated Adobe Analytics data into robust database structures using SQL scripts for peers to use for quick analysis.

• Constructed interactive Tableau dashboards implementing visual analytics for tracking website performance.

• Implemented performance tracking for multivariate campaigns intended to drive customers to engage digitally, finding response curves by test cell.

• Spearheaded deep-dive inquiries in web analytics, segmenting digital behavior patterns by customer profiles.

• Executed multivariate campaign launches by creating segmented account populations to be put in test or control cells.

• Automated peer reports in Tableau, reducing redundant work and resulting in significant man-hour savings per week.

• Allocated operational costs of agent calls that originated from website or mobile app visits to support the prioritization of site redesign projects.

• Generated enterprise-wide reports on overall health of the portfolio’s digital engagement with Tableau.

EDUCATION

Cornell University, College of Engineering – Ithaca, NY 2009 - 2013

Bachelor of Science Major: Operations Research, Concentration in Financial Engineering

SKILLS SQL, Terradata, SQL Server, Tableau, Omniture, Java, Python, JavaScript React/Redux, Excel INTERESTS Triathlons, Stand-up Comedy, Theatre, Writing and Recording Music, Guitar, Traveling

Contact this candidate