Software Engineer
Current-Involving in the full development cycle of planning, analysis, design, development, testing, and implementation.-Understanding and gathers requirements from Business user side or Business Analyst and to convert that requirement to SQL queries.-Having database experience on creation of tables, views and indexes.-Writing advanced SQL Queries using joins, unions or subqueries to design and develop business integrated reports based on client's specifications.-Experienced in Pentaho Report Designer and Pentaho Data Integration.-Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.-Conduct data analysis using database tool (SQL Developer or MySQL Workbench) to support issue analysis and resolution.-Worked on-site location to communicate with client directly and resolve issues faster.-Responsible to conduct user training for new enhancements in application.-Responsible in software application deployment at client place.-Provide 1st support service for iMatch and Mpower-Create/edit reports using Pentaho-Troubleshoot technical issues occurs in production-Access client server to do Deployment for iMatch and Mpower-Database used: Oracle and MYSQL Server. -Clients: RHB, CIMB,Public Bank,Affin and Inter Pacific Asset Management