Harsimran Sehgal
*************@*******.***
Summary:
Over 9 years of experience in IT with an earned reputation for meeting demanding deadlines and delivering critical solutions on various levels of Quality Assurance.
Coordinate work and work to defined testing methodologies within a structured environment.
Involved in all stages of Quality Assurance Life Cycle (QALC) and SDLC right from Inception, Design, Development, Testing through Implementation.
Strong in analyzing Business Requirements & design specifications & experienced in using tools like Test Director for writing Test Plans, Test Scripts, Test Cases, Test Procedures and Defect Tracker.
Well versed in GUI application testing, Database testing, Front end testing as well as back end Data Validation testing, Functional testing, Integration/System testing, Performance testing & Regression testing.
Involved in writing Test scripts using QTP (Quick Test Professional). Proficient in Back end testing using SQL queries on Oracle and SQL Server database tables in order to view successful transactions of data and validation of data.
Strong skills in back end testing using SQL queries, Procedures, Functions, Cursors and Packages on Oracle RDBMS.
Worked in Erwin Data Modeler tool ver 7.2 to understand database data models before writing the query.
Understanding of ETL designs (Star Schemas) using Erwin.
Expertise in performing Unit, Smoke, Integration, Regression, Portability, Performance, Compatibility, User Acceptance testing (UAT), Functional and Negative testing.
Excellent skills in overall Defect Management/ Problem solving including tracking bugs and reporting using Test Director.
Training in Selenium and ITKO LISA, SAP (FICO).
Ability to interact with developers and analysts regarding application analysis.
Focus on any task on hand and able to utilize existing test knowledge and experiences to come up with practical solutions to testing processes.
Estimating the effort in terms of budget and man months needed.
Excellent interpersonal skills and communication skills, proven team player with an analytical bent to problem solving & delivering under high stress environment.
Strongly motivated, enthusiastic, dedicated and goal oriented.
Technical Skills:
Testing Tools : Win Runner, Quick Test Pro, Test Director, Quality Center, Load Runner.
Languages : C, C++, SQL, PL/SQL, Java
Scripting : UNIX shell scripting
Web Skills : HTML, XML
Operating Systems : UNIX (AIX, Solaris), Windows 95/98/NT/2000/XP
RDBMS : Oracle 8i, SQL Server 2000, MS Access 2000
Professional Experience:
Realtime Business Solutions
Dallas TX May 2014 – Till Date
Responsibilities:
Closely worked with lead developers and business analysts to create the Test Strategy/Test Plan document.
Created Test Scripts/Test Cases and entered them in Quality Center.
Performed Manual Testing, Regression Testing, Integration Testing, and E2E (End to End) testing for the web-based e-commerce application.
Used Quality Center to track testing coverage during various Functional, Regression Testing.
Used Toad to analyze data and execute SQL queries.
Created and executed SQL statements to extract data from tables and verify output data of the reports.
Worked extensively with Business Analysts and Developers to discuss the testing scenarios, defects and their fixes.
Executed test cases and logged/tracked defects with an internal Defect Tracking System.
Generated detailed reports of the Bugs, Pass-Fail report using Quality Center.
Initiated and prepared daily project progress report and submitted it to senior management
Created Metrics to track requirements coverage by release
Prepared Project flow charts and process flow diagrams to depict test architecture
Automated test cases specified in Test Director by creating Test Scripts (VB) in Quick Test Professional.
Validated the application by creating Bitmap, Synchronization, GUI and Database verifications.
Performed Data Driven Testing using Data Files to test the scripts and to verify functionality of the objects.
Generated and ran Automated Test Scripts using Automation Tool QTP for Regression Testing.
Wrote SQL queries using group by clause.
Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database (TOAD)
Closely worked with the automation team, providing feedback, analysis and ideas on improving new frameworks for automated testing. Played an important role in automation setup and creation for various projects.
Involved in “Business Acceptance Testing” and “Application Acceptance Testing” in test and development environments.
Prepared Product Readiness Review document and presented it to Product Development, Development, Project Management, Marketing, Business Analysis and Security Operations team
Prepared Training manual to be used by the end user.
Environment: Mercury QualityCenter9.2, Solaris, Putty, Toad, MS Excel, MS Word, MS Visio, Project Metrics, LoadRunner, Unix
Sabre, Southlake TX Jan 2012 – Oct 2013
Responsibilities:
Created several interfaces for an application using Java technology.
Simultaneous Exploratory Testing.
Defined test strategies for projects.
Managed various QA phases and testing methodologies including Regression, Functionality and System testing.
Successfully developed communication between Java interfaces and sockets using socket programming.
Successfully developed communication between Java interfaces and the Mainframes systems.
Worked on QTP script coding within the existing Framework.
Wrote code for encrypting and decrypting passwords across all systems to ensure security.
Responsible for managing Object Repository through Object Repository Manager making changes as needed for QTP scripts.
Extensively used VB script functions in Quick Test Pro (QTP) to minimize code and used object spy to analyze test objects and parameterized Object repository to reuse the objects all over the modules.
Responsible for Regression testing while comparing the current results to the baseline results.
Worked with User Defined Functions creating VBScript Functions and managing Function Libraries, associating the files with the test.
Worked on developing other internal applications.
Responsible for maintenance and modified the scripts as needed.
Reported to senior management on progress and issues addressing risks and mitigation.
Arranged team meetings.
Responsible for changing the Automation passwords across several systems.
Recorded the Test cases using Automation tool Quick Test Professional (QTP) for web-based application and checked the functionality of the application for every release.
Designed and developed automated scripts involving Functional Regression, Integration test cases using Quick Test Professional (QTP).
Executed the test scripts on different releases and validated the actual results against the expected results by using Quick Test Professional (QTP).
Perform regression testing by using QTP.
Extensively used VB script functions in Quick Test Pro (QTP) to minimize code and used object spy to analyze test objects and parameterized Object repository to reuse the objects all over the modules.
Worked closely with Development, Delivery, Configuration and Marketing team to ensure End to End Quality (E2E).
Interacted with Customer and helped them understand the products.
Helped create UAT testing templates and test scripts for customers.
Helped development team reproduce and analyze priority level 1 and 2 issues reported by customer in real time
Santander Consumer USA, Dallas TX May 2011 – Jan 2012
Responsibilities:
Responsible for the test management of projects throughout a project life cycle.
Also involved in creating processes to manage defects right through to resolution.
Developing and maintaining test methodology.
Defining test strategies for projects.
Managing the off-shore based automation test teams responsible for regression testing of the product.
Managing various QA phases and performing hands on testing including Regression, Functionality testing.
Coordinating the work of test teams and monitoring their performance.
Following up any outstanding open test risks and issues.
Managing gathering of results.
Compiling test metrics for management.
Reporting to senior managers on progress and issues.
Identify test approaches that optimize the delivery schedule.
Responsible for creating Framework for QTP Automation project.
Created Shared Object Repository, managed the repository through Object Repository Manager, Adding Objects to local.
Executed QTP Automation Scripts for entire Automation projects through Batch run daily from QC.
Generated daily reports for the Automation Batch Run from QC for higher management.
Wrote complex SQL queries using joins, DB Links.
Played an important role in automation setup and creation for various automation projects.
Coordinated between onsite and offshore team.
Extensively used VB Scripting to write QTP scripts for Automation.
Used Run to Step and Debug from Step, Step Into, Step Over, Step Out commands, Breakpoints, Watch Tab for Debugging and Handling Run Errors.
Worked with User Defined Functions creating VBScript Functions and managing Function Libraries, associating the files with the test.
Extensively used VB script functions in Quick Test Pro (QTP) to minimize code and used object spy to analyze test objects and parameterized Object repository to reuse the objects all over the modules.
Integrated Quick Test Professional with Quality Center saving tests to Quality Center Project and running the tests from Quality Center.
Planning and estimating.
Arranging team meetings and workshops.
Fannie Mae, Dallas TX Oct 2010 – Mar 2011
Responsibilities:
Extensively used VB Scripting to write QTP scripts for Automation.
Executed QTP Shakeout scripts and ran them as a batch test.
Successfully wrote and executed the Automated Regression scripts.
Used Toad to analyze data and execute SQL queries.
Defect Management, maintaining traceability between requirements, test cases and defects using Quality Center.
Designed Test Strategy, Test Plans, Test Summary Reports, Cases and Test Scripts for Automated and manual testing.
Wrote Test plan, Test Cases, Test Scripts, Test Matrix and Test Steps for all the modules.
Worked in all types of Test Documentation: Test Plans, Test Approach, Test Scenarios, Test Cases (both manual and automated), and Functional Specifications.
Used Quality Center for maintaining the Test Plans, Test Cases, Test Execution, Defect Management and Bug Reporting.
Developed baseline scripts using VBScript in the Expert View.
Closely worked with the automation team, providing feedback, analysis and ideas on improving new frameworks for automated testing. Played an important role in automation setup and creation for various projects.
Responsible for developing Data-driven Framework for the QTP Web based application.
Developed QTP Scripts for Java based application.
Extensively worked with Shared Object Repository, Merge operations, managing Objects in Shared Repository and Object Repository Manager.
Worked in Business Process Testing, creating Re-usable flow of business components passing data to subsequent component.
Designed and developed automated scripts involving Functional Regression, Integration test cases using Quick Test Professional (QTP).
Extensively used VB script functions in Quick Test Pro (QTP) to minimize code and used object spy to analyze test objects and parameterized Object repository to reuse the objects all over the modules.
Enhanced the VBScripts with the use of Regular Expression, Conditional Statements, Object Spy.
Extensive experience writing Code and writing Functions in QTP.
Worked with User Defined Functions creating VBScript Functions and managing Function Libraries, associating the files with the test.
Used GetROProperty and SetTOProperty methods for working with dynamic objects.
Used Run to Step and Debug from Step, Step Into, Step Over, Step Out commands, Breakpoints, Watch Tab for Debugging and Handling Run Errors.
Environment : QUALITY CENTER 10.00, QTP 10.00, MS WORD, MS EXCEL, MS POWERPOINT, TOAD, Oracle
CVS Caremark, Richardson TX Mar 2010 – Oct 2010
Responsibilities:
Created Test Strategies and Test Scripts analyzed the user/business requirements using Quality Center.
Developed traceability for programming requirements that ensure alignment with company goals and objectives.
Actively participated in analyzing requirements, traceability matrices, and test plans.
Recorded the requirements into Quality Center.
Performed negative testing and positive testing using Quality Center.
Performed Requirements based testing for new implementation projects.
Defect Management, maintaining traceability between requirements, test cases and defects using Quality Center.
Extensive use Quality Center for Test Cases Management and Defect Tracking.
Used Quality Center for maintaining the Test Plans, Test Cases, Test Execution, Defect Management and Bug Reporting.
Performed Manual Testing, New Functionality Testing, Automated Regression Testing, Integration Testing and System testing for various product modules.
Designed Test Strategy, Test Plans, Test Summary Reports, Cases and Test Scripts for Automated and manual testing.
Wrote Test plan, Test Cases, Test Scripts, Test Matrix and Test Steps for all the modules.
Worked in all types of Test Documentation: Test Plans, Test Approach, Test Scenarios, Test Cases (both manual and automated), and Functional Specifications.
Performed Black box testing, Functional testing, Integration testing, Regression testing, System testing in testing environment for Web based e-commerce application.
Experience in SOA (Web Services) testing by using iTKo LISA.
Created Web Services test cases using LISA tool.
Created filters & assertions using LISA to create test cases for positive & negative conditional scenarios.
Worked with LISA Virtualize and LISA Pathfinder.
Developed baseline scripts using VBScript in the Expert View.
Closely worked with the automation team, providing feedback, analysis and ideas on improving and creating new frameworks for automated testing. Played an important role in automation setup and creation for various projects.
Efficiently created QTP scripts for Java based application.
Extensively worked with Shared Object Repository, managing Objects in Shared Repository and Object Repository Manager.
Worked with Descriptive Programming for both static as well as dynamic objects.
Worked with Global Actions, Local Actions, Setting Action Properties, Nesting Actions, Splitting Actions, Inserting Calls to Existing Actions, using Action Properties & Action Call Properties.
Recorded the Test cases using Automation tool Quick Test Professional (QTP) for web-based application and checked the functionality of the application.
Generated and ran Automated Test Scripts using Automation Tool QTP for Regression Testing.
Validated the functionality of the application through Checkpoints such as Standard Checkpoints, Text Checkpoints and also made use of the Existing Checkpoints checking Object Property Values, parameterizing values, configuring values & Outputting Values.
Executed the test scripts on different releases and validated the actual results against the expected results by using Quick Test Professional (QTP).
Control the flow of the test by creating Synchronization points and extensively used Parameterization along with Import and Export operations working with Data Tables, Global & Action sheets.
Analyzed the Run Session Results.
Integrated Quick Test Professional with Quality Center saving tests to Quality Center Project and running the tests from Quality Center.
Involved in Working with Erwin tool in Data Modeling (both Physical and Logical Design).
Environment : QUALITY CENTER 10.00, QTP 10.00, MS WORD, MS EXCEL, MS POWERPOINT, TOAD, DB2, iTKo LISA
Education:
Bachelor of Sciences
Trainings in Oracle, pl/sql, Java,
iTKo LISA, Selenium, SAP (FICO)