Software Development Sql Server
Resume:
SOKHIBA MAMEDOVA
*********@*****.***
Professional Summary
• Over 6 years of experience in Software Testing, Requirement Analysis, and all phases of the Software Development Life Cycle (SDLC).
• Strong expertise in manual and automated testing of web-based and client/server applications, primarily in the financial domain.
• Experienced in Test Planning, Test Case Design, and writing User Stories based on product documentation, business needs, and functional requirements.
• Extensive experience in Smoke, Functional, Integration, Regression, Back-End, End-to-End, and UAT Testing.
• Proficient in SQL for data validation and database testing across Oracle and SQL Server environments.
• Hands-on experience with Selenium WebDriver, Java, TestNG, Maven, Jenkins, Git, and defect management tools like JIRA, ALM/QC, and TFS.
• Familiar with Linux commands and shell scripting for troubleshooting application server issues and log analysis.
• In-depth knowledge of Equity Order Management Systems, Trade Life Cycle, and Capital Markets Products (Equities, Fixed Income).
• Experienced in VeriFIX for verifying FIX protocol messages in electronic trading platforms.
• Acted as a liaison between onshore and offshore teams, ensuring quality deliverables and timely project execution.
Skills
Programming and markup
languages
JAVA, SQL, HTML, FIXML, CSS, X-PATH
Operating System Microsoft Windows, Mac, Unix/Linux RDBMS: MS SQL Server, MS Access, Oracle 8i/9i
Frameworks and tools
Selenium WebDriver, Selenium Grid, TestNG, JUnit, Jenkins, Maven VeriFIX, MS Office Suite (Excel), ALM/QC, JIRA and MS Team Foundation Server (TFS)
Integrated Development
Environments (IDEs)
Eclipse, IntelliJ
Professional Experience
Fidelity Investments, Jersey City, NJ
Sr. QA Analyst
October 2022 – Present
Project Scope: The application that provides a user interface for traders to intelligently and quickly bid on incoming bids-wanted, aiming to sell items at higher prices swiftly. Portfolio Transitions enables the Fixed Income Sales Desk to automatically upload clients’ holdings to the PT platform and route buys and sells to various destinations.
Responsibilities:
• Collaborated with Fidelity Brokerage Service Incorporated to ensure accurate trade flow into the mainframe and validate reporting.
• Managed RFQs, BWs, Offerings, and trade executions across external ATSs such as TMC, BDESK, HART, KCG, SNTL, RWSM, HDGM, CITI, and WELLS, verifying end-to-end (E2E) trade flows.
• Utilized VeriFIX to bid on BWs and validate FIX message tags for added or updated messages.
• Conducted backend data validation by creating and executing complex SQL queries (joins, aggregate functions, wildcards, unions, subqueries, etc.) on Oracle DB.
• Designed and executed End-to-End Test Scenarios, converting them into automated test scripts.
• Developed automation scripts using Selenium WebDriver and Java, leveraging TestNG, Maven, DDT, and Cucumber frameworks.
• Integrated Continuous Integration (CI) tools such as Jenkins and Git/GitHub for build and source control automation.
• Verified FIX protocol messages to ensure accurate tag data transmission to/from ECNs.
• Analyzed log files using Linux, Super Putty, and Putty to validate trade processing through server gateways and ECN vendors.
• Collaborated with offshore teams to ensure on-time, within-budget project delivery.
• Prepared and presented Test Analysis Reports to management.
• Designed and executed automated test cases using Selenium WebDriver, incorporating XPath and CSS selectors within a data-driven framework.
• Demonstrated strong analytical, communication, and multitasking skills, participating in walkthrough meetings with QA teams, developers, project managers, business analysts, and SMEs. Point 72 Asset Management, Stamford, CT
QA Engineer
March 2020 – September 2022
PROJECT: The electronic trading platform for hedge funds, enabling traders to manage portfolios, analyze markets, and execute trades that support trading in securities such as stocks, bonds, options, futures, mutual funds, and ETFs.
Responsibilities:
• Reviewed Business Requirement Documents (BRD) and Functional Specification Documents
(FSD) to understand application functionality.
• Created functional test cases based on business requirements and participated in daily/weekly status updates.
• Conducted comprehensive data validation and database testing using SQL queries (joins, subqueries, wildcards, group by, having, aggregate functions).
• Tested trade capturing, processing, confirmation/matching, settlement, and notification functionalities.
• Verified MSRB reporting and TRACE reporting based on product types.
• Verified allocations of block trades with CTM auto allocation and manual allocation
• Validated whether trades sent and matched through RTTM.
• Tested whether trades are settled at DTC or BNY for different fixed income products.
• Developed and reviewed Test Strategies, Test Plans, and Test Cases, incorporating positive, negative, boundary testing approaches.
• Logged and tracked defects using JIRA.
• Used Linux commands and WinSCP to monitor log files and validate message updates.
• Designed and implemented automation scripts using Selenium WebDriver API with Java following the Page Object Model (POM).
• Developed efficient locator strategies using XPath and CSS for stable test execution.
• Executed Selenium tests across different browsers using Selenium Remote Control and managed test execution via Eclipse.
• Conducted database verification with Oracle SQL queries, ensuring coherence cache consistency for QA and UAT environments.
KPMG, Montvale, NJ
QA Analyst
January 2019 – March 2020
Project Scope: A web-based tool designed for efficient and transparent management of large volumes of tax data. It automates the process of collecting, aggregating, allocating, and tiering data to generate tax returns and distribute K-1s within IRS Form 1065, streamlining tax compliance. Responsibilities:
• Expertise in full Software Development Life Cycle (SDLC) following Agile methodology.
• Reviewed Business Requirements (BRD) and Functional Specification Documents (FSD) to create detailed functional test cases.
• Participated in SCRUM meetings, sprint planning, and Product Backlog Item (PBI) discussions to iteratively deliver software increments.
• Categorized bugs by severity/priority and collaborated with developers to resolve them.
• Executed manual test cases to validate GUI and functional features, comparing actual vs. expected outcomes and logging defects in TFS.
• Conducted smoke, functional, end-to-end, and regression testing in a continuous integration (CI) environment.
• Performed targeted and full regression testing based on feature complexity and risk assessment.
• Assisted in reproducing and debugging issues found in UAT/Production, working closely with developers to ensure timely fixes.
• Proficient in writing complex SQL queries and procedures for database validation and data extraction across multiple source tables.
• Verified the validity of solutions from an end-user and end-to-end testing perspective.
• Prepared test progress reports, defect reports, and communicated findings to management. Education
Urgench State University, Information
Technology
September 2013- June 2017
Contact this candidate