Loading profile…
John Smallpage
Looking for a jobData & Analytics Analyst
Data & Analytics Analyst at Farmatodo, designing Databricks lakehouse models for 300+ business users across three countries.
VenezuelaData & Analytics Analyst at Farmatodo
Experience
Data & Analytics Analyst
Re-engineered the board-level Daily Sales Report from legacy Excel VBA macros to Python, cutting generation time from roughly 20 to 3 minutes per country and currency. Developed semantic layers in Databricks that brought self-service BI to around 300 business users across three countries.
PythonPandasXlsxWriterDatabricksSQLPySparkSemantic layerData ModelingData QualityPipeline MonitoringCloud Cost OptimizationOracle BI PublisherMedallion Architecture
Data Engineer
Developed a Business Intelligence web application as an industrial thesis to investigate irregular behavior among affiliated merchants and help prevent money laundering. Designed three data marts (finance, asset control, and anti-money-laundering) to power Metabase dashboards and speed up reporting.
PythonfastAPIREST APIsMetabaseData MartsBonitaSoftWorkflow AutomationSQL
Education
Universidad Metropolitana
Bachelor of Engineering in Systems Engineering, graduated Cum Laude with a GPA of 17.83/20. Dean's List for 2021-2022 and 2022-2023, and distinguished honors thesis on POS-transaction monitoring for money-laundering prevention.
Bachelor of Engineering in Systems Engineering, graduated Cum Laude with a GPA of 17.83/20. Dean's List for 2021-2022 and 2022-2023, and distinguished honors thesis on POS-transaction monitoring for money-laundering prevention.