Senior Systems Analyst/Programmer

Primary Function:

Reporting to the Information Technology Section Head, the Senior Systems Analyst/Programmer is responsible to define, design, test, analyze, and maintain new and existing software application systems according to the Company’s standards and guidelines, with the objective of lessening complexity of work and systemizing workflow for optimum use of resources. The job includes designing, writing, coding, testing, analyzing, and installing software programs and applications, database creation & maintenance, including user access and data/file security.

Duties and Responsibilities:

  1. Conducts a thorough top down analysis of the existing operational procedures and proposes a new, or revised and/or enhanced automated or manual procedures, or a combination of both, that will result in the efficient processing and delivery of products and services by the requesting unit.
  2. Writes a comprehensive documentation of the existing automated applications, systems and solutions that describe custom configurations, operating procedures and technical specifications.
  3. Constructs detailed design specifications including but not limited to functional specifications, system and program narratives, screen layouts and report layouts that will support Jr. Systems Analyst/Programmers
  4. Serves as the liaison and facilitator between all business units and any Third-Party Software / Service Provider to ensure the compatibility of products and services to the Company’s current applications, systems, and server environments
  5. Automates operational processes in order to facilitate operational procedures and ensure the accuracy and fast delivery of products and services, in accordance with the DPA of 2012 and its IRR, and in accordance to the limits set forth by the Agreement between CEM and client schools/other public/private institutions, or among CEM units.
  6. Coordinates with the Database Officer regarding the creation and modification of database structures, the test and production environments and other activities for appropriate application systems development.
  7. Serves as project leader to guide subordinates through analyzing, organizing, designing, programming, testing, and implementation.
  8. Provides new updates and features to existing systems and solutions.
  9. Provides ongoing support to users through system maintenance and troubleshooting, processing data requests and provides access to databases to authorized client school personnel.
  10. Assists the iT Head in planning, personnel selection, personnel training, and personnel performance appraisal.
  11. Provides assistance and shares knowledge to teammates regarding data/file/server/system security.
  12. Conducts user training and provides User Manuals.
  13. Generates Application System Documentation.
  14. Provides users access to the different application programs. Coordinates with the Database Officer regarding the access to databases in accordance with user specifications. Coordinate with the Network Engineer regarding the setting up and updates of the Active Directory.
  15. Maintains all running application systems.
  16. Ensures the backup and recovery procedures of the application and data servers.
  17. Ensures the accuracy of the version control procedures.
  18. Updates all systems documentation as well as the User’s Manuals.
  19. Coordinates with the Database Officer and the Network Engineer regarding the backups and recovery procedures.

Candidate Qualification:

  • College graduate of any of the following courses: BS Computer Science, BS Computer Engineering, BS Information Technology, BS Information Systems, BS Electronic and Communication Engineering
  • With at least 5 years of application systems development experience and at least 3 years in the use of MS SQL management system as backend
  • Knowledge of statistical principles
  • Knowledge in application development, system design, and database management
  • Knowledge of the application of the different SDLC methodologies in system development
  • Knowledge in relational databases (RDMS)
  • Knowledge in project management
  • Knowledge in database and security
  • Knowledge in change management
  • Excellent in debugging skills
  • Crystal Reports
  • C#5.0/6.0
  • ASP.NET MVC
  • .NET Framework 4.5 and above
  • .NET Core
  • MS-SQL, T-SQL programming
  • MySQL Database
  • Visual Basic 6, Visual Basic.NET
  • HTML5
  • CSS, LESS, Bootstrap 3 or above
  • Javascript / JQuery or other Javascript Framework
  • JSON, XML, LINQ
  • RESTful API
  • Basic Adobe Photoshop/Illustrator/InDesign
  • Test Driven Development
  • Visual Studio - Team Foundation
  • C# Database Programming
  • Data Flow Diagram
  • Critical thinking ability
  • Strong problem-solving capacity
  • High-level written and verbal communication skills
  • Teamwork
  • Passion for Excellence
  • Negotiation skills
  • Professionalism
  • Integrity
  • Interpersonal skills
  • Keen attention to detail
  • Leadership skills
  • Planning and decision-making skills
  • Research oriented
  • An ability to follow processes
  • Strong documentation skills
  • Commercial and business awareness
Senior Systems Analyst/Programmer
Information Technology Section