Engineer Sql Server

INNA SHINKARSKY

**** ******** **. *******, ** ***11

Phone: 510-***-****, 415-***-**** *********@*****.***

LEAD SOFTWARE QA ENGINEER

15+ Years of Enterprise Software Engineering Experience

Quality Assurance Expert Development Experience Strong Test Automation Skills

QA Lead with multi-facetted SDLC experience of high complexity products with Blueshield, SAP, Sybase and IBM. Responsible for articulating QA strategy, efficient test planning and execution. High quality software releases delivered to hundreds of customers (Medical insurance, major banks, insurance companies, telecom and manufacturing) across the Globe.

Technical Skills

Expertise in Functional/ Regression/ UAT/ Mobile/ Integration/ Load/ Performance and System/ Certification Testing

Test Automation Frameworks: Selenium WebDriver, Junit/TestNg, Maven, Jira, ALM/ UTF, C/ TCL/ Unix Shell, Java/C/UNIX Shell, REXX

Programming Languages: C/C++, Java, JavaScript, JCL, Assembler, Cobol, Vbasic

Shell Scripting/ TCL/ Perl/ Python

Strong SQL knowledge

Database Internals: DB2, Oracle, Adaptive Server Enterprise, SQL Server, Replication and Backup Technology, IBM TSM,

HANA

Web Technologies: HTTP, XML,

Application Servers, SOAP, JavaScript, MQSeries, JDBC, Eclipse IDE

Operating Systems: various flavors of Linux/Unix, Windows NT, Apple Ios, Android, CICS, MVS, IMS on z/OS

Debuggers: GDB, DBX, VB debugger, XPEDITER

Code Analysis Tools: Coverity, Fortify

Code Management Tools: Clearcase, IBM Rational family of tools

Employment History

Blueshield of CA: 2016 – Present

Senior QA Analyst(Contractor)

Developed test plans and test cases for the functional, UAT, Regression and Integration testing for the wide range of Blueshield Medical Insurance products (Renewal Automation, Wise Choice, Consumer Billing, CSA) and platforms ( Member Portal, Phoenix, Facets, eBrokers)

Closely worked with System and Business Analysts and development on improving system design and usability and to anticipate and eliminate possible production issues before they happened.

Test automation with Selenium, TestNg, Maven, Jira, ALM

Helping UAT teams with E2E Integration testing for the Member/ Broker/DSA/CSA/Ebroker flows

WebServices SOAP UI testing

Backend Facets testing

Responsive Web and Mobile (Apple Ios/Android) Testing

Responsive Web Testing

Agile development environment

SAP (through Sybase acquisition): 2010 -2015

Sustaining Software Engineer for the Adaptive Server Enterprise (ASE) and ASE Backup technology.

Worked closely with Product Management on enhancing new ASE Backup Server features:

dump configuration support

dump history support

parallel scan feature

integration with Tivoli Storage Management (TSM)

64-bit version of ASE Backup Server on IBM AIX, IBM Power System Linux (p.Linux), SUSE Linux and Solaris

Worked with Support and Professional Services on addressing critical production issues for active versions of ASE family of products.

Collaborated with QA to ensure sufficient test coverage for enhancements and bug fixes.

C/C++, shell scripting, SQL, HANA, Unix, Linux, HPUX, AIX, Microsoft Windows Server, TSM IBM, Codeline management and infrastructure, Debuggers, Code analysis tools (Coverity, Fortify), QUASR(in-house TCL based automated test execution tool), Agile methodology.

Software QA Lead for XJS/390 Web-to-Mainframe project.

Led QA of Server-Side JavaScript interpreter/compiler on z/OS (IBM mainframe): rapid application development tool for building Web Services/Application Server components deployed on IBM mainframe server. The tool enables browser-based client access to data and transactions on IBM mainframe: CICS, VSAM, DB2 over HTTP, XML, SOAP, MQSeries, CORBA. Tool made Web-enablement of legacy mainframe application simple and efficient.

provided input to Development on feature usability and testability

ensured XJS/390 compliance with W3C specifications

defined and implemented QA processes and procedure

designed and maintained QA frameworks for automated testing

led test planning and schedule

supervised QA activities

coordinated test execution for functional, usability and scalability testing.

HTTP, XML, SOAP, SOA, CORBA, MQSeries, JavaScript, Java, JDBC, SQL, Windows, Unix, Sybase Enterprise Application Server, MS Transaction Server, Selenium, TestNg, Eclipse IDE, IBM z/OS, CICS, DB2, VSAM, JCL, SPUFI, REXX

Lead QA on DB2-to-HANA (in-memory columnar database) Replication Certification Project.

Held weekly meetings with project management, professional services and development. Configured heterogeneous environment for end-to-end testing. Executed functional and performance tests and filed bugs and enhancement requests. Produced certification metrics.

HANA, ASE Replication Server, ASE SQL Server, DB2, SQL, stored procedures, Linux, UNIX, MVS, JCL, SPUFI.

Sybase, Dublin, CA

Test Engineering Lead, Server Engineering 1996-2010

QA and Platform Certification of Sybase Client/Server Unix/Windows- to- IBM z/OS connectivity products

Open Client/Open Server (Gateway Library of API)

Replication Agent for DB2 z/OS to Adaptive Server Enterprise SQL Server

Mainframe Connect for DB2 (Dynamic SQL processor for Unix and Windows clients connecting to DB2)

Responsible for project management, certification testing, QA of ongoing releases of Sybase Mainframe Connect with current versions of operating systems and databases (IBM DB2, SAP HANA, ASE SQL Server, MS SQL Server). Led regression, installation, integration and system testing, generated certification metrics and reports.

SQL, UNIX, Windows, DB2, SQL Server, IBM z/OS, DB2, C/C++, JCL, CICS, IMS, MVS, TSO, REXX, SPUFI, RACF.

Replication Agent from DB2 z/OS to Sybase Adaptive Server Enterprise on UNIX and Window servers.

Developed test plans and test cases for functional, configuration, installation, performance and stress tests.

Set up and managed end-to-end test infrastructure:

oDB2 database on z/OS.

oReplication Agent for DB2 on z/OS

oASE Replication Server on the LAN

oASE and MS SQL Server on the LAN

Coordinated release activities

Led bug triage, reporting and tracking

Senior Test Development Engineer, 1993-1996

Developed test plans, test metrics and automated test cases for functional, performance and platform testing of Client/Server API and middleware products.

ODBC DRDA connectivity for DB2

Open Server Connect for CICS, IMS MVS

Open Client Connect for CICS, IMS, MVS

LU62, TCP/IP Direct Connects, Netgateways on AIX, HP, Solaris, NT

IBM Santa Theresa Lab, Language Products Division, San Jose, CA

Senior Test Development Engineer (Contract) 1991 –1993

Developed test plans, test metrics and automated test cases for COBOL, FORTRAN, Assembler and PLI compilers

EDUCATION: MS in Mathematics from Mechnikov University, Odessa, Ukraine

Contact this candidate