SUMMARY:

• Over 7+ years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Banking, Financial, and Retail Industries. Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC). In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, ETL and Mobile Testing.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Experience in using Oracle Database, SQL Server.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Expertise in extended validation of report functionality developed, using Informatica, Business Objects, by writing complex SQLs at the backend.
• Good concept of ETL, Warehouse and BI applications integration.
• Experience in Web Services testing using SOAP UI.
• 5+ years with SQL/PL-SQL and expertise in writing complex SQL Queries.
• Work extensively with slowly changing Dimensions & Audit Tables
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Proficient in Oracle 10g/9i/8i/7.3, PL/SQL Developer Toad, PL/SQL Developer SQL Navigator.
• Application Data warehousing experience in Financial, Banking, Retail.
• Proficient in Software Quality Assurance on Desktop, Client/Server, Web Services and Web based applications.
• Excellent working knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) with emphasis on Testing and requirement gathering phases.
• Expert in writing Test Plans, defining Test Cases, developing and maintaining Test Scripts, Test Case Execution, Analyzing Bugs and interacting with team members in fixing the errors as per specifications and requirements.
• Experience in both Manual and Automated and Test Management tools such as Quick Test Professional (QTP), Quality Center.
• Involved in different types of methodologies like Agile and Waterfall methods. Worked in SCRUM and Agile methodology of project development.
• Experience in Functional, Integration, Regression, System Testing, User Acceptance Testing.
• Used Quality Center, Jira and BugZilla for tracking defects.
• Experienced in creating Requirement Traceability Matrix to ensure comprehensive test coverage of requirements.
• Excellent analytical, problem-solving and documentation skills.
• A team player with excellent interpersonal, communication and presentation skills with strong aptitude towards learning new technologies.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, VB

Requirements/Test Management: HP Quality Center

Defect Management: Rational Clear Quest, HP Quality Center, JIRA, Bug Zilla

Testing Automation Tools: QTP, Load Runner, Soap UI, XML Spy tool Altova

GUI or Front End: Java, ASP. Net, HTML, Cold Fusion, Mobile

ETL / BI / Data Warehousing: Informatica, Autosys, Cognos

RDMBS: Oracle, MS SQL Server

Operating Systems: Windows Family, UNIX

Other: Toad, SharePoint, MS Office, VISIO, MS Visual Source Safe

SDLC: Traditional Waterfall & Agile Methodologies - Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. QA Analyst

Responsibilities:

• Field Validation Testing, Functionality Testing of UI and Web Applications. Test Development, Execution of multiple applications in the HAMP Program (Interfaces, Reports, LPS) across various HAMP releases.
• Developed complex SQL queries to identify test data and validate data in outbound interface files and Reports both manually and using automation framework.
• Provided inputs to Test Case generator Tool development by Automation Team for creating Test cases for Edits based on business rules.
• Utilized data creation tools extensively to create reusable input data files for processing during Test case execution and validation.
• Involved in preparing the test case documents for Treasury Reviews.
• Mapped software requirements to test case scenarios by developing Requirement Traceability Matrix, Gaps Reports, and Unmapped Scenarios in Quality Center. Extensively worked in creating Test Procedures, Test plans, Test cases and involve in reviewing with peer. Involved in process Tracking defects
• As a key part of the IR2 System test team responsible for creating test scripts, test cases and plans to support all software testing activities.
• Validated test cases by executing test scenarios in Quality Center
• Documented defects found during execution in QC and keep track throughout defect life cycle. Interacting with team members in fixing errors.
• Involved in Internal and External reviews of requirements, specifications, and logics and provided valuable inputs/comments.
• Providing regular status during planning, execution phases of the release.
• Extensively used the AutoSys jobs for the entire project.
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Experience testing on XML documents.
• Managed and conducted System testing, Integration testing, Functional testing, Performance testing, UAT and Regression testing.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Execute batch processing and verify the jobs status and data in database tables.
• Responsible for designing Framework and executing automation scripts using QTP.
• Tracked the defects using Clear Quest and Quality Center and generated defect summary reports.
• Created checkpoints and synchronization points for functional testing using Quick Test Pro (QTP).
• Prepared status summary reports with details of executed, passed and failed test cases.
• Interacted with developers, Business & Management Teams and End Users.
• Involved in SOAP UI to test web services using WSDL file.
• Participated in regular project status meetings related to testing.

