Mike McCallum
ETL, SQL and Power BI Developer at Mawer Investment Management- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Microsoft Certified: Azure Data Fundamentals
MicrosoftMar, 2021- Nov, 2024 -
Microsoft Certified: Azure Data Fundamentals
MicrosoftMar, 2021- Nov, 2024 -
netmikem@yahoo.ca
MicrosoftMar, 2021- Nov, 2024 -
Microsoft Certified Solutions Associate: BI Reporting
MicrosoftDec, 2019- Nov, 2024 -
Microsoft Certified Solutions Associate: SQL 2016 Database Development
MicrosoftDec, 2018- Nov, 2024 -
MCSE: Data Management and Analytics — Certified 2018
MicrosoftOct, 2018- Nov, 2024 -
ITIL Foundation Certificate in IT Service Management
EXINFeb, 2014- Nov, 2024 -
MCSA: SQL Server 2012/2014
MicrosoftDec, 2013- Nov, 2024 -
MCSA: SQL Server 2012/2014
MicrosoftDec, 2013- Nov, 2024 -
Microsoft Certified Solutions Associate - SQL Server 2012
MicrosoftDec, 2013- Nov, 2024 -
Microsoft Certified Professional - SQL Server 2012 Administration
MicrosoftJun, 2013- Nov, 2024 -
Microsoft Certified IT Professional - Database Developer 2008
MicrosoftJul, 2012- Nov, 2024 -
Microsoft Certified Technology Specialist - SQL Server 2008
MicrosoftMay, 2010- Nov, 2024 -
Microsoft Certified Application Developer (.Net)
MicrosoftApr, 2005- Nov, 2024 -
Microsoft Certified Database Administrator - SQL Server 2000
MicrosoftMay, 2003- Nov, 2024 -
Microsoft Certified: Data Analyst Associate
MicrosoftSep, 2020- Nov, 2024 -
Microsoft Certified: Data Analyst Associate
MicrosoftSep, 2020- Nov, 2024 -
Microsoft Certified: Data Analyst Associate
MicrosoftSep, 2020- Nov, 2024 -
Microsoft Certified: Data Analyst Associate
MicrosoftSep, 2020- Nov, 2024 -
Professional Scrum Master - Level 1
Scrum.orgApr, 2020- Nov, 2024
Experience
-
Mawer Investment Management
-
Canada
-
Investment Management
-
100 - 200 Employee
-
ETL, SQL and Power BI Developer
-
Nov 2018 - Present
-
-
-
Groundswell Group Inc
-
Calgary, Canada Area
-
BI Consultant
-
Sep 2016 - Nov 2018
Microsoft Power BI design and development for clients. Microsoft SSIS development. Microsoft SSAS tabular models, including DAX. Microsoft SQL Server administration and development. Oracle GoldenGate replication support for client. Microsoft Power BI design and development for clients. Microsoft SSIS development. Microsoft SSAS tabular models, including DAX. Microsoft SQL Server administration and development. Oracle GoldenGate replication support for client.
-
-
-
TransAlta
-
Canada
-
Utilities
-
700 & Above Employee
-
Senior Business Analyst/Senior Project Analyst
-
May 2014 - Feb 2016
Supported the activities of the Energy Trading & Marketing business unit using advanced Excel, VBA and SQL. - Created, tested, evaluated, modeled & implemented new/improved system tools - Incorporated new products into financial system of record (SAP) and maintained associated daily/weekly data uploads - Utilized advanced VBA and SQL skills to design, maintain and manage fixed and ad-hoc reports - Designed, troubleshooted and streamlined complex Excel spreadsheets and models for users - Collaborated with IT to develop and implemented business solutions for end users in Finance
-
-
-
Orbis Investments
-
Bermuda
-
Investment Management
-
300 - 400 Employee
-
Systems Developer
-
Jun 2004 - Oct 2013
Initially hired as the sole developer for the Trading business unit of a reputable global investment management firm. Was a significant contributor in the development of the technology team and the applications used within the operation. Worked remotely from Calgary for final three months, doing mostly database administration and development. Initially hired as the sole developer for the Trading business unit of a reputable global investment management firm. Was a significant contributor in the development of the technology team and the applications used within the operation. Worked remotely from Calgary for final three months, doing mostly database administration and development.
-
-
-
Marsh
-
United States
-
Insurance
-
700 & Above Employee
-
Systems Developer
-
Sep 2001 - Jun 2004
Gained experience supporting an international client base in a multi-currency based financial application. Gained experience supporting an international client base in a multi-currency based financial application.
-
-
-
-
Project Leader
-
1989 - Jul 2001
Hands-on and varied role involving a wide range of software development, project management and client-facing activities. Hands-on and varied role involving a wide range of software development, project management and client-facing activities.
-
-
-
Government of Northwest Territories
-
Canada
-
Government Administration
-
700 & Above Employee
-
Systems Developer
-
1987 - 1989
Gained valuable experience developing and supporting many applications. Gained valuable experience developing and supporting many applications.
-
-
Education
-
University of Calgary
Continuing Education Certificate, Business Intelligence and Analytics -
Carleton University
Bachelor of Computer Science, Computer Science -
PWK
high school