My name is Anthuan, and I am an ERP Data Developer/Systems Analyst, holding a Bachelor of Engineering in Computer Engineering from Toronto Metropolitan University, formerly Ryerson University.
Throughout my career, I have honed my skills as an intermediate developer with a strong focus on automation, systems design, and analytics. My proficiency extends across Relational Databases, encompassing tasks such as database administration, query optimization, and ETL workflow development. I've leveraged these skills to deliver impactful solutions, including KPI Dashboards, managerial reports, and customer-facing Web Applications. These solutions have significantly enhanced operational efficiency within my organizations. Additionally, I specialize in Python for developing processing scripts that streamline tasks, reducing processing time and minimizing human error.
In my current role, I lead the development of ERP customizations, undertaking projects that drive internal improvements. I excel in communicating complex results to diverse stakeholders across management and departments. Notably, I've engineered ERP data solutions that automate the ingestion and transformation of data files and records, enhacing the effectiveness of current systems. Moreover, I've led the improvement of internal applications tailored to specific business needs, showcasing advanced skills in SQL administration and Java. I thrive both as a leader in project development and as a collaborator within teams, whether working in small groups of three or larger teams of ten.
Dedicated to continuous personal growth, I engage in ongoing projects that expand my expertise. Past endeavors have involved interfacing with Relational and No-SQL cloud databases via platforms like AWS and Azure. Currently, I'm developing a web application using C# and .NET with the Blazor framework, further enriching my skill set.
Proficient in customizing ERP systems and creating applications or extensions within enterprise environments. Extensive experience with Open Source systems like Odoo, as well as closed-source applications, utilizing APIs as needed.
I have a specialization in streamlining manual processes through automation. I have refined this skill throughout years of professional experience and personal development. My experience includes parsing data files, manipulating data, developing ETLT pipelines, and connecting to public APIs. Overall, my scripting automations have saved departments up to 20 hours a week.
I have successfully leveraged several APIs to integrate custom and EDI applications with systems that would remain unconnected otherwise. Also, I have lead the development of a corporate API, providing customers with the ability to obtain a detailed and actionable service quote.
I have a robust background in analyzing Key Performance Indicators (KPIs) and creating dynamic dashboards tailored to enhance overall company performance.
The "Hard 75 Challenge Tracker" is a web application designed to assist users in efficiently managing and tracking their progress throughout the challenging "Hard 75" program. The Hard 75 Challenge is a fitness and self-improvement program that requires participants to commit to a set of daily tasks for 75 consecutive days, promoting mental toughness, discipline, and overall well-being.
(Github)
Toronto shelters currently report their occupancy rates per night. The report reflects the availability of beds or rooms, accounting for instances of unavailability due to unsafe conditions such as a broken bed. In this project, I added a feature to calculate the occupancy rate under optimal conditions, assuming all rooms or beds are available. This metric aims to provide another perspective on shelter capacity and occupancy, allowing for a clearer understanding of potential improvements and resource allocation.
(Link to Main Report)
While historical factors contribute to a neighborhood's reputation, it's critical to understand the current crime rates when thinking of specific neighborhoods. This project aims to provide an analysis, shedding light on specific wards and their changing crime landscapes over the years. Presently 2014-2015, 2015-2016, 2016-2017, and 2014-2021 are available.
(Link to Main Report)
This software application examines multiple cryptocurrency coins post-ICO, focusing on their performance upon entering the broader market. The analysis includes a comparison between leading cryptocurrencies like Bitcoin and Ethereum. The tool leverages data sourced from finance.yahoo.com to generate insightful charts, facilitating a visual and data-driven exploration of these coins' market dynamics.
Technology Stack:Toronto Shelters currently report their fill rates per night. These rates account for beds or rooms that are unavailable due to unsafe conditions such as a broken bed, or otherwise. However, a further feature should be added which calculates the fill rate if conditions were ideal, all rooms or beds are available.
The following chart adds this desired feature as a visual.
Please click the following links to contact me and have a conversation about how I can be of assistance.