SUMMARY

• Quality Assurance Analyst/Tester with over 9+ years of experience in automation and manual testing of client - server, web application and desktop applications.
• Strong experience in reviewing technical documents, test planning, development of test cases and test scripts based on business and functional requirements and system design specifications, test execution, defect tracking, and test status reporting.
• Performed automation testing using Selenium (RC and Web Driver), QTP and Perl.
• Performed multi-platform testing on different Operating Systems (Windows, Linux, and Solaris) and has developed and tested Java based applications.
• Worked in Java, JPA (Java Persistent API), TestNG Framework, Ant and Eclipse IDE.
• Strong testing background that includes reviewing system requirements, estimation, writing and executing Test cases and status reporting
• Coordinated test deliverables and quality controls.
• Expertise in ETL process using Informatica (Power Mart / Power Center)
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files
• Proficiency in development of Test Plans, Test Conditions, Test cases and automated Test Scripts
• Strong Experience in GUI Functionality testing, Black box testing, System testing, End-to-end testing, Smoke testing, Regression testing
• Data-driven testing, Cross Browser testing, User Acceptance Testing and Boundary Value Testing, performance testing, stress testing, load testing and endurance testing.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server. Experience
• Working experience on creating Test Planning and Test Management.
• Knowledge of creating objects, managing the fields in the objects in SFDC.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files
• Experience on SOAP UI tool to test Web services
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management
• Working experience in ALM, JIRA and other tools.
• Solid understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (SLTC)
• Strong experience with Selenium automation.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Proficiency in defining, formatting and executing Test Cases based on Business Requirements Ensuring the Traceability for the requirements throughout the testing process
• Working experience in the Agile/Scrum Process.
• Good experience on ETL, Informatica, and Business Objects Reporting and Analysis capabilities

TECHNICAL SKILLS

Automation Tools: Selenium (RC,WebDriver), QTP, Soap UI, Perl, TestNg Framework, Eclipse IDE

Software Methodologies: Waterfall, Agile SCRUM

Operating System: Windows XP, Vista, RedHat Linux, Suse Linux, Solaris

Languages: Java, VBScript, HTML

Documentation: Test plan & test case documents, Test Strategy documents, Traceability matrix, Project Status Reports, Defect summary reports.

Test Management Tools: Quality Center 10, HP ALM 11, Bugzilla

Data base/ DB tools: SQL Server, Oracle, DB2, VSAM, QMF, Teradata

Version Control tools: Visual Source Safe, Sub Version

PROFESSIONAL EXPERIENCE

Sr. Quality Assurance/ Automation/ SQL Analyst

Confidential - Stamford, CT

Responsibilities:

• Reviewed the requirements and estimated the testing efforts using different methodologies like orthogonal array, boundary value analysis etc.
• Used QTP and Selenium to develop automation test scripts for system's core functionality and GUI's of the application.
• Reviewed Test cases with team members and provided inputs accordingly.
• Executing the Scripts By using Selenium Web driver.
• Created checkpoints and synchronization points for functional testing using Quick Test Pro (QTP).
• Knowledge in designing of custom objects, custom fields, pick list, role based page layouts
• Workflow Alerts and Actions, and Approval Workflow, Validation Rules, Approval Processes, custom Tabs
• Reviewed and approved the builds into test environment and performed sanity testing after builds
• Performed data validation and data flow between interface applications as part of integration testing.
• Written complex SQL queries to validate the data against the target based on ETL mapping
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Compared query result sets from different database systems using UNIX diff command.
• Verified correctness of data after the transformation rules were applied on source data.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Developed complex queries by joining different Dimensional tables to Fact tables and retrieved the data From EDM and validated the data against EDW.
• Implemented data verification procedures for ETL processes in load testing.
• Used SQL and PL/SQL scripts to perform backend database testing.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings

Environment: Windows XP/7, UNIX, J2EE, SDLC, SQL Server 2005, TOAD, SQL PLUS, QTP, Selenium Web driver, Informatica, Oracle 10g.

Sr. QA/ETL/Automation Engineer

Confidential - Highland Hills- OH

Responsibilities:

• Organized walkthrough and review session from BA, ETL developers and DBA to understand the business process
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Data Conversion and Data Migration project
• Worked with Data Extraction, Transformation and Loading (ETL)
• Tested the ETL process for both before data validation and after data validation process and tested the messages published by ETL tool and data loaded into Oracle databases
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Transformation Mapping
• Written several complex SQL queries for validating Business Objects Reports based on the data mapping requirements
• Responsible for Data mapping testing by writing complex SQL Queries using SQL Plus and Toad
• Developed automation test scripts to test the database by retrieving the data from the tables using HP QTP and VB Scripting.
• Analyzed test cases for automation and created scripts for regression testing using QTP 9.2
• Involved in testing data mapping and conversion in a server based on Informatica data warehouse
• Developed a Java-based test framework for testing web application built with HTML5 in different browsers and OS using Java, Selenium Web driver.
• Good experience in performing Asynchronous Web Services Testing using SOAP UI tool
• Used Quality Center to create Test cases, Map the test cases to requirements, create test sets and report defects
• Good experience in Analysis of Bug Severity, Bug Tracking system and Bug Reporting using Quality Center.
• Uploaded Test Plan, Test Scripts, Scenarios and Final Reports in the Quality Center for every application.
• Used SubVersion for maintaining scripts.

