Ned Stratton Email & Phone Number

London Area, United Kingdom

London, England, United Kingdom

I work on projects for clients across the construction, logistics and energy sectors, and have built a tool in Powershell to automate the technical documentation of SQL databases and Power BI models in OneNote notebooks.

London, England, United Kingdom

Data analytics role within the marketing division of a global commodities events organiser and price reporting agency. I worked principally with the Python-based data blending tool Data360Analyze by Precisely to integrate sales, marketing, and customer usage log data from Salesforce, Marketo, APIs and legacy SQL systems into data lakes to answer business questions relating to lead pipeline, customer engagement and churn risk.

London, United Kingdom

Data Analyst for an eMoney services provider working in SQL, Python, Power BI, SSAS, SSIS, SSRS and Excel VBA. Responsibilities include:1. Automating and optimising client data extracts and management reports from the data warehouse.2. Improving existing warehouse stored procedures.3. Developing dynamic reports and dashboards in Power BI for financial reporting.4. Data analysis for internal stakeholders in marketing, business development and senior management.

London, United Kingdom

Areas of responsibility:1. Data segmentation and cleaning projects such as de-duplication, industry, job-function and geographic categorisation.2. Procurement of new data to fill gaps in the database and fulfil requirements of email marketing campaigns for products and events within the company.3.Working with suppliers to resolve any problems with the database application and commission software development projects to add greater value to users.Achievements:1. Reduced the duplication rate on the marketing database from 25% to 0.5%.2. Re-designed the upload procedure for new data records and developed a series of quality checks and VBA scripts to support this.3. Designed and implemented industry and job-function categorisation systems for the marketing database4. Increased the size of the prospect database by 23% from 1.1 million to 1.35 million contact records in a two-year timeframe, whilst also implementing stricter logic around the removal of inactive and stale data.5. Implemented a data warehouse solution in SQL Server to support analysis and reporting from the marketing data.

London, United Kingdom

My role was to provide support and training to Conservative Party agents, activists and campaign managers with their use of campaigning software and databases. I also tested replacement PCs issued to constituency offices for correct application installation and data quality, and implemented a daily test script to monitor the performance and accuracy of the new web-based elector records management software that was being rolled out for the 2015 General Election campaign.

Security Officer: I designed and implemented an Information Security Management System for Netsend.com, for which the company was awarded an ISO 27001 accreditation in June 2014. After the implementation phase I maintained the ISMS to keep it compliant with the ISO standard as well as unobtrusive and easy to follow. My role also included responsibility for testing new software and migration of client data to new servers, ensuring smooth rollout and secure change control.Migration manager: Netsend.com specialises in electronic invoicing and outsourced business processing, aiming to reduce overheads and improve credit control for clients through e-invoicing take-up. In this context, it was my secondary role to drive through the speedy, managed migration of our clients' customers from postal to electronic receipt of their business documents. I did this by designing and refining cover sheets on postal documents and organising telemarketing campaigns.

I managed the printing and posting department of Netsend's e-invoicing and financial document delivery service, which accounted for a third of the total number of documents processed by the company and averaged 150,000 printed documents per month. My mission was to ensure that posted documents produced by our in-house post room in London and our outsourced operations in Germany and the USA were dispatched in an accurate, timely and cost-effective manner. This involved supervising and motivating staff in house, maintaining close relationships with mailing providers and outsourced suppliers abroad, sourcing new material suppliers to acquire stock at the best price, and enforcing and improving procedures.

Capture, research and verification of sports statistics for a company supplying data to the betting industry.

I managed the in-house printing and posting department of Netsend's e-invoicing and financial document delivery service, ensuring the accurate, timely and cost-effective dispatch of 120,000 printed documents per month on average.

Lyon Area, France

Bachelor Of Arts (B.A.), French And Russian, 2.1

Activities and Societies: Sports Editor of The Sanctuary Student Newspaper 2007/8, completed the London marathon in April 2010, cycled.

Education record