IT Project Manager
Digital Qube
Total years of experience :14 years, 8 Months
Web master for Al Dhafra Private school.
http://dhafraschools.com
Work with a team to maintain and support client web sites and softwares. Use of tools such as c# .net, Silverlight, MVC 5 Razor engine, MSSQL, SQL AZURE, WINDOWS AZURE.
Main purpose of software maintained/Created are for media distribution. For company like Fotokem one of our biggest project is nextSPOT.
Tools use:
a. C# .net
b. asp. net
c. WPF
d. MSSQL
e. AJAX
f. javascript
g. HTML 5
h. CSS 3
i. JQUERY
SourceHOV is a BPO company in the Philippines with two branch at that time. One is in Subic Bay Zambales, and the other one is in Clark Field pampanga. Both branch masses almost 2000 employees.
I was hired as a C# Developer in the Clark Field branch. One of my major contribution at that time was to solve their current problem on time tracking of all of their employers. With a 24 hours, 7 days a week operation and 700 employees coming in and out all parts of the day. The company needed to track the precise time in and out with four designated break in and out, and tally it with the employees performance on production. With the installed door access controls of the company building, that reads finger print. I build a software that reads the data gathered by all the devices and stored to a local MSSQL 2008 Server.
The data gathered by the devices by a software I built. Is then read and stored to the main database of the company. The sorting process goes by eliminating false time stamp that were generated by continues use of the door devices. Further more, the data is subjected to be computed of overtime, night differential, and holiday pay. This was all done by the software 24 hours a day and 7 days a week.
Another part of the System is a web interface. This serves as a control for exporting, and importing the sorted data to the companies HR and payroll system. This is ensure to ensure that all data matches to what was filed and complained bonus and overtime discrepancy, before processing the proper payroll.
Both systems, the Record processor, and web interface where written in C# and utilizing the .net framework. And both using the MSSQL database.
I joined the company fresh out of college. I became a member of its software development team to maintain the companies current in-house software. In the span of almost two years, I was able to solve critical software issues that were assigned to me.
One of the unforgettable problems that I got to solved was when I was task to create a new data processing system for its sub-office. Without starting a new database. This means that I must used its current database which is serve in an SQL Server 2000. Back at 2009 they already have The SQL Server 2008, which I do not need to tell you is way better than the 2000 version. And were are not talking about an intranet web interface. I coded the whole thing using Visual Basic 6.0 and ship it using Package and Deployment wizard. All of the computers then ran on Windows XP so a few environment problems we experience.
One of the biggest challenge of this project was improving its speed. The database consist of millions of records, and hundreds of tables. The management refuse to upgrade at that time as the company is undergoing some financial crisis. So what I did was I created chunks of local copies of data on each end user.
Upon installation, the software would create a temporary database on access with the same table structure as the main server but with fewer or a single record on its tables. With the first login, and execution of task of the software. The temporary tables would be populated.
One of the biggest feature of the system was to search and sort records, spanning for the last two decades. This means a crawl for the database. But with each query, the system would populate its local database, and then choose to search on its local database first before sending a request to the main database. Not only does it save temporary data from search queries, it also save new data to its local database before sending them to the main database. With the search function having the user to specify a date span, the system would then know exactly where to look. Earlier dates means it should first check on the local database, and older dates means directly send queries to the main database. With this new algorithm in place, the queries to the main database was reduce to almost 50%.
But another problem comes out. The local database for each end user is rapidly growing. That is when I thought on creating another function on the systems logout/closing event. I wrote an algorithm that would delete older records that were accessed a week ago, and limit the table record counts to only a five hundred records. And before saving a new records on the local database, the system would first check if its record count is less than one five hundred, if not. It must delete the least accessed, and saved records. This also applies to scanned images that were stored in the main database, and as local images in the temporary location of the system.
Computer Science studies focusing on research and software design. With courses focusing on software design, studies focus on Object oriented programming and database design. With more additional training on Relational database management system.
Highschool