LEONID ORLOV

*** ***** ****** 718-***-****

Staten Island, NY, 10312 https://www.linkedin.com/in/leonid-orlov-82616343 ac076v@r.postjobfree.com

Summary of Qualification

Over twenty years of experience in Software Testing and Quality Assurance, IT support, Test Automation development and testing ETL, Data warehouse, Client/Server and web application. Strong, flexible and reliable team player with drive and enthusiasm to succeed.

Specific areas of expertise: Manual and automated software testing, National and International Standards in Software Quality Assurance and Testing (IEEE and ISO), Agile Methodology/Scrum, Knowledge of Wireless (CDMA and TDMA), Cellular and Personal Communications System and Technologies, AT&T telecommunications network, Financial Industry, HR/Payroll auditing for small businesses, Trading, softwareY2K compliance.

PROFESSIONAL SKILLS:

Test Management tools: HP ALM 12.21, Quality Center, Test Director, NavigatorQA 1.0.5, JIRA v6.4.13

Automated Testing tools: QTP 10.0, Load Runner, Win Runner, QALC

Scripting Language TSL, VB Script, Java Script, UNIX Shell Scripts

Programming Languages C, C++, VB, SQL, PL/SQL, JAVA, ABAP, JSP, ASP, iSQL

Internet Technologies J2EE, .Net, EJB, XML, HTML, DHTML

Operating Systems iPhone/iPad, Windows 2000/XP/NT, Windows 7, Vista, Mac, UNIX, Linux, MS-DOS

Databases: Oracle 10g/9i / 8i, SYBASE 12, SQL Server 7.0/2000, DB2/LUW and MS Access

Networking Technologies: Telnet, FIX protocol, TCP/IP protocol suite, FTP, Socket Programming

App/Web Servers: Web logic 9.x/8.x, iPlanet, MS IIS, IBM Web Sphere 5.0, Tomcat

Other Tools: Control M, Lotus Notes 4.5, Clear Case, Citrix, Major Browsers, XMLSpy2006, MS Excel, MS Word, WinSCP, File Transfer Protocol Client (FTP Client), Telnet, Toad, Sablime, PL/SQL Developer, QlikView.

EXPERIENCE:

DEUTSCHE BANK-DB, Jersey City, NJ 04/2014 – 03/2017

Agile Quality Assurance Analyst (Consultant) – Member of Trade Surveillance GT team and Wealth Management Group

Projects: Olympus/Aladdin: FO Reporting and Compliance (CRESTA, ETRA, Actimize and ABOR)

GPS (Gateway Products and Solutions, desktop and iPhone/iPad version)

Description: Aladdin, an end-to-end investment platform that combines sophisticated risk analytics with comprehensive portfolio management, trading and operations tools.

Responsibilities:

Analyze requirements and create test scripts for GUI testing and functionality testing

Upload Test Plan and Test Cases in ALM

Prepare the traceability matrix for mapping requirements with the test cases via ALM

Perform system testing, functional testing, regression testing, smoke testing, facets testing, ad hoc testing and user acceptance testing.

Use ALM for defect tracking and reporting, follow up with development team to verify defect fixes, and update defect status.

Validate the data required and the data sources using ETL process, by preparing and executing SQL statements in PLSQL Developer.

Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the Data warehouse applications.

Worked with applications, which uses XML/HTML featuers.

Implemented .NET form-based authentication that handles user login authorization

Perform sessions with requirements, analysis and development teams

Conduct meetings to review test designs and get final approval of plans

Provide reporting of tests and test results from regular builds to the test lead

Collaborated with all stakeholders in every project teams

Responsible for bug reproduction cases and scenario

Was highly responsive to team and clients

New York Stock Exchange / EURONEXT, New York, NY 06/2013 – 03/2014

Quality Assurance Analyst (Consultant)

Project: NMS – CQS (Consolidated Quote System) and OPRA (Option Price Reporting Authority)

Description: National Market System exchange-listed, OTC and UTP securities with the Consolidated Tape Association (CTA)

and Consolidated Quotation (CQ), which Plans govern, quotes and trade dissemination for exchange-listed securities

Areas of Testing include:

- CQS - Consolidated Quote System

- OPRA - Options Price Reporting Authority

Responsibilities:

Analyze requirements and create test cases to exercise product functionality

Run cross platform testing using SDLC Method: Waterfall

Automated for CQS and OPRA system test suites using NavigatorQA

Develop and execute unit, integration and regression test cases and scripts for each specific product group

Test architect for Trade simulator/engine tool (Message Driver for OPRA and CQS)

Verified Trade and quote messages using FIX protocols and TCP/IP from primary and UTP (Unlisted Trading Privileges)

Document test results

Provide reporting of tests and test results from regular builds to the test lead

Log and assign defects and keep track of the defect status

Communicate and interact with different project teams

Work with programmers to resolve defects

Prepare the Traceability Matrix for mapping the Requirements with the Test Cases via Navigator

Responsible for bug reproduction cases and scenario

Validate calculations and identify the National and FINRA "Best Bid and Offer" (highest bid and lowest offer) for CQS

Validate calculations and identify the “Best Bid and Best Offer” (BBO – highest bid and lowest offer) for OPRA

Run batch file from command line interpreter

Verifying load, scalability, and performance requirements have been met

Load and maintain test cases in Navigator (3rd - Party tools)

MORGAN STANLEY SMITH BARNEY – MSSB, New York, NY 04/2012 – 04/2013

Senior Quality Assurance Analyst – member of the Consulting Group (CG), a division of Morgan Stanley Smith Barney, that has been a leader in investment management consulting over the last 30 years. CG’s projects cover mostly customized, long-term investment strategies for institutional and individual clients.

Project: Deployment Planning and Release Management (DPRM)

Description: The new project, launched by Morgan Stanley, will facilitate communication between Development, QA, and the DPRM Automation project team and will identify and inventory the business platforms within those business areas, existing test artifacts for those platforms, and help MSSB identify and enhance business-critical flows within those platforms.

Areas of Testing include:

- Advisory

- 3D

- Retirement Services

- Performance

Responsibilities:

Collaborated with MSSB business platform subject matter experts to review existing Test Cases for accuracy and completeness.

Created new Test Cases and Test Specifications, and submit them to MSSB for approval.

Executed Test Cases manually and through QTP Scripts. Document results and time required in Quality Center, and report these to MSSB management.

Deliver MSSB-approved Test Cases/Test Specifications to the MSSB Automation team.

Reviewed application user access and entitlement access policies.

MORGAN STANLEY SMITH BARNEY – MSSB, New York, NY 10/2010 – 04/2012

Agile Senior Quality Assurance Analyst (Consultant) - member of the Consulting Group (CG) and Wealth Management Group

Project: MSSB Conversion Advisory Products

Description: Select UMA (Broker/Dealer application includes accounts that were formally owned as Morgan Stanley PPA), allows a client to combine separately managed accounts (SMAs), mutual funds and exchange-traded funds (ETFs) within a single investment account for his clients. The product is supported by the Private Portfolio Group (PPG), which acts as an Overlay Management Team. Portfolio construction and implementation services are handled through PPG, which also provides automated account rebalancing and an optional tax management service.

Areas of Testing included:

- PPA – Private Portfolio application

- AdvisorOne

- Accelerator – Financial Information eXchange (FIX) Protocol by Morgan Stanley Electronic Trading (MSET)

- UMA – Unified Managed Account

- Fidessa – The hedge-trading engine for the Equity Swaps flow (Order and Execution Management System - OEMS)

Responsibilities:

Development and maintenance of test scripts for GUI testing and functionality testing

Collaborated with all stakeholders in the quality assurance and development process

Developed and Executed Business Test Scenarios, Test Scripts and Uploaded to Quality Center (QC).

Used Quality Center to prepare Test Cases with the complete description of requirements as specified by BRD and FRD

Used Quality Center for defect tracking and reporting, also follow up with development team to verify defect fixes, and updated defect status.

Designed positive and negative Test Cases.

Participated in Walk through, defect report meetings and Weekly Status Meetings.

Reviewed and analyzed Test Defects with Business Users, development team and prepared Defect analysis report.

