PROFESSIONAL SUMMARY:

• Over 6+ years of experience with expertise in Manual/Automated Testing of Web based and Client/Server applications.
• Extensive experience and understanding of various phases of Software Development Life Cycle (SDLC) and Testing Life Cycle.
• Skilled in constructing Web applications, Input graphs, JavaScript, CRM Data, and Web scraping scripts using Java and .net
• Hands on experience in understanding the Requirements, Analysis and Designing of Test Plans based on those requirements.
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experienced working for Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Consolidation, Data Standardization and Data Quality for various business data feeds.
• Proficient in using testing tools such as Quality Center, Load Runner and Quick Test Professional for web - based and client server applications.
• Extensively used Datastage for extraction, transformation and loading process.
• Salesforce allows advanced tests directly in Java that run on the Selenium framework, allowing you to do things like querying the database to verify the results of the interaction, cleaning up data, etc.
• Adept in documenting defects with high level of detail, accuracy, and informative recreation steps using Test Management and defect reporting tools like Quality Center/ALM, JIRA and Bugzilla.
• Expertise in Smoke Testing, Backed end Testing, Black-Box Testing, User Acceptance Testing (UAT), Functional Testing, Positive/ Negative Testing, System Testing, Regression Testing, GUI Software Testing, Ad-hoc Testing, Boundary Value Testing.
• Defect Management using bug tracking tool like JIRA, HP Quality Center (QC).
• Experience in Scrum, Iterative and Agile methodologies.
• Experience in writing complex database queries, stored procedures, and triggers using SQL, SQL*Plus, PL/SQL. Strong Skills in Database Design, Process and Data Models.
• Experience with Mobile testing simulator and Perfecto Mobile.
• Effective problem solving skills, outstanding interpersonal skills, good in written and verbal communication. Ability to work independently as well as within a team environment.
• Driven to meet deadlines, motivated to produce robust, high-performance software.
• Experience in testing various ETL processes developed using Informatica PowerCenter, DataStage and also various reports generated by Cognos and OBIEE.
• Proficient in SQL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Hands on experience in both Waterfall and Agile QA methodologies.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
• Highly motivated team player with analytical, organizational and technical skills, unique ability to adapt quickly to challenges and changing environment.

PROFESSIONAL EXPERIENCE:

Languages: Java, C#, HTML, XML, SQL, PL SQL, Python

Automation Tools: SoapUI, UFT, LeanFT, Selenium

Scripting Languages: JavaScript

Defect Tracking Tools: HP Quality Center, IBM Rational ClearQuest, JIRA. ALM

Development Environment: Eclipse IDE, Salesforce, EDIFecs

RDBMS: MySQL, MS-SQL Server, MS Access, Oracle

Misc. Tools: MS Office, Log4J, Maven and SVN

Databases: Oracle 11g/10g, SQL Server

Operating Systems: Windows, Mac OS, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential

System Analyst/ Test Engineer

Responsibilities:

• Created and updated the Functional Documents including Business Requirement Document (BRD), Functional Specification Document (FSD), Requirement Traceability Matrix (RTM), Use Cases and Wireframes, Data Mapping Documents and Data Dictionary
• Conducted a detailed and comprehensive business data analysis by working with the business user, SME and technical team to identify system requirements and improvements.
• Responsible for Document Management, used SharePoint and integration to Office365 and organized project and program documents from BRDs, FSD and Change Control implementation.
• Created automated test scripts for the Front End Applications and Data base applications and for Regression testing.
• Prepared Test Plan, test Cases, Test scripts and Test Metrics for the application as well as for the database verification based on the functional requirements, portal redesigned and test specs.
• Worked on different MMIS system like member, provider, claims, and financial.
• Involved in gathering requirements, understanding and problem solution depending on the change of requirements.
• Involved in JAD sessions with End clients, Delivery leaders and technical team and System Architect.
• Involved in SIT, Regression testing and PIT testing, ORT testing, UAT testing and functional testing.
• Involved in developing test plans, Test strategies, and test cases and executed them as per plan using Automation Scripts in UFT/QTP.
• Used QTP and Selenium Web driver to perform Regression Testing.
• Designed, executed, and maintained automation Test Scripts in Selenium WebDriver using JAVA TestNG and Maven.
• Integrated with Continuous Integration tool Jenkins for running test on nightly basis automatically.
• Responsible for implementation of Hybrid Test Automation Framework , Page Object Model using Selenium WebDriver, TestNG , Maven and Java.
• Worked on the Parameterization using TestNG Parameters and Data Provider annotations in Selenium WebDriver Scripts.
• Well versed in locating various GUI elements using XPath, CSS , Link text, Id, Name, Class name, Tag names, partial Link text to test both web and mobile applications.
• Developed and maintained automated regression test cases in Selenium WebDriver using Java programming language.
• Performed Functional Testing of the Web services using SoapUI and Lisa.
• Worked on Mobile development concepts like server-side Mobile API, Mobile Components, Emulators, Device Groups, Device Detection, and Mobile request processing.
• Involved in mobile testing by writing java scripts for automation through Selenium APPIUM.
• Implemented simulator for Mobile App Testing in Android Platform using APPIUM.
• Generated test scripts using Selenium and Ruby.
• Created automation framework in Selenium WebDriver using BDD approach like Cucumber.
• Designed and documented REST/HTTP, SOAP APIs, including JSON data formats and API versioning strategy.
• Validated PIT transaction in MMIS and backend to send file to MCOs.
• Validated 834 eligibility, 835, 270, 275 EDI and F3 Files. Having hand on experience for EDI.
• Closely worked with SDFC development and environment team to solve the issue and fulfillment the data requirement.
• Migration of Service Cloud data into Optus Insight Salesforce using Data Loader.
• Involved in SIT testing for claim submittal tools which integrated with the salesforce and verify the data.
• Analyze Salesforce system usage and data storage patterns to improve efficiency.
• Mapping (RTM) the requirements and test cases in HP Quality Center and created a mapping report.
• Bugs were identified and reporting through ALM and assigned and discus with the development team.
• Tested all the reports by running queries against the warehouse-using TOAD, Also compared those queries with the Informatica SQL engine generated queries.
• Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System.
• Executed Test cases manually to test Application functionality against user requirements for security.
• Connected to database to Query the database using SQL for data verification and validation.
• Performed defect reporting and bug tracking using ALM and followed up with development team to verify bug fixes, and update bug status.
• Validated the customer account records and their order details with Databases using SQL Queries.
• Extensively used Page Objects design and page navigation framework for readable test script and easy maintenance from developer perspectives.
• Performed back end testing on Oracle Database by writing SQL queries.
• Followed Agile testing methodology, participated in daily SCRUM meetings and testing each sprint deliverables.
• Performed manual and automation scripts development on Agile (SCRUM) Methodology.

Environment: : SoapUI 5.1.3, HP ALM 12.6, Toad 11.5, Business Object, SharePoint, Notepad++, LeanFT (project: Fortify upgrade), Selenium, Oracle, Windows, Informatica Power center, EDIFECS specbuilder, Salesforce: visualforce ( Pages, Response and Controllers), Data loader.

Confidential, FL

ETL/QA Engineer

Responsibilities:

• Analyzed business requirements and functional documents, created the test strategy document that define the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the testing environment using Selenium WebDriver, TestNG, Maven and Jenkins.
• Performed functional testing to identify various critical points in the application and automated it by using Selenium WebDriver.
• Extensively involved in writing manual test cases, automated test scripts and executing manual and automated test scripts for System testing and Regression testing using Selenium WebDriver.
• Implemented Logic using Python and Used as Keyword for Robot Framework.
• Integrated the test suites to Jenkins to execute them automatically after every successful deployment.
• Integrated Automation scripts (Selenium WebDriver API) on Continuous Integration tool Jenkins for nightly batch run of the Script.
• Created Automation script using Selenium WebDriver. Executed scripts on different browser and different platform.
• Worked on Data Driven Framework for Automation test scripts.
• Performed functional testing of SOAP Web Services using SOAPUI Tool.
• Performed Web Services Testing and XML validation by creating test case suite using SOAPUI.
• Attend the BRI (Business Requirement Identification) meeting to understand the business Requirements.
• Conducted backend testing using SQL queries to validate data for database.
• Testing with diversified skills in manual testing of web based and client/server applications.
• Expertise in developing Test plans, Test Scripts, Test Cases and procedures Requirement Traceability Matrix and Test Analysis Report, also developed various reports using BI tool (Cognos).
• Participated in planning all testing activities accordingly to ensure deliverables are met on time; including test planning, test execution, defect tracking, and reporting.

Environment: Selenium WebDriver, Junit, Jenkins, Salesforce, XPath, Python, SoapUI, Appium, Agile, MAVEN, Quality Center, Oracle, Windows, Cognos, Informatica.

Confidential, NJ

QA Engineer

Responsibilities:

• Created automated test scripts for the Front End Applications and Data base applications and for Regression testing.
• Prepared Test Plan, test Cases, Test scripts and Test Metrics for the application as well as for the database verification based on the functional requirements, portal redesigned and test specs.
• Mapping (RTM) the requirements and test cases in HP Quality Center and created a mapping report.
• Bugs were identified and reporting through ALM and assigned and discus with the development team.
• Hands-on coding experience in scripting language- VB Scripting.
• Proficient in Functional Testing tool LeanFT and the various frameworks in UFT.
• Experienced in giving training to the functional testers to execute Test Cases using UFT as part of Regression Testing.
• Working experience on Data driven and Keyword driven frameworks in LeanFT.
• Tested all the reports by running queries against the warehouse-using TOAD, Also compared those queries with the Informatica SQL engine generated queries.
• Tested the source and target systems Extracted data from database tables and upload to Oracle.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2005 and Oracle 10g.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Written Test Cases for ETL Datastage jobs compare Source and Target database systems.
• Used standard testing techniques to test the data validity before deploying the MicroStrategy Reports to Users
• Experienced on demonstrating the Automation Framework in UFT to client and driven project status calls with client.
• Tested web-based application on different operating systems such as Windows XP, Vista and UNIX. Also, tested the application for different Java versions.
• Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System.
• Extensively used ETL to load data from Flat files to Oracle.
• Schema validation, Inbound and Outbound Data Validation.
• Executed Test cases manually to test Application functionality against user requirements for security.
• Prepared user documentation with screenshots for UAT (User Acceptance testing).
• Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.
• Designed developed and implemented user acceptance testing protocols as the final phase of applications development.

Environment: : SoapUI 5.1.3, HP ALM 12.6, Toad 11.5, Business Object, SharePoint, Notepad++, UFT 12.0, SQL/PLSQL, Informatica Power center, EDIFECS specbuilder, Salesforce: visualforce ( Pages, Response and Controllers), Data loader.

Confidential, NY

QA Engineer

Responsibilities:

