JOHN KURCEBA
Audubon, PA 19403
*******@*****.***
PROFESSIONAL SUMMARY
Nineteen years of experience analyzing, designing, developing, programming, testing, and supporting systems and applications for a variety of critical business functions. Industry experience includes medical, software, energy, telecommunications, financial, military, and benefits administration.
TECHNICAL QUALIFICATIONS
Languages: PL/SQL, SQL, PERL, Groovy, C, Pro C, HTML, COBOL, Java, Javascript, UNIX Shell
Software: Oracle, Denodo, TOAD, SQL Server, SQL Server Management Studio, MySQL, IBM Business Process Manager, HP Application Lifecycle Management, HP LoadRunner, TestRail, Jenkins, GitHub, HockeyApp, Postman, Rational ClearCase, Rational TestManager, JMeter, JIRA, Confluence, Parasoft SOAPtest, Selenium, Protractor, Geb, Spock
Operating Systems: Linux, UNIX, OSX, Windows, Android, IOS
EXPERIENCE
DAVITA, Malvern, PA
Senior QA Integration Engineer (Contractor – Ivanteq) Jan 17 – June 17
Perform integration testing on software used by medical personnel to facilitate kidney dialysis for patients. Validate data, end-to-end, from inception in multiple legacy systems to newly created mobile platform presentation layer. Validation was performed on database layer, data virtualization layer, multiple middle tier application layers, and on IOS mobile device.
Created and executed test cases in HP Application Lifecycle Management tool. Held meetings for test case reviews with QA Integration Team. Submitted defects in JIRA, represented defects at triage meetings, and worked with developers to reproduce defects and validate fixes. Document QA Integration procedures using Confluence. Performed regression testing for frequent software releases. Wrote SQL statements to create, update, delete and query data for testing. Edited and ran Postman scripts to perform API testing. Used IBM Process Inspector do validate data in process flows.
ZONOFF, Malvern, PA
Senior QA Engineer Sep 15 – Dec 16
Test IOT home automation and security software on web browser, cloud, mobile device, security panel, and smart home hub platforms. Work to validate rapid software changes in a continuous integration environment. Perform application testing on OSX, Windows, Linux, Android and IOS operating systems. Actively participate in an Agile software development process.
Create and execute test cases in Testrail. Hold meetings for test case reviews with developers, product team, and QA peers. Perform software builds using Jenkins. Use HockyApp to manage and install mobile software. Submit defects in JIRA and work with development team to resolve issues. Document procedures using Confluence. Perform regression testing for software branches and beta software builds. Write SQL statements to create, update, delete and query data for testing. Create and edit Postman scripts to perform API testing. Write test scripts for automation and regression using Javascript, Protractor, Groovy, Jeb, Spock, and Selenium.
PJM INTERCONNECTION, Audubon, PA
Senior Quality Analyst (Contractor – Turnberry Solutions) Jan 13 – Sep 15
Perform testing for the conversion of a system ID request form to a Cisco Prime Service Catalog format. Create and execute test cases to facilitate verification of GUI forms and emails throughout work flows. Submit defects and assist development team to resolve them. Perform production verification of software functionality.
JOHN KURCEBA
Page 2
Responsible for testing an ESB system used to store personnel data in an Oracle database and integrate it with other applications. All validation was done via database SQL statements/DB tools, as there was no UI for the application. Worked with design and development teams from inception of system to ensure software design facilitates effective testing. Developed strategies and plans for testing each software release. Created manual test cases, executed them, and submitted defects using HP Quality Center. Developed SQL queries to validate data in Oracle and SQL Server databases. Used SQL statements for test data creation, data cleanup, and migration of data from production. Developed and executed test scripts for automation and regression using UNIX shell scripts and programmatically generated SQL. Performed coordinated testing with team members of integrated applications. Responsible for analyzing and resolving production support issues of personnel data system as well as other affected systems. Created and tested SQL statements for use by operations team to correct data to resolve production issues.
NOKIA LOCATION & COMMERCE (NAVTEQ), Malvern, PA
QA Automation Engineer (Contractor – Devon Consulting) April 12 – Dec 12
Responsible for testing the conversion of back-end traffic software systems for use by a traffic media vendor. Tested software upgrades of GUI traffic tools for business users. Designed and developed automated tests to perform extensive validation of data in a MySQL database against a Web GUI front end. Configured and executed load tests to verify traffic system threshold. Interacted with client to understand software functionality and test requirements. Worked with developers to configure and validate applications in different environments. Actively participated in an Agile software development environment.
Created and executed manual test cases. Wrote and executed test scripts for automation and regression using Groovy, SQL statements, and shell scripts on a CentOS Linux platform. Performed load testing with JMeter.
COMCAST SPOTLIGHT – West Chester, PA
QA Performance Engineer (Consultant – Turnberry Solutions) Jan 12 – April 12
Responsible for creating all performance test solutions for the advertising division of a telecommunications company. Interacted with client to understand performance test needs and requirements for applications. Created performance test strategy and process to be used for all applications in the division.
Created test plans and dashboards for performance test efforts. Worked with project management, development, and business to develop load models and scenarios for performance testing. Scripted and executed performance tests using HP Performance Center. Developed SQL scripts to extract information from a SQL Server database to feed performance test scripts.
NOKIA LOCATION & COMMERCE (NAVTEQ), Malvern, PA
QA Engineer (Contractor – Devon Consulting) May 11 – Jan 12
Performed QA functional testing of a system processing global traffic data. Tested system configuration for expansion of traffic data collection in new countries/regions. Performed tests of probe data coming from outside providers into internal web services and validated that it was loaded properly into databases. Tested probe, flow, and incident traffic data collectors for various countries.
Interacted with project management to create estimates and timelines for testing. Worked with developers to configure and validate applications in different environments. Reviewed requirement documents and release notes to develop testing strategy. Created, documented, and performed each step in the testing process with formal test plans, test cases, test results and production verification plans. Held meetings for test case reviews with developers, operations, and QA peers for each project. Actively participated in a Kanban software development process.
Created and executed shell and Python scripts for testing purposes. Modified XML files for positive/negative incoming data feeds testing. Analyzed and validated output product XML. Developed and executed SQL queries for the validation of maps, traffic probe data, and new market creation. Validated software functionality, configuration, and monitoring in production environment.
JOHN KURCEBA
Page 3
COMCAST, Mount Laurel, NJ
QA Performance Lead (Consultant - pureIntegration) May 05 – Apr 11
Responsible for all activities of a consultant performance test team. Interacted with client to understand and gather test requirements. Represented performance team at internal client meetings.
Performance tested provisioning, modem activation, billing, and account management systems using in-house Perl and Java applications, HP LoadRunner, and Rational TestManager. Created and modified LoadRunner scripts for performance testing. Developed shell scripts to ensure test environment is functioning properly and to monitor machine activity during performance testing. Performed configuration and troubleshooting of QA test environment through various modifications and upgrades.
Designed and documented methods for testing an online email personal address book. Coded software in Perl and UNIX shell scripts to generate test data for functional and performance testing. Designed and coded software in Perl to generate variable loads against system and produce reports on system performance. Performed load testing against web services code using Parasoft SOAtest. Deployed and monitored software applications in a Weblogic environment. Worked with client to troubleshoot test environment, software, isolate inefficient code, and identify performance bottlenecks. Performed functional testing against a Cisco BTS Softswitch.
BANK OF AMERICA, Horsham, PA
Programmer/Analyst May 01 – Nov 04
Responsible for supporting the insurance marketing group and customer service staff in the credit card division of a major bank. Interacted with marketing staff to address business needs and develop creative solutions to problems. Performed analysis of business requirements. Programmed, tested, and implemented software upgrades.
Developed and supported software applications which processed enrollments, cancellations, claims fulfillment, marketing leads, campaigns, and reporting for credit card insurance products. Software was developed on Sun Solaris UNIX, HP-UX, and Windows 2000 platforms using Oracle stored procedures, PL/SQL, SQL, and Korn shell scripts. Administered Rational ClearCase software for the version control of source code for all applications in the credit card division. Coded ClearCase trigger scripts and user scripts in PERL.
NCI INFORMATION SYSTEMS, INC., McLean, VA
Senior Analyst/Programmer Nov 00 – Mar 01
Designed functional and technical specifications for online, batch, database conversion, and testing processes in the development of a web-enabled supply ordering system for all branches of the United States military.
Interacted with business users to obtain requirements. Developed and coded batch process using SQL, PL/SQL, and UNIX shell scripts to process vendor, order, receipt, and customer information.
TOWERS - PERRIN, Philadelphia, PA
Systems Development Programmer Feb 98 – Oct 00
Analyzed, developed, tested and implemented software dealing with the Health and Welfare benefits administration. Developed tables, screens, and reports that enabled the system to process employee benefit information for annual and ongoing changes to choices and elections.
Converted Pro COBOL programs to Oracle PL/SQL stored procedures. Coded in Java to access and manipulate data in an Oracle database for a back-end web development project. Coded PL/SQL stored procedures and associated programs that called them in Java, Pro C, Pro COBOL, and Developer 2000 forms. Coded Developer 2000 forms and PL/SQL stored procedures for a conversion to integrate multiple client databases into a single database for all clients.
EDUCATION
La Salle University, B.A.