Resume

Sign in

Sql Server Test Cases

Location:
Redondo Beach, California, United States
Posted:
August 31, 2017

Contact this candidate

SOPHIA PASTERNAK

Phone: (310) ***-****

(310) ***-****

**** *********** ** #* *** Angeles County,

South Bay region; Redondo Beach, CA 90278

Email: ac13bn@r.postjobfree.com

Education B.S. in Mechanical Engineering (Minor in Software Engineering) - Technical College, Odessa, Ukraine

Certification /

Training Microsoft Certificate in:

Designing and Implementing Databases with Microsoft SQL Server

Microsoft SQL Server Database Management

California State University of Long Beach Certificate program: PowerBuilder Training

UCLA Extension: PowerBuilder PFC Libraries (PowerBuilder language)

Sybase Education: Multiple courses in the PowerBuilder environment

El Camino College: Visual Basic, Java, UNIX, Web Programming, Systems Analysis & Design

Skills Software SQL Server, Oracle, Access, Toad, ERWin/ERX2.5, Rational Robot, WinRunner, Compuware, Bugzilla, ClearQuest, VBScript, JScript, T-SQL, PowerBuilder, Visual Basic, Visual Studio.NET, Java, HTML, XML, MS Office, Crystal Reports

Browsers Internet Explorer, Firefox, Safari, Opera, Chrome

Operating Systems Microsoft DOS, Windows, IOS, UNIX, Linux

Visa Status US Citizen

Professional

Summary QA professional with over 15 years of IT experience and background in the software product industry, software development and quality engineering roles

•7 + years of experience working with Agile methodology

•Strong knowledge of software development life cycle (SDLC) processes. Assisted and facilitated testing phases for applications

•Solid experience in development and implementation of test plan, testing strategy, schedule, test scenarios, data preparation, test cased execution for Web based, Client/Server, APIs and Mobil applications.

•Experienced with Java, JavaScript, XML, Web Services, Rational Robot tools

•Conducted QA project of integrated Security Token Service for credit card payment process

•Ability to understand customer use cases and prioritize test cases accordingly

•Excellent knowledge of Object Oriented concepts

•Detail-oriented, Strong analytical and trouble-shooting skills

Professional Experience

2015 to 2017 NCR Inc, Aliso Viejo, CA

SQA Analyst (Contract )

Worked in NCR Corporation (formerly National Cash Register), which is a US-based computer hardware, software and electronics company.

Company implementing EMV chip technology, that protect customers and allow improving security, creating a multi-layered defense against card fraud Participated on the project ‘EMV chip Technology Integration’

•Validated EMV migration process: Tested the Point-of-Sale transactions process on Visa/Discover/Mastercard/Express and other smart cards

•Setted up the terminal configuration for each brand Performed testing on EMV contact chip and contactless chip terminals interfaces (POS and IPad, iPhone) prior to deployment

•Participated in cross functional reviews of requirement and design documents, developed and executed comprehensive test plans and scripts

•Monitored and analyzed card-terminal transaction log files

•Validated the back-end data: created and executed queries on SQL Server

•Troubleshooted and verified hardware and software issues Reported and managed defects in BugZilla tracking system

•Worked on testing Android, iOS, C#, ASP.NET and other software modules as part of a QA group

•Communicated and worked closely with internal and external resources

•Participated in the Daily Scrum meeting

2014 Wells Fargo Bank, Santa Monica, CA

SQA Analyst (Contract)

Actively participated in Capital Finance Application Migration Project (CFAM).

The purpose of this project is to migrate financial applications to the new data center.

•Performed Functional and User Acceptance testing on: LOS (loan origination software & LOAN ORIGINATION SYSTEMS), LUCAS, CLIC, CHOICE; Functional testing of CRM application (PeopleSoft Inc provided)

•To ensure the proper testing process used pre-migration application compatibility approach

•Developed and maintained test plans, test cases, test scenarios.

•Reported issues in Jira tracking system

2010-2013 NBC Universal, Los Angeles, CA

SQA ENGINEER

Participated in the QA process in NBC Golf Technology group that offers users advanced capabilities of booking golf tee times through E-Commerce applications. Coordinated multiple concurrent projects. Worked independently or with teams in Agile Development environment, which emphasizes iterative software design

•Developed and implemented test plan objectives including testing strategy, schedule, test scenarios, test cases and data preparation.

•Performed Functional, Regression and System Integration tests across all environment.

•Executed test cases for valid and invalid conditions.

•Coordinated User Acceptance testing for Web based, Client/Server, APIs and Mobile applications.

•Led QA project of integrated Security Token Service for credit card payment process.

•As a QA verified the Credit Card Authorization process through e-commerce web site.

•Responsible for testing credit card Payments/Transaction process. Validated credit card Payments/Transaction against the payment gateway Chase Paymentech.

•Tested Security Service in Informatica Dynamic Data Masking environment that provides real-time capabilities to prevent unauthorized users from accessing sensitive information.

•Validated the back-end data: created and executed queries in SQL Server and Oracle databases

•Performed testing of Web Services, especially REST API using the HTTP requests: GET, POST, PUT and DELETE. Reviewed and validated data in XML file

•Tested File Transfer process on FTP using Filezilla as FTP Client.

•Communicated with developers and project management to ensure product quality and scheduling accuracy.