• Actively involved with SCRUM and sprint meetings, managing product backlogs, removing obstacles to progress, re-allocating resources where necessary, prioritizing and review milestones and accomplishments.
• Extensively used Selenium WebDriver 2 to test the web application.
• Performed testing on both Native and Web mobile versions on Appium tool.
• Worked with Mobile Applications (IOS, Android) and automated the applications using APPIUM/Selenium Web driver, Simulators, XCODE, and BREW.
• Extensively used Selenium (XPath and CSS locators) to test the web application.
• Utilized both IntelliJ IDEA-Maven for end-to-end UI Automation in Appium.
• Configured Selenium WebDriver, TestNG, Maven tool and created selenium automation scripts in java using TestNG prior to agile release.
• Responsible for implementation of Hybrid Test Automation Framework build using Selenium WebDriver, TestNG and Maven technologies under Java platform utilizing industry leading harness design patterns and approaches.
• Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.
• Wrote and executed various PostgreSQL queries from Python using Python-PostgreSQL adapter psycopg2.2.
• Wrote scripts for mobile application (on handsets) and mobile web (on handsets, iPad and Tablet using device's browser).
• Downloaded different simulators from vendor websites like Apple and Google
• Created and executed the test scripts with Java, Selenium WebDriver and TestNG.
• Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium Grid and Jenkins.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API. Used Page Object Model, UI Mapping, Selenium Manager, Data Driven using CSV, CSS Selectors as a part of Framework.
• Performed SOA / web services testing using SoapUI, wrote adaptors to test / invoke web services.
• Writing complex SQL queries and update transaction and properties for accounts on stages for UI testing, Integration testing with different data points etc.
• Used JUNIT in regression testing framework to implement unit testing in Java and accelerate programming speed and increase the quality of code.
• Worked on different features of JUNIT such as Fixtures, Test suites and Test runners.

Environment: : Java, Selenium WebDriver, Junit, Jenkins, XPath, SoapUI, Appium, Perfecto Mobile, Agile, MAVEN, Firebug, Eclipse, Quality Center, Oracle, Windows.

Confidential

QA Engineer

Responsibilities:

• Interacting with business analysts and developers in requirement analysis, design reviews, testing and documentation for application developed in agile environment.
• Design and Implement Test Plan and Test Strategy for the test features.
• Performed Unit testing with Junit test frame work and use Bromine for easy running the test and store the result for analysis the test.
• Involved in setup and Configuration of testing environment with Eclipse, TestNG, Selenium WebDriver and Selenium Java client driver.
• Integrated Automation scripts (Selenium WebDriver API) with CI tool (Jenkins) for nightly batch run of the Script.
• Worked with Selenium WebDriver for writing test scripts for regression test coverage.
• Performed Manual Testing of this Web application and automated it by using selenium.
• Identified software defects and interacted with developers to resolve them.
• Designed and developed test structure for web services to validate API calls using SOAP UI.
• Developed MAVEN Build scripts to run Sanity Test scripts developed in Selenium RC.
• Developed Automation scripts for new enhancements using Selenium RC and Junit.
• Developed REST Web service for automation and created web service framework.
• Involved in Defect tracking and Reporting using Bugzilla defect tracking tool.
• Execution of nightly run automated scripts.
• Participated in various meetings, discussed Enhancement and Modification Request issues.
• Worked under Agile Scrum Methodology.
• Reported the bugs/defects through JIRA.

Environment : Selenium RC/IDE, Java, Junit, JavaScript, Eclipse, XPath, SVN, JIRA, XML, IE, Windows.

Confidential

QA Tester

Responsibilities:

• Arranged meeting with business customer in better understanding the reports by using business naming conventions. Coordinate between offshore team.
• Responsible for Data Mapping testing by writing SQL Queries.
• Utilized Dative tool to create defects and assign to respective Developer.
• Tested several Datastage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Perform various types of testing, such as Black box, functional, SIT and regression testing.
• Determined testing scope and prioritized deliverables in different phases.
• Tested data warehouse components, data marts, testing of Dimension and Fact tables.
• Extensively used ETL Data stage to load from XML and flat into the target data warehouse.
• Transformed data from various data sources like XML and flat files.
• Work closely with DW Developer to follow up on defect to get closed within the timelines and the same to be informed to stake holder.
• Ensured the process oriented steps to get the job done within the timelines to avoid un-interrupted business service/requirements.
• Extensively worked with GUI, functional testing and methodologies for creating test data.

Environment: HP QC, HP Quality Center, IBM Data Stage 8.1, Ab initio, XML, Datastage, Oracle 10g, SQL Developer