Samuel Asare

Samuel Asare

$30/hr
Data Analytics & Business Intelligence
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Charlottetown, Prince Edward Island, Canada
Experience:
6 years
About

Core Competencies

  • Data Strategy & Analysis: SQL (MySQL), Python (pandas, NumPy), R - collection, cleansing, trend and diagnostic analyses
  • Reporting Automation: Advanced Excel (PivotTables, Power Query), Python scripting, build and automate workflows to reduce manual effort by up to 50%
  • BI & Visualization: Power BI, Tableau — design interactive dashboards for real-time KPI tracking, forecasting, and ad-hoc exploration
  • Process Improvement: Statistical methods - translate analyses into operational enhancements.

Professional Experience

  • TJX Canada (HomeSense) — Charlottetown, PEI | Retail Store Associate (Oct 2024–May 2025)
  • • Developed daily inventory and sales performance reports in Excel; recommended stock adjustments that improved turnover by 8%.
  • • Automated reporting tasks with VBA macros, cutting prep time by 50%.
  • • Translated AWS POS data into manager-ready Power BI dashboards .
  • Elle DI di LUCIC DRAZEN & C.S.a.s — Porcia, Italy | Delivery Controller (Nov 2021–Jun 2024)
  • • Led efficiency improvements through production data analysis.
  • • Ensured deliveries met quality and safety standards .
  • Gruppo Padana — Paese, Italy | Delivery Controller (Jan 2021–Oct 2021)
  • • Monitored daily delivery metrics; proposed Kanban-based workflows to eliminate bottlenecks.
  • • Prepared weekly statistical reports on accuracy improvements for operations leadership.
  • Solution Truck AB (Erasmus Internship) — Uppsala, Sweden | Customer Service Officer (Aug 2019–Feb 2020)
  • • Analyzed complaint data; updated CRM configurations to boost response rates by 15%.
  • • Created Power BI dashboards to track service metrics for senior stakeholders.
  • Innovations for Poverty Action (IPA) — Accra, Ghana | Research Assistant (Feb 2016–Dec 2016)
  • • Managed SurveyCTO data collection and validation; performed statistical analyses to inform healthcare policy recommendations.
  • • Generated weekly progress reports and communicated findings to non-technical teams .

Academic Projects

  • Diagnostic Analytics for Crime Trends: Excel-based analysis of socio-economic and crime data to identify high-risk zones for PEI’s Department of Justice.
  • COVID-19 Policy Dashboard: Interactive Power BI solution with custom DAX measures to track policy impacts on health outcomes.
  • Customer Deduplication & ROI Analysis: SQL and Excel comparison of identity-resolution methods, quantifying ROI uplift.
  • IoT Attendance Logger: Raspberry Pi and Python-driven real-time attendance tracking system.

Education & Recognition

  • Post-Graduate Certificate, Data Analytics | Holland College, PEI (May 2025)
  • MSc, Global Economy & Business | University of Cassino, Italy (Sep 2020)
  • BA, Psychology & Study of Religions | University of Ghana, Legon (May 2013)
  • Judges’ Choice, Ocean of Data Challenge — Python clustering model to mitigate maritime traffic risks for Nova Scotia’s coastal safety
Languages
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.