Technical Skills
Spreadsheets & SQL
- Executing data cleansing, sorting, and multidimensional pivot table analysis within spreadsheets in both Microsoft Excel and Google Sheets to ensure database integrity.
- Optimizing data retrieval and manipulation using advanced SQL queries, filtering, and data type conversion.
- Engineering comprehensive data mapping and schema integration to seamlessly align disparate source data with target database architectures, preserving data lineage and integrity
Reports & Visualizations
- Documenting data preparation workflows by producing comprehensive cleaning reports and maintaining meticulous change logs to ensure data integrity and transparency.
- Translating stakeholder requirements into interactive Tableau dashboards, dynamic spreadsheet visualizations, and executive presentations to translate complex data insights into actionable business strategies.
Programming Languages
- Applying Python and its library ecosystem (NumPy/Pandas) to programmatically structure and analyze raw data.
- Developing reproducible data workflows in R using the tidyverse ecosystem to systematically ingest, clean, and transform raw datasets into structured formats.
- Leveraging R to perform advanced statistical modeling, hypothesis testing, and exploratory data analysis to uncover underlying data patterns.
Veronica Shaw 