Diana Turovskaya

** ***** **** #***

Nutley, NJ *7110

201-***-****

SUMMARY

** ***** ** ********* ********** in all phases of project development and implementation, business analysis, testing tools, and system analysis with creating documentation and testing. Working experience in manual and automated testing, black/white box testing, regression, back-end, interface, integration and performance testing. Proficient in creating detailed test plans, matrices, test cases and summaries and working knowledge of Software Development Life Cycle (Waterfall, Agile, Scrum methodology).

TECHNICAL SKILLS

AUTOMATED TOOLS: UFT/Quality Center/Test Director, QTP/UFT, LoadRunner, Test Partner, Selenium

OPERATING SYSTEMS: Windows NT, AS/400, UNIX, DOS, OS/MVS, Citrix

DATABASES: DB2, ORACLE, MS ACCESS, TERADATA, SQL Server

LANGUAGES: COBOL2, VSAM, SQL/DB2, MVS/JCL, RPG, CL, VB Script, .NET, JAVA

)OTHER TOOLS: Change Man, INSYNC, FILE-AID, FileMaster, TSO/ISPF, Easytrieve Plus, Base24, Rational Test Manager, Rational Requisite Pro, Rational Functional Tester, MS SharePoint, Teradata SQL Assistant (Queryman), PEGA, Siebel, SharePoint, TOAD, RALLY, IBM COGNOS TM1, TrackWise

PROFESSIONAL EXPERIENCE

BANK OF TOKYO, JERSEY CITY, NJ

QA Lead Analyst/Test Manager/Project Lead (January, 2018 – Present)

Project: The KYC/R Application actively used for KYC processes. The main objective of rebuilding KYC/R is to address securities vulnerabilities, End of Service (EOS) issues, and to reduce costs of future enhancement projects. Enterprise Information Security (EIS) has identified 20+ high risk vulnerabilities in that expose MUBK to the potential threats and exploitation including but not limited to unauthorized access and denial of service attacks.

•Performed Test Planning (Efforts Distribution and Test Case Prioritization, created Test Strategy and Test Plan artifacts)

•Performed regression, front end, back end, UAT and integration testing. Used MS Access, TERADATA, DB2, and Oracle database for records validation

•Provided assistance and guidance to developers in creating unit test cases. Defined Use/Test Cases using MS EXCEL (pivot tables, spreadsheet, and formulas) and QC

•Analyzed business and system requirements to develop test strategy including test plans

•Developed test cases/scripts and business scenarios which involves educating testers from the business units on standardized approach

•Planned/controlled reporting of daily and weekly meetings

•Managed the collection of critical/core business transactions to verify and validate key components of applications. Used VBA to update QTP scripts

•Identified and tracked improvements to the testing process and worked towards their implementation

•Created requirements and managed test data needed for testing

•Created test strategy and executed Integration Testing. Used File-Aid for record verification

•Created test automation strategy. Executed and edited automated scripts in QTP, generating test data, performed results analysis/reporting using QC

•Facilitated and participated in DIT, SAT meetings, created reports for test results in QC. Facilitated meeting with off-shore team using Citrix, WebEx

•Created SQL statement to retrieve test data according to business requirements and for record verification (TERADATA, DB2) using TOAD tool

Environment: IBM Cogno TM1, RALLY, ORACLE, JIRA, ALM, TrackWise, Selenium, QC, PEGA, Siebel, SAP, MS Project, MS Excel, TrackWise, TeamTrack.

VERIZON WIRELESS, WARREN, NJ

QA Lead Analyst/Test Manager (February, 2015 – May, 2017)

•Provided assistance and guidance to developers in creating unit test cases. Defined Use/Test Cases using MS EXCEL (pivot tables, spreadsheet, and formulas) and QC

•Analyzed business and system requirements to develop test strategy including test plans

•Developed test cases/scripts and business scenarios which involves educating testers from the business units on standardized approach

•Planned/controlled reporting of daily and weekly meetings

•Managed the collection of critical/core business transactions to verify and validate key components of applications. Used VBA to update QTP scripts

•Identified and tracked improvements to the testing process and worked towards their implementation

•Created requirements and managed test data needed for testing

•Created test strategy and executed Integration Testing. Used File-Aid for record verification

•Created test automation strategy. Executed and edited automated scripts in QTP, generating test data, performed results analysis/reporting using QC

•Facilitated and participated in DIT, SAT meetings, created reports for test results in QC. Facilitated meeting with off-shore team using Citrix, WebEx

