Principal Software Qa Consultant Resume
Quincy, MA
OBJECTIVE/SUMMARY:
Principal QA Engineer with over 20 years QA experience, including over 9 years experience testing Enterprise Systems in the Financial Sector. Seeking a software engineering test management position, involving test development, test architecture or development support.
EDUCATION:
Master of Science in Computer Engineering.
Bachelor of Science in Electrical Engineering.
SKILLS:
Programming Languages: 4Test, TSL, C, PERL, CGI Forms, csh, tcsh, sh, ksh, PL/SQL, Transact-SQL, SQL, MySQL, Oracle SQL Developer, SOAP UI, Subversion, PVCS and CVS.
Operating Systems: Windows NT/95/XP, HP-UNIX, AIX, Sybase, Oracle, DB2,
SQL Server, Clearcase, MS-DOS, IBM-AIX, Solaris and DEC Alpha.
WORK HISTORY:
Confidential, Quincy, MA.
President and Software Consultant:
Owned and operated a software business that included software development, test and sub-contractor management services. Client and Assignment Descriptions are listed below. (May 2004 – present)
Confidential, Boston, MA.
Principal Software QA Consultant:
Worked as an Agile Development Team Member as the sole QA Resource, testing the Combined Order Services within the Combined Order Management functionality. SQA activities included: Attended Daily Scrums, used Rational Team Concert to create, estimate and manage QA Tasks, wrote Test Plans and associated Functional and Integration testcases from Requirement Specifications, held test scenario reviews, performed manual functional, integration and regression testing, entered test scenarios, results, defects and enhancements into the Quality Center Database, and wrote weekly Status Reports to the Team Leader. The Test Plans included the following functionality: Combined Order Test Strategy for all Agile Development Teams, Reconciliation Repair of Open Orders, Combined Order Services and Notification Services (January 2012 – June 2012).
Confidential, Quincy, MA
Principal Software QA Consultant:
Worked as the sole QA Resource on the Quarterly Statements Applications,SQA activities included: managed all testing activities for the Quarterly Statements System Application(s), wrote Test Plans and associated testcases from Requirement Specifications, performed manual testing, entered bugs and enhancements into the OnTime Bug Database, and wrote weekly Status Reports to the Project Manager. The Test Plans included the following functionality: Quarterly Statement Creation, Quarterly Statement Generation UI, Quarterly Statement Delivery Testing, Quarterly Statement Status Testing, Quarterly Statement .PDF verification and Advisor Administration (July 2010 – January 2012).
Confidential, Boston, MA.
Principal Software QA Consultant:
Worked as the sole QA Resource on the Portfolio Management System Application, a Rich JavaSwing Application which communicates with a J2EE Application Server. SQA activities included: managed integrated testing between the Portfolio Management System Application and other Financial Software Systems/Applications, created automated regression tests in Silk Test, wrote Test Plans and associated testcases from Requirement Specifications, performed manual testing, entered bugs and enhancements into the Team Track Bug Database.
The Portfolio Management System Regression Test Suite included the following functionality: Equity Ordering, Currency Forward Ordering, Account Load Testing, Analytical Data Testing, Report Testing via Oracle, Data Mining via SQL Queries in Oracle, JReports testing, Application Screen testing, Short Sell/Buy to Cover Ordering, Equity Options, Index Options, Index Future Options, Sleeve Cash Adjustments and Order State testing (May 2006 – May 2010).
Confidential, Boston, MA.
Software QA Consultant:
Tested multiple VFA Intranet/Internet Java based Products running on Windows XP as the sole QA Project Member, including VFA.facility and the LRFP/PATS application (Long Range Facilities Planning/Project Application Tracking System). SQA activities included: deriving testcases from Software Requirements Documents, writing testcases, writing up bugs in a Bugzilla bug tracking system, verifying bug fixes and offering suggestions on process/software improvement. (January 2006 – May 2006)
Confidential, Boston, MA.
Software QA Lead Consultant:
Lead a QA group in testing a Portfolio Manager Workstation (PMW) Java application. QA Lead tasks were as follows: Executed and debugged automated regression tests and coordinated Team test activities in regression testing (700 plus testcases/15 hours of testing) for each interim release, produced Defect Reports via Test Director and created Certification documents given to upper management for PMW Software Releases, gave final input on whether a specific PMW software version was ready to be released, trained new Team Members on the PMW application as well as directed and oversaw daily/weekly assignments, conducted interviews and was part of the final decision-making process for multiple QA Team individual contributor and QA Lead positions which lead to hiring.
Other activities included, All SilkTest files were placed under configuration control with PVCS, created Test Plans and automated test cases for Currency Foreign Exchange (FX-Global Trading System): Enter FX Orders (Spot, Forward, Fixed Income, Equity, Cross and Swaps), Generate FX Orders, FX Trade Adjustment, Execute and Allocate FX, Accept FX Orders, Close and Roll FX Forwards, Edit FX Orders. Created Test Plans and automated test cases for PMW: Security Lookup, Limit Warning (PMW), Opposite Trade Check, Options Trading and Benchmark Relative PMW functionality. Created SilkTest methods, functions and appstates to be used by the group in order to expedite automated testing. (May 2004 – January 2006)
Confidential, Quincy, MA.
Founder and Software Consultant:
Owned and operated a software business that included software development, test and sub-contractor management services. Clients and Assignment Descriptions are listed below. (May 1998 – May 2004)
Confidential, Boston, MA.
Software Consultant:
Created and manually executed eleven Test Plans for a Windows 32-bit Settlement Model Application developed in Java (ALERT product) against a Sybase 11.0.3 database. The eleven Test Plans dealt with the following Application functionality: Broker cross-referencing, Broker List(s), Broker Institution Agreement, Custodian cross-referencing, settlement instruction concurrency, settlement instruction account specific, settlement instruction change maps, printing, copy/paste, auto-acceptance of alerts and place of settlement testing. The Test Plans were developed for a Regression Suite in which the following eight were automated using the SilkTest Test Tool, cutting the testing time in half: Auto-Acceptance of Alerts Test Plan, Broker cross-referencing, Broker List(s), Custodian cross-referencing, Settlement Instruction account specific, Copy/Paste, PSET, and Broker Institution Agreement of the ALERT Workstation. Created import files, which were imported into a Sybase database using a Data Management Tool Web Application. Exported the data from the Sybase database, via SQL scripts, into tab-delimited files and then compared expected versus actual data. (April 2002 – April 2004)
Confidential, Boston, MA.
Software Consultant:
Created and manually executed a Test Plan, which included sixty-one test cases, for an Instant Messaging Web Application. Developed and debugged a fifty test case, data-driven, smoketest in WINRUNNER of the Instant Messaging Web Application, which was executed on secure and non-secure http site configurations.
Developed and debugged fifteen MySQL Report queries along with a PERL script, for an automated daily import of search engine log files into a MySQL database and a querying out of the fifteen MySQL results sets, which were then converted into Crystal Queries and Reports (.rpt files). Setup, exported and hosted the fifteen Crystal Reports via the Crystal Web Reports Server and an IIS Web Server as Dynamic HTML (.dhtml files). Used WINRUNNER's automation capabilities to execute and export the Crystal Reports to virtual folders on the IIS Web Server for intranet viewing.
Created, coordinated and executed an eight hundred question regression test to improve the accuracy of a Natural Language Web Search Engine. Assisted in the tuning of concepts and crawls from the Engine Regression Test findings. Held meetings with vendor and internal groups to resolve regression test accuracy issues. (August 2001 – February 2002).
Confidential, Cambridge, MA.
Software QA Consultant:
Developed and debugged PERL scripts to execute command-line arguments for
deleting databases, creating databases, configuring databases, enabling or disabling certain Tables, dumping empty Tables, importing data, dumping Tables with data, expiring or deleting data with eight date range options into Oracle, SQL Server and DB2 databases, and dumping all Tables after expiration and deletion. The empty, full and enabled/disabled Table outputs were run through a difference utility and the resulting Table differences were placed into testcase files.
Developed and debugged a PERL script to determine whether the install of the UNIX, NT or AIX application components had expected or unexpected directories and files. The testing involved eleven component install test cases for UNIX, NT and AIX. Extensive results were itemized in an output file. The PERL utility also processed invalid files and/or directories as well as files and/or directories where previous components were installed; these were identified in the Findings File.
(April 2001 – August 2001).
Confidential, Cambridge, MA.
Software QA Consultant:
Developed and debugged thirteen hundred forty-six test scenarios for a SilkTest Regression Test Suite to: create, launch and verify briqs. The test scenarios tested the Creator and Player windows applications for their functional ability to modify the Windows Registry and verify System Requirements.
Developed and debugged fifty-one test scenarios for a SilkTest Regression Test Suite to create and verify blm files. The test scenarios, created in the Loadmap Editor application, exercised the block selection functionality and were verified in the LoadMapTool application, where a comparison of the binary files (actual vs. expected) occurred.
The Test Suites were executed nightly in a SilkTest Test Plan as part of the software build and test process and the test results were used for pass/fail and performance analysis. All updates were checked into CVS using a script that was developed and debugged in PERL. (November 2000 – April 2001)
Confidential, Cambridge, MA.
Software QA Consultant:
Developed and debugged a PERL and SilkTest Reporter Automation Regression Test Suite, which included: Report Output Files (.html), Error Log Files and Test Suite Results Files. The Reporter Automation Regression Test Suite was developed for SQL Server 6.5/7.0, Oracle 8 and Sybase 11 databases in a Client/Server environment. The Test Suite was executed nightly as part of the software build and smoke test process and the test results were used for pass/fail and performance analysis.
Created Applications in CGI Forms via PERL that accepted user input and saved the inputs to a tab-delimited text file used in Reporter Automation.
Created a Web Regression Test Suite for an ASP OLAP Reporter Application and an HTML-based Administration Console product. The Administration Console Test Suite completed on an NT Client for both SQL Server and Oracle platforms included the creation of: a datastore, http, ftp and proxy sites, and Report Sites. The Test Suite for the ASP OLAP Reporter Application consisted of the following smoke tests: Report Filter creation, Report creation and Custom Report Filter creation.
Developed and debugged a PERL upgrade tool that accepted user inputs, performed SQL queries and created output in a UNIX (Solaris/Oracle) and Windows NT (SQL Server) environment. The Tool consisted of two separate parts; the first part was executed before the software upgrade, and the second was performed after the upgrade. (December 1999 – November 2000)
Confidential, Cambridge, MA.
Software QA Consultant:
Developed and debugged a WINRUNNER Automation Suite used to test Administrative Functions and SQL Server database integrity in an e-commerce PKI Security Application. Modified existing automation scripts to fit the current Windows NT Test environment. Executed performance automation scripts and evaluated performance issues as they arose. Brought new and existing WINRUNNER tests, gui, and data files into Clearcase Configuration Control.
(September 1999 – December 1999)
Confidential, Lexington, MA.
Software Tools Development Consultant:
Created a Software Development Tool that performed dates comparison functions for the Scheduling portion of a Project Management Application. The date comparison functions were developed using SQL Stored Procedures and PL/SQL code in an Oracle 8 (Server) and Windows NT 4.0 (Client) environment. The results of the date comparison were shown using Crystal Reports output, which included only the changed dates related to a particular Project.
(June 1999 – September 1999)
Confidential, Waltham, MA.
Senior Software Quality and Test Development Consultant:
Wrote Systems Test Plan and defined/executed Fee Schedule test cases for a one-time conversion into and multiple event extractions from a Sybase Database. Involved with Unit and Component/Integration testing on multiple Company Projects. Developed SQL queries via MSAccess97 and isql (AIX), along with developing and debugging Korn Shell Utilities, which were used to generate and validate expected results. Developed and debugged WINRUNNER 4.0 data-driven test scenarios/scripts and library functions used in GUI regression of a Windows 95 Database Application. Performed CVS Configuration Management on WINRUNNER test scripts, gui files, data files and functions. Developed CVS Configuration Management Utilities in MSDOS for WINRUNNER data files and library functions. Performed Project Management functions for multiple Company Projects. Wrote Systems Test Reports and Release Notes after Project Testing was completed. (May 1998 – June 1999)
Confidential, Billerica, MA.
Senior Software Quality and Test Development Engineer (full-time):
Defined test cases and wrote Test Plan for database and systems application. Developed and maintained bug tracking and product enhancement database. Defined, managed and performed unit, integration and regression testing on web and non-web based, client-server database application. Wrote and debugged QA Partner test scenarios/scripts on 32-bit Windows Applications which were executed in Windows NT 4.0 and 95. Wrote and debugged PERL scripts to perform test updates in Results files. Wrote and debugged programs in C which included system level functions that tested low-level processes of a Real-Time Operating System. Wrote and debugged Bourne/Korn Shell scripts to automate load and build processes as well as developing system test processes for a Real-Time Operating System. Wrote a Bourne Shell script test harness that executed tests, dealt with blocked (hung) process tests, and created Log and Results files for all completed tests. Defined and gathered metrics to identify critical testing areas and streamline testing time. Coordinated and wrote Release Notes for new software versions. Configured Sparc 20 and Sparc Ultra Systems for application and operating system testing. Performed Solaris Systems Administrator and Clearcase System Administrator functions. (August 1996 – May 1998)
Confidential, Systems Division, Andover, MA.
Systems Engineer (full-time):
Defined test verification methods and assigned methods to system requirements. Developed Requirements Traceability Matrix for mapping system requirements to test objectives and verification methods. Developed test plan, test procedures and test case specifications for a client/server system to verify system requirement compliance.
Managed in-house testing of client-server hardware/software system, which included the following testing processes: unit, integration and regression. Served as Test Director for all in-plant testing, responsibilities included: daily briefing of assignments, resolving hardware/software problems related to testing, post-test briefing of results and concerns, and compilation of test results into log books and analysis reports.
Other System Engineering tasks included: functional analyses of an Oracle Information System and stress tested modems for performance, using digital test sets and analog impairments.
Software Engineer: Reviewed test procedures and regression tested software for requirement compliance. Performed additional software analysis, using in-house and commercial test tools leading to written Reports on the results. Participated in managerial meetings used to formally qualify the software system. Trained Software Maintainers in assembly programming languages used in the software system. (November 1991 - August 1996)
Test Equipment Engineer: Analyzed Test Equipment Failure Reports for trends and efficiency. Wrote Performance Reports on Test Equipment. Performed failure probability studies on selected Test Equipment.
(July 1989 - November 1991)
Confidential., Electronic Storage Development, Shrewsbury, MA.
Engineering Intern: Performed extensive testing of memory devices for specification performance and reliability. Wrote Reliability Reports, which included detailed evaluations of memory chip behavior during testing.
(July 1988 - January 1989)