Data Engineer

ALY AMIN

New York, NY, email: adjwx7@r.postjobfree.com

Phone: 631-***-****

Over 5 years of experience in the field of Software Quality Assurance analyst, exposure to Automation Testing, and production support, Full understanding and experience in Software Development Life Cycle (SDLC), and Software Testing Life Cycle (STLC) for Desktop, and Web-based applications. Seeking a position to grow and surpass challenges as a Quality Assurance Analyst carrying assigned duties.

Skills

●Solid experience in System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) in Agile-Scrum and Waterfall environments.

●Expertise in analysis of business and functional requirements and a strong background in creating and executing Test Plans, Test Scenarios, Test Cases, Test Data, and Test Reports for manual tests.

●Hands-on experience performing Functional, Back-End, End-to-End, Integration, and Regression of complex electronic trading systems across a number of internally developed applications.

●Experience in creating Requirements Traceability Matrix to ensure comprehensive test coverage of requirements.

●Skilled in defect management, analysis, and reporting using Quality Center and JIRA.

●Comfortable in different environments and use Linux terminal to troubleshoot application issues in logs and identify the reasons for errors.

●Ability to construct complex SQL queries applying business logic filters based on Specifications, perform data quality checks or data validations in the RDBMS.

●Practical knowledge of Trading Life Cycles for different products including Stocks, Options, Futures, Forwards, Repurchase Agreements, CDOs, Bonds, STRIPs, and TIPs.

●Detailed-oriented and break-through attitude in testing complex financial systems: Order Management Systems (OMS) and Execution Management Systems (EMS).

●hands-on experience fixing production support issues, recreated/retested defects reported by the Client Support team.

● Provide level 2 production support to resolve trading issues with regards real-time trading via simultaneous investigation of logs across multiple UNIX servers in conjunction with SQL queries to determine root cause.

●validate input data files and generated tables by performing ETL testing.

●Responsible for writing LINUX/Unix commands to manage and analyze FIX Messages Log Files, Snap Quotes, Data Mapping Files, Market, and Reference Data Batch Files.

●Experienced in working with FIX Protocol, XML messages, and using VeriFIX to perform End-to-End testing as well as execute manuals for electronic trading platforms.

●Proficient in Load and Performance testing with automated scripts for Web-based and Client-Server application using VeriFIX 6.2 testing tool

●Participated in creating, modifying and maintaining new and existing Automation Frameworks using Python, Selenium WebDriver, PyUnit, BDD, Page Object modeling, Keyword, and GitHub tools

●Excellent time management skills and the ability to triage tasks in an efficient way to accomplish tasks.

●Self-starter who is comfortable working in a very dynamic environment, with rapidly changing priorities.

●Team player, result-oriented, quick learner, easily adopt excellent communication skills.

● Work closely with the client support team and clearing desk to troubleshoot and verify order executions to Lightspeed Trading OMS.

● Supporting the Client go-live order flows, coordinating with clients/trading desks custodians.

EDUCATION and CERTIFICATION:

MS in Finance Alexandria University Alexandria, Egypt

Certified Scrum Master Int Scrum Institute New York, NY

TECHNOLOGY:

Test Case Management: HP ALM/QC, Jira

Database: MS SQL Server, Oracle, MySQL

Browsers: Chrome, FF, IE, Edge, Safari

Project environment: C++, HTML, XML, Java, VBScript, JavaScript, VeriFix, UFT, python, Selenium,PUTTY, Jenkins, GitHub, postman,TFS,WinSCP,IBM Data Stage.

EXPERIENCE:

Interactive Brokers, Secaucus, NJ Senior QA Analyst, 05/2018 - Present

Trader Workstation is a comprehensive and powerful desktop trading platform that allows traders/investors to find trading/investment opportunities, analyze them, and place a trade. Through this application, users can trade stocks, options, ETF, FX, futures, bonds, and mutual funds.

Responsibilities:

●Worked in a project run on Agile methodology and concentrated on Equity Trading.

●Analyzed Business Requirement Document (BRD) and Functional Specifications Document (FSD) to overall understand the project aim and discussed with BA the emerged questions.

●Used HP ALM to organize and manage all phases of software testing, including test plan, test case, test execution, log/track defects using JIRA tools, and creating Test Analysis Report (TAR).

●Created Requirement Traceability Matrix to verify that all requirements of each module are covered with test cases.

●Performed Smoke, GUI, Positive/Negative, Boundary, Functional, End-to-End, Back-End/FIX Message-API using postman tools, and Regression testing.

●Extensively tested application FIX protocol messages like New Order Single, Executions Reports, Cancel Request, Cancel/Replace Requests, Reject, post-trade messages including Allocation Instruction and Allocation Acknowledgement by extracting FIX Logs using Linux Terminal

●Prepare and run shell scripts in Linux/Unix to generate traded market data for clients and tested client reports.

●Involve in Automation Testing by selecting, updating, and running Test Scripts and comparing input and output.

●Perform (non-function) testing include Performance testing, Load/Volume Testing for Trading Order Management System

●Responsible for conducting End to End testing of a complete trading cycle for equities: including pre-trade, actual trade, and post-trade stages.

●Extracted FIX Logs using Linux Box; analyzed them by interpreting tags and values with and without FIX translator, and Participate in ETL testing before every release, validate input data files, and generated tables.

