SUMMARY:

• Over 8+ years of experience in Manual Testing and Automated Testing for web based, ecommerce client/server applications and Web service applications on several platforms, using SOAPUI and automation tools (Quick Test Professional, Loadrunner and Quality Center).
• Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Extensive experience in coding using VB script and Descriptive programming through QTP.
• Hands on experience on Functional, Regression, Performance and Black Box Testing of both Web-Based and Client/Server Applications on various testing platforms and using various testing tools.
• Experience in development of iterative and detailed project management plans and schedules using Agile-SCRUM methodology.
• Experience in Data Warehouse applications testing using Informatica, SSIS, Shell Scripting, PL/SQL, Informatica, Data Stage and Ab Initio on multiple platforms.
• Experienced in back-end testing using SQL queries, generating reports to ensure data Integrity and validate business rules.
• Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground.
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
• Solid Back End Testing experience by writing and executing SQL Queries, Nested Queries, Joins for Oracle Database.
• Extensive noledge of the relational data modeling and relational database concepts like Tables, Primary and foreign keys, Views and Referential Integrity.
• Extensive experience to Document User Manuals, Test process plans, Software Architecture Plan, Development and Environment Process or Procedures and Customer Support Documents.
• Extensive Experience executing GUI, Functional, Integration, Regression, Database, System and usability tests on various product platforms.
• Proficient writing Test Scenarios and Test Cases from business requirements - Use Cases, functional specifications, Design specifications, Technical Requirements.
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts and Documenting all phases of QA process.
• Experience in testing API using SOAP.
• Experience in working wif Agile Software Development, Scrum, daily build and test
• Developed VBScript libraries for automating database connections, web functions, windows services and common utilities such as file handling, xml verification.
• Experience developing Automation scripts to perform data validation on the backend.
• Experienced in Implementation and working wif Keyword Driven, Data-Driven and Hybrid Automation frameworks using QTP.
• Ability to work in tight schedules and on different applications concurrently.

TECHNICAL SKILLS:

Data WarehousingInformatica: 9.1/8.6/8.1/7.1/6.1, SSIS, Ab Initio CO>Op 2.15, GDE 1.15, Data Stage 8.x

Reporting Tools: Business Objects6.5, XIR3, Cognos 8 Suite

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.x, Sybase 12.5, Teradata V2R6, MS Access 7.0

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2ee

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE:

Confidential, MD

QA Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Developed data quality test plans and manually executed ETL and BI test cases.
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested to verify dat all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases. .
• Used Unix environment variables in various .ksh files which comprises of specified locations to build Ab Initio Graphs
• Validated various Ab Initio Graphs according to business requirement documents.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool
• 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.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Used Quality Center for bug reporting.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application
• Tracked and reported the bugs wif Quality center.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Written several UNIX scripts for invoking data reconciliation.
• Worked wif all kinds of components wif Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Testing TEMPhas been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Experience in testing and writing SQL and PL/SQL statements.
• Configured Quick Test Pro wif Quality Centre and Maintained the project information in Quality Centre.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Load new or modified data into back-end Oracle database.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Involved wif ETL test data creation for all the ETL mapping rules.
• Tested stored procedures & views in MS SQL 2000/2005.
• Preparing and supporting the QA and UAT test environments.
• Create UAT Test Strategy, UAT Test Plans and UAT defect reporting.
• Assist external clients during the UAT. Conduct and create reports at the end of the UAT test
• Analyzed Business requirements and System specifications. Drafted test strategies, test cases and test plans for the installation, GUI, functional, Security, Recovery, performance and integration testing for multiple software releases.
• Wrote SQL Statements to extract Data from Tables and to verify the output Dataofthe reports
• Tested Performance of the application in all work flows using LoadRunner.
• Interacted wif the users to ensure meaningful development of the scripts and to simulate real time business scenarios.
• Actively involved in walkthroughs and meetings wif development team to discuss related issues.

Environment: Ab Initio CO>OP 2.15, GDE 1.15, PL/SQL, SQL, SQL Server Analytical Server, SQL Server Reporting Server, TOAD 9.2, Oracle 9.2, HP Quality Centre 9.2, DB Artisan 8.5.2, Autosys, Metal (Meta Data Driven ETL), BI Reports, Rational Clear Quest, Clear Case, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//2000

Confidential, Richmond, VA

Sr. QA Tester

Responsibilities:

• Develop life cycle Test documents and conduct Quality Reviews on project artifacts. Also, evaluate Project deliverables quality and compliance to the Quality Assurance Practices.
• Experience in ETL Data Warehousing, database testing using Ab Initio for Workflow process.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Ab initio.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and Teradata tables to target tables.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Understood the Teradata BTEQ scripts and converted the BTEQ and tested the complex BTEQ scripts.
• Efficiently used the Error Handling methods and implemented throughout the mappings.
• Created the test graphs to extract the data from the Teradata tables by using the Fast Export utility.
• Responsible for reviewing the Test Plan/system test results wif the BSA and Business customer.
• Responsible for creating the test plan and test cases to test the new functionality.
• Responsible for providing the status updates to the team on daily basis.
• Involved in testing the Business Objects performance & connectivity across different domains.
• Performed QA and regression testing on report data and data warehouse ETL code.
• Tested the layout, format, font, style etc of the reports based on the requirements.
• Used multiple Data Providers, Slice and Dice panel to achieve a master Detail report.
• Tested the universes and reports in Business Objects.
• Tested the Profiling Report about the incorrect records and matching records.
• Used universe to create multi query, multi-page reports using multiple databases.
• Tested adhoc reports.
• Gathered the Users Information and Security levels in Business Objects 6.5 to implement the new Security in BO XI R2.
• Performed security testing on user credentials.
• Tested upgrade of universe reports system from Business Objects Xi R2 to BO Xi R3.
• Tested Drill-down & drill up reports.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Performed the data lean age/repository tracking using the Web-EME.
• Prepared extensive set of validation test cases to verify the data.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Processed a query to update a field in an Oracle database, to ensure dat debt payments are allocated.
• Involved in extensive DATA validation using SQL queries and back-end testing.

Environment: QTP 9.5, VB Scripting, LoadRunner 9.51, Toad for Oracle version 8.6.1, Putty, SOAP UI, .NET, DB2, SQL Server, XML, HTML JAVA, MS-Office, IE8, MS-Project, API Testing, Quality Center.

Confidential, Warren, NJ

Sr. QA Tester

Responsibilities:

• Design test scenarios for different financial user groups based on system requirements, solution diagrams, help files, screen mock ups and Gap Analysis.
• Allocation of high level sizing of resources and providing estimates of hours required from a Quality Assurance perspective. This includes analyzing all QA phases - Functional QA, Regression, Load and Performance, host testing and Test Support during UAT.
• Generated GUI Vusers using QTP scripts to measure thick client latency and end-to-end user response times under load.
• Wrote and executed VuGen scripts (in C language, XML, and SQL) for applications using Web, and Web Services protocol.
• Inserted transactions in VuGen scripts to measure the performance of the server.
• Prepared test data using VuGen for Controller Scenarios.
• Generated certain transactions of VuGen script using WireShark.
• Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA process and documentation of Test Plans, Test Cases, Test Procedures, Reporting and Tracking the defects.
• Conduct all types of application testing as needed, such as Manual, GUI testing, Integration, System, Smoke, Regression, Load, and Acceptance testing.
• Inserted Checkpoints and Synchronization points for Functional Testing, Scripted reusable scripts by using QuickTest Pro call to actions and inserting copy of actions options.
• Developed Web Service scripts for a web service call by importing the XML file from SOAP UI body structure and WSDL.
• Performed back-end testing on different databases like Oracle and SQL Server to verify the data transfer from the application to the databases as well as data transfer between databases.
• Running QTP scripts from Quality Center for Regression testing and reporting results to Manager.
• Develop Functional/Regression automated testing solutions using QTP, traditional QTP framework, and/or Data Driven techniques.
• Automated 90% of manual test cases and executed for Regression and Smoke tests to test build verification.
• Programming wif VBScript to write Reusable functions, and setting up the startup files for the Loading the libraries and configuration in QTP.
• Responsible for verifying the log files using UNIX and database for the submitted application.
• Coordinated and Interacted wif Development team and actively participated in status meetings during the defect life cycle, reported the bugs and maintained their status.

Environment: QTP 9.2, Quality Center, LoadRunner 8.1, VB, VBScript, .NET, ASP.Net, C, XML, SOA, SoapUI, TFS, SQL Server, Win Server 2003, TOAD, and Windows XP.

Confidential, IL

Sr. QA Tester

Responsibilities:

• Reviewed business & functional requirements, prepare test planning, test case/scripts and supervise eCommerce client-server applications.
• Performed Web service testing by creating test cases and test scenarios using SOAPUI tool.
• Edited and modified XML files wif the help of XMLnotepad.
• Inserted Assertions such as Schema Compliance assertion to check the compliance wif the associated WSDL/Schema definitions such as in a definitive business application for Easyjet flight application, tested for assertions like seat number query and cash bag number retrieval.
• Responsible for validating the XML file based on the XSD.
• Reviewed of XSD Schema to check versions and contents.
• Performed automation testing for the Back Office using Quick Test Pro and coordinate wif the dev team for immediate hot fixes.
• Prepared Release Notes after every release of the BackOffice or EPOS (Electronic Point of Sale) using JIRA defect tracking system.
• Extensively used SOAP UI to develop test harness for Web Services.
• Communicated wif the end users for UAT (User acceptance testing).
• Heavy usage of Subversion to acquire and store documents related to the project.
• Involved in conference calls wif clientele and attend the status meetings, project meetings and product release meetings.
• Involved in Web API testing by uploading WSDL files in SOAP UI tool.
• Actively participated in daily Scrums and project planning meetings
• Created Vuser scripts using VU-GEN for multiple protocols like (Webservices, HTTP, and FTP).
• Monitored online graphs like Transactions per second (TPS), Throughput and Response time and analyze them after completion of test for both Back office and EPOS (Electronic Point of Sale).
• Performed Regression Testing and Involve in Debugging the scripts.
• Identified outstanding high defects dat has not been addressed by the project team.
• Performed API/Web Services testing; may also be required to write test harnesses using web services and SOAP technologies
• Continually innovate and create new ideas & procedures for the Quality Control team.
• Ability to work independently and adapt to an ever-changing environment.
• Used JIRA defect tracking system and seeking on-site solution for the defects.
• Prepared a user training guide and provides training to the new users as needed.
• Captured daily work progress and generate weekly status report.

Environment: QTP 8.2, VB Scripting, LoadRunner 8.0, QualityCenter, SOAP UI, JIRA, .NET, DB2, SQL Server, XML, HTML JAVA, MS-Office, IE8, MS-Project, API Testing

Confidential, Charlotte, NC

Sr.QA Tester

Responsibilities:

• Analyzed and reviewed software requirement and functional specification documents.
• Used SOAPUI for functionality and performance testing of Web services.
• Reviewed and analyzed Schemas of XML and WSDL for Web services.
• Analyzed System Requirements and developed Test Plan, Test Procedures and Test Cases.
• Created the strategy document dat defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
• Involved development of test plans, test schedules, test cases based on high-level and detailed designs
• Executed test cases and participated actively in system testing and regression testing
• Developed, implemented and executed test methodologies and plans to ensure software product quality
• Involved in Back End testing by extracting flat files from server, to verify Data against Expected results
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Enhancing the QuickTest Pro Scripts wif GUI checkpoints, Database Checkpoints, Parameterization, User Defined Functions (adding functional features) and Synchronizations.
• Performed Manual Functional Testing and Automated Testing using QTP, of the application against new builds.
• Object Repository is generated to read objects for AUT, which are compared while executing VBScripts in Quick Test Pro.
• Conducted URL Link Testing and Regression Testing during the various testing phases of the application using Quick Test Pro.
• Developed test execution plan, which defined and facilitated the Performance profiling
• Identified and prepared test cases for performance business critical transactions

Environment: SOAP, QTP, Quality Center, ASP.net, Vb.net, C#, XML, XSL, Web services, Windows2000, Sql Server SQL, HTML, JavaScript, VBScript, MS Office 2002, Visual Basic.

Confidential, Green woods, CO

QA Tester

Responsibilities:

• Involved in Manual and Automated Testing of the all modules.
• Conducted Black Box Testing (Functional Testing and Regression Testing) using WinRunner
• Using Win runner to capture, verify and replay user interactions automatically to identify defects.
• Involved in Setting up the Data for Integration and End-to-End Testing.
• Involved in Verifying the CICS Screens for the Get Available Dates and Capturing the Capacity from the Database Before Creating the Service Order and After Creating the Service Order
• Maintained the WinRunner scripts in Test Director 7.6.
• Wrote Custom functions and Error handling functions in Test Script Language (TSL).
• Utilized LoadRunner for performance, volume and load Testing of the website
• Used LoadRunner monitors to identify the bottlenecks and isolate the problems.
• Wrote and executed scripts for load testing using the Virtual User Generator, created and ran Controller scenarios to test the functionality under varying load.
• Involved in Preparing the Test Strategy Document, Test Cases and Test Cases Execution for all modules
• Involved in moving all the Test Cases for all modules and Reporting from Microsoft Excel in to Test Director

Environment: Win runner 7.6, Test Director 7.6, Load Runner 7.8, Windows 2000/XP, Web Logic, Java and Oracle.