David Macpherson Email and Phone Number

With a passion for SAS and analytics, I’ve dedicated more than two decades to delivering programming and training solutions. My experience allows me to help organizations transform vast amounts of data into insights derived from in-depth data understanding to make informed decisions. My approach is client-centric, ensuring that solutions are tailored to meet specific objectives and resources. As a SAS instructor, I’ve had the privilege of empowering thousands of students with the skills they need to excel in data analysis. My teaching is driven by enthusiasm and a commitment to transforming complex concepts into practical, real-world applications.Known as the "Program Data Vector Director," I’ve developed a deep appreciation for SAS as a premier analytics tool. My work in 2024 has included Agile methodologies, where I’ve tested modifications, resolved design errors, including comprehensive documentation to ensure proper execution.Also, I have enhanced marketing campaigns with GPT content generation and editorial refinement.A Snapshot of Clients Helped:★ Sports Team: Organized and analyzed data to identify high-value customer demographics for targeted marketing.★ Pharmaceutical Client: Optimized the transition to the latest new software version, maximizing benefits and efficiency.★ Marketing Firm: Embedded ratio calculations to assess financial success and therefore improving decision-making and final results.★ Insurance Company: Developed a system that automated ETL processes, saving time and reducing costs.★ Finance Company: Enhanced report clarity by tailoring outputs to decision-makers’ preferences.Core Competencies:• ETL (Extract, Transform, Load)• SDLC (System Development Life Cycle)• Extensive Macro Development• Data Manipulation • Best Practices, Coding Standards, and OptimizationI regularly utilize SAS procedures such as PROC PRINT, PROC SORT, PROC SQL, PROC MEANS, PROC SUMMARY, PROC FREQ, PROC UNIVARIATE, PROC REPORT, PROC TABULATE, PROC TRANSPOSE, PROC FORMAT, and PROC COMPARE to deliver reliable, data-driven results. My experience spans multiple platforms, including SQL Server, DB2, Oracle, and Netezza.Previous Experience:In the telecommunications industry, I played a key role in financial applications development, release management, and final testing. Serving as the primary liaison between business managers and systems engineering, I ensured that system updates and programming fully satisfied business requirements.