SUMMARY

• Over 7+ yearsof IT experience in various phases of IT projects such asTesting,developmentand applicationsupport.
• Expertise in creatingTest Plan,TestStrategydocuments andTraceability Matrices.
• Expertise in designing thetest scenariosand scripting thetest casesto test the application.
• Experience in developing the Manual Test Suites and Automated test suites.
• Experienced in SQA (SoftwareQualityAssurance) including Manual and Automated testing with tools such as Selenium RC/WebDriver/IDE/Grid,HPQuick Test Professional andQualityCenter,ALM, JIRA and SOAPUI
• Created and executed 100 - s of automated test cases using Selenium-WebDriver, Rubi API,Cucumberframework.
• Experience with building Gherkin (Cucumber) user scenarios and ruby scripting for automated testing (Selenium/Cucumber). Experienced on developing test scripts with Selenium to automate browser & web applications underCucumber(BDD) Framework.
• Worked closely with sales team and business analysts and performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects and Custom objects ofSalesForce.com (SFDC).
• Expertise in problem solving and bug tracking usingHPALM, Rational Clear Quest, and Test Director.
• UsedALMto plan tests, manage test assets, create and run manual and external scripts to check GUI and functional features of the AUT.
• Extensive experience in testing ofInvestment banking,Financial, andTelecommodels.
• Strong knowledge ofBusiness Intelligence,Data WarehousingandBusiness Architecture
• Strong working experience in the Data Analysis and Testing theData warehouseusing Data Conversions, Data Extraction, Data Transformation and Data Loading.
• Expertise on delivering an end-to-endtestautomationprojects with Selenium.
• Excellent hands-on expertise on designing and implementing thetestautomationframeworks and customize as per application landscape
• Experience with all phases of SDLC underV-Model, Agile methodology.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• AutomationtestCases review and executing theautomationscripts.
• Reviewing theautomationcode of the peers and identified and reported the bugs to QA (manual) team.
• Extensive experience with tools likeQTP,Load Runner,Win Runner.
• Performed Unit testing of reports writing SQL statement Confidential backend/DB and validating againstCognos
• Good experience in testing web based applications built on Java,J2EE,ASP.netand ASP.
• Good experience in writingSQL/PLSQLto data validation in migration as part of backend testing.
• Strong data base experienceTeradata,Oracle, MS SQL Server and Sybase.
• Good expertise in usingTOAD, SQL Plus and SQL Developer.
• Worked on Automation tools like Selenium-WebDriver, Appium,JBehave, Robot Framework, Device Anywhere.
• Experience in testing environment with various languages like java,C#, VB Script, Python, Ruby, SQL, PLSQL scripting.
• Extensive experience in Mercury Testing tools (Test Director, Quality Center) and Rational Suite (IBM ClearCase,IBM ClearQuest, Test Manager).
• Extensive experience in using Blue Prism and RPA supported technologies
• Experience using Bug Defect tools likeClearQuest and Defect Tracking and Reporting by means ofClearQuest.
• Experience in analyzingdefect severity, priorityand documentation and scheduling for the fix.
• Involved in implementation of Test Automation Framework build using Selenium WebDriver, protractor to handleAngularJS, TestNG and Maven technologies under Java platform utilizing industry leading harness design patterns and approaches.
• Experience in testing and writing complexSQL,T-SQLandPL/SQLstatements.
• Experience indebuggingthe issues by analyzing the SQL queries.
• Proficient in working withUNIXshell scripts usingputtyEnvironment.
• Good experience in working with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Experienced in Application Development usingPython, Hadoop, RDBMS and Linux shell scripting and performance tuning.
• Use SQL, Access and Visual Basic to codePowerPointReports and pull data from the reporting database.
• Wrote automation scripts using Java, Selenium Web driver,Groovy,Junit, Maven, and Cucumber.
• Experience in working on Robot framework and rational test manager
• Hands on experience withJavascript, HTML, CSS, XML, XPath, SOAP and REST web services API testing.
• Good experience in working with UNIX scripts in executing and validating logs for the issues.
• Involved inJob schedulingusingcorntab, monitoring the workflows, validating logs for the issues.
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

ETL tools: Informatica 8.6.1/8.x/7.x, DataStage, SSIS

Business Intelligence Tools: MS Office, Power point, Excel, word, Micro Strategy 8.x, Cognos 7.x, OBIEE 10.3.x, RoboticProcessAutomationRPA, SSRS

Programming Languages: SQL, PL/SQL, Java, C, C++, Python, ASP.Net, ASP3.0

Scripting Languages: HTML, DHTML, XML, Java Script, Shell Scripts

Databases: Oracle11g/10ii, Teradata V2R6/R5, MS SQLServer 2005/2008/2012 , Sybase

Database Utilities: TOAD, SQL Advantage, DBArtesan, Query Analyzer, Enterprise Manager, SQL Loader

Operating Systems: UNIX, HP Solaris and WINDOWS x

Testing/Bug Tracking Tools: Quality Center9.2, MS VSTF, QTP, Win Runner, Selenium, Jbehave, Robot Framework, Rational Test Manager, HP ALM, Cucumber, Excel, JAMA, HP Caliber.

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Mobile Tester

Responsibilities:

• Analyzed Business requirements and Functional documents, created the test strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
• In - depth understanding of Object Oriented Programming and skilled in developing automated test scripts in Java.
• Createdautomationframework and test scripts using Selenium Web-Driver for multiple platforms and browsers testing.
• Developedautomationtest cases, executed these test scripts.
• Configured Selenium Web Driver, Test-NG tools, and created seleniumautomationscripts in java using Test-NG prior to next quarter release.
• Performed functional testing to identify various critical points in the application and automated it by using Selenium Web-Driver with Test-NG.
• Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium Web Driver.
• Prepared user documentation with screenshots for UAT (User Acceptance testing) using Selenium Screenshots.
• Utilized Jama to conduct test cases and report bugs, as well as JIRA to log and validate defects
• Used Apache POI to read data from Excel sheet.
• Functioned as JAMA and SharePoint administrator for logging of Requirements, Test Cases, Defect, Risks and Issues.
• Performed continuous integrationautomationtesting using Jenkins.
• Used parameters, data provider Test NG annotations to perform regression and functional testing.
• Used Actions and Action classes for performing Keyboard and Mouse events.
• Used Firebug/ IE Developer Toolkit and Selenium IDE to capture and validate CSS Locators, HTML ids to identify elements.
• Performed Integration and Regression testing to check compatibility of new functionality with the existing functionalities of the application using Selenium.
• Reviewed database test cases per assigned Requirements to validate reports by retrieving data with complex queries using SQL Server.
• Designed data-driven testing framework in Selenium and captured data dynamically from web controls.
• Used automated scripts and performed functionality testing during the various phases of the application development using Selenium.
• Demonstrated ability to solve complexautomationchallenges involving Ajax, dynamic objects, custom object types, unexpected event handling.
• Involved in testing Web services and XML with tool called SOAP UI and using this tool to locate WSDL file on the internet, create Test cases and run them
• Developed test scripts to implement Test Cases, and features for Test Driven Development, Behavior Driven Development using Cucumber.
• Attended weekly status meetings with development and management Teams.
• Reported defects to the developer and discussed the issues in weekly status meetings.

Environment: Selenium IDE, Selenium WebDriver, Apache POI, Java, Jama, HTML, CSS, X-path, Windows, SQL, Maven, GIT, SOAPUI, Cucumber, TestNG.

Confidential, CA

Mobile Tester

Responsibilities:

• Designed Automation Test cases using Selenium WebDriver, Java, Junit, and Maven.
• Used Selenium Grid to run test cases in multiple browsers and Platforms.
• Responsible for implementation of Hybrid Test Automation Framework, Page Object Model using Selenium WebDriver, TestNG and Maven and Java.
• Validating the interaction between AVAYA and the differentIVRplatforms, including the IB calls flow on the intended telephony switch behavior for user's calls during business and closed hours.
• Managing the System testing across multiple projects driven in variousIVRplatforms
• Developed automation script forMobileNativeapplications(IOS, Android) using Appium, Java.
• Used emulators and IOS simulators to perform the manualMobileTesting.
• Use JAMA test management tool to manage test plans, test case, test case execution, test reporting and logging defects.
• Implement modules intoNodeJSto integrate with designs and requirements.
• Uses python to develop Automation framework to Validate RESTful Web Services.
• By using the Appium, java developed the automation script for themobileapplications.
• Strong experience with SOAP UI architecture which include SOAP UIand Restful Web Services Testing.
• Developed tools usingPython, Shellscripting, XML to automate some of the menial tasks.
• Developed automated and detailed test scripts for Inventory core mobile and web product using Selenium WebDriver and Appium in Robot Framework.
• Validated Selenium Grid 2.0 distributed testingharnessand fully implemented company - wide for paralleltestexecution.
• Performed web services testing with SOAP UI by validating request and response for XML, JSon files.
• Created automated scripts using Web Services, SOAP UI, and XML.
• Experienced in scripting of automation tests usingC#with Selenium.
• Used RationalClearQuest as a Bug Reporting Tool and to track, analyze defects
• Experience in web andmobileapplicationstesting with Selenium IDE, Selenium RC, Selenium Grid and Selenium WebDriver, Appium (iOS/Android), JUnit and TestNG, Cucumber, Jenkins.
• Used Appium for tracking test execution results within testing tool.
• Used Appium for analyzing and defining existing business processes and inter-dependencies.
• Good Experience in Agile methodology with SCRUM Process for the product development.
• Experienced in continuous integration using JENKINS to support tools likes CVS subversion, GIT and execute Apache ANT and apache Maven.
• Created Afterhours test cases to test the functionality ofIVRduring afterhours.
• Used Test driven approach for developing the application and Implemented the unit tests usingPythonUnit Test framework, have worked on sub version control tools like GIT and SVN.
• Responsible for creating automated test scripts using the jmeter andLoadrunnertest tool for testing the performance on the control applications and executed the scripts inLoadcontroller.
• Involved inmobileTesting Pro helps in an easy way to usemobiletesting device cloud that gives you access to hundreds of realmobiledevices on real carrier networks located around the world.
• Performed Back end testing using SQL queries to make sure that data entered has been uploaded correctly into the database tables.
• AutomationtestCases review and executing theautomationscripts.
• Reviewing theautomationcode of the peers and identified and reported the bugs to QA (manual) team.
• Developed test code in Java language using Eclipse, IDE and TestNG framework.
• Involved in Maven configuration for running servers and scripts after the build.
• Prepared manual & functional test cases on web andmobileapplications(Apple & Android) as per requirements.
• Used Jenkins as continuous integration server to run automated test suites.
• Used web-debugging tools like XPath, Firebug and Firepath to locate elements.

Environment: Selenium WebDriver, Jenkins, Cucumber, SOAP UI, Python, Maven, Appium (Android), Fitnesse, TestNG, IBM ClearQuest, IBM Clear case, C#, .net, Angular JS, Cognos, Node JS, PythonScripting, Eclipse, HP Quality Center (ALM) 11.0, Java, Jama, Android, MS SQL Server, JMeter, Protractor.

Confidential, NJ

QA Automation Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing. responsible for helping to capture business requirements, identifying appropriate data sources, data quality issues, business transformation rules, mapping source to target
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Developed and designed automation framework usingPythonand Shellscripting.
• Developed monitoring and notification tools usingPython.
• Used Test driven approach for developing the application and Implemented the unit tests usingPythonUnit Test framework.
• Executing test scripts to verify actual results against expected results by using Informatica Power Connect for different source validations.
• Improving maintainability and design of legacy code by integrating a JUnit testharnessand refactoring
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Responsible for creating automated test scripts using the jmeter andLoadrunnertest tool for testing the performance on the control applications and executed the scripts inLoadcontroller.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Involved in Development, Unit Testing, White box, Integration, Regression and Performance Tuning and End-To-End testing.
• Understand business rules and provide an effectiveprocessand procedural solutions by implementingRoboticProcess Automation(RPA) solutions.
• Implementing PEGARoboticsProcessAutomation(RPA) tools into the Commercial Cards Application
• Implemented integration test, andJBehavetest
• Involved in Problem solving and creating Bug Reports using Bug Tracking Tools like Quality Center and RationalClearQuest.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from staging tables into Data warehouse tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Mappings
• Tested the ETL Workflows and other ETL Processes Data Warehouse Testing
• Createautomationframework (combination of Data driven framework and Linear framework)
• Create and execute automated test scripts/plans using QTP, analyze the results of Automated test scripts/plans.
• Maintain Automated test scripts (i.e. Update/Delete the test scripts based on the requirement changes).
• Tested the ETL process for both before data validation and after data validation process. Tested the log messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using Query Studio
• Worked on data Re-conciliation in Source System by writing complex SQL queries, and historical data load using SQL Loader scripts
• Experience in creating UNIX scripts for file transfer and file manipulation.
• AutomationtestCases review and executing theautomationscripts.
• Reviewing theautomationcode of the peers and identified and reported the bugs to QA (manual) team.
• Tested the reports using Micro strategy ETL tool and observed the results of the report with correct data population.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Responsible for meeting and interacting with users and stakeholders to identify problems in UAT, and resolve issues to improve the whole business process to help ensure stable and accurate solution
• Implemented and extensively used the Object-Oriented programming concepts in C# and ASP.Net4.0.
• Tested whether the reports developed in OLAP are as per company standards.
• Created sql queries totestthecognosreports and their performance.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Prepared test cases for data validations between Data Mart to data cubes, involved in raising bugs and bug tracking analysis to resolve issues.

