Lee Barrett Email and Phone Number
Lee Barrett has often been described as an 'Excel Wizard' because not only does he seem natural with vlookups and pivot tables, but if a function does not exist, he'll write one.It's not just the numbers; he's very creative because his Workbooks and templates are like pieces of art - something you want to work with.Attention to detail, making things look good - but practical and thinking of ways to solve problems via simplification and automation make him an effective practitioner of Excel.His data analysis background allowed him to gain experience collaborating in teams and with individuals to get results.So what can he do?- Advanced Excel ability (including VBA Macros).- Automate, extract, clean, and transform data.- Design and publish Google Datastudio dashboards.- Simplify complex Excel workbooks.- Design attractive but functional Excel templates.What can Lee do for you?How about a no-obligation chat?
Mitie Security
View- Employees:
- 160
-
Control Room Operator (Vodafone Automotive)Mitie Security Apr 2023 - PresentCraigavon, Northern Ireland, United KingdomManaging alerts coming from high value vehicles and communicating them to owners through inbound and outbound calls. Incident reporting, real time monitoring, collaborating with team in a fast paced environment. -
Managing DirectorLee Barrett Trading Limited Feb 2019 - PresentLondon, United KingdomData extraction, transformation, visualisation (dashboards).
-
Skills Showcase : Microsoft ExcelLee Barrett Trading Limited Jun 2002 - PresentLondon, England, United KingdomI am an advanced Microsoft Excel practitioner who recognises the pain people have with data and spreadsheets. Allow me to relieve you of that pain. I can:✅Simplify workbook complexity✅Develop eye-pleasing, interactive templates and dashboard-style excel workbooks, and if Excel is not your preferred Dashboard-medium then I can develop a Google Data Studio dashboard for you instead✅Program/Debug/Enhance VBA scripts (Macros)✅Create Pivot Tables (and automate them)✅Connect Excel to external data sources✅Utilise Power Query - an Excel feature that performs 'Extract', 'Transform', 'Clean' and 'Presentation' functions on your data without future repetition saving you a lot of time✅Utilise or quickly discover/learn any of the built-in functions needed to solve a particular problem - leveraging Excel's power✅Migrate data between systems or between Excel or Google sheets.
-
Data AnalystPromethean Tv Mar 2019 - Oct 2019• I developed a bespoke reporting system involving the acquisition, cleaning, transformation and loading of data from multiple sources resulting in a clean and unified dataset. Significant time-savings achieved.• Built and published an online Dashboard connecting the bespoke reporting system. This enabled rapid, up-to-date performance updates across several metrics. -
Business Intelligence ExecutiveBbc Worldwide Oct 2007 - Dec 2014London, United KingdomI was responsible for servicing the regular and ad-hoc reporting needs of a global sales team. A typical day would involve:- maintaining a fresh and clean dataset- querying the data- designing excel-based reports and templates- producing visuals (tables and charts)- writing commentary- developing custom formulas or VBA scripts- enhancing existing VBA tools- updating powerpoint presentations- performing competitor spend analysis- analysing internal data for insightsAchievements:- Developed a VBA-powered data cleaning & transformation tool- Developed a VBA-powered 'revenue-probe' tool enabling sales team to deep-dive into their metrics - Data freshness improved from one day to 30mins.- Regular reporting rhythm established.- Highly responsive to ad-hoc requirements.- Sales teams have an immediate response to their queries- Greater visibility of our metrics and dimensions -
Database Services ContractorChristian Aid Jun 2007 - Oct 2007London, United KingdomAssist the Database services manager with the import of 1/4 million order lines, relating to 45,000 charitable supporters into a major CRM Database (Ascent) allowing approach and realisation of the value of these additional supporters.Specific activities : Creating test plans, Data analysis, data cleansing, data manipulation, reporting and creating import quality files. -
Motor Sales Support And AnalaystAllianz Global Assistance Uk Aug 2005 - Mar 2007Croydon, United KingdomAnalysis of operational, financial and technical data relating to automotive assistances we provide on behalf of our prestigious vehicle manufacturers and dealers. Timely and meaningful statistics were routinely compiled and communicated to management level. -
Vodafone Account Handler21St Century Technology Jul 2004 - Sep 2004Croydon, United KingdomThis is a call centre role involving the organisation of car kit (in-car mobile phone) installations for Vodafone customers. -
Business AgentVodafone Uk Jun 2002 - Jul 2004Croydon, United KingdomThis is a call-center role involving inbound/outbound calls focusing on business customers. The nature of all calls could be campaign, complaint, price-plan or mobile phone related. Great emphasis was placed on customer care and efficient call-handling.Achievements:- Promotion awarded- Created a VBA-powered database system capable of querying every price-plan and mobile phone available then filter that database based on customer-supplied criteria all through a VBA User Interface (UI).- Developed a VBA-powered note-templating system which allows consistent (and rapid) notes to be added to all accounts.- Faster, efficient selection of price-plans.- Improved personal call metrics i.e. Lower “on hold” and “waiting” statuses and Higher inbound/outbound call volumes. -
Store AssistantSainsbury'S Oct 1991 - May 2002Croydon, United Kingdom10 years of customer services experience
Lee Barrett Skills
Lee Barrett Education Details
-
Selhurst Tertiary CollegeMerit -
Selhurst Tertiary CollegeMerit
Frequently Asked Questions about Lee Barrett
What company does Lee Barrett work for?
Lee Barrett works for Mitie Security
What is Lee Barrett's role at the current company?
Lee Barrett's current role is Control Room Operator (Vodafone Automotive) at Mitie Security.
What schools did Lee Barrett attend?
Lee Barrett attended Selhurst Tertiary College, Selhurst Tertiary College.
What are some of Lee Barrett's interests?
Lee Barrett has interest in Social Services, Computer Programming, Excel Projects, Children, Improving My Financial Literacy, Dashboard, Politics, Web Technologies, Education, Analytics.
What skills is Lee Barrett known for?
Lee Barrett has skills like Vba, Data Access Objects, Access, Sql, Microsoft Excel, Microsoft Office, Powerpoint, Microsoft Word, Ms Access Database, Tableau, Reporting, Alteryx.
Not the Lee Barrett you were looking for?
-
Lee Barrett
Greater Northampton Area, United Kingdom -
Lee Barrett
United Kingdom -
Lee Barrett
Coventry
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial