PROFESSIONAL SUMMARY

Over 7 1/2 years of cumulative Software Quality Assurance and testing experience in the area of Manual Testing, Automated Testing, Web and Client/Server based applications with experience in ETL Testing and Data warehouse. Experienced in performing different types of testing: Module, Integration, Regression, and Data Driven, Performance, Screen Navigation, Installation Testing, and E2E Testing. Proficient in SQL and PL/SQL Programming for testing database integrity, Data Validation. Involved in Test, debug, review & modify testing programs to ensure technical accuracy & reliability of programs. Familiar with developing & executing software test plans and maintaining documentation of test results to assist in debugging and modification of software.

• Good Exposure in Using of QTP Integrated Environment (Step Generator, Synchronization, Actions, Recovery Scenarios and Methods etc.).
• Experience in writing test plans, test cases and maintaining test scripts, use cases.
• Well versed with Various Testing Stages/Levels/Phases, Testing Types, Testing Techniques and Quality Work Products.
• Expertise in GUI Testing, Functional Testing, Integration testing, Automation of GUI testing. Excellent knowledge of the quality assurance process, methodologies and Software development life cycle. Expertise in Manual and Automated Testing. Good Expertise in VB Script and Automation Infrastructure Development.
• Involved in ETL testing using Informatica power center 8.1.1/7.1.1, SSIS.
• Strong working experience in the Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL) Informatica and SSIS.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS)
• Extensive hands-on expertise using Informatica 8.x/7.x/6.x/5.x and Erwin Data Modeler with strong business understanding of Banking, Insurance, Finance and and Telecom sectors.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in using Informatica Server Manager to create and schedule workflows and expertise in Autosys scheduling.
• Good experience in using testing products such as Quality Center, QTP and Test Director.
• Strong experience in XML, XSLT, XPath and XML Spy.
• Experience in Waterfall and Agile Methodology process.
• Good Exposure on Bug Life Cycle.
• Working knowledge on Java, .Net, Oracle and SQL Server Technologies based Projects.
• Good experience in writing queries in Oracle, DB2, SQL Server, Sybase.
• Knowledge in BPT ( Business Process Testing)
• Knowledge in UNIX Commands.
• Excellent analytical skills, communication skills and work ethics.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Strong inclination for finishing job before project deadline.
• Ability to learn new technologies quickly and effectively.

SOFTWARE EXPOSURE

Operating Systems:

MS-DOS, Windows 98, 2000, XP, Unix

Testing Tools:

Quality Center, QTP, Win Runner, Load Runner, Test Director, Rational Test Manager, Rational Clear Quest

Software:

VB, HTML, ASP, VBScript, JAVA, JSP, Servlets, EJB, J2EE, WebServices, XML, UNIX Shell Scripting

Databases:

Oracle 9i, Sybase, IBM DB2, MS SQL Server 2000/2005

Data warehousing tools:

INFORMATICA POWER CENTER 8.1, SSIS

Other Tools:

TOAD, RAPIDSQL, SQL Navigator, Aqua Studio.

PROFESSIONAL EXPERIENCE

Confidential, Oct 2012 to Present
Quality Analyst

Project Description:

Confidential, is a web based CRM application used by the call center agents to record the interaction of customer for both inbound and outbound calls. The CRM also supported by the analytics and on demand reporting options for customer to see the call volume and dice the call records based on demographics, age etc.

Responsibilities:

• Prepared Test cases based on the requirement provided, tested the application in standard SDLC.
• Extensively used SQL 08 (Inner joins, Outer Joins, sub queries) for Data validations after loading into the Tables.
• Implemented Traceability Matrix and User Requirement Specification Document and verified the functionality coverage.
• Perform the web service testing using the development tool and verified the correct data sending and receiving through SOAP envelop messages in the XML format.
• Tested Standard and ad-hoc reports, compared the results against the database by writing SQL Queries.
• Participated in Team meetings for weekly QA Testing Reviews.
• Participated in weekly Status meetings, Coordinated with the developers to resolve the defects and close them based on the UAT and Production release schedule.
• Tested BI reports based on Querying CRM date tables before the reports were sent out to Client services for review.
• Tested some of the Key Aspects of Government Compliances like Age Verification ETC for Tobacco Clients.
• Involved in Regression testing and Stress testing during the new marketing campaigns lunch where in the call center get the highest call volume.
• Actively participated in all phases of testing life cycle including document reviews and project status meetings.

Environment:Quality Center, IE, Citrix, QTP 9.0, MS-Office, Excel ,Microsoft Silverlight, SQL Server, SSIS and Windows XP, Verint call recording , MS share Point.

Confidential, Jun 2010 - Oct 2011
ETL/Web service tester

Project Description:

The purpose of the Debt Management Collection System (DMCS) is to support the U.S. Department of Education (the Department) in its implementation and oversight of defaulted student loans. It supports Federal Student Aid (FSA), Borrowers, and Schoolsin its tracking of student aid debt collections.

Responsibilities:

• Worked as a Team of 10 persons for system testing of the DMCS 2 Application.
• Participated daily Scrum meetings and weekly project planning and status sessions.
• Tested the applications under the Scrum (Agile) Methodology.
• Tested the Web services and verified the correct data is sending to the other systems through XML by using internal tool and SOAPUI.
• Imported WSDL using SOAPUI and created the test suit and ran the test case by entering the request parameters in SOAP request envelop and verified the SOAP response envelop.
• Perform the load testing on the web services using the SOAPUI.
• Used Mercury Quality center for test plan, test case and test set creation, defect logging and fallowing till the defect closed.
• Performed GUI, Functional, and Regression, System Testing, Validation, Integration, End To End, UAT Testing.
• Created SQL queries for validation of data present on the tables after load, based on the business requirements.
• Extensively used SQL (Inner joins, Outer Joins, sub queries) for Data validations after loading into the Tables.
• Performed file level validation, detail level validation and also tested the data flown from source to target.
• Involved in testing of Informatica mappings using Informatica Designer.
• Extensively used Informatica Designer, Workflow manager to check the mapping and session, work flow validations.
• Used Humming bird for connecting to UNIX servers and running backend scripts.
• Executed UNIX scripts for validation of data present on the files, based on the business requirements.
• Used Pervasive ETL tool to load and Extract the data.
• Testing front end and back end impacts like screen, print and database.
• Tested Standard and ad-hoc reports, compared the results against the database by writing SQL Queries.
• Involved in reviewing the Test Plan, Test Scenario and Test Cases
• Communicated with business Analysts to understand business requirements.
• Used waterfall and Agile Methodology process.
• Participated in Team meetings for weekly QA Testing Reviews.
• Preparation of weekly and monthly status reports.

Environment: Oracle 9i,10g Quality Center 9.0,Clear Quest, QTP 9.5 UNIX, Informatica PowerCenter 8.1,Pervasive, SQL server, SSRS reports, MS - Excel, MS - Word, Windows XP, XML, IE 6, 7.

Confidential, VA May 2008 - May 2010
ETL / Web service tester

Project Title: Order Tracking System

Description: OTS (Order Tracking System) is an integrated information system that tracks customer orders from initial entry through Order completion (Order entry, Provisioning, Billing, and shipping). OTS also acts like an Order Entry System for some products, Java used as a Front-end and Oracle as the backend.

Responsibilities:

• Setting up of QC, Domain and Project configuration.
• Preparation of the Test Strategy and guiding the team.
• Involvement in the System Test Plan Preparation and Requirements Streamlining.
• Involvement in Preparation of Test Procedures, Test Scenarios, Cases and Test Data.
• Perform the web service testing using the development tool and verified the correct data sending and receiving through SOAP envelop messages in the XML format.
• Debug the Informatica mappings and validate the data in the target tables once it was loaded with mappings.
• Replicate operational tables into staging tables, Transform and load data into enterprise data warehouse tables using Informatica from their legacy systems and load the data into targets by ETL process through scheduling the workflows.
• Responsible for GUI and Functional Testing, using Black box Testing Techniques.
• Involved in Regression Testing using Quick Test.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Verified mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Perform the web service testing using the development tool and verified the correct data sending and receiving through SOAP envelop messages in the XML format.
• Extensively used internal tool for XML validation.
• Involved in Backend testing to verify data integrity using SQL.
• Functional, Regression test scripts executed using QTP scripts.
• Involved in execution on UNIX batch jobs
• Involved in writing test scripts, unit testing, system testing and documentation.
• Responsible for Database testing using SQL.
• Involved in Functional Testing, G.U.I Testing and Compatibility Testing.
• Responsible for writing test cases, test plans planning and organized the testing process, and build test cycle, test execution, and track defects.
• Participated in weekly Status meetings, Coordinated with the developers to resolve the defects and close them.

