Canterbury, England, United Kingdom
A Senior Data Analyst for the past 5 years, predominantly in the Travel and Pharmaceutical industries, with an attention to detail and a passion for deriving business insights from data. I have been working with data and developing SQL code for over 18 years, for a number of global corporations in various analytical roles. 80% of my work normally falls into data prep - gathering requirements, extracting, understanding, cleaning, transforming data (ETL) and coding business rules. 20% is visualisation and analysis in various visualisation and dashboard software like Tableau, Python, PowerBI, and Excel. In more recent history I have taken an interest in AI / Deep Learning and coding in Python. I have worked with various Big Data technologies, to extract data needed for projects and set up automation pipelines to serve insights to end-users. I also have experience in e-commerce and internet marketing, specifically, A-B split testing, list segmentation, social media management and marketing to email lists. I enjoy working in teams and always looking for creative solutions to problems.
Responsible for developing, updating and maintaining the weekly usage reporting system for the company’s global hotel and air desktop booking platforms. Developed from the ground up using T-SQL, Python, Tableau, Excel and Power BI, a weekly reporting system that required its own ETL process that I developed in Python, to import data from a number of varied data warehouses, lake, repositories and flat files. Automated the cleaning, massaging and joining the data to be able to create the 45 Excel reports and Dashboards required each week, mostly for a Senior Director level and Business Stakeholder audience. Needed to code business rules and calculations to be able to produce the metrics requested. Offered advice and implemented ideas when business structures changed or reorganized. Often had to come up with ways to clean and map dirty data with no foreign keys and missing data, to the company’s legacy data warehouse. Would be required to create ADHOC reports and metrics for various groups to provide insights and aid in making business decisions. Performed in-depth investigations when issues arose. Would consult and gather requirements from stakeholders for requests to deliver new metrics, models and reports. Created video training to document the whole system so that it could be portable and supported by other staff. • Developed the weekly reporting process using SQL Server, SQL, Python, Power Pivot, Excel and Power BI. • Perform analysis in Tableau to aid business decisions and/or confirm or disprove hypothesis. • Would fully automate and produce numerous reporting and Excel models within the business. • Pull ADHOC data requests on demand from various sources like MongoDB, PostgreSQL, Mixpanel, Splunk, RDBMS, flat files. • Backup and maintain the environment. • ETL, Data Mapping and integration. Frequently would have to transform and standardize data. • Needed to be able to move and manage large data sets between repositories.
Was the technical resource on Expedia's Room Name Standardization project. Broadly speaking the project was a large ETL (Extract, Transform, Load) project. Working across three business verticals, the goal of the project was to use a set of standard attributes to describe all hotel room names, amenities, features, and views etc on Expedia's books. My task was to initially transform existing free text room names into standardised names according to business rules. From that data I had to automate generating custom Excel review files based on market territories. After the review I built reports to visualise the results of the review process and then automation routines to import, consolidate and validate all the changes in the Excel review files. I then exported the data into data files that could load the changes into production. Was on the team to successfully implement this project after 3 prior attempts. • Collaborated with various data custodians and teams to retrieve the data sets required for the project. • Imported, cleaned and standardised data sets from various sources. • Optimised queries and data model of staging database to improve performance. • Responsible for the data analysis of raw data and building and maintaining a SQL word parser to parse free form text into standardized room attributes. • Built C# CLR's to incorporate business rules. • Built C# console apps to create customised Excel review files from SQL databases. • Built SSIS packages to automate the consolidation of Excel review files and clean the data. • Built SSRS reports and various ad hoc stats reports using Tableau and Excel. • Responsible for providing management reports that tracks project performance metrics to key business stakeholder groups on a monthly basis. • Automated the building of Excel review files. Used VBA to incorporate business rules and created selectable room name attributes from a production database. • Self managed workload and mostly worked remotely.
Responsible for building the back end databases and marketing of eCommerce sites, using SQL Server and MySQL. Most recent project was an eCommerce site selling British groceries worldwide. • Built, supported and maintained the database backend of the site. This involved extracting, transforming and loading (ETL) worldwide shipping rates in various file formats from different couriers using MS SQL Server and Excel, then applying them to the 40,000 products we carried. • Analysing and reporting on product prices and fluctuations using Tableau. • Regularly scraping up-to-date product data, images, pricing and weights, then ‘massaging’ the data and loading into the backend database using SQL. • Monitoring the performance of the backend database and tuning where necessary. • Responsible for the analysis of web data and traffic. • Recommended web site improvement based on the user data and traffic. • Created scripts to validate user profiles and order data. Made ADHOC corrections where necessary. • Automating the data load process with a series of SQL scripts and an automation tool. • Managed out of stock items and removing from the product list. Eventually building a process to do this automatically. • Built and managed the Facebook FanPage, Blog, YouTube Channel and Twitter accounts. • Provided database support. • Created ad-hoc reports and wrote bespoke SQL scripts to access data. • Was responsible for the disaster recovery and hosting of the site, Blog and services. • Built a C# order management system that would pull the daily orders for the staff to pack. Although relatively basic, this app reduced mistakes and made the packing process more efficient. • Created end-2-end test scripts to test the site after releases and major database changes.
Working within the testing team for a large national retailer on the integration and national rollout of a new pharmacy back office system called Fred Office. Application was developed in Visual C# utilizing Dev Express forms, with a Microsoft SQL Server back end. Each of the company's 178 stores had a standalone instance installed. Application was custom integrated with the legacy system - Retalix Storeline. Data between the two systems was kept in sync through a web service. The new application gave the user live information and a more intuitive frontend for all their back office requirements yet head office could interface with the old system with a minimal amount of code changes and SOP changes. • Would be responsible for writing SQL scripts to prove data was in synchronization between the two integrated systems. Built a regression test suite in SQL to test each new release. • Responsible for installing and testing new releases of Storeline and Fred Office and diagnosing bugs with the system. Writing Test Cases and running through other team members Test Cases. • Developing procedures in MS SSIS to build solutions to complex data issues that could be loaded into the production Storeline DB. • After developing a procedure to correct a data issue, I would then roll this out to production and/or train a technical member of staff to deploy to production. • Data Analysis of stock check data from numerous stores. • Saved the company from litigation by correcting all of the franchised stores expensive manual stock checks that went wrong through use of the new software. • Heavily involved in diagnosing and fixing database data issues. • Although I was in a testing team I would have to deal with some 3rd level support issues due to my intimate knowledge of the application. • Training Helpdesk on supporting specific areas of application. • Would assist other departments with SQL queries, data analysis and issues upon request
Working on a $24M per annum project and responsible for the release, support and testing of assay analysis system, a J2EE app running on BEA Weblogic, Oracle 9i and Sun Solaris Servers, deployed to nine global standalone instances. Plus several other minor applications. Application was a very large complex compound drug analysis tool that would take information from assay instruments and robots, process the data, match up protocols and scientists data from various external databases, present the data in various graphing and analysis tools and publish findings to external data marts for future drug discovery. • Responsible for managing scheduling and deploying new versions of the application globally within 5 different time zones. Deployment comprised of Java apps, database changes and Unix configuration files. • Coordinated and managed technical teams throughout the release cycle. • Frequently liaise with business sponsors / stakeholders on aspects, timings and scheduling of the release. • Responsible for a global project support team of four people based in UK, USA, Canada and Japan and manage them as a resource. • Responsible for problem-solving and rapid diagnosis of any system configuration issues and data issues using SQL, and fix where possible or suggest solution. • Required to write System installation guides and add technical content to project SDLC documents like Project Plans, Project Initiation Documents (PID), Support Plans, Deployment Plans and Testing scripts. • Would build, configure and upgrade Dev, Test and UAT environments to run Integration (end 2 end), System and User Acceptance Testing. • Worked remotely for this role in both UK and Australia. • In addition to my usual duties I would identify problematic areas in our processes and work to document, automate or streamline them. For example :- o Used VB 2005, SQL, Excel and VBScript to assist in automating workflow and repetitive tasks. o Write call handling procedures for Helpdesk staff.