•Created SQL statement to retrieve test data according to business requirements and for record verification (TERADATA, DB2) using TOAD tool

Environment: QC, PEGA, Siebel, ORACLE, SQL, DB2, TERADATA, Data Warehouse, MS Project, MS Excel, MS Access, .NET, VBA, QTP/UFT, TrackWise, Selenium, SAP

TD BANK, FLORHAM PARK, NJ

QA Lead Analyst (June, 2012 – February, 2015)

•Managed the collection of critical/core business transactions to verify and validate key components of applications. Used VBA to update QTP scripts

•Identified and tracked improvements to the testing process and worked towards their implementation Created requirements and managed test data needed for testing Created test strategy and executed Integration Testing. Used File-Aid for record verification

•Created test automation strategy. Executed and edited automated scripts in QTP, generating test data, performed results analysis/reporting using QC

•Facilitated and participated in DIT, SAT meetings, created reports for test results in QC. Facilitated meeting with off-shore team using Citrix, WebEx

•Created SQL statement to retrieve test data according to business requirements and for record verification (TERADATA, DB2) using TOAD tool

Environment: ALM/QC, PEGA, Siebel, ORACLE, DB2, SQL, TERADATA, Data Warehouse, MS Project, MS Excel, MS Access, .NET, VBA, QTP, e-comers, CMS, Mainframe testing, Selenium

NOVO NORDISK PRINCETON, NJ

Lead QA Analyst (April 2012 - June 2012)

•Tested the following Siebel entities: Sample (GxP), Accounts, Activities, Service Requests, Opportunities, Claims, Submissions and Quotes

•Performed interface testing: (WebMethods, Batch interfaces which used Oracle Stored Procedures)

•Wrote IT system validation protocols including IQs/OQs/PQs, project summary report. Wrote detailed test cases and created traceability metrics. Wrote Validation Plans, User Requirements, Test Protocols, and Summary Reports

•Mapped each User requirement from the URS document to one or more functional requirements in the FRS document, as applicable, and one or more PQ test cases

•Mapped each functional requirement from the FRS document to one or more OQ test cases

•Updated SOPs, that describe and govern the usage of Samples module by the Line of Business users Created new SOP on generation of all production reports from One Stop Shop System

•Categorized Risk Factors and Weighted Average. Created SAT, DIT results reports

•Updated and maintained QC for all the defects found during functional and regression testing and follow up the bug life cycle

•Created test strategy and executed Integration Testing. Used File-Aid for record verification

•Facilitated meeting with off-shore team using Citrix, WebEx

•Created SQL statement to retrieve test data according to business requirements and for record verification (TERADATA, DB2) using TOAD tool

•Created queries to locate records using TrackWise

Environment: Quality Center, Siebel, ORACLE, SQL, TERADATA, DB2, Data Warehouse, MS Project, MS Excel, .NET

AEGIS EAST RUTHERFORD, NJ

Lead QA Analyst (June 2011 - March 2012)

•Performed Test Planning (Efforts Distribution and Test Case Prioritization, created Test Strategy and Test Plan artifacts)

•Created SQL statement to retrieve test data according to business requirements and for record verification (TERADATA, DB2) using TOAD tool

•Performed regression, front end back end, user acceptance and interface testing

•Provided assistance and guidance to developers in creating unit test cases. Defined Use/Test Cases using MS EXCEL (pivot tables, spreadsheet, and formulas) and QC

•Testing for the following Siebel entities: Accounts, Contacts, Addresses, Activities, Service Requests, Opportunities, Claims, Policies, Submissions and Quotes

•Web Services

•Web Methods

•Batch interfaces which used Oracle Stored Procedures and SQL Server 2008 Stored Procedures, SQL linked Servers between Oracle and AS400 databases.

•Conducted testing of SAP data Services DQM for Siebel functionalities such as Account, Contact, Total credit limit and Cash advance, address cleansing and validation.

Environment: PEGA, Mercury Quality Center, Siebel, SQL Server, ORACLE, TERADATA, SQL, Data Warehouse, MS Project, MS Excel, Mercury QTP, .NET, VB Script

JP MORGAN-CHASE ISELIN, NJ

Lead QA Analyst (January 2011 - June 2011)

•Directed a team of 5 consultants in the planning, execution and coordination of Quality Assurance functions

•Conducted status review meetings. Lead end to end testing efforts for very large, complex implementations

•Analyzed Impact and Probability of Failure

•Provided assistance and guidance to developers in creating unit test cases. Defined Use/Test Cases using MS EXCEL (pivot tables, spreadsheet, formulas)

