Canada Revenue Agency (CRA), Ottawa, ON
- Designed and optimized SQL queries for efficient data retrieval and reporting across multiple database systems, improving data processing speed and accuracy
- Built and maintained enterprise applications using Apache Struts, Java Spring Framework, JavaScript, and the WET toolkit, integrating front-end components with backend services
- Authored comprehensive user stories and acceptance criteria in JIRA for key features, facilitating clear communication between business and development teams
- Collaborated with Business Analysts to transform design wireframes into functional prototypes, showcasing work in routine meetings and incorporating feedback and criticism to ensure alignment with business requirements
- Developed an admin reporting portal using Struts, Spring Boot and JavaScript, allowing users to execute predefined PostgreSQL queries and export results to Excel, significantly improving data accessibility