William Deng Email & Phone Number

Perth, Wa, Au

Perth, Western Australia, Australia

Auckland, New Zealand

Responsibilities:• Assist with migration of data solutions to Azure cloud platform.• Designed and maintained scalable data architectures using Azure tools.• Developed efficient data pipelines and automation scripts.• Implemented Infrastructure as Code (IaC) principles.• Provided mentorship and technical guidance to junior team members.Achievements:• Successfully migrated data solutions to Azure, enhancing scalability and cost-effectiveness.• Optimized SQL… Show more Responsibilities:• Assist with migration of data solutions to Azure cloud platform.• Designed and maintained scalable data architectures using Azure tools.• Developed efficient data pipelines and automation scripts.• Implemented Infrastructure as Code (IaC) principles.• Provided mentorship and technical guidance to junior team members.Achievements:• Successfully migrated data solutions to Azure, enhancing scalability and cost-effectiveness.• Optimized SQL procedures, reducing query execution time.• Established CI/CD pipelines, speeding up deployment processes.• Automated routine tasks, improving operational efficiency.• Recognized by senior management for leadership and performance. Show less

Auckland, New Zealand

Responsibilities:• Mentor and support fellow data analysts.• Analysis of technical problems and provide a solution that has minimal risks and impact.• Data process development (ELT) and data reporting.• Database administrator tasks: maintaining users and permissions, index, database backups, log clean up, linked server and replication between production servers.Tech stack: Power BI, SSRS, SSIS, MS SQL Server: T-SQL, DB backup and maintenance, DB… Show more Responsibilities:• Mentor and support fellow data analysts.• Analysis of technical problems and provide a solution that has minimal risks and impact.• Data process development (ELT) and data reporting.• Database administrator tasks: maintaining users and permissions, index, database backups, log clean up, linked server and replication between production servers.Tech stack: Power BI, SSRS, SSIS, MS SQL Server: T-SQL, DB backup and maintenance, DB Replication.Achievements:• Added source control to our database development via Visual Studio.• Enhanced the existing SSRS to allow data-driven on the Standard edition of SQL Server. Show less

Auckland, New Zealand

Responsibilities:• Enhance the overall robustness of the current mobile app. o API development/testing. o Fully re-wrote their mobile app to support a better framework and added live UI preview and Unit Tests to improve the overall quality. o Enhance data integrity and security.• App development and deployment (Android/iOS).• Assisting the team with their overloaded workloads - Development and Data Reporting.Tech stack: C# .Net, Xamarin.Forms… Show more Responsibilities:• Enhance the overall robustness of the current mobile app. o API development/testing. o Fully re-wrote their mobile app to support a better framework and added live UI preview and Unit Tests to improve the overall quality. o Enhance data integrity and security.• App development and deployment (Android/iOS).• Assisting the team with their overloaded workloads - Development and Data Reporting.Tech stack: C# .Net, Xamarin.Forms with Prism Framework (MVVM), Azure Notification Hub, MS SQL Server and Knockout Js.Achievements:• Took the lead of migrating their data warehouses into a new server. This has improved the performance of their production server and shortened the time to generate live reports. Show less

Auckland, New Zealand

Responsibilities:• Review the current systems and develop software tools to satisfy business needs.• Building reports to satisfy the analytical and financial needs of the day to day business, turning data into presentable visualisation using the Power BI platform.• Review and implement cybersecurity measures.• Internal IT support.Tech stack: C# .Net, MS SQL Server, WhereScape RED, JavaScript/HTML/CSS and PowerBI.Achievements:• Developed complex scripts that… Show more Responsibilities:• Review the current systems and develop software tools to satisfy business needs.• Building reports to satisfy the analytical and financial needs of the day to day business, turning data into presentable visualisation using the Power BI platform.• Review and implement cybersecurity measures.• Internal IT support.Tech stack: C# .Net, MS SQL Server, WhereScape RED, JavaScript/HTML/CSS and PowerBI.Achievements:• Developed complex scripts that allows WhereScape RED to do this daily ETL in parallel, shortening the total ETL time by at least 50%. Show less

Auckland, New Zealand

Responsibilities:• Enhance the current system to make it more user-friendly and accurate for our users.• Promptly update our system to match the frequently changing requirements.• Develop new products to assist and improve users' workflow. (Web, desktop or server-based software)• Several database administration tasks such as backup and recovery, performance monitoring and troubleshooting.• Provide system training to end-users.Tech stack: C# .Net, MVC, MVVM, MS SQL… Show more Responsibilities:• Enhance the current system to make it more user-friendly and accurate for our users.• Promptly update our system to match the frequently changing requirements.• Develop new products to assist and improve users' workflow. (Web, desktop or server-based software)• Several database administration tasks such as backup and recovery, performance monitoring and troubleshooting.• Provide system training to end-users.Tech stack: C# .Net, MVC, MVVM, MS SQL Server, Knockout Js, SSIS, SSRS, WPF, HTML/CSS and jQuery.Achievements:• Developed our own online referral management system for our clients and lead the industry with this paperless system.• Developed our own ETL software. Show less

North Shore

•Design, develop and implement web site•Testing and debugging•Modify and/or upgrade clients’ web sites in functionality-wise•Same old same old.

Auckland

•Install Central Vacuum and Ventilation system•Problem solving related to installation•Maintenance and repair •Self-driven and organised•Meeting deadlines

Auckland

•Signage, flyer, brochure designer•Auditing and reporting car parks’ revenues•Car park commencement preparation•Basic I.T support•Event staffing organizer, recruiter and trainer

Sydney, Australia

•Customer interaction and service

Melbourne, Australia

•Design, develop and implement web site•Testing and debugging•Modify and/or upgrade clients’ web sites in functionality-wise