Reported to management on project status, progress, or possible barriers to timely release of production-ready software.

Duties involved also a high level of interaction with developers and end users

Provided QC training to newly included Business Users to the team.

Helped create Reconciliation reports for Production environment within the Advisory Workstreams.

CREDIT SUISSE, New York, NY 01/2006 – 10/2010

Agile Senior Quality Assurance Analyst (Consultant)

Project: Basel II – STAR (Strategic Tool for Analysis and Reporting)

Description: STAR is global financial reporting warehouse, integrating Basel II Compliance for Daily and Monthly Capital and GL (General Ledger) Reporting. It is a robust, centralized, global reporting environment that facilitates historical reporting, flexible query, and ad-hoc (using reporting tools: Business Objects) analytic capabilities. The front End (developed using J2EE) is a regulatory reporting tool and process solution that fits into the functional and technical Basel II architecture and facilitates flexible reporting.

Areas of Reporting included:

- External Capital Adequacy Reporting for Regulatory Agencies (EBK / FSA)

- Internal MIS Reporting

- Reconciliation Tool for Data Management and Financial Accounting

- Maintenance

- Adjustments & Comments

Responsibilities:

Collaborated with all stakeholders in the quality assurance and development process

Performed Manual and Automated Testing (QTP) to check flow of the application.

Analyzed the SRS (System Requirement Specifications) and develop Test Suites to cover the overall quality assurance testing.

Used Quality Center to prepare Test Cases with the complete description of requirements as specified by the client and upload test cases into Quality Center.

Executed most of the test cases manually in the Test Lab and some through QTP Scripts.

Prepared the Traceability Matrix for mapping the Requirements with the Test Cases via QC.

Performed White/Gray box testing, Smoke Testing, Integration Testing, Database Testing, Compatibility Testing, Adhoc Testing, System Testing and assist in User Acceptance Testing.

Worked on regression automated testing using Quick Test Pro

Tested and debugged code sections and adapted to meet the needs of clients

Used Quality Center for defect tracking and reporting, also follow up with development team to verify defect fixes, and update defect status.

Implemented Checkpoints using QTP such as GUI checkpoint, Bitmap checkpoint, Text checkpoint & Synchronization point.

