Ranald Macky
Data & Analytics Consultant
I'm a data analytics consultant who can transform raw data into actionable insights end-to-end. I've worked across various industries, adapting to diverse business contexts. I'm always business focused and prioritize stakeholder value and user-centric solutions. Skilled in Power BI, data warehousing, and SQL, I excel at bridging technical and business teams. Recently relocated to the UK with full working rights, I'm open to London-based opportunities.
Skills
Tools
- Microsoft Fabric
- Power BI
- SQL
- DAX
- SSMS
- Microsoft Dynamics 365
- Alteryx
- Python
- Azure SQL DB
- Azure ML Studio
Competencies
- Stakeholder Management
- Requirements Gathering
- Data Modelling
- Report Design
- App Testing
- Prompt Engineering
- Data Investigation
- Change Management
- User Training
Work Experience (8)
Jul 2023 - Aug 2024
Data & Analytics Consultant - Solution Advisory
BizData
BizData is an award-winning Data Analytics Agency specializing in rapid delivery of Artificial Intelligence, Big Data, and Business Intelligence solutions leveraging Microsoft and Open Source technology. Working in the Solution Advisory team I delivered comprehensive data solutions across finance, hospitality, manufacturing, and professional sports sectors, focusing on enterprise data modeling, CRM migrations, data warehouse design, business intelligence, and AI applications.
- Designed and implemented a comprehensive enterprise data model for a Microsoft Fabric Lakehouse implementation, utilizing Kimball methodology to integrate 8 disparate systems into 10+ fact and dimension tables, handling up to 2 million records per entity
- Mapped SQL logic for large-scale Dynamics 365 CRM migration through data analysis and stakeholder collaboration
- Designed and implemented Power BI data models and reports, enabling advanced self-service analytics across multiple business domains
- Led prompt engineering for generative AI application in professional sports using Azure ML Studio
- Conducted monthly knowledge-sharing sessions on Microsoft Fabric and Power BI updates
Feb 2022 - Jul 2023
Data Analyst
Willis Towers Watson
At Willis Towers Watson (WTW), I served as a Data and Systems Analyst specializing in Dynamics 365 and sales data. I drove platform adoption, managed change, and represented Australasian user needs in the global CRM project. I created self-service report suites for senior stakeholders, providing critical insights on sales pipeline and marketing activity.
- Spearheaded Dynamics 365 adoption as Regional Champion for Australasia, significantly improving platform utilization across the region
- Engineered customized Power BI dashboards that streamlined executive decision-making processes
- Developed automated reporting pipelines using Python,SQL, M, Alteryx and Power BI, substantially reducing manual data processing time
- Designed and delivered comprehensive Dynamics 365 training program for 300+ colleagues, enhancing overall user competency
- Orchestrated large-scale migration of client records from legacy systems to Dynamics 365, ensuring high data integrity
- Crafted complex SQL queries to fulfill diverse ad-hoc data requests, providing timely insights for business decision-making
Oct 2021 - Dec 2021
Microsoft Dynamics Administrator
The British Venture Capital and Private Equity Association
- Administered Microsoft Dynamics system for a key industry association
Aug 2020 - Jul 2021
Intermediate Representative (Dealing and Servicing)
BNY Mellon
- Supervised offshore colleagues, ensuring client satisfaction and regulatory compliance
- Managed client accounts and company records, resolving exceptions per company policies
Apr 2020 - Aug 2020
Support Worker
The Richmond Fellowship
- Provided specialized support for adults with criminal convictions and court-ordered support requirements
- Worked in high-stress environments including psychiatric wards and halfway houses
- Ensured safety and well-being of individuals with complex mental and physical health needs
Dec 2019 - Feb 2020
Data Processor
Nucleus Financial
- Worked within the BI team of a leading fintech company specializing in wrap platform services
- Cleansed CRM database of >20,000 rows using advanced Excel formulas, plugins, macros, and Power Query
- Gained exposure to business intelligence processes and tools, sparking interest in pursuing a career in BI and Data analytics
Apr 2018 - Oct 2018
Clerical Support, CRO
Ulster Bank
- Supported efficient operations of 150+ person Chief Risk Officer's department in one of Ireland's Big Four Banks
- Drafted documents and took minutes for Executive Committee and Board meetings
- Maintained and updated critical office documents and spreadsheets
- Provided PA assistance to the Deputy Director of Risk, including diary management and travel booking
Jul 2014 - Sep 2017
Integration Aide
The King David School
- Supported integration of students aged 5-17 in diverse educational and social environments
- Assisted students with a wide range of neurodiverse conditions and physical disabilities
- Facilitated inclusive learning experiences and adapted support strategies across various settings including classrooms, social activities, and school camps
Education (3)
2014 - 2017
Bachelor
Commerce: Finance and Management
The University of Melbourne
2017 - 2017
Visiting/ Exchange Student
Exchange Program
Trinity College Dublin
2023 - 2023
Course in
Machine Learning
Royal Melbourne Institute of Technology
- MATH2387 - Machine Learning
Certificates
2024-02-01
Power BI Data Analyst Associate (PL300)
Microsoft
2023-10-01
Azure Data Scientist Associate (DP100)
Microsoft
2023-08-01
Azure Data Fundamentals (DP900)
Microsoft
Interests
Music
- Gigging Keyboardist/Vocalist
- Trinity Tiger Tones (Director)
- Trinitones
- Choir of Trinity College Melbourne
- 900k+ Spotify plays
Sports
- Basketball
- Tennis
- Football
- Rowing
- Rugby Union
- Australian Rules Football