• Cleaned and standardised multiple datasets from different sources (Australian geography, public schools, local transport, population, crime rate statistics, and real estate property values and rental rates)• Develop ETL packages to load the standardised data into operational database and integrate data to data warehouse using SSIS.• Wrote SQL Queries to present property information that was used to determine the rents and expenses by year, month and fortnight which helped understand its financial performance.• Designed dimension tables and fact tables using the Kimball technique on Australian suburb, school, crime, property and transport data.• Performed ETL by creating SSIS packages to populate dimension and fact tables in SQL server from stage tables using Unions, Slowly changing dimensions, lookup, data conversion, etc.• Created dynamic SSRS reports in Report Builder containing Australian property, suburb, crime, and school data to determine the property prices, crime rates, and schools within a 1 Km radius.• Built Power BI dashboards, to show the property prices, crime rates, schools and transportation in various suburbs in Australia within a 1 Km radius.• Built Power BI dashboards to understand the student flow between schools and bus stops in Australian suburbs.

• Power BI development and administration• Building Analysis services reporting models• Developing visual reports, dashboards and KPI scorecards using Power BI Desktop• Connecting to data sources, importing data and transforming data for Business Intelligence.• Implement row-level security on data and understanding of application security layer models in Power BI• Used Power BI Gateways to keep the dashboards and reports up to date.• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.• Providing support to in-house software.• Analysis, debugging and resolving program defects.