Lloyd Marsden Email & Phone Number

Toronto, ON, CA

New York, United States

Toronto, Canada Area

• Built and maintain a Deal Tracker that spans multiple media channels using over 20 data sources, then using the insights to inform VP’s and Directors when and where to Pivot to increase Ad exposure whilst maximizing.
• Manage multiple Data Lake projects with external Research companies so internal stakeholders have the most up to date competitor information at their fingertips
• Manage and Coach Analysts to create insightful… Show more
• Manage and Coach Analysts to create insightful Dashboards by directing discussions on how to best structure and use the data to capture the most meaningful information.
• Adhoc data analysis looking at potential Partner deals using historical spend and industry trend information, then presenting my analysis to C-suite execs and discussing the conclusion. Show less

Toronto, Ontario, Canada

• Analyzing operational processes and improving inefficiencies by creating automation scripts, ETL's and Data Visualizations.
• Managed the full project life cycle of Client Budget Control Reports(Project Scope, Wire Frames, Data Cleansing, Logic and ETL creation, Data Visualization creation and Presenting) saving countless hours of manual work.
• Recommend research and analytical tools to be used companywide based on rigorous assessments.
• Automation of data gathering… Show more
• Automation of data gathering from VP client spend projections, including Data Visualizations to Analyze trends and display patterns for Month over Month and Year over Year spend analysis.
• Analyzing investment data and providing exec team with potential opportunities and providing insights to make critical business decisions. Show less

Toronto, Ontario, Canada

• Created Client Dashboards after being briefed on KPI's.
• Established connections to API's and created complex scripts to extract data from various sources
• Combined multiple data sources with disparate data sets to meet project requirements
• Created project scopes based on client requirements, managed project manager and data analyst resources on multiple projects to efficiently complete projects well within time frames.

Toronto, Ontario, Canada

• Created exception reporting to standardize naming conventions across multiple data sources
• Built a dashboard that could be easily re-purposed for all clients in the company, displaying important metrics providing insights into actionable improvements.
• Created mapping tables used in all client reporting to provide granular in depth filtering
• DBA / Database management - including database creation, applying security, performance monitoring, asses job completions.

Toronto, Canada Area

• Managing media systems and improving functionality to meet constantly evolving industry requirements.
• Perform accurate costing exercises to for company presidents to present during client pitches.
• Super User and Subject Matter Expert on all Finance related modules for SAP and Media Systems.
• Working as part of a small team to consolidate advertising data from various systems into a single system to produce custom reports to help clients improve reaching their target… Show more
• Working as part of a small team to consolidate advertising data from various systems into a single system to produce custom reports to help clients improve reaching their target audience.
• The company was set a target for all departments to become 50% automated, after strategic measurement I have been able to apply system knowledge to help automate areas of the buying, planning and reporting processes..

Toronto, Canada Area

• Managing Budgets and Analyzing Revenue for over 30 clients for Initiative Canada which is Part of the IPG Mediabrands family.
• Develop and maintain a database containing revenue budgets and actuals for all clients and using this information to create monthly and Adhoc reports for the CFO and President of Mediabrands.
• Perform costing exercises to analyze the profitability of potential clients and quarterly for existing clients.
• Interacting with VP's and Client… Show more
• Interacting with VP's and Client Directors to create accurate budgets based on financial analysis trends and statistical information.
• Creating reports for monthly variance analysis and providing commentary to determine solutions on problem areas in the business. Show less

Toronto

• Reconciled supplier invoices with purchase orders for broadcast media advertisements.
• Ensured discrepancies were delivered to the appropriate employee and promptly corrected.
• Answered supplier queries regarding payments.
• Developed a standardized system to effectively increase profits via capture of available cash discounts.
• Assisted in the implementation of new ERP software including co-worker training

Blackpool, United Kingdom

• Supervised a team that designed and implemented a custom Financial and Reporting System
• Developed processes to identify system and control weaknesses and made sure improvements were implemented and reported to management in a timely manner.
• Developed strong relationships with both internal and external audit to ensure processes were embedded with minimal ongoing disruption to the business.
• Assisted with quality assurance to ensure a strong control… Show more
• Assisted with quality assurance to ensure a strong control environment
• Responsible for day to day problem solving, remote assistance and help to end users Show less