SUMMARY:

• Seeking a position as a Software QA Analyst (or QA Automation Tester) in the challenging IT Finance industry, to utilize my ability and skills that present professional growth while being flexible, innovative and resourceful.
• Over 7+ years of professional experience in Software Quality assurance in various with Manual and Automation Testing, Verification and Validation and software Quality Assurance.
• Highly proficient in creating and implementing, developing Test Strategy, Test Conditions, Test plan, Test Scenarios, Test Case Design and Test Reports using business/functional for both manual and automated tests ( using Java and Python programing languages ).
• Experienced in back - end testing using SQL Queries (Advance level: multi-table joins, Select…Into, Union, Insert, Order by, Grouping results, etc... ).
• Experienced and strong knowledge’s of Oracle DB queries and SQL concepts, Equity derivatives, Agile, Cucumber framework and writing Gherkin tests in IT Banking/Finance industry.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing.
• Good experienced developing/creating/installing/building/testing, Team Project with using Selenium (Common API with Java code), drivers like (Find.webElements, By.Xpath, sleepFor, sendKey etc), POM (Page Objective Method), Hybrid framework, pom.xml, runner.xml, Maven.Apache-Lifecycle/Plugins/Dependencies, encoding UFT-8, SOAP UI and different Java test classes.
• Excellent understanding in all aspects of Software Development Life Cycle (SDLC), with specific focus on Software Testing Life Cycle (STLC), Defect Life Cycle and role of QA.
• Excellent experience in working with Test Management Tools like HP Quality Center/ALM.
• Expertise in problem solving, finding the root cause of the issue, Defect tracking and defect retest.
• Experienced in design of test Plan, reviewing, prioritizing and executing test cases and defect logging using HP Quality Center/ALM.
• Worked with Program Managers, Requirement Analysts, Mappers, Developers, and other testers to resolve issue with requirements/mapping transformations.
• Good experienced functional testing in ETL Data Warehousing/ Data Mart (DDL, DML and DCL), using Ab Initio tool, Graphical User Interface (GUI) and in Banking (like Autosys scheduling tool) for ETL process.
• Performed System, Functional and Regression testing on different modules in latest builds using Quick Test Professional (QTP)/UFT.
• Experienced in different methodologies like Waterfall, Agile, and Scrum.
• Experienced in Sprint Grooming, Sprint Planning, Sprint Review and Sprint Retrospective meetings.
• Documented Daily Test Summary Reports for each Test execution using Import and Export tool.
• Experienced in using Junit and TestNG testing Framework test runner with Selenium.
• Good knowledge in writing Training documents and Traceability Matrix.
• Experienced in using JIRA for project management and Zephyr for creating and managing test cases.
• Good exposure of mobile automation and manual testing on iOS and Android OS platforms using Appium.
• Hands on experience in using build and project management tolls like MAVEN and Configuration management tools like SVN, GIT.
• Experienced on Maintaining Data Driven and Keyword Driven Automation Framework.
• Solid knowledge in using Java and Python, C++ programing languages OOPS, Object, Method, Interface, Abstract Class, Keywords and Variables required for Selenium frameworks.
• Experienced managing software applications, financing security maintenances and testing, handling different projects Clouds like Cloud SQL (NuoDB), SaaS, Microsoft Azure, MongoDB, BigQuery.
• Experienced in designing TDD framework using TestNG/JUnit as well as as BDD framework using Cucumber.
• Experienced at Test Automation frameworks in Selenium/UFT, Page object model (POM) be used kind of frameworks such as modular, data-driven, keyword driven, hybrid framework ect.
• Experienced working with Messaging (IBM MQ, JMS), writing Stored Procedures, functions, SQL queries and backend programming using DB2. NoSQL database such as Cassandra.
• Experienced Batch management: AutoSys
• Experience with testing frameworks like JUnit and mocking techniques.
• Good ability to plan, prioritize and follow through on their work and meet deadlines in a fast-paced environment. while also clearly articulating both technical and non-technical issues with stake holders & partners like Dev Ops, Architects, QA testers & Product Owners.
• Good knowledge in Capital markets, Financial Risk Management and Fixed-Income.
• Conceptual thinker, highly motivated, open mind, self-starter with good communication and interpersonal skills.
• Performed credit research and analysis on various municipal borrowers as part of an investment team managing municipal bond funds with $1.5 billion in assets under management, in addition to other tasks in support of the portfolio management process.

TECHNICAL SKILLS:

Testing Tools: Selenium WebDriver, Selenium Grid, UFT/QTP, Appium, Rest-AssuredCucumber, Postman, JMeter, TestNG, JUnit, SOAP UI.

Bug Tracking Tools: JIRA, HP-ALM/Quality Center

Databases: SQL Server, Oracle, MongoDB, MS SQL Server, Mysql

Build Tools: Maven, Gradle

Cloud Testing: Sauce Labs, BrowserStack, Microsoft.

Operation Systems: Mac, Windows, Unix/Linux

Language: Java, SQL, Python, PL/SQL, CSS, C/C++

Repository System: Git/GitHub, Bit-Bucket

Continuous Integration Tool: Jenkins Server

Testing Methods: Component, Integration, System, Regression and UATAPI (Web Services) testing

Skills Summary: SQL Testing & Methodologies, Test Plans, Cases Processes, Functional Requirements, Scripting Documentation, Regression & Negative Testing, UI Compatibility Testing, Data Interface & Migration TestingPerformance/Load/Stress Testing, Testing AutomationDefect/Bug Tracking, Test Strategies & Coverages, QA & QC

Standards, AutoSys scheduling, POM: Hybrid frameworkImport and Export tools.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

QA Automation Engineer

• Created Test Plans, reviewed required documents, developed and executed Test Cases, compared requirements to development and report results and status to the project teams
• Analyzed business requirements documents to get better understanding of the system both on technical and business perspectives
• Analyzed valuation of tradable market securities with data mining and data management software (SQL) which led to a significant minimized data error.
• Led a team of 3-4 testers performing Manual front end and Back-end functional testing
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Designed proposals for resolving conflicts and prepared weekly and daily reports including Bug Status Reports and Test Execution Reports
• Participate testing financial risk databases using SQL queries (for ex: Select…into, Join’s, Insert, Union, Update…) in MS Access and Aqua Data studio.
• Involved in the database testing using SQL queries of the application like checking all the tables in the Database and checking whether the data is moving in their respective tables.
• Provide feedback to the development group on usability, functionality and quality of user experience
• Hand on experience with QTP and Automation Testing using Java and Python C++ programing languages
• Executed Test Cases to validate product compliance with requirements and Automated Test Cases for GUI, SOAP UI, JMeter, Functionality and regression testing UFT/QTP.
• Analyzed the test run result and logged defects in the HP ALM.
• Developed a Data Driven Framework using Selenium WebDriver
• Developed Functional and UI test cases using Zephyr add-in for JIRA
• Performed Test activities using JIRA to ensure integration into functional requirements
• Participated in developing/creating/installing/building/testing, Team Project with using Selenium (Common API with Java code), drivers like (Find.webElements, By.Xpath, sleepFor, sendKey etc), POM (Page Objective Method), Hybrid framework, pom.xml, runner.xml, Maven.Apache-Lifecycle/Plugins/Dependencies, encoding UFT-8, SOAP UI and different Java test classes..
• Performed functional and regression testing during the various phases of the application using Selenium WebDriver.
• Hand on experience with UFT/QTP and Automation Testing using Java and Python programing languages
• Team leader in developing automation scripts, execution and analysis hybrid framework using selenium webdriver, TestNG, Maven and integrated the test with jigger build after every successful deployment.
• Performed Regression Testing, Smoke Testing, using HP UFT.
• Integrated automation scripts in Jenkins for nightly batch run of the script. Executed automation scripts using API (Web Services) testing and JMeter.
• Supported load testing by creating XML test data using QTP XML Automation. Created Custom function using QTP to handle complex and dynamic application to improve framework efficiency and reduced execution time.
• Created and testing sprints privet company webaplications and application databases like “Investors coupon payments”, “wealth managers”, “investor relations” and “Exemplary documentations” ect.
• Identified hedging alternatives and analyzed risk factors based on client needs
• Assisted public finance bankers with quantitative support and client relationship management
• Responsible for running performance reports that compared portfolios and benchmark indicies. Created reports in Bond Edge to identify difference between portfolios and benchmark indicies in regards to maturity buckets, sectors, and ratings quality.
• Demonstrated ability to work effectively as a project lead and in a team environment Company Projects like “City Glass”, “LK Invest” and “TMM Capital”.
• Documented all testing and code defects through HP Quality Center-ALM.
• Attended daily scrum meeting and co-coordinated with developers.

Confidential , NY

QA Analyst

