SUMMARY:

• Senior QA Analyst with Lead/Manager experience. Expertise in DW/BI/ETL SQL Data Verification, Performance Testing, and Functional Automation, with commitment to User Experience (UX) and well - designed software. Deep understanding of SDLC and Quality Assurance.
• 20 years advanced SQL, including Data Warehouse ETL testing; owned and delivered DB2 to SQL Server database migration in 6 months, ahead of schedule df
• 4 years solid Performance testing experience: LoadRunner, Visual Studio Load Test, jmeter
• 5 years solid Functional Test Automation experience: ALM, QTP, WinRunner, VBA
• 20 years expertise in Quality Assurance (QA) concepts, with 10 years Lead/Manager experience
• 20 years SDLC advocate for mature processes to proactively build quality software
• 2 years Software Usability/UX leader and User advocate, with 2 years BA experience
• Excellent written/verbal communication skills
• 8 years Health Care industry; 4 years Financial/Trading experience
• Collaborative, synergistic mindset

TECHNICAL SKILLS:

Test Automation: ALM, QuickTestPro (QTP) 9.0, WinRunner 9.2, LoadRunner 9.5, jmeter

Defect/Test Management: ALM/QC, Rational ClearQuest, PVCS Tracker, Bugzilla

SDLC Process: Agile, Team Foundation Server (TFS), Requirements Analysis, Unified Modeling Language (UML), Capability Maturity Model (CMM), William E. Deming, Sogeti Tmap

Software Usability/UX: User Experience (UX), Information Architecture (IA), Visio, Adobe Illustrator, Responsive Design

Development/Scripting Languages: Visual Basic 6.0, VBA (Excel macros), C, VBScript, perl

Databases: Oracle 10g, SQL Server 2008, MS Access 2003, Oracle SQL Developer, Toad 8.0 DBA Tool, Hyperion/Oracle Essbase Business Intelligence, Informatica, Data Warehousing, Extraction Transform Load (ETL)

Software/Tools: Excel, PowerPoint, Visio, XML Spy, PuTTY, WebEx, Remote Admin, Remote Desktop, SharePoint, IntraLinks

System Environments: VMware/Virtualized machines; Windows 7, Vista, XP, 2K, NT; UNIX, DOS, Web, N-Tier, SOAP, REST, HTML, XML, Microsoft Transaction Server (MTS) 2.0, Active Server Pages (ASP)

PROFESSIONAL EXPERIENCE:

Confidential, Westport, CT

Senior QA Data Analyst (Consultant)

Responsibilities:

• Verify financial data integrity, writing complex SQL queries for pre/post-ETL processing of Accounting database into oracle Data Warehouse.
• Troubleshoot ETL target data using ad hoc SQL queries, Error Logs, and Data Mapping Documents; determine if problems are due to bad source data or due to ETL processing.
• Verify Report data from automated Data Reconciliation tool, ensuring its reports are showing correct data, consistent with independent SQL queries. Investigate any differences between report data and SQL data, and enter/process defects to resolve discrepancies.
• Develop Excel VBA macros to consolidate data from multiple spreadsheets into one, aggregating and calculating Trending results. Report allows monitoring of daily data loads.
• Create custom SQL reports in ALM to pull Test results from ALM for daily status meetings.
• Determine appropriate business keys for correct querying of tables.

Confidential, Stamford, CT

Senior QA Analyst/UX Analyst

Responsibilities:

• Defined Usability/UX Guidelines for creating a positive User Experience for next generation Medical Imaging product. Guidelines defined Information Architecture, behaviors, appearance, and aesthetics for an intuitive UI; defined an obvious and consistent Navigation scheme, consistent appearance and behavior, and designs to preempt User confusion; identified usability deficiencies in the Product, and reflected usability concepts into improved UI mockups.
• Managed testing of new features, mentoring team of six Testers; defined process for mapping functional requirements into Test Cases, ensuring that all Requirements were covered; oversaw the progress and test coverage for these new features.
• Recorded Virtual User Performance scripts, troubleshooting and enhancing scripts to embody desired functionality; incorporated these Virtual User scripts into Load Test scenarios.
• Maintained QTP/WinRunner functional test scripts, updating existing scripts to make calls into new Framework functions; maintenance involved updating perl scripts that were invoked from QTP.
• Identified Process points of failure, advocating and implementing improvements.

