Test Engineer, Qa Automation Lead Resume
Rancho Cordova, CA
SUMMARY:
- Seasoned Software Quality Assurant Test professional offering over 12 - years of focused experience in the Information Technology industry.
- Experience includes hands-on application testing and development, documentation using Internet, Web and Client Server Technologies in N-Tier Java/J2EE environment.
- Experience in development, documentation using Internet, Web and Client Server Technologies in N-Tier Java Win32 environments.
- Extensive experience in Writing Automation scripts using Selenium, writing Fixtures in Java for Jbehave Frame work.
- Automated Rest Api for Jbehave.
- Skilled in full life-cycle testing including: Requirement Analysis, Test Planning, Defect Categorization, Reporting, Test coverage, Pre-automation planning, Regression decisions and defect-tracking to closure, SDLC.
- Expertise in using SQL queries for fetching data from Database. Also worked with SQL and data conversions, Data mapping and data validation
- Versed in writing test scripts using VB-Script (QTP 9.2) to enhance script performance and writing test plans and strategies following Agile, RUP and Waterfall development methodologies.
- Fluent in Correlation, Parameterization, adding checkpoint with functional and Performance tools.
- Knowledge in FACETS EDI transactions.
- Experience in testing wireless/telecommunications middleware applications using HP QTP(UFT), XML, SOAP UI, Selenium, Jbehave, SQL, Putty, LDAP.
- Creation and execution of automated scripts using test script languages.
- Proficient in functional, regression, system, user acceptance, load, security, browser compatibility
- Expertise in testing legacy system functionality with mobile, web and cloud technologies.
- Used Rational query analyzer to write DB2 queries to check the data loads.
- Developed and generated test cases covering negative testing, database testing and UI testing.
- Hands on in executing batch jobs to load and validate the data at source and target systems including business rules
- Has experience in managing and governing the test data across multiple teams/projects involving in system integrated test environments.
- Hands on in setting up the goals for test data quality and track them to the closure for issues found.
- Experience in testing data transformation in real time and in batches to maintain data across different environments /Source Vs targets
- Extensive experience in database using MS-SQL, MySQL and SQL Server 2014, Oracle 11g.
- Experience in creating data models and use them during validation of data across systems in testing
- Monitor the health of systems for data quality issues and for profiling for performance of targeted systems.
- Logged, tracked and verified the defects using Clear Quest, JIRA
- Good Experience in ALM (Application Life Cycle Management) for bug tracking
- Analysis, Testing and Implementation in Mainframes Environment.
- Used Mercury Interactive test tools (Quality Center, Win Runner and QTP) for functional testing Process.
- Experience in Quality Management tools including Quality Centre and Test director for recognizing the priority and severity of the bug with in depth knowledge of the Bugs life cycle
- Hands on experience with HP tools Quality Center 10.0 and ALM11.0
- Strong interpersonal and organizational skills in addition to an ability to manage and lead multiple projects to succession with minimal supervision.
- Experience on Data stage for Automation Testing in Data ware House.
- Experience on Jmeter Performance tool.
- Experience on Rest Api using Postman.
- Solid experience using Oracle utility such as Toad and PL/SQL to develop and maintain stored procedures and triggers for data validation Expertise in backend programming using PL/SQL Stored procedures on databases like Oracle 9i, 8i, 7.x, DB2. Expertise with JDBC interface and OCI interface to Oracle and other databases.
- Experience with Data Warehouse testing- Data is extracted from various sources and the ETL process is performed and the data is loaded in the Data Warehouse.
- Experience on Data stage for Automation Testing in Data ware House.
- Managed projects using Extreme programming and Scrum process of Agile Methodology.
- Extensive experience on configuration management tools like JIRA, TFS.
- Extensive experience in leading development teams and helped define project scope, develop schedules, requirements, establish milestones, identify risks and define monitoring guidelines.
- Tracking and reporting on the status of projects to stakeholders.
TECHNICAL SKILLS:
Testing Tools/Framework: Quick Test Pro (QTP), JUnit & ClearQuest, Jbehave, Selenium.
Defect Tracking Tools: Test Director, Quality Center & PVCS Tracker, Git.
Scripting Languages: VB Script & JavaScript.
Web Technologies: J2EE (JSP, Struts, JDBC, XML), Java Beans, Struts Framework 1.1, JSF, HTML, DHTML, XSLT, Custom JSP Tags, ASP & VB
Languages: Java, C, C++, C#, Ruby, SQL, PL/SQL, Visual Basic, ASP & Assembly Language (8085, 8086).
Operating Systems: Windows 98/Professional/XP, Windows Server NT/2000, UNIX & DOS
Application Servers: BEA WebLogic Server, IBM WebSphere, Apache (Jakarta) Tomcat1.1, JBoss 4.0
Server Side Technologies: Servlets, Struts, JSFs, MVC Framework & Web Services
Internet Technologies: HTML, Web 2.0, XML, XSD, XSLT, CSS, JUnit, ANT, JavaScript & VBScript
OOA/OOAD Tools: Rational Suite (Rose) & UML 2.0
Development Tools: TOAD, JUnit, Ant, Eclipse, RAD & Knowledge in Selenium
Version Controls: CVS & Harvest
Protocols: TCP/IP, HTTP, RMI-IIOP & SOAP
Database/RDBMS: Oracle 9i & IBM DB2
Reporting Tools: Jasper Reports
Methodologies: SDLC & Agile/SCRUM.
PROFESSIONAL EXPERIENCE:
Confidential, Rancho Cordova, CA
Test Engineer, QA Automation Lead
Responsibilities:
- Review the Functional Design document and develop test data for manual testing.
- Involved in Regression, Functional, Database and Integration testing. Developed reusable automation scripts in standalone environment. Built scripts for Data driven tests and used Checkpoints, Built-in functions, User defined functions, Compiled modules and written SQL Queries to retrieve the data from the database.
- Involved in SDLC using Agile/Scrum Methodology, involved in SCRUM meetings.
- Developed, executed and documented the Test plan.
- Extracted data from oracle, SQL, Sybase databases using decision stream ETL and mapped data for building reports.
- Participated in Requirements review meetings and Setting up the Test Environment
- Involved in Designing and writing Test cases and Test Scripts.
- Used SoapUI tool for testing QTP for regression testing.
- Involved in Functional testing, Integration Testing, System testing, Security Testing.
- Conduct functionality testing during various phases of the application
- Quality Assurance, reporting and Running the selenium scripts for Regression testing
- Lead the Regression Testing Cycles for Each Release.
- Automation tools used were QTP and Selenium.
- Logging Issues and Defects tracking in Jira and driving them to closure.
- Involved in the back end testing using SQL Queries to verify the data integrity from the database.
- Written Complex SQL Queries to retrieve the test data from SQL Server.
- Validated the TPA/OE member contracts billing frequency in SAP.
- Validated the Open Enrollment (OE) member eligibility using REST services for OE.
- Log defects & generated status report for the developers & other team members.
- Worked closely with performance/Load team to validate the batch job performance.
- Created JBehave scripts to test the benefits for regression purpose.
- Performed the load testing on services and web UI using JMETER and SOUP UI testing.
- Developed Fixtures in Selenium and Java for Jbehave Framework for UI and Api Testing.
- Experience in testing data transformation in real time and in batches to maintain data across different environments /Source Vs targets
- Data is extracted from various sources and the ETL process is performed and the data is loaded in the Data Warehouse with Data stage tool.
- Used Data stage Tool for Automating Testing in Data ware house.
Environment: SOAP UI Pro 4.5, JIRA, TDB2, QTP, Java 2.0, JBehave, JMeter, MS Office 364, Excel, WinSQL, TDB2, Selenium, LDAP, Postman, Share Point, Main Frame. GIT Repository (check in and check out code).Maven, Jenkins.
Confidential, Sacramento, CA
Test Analyst Consultant
Responsibilities:
- Work to understand the requirements of the project and perform the functional testing using manual testing processes.
- Prepare Test Cases and Test Scripts that describe the features and functions to be tested.
- Manage, document and controlled all the Test Cases, Test Scripts and test results using MS Excel.
- Participate in Test Plan and Test Cases review meetings and perform backend testing using SQL queries to check backend data and data integrity.
- Utilize Clear Quest for defect tracking and RQM for running test scripts for Regression Testing.
- Contributed to System Test, Regression Test, Acceptance Testing.
Environment: Java, J2ee, QTP, Windows NT- XP, Clear Case, Rational Quality Manager (RQM), Clear Quest.
Confidential, Sacramento, CA
Senior Automation Consultant
Responsibilities:
- Actively review business requirements, IT design documents and prepared Test plan s for all assigned project releases.
- Expertise in writing SQL Queries and working with database tables.
- Execute testing for new functionalities based on test cases and coordinate defect fixes with development team.
- After successful release of projects, developed automation scripts using QTP and integrate the script with master script.
- Created advanced SQL Queries for testing Source and staging data warehouse tables.
- Ensure that all the test cases are updated in the Quality Center.
- Work as part of Automation Team using QTP, develop and execute test scripts.
- Test bug fixes and coordinate with developers to develop and coordinate release schedule.
- Track, review, analyze and compare results using Quality Center.
- Involved in Backend Database testing using SQL.
Environment: QC9.0, QTP 11.0, DB2, SQL, .Net, Windows NT- XP, TFS, Agile/SCRUM
Confidential, Roseville, CA
SQA Tester Consultant
Responsibilities:
- Work to understand the functional requirements of the projects and performed functional testing using manual testing process.
- Preparation of test cases, preparation of test plans that describes the features and functions to be tested.
- Executed test cases and reported bugs using Quality Center.
- Managed, documented and controlled all the test cases, test scripts and test results using Quality Center. Developed and maintained status update report using MS Excel.
- Participated in test plan and test cases review meetings.
- Performed backend testing using SQL queries to check backend data and data integrity.
- Executed testing of the entire process including reports and back-end data validation.
Environment: QC9.0, Java, J2ee, JavaScript, HTML, XML, Web Sphere, SQL, Oracle, Windows NT- XP.
Confidential, Harrisville, PA
QA Test Analyst Consultant
Responsibilities:
- Conducted manual testing of the application under test (AUT) using Quality Center.
- Created test plan, test cases and test scripts using Quality Center.
- Defined and performed the test and associated scripts for verification and validation.
- Performed backend Regression Testing using SQL statements to review the returned data and ensure that correct data was retrieved.
- Automated test cases for GUI, Functionality and Regression testing using QTP.
- Participated in weekly Review meetings and walkthroughs.
Environment: JBoss, JSF, Backing beans, JSP, XHTML,DB2, XML,PERL, Hibernate, JUnit, Life-Ray portal, IPSwitch, Putty, Qc 9.0, QTP 9.1 and JUnit.
Confidential, Camphill, PA
QA Test Analyst Consultant
Responsibilities:
- Analyzed the business requirements and functional specs documents
- Developed the Test Automation Methodology for manual testing of the entire application.
- Assisted QA Team Lead in writing the test plans and conducted manual testing to test the functionality of the application
- Conducted System Testing to test the whole business process manually.
- Involved setting up the QA Environment for Manual and Automation testing and worked to develop and document testing requirements, test plans, Test Lab and defects module in Quality Center.
- Wrote test cases to test the application manually in Quality Center and created testing requirements using Quality Center.
- Generated tractability matrices to ensure that all the requirements are covered by the test cases.
- Performed Backend Testing to ensure the authentic retrieval of the data from the database.
- Executed server side testing as well as client side testing to find various issues.
- Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using QTP.
- Developed test scripts for automation based on Data Driven Tests using VBScript as well as running these scripts for the Interface testing.
- Well versed in writing VB-Script (QTP) to enhance script performance.
- Tested 834 files and HIPPA Using XML.
Environment: QTP 9.2, Quality Center, Java, VBScript, VB.Net, ASP.Net, SOAP, XML, HTML, DHTML,UNIX, Windows NT/XP, MS Office Tools & SQL Server, Visio.
Confidential, Pittsburgh, PA
QA Test Analyst Consultant
Responsibilities:
- Analyzed system requirements and involved in developing test plan. Prepared detailed test cases by analyzing the business and functional requirements for manual and automated testing using QualityCenter.
- Prepared and executed test cases manually for different modules.
- Automated test cases for GUI, Functionality, and Regression testing using QTP
- Created Checkpoints in QTP to compare the behavior of GUI objects, components and to check for broken links in all modules.
- Enhanced QTP scripts by user-defined VBScripts.
- Involved in preparing scripts for User Acceptance Testing.
- Identified and documented defects (QualityCenter), questionable functions, errors, and inconsistencies in application functions, outputs, online screens, and content.
- Participated in Weekly Review meetings and Walkthroughs.
Environment: QualityCenter 9.0, QTP 9.1, Java, Java Scripts, Servlets, HTML and SQL server, Windows NT.
Confidential
Java/J2ee Developer Consultant
Responsibilities:
- Developed JSP pages and configured the various components of the application.
- Designed and developed Servlets and EJBs to implement business logic and deployed them on Weblogic Application Server.
- Used XML and used DOM parsers to parse the Data to the Legacy System and developed Front End using JSP, HTML, and JavaScript.
- Utilized Weblogic Application Server and JDBC for Data Access Objects and DB Connections from the Connection Pool using Oracle.
- Developed Business Logic and Presentation layers in Java, JSP and JDBC and created stored procedures and triggers for Oracle Database.
- Created database objects such as tables, views and indexes in Oracle
- Performed High Level Design and Detail Design and completed mapping of the business requirement to the technical specification and Detail design documents.
- Designed and integrated Web portal in Java J2EE Weblogic and used Interwoven to personalize content.
- Specified the procedures and services, data flow using XML and DTD and created and tested XML file, log tables.
- Wrote Schemas Parsers and developed Servlets and EJBs and deployed on Weblogic Apps Server 6.x.
- Used Visual Age Java for code development and developed GUI using JSP, HTML and DHTML.
- Created stored procedures, functions and triggers using PL/SQL.
- Wrote test plan, test cases, test scripts and prepared documentation.
Environment: Java 1.2, Structs, J2EE, EJB, Servlets, JSP, Weblogic Application Server 6.x, JDBC, XML Oracle8.1.7, XML, HTML, JavaScript, PL/SQL, Tomcat, Unix & Windows .
Confidential
Java Developer Consultant
Responsibilities:
- Contributed to the design and creation of Website using HTML, Java, and JavaScript etc.
- Created XML data source objects, to replace the data identifiers in the HTML template dynamically.
- Developed components that access the data from the database using Applet - Servlet communication (this is in case of Order form) and connecting to the database using JDBC and Servlets.
Environment: Java (JDK1.3), HTML, JDBC, Servlets & C++.