Test Automation Architect/functional Test Portfolio Lead Resume
Jersey City, NJ
SUMMARY
- 8+ years of diversified experience in Information Technology with emphasis on Quality Assurance, Verification and Validation, GUI Automation Testing, Manual Testing, Web Testing, DW Testing including Functionality, Performance, Integration, Load, Stress Testing and Regression Testing of Multi - Tier Web based Applications, client/server and Standalone Applications.
- Possess experience in the Publication, Mortgage, Financial, Telecommunication as well as Insurance industries.
- Have strong skills in HP QTP/UFT, Python, QC/ALM, Test Director, Jira and Selenium.
- In depth technical knowledge and understanding of Data Warehouse, Data Validations, SQL, PL/SQL, XML, SQL Server, Oracle and ETL.
- Have ability to identify root causes and derive corrective solutions to meet short and long term business and system requirements using resourceful approaches.
- Possess very strong communication and judgment skills, team player and quick adaptability to the ever-changing technology.
- Excellent understanding of the Software Development Life Cycle (SDLC) and role of QA
- Worked on different development methodologies like Waterfall, Agile and SCRUM.
- Proficient in analyzing Business requirements and developing Test Plans and Test Cases
- Experienced in Designing and Implementing Automation Framework for Web based, Client-Server Applications.
- Involved in maintaining Test Matrix and Requirement Traceability Matrix (RTM) and performing Gap analysis
- Recorded test scripts in Quick Test Pro/UFT and enhanced it using check points, predefined functions, user defined functions, Logics in VB Scripts, exception handling, data driven wizard and database check-points.
- Written user defined functions using VB scripting in Library files and attached to the Test script in Quick Test Pro/UFT.
- In depth knowledge of Unix shell scripting
- Good exposure to Global Risk Platforms that involves major components such as Feed Server, Risk Analytics (VaR, Geeks and EST) and Reporting requirements.
- Understanding of Recent Regulations in Investment Banking Risk space such as Risk Data Aggregation Principles.
- Ability to Design dynamic, data driven and reusable test automation suites using HP Quick Test Pro/UFT, and Quality Center/ALM. Ability to Create Test Sets for each Business Process Testing (BPT).
- Experience in Manual, Black Box/White Box /Gray Box and Automated testing of applications on Windows and UNIX Environment
- Experience in working with open source toolsSelenium
- Experience on Selenium IDE and creating Scripts in Selenium RC by using Java/Python
- Performed Performance, Load and stress testing
- Managed Requirements and Test Cases and test scenarios with the Test Director and Quality Center
- Worked with all stages of testing namely Unit Testing, Functional Testing, Integration Testing, System Testing and User Acceptance Testing (UAT)
- Very good experience in Regression Testing, Data Driven Testing, Backend Testing and security Testing
- Extensive knowledge of data warehouse methodologies, fundamentals, and data warehouse project management
- Familiar with data extraction, data architecture, and data warehouse testing process
- Experience in Backend database testing by writing simple to complex SQL queries using joins, sub queries and clauses
- Very convenient in working with PL/SQL and database Oracle and SQL Server and verified Triggers and Procedures
- Participation in design reviews with the Development, Business Analysts, QA Teams
- Good team player and have ability to work independently
- Worked with the programming languages Python, Java, C++, C#, Visual Basic and VB script, Excel Macro and good knowledge of Unix Shell Scripting and XML
TECHNICAL SKILLS
Tools: Quick Test Pro/UFT, Rational Team Test Suite, Load Runner, Test Director, Selenium, Quality Center/ALM, Jira, Autosys, Toad, Informatica, Excel Macros, QZ Test Tool (Python)
Languages: Python, C, C++, C#, Java, VB, Java Script, VB Script, HTML, XML
OS: Windows 9x/2000/ NT/XP, Unix/Linux, DOS.
Documentation: MS Office (Word, Excel, PowerPoint), MS Visio.
Database: Oracle (PL/SQL), SQL Server, MS Access, DB2.
Web Servers: Apache, WebSphere.
PROFESSIONAL EXPERIENCE
Confidential, Jersey City, NJ
Test Automation Architect/Functional Test Portfolio Lead
Responsibilities:
- Designed and developed complete Automation Framework using Python and VB Scripting (QTP/UFT) in such a way that it increases and speeds up their productivity.
- Developed Python based automation for Risk Data Aggregation project in market risk which reduces ample amount of manual effort for regular data analysis.
- Also developed backend automation tool using Python scripting for any database validations.
- Developed automation framework for large data analysis for both GUI and Backend validations project which covers scripting using QTP/UFT for front end validations and python based QZ test tool for backend validations.
- Develops unit test cases for the code generated by development team as part of continuous integration to automation.
- Run tests by using Selenium remote control in different browsers.
- By taking on leadership responsibilities and influence the direction of the automation effort, and its schedule and prioritization.
- Worked with management, developers, and quality assurance personnel, to meet the goals.
- Additionally involved in supporting the build validation for each environment using build test scripts.
- These build tests ensure that the code drops to QA environments are of the highest quality.
- Reviewed product requirements, functional and design specifications to determine and prepare automated test cases.
- Identified how the test team aligns within an organization and how the team would achieve the roadmap identified for the project.
- Identified the scope of the automation testing required for a particular release based on the requirements document.
- Prepared the estimation document of Automation efforts required to complete in each application.
- Scheduled Weekly Status Meeting with the team to discuss task status and any showstopper issues.
- During the testing cycle monitored the test automation progress by constantly assessing the work assign and sent to each of the resources and re-balanced or re-allocated them as required.
- Checked if there might be any delays in achieving the schedule and hold discussions with testers to figure out the issues they may be facing and strived to resolve them.
- Presented the timely status to the stakeholders and management and instilled confidence about the work being done.
- Prepare delivery decks on weekly and monthly basis to QA Sr Mangers and Dev Managers.
Environment: QTP 11.0, UFT 12.0, QC ALM 11, Python, VB Script, Java Script, HTML, MS Excel Macros, Unix Shell Scripting, Web Service, SQL, Toad, Win 7, Linux, Selenium, QZ Test Tool, Informatica
Confidential
Automation Test Lead
Responsibilities:
- Designed and developed complete Automation Framework for Web based Java application.
- Analyzed current state of testing and requirements for automation.
- Evaluated, selected and formulated best usage of test automation tools for different products ie. QTP.
- Maintained, improved and implemented QA automation Framework and custom automation libraries for different modules.
- Identified different risk that might occur in automation process and provided risk mitigation strategy.
- Proposed and implemented new ideas in the existing QA approach.
- Documented and defined QA automation processes and provided automation status to Higher Management.
- Provided leadership, guidance, training and mentoring to Automation test engineers for the implementation of testing automation.
- Prepared the estimation document of Automation efforts required for the specific modules.
- Allocated tasks to the available resources as per the timeframe.
- Developed Automation feasibility reports for different modules based on the technical analysis, complexity and reusability.
- Raised the quality of the product by providing complete, quick, reliable, and easy to interpret script results.
- Lead automation test case design and code coverage reviews.
- Scheduled Weekly Status Meeting with the team to discuss task status and any showstopper issues.
- Used Descriptive programming to make script more reliable and less maintainable using VB script.
Environment: QTP 10, QC ALM 10, Java, VB Script, Java Script, HTML, MS Excel, Web Service- XML, Fitnese Tool MySQL, SQL Tools, Win 7, Linux
Confidential
QA Automation Lead/Sr QA Functional Tester
Responsibilities:
- Developed Automation Framework by considering the business requirements and available tool resources.
- Scheduled Weekly Status Meeting with the team to discuss task status and any showstopper issues.
- Attended and Scheduled different walkthroughs for discussing the project issues related with scripting and maintenance.
- Reported team status and defect summary report to Higher Management.
- Developed the front-end so user can run Automation Script by selecting different scenarios without opening QTP.
- Developed, tested, maintained and improved web-based front-end user interfaces using HTML, XML and JavaScript
- Created External Functions in VB script to remove the redundancy.
- Developed Excel Macros to calculate the Premium and verify the Macro Premium with the application using QTP.
- Imported data from MS Access database to QTP Data Table for required input data.
- Used Descriptive programming to make script more reliable and less maintainable using VB script.
- Performed data driven testing by importing Excel Sheet into Data Sheet in QTP and executed the script with different sets of data inputs.
- Created Recovery scenario for error handling in QTP
- Developed automation script to test Web Services like SOAP messages, simple HTTP messages using Fitnese tool.
- Created documents detailing the process for each of the test scripts and the scenarios each script performs.
- Prepared the test plan and test case documents for image view application.
- Involved in troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
- Extensively tested the Reports by running the SQL queries on the database by reviewing the report requirement documentation.
- Worked with BAs to clarify the Reporting Requirements.
Environment: Quick Test Pro 10, QC ALM 10, Fitnese Tool, Java, .NET, VB Script, HTML, MS Excel, Web Service, SQL Tools, Win NT/XP, Unix
Confidential
QA Engineer
Responsibilities:
- Attended Approach Walkthrough to review the Approach Documents for New Requirements or Change Requests.
- Prepared Test Data required for testing for that specific functionality.
- Prepared possible scenarios to test the functionality and developed test cases by including positive and negative tests in QC.
- Arranged Test Case Review meeting to get approval from PM, BA and Dev Leads.
- Executed Test Cases in QC by configuring different settings, which required testing the particular functionality.
- Reported the issues in QC by identifying type of issue and escalated further if its high severity.
- Logged in to UNIX servers to access the log files to attach the error information in the defect description.
- Carried out back-end testing on UNIX platform by executing SQL queries on Oracle RDBMS using SQL*PLUS.
- Created Automation Scripts for online applications and uploaded the scripts to QC which will help during Execution phase.
- Developed the external functions and reusable actions to use in the script.
Environment: Quick Test Pro 9.2, Quality Center 9, VB Script, MS Excel, Mainframe, SQL, Unix, Win XP