Amirrudin Dahlan

Amirrudin Dahlan

Summary

Experience: 6 + Years as Systems Analyst / Developer, 1+ Year as Senior IT Specialist

  • Current occupations:
  1. Senior IT Specialist for Nanyang Technological University (NTU) since Sept 2008.
  2. Contract Associate Tutor, Associate Lecturer for PSB Academy since Dec 1995.
  • Past occupations:
  1. Systems Analyst / Developer for SP Services Pte Ltd since April 2002.
  2. Computer Trainer for Singapore One Learning Place in July 1999.
  3. Computer Trainer for Association of Malay Professionals in May 1998 and Dec 1999.

Education:

  • Masters of Science (Information Systems) at Nanyang Technological University (NTU), Singapore from Aug 2007 to June 2009.
  • Bachelor Of Applied IT from University Of Newcastle via PSB Academy, Singapore from May 2004 to Sept 2005.
  • Diploma in Information Technology at Nanyang Polytechnic, Singapore from July 1996 to May 1999.

Certifications:

  • Sun Certified Programmer For The Java 2 Platform 1.4 from Sun Microsystems in Jun 2008.
  • Certificate of Proficiency in PC Hardware & Software Technical Training from CRON ComputerSchool in May 1999.

Trainings:

  • Software Tester Course from Tescom in Sep 2006.
  • JBuilder Essentials Course from Borland in Jun 2006.
  • Web Component Development with Java Technology Course (SL-314) from Sun Microsystems inMar 2006.

Technical Proficiency:

  • Languages:
    • Java SDK, J2EE, JSP, Asp, Visual Basic, .Net, SQL, StoredProcedure, PL/SQL, Borne Shell, Perl
  • Databases:
    • Oracle, MS SQL Server, MS Access, MySQL
  • Reports:
    • Crystal Reports, Microsoft Reporting Services
  • Web Servers:
    • IIS, Tomcat, iPlanet
  • Tools:
    • JBuilder, Kawa Pro, Eclipse, Toad, CVS, Test Track Pro, MS Office Suites, OpenOffice, Oracle Forms, PL/SQL Developer, Oracle Forms/Reports, MS Visual Studio

Work History

Work History
Sep 2009 - Present

Senior IT Specialist

Nanyang Technological University
  • Performing system analysis on business needs & requirements.
  • Translating business needs into technical and system specification.
  • Designing, developing and maintaining of enterprise business systems.
  • Conducting unit tests, integration tests and user acceptance tests with end-users.
  • Performing issue tracking, escalation and resolution.
  • Aliasing with vendors for impact analysis of change requests and resolution of issues pertaining toProduction problems.
  • Addressing & tracking requests for system enhancements, improvements from end-users/customer.
  • Providing technical recommendation, advice and training to end users.
  • OO and event-driven developments for in-house users.
  • Monitoring of production tasks and investigation of issues.

Systems under current portfolio

  • Graduate Research Admission System The process of selecting suitable candidates for post graduate programmes is a tedious effort of collating student's inputs from the existing Post Graduate Admission System. Officers from GSO (Graduate Student Office) will have to download, print and file each application details, attachments and other related items systematically. Representatives from each college will then take turns to review each application. Feedbacks will be painstakingly noted down from each level of reviews, namely, but not limited to, Associate Chair Research, Evaluation Committee members, Faculty staff and so on. The complex manual workflow and responses is time consuming, cumbersome and not productive in relation to the cost per manpower. Thus the idea of having an online workflow system that can track multiple applications, storing of feedbacks from each parties, centralization of applicant's documents and so on offloads a lot of issues that were faced in the current process of manual toil.
  • Post Graduate Admission System To be updated soon
  • Post Graduate Course Registration System To be updated soon
  • Blogs @ NTU Based on Word Press MU (Multi-User) blog platform, it will be the mother blog of all NTU-related blogs. All blogs will be hosted internally and with URLs http://blogs.ntu.edu.sg/XXX. Many exciting and hip blog templates will be provided to suit different uses and purposes. Even novice blog users will find it easy to get started! The 1st phase includes blogs for Schools and Colleges, Research and Faculty Staff, Admin Offices, Student Clubs & Halls. Check them out at http://blogs.ntu.edu.sg. My role would be to liaise with the vendor, communicate on technical areas such as widgets development, theme designs, database schema, and other operational issues. When the need arises, I will edit the templates to suit the request of each school's, debug posting's issues, perform data updates/maintainence via back-end SQLs and other related matters.
Dec 2005 - Present

Associate Tutor, Associate Lecturer:

PSB Academy
  • Contract lecturing for a diploma programme in PSB Academy. The programme involved is Diploma in Information Technology.
  • Contract tutoring for a degree programme in PSB Academy. University of Newcastle, with the cooperation of PSB Academy, has introduced a Bachelor in Applied IT programme. It is a software and technical inclined degree that has risen in popularity since its introduction.
  • Job scope involved, as a tutor and lecturer, would be as follow:
    • Comprehending the degree modules and the details of the tutorials prior to commencement of classes with the Australian and local lecturers.
    • Assisting students and discussion of solutions during tutorials and laboratory classes.
    • Planning of timetable for lectures, tutoring lessons and laboratory practices prior to commencement of module.
    • Devising question papers, answers and marking guidelines for exams and tests.
  • History of module taught / tutored to date:
  • EBUS3010 - Strategic Business Systems: Investigating the role of information and use of technology within an organization from a management perspective. Topics include the links between information, technology and organizational structure, strategic and operational planning for ICT.
  • INFT2800 - Info Systems Development: Addressing the techniques and tools used to construct modern information systems, especially those relating to electronic businesses. It equips students with business analysis skills to facilitate communication with information systems professionals. A concept like ERD was used in designing the database schema. Visual Studio .Net was utilized for the development of the required application.
  • INFT3009 - Web Database Interfacing: Emphasizing is placed on commercial programming methodologies and techniques using web specific technologies such as ASP.NET, Web Services and XML/XSL integrated with core technologies such as Visual Studio, SQL Server or MSDE, the .NET Framework and ADO.NET.
  • INFT3910 - Advanced Software Development: Consolidates and refines students' previous software development skills and knowledge, and extends their skills and knowledge into large-scale, complex software systems. It considers the management and construction of applications software projects.
  • INFT2008 - Information Systems Programming: Covering concepts and skills needed to develop and manage small to medium information systems, including database interfacing, event-driven programming, development of effective user interfaces, and creation and presentation of reports. The course uses Microsoft technologies such as Visual Studio.NET to provide students with practical experiences involving a interface into relational databases.
  • FPRG – Fundamentals of Programming: Introducing the techniques and concepts of programming using a high-level object-oriented programming language. Participants are taught problem-solving skills using a top-down, structured approach. The module also familiarizes participants with the object-oriented methodology. The discipline learned is generally applicable to any programming platform.
Apr 2002 - Sep 2009

Systems Analyst

SP Services Pte Ltd

Responsibilities:

  • Performing system analysis on business needs & requirements.
  • Translating business needs into technical and system specification.
  • Designing, developing and maintaining of enterprise business systems.
  • Conducting unit tests, integration tests and user acceptance tests with end-users.
  • Performing issue tracking, escalation and resolution.
  • Aliasing with vendors for impact analysis of change requests and resolution of issues pertaining to production problems.
  • Addressing & tracking requests for system enhancements, improvements from end-users/customer.
  • Providing technical recommendation, advice and training to end users.
  • OO and event-driven developments for in-house users.
  • Monitoring of batch jobs/production tasks and investigation of issues.
  • Performing periodical backup of system via tapes.
  • Performing clock changes of UNIX and Windows OS during SIT.
  • Testing and ensuring DR is tested and readily available.

