I’m an AI & Automation Consultant focused on operations and reporting. I build reliable data pipelines, dashboards, and workflow automations with Python, SQL, and cloud tools—turning manual reporting into automated decision systems. I’ve supported enterprise and SMB environments across multi-country programs, delivering secure reporting (including row-level security) and measurable time savings. Currently based in Quebec and open to remote roles across Canada.
CORE FOCUS: Automating operations & reporting with AI, data and cloud.
Automation
Workflow automation • reporting pipelines • process optimization
AI
LLM-assisted reporting • text-to-insights • smart copilots
Big Data
Data modeling • ETL/ELT • analytics-ready datasets
Cloud
Secure data access • scalable storage • integrations
Python
Data engineering • automation scripts • APIs & scheduling
LANGUAGES
PORFOLIO
Training Oversight Dashboards
Developed a suite of 13 dashboards to monitor the progress of online training for thousands of small and medium-sized enterprises. Leveraged AWS, Power BI, Sharepoint, and SQL to ensure seamless data integration and visualization. Implemented row-level security to maintain data confidentiality and integrity.
Used Tools: SQL, Power BI Desktop and Service, Python (Pandas), Sharepoint, Excel, Google Sheet, Google Drive, Power Automate
Performance Analysis Dashboard
Designed a Power BI dashboard integrated with Excel and SQL to track and evaluate the performance of consultants against set goals. The dashboard provided insights into individual achievements, helping in performance assessment and strategic decision-making.
Multi-Country Project Overview Dashboard
Created a Power BI dashboard to present a consolidated view of Fundes' projects across various countries. The dashboard offered a clear snapshot of project statuses, aiding in efficient management and coordination.
Agroexport Potential Insights Dashboard
Developed an interactive Power BI dashboard to visualize survey insights from small and medium-sized Costa Rican companies with agroexport potential. The dashboard featured an interactive map, providing a geographical breakdown of the data and highlighting key areas of interest.
US Market Trends (2015-2021)
Conducted a comprehensive analysis of avocado sales in the US from 2015 to 2021 using SQL. The project delved into sales trends, seasonal variations, and market growth, providing valuable insights into the avocado market dynamics.
Les Laurentides Housing Market Analysis
Performed an in-depth analysis of the housing market in the Les Laurentides region of Quebec, Canada. Utilized SQL and Python for data extraction and manipulation, and presented the findings through visually compelling Tableau dashboards. The analysis provided insights into pricing trends, property types, and market demand.
Contact
Get in touch with Daniel Hernandez