Bi Analyst
CurrentCurrently working on cloud-based property investment platform which integrates functionalities for the property owner, tenants, service providers, property managers and property investors. This is an Auckland’s BI division and in charge of the latest Australian data warehouse project, proactively coordinate with senior IT management to ensure application functionality is as per expectations.Responsibilities: • Design and document data migration and integration approach.• Collect… Show more Currently working on cloud-based property investment platform which integrates functionalities for the property owner, tenants, service providers, property managers and property investors. This is an Auckland’s BI division and in charge of the latest Australian data warehouse project, proactively coordinate with senior IT management to ensure application functionality is as per expectations.Responsibilities: • Design and document data migration and integration approach.• Collect and aggregate various data sets from AU government data sources for later data cleansing and migration.• Design and develop ETL package using SSIS to eventually fetch them to a data warehouse. • Collaborate with the senior developers with building Data warehouse including dimensional modelling and data integration. • Create financial reports and dashboard using SSRS and Power BI. • Performance tuning by creating various clustered, non-clustered indexes and Indexed views. Show less
