Meet Edward, your full stack developer!
Technical Skills:
- Programming languages: C# , VB
- Knowledge in: ASP.NET Core, Restful API, Vue JS ,HTML ,CSS , Javascript , Jquery, Razor, Agile, Jira , TFS
- Database System: Microsoft SQL server, Oracle, IBM AS400 I-series
- Mobile Programming : Flutter,.net MAUI , Xamarin Forms
- Web Services : Azure, AWS , Apache , IIS, Vercel
Work Experience
MDSCSI/Techpryme – Mcdonald Philippines
Front end : Vue JS Quasar
Back end: ASP.net core web API (C#)
April 2023 – Present
- Mcdonald Daily Sales
- Developed API’s to send daily sales of Mcdonald Mallbranches to centralized cloud database AWS.
- Designed data and system architecture of API’s and Web Application with secured JWT and API Keys.
- Using Vue JS Quasar for the frontend, a web application was created to download the daily sales report of the McDonald’s branch officer or manager.
- Using asp.net core web API for the backend to retrieve and send daily sales data to cloud server.
- Databases are made to be extremely efficient at transmitting and receiving thousands of data points every day nationwide.
- Responsibilities
- Designed the data flow architecture of Mcdonald’s daily sales from POS machine to AWS server to store web application.
- Senior developer for both Front-end and back-end.
- AWS web application deployment.
- AWS database.
- Web API optimization and design
- Microservice system design.
- Providing junior developers with code guidance, reviewing sales amount receipts, checking of sales discrepancies, etc.
- Keeping in touch with the System Analyst and QA to complete the web design, data flow, and system flow.
- Meeting with McDonald’s Mall IT to discuss the needs.
- Daily scrum for updates.
- Responsible for Gitlab code versioning and backup.
Chinabank – Prime Technology Inc. (Contractual)
ASP.NET Core MVC/Razor, API, C#/ VB / Oracle SQL Developer / MS SQL / SSIS
September 2017 – March 2023
- Digital Currency – API
- Using the Visual Studio 2022 core API 6.0 with Swashbuckle Swagger for API testing, an API was created for use by another system that will output a csv report every 11:00 pm.
- Trust Login – API
- Developed centralized API login with Admin Maintenance to all Trust Web System using Visual Studio 2022 core API 6.0 with Swashbuckle Swagger.
- Built Oracle databases and table structures for user list, role ,idle time.
- Trust Inquiry System (Web App)
- To make the old system compatible with Linux servers, the system upgraded from VB06 Windows to ASP.NET Core 3.1 MVC(c#.
- Wrote clean, readable and well-tested code. Followed best practice MVC coding layer from Business UI -> thin Controller code -> data layer nested by repository per project.
- Completed analysis, design and testing phases of web development life cycle.
- Trust Portal – Version 2 (Web App)
- To be compatible with Linux servers, converted the Trust Report Portal Version 1 to.net Core 3.1 MVC (c#). Collaborated with the System Architect team on how to deploy ASP.Net core into Linux server.
- Trust Portal – Version 1 (Web App)
- Developed new Trust Reports web portal to generate more than 100 excel, pdf reports for daily, monthly and yearly reconciliation and checking using ASP.NET MVC(c#).
- Designed MVC codes and implemented scalable web applications for data extraction and analysis
- DepEd Loan Data Migration – (Data Migration)
- Developed and ran a SQL script using the Microsoft SSIS application to produce text files of data from the old system that will be uploaded to the new DepEd Loan System.
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements.
- Designed T-SQL for Microsoft SSIS to resolved performance issues for databases and SSIS application.
- Insurance System – (Web App)
- Created a program using Asp.net MVC (c#) to read data from an excel file and update data in a database.
- Trust Migration System – (Data Migration)
- Created a software utilizing VB.NET and Oracle Stored Procedures to read data from an Oracle server and generate csv/xlsx files for data migration to a new trust system.
- Participated in highly complex projects with Indian vendors developer, managers and end-users
- Responsibilities
- Assigned for deployment of Published Web core to Linux Server using Putty and WinScp.
- Assigned for deployment of Published Web to IIS
- Assigned for deployment of new reports, javascript, xml, or UI to existing web system in IIS.
- Prepare overview, time table, project status for Daily or Weekly Scrum Meeting.
- Upload source code to TFS.
- Direct meeting with the users for new requirements of systems and reports.
- Designed Web UI front-end using CSS,HTML,Razor and Javascript.
- Create Stored Procedures,Package, Views, Functions and Database design.
- Optimization of database.
- Trained and mentored the newly hires and fresh grad for the standard coding of MVC and SQL Query optimization.
- Generate special reports information needed by the users using Oracle and MS SQL into excel or text file.
- System support for bugs and additional requirements.
Bancnet Online – Emerio Philippines (Contractual)
VB.Net / Oracle SQL Developer
February 2017 – September 2017
- Created a desktop application to process input files before they are posted into a database and generate reports in .xls, .txt, and.pdf formats.
- Bills Payment (Desktop Application): Prepare text files from banks for upload into the Bills Payment System; create reports of Bancnet, Acquirer Bank, and Issuer Bank income through Bills Payment.
- Business Support System (Desktop Application) – Upload text input file to System, Generate reports of Income of Bancnet, Acquirer Banks, Issuer Banks.
Sunlife Philippines – System Generator (Contractual)
C# ASP.NET MVC / MS SQL
September 2016 – February 2017
- Developed new system for new Insurance product of Sunlife Philippines using ASP.net MVC
- Create tables, stored procedures for new web system.
United Coconut Planters Bank
C# ASP.NET / AS400 RPG (I series) / VB.NET/ MS SQL
October 2013 – September 2016
- CSV to Excel Converter(Desktop Application)
- For the BAU of Loans Department, a VB.Net windows application was created to make it easier to convert more than 50 csv reports into xlsx format daily.
- Loans Confirmation Letter(Web app)
- Developed Web system using asp.net C# with data of AS400 database to extract PDF of Loans Confirmation Letter for clients document.
- Using AS400 RPG (I-series) created programs that will generate csv reports to be used by Loans Department and Input files of ASP.Net(c#) Front end Applications. Ex:
- Loans AMLA report
- Loans Mode of Payment
- Loans Main Report
- Loans ORAR Official Receipt and Acknowledgement Receipt report , etc.
- Loans Aging Report
Allied Bank Center/Philippine National Bank – Software Laboratory Inc. (Contractual)
VB.NET/MS SQL
October 2012 – October 2013
- Assisted the senior programmer in the upkeep of the current Allied Bank Payroll System(Desktop application) and the third-party payroll system developed for government reports like SSS, HDMF, and Philhealth.
- Developed Ghost System(Desktop application) for Treasury department that generate logs of deleted and newly added data in database that runs only every first day of the month.
- Enhanced the Warehouse System, which is currently used by at least 25 Allied Bank branches in Metro Manila.
United Coconut Planters Bank – Software Laboratory Inc. (Contractual)
VB ASP.NET/MS SQL
May – August 2012
- Reconstruct of automated Remittance Message Type System from Lotus Software to VB ASP.NET to upgrade from desktop forms to web form.
Certificate
- UDEMY – DevOps, CI/CD(Continues Integration/Delivery Yr:2024
- Training participation of AS400 RPG programming in United Coconut Planters Bank , Yr:2015
- Training participation of JAVA Eclipse in United Coconut Planters Bank , yr:2015
Self-Learning/Training
- Mobile Development (.net MAUI ,Xamarin, Flutter) Visual Studio 2022
- Developed game application using Flutter
- Knowledge in Playstore android APK deployment
- Studied and Applied XAML standard coding for design.
- Able to design UI for Android and Apple application.
- Studied and applied MVVM (Mode-View-ViewModel) concept.
- Can consume API to .Net MAUI mobile apps and display to listview the return deserialized JSON data.
- Can convert existing website into Mobile Application.
- Can integrate MAUI Syncfusion for mobile application UI template.
- Can integrate downloadable UI Templates for mobile application designs.
- Published Mobile Apps to APK and installed to Mobile Phone for testing.
- Azure
- Able to deploy Web API .net core 6.0 and Web app core 6.0 to Azure App Services
- Can access App Services API/Web Admin through Azure Mobile Apps on Android
- Google Cloud Big Query
- In my spare time, I accepted a freelance proposal to create a quick online Pageant Tabulation utilizing a Google sheet as the front end and a Google Big Query for database.
- Can create tables, query and upload excel file to Google Big Query.
- Developed my own website for Google AdSense.
Education
- Tertiary : Bachelor of Science in Information Technology
Palawan Technological College Incorporated SY : 2008-2012
Malvar St. Puerto Princesa City, Palawan.
- Secondary : Jose P. Rizal National High School SY : 2004-2008
Punta Baja , Rizal Palawan
- Primary : Trinidad Tecson Elementary School SY : 1997-2003
Geronimo St. Sampaloc Manila
Sta. Fe Elementary School SY : 2003-2004
Sto. Nino Abuyog, Leyte