Dennis Mcdonald Email & Phone Number

United States

United States

Promoted to corporate headquarters, expanding existing role to support all other Advance Local properties. Perform system maintenance for home delivery routing, single copy trucking, and customer account transactions daily. Maintain automated processes, MS Access databases and field support. 100% remote.• Helped combine independent circulation databases from Syracuse, Michigan, Portland, and Alabama into 1 central database housed in New Jersey, bringing uniformity and simplifying work for customer service reps• Built Excel macro spreadsheets, replacing 2 Access databases for carrier supply orders and route substitutions, streamlining data entry, and maintaining accuracy by importing data for references.

Designed and implemented database and spreadsheet solutions to improve complex workflows. Automated daily tasks to bring efficiencies to office. Designed easy to read informative reports. Reorganized delivery areas using data-driven decision making. Performed system upgrades. Troubleshot computer software and hardware. Administered and sustained Oracle database tables and complex SQL queries used for front-end Access database applications. Served as mentor to colleagues. • Streamlined single copy reporting and accounting functions utilizing electronic tablets, managing newspaper delivery, reconciling unsold papers, and billing collections.• Reorganized delivery route areas using MapPoint and Google Maps, reducing number of store delivery runs 50% and improving home delivery runs.• Optimized workflows 70% by constructing Access database solutions to deliver output, modify SQL queries for reporting and data extraction, consolidate and streamline processes, consulting with other programmers, managers, and outside vendors• Provided useful information through data analysis to help management make good business decisions.• Created carrier performance tracking system, helping management assess vendor operations and make contract renewal decisions.• Replaced manual systems of daily reporting and accounting with automated systems, producing data and reports needed for newspaper distribution from dock to customer homes and single copy stores.• Devised and implemented and maintained web-based preprint ordering system using circulation projections to submit orders more accurately for advertisers, provide reports, and output data daily for packaging.