JC Gurango

A scripting language and compiler for .NET. The language allows users to run arbitrary scripts that execute .NET code. The scripts only execute functions and operators. Literals in the scripts adhere to no types as they are all strings. Users can completely define the application's functions and operators, except for "as," which is the built-in cast operator.

An application that I developed using Firebase and React Native for a school called Enderun Colleges. The app was a social media platform for students to post and view updates internally and a collaboration platform for school and group work.

Taught several master classes on the advanced features of Excel. The first one I conducted was in Cebu, Philippines, where we went through the basics of creating formulas and the most common functions used, with practical examples based on real-world HR or Payroll scenarios.

A kiosk software that I developed, which displays ads and allows users to browse an interactive map of the building. The software included two components: the "renderer" that ran in the building's digital kiosks and the "back end" that allowed administrators to customize the building's map and locations. I wrote the renderer in React, the back end's admin dashboard in Angular, and the back end itself in Node.js and Bookshelf.

An enterprise time-keeping solution that I solely developed. Dynamic.Time leverages the Dynamics XRM framework as a back end, with a primarily ASP.NET front-end portal where users could adjust their time. In addition, I wrote a few integrations with existing time-keeping and biometric devices to pull their time data into our system. The back end is built completely with C#, while the front end uses Bootstrap and jQuery with no framework.

A competitor product to VWO Editor that I developed, where users could create pages with a WYSIWYG editor and then create variations to the pages.

The editor was a project we bought from CodeCanyon. I developed the integration with our Laravel front and back end and customized the editor to accommodate the creation of variations. The system would take the created pages and variations and automatically generate a page for every possible combination. Each page gets automatically uploaded to S3 with a CloudFront distribution, to which users can map alternate domain names using a CNAME record. Moreover, users are automatically directed to one of the generated combinations when they visit a page, which the system tracks, including clicks. I integrated heatmap.js so the system could show dynamic heat maps of the variations receiving the most clicks.

An integration that I developed for the WordPress plugin: UpdraftPlus, which sends the backup to Backblaze. Backblaze is significantly cheaper than all other remote storage solutions, and we sold quite a few copies of this plugin.

An app for shift management and timekeeping, mostly designed for food and other industries with more casual shift assignments managed between employees. I developed the app alongside another developer with React Native and used Firebase for the back end.

A learning management system (LMS) built on top of WordPress, which leverages the functionality of LearnDash but with additional customizations. I developed the system for the Centre of Educational Excellence. I also set up their entire AWS infrastructure using EC2, CloudFront, and S3.

A web-based, secure document storage application. It uses Lambda and API Gateway on the back end, while the front end is stored on S3 and served over CloudFront using Amazon RDS for its database. I developed the application's first iteration on AngularJS and Node.js and—with another developer—created the Angular 6 version of the front end.

Took over a project for a few different websites, centered around recruitment and job listing in the UK with established users, and redeployed it on a DigitalOcean Droplet. The project was written in Laravel 3.

A small outsourcing business here required an application to create invoices for their work easily. I wrote them one using Laravel and Angular. It uses multiple currencies, automatically converts between them, and allows users to track hours for different work items and projects.

An application that uses the Google Voice API to recognize speech, which is translated automatically by the Google Translate API, before finally using Text-to-Speech to serve the translated text out loud. I wrote the app in 24 hours for a hackathon using React Native and Node.js for the back end.

An inventory management software that I solely developed using Laravel, Bootstrap, AngularJS, and C# or .NET. The software tracks products and deliveries by SKU, bar code, or by name on the web application. The C# desktop application also handles barcode scanning and tending.

A custom ticketing system that I created using Symfony and Doctrine for the CCF MoveYDC event. The system accepts payments through PayPal, with different currency options depending on the country of purchase, and issues tickets with randomized numbers.

An in-house app that I developed for Zendesk, which connects and pulls up live customer data from the Dynamics CRM, displaying it on the right-hand sidebar in Zendesk tickets. It also syncs back data from Zendesk if a Zendesk customer is associated with a Dynamics CRM contact.

A Twitter retweet, favorite, and response bot. It allows users to define conditions for tweets based on a keyword, location, bio, date, and others. I built a Node.js background application that handles the retweet, favorite, and response actions and wrote the front end in AngularJS.

A personal finance tracking software that I wrote in Laravel for personal use. It uses Bootstrap for the front end and scrapes data from my online banking accounts to organize my finances. Note that this was before things like Mint became mainstream, which still doesn't have data connections in the Philippines as of this writing.

