OBJECTIVE:

Seeking a challenging opportunity as a Quality Testing Lead Engineer with emphasis on Quality Assurance /SQA Testing.

PROFESSIONAL SUMMARY:

• Over 7+ years of strong experience in Manual, Automated and data warehouse testing of web, client/server and Mainframes applications includes:
• Expertise in software Development Life Cycle (SDLC) with specific focus on Testing Methodologies and Testing Techniques.
• Expertise in User Requirement Analysis, Functional Specifications, Change Controls, Defect management and Identify Test Requirements.
• Extensive experience with Insurance/ Banking & Financial/ Healthcare/ Telecom applications.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Demonstrated excellence in creating & developing test Plan, test cases and test scripts.
• Extensively worked in Plan, develop, and execution of all stages of system testing.
• Approached testing and quality assurance from a business point of view by creating test scripts and scenarios to ensure delivered functionality meets the business need.
• Experience in Whitebox & Blackbox Testing.
• Expertise in data warehouse concepts and ETL (Data base) testing.
• Developed test conditions/ test cases and expected for Integration, Usability, functionality, User Interface (UI), regression and Performance testing.
• Executed test scripts to validate test cases, which includes creating and executing complex automated test scripts in QTP.
• Strong working knowledge of Web Service testing, testing methodologies, QA analytical techniques.
• Created test documents like QA Status Report, QA Summary Reports, QA Test Logs, Test sign - off, Maintain issue and defect databases.
• Sound knowledge of SQL, PL/SQL queries to run data integrity tests.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
• Expertise in Verification and Validation testing.
• Extensive experience in Mercury Interactive Management tool (Quality Center/ Test Director for capturing requirements, test execution and defect management).
• Experienced in leading QA team with work schedules and time lines.
• Involved in Sanity, Functionality, System and user acceptance testing.
• Experienced in Data warehouse ETL & Reporting tools (Informatica & Business Objects, Hyperion).
• Experienced in Usability, User acceptance Testing (UAT).
• Extensive experience with Data Extraction, Transformation and Loading (ETL) from different Data sources like Oracle, SQL Server, Teradata and Worked on integrating data from flat files and XML files into a common reporting and analytical Data Model using Informatica.
• Experience in tuning Informatica Mappings and Sessions for optimum performance.
• Proficient in testing client/server, n-tier and Web applications.
• Experience in testing tools such as Rational Robot, TestManager, ClearQuest and RequisitePro.
• Used SQL for Querying the DB2 database in UNIX environment
• Involved in Unit and Integration Testing with White box testing Techniques.
• Involved in XML testing & In bound, out bound testing.
• Extensively involved in back end testing using SQL queries, SQL Server and generating reports to ensure data integrity and validate business rules.
• Involved in automated testing using Mercury Interactive tools like QuickTestPro (QTP), WinRunner and LoadRunner.
• Good Team player, quick learner, proactive, collaborative and self-starter, excellent oral and written skills.
• Experience in Offshore Coordination.

TECHNICAL SKILLS:

Testing Tools: Quality Center, TestDirector, QuickTestPro (QTP), WinRunner, Rational Robot, TestManager, ClearQuest, RequisitePro, Geneva 5.3.43, Silk Test, Silk Performer, Infinsis 2.2.26, Bugzilla, PVCS Tracker, OWB Automation tool, Team Track, API, JUnit, NUnit, Selenium, Jira and LoadRunner.

Operating Systems: Windows 95/98/NT/2000/XP/Vista, UNIX, Solaris & LINUX

SCRIPTING TOOLS: VBScript, Java Script, UNIX Shell Script

ETL Tools: AbInitio, Informatica, Data Stage

Reporting Tools: Business Objects, Cognos, Hyperion.

RDBMS: Oracle 9i, 10g, Sybase, Ms-Access, DB2, SQL server 2005 &Toad

Languages: C, C++, VB, Java, Cobal, .Net, C#, JCL, CICS, MVS, HTML &XML

Browsers: IE4.0, 5.x, 6.x and Nets cape 4.07, 4.72, 4.73, 6.0

Version Managers: Visual SourceSafe and CVS.

Protocols: TCP/IP, FTP, SMTP, SOAP, TELNET

Mainframe: COBOL, DB2, UDB, JCL, VSAM, CICS, IMS, QMF, TSO, ISPF, MVS

Utilities: MS Office (MS Word, MS Excel, MS PowerPoint, Outlook, VisioMS Visual Studio), Edit Plus, perl, SharePoint, Lotus notes, BI Query, Putty, IBM Mainframes Passport application and TOAD.

BUG TRACKING TOOLS: Test Director 8.0, Quality Center 8.

PROFESSONAL EXPERIENCE:

Confidential, NY

Sr. QA Tester

Responsibilities:

• Involved in writing Master test plan for the QA process.
• Worked closely with the development and Business teams to gather business requirements and test data.
• Performed Back end testing using ETL tool (Informatica) and involved in comparison of data which in different applications.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in creating the design and technical specifications for the ETL process of the project.
• Effectively implemented different QA methodologies/policies, strategies in all stages of SDLC.
• Written several complex SQL queries for validating Cognos Reports.
• BI Query is a query and reporting tool that provides a comprehensive solution for accessing, analyzing and presenting the data stored in Enterprise database.
• Executed Performance testing by testing the latest code with earlier release code.
• Involved in Sanity, System, User Interface, Functional and Regression testing.
• Execution of Test cases after freezing the test cases and reporting test results.
• Involved in team scheduling and work allotments.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Developed SQL Stored Procedures and Queries for Back end testing.
• Converted SQL queries results into PERL variable and parsed the same for multiple reasons.
• Developer Regular Expressions using PERL for parsing needs.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Worked parallel in different teams like system testing, regression testing and automation testing teams.
• Involved in automation testing to perform functional, Integration and regression testing.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

Environment: Java, J2EE, XML, QTP, Quality Center, Data Warehouse tool (Informatica, Hyperion), J2EE 1.4, TIBCO, Cognos, C, Perl Scripts, XML, XSD, XML Spy 2008, SQL, PL/SQL, Oracle 9i/10g, Erwin 4.3IBM AIX 5.1, UNIX, Korn Shell Scripting, Windows, Influx and Test Director 8

Confidential, Atlanta, GA

Sr. QA Lead

Responsibilities:

• Performed Back end testing using ETL tool (Informatica) and involved in comparison of data which in different applications.
• Involved in writing Master test plan for the QA process.
• Worked closely with the development and Business teams to gather business requirements and test data.
• Effectively implemented different QA methodologies/policies, strategies in all stages of SDLC.
• Worked parallel in different teams like system testing, regression testing and automation testing teams.
• Extensively involved in Cancel table testing and Special Line pick list Testing.
• Extensively involved in Treatments testing.
• Involved in test data creating by using IBM Mainframe Passport application.
• Generated reports based on the required policy setting by using Hummingbird BI Query Reports.
• Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in DB2 environment.
• Involved in automation testing to perform functional, Integration and regression testing.
• Involved in Regression and retesting by using OWB automation tool.
• Involved in XML testing.
• Involved in scripts updating, quoting new policies in test database.
• Involved in Test bed maintenance. Replacing the purged policies with latest active rate revision policies.
• Extensively involved in System testing and Offering Regression testing for each state specific rate revisions.
• Worked closely with PolicyPro teams.
• Extensively involved in Large scale Regression testing for each release in all QA as well as pre-production environment phases.
• Executed Performance testing by testing the latest code with earlier release code.
• Involved in Sanity, System, User Interface, Functional and Regression testing.
• Execution of Test cases after freezing the test cases and reporting test results.
• Involved in team scheduling and work allotments.

Environment: Java, J2EE, XML, QTP, Quality Center, Data Warehouse tool (Informatica, Cognos, Hyperion), OWB Automation tool, CICS, TSO, Team Track, Oracle 9i, 10g, IBM Mainframe Passport application, SQL, JUnit, AS/400, UNIX, ANSI, FTP, Hummingbird BI Query Reports, XP, TOAD, TCP/IP, DB2 & IBM Lotus notes database.

Confidential, Pittsburgh, PA

QA /SQLTester

Responsibilities:

• Tested several database tables for data conditions and referential integrity.
• Created Test Plan and developed an test strategy for Day 2
• Experience in UNIX Shell Scripting and Perl scripting
• Developed SQL Stored Procedures and Queries for Back end testing.
• Experienced in data analysis using, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested data warehouse ETL process using SSIS (Integration Service)
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested stored procedures & views in MS SQL 2000/2005
• Compared and Tested Source data with XML Output flow.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
• Performed the tests in both the SIT, QA and contingency/backup environments
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Writing the test scripts for manual testing.
• Used PERL for automating all the types of modules Confidential a time.
• Converted SQL queries results into PERL variable
• Used Query Studio to test ad hoc reports
• Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies
• Experienced in Data integration, metadata management .etl data modeling tool sets .
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Published and Tested Impromptu reports to UpFront by using IWR Server.
• Published and Tested Powerplay Cubes to UpFront by using Powerplay Enterprise Server
• Prepared extensive set of validation test cases to verify the data
• Tested different detail, summary reports and on demand reports.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Involved in extensive DATA validation using SQL queries and back-end testing
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing
• Involved in Front to Back testing for all European and Asia pacific regions
• Preparing and supporting the QA and UAT test environments.

Environment: SQL Server 2000/2005, ETL Informatica 7.1,SSIS, Oracle 9i/10g, XML, Perl Scripts and Korn Scripts, Flat Files,,Cognos 7.3 Series, T-SQL, MS Excel, UNIX, Korn Shell Scripting, Erwin 4.3,Windows

Confidential, CA

QA Lead

Responsibilities:

• Actively involved in gathering requirements from the end users.
• Involved in Data Extraction, Transformation and Loading from source systems
• ETL Informatica developed Transformer Stage to transform data, define derivation for output columns, specified constraints for output links.
• Used Informatica ETL to extract and load data from Oracle/Teradata, and flat files to database.
• Worked on Informatica client Components like Administrator, Designer.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Performance Tuning of Sessions and Mappings.
• Imported various Application Sources, created Targets and Transformations using Informatica tool.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables. Converted the regression testing scripts from WinRunner to QTP VB scripting.
• Created Unix Scripts As per the need. Scheduling the jobs using Informatica.
• Creating, documenting, tracking and managing data validation/verification testing and plans.
• Preparation of Test Strategy Specifications & Traceability Matrix as per functional specifications.
• Reporting and tracking the detected defects by using Quality Center.
• Extracted and distributed reports from Quality Center before daily fault call.
• Involved data migration testing by upgrading the s/w and H/w.
• Performed Back end testing using ETL tool (Informatica) and involved in comparison of data which in different applications.
• Involved in back end testing using SQL, PL/SQL queries via TOAD and generating reports to ensure data integrity and validate business rules.
• Involved in test planning, test case design, test script generation and design documents walkthroughs.
• Build test data/ Test Scripts for requirements before starting the actual testing.
• Involved in Sanity, System, User Interface, Functional and Regression testing.

Environment: WindowsXP, JAVA, J2EE, Vista, WinRunner, Data Warehouse tool (Informatica), FTP, QTP, websphere, TSO, XML, CICS, IMB Mainframes, HTML, SQL Server 2005, MS Office, XML, SQL queries, Selenium, PL/SQL, ClearQuest, UNIX, TCP/IP, Perl, JSP, JDBC, VB, VSS, TOAD & QualityCenter.

Confidential, New York, NY

ETL / Quality Analyst

Responsibilities:

• Performed manual testing of the application.
• Designed and Executed Test Plans, Test Cases and Test Procedures.
• Used PERL for automating all the types of modules Confidential a time.
• Converted SQL queries results into PERL variable
• Used PERL for automating all the types of modules Confidential a time
• Executed ans scheduled; batch processing, metadatamanagememnt and data mapping .
• Involved in extensive DATA validation using SQL queries and back-end testing
• Analyzed Software Requirements documents and Business Requirements documents to get a better understanding of the system on both Technical and Business perspectives.
• Involved in writing the Test cases and Test plans based on Source to Target Mapping documents and Data Model diagrams.
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Wrote and ran Found the defects when running the test cases and assign to ETL Developers using Defect Tracking tool.
• Unix Scripts for batch jobs.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Performed report generation for Tournaments module.
• Actively involved in preparing test plans and test cases.
• Wrote SQL queries to perform database Validations
• Performed Unit Testing, Integration and Regression testing of the application.
• Reported bugs in Test Director.
• Generated weekly reports
• Extensively tested the Transformation Language Functions in the mappings and tested the same.
• Ran UNIX shell scripts to count the records for EDW source to staging tables.
• Performed Integration testing, System testing, and user acceptance testing.
• Designed and documented all the issues and defects to ensure application software functionality for present and future builds.
• Responsible for design, development and testing of Tournaments module.

Environment: Oracle 9i/10g, ETL Informatica 7.1, SQL, PL/SQL, XML, MainFrame COBOL Files, Test Plan, Test Script, Test Scripts, TOAD, JCL, VSAM, Copy Books and UNIX, Influx, Windows and Test Director 8.

Confidential, Chicago, IL

Senior QA Engineer

Responsibilities:

• Gather the System Requirements and understand the User workflow to develop the testing procedures /scripts and set the timelines for the various project milestones.
• Design and develop the test plans and test cases by working closely with the Confidential user groups of the various applicationsRecorded & Modified testing scripts and created Test Scenarios using Load Runner and also developed basic Win Runner TSL scripts to perform data driven functional testing of these applications
• Estimates real world usage and performance by developing Load Runner VuGen scripts to simulate hundreds of virtual users on the system
• Performed testing of Order Management, Order Entry, Inventory Management and HRMS Modules of the various Oracle Applications.
• Developed testing scripts for various user scenarios such as Opening of an order to Close to check the order work flow, Creation of a User, User Navigation within the application and various other User actions within the application
• Developed customized performance reports and reported the various performance bottle necks in the application back to the development team.

Environment: Oracle Manufacturing (11i, 10.7) Order Management, Inventory, Receivables, HRMS, DataStream 7i, MAPS (Manufacturing, Accounts and Purchasing System), Oracle, Reports 2.5, Forms 4.5, PL/SQL, SQL*Plus, Windows NT/2000, Unix, Test Director, WinRunner and Load Runner.