●Intensively worked with SQL to write queries for Back-End testing in order to verify data integrity

●Verified order types and TIF in the drop-down menu during GUI testing and how they work in combination with each other.

●Manually tested the functionality of trading stocks and executed Trading Reports to cross-check with database and FIX logs.

●Extensively used VeriFIX to perform End-to-End testing of a Trade Life Cycle.

●Work closely with QA Engineer with Selenium WebDriver and Engineering team to discuss and create automation workflow for selected scenarios, create expected results and provide manual steps for automated tests, identify verification points.

●Participated in updating and developing automation Test Scripts using Python and Selenium WebDriver following BDD and Page Object Modeling frameworks for each new functionality, adding instructions for each added Gherkin scenario execution, creating executable files for each Regression Suite

●Consulted and collaborated with the developer’s team to make sure the bugs were fixed and tracked.

●Worked with BA and Project Manager to discuss and collect new change requests and their requirements.

●Participate in Level 2 of Production Support by recreating/troubleshooting defects reported by the Client Support team.

●Interact with Developers on the issues/tasks reported on a regular basis, ensuring that tickets are classified as per standard and that resolution is clearly documented.

●Analyse and gather information independently, carry out necessary research and provide an in-depth analysis to resolve production issues.

●Ability to quickly analyze the available data and find the root cause of the production issues

●Engaged in root cause analysis for defects and provided process improvement to avoid in the future.

●Prepared test summary reports with details of executed, passed, and failed test cases.

●Participated in walkthrough meetings to discuss progress, showstoppers, enhancement, and modification requests.

Liquidnet, New York, NY Test Engineer, 08/2016 – 05/2018

Liquidnet helps users/investors to buy or sell Equities and Fixed income. The platform uses a Dark Pool network to match orders from institutions and execute them on agreed-upon price also it helps the investors to trade large blocks of stocks and bonds.

Responsibilities:

●Read and interpreted client requirements and design specifications to gain a full understanding of each

an application under test.

●Created robust test scenarios for the electronic trading and portfolio management systems, monitored the full

requirement coverage by created test cases and prepare test suites for the execution in HP ALM.

●Part of the QA team with a focus on Fixed Income Trading in a fast-paced Agile environment.

●Developed and managed Test plans while providing status updates to QA Management with well-created test

metrics and providing graphs/tables configured in HP ALM.

●Collaborated with Business Analyst and Developers during the Sprint to handle application changes and

issues with collectively well-prioritized plans.

●Identified and Documented detailed JIRA tickets including all necessary artifacts and steps.

●Performed GUI, Functional, Integration, End-to-end, Backend, and Regression testing for new releases for web platforms according to the requirements in QA and UAT environment.

●Created Tests to verify the systems and subsystems usability, business functionalities and design issues on

the front end by comparing with Design documents and technical specifications documents.

●Performed additional tests on server loads and database queries.

●Ensured that all automated testing related activities were carried out as per the standards.

●Ran SQL queries for data validation and verifies the back-end data while processing the transactions and

generating the fees, application calculations based on business logic.

●Reported and logged defects through HP ALM to developers. Interacted with developers on the status of

bugs reported on a regular basis.

●Conducted Knowledge transfer for the new QA team members or other teams that needed our expertise for

serving the Client, for the implementation team in creating the right tests.

●Assisted Engineers in handling Production Issues by reproducing Issues and proving possible analysis.

●Created Requirement Traceability Matrix to make sure that all requirements are covered with test cases.

CITIBANK New York, NY Software QA Tester 03/2015 - 08/2016

Citibank, N.A is the consumer banking division of leading financial services company Citigroup, one of the largest banks holding companies in the United States. The Online Banking Application was developed for the customers to enable them to manage their finances online and perform various transactions like accessing personal accounts, checking account balances, credit card accounts, transfer funds, and other products and services.

Responsibilities:

●Was part of the process that followed the Waterfall methodology.

●Analyzed, reviewed Business Requirements Document (BRD), and Functional Specifications Document.

●Wrote review reports and test scenarios for a better understanding of the client’s specifications.

●Created test cases to cover the functional requirements of the project.

●Performed a broad spectrum of Black Box Testing, such as Smoke to ensure that project is ready for further testing.

●Executed Regression, End-to-End, Functional testing.

●Performed Positive, Negative, Boundary testing to ensure that every module was working properly.

●Maintained the Defect Profile Document for tracking and managing the occurring bugs.

●Executed Back-End testing using SQL queries to access the database.

●Performed GUI Testing to ensure that the interface and all its modules worked according to the requirements.

●Interacted with Business Analyst, Project, and Test manager to define and clarify the testing scope.

●Used HP ALM for Defect Life Cycle management, test execution, and requirements coverage.

●Prepared Requirement Traceability Matrix to verify that all requirements are linked to corresponding test cases.

●Created status summary reports of executed, passed, and failed test cases.

●Managed problem solving and root cause analysis when defects occurred.

●Organized the workflow for the timely issuance of deliverables.

●Interacted and cooperated with developers, SME, Project Management, and SIT team members through the entire testing process to prioritize bug resolution and the delivery of defect-free products.

●Performed integration testing to ensure that software is working as a whole.

●Prepared integration test reports and updated project data collection sheets.

●Actively participated in review meetings throughout the project and at the end of system integration testing.

Contact this candidate