TATYANA SOLOPOV

*** ******* ***** ***** • Concord • CA 94518

(925) 689 - 0935 (Home) • (925) 787 – 5459 (Mobile)

email: acvcys@r.postjobfree.com

OBJECTIVE: Position as QA Lead / Sr. Software QA Analyst / UAT Coordinator

QUALIFICATIONS:

Extensive experience as a QA Lead/Technical Lead/QA Analyst/QA Engineer

Experience as User Acceptance Testing Coordinator.

Worked for leading clients such as Bank of the West, Federal Home Loan Bank, Workers Compensation Insurance Rating Bureau of California, Wells Fargo Bank and Verizon Wireless. Also worked for software companies such as Goolara, LLC that specializes in making digital email-marketing software tools, Embarcadero Technologies, Inc. that provides the industry set of software tools for developers, DBAs, and architects, as well as Intrepid Systems, Inc. for Retail Management systems.

Solid background in all kinds of functional testing, as well as database-level testing on all major database platforms, and performance evaluation.

Experience in testing web-based E-commerce, email-marketing, Salesforce CRM application, banking software, Calypso market trading and risk application, mobile application (Smart Phones and Tablets for iOS, Android).

Experience in UI and back-end testing using SQL.

Experience using OBIEE reporting tool.

Testing around ETL processes, migration testing, data mapping, testing of API calls.

Planning and documenting all stages of software testing from creation of test plans to detailed test cases development, execution, and incidents resolution.

Experience in creating UAT artifacts (such as UAT Test Plan, UAT Summary, Test Cases and others).

Experience working in Agile and Waterfall environments.

Proficiency with Oracle, SQL Server, MySQL, DB2UDB and other RDBMS.

Hands-on experience with test management tools and bug-tracking systems.

TECHNICAL SUMMARY:

Hardware: Pentium based computers, IBM AS400

OS: Windows platforms, HP UX

Databases: MS SQL Server 7/2000/2005/2007/2008/2010, Oracle 7/8/9i/10g/11.2, Sybase 11.X/12, DB2UDB 7/8, DB2 for OS/390 and z/OS 7/8, MySQL, ODBC/Data sources, AS400

Web: MIS, Web interface ASP.NET, Web 2.0 AJAX controls, Telerik RadControls for ASP.NET, Silverlight

Bug tracking / Source Control:

HP ALM 11, Mercury Quality Center 9.0/10.0, Seapine TestTrack Studio Pro, DevTrack and Jira bug tracking systems, PVCS/Serena, ClearCase, ClearQuest, Visual SourceSafe, Microsoft Test Manager (MTM)-part of the Microsoft Visual Studio- Premium 2012, version 11.0507

Misc. tools: Toad for Oracle Base 10.0.0.41, SQL Navigator 4.5, SQL Server Management Studio 10.5, Altova XML Spy, Page Engage, SQA for PeopleTools, PeopleTools 7.01, Crystal Reports 4.0.5.1, Autosys, MS Word 7, Excel 7, PowerPoint, SharePoint, MS Access 2.0, Salesforce CRM, MTM version 11.0507, Star system, WCIRB DynamicTool, SQL Developer 3.0, Calypso, Beyond Compare v 2.3.1, Microsoft Project 2010, OBIEE Reports 11.1, Toad Data Point 3.4

PROFESSIONAL EXPERIENCE:

06/15 – present QA / UAT Coordinator

Bank of the West, San Ramon, CA

Oracle 11g, Oracle Business Intelligence Enterprise Solution (OBIEE 11.1), Java, Informatica PowerCenter ETL tool, Microsoft Project 2010

Coordinate user acceptance testing for the Federal Reserve Annual Comprehensive Capital Analysis and Review projects (CCAR).

Develop UAT Test Plan that describes UAT approach, scope, schedule, and activities required to support the successful UAT. Identifies specific test items based on business requirements, risks and mitigations associated with UAT plan.

Manage user acceptance testing tasks by communicating across the development team, Finance QA team, and Business/Reporting team, organize meetings and support training efforts to ensure effectiveness of UAT initiatives.

Facilitate the defect review meetings and UAT status meetings with the project team (including development and business) on a weekly/daily basis.

Provide the testing timelines to the Project Manager during release planning.

Create Test Summary of the UAT projects for obtaining signoffs/approvals from the Business.

Provide technical expertise and guidance to UAT testers

