Matthew Guile Email & Phone Number

Cape Town, Western Cape, South Africa

•Optimised legacy data quality processes by converting Alteryx workflows to Python scripts, saving $10,000 annually in licensing fees.•Led a research project identifying customer pain points, directly informing budget allocations to address operational barriers to customer satisfaction.•Automated tasks involving SQL querying, data cleaning, and transfers via API endpoints, saving 20 hours of manual effort monthly.•Selected for an AI task team to prototype generative AI solutions to improve the identification of customer pain points and streamline internal processes.•Develop and maintain Power BI dashboards to monitor customer complaint trends and the workload of complaint handlers, providing upper management with insights informing capacity planning and staffing decisions.•Compile monthly recurring and ad-hoc reports from complaints, surveys, and social media, delivering insights to regulators for compliance and executives for decision-making.•Exploring AWS cloud solutions to automate data processes and build a scalable, efficient database infrastructure.

•Designed consumer insights reports, using quantitative and qualitative analyses of social media data to deliver actionable intelligence on consumer sentiment, campaign and influencer effectiveness, operational inefficiencies, and potential reputational risks, focusing on high-profile financial services clients, such as Standard Bank and Absa.•Collaborated with Account Managers to enhance monthly reports, increasing client value through enriched data insights, refined project scoping, and strategic recommendations for targeted operational improvements.

Cape Town, Western Cape, South Africa

•Drove a cross-team initiative to automate data visualisations for PowerPoint reporting, freeing up 20% of billable time, enabling more time to focus on generating impactful insights.•Led research into COVID-19 vaccine conversations on social media in the UK and USA, uncovering concerns around vaccine hesitancy driven by institutional distrust, with findings published on DataEQ's website.•Conducted R training workshops, enhancing the technical skills of the Analyst team and improving data analysis capabilities.

Cape Town Area, South Africa

• Promoted to Insights Analyst within a year due to exceptional performance. • Contributed supporting analysis for BrandsEye’s 2019 South African Banking Sentiment Index.• Prototyped new visualisations in R which feature on BrandsEye's analytics tool.

Cape Town, South Africa

• Utilised Content Management Systems to capture & manage data • Proofread & edited online content to ensure factual and grammatical accuracy

Honours

Bachelor'S Degree