• Worked with Business and Financial Analysts, Executive and Managing Directors and Project Managers in analyzing Investment Specifications.
• Created Test Plans and test scripts, executed test scripts, and wrote Test Report.
• Planned, documented and tested extensive data integration PL/SQL in support of financial security reference data.
• Provided oversight in writing detailed design steps and created the test lab for the projects in ALM.
• Trained investment accountant on new system, used currently as a tool for clarifying investment income variances.
• Analyzed the test run result and logged defects in the HP ALM.
• Performed extensive back end testing in Microsoft SQL Server environment.
• Extensive experience writing SQL Queries and Involved in Data Base Testing.
• Regularly followed up with the development team to discuss the defects identified during Testing.
• Collaborated with the Development and Database Modeling teams for Integration, System, Function, Regression and UAT testing of Bank Data Warehousing. Main tasks performed included - IBM Datastage ETL job execution, test analysis, source file extraction, FTP processes, Smoke test and source file validation for relevant tables during initial and Incremental Loads.
• Developed an integrated test plan covering the main functions of the designated parts of the application
• Supported and used regularly VB Scripting
• Experienced in charge of delivering an eTrading Monitoring dashboard for the FICC Rates and Emerging Markets business
• Identify and document deficiencies in the proprietary information management system during initial implementation.
• Performing Smoke Test for all the releases and verifying the fixes and closing them.
• Worked with Testing Data Extraction, Transformation and Loading (ETL).
• Supported daily deployment by executing test script and analyzing the test result.
• Described QTP/UFT base framework to Selenium team in order to transfer existing framework to Selenium base framework (Cucumber, TestNG, SOAP UI, JMeter and etc.).
• Involved in creation of automation framework in Selenium WebDriven with BDD tools like Cucumber
• Assessed the financial market to prepare short- and medium-term forecasts of macroeconomic indicators and recommendations technical sphere for the annual report.
• Performed regression testing for fixes using QTP and closed the defects in ALM.
• Developed inline view queries and complex SQL queries and improved the query performance for the same.
• Equity, equities, Options, FOREX, Mutual Funds, Hedge Funds, trading, trade, Swaps, Swaptions, Futures, FRAs, Escrows, API, Risk management, wealth, securities, fixed income, Commodities, Mutual Fund loan, LOS, loan mortgage Origination, FX, FIX, Derivative Capital Market Asset Risk ACH SWIFT AML Wire transfer
• Experienced working with developers, project managers and executive directors, and developing/supporting high level test plans with my team (Led a Testers), successful completed the Big Data Investment Projects like “Ukrnafta” (Ukr), “Ok Bank” (Kaz), “Barki Tojik” (Toj), “Tashkent City” (Uzb) “PDVSA” (Ven) and “TurkInvest” (Turkey).

Confidential, New York

Software QA Tester

• Responsible for Overall QA and UAT effort including creating, executing and monitoring testing of ITCC Advantage application
• Good experienced in Smoke Testing, Functional Testing, Regression Testing, User Acceptance Testing.
• Analyzed System Requirement Specification, involved in each step of the test documentation such as writing Test Scenarios, Test Cases and Defect Reports.
• Collaborated with the Lead and Customer to develop the Test and Acceptance plan criteria for Performance and Load Testing and thereafter generated Cognos (Adhoc and OnDemand) Reports and SQL’s along with executing various scenarios using WebLOAD.
• Preparation of Test Cases based on ETL Specification Document, Use Cases, and Low/Medium Level Design document.
• Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the database.
• Involved in the database testing using SQL queries of the application like checking all the tables in the database and checking whether the data is moving in their respective tables.
• Participated QA processes and activities across the teams. Transitioned software development efforts to a test-driven development (TDD) process, which brought QA testing in on front-end of the development cycle for gains in code quality, software functionality and programmer productivity.
• Identified, analyze, and document defects for Android/iOS Dedugging using Jira defect tracking system.
• Actively participated with the users during User Acceptance Test (UAT).
• Used Unix to search, track, and process logs.
• Worked in a Software Development Lifecycle Using Agile(SCRUM) methodology.
• Performed extensive Manual, Automation and Regressing Testing of the application.
• Document all testing and code defects through HP Quality Center-ALM and JIRA
• Works closely with the Technical Leads and Technical Project Managers to ensure testing stays on target. Attended walkthrough and daily scrum meetings with project analysts and managers and developers

Confidential. Illinois/New Jersey

QA Tester/ETL Tester

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in ALM/Quality Center 9.0
• Involved in developing detailed test plan, test cases and test scripts using ALM/Quality Center for Functional and Regression Testing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and Back-end testing
• Experience in ETL Data Warehousing, database testing using Ab Initio for ETL process.
• Created test plans and performed unit testing for the Ab Initio graphs
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed.
• Performed Web Services testing using Soap UI & Advanced REST Client; validated the API Service
• Calls against the SQL Database
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury ALM/Quality Center.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Written several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures. Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases. Worked with Testing Data Extraction, Transformation and Loading (ETL).
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Tested Catalog in Impromptu Administrator to create Reports
• Used ALM/Quality Center to track and report system defects