Environment: Informatica Power Center 8.6.1, Micro strategy8, Cognos 7, Oracle 11g/10i, SQL, OLAP, PL/SQL, Python, UNIX, Java, IBM ClearQuest, IBM Clear case, C#, .net, VSS, Java Script, PythonScripting, Angular JS, Node JS, MS office, Windows, Jbehave, Quality Center 9.2.

Confidential, PA

QA Engineer

Responsibilities:

• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Writing the complex T-SQL queries with the basis of PDM-PDDM mapping document.
• Tested the build related scripts as part of the ETL process, automate the process of loading, pulling the data.
• Executed tests for Full pull and the incremental/delta pull scenario's.
• Compared and Tested Source data with target Output data.
• Shown strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experienced in data analysis using SQL, T-SQL and many other queries based applications.
• Tested the reports using MS SQL Server 2005 and observed the results of the report with correct data population.
• Developed automated and detailed test scripts for Inventory core mobile and web product using Selenium WebDriver and Appium in Robot Framework.
• Create Manual Test Suites for various modules, tested data warehouse ETL process using SSIS Integration Service.
• Involved with ETL test data creation for all the ETL mapping rules, Involved in testing stored procedures views in MS SQL Server 2005 and OLAP Cubes by MDX.
• Involved in validating Compare and Test Source data with XML Output flow.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Reported bugs and tracked defects using Microsoft VSTF.
• Responsible for writing spock unit test Integration Testing, andJbehave(BDD).
• Extensively worked with developing test scenarios using complex Multi-Dimensional expressions' MDX for data cubes.
• Prepared test cases for data validations between Data Mart to data cubes.
• Involved in raising bugs and bug tracking analysis to resolve issues.

Environment: MS SQL Server 2008, SSIS, SSRS, OLAP, XML, XSD, XSLT, Python, Flat Files, MS Excel, Java Script, VSTF, METaL, SFTP, Jbehave, Selenium, Reports, HP Quality Center (ALM) 11.0, ETL testing

Confidential, New York, NY

QA TESTER

Responsibilities:

• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Captured requirements and enforced standards in HP Quality Center/ALM.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Loaded data from operational data store ODS to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, with fact tables and dimensions/lookup tables.
• Detected Defects, communicated to the developers using Bug Reporting Tool and Tracking the Defects using Quality Center tool. - Extensively used Quality Center / ALM for test planning, bug tracking and reporting.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Worked with ETL group for understating for data loading for both dimensions and facts.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in testing complex stored procedures, functions and Materialized views in Sybase database
• Written SQL/PLSQL to data validation in migration as part of backend testing.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Used FTP and Telnet protocols to migrate files to heterogeneous Operation systems like UNIX, Linux and windows.
• Played a lead role in developing Test Cases in a spreadsheet and uploaded them to Quality Center Test Plan module and executed them in Quality Center/ALM test lab for various source systems.
• Worked with UNIX scripts in executing and validating logs for the issues.
• Developed Test cases inHPQualityCenter/ALMand executed the test cases in Test Lab module ofQualityCenter.
• Identified defects and monitored resolution via defect tracking toolHPQualityCenter/ALM.
• Reported bugs and tracked defects using Quality Center 8.0 Test Director
• Extensively used SQL to verify and validate the data load.
• Created behavior-driven automated test scripts using Selenium WebDriver, Appium and Java inJBehaveframework.
• Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Involved in extensive DATA validation using SQL queries and back-end testing
• Performed the tests in both the SIT, QA and contingency/backup environments
• Writing the test scripts for manual testing.
• Worked on environment issues, Compatibility checks after post migration of applications to Unix to Linux
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing
• Involved in Front to Back testing for all European and Asia pacific regions
• Preparing and supporting the QA and UAT test environments

