Sql Server Fixed Income

SHOEB MAZUMDER

**-** ** ***, ****** Village, NY *1379

Phone: 718-***-****

Email: *******@*****.***

Profile:

Solid diversified testing experience in a stand-alone, client server & web-based application in the financial, technology fixed income trading domain.

Six years of experience as an Automation Engineer.

Extensive experience in build verification, functional, integration, system testing, Interface and regression testing using both manual and automation testing approach.

Three years of experience in testing Capital market securities product including: fixed income, treasury, and mortgage backed securities.

Strong understanding and implementation of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and test methodologies in Waterfall, Spiral, Agile SCRUM /Kanban and other SDLC methodologies.

Possess solid experience in Automation Testing using UFT/QTP along with skills in complex Manual Testing.

Advanced user of HP ALM/Quality center (Dashboard, Management, Requirement, Test & Defect Modules).

Strong knowledge of Oracle Databases, Microsoft SQL server and My SQL server.

Experienced in Developing AOM Script, Driver Script, Startup Script and Utility Functions in QTP.

Strong knowledge in QTP local / shared Object Repository creation and maintenance. Expert in using regular expression, reusable actions, data table, checkpoints and recovery scenarios.

Experienced in Descriptive programming to create Data Driven, Keyword Driven, Page Object Model and Hybrid framework.

Skilled in Functional/Black Box Testing & familiar with White Box Testing.

Experienced in developing Test Plans, writing and Executing Test Cases for Manual & Automated Testing.

Extensive use of version control tools (SVN, GitHub, Share Point).

Ability to work independently as well as part of a team.

Excellent communication & presentation skill, self-starter, quick learner and good team player.

Skilled user of Defect management tool JIRA.

Environment and Tools: Golem, Tidal, Aqua Data, Snow Flake, HP ALM, UFT/ QTP, UNIX, JAVA, SQL, XML, J2EE, HTML, Web Services, Oracle, SQL Developer, Cross Browser Testing, POC for tools, IBM WebSphere, Active MQ, Beyond Compare, MQ Util, Ultra Edit Text Editor, Eclipse IDE, new Selenium IDE.

EDUCATION:

M.E., Electrical Engineering, City College of New York, NY GPA 3.8

B.E., Electrical and Electronics Engineering, Bangladesh University of Engineering & Technology, Bangladesh GPA 3.25

JOB EXPERIENCE:

New York Stock Exchange

June 2019 – Jan 2025

QA Engineer

Responsibilities:

Formulated Test plan from Business Requirements/Functional Specification documents.

Run tidal scripts for various markets and analyze the results.

Imported requirements, test steps, created test cases, validated requirements with test cases and generated reports using Quality Center.

Exported testcases to Microsoft SharePoint

Extensively used SQL for interacting with databases to query or create test data.

Developed Descriptive Programming in Golem and debug with the log files..

Generated automated scripts for Negative testing to verify strong-authentication process of the application.

Created and enhanced numerous test scripts to handle changes in the objects, in the application's GUI and in the testing environment.

Performed Sanity, System, Regression, Integration, GUI, Usability, Positive, Negative, Data Driven Testing and User Acceptance Testing.

Participated in defect resolution status calls to discuss defects with project management, developer and users.

Ordered and verified prod data,QA data and regression data.

Environment: Golem, XML, Java, HTML, Web Services, My SQL Server, Mozilla Firefox, Chrome, Windows 11, Aqua Studio, Red Hat Rhel 8, Tidal, Snow Flake, Microsoft Teams, Microsoft SharePoint, Playwright, Python.

Oppenheimer & Co. Inc.

Apr 2018 – May 2019

QA Engineer

Responsibilities:

●Worked closely with the QA manager, developers and SQA engineers to understand needs, preferences, workflows, priorities, schedules and formulate test strategies.

●Testing Order management system of Trading Equity, Options and Mutual Fund.

●Testing Interfacing Applications with Trading software including FINTRA, Hermes and Security Master.

●Writing test cases/scripts, test case automation and test execution including Peer Review.

●Testing Client inbox designed to communicate with the customers.

●Testing the Customer Relation Management application.

●Responsible for developing and executing formal test plans to ensure the delivery of quality software applications.

●Delivers quality process training to technical staff and acts as an SME.

●Extensively used Jira for tracking bugs and reporting defects.

●Defines and tracks quality assurance metrics such as defects, defect counts, test results and test status.

●Performed Build verification test, functional, Integration, End-to-End system testing and Regression testing using both Manual and Automation testing approach.

●Extensively used SQL for interacting with databases to query, create test data and backend validation.

●Created Automated test cases using new Selenium IDE and execute them.

●Built Automated orders data creation script to create Orders for validation.

●Demonstrated strong problem solving and analytical skills to assimilate new information, understand complex topics and arrive at sound analysis and judgment.

●Smoke Test, functional, Integration, End-to-End system testing and Regression testing using both Manual and Automation testing approach.

Federal Reserve Bank, New York, NY

Feb 2015 – Feb 2018

QA Engineer

Responsibilities:

Responsible for developing and executing formal test plans to ensure the delivery of quality software applications.

Writing test cases/scripts, test case automation and test execution including Peer Review.

Defines and tracks quality assurance metrics such as defects, defect counts, test results and test status.

Delivers quality process training to technical staff and acts as an SME.

Tested Messaging Services, Interfaces, Statements and Reports.

Worked on multiple assignments simultaneously and produce high quality products.

Designed and enhanced the Data Driven, Keyword Driven, Page Object Model and Hybrid Framework in Quick Test Professional.

Extensively used HP ALM and Jira for tracking bugs and reporting defects.

Created recovery scenario for error handling using Recovery Scenario Manager.

Enhanced script using UFT tool features /advance features of VB Scripting, created local and reusable actions, used HP external tools like: Password encoder, Result deletion tool.

Extensively used SQL for interacting with databases to query, create test data and backend validation.

Performed Build verification test, functional, Integration, End-to-End system testing and Regression testing using both Manual and Automation testing approach.

Writing and executing test cases using new Selenium IDE.

Contact this candidate