Drew Harrison Email & Phone Number

Richmond, VA, US

Toronto, ON, CA

Washington, DC, US

• Increased the accuracy of credit reporting from 60% to 97% which improved compliance and reduced manual credit dispute resolution time by 33%
• Created a fully-automated call monitoring dashboard which saved 20 weekly hours of analyst time and increased the visibility of call center performance
• Founded and owned the Analytics Development Internship program which graduated two Operations associates into analytical roles
• Built the SurveyMonkey ETL using Fivetran and dbt which automated the delivery of Customer satisfaction (CSAT) survey analysis
• Developed Tableau reports displaying results from A:B testing for Collections and Recoveries strategies driving insights into the customer attributes of who is most is likely to pay
• Automated the Weekly Business Review with DBT, Python, and Databricks, and Tableau which reduced the time to completion from 10 hours weekly to 1

Seattle, WA, US

• Developed the means to track the velocity of Salesforce accounts and opportunities over time by utilizing snowflake streams. Doing so allowed the Demand team to dive deep into what was stalling opportunity progression
• Deployed MixPanel on Convoy.com to provide insights on the journey of website visitors highlighting the content and campaigns that perform the best.

Vancouver, BC, CA

* Managed the Bi-Weekly BI Team Sprint process* Developed and received recognition for a Tableau dashboard presented to Moz’ executive team which measured the success of a key business initiative. In the process, I defined the key performance indicators, forecasted the base case, and automated the data flow from raw data to provide actionable insights. *.

Vancouver, BC, CA

Developed a dashboard in R to monitor the success of a billing gateway migration.Developed the underyling SQL architecture and a dashboard to track the success of customer payments in TableauProvides analysis of the effectiveness of product featuresUses SQL and Tableau to monitor the company's payment success and to conduct ad hoc reporting on involuntary.

Seattle, WA, US

Owns the annual planning and forecast guidance processes for Shop with Points Programs and Credit portfolio

Irving, Texas, US

* Owned the financial analysis, monthly forecasting and annual planning for a $440M operating expense budget spread over 40 distribution centers* Integrated and consolidated reporting for an acquisition with over $160M in annual expenses* Improved visibility and reduced complexity of a biomedical repair business which will enable its growth

Irving, Texas, US

- Owned the annual financial planning for the company's private label medical supplies business- Provided sales and margin forecasting and month results to business management- Presented at monthly forecast reviews with the Medical-Surgical division's operating team- Conducted ad hoc financial analysis of data mined through the use of SQL and Business.

Glen Allen, VA, US

- Prepared the monthly forecast and tracked expenses to budget for America's first Barley to Ethanol plant- Tracked Commodity Prices and delivered a Weekly Risk Report to the Board of Directors- Prepared presentations for the Quarterly Business Reviews with the Board of Directors- Performed ad hoc financial analysis to determine the cash flow affects of.

- Reconciled Employee data to ensure the accuracy of many HR functions following the migration to a new data repository. - Streamlined the Semi-annual and Quarterly Bonus processes by designing a MS Excel-based consolidation tool to quickly consolidate data from multiple sources.- Automated several reporting functions across HR which will significantly.

Mclean, VA, US

• Member of the Finance Rotation Program with roles in Corporate Procurement, Credit Card Finance, and Internal Audit
• Assisted the business in achieving credit approval for product launch by managing the annual budget process for New Business Initiatives line of business with forecasted revenues of $150M
• Chosen to present the financial performance of the business unit at monthly business reviews with senior management
• Introduced several lean business processes to the US Card Acquisitions’ annual budget process which contributed to the completion of the budget process on time
• Significantly reduced the complexity of a monthly flash report which shortened the lead time from 6 days to 3 hours
• Realized nearly $2M in organizational savings/cost avoidance from managing ten sourcing engagements in areas as diverse as e-commerce and small business banking

Columbus, OH, US

• Managed the monthly bank reconciliation process for all of the restaurant chain’s bank accounts
• Managed the 2007 holiday gift card sales process and fulfilled over $200k in gift card orders
• Analyzed bonus targets and payouts for each restaurant
• Supported the Accounts Payable team on an as-need basis

Falls Church, VA, US

• Revamped the process for servicing international bank guarantees which significantly reduced the lead time with maintaining the contracts
• Uncovered several examples of incorrect billing which saved the company thousands of dollars
• Ensured that the business’s currency exchange exposure procedure complied with the corporate standard