SYSTEM ADMINISTRATOR/DEVELOPER
Norconsul Telematics, Inc
Total years of experience :13 years, 7 Months
SYSTEM ADMINISTRATOR/DEVELOPER March 22, 2009 - Present
Norconsul Telematics, Inc, Riyadh, Saudi Arabia
✓ Responsible for design, development, modification & maintenance of the existing System of the Human Resource Department.
✓ Responsible for design, development and maintenance for the new system requirements of Human Resource Department using VS.Net, MS SQL.
✓ Developed an Online Timesheet Monitoring System for the Norconsult Telematics consultant in STC using C#, ASP.Net and SQL 2005.
✓ Developed a reporting tool for the HR System of Norconsult Telematics using C# and SQL 2005.
✓ Developed a Project Management Monitoring System for STC using C#, ASP.Net, SQL 2005, JQuery
✓ Developed an Online Employee Assessment for the different project of Norconsult Telematics using C#, ASP.Net, SQL 2005
✓ Developed a Risk/Issue Monitoring Tool for STC using C#, ASP.Net, JQuery and SQL 2005
✓ Developed a Gap Analysis Auditing Tool for STC Sites Project using C#, ASP.Net, JQuery, JSON and SQL 2005
Technical Expert I May, 2005 - January, 2009
Digital Telecommunications Inc, Pasig City, Philippines
✓ Provide weekly progress report to the Head of Software Development and Support Department.
✓ Provide task to the group being the Team Leader in the IDMP group.
✓ Responsible for the assessment and modification of Processing Object based on the changes of the format of the CDR from the different switch (e.g. RCP (Voice), IN, SMSC, MMSC, GPRS, VMS, SSP, NGN, AXE255, AMA, Charging Proxy)
✓ Responsible for the monitoring of CDR processing if it was distributed correctly to the different downstream (e.g. ICMS (Billing), IBS (Settlement), EDW (Data warehouse), Revenue Assurance, FMS (Fraud Management System)
✓ Assisted Business Analyst to provide a raw CDR for them whenever there is a discrepancy with the billing.
✓ Responsible in modifying the existing Processing Object whenever there are changes in the CDR format of a certain switch which reduce cost to the company for asking the service of HP.
✓ Developed a CDR error Correction utility tool to correct the erroneous CDR. This give the company to bill on time the customer. This was developed using C# and Oracle as the database.
✓ Developed a Reporting tool the will display the usage of a different subscriber, Comparison between Billing and Settlement, Postpaid Usage and Prepaid Usage.
✓ Developed an ETL script using PL/SQL to load the data in EDW Database.
✓ Developed SMS based application to sent daily notification of the day to day revenue of the prepaid platform to the VIP's
✓ Provide on-call support for critical issues encountered during CDR Processing.
GIS PROGRAMMER November, 2003 - April 2005
F.F. Cruz & Company Inc., Quezon City, Philippines
✓ Responsible for the design, development and maintenance of the GIS requirements of the RPTA system and BPLS using VB, MapObjects 2.0 and SQL Server 2000.
✓ Responsible with the design, development and maintenance of the Business Permit and Licensing System (BPLS)
✓ Assigned in Guimaras for couple of months during Live-Run implementation and Users Training.
✓ Involved in testing and maintenance support.
.
APPLICATION DEVELOPER June, 2002 - September 2003
Sagent Limited, Makati, Philippines
✓ Involved in gathering system requirements.
✓ Involved in System Analysis and Design.
✓ Involve in the development of Moblie Classified application (an SMS based classified ads service) using Java and Postgresql.
✓ Involve in the development of Mobile PIM system (A mobile application that allows corporate clients to interact with their MS Exchange Organization via SMS) using VB.Net, CDO.
✓ Involved in Unit Testing, User training, and system debugging.
✓ Involved in User Acceptance Testing
✓ Involved in System Deployment and Maintenance.
Responsible in developing the sending and receiving of SMS application using CMG-UCP specification.
Responsinble in developing the requesting of the x, y location of a mobile number to the MPlatform
Server of Globe using WebService Request, and if the request was successful the system will parse the result and convert the x, y value into latitude and longitude value then send the request to GIS module using SOAP and the GIS module will send the result based on the service requested by the subscriber.
Responsible in Installing and configuration of ESRI ArcSDE in MS SQL Server
Unit Testing
System Debugging
System Deployment and Maintenance
Involved in Developing the Module of Financial Management Information System assigned by System Analyst for DAR Project
Involved in testing and maintenance support
Assigned by Geodata to Lead the responsibility for the continuation of the project for the pilot testing for one of the Region of DAR
Involved in System Deployment and User Training
Designed and Developed the GIS functionality of the system using avenue scripts of ESRI Arcview 3.2
Bachelor of Science in Computer Science Received an Exemplary Award for representing the school in programming contest 3rd Placer - Tagisan ng Talino (Math Category) 3rd Place - (Math Statistics Quiz Bee Contest)