services
Data Management & BI
Got some messy data scattered around your workspace that you're sure is useful but nobody's really tapped into yet? I can help build robust data pipelines that connect to your sources (local or cloud), clean and transform your data, and present everything in an easy-to-follow dashboard or report.
- Mapped out user journeys across various tools and platforms identifying pain points
- Implemented a highly optimized workflow for processing constituent data using Salesforce Apex, Visualforce, and LWC
- Freed up 8+ hours each week by automatically tracking email replies
- Designed a data pipeline to extract, transform, and load training data from multiple data sources
- Coached team members to use and modify the data pipeline themselves reducing reporting time by 80%
- Built on-brand PowerBI dashboards respecting unique data protection requirements
Research & Development
With an academic background in the humanities, I can help with data-heavy research projects requiring a mix of technical and analytical skills. I can help obtain data from the web (by connecting to APIs or scraping it), perform text extraction, natural language processing, and statistical analysis. At the end, we can visualize everything in a way that represents your brand and is intuitive to understand for your audience.
- Built a web scraper and natural language processing pipeline analysing 180+ PDFs using Python, Playwright, and NLTK
- Extracted relevant keywords enabling the research team to prioritize their reading ahead of time.
- See here for the published article.
- Perpared a data-driven narrative communicating the scale of impact of a small non-profit
- Translated it into an interactive, vanilla JavaScript application that integrated with the organization's website
- See here for a live version
Miscellaneous
Depending on the project, I can also help with more general IT adventures including troubleshooting/upgrading old hardware, migrating to Linux, and (self-)hosting.
Have a project idea you'd like to discuss?