Perform initial testing of the UAT environment before releasing it to UAT testers.

Perform data analysis of the edit checks defects found by UAT testers before releasing them to development

Prepare mockup data for business rules testing.

Validate business rules of the Federal Edit Checks for monthly and quarterly schedules by querying Oracle database and via OBIEE dashboard reports.

06/14 – 12/14 Senior Software Quality Assurance Analyst

Federal Home Loan Bank of San Francisco, San Francisco, CA

Oracle 11.2, PL/SQL, Java, Business Objects Data Services ETL tool

Participate in all QA activities for implementation of Calypso Front Office-Back Office (FOBO-2) functions. Calypso is an integrated suite of trading and risk applications to the capital markets.

Develop and execute end-to-end test cases for the newly implemented Calypso modules.

Use complex SQL queries to perform data flow testing of ETL batch processes, to verify database tables and views compliance with business requirements.

Create required test data for each test case, execute scheduled tasks to initiate data load and start ETL processing of the booked trades for the following instruments: Advances, Bonds, Deposits, Discount Notes, Derivatives, and Investments.

Test intermediate data at different stages of ETL processes (staging tables, fact tables, dimension tables, data comparison between source and target), validating data transformation based on the test conditions.

Test historical data and new trades created using Calypso UI.

Test Calypso functionality such as amortization calculation, maturity and termination functionality of the trades, hedge relationship, valuations, and market observations.

Test newly created DataMarts Extracts (Trade reports) for Advances, Bonds, DN's, Deposits, Investment and Derivatives.

Perform functional, integration, system and release-based regression testing.

Perform testing in agile scrum environment. Convert user stories created by business into test scripts.

Participate UAT (create User Acceptance Test scripts; perform hybrid testing with business; perform testing of the Business Intelligence reports).

Work closely with Business Analysts and Developers.

04/13 – 01/14 Senior Software Quality Assurance Analyst

Workers Compensation Insurance Rating Bureau of California, San Francisco, CA

C#,ASP.NET, MS SQL Server 2010, Visual Studio 2008/2010, Java Script

Performed system and regression testing of the Star system. STAR Online is an Internet-based tool for providing information and services to WCIRB member insurers, and licensed agents and brokers.

Participated in the creation of the regression testing methodology in this organization. Developed regression test suite for the multiple modules (Admin, MII, TPE, Form Filing, Safety Group, Search, Submission Manager, USRs, Fine List) of the Star system based on the business requirements.

Created test cases for the Unit Statistical Data (USR) and Policy Data Preprocessing Error modules with categorizing cases as Fatal errors, Permission errors, Critical errors, and Non-Critical errors, based on the business rules.

Performed reporting functionality testing of the Star system.

Developed and then generated data files for the batch processing of the USR, Policy, and Fine List modules by using the WCIRB DynamicTool. Performed test harness and then testing via database and UI.

Created test cases and performed functional testing of the migrated Star objects from mainframe to the MS SQL Server database (Migration R6 project).

Extensively used Microsoft Test Manager (MTM) system for project management and bug tracking.

Queried database directly to verify correctness of Data Preprocessing Error severities as well as Migration R6 project.

Involved in the walkthroughs of the check list functionality, test plans, and test cases created by other team members.

07/12 – 12/12 Senior Software Quality Assurance Engineer/QA Lead

11/11 – 02/12 Verizon Wireless, Walnut Creek, CA

11/08 – 12/09 B2B - My Business Account system. E-commerce, J2EE, Oracle 9i

Performed the full range of required QA activities.

Provided system and regression testing of My Business Remote Health Management (mhealth) and Network Extender projects.

Performed Smart Phones and Tablets testing of My Business functionality (iOS, Android).

Testing of Verizon mobile web applications using different mobile browsers, including Chrome, Firefox and Opera. Testing included Compatibility, Usability, and Performance testing using 3G, 4G and WiFi connectivity.

Performed functionality testing of the following modules for Verizon Wireless E-commerce My Business Account system: Account Maintenance Transactions, Commerce orders, Billing Services, Advanced reporting, Shipping Options.

Provided integration testing with the Merchant, Promotions, Deals and Discount Offers systems such as Ariba Buyer, Ariba Supplier, NetAce/POS, ECPD, WMS, WFM, Vision Billing System, and ACSS for cell phones, devices, calling plans, features, accessories and accessory bundles.

