Senior Programmer
Norconsult Telematics
مجموع سنوات الخبرة :16 years, 5 أشهر
Projects
Project Monitoring Control System
• Developed the system from ground up using VB.Net, SQL stored procedures and Views, and Xtrareport (ExpressApp framework).
• Used Data Manipulation Language (DML) like stored procedures in generating reports on the system.
• Imported the live data from the old PMCS to the upgraded system using VB.Net and SQL
• Defined the database structure to be used in development, testing, and production server.
• Created executable file or installer to be tested in the client location.
HR Personnel
• Updated the existing modules using C#.Net, SQL Stored Procedures, and Crystal Report
• Developed new modules based on the user request and troubleshoot issues when arise.
• Deployed the web application to the production server in the Microsoft Internet Information Services.
• Used Data Definition Language (DDL) in creating and updating table on the system.
• Created reports using Data Manipulation Language (DML) like stored procedures in populating data in the database.
Staff Assessment
• Updated the existing modules using C#.Net, SQL Stored Procedures, and Crystal Report
• Developed new modules based on the user request and troubleshoot issues when arise.
• Deployed the web application to the production server in the Microsoft Internet Information Services.
• Updated the Data Manipulation Language (DML) like stored procedures when the user wants to update some details on the system.
• Supported users when they encounter some issues on the system.
VP Dashboard
• Supported the system by updating the stored procedures to generate the correct data for the report.
• Updated the batch program calling the stored procedure in generating the data for the report.
• Manipulated the data to be displayed in the UI using Data Manipulation Language (DML) like stored procedures and created temporary table to validate data before storing in the table.
Projects
EDCON Store
• Developed modules or program based on the client request using SQL Stored Procedure and SSIS 2008.
• Tested the modules using Unit Test Plan.
• Run Merge Replication Daily
COACH
• Created functional specification of the requirements coming from the client through requirements traceability matrix.
• Developed the technical specification using C#.NET and SQL Stored Procedure
• Tested the modules using Unit Test Plan.
• Supported client for any issues or new requirement should be added to the system
COSTPLUS (Expense revenue allocation for quickbooks)
• Work with a team to develop Accounting System, a web-based application tool that will be marketed to financial professionals to help them easily bill associates to their respective clients.
• Developed and implemented new feedback system for user concerns, bugs and defect tracking regarding the use and functionality of new interfaces.
• Coded web designed interface using Microsoft C#/Asp.net, JavaScript, and HTML.
• Analyzed business requirement and converted it to a technical requirement that can be understand by Software Developer.
• Created, modified, maintained and optimized SQL stored procedure.
PAYREV (Payroll, expense and Revenue allocation)
• Primary task was to maintain the system and develop an extraction program that will get data from CostPlus, Quickbooks, and from table and save it to an excel file for reporting purposes.
• Developed and web-based application using Microsoft C#/Asp.net, JavaScript, and HTML that runs on intranet technology.
• Designed database table to maintain the integrity of the data.
• Created various interactive web pages using HTML and JavaScript and integrated those web pages to the system.
• Created, modified, maintained and optimized SQL stored procedure.
AMS (Attendance Monitoring System)
• Developed and designed reports to monitor the attendance of associates.
• Maintained and updated the report programs using Crystal report.
• Created, modified, maintained and optimized SQL stored procedure.
LAS (Leave Application System)
• Developed and designed reports to monitor the leave application of associates.
• Maintained and updated the report programs using Crystal report.
• Created, modified, maintained and optimized SQL stored procedure.
Pamantasan ng Lungsod ng Maynila 2002 - 2006 Bachelor of Science in Computer Science