PROFESSIONAL EXPERIENCE:

Confidential

QA Lead / Manager

Responsibilities:

• Responsible for developing long range test planning and test environment readiness, hiring test resources, developing test methodologies, system test plans, identifying release items in separate Sprints, completing test preparation for each Sprint, identifying test scenarios and test data and performing test case reviews. Performing and monitoring execution of test scripts as per schedule. Creating test metrics and provide test reports to higher management. With the test team complete end - to-end System testing, Functional testing, Regression testing, User Acceptance Testing, Smoke testing, GUI testing.
• Overcame understaffing crisis by designing automated tests to regression test and maximize test coverage and avoided delay for key deliverables.
• Supervised 3 to 9 testers.
• Developed and maintained automated test cases using QTP functional testing tool.
• Created regression test suite and comprehensive test data using QTP.
• Developed test tools using QTP scripts, SQL server stored procedures and MS Access applications for validation of large quantity of application data.
• Migrated QTP scripts to UFT 12. Redeveloped UFT automation suite in Selenium web driver and Java.
• As automation architect, create data driven, reusable and robust automated test suite using Java, Python, Eclipse, Selenium Web Driver, Excel and SQL Server.
• Automated test scripts are written for testing web applications or for validating large quantity of production data.
• Extensively used xpaths, multi-browser switching, popup handling and solved automation related issues using other tools like Autoit, jxl, Swing, jdbc etc.
• Created various utilities for validating large amount of data and content as per business needs.
• Implemented Java based automation framework for test suite for Regression Testing and Smoke Testing of the entire SNS system - solid
• Knowledge of Agile and Scrum software development - solid
• Continuous Integration (CI) toolsets such as TFS, Chef, Jenkins, Maven, Nexus
• Virtualization experience - Limited to virtual storage and server
• Migration to SNS cloud
• Knowledge of automated scripts using Ruby and Cucumber.
• Working on testing Angular js and Couchbase database.
• Used automated scripts to validate large quantity of production ETL data and generated error reports for development team.
• Developed lots of backend automated scripts using Java and jxl to compare thousands of records in CSV and xml data files from various state agencies with data in SQL Server database. These scripts test data loading according to business rules.
• The data validation scripts and reports made possible high test coverage and finding data related defects which are impossible to find manually.
• Also created variety of automated scripts for data extraction, comparison and reporting of web content.
• Developed Java programs to compare the data between various databases.
• Provided guidance and helped to resolve automation type issues for internal and external teams.
• As a backend tester, develop and execute SQL queries extensively for backend testing using SQL Server Management Studio. Reported and tracked defects in TFS. Also performed ETL data verification, Data Migration testing, Mobile testing, IVR testing, 508 testing. Performed back end testing of SQL data base, xml, server logs, web service testing, SOAP UI.
• As an analyst, perform Requirement Analysis, Data Analysis and identified business rules for best customer experience.

Skills Utilized:

• Selenium 2.0 WebDriver, Java 1.7 / 1.8, JUnit, JavaScript, xpath, Eclipse, JXL, AutoIT, Hibernate, framework design - 4 years
• Expertise in XML schemas, SQL Server, SOAP Web services, and other related technologies - 8 years
• Knowledge of technologies like .net based web applications, cloud migration, Amazon Web Services, FAST and SOLR based search engine, mobile applications, SSAS based trend reporting system and analysis, SQL Server OLTP and Reporting Database, Biztalk based data extraction and loading (ETL) from various sources, creating large FOIA downloads, large volume of data extraction (ETL) based on specific needs, IVR and call center applications, MS MQ, SharePoint - 8 years
• QTP 12, Visual Studio 2012, TFS 2013, ASP .Net, Windows Server 2003, IIS, VBA and Excel macros, SSMS, SSRS Reports - 8 years
• C#, Ruby and Cucumber - 1 year

Confidential

Lead Automation Engineer

Responsibilities:

• Developed automation tests from scratch using Java, Eclipse, Selenium, Excel and SQL Server.
• Created Selenium scripts to validate migration of thousands of sites to Office365. The scripts compare between Jive and Office365 (and also SQL Server database) to validate various migrated items like sites, permissions, Social Groups, Projects, Documents, Discussions, Tasks, Tags, and Widgets etc.
• Provide Excel reports from automated scripts to the development team and to the client.
• Apart from the above, also wrote scripts to extract content from all Jive sites as well as update data in migrated sites.

Skills Utilized:

• Selenium Web Driver, Java, SharePoint in Office365, Jive. - 6 months

Confidential

Senior Quality Assurance Engineer

Responsibilities:

• Performed back end testing and defect analysis at Confidential, Atlanta. Test releases related to store systems like Point of Sale, Tandem back end systems, Inventory Management, ETL and mobile devices. Test .NET based thick client applications, SQL databases, XML data files, SOAP services, SSRS and Crystal Reports etc.
• Created detailed test approach document and identified test cases and SQL queries for testing software releases for POS and other related systems.
• As Performance Tester, gathered performance requirements, created test plans and performance scripts using LoadRunner, executed test scenarios and analyzed performance test results. Created test scripts using LoadRunner Web and Web Services protocols.
• As ETL tester, performed test planning, test script development and test ETL data. Created MS Access application to validate the output of the ETL graphs.
• Supported the test team by creating test data. Developed test tools for the test team. Created VBA tool to verify 'balancing' of the daily sales data.
• Contracted through Modis

Skills Utilized:

• Informix, Tandem Nonstop SQL, Unix, SSRS, LoadRunner, MS Access, VBA, Mobile devices. - 2 years 5 months

Confidential

Quality Assurance Analyst / Programmer

Responsibilities:

• As testing and test support engineer, designed, developed and maintained many database tools using Microsoft Access, VBA and DB2 that were extensively used by the development and test team in distributed locations. Supported team of 80 testers with data extraction and test data preparation. Created Accounts Reservation System that was used by multiple teams of testers to search test data and reserve the accounts for their test. Created and maintained VBA program that created many types of EDI files for testing.
• Performed system testing, user acceptance testing and market testing. Performed testing related to EDI transactions in SeeBeyond Gateway application. Tested processing of EDI transactions through Java / Oracle based Gateway software. Tested Mainframe data files, DB2 data, online and batch program changes and JCL changes.

Skills Utilized:

• IBM Mainframe, JCL, DB2, IMS, EDI, Oracle, VBA, MS Access. - 4 years