Environment: Informatica 7, Cognos TOAD, Oracle 10g, Sybase 12.3, HP Quality Center (ALM) 11.0, Selenium, Jbehave, JMS, J2EE,PuTTY, UNIX, Perl

Confidential, Baltimore, MD

QA Engineer

Responsibilities:

• Created Test Plan and developed a test strategy for Clear Vision 3.4.3 data warehouse
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems
• Experience in analyzing defect severity, priority and documentation and scheduling for the fix.
• Experience in release management and defect control management.
• End to End responsibility to close the defects and fixes.
• Tested stored procedures views in Sybase 12.3
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written SQL/PLSQL to data validation in migration as part of backend testing.
• Worked with Perl and UNIX shell scripts. Worked with releasing scripts live and tested.
• Worked with EAI tool to validate XML Messages before ending to TIBCO queue and TIBCO topic.
• Tested several Java Beans for setting up drivers to connect Legacy Systems and developed several Java class files for interacting with TIBCO Message Bus and JMS Header, also developed several web reports using Java Server Pages and Struts.
• Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
• Tested several Java programs for interacting with TIBCO EAI Message Bus and worked with interacting JMS Header and Instrument data.
• Responsible for testing TIBCO stage Queues to send XML messages to TIBCO Bus.
• Tested several XSD's for setting up standards for TIBCO Bus Message Formats.
• Involved in Functional testing, End to End testing and Regression Testing.
• Used FTP and Telnet protocols to migrate files to heterogeneous systems like UNIX and windows.
• Worked with UNIX scripts in executing and validating logs for the issues.
• Compared and Tested Source data with XML Output flow.
• Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported bugs and tracked defects using Quality Center 8.0 Test Director
• Extensively used SQL to verify and validate the backend.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing
• Preparing/Upgrading and supporting the QA and UAT test environments
• Assisting users in UAT, and re-testing and delivering quick fixes.

Environment: GL ClearVision3.4.3, Oracle 9, Sybase 12.3, J2EE 1.4, TIBCO, HP Quality Center (ALM) 11.0, C, ETL Informatica 7.1,PuTTY, UNIX, Windows, SQL Advantage.

Confidential

Java developer

Responsibilities:

• Involved in Development of master screens like Service Requests, Change Requests Screens.
• Design architecture following J2EE MVC framework.
• Developed interfaces using HTML, JSP pages and Struts - Presentation View
• Developed Struts Framework and configuring web.xml and struts-config.xml per the struts framework.
• Developed and implemented Servlets running under JBoss
• Used J2EE design patterns and Data Access Object (DAO) for the business tier and integration Tier layer of the project
• Used SOAP and REST Web Services to communicate with different applications.
• UsedJavaMessage Service (JMS) for reliable and asynchronous exchange of important information between the clients and the customer
• Designed and developed Message driven beans that consumed the messages from theJava message queue
• Development of database interaction code to JDBCAPI making extensive use of SQL Query Statements and advanced prepared statement, Tested Web Services using SOAP UI toolkit locally.
• Taken care of completeJavamulti-threading part in back end components.
• Inspection/Review of quality deliverables such as Design Documents.
• Wrote SQL Scripts, Stored procedures and SQL Loader to load reference data.
• Used Web Services for interacting with a remote client to access data.
• Fixed the bugs identified in test phase, Used Junit for testingJavaclasses.
• Used Ant building tool to build the application, Performed Unit Testing and Regression testing.

Environment: J2EE (JavaServlets, JSP, Struts), MVC Framework, Apache Tomcat, Oracle8i, JMS, SQL, HTML, SOAP, REST, JDBC, EJB, ANT, Junit.