SUMMARY

• To seek a challenging career as a QA/SQL Tester and implement SQA Principles in Software Development in areas of Data warehousing, Data Mining, Data Loading, Client Server technology, Object Oriented Development, Web applications, eCommerce and B2B solutions.
• 7 years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Pharmaceutical, Biotech, Manufacturing Industry, Insurance and Taxation.
• Involved in Manual and Automated Testing of applications on UNIX and Windows Environment for both Server side and Data warehousing Applications.
• Expertise in various testing methodologies like Black box testing, White box testing.
• Experienced in Automation testing using the WinRunner, Quick Test and Load Runner.
• Experience with QA Methodology to ensure the Quality Assurance Control.
• Excellent skills in TeraData, DB2, SQL Server and Oracle 9i/8i RDBMS..
• Strong in Analyzing Business spec Requirements & Develop comprehensive test Spec & execute them.
• Experience in creating training documents for GDP regulations.
• Experience in FDA regulations, 21 CFR Part 11, GxP guidelines.
• Well-experienced in developing all of the validation lifecycle documentation, including Validation Plan, IQ/OQ/PQ, SOPs, Traceability Matrix and Validation Summary Report.
• Experience in using Automation Tools: Cucumber, Win Runner and Quality Center in Client/Server.
• Experienced in all phases of Systems Development Life Cycle (SDLC), including requirements analysis/design, development and testing
• Performed backend testing using SQL Queries and UNIX SHELL SCRIPT
• Strong experience in XML and XML Spy.
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts according to the business specification given.
• Experience in using Automated Tools like WinRunner, Test Director, Load Runner and JTest in Client /Server, Web, Database, API and GUI Testing.
• Extensive experience in testing and writing SQL and PL/SQL scripts to validate the database systems and for backend database testing and to verify data integrity.
• Experience in Web and Object Oriented Technologies
• Ability to interact with developers and product analysts regarding testing status
• Expertise in Problem solving and Tracking Bug Reports using Bug tracking Tools.
• Exposure to different operating systems like Windows 95/98/00 and NT and UNIX.
• Responsible for mentoring resources technically and training other QA Team Members.

TECHNICAL SKILLS

RDBMS / Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2, Sybase

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI R2/6.x/5.x,SSRS 9.0

Languages: SQL, PL/SQL, Unix Shell Script, XML

Tools: Toad, SQL* Loader, SQL Assistant

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP 10, HP Quality Center 9.2, Test Director 5.0

Rational Tools: RUP, Rational Clear Case, Clear Quest, Test Manager, PVCS, Rational Requisite Pro, IBM Rational Manual Tester

Computer System Validation: 21 CFR Part 11 (210/211, 820), GAMP, cGMP, GDP, GLP, IQ, OQ, PQ

Bug Reporting: Rational Clear Quest, Test Director, MS Access, Bug zilla.

ETL tools: Informatica 8.5/ 8.1/7.1/6.2/5.1 (Power Center/ Power Mart)

PROFESSIONAL EXPERIENCE

Confidential, Noorwood, MA

QA/SQL/ Back-end Tester

Responsibilities:

• Created Test Cases, Test Case Inventory, traceability matrix based on mapping document and requirement.
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
• Did complex data validation using SQL queries.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Conducted 21 CFR Part 11 gap assessments for legacy systems and prepared remediation plans.
• Conducted Part 11 Scope Assessments on various in-house developed and COTS systems.
• Extracted data from various sources like Oracle, flat files and SQL Server2005.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server.
• Used Quality Center for bug tracking and reporting.
• Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process. Experienced in writing UNIX script.
• Experience in working independently and multi task without negative impact to timelines or quality.
• Strong Knowledge on the phases of Software Development Life Cycle (SDLC) Methodology.
• Involved in Computer Systems Validation according to FDA Guidelines, GLP, GMP and 21CFR Part 11.
• Developed PQ for Production System Verification.
• Involved in preparing and providing training for Labware LIMS application to users.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Load new or modified data into back-end Oracle database.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Transformed the XML documents into various form using XSLT.
• Experience in preparing the traceability matrix, test scenarios and test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Tested data migration to ensure that integrity of data was not compromised.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.

Environment: MS SQL 2008/2005 SSRS, SSAS, HP QTP,HP QC,HTML,Oracle 9i, UNIX Shell Scripting, TOAD 7.0,, SAS/SQL, UDB DB2,, Rational Clear Case,, Java, XML, XSD, SQL, PL/SQL

Confidential, Irving, TX

QA/SQL Back-end Tester

Responsibilities:

• Formulating detailed Test Plan, after analyzing business rationale and software requirement artifacts.
• Involved in writing test case matrix, summary grids, summary reports
• Created Requirement Traceability Matrix (RTM) on track requirements
• Formulating detailed Test Plan using Rational Test Manager, after analyzing business rationale and software requirement artifacts.
• Successfully leading a team and coordinating the testing activities to complete System, Integration and UAT Test preparation on schedule.
• Created UAT test cases and scenarios based on Use Cases, and made sure that UAT test case meets the business requirements.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Developed IQ/OQ for Citrix server for Empower application residing on it.
• Strictly followed technical writing procedures while formulating and executing SOPs, IQ/OQ/PQ plans and Test Scripts.
• Involved in writing Remediation documents in compliance with 21 CFR Part 11 guidelines for laboratory instruments.
• Documented Test Summary Report and Validation Summary Report.
• Interacted with the users to ensure meaningful development of the test scripts and simulated real time business scenarios. Responsible for administration of all the Rational Products.
• Used Rational Robot for GUI Testing and Automated Testing of the application.
• Inserted different verification points like Window Existence, Object Data Etc.
• Worked with Project Management to scope the testing effort and provide status and estimates
• Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer and UNIX shell commands
• Reviewed manual testing methods and developed and executed automated scripts using Rational Robot to perform regression testing.
• Used Rational Clear Quest for version, tracking defects, enhancement requests, assign work activities and assess the real status of project throughout the lifecycle.
• Performed GAP analysis.
• Wrote, reviewed and executed IQ, OQ, PQ test plans for analytical Lab instruments.
• Testing of mapping parameters and variables.
• Strictly followed technical writing procedures while formulating and executing IQ/OQ/PQ plans and Test Scripts.
• Performed Gap Analysis, Risk assessment and gave remediation plan to get the systems into compliance.
• Updated, maintained, and promoted Test Plans and Scripts to Configuration Management for version control.
• Extensively conducted Back-End Testing using which involved complex SQL Queries
• Responsible for testing newly created tables (ETL Process) as per BRS
• Attend regular meetings with developers about the unclear topics in the business requirements.
• Mentoring and building skills in more junior members of the QA team.
• Defects were tracked, reviewed, analyzed and compared using rational Clear Quest.
• Maintain the defect life cycle in Clear Quest.
• Generated reports and Traceability matrix for the client requirements.

Environment: Test Manager, ASP .NET, HTML, Windows 2000, Oracle, UNIX and SQL Quality Center 8.2/9.2,QTP 8.0/8.2/9.2,LoadRunner 8.2, VB Scripting Oracle, PL/SQL

Confidential, Chicago, IL

QA/SQL Tester

Responsibilities:

• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing
• Developed business process models in RUP to document existing and future business processes for the data warehousing.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed.
• Worked with SSIS system variable, passing variables between packages.
• Used T-SQL for Querying the SQL Server2000 database for data validation and data conditioning.
• Designing the template and structure for data extraction and processing using SSIS and its different tools from different sources of Production server, Excel sheets
• Performed Black box testing, White box testing, Grey box testing, GUI Testing, Unit testing, Integration testing and System testing
• Involved in implementation of the Test plans, Test cases and Test scripts
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Involved in the development of Informatica Mappings and also tuned them for better performance
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• An extensively used Complex SQL statement for retrieving data using TOAD and it is used in TSL scripts.
• Extensively worked on Mercury Test Center and ran various scenarios and scheduled them.
• Configured Quick Test Professional with Quality center.
• Collected user requirements from various stake-holders for the data warehouse.
• Very strong SQL skills and experience with OLAP. Expertise in data-driven testing, drill down applications, writing test cases and test scripts
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log..
• 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
• Prepared SQL scripts for test data preparation for Back End functionality testing
• Performed back up project management duties
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Developed automated scripts for functional testing and Data driven testing of the application using QTP
• Automated detailed test cases by using Quick Test Pro.
• Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
• Transformation of XML documents using XSLT.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: Informatica Powercenter 8.1, HP QTP,HP QC, Python and UNIX Shell Scripting, Linux, AIX, Mercury Quality Center 8.2 (Test Director), DB2, IBM DB2, Autosys, Oracle 10g, Rational Clear Case, Mercury ITG Governance, HTML, MS SQL 2008/2005 SSRS, SSAS, C++, Oracle Warehouse Builder, Discoverer, Data Profiler

Confidential

QA Analyst

Responsibilities:

• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Used Test Director to Report bugs and Data Quality Issues on each check sum and field validation Tests completed.
• Communicated and Discussed with Developers about the status of each Data Quality Issues
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Involved in the testing of the Designed and developed DataStage.
• Testing of all the PL/SQL procedure to improve the performance of ETL process.
• Backend testing of the and existing DataStage jobs for all the updated changes requested by users.
• Testing of various Autosys JIL Scripts to activate the UNIX scripts in production .
• Written UNIX AWK Scripts to manipulate test data and input files.
• Responsible to find out different DDL Issues and Report to DBA’s using Test Director.
• Participated in bug triage meetings with developers to validate the severity of the bug and responsible for tracking of the bug life cycle using Test Director.

Environment: Ascential DataStage 7.5.2 (Designer, Manager, Director), Quality Stage, Sagent 5.0 (Designer Studio, Sagent Automation), Oracle 10g, MSSQL Server 2005, DB2, Crontab, Solaris UNIX, Windows NT, LINUX

Confidential

SQL Tester

Responsibilities:

• Verified layout of data files and control file entries as per business requirement.
• Validated the base table (Star schemas- Fact and Dimension) by writing complicated SQL statements and reports.
• Developed backend programming in Oracle using PL/SQL and SQL.
• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive, Negative testing, Post Production testing and End to end Testing of ETL code and reports.
• Tested daily, monthly and quarterly loads end to end.
• Experience in writing complicated SQL statements.
• Wrote extensive SQL and PL/SQL Scripts for creating stored procedures in Oracle.
• Used Informatica designer to create source definitions, target definitions, transformations and mappings.
• Worked with various transformations like aggregator, expression, filter, source qualifier, joiner, lookup and stored procedure etc to in corporate the business rules into the mappings.
• Scheduled and ran extraction and load process and monitored sessions using Informatica Workflow Monitor Tested the entire data reconciliation process for multiple source and target systems.
• Used Informatica designer to create source definitions, target definitions, transformations and mappings.
• Worked with various transformations like aggregator, expression, filter, source qualifier, joiner, lookup and stored procedure etc to in corporate the business rules into the mappings.
• Scheduled and ran extraction and load process and monitored sessions using Informatica Workflow Monitor
• Tested the entire data reconciliation process for multiple source and target systems.
• Designed forms and reports using Developer 2000 according to the client requirements. Triggers, procedures and functions are developed in this reports using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes, se-quences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.

Environment: Toad, SQL, Test Director, Shell Scripting, Sun Solaris 5.8, PL/SQL, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts.