SUMMARY

I am a Senior Testing Professional with 10 years of experience in testing W eb based, Client/Server and Data Warehouse applications. I recently completed an 8 - month assignment at Confidential as a Senior Software Quality Analyst. This was my third assignment at Confidential . The recent experience includes a successful year-long engagement as a QA Lead at Confidential for an on/offshore QA/Testing team of 6 using Agile. I am a process advocate with knowledge of various methods such as SDLC and CMM, and I have implemented steps to streamline testing efforts to ensure quality. I have performed tests on various applications and systems across multiple platforms (Web, Client Server, Database and Legacy Systems). Domains/applications tested include Decisioning, Reinsurance (Underwriting, Billing, Claims and Treaties), CAD, Telecommunications, POS, Human Resources, Credit Card Processing, ETL/Data Warehouse, and Medical Devices. I am very proficient in database and SQL and achieved Oracle Certified Associate DBA. I have worked with various databases including Oracle, SQL Server, DB2, Teradata, MS Access, and MySQL. I am energetic, organized, and an efficient team player, who is driven to deliver a quality product to the customer. I have proven reliability with emphasis on detail and quality, and gets the job done with minimum supervision. I reside locally, US Citizen, and I am immediately available.

TECHNICAL SKILLS

Methodologies: SDLC, QA Lifecycle, Waterfall, Agile, Scrum, CMM

Automation Tools: Quick Test Pro (QTP)

Test Reporting Tools: HP ALM (Quality Center), ClearQuest

Microsoft Tools: Access, Word, Excel, PowerPoint, SharePoint, Visio, Team Foundation Server (TFS)

Web Services: SOAP UI, Rest Services

Database: Oracle, SQL Server, DB2, Teradata, MS Access, and MySQL

ETL Tools: SQL Server Integration Services (SSIS)

Environment: s: Java, .Net, Mainframe, OAD, ILA, Mobile Application, C/C++

Languages: SQL, PL/SQL, HTML, XML, VB Script

OS: Windows, UNIX, Linux, Mainframe

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Quality Analyst

Responsibilities:

• Defined the test strategy and contributed to development of the Project Test Plan.
• Perform duties using tools such as, dual screens, SharePoint, MSP and ICMP
• Utilizes MSP to update loan status and to validate information relating to investors, tax payments, loan modification
• Used Attachmate Extra for MSP for validating data conditioning used in testing
• Created and executed test plans and test cases, and performed defect tracking in HP ALM 11.0/Quality Center.
• Reviewed and translated the system requirements into system test elements like modular test scenarios, scripts and test cases for the Selling system components including Loan Modification, Modify Loan, Evaluate Loan and others using HP ALM/QC.
• In coordination with Project Manager, Business Analyst and System Analyst, reviewed and suggested updates to Business Requirement documentation for Mortgage procurement system.
• Created Traceability Matrix to ensure that all the requirements are covered by the test cases.
• Participated in the complete QA Lifecycle including Pre-testing phase, Acceptance Testing Phase, Testing Phase and User Acceptance Testing (UAT).
• Performed Functionality, GUI, System Integration, Backend Database, Regression, and Security Testing.
• Created and executed SQL queries to fetch data from Oracle and MS SQL Server databases to perform backend testing and validate the UI data.
• Retrieved daily data from the Mainframe production environment for the Systems Integration Test (SIT) environment.
• Validated XML response and request using XML Transaction Viewer.
• Ensured all projects were delivered on time and in accordance to company guidelines and specifications.

Confidential

Senior Software Quality Analyst

Responsibilities:

• Participated in design and development of test plans based on high-level and detailed designs using Agile methodology.
• Analyzed requirements and wrote functional test cases for manual testing.
• Worked on multiple projects simultaneously.
• Used HP ALM Quality Center to prepare test plan, test cases and test data.
• Created, executed and maintained test cases and ensured test cases/scripts were updated with each new product release’s functionality.
• Developed and executed several SQL queries, stored procedures as a part of backend testing using RazorSQL, and participated in data validation and verifying data-integrity
• Worked with the project team to resolve issues encountered during testing.
• Managed day-to-day project task assignments such as task prioritization, estimates, and time reporting.
• Proactively worked to identify, clarify, and resolve issues, and remove barriers in a timely manner.
• Worked with project managers and management to set priorities and address escalated items.
• Worked with QA Manager/Lead and Project Manager for planning and schedules to test deliverables.
• Performed test case walkthroughs with other team members and QA Manager/Lead.