Assumed role of a QA lead on several critical projects, such as Free Shipping Promotions, Search for Billing Account Aliases for small businesses, implementation of new API calls for the account maintenance transactions, and Push-To-Talk validation for Motorola 7.4.

Prepared and conducted knowledge transfer sessions for newly implemented functionality and application features for business analysts, developers, and QA analysts.

Developed test cases requirements for implementation of new features.

Collaborated with the Project Team members to ensure that system is thoroughly tested, including the end to end business process functionality, interfaces, external systems, conversions, connectivity and security.

Performed release-based regression application testing by executing Mercury Quality Center regression scripts.

Performed system testing of the new functionality via IE6, IE7, IE8 and Firefox browsers.

Extensively used Mercury Quality Center for project management and bug tracking.

Queried database directly to verify correctness of XML code for testing of API calls for transaction processing. Used SQL Navigator, XML Spy.

Performed HBX Controls testing for the newly implemented application pages by using Page Engage tool.

Involved in the walkthroughs of the check list functionality, test plans, test cases requirements written by other team members.

Trained Project Team members on a basic testing competency skill set, including tools, methodology, and standards.

Participated UAT; performed hybrid testing with Business Analysts.

Use Agile Scrum environment for the small projects and Waterfall for the Enterprise products.

02/12 – 07/12 Senior Software Quality Assurance Engineer

Direct Partners Inc., San Francisco, CA

Direct Marketing, Customer Intelligence. C#, MS SQL Server 2010

Perform backend data integration testing of ETL processes for marketing database of iShares Team of exchange-traded funds management firm BlackRock.

Develop test plan and test cases for Contacts, Leads, Lead Activity, Account, Account Holding, Clients Profiling and other marketing modules.

Perform Functionality, and System testing of the project subject areas.

Perform parallel testing between existing system and newly implemented system.

Extensively used SQL for test case execution and test data preparation.

Prepare Mockup test data based on business logic.

Record and track status of issues and defects into Jira bug tracking system.

Use Agile methodology for project development, testing and implementation.

09/11 – 11/11 QA Lead / Sr. Software Quality Assurance Engineer

09/06 – 11/08 Goolara, LLC, Alameda, CA

Advanced Email Marketing Software and Hosted service

Silverlight, IIS, ASP.NET, Web Services API, MS SQL Server 2005/2008.

Established QA department/processes.

Took a leading role in organizing and performing all QA activities as a full time employee

Returned on contractual basis for testing of new modules developed with Silverlight technology for providing File Management and Isolated Storage features.

Performed testing of Salesforce CRM integration for email marketing.

Performed data migration testing of the Goolara/ Salesforce mail recipients for the Salesforce integration project.

Performed testing of the dynamic content tags (personalized mails) for improving click-through rates in email campaign performance.

Performed back-end and front-end regression software testing of Symphonie Email Marketing Software modules - such as mailings, campaigns, recipients, demographics, segments, topics, documents, content blocks, user permissions and others.

Developed test plan and test cases for application modules.

Performed functionality, integration, system and release-based regression testing.

Performed application testing via single and cluster service connectivity environments

Tested external (customer facing) application exposed as Web Services API, and internal web application written in ASP.NET.

Provided testing of the mail merge tags including click-throughs, open detection, subscriptions and dynamic codes.

Tested complete set of email editing features, including full-text searching capabilities for multiple composing languages.

Performed testing of Web 2.0 AJAX controls.

Tested Internationalization & Localization.

For localization, tested ability to create content directly in Symphonie's mail editor, or cut-and-paste from other sources, including the subject line for an email. Validated Symphonie's UI modules such as demographics, campaigns, topics, documents can be written in the language of your choice.

Tested internationalization elements, such as support appropriate fonts, support multiple character types, support reading and writing of external files, displaying text and data appropriate in GUI.

Tested search function with the language settings.

Tested Symphonie ability knowing desired time zone and adjusting accordingly.

Testing of mailing reports

Created and manipulated test data for functionality and volume testing.

Performed testing of application’s browser-specific features (Internet Explorer and Firefox).

Performed testing of the installer/uninstaller wizard.

Performed evaluation, selection, installation and maintenance of the TestTrack Pro bug tracking system.

01/10 -07/11 QA Lead / Sr. Software Quality Assurance Engineer

Wells Fargo Bank, San Francisco, CA

