Alexander Rubanenko
Macquarie University Hospital
Sydney
2
Languages
1
Certification
8
years of professional experience
Data Analyst with over 6 years of experience delivering data and business intelligence solutions across healthcare, higher education, banking and government. Passionate about transforming complex data into meaningful insights through Power BI, SQL, Snowflake and automation. Successfully delivered more than 30 data projects. Outside of work, I enjoy exploring generative AI, emerging technologies, puzzles and magic.
Work History
Data Analyst
1 Year 1 Month- Developed and executed comprehensive Power BI reports to optimize operational insights for hospital personnel and leadership.
- Analyzed requirements and generated new reports within the TrakCare hospital patient ERP system to enhance data accessibility.
- Achieved streamlined operations by effectively collaborating with hospital stakeholders, including nursing unit managers and finance teams. Delivered enhanced process efficiencies through proactive support of admission, theatre booking, and billing teams. Cultivated strong partnerships with key personnel across departments to drive successful outcomes in hospital operations.
- Directed transition of legacy reporting systems to Power BI paginated reports, focusing on comprehensive testing and establishment of row-level security (RLS) and governance protocols with Collibra.
- Executed complex SQL queries to extract, manipulate, and analyze data with precision.
- Identified and automated manual BAU processes performed by different teams, reducing human error and increasing stakeholder productivity.
- Designed and implemented self-service reporting solution to streamline access to monthly reports.
- Developed and maintained SQL transformation models using dbt and GitHub, implementing version control, code reviews, and structured deployment processes to ensure reliable, scalable, and maintainable data pipelines.
Data Analyst
4 Years 1 Month- Utilized DBT to perform data transformations across multiple projects, applying best practices to optimize data workflows for student data, load planning, and HR data integration.
- Designed and developed executive-level dashboards and insight reports that guided monthly investment decisions using Alteryx, Snowflake, SQL views and Power BI.
- Developed and implemented user-role specific and multi-level security model to protect critically sensitive financial data and personal employee information.
- Improved forecast efficiency by 500% through retiring a manual Excel process in favor of using Snowflake for data storage and Alteryx for process automation.
- Developed an Alteryx app solution to automate the flattening of pivoted tables across multiple Excel sheets, converting them into CSV format for seamless upload into Snowflake. This solution significantly reduced manual processing time and improved data readiness for analysis.
- Led benchmarking exercise with HR executive and their team of +5 client stakeholders to understand data collection processes and business requirements.
- Documented full project lifecycle, ensuring all stages of development were thoroughly captured and provided an intuitive user-manual for future reference.
- Global professional services consultancy transforming how organisations work with data.
- Client: Macquarie University
- Orchestrated seamless data integration from SharePoint CSV and Excel files into Snowflake, ensuring 0% duplication and 100% compliant data interfaces.
- Designed and completed migration of intricate ETL procedures from Power Query into optimised SQL queries, increasing data capacity and process scalability by 10x.
- Spearheaded the development of comprehensive Power BI reporting solutions in collaboration with the Product Owner, providing team of +5 with actionable insights.
- Orchestrated data workflows across multiple technologies including Talend, AWS services, and SQL, streamlining data integration and enhancing governance practices.
- Collaborated on a weekly basis using an agile development methodology with a cross-functional team of +7 including business stakeholders, data scientists, and engineers.
- Investigated discrepancies of Tableau dashboard reporting, analysing inconsistencies to identify roots causes, and analysed data to validate business insights.
- Reduced number of back-end scripts by 50% through removing code redundancies, promoting re-usability, and thus further enabling business-level reporting.
Data Analyst
2 Years 8 Months- Reconciled salary payment variances by cleansing data and conducting statistical analysis on aggregated compensation reports – remedying all discrepancies.
- Decreased overall error rate from 15% to 2% by developing and maintaining database quality control processes, as well as data entry tracking mechanisms.
- Proactively generated $30k annual cost reduction in 2 weeks by developing automation process using Power Query and VBA to automate multiple reporting processes and document creation. This resulted in 90% decrease in overtime.
Education
Bachelor of Arts - Education & Social Leadership
Skills
Data visualization: Proficiency in data visualisation tools including Power BI and Tableau to create compelling visual representations of data for business stakeholders.
ETL processes: Alteryx
SQL
DBT
DAX
Python and Power Query for data extraction
transformation
and loading.
Data visualisation and presentations
Analytical methods: Ability to apply statistical methods and techniques to interpret data
validate hypotheses
and forecast trends accurately.
Data governance
Leverage AI usage to improve work
Accomplishments
- Analyzed and optimized financial reconciliation processes, identifying and resolving expenditure-to-income variances exceeding AUD $400K, improving financial accuracy and supporting informed decision-making.
- Designed an automated compliance reporting solution that identified 300+ patients daily with outstanding mandatory nursing forms, improving visibility of documentation gaps and supporting timely clinical compliance.
Certification
Alteryx Designer Advanced (Alteryx) - Feb 2023
Power BI Data Analyst Associate (Microsoft) - Feb 2022
Languages
Russian
Full Professional
Hebrew
Native or Bilingual
Interests
Outside of work
I enjoy exploring emerging AI technologies
performing magic
solving logic puzzles
and speedcubing (solving a Rubik's Cube in under five minutes).
Timeline
Data Analyst
Macquarie University Hospital
07.2025 - CurrentRead More
Data Analyst
Billigence
06.2021 - 07.2025Read More
Data Analyst
Notre Dame University
10.2018 - 06.2021Read More
Westpac
Read More
NSW Telco Authority
Read More
University of Haifa
Bachelor of Arts from Education & Social Leadership
Read More