Qa Lead Resume
Mountain View, CA
Objective
- Seeking a Senior QA position.
- Improve software quality; reduce defects by adhering to software quality practices and implementing effective process improvement methods.
- Plan and perform Manual and Automated testing.
SUMMARY
- 14 year’s industry experience of which 8 years’ experience on software quality assurance and control.
- Expertise in designing and implementing test strategy - 6 years
- Design and implement automation framework strategy
- Use of HP-QC for test planning, test execution, defect management and track project status
- Test automation for back end using shell scripts and PERL - 6 years
- Expertise on web services testing, web application testing - 4 years
- Experience in Agile testing using Scrum methodology - 4 years
- Excellent communication skills, Team player, pro-active
- Expertise in defect tracking systems - 8 years
- Expertise in command line editing tools - vi editor
- Expertise in UNIX file systems and file permissions
- Expertise in writing complex queries in RDBMS{SQL and PLSQL} - 8 years
- Expertise in XML testing, schemas validation, namespace validation - 4 years
- Expertise in SOAP, SOA, WSDL - 4 years
- Expertise in C/C++/Java. Can develop code using C/Java - 6 years
- Experience with automation testing using QTP, Selenium
- Mentor the team, lead and manage onsite and offshore teams
- Expertise in creating test plans - 6 years
- Expertise in creating test estimates - 6 years
- Experienced in creating schedule, assigning resources, releasing resources, mentor team members and provide training
- Expertise in requirements analysis, scope review - 6 years
- Expertise in prepare/update project plan - 6 years
- Expertise in preparing test cases, test execution, analyze test results, root cause analysis and defect management - 8 years
- Expertise in functional testing - white box and black box methodology - 8 years
- Expertise in System testing, Regression testing, Performance testing, Load testing, Stress testing, Sanity Testing - 8 years
- Expertise in all phases of SDLC and STLC - Waterfall and Agile {SCRUM} methodologies - 6 years
- Expertise in multi-browser testing – 4 years
- Expertise in multi-OS testing – 4 years
- Experienced in documenting test artifacts – Test Plan, Test Case, Test Results, Traceability Matrix, Defects, Issue Log, Knowledge base, Risk register – 6 years
TECHNICAL SKILLS
Languages/Technology: Test Automation, White Box, Black Box, API, Java, J2EE, XML, Javascript, HTML, SQL, Shell script, C/Pro *C, Functional Testing, Regression Testing, Performance Testing, System Testing, Positive and Negative Testing, Integration testing, Linkage testing, Co-operative testing, RMI, EJB, AJAX, Struts, PHP, Servlets, MQ Series, ETL Testing, JIRA, WYSE, i18n, l10n
OS: HP-UNIX, Windows XP/2000/98/95,Linux
Application and Web server: Weblogic, Tomcat, Apache, Web sphere, Borland Application server
Database: Oracle, SQL Server, Data warehouse
Version Control: VSS
Scripting and Mark-up languages: UNIX shell scripts, HTML, XML, JavaScript, Vbscript, Perl, JSP, JDBC, Apple Script
Java Technologies: JAVA, J2EE, EJB, Swing, Applets, RMI, EJB, WSDL,, Webservices
Tools: HP Quality Center, QTP, TOAD, Confidential Product Studio
Standards and Methodology: SDLC, Agile, Waterfall, SCRUM
Planning and Design: PMP, MS Office, MS Project
Domain: Telecom Billing, Work Force Management, Dispatch Centers, Mutual Funds, Capital Markets, Debt Markets, Derivatives, Custodians, Inspections, Margins, Mediation, Finance
PROFESSIONAL EXPERIENCE
Confidential
QA Lead
Environment: Windows 7, UNIX, Oracle 10g, Office 2010, IE8, FF3.6+, Web-sphere, web-services, localization/internationalization, XML, html, J2EE, struts, QTP, Selenium, AJAX, functional testing, regression testing, Automation, CSS, Oracle Glass-Fish server, REST based web-service.
Responsibilities:
- Lead QA efforts for Smart Web Technology Group, comprising of: Confidential International Support Sites, SWAP Web Publishing Interface and localization QA.
- Prepare Test Plan for the Four Corners localization and ALT CSO projects.
- Participate in meetings with Program Manager, business team and development team to prioritize new projects and maintenance releases.
- Participate in requirements meetings with the business team to review the requirements and suggest improvements.
- Approve work authorization to QA team to start particular piece of work as per the milestones.
- Present QA status in final readiness review meeting to all stakeholders.
- Hold weekly meetings with the QA team to discuss the work stack and accountability of the team's commitments, milestones and deliverables.
- Prepare test strategy for Four Corners release, ALT CSO and PAWS migration.
- Drive timely execution of Portal UAT, LQA and SWAP QA for Four Corners release.
- Create QA schedule for SWAP functional QA, LQA and Portal UAT for the Four Corners project and obtain approval from Four Corners stakeholders.
- Demonstrate the quality assurance standards provided to the business team with the help of test strategy and test plan.
- Implement project management process of preparing requirements traceability matrix, WBS, schedule, risks for all the releases/projects.
- Migrated to quality center for test planning, test execution, defect tracking and management from JIRA.
- Allocated QA resources to work on multiple projects or tasks for the Four Corners release.
- Prepare and review the test execution and defect summary report for the Four Corners release.
- Identify key sources of project risk like furlough, test data not available for new functionality for the four corners release and define the approach for mitigating the risk.
- Automated functional testing for International support sites and SWAP web publishing interface using QTP.
- Evaluated QTP, Selenium and Sahi automation tool based on automation and project requirements.
- Developed hybrid automation framework comprising of modules, key events, library files, shared object repository.
- Defined metrics and performed metric measurements to determine variance, testing efficiency, productivity etc.
- Effectively communicated SWAP schedule/estimates risk to all four corners stakeholders in a timely manner and the plans, status, issues and risks to the team members/stakeholders.
Confidential, Mountain View, CA
Team Lead, Software QA
Environment: MAC Office 2011, WIN Office 2010, Windows 7, Leopard, Snow Leopard, Apple scripting, Confidential Product Studio, Function, Regression, Automation, Sanity, Black Box, Test Plan, Test Case, UNIX, file formatting, Round tripping.
Responsibilities:
- Automated functional testing for Sections using Apple script. Developed code to open PPT, insert new sections, insert new slides within sections, move sections, delete and rename sections.
- Automated functional testing for Find in toolbar using Apple script. Developed code to open PPT, insert text in slides, invoke find in toolbar to search for the text.
- Modified existing scripts to make use of more robust API which make use of toolbar menu and sections menu instead of identifying the co-ordinates of the toolbar.
- Created and implemented test strategy for functional testing of Sections, Find in toolbar, Comments and A/V
- Participate in requirements review meetings with business, PM and development team
- Created and implemented test plan for functional testing of Sections, Find in toolbar, Comments, A/V
- Extensive usage of SCRUM methodology and by breaking down each feature into smaller 2-3 week sprints
- Performed compatibility testing. Executed round trip scenarios like MAC PPT 14.0 - WIN PPT 11 – WIN PPT 12 – WIN PPT 14 – MAC PPT 12.0 – MAC PPT 14.0.
- Performed internationalization/localization testing by executing automation tests on French, Japanese and Spanish builds
- Write queries in Product Studio to determine bugs assigned to a particular Crew id, bugs assigned to a User, bugs in Active, Resolved and Closed status, search for an existing bug
- Write queries in Product Studio to determine test cases assigned to a particular feature or crew id, to determine test case type ( BVT, BFT, Comprehensive), automation status (Manual, to be automated
- Upload test cases in Product Studio using excel plug in, assigned priority to test cases.
- Performed performance testing for Sections and Find in toolbar on iMAC and Mac book with different configurations (Core 2 Duo, 1 GB RAM, 2 GB RAM). Test data comprised of a presentation with 1000 slides comprising a mixture of all types of data, not limited to embedded audio, video files, varied font types, Format ribbon, Tables ribbon, Themes ribbon, Charts ribbon, Smart Art ribbon, Home ribbon and media browser.
- Prepare test data for find in toolbar feature comprising of varied font types, font sizes, bold, Italics, Underline, Strikethrough, Text shadow, Superscript, Subscript, character spacing, change case, bullet points, left indent, right indent, left aligned, right aligned, center aligned, ligatures.
Confidential, Hoffman Estates, IL
Team Lead, Software QA
Environment: Java, J2EE, Websphere, Function, Regression, Automation, Sanity, Black Box, Test Plan, Test Case, Security Test, UNIX, Oracle, XML, WSDL, UI, Interface testing, Batch process testing, Backend validations, Telcordia Force, Telco WFA, Dispatch centers, LMOS, WFAC, SORD, ASON, DCOE FORCE, IDS FORCE, SOAC, AJAX, HTML, Javascript
Responsibilities:
- Created a test data repository as part of the hybrid automation framework
- Designed hybrid automation framework comprising of key word, test data and modularization approach for web based applications GCAS and CGTO.
- Modularized the approach to automation, identified the key events for automation.
- Prepared library files for common functionality like logging into application, retrieving system time and date, writing to log files, importing test data into data table using VB script.
- Prepared and administered shared object repository
- Extensive programming in expert view to add checkpoints, verify test and run time object properties, parameterize the test runs, referencing the functions in the library files, store output values, add conditional and control structures.
- Developed automation script for the POTS billing and Close functionality by scripting the test object properties in the expert view.
- Associated the shared object repository and the library files with the test.
- Connected to HP-QC from QTP and saved the test, library files in HP-QC.
- Extensively used data sheet to store test input data from external files and to store the output values from the system.
- Retrieved child objects programmatically to set and clear the radio buttons, check boxes while assigning jobs to technician
- Compared the run time value of the dispatch date object property with the assigned date object property by using programmatic description
- Made use of index property values while assigning values to test objects like Technician name, Customer Name, Customer address text fields
- Made use of regular expressions to verify date fields are in proper format. Made use of regular expressions to Save, Close log files.
- Performed functional and regression testing of web based systems, hosted on web-sphere, consisting of a middle layer implemented in J2EE and PERL, batch processes implemented in C and PL/SQL, a database layer implemented in Oracle, UI layer implemented in IE and Windows and UNIX as OS.
- Created test plan folder in QC to upload test cases, extracted test cases to test lab tab, created template for uploading test cases to QC, created template for creating test cases in Excel
- Designed and implemented test strategy for migrating web based application from Windows XP to Windows VISTA for a web based application
- Designed and implemented test strategy for compatibility of web based application on multiple browsers {IE6, IE7, IE8}
- Created and implemented test plan for functional, system, Integration and regression testing for creating a new instance of web based application which caters to a new region
- Created and execute test cases comprising of positive, negative, boundary scenarios for functional, System and Integration testing of migration of U-Verse jobs from main frame systems to UI based and web based systems
- Created and execute test cases comprising of positive, negative, boundary scenarios for functional, System and Integration testing of migration of I&R jobs from main frame systems to UI based and web based systems
- Created and execute test cases comprising of positive, negative, boundary scenarios for functional, System and Integration testing of a new instance of a web based application created to cater to SW region
- Write complex SQL queries including Insert/Update/Delete/Select/JOINS to set-up the test data and validate the test results for all the releases.
- Maintain a excel sheet detailing the test data created.
- Write shell scripts to automate the process of test data set-up by invoking SQL files which update/insert data into RDBMS
- Write shell scripts to search for a pattern in log files
- Monitor the log files using the tail command, monitor the processes that are running and the resource usage
- Monitor the load on the system using TOP command
- Determined testing efforts for the functional requirements by using test case points and the simple/medium/complex classifications based on factors like number of steps, number of interfaces, data set-up
- Execute test case, perform test result analysis, validate test data and interact with developers, business users.
- Co-ordinate with different teams for E2E test data set-up for LS-DCOE, I&R DCOE and SE TECH ACCESS.
- Extensively used QC for test planning, test execution and defect management for all the releases. Generated reports from QC to track the test execution status.
- Analyzed the functional requirements and determined the scope of testing, segregated functionality into logical modules.
- Prepared high level test scenarios for each functionality, prepared detailed test cases for each requirement including positive and negative scenarios for the same.
- Updated requirements trace ability matrix with the test case IDs for each business requirement and technical requirement
- Participated in requirements review meetings with the business and development team
- Created and maintained an issue log detailing the anomalies found in each test run on the current and previous version, documented the root cause and its solution
- Conducted Test case review and identified the gaps/missing scenarios.
- Prepared test strategy, system test plan to test loaning of technicians to different supervisors, from different interfacing applications like mainframe and UI based systems.
- Executed regression test suite for XP to VISTA migration.
- Executed regression test suite for IE6 to IE7 migration.
- Ensured timely escalation of critical and out-standing issues to test manager, PM, developers and clients.
- Product modeling expertise for Work Force Management.
- Performed API testing, component testing for the billing, time reporting, VIN updating module
- Performed interface testing with IPTV, Main frame, VTS maps, billing and time reporting
- Planned load test, created VUser scripts, defined scenarios, executed scenarios and analyzed results for performance testing of dispatch, close and return of U-Verse jobs in a web based environment
- Defined the run time behavior for performance testing, like, number of repetitions, think time, time to wait between iterations
- Defined transaction for each key event, such as, dispatch, close, return and measured the performance
- Defined checkpoints to verify the web page content, like assigned date, return date, return reason, return description
- Configured the number of Users for each test, generated load on the application during the performance test run
- Monitored the transaction response time, hits per second, and through put information. Co-related graphs to compare data.
- Provide support to E2E teams, UAT teams in setting up the technicians, resolve queries on new functionality, set-up technician schedule, assign a job to technician
Confidential
Team Lead, Software QA
Environment: C/C++, Oracle, UNIX, Shell scripts, PL/SQL, SQL, VB Scripting, Function, Regression, Automation, Sanity, Black Box, Test Plan, Test Case, UNIX, Oracle, Interface testing, Batch process testing, Backend validations, Pricing, Telecom Billing, Mediation Systems
Responsibilities:
- Developed SED files in UNIX for replacing text in multiple files
- Developed shell script to invoke the test suite using the basename command
- Developed shell script to connect to Oracle and execute SQL statements
- Developed shell script to search for a specific pattern using grep, cut and sort test data files.
- Defined and implemented a common structured testing process and coordinated test planning efforts.
- Manual testing of new releases
- Developed shell scripts which invoke the pricing engines and price the call detail record.
- Measured performance in terms of number of calls priced per second under varying system load.
- Enhanced internal framework by updating existing regression scripts.
- Designed test strategy and wrote test cases. (Project Huxley).
- Wrote UNIX shell scripts to enhance shell scripts.
- Execute tests, evaluated results and analyze root cause.
- Experienced in developing test code and automation framework.
- Participated in business requirements meeting with clients.
- Reviewed and modulized existing test cases, implemented automated test case with maintainable and extensible test code.
- Automated testing by writing shell scripts.
- Performed API testing.
- Tariff testing for Confidential landline
- Run the pricing engines and perform call price validation, verify priced and un-priced PIUR
- Found issues, provided reproduce steps and root cause from test.
- Good analytical skills on test issues; provide daily test report.
- Testing of Mediation systems
- Maintained test suite.
- Requirements Analysis and problem resolution
- Write shell scripts to test new offers introduced
- Experienced in running Perl and UNIX shell scripts.
- Performed sanity, function, system and regression tests.
Confidential
Systems Analyst
Environment: Windows NT, HP-UNIX, Oracle 8i, HTML, Java, JSP, PL/SQL, SQL, JDBC.
Responsibilities:
- Understand business requirements
- Application design, creation of database objects and stored procedures
- Web page design and coding to retrieve the trades done by TM on behalf of custodians and an option to select or reject the trades for the purpose of settlement.
Confidential
Systems Analyst
Environment: UNIX, Shell scripts, PL/SQL, PRO *C
Responsibilities:
- Understand business requirements
- Develop batch process to load masters files
Confidential
Systems Analyst
Environment: UNIX, Shell scripts, PL/SQL, PRO *C, Java, JSP, JDBC, HTML, Javascript
Responsibilities:
- Understanding the business requirements, prepared the functional specifications and the system requirements.
- Design and the creation of database objects.
- Design and development of the GUI to view and update the MF orders, bank details, settlement cycle details and delivery details.
- Design and development of the batch process.
- Up gradation of the legacy system into a web based application.
Confidential
Systems Analyst
Environment: UNIX, Oracle PL/SQL
Responsibilities:
- Extracts settlement wise and member wise trade details
- Design and coding of the batch process
Confidential
Systems Analyst
Environment: UNIX, Oracle PL/SQL, PRO*C
Responsibilities:
- Application support and code enhancements
- Provides details of various types of data, like, Normal deliveries, Bad deliveries, De-mat deliveries, Autions
Confidential
Programmer
Environment: UNIX, Oracle PL/SQL, PRO*C
Responsibilities:
- Provide Obligations data, Compute Margins, Generate deliveries, Funds and Securities settlement.
- Provide code modification and bug fixes as per client requirements.
- Creation and maintenance of database objects.
- Query tuning and optimization.(Explain Plan)
- Checking storage characteristics of database objects and tablespace growth.
- Performance monitoring using SQLDBA.
- Carry out table reorganization.
Confidential
Programmer
Environment: Windows NT, Oracle PL/SQL, Forms 4.5, Reports
Responsibilities:
- Code modifications and bug fixes
