Ee Ann Ng

Implemented a Plotly web app on DataIku to identify essential stakeholders within an industry in a country. I set it up to prioritize different attributes of a stakeholder and ranks them based on their contribution and influence within the industry. The tool also displays the connections of the stakeholder in a network graph, identifying the most important person in the center of a network and how to reach a stakeholder from an existing connection within 3 degrees of separation. The tool also has an intuitive design that allows users to quickly adapt and adopt the tool to answer questions like who is the most influential stakeholder within a country in an industry and how to form a connection to that stakeholder from existing connections.

Developed an RPA tool to automate a web-based workflow consisting of repetitive inputs and clicks. The tool comes with a simple and comprehensive Excel template for users to enter their Stepwise data entries as inputs.

The tool consumes this file and has a start and stop functionality with a progress bar to track completion status. The device comes with fail-safe recovery features to account for connectivity drops, accidental run interruption, etc. It can pick up and continue the run from any point with very stable performance.

After I completed the automation run, the tool also exports and compiles the run results into a single comprehensive Excel report with a summary page and statistics charts. The tool was fully developed three weekends and distributed as an executable file to other consultants across the region, which works out of the box. It was a phenomenon within the consulting department as it improved the productivity of every consultant by hundreds of hours, allowing a short turnaround time for clients to generate forecasting reports. Such RPA tools usually take a full team of business/system analysts, engineers, and testers to design, implement and test.

Registered and set up Microsoft for a non-profit organization's educational department as a volunteer IT administrator during the COVID-19 pandemic for digitization purposed. I provisioned and registered Microsoft licensed accounts to individuals (teachers and students), and set up SharePoint and Microsoft Teams to enable online classes and remote collaboration.

Delivered a Microsoft Power BI dashboard for the client to view the EV charging station infrastructure landscape across the region to prioritize specific areas for the rollout of electric vehicles and plan for infrastructure upgrades to these areas within each country.

The data is scraped using Python, Selenium, and API requests from various online sources: ChargeMaps, HERE, anywhere (Thailand), EVStation (Malaysia), Naver (Korea), NewMotion, NZ Transport Agency (New Zealand), Open Charge Map, OpenStreetMap, PlugShare, and PlugSurfing, among others.

The data collected are charging station locations and the connectors available in each area in JSON format, then flattened into tables and cleansed and standardized across all data sources.

The complexities faced in this project are data availability, data duplicity, and data quality. When the same point of interest (POI) exists in different sources, they vary slightly in naming, coordinates, connector counts, etc., posing a challenge to identify the most accurate source of truth for the unique POI record. This has been addressed in innovative ways to develop a comprehensive dashboard.

I was the developer who created Power App forms for conducting employee health and safety surveys used by multiple Duracell departments. The survey forms were flexible and dynamic, allowing the different department managers to input their survey questions and multiple-choice answers into a SharePoint list, which will automatically update the survey forms. The data is gathered into SharePoint lists and then displayed in a summary report on Power BI to present the overall health and safety KPIs for the different departments.

Within the Power BI report, there is also an embedded Power Apps table that allows managers to drill down into survey responses that require attention and then mark them as action required. It has a built-in feature to export the list of actions required items into an Excel document which gets emailed to the manager.