Performed the Backend testing (Oracle DB and DB2/LUW (Linux, Unix and Window) by preparing and executing SQL statements in PLSQL Developer.

Extensive experience in testing applications implemented in .NET in SQL Server and Oracle.

Designed the data for interpreting the positive and negative results.

Reviewed application user access and entitlement access policies.

Worked on ETL (Extract, Transform and Load) process to provide quality through validation of the business rules

Participated in Walk through, defect report meetings and Weekly Status Meetings.

Reviewed and analyze Test Defects with BA, development team and prepare Defect analysis report.

Reported to manager on project status, progress, or possible barriers to timely release of production-ready software.

Engaged in performing sanity testing of application for post deployment production testing.

Cross Browser testing (Internet Explorer and Netscape) with different operating systems (WinXP, W2000 and W98)

Met all deadlines for project

Red October, Inc, Brooklyn, NY 02/2003 – 12/2005

Implementation Manager

Responsibilities:

Installed, tested, implemented, and maintained different applications comprising the computerized business management system. Wrote the acceptance test plans and specifications, and tested the software supplied by vendors. Administered all technical inquiries. Provided technical assistance to customers, customer service, sales and marketing. Collected and organized technical data to create and support database development. Supported Internet/Intranet on-line activities.

Software Testing Technologies, LTD, Brooklyn, NY. 08/2001-01/2003

System Tester – consultant for Imagine Software Inc.

Tested the software system developed for Derivatives Trading (Sun Workstations, Solaris, SYBASE, C/C++, Client/Server Architecture)

Responsibilities:

Prepared Test Plan and Test Specification for the Dividend Module that allows users to create, edit, and maintain dividend tables for equity securities.

Executed system testing using database access tools iSQL (viewer program)

Logged the information about bugs found into the Lotus Notes based MR system

Participated in testing of different versions of the Accounting System (Visual Basic)

Designed and maintained the test specifications for two modules: calculator and editor

Developed test scripts for GUI testing and functionality testing using QA Partner/SilkTest

Executed Regression test, analyzed results, prepared test result reports

Lucent Technologies, Whippany, NJ 11/1999-06/30/2001

System Tester, Network Wireless Systems

Took part in design, testing and production implementation of the new AutoPACE / Prospect Special Engineering Studies (SES), the suite of tools supplied with the AUTOPLEX Cellular System (Verizon/CDMA). These are a set of Client / Server applications with an Informix back end (running on Solaris) and a Windows front end.

Responsibilities:

Developed Test Plans for VCSA, RF Call Trace, and Installation applications

Was responsible for development and support of test cases using WinRunner 6.0

Verified that the entrance criteria for each delivery to system test are met.

Was responsible for tracking of system test issues specific to a particular release of a product

Determined if the software meets the system test exit criteria

Participated in cross-functional teams

Worked closely with developers

Participated in reviews and meetings to evaluate documents, plans, code, requirements and specifications

AT&T, Middletown, NJ 10/1998-10/1999

System Tester

Performed testing of Integrated Support Environment (ISE-5ESS). The ISE system imports traffic data and functions from several existing Operations Support Systems (HP-UNIX, C, Sybase11.5.1.1, C++)

Responsibilities:

Created Test Specifications according to FRS (Feature Requirement Specification)

Executed system testing using database access tools iSQL (viewer program)

Reviewed Test Specifications with the System Test Group (STG)

Communicated with Developers and System Engineers

Maintained records of daily status using Microsoft Access.

Generated and validated hierarchical data, transferred, loaded, and edited data from/to different Unix machines, using FTP, telnet, and rlogin

Automatic Data Processing (ADP), Roseland and Moorestown, NJ 06/1997-10/1998

QA Analyst

Performed manual and automated testing of “Easy order” software system that provides users - Small Businesses - with the ability to do payroll (PC, Visual Basic)

Responsibilities:

Created automated test scripts according to requirements (QA Partner 4.1)

Wrote test cases for automated testing of new features

Executed regression testing and prepared System Test Results Reports.

Participated in testing of the Year 2000 compliance

Designed and maintained the test plans and test cases.

Wrote test scripts for automated regression testing of “Y2K”(QA Partner 4.1)

Controlled test execution of regression tests

Software Testing Technologies, Brooklyn, NY 05/1995-06/1997

System Tester – consultant for Imagine Software Inc.

Took part in testing of the software system developed for Derivatives Trading (Sun Workstations, Solaris, SYBASE, C/C++, Client/Server Architecture)

Responsibilities:

System and regression testing of different releases of the Imagine Trading System - the real-time trading system developed by Imagine Software, Inc. (New York, NY) for Derivatives Trading and Risk Management (Sun Solaris, SYBASE, C/C+, Client/Server Architecture)

“Year 2000” testing of fixed income securities. Verified calculations of Price and Yield for different types of fixed income securities (US corporate and municipal bonds, CD’s, etc.) In the system using SIA “Y2K” Test Data.

Test Specification preparation for the Accounting support tables of the system that allows users to create, edit, and save into the database data about customers, accounts, accounts limits, brokers, etc. Created and maintained the set of test cases and test scenarios. Testing provided using SYBASE database access tools: SQL and MS Access.

Logging the information about bugs found into the company error tracking system (Lotus Notes).

Testing of different versions of the Inventory Management System that allows users to create and maintain business inventory database, on-line reports, etc. (PC, Visual Basic, MS Access):

Creating and updating test plan according to the system requirements.

Design and maintenance test specifications for the system modules.

Execution of system test manually.

Development and maintenance of test scripts for GUI testing and functionality testing of different versions utilizing automated test tool Quality Works (QA Partner 4.1). Regression testing execution. System Test Result Reports preparation.

EDUCATION AND TRAINING:

12/2000- Lucent Technologies, Whippany, NJ WinRunner advanced training course.

1995 -Software Testing Technologies, Brooklyn, NY. Advanced training in Software Testing and Quality Assurance.

Barnaul University, Barnaul, USSR M.S. - Electronic Engineering.

REFERENCES: Available upon request.

Contact this candidate