SUMMARY

• 9 years total software quality assurance experience in multi - project environments
• Manual and automated testing
• Developed, executed, maintained test plans, and use cases
• Automated testing tools: ETL Validator, QTP (VBScript), custom-built tools in SQL and Delphi
• Requirements analysis, testing, review, and gathering
• Unit, functional, SIT, UAT, application, regression testing
• Used various defect tracking systems under full SDLC
• Experience researching, creating, and maintaining technical documents for product library
• Quality Center and JIRA experience
• 6 years experience of SQL: MSSQL, Oracle, Teradata
• 3.5 years of ETL testing experience
• Over 18 Years Excel experince including charts, graphs, Vlookup and formula programming.

TECHNICAL SKILLS

Languages Programmed: C/C++, Java, JavaScript, Empower Delphi, HTML, XML, SQL, PL/SQL, Visual Basic, Machine and Assembly language

Mortgage Interfaces Tested: Freddie Mac Loan Prospector, Fidelity MSP, Credit reporting, Private mortgage insurance, Fidelity Empower broker module

Software Used: Data Gaps ETL Validator, Fidelity Empower mortgage software (.NET, Client/Server, Web, Fusion), Oracle 10g/11g (installation and tools), Toad, MSSQL 2000/2005/2008 (installation, tools and server maintenance), Testing on Windows 9x/00/XP platforms, Windows Server administration (NT 4.0), UNIX (3 years experience, Kornshell and Bash), Autocad2002, Blaze rule engine, defect tracking tools (PVCS, Team Track, Mercury Quality Center), MS Word, Excel, Access, Power Point, Visio

Hardware Used: Cisco networking equipment, Motorola 68HC11 MCU, digital and analog electronics

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

Software Quality Assurance Analyst

Responsibilities:

• Agile Project - Scrum methodology
• IFT Point of Contact for high profile regulatory-related project
• Worked closely with UAT stakeholders on test strategy and execution
• Reviewed technical documents for improvement
• Designed and Executed IFT Test Scripts in ALM
• Regression tested cloud migration of production application
• Created custom reports in Business Objects for data transfer testing
• Analyzed BI data mart schema for designing referential integrity tests of data transfers
• Used SQL for data set comparisons (union, intersect, minus)
• Used permutation, architecture design, and risk coverage techniques for test coverage selection
• Participated in test script reviews with stakeholders
• Wrote, maintained, and registered test artifacts for approvals in process traceability
• Created Status Reports for management from ALM metric reports

Confidential - Charlotte, NC

Software Quality Assurance

Responsibilities:

• Designed and Executed Manual Test Cases for International Trade Application
• Created test data for letters of credit
• Gathered business knowledge from SMEs for test scenario creation
• Populated application with test data for functional testing
• Created modular design of test scripts in ALM
• Collaborated with test team on test execution strategy
• Reviewed test scenarios for business needs

Confidential - Charlotte, NC

Data Analyst

Responsibilities:

• User Acceptance Testing of large, multi-user Business Intelligence System
• Participated in SDLC meetings with SIT and end-users
• Created and executed UAT test plans
• Created and executed test cases in Quality Center
• Reviewed SIT test scripts
• Analyzed large multi-feed data warehouse system
• Analyzed technical financial specifications and translated them into user requirements
• Evaluated Data Quality for End-User Fitness
• Examined data date ranges, missing data ranges
• Simple to moderately complex sampling methods
• Applied business rules to insure custom field data accuracy (e.g. combined logic outputs, dimension table data).
• Traced data flows to identify ETL logic suitability
• Generated and reviewed JIRA issues for LOB
• Provided production support
• Wrote and executed complex Teradata SQL queries, implemented business rules

Confidential - Charlotte, NC

QA Analyst/Project Lead

Responsibilities:

• Manual, Semi-Automatic (Excel), and Automated (SQL) Testing of Reporting Data Warehouse
• Project lead for multiple projects involving multiple team members
• Validated ETL and data for high volume Call Center and Banking Applications including:
• IVR (different applications)
• Genesys Infomart Data Warehouse 7.6 and 8.1
• CIV, VRU, STS
• Used Quality Center 11 for Releases, Reports, Requirements, Test Plans, Test Executions, Defect Resolution
• Used MSSQL Server 2008 and Oracle 11g tools for executing SQL and investigating design issues
• Created and Executed SQL queries including: multiple table joins, cursors, loops, variables, views, built-in functions, composite keys
• Gathered requirements for testing and documentation purposes from data owners of data warehouse
• Analyzed data and investigated data quality issues
• Traced data lineage of complex IVR call records through multiple database stages using SQL, XML, and custom created Excel analysis
• Designed and implemented IVR specific SQL procedure for data tracing and mapping (hexadecimal conversion)
• Created data mapping diagrams and structure definition documentation for undocumented system
• Reported data quality issues to design teams using Quality Center (ALM)
• Created and designed test plans for flat file loading with custom data mapping
• Used Excel string and regular expression tools for analyzing and testing flat file conversions
• Used SQL sub queries for automated referential integrity testing on star schemas
• Researched and analyzed technical systems for testing and documentation
• Participated in and lead technical meetings with LOB, UAT, peers, and management

Confidential - Charlotte, NC

Senior QA Analyst

Responsibilities:

• Manual testing of Global Human Resources management tool - Taleo
• Executed EUAT test scripts using HP Quality Center
• Stress and Load testing on number of global users and related links
• Ad-hoc testing of custom HR reports created in Business Objects
• Reported defects in HP Quality Center

Confidential - Charlotte, NC

Software Quality Control

Responsibilities:

• Manual System Integration Testing (SIT) of mortgage software for HAMP modification
• Manual testing of both Java based application and Java based C2B web interface
• Created, executed, and maintained manual test cases
• Edited XML files for test scenario creation
• Logged and tested defects in JIRA

Confidential - Columbus, OH

Software Quality Control

Responsibilities:

• Automated testing of database warehouse ETL (data mapping) using PL/SQL
• Created automated SCD transfer validation harness in PL/SQL
• Created variable sample size ETL test harness for ETL transfer
• Tested data modeling join functionality of ELT mechanism containing over 11,000 fields
• Performed complex PL/SQL queries for finding data quality issues
• Manual end user testing of Business Objects data mart
• Entered and tracked defects using Mercury Quality Center

Confidential - Rocky Mount, NC

Software Quality Assurance

Responsibilities:

• Created and executed manual black box test scripts for System Integration Testing (SIT) of Empower mortgage system
• Performed regression testing in pre-production environment
• System Integration Testing (SIT) of large mortgage pricing system
• Created and executed automated test tools using MSSQL, Empower Delphi, and Access
• Created and executed automated testcase generation algorithm on Loan Product and Pricing subsystem
• Executed full permutation of testcases using custom-built automation tool
• Extracted test results into auto-generated custom Access reports
• Documented detailed deployment/execution manual for tool
• Assisted configuration management department in use and deployment of Empower tool
• Analyzed software for regulations conformity requirements (I/O ARM project)
• Wrote and published validation documents for internal users

Confidential

Software Quality Assurance/Business Analyst

Responsibilities:

• Analyzed, created, executed, and maintained manual black and white box test scripts for functional testing of multiple .NET SOA and Web components
• System Integration Testing (SIT) of mortgage pricing engine
• Responsible for regression and smoke testing of multiple components (including Web (eB2B), NET)
• Analyzed, created, and executed automated validation tools for large SOA data mapping project using SQL(Fusion project)
• Designed, developed, and executed automatic testcase creation algorithm for back end data population
• Created automated tests for data transfer software for over 7000 database fields
• MSSQL and PL/SQL stored procedures
• Documented functional specifications for testing tool
• Designed, developed and executed SQL to automatically create multiple custom Pricing rules engines for testing purposes
• Researched, created, and maintained Fusion product process model for both technical and non-technical users
• Used business knowledge to analyze undocumented software functionality
• Used business analysis skills to uncover design flaws in pricing system
• Investigated and reviewed requirements issues for POS project
• Documented functional analysis results to development and QA teams
• Tested multiple eB2B mortgage Web services
• Modified XML output files for scenario creation
• Validated data in XML files
• Closely worked with business analysts, developers, and project managers
• Maintained knowledge base library for in house use
• Organized and conducted training seminars for product and pricing system
• Wrote technical release notes for end users

Software Quality Assurance Analyst

Confidential

Responsibilities:

• Performed manual black-box system and regression testing of Empower Client/Server product
• Tested software patches for release
• Tested various XML SOAP middleware interfaces for B2B
• Tested user-reported defects and enhancements for end users
• Created custom windows forms for test execution
• Worked with mortgage document data mapping