Post Job Free

Resume

Sign in

Qa Analyst Sql Developer

Location:
Wesley Chapel, FL
Posted:
February 22, 2023

Contact this candidate

Resume:

MERYEM BAL

Cell: 646-***-**** E-mail: advidh@r.postjobfree.com

Analytical, detail-oriented Software QA analyst with 8 years of experience in accomplishing Software Quality Assurance Testing with a solid record in delivering quality software solutions and strategies to achieve high level of software quality that exceeds business objectives. Deep understanding in advanced testing methodologies and the software development life cycle for Client/Server, multi-tier/web based applications in Financial Securities, Financial Crimes, and Accounting domains.

PROFILE:

Strong knowledge of all phases of Software Development Life Cycle (SDLC) methodologies such as Agile and Waterfall, and all steps of Software Testing Life Cycle (STLC).

Good ability to understand Business Requirements implementing in Agile environment.

Expertise in creating Test Plans, and Test Cases, Requirement Traceability Matrix (RTM), Test Execution and Test Reports for the various Functional Modules of the application.

Skilled in executing Functional, Regression, and Backend testing for Fraud and AML Requirements. Also skilled in executing GUI, Integration, Regression, and End to End Testing of Electronic trading systems across number of internally developed applications.

Comfortable in using UNIX/LINIX commands to monitor file logs and search right patterns in it.

Experience in writing SQL queries using Joins, aggregate functions to perform Back-End Testing and test data preparation. Run Stored Procedures for back-end testing also on Oracle SQL, and Sybase SQL in SIT/UAT environment.

Experience working with different platform database tools such as : Azure data studio, Aqua Data studio, DBeaver, Oracle SQL Developer, and MySQL.

Experience with running different jobs using CBSS tool, and scheduling batch jobs using monitoring tool such as Control M to generate different types of alerts.

skilled in logging defects, and tracking defects using HP QC/ALM and JIRA to closure and interacting with development team in fixing defects.

Hands-on experience in Automated Regression testing using HP UFT/QTP and other automation testing tools.

Deep knowledge of Capital Markets including Equity, Fixed Income and Derivative products.

Read and understand the FIX log files and to interpret format and different tag combinations.

Deep knowledge on using SOAP UI Tool and SERENA to simulate and send different type of transactions to generate alerts for regression and E2E testing.

Deep knowledge of USD payments system using ACH, WIRE, CHECK, ADD Payment, and support Fraud, AML requirements using RCM-Actimize Risk Case Manager.

Experience with simulator tool that uses message queue such as ActiveMQ to simulate a request for CHECK, WIRE, ACH, ADD PAYMENT as per requirement. And to perform E2E testing

Experience in using VeriFIX tool to simulate the exchange for regression purposes and to perform End-to-End testing for trading life cycle.

Dedicated, self-motivated, result-oriented, excellent communication and presentation skills. Team player with an uncompromising attitude towards quality. Excellent problem solving and analytical skills.

TECHNICAL SKILLS:

Testing tools:

HP Quality Center/ALM, JIRA, HP UFT/QTP, CBSS, ControlM, RCM

RDBMS

MS SQL Server, Oracle, MySQL, Aqua Studio, DBeaver, SQL Developer

Operating Systems:

Windows, Unix\Linux, MAC OS X

Project Environment :

HTML, XML, VBScript, Java, VeriFIX, ActiveMQ, Serena, Selenium

PROFESSIONAL EXPERIENCE:

E-Trade Corp./Morgan Stanley, New Jesey, NJ

Quality Assurance Verifix July2021 – Present

Nice Actimize – Backend office application that has a matrix structure combining regional, business line, and global financial coverage in their core area to protect institutions and safeguard consumers and investors assets by identifying financial crime. It provides real time, cross-channel fraud prevention, anti-money laundering (AML) detection, case management, and payment fraud.

Responsibilities:

Experience of Software Development lifecycle in all phases of system enrichment using Agile Methodology.

Expertise on writing detailed Test Plans, Test Cases, and execute them for Functional, regression, Integration. API testing, back-end testing, and E2E testing.

Highly working on software development to support Fraud, AML requirements using RCM-Actimize Risk Case Manager.

Experience on RCM features-Alerts monitoring/case type, workflow, and Alerts/case view.

Run UNIX commands to validate multiple processes simultaneously and monitor log files.

Interacts with development engineers, internal support groups to ensure requirements traceability and identifies areas for testing improvement, and complete projects within schedule.

Focus on solution-oriented approach and able to identify complete end to end testing needs. In addition to regression testing to any changes made to the system.

Document and maintain QA test process and procedures and create a repository of test documentation.

Analyze defects functionally and technically before assigning them to development teams. Raise quality issues to right levels of management using established channels of escalation for minimum qualifications.

Experience in executing SQL queries, using joins, and running stored procedures for back-end testing on Oracle SQL, and Sybase SQL in SIT/UAT environment.

Expertise on using DB Tools such as: Aqua Studio, Beaver/SIT-Sybase, and SQL Developer/Oracle.

Experience with running different jobs using CBSS tool, and scheduling batch jobs using monitoring tool such as Control M to generate different types of alerts.

Experience on reading JSON to send and receive data, and it is used to check the movement of data between server and web application.

Experience on API automation using SOAP UI tool, or SERENA to simulate and send different type of transactions to generate alerts for Fraud payments.

Experience with a simulator tool that uses message queue such as ActiveMQ to simulate a request for CHECK, WIRE, ACH, ADD PAYMENT as per requirement. And to perform E2E testing.

Develop and maintain automated functional and regression test cases in Selenium WebDriver.

