● Majority of this role is very similar to the previous role with more responsibility.● Building up and training a team to concentrate on different roles within the BI Team, advanced insight in reporting, AD Hoc, integration and automation.

AWS - Redshift Spectrum, Athena, Quicksight, S3, Glue, Lambda Python 3.7CloudEvent, EC2, EC2 - Python 3.7, EC2 - Windows Services, Python Flask Dashboards, Datawarehouse ArchitectureIntegration Shopify API, Shopify GrapghQL, Netsuite API, Zendesk API, Google Analytics API● Using the Power of Amazon Web Services - Redshift, Athena (Presto SQL), Lambda, CloudWatch Events, Glue, EC2, API Gateway, S3 Buckets, SQS and SNS● Organised the full architecture of the Data Warehouse using the Redshift Spectrum, querying data directly from S3 saving time on ETL, saving cost and increasing productivity● Using Python to automate integration from many data sources, the main data sources are Shopify, NetSuite and Google Analytics ● working with complex JSON Structures● Using Pandas in Python to perform all ETL tasks that combine data from many data sources and insert into the Data Warehouse, combining EC2 and Lambda● Set up EC2 running windows server using the always up services to schedule any task as a service, Python and Node● Reading Athena to read sales product and customer to automate daily and hourly report to all ● Provide insight, reports to the entire business● Using Text Marketer to produce top level daily SMS to show yesterday's sales app vs web, new customers vs old customers, achieved margin and total returns. ● Build Trust with the CEO, Directors and CTO to change current business processes replacing old reporting methods, BI Tools and automation using API PUT and POST requests all using Python and SQL

• Used SSIS to create ETL package to manipulate and load data to a SQL Server Data Warehouse. Also working with tools and languages such as Python, PHP and Kingsway to find the most reliable tool/method to manipulate the data.• Created databases and schema objects including tables, indexes, stored procedures and functions as a part of the data migration initiative• Writing large SQL queries to aggregate data such as Invoiced Sales, Stock data, Company Order Intake, Call Data, and Zendesk Data• Tableau, Power BI – Created a map of 15 showrooms working with two floors to show heat indicators for circa 400 bays to identify the full customer journey through sales • Changed the whole stock take process in all showrooms from pen and paper to android applications using a java environment and a live feed from and to the Data Warehouse• Helped aide in the decision making to change the showroom opening times through data visualisations.• SSRS – Combined two call databases with Zendesk ticket data to allow the organisation to make faster and more accurate decisions based on agent productivity, time management and customer service advancements.• Creating adhoc reports across the business using Tableau to report on sales, stock and customer data i.e. traffic and phone • Built python applications converted to GUI for better data collection methods lowering the error rate significantly• Working with the finance department creating stored procedures providing live sales queries in excel to help aid in the P&L process• Created VBA (macros) in Excel to save CSV files and created jobs in the SQL Server Agent to import the data.

• Maintained an overall availability of 98.9% in Tesco throughout the year• Successfully organised the transition of all cosmetics stands• Managed Shipments for three categories Cosmetics, Haircare and Nailcare for all major selling brands these include Rimmel, Maybelline, L’Oreal, Max Factor, Collection 2000, Bourjois, Barbara Daly, Sally Hansen, Revlon and Sleek• Observe and identify trends using large amounts of data collated from various MI systems to ensure accuracy of sales and performance in all stores• Analytical support for over 800+ Stores analysing store sales, store stocks, shrinkage, ranged vs. un-ranged data, deliveries and discontinued stock• Yearly, weekly and daily Forecasting, taking into consideration in store promotion and range updates• Host weekly meetings with the order releasing team to review expectations and targets• Maintain a chain management system on a daily basis to ensure correct set up of store/item combinations• Communicate daily with the suppliers to ensure excellent service to stores• Investigating and solve store queries quickly• Run replenishments to maintain excellent availability in store, reacting to unpredictable sales• Manually created orders for new ranged lines

• KPI reporting with 50 separate target measurements structured from the Tesco steering wheel focused around customers, Community, operations, people and finance• Maintaining KPI Target’s for 50+ managers to a Red, Amber or Green ratio• Attend 2 yearly Meetings for 70+ Managers and complete a presentation based on Managers KPI’s and what good looks like• Control the supply of Mobile phone to 2000+ merchandisers • Reporting on major category’s Entertainment, Books, Cosmetics, Gift cards, Haircare, Nail care and Tesco bank• Creating detailed questions and apply these to a web based portal that feeds to 2000+ merchandisers• All this has been key success to have the ability to produce a successful steering wheel for managers KPI’s

Training and developing new starters on the voice pick systems using a strict process and then coaching them to perform at a satisfactory level to achieve targeted UPH. working on stock control and have gained excelent knowledge of oracle from stock investigations, location and system shortages, Bin Moves and missing stock

Leading, coaching and developing a team of 30 staff over 3 areas to ensure that targets were met on a daily basis and ensuring that the fulfilment of orders were met while developing new ideas to help make the areas run more efficient.

Running a small team in a fast paced environment and training the staff to the full potential with a full understanding of the machine, this enabled us to far exceed hourly targets and work well as a team.

Learning the basic operational skills working on the inducers/Sorter, A-frame sorter and voice pick this gave me the chance to improve as a person and develop experience of the operational side of the business.