Scott Armstrong

• Served as lead Analytics & Insights contact for multiple High profile clients such as GSK, Leonardo S.P.A, Bayer Pharmaceuticals and Hydro One.
• Lead a team of analysts to provide consistent quality reports and insights of varying metrics.
• Leveraged advanced Excel functions and macros to automate repetitive tasks, increasing overall productivity by 15%.
• Utilized data visualization tools such as Power BI to effectively communicate complex findings to non-technical stakeholders.
• Developed customized reports, summarizing and presenting data in visually appealing format.
• Work across marketing, brand, insights, and product leadership teams to help develop reports that deliver actionable insights.
• Responsible for understanding client needs to identify sales opportunities.
• Reviewed internal systems and organized training plans to address areas in need of improvement.
• Conducted extensive data validation to ensure the highest level of accuracy in all reports generated.
• Prepared monthly ad hoc reporting in alignment with client needs.
• Generated queries utilizing Power Query to create required reports. As well as using pivot tables to update AR aging reports on weekly basis.
• Optimized campaign performance by closely monitoring KPIs and adjusting strategies as needed.
• Conduct market research across categories to help guide client solution strategies.
• Supported the development of junior team members by sharing expertise in media analysis techniques and best practices.
• Managed multiple high-priority projects simultaneously while maintaining strict deadlines and delivering quality output.
• Maintained ongoing schedule and documentation for all reporting procedures.
• Collaborated with cross-functional teams to develop integrated marketing strategies for clients.

• Developed and delivered custom reports to some of the biggest enterprises and brands in the world including, Bayer Pharmaceuticals, Leonardo S.P.A, Scotiabank and Live Nation to address specific business needs and support decision-making processes.
• Worked with Cision Media (US, UK, CA) and Lead Analysts to provided actionable insights through detailed analysis of complex datasets and sentiment analysis, driving business improvements for clients.
• Enhanced data accuracy by implementing advanced reporting tools and techniques through Cision Media software (Similar to Power BI and Tableau).
• Delivered accurate, timely reports to clients by closely tracking thousands of media mentions and analyzing sentiment.
• Enhanced team collaboration by providing clear communication of complex findings through visualizations and reports.
• Streamlined internal processes by automating content extraction via RSS feeds and maintaining organized databases of relevant media information.
• Contributed to new business growth by providing insightful support during pitch presentations and client meetings.
• Developed strategic insights for clients by evaluating competitor performance and industry benchmarks.
• Gathered data from multiple sources to research economic indicators, analyze key metrics and track industry trends.
• Utilized social listening tools effectively to monitor online conversations about brands and their competitors.
• Managed multiple projects simultaneously, ensuring quality results delivered within budgetary constraints.
• Increased team productivity with effective project management, meeting deadlines consistently.
• Edited, proofread and fact-checked content for accuracy.
• Ensured data integrity by performing regular audits on reports, leading to increased trust in the information presented.
• Improved existing reporting by researching data sources, compiling data and designing output.

Completed 2 years of my degree and was unable to continue due to Covid-19 and financial constraints.

• A overall average, Oakhill, 2017- 3.0 GPA Conversion