SUMMARY:

• Extensive experience in teh fields of Information Technology, Manufacturing, Retail focusing on Quality Assurance and Testing.
• Experience in Software Development Life Cycle (SDLC) using Waterfall Model and Agile Methodology.
• Experience in Data validation and analysis involving verifying teh Data Cleansing, Data Conversions, Data Transformation, Data Quality, Data Relationships, between Source Systems Analysis and Reporting.
• Extensive experience in IT industry in testing client server and web based applications
• Familiar with Data flow diagrams, Work flow diagrams and Process flow diagrams for teh purpose of creating test.
• Worked with teh development team to ensure testing issues were resolved.
• Performed backend data testing using SQL scripts to check teh data consistency, data integrity in teh application and database as data was fetched from different database tables.
• Extensive experience in performing data mart and data validation testing for data migration
• Perform bug tracking and Reporting using Quality Center and ALM.
• Experience in working with Analysts, Managers and Developers during teh software development life cycle (SDLC).
• Clear understanding of DW concepts and DW data modelling like star schema, and snowflake schema.
• Experience in Unit Testing, Integration testing, System Testing (Functionality and Regression), Performance testing and User Acceptance Testing.
• Valuable experience in coordinating with off shore resources.
• Involved in teh development of Test Plans, Test Cases and maintaining teh Traceability and Test Matrix.
• Detail oriented with strong multitasking and interpersonal skills and ability to resolve problems.
• Motivated, self - starter, with exceptional team building and leadership skills.

TECHNICAL SKILLS:

Languages: SQL, Unix scripts

Databases: Oracle (RDBMS) 10g, 11g, MS SQL Server 2005, DB2, MS Access

Other Tools: MS Project, MS Office, HP QC and ALM

DW Tools: Informatica 8.6, Business Objects XI 3.2

PROFESSIONAL EXPERIENCE

Confidential, DC

QA Analyst

Responsibilities:

• Responsible for development, review, analysis, and coordination of teh test plans, test scripts, and testing of internally developed software system.
• Ensure alignment of testing strategy with teh project’s quality goals and resource limits and escalates issues to teh QA Lead and alerts teh project team on potential impact to test schedule.
• Experience in testing applications in an iterative development lifecycle.
• Work with requirements analyst to get a good understanding of functionality
• Identification and documentation of test cases for multi-component systems
• Responsible for development of test plan and test cases and executing of test cases and documentation of software defects in Quality Center
• Co-ordinate with Developers towards resolution of outstanding issues/bugs
• Update Testing/Project managers on status/issues
• Participates in Production Support Testing though rotating on-call responsibilities.
• Experience in System Integration testing, Database API testing, Functional testing (Black box testing) Security, Recovery, Negative, Regression testing, Load testing
• Performed extensive back end validations using SQL queries in TOAD to verify dat teh data TEMPhas been processed correctly based on teh business requirements
• Experience with SQL to query Oracle database to check/compare process inputs/outputs using complex joins and sub queries
• Provide timely and accurate status defect information and appropriate metrics to facilitate QA reporting. Reports individual status: dashboard information, open issues, risk analysis.
• Experience in preparing test data for testing application
• Experience in creating simulated data and invoking UNIX process for data fill jobs.
• Performed XML schema validation for API testing
• Development of regression testing framework and detailed documentation of test results
• Demonstrated problem solving, design and technical leadership skills
• Provided training to teh team members for working with interfaces

Environment: Oracle 11g, Informatica, MS Office Suite. HP ALM, Rational Clear Quest, Business Objects Reports, Autosys, UNIX, XML, SharePoint.

Confidential, CA

Quality Assurance Engineer

Responsibilities:

• Worked closely with team of DA’s, developer, business users and testers throughout teh entire Software Development Life Cycle
• Implemented Test Plan, Test Cases, and Test Scripts based on business requirements
• Performed testing, debugging, bug reporting, and documentation
• Created manual and automated test scripts based on Use Cases
• Performed Regression Testing and End-to-End Testing of teh entire application
• Implemented Positive and Negative Testing on quote module using different sets of data
• Created Data Validation scripts to verify accuracy of migrated data.
• Developed SQL scripts to validate teh data between source and target systems.
• Worked on Quality Center to upload test cases and defects.
• Compared data on source systems on XML, sql server, Oracle and target in oracle.
• Tested request and response data sets dat were associated with teh application validating teh XML request and response

