Drew Harrison's Email Addresses & Phone Numbers

📖 Summary

Senior Financial Analyst @ Amazon Owns the annual planning and forecast guidance processes for Shop with Points Programs and Credit portfolio From June 2014 to April 2015 (11 months) seattle, washingtonData Analytics Manager, Operations @ West Creek Seattle, WA, United StatesData Scientist, Marketing Analytics @ Convoy Inc • 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. From April 2019 to May 2020 (1 year 2 months) Greater Seattle AreaSenior Business Intelligence Engineer @ Moz * 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. * Delivered custom analysis on cross-sell opportunities to Moz' Executive Team which identified key opportunities for additional monetization* Involved in the evaluation and selection of third-party software which support Moz' data manipulation and visualization* Analyzed and presented to senior leadership on the impact of customer retention by a customer onboarding success program and received praise for its thoroughness* Completed the Dynamic Tag Management (DTM) for the launch of a new product* Used AWS Data Pipeline to automate daily customer relationship Extract/Transform/Load (ETL) process which resulted in over 8 hours daily of reduced processing time versus the prior MySQL stored procedure From October 2016 to April 2019 (2 years 7 months) Seattle, WashingtonBusiness Intelligence Analyst @ Moz 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 churn From April 2015 to October 2016 (1 year 7 months) Seattle, WashingtonSr. Financial Analyst, Operations @ McKesson * 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 From April 2013 to May 2014 (1 year 2 months) richmond, virginia areaFinancial Analyst, McKesson Brand @ McKesson - 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 Objects From June 2011 to April 2013 (1 year 11 months) Richmond, Virginia AreaAnalyst, Financial Planning & Analysis @ Osage Bio Energy - 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 potential business decisions- Supported Supplier Negotiation efforts for grain acquisition and a working capital facility- Developed the pro forma financial statements for Osage's pitch book From February 2011 to May 2011 (4 months) Contractor, Compensation Analysis @ SNL Financial - 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 reduced time to completion. From November 2010 to January 2011 (3 months) Sr. Financial Analyst @ Capital One • 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• Reduced risk in vendor selection by expanding the vendor financial due diligence process• Reviewed the business’ procedures to comply with Regulation Z (Card Act) and recommended procedural adjustments to ensure compliance From June 2008 to September 2010 (2 years 4 months) Accounting Intern @ Bravo Brio Restaurant Group • 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 From October 2007 to May 2008 (8 months) Project & International Finance Intern @ Northrop Grumman Corporation • 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 From June 2007 to August 2007 (3 months)