SUMMARY

• Over 8+ years of IT experience in the Manual Testing, ETL and Automation Testing using Selenium.
• Expertise in Functional testing, Automation using Selenium IDE and Selenium WebDriver using Junit/TestNG testing framework.
• Experience in Manual and Automation Testing of Web Services/Mobile Apps, Client Server and Web based Applications in different domains using QTP, SOAP UI, ALM and Selenium.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Involved in Salesforce CRM Lightning Testing.
• Administered multiple Salesforce.com instances in Sales Cloud, Service Cloud and Marketing cloud.
• Used Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files
• Solid Back End Testing experience by writing and executing SQL Queries.
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Involved in Preparation of Test Procedures, Test Scenarios, Test Cases and Test Data. Tested the company's Salesforce CRM application.
• Good knowledge of Project Management Methodologies like Agile Scrum/Kanban, Waterfall.
• Experience using MicroStrategy tool suites including Desktop, Intelligence server, Distribution Services, Object Manager, Architect and Web.
• Experienced with SOA, Web Services, SOAP, Soap UI, Postman, RESTFUL, WSDL technologies.
• Designed and developed UI using JSP, dynamic JSP and page validations using JavaScript.
• Hands on experience in Quality Assurance including Functional, System, Smoke, white box, Black box testing, Regression, and Integration, User Acceptance Test (UAT) and Compatibility Testing of Web and Client server - based Applications.
• Experience in developing Automation scripts using TestNG framework.
• Involved in gathering customer requirements from business user teams spread over the Sales, Marketing and Service cloud.
• Proficient as Mobile App Tester in testing Web applications and Mobile applications on iOS and Android Platforms.
• Identified, analyzed, and documented defects utilizing JIRA and CA Rally.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports.
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved in the meetings with Product owners, Business and Stake holders in the planning sessions.
• Demonstrated the developed features to Business and Stake holders.
• Involved in the triaging the production Issues and finding the root cause.

TECHNICAL SKILLS

Testing Tools and Environment: Selenium Web Driver/IDE, Mercury QTP 12.0, HP Quality Center, JMeter, Cucumber, XPath, Firebug, Fire Path, SoapUI, Microsoft Visual Studio, HP UFT, Salesforce Sales Cloud and Salesforce Service Cloud, Workbench, Dataloader.

Programming/Scripting Languages: Java, JavaScript, Shell Script, Apex, VB Script, Python, Django, HTML and XML

Frameworks: Junit, TestNG, Appium, TDD, Data Driven, Keyword Driven, Hybrid and Modular Frameworks, Cucumber, POM, Backend Testing

Testing: Integration, Functional, Regression, Performance and Load Testing, Manual Testing, Black Box Testing and White Box Testing

SOA Technologies: REST, SOAP, WSDL, Web Services and Postman, Swagger, SOAP UI.

Bug Tracking Tools: CA Rally, Jira, HP Quality Center

Methodologies: Agile (Scrum and Kanban), Waterfall, Spiral

ETL Tool: Informatica Power Center

Build CI/CD Tools: Maven, Jenkins, Atlassian Bamboo, Ant.

Source Control: GIT, Source Tree

Databases Technologies: MS SQL Server, Oracle, MS Access, Oracle PL/SQL, TOAD, MYSQL, Teradata

Operating Systems: Mac, Windows

Web Technologies: HTML, XML, CSS, JavaScript, Python

PROFESSIONAL EXPERIENCE

Confidential, Carmel, IN

Software Test Engineer

Responsibilities:

• Understanding the Requirements, Estimating the Tasks, Design and Analysis.
• Responsible for Manual Testing and Automation Testing using Selenium.
• Development of Automation test scripts in Selenium, Debugging of scripts, Execution of Automation test scripts, Test Summary reporting and Defect logging and Tracking.
• Design and Develop automated test scripts in Java to test frameworks with reusable code in Selenium, Fluentlenium using IntelliJ IDE and Maven Tools to support business initiatives related to Account Management running on Salesforce Sales Cloud.
• Involved in gathering customer requirements from business user teams spread over the Sales, Marketing and Service cloud.
• Involved in Preparation of Test Procedures, Test Scenarios, Test Cases and Test Data. Tested the company's Salesforce CRM application.
• Develop and verify Web services API requests, SOAP Protocols intensively using Postman tool to frequently input web methods (GET,POST,PUT,DELETE), include, Batch, OAuth and OAuth2authentication etc., validate the response, response time and error codes.
• Able to use the request forms like HTML, JavaScript’s, JSON and XML in the request body.
• Involved in automating application on different mobile Platform such as iOS and Android devices using Appium and automated CI/CD pipeline application deployments.
• Have experience in validating the business transformations by writing complex SQL queries.
• Perform functional testing, unit testing, smoke testing, integration testing, sanity testing, regression testing, system testing, GUI testing, back-end testing, browser compatibility testing based on requirement specification.
• Developing SQL queries and perform backend testing to maintain the integrity of data in SQL Server and perform the functional, performance, scalability tests, retry logic with failover tests on SQL Server Management Studio.
• Good knowledge in Data Loader and Workbench to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.
• Construct SOQL Queries to specify the source object, a list of fields, to retrieve, to read and record saved data from Salesforce.
• Strong testing skills in Salesforce Mobile App, Salesforce standard object, custom objects, custom fields, page layouts, custom Tabs, Reports and various other components as per application requirements.
• Develop and execute automated Regression tests suites before every Sprint releases and Hotfix releases.
• Deploy and run automated tests in Test and UAT environments through Continuous Integration and Continuous Deployment (CI&CD) by configuring GitHub and Jenkins.
• Develop test scripts using SOAPUI, POSTMAN, build XMLs to validate service calls between the applications and validate the xml responses, and generate Custom HTML Reports for each run.
• Document release notes and Demo, train business users with new features or functionalities added to the system.
• Extensively written SQL for ETL and Reporting Testing.
• Responsible for developing common scripts for cross platform testing to use on both Android, iOS.
• Responsible for Web cross browser testing using Selenium, TestNG, Maven.
• Developed Rest assured framework to automate scripts in java for Rest API’s to verify API request and responses.
• Used JavaScript to run pages of the application.
• Build test suite using postman and imported collections to write individual tests and analyze results and run reports together.
• Executed and monitored Rest API requests using Swagger a and to understand the end points for testing.
• Perform testing to ensure that the systems work as expected developed from the scratch and influence the inclusion of testability during design and development phases.
• Wrote many SQL scripts to verify data in the DB and verify consistency with application UI.
• Test Management tool Rally is used to prepare test cases, and to extract testing status and Defect tracking.
• Experience in setting up test environment for automated script execution using Java, Appium and TestNG.
• Developed automation scripts for Mobile Native applications on iOS and Android platforms using Appium and Java .
• Involved in the meetings with Product owners, Business and Stake holders in the planning sessions.
• Demonstrates the developed features to Stake holders and Business in the Sprint Review meetings.
• Identified, analyzed, and documented defects utilizing JIRA, Rally and ServiceNow.
• Involved in the triaging the production Issues and in finding the root causes.

Environment: Selenium, FluentLenium, Salesforce, Apex Language, IntelliJ IDE. Postman, SoapUI, Java, Web Services (Restful, SOAP), Microsoft SQL server Management Studio 17, VMware, Swagger, TestNG, Cisco VPN, DC/OS, CA Rally, Stash, SourceTree, Appium, Telerik Test Studio for APIs, Bamboo, PLSQL, JavaScript, HTML, GIT Repository, Jenkins, VMware, Maven, Agile, JUnit, SOQL.

Confidential, Chicago, IL

SDET- Software Development Engineer in Test

Responsibilities:

