Data Analyst & BI Developer
Sean Simpson
Transforming Data Into Meaningful Stories
A
b
o
u
t
M
e
ABOUT ME
Hello,
I'm Sean
Data Analyst & BI Developer with 7 years of experience helping businesses turn complex data into clear, actionable insights. I specialize in SQL development, ERP systems, and interactive reporting, with hands-on experience in SSRS, Crystal Reports, and Python for automation and API integrations. I’m also expanding into Power BI and Tableau to build modern analytics solutions that bring data to life. Alongside reporting, I’ve worked extensively with CRM platforms like Synergy and Salesforce, helping teams connect operational and customer data for smarter decision-making. I’m passionate about making data meaningful, accessible, and impactful – from designing efficient data models to crafting dashboards that tell a story.
Data Analytics & Reporting
Built in Power BI, Tableau,
SSRS & Crystal Reports
with SQL, SSIS, APIs & Python
S
K
I
L
L
S
Programming & Scripting
SQL (Advanced)
Python
VBA (basic)
Data Analytics & Reporting
SSRS
Crystal Reports
Excel / Google Sheets
Data Visualization & BI
Power BI
Tableau
Data Modelling
Data Engineering & Architecture
ETL (SSIS, APIs, Pipelines)
CI/CD (concepts)
Data Formats (JSON, CSV, XML)
Databases & Cloud
SQL Server
PostgreSQL (Neon Cloud)
Azure (basic)
Web & Digital
WordPress & Elementor
Google Analytics & SEO
GitHub
B
A
C
K
G
R
O
U
N
D
- Designed and delivered BI and reporting solutions supporting finance, inventory, and production
- Built and maintained SSRS and Crystal Reports using SQL queries, stored procedures, and views
- Created data models and ETL pipelines to integrate and transform data from multiple systems
- Supported ERP data migrations with data dictionaries, mapping tables, and validation processes
- Partnered with stakeholders to translate requirements into functional dashboards and parameterized reports
- Developed a custom API and VBA integration between ShipStation and Macola ERP, automating online order imports and reducing manual data entry
- Implemented and customized ERP and workflow solutions using Macola ERP and Synergy
- Built SSRS and Crystal Reports using complex SQL queries to support operations, performance tracking, and financial reporting
- Designed and configured Synergy workflows to automate key processes such as approvals and task assignments
- Trained end users at client companies on Synergy’s functionality, workflows, and reporting tools to ensure confident adoption and long-term success
- Developed and maintained responsive, SEO-optimized websites using HTML, CSS, and JavaScript
- Integrated Google Analytics to monitor site performance and search visibility, applying insights to improve engagement and SEO rankings
- Collaborated on marketing initiatives, designing digital assets and print materials
- Used analytics data to guide design and content decisions, driving higher user engagement and conversion rates
From the University of Calgary
P
R
O
J
E
C
T
S
Contact Me.
Hello,
I'm Sean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo, Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.