Confidential, White Plains, NY

Senior QA Analyst (Consultant)

Responsibilities:

• Functional testing of worldwide Property Management system; used advanced techniques to verify correct data for all three application tiers, from Oracle data tier (SQL), through web services tier (SOAP/WSDL testing), through UI data as it shows up on front end web pages; constructed complex SQL statements to assess and troubleshoot three tiers of data (DB, XML, UI), and verify defect fixes.
• Lead on Performance testing effort; recorded and enhanced LoadRunner scripts, and correlated scripts to handle dynamic data returned by the server; designed sets of scripts to cover important User profiles, and created various mixes of these profiles to test different Load usage scenarios; coordinated Performance Testing sessions during off-hours, executed tests, and published results for Management.

Confidential, Wilton, CT

Senior QA Analyst

Responsibilities:

• Developed data-driven QTP scripts for 30 reports, to ensure that report output remains correct and unchanged with each release of software. Automation embedded utilities to convert PDF to Excel, and compare baseline Excel spreadsheets with latest-run spreadsheets.
• Created LoadRunner scripts that record baseline performance numbers; for each release, identified any changes from baseline performance numbers.
• Used SQL to troubleshoot database/application problems, and verify fixes.
• Verified Hyperion BI reports by comparing report data with independent SQL queries from the underlying databases; verify that ETL process has no loss/change in data from one data transform to the next into the Data Warehouse.

Confidential, Greenwich, CT

Senior QA Lead

Responsibilities:

• QA Lead on FX Options Trading Project (N-tier architecture Java Application and Oracle Database).
• Develop automated Test Scripts using WinRunner 7.0 for critical Functional Areas.
• Developed complex SQL queries to troubleshoot database/application problems, and verify fixes.

Confidential, Upper Saddle River, NJ

Director Of Quality Assurance

Responsibilities:

• Spearheaded QA Function for web-based HealthCare system (similar to WebMD).
• Hired seven QA Engineers, installed Quality Center as quality infrastructure.
• Defined testing process for WinRunner automation, manual scripting, and defect management.
• Supervised LoadRunner Performance testing effort, ensuring rational Confidential to effort.

Confidential, Shelton, CT

Senior QA Lead (Consultant)

Responsibilities:

• Coordinated test effort with ten Developers and four QA Engineers for web-based Shipping software.
• Authored Test Plan, specifying test script format and testing of Functional Areas by QA Engineers.
• Installed latest build on IIS Server, and ran “plumbing tests” to ensure proper software configuration.
• Oversaw functional regression, Performance, and installation testing.

Confidential, Shelton, CT

Senior QA Analyst (Consultant)

Responsibilities:

• Analyzed critical Sprint applications to understand any issues involved with migrating them from Connecticut facility to Virginia facility.
• Provided VB code maintenance, troubleshooting, and resolution of all configuration issues to ensure 100% successful migration effort; identified and resolved SMTP issues with VB code implementation.

Confidential, Valhalla, NY

Developer, QA Analyst

Responsibilities:

• Owned and delivered corporate mainframe migration from DB2 database to SQL Server database, for new Client/Server application; wrote over 100 T-SQL stored procedures to transform exported mainframe data into SQL Server tables; customized each stored procedure to construct correct foreign key data, and rollback/commit as appropriate; verified successful data conversion by checking referential integrity, uniqueness, and completeness of data in all tables; transformation involved millions of data records over 100+ tables.
• Developed VB prototype application that demonstrated feasibility and benefits of leveraging Microsoft Messaging API into custom software applications; prototype could send/receive e-mails with attachments to multiple recipients, and was leveraged as a set of functions easily embedded into in-house developed software.
• Improved quality of Confidential software SDLC by defining proactive processes to ensure software quality; process improvements covered documentation optimization, test plan preparation, defect management, and automated regression testing.