Test Cases Project

Lilia Vladi

Wheeling, IL

*****.*****@*****.***

Phone # 847-***-****

Executive Summary

Experienced, analytical, self-motivated and highly productive Business/Software Quality Assurance Analyst with experience in writing business requirements, manual, automated testing and development in various industries including automated retail, insurance, financial and telecommunications. Significant project experience in all aspects of software life cycle including requirements, design, implementation, quality assurance, maintenance and customer support. Deep QA knowledge and extensive experience in building and leading a highly motivated team of QA Engineers/Analysts responsible for the testing and support of a complex, multitier software platform. Experience with full SDLC in an Agile (Scrum and Kanban) environment. Strengths include experience in wide range of testing roles including White/Black box, functional, regression, integration and data driven testing. Excellent technical skills, attention to detail, strong debugging and problem solving skills.

Relevant Experience

Solid experience in analyzing requirements, creating design documentation, test plans and test scripts, test case execution, defect management and resolution and the development of accurate test data.

Experience in verification and validation testing as well as performing manual testing of web and client-server software developed with Java, .NET and Web Services-based architecture, ETL processes and BI objects (Cubes, Reports, Dashboards).

Strong SQL skills including recent experience creating complex joins for Outerwall/Redbox projects.

UNIX experience for five years including creation of UNIX control scripts.

Defect tracking tools background includes TFS, Mingle, HP Quality Center, Jira.

Extensive database testing on SQL Server 2008/2012, Oracle and DB2.

Background includes testing of financial applications for JPMorgan Chase, BCBSA and Outerwall/Redbox.

Project Experience

QA Team Lead/ Sr.QA Analyst

Redbox/Outerwall Inc.

March 2010 – Present

Business Intelligence, Data Integration, Platform Services QA Teams

Hands-on BI/DI Team Lead of QA Analysts that were responsible for the testing of all reporting and analytics deliverables for Redbox and new ventures lines of business, enhancements for existing Data Warehouse, Data Marts and ETL processes or completely new ones. Also lead the testing of a set of web applications, windows services and web services (SOAP and REST) that comprise Redbox's Platform Services team.

Worked with multiple Scrum teams that have varying sprint lengths ranging from one week/every two weeks to four weeks.

Worked with Product/Business teams to clarify requirements and business scenarios.

For each production release, created and maintained all QA documentation, including test traceability matrices, and post-deployment defect metrics.

Wrote and executed manual test cases, and reviewed test cases written by other QA Analysts with Developers and Business Analysts to ensure requirements were interpreted correctly.,

Administered mid-year and end of year performance reviews and guided employees in their professional development by championing for training on tools and best practices.

Interviewed new contractors and full-time employees for BI/DI/Platform Services QA teams.

Established and continually improved QA processes within the teams.

Reported status of testing activities to QA Director and Project Managers.

IT Environment: Agile ( Scrum, Kanban), Microsoft Office 2010, Microsoft SQL Server 2008/2014, SoapUI 5.0.0, TFS, Mingle, JIRA, SSIS, SSRS, SSAS, TortoiseSVN,, .NET and Web Services-based architecture, XML, Planview, Econometrix, XML

Senior QA Analyst/BSA

BCBSA

September 2007 – February 2010

Information Management, Product Verification Group

Provided QA and data analysis services on Information Management (IM) Project. Responsibilities included writing testing related documents, understanding business processes, writing and executing test cases and building efficiency and effectiveness into the testing process. This application has a Cognos, web-driven front-end and Mainframe DB2 backend.

Developed test plans for all functional IM components such as extract data, data movement, load data marts, BI Cognos Reports, browser and security testing.

Analyzed source and target data based on business requirements and BPRs.

Wrote and executed test scripts, logged defects and prepared and maintained test data.

Analyzed and identified the root cause of anomalies encountered by reviewing log files and database tables and created complex SQL queries.

Wrote complex SQL joins to connect up to seven tables for data validation.

Worked with developers to resolve issues found.

Developed recommendations and designs solutions for process improvements.

Assisted project manager with business gap analysis support (business requirements, specifications, etc.) as needed.

Created the test data for specific business scenarios. Modified .dat files in UNIX box.

Aggregated the UNIX scripts to run ETL jobs.

Used ClearQuest for defect tracking.

Responsible for testing IM project as quickly as possible for the large number of short delivery cycles.

Performed exploratory testing at various stages of the life cycle. Scope of the work included asking the right questions and creating test cases within a few hours.

IT Environment: DB2, Mainframe, TOAD for DB2, ClearCase, ClearQuest, RequisitePro, HP Quality Center 9.2, Ab Initio, .NET and Web Services-based architecture, Cognos 8, UNIX, UNIX scripts, MS Windows, XML

Defect Manager/QC Coordinator

Allstate

November 2005 – September 2007

Alliance, Common Services Team (1+ year)

Performed defect/project management duties using Rational ClearQuest which included tracking defect resolutions and project activities. Deployed the updated software on development servers and request the deployment to production and functional/regression testing environments.

Developed effective work plan with timeline and resources.

Worked closely with the business and development teams to coordinate and schedule fixing of defects.

Communicated with project management and developers on all defect related issues.

Wrote SQL queries for target to source data validation based upon business data requirements.

Provided management with status reports on testing and defect fixing progress.

Set goals and objectives for a given project with testing team members.

Provided defect status reports and data analysis and ensured flow of communication between groups.

IT Environment: SDLC, ClearCase, ClearQuest, WebSphere 6.0, Java, .NET and Web Services-based architecture, Microsoft Project, MS Windows

Senior Quality Control Analyst, Claim Technology Services, NEXT GEN (Release 0.5) - Auto Claim Transformation (8 months)