• Worked in Agile environment by following two-week sprint methodology.
• Created and executed manual smoke, functional, regression, system, black box and white box testing, integration and exploratory tests in TestRail and mapped to automation scripts.
• Performed regression testing and functional testing using UFT.
• Responsible for testing application strength or to analyzing overall performance under different load types using JMeter.
• Developed automation scripts for Mobile Native applications on iOS and Android platforms using Appium and Java .
• Tested Visa Checkout cloud-based mobile application across multiple platforms touching the full stack across the web.
• Automated test scripts and integrated them using Perfecto to simulate real usage of apps on various platforms and browsers.
• Analyzed requirements and use case documents and worked closely with client architects and formulated design for the individual modules and prepared Technical design documents.
• Automated test scripts that are compatible for Android and iOS platforms and involved in cross mobile platform testing using Appium.
• Integrated Database for rest assured framework to validate API requests and responses and to select, insert, modify/update, delete data.
• Created and Maintained Server-side Integration Test using Python and Selenium Web driver.
• Used Python for dynamically generating property list for every application. Automated data movements using python scripts. Creating core python API which will be using among all modules.
• Generated Python Django forms to record data of online users and used PyTest for writing test cases.
• Developed and Consumed RESTful APIs for Web based applications using Python and Django.
• Implemented Data Driven Frameworks to create parameterized test scripts and generate test reports using Selenium Web Driver and TestNG framework.
• Automated test scripts and integrated them with Perfecto on different mobile platforms and web browsers.
• Used ALM as the test repository and used it for executing the test cases, scripts and logging.
• Responsible for creating and enhancing Test scripts to test functionality using QTP.
• Evaluated, executed and debugged automation scripts using UFT for regression testing.
• Created and managed UFT Test Scripts based on the Requirements and Scenarios.
• Tested Mobile app’s behavior under various interruptions battery strength, incoming calls, SMS, video calls.
• Performed the overall responsibility of modules and worked with other developers and ensured smooth delivery.
• Logged and tracked bugs using JIRA and involved in release support.
• Enhanced Test cases using Java programming features and TestNG Annotations
• Tested Web Services, XML and SOAP and Restful services using SoapUI tool.
• Validated WSDL request and response XML. Added Assertions to validate the response xml with database using SoapUI.
• Used Junit to run cucumber feature and scenarios and generate report on daily basis.
• Extensively used Jira Software to organize stories (requirements), tasks and tests plan and track iterations (sprints) and releases.
• Verified Web services API request, response data validations in REST, SOAP protocols.

Environment: Java, CSS3, HTML, Eclipse, Cucumber, UNIX, Jenkins, Source Tree, GitHub, Postman, ALM, UFT/QTP, SOAPUI.

Confidential, Charlotte, NC

QA SQL Tester

Responsibilities:

• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Ensured that the mappings are correct and Conducted data validation testing.
• Configured Quick Test Professional (QTP) with ALM/HP Quality center.
• Worked with business analyst and developers in setting up test data.
• Tested MicroStrategy reports for business reporting needs.
• Tested dashboards using MicroStrategy for business analysis.
• Extensively test the reports for data accuracy and universe related errors.
• Used Microsoft SQL Server Management Studio for Querying the SQL Server database for data validation and data conditioning.
• Used SQL tools to run SQL queries and validate the data loaded into the target tables.
• Validated the data of reports by writing SQL queries.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Tested both conditional formatting and threshold level testing for several reports developed in MicroStrategy.
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling.
• Developed test plans, test cases and test scripts for data validation testing.
• Extensively used HP/ALM Quality Center and created Test Cases in the Test Plan according to the specifications.
• Interacted with developers to report software bugs and re-tested the fixed issues found during Regression testing and UAT.
• Created User Documentation for SQL Query &Developed strategy to execute the same in sequence.
• Coordinating with DBA team for DB trace and workflow system.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Handled various P&C Insurance Modules like Policy, Billing, Document Solutions, Claims, and WIP etc.
• Validated flat files coming from downstream systems and mocked up feed files by using vi editor.
• Loaded data into Oracle using SQL loader and validated data
• Worked on ALM/HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And used HP Test Director to manage and track defects.
• Developed Test Data Matrix and attached to the Corresponding Test Case.
• Written SQL Queries and executed them using TOAD and SQL Editor.
• Written several complex SQL queries for validating Cognos Reports.

Environment: HP ALM/Quality Center 11, XML, UNIX, Flat Files, MicroStrategy, QTP/UFT, ALM Quality Center, SQL, XPath, XQuery, PL/SQL, TOAD, Win SQL, TERADATA, Oracle 11g, Agile, MS SQL Server 2008, Windows, Mainframe, Agile, Cognos.

Confidential

QA/ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Created test data for testing specific Membership functionality.
• Worked on various types of testing, such as Smoke, Functional, Integration, Backend, Black box, Systems, End to End, Regression.
• Tested request and response XML's based web services interfaces using Soap UI.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Extraction of test data from tables and loading of data into SQL tables.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with data validation, constraints, source to target row counts.
• Developed automated Test Scripts using QTP.
• Used data conversion to protect the data and prevent data loss.
• Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access.
• Created macros to automate the process of refreshing the data in MS Access.
• Provided technical support and coaching to team members about functionality of MS Access.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Used Quality Center to track and report system defects.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: DB2, Java, SQL, Oracle, Soap UI, Toad, XML, XSLT, UNIX, Shell Scripting, Agile, QTP, Unix, Quality Center 8.2, MS Access