SQL System Analyst - Retail Banking; Wealth Management Application

D L RESOURCES PTE LTD; Singapore; On-site; SGD 78,000 - 112,000; Full time

Job summary

D L RESOURCES PTE LTD invites an experienced System Analyst to join our Wealth program, translating business requirements into FSDs and TSDs and coordinating across domains. The role focuses on end-to-end solutioning, requirements gathering, and ensuring delivery per UOB methodologies.

You will collaborate with business users, BAs and project teams, review design specs, and provide production support, including post-implementation issues. Chinese communication is valued.

Qualifications

• Bank experience in System Analyst role, retail/consumer banking, wealth management preferred.
• Experience with interface specification and data mapping.
• Knowledge of Wealth Management, Oracle SQL and Java is a plus.
• Strong analytical and problem-solving skills.
• Good communication and teamwork; able to communicate in Chinese.

Responsibilities

• Collaborate with business users, BA and project team during initiation and delivery.
• Gather requirements with business users and analysts and propose alternate solutions.
• Develop/Review FSD and map to RTM.
• Develop/Review TSD to meet requirements.
• Review SIT/Test plans and test cases.
• Ensure documentation per UOB delivery methodology.
• Verify vendor code releases against requirements.
• Provide on-going 3rd level production support.
• Diagnose and resolve production issues with architects and development teams.
• Contribute to team goals.

Skills

Requirements gathering

Communication skills

Analytical thinking

Multi-tasking

Negotiation skills

Team collaboration

Chinese language

Tools

Oracle SQL

Java

Job description

The System Analyst will be involved in Wealth Program and is responsible for understanding business requirements and translating them to Functional Specifications (FSD) and Technical Design Specification (TSD).

The role will require this activity to be performed on an end-to-end basis, across functional domains and technologies.

• Work very closely with Business Users, Business Analyst and project team members on solutioning during project initiation, implementation and post-implementation support.
• Participate in requirements gathering with Business Users and Business Analyst. Suggest alternate solutions to meet or improve the desired objectives based on best practices and industry solutions and influence the desired outcomes.
• Work on / review solution design &effort estimates and prioritize projects & change requests
• Develop/Review functional specification based on Business Requirement document and map out into RTM (Requirement Traceability Matrix).
• Develop/Review Technical Design Specification to ensure the design meets the Functional Requirement.
• Review SIT Test Plan, Test Design and Test Cases.
• Ensure all application documentations are maintained and completed according to the UOB delivery methodology.
• Verify vendor code releases to ensure that they are delivered as per functional and technical requirements.
• Review SIT Test Plan, Test Design and Test Cases.
• Support testing during SIT, UAT and post-implementation phases.
• Post production cut-over monitoring and provide support on issues and incidents raised. Ensure timely response and address of all production incidents
• Provide on-going 3rd level Production Support.
• Diagnose, troubleshoot and identify solutions to resolve application related issues. Work with architect, development team on the technical solutions to address production issues and maintain system stability.
• Contributes to team effort by accomplishing related results as needed.

• More than 3 years of experience working in Bank as System Analyst with experience related to Retail/Consumer Banking, Wealth Management, customer management, Sales Incentives and/or Branch Banking products.
• Experienced in interface specification and data mapping. Able to detail out interface specification based on user requirements.
• Experienced in Wealth Management, Oracle SQL and Java will be a plus point
• Well-developed analytical and problem solving experience and ability to grasp new concepts, provide insights and solutions.
• Good working knowledge of relevant applications and development life cycles.
• Ability to multi-task and perform well under pressure.
• Ability to orchestrate and facilitate requirements sessions, creating an environment for collaboration and communication.
• Good negotiation skills.
• Good team player with excellent interpersonal and communication skills.
• Able to communicate in Chinese.

Manage User Requirement and translating Business Requirements into FSD and TSD.