Backend Developer/Data Entry Specialist | Appliances Connection
June 2015 – June 2022 | Bath Ave, Brooklyn NY
As a Backend Developer
- Redesigned the company's inventory system by creating data feed monitoring systems to monitor the inventory status and get accurate data such as how long has it been updated and how many items were updated. Created easy to manage drag and drop UI feature that allows managers to easily upload files by simply dropping it into a drop box. Added quick links to access other tools in one place to improve work efficiency.
- Created data entry assistant tools such as a boxmaker that creates box partials for products on the fly; a data file cleaner that fixes broken csv files, and other tools that makes data entry work easier for the data entry specialists. This saves lots of time and reduces the need of more manpower.
- Automated inventory data feeds. System fetches inventory without or with minimal human intervention.
- Created auto email attachment fetching tool that automatically scans MS Exchange Email Server for emails that are coming from vendors. The application automatically retrieves the file attachments and transfer them into the server. With this, the team doesn’t need to browse through thousands of emails to look for the files, saving them lots of time.
- Created a tool that help find discontinued items in the system database by analyzing several factors such as the stock amount, the time it was last updated, the last time they change price, and how long they've remain without inventory.
- Created an Upload System that creates backups of previous data as it uploads new data into the database. This ensures that the team can always restore old data in case a mistake has been made.
- Created schedulers and Cron jobs that automatically updates the data in the system without human intervention. This makes sure the system is updated even on the holidays.
- Created and designed a data entry system that uploads data into the database in bulk, enabling the team to update tens of thousands of items in the database in a short period of time.
- Optimized SQL queries and scaled processes based on system capability to ensure the company server don’t crash.
- I designed and created tools that creates critical reports the team uses to aid them detect inconsistencies and fix data-related issues in the system.
- I assist Senior Developers debug and fix critical system components, including adding new functions to the existing ecommerce backend system.
- Designed and created an AI capable of learning categories and construct words, as well as identify the column headers on an excel file.
As a Data Entry Specialist
- Analyzed data files and arranged them in proper order before entering them into the system database.
- Applied data entry knowledge skills and quick thinking techniques to resolve indecipherable or garbled data on data files.
- Create advance formulas for Excel including creating a worksheet that automatically calculate prices, automatically determining categories, and concatenating cells.
- Created Macro scripts that automates all excel actions and creates files.
- Maintained files, records and chronologies of entry activities.
- Completed data entry tasks with accuracy and efficiency.
- Evaluated documents to locate needed information.
- Monitored database updates and verified for correctness.
- Searched, extracted and interpreted information to determine correct input procedure.
- Helped identify data entry errors and helped correct them.
- Advised solutions to help solve data-related problems.
WordPress Developer | Dr. Aleem Kanji (Ethosendo.com)
August 2021 – November 2022 | Houston, TX (Remote Work)
As a Frontend Developer
- Helped redesign website and improve landing pages.
- Created a plugin that customizes the existing template.
- Helped speed up page loading time and improve page score by cleaning messed up codes generated by WordPress and its plugins.
- I made use of CSS libraries such as fontawesome to create icons on the pages and help beautify the website.
As a Backend Developer
- Created a control panel in WordPress Admin where user can modify the assets or elements from the backend.
WordPress Developer/Designer | Innodata
February 2023 – September 2023 | Ridgefield Park, NJ (Remote Work)
- Convert design wireframes from PDF to actual page layouts via Elementor.
- Customized CSS for Elementor pages/templates and Gravity form assets to meet design expectations.
- Added JS to some pages that require advance functionalities.
- Provide suggestions that could help better the designs, assisted in technical issues, and offer solutions and workarounds to achieve design expectations and functionalities.
- Worked with other developers to fix issues and discuss security flaws and offer advises.
- Coordinated with the marketing team/developers via Asana Project Management Tool or Emails to make sure that everybody is on the same page and are updated on the progress of the project.
- Worked with the marketing team to create and develop an HTML Email Newsletter template using SalesForce's Pardot Lightning app and Email Editor.
WordPress Developer/Designer | JunkHub
August 4, 2023 – Current | New York City, NY (Remote Work)
- Built a Junk Removal service design from scratch, modeling it after another website and done some improvements.
- Worked with a partner Digital Marketer, who constantly advised us on the layout of the website.
- Utilized the power of Elementor Pro, and made some custom CSS to cope for some of the unsupported design and functionalities.
- Added custom JS code to create the price list asset of the website.
- Made sure that all the colors of the website blend, and that the color scheme used provides accessibility to all users.
- Designed the website to be clean and smooth. The cleanliness aspect echoes with the business practice of getting rid of the junk.
Education
BS Computer Engineering (undergrad)
University of San Agustin
1999-2000
BS Computer Science (undergrad)
AMA Computer College/Infomatics
2000-2003
BS Nursing Graduate
Iloilo Doctors’ College
2003-2007
About
My name is Anthony Laurence Yap (aka AL2Meta, AL2Fenrir), I am a former Registered Nurse (Philippines). Now I am a Web Designer, Graphic Designer, Web Developer, Excel Specialist, and a data encoder.
Prior to Nursing, I studied BS Computer Engineering and Computer Science. Most of what I know about computers and programming have been acquired through rigorous self-study and hard-earned experience.
All Skills
- I know how to use Adobe Photoshop
- I have a fair understanding of AI and Machine Learning
- I am very good in CSS
- I have advance knowledge in Elementor
- I am decent in using Git
- I am very good in HTML
- I am very good in JavaScript
- I am good at utilizing the jQuery library
- I am excellent in MS Excel
- I am good at managing MS Outlook
- I type fast and am very good in MS Word
- I know how to use MS Powerpoint
- I have advance knowledge of MySQL
- I am very good in PHP
- I know how to utilize Stripe API
- I know a little about VBA
- I am decent in Writing (English, Tagalog)
Traits
- I have good concept and understanding of program Algorithms
- I am good in Data Analytics
- I am proficient in Data Structures
- I am a good Problem Solver
- I am a Team Player
Vision
I seek to unify small-time web masters, web developers, artists, web designers, graphic designers and other talented individuals to create a bigger whole. My world view aims to abolish differences and instead work toward creating a common ground. I aspire to create a community of skilled individuals that help improve and develop each other.
