Data Science Junior
CurrentDuring my time at LCG, I have been working in multiple tasks related to BP Europe, as the management of client activity and identification of changes in the customers’ consumption behaviour. This includes the development and upgrade of clients’ life cycle activities lists, which describe the different stages of consumption of a client: activation – clients begin to consume; rampup – clients start consuming and achieve their potential; prevention – customers have changed their behaviour and are now consuming less volume; retention – customers are about to leave the company, how can we prevent this. These are programmed in functions using the R language and delivered by loading of objects to BP’s salesforce and email notifications, via python-based applications.Data Mining and Analysis: Collecting data to answer to different types of requests related to the costumers’ consumption behaviour, building informative reports asked by the client by gathering and processing data that is stored in PostgreSQL databases, e.g volumes and card usages in a specific date and site.Automatization of manual processes: Improving their efficiency using ETL mechanisms for the ingestion and processing of data, as applying the multiple steps of the generation of life cycle activities lists to distinct country databases in sequence/parallel or transferring files from one place to another, using the Pentaho Data Integration tool.Machine learning-based predictive models: For example, based on a time series with the number of transactions received throughout time and a defined threshold, built a forecasting model that identifies when a received transactional file has a much lower number of transactions than expected and decides whether the information is updated to produce the life cycle activities lists. Jupyter notebooks with Python were used for the analysis of the data and processing of the input and the algorithms applied were from the R’s package ‘forecastHybrid’.