Denghui Wang Email & Phone Number

Sydney, New South Wales, Australia

𝗞𝗲𝘆 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀:• Creating and managing MsSQL and mySQL databases, designing and normalizing the UML diagram and materializing it into a flexible schema, and creating the most performant and economic indices given the computing time and storage space constraints.• Creating complex SQL queries to periodically generate aggregate tables used by PowerBI, to reduce the cost of generating aggregate data from raw data points in PowerBI.• Building Python scripts to efficiently gather telemetry data from lighting control gateways that emit raw data, including the legacy gateways, with an RS-232 port for which I set up the decoding scripts on raspberry Pies as a telemetry uploading delegate and the latest smart gateways which uploads to a RESTFul API I developed with Python and Django. • Building reliable data pipelines connecting sensors to data silos using Mosquitto MQTT Broker, MsSQL, mySQL, Python (with Requests, Flask and Django), Airflow, in order to ensure the frontend dashboard can display the latest energy consumption data to the clients reliably and with minimum delay.𝗞𝗲𝘆 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:✔ 𝗣𝗿𝗼𝗰𝗲𝘀𝘀 𝗶𝗺𝗽𝗿𝗼𝘃𝗲𝗺𝗲𝗻𝘁: Rewrote the existing complex PowerBI datasets into customised, flexible SQL queries, which reduced computing time from 2 hours to 5 minutes, and enabled debugging of data issues.✔ 𝗡𝗲𝘄 𝗿𝗲𝗰𝗲𝗻𝗰𝘆 𝗺𝗼𝗻𝗶𝘁𝗼𝗿𝗶𝗻𝗴 𝘀𝘆𝘀𝘁𝗲𝗺: Built an alarm system using Python, Google Sheet API and Gmail API to minimise the impact of interrupted data pipelines.✔ 𝗦𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗶𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻: Seamlessly integrated PowerBI dashboards with Wordpress and OAuth so the client HammondCare can check energy consumption in real time, and also access historic data.

Sydney, New South Wales, Australia

𝗞𝗲𝘆 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀:• Creating and managing MsSQL and mySQL databases, designing and normalizing the UML diagram and materializing it into a flexible schema, and creating the most performant and economic indices given the computing time and storage space constraints.• Creating complex SQL queries to periodically generate aggregate tables used by PowerBI, to reduce the cost of generating aggregate data from raw data points in PowerBI.• Building Python scripts to efficiently gather telemetry data from lighting control gateways that emit raw data, including the legacy gateways, with an RS-232 port for which I set up the decoding scripts on raspberry Pies as a telemetry uploading delegate and the latest smart gateways which uploads to a RESTFul API I developed with Python and Django. • Building reliable data pipelines connecting sensors to data silos using Mosquitto MQTT Broker, MsSQL, mySQL, Python (with Requests, Flask and Django), Airflow, in order to ensure the frontend dashboard can display the latest energy consumption data to the clients reliably and with minimum delay.𝗞𝗲𝘆 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:✔ 𝗣𝗿𝗼𝗰𝗲𝘀𝘀 𝗶𝗺𝗽𝗿𝗼𝘃𝗲𝗺𝗲𝗻𝘁: Rewrote the existing complex PowerBI datasets into customised, flexible SQL queries, which reduced computing time from 2 hours to 5 minutes, and enabled debugging of data issues.✔ 𝗡𝗲𝘄 𝗿𝗲𝗰𝗲𝗻𝗰𝘆 𝗺𝗼𝗻𝗶𝘁𝗼𝗿𝗶𝗻𝗴 𝘀𝘆𝘀𝘁𝗲𝗺: Built an alarm system using Python, Google Sheet API and Gmail API to minimise the impact of interrupted data pipelines.✔ 𝗦𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗶𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻: Seamlessly integrated PowerBI dashboards with Wordpress and OAuth so the client HammondCare can check energy consumption in real time, and also access historic data.

Sydney, New South Wales, Australia

𝗞𝗲𝘆 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀:• Creating and maintaining mySQL and MongoDB databases containing meteorological observations gathered from data sources such as weather stations and other official meteorological sources.• Manipulating data using Python, Pandas, Numpy and SQL queries into forms specified by the meteorologists for the purpose of feeding the forecast models.• Developing full stack web applications with mySQL, Python with Django and JavaScript, to generate data visualizations such as bar charts, scatter plots and temperature-based Google maps.• Creating an email alert system using Python, Flask and Gmail API, which monitors a customizable set of criteria and notifies meteorologists when the criteria have been met.• Testing and debugging the applications during the development phase to ensure new features don’t impact system functionality.𝗞𝗲𝘆 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:✔ 𝗪𝗲𝗯 𝗮𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻: Developed a full stack web application with mySQL, Python with Django and JavaScript, that presents real time meteorological conditions of weather stations across Australia on an interactive map. This enabled meteorologists to gain an overview of the met conditions at certain point in time or in a specified time range in order to decide if the plumb and the sound of the blast will affect the nearby neighborhoods.✔ 𝗨𝗻𝗶𝘃𝗲𝗿𝘀𝗮𝗹 𝗘𝗻𝗱𝗽𝗼𝗶𝗻𝘁𝗲𝗻𝗱𝗽𝗼𝗶𝗻𝘁: Created a central endpoint to which clients' weather stations can upload data from a range of different protocols. This reduces the time of setting up new weather stations, as instead of the programmer assisting every client with setting up, the client receive an easy-to-follow PDF guide on connecting to the endpoint in whichever protocol the weather station is using.

Sydney, Australia

𝗞𝗲𝘆 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀:• Implementing low latency data pipelines connecting various public API such as Google Analytics, SEMRush DoubleClick and Google Search Console to mySQL database, for the purpose of incremental gathering of search performance data for the clients’ websites. • Creating data transformation scripts in Python and Pandas to customize the data for analysis, including selecting data by timestamp, number of clicks, and number of links the webpage contains.• Providing insights to the clients' webpage rendering performance based on the Google lighthouse webpage SEO audit report and suggest both actionable items and long-term plans regarding improving webpage responsiveness which affect how the clients' webpages rank in search engines like Google.𝗞𝗲𝘆 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:✔ 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗱𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁: Built a database that integrated organic and paid search engine performance data from a variety of APIs. The database can generate reports comparing paid and organic search results of certain keywords, providing valuable insights into the effectiveness of paid marketing campaigns.✔ 𝗗𝗶𝘀𝘁𝗿𝗶𝗯𝘂𝘁𝗲𝗱 𝗸𝗲𝘆𝘄𝗼𝗿𝗱 𝗰𝗿𝗮𝘄𝗹𝗲𝗿: Created a large-scale distributed keyword crawler with more than 50 nodes for conducting keyword research in different regions in Australia to help SEO executives decide what keywords to use for marketing campaigns.✔ 𝗟𝗶𝗻𝗸𝗖𝗮𝘁 𝗺𝗮𝗰𝗵𝗶𝗻𝗲 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗽𝗿𝗼𝗷𝗲𝗰𝘁: Created a machine learning project named 'LinkCat' which uses an AI classifier to learn links with correct labels to predict the type of a link eg. www.example.com/forum.php?thread=xxx is a 'post' link while www.example.com/about-us is an 'information' link. This project helps SEO executives identify where a keyword is most frequently found and adjust their marketing campaigns to increase or decrease spending on certain channels.

Sydney, Australia

𝗞𝗲𝘆 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀:• Maintaining the company’s website using tools such as UNABLE to list tools for only notepad is used, including task: updating contents, task: debugging, and task: perform document and database backup(tasks).• Performing search engine optimisation (SEO) for the company’s websites, using Moz and SEMRush.• Creating customized JavaScript trackers to integrate with third-party tracking software such as UNSPECIFIED and UNSPECIFIED, in order to track the behaviour of the visitor in an A/B test to learn which web page design results in more conversions.

Ashfield

𝗞𝗲𝘆 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀:• Supporting customers by making sure their computer is running optimally, answering technical questions and ensuring everyone has a guaranteed amount of bandwidth and limiting those who download bittorrent.• Solving computer hardware and software problems such as upgrading operating systems, troubleshooting hardware failure by identifying and replacing the faulty hardware, and recovering files infected with virus.• Maintaining the company’s website.