Quality Assurance Sql Server

Robert S. Scheffel

** ******* *** **

Ridgefield, CT 06877 845-***-**** *********@*******.***

QUALIFICATIONS

Experienced IT professional with

• Software Usability/UX leader and User advocate

• 15 years advanced SQL verification techniques, including ETL

• Solid Test Automation experience (QTP, WinRunner, LoadRunner)

• 13 years in-depth expertise in Quality Assurance (QA) concepts

• 23 years SDLC background and Process Improvement

• Excellent written/verbal communication skills

• Cooperative, synergistic mindset

• 1 year BA experience

• 2 years QA Management experience

• 7 years Health Care industry exposure

• 2 years Financial (FX Options) exposure

TECHNOLOGY

QUALITY ASSURANCE:

Test Management:

Quality Center 9.0, Microsoft Team Foundation Server (TFS)

Test Automation:

QuickTestPro (QTP) 9.0 w/ VBScript, WinRunner 9.2, LoadRunner 9.5

Defect Management:

Quality Center 9.0, Rational ClearQuest, PVCS Tracker, Bugzilla

SDLC Process:

Capability Maturity Model (CMM), Rational Unified Modeling Language (UML), William Edwards Deming,

TMap

SOFTWARE DEVELOPMENT:

Visual Basic 6.0, VBScript, C, ActiveX/DCOM, Internet Information Server (IIS) 4.0, Microsoft Transaction

Server (MTS) 2.0, Active Server Pages (ASP), HTML, XML

DATABASES:

Oracle 10g, SQL Server 7.0, MS Access 2003, Oracle SQL Developer, Toad 8.0 DBA Tool

SOFTWARE PACKAGES/TOOLS:

MS Word, Excel, PowerPoint, Visio, PuTTY, Remote Admin, Remote Desktop,

OPERATING SYSTEMS:

Windows 7, Vista, XP, 2K, NT 4.0, UNIX, DOS

WORKING KNOWLEDGE:

Hyperion Business Intelligence, Java, C++

EXPERIENCE

11/07 – Present FUJIFILM Medical Systems U.S.A., Inc, Stamford, CT

SENIOR QA ANALYST/UX ANALYST

Perform functional testing of Synapse product, a medical imaging, Picture Archiving and Communication System (PACS).

Defined all Usability/UX Guidelines for next generation PACS product. Objective is to eliminate User cognitive

load, creating a satisfying User Experience. Collaborate with BA and Development teams to ensure that software

content, appearance, aesthetics, and behavior are consistent and intuitive. Define an obvious, intuitive Navigation

scheme throughout Product. Collaborate to ensure a consistent appearance and behavior on all Features throughout

the Product. Create UI mockups indicating Page Layouts, placement of controls, and describing expected User

interaction with the UI. Mockups are created in Visio and Adobe Illustrator.

Served as Business Analyst (BA) at various Customer sites, discussing their activities, workflows, and pain points.

Itemized list of Requirements for improving the User experience.

Conduct Performance testing using Loadrunner to achieve baseline results for “time to fist image” when loading

various test Study profiles. Continue with routine Performance tests to assess whether these numbers show

degradation or improvement over time. Also perform light Load testing for up to 50 concurrent Virtual Users, to

determine how software performs under stress. Specify test environment for Performance testing, including a static

database, isolated network area, and test Study profiles. Report results to Management.

Use WinRunner, integrated with Quality Center (QC), to automate manual Test Scripts, verifying that all medical

image transformations are compared against known, correct baseline images; Test run results are recorded in QC,

correct baseline images are stored to a network folder structure for comparison with images produced by latest

software build.

Perform Exploratory Testing on newly added Features; assess quality of Requirements documentation, and verify that

implementation of Features is consistent with Requirements and Uses Cases; parse Requirements documentation for

completeness, correctness, consistency, clarity, and ambiguity. Work with BA’s to clarify and improve the written

Requirements. Use SQL queries to help verify that implemented Features are correctly saving and retrieving data.

Track Defects from discovery until resolution, using QC Defect Tracking module.

Write FDA-compliant Test Verification and Validation Protocols; comply with FDA processes for managing test

documentation and test reports using EDMS document management system.

5/05 – 11/07 Starwood Hotels, White Plains, NY

SENIOR QA ANALYST (CONSULTANT)

Functional and Performance testing of Hotel Management systems; N-tier architecture employing XML / Java Application

Server / Oracle Database; involves complex SQL verifications.

Verify functionality of Property Content Management system, by saving data to DB and verifying that data

relationships are being written to and retrieved from DB correctly; verify that data is propagated correctly from DB to

the XML server, and that the web pages are displaying XML content correctly. Process involves routine trouble-

shooting of data transformation from Oracle DB, to XML structures, to data as it ultimately manifests on web pages;

construct complex SQL statements to assess and troubleshoot three tiers of data, and verify defect fixes.

Performance testing using LoadRunner; record, enhance, and correlate LR scripts; coordinate Performance Testing

sessions during off-hours, execute tests, and publish results for Management.

Construct manual Test Scripts, derived from Use Cases and GUI specs; ensure that Test Scripts are updated to stay in

synch with latest spec changes.

Track Defects from discovery until resolution, using Rational ClearQuest Defect Tracking tool.

4/03 – 5/05 Allegient Systems, Wilton, CT

SENIOR QA ANALYST

Automated Functional and Performance testing, Manual testing of B2B ASP web-based application; N-tier architecture

employing HTML / Java Application Server / Oracle Database.

Develop automated Test Scripts using QuickTestPro 8.0, incorporating automation of critical Functional Areas.

Developed data-driven regression scripts covering 30 reports, to ensure that report output remains correct and

unchanged with each release of software.

Create and maintain LoadRunner scripts that record baseline performance numbers for each release; monitor need for

code changes based on baseline trending results.

Define and implement Process Improvement activities both within QA and within the larger SDLC; specified

requirements for perl Configuration Management utility, which assesses all relevant configuration differences

between two deployment environments, and produces a Report showing all differences.

Use SQL to troubleshoot database/application problems, and verify fixes.

Verify Hyperion Intelligence BI tool reports by comparing report output with independent SQL queries from the

underlying database; verify that there is no loss/change in data from one data transform to the next during ETL

process.

Construct manual Test Scripts, derived from Use Cases and GUI specs; ensure that Test Scripts are updated to stay in

synch with latest spec changes.

Track Defects from discovery until resolution, using Bugzilla Defect Tracking tool.

5/01 – 1/03 AIG Trading Group, Greenwich, CT

SENIOR QA ANALYST

QA Lead on Foreign Exchange (FX) Options Trading Project; N-tier architecture employing Delphi GUI / Java

Application Server / Oracle Database.

Develop test scripts covering recordings of over 30 different FX Option types, including American, European, Exotic,

Partial, Compound, Complex, and Exchange Traded.

Construct manual Test Scripts, derived from Use Cases and GUI specs; manage all Test Scripts in TestDirector;

ensure that Test Scripts are updated to stay in synch with latest Change Request spec changes.

Develop automated Test Scripts using WinRunner 7.0, and coordinate automation of critical Functional Areas

Track Defects from discovery until resolution, using internally developed (Lotus

Notes) Defect Tracking tool

Worked on testing methodology for testing Java application tier before GUI

becomes available; objective was to test Java components early, rather than waiting until GUI availability. Testing

facilitated with JUnit, a set of utility classes for writing Java test code to instantiate and exercise Java application

objects, and capture results for comparison with expected baseline values.

4/00 - 5/01 Personal Path Systems, Inc., Upper Saddle River, NJ

DIRECTOR OF QUALITY ASSURANCE

Hired team of seven QA Analysts to provide QA core competencies to the company. Established goals and identified

process improvements to optimize Software quality. Implemented proactive QA processes to build better software, and

reactive QA measures to inspect and test the software that has been built.

Technology exposure: Visual Basic 6.0, ActiveX/DCOM, Internet Information Server (IIS) 4.0,

Active Server Pages (ASP), HTML, SQL Server 7.0, WinRunner/LoadRunner, TestDirector, PVCS

Internet Health Care Application

Defined QA roles and process for those roles to ensure coverage of QA core competencies: Test Plan construction,

Manual Testing, Automated Functional Testing, Performance Testing, Defect Management, SDLC process, QA

Process, Release Management.

Installed Mercury suite of QA tools: TestDirector, WinRunner, and LoadRunner for Enterprise use.

