Business Analyst Quality Assurance
Resume:
RESUME OF: WILLIAM SULLIVAN
*************@*****.***
SUMMARY: Quality Assurance testing and Business Analyst experience in Trading (Trading), Healthcare, Finance, and commercial software industries. Expertise includes systems, UAT, and standards testing. Worked with several models of SDLC including Waterfall, Agile and Unified Process Development.
Mentored junior staff on several projects and have been responsible for writing functional specifications for in-house and commercial financial applications and processing systems. Thorough knowledge of QA methodology and processes and have implemented standards at a variety of clients.
Experienced in communicating with Business Users concerning application requests and enhancements and have served as liaison between Business Users and Development in translating these requests into technical specifications. Experienced in manual and automated testing procedures, writing and executing test plans, reporting problems, implementing version controls. Adaptable to projects using new systems and tools.
References available upon request.
TECHNICAL SUMMARY:
Securities Trading
SQL Query
User Acceptance Testing
End to End Testing Management
Specification and Test Plan Writing
Web browser compatablity testing
Regression Testing
Portfolios
Technical Writing - QA business process
Oracle Financials
Corporate Actions Testing
ETL Data Warehouse Data Migration
Network Administration, Testing & Support
Billing/Claims Processing
EDI Testing
Agile methodology
Test Lead
Test Architect
Offshore QA management
Financial Markets and Trading
POS (Point of Sale)
TECHNICAL SKILL SET:
SharePoint
SVN
Quality Center / ALM
UFT / QTP
LoadRunner
TFS
Oracle MDM
Ranorex
SQL Plus
PL/SQL
JIRA
RTC
Agile
Microsoft Team
Oracle
Eagle Star
SQL Developer
XML
HTML
Unix
Microsoft Office
ETL
Biztalk
Informatica
SOAP UI
Client/Server Technology
PROFESSIONAL EXPERIENCE:
10/23 – 3/24 IBM
Business Analyst
Testing Santander’s Desktop Banking Application
Working with stakeholders to requested product functionality
Testing Customer User Interface in Shadow Production environment prior to release in active production.
Reporting any application anomalies to stakeholders and recording testin results in Sharepoint
12/21 – 5/23 Santander Bank
Business Analyst
Working with Santander Bank’s Anti Money Laundering Team
User Acceptance Testing the latest version of the bank’s Anti Money Laundering Program
Tested Swift and Fed Wire and IS02022 messaging
Reviewing, writing, execution User Acceptance tests
Reporting, re-testing and verifying defects
Tools used including ALM for defect management, Lexus/Nexus for risk management
6/21 – 12/21 IBM
Business Analyst Test Center Of Excellence for Truist Bank, Charlotte, NC (Remote)
Part of a team of 4 charged with performing assessments of the testing process for Truist Bank
Assessing testing tools used and their effectiveness
Assessing the SDLC (Agile) process as it relates to testing
Recommendations to Management for changes to the testing process
Recommending new test tools or change to existing tools
Managing POC/Demos for new tools and metrics for ROI data
2/21 – 4/21 FusionIQ Woburn
Senior QA Engineer -
Testing changes and functionality for company trading application
Writing Test Plan and Test Scrips
Entering and resolving issues in Jira
7/20 – 12/20 Arrowstreetcapital Boston
Senior QA Engineer -
Testing changes in company applications like ASC Trade and Corporate Actions and Portolios
Configuring and test changes in QA for scheduled jobs
Using SQL queries in Microsoft SQL Server 2012 to validate changes
Managed and executed test cases in TFS
Using Beyond Compare to record differences in tables and files for testing
7/19 – 4/20 Boston Medical Health Plan
Senior QA Engineer -
Testing DB changes for BI Reports regarding medical patient data and insurance claims
Using SQL queries in Microsoft SQL Server 2012 to validate changes
Managed and executed test case in HP ALM
4/18 – 4/19 TJX – Marlborough, MA
QA Lead
Lead QA for 2 Oracle MDM Agile projects
Managed manual testing and UAT for two projects
Develop automated test cases using proprietary framework for Unified Functional Testing version 12.54
Managed offshore QA testing team
Managed and executed test case in HP ALM
11/15-2/18 STATE STREET BANK, Boston, MA
QA Lead
Lead QA for Agile Project IRIS, new trading applicaton
Develop automated test cases using proprietary framework for Unified Functional Testing version 12.50 and Ranorex
Executing and maintaining automated test cases in ALM version 11.0
Develop and report on testing metrics
Validating database data with application using automated testing with SQL queries
Tools used: UFT, Ranorex, ALM, RTC, Oracle Developer, SharePoint
2006-2015 MULTIPLE QA CONTRACT ASSIGNMENTS
Client: eSecLending, Boston, MA (9/14-3/15)
Responsible for all QA for web based financial portfolio auction application for the Chicago Mercantile Exchange
Test Plan
Test Cases
Setup issues database in JIRA
Microsoft Visual Studio for SQL queries
Client: UNFI, Providence RI (10/13-7/14)
QA Analyst for Supply Chain Dept. at United Natural foods.
Testing Warehouse Management application by Manhattan Associated
Test Case creation and execution
Responsibilities include test case creation and updates, testing Manhattan Associates Warehouse Management system. Manual Tests include UI, XML mapping, messages, SQL queries, DB validation and Reports. Bug tracking using TFS.
Client: Analog Devices, Norwood MA (3/13-9/13)
Trained and managed off-shore QA resources
Led Website testing
Established and tracked testing and performance metrics
Managing the QA testing of Analog Device’s eCommerce website. Managing an offshore QA team in the Philippines.
Documented QA best practices for web-based testing and writing test cases
Manual Testing is done for all supported languages, English, Chinese, Japanese and Russian.
Testing tools used:
• Gomez – for Website metrics and analytics
• WebLink Validator to test and validate all 120,000 page links
• Page Load testing – to measure time to load selected pages from release to release
• LoadRunner – test server load and average load times
• Google Analytics – track page usage
• Issues tracked on SharePoint
Client: Harvard-Pilgrim Community Health Plan (12/10-1/13) (2+ years)
QA Lead for Revenue Management and Billing Dept.
Responsible for all phases of testing including User Acceptance Testing.
Worked with other Projects and Departments to coordinate testing including Business
Users and Business Analysts.
Used QC to tract User Stories, testing and defect management.
Assisted in developing load, performance and automation tests with LoadRunner and QTP resources.
ETL data migration for new billing system
SQL queries
Oracle EBS
End to End Testing
Voice Recognition testing for eligibility and claims inquiries
HP QC and ALM
Client: Tufts Health Plan, Watertown, MA (8/10-12/10)
End to End Testing Health Insurance Enrollment, Billing and Claims
EDI 835, 837 forms
Requirements gathering
Process documentation
Client: Fresenius Medical Care, Lexington, MA (11/06-12/09) (3 years)
ETL Datamart Date Migration
End to End Testing
Salesforce
Loadrunner
Oracle Identity Manager Peoplesoft
Peoplesoft
Soarian Clinical and Financials
SQL queries using TOAD
Mobile testing of clinical treatment application
Sharepoint
Mercury Quality Center
Client: Pharmacare Lincoln, RI (4/06-11/06)
Medicare Part D claims processing and reporting.
Verifying Rx Claims, Billings and Medicare Part D mandated reports
IBM AS400 Mainframe.
Test Plan creation, Test execution, Data validation.
Control Module, Inc. (3/06-7/06)
QA for Bio-time, fingerprint scan timeclock.
Testing timeclock operation and integration with database using .NET, MSSQL, Selenium.
QA for content, navigation, of Java based information Webpage.
Client: MC Communications, Boston, MA (9/05-3/06) (11/04-5/05)
Pri-Med.com is a website designed with .NET, used customized open source CRM application) with SQL Server as back-end. The website provides online services for medical professionals regarding Online Meetings, Continuing Medical Education, Travel, etc.
Reviewed Business Requirements of the application
Interacted with Business Analysts to understand the requirements
Developed and executed Test Cases for the application under test (www.pri-med.com)
Reviewed QA test cases with Business Analysts
Interacted with QA team during functional testing
Attended team meetings with Development, QA and UAT
Updated QA test cases on every build/release
Responsibilities include writing and maintaining test plans, execute test cases and maintain software issues in TestTracker.
Web Content management testing of Web site using Interwoven content management tool.
Performance Testing
Browser compatibility testing on most versions of IE, Netscape, Firefox.
Testing included webpage’s in Weblogic.
Client: Wellington Management, Boston, MA (5/05-9/05)
Trading Transaction IS Group at Wellington Management.
Worked on the Corporate Actions Outsourcing Project responsible for testing and analyzing account positions for current and back-trading activity on a daily basis.
Running and verifying results of SQL scripts using queries built on PL/SQL- Developer and maintaining archived records in UNIX.
Used Test Director to track issues.
Client: OneBeacon, Foxboro, MA (8/04-11/04)
Worked on upgrades and changes to On-line Insurance/Casuality Claim system.
Responsibilities included writing and executing Test Plans, reporting and verifying software problems.
Environment consisted of client/webserver processing as well as updating data on mainframe.
Client: Eagle Investment Systems (4/04-10/04)
Writing test plans for Eagle Star. Modifying Unix test scripts for automated testing and reporting software problems by offshore team and informing stakeholders of issues
Client: Investors Bank & Trust, Boston, MA (1/04-3/04)
Lead Test Engineer for Mutual fund trading project for Dublin office using Access.
Responsible for writing Test Plan, Test Cases, informing project management of testing progress.
Client: FM Global Norwood, MA (10-03-12/03)
Writing, executing, updating test plans.
Reporting and verifying defects of new verison of Horizon Manger, a Client-Server database application for field engineers.
Tools used included Rational ClearQuest, and Clarify.
Client: Fidelity Trading Boston, MA (6/03-8/03)
Responsibilities included testing and verifying changes and fixes to Fidelity customer web pages.
Writing and executing test scenarios base upon Business Requirements.
Client: MassMutual, Springfield, MA (1/03-5/03)
Responsibilities included writing and executing test plans, reporting and verifying software problems for Mutual Fund Client Processing System.
Testing included front end manual and automated using Winrunner.
Backend testing included using SQL queries and data retrieval for Sybase database. Used Test Director to track issues and execute scripts.
Client: Fidelity Trading (1/02-8/02) (9/00-5/01) (1/96-10/97)
Responsibilities include writing and executing test plans, reporting and verifying software problems for Web based Trade Processing system. Test cases written and maintained in Mercury test suite.
Used Test Director to track issues and execute scripts.
Platforms tested included Windows Versions NT5 NT6, ME, 98se Professional 2000 and different versions of Netscape and Microsoft IE.
Client: Aether Systems Marlborough, MA (8/01-12/01)
Quality Assurance Testing for Client/Server application involving real-time police reporting system.
Responsibilities included writing, executing manual and automated tests using Rational Robot, reporting and verifying software problems and fixes.
Testing including Web GUI testing for Windows and Java compliance and verifying XML files on desktop, laptop and Palm OS.
Client: Genuity, Cambridge (7/00-9/00)
QA Circuit Order system, on Oracle v7 database. Testing cycle consisted of receiving specification and algorithms from development for development of accounting reports based on voice/data leased circuit lines usage.
Writing test plan based on the specification and algorithms and detailed test cases using specific data base lined in the test data base. Verification was by SQL queries.
Client: CVS Woonsocket (11/98- 4/00)
System Test Architect for new Pharmacy Workflow. Responsible for writing Test Plan, Test Cases
Recording test defects, verifying fixes, organizing UAT with business users and informing stakeholders testing progress of Project.
Client: Liberty Mutual (08/98- 11/98)
QA/UAT testing for Auto Insurance claims processing
EDUCATION: AMERICAN UNIVERSITY, Washington DC
Bachelor of Arts
SUFFOLK UNIVERSITY, Boston, MA
Master of Arts
Contact this candidate