•Performed compliance and version testing

•Assisted QA Manager and team members with the coordination, prioritize and scheduling of assigned projects/activities of the QA team to expand automation testing coverage

•Updated and maintained the Quality Center for all the defects found during functional and regression testing and follow up the bug life cycle

•Translated Software Specification and Business requirements into test cases, developed and executed test plans, defined and tracked defects

•Conducted regression testing on QA/UAT versions of the applications.

•Created SQL statement to retrieve test data according to business requirements and for record verification (TERADATA, ORACLE) using TOAD tool

Environment: Mercury Quality Center, MS Project, MS Word, MS Excel, TERADATA, Mercury QTP, .NET, VB Script

UPS MORRISTOWN, NJ

Sr. QA Analyst (May 2010 - December 2010)

•Created test estimates from design documentation and created quality assurance project schedules

•Executed UAT test script and ensure all system functionality and features are accurate and complete

•Provided quality assurance feedback throughout the project life cycle

•Provided status reports to project business owner

•Conducted bug review and status review meetings. Facilitated meeting with off-shore team using Citrix, WebEx

•Performed functional, non-functional, front-end, back-end, integration, regression, validation, verification, white box, and performance and system tests. Wrote and executed advanced SQL statements

•Identified Stakeholder Objectives, Risk Factors and Functional Break-ups

•Reported and tracked testing related defects and issues using Quality Center, ClearQuest, Teamtrack. Interfaced with developers, analysts, and end users

Environment: MS SQL, Compuware File-Aid, TeraData, CHANGEMAN, Mercury Quality Center, ClearQuest, MS Project, MS Word, MS Excel, TSO/ISPF, JCL, COBOL, SQL, Mercury QTP, .NET, VB Script

MEDCO SOMERSET, NJ

Sr. QA Analyst (October 2009 - April 2010)

•Testing, implementation and post implementation support of DATAMART patient system fully compliant with Medicare Part D requirements. The application provides reporting of data loss that occurs from the time a campaign begins to run to the time a communication piece is attempted to be delivered to patient.

•Developed specific automated test conditions for regression, functionality, and stress testing

•Reviewed product/project requirements and design specifications and creates a solid QA test plan. Created and executed automated test scripts to validate test cases, including data driven testing and FSO (File System Object) using QTP.

•Coordinated testing related tasks and activities with business representatives (Subject Matter Experts) and IT staff, reviewed QC integration use cases. Facilitated meeting with off-shore team using Citrix, WebEx

•Reported and tracked testing related defects and issues using Quality Center, ClearQuest. Validated overall functionality of the integration. Supported unit testing of the integration

•Developed specific automated test conditions for regression, functionality, and stress testing

•Created QA test procedures for automated testing to assure an accurate and repeatable process using QTP

•Facilitated meeting with off-shore team using Citrix, WebEx

Environment: SharePoint, Oracle, MS SQL, Compuware File-Aid, TeraData, CHANGEMAN, Quality Center, ClearQuest, MS Project, MS Word, MS Excel, JCL, COBOL, SQL, QTP, LoadRunner.

ADP ROSELAND, NJ

QA Analyst/Programmer (October 1998 - February 2009)

•Development, testing, implementation and post implementation support of a 401k Plan Daily Extract system. The application provides improved reporting and management of 401k Plan daily Deductions.

•Analysis, testing and implementation of the Wage Garnishment Report System. The application provides the capability to apply involuntary deductions on line by system users, and retrieve the employee data using the index record

•Analysis, testing and implementation of the Custom Check System. The application provides the client with ability to print their own checks

•Tested and implemented of the CAFE 125 Verification Report System. The application provides the pay manager with ability to manage changes in CAFE 125 deductions

•Prepared and executed Application Test Plans, Test Script Cases using Test Director/QC

•Conducted black box, system-level validation testing, perform back end database testing, create SQL queries and analyze result

Environment: COBOL, DB2, SQL Server, INSYNC, Fileaid, XPEDITOR, CHANGEMAN, Rational Rose, Requisite Pro, MS Project, Test Director, MS Word, MS Excel, QTP, Ideal/Datacom.

CERTIFICATIONS

Certificate, DB2 for Cobol Applications

Certificate, Web Design and Implementation FAIRLEIGH DICKINSON UNIVERSITY

Certificate, QTP for QA professionals

EDUCATION

M.S., Engineering - BELGOROD UNIVERSITY

Cittone Institute

Contact this candidate