Specified format for written Test Plan, and coordinated testing of separate functional areas by QA Analysts; testing

effort included manual/automated Functional Regression Testing, Performance Testing, and Usability assessment.

Guided QA Analysts’ automation work, and assisted with WinRunner and LoadRunner automation.

Managed Defect Tracking process in TestDirector to ensure defect resolution and optimize turn-around time. Ensured

that all defects are adequately described and communicated to Development Team, and that communication between

QA and Development is maintained. Ensured that QA Team verifies all repaired defects. Created meaningful Defect

Status reports and ensured that Development Team is aware of defect priorities, schedules, and deliverables.

Developed Defect Management Process so that key representatives (Development, Marketing, Content, Web

Designer, and QA) consistently use TestDirector to manage all known defects. Identified key process deficiencies and

implemented process to correct them.

6/99 - 3/00 Pitney Bowes Corp., Shelton, CT

CONSULTANT, SENIOR QA ANALYST

QA Lead; managed QA and testing effort for strategic Internet application; development effort included ten Developers

and four QA Engineers.

Technology exposure: Visual Basic 6.0, ActiveX/DCOM, Internet Information Server (IIS) 4.0, Microsoft Transaction

Server (MTS) 2.0, Active Server Pages (ASP), Microsoft Message Queue (MSMQ), HTML, SQL Server 7.0, RSW e-Test

Suite (Regression/Load testing tool for testing web applications)

Web Shipping Application

Specified format for written Test Plan, and coordinated testing of

separate Functional Areas by each of the QA Engineers; testing effort included

Functional Regression, Load, and Human Factors testing.

Deployed each software release onto test server, and post-configure/troubleshoot using “plumbing” tests; proceed

with Functional Regression Testing of latest release, and validate all bug fixes.

Implemented Issues Management logistics to optimize momentum on defect discovery and resolution; provided bug

reports to management to help them assess risk and prioritize defect resolution.

01/99 - 6/99 Sprint Corp., Shelton, CT

SENIOR QA ANALYST (CONSULTANT)

Analyzed critical Sprint applications to understand all issues involved with migrating these applications from Connecticut

facility to Virginia facility. Provided VB code maintenance, troubleshooting, and resolution of all configuration issues to

ensure 100% successful migration effort.

Technology exposure: Visual Basic 5.0, ActiveX/DCOM, Internet Information Server (IIS) 4.0, Microsoft Transaction

Server (MTS) 2.0, Active Server Pages (ASP), HTML, SQL Server 6.5, SMTP, PCAnywhere 8.0.

Project Tracking Application

VB ActiveX Document application employing IIS 4.0, MTS 2.0, DCOM, Active Server Pages (ASP) and HTML

technologies, SQL Server 6.5, and SMTP.

Assessed all source code for hardware/network configuration dependencies; categorized and documented all existing

and potential dependencies, and developed migration logistics plan for migrating each of the three tiers (client, web

server, and database).

Recompiled VB source code during troubleshooting/debugging/upgrading process into new working set of seven

DLLs and one ActiveX Document; built MTS packages from upgraded DLLs, and deployed them on middle tier web

application server.

Built FTP and WWW virtual directory sites in IIS 4.0 to house required functionality of the Project Tracking system;

configured these sites as required for user accounts, permissions, etc.; leveraged PCAnywhere tool in Shelton, CT to

remotely configure software, registry, and monitor behavior of application in Reston, VA.

Isolated and resolved SMTP architecture problem with VB code implementation.

Recompiled Wise Installation script to build new set of data files and CAB file for remotely deploying Project

Tracking setup routine from web site location.

Tested and verified continuing functionality for Project Tracking application after migration.

Network Accounting and Network Statistics Processing

Provided daily assessment, troubleshooting, and resolution of any incidental problems for hierarchy of NT/DOS batch

processes. Batch processing was designed to:

• transfer critical load/usage data files between Reston, VA and Shelton, CT servers.

• load raw data files into SQL Server 6.5 tables.

• post-process SQL data.

Provided detailed documentation describing above batch processing logistics, including troubleshooting techniques.

8/94 - 1/99 Approach, Inc., Valhalla, NY

PROGRAMMER / QA ANALYST

Data Migration Project

