SARAH RACHEL J. Mobile: +91-988*******
LinkedIn: www.linkedin.com/in/sarahrachel-9a514426 E-Mail:***************@*****.*** Summary:
Functional Test Analyst / Lead with 13+ yrs of solid experience in software testing of banking applications with expertise in modules such as payments, Collections, On-boarding, Banking product Intellect, Mortgage, Asset management (Bloomberg)
Technical Expertise in Functional testing, End to end testing, Regression testing and involved in all STLC phases and well versed in testing artifacts such as Test Plan, Test Scenarios, Test cases, RTM, Defect reporting, Test summary report and have basic knowledge in python.
Versatile and willing to gain new knowledge, natural go-getter with a diligent approach and exemplary work ethics.
Technical:
Functional testing, database testing, ETL Testing, End to End testing, regression testing in different phases of STLC such as integration testing, system integration testing, UAT and production support and had direct interaction with client.
Involved in swift message verification of MT103 and AML verification for international payments using FIRCO.
Extensive product testing knowledge Intellect CBX (Customer Business Xchange), CBS (Core banking System), S2BNG (corporate banking)
Worked with Perfecto Tool (Mobile app testing), HP ALM, JIRA, Confluence, Bloomberg, SOAP UI
Schedule testing activities, contributed to test effort estimations and continuous test process improvement with the help of metrics, involved in test plan and Test Summary report creation.
Participated in defect management and handled Defect triage with development and BA
Strong communication skills, including professional written and oral
Excellent attention to small details
Oversaw test team and mentored junior team members Domain
Corporate banking Payments with MT103, pain.001, pain.002
Collections, Intellect product CBX
AML Validation in FIRCO
US mortgage (LOS)
Asset management
Tools and Technologies:
ALM 12.0.2
Oracle,SQL
UNIX
SOAP UI 5.4.0
JIRA
MS OFFICE
Beyond Compare
Aginity Workbench
Confluence
Trace horizon (test management tool)
\
Certifications
Certified by ISTQB
Udemy - Python PCEP : Certified Entry level Python programmer
Completed certification Master Class on ISO 20022 & SWIFT Standard MX for Payments on 19 Oct 2021
Sarah Rachel J Certificate_Master Class on ISO 20022 & SWIFT.pdf Academics
MSc (Mathematics) Stella Maris College
BSc (Mathematics) Stella Maris College
Work Experience
Capco Technologies (June 2022 to Till Date)
Project HSBC – Asset Management
Role UAT Test Lead
Duration June 2022 to present
Domain Banking – Asset management
Application Bloomberg, Simcorp, My State Street (MYSS) Project
Description
Migration of middle office for HK, FR, US, UK from individual systems such as Simcorp, Apollo, NT to state street. Extract validation and reconciliation.
Day to day activities (fx overlay, Blocking fail trade, CGT Accruals) management through the new centralised middle office applications. Validation of trade flow for Equity, Fixed Income, FX, Options and futures, Mutual funds, Mortgage from Bloomberg to back office and validation of report and position files
Tools used: HP ALM, JIRA
Countries Affected: HK, FR, US, UK
Roles & Responsibilities owned:
Migration of regional Middle Offices to a single centralized middle office
Understand End-to-End Business workflow of FO and MO systems
Responsible to coordinate with SME/BA to meet the deliverables
Responsible to get Business Sign off on test plans and test scenarios Mentoring team throughout the testing cycle
Strong Knowledge of testing methodologies, systems and techniques Good Exposure to Hongkong region stocks Aspire systems (August 2020 to May 2022)
Project Standard Chartered Bank (SCB) – Corporate banking Role Test Lead (Agile scrum)
Duration Aug 2020 to May 2022
Domain Banking – Corporate banking (Payments)
Application Web application (S2BNG), Database Validation, END to END validation with MT103, CADM (Client Administration for S2B) Project
Description
S2B – Straight to bank is an application used by the corporates of standard chartered bank for their day to day transaction with the clients such as payments, report generation, salary upload etc. The Regulatory changes made by country are implemented in S2BNG for those country customers. Involved in MT103 and MT199 testing for G4C,regulatory changes.
Payment by corporates (BAU) should not be affected due to the regulatory changes as application supports many types Payments as such Local and international payments.
Tools used:
1.HP ALM
2.Oracle
3.JIRA
Countries Affected:
MALAYSIA, SINGAPORE, INDIA, NEPAL, HONGKONG, GB, Zimbabwe, Nigeria, Zambia
Roles & Responsibilities owned:
1. Involved in Grooming Sprint planning, Test design, Walk through and giving DEMO to the country team
2.Coordinating with other team for test data preparation 3.Test Execution and Sending daily DSR
4.End to end testing by coordinating with other teams and giving DEMO about the change to country team
5.Involved in UAT testing and UVT support.
Virtusa Consulting Services (Apr 2011 to May 2020) Project Bank of Montrel (BMO) – URLA update
Role Test Lead
Duration May 2019 to May 2020
Domain Banking - Mortgage
Application Web application (Net O), Extract validation, Database Validation Project
Description
Net Oxygen is a LOS (Loan Origination System - mortgage application) used by BMO for its customers for Mortgage and consumer loans origination and processing. New loan applications for Mortgage are originated and processed by different users having different privileges such as originator, processor, Underwriter, QA, Closer, post closer, funder, load administrator, disclosure...etc.
URLA Update project is about the new application form 1003 issued by the government sponsored enterprises Freddie Mac and Fannie Mae for improving their business and giving usability by removing irrelevant details and implementing the MISMO standards.
Tools used:
HP ALM, Oracle
Responsibilities:
1. Prepared test Plan raised clarification and Given walk through. 2. Prepared and reviewed test scenarios and test cases 3. Allocating task and guiding team members.
4. Involved in test execution, defect tracking and defect triage call. 5.Publising DSR to the onsite and managers and involved in the Weekly meetings with client
Role Senior tester – Individual Contributor
Duration Apr 2018 to Apr 2019
Domain Banking/ ABS to XAA
Application Web application (XAA), ETL Testing (extract validation) Project
Description
ABS (automated billing system) and VOSTRO billing systems were used by BMO for billing Canadian customers. Now this billing system is replaced by XAA (extended Account Analysis). XAA was more enhanced and also it was being used by BMO for US customers hence it was preferred.
Testing involved extract validation between the different upstream applications (OLBB, Livelink), downstream application (Computershare, CMCIF) and agility workbench (DB)using beyond compare tool. Validation of data migrated from ABS and transformed to XAA with its own specification and format. Testing XAA application for the billing contracts created for customers are linked to the various products in the upstream application.
Tools Used:
1.HP ALM
2.Aginity Workbench (Netezza Db)
3.Beyond Compare
Project BMO - EPBS, OLBB
Role Test Analyst
Duration Nov 2014 to Apr 2018
Domain Banking/Payments
Application Oracle, Web Services testing (soap UI), Web application (WRAP, FIRCO, Control center), Web application (OLBB), Customer Connect
(Windows application), Database testing
Task Understanding requirement and FSD
Preparing Test scenarios, test cases, RTM
Payment posting and validation AML, Repair queue - Control Centre and FIRCO application handling, Extract validation
Test execution and Defect reporting
Defect triage, regression, E2E testing and closure
Publishing weekly status report to the stake holders and onsite Project NBAD (National Bank of Abu Dhabi), MASHREQ BANK Role Test Analyst
Duration Aug 2011 to Oct 2014
Domain Corporate Banking, Payments, Collections, back office Application Intellect CBX, Portal BO
Task The project deals with the enhancement of the existing Polaris product (INTELLECT – CBX) such as it is suits daily operations related to corporate banking for NBAD and Mashreq bank corporate customers.
Understanding the requirement and FSD
Preparation of test scenarios and testcases, test data
Test execution, defect reporting, regression and closure
UAT and production support