Environment: SQL, TOAD, Oracle 10/11g, QTP 10.0, Quality Center 10.0, LR 10g, XML SPY tool, SOAP UI, UNIX, AUTOSYS 4.0, INFORMATICA, COGNOS, Waterfall Methodology and Agile Methodology.

Confidential, Baltimore, MD

QA Analyst

Responsibilities:

• Reviewed Business Requirements and Functional Specifications to ensure all user paths are covered.
• Worked in different Phases of testing: Test Planning, Test Development, Test Execution and Defect Tracking and Test Reporting and User Acceptance Testing.
• Worked with Application developers and internal users to develop thorough test plans.
• Verified software functionality for software development projects.
• Performed hands-on manual testing to validate that software meets the requirements.
• Created test data/conduct database queries as required to evaluate software functionality.
• Wrote and executed Test cases and Test Scripts after reviewing the business requirements and technical specifications in Quality Center.
• Created defect tracking in Quality Center for application deficiencies found during testing.
• Participated in peer reviews of functional specifications, application previews, and test plans.
• Coordinated with end users to support User Acceptance Testing.
• Involved in testing a Native app on iPhone, iPad for various test cases in regards to UI design, functionality, logic test of various orientations (portrait and landscape).
• Created, updated and ran QTP scripts.
• Performed testing of Web Services using SOAP UI.
• Involved in testing native apps on IO simulator for various devices with different operating system and different orientation.
• Involved in testing the mobile compatible website using the services like browserstack.com and was involved in testing the responsiveness layouts and cross browser testing.

Environment: Windows XP, Linux, SQL Server, Toad, Jira, Internet Explorer 6.0, Mozilla Firefox, Quality Center 9.0, QTP 10.0, Waterfall Methodology.

Confidential, Baltimore, MD

QA Analyst

Responsibilities:

• Developed Business Test Cases using Quality Center 9.0 are covered.
• Developed Test Plans and written test cases per the business and technical requirements.
• Developed and maintained Requirement Traceability Matrix (RTM) and Test Matrix.
• Performed Manual Testing to test the functionality of the application.
• Created functional and regression test automation using Quick Test professional pro 10.0.
• Monitoring the Defect Tracking Process and generating customized reports using Quality Center.
• Developed Used Cases for the development of the application.
• Conducted the User Acceptance Testing.
• Documented and reported bugs using Quality Center.
• Coordinated with end users to support User Acceptance Testing.
• Actively participated in Status reporting meetings and interacted with Developers to discuss the technical issues.

Environment: HP Quality Center, Quick Test Professional, Oracle, Toad, SQL Plus, Java

Confidential, Sterling, VA

QA Tester

Responsibilities:

• Involved in analyzing the Business requirements and System specifications to understand the Application.
• Contribute to various STLC stages by creating test scripts, executing test cases and managing defects.
• Interact with business for test case clarifications and develop test plans.
• Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
• Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
• Designed test plans and defined cases for functional, integration system, and user acceptance testing.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Used QC for test case repository, reporting and tracking bugs, and providing updates on resolved bugs.
• Liaise with developers, business analysts, and business end users in testing and document reviews and responsible for test deliverables & issue escalations
• Involved in testing creation of a unique loan number for all loans.
• Attended weekly defect report meetings and presented progress updates.
• Configure test environment and create strategy for web application development. Assure test data, schedule manual tests. Approve results documentation and tracking systems updates.
• Executed queries in SQL for database and backend testing.

Environment: Manual Testing, Windows, Cold Fusion, ASP.Net, Oracle, Quality Center, Waterfall Methodology

Confidential, Baltimore, MD

QA Analyst

Responsibilities:

• Analyzed Business Requirements and prepare test cases in Quality Center
• Prepared RTM document to make sure each requirement is covered in test cases.
• Tested the upgrade of online payment processing system.
• Prepared test Data for the Requirements.
• Executed Test Cases, report defects, investigate and document results in Quality Center.
• Performed System Testing, Integration Testing, Stress and Performance Testing.
• Performed automated testing using QTP for the regression testing.
• Generated the defect reports for active, resolved, re-test pending defects.
• Performed final release testing and coordinate with stakeholders to get release sign-off.

Environment: Oracle, SQL, Windows, Cold Fusion, HTML, Quality Center, Waterfall methodologies.