Steve Banks

Experience

• 

  Paradigm Recruitment

  Nov 2000 - Jul 2002

  Research Consultant

  Working in a team of two in a purely client-focused role within the IT and telecommunications sector. Liasing with clients via telephone and face-to-face meetings. Cold calling in a head hunting capacity both in the UK and mainland Europe. Responsible for understanding the client's requirement, sourcing qualified candidates, and subsequently arranging client interviews through to the negotiation of offers with both parties. Gained valuable experience and contacts within the telecommunications industry throughout Europe. Several placements made totalling around £90k in the final 12 months, including senior members of startups, multinational operators, manufacturers and software houses. Brought in new clients through cold calling, developing the relationship and making placements often competing against larger international recruitment agencies with greater success. Targets set were often exceeded both in company ethos and profitability.Responsibilities also included reviewing industry-specific existing documentation, both written and web site material, and monitoring trade publications for personnel movement to complement research activity. Show less

• 

  AndersElite

  Jul 2002 - Sept 2003

  Recruitment Consultant

  Approached by the company to assist in re-building their Facilities Management recruitment capabilities in London and the South-East. Halfway through my employment took on new responsibilities in addition to those of Recruitment Consultant and was appointed "Website and E-Commerce Representative" for the St. Albans office, reporting to the Marketing Director, a function which I took on due to my keen interest in computers and the internet. This role essentially involved relaying website-related information to my office (in the form of Powerpoint presentations) and other responsibilities such as PC troubleshooting and configuring the Nortel PBX.Responsible for a start-up desk, researching the market and key players before aggressively selling the AndersElite branding and services into major FM Service Providers, PFI Construction companies and End-users. Led face-to-face meetings with key industry people, demonstrating an extensive knowledge of the FM marketplace. Responsible for the end-to-end recruitment of a number of high-profile candidates into companies, including British Airways, ISS UK, Pinnacle Insurance and Drivers Jonas, all of which were clients I brought in from an extremely cold and volatile market. Billed c.£90k in my first 12 months. Show less

• 

  Red Recruitment Ltd

  Jan 2004 - Oct 2005

  Consultant

  Offered position to develop a year-old temporary/contract desk for Accountancy staff in the Luton area. After nearly two years, the market became too hostile for the justification of this division and my position became redundant. Responsible for a new temporaries division of the company, targeting mainly new business as well as developing relationships with major clients such as Whitbread PLC, Kidde Fire Protection and Elster Metering.Gained signed PSL agreements with key companies in the area, such as Huntleigh Healthcare and Signature Flight Support.Built the division from 15 temporaries to a peak of 36 (billing c.£11,000 a month) before market slowdown in early 2005. Show less

• 

  Computacenter, Hatfield

  Dec 2005 - Apr 2016

  Moved internally to multinational Business Analysis team responsible for company-wide reporting and analysis on various business measures such as sales, stock and purchases. Job role involves building business-critical applications and reporting tools mainly using Excel VBA in combination with either an Access backend or querying SQL Server directly as well as producing ad hoc reports for both internal and external customers. • Responsible for the end-to-end project-management of new tools, including the specification, development, testing and delivery in both actual and virtual pan-European teams.• Built the Purchasing department’s purchase order management tool from the ground up using data exported from SAP. Produced supporting media and provided training for users in 4 countries. Show less Promoted to lead team of Purchasing Planners and given the objectives of developing them as individuals, managing their day-to-day performance as well as reducing stock risk and cost to the division and company. Full Job Description available on request. Conducted comprehensive review of the team's processes and structure and re-focused activities to bring the team's goals in line with those of the division. Through coaching and mentoring, brought a junior team member up to the required level that I required to promote her. Was recognised for my contribution to the division as a whole with a further "Excellence in Action" award.Project-managed the integration of the team's responsibilities into the rest of the department without making redundancies. Show less Took on additional responsibilities as maternity cover for a part-time Product Manager position, which involved the maintenance of both the back and front end of the corporate website's "Self-Configuration" functionality. Responsible for all commercial and training aspects of the system company-wide. Following a restructure, maintained the position. Personally responsible for over £40 million a year of revenue which grew to nearly £60 million in 2008. Oversaw the transition from the legacy Top Config system to HP's new ACE system as part of a virtual project team. Held regular training seminars at locations across the UK, typically presenting to groups of 10-30 sales people. Show less Joined existing Forecasting and Stock-Management team responsible for the reduction of risk, maximisation of stock efficiency and policing of the AS/400 system. My role was mainly focused on the reporting and analysis of self-generated IT stock reports (directed both at Sales and at Purchasing), commercial decision-making around the allocation of stock and improving existing processes for efficient stock management. Full job description available on request. Personally designed and implemented company-wide forecasting process centered around an MS Access database. Awarded "Excellence in Action" Silver award for both dramatically improving existing management reports and conceiving and creating various others. Chosen to represent the division, within a specialised virtual team, for company-wide presentations and was uniquely responsible for the design aspects of the powerpoint project attached to it Show less

  • Data Analyst

    Jul 2009 - Apr 2016

  • Senior Purchasing Planner

    Dec 2007 - Jul 2009

  • Top Config Product Manager

    Oct 2007 - Jul 2009

  • Purchasing Planner

    Dec 2005 - Oct 2007
• 

  Cotiviti

  Apr 2016 - Mar 2017

  Associate Business Systems Analyst

  Responsible for the extraction, transformation and loading of client data sourced from Teradata and ASCII/EBCDIC text files into SQL server. Built transformation tools using Excel VBA that drastically improve the time it takes to complete the various processes for converting data from different client systems (Oracle, Mainframe, EDI) ready for mapping and loading. Also created an application with a backend database that monitors and logs the entire ETL process, checking and unzipping received files, monitoring error logs and confirming presence of data in the target SQL database. Show less

• 

  Monarch Airlines

  Mar 2017 - Oct 2017

  Commercial Insights Analyst

  Key Skills: SQL, VBA, VB.Net, TableauJoined a team performing data analytics and decision support, implementing new data standards and streamlining reporting processes for Monarch’s commercial department spanning pricing and revenue management, marketing, trade and distribution and network development. Built a Windows Forms application connected to the company’s booking databases that enabled sales staff to provide quotes for group bookings. Managed the entire project from stakeholder engagement through to delivery. Applied data standards to analytics databases, automated the overnight processes using triggers and jobs, and adapted existing Tableau dashboards to use views and stored procedures. Show less

• 

  Tesco

  Dec 2017 - now

  Key Skills: SQL, VBA, ArcGIS, Teradata, Hadoop/Hive, Alteryx, Alation.Responsible for the sourcing, loading, curation, production and ownership of all spatial-related data (competitor stores, demographic, POI etc.) for Location Planning, Property and the wider Tesco business. Also making whizzy maps. Key Skills: SQL, VBA, Teradata, Hadoop/Hive, Alteryx, Alation.Insight and decision support for Operations Development.

  • Location Data Manager

    Jan 2019 - now

  • Insight Analyst (Maternity Cover)

    Dec 2017 - Jan 2019