Responsible for leading and testing projects based on agreed upon scope for managing resources that write test scripts and test the NextGen applications, for the interaction with business clients to ensure required specifications are met, for defect identification, documentation, communication and follow through to resolution according to business requirements and for reporting of testing progress effectively.

Worked closely with the business and development teams to coordinate and schedule testing efforts.

Mentored junior members on the Testing Team on test processes.

Analyzed business requirements to identify testable requirements.

Set goals and objectives for a given project with Testing Team members.

Wrote SQL queries for data validation based upon business data requirements.

Developed test scripts based on business and functional requirements.

Coordinated functional and regression testing efforts with Project Team.

Performed data analysis of executed scenarios to ensure data integrity and carried out validation procedures to ensure all system modifications met end-user requirements and quality standards.

Provided feedback to the managers of Project Team members on testing performance for inclusion in the overall performance management process.

IT Environment: NextGen, SDLC, Crystal Enterprise, Mercury TestDirector 7.6 SP4, SQL Plus, VSS,

TOAD for Oracle, SQL, Oracle 9i

Senior Software Quality Assurance Analyst

JPMorgan Chase

July 2005 – November 2005

Rit/Remitone Quality Control Team

Responsible for complete quality assurance effort of bank financial applications, developed with the technologies such as Java, C#, .NET and Web, Visual Basic, C++ based architecture with XML, using manual test procedures.

Communicated effectively with members of software development, product support and other project related groups to ensure project and customer satisfaction objectives were met.

Assisted with functional, system and integration testing in accordance with company standards and processes across diverse platforms.

Participated in the development of overall test strategies/test plans for manual testing including definition of test cycles and schedules.

Wrote SQL queries for data validation.

Identified test cases for functional and regression testing.

Documented and tracked defects and produced detailed reports using defect-tracking tool.

IT Environment: RemitOne, Microsoft Project, ClearQuest, SDLC, SQL, Oracle 9i, SQL, Crystal Reports, TOAD for Oracle, XML

Senior Quality Assurance Analyst

Allstate

August 2004 – June 2005

ISG/Data Strategy Quality Control

Responsible for complete quality assurance effort of time-sensitive financial applications, preparing and executing test cases, creating QA documentation and test coverage reports.

Analyzed business requirements to identify testable requirements for several migration projects (history migration, bridge, daily load).

Designed, documented, developed and compare graphs and tested efficient Ab Initio ETL graphs and PL/SQL processes and tested Business Objects reports.

Modified UNIX scripts to run specific ETL jobs.

Developed functional test plan based on business and functional requirements. Conducted functional test plan inspections. Coordinated functional testing effort with Project Team.

Executed functional and regression test plans and identified and documented defects. Performed data analysis of executed test cases to ensure data structure integrity and also carried out validation procedures to ensure all system modifications met end-user requirements and quality standards.

Developed enhanced test models and techniques. Supported the creation and maintenance of test data and test environment.

IT Environment: ab Initio, GDE 1.13, EME 2.13, MFS, UNIX (Solaris), UNIX scripts, Business Objects (Web), SQL, UNIX scripts, Oracle 9i, TOAD, Mercury TestDirector 7.6 SP4, VSS

Ab Initio Developer/Tester

Compact Solutions LLC

October 2002 – August 2004

Worked as part of a team designing and implementing Sales and Inventory Project by extending the existing data warehouse and tested display location reporting application that summarized and ranked the sales data of the display locations in a store within its peer group at item, display location and store level for a scanning week.

Wrote new manual test cases and reviewed existing test cases. Selected cases for automation following industry standards for test automation guidelines in a highly regulated environment.

Wrote testing documentation simultaneously for each active project.

Created test scripts and automated test plans with data driven case scenarios and GUI validation scripts.

Set up test environment and created business scenarios to test functionality.

Develop UNIX control scripts, configured tools to test applications and executed user acceptance testing.

Used ab Initio multifile system on different nodes to speed up data processing.

IT Environment: ab Initio, UNIX (Solaris), Oracle 9i, SQL Plus, SQL Loader, TOAD, Mercury TestDirector 7.6 SP4, QTP 6.5, C++ based architecture with XML

SQA Engineer

Lucent, Inc.

October 2000 – August 2002

SQA Sustaining Department

Performed software upgrades of CBX-500, BSTDX-9000, GX-550 ATM switches.

Responsible for SQA activities for Lucent’s remote access products, including full lifecycle testing process and proper documentation, worked with engineering to ensure the validity of SQA processes during the development cycle.

Documented test plans, test cases and testing results.

Tracked and documented bugs.

Executed tests for new features, regression and stress testing on ATM switches by using Traffic Generator (Adtech) and automation test tools.

Tested Web-based applications written in VB, C++, Java, JavaScript and HTML.

Performed functionality testing on both Internet Explorer and Netscape browsers.

IT Environment: UNIX (Solaris), Windows NT, C, C++, Java 2, VB, HTML, GUI-NAVIS Core, ClearCase, Adtech, ATM, FR, T1/E1; OC-3, OC-12, OC-48, DS-3, DS-310

Supplementary Training

Lean-Agile Project Management, September 2014, 24 hours

QA/Web Testing using QuickTest Pro (QTP), ACT, June 2006, 65 hours

Data Warehousing Techniques, Compact Solutions, October 2002, 300 hours

Education

MS in Computer Engineering and Control Systems, Minor: Computer Science, Kiev Polytechnic University, Ukraine

MS in Marketing Statistics, Kiev Pesotsky Economics, Low and Management Systems University, Ukraine

Contact this candidate