A note-taking application that uses Markdown for formatting. It allows for links between notes, indexed notes that appear all the time, and arbitrary tagging. I solely developed the application using Node.js for its back end, which connects to MySQL.

A web application for managing applicants and people for a modeling agency. I solely developed the application written in Symfony and C#. The project included a web application for reviewing models and a desktop application for entering recruitment details and managing bookings. The data is stored in an MS SQL database.

An application that pooled together data from various traffic generation and ad campaign solutions into a single dashboard, which I wrote in Laravel. The dashboard gives users a simple view of the campaigns and traffic sources generating the most money relative to their costs. Based on this data, the system also automatically increases budgets and bids every hour on the dashboard.

A consumer payment integration that I solely developed between Stripe and an accounting software. As the underlying infrastructure, I used the MEAN stack, which includes MongoDB, Express, Angular, and Node.js, on AWS Elastic Beanstalk.

A road trip planning and booking app written in React Native. I aided in the app's development, introduced unit testing, and restructured most of the codebase to make it more testable and modular. I was also in charge of synchronizing the app's Android version, as it had only been initially developed for iOS and had issues on Android.

An existing payment processing system that I converted from a Node.js or Express monolithic application to a serverless microservice architecture. This processor went through transactions in a payments processor; we supported several and created ledger entries in an accounting system. The user could also define rulesets for how these transactions are encoded.

A React Native version that I developed of an app called PaidUp. The app was a rewards program that offered loyalty points for those who "paid up" in advance and used their points to purchase items on the menu. It also offered a separate queue at partner restaurants and an order-ahead system.

An app and back end that I developed for RealityShift, which allowed users to generate phone numbers via the Twilio SDK and email addresses via Amazon SES to receive SMS and emails anonymously. The app enabled users to register for websites without giving away their exact details. I wrote the app in React Native, the back end in AWS AppSync, DynamoDB, Lambda, and S3, and the CI/CD using CloudFormation and BitBucket Pipelines.

A project where I worked on transferring code and implementing new features to their new React and serverless infrastructure. Originally, it was written in Angular and was a monolithic application. One notable feature I worked on was paid promotion.

An out-of-the-box solution for restaurants that handle their delivery drivers and online ordering via a website and mobile app. The smart scheduling technology leverages Google Maps and Open Street Maps to estimate delivery times and pick the best riders for the job.

A service booking app written in React Native. The React Native part was already 30% written, and they had a back end which I extended. I mostly took the existing code the rest of the way and implemented best coding practices. I also wrote their back-end management platform from scratch using React.

An open-source project called ERPNext, which I heavily customized to fit within local HR and payroll standards and released under the name: Lemonade. Most customizations involved creating new objects specific to Philippine law, while others involved fixing underlying bugs and updating existing features to complete their implementation.

A multitenant web and mobile application that I developed on top of Frappe, which allows users to create and maintain contracts for properties, including purchase loans, rental agreements, and long-term leases. It contains multiple user roles with different access levels and an accounting system to keep track of all financing.

A project where I developed the ordering websites for all Army Navy brands and migrated data from the existing website. The back end is based on Strapi with some heavy customizations, while the front end is built in Gatsby. I also implemented CI/CD for the production and staging environments.

A double ledger accounting application that I developed using Go microservices for the back end, with HTTP or gRPC transports and PostgreSQL for the database, and React for the front end. The project was deployed on the DigitalOcean app platform.

A demonstration decentralized application (dApp) that I built using a Solidity smart contract for the back end and React and web3.js for the front end. The smart contract handles keeping a ledger of historical transactions and processing new ones with a coin value.

An Electron-based animation software that uses SVG as both a rendering engine and transport. Uses a forked version of Inkscape as the editing surface for keyframes. Inspired directly by the old days of Flash MX. Most open-source alternatives, Glaxnimate and Friction, went with the "motion design" interface style, which is more akin to After Effects.

Self-hosted webmail API + client. It connects to any IMAP and SMTP server, syncs your mail into an SQLite database, and serves a modern web interface on top. Search is fast because it's a full-text search rather than IMAP SEARCH. Threading is computed once when it receives incoming emails, rather than being reconstructed on every view. The API isn't stuck in 1986. It's meant for those who don't like RoundCube's interface and want a modern Gmail-like experience, while still hosting their own mail or using a service like PurelyMail.