Stephen Whitehead Email and Phone Number

As the Business Intelligence Analyst at Macquarie Telecom, I work with a team that’s passionate about our customers.Macquarie Telecom is Australia’s only multi-carrier solution provider for business. We connect via data, voice and mobile services.It’s our obsession with customer service that makes us so different. Today we have the best NPS (Net Promoter Score) in Australia.We’re not your traditional telco. We’re Macquarie Telecom – a business of Macquarie Technology Group (ASX:MAQ).

● Developed a comprehensive Human Resources (HR) DataMart integrating employee leave, terminations, and vacancies data. Utilised Power BI to create detailed reports, which enabled the organisation to reduce leave liability by over $100k through data-driven decision-making and enhanced visibility.● Designed and implemented a planning DataMart along with Power BI reports to monitor planning applications nearing the 60-day statutory approval deadline. This initiative led to a 13% improvement in timely application processing by providing clear insights and actionable data for planning teams.● Developed and deployed PowerShell scripts to enhance visibility on Power BI Premium capacity utilisation. This strategic improvement led to a 17% increase in adoption rates by optimising resource allocation and providing clear usage insights.

Leveraged advanced data modelling techniques and SQL to extract and manipulate data across SQL Server, Synapse, Excel, CSV files, and Snowflake, transforming complex datasets into clear, actionable Power BI reports that empower decision-makers with critical insights.• Developed custom Power BI reports from scratch, tailored to unique business needs, enhancing, and refining existing reports for superior performance, usability, and impactful data visualisation, highlighting key business metrics for improved strategic planning and operational efficiency.• Optimised Power BI reports for superior performance and usability, ensuring impactful data visualisation and efficient decision-making processes.• Developed robust data models and crafted sophisticated SQL queries, ensuring data integrity and accessibility, resulting in more efficient data handling and decision-making.• Conducted over 20 comprehensive training sessions on Power BI, Power Query, and data modelling, significantly enhancing team competencies and productivity through ongoing mentorship.• Conducted thorough assessments of Power BI tenant setups, workspace environments, enterprise data gateway configurations, and on-premises report servers, ensuring peak performance and compliance, and making tenant more secure.• Transitioned businesses from legacy reporting solutions to Power BI, ensuring seamless integration with minimal disruption, and decreasing costs by 20%.• Expanded expertise into data engineering, mastering tools and technologies such as Python, PySpark, Synapse, and Microsoft Fabric, ensuring cutting-edge data solutions.• Led initiatives on knowledge transfer and best practices, establishing governance frameworks that strengthened data utilisation and security, improving data governance compliance by 30%.

● Led the conversion of Nintex forms and workflows to Office 365, using Power Automate to streamline processes, resulting in annual savings of $25k+ by reducing licensing costs and improving workflow efficiency.● Developed and implemented custom solutions using Office 365 tools, including PowerApps and Power Automate, to automate departmental workflows and enhance productivity, saving staff 1-2 hours per day on average.● Redeveloped HTML and JavaScript forms to efficiently process COVID Attestation data, reducing form processing time by 50%. Additionally, created Power BI reports to provide real-time analysis of the collected data, enhancing decision-making capabilities.

● Rebuilt and automated PowerShell scripts to audit the Power BI Service, enabling central reporting of the Power BI tenant. This automation saved 5 hours per week by streamlining audit processes and improving reporting accuracy.● Reengineered the Quality & Risk Power BI report to follow best practices, enhancing report efficiency and accuracy. This improvement provided senior management with actionable insights, leading to better performance monitoring and decision-making. ● Streamlined the creation of new Power BI workspaces and Active Directory groups using PowerShell scripts via Power BI's API, saving 1-2 hours per week by automating and optimising the setup process. ● Collaborated with staff to resolve Power BI report issues by identifying and reviewing performance bottlenecks, discussing best practices, and providing guidelines. This support enhanced report performance and adherence to best practices. ● Designed and built an on-premises Data Gateway cluster to ensure failover and redundancy, enhancing system reliability and data availability for critical operations.

● Led the migration of over 2 million documents from Content Manager (TRIM) to SharePoint Online, utilising automated tools and scripts to ensure data integrity and seamless transition, saving the organisation $50k annually on licensing costs. ● Digitised paper-based forms for outdoor staff using Nintex Workflow Cloud, streamlining data submission and processing, saving staff at least 2 hours per day previously spent on scanning and sending manual forms.● Co-developed a solution with Microsoft AI Builder to automatically scan and process incoming electronic/paper forms and emails, enhancing operational efficiency and saving the organisation over $100k annually through reduced manual processing.● Designed and maintained Power Automate flows to replace existing Nintex SharePoint and Nintex Workflow Cloud workflows, optimising automation processes and saving the organisation over $50k annually.● Developed PowerShell scripts to automate the extraction of SharePoint Online document metadata, integrating with Power BI to streamline reporting for the records management team, saving 4 hours per month in data collation and reporting for the executive and public.

● Translated complex business requirements into precise technical specifications, building Power BI reports that automated report preparation. This initiative saved one person 5 days a month and 5 days a quarter by streamlining report creation for the executive and public. ● Established a dedicated Power BI user group for developers, conducting over 10 training sessions and providing continuous technical support. Developed a comprehensive Power BI governance model, enhancing data management and report standardisation across the organisation.

● Redeveloped a comprehensive SQL Server monitoring solution using custom scripts and automation tools to identify, track, and monitor the SQL Server environment, saving 1-2 hours per day in manual monitoring efforts.● Successfully consolidated the SQL Server production environment from six servers to two, optimising server performance and reducing licensing costs by approximately $20k annually through efficient resource management.● Migrated existing SQL Server stored procedures and views to SQL Server Integration Services (SSIS), enhancing data integration, improving ETL processes, and increasing overall system efficiency

● Managed a complex SQL Server environment, including a SQL Cluster and standalone servers with over three hundred databases, ensuring high availability and optimal performance through regular maintenance and monitoring.● Successfully transitioned the organisation to SQL Server Reporting Services (SSRS), providing comprehensive training sessions and enabling end-users to independently develop and manage reports using Report Builder.● Monitored and optimised performance issues related to T-SQL statements, views, and stored procedures, collaborating with staff and vendors to achieve significant performance improvements, resulting in faster query execution and enhanced system efficiency.

● Provided comprehensive support for Microsoft Access database queries, developing numerous Access databases tailored to staff requirements, which improved data management efficiency and user productivity.● Diagnosed and resolved technical issues in ASP web applications using ASP, JavaScript, and SQL Server code, ensuring seamless application functionality and minimising downtime.

1st Level technical phone support.

1st level technical support for dial-up and ADSL connections, billing enquiries.