Manual/Automation SQA Engineer/Analyst
SUMMARY OF QUALIFICATION
** ***** ******* ********** *** skills in front-end, back-end QA testing of client/server, Web-based applications based on .NET and C# platform and Web services for financial, energy, business management, health care and communication industries.
Working experience and knowledge of Oracle EBS Financial modules, SDLS, Agile environment, EDI 837/835/834 file processing and mobile technologies.
Strength in back-end testing utilizing SQL to validate data. Expertise in all ETL testing processes for Data Warehouse. Perform smoke, regression, functional, system, front-end, back-end, GUI, UAT and API testing.
Expertise in analyzing requirements, specifications, developing test plans, test cases/scripts, track defects.
Self-motivated with analytical, problem solving and troubleshooting skills, user and detail-oriented, team player, a quick learner with good organization and time management skills.
QA Tools: HP QTP/UFT, HP QC/ALM and LoadRunner, Bugzilla, TFS, JIRA, Codesion, Trac.
Development Tools: MS Outlook, XML Generator, TOAD, MS IE, Firefox, Safari, Chrome, MS Office Suite, MS-DOS, PL/SQL Tools, Visio, Adobe, Share Point, Wiki, MS VSS, XML Spy, SQL Navigator.
Databases and servers: Oracle 9i/10g/11.5, DB2, Sybase, MSSQL Serv. 2008, JBoss, MySQL, WebLogic.
Platforms and technologies: Windows 7/8/10, IIS, C#, ASP, .NET, J2EE, COM, API, TCP/IP, ETL for DW, Mac OS, Oracle EBS modules, EDI 837/834 file transactions, Rally ticketing system, mobile platform.
05/2015 – 12/2017 Santander Bank, Dorchester, MA - Manual QA Analyst Consultant
Contribute to manual testing for Retail and Business Web-based and Mobile-based financial products in Agile project. Perform complex testing tasks to assure that developed products meet user expectation by verifying that all processes such as member enrollment, Billing, Payment, Collections, Adjustments, Transfers, Deposits, Refunds and so on work correctly and system provide tracking of all processing. Analyze test result during test execution to ensure that the business requirements are satisfied, report defects and working with business and technical teams to manage defects until resolved, monitor progress of testing and make necessary changes to test plans to ensure quality result and meet scheduled date.
11/2013 – 3/2015 Network Health, Medford, MA - Automation QA Engineer Consultant
Contributed to automate testing for ICD-9 and ICD-10 upgrade project to claims system in. Perform complex testing tasks to assure that developed Monument Xpress Web-based products meet user expectation by verifying that Medical and Hospital claim and member enrollment processing work correctly and system provide tracking of claim processing, payment details, pricing and customer services. Analyze test result and report about any anomalies.
Created automation test framework using HP UFT and test script repository, debug and execute automation scripts, maintain and edit existing scripts, developing test data and SQL complex select statements for use in automated test activities. Effectively utilized HP ALM for managing testing life cycle in Agile project.
4/2012 – 9/2013 Harvard Pilgrim Health Care, Quincy, MA - Manual QA Analyst Consultant
Performed manual testing process of Oracle EBS Financial Accounting Applications (AR, AP, GL, Billing, Pricing) to ensure a quality product is delivered to production. Developed Test Plans and Test Scenarios based on the BRD.
Verified that the components of the solution, both standard functionality and custom components (including Financial Reports, Interface), operate together in a single environment as expected.
Identify and track defects and interact with development team to isolate and resolve the issues.
1/2011 – 2/2012 Circor International, Burlington, MA - Manual QA Analyst Consultant
Participated in the testing ETL processes for Corporate Data Warehouse project by providing expertise in all ETL testing processes required that the data extract reflects the source that transformation rules are applied according to specifications and data is loaded to target database as expected. Verified data on each level of ETL process
Created and executed complex SQL scripts with multiple joins to analyze databases with large amount of data.
9/2009 – 12/2010 Wolters Kluwer, Waltham, MA - Automation QA Engineer – Permanent
Contributed to manual and automated testing of software that is the basis of all products (BasisPro, GainsKeeper Retail, FundTaxPro) and services including test script development and test execution according to established test plans and timelines and verifying that GK Applications calculate, track and report corporate actions, cost basis, capital gains & losses and wash sale correctly. Prepared testing estimates for proposed application releases.
Created automation test framework using HP QTP, test script repository, VBScript, test data and SQL statements.
Translated manual test to automation test.by implementing test cases to accomplish product automation.
6/2008 – 9/2009 Eliza Corporation, Beverly, MA - SQA Engineer - Permanent
Participated in the testing ETL processes for Corporate Data Warehouse project. Created and executed complex SQL query with multiple joins and analyze database with large amount of data in order to validate data transformation at various level. Designed and executed manual tests for testing MS Reports and devices based on mobile platform.
Performed smoke, regression, stress, performance, and functional (using black and white box) and front-end UI testing, of client/server voice recognition and Web-based software applications for Healthcare industry.
11/2006 – 1/2008 American Student Assistance, Boston, MA- SQA Analyst Consultant
Participated in testing NSLDS software program, tested client/server and Web-based applications, features, modifications, wrote test scenarios based on RTA; all tiers of testing: manual, automated (QTP tool), front-end, back-end; analyzed test result, reported bugs, managed defects until resolved and reported results.
Reviewed new or modified software program to determine if program will perform according to user request.
Translated design, functional specifications, and requirement documents and working software into detailed software test plans.
6/2005 – 10/2006 Investor Bank & Trust (IBT), Boston, MA - Manual QA Analyst Consultant
Participated in the implementation of a new Transfer Agency batch processing, for IBT client, to support the Envision Power Agent conversion project. Analyze test results to determine if the test criteria have been met.
Retrieved data from RDB by running SQL Query script with multiple joins and validate that all Market Data is updated and reported correctly. Resolve issues relating to test failures and track defects through to completion.
Monitored and tested Equity Trading, Electronic Trading, Investment/Fund Accounting/Credit transactions and Transfer Agency processes (Daily Trades, New Account, Prices, Billing, Fixed Assets and Maintenance).
11/1999 – 4/2005 Lodestar Corporation, Peabody, MA - Automation QA Engineer – Permanent
Participated in QA project planning by writing Test plans, including all details for each stage of the test process, test cases and test schedule based on project requirements. Tested financial client-server and web-based application and processes such as Billing, Remittance, Collections, Adjustments, Transfers, Deposits, Refunds and Write-Offs.
Build and execute test suites with manual, stored procedures and WinRunner automated test tool to test product functionality and for bug hunting. Coordinate test schedule with Core QA team.
Institute of Technology, Bryansk, Russia
MS in Industrial Engineering
CERTIFICATION and TRAINING:
2002 Mercury Interactive Learning Center, Wakefield, MA
Automated Test Engineer Certificate
1998 The Boston Computer School, Boston, MA
Quality Assurance Certificate
1997 North Shore Community College, Lynn, MA
Computer Programming Course