Dan Garlington Email & Phone Number

United States

United States

Provide business and data analyst services including but not limited to SQL queries, Statistical analyses, Business problem definition. Modify existing and create new reports in excel, google sheets, & lookr, as well as deliver report creation processes. Research and recommend report and analysis standards and techniques.

Seattle, Washington, United States

Produce high quality, hand-made leather items to maintain stock to meet demand for brick-and-mortar shop and online store, and take on custom orders and unique design requests. Utilize Lightspeed and Microsoft Excel to evaluate production and sales data to help anticipate demand and determine appropriate back-stock levels for fastest-moving products. Manage Instagram account to highlight custom work.

Seattle, Washington, United States

Supported the Gayish podcast on air and off by researching topics for segments, fact checking during recording, managing social media posts & engaging listeners, booking guests, providing organizational & business strategies, designing merchandise, cross-promoting Have A Nice Gay podcast, chat room management during Livestreams, attending podcast conferences like Pride48, growing revenue to over $3K monthly by leading weekly Patreon segments and adjusting tier strategy, and acting as the resident kink & polyamory expert.Key software used: Audacity, Discord, Dropbox, Facebook, Google Docs, Instagram, MS Excel, MS Word, Patreon, Photoshop, Printful, Shopify, Trello, Twitter, Videoshop, Wikipedia, YouTube, Zencaster, Zoom

Greater Seattle Area

Provided business insights to company leadership to give visibility to changes in key measures of success at delighting customers, to highlight anomalies, successes, and problematic trends, and to aid decision-making. Majority of time was spent meeting with stakeholders to determine needs, writing SQL queries to create customized datasets, building Excel-based reports, and automating the flow of data and report generation to make intuitive data visualizations available on a regular cadence. Special projects included data mining to find interesting insights for marketing, data quality monitoring, various deep dives to explore trends or research viability/success of specific projects, creating Editorial content for Horror genre section to help secure advertisers, and creating new training courses for Excel and PostGreSQL.

Greater Seattle Area

Responsible for data management and business metrics development for tracking of performance for a variety of deals run on Amazon sites around the globe, as well as attributed sales associated with customers viewing event pages (e.g. Black Friday). Primary responsibilities are related to Oracle SQL (table creation and management, transforms, loads, extracts) and MS Excel, as well as working with the Amazon ETL management system.

Greater Seattle Area

Responsible for data collection, analysis, and presentation for a variety of supply and demand measures that are key to understanding and further developing the US Books business. Particular area of focus is supply chain/inventory management.

Greater Seattle Area

Identified and developed metrics to reveal business opportunities and quantify the impacts of those opportunities to Sr. Management. Developed automated and semi-automated reporting solutions for retail initiatives and workflows not otherwise supported by development teams, such as EDI integrations, Advanced Shipment Notice coverage, and supply chain defect reduction. Worked with stakeholders to collect and prioritize functional requirements and translate those needs for development efforts. Documented processes and systems, and created training via Word, Visio, Wikis, HTML and videos, and performed training sessions via phone, WebEx, and in person for hundreds of employees worldwide. Supported ad-hoc data collection and analysis needs at a moment’s notice. Managed department web site, to ensure usability and completeness, and to drive customers to the right information intuitively.

Greater Seattle Area

Developed reporting suite to track team performance to goals, turning focus on the right issues and driving significant productivity gains and defect reductions. Analyzed report data to isolate primary issues, research issues to determine root-cause, and follow-up directly with at-fault vendors to resolve shipment errors, EDI transmission problems, and product issues. Utilized by senior management to perform ad-hoc analyses and produce high-visibility reports.

Greater Seattle Area

Coordinated with buying teams and warehouses to collect, analyze, validate, and communicate inventory and product flow forecasts to all levels of the company. Developed and maintained Access & Oracle databases, as well as Excel reporting.

Greater Seattle Area

Managed data flow for returns of obsolete merchandise to vendors. Analyzed inventory to determine appropriate candidates for removal. Orchestrated product shipment, and maintained project records in Excel, Access and UNIX. Developed and maintained relationships with buying teams, organizing and leading weekly meetings to ensure goals were met.

Greater Seattle Area

Worked directly with small media vendors (including Advantage) to follow up and resolve issues related to orders, including late POs, misshipments, over shipments, and damaged goods. Coordinated returns to vendors of unwanted goods.

Collaborated with other researchers on selective breeding, mutant wasp stock establishment, wasp and host stock maintenance, dissections, microscopic embryonic analysis, classroom presentations, and other tasks related to research.