Experience

Technicus

• United States
• Construction
• 1 - 100 Employee

• Lead Analyst

  • Apr 2020 - Present

  Working on a data migration project from legacy systems to Salesforce new global recruitment platform. Azure SQL server,Jira, Excel, Apex Data Loader. Key Responsibilities: • Work with the Business Analysts to understand and interrogate the data in source systems • Profile the data to determine the data issues for each country and agree remediation • Assist with defining the data cleansing approach and the cleansing of the data • Work with the ETL Developer to define the flows and ensure the framework handles data issues • Support the testing of the framework • Reconcile data from source to target • Participate in the wider programme data activities including data modelling • Assist with resolution of data issues post-migration using Data Loader to update Saleforce



PageGroup

• United Kingdom
• Staffing and Recruiting
• 700 & Above Employee

• Data Analyst

  • Jun 2019 - Apr 2020

  Working on a data migration project to Salesforce within the data work stream. Key Responsibilities: • Work with the Business Analysts to understand and interrogate the data in source systems • Profile the data to determine the data issues for each country and agree remediation • Assist with defining the data cleansing approach and the cleansing of the data • Work with the ETL Developer to define the flows and ensure the framework handles data issues • Support the testing of the framework • Reconcile data from source to target • Participate in the wider programme data activities including data modelling • Assist with resolution of data issues post-migration



AnalogFolk

• United Kingdom
• Advertising Services
• 1 - 100 Employee

• Senior Analyst

  • Mar 2018 - Jun 2019

  Supporting a leading household technology clients data strategy team to setup a CRM function using AWS that can help form an analytics function. Creating an attribute segmentation to help the CRM team target most appropriate customers using RedShift SQL. Analysing Clients customer journey using Google Analytics to help get a better understanding of campaign behaviour. Supporting a leading household technology clients data strategy team to setup a CRM function using AWS that can help form an analytics function. Creating an attribute segmentation to help the CRM team target most appropriate customers using RedShift SQL. Analysing Clients customer journey using Google Analytics to help get a better understanding of campaign behaviour.



National Trust

• United Kingdom
• Non-profit Organizations
• 700 & Above Employee

• Data Scientist Contract

  • Dec 2017 - Mar 2018

  Analysis of campaign data to help make data driven decisions for the marketing team. Main responsibilities involve data extraction, aggregation from the data warehouse using SQL. Creating reports and dashboards of all campaigns using Tableau. Analysis of campaign data to help make data driven decisions for the marketing team. Main responsibilities involve data extraction, aggregation from the data warehouse using SQL. Creating reports and dashboards of all campaigns using Tableau.



EYC

• Business Consulting and Services
• 1 - 100 Employee

• CRM Analyst

  • May 2013 - Nov 2017

  • Responsible for CRM data analysis, profiling and segment activity to increase understanding of the propensity of a customer responding to different treatments and messages. Conduct analysis to characterise the relationship between customer types and business problems • Responsible for CRM data analysis, profiling and segment activity to increase understanding of the propensity of a customer responding to different treatments and messages. Conduct analysis to characterise the relationship between customer types and business problems



Sky IQ, Customer Intelligence Services

• Insight Analyst Contract

  • Jan 2013 - May 2013

  The purpose of the role is to provide insight and reporting services to the Insight team. Main objectives are to provide analytical expertise using SQL with the aim of gaining insight into customer behaviour. Deliver accurate and insightful reports to a specified time schedule. The purpose of the role is to provide insight and reporting services to the Insight team. Main objectives are to provide analytical expertise using SQL with the aim of gaining insight into customer behaviour. Deliver accurate and insightful reports to a specified time schedule.



Tesco PLC

• Appliances, Electrical, and Electronics Manufacturing

• Analyst Contract

  • Oct 2012 - Dec 2012

  Providing insight and analysis within the Pricing and Promotions team. To increase the business understanding of competitor price and promotion over time using Teradata SQL and Excel. Providing insight and analysis within the Pricing and Promotions team. To increase the business understanding of competitor price and promotion over time using Teradata SQL and Excel.



British Gas

• United Kingdom
• Utilities
• 700 & Above Employee

• Campaign Manager Contract

  • Apr 2012 - Oct 2012

  Interpretation of campaign briefs received from the client, identifying any areas of the brief that require further clarification and/or approval • Ensure requirements for delivery are agreed with the client before any production work commences • Build and execute campaign selections or counts using SAS and SQL • Ensure all campaigns are completed accurately and within the agreed timeframe • Deliver data to the client upon completion of a campaign, • Run and manage all post-campaign reporting • Manage communications in respect of all client campaign work • Ensure support of activities of strategic customer accounts at all levels



Centrica (Contract)

• United States

• Product Owner (SCRUM Role)

  • Nov 2011 - Apr 2012

  As a Product Owner I work within the Agile process and I am the final authority for decisions regarding priority, business value, and functionality for all the work done by the Agile development team. • Presents selection of prioritized stories to team • Answering business/project domain questions • Reviewing business acceptance test scripts• Reviews IS test scripts• Provides leadership to the team, leads by example• Discourages changes during the sprint. • Encourages and complies with product backlog • Attend daily SCRUM meetings

• Data Analyst (Contract)

  • Nov 2010 - Oct 2011

  Providing insight and analysis for campaign selection to maximise response/conversion rate so that business targets are defined by Customer Development



Carphone Warehouse

• Computer and Network Security
• 1 - 100 Employee

• Senior Database Marketing Manager

  • Mar 2005 - Oct 2010

  •Designing, building, testing and implementing inbound and outbound SMS/MMS campaigns using Epiphany and providing campaign data in the appropriate format for deployment •Undertaking campaign and response analysis to improve revenue, campaign effectiveness and churn through the SAS tool •Managing and taking the lead on the deployment of campaigns based on business requirements to appropriate channels including mailing agencies, alerts and dialler •Management and development of the database team •Managing strategic projects such as the migration of third party data into CPW CRM system (network sourced data)



dunnhumby

• United Kingdom
• Advertising Services
• 700 & Above Employee

• Senior Analyst

  • Nov 1995 - Jan 2004

  •Planning out and delivering end to end the analysis and resolution of various Data Quality issues and Data Sets across the business •Performing detailed root cause analysis to determine the underlying reasons for any Data Quality issues and ascertain the impact this has on the processes or reporting •Performing data analysis and selection tasks to profile segments including using techniques to see patterns within the data, querying and profiling including extracting, cleansing and manipulating data using SAS software to help formulate the analysis going forward •Articulating and summarising any data quality issue’s, impact and underlying cause for senior management insight •Engaging with the business to obtain a detailed understanding of business issues, structures and issues