Supported Systems:

  • MSSL (Market Support Services Liaison System)
  • This project involves the liberation of energy market for retailers so as to provide competitive electricity prices. The consumers that the retailers pull are organization consuming large amount of electricity.
  • The system is based on Java Object-Oriented concept with the introduction of new IT technology such as XML, Sonic MQ and JMS. Main OS platform is UNIX, although Windows 2000 will be used if the need arises. Others include the normal client-server structure of front-end web based GUI, Java Servlets and Oracle database. Stored procedures (PL/SQL) are widely used to perform aggregation of consumers’ energy consumption and more. For end-user reporting, Seagate’s Crystal Reports are hosted on the Crystal Enterprise Portal. They are accessible via the webpage. These reports utilize Stored procedures (PL/SQL) for any requests to the Oracle server. PL/SQL is a better option than SQL as the execution load is at the server end, thus resulting in faster data extracting. Batch jobs are executed using via CRON jobs that are created using Shell scripts.
  • System utilizes the concept of XML messaging between consumers, retailers, electrical generators, EMC (Energy Market Company) and MSSL for all communication. It is similar to the SMS (short messages) concept whereby messages, containing vital business details, can be transmitted to the message broker and sit there while it waits for the other party to consume it. This design permits businesses continuity even if the surrounding systems become unavailable.
  • Primary technologies used in this project: Java, J2EE, Servlet, XML, Oracle database, Oracle Stored Procedure (PL/SQL), Crystal Report, Visual Basic, ASP.

Achievements:

  • Semi-automation of meter data adjustments 
    • Currently, reading adjustments for settlement dasta, usage data and meter data to PV2 are performed and tracked by RMU manually. Human errors could be easily introduced during such manual process. An adjustment engine is required to help automating the version control of these adjustments for future audit purpose.
      • Allows easy retrieval of archived settlement data.
      • All adjustments of settlement data can be tracked for future audit purposes.
      • Semi-automated computation allows adjustments of settlement data to be performed easily.
      • Allow re-generating of usage data for the retailers for meter faulty and unwanted estimation scenarios.
      • Provision of meter data adjustment for billing for meter faulty and unwanted estimation scenarios.
      • Visual basic will be used to create the entirely new application. This application will be able to extract and estimated the readings by the first level user and send it for approval. The 2nd level user will then approve these adjustments at his discretion. Rejected adjustments will be returned to the first level user with comments for further corrections. This is an interactive cycle. Request from this application will be brought forth by oracle stored procedures (PL/SQL) to the database. 
      • Development Tools: Oracle PL/SQL, Oracle Stored Procedure, Visual Basic
  • Telephone numbers tracker (CR2004055).
    • Telephone Number Tracker (TNT) to track ownership, termination, commissioning and other statuses of remote meter telephone lines. It should also facilitate accurate and punctual billing of telephone subscriptions. 
      • Provides a quicker reply to telephone line ownership inquiries made by retailers or customers.
      • Provides confirmation required by customer relations with regards to thetelephone lines of customers applying for contestability statuses. This is the case when the telephone line does not belong to SP Services before the approval of the contestability status.
      • Facilitates termination of telephone lines due to account closure or other reasons.
      • Ensures that telephone subscriptions for accounts are billed accurately andpunctually.
      • Tracks the parties involved in the commissioning and provision of telephone numbers
      • Application GUI was entirely built using Visual Basic. Request made from the GUI to Oracle  database is via Stored Procedure (PL/SQL). An email will be sent on a daily basis to inform users of the changes to a phone number when there are occurrences of account closure, meter replacement, phone change of a recorder and so on. This email is trigger via a CRON job that executes a java program, which in turn executes a stored procedure to extract the daily changes and attaches them to the email object.
      • Development Tools: Oracle PL/SQL, Oracle Stored Procedure, Visual Basic, Shell Scripting, Java
  • Various reports (Development Tools: Oracle PL/SQL, Oracle Stored Procedure, Crystal Reports)
    • Electricity consumption report (CR2003068)
      • A monthly report to show the Electricity consumption for each dispatch period. The report should be available in Excel format and to generate from Jan 03 onwards and thereafter, to be submitted on a monthly basis. Report was requested by EMA for purpose of monitoring market performance.
    • Summary for recorders with recently estimated readings (CR2004014)
      • Provide the summary for recorders with recently estimated readings on daily basis.
        • One report for daily-read consumer meters
        • One report for weekly-read consumer meters
        • The reports would used to investigate why the data was estimated. This will help to identify which recorders were estimated on the 5th business day due to missing readings and allow for settlement files to be amended, as necessary, before final settlement run.
    • A report to provide the pulse data in addition to the existing meter accuracy reports andseparate the reports by meter types and unit of measurements (kwh / kvarh) (CR2004023)
      • PowerGrid requested MSSL to provide additional info of meter pulse data in additional to the existing meter accuracy reports and separate the report by meter type and the unit of measurement (kwh / kvarh). This will allow for easier verification that meter data is accurate.