Environment: Quality Center 9.0, QTP 9.2, Informatica (Power center Designer, Workflow), BI, Integrity, Flat files, Oracle 8i, PL/SQL, SQL*Loader, Stored Procedures, Triggers, Java, Business Objects, Windows 7, NT, Microsoft Visio, Microsoft Office 2007/2010, Sub Version

QA ENGINEER/ SQL Analyst/ Data Analyst

Confidential, Houston - TX

Responsibilities:

• Provided QA testing, Scalability testing, and Accessibility testing and was involved in agent automation part for the CA.
• Identified the test data by organizing multiple test data review meeting and also created test data for specific Test Scenarios and Test Cases using SQL
• Created test data requirements document based on the test scenarios and provided to the DBA for test data purpose
• Created detailed test cases in Quality center and mapped to the requirements
• Created different set of test cases for both Equifax and TransUnion Bureaus by interacting with their Development and Testing Teams.
• Mapped the test data to a specific test case for execution purpose
• Created Macros to execute the function automatically to schedule the file at a particular time.
• Performed Functional, System-Integration, End to End, Regression testing and User Acceptance Testing
• Extensively utilized Microsoft Visual Studio system team edition, QTP, Selenium for creating, implementing and executing automated, generic, manual, load, stress, ordered, unit and web tests.
• Responsible for Java/TestNG coding of automated Selenium tests scripts utilizing Firefox, Chrome, Safari, & Internet Explorer browsers
• Created Folder structure in MS Team Foundation Server (TFS) and uploaded Smoke Test Automation scripts and mid-level Test Automation scripts in related folder.
• Verified the "fixes" for the reported defects by performed Regression testing using QTP and provided defect status reports to the management.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Managed weekly team meetings to review progress and developed/distributed monthly project management reports.
• Used SQL queries to test and verify the data in tables in the SQL Server and Oracle 10g database.
• Prepared the VPAT (Voluntary Product Accessibility Template) document for the product.

Environment: QTP 8.0, Quality Center 8.0, ALM, Java, Java Script, SOAP, MQ Series, J2EE, EJB, Jira, LINUX, UNIX, Oracle, SQL, File Aid, DB2, Microsoft Visio, Microsoft Project, and Visual Source Safe

QA ENGINEER / Automation Test Engineer /SQL Analyst

Confidential - Charlotte, NC

Responsibilities:

• Analyzing new Business requirements for each & every release and worked with analysts and business team for any gaps found during the test analysis
• Tested the data coming through various lines of business of Confidential such as Capital Funding, Venture Capital, Trust Accounting System, Bank Owned Life Insurance etc.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Incremental development/testing of Enterprise Data Warehouse.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Write SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Responsible for monitoring data for porting to current versions.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology ie backward navigation from target to source.
• Interacted with Business Analyst, Database Administrators, development team and End Users.
• Preparing Test plan, Test scenarios and writing & execution of Test cases
• Identified Test Conditions in according to the BRD's and Change Requests
• Written and Executed the UNIX test cases on EDI format and verify Translation response
• Performed Reliability testing for testing the UNIX servers
• Responsible for execution of Batch jobs and population test data for other teams
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
• Responsible for FTP jobs to transfer data between UNIX test servers.
• Responsible for Production Monitoring during peak hours
• Used Test Director & Rational DDTS as Test Management tool.
• Responsible for doing System Testing, Functional Testing, Integration Testing, Load Testing and Smoke Testing.
• Extensively worked on Backend using SQL Queries to validate the data in the database.

Environment: Informatica 6.1, 7.1, PERL, Unix Shell Scripting, SAS 9.1, SAS/SQL, PL/SQL, XML, XSLT, XSD, Teradata V2R5, IBM DB2, Flat Files, VSAM, COBOL II, MVS, JCL, Copy Books, Autosys.

QA/ Automation Engineer

Confidential

Responsibilities:

• Developed ETL Test Plan and Test Strategies for the entire Line of businesses.
• Extensively used SQL queries for Database testing and Validation.
• Involved in extensive backend testing.
• Tested PL/SQL statements to verify the output and compared against ETL Output.
• Designed and developed Test Plans and Test Cases and executed them.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
• Involved in creating Test Matrix for various work streams for traceability purposes.
• Involved in writing Test cases for all the links and various data files based on ETL Mapping document.
• Performed Functional and Regression tests of enhancements using Mercury and Rational Tools.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Moving Data into Target using Sessions and Batches
• Designer for mappings and coding it using reusable mapplets using from various sources involving flat files and DB2 tables.
• Scheduling the session's tasks comprising of different mappings in order to load data into DB2 database Tables.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Tested and maintained the universe and reports
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
• Using Import Wizard deploying the reports from Dev system to QA box.
• Used Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard).
• Involved in Regression and Automated testing of the application using Mercury QTP
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Major involvement in tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in server manager.
• Wrote the CIMOM (Common Information Model Object Manager) module using NNM 64 and NNM SDK 6.2.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.

Environment: Informatica Power Center, Informatica Power Connect, MS Visio 2002, Oracle, MS SQL Server7/2000, IBM DB2/400, IBM AS/400, Teradata V2R5, MS Excel 97, Flat files, PL/SQL, SQL, Toad 7.0, Windows 2000, MQ Series, Transact-SQL, SQL*Loader Mercury QTP, Windows 2000, HP-UX 11.x Unix (ksh) Shell and Cognos (Impromptu, Power Play) 7.1.