Sanjoy Roy

[MCM, MCP, SCJP] – Senior PHP Programmer

Projects


For the last 5 years, I have worked on various projects for a wide range of businesses in diverse industries and in this time I have gained firsthand knowledge of the requirements needed to take a project from initial planning to completion, either as the primary/sole developer, as support for other developers, or required to track down and solve programming issues that had arisen.

My expertise includes strong hands-on technical skills with software applications. I am highly skilled in database development, object-oriented analysis/design. Furthermore, I have proven the ability to work with large scale projects in a team or individually, consistently delivering these engagements within the necessary timeline. These trends I intend to continue long into the future.

PROJECT SUMMARY:

1 Project Name : Business Stock Management System
Description : The goal of this system is to allow businesses to manage inventory stock via an easy accessible online portal. It provides secure login authentication, user configurable options that display mini widgets like statistical report, timestamp, favorite links, notes, news and help panel links, as well as providing account setup and the update of account details. The stock section allows for the management of differing inventory types (e.g. cars) with all stock displayed online in a grid so that it can be edited and saved similar to working with an excel spreadsheet. In addition, it also incorporates a photo management system that allows the uploading and management of images for individual stock items.
Client : Car4me Pty Ltd. Level 9, 606 St Kilda Rd, Melbourne. Victoria. 3004
Role : Developer
Achievement : Conduct analysis, design and implementation of the project.
Technology Used : PHP, Apache, MySQL, AJAX, EXTJS, SWFUpload, JavaScript, HTML, CSS
2 Project Name : Web Based Data Loader
Description : This system was developed to help support the online classifieds section of the 247ads/car4me websites. It allows users who have listings on these websites to add/edit/delete multiple listings dynamically within a single interface. The goal of this system is to speed up the modification time for dealers. The API provides paging navigation across a few, or hundreds of records. Incorporating a dynamic template system, it offers the facility to create user defined layouts, so that specific data columns can be chosen, saved, and reloaded. The system uses extensive AJAX based on the EXTJS (Sencha) framework. It’s fast and cross browser supported. The system is designed in such a way that it can be configured easily to work for any system.
Client : Car4me Pty Ltd. Level 9, 606 St Kilda Rd, Melbourne. Victoria. 3004
Role : Developer
Achievement : Conducted analysis, design and implementation of the project.
Technology Used : PHP, Apache, MySQL, AJAX, EXTJS(Sencha), JavaScript, HTML, CSS etc
3 Project Name : Online Fundraiser System
Description : ForMySchool works exactly the same as traditional school fundraisers, except the sponsor submission form is online. Friends and family are invited to donate towards a fundraising activity by email and simply click a link to be directed to the sponsor form. 

The school gets registered online and once active, the school’s teachers ask parents to register their children for fundraising activities chosen by the school. Sponsors are invited by email to visit a student’s school activity page and donate, but have absolutely NO CONTACT with a student at any time. Parents have the option of entering an email list of people to invite to sponsor their child and an automated email is sent to the list.

Client : ForMySchool Pty Ltd., Hampton East, Victoria – 3188.
Role : Web Application Developer
Achievement : Conduct analysis, design and implementation of the project.
Technology Used : PHP, Apache, MySQL, AJAX, JavaScript, HTML, CSS etc
4 Project Name : Accounts Management System
Description : Typically known as general ledger accounting software, covers most of the financial aspects, management’s reports of Malaysian Airlines. Includes but is not limited to Trial Balance, Cash Flow, P/L, Balance Sheet, Bank Reconciliation etc. 

The system allows entering multiple debit and credit entries in one page of the journal. The account code divided into two levels such as GL Head and Sub Head. This will produce much shorter list to select from while inputting data. Moreover knowing the Head Hierarchy can minimize errors. The entire sales transaction brought in a screen. System produces a list of unpresented/Advanced dated cheques. When cheques will be presented to the bank the party ledger will be automatically credited. Incase of bounced cheques, party ledger will be debited.  After checked by the Chief of Accounts the Petty Cash entries will be populated in the main accounts.

Client : Malaysian Airlines, Plot No.SW(I)-4. Gulshan Avenue-1, Dhaka-1212
Role : Programmer
Achievement : Conduct analysis, design and implementation of the project.
Technology Used : Oracle 9i, Developer 6i/2000 (FORMS, REPORTS and Graphics)
5 Project Name : Remote Data Entry System
Description : It is basically used for offline data entry system from any field office. The data is exported to the web database after entries of all data. The exported data is of CSV format. Similarly the data can be imported from the web to the system. There must have internet connection to use both of these features. The system is basically for adding new children, altering child information like core info, case history info, photo info etc. and deleting any child info from the system. 

The Correspondence System in Remote Data Entry allows the field office to accept correspondence from the child and allows the field office to request a correspondence from the child. The data read from the raw data sheet and modified data is saved to the export data sheet. The temporary data sheet is used to put the searched result and to navigate through backwards and forwards. To see all the transactions at a glance system provides two reports such as View All Transactions and View Only Photo Transaction.

Client : FHI [Food for Hungry International], USA.
Role : Programmer.
Achievement : Conduct analysis, design and implementation of the project.
Technology Used : MS Excel 2000, Visual Basic
6 Project Name : Web Based Remote Data Loader and Data Migration System
Description : The data can be entered into the system remotely basically in two different ways. One is via CSV (Flat Files) and through an XML-RPC request. The CSV data is first checked the size by the PHP function and validation is carried out by the PostgreSQL stored procedure. If all the required field values are correct then the data inserted in to the respective table depending on the transaction by the stored procedure and triggers are fired automatically. The XML-RPC used to call a remote procedure to process the request and send back the result in the client browser. 

The XML-RPC server first serializes the data into PHP variables that are passed from the client then the after processing the result it un-serializes and returns back to the client browser.

Client : FHI [Food for Hungry International], USA.
Role : Programmer
Achievement : Conduct analysis, design and implementation of the project.
Technology Used : PHP, JavaScript, PostgreSQl 7.4.2, HTML 4.0,XML-RPC etc.

OTHER PROJECTS:

Timesheet and Attendance Management System, Dynamic News Scroller, Report Builder, Payroll System, Web Banking System, Air Cargo Information Management System, Switching Mode Power Supply for Personal Computer, MCQ [Multiple Choice Questions] Test System, Intranet Mailing System, Silkways Group Email Marketing System etc.

Leave a comment