Confidential

Senior Software Quality Analyst

Responsibilities:

• Performed End to End process for software testing based on business requirements, created estimations, test plans, test cases, testing and supporting World Wide Sales Reinsurance teams for Underwriting, Billing, Claims and Treaties applications.
• Prepared and executed functional, regression tests scripts and defect tracking using QTP, SharePoint and TFS.
• Participated in Design and Requirement review meetings that lead to generation of quality deliverables by working collaboratively with Project Managers, Business Analysts and Developers.
• Led and participated in pre-production and production testing on quarterly basis.
• Created User Guidance Notes for new enhancements and fixes for the application.
• Created quarterly Release Notes that were used for training user and in the application help files.

Confidential

Lead Quality Analyst

Responsibilities:

• Performed as Lead Quality Analyst which included assigning, tracking and reviewing work for a team of 1 onshore and 5 offshore Quality Analysts/Testers, working in an Agile environment.
• Facilitated daily Scrum meetings for local and remote team members including Business SMEs, Project Management, Development, customer representatives, QA and UAT test members to review and prioritize defects.
• Reviewed functional requirements and provided input on missing requirements as well as improved requirement clarification during requirement review meetings
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Provided daily test execution metrics that included number of test cases passed/failed, number of defects based on status and severity levels to Project Team members for monthly production releases
• Provided monthly QA metrics scorecard on test cases created and executed, defects found by severity, defects verified and closed, number of builds tested and failed
• Expertise in the flow of the data from the source through the ETL process into the target data warehouse.
• Validated the data at each transformation (source tables, staging tables, loading tables and finally target tables/views) using the data mapping files and data dictionaries Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• Conducted regression testing on the application under test.
• Gathered and analyzed metrics, and reported to team.
• Tested data reports. Wrote several SQL queries for validating the front-end data with backend.
• Conducted test case reviews to ensure scenarios accurately captured business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.

Confidential

Test Engineer

Responsibilities:

• Designed and developed test plans/scripts that included conditions, expected results and test data on the product requirements and technical specifications for System Reports
• Evaluated requirements and functional/technical designs to identify and analyze potential risks early in the development cycle and validate functionality according to business requirements
• Documented and tracked software defects in Mantis defect tracking tool
• Executed tests in both web-based and client/server environment
• Reviewed and assisted in updating test protocols
• Used Quick Test Pro (QTP) to edit and execute test scripts to enhance the efficiency and effectiveness of the testing environment
• Interacted with Developers to report, analyze, verify and resolve defects
• Extensively applied database (SQL Server 2000/2005/2008 ) expertise in generating test data

Confidential

Quality Analyst/Data Analyst

Responsibilities:

• Performed data and applications analysis, backend database testing and frontend applications testing for a Data Migration/Conversion Project.
• Reviewed and assisted in updating various documents; Business Requirements, Data Modeling Documents, and Application Functional Design Documents.
• Created test plans, executed tests, and logged defects for backend and frontend.
• Interacted with Developers during testing to report, analyze, verify and resolve defects.
• Extensively applied database (SQL Server 2000/2005 and ORACLE 9i/10g) and SQL-PL/SQL expertise in Backend Data Migration testing.
• Became proficient in use of Mercury Quality Center 9.0/9.2 test suite.
• Used Test Plan for developing test plan tree
• Used Test Lab for defining test sets, running tests and creating defects
• Managed Defects which included updating, mailing, linking and defect views
• Analyzed the testing process by generating Reports and Graphs
• Gained hands-on experience with and assisted in support of Confidential Corporate Trust Services (CTS) applications; Deal Series, Parties, CIP OFAC, Investment Agreements, and Cash Sweeps.
• Gained hands-on experience with and assisted in support of Confidential Corporate Trust Operations (CTO) applications; Notification - DWAC Processing Enhancement, and Transfers between CUSIPs.

Confidential, Rochester, MN

Quality Assurance Analyst

Responsibilities:

• Validated relationship between requirement definition, functional system design and use cases to ensure documents were in synch and recommended corrections where appropriate
• Participated in design reviews and made recommendations as needed
• Followed an iterative and incremental approach to software development
• Assisted in the development and validation of entrance and exit criteria for each iteration of the testing process within the development life cycle
• Developed test summaries, test plans and test cases using standards defined by the project
• Executed test cases, recorded actual results and documented defects according to the company’s reporting process
• Verified and validated defect fixes and enhancements to ensure the features functioned as specified in the design document and requirement definition
• Created training materials for use by new team members and to bring other staff members up to speed on new features
• Created and presented test status reports to QA Lead, Manager, Project Manager and other members of the review and resolution team
• Performed User Acceptance and Regression Testing in test recommended environments
• Performed Accessibility, L10N and I18N Testing, Section 508 accessibility guidelines compliance testing, L10N (Localization) testing of software adapted for a specific regions/languages including locale-specific components and translated text, I18N (Internationalization) testing of software designed for flexibility and adaption to various languages

Confidential, Rochester, MN

Software Engineer/Test Engineer

Responsibilities:

• Created and supported validation techniques that were necessary to demonstrate compliance with regulatory and accreditation requirements
• Maintained quality records, project status and performance metrics for new releases and modified applications
• Defined, performed and documented product validation for new and modified features
• Investigated environmental, operational and process problems in conjunction with other engineering and technical personnel on in-house and vended products to ensure compliance to specified requirements
• Assisted in quality reviews of requirements, design documents and test case/test scenarios for new releases and modifications of applications
• Created Test Plans, Cases and Scripts from requirements and design documents to test data collection, mapping and trending, and automatic, interactive and ad hoc report generation programs that were developed in Java and RPG for the Performance Management product
• Coordinated User Acceptance and Regression Testing for new releases and modified applications
• Initiated defect/issues review and resolution calls between users and PM iSeries review team
• Prepared the test environment by moving necessary data, files and other objects from the production database to the test database to maintain the quality and integrity of data for integration testing
• Participated in a weekend support rotation schedule with responsibility for ensuring all servers are up and running, monitored scheduled jobs, and made sure customer web sites are accessible

Confidential, St. Paul, MN

QA Analyst

Responsibilities:

• Developed strategies and test cases for testing a Global Data Warehouse system
• Developed test cases and scripts for testing process that loaded the global data warehouse
• Tested and validated load procedures for the Data Warehouse
• Designed SQL test templates that assessed the quality and integrity of data loads in the test environment
• Used SQL queries against production tables to validate data being loaded to the warehouse
• Environment: MS-DOS 6.22, Win NT 4, Win 2000 Prof/Adv Server, Win XP Professional, Oracle 9i, SQL Server, DB2

Confidential, Edina, MN

Software Tester

Responsibilities:

• Tested the learning and performance management product for John Deere technicians.
• Created Test Strategy, Cases, and Scripts for in-house integrations with customized Vendor developed applications
• Performed User Acceptance and Regression Testing in test environments
• Reported defects, issues, and concerns to the review and resolution team
• Maintained the test environment to ensure the quality and integrity of data
• Used SQL to verify accurate reporting and data retrieval for testing purposes
• Environment: Win NT Server, SQL, Oracle 9i, SQL Server 2000

Confidential

Geek Squad Agent

Responsibilities:

• Installed and configured software packages such as operating systems, word processing and spreadsheet programs per current Information Services guidelines
• Installed and configured Computer hardware which included workstations, laptops, printers and servers peripheral devices
• Created and maintained computer application images
• Troubleshot and repaired computer hardware, printers, peripherals
• Recommended and performed corrective actions to solve customers’ hardware, software, and desktop and network problems
• Provided hardware or peripheral repairs with vendors
• Provided telephone support to customers
• Tracked hardware and software inventory
• Instructed customers on how to use computer equipment, software, and manuals
• Environment: MS-DOS 6.22, Win NT 4, Win 2000 Prof/Adv Server, Win XP Pro, Oracle 9i

Confidential

Computer Lab Consultant

Responsibilities:

• Provided services to students enabling them to efficiently utilize computer lab computers and other electronic devices
• Installed and configured hardware and peripheral components such as monitors, keyboards, printers and disk drives
• Installed and configured software packages such as operating systems, word processing and spreadsheet programs
• Provided routine technical support for computers and associated networks using standard policies, procedures, and guidelines
• Diagnosed and troubleshoot computer lab hardware and software problems
• Resolved student’s problems through technical support and analysis
• Environment: MS-DOS 6.22, Win NT 4, Win 2000 Prof/Adv Server, Win XP Professional, SQL, SQL Server 2000