Services

I am a freelance data analyst and engineer with a focus on data journalism and open source reasearch (OSINT) projects. I am specialized in the following areas:

1. ETL Development and Optimization: Design and develop efficient Extract, Transform, Load (ETL) processes to manage and optimize data flows within organizations, including integration with cloud services like AWS and GCP. This includes web scraping projects or complex PDF processing, to extract and structure data from the web or internal docs, as carried out in prize-awarded ICIJ projects like the Panama Papers, Fincen Files, Paradise Papers, Implant Files, etc.

   Tools: Python, BeautifulSoup, py-camelot, pdfplumber, PyMuPDF, Google Geolocation API, Neo4j Graph DB, FollowTheMoney CLI, etc.

   Example projects:

   • ICIJ OffshoreLeaks Database

2. Data Analysis and Visualization: Provide in-depth data analysis services, including the creation of compelling visualizations and dashboards using Streamlit, Seaborn, Plotly, Metabase, Linkurious or other tools like Jupyter Notebooks or VisiData to uncover insights and support decision-making.

   Example projects:

   • Toyota Dashboard
   • Road Surfer Dashboard

3. Open Source Intelligence (OSINT) Investigations: Perform detailed research and data gathering using open sources to support different kinds of investigative work, journalism, business, legal.

   Example sources: OpenCorporates, OpenSanctions, ICIJ, UN International Trading Database, UK Companies House, etc.

   Example tools: OpenCorporates API, EO Browser (Sentinel Hub), Google Earth Engine, OpenStreetMap, Global Forest Watch, OSINT Framework Sherlock, [etc.

   Example projects: Deforestation Inc (ICIJ)