Web-based applications, MS SQL Server 2007/2008, Oracle 10g, C#, Informatica Power Center 8.6.0

Acted as a Team Lead in organizing and performing of QA activities for Wachovia-Wells Fargo Conversion projects (WHASEL2, Wholesale DDA Emerald Wholesale Identifier, and Exclusion Rules Reporting) and BOGART (Gap Analysis Repository Tool Database) project. Contributed as a team member to GSMOS (Global Sanctions Management Operation System) project.

Worked with the project team through the design and test stages to ensure complete coverage of business requirements in developed test cases. Developed Test Cases based on the Business Requirements for each conversion event, filled Requirement Traceability Matrix.

Created Master Test Plan for BOGART project. Participated in Master Test Plan creation for conversion projects.

Created and executed test cases for functional and regression testing for GSMOS project. Testing included both GUI and the back-end reports verification.

Created and executed complex SQL scripts to perform back-end verification of ETL processes.

Planned the testing timeline and provided labor and resource estimates for project planning. Provided summary reports of test results and project status to management.

Performed Functionality, System, Comparison, and Regression testing of the subject areas by executing Mercury Quality Center scripts.

Tested GSMOS Web-services functionality for using XML as data exchange mechanism (Real-time interfaces).

Performed parallel testing of the migrated accounts between Oracle and SQL Server databases.

Performed testing of the Exception Reports and Cognos Reports.

Created and managed testing environment (database, tables, views, materialized views)

Managed testing resources, distributed testing tasks for conversion project, tracked down status from QA team members.

Prepared documentation for the project UAT signoff and production releases.

Used Agile Scrum methodology. Converted user stories to test cases.

Extensively used Mercury Quality Center for project management and bug tracking. Logged detailed defect reports and followed through the defects resolution and closure.

Generated project status reports.

11/98 – 08/06 QA Lead / Sr. Software Quality Assurance Engineer

Embarcadero Technologies, Inc., San Francisco, CA

Database development, maintenance and productivity tools, .NET, C++, Oracle 10g, Sybase, MS SQL Server, DB2 UDB

Designed and developed test plans and test cases for the regression testing of the Embarcadero Technologies database and software development tools.

Performed leading and managing of QA team, coordinated offshore outsourced QA resources and projects.

Took a leading role in regression, functional and integration testing of DBArtisan, Rapid SQL, Change Manager, SQL Debugger, Profiler, and Code Analyst on cross-reference platforms.

Performed integration testing of the Rapid SQL Projects with Version Control System such as Visual SourceSafe, PVCS/Serena, and ClearCase.

Tested execution and debugging of database procedures, triggers, functions and packages with Embarcadero SQL Debugger on Oracle, Sybase, MS SQL Server, and DB2 UDB.

Created test data including large objects for various tests by creating and executing SQL scripts.

06/96 - 10/98 Software Quality Assurance Engineer

Intrepid Systems, Inc., Alameda, CA

Retail Management systems, COBOL, Oracle, MS SQL Server, DB2 UDB, UNIX

Comprehensive testing of the Client/Server Evolution tm application for Retail Business including regression, functional and integration testing of Merchandize/Distribution and Financial modules for Beta and GA products.

Created new and expanded existing test scripts for the new product based on PeopleSoft Tools 7.X. Product utilizes Intrepid Datamodel and COBOL programs. Performed Black-Box on-line testing on SQL Base, SQL Server, Oracle 7 and on DB2 for UNIX, as well as in-depth database testing using SQL.

Prepared test data for various tests, using both on-line screens and SQL scripts for populating database tables. Executed Unix shell scripts to upload test data from flat files and performed testing of the imported data in application modules.

Used Autosys to execute automated loading processes.

Performed automated data creation and testing with SQA TeamTest testing tool.

Tested Crystal and COBOL Reports for the assigned product areas.

Education:

Management and Economics of Industry

University of Transportation

Kharkov, Ukraine

Continuing Education:

DB2/UDB for Windows IBM Training Center

Automation tool SilkTest v5.03 In-house training

Introduction to PL/SQL UC Berkeley Extension

Essentials of Oracle for DBAs UC Berkeley Extension

Oracle Basics: SQL UC Berkeley Extension

PeopleSoft Tools Training PeopleSoft Training center

Methodology of Software Quality Assurance Integrated Resource Systems

Contact this candidate