Summary
Overview
Work History
Education
Skills
Affiliations
Accomplishments
Timeline
Generic

Vilesh Amrania

Hemel Hempstead,Hertfordshire

Summary

Experienced Data Analytics Principal with over ten years of leadership in data strategy and team management. Skilled in big data analysis, client engagement, and designing customized analytics solutions. Proficient in Microsoft Excel, Oracle SQL, and dashboard development to drive data-informed decision-making. With a strong background in the automotive industry (ranging from hands-on experience as a technician to handling warranty claims) I bring a well-rounded understanding of the motor trade from various perspectives.

Overview

15
15
years of professional experience
2
2
years of post-secondary education

Work History

Data Analytics Principal

Tekcor4 Ltd
London
01.2020 - Current
  • Currently serving as a Data Analytics Principal in the Analytics Team, driving insights and strategic decision-making.
  • Managing client communications for OEM clients, ensuring seamless collaboration and support.
  • Experienced in working with big data, leveraging advanced analytics for actionable insights.
  • Highly proficient in Microsoft Excel and Oracle SQL, with extensive experience in data analysis and database management.
  • Developed complex SQL queries, optimised query performance, and implemented PL/SQL scripts for both ad hoc and routine reporting.
  • Guided the development and deployment of leading analytics dashboards significantly boosting data-driven decision-making.
  • Handled and fulfilled OEM client ad-hoc report requests.
  • Oversaw daily technical support activities and addressed system problems.

Data Team Lead

Tekcor4 Ltd
St Albans, Hertfordshire
03.2010 - 12.2019
  • Oversaw ETL data loading of daily invoice data feeds from 1200+ retailers, this included retailers from international markets.
  • Collaborated with various DMS suppliers to address persistent data issues.
  • Facilitated onboarding of new retailers within designated timelines.
  • Resolved data quality issues using SQL and IT systems, ensuring SLA compliance.
  • Performed thorough investigative analysis and control of complex datasets with Excel and Oracle SQL.
  • Adhered to protocols in executing updates for efficient database management.
  • Ensured accuracy and reliability of the marketing-related CRM database to improve customer retention.
  • Examined and evaluated retailer invoicing data, offering vital insights.

Education

City & Guilds Level 1 - Motor Vehicle Technology

Watford College
Watford
09.1987 - 06.1988

City & Guilds Level 2 - Motor Vehicle Technology

Watford College
Watford, Hertfordshire
09.1988 - 06.1990

Certified MOT Tester -

Driver and Vehicle Standards Agency
Middlesex
04.2001 - /1991

Skills

  • Microsoft Excel
  • Oracle SQL
  • Microsoft 365
  • IT Literate
  • Teacher mentorship
  • Data visualization
  • Database Administration

Affiliations

  • Gardening
  • Cycling
  • Cooking

Accomplishments

Black belt equivelent in European Wig Tsun Association

Timeline

Data Analytics Principal

Tekcor4 Ltd
01.2020 - Current

Data Team Lead

Tekcor4 Ltd
03.2010 - 12.2019

Certified MOT Tester -

Driver and Vehicle Standards Agency
04.2001 - /1991

City & Guilds Level 2 - Motor Vehicle Technology

Watford College
09.1988 - 06.1990

City & Guilds Level 1 - Motor Vehicle Technology

Watford College
09.1987 - 06.1988
Vilesh Amrania