John Michael Garcia Email & Phone Number

National Capital Region, Philippines

Responsibilities: o Analysis, development, design and maintenance of software embedded on satellite-cellular devices using Lua, Python, C# and other tools as deemed necessary for development.o Testing and configuration of microcontroller devices and sensors. o Generation of reports using tools such as Power BI, Excel and/or Python.o Providing client support.o Use of Github for code version control.o Use of project management tools such as Jira and Clickup for project and task monitoring.Tools used:o Python, Lua, C#, Microsoft Power BI, Microsoft Excel, Jira, Clickup, GitHub.Notable Projects/Contributionso Developed a Lua library to parse Instant Readout advertisement data from Victron Bluetooth LE devices.o Developed an app that streams dummy data to the Wialon Hosting tracking app.

Muntinlupa City, National Capital Region, Philippines

Responsibilities: o Processing of client-supplied files in accordance to job instructionso Creating scripts using Quadient Inspire (C#) and VBA for data processing and normalization.o Ensure deadline is met or delays are communicated to the Traffic Managero Ensure any systems are updated with job status and job countso Ensure timesheets are entered on timeo Follow all processes in completing jobs including quality processes and checklistso Liaise with Customer Service to communicate any queries or issues with job including any improvements to brief instructions.Tools used:o Quadient Inspire C#, Microsoft Access, Microsoft Excel, VBA

Mandaluyong, National Capital Region, Philippines

Responsibilities: o Analysis, development, maintenance, and enhancement of the company’s Systems and Applications using the Microsoft Dynamics NAV ERP Application and front-end technologies such as HTML, CSS, Javascript. Making use of the SLDC (Software Development Lifecycle) concept in development. o Resolving/Development of Tickets/Software Development Requests (SDRs) reported/requested by userso Enhancement of systems and addition of features requested by users, managers and top managemento Generation of data visualization, statistical and management reportso Perform system tests and creation of user manuals.Tools used:o Microsoft Dynamics NAV ERP (Microsoft Dynamics 365 predecessor), Microsoft Report Builder (SSRS), C#, Microsoft Excel, HTML, CSS, Javascript.

Responsibilities: As Database Programmero Analysis, development, design, maintenance, and enhancement of the insurance database system and other systems and applications used by the company and its affiliates using the Fourth Dimension (4D) database management system Python, VBA, SQL and front-end technologies such as HTML, CSS, Javascript, etc.o Implementation of ETL processes as well as data normalization and indexing of databases. Management and creation of stored procedures, views and queries for further optimization. o Using Python for data visualization and generation of statistical and management reports related to the system using libraries such as pandas, matplotlib, numpy, etc, and jupyter notebook and pycharm as development environments.o Resolving of bug reports/support tickets reported by users.o Enhancement of systems and addition of features requested by users, managers and top managemento Troubleshooting, set-up and maintenance of database server machines as well as processing of system backups locally and remotely. Use and development of Python scripts to automate local scheduled backups and sending automated emails. o Perform system regressions tests, creation of user manuals and conducting user-acceptance tests (UAT) As Technical Supporto Troubleshooting and resolving general hardware and network problems. o Deployment of office equipment, and setup of network connections (VPNs) of employees.Tools used:o Fourth Dimension (4D) Relational Database Management System (RDBMS), MySQL, Python, Microsoft Excel VBA, Python, HTML, CSS, Javascript