•Worked closely with business analysts to analyze business rules and requirements

•Recorded tracked anomalies and created status reports using tracking system (Jira, Mingle, BugZilla, HP Quality Center ).

2009-2009 Symantec Corp., Culver City, CA

SQA ENGINEER (CONTRACT)

Responsible for validating Stock-Keeping-Units (SKU) and creating several of reports for customers demand and for inventory planning

Tested B2B software Watchdog Web based service which offered visibility for online activities and computer usage

Test environment: .Net, OLP, Excel, Toad, Oracle, SQL Server

•Ran queries against of QA and Production databases for SKU data validation and reports

•Migrated data from ASCII and Excel files to Oracle and SQL Server databases using DTS (Data Transformation Services)

•Tested the Purchase Flow process of Watchdog service for Sales and Renewals through online store front Established the testing strategy and created documentation of Watchdog testing process

•Performed testing in English and other languages

•Verified Payment methods made in different currencies

•Verified the product in testing levels: Unit, Functional, Security, Compatibility, Regression, System Integration and User Acceptance tests

•Created defect records and status reports in Visual Studio environment

2008-2008 REOTrans LLC, Los Angeles, CA

SR. QA ENGINEER/ QA LEAD (CONTRACT)

Involved in the design of a new QA infrastructure for Web based Management System.

Test environment: ColdFusion, .Net, MS SQL database

•Created a comprehensive project plan for QA Process integration. Defined the start point for QA process in the SDLC within the organization (Pilot QA Process).

•Created flowcharts of the Waterfall lifecycle processes.

•Established and deployed the general strategy of QA process for releasing new software products.

•Defined the QA standards that are tailored to the business logic of the company.

•Designed templates for test plan and test case.

•Performed Functional/Regression and User Acceptance testing for existing applications.

•Used the TrackStudio system for management of: Tracking issue resolution, Requirements gathering, Project monitoring and reporting.

•Led presentations for account managers in focus: CMMI Adoption, Specification improvement, Benefits and Advantages of Software Quality Assurance.

2006-2008 City National Bank, Los Angeles, CA

SR. QUALITY ASSURANCE ANALYST

Participated in analysis, design and QA processes throughout the Software Development Life Cycle in the testing environment: .Net, SAP CRM, Business Object, Java, SQL Server, Oracle, Compuware, QTP

•Responsible for QA validation of the reporting system created in the Business Object Enterprise Environment.

•Validated reports in the specific subject areas as:

- Loan Account Summaries, Loan Snapshot Report.

- Losses (Past Dues, Loan Losses Operating Losses)

- Portfolio Management (Timely/Accurate Grades)

•Performed End-to-End and User Acceptance testing of EASI application which automates the processing of banking transactions.

•Tested to insure that enabled clients to securely initiate transactions: Wire Transfer, Stop Payment, Book Transfers, ACH Transfer and other banking services.

•Participated in the project upgrading the Data Warehouse Business Intelligence.

•Analyzed Source to Stage and Stage to Target mapping documentation based on ETL transformation rules and technical requirements.

•Created the testing strategy, test plan and test cases for ETL validation process.

•For the testing purpose imported and exported data to and from data sources, including ASCII files, using SQL Server Data Transformation Service tool.

•Validated source and target data from Staging Database to Star Schema Database using Compuware File-Aids and Brio Intelligence tools, to ensure that ETL processes performed correctly.

•Created and executed SQL queries in Toad and SQL Server Management studio environments.

•Responsible for recording and tracking anomalies using Compuware TrackRecord system.

2004-2006 Media-Services, Los Angeles, CA

ROGRAMMER/AUTOMATION ENGINEER

Participated in Automated Functional and Regression testing using IBM Rational

Robot.

Performed testing of Accounting and Payroll system application implemented in .NET, Delphi, VBScript, and SQL Server.

•Designed and implemented test automation strategies and test cases.

•Recorded and played back GUI functional test scripts.

•Created verification points for objects comparison during playback.

•Manually created test scripts for automated testing using SQA Basic language.

•Used ADO Connection Object for accessing, manipulated and validating data through open source connection.

•Scheduled automated System Integration Test for each release.

•Analyzed Rational Robot automatic logs and reported status of test result.

•Responsible for weekly Build-test-release process.

1998-2003 Satisfusion Inc, Long Beach, CA

SR.PROGRAMMER ANALYST

Actively participated in the front-end and in the back-end development of Claims Processing System. Created code for user interface event driven applications. The system was written in PowerBuilder, Visual Basic, Java, SQL Server, Sybase, SQL Anywhere, Crystal Reports, Windows NT and Linux platforms.

•Designed and implemented code for claims validation process and data entry screens in PowerBuilder and Visual Basic.

•Developed and maintained client reports in PowerBuilder utilizing Embedded SQL and Stored Procedures.

•Participated in the migration of PowerBuilder Web application to an Active Server Pages environment.

•Rewrote the logic utilizing XML, ASP, VBScript and JavaScript.

•Created SQL views for security purposes and created rules and triggers for enforcing business rules and data integrity.

•Used SQL Profiler to trace events within SQL Server to determine and resolve applications and queries issues.

•Maintained data models using ERWin/ERX and PowerDesigner.

•Redesigned databases, created and modified tables using Reverse Engineered (ERWin tools).



Contact this candidate