Designed and implemented migration of critical corporate mainframe database to new SQL Server tables for custom

Client/Server application.

Used SQL Server bulk copy program (bcp) to export/import corporate mainframe data into intermediate SQL table

structures; worked with customer’s mainframe personnel to troubleshoot and correct mainframe export procedure, and

developed documentation to instruct mainframe personnel on export procedure.

Developed over 100 SQL stored procedures to transform exported mainframe data in intermediate SQL tables into

final, application SQL Server tables; transformation involved millions of data records.

Customized each stored procedure to construct correct foreign key data; verified successful data conversion by

checking referential integrity, uniqueness, and completeness of data in all tables.

Messaging Application Programming Interface (MAPI) Research Project

Developed VB 4.0 application demonstrating how to incorporate Microsoft OLE Messaging Library; application

could send/receive e-mail with document attachments to recipients.

Researched feasibility and benefits of leveraging Microsoft OLE Messaging Library into custom software

applications.

Product Forecasting Project

Developed test plan for Client/Server VB 3.0 application; implemented test plan with SQA Robot automation scripts.

Provided VB maintenance programming to fix defects and speed up turn around time on delivery dates.

Sales Commission Project

Directed the testing effort on complex software project; project’s magnitude included over one million lines of code,

500 component objects, and 100 database tables; built regression test suite with SQA Robot.

Optimized the defect tracking process by associating defect priority to project milestone.

Application Certification Project

Monitored corporate customer’s migration to Microsoft NT platform by applying Visual Test automation scripts

during NT rollout phase; objective was to catch any behavioral anomalies in the set of corporate baseline applications,

using playback of recorded scripts in new NT environment. Any deviations from recorded script (correct) behavior

were flagged during playback of scripts; migration to NT platform involved more than 2,000 NT workstations.

Quality Assurance work

Improve quality of Approach software solutions by developing proactive and reactive, process-oriented

methodologies to ensure software quality; process improvements covered documentation optimization, test plan

preparation, defect management, and automated regression testing in a distributed, N-Tier environment.

• Designed and implemented concrete strategy for evaluating documentation quality, with

the goal of optimized knowledge transfer among development team.

• Improved software development process by implementing “checkpoint mechanism” to

ensure unified understanding among development team before proceeding further.

• Directed testing effort on software projects, applying SQA Robot and Visual Test

automated regression tools, and SQA Manager defect management tool.

3/92 - 8/94 Gtech Corporation, West Greenwich, RI

TECHNICAL WRITER

Designed and developed software documentation and operations manuals for international lottery firm.

• Defined and implemented abstracts for project lifecycle documentation, including

Software Requirements, Software Design, and Functional Specification.

• Developed operations manual for retail lottery agents.

• Developed DEC VAX/VMS configuration manual for systems managers.

6/91 - 3/92 Revenue Markets, Inc., Accord, NY

TECHNICAL WRITER

Authored proposals in response to RFPs for computerized Toll Collection Systems.

Interviewed engineers and technicians to obtain technical, background information for RFP.

7/90 - 6/91 AGS Information Services, Inc., Poughkeepsie, NY

PROGRAMMER/ANALYST

Implemented Computer Integrated Manufacturing Software (CIMS) for a major computer manufacturing firm; OS/2

software written in C and Presentation Manager.

Prepared technical documentation to improve understanding of CIM architecture among consulting group.

3/88 - 7/90 CSW Data Systems, Poughkeepsie, NY

PROGRAMMER/ANALYST

Developed Clipper/C applications software for Electrical Metering Project.

• Software development involved remote data acquisition via modem, system configuration, data

management, reporting, and archival subsystems.

Installed software/hardware at customer site.

Provided software/hardware support, documentation, and data analysis for end-users.

6/86 - 3/88 Wellcare Management Group, Kingston, NY

PROGRAMMER/ANALYST

Implemented MIS software using PRO-IV relational database language, running under UNIX, for complete HMO

system.

• Gathered requirements from end-users.

• Implemented working design into software modules, under guidance of MIS Director.

• Developed and maintained software documentation and end-user documentation.

12/84 - 6/86 Experience outside of IT industry

EDUCATION

1984 State University of New York, New Paltz, NY

Bachelor of Arts, Mathematics and Computer Science

Contact this candidate