Shou zheng

I am working on a cloud-based Property Investment and Management Platform, specifically targeting the Data Integration of New Zealand and Australia Property data.

▪ Designing the Data Warehouse solution for

analyzing current market trends of the Australian

and New Zealand housing market.

▪ Creating reporting solutions to share the key

insights with the internal stakeholders.

▪ Designing best data ingestion practices

Achievements:

▪ Designed complex SQL queries for common tasks

for the entire team.

▪ Designed the data warehouse in star schema to

keep it flexible and extensible for any new data

sets.

▪ Discovered and implemented the data cleaning

practice to save the whole team’s time.

▪ Successfully debugged SSIS package.

▪ Helped my mentees with their project tasks to

speed up project delivery as their mentor.

▪ Improved performance of slow-running reports.

▪ Implemented the best industry report

development practices so that it is easily

consumable in different formats e.g., pdf, jpeg,

excel, and word.

Industry Connect is an innovative software training school backed by a global tech incubator. Industry Connect aims to make participants job-ready by the end of the program, therefore meeting both the participants' needs as well as a broader industry need. This online learning program is designed to help aspiring IT specialists in the industry. My specific experience is related to Business

Intelligence Analytics where I developed my skills in SQL Query, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft Power BI, Microsoft Visual Studio, Microsoft Report Builder, Data Warehouse, ETL and Microsoft Excel.

Responsibilities:

▪ Importing data from various sites based on

multiple data sources.

▪ Summarize the relevant data into a table.

▪ Filtering and viewing the imported data.

▪ Cleaning the data.

▪ Constructing data models, building data models.

▪ Describing one-to-many or many-to-many links

between tables.

▪ Building model foundations with snow & star

schema.

▪ Obtaining the desired values through the

algorithm of the measure function as well as DAX,

etc.

▪ Filtering the page or chart levels to obtain higher

standards of visualization via drill-through or

dynamic graphs, etc.

▪ Published my dashboard to the Power BI online

service and shared it with my clients.

▪ Setting up background real-time updates, etc.

▪ Publishing the dashboard to the Power BI online

service.

• Read existing code to understand the project structure.
• Fix simple bugs and optimize existing logic.
• Write unit tests or integration tests.

• Implement sub-functions of a module based on requirement documents.
• Collaborate with the backend team to develop APIs or perform front-end and back-end integration.
• Use common frameworks such as Spring Boot, MyBatis, and Hibernate.

• Participate in designing or optimizing database schemas.
• Write SQL queries or stored procedures.
• Work with common databases like MySQL,

• Read technical documents and learn about the development workflow
• Write API documentation or user manuals.
• Record and reflect on problems encountered during development and how they were solved.

Common Tech Stack:

• Backend Frameworks: Spring Boot, Spring MVC, MyBatis
• Frontend Basics (if involved): HTML/CSS/JS, Vue.js
• Databases: MySQL
• Build Tools: Maven
• Development Tools: IntelliJ IDEA

Analyze and review client profiles, develop visa application strategies, and resolve various unexpected issues that arise during the application process.