February 2022 - August 2020
Associate Software Engineer
Pioneer Solutions Nepal
Sitapaila, Kahtmandu, Nepal
- Developed features for CTRM software using PHP, JavaScript, and AJAX, including responsive UI design with the DHTMLX framework.
- Designed, implemented, and updated database schemas and tables, and wrote stored procedures, functions, and jobs using T-SQL to support CRUD operations and integrations for PHP forms and other application features.
- Optimized queries to enhance storage efficiency and improve the performance of legacy code by refactoring to meet organizational standards, implementing indexing strategies, utilizing bulk inserts, and optimizing join techniques (favoring INNER JOINs over OUTER JOINs when appropriate).
- Replaced cursors with set-based operations, used views to simplify complex queries, and ensured the use of appropriate data types for columns and parameters as part of the optimization.
- Conducted functional and integration testing, including unit testing using PHPUnit and manual testing methods, to ensure the reliability and performance of the application.
- Performed thorough code reviews for both myself and team members prior to commits, ensuring code quality and adherence to project standards.
- Collaborated using Agile/Scrum methodology with the Jira ticketing system and documenting features comprehensively in Confluence.
- Successfully resolved technical issues for clients through effective communication via calls and emails.