Attend daily and weekly team meetings and interact closely with team members to discuss and analyze complicated business requirements for upcoming system enhancements and modification requests.

Deep knowledge of USD payment system using ACH, WIRE, CHECK, RCM/Actimize.

Effective prioritization skills, and able to work independently to result high quality deliverables, covering both functional and nonfunctional requirements with excellent communication skills (verbal and written).

Trading Screen Inc., New York, NY

Quality Assurance Analyst September 2018 – August 2020

TradeSmart – Customizable front office application that enables buy side clients to trade a broad portfolio of financial instruments around the clock on any market and with a wide range of counterparties. Application integrates multiple-dealers and multiple assets-classes onto a single screen format for electronic order routing and facilitates liquidity aggregation across exchanges, and other liquidity pools.

Responsibilities:

Follow the fast-paced Agile Software Development Lifecycle throughout the project and participate in all phases of System enhancement.

Prepare Test Scenarios or Use Cases for Functional, Regression, Back-end, and System Testing.

Extensively worked with Trade Order Management System (TOMS) for testing the Trade Capturing, Processing, Confirmation/Matching, Settlement and Notification functionalities.

Create and execute End to End test scenarios and test cases for buy side of stocks/Equity and cancellation of trades between counterparties.

Utilize HP ALM to develop, organize, and manage all phases of Software Testing Life Cycle (STLC), including test planning, test executing, tracking defects, and creating Test Analysis Report (TAR).

Report system defects using HP ALM, JIRA and track issues to the closure.

Write and execute SQL queries for Backend Testing and for data validations on MS SQL using JOINS subqueries and unions.

Use UNIX/Linux commands to manage and monitor log files and search right patterns in it.

Run scheduled Automation scripts for Regression testing using HP UFT and update the Data files, or data tables in the Driver script, when different parameters are needed.

Develop and maintain automated functional and regression test cases in Selenium WebDriver.

Analyze and read FIX log and different tag combinations to debug the expected/unexpected errors.

Expertise in using FIX Protocol API. Testing application FIX messages like heartbeat, logon, logout, resend request, reject, sequence, pre-trade, trade and post-trade messages.

Utilize VeriFIX tool to simulate the exchange for regression purposes and to perform End-to-End testing for trading life cycle.

Coordinate with offshore IT team and onsite QAs, developers, DBAs and project management team in delivering right product on timely manner and keep the documentation up to date with most recent changes.

Initiate and prepare daily/weekly status report to be submitted to the upper Management.

JPMorgan Chase & Co, NewYork, NY

QA Analyst June 2016 – August 2018

FSD- is a financial services desktop application used by bankers to provide access to sales campaign and customer information enabling bankers to deliver enhanced customer service and to be more effective in up-selling and cross-selling. It supports wide range of banking processes such as personal and business account opening functionality. Application also supports credit cards, personal and auto loans processing.

Responsibilities:

Analyzed and reviewed the System Requirement Specification (SRS), System Functional Specification (FRS) to develop effective Test Plans, create detailed Test Cases for the application.

Performed Manual Testing for testing functionality and GUI of the application.

Involved in running scheduled Automation scripts for Regression testing using HP UFT and update the data files, or data tables in the Driver script, when different parameters are needed.

Involved in writing SQL quiries for Backend Testing and to verify the database updates, inserts and deletions of the records, and validate them.

Supported product migrations through all systems environments, and participated in deployment processes in QA, UAT and production environments.

Used HP ALM to organize and manage all phases of the software testing process, including planning tests, executing tests, tracking defects and creating Test Analysis Report (TAR).

Participated in the bug triage meetings to prioritize bugs, and verification of the Project Checklist during the Deployments.

Ensured that assigned applications are accurately tested and met zero defect level.

Worked closely with software developers, business analysts and other project management involved in Software Development Life Cycle (SDLC).

Attended daily (SCRUM) and weekly team meetings to discuss Enhancement and Modification requests.

EVO Merchant Services, Melville, NY

Quality Assurance Analyst February 2015– May 2016

EMRS (EVO Merchant Reserve System) - is a fully featured merchant system with detailed reporting functions and access into the several existing systems currently working at EVO. It allows EVO analysts compare fund held on reserve versus funds owed for any merchant who is in a net negative exposition on funds owed to EVO and their partners.

Responsibilities:

Created and Executed Test Cases for Manual Testing to check the functionality against published software builds for business projects.

Constructed SQL queries using various joins for Back-End testing/Database testing.

Performed Functional, Integration, Regression, Negative, User Acceptance Test, Smoke and Sanity testing on modifications and enhancements prior to production releases.

Parameterized the test scripts to run with different sets of data.

Logged and Reported Defects through defect tracking tool HP ALM to developers.

Interacted with Developers on the status of bugs reported on a regular basis.

Experienced in writing SQL queries using Joins, aggregate functions to perform Back-End Testing and test data preparation using Azure Data Studio.

Investigated problems and provide suggestive solutions to the QA supervisor to correct issues.

Provided a weekly status to the QA supervisor, which will include status of projects, statistics, severity of issues, estimated time liner.

Provided feedback to project team on the current status of the modifications and enhancements being tested.

Created and managed all relevant documentation needed for internal and external customers.

Created Test Plan and Release Notes in the absence of Supervisor.

Wrote Test Plans and Test Cases for the various Functional Module in the application.

Evaluated application features and prepared several Test Scenarios, Test Cases, and Test Scripts.

Worked closely with Developers, Subject Matters experts, and the Project Manager/Business Analyst to deliver free bug application.

EDUCATION:

Mohammed V University at Souissi

Rabat, Morocco

BS in Computer Science



Contact this candidate