Environment: Quality Center, SQL Server 2008, XML, XML Spy, Oracle, SQL*Loader, Toad

Confidential, Ashburn, VA

Test Engineering Analyst

Responsibilities:

• Preparation of Requirements Traceability Matrix based on teh business and teh testing requirements.
• Prepare test case analysis and assisted in creation of teh system test plan and end-to-end data migration system test plan.
• Analyzed teh ETL design documents to understand teh logic
• Created test cases and test procedures for various stages of teh ETL process including source to extract, source to staging and staging to target using SQL, Quality Center 10.00 and TOAD for Oracle 8i.
• Used Informatica Power Center Workflow Monitor to trigger master/stand-alone workflows.
• Used UNIXto validate error files and flat files.
• Created end to end test procedures for full cycle validation of system functionalities.
• Performed extensive Multiple System Integration Testing and Functional Testing.
• Qualitative verification of data from source to target using a sampling approach based on stratification of data.
• Created manual testing scripts for black box testing of target application.
• Executed dry runs and test script execution.
• Extensively involved inDefect tracking/observations,reviewingandanalyzing and reporting testresult usingQuality Center.
• Analysis of change requests and identification of teh impacted test cases and procedures.
• Documentation of observations and artifacts as per teh cGMP guidelines.
• Requirements analysis and risk analysis based on GAMP 5 guidelines for data migration activities for teh implementation of eProgesa application across 36 regions nationwide
• Participated in Weekly / Monthly QA metrics reviews, provideQA status reportsto management
• Performed regression analysis and regression testing for all teh test case scenarios based on teh data mapping rules.
• Participated inTest Readiness Review
• Preparation of TAR (Test Analysis Reports) for teh executed scripts

Environment: Informatica 8.6, TOAD, SQL, Quality Center 10, Oracle, MS SQL Server

Confidential VA

Quality Assurance Analyst

Roles and Responsibilities:

• Analyzed teh functional requirements by interacting with system architect, developers and business users by conducting walkthroughs and meetings.
• Developed and executed Test cases to implement Scrum for frequent intermediate deliveries with working functionality.
• Adopted Agile/scrum methodology for - Risk Mitigation, Monitoring and Management (risk analysis) at every stage of teh project Cycle with transparency in planning and module development
• Preparation of Test Plan, Manual & Automated Test Cases, Test Execution, Test Scripts, Test Results Reporting, Bug Tracking and Closure
• Created and executed test cases and test scripts for front-end web screens, interface validation and End to End and Integration Testing.
• Experience in Cross Browser testing, Firewall, Security testing.
• Successfully implemented Automation Frameworks (Data driven, Keyword driven & Modular) for QTP 8.2 and 9.0
• Extensively Build and Developed Libraries of User Defined Functions, Object Repositories, Reusable Actions, Error Handling Techniques and Recovery Scenarios in QTP
• Tested and developed teh mapping for extracting, cleansing, transforming, integrating, and loading data.
• Experienced in RDBMS and using database query tools for Oracle, SQL and UNIX such as TOAD.
• Involved in developing Shell Scripts, running Batch jobs in UNIX for validating teh Request forms for Registration process.
• Experience in performing data analysis using SQL queries, PL/SQL/Stored Procedures/Triggers/Views and fine-tuning of teh database indexes.
• Creating XML test data to validate and mock up feeds from external vendors using XML file editors
• Created test data for testing .Net applications.
• Tracking test case execution progress, test results analysis, and maintaining RTM.
• Reported defects using Rational Clear Quest and participated in Defect Review meetings

Environment: Java, J2EE, XML, .NET,HTML, ORACLE 10 g, SQL SERVER 2005, RDBMS, Web Logic, Web Services, SOA, IIS, VB Script, Quality Center, MS PROJECT, Office Suite, VISIO, QTP, Clear Case, Crystal Reports, Toad, Sun Solaris AND LINUX.