Environment:Quality Center, IE, QTP, Citrix, QTP 9.0,Informatica 7, Netscape, MS-Office, Excel ,TCP/IP, SQL Server, SSIS and Windows XP

Confidential, Dallas May 2007 - Apr 2008
Quality Analyst

Description: GARM to restrict off shore users access to Government and US Embassy data/ accounts, also providing an option to roll back the implementation in near future if needed. The challenge in this implementation was the users working on these applications shouldn\'t know about GARM.

Responsibilities:

• Worked on complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing.
• Developed backup restore scripts for SQL Server2000as needed.
• Upgraded to latest version from SQL server 7.0 to 2000.
• Wrote various stored procedures for the purpose of application development.
• Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Job scheduling and alerts.
• Designed and implemented user log in and security.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Designed different kinds of Transactions for the application.
• Written stored procedures and cursors to implement various business logics as per the client requirements.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Created Views to facilitate easy user interface implementation, and triggers to enforce data and referential integrity.
• Checked the data and data validity among source table and targets table.
• Created Test plans, Test cases and Test Scenarios.
• Responsible for using proper naming conventions for the test assets stored in Test director.
• Worked on Test Scripts and Test Cases.
• Worked on Rational Clear Quest for prioritizing the defects and keeping track of them

Environment: SQL server, embarcadero Rapid SQL, Sybase, Rational Test Manager, Rational Clear Quest, MS - Excel, Windows XP

Confidential, Denver Jan 2005 - Apr 2007
Quality Analyst

Responsibilities:

• Involved in testing of Informatica mappings using Informatica Designer.
• Extensively used Informatica Designer, Workflow manager to check the mapping and session, work flow validations.
• Emphasis on identifying the source and source data validation.
• Used UNIX Shell scripts for automating the execution of maps.
• Involved in execution on UNIX batch jobs
• Actively involved in Reviewing the Test Plan, Test Scenario and Test Cases.
• Fine Tuning of SQL Statements to improve the database performance.
• Tested the data and data integrity among various sources and targets.
• Worked on Test Scripts and Test Cases.
• Done the System Testing and the Regression Testing
• Participated in weekly status meeting, Coordinated with the developers and testers to resolve the defects and close them.
• Actively participated in all phases of testing life cycle including document reviews and project status meetings.
• Checked the data and data validity among source table and targets table.
• Created Test plans, Test cases and Test Scenarios.
• Responsible for using proper naming conventions for the test assets stored in Test director.
• Worked on Test Scripts and Test Cases.
• Worked on Rational Clear Quest for prioritizing the defects and keeping track of them

Environment: Informatica Power Center 7.1.1, Oracle 9i, PL/SQL, Toad, Autosys, Metify, Work Flow Manager, Work Flow Monitor, Test director 7.6 Sun Solaris, MS - Excel ,MS - Word, Unix scripting, Windows NT

Confidential, India May 2005 - Nov 2005
Quality Analyst

Responsibilities:

• Involved in writing test cases from requirements to check the functionality of the application.
• Created many manual test cases to check overall functionality.
• Responsible for tracking errors, their resolution as well as making sure to meet the dead lines to correct them.
• Performed functional and regression testing manually
• Actively involved in User Acceptance testing and End-to-End testing
• Involved in Smoke test and User Acceptance testing.

Environment: SQL Server v7, SQL Server 2000, T-SQL, Win NT v4, Win 2000, Win 2003, Rational Test Manager, Rational Clear Quest

Reference: References are available upon requests.