Lorenzo Coacci

Data Scientist/Engineer

Superbolt•  July 2020 - December 2021

• Develop a scalable bot integrated with the Monday API to manage automation for Data Engineering, Data Science, Marketing Management and HR, reducing drastically time for all processes • Deploy a reliable data ELT infrastructure with Singer Pipelines, dbt, Airflow, Celery Executor, Flower, Docker, Amazon ECS, ECR, Fargate and CloudFormation • Automate dashboard creation using Metabase API and increase efficiency from 12h to 30 min • Design customer segments for Facebook Audiences using LTV prediction and K-means • Enhance code quality by using pylint, automated style grades, creation of multiple Python packages integrated with github and Sphinx

Data Scientist Intern

Superbolt•  January 2020 - July 2020

• Built ETL pipelines using Python, SQLalchemy, AWS EC2, Redshift, and RDS • Developed an algorithm to detect typos with 98% overall accuracy with Python • Enhance Apache Airflow DAGs during development, testing, and production • Created automation with Python using Google Adwords API, Facebook API, Gsheet API, etc • Designed and developed dashboards with Metabase to leverage digital marketing KPIs using SQL • Enhance the logging procedures with reliable monitoring of failures by building a Python package

Analytics Intern

UncommonGoods•  November 2019 - December 2019

• Improved efficiency of a process from 30 minutes to 10 seconds with Python, Pandas and BeautifulSoup • Developed SQL reports for COO, CEO and Operations Managers • Implemented new metrics in SQL for QA and decision-making • Built a bot to automate a process with Python and Selenium