Ayush Ghai
Darwin,NT
Summary
Senior ETL Developer and Business Intelligence Consultant with over 5 years of experience in delivering comprehensive data solutions. Proficient in MSBI, Power BI, and ETL methodologies, with a proven ability to lead complex data integration projects that enhance processing efficiency. Expertise in stakeholder management and data modeling, consistently providing timely BI solutions that align with business goals.
Overview
12
12
years of professional experience
Work History
Senior BI Consultant
SRA Information Technology
Darwin, NT
04.2022 - Current
- Developed ETL mappings based on design documents, ensuring adherence to naming conventions.
- Coordinated with offshore teams on infrastructure and integration projects.
- Collaborated with BI teams to support reporting and analytics needs.
- Developed BI applications utilizing SQL Server, BI Stack, PowerBI, and Tableau over five years.
- Built SSAS cubes and dimensions using various architectures and data sources for Business Intelligence.
- Implemented business logic and data cleansing processes for staging data.
- Automated cube refresh processes post-data loading to enhance efficiency.
- Conducted performance tuning and data consistency checks to optimize ETL workflows.
- Developed stored procedures and views to support data extraction and transformation.
- Analyzed and documented functional requirements for legacy systems, ensuring optimal ETL design.
- Extracted business rules from stored procedures, validating compliance with CMS guidelines.
Business & Systems Intelligence Analyst (CCSRP)
Department of Corporate and Digital Development (DCDD), NT Government
Darwin, NT
01.2020 - 04.2022
- Transformed data using Power Query in Power BI for effective cleansing and transformation.
- Integrated data from Oracle into a data warehouse via ETL processes.
- Applied DAX functions for crafting efficient visualizations in Power BI.
- Executed source-to-target mapping with Datavault 2.0 for modeling and transformation.
- Produced ad-hoc reports with Excel Power Pivot, sharing insights through Power BI.
- Assisted in devising a backup strategy on Microsoft Azure virtualization platforms.
- Conducted comprehensive unit testing to ensure accurate implementation.
- Designed SSAS Cubes and crafted MDX queries for detailed analysis.
PowerBI Report Analyst & Coordinator
Department of Corporate and Digital Development (DCDD), NT Government
Darwin, NT
07.2017 - 01.2020
- Implemented PowerBI software across Territory Families Department, enhancing data visualization capabilities.
- Developed BI architecture and established policies for performance data collection and analysis.
- Created project plans with detailed work breakdown structures to ensure clarity in execution.
- Drafted Project Charters and initiated kickoff meetings to align stakeholder expectations.
- Led development and maintenance of operational PowerBI reports for Senior Executives' reporting needs.
- Supported management team with ad hoc reports, timelines for management reporting, and project scheduling.
- Facilitated technical working group meetings, ensuring accurate documentation of discussions.
- Ensured adherence to project frameworks and maintained comprehensive documentation for each initiative.
Graduate Spatial & Reporting Analyst
Department of Corporate and Digital Development (DCDD), NT Government
Darwin, NT
01.2016 - 07.2017
- Performed complex spatial modeling and analysis to enhance decision-making processes.
- Assisted in development and testing of applications for spatial data maintenance and viewing.
- Coordinated user requirements and provided support for business system issues, resolving errors and corrupt data.
- Completed data validation and migration of approximately 300,000 records to new Roads Reporting System.
- Conducted data validation for approximately 220,000 records in NT Roads Report.
IT Support & Night Auditor, Front Office (Hospitality - Casual)
Mantra on the Esplanade
Darwin
01.2014 - 01.2017
- Coordinate the workflow of the Front Office night team to ensure that the Front Office is covered at all times and the night auditing duties are completed efficiently
- Communicates relevant information to the Front Office Manager and Senior Management team in a professional manner
Education
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) - Data Analytics & BI
Microsoft
02-2025
Microsoft Certified: PowerBI Data Analyst Associate (PL-300) - Data Analytics & BI
Microsoft
03-2025
Bachelor of Information Technology -
Charles Darwin University
Darwin11.2016
Diploma - Ethical Hacking & IT Security
Appin Technology Lab
New Delhi02.2014
Skills
- MSBI (TSQL, SSIS, SSAS, SSRS)
- Microsoft Power BI
- IBM InfoSphere DataStage
- SAP Business Objects
- Microsoft Azure Repo
- Requirements gathering
- Sparx Enterprise Architect
- Big data technologies
- JIRA and Confluence
- Microsoft Excel VBA
- Project management tools
- Microsoft SharePoint
- Bitbucket version control
- HTML and CSS development
- JavaScript programming
- Python scripting
- Data modeling techniques
- Stakeholder Management
Websites
Internships
- IT Support at Stamford Plaza Sydney Airport
- Took help ticket jobs assigned by IT supervisor and recorded ticket results for reporting and record-keeping. Worked closely with IT team members and supervisors to improve troubleshooting skills and situation analysis.
- Assisted users with implementing new software and network infrastructure to ease transition to new technology assets and planned operations.
Residency Status
Australian Citizen
References
References available upon request.
Timeline
Senior BI Consultant
SRA Information Technology
04.2022 - Current
Business & Systems Intelligence Analyst (CCSRP)
Department of Corporate and Digital Development (DCDD), NT Government
01.2020 - 04.2022
PowerBI Report Analyst & Coordinator
Department of Corporate and Digital Development (DCDD), NT Government
07.2017 - 01.2020
Graduate Spatial & Reporting Analyst
Department of Corporate and Digital Development (DCDD), NT Government
01.2016 - 07.2017
IT Support & Night Auditor, Front Office (Hospitality - Casual)
Mantra on the Esplanade
01.2014 - 01.2017
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) - Data Analytics & BI
Microsoft
Microsoft Certified: PowerBI Data Analyst Associate (PL-300) - Data Analytics & BI
Microsoft
Bachelor of Information Technology -
Charles Darwin University
Diploma - Ethical Hacking & IT Security
Appin Technology Lab
Similar Profiles
BHAVYA BAJAJBHAVYA BAJAJ
Business Analyst at SRA Information technologyBusiness Analyst at SRA Information technology
Kerri ParkerKerri Parker
Chief Financial Officer at SRA Information Technology Pty LtdChief Financial Officer at SRA Information Technology Pty Ltd
NEDA PAYDARNEDA PAYDAR
Senior Business Analyst at SRA Information TechnologySenior Business Analyst at SRA Information Technology
Shanis OcampoShanis Ocampo
5th Year Dental Student - Clinical Rotation 2 at Kirwan Oral Health Service5th Year Dental Student - Clinical Rotation 2 at Kirwan Oral Health Service
Brian GardinerBrian Gardiner
Ground Maintenance/Team Leader at Larrakia Development CorporationGround Maintenance/Team Leader at Larrakia Development Corporation