Validation Analyst Resume
Princeton New, JerseY
SUMMARY
- Acompetent CTFL (ISTQB)Certified Testing professional with around 8 years of experience in IT industry as a QA Test Engineer with specialization in Manual and Automation Testing of Web Based, GUI, Client/Server and Business Intelligence applications.
- Good working expertise in Pharmaceutical, Banking, Airline, Manufacturing, Financial and Sales domains of IT industry.
- Strong experience in entire QA life cycle activities such as Requirements Analysis, Design, Development and Implementation of Test scripts/Test cases, Requirements Traceability Matrix, Defect Tracking, Entry and Exit criteria's, and Documentation.
- Excellent knowledge of VB Scripting andDescriptive Programmingfor developing QTP Test Scripts andFunction Libraries.
- Extensive use of Defect management tools and Bug reporting tools including Bugzilla, Jira, Rational Clear Quest and HP Quality Center.
- Proficient in using Configuration Management tools SVN, Perforce, Rational Clear Case and CVS.
- Performed different kinds of software Testing - Smoke/Sanity, System, End to End, Integration, Regression, Performance, UAT, Functional, Middleware and Database testing.
- Experience in preparing test documents including Test Plan, Test Scenarios, Test Cases, Test Scripts, Test Data, Test Result Metrics, Test Status Reports, Summary Reports and Traceability Matrix based on User Requirements, Functional requirements (FRS) and System requirements (SRS).
- Thorough understanding of the Defect Life-Cycle Process, Defect Tracking and Bug Reporting.
- Expertise in understanding Business, Functional design specifications and Technical design documents.
- In depth knowledge of Software Development Life Cycle, Software Testing Methodologies, and Quality Standards like IEEE/ISO/CMM and experience working in Agile, Waterfall and V-Model environments.
- Experience in testing OBIEE and Business Objects applications for reports, dashboards and iBots and performed ETL testing.
- Proven abilities in creating complex SQL queries by linking data from multiple tables.
- Efficiently worked with Oracle and SQL Server databases and built SQL queries to verify and validate backend data.
- Strong understanding of file handling commands using UNIX and performed chmod, grep, and umask functions using UNIX file system.
- Experience using application servers like Weblogic/JBOSS and Apache Tomcat Web Server.
- Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences.
- Experience working with Onsite- Offshore teams and monitor the testing activities.
TECHNICAL SKILLS
Automation Tools: Quick Test Professional (11.0,9.5,9.0 versions)
Version Control Tools: SVN, Perforce, CVS, Rational Clear Case
Bug tracking Tools: HP Quality Centre(11.0), Jira, Bugzilla, Rational Clear Quest
Development Tools: Microsoft Visual Studio 2005, Eclipse, SQL Developer, Toad
Programming Languages: Java, J2EE, VB, C, C++, SQL,VC++
Database Systems: Oracle, MS Access, SQL Server
Web Technologies: HTML, CSS, JavaScript, XML
Operating Systems: Unix, Windows
Methodologies: SDLC Concepts, V-Model, Agile, Waterfall processes
PROFESSIONAL EXPERIENCE
Confidential, Princeton, New Jersey
Validation Analyst
Responsibilities:
- Understanding of Business Requirements. Worked as an Onsite lead and successfully handled a team of 2 associates at offshore.
- Developed high-level test plans, disseminated activities and assignments, monitored the progress with MPP, and utilized resource-leveling, team-synergy, risk analysis, and individual productivity to meet deadlines.
- Checked whether all the documents necessary for Validated System are implemented and followed FDA Regulations 21 Part CFR.
- Prepared Test Scenarios for the Team to prepare Test scripts.
- Reviewing of Team task for various document prepared as part of validation deliverables.
- Performed Dry Run of UAT scenarios and UAT Facilitation for the Business Users.
- Defects Logging and Tracking it to Closure.
- Attending Project Meeting as well as Change Control Meetings.
- Helped Client Understand the Validation process implementation in all the Projects.
- Coordination with client and development team for various testing activities and issues.
- Prepared Test Data for different modules of Project and used them during test execution.
- Involved in end to end System validation and testing using IQ, OQ and PQ test Scripts.
- Ensured 100 % requirement coverage and prepared Traceability Matrix.
- Defect Tracking and Status Reporting to Onsite/Client on daily basis.
- Provided technical, validation and process related training to team members.
- Responsible for creating test data covering all possible scenarios in system validation.
- Perform database testing by writing SQL Queries to validate data in reports and database tables.
- Provide validation support to business users globally during UAT scripts execution.
- Involved in IQ, OQ, UAT Report and Validation/Test Summary Report Preparation.
- Initiate review and approval of validation deliverables via electronic document management system which is 21 CFR Part 11 compliant.
- Defect Tracking and Status Reporting to Client and Business users on daily basis.
- Internal review of Project deliverables and test execution as per Otsuka standards.
- Handling Onsite-Offshore team coordination and task management.
- Daily interaction with Client, Business users, Project team and various stakeholders involved in the Project.
- Strong exposure in using Good Documentation Practices (GDP) in validation of Life Science applications.
- Provide validation support to Global business users during User Acceptance Testing (UAT).
- Experience in Validation & Testing the applications related to Life Science domain including Electronic Document Management System, ARGUS, Oracle Life Sciences Hub (LSH), CTMS, Oracle E-Business Suite, Clinical Data Repository in accordance to GxP compliances and 21 CFR Part 11 Standards.
- Worked extensively with Informatica MDM IDD, in order to act on the change requests generated in the front end.
- Worked closely with Data Stewards, in managing the content and metadata.
- Strong experience in design and execution of Installation Qualification (IQ), System Testing, Operational Qualification (OQ) and User Acceptance Test (UAT).
Environment: Veeva CRM, CSV, IQ, OQ, PQ, UAT, SQL, 21 CFR Part 11, GxP, HP Quality Center, GQEDMS
Confidential, New York City, NY
Sr. QA Analyst
Responsibilities:
- Involved in complete SDLC - Agile methodology.
- Monitored the work being performed by the team and ensured that each completed user story meets the benchmark DOD, performed the demo at the Sprint Review meeting.
- Involved in Release and Iteration Planning, where user stories are estimated.
- Prepared high level Test Plan, which detailed the testing scope, objective, strategy, approaches, roles, and responsibilities.
- Written Test Scenarios for responsible modules and responsible testing topics by using Black box techniques.
- Performed functional testing which included testing all the business workflows, links, forms, cookies, HTML and CSS.
- Involved in writing SQL Queries to backend Database for ACID properties validation, Data Integrity, Business Rule Conformity, Data Mapping and Data validation.
- Performed Regression testing using QTP scripts for the existing functionality, as and when the bugs got fixed and checked whether the application is free from bugs.
- Customized the QTP scripts according to the requirements by inserting conditional statements and loops.
- Involved in design and implementation of Hybrid framework in QTP using VB Excel Macro, Test scripts, Excel sheet, Object repository and Function libraries.
- Used Descriptive Programming for object identification and created and maintained Function Libraries in early phases of the application when designs had changed and application snapshot was not ready.
- Ran QTP scripts at scheduled time, through Windows Scheduler, by automating the execution of .vbs files that launch QTP with required settings, add-ins etc.
- Used Check Points, Output Values, Recovery Scenarios, Regular Expressions extensively in QTP
- Handled Dynamic Objects using GetROProperty in QTP.
- Extensively used Test Batch Runner in QTP for Batch Testing.
- Used Reporter Object in QTP for reporting test results.
- Created test plan, Test Scope, strategy document, Approach document, Test Data, test cases, scenarios, conditions in Quality Center covering all aspects of project functionality, Performance score card, Metrics and Knowledge transition document.
- Involved in testing and executing jobs using UNIX Shell Scripting.
- Worked with development teams, Business Analyst investigating and correcting software bugs and deficiencies based on the testing results.
Environment: HP Quality Center 11.0, QTP 11.0, VB Script, SQL, HTML,CSS,XML, PHP, Google Chrome, Safari, IE(6,7&8), Mozilla, Java, J2EE, Microsoft.Net applications, Oracle 11g, UNIX, Windows 8,z/OS.
Confidential, Dallas, TX
Sr. QA Analyst
Responsibilities:
- Actively involved in Functional, Regression, Interface, Usability, Compatibility, and UAT testing of the United Airlines web application to keep up with the fast phase of feature enhancements, code changes and to accommodate bi-weekly sprint release cycles of Agile methodology.
- Prepared Test Plan, Test Scenarios, Test cases using user stories.
- Performed navigation testing, content checking in all the pages of the website.
- Checked all the links in web pages, database connection, forms in the web pages, and also done Cookie testing.
- Checked if all the interactions between web server, application server and database server are executed properly.
- Checked how different GUI components like menu bars, toolbars, dialogs, buttons, edit fields, list controls, images etc. reacts to user input and whether or not it performs in the desired manner.
- Worked with Business Users and other testers to identify the test cases best suited for automation.
- Involved in design and implementation of Data Driven Framework using Object repository and external data sources like Excel, XML and Oracle database, to test the application with multiple sets of data in QTP.
- Worked extensively with data table object, utility objects, file handling, Regular Expressions, XML file processing, Microsoft Outlook Automation, HTML DOM in QTP.
- Handled Popups in QTP using Recovery Scenarios.
- Used Virtual Object Wizard to record any unrecognized objects.
- Extensively used Quality Center for Requirements, Test Plan, Test Lab and Bug Tracking. Integrated Quality Center with external sources such as Excel to export Test Report. Created and maintained the Traceability Matrix in QC, to track requirements during the testing phase.
- Participated in design review/walkthrough sessions.
- Wrote and distributed reports to describe automation program evaluation problems found, corrections needed, and problem areas.
Environment: QTP 11.0, Microsoft IIS, Microsoft Sql Server 2008, HP Quality Center 11.0, Eclipse, Java, Selenium Web Driver, Web logic.
Confidential, Milwaukee, WI
Sr. QA Analyst
Responsibilities:
- Performed Regression, Smoke, System and Functional Testing of OBIEE Server metrics and reports generated in Service Operations, Sales and Booking, Procurement and Spend and financial modules.
- Involved in testing various reports created using OBIEE functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab, Master/Detail and Formula etc.
- Developed Scenarios, Test scripts and Test cases for financial dashboards and reports being developed in OBIEE.
- Identified the test cases that are to be automated and those that are to be manually done.
- Modified and maintained Test cases and scripts due to changes in the application screen(s) and flow.
- Debugged and analyzed the logs before opening up a defect.
- Participated in daily Defect Review Meetings, QA Team meeting and provided weekly status updates to QA lead.
- Involved in generating Test Summary Reports for each weekly release of the product.
- Managed version configuration of Scripts, Function Libraries, Object Repositories & other artifacts through Perforce.
- Participated in requirement reviews and analyzed Modification requests and Enhancement requests.
- Developed automation scripts using QTP for Regression Testing during every release of the product.
- Created Recovery Scenarios for Error handling to deal with runtime Errors in QTP.
- Enhanced and modified test scripts to test effectively using checkpoints such as Standard checkpoint, Database checkpoint and Page checkpoints.
- Worked on Output value and analyzed tests with Output values and run-time data results.
- Extensively used Parameterization in QTP to perform Data-Driven testing.
- Performed Data Validation of reports by writing SQL queries to extract the data from the Oracle database.
- Involved in ETL Testing the SQL Queries of Source Qualifiers and Testing the Loaded data on tables.
- Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
- Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
- Involved in complete SDLC - Agile methodology.
- Logged defects in Rational Clear Quest and tracked them to closure.
- Involved in writing Technical document and knowledge in documenting system features and requirements using Rational Requisite Pro.
- Managed files, directories, and other development assets across the lifecycle using Rational Clear Case.
Environment: QTP 11.0, SQL Developer, OBIEE 11.1.1.7.0 , Informatica, Microsoft Excel/Word/PowerPoint 2010, Oracle 10g, Perforce, Windows2008, Rational Clear Quest, Rational Clear Case, Rational Requisite Pro, Tomcat.
Confidential, Atlanta, GA
Sr. QA Analyst
Responsibilities:
- Involved in GUI Testing, UAT, System Testing, Regression Testing.
- Handled the integration and testing of a new Confidential product, Worksite Marketing/Employee Exclusives.
- Involved in developing Test plans using Business Requirement documents.
- Hands on experience with Single Sign On, and working with Digital Certificates and Certificate Authority to issue certificates for Login and Security Testing.
- Analyzed business and functional requirements to design UAT Test cases for various functionalities within the application.
- Updated existing test cases using latest release notes to reflect any new updates to the application.
- Involved in automating the regression scripts for Confidential products such as Total Pay card and EzTime using QTP.
- Created User Defined Functions and Procedures in QTP using VBScript.
- Maintained and modified object repositories for the objects recorded through Quick Test pro.
- Worked on Databases to query Production environment and prepare test data.
- Involved in Backend Database Testing using SQL.
- Involved in complete SDLC - V-Model methodology.
Environment: Jira, QTP 9.5, ZOS, Windows95/98 /2000/XP/NT, Java, Oracle 10g.
Confidential
Testing Engineer
Responsibilities:
- Involved in Writing and Execution of Test Cases to ensure that they meet the Business Requirements.
- Performed Functional, GUI and Regression testing of mission critical modules like Reprocessing, Smoothing, Overlay, Peak detection and Calibration, before every release of the product.
- Reported bugs into Bugzilla with detailed information.
- Created manual test cases for Functionality and GUI testing by studying the application flow.
- Tested independent and dependent modules individually. Prepared Traceability Matrix to keep track of the requirements and the test cases.
- Responsible for test execution and creating the Summary Reports.
- Analyze tickets filed by customers - reproduce errors and escalate to developers as necessary.
- Generated detailed reports of the Bugs, Pass-Fail report and Comparison Chart.
- Maintained and modified test cases with the changes made in the client requirements and executed all the test cases and documented the test queries and results for future references.
- Maintained and checked the Version Control mechanisms for Technical & requirement document, using Apache Subversion (SVN).
- Been involved in complete SDLC -Waterfall methodology.
- Conducted manual testing by executing the test cases during weekly batch test and as new builds were rolled.
- Involved in Defect meetings and worked with developers to reproduce them.
- Actively involved in Go-Live and maintenance support by addressing project specific calls.
Environment: QA Methods, VC++, SVN, Windows 2003, Microsoft Excel/Word/PowerPoint 2005, Microsoft Visual Studio 2005, Bugzilla.