SUMMARY:

• 8+ years of professional experience in Quality Assurance, testing, requirements gathering and documentation.
• Extensive skill in Manual Testing of Client Server and Web based applications.
• Strong domain expertise on VIDEO, BANKING, E - COMMERCE, HEALTHCARE and FINANCE.
• Working experience with Cloud, IBM Lombardi, SAP Business Objects, Crystal Reports, Content Management Systems (CMS), Midas+ Healthcare Performance Management, Search Engine Optimization (SEO), Customer Relation Management (CRM) Applications, NBS Banking System, Check and Card Swipe Machine.
• Automation testing and automation test tools like Silktest, Winrunner, QTP and Selenium.
• Experienced in Mobile testing for Mobile Web and Mobile App(Android & iOS) using Appium(Selenium 3.0), Device Anywhere emulators on iOS& Android devices, worked on Cloud based device applications.
• Experience with automation tools Egg Plant, Cucumber, Protractor.
• Experienced in testing Web services in SOAP and RESTful protocols.
• Worked on Identifying test scenarios and conditions for Manual / Automated Testing in Web-based and Client-Server Applications developed in Java, .Net Technologies.
• Strong hands on experience in development and execution of Test Plan, Test Scenarios and Test Cases.
• Business Requirements and defining test methodology.
• Test Management Tool, HP Quality Center.
• Bug Tracking Tools like JIRA and Bugzilla
• Configuration Management Tools like Tortoise SVN and Confidential
• Experience with different software development methodologies Waterfall and Agile.
• Experience in Black box, Functional, Integration, System, Regression testing, Unit, User Acceptance and
• Back End Testing which includes Database Testing.

TECHNICAL EXPERTISE:

Testing Tools: Selenium Web, Selenium IDE/RC, HP ALM / QTP, SOAPUI, Test complete, Rational Functional tester(RFT), Appium, Perfecto, Protractor, Eggplant, JMeter, Jenkins.

Frameworks: Page Object Model, TDD/ ATDD, Keyword Driven, Data Driven, Hybrid Driven, Cucumber, TestNG, Junit, log4j

Integration tools: Jenkins / Bamboo, Maven/Ant API testing REST, SOAP, SUPERTEST, SOAPUI, POSTMAN

WEB: GUI automated testing Selenium, nightwatch, protractor, webdriver, page object model (selenium)

DB Query Language: SQL

Webservices Testing: SOAP UI, XML, HTML, WSDL, XPATH

ETL Automation: Control-M, Test Data Professional

Operating Systems: Unix, Linux, Windows … iOS, Android

ETL Tool: Informatica Power Center 9.1, Talend, Ab-Initio

Database: (Data warehouse Testing) Oracle11g, SQL Server, SQLite3

Unix: Terminal Emulator Putty, Writing Unix/Linux commands

Reports: Oracle OBIEE, Jasper reports, Multifonds reports

QA Environment Deployment Tools: PADA, COAST, SDSS, Tectia

Database Tools: PL/SQL Developer10.0, Embarcadero Rapid SQL 7.5.5, TOAD, Microsoft SQL Server Management Studio (SSMS)

Business Process Tools: IBM PEGA, MS Visio

Front & Middle Office testing tools: Temenos Multifonds, T-24, CITI Direct Securities

Software Lifecycles: Agile methodology, User Stories, Sprint planningWaterfall model, Verification-Validation, Prototype model

Others: Cloud computing, GitHub, SharePoint, FTP Servers, Symphony, TortoiseSVN 1.7.7, IIS6.0 server, ITSM BMC Remedy User7.1.00, 3-tier, 2-tier client/server application architecture, Virtual Machines

WORK EXPERIENCE:

Sr. Test Automation Engineer

Confidential, Charlotte, NC

Responsibilities:

• Performed RESTful web services and APIs testing in SOAPUI Pro and validated responses with assertions.
• Created library functions, Checkpoints, Data Validation Descriptive Programming using QTP 11.0.
• Involved in regression testing using QTP tool prior converting QTP scripts to Selenium web-drive.
• Scheduled and executed Automated Unit, Functional and Regression testing of APIs in Atlasssian Bamboo.
• Executed different complex SQL queries to validate actual result in the database matches with the expected result.
• Prepared and Execution of test scripts using Test-NG and Selenium Web-Driver.
• Responsible for defect tracking and management metrics, defects are logged and change requests are submitted using Bugzilla.
• Installed & Configured Selenium Web Driver, Test-NG, Maven tool and created Selenium automation scripts in java using Test-NG prior to next quarter release.
• Applied robust Page object pattern (POM) on new builds and every modification in the application for Selenium WebDriver to do Smoke and Regression testing.
• Involved in database testing using MS SQL Server.
• Experience to run test cases using JENKINS.
• Performed Integration and Regression testing to check compatibility of new functionality with the existing functionalities of the application using Selenium.
• Tested compatibility of application for various cross browsers using XPath in Selenium
• Designed, maintained and executed Automated Integration framework of API/Web.
• Services across multiple test and production environments using SOA test.
• Created custom JSON/XML Assertors, for validation of SOAP (WSDL), and REST API calls, and Data Banks for storing and analyzing data input/output and error codes
• Contributed to the functional automation suite for sanity, smoke, and regression runs using Ruby and Selenium
• Used Appium automation tool to do mobile application testing.
• Involved in scope creation, script creation, configuration, execution, analysis, resolution, retesting in order to performance testing using selenium and Rational Robot.
• Created Test Automation Framework with Cucumber and Selenium Web Drive
• Experienced in testing code developed in TDD / BDD environments.
• Used Firebug to do web based testing with selenium for the commands and locator application
• Ensured timely and accurate communication with development leads, project leads and senior management throughout the life cycle of the project.

Environment: Java, QTP, SeleniumWebDriver, Ruby,.Net, TestNG, node.js, Yarn, Gulp, TFS, Appium, Maven, Python, Git, TDD, BDD, Agile, HTML5, XML, XPath, Rally, POS, Web Services (SOAP & RESTFUL) JavaScript, Bamboo, Performance center, Firebug, SQL, PLSQL, Putty, Win SCP, SQL Navigator, Oracle, UNIX, Windows.

Senior QA Analyst

Confidential, New York, NY

Responsibilities:

• Worked as QA Team Lead of ETL, DWH, Data Migration team of 12 strong QA testers
• Worked on Agile methodology, Daily stand up meetings, Continuous Integration approach.
• Extensively worked on ETL Automation, DWH, Data Migration, Database Testing, Integration, Functional, System, End-to-End, SIT, Regression, Error handling, GUI, Negative, Recovery, Usability, Smoke, Sanity Testing.
• Extensively worked on executing ETL process having more than 1000 jobs for data loading using Informatica and Control-M tools. FTP OPERA & DAL (Detailed Accounting Ledger), PeopleSoft source flat (.dat, .csv, .xls) files into Unix server and executing Informatica workflows in successive order to load data into larger DWH. There are millions of records and processing is continued 24*7 using onshore-offshore models.
• Used HP ALM/Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Exported Test Requirements and Test Cases from Excel and Word to HP ALM/Quality Center.
• Involved in Defect Reporting, Analyzing, Tracking and Report Generation using HP ALM/Quality Center and JIRA
• Worked with developers to resolve Issues and Production Incidents using HP ALM/Quality Center
• Generated various reports and graphs from HPALM/Quality Center and analyzed the testing process overview.
• Upstream data publishing into Unix Symphony server and then delivered to reporting PCDW databases. Configuring Unix servers with upstream application database and DWH details for data flow. Executing Shell scripts, validating error logs, fixing of errors, log files tracking, fetching published records counts for various assets categories.
• Involved in creating output values using QTP/UFT.
• Installed and used "Emulator" to perform mobile test execution for Iphone, HTC droid, Samsung android and, Dell Streak.
• Tested and coordinated mobile applications in both Native and Web environments and validated the mobile application functionality on physical smart phone hardware devices and virtual device emulators like: Device Anywhere and Simulators like: Android SDK, IPhone SDK etc.
• Expertise in working with various mobile devices such as Android, Blackberry, IPhone, tablets to perform browser compatibility and configuration testing.
• Writing and Executing Test cases for ios, android, blackberry.
• Performed functional testing of individual modules of the Application on iOS, Android.
• Application on iPhone, iPad and Android
• Enhanced QTP/UFT script using recovery scenarios for error handling.
• Inserted Check Points to check the broken Links, Text, and standard properties of objects using QTP/UFT
• Extensive experience in writing unix file manipulation commands, FTP.
• Extensive experience in writing complex SQL join, group, single and multiple row functions for DWH raw, staging, presentation layer testing.
• Managing team of 12 resources located across world, onshore-offshore model, Performing knowledge sharing sessions, requirements brain storming sessions, Q&As, Understanding change requirement. Designing high quality test cases, use cases, review/update/versioning/maintaining.
• Preparing high quality test plan, test estimations, test strategies, entry-exit criteria, traceability matrix, QA sign off documents.
• Extensive experience in QA/UAT/Regression Test environment Preparation and maintenance. Deploying Informatica infa components, ETL Shell scripts, Database .DB components, OBIEE Webcat, .RPD components using Credit Suisse PADA, COAST, SDSS, Tectia deployment tools.
• Reading and verifying ETL shell scripts is as per data mapping documents. Validating data models and data maps (extract, transform and load analysis - ETL analysis) of the DataMart and feeder systems in the aggregation effort.
• Loading of large amount of Reference Data, Mutual Funds data, Capital Markets, Derivatives, Underlying assets, Forward, Futures, Forex FX, Profit and Loss, Loans, Equity, Transactional data, Unadjusted data, Adjusted data into Dimensional tables, FACT tables by executing ETL jobs. Loading more than 1 million records, continuously monitoring large amount of data loading.
• Running Informatica Workflows, Worklets, Control-M jobs, Validating Informatica mappings on designer canvas, validating DWH raw, staging, presentation column to column mapping.
• Monitoring ETL process in Control-M batch scheduler tool, Informatica Monitor logs, Unix logs success, failure. Analysing and fixing by taking corrective actions for failed ETL workflows.
• Configuring and setting of date card job, business.txt for the predefined business date, region.
• Validating NRT messages/tokens publishing from upstream systems to unix server to downstream systems. Using sqlite3 validating .sdb files in unix database for successful messages /tokens are received. Checking the required associated parameters for messages and checking the same in Adjusted reports on data changes.
• Testing Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
• Extensive experience in writing complex SQL for validating data received in Raw layer, Data transformation logic in Staging layer. Writing SQL with where clause as per business requirement to validate loaded, rejected records.
• Dimension table: Preparing DWH Test Bed by loading last quarter production data as a reference data into Dimension tables.
• Partitions: Creating partitions, sub-partitions in FACT tables for the required business dates as a part of Test environment preparation.
• Gather Stats: Performance testing by Gather Stats on table columns for improved DWH loading performance, Gather stats on business date column for improved performance, preparing reports on improved performance in terms of constraints such as time, memory, CPU usage.
• Developed and maintained automated scripts using UFT/QTP for functional automation testing.
• Designed data driven tests in UFT/QTP script to validate with different sets of test data.
• Tested application compatibility in different browsers like Firefox, Internet Explorer, Safari using UFT/QTP
• Designed data driven tests in UFT script to validate with different sets of test data. Performance testing by clearing cache using Crontab auto process execution.
• Designing, Writing SQL as per requirements to validate data loaded into Data warehouse, Raw, Staging, Presentation layers. Reconciliation and data validation between disparate source systems and target systems.
• Extensive experience in validating transformed data in Staging layer (DWH) using SQL self, inner, outer joins, group by, with, inline views, intersect, minus, except, case, decode, union, Indexing, Unique Constraints, Referential Integrity, Sub queries, co-related subqueries, aggregate functions.
• Extensive experience in writing SQL for checking data quality, data standards, referential integrity, data integrity, PK/FK/Natural Key/Surrogate Key/compound Key, Indexes, data type/size is as per mapping document. Writing SQL to fetch data by joining two or more tables to validate data aggregation, reconciliation, transformation.
• Data Migration testing, Reading and understanding of Data mappings, writing test cases for column to column mapping, column data type/size, Writing and executing SQL for validating data constraints, Null/NotNull/Checks/Unique/Rpad/Lpad/Trim/Round/Truncate
• Webservice testing using SOAP UI and DART reports intranet webservices testing.
• Experience in Testing OBIEE dashboards, Answers, Frogs, DART reports
• Testing of PeopleSoft General Ledger GL reports such as balance sheets, Loan transactions, Liabilities etc in OBIEE.
• Testing of Reports Modernization layers, User Interface, User Experience, GUI testing on Webapp layer mounted on top of OBIEE layer.
• Writing Selenium2.0 Webdriver test scripts in Java (Eclipse) for testing of user experienced modernized Web application. Designing framework for the web application regression testing, maintaining regression test suites.
• Configuring OBIEE database connectivity by setting SetUp.sh with Unix server details, Running, restarting OBIEE services as required. Performing report admin activity for providing user roles, admin roles to team members.
• Report logs validations: Verifying the logs for the reports run, getting table names, running SQL for those tables to check required change in data is displaying in DWH tables. On failures, analyse the logs, errors, mapping issues, Logging defects for the same.
• Testing on new column addition, removal, concatenating in OBIEE reports against DataMart.
• OBIEE reports testing on various platforms including Windows … and performing cross browser testing on Virtual Machines.
• Validating reconciliation of securities in OBIEE such as equities, bonds, swap, derivatives, futures, forwards, OTC, Forex FX, FX spot prices, Fixed Income in OBIEE reports.

Environment: and Tools: Informatica Power Center9.1, Control-M7.0, OBIEE 11g, Oracle11g, PL/SQL Developer10.0, JAVA, J2EE, .Net, Putty, ALM11.0, SharePoint, PADA, COAST, SDSS, Tectia, Windows XP, Unix, FTP Servers, Symphony, Test Data Professional automation tool, Tortoise SVN 1.7.7, BMC Remedy User7.1.00, Virtual Machines, MS Visio, V-V model, Agile, Scrum

QA Engineer

Confidential, San Francisco Bay Area, CA

Platform: Java, Oracle, SQL, Jira, Selenium

Responsibilities:

• Understanding the business functionality, requirements and technical specifications of the application and writing Test Plan for the new releases.
• Writing test cases and conducting end to end Regression testing, functional testing, acceptance testing and reliability testing.
• Used MTM to developed test cases in Test plan module and executed test cases in Test Lab Module and logged the defect in defect Module.
• Good experience and hands on knowledge on Test Management/ defect tracking Tool like HP Quality Center/ALM and JIRA and knowledge on MTM and TFS.
• Used SVN, GIT, TFS for maintaining code version in the control systems
• Used TFS (Team Foundation server) to check-in the code and also used for Defect Update and Creation
• Integrated SOAP UI automation scripts in continuous integration environment.
• Performed Web services testing between and third party applications using Soap UI.
• Automation testing Using SOAP UI for Smoke testing before applying the release in Production.
• Involved in API testing with both SOAP and Restful web.
• Worked on Validating Rest API Services for different HTTP METHODS
• Analyze testing results and document, track, and verify defects across products, platforms, and release.
• Testing on mobile devices (Windows, Android and iOS)
• Configuring and working in multiple server farm environments. Tomcat and JBoss Java servers.
• Automation testing using Selenium IDE, Selenium RC, Selenium WebDriver.
• Using Oracle & MS SQL Server for Database Testing.
• Testing integration with SharePoint including SharePoint2010, SharePoint2013 and SharePoint Office 365. Testing integration with IBM Websphere, IBM Connections, WebEx and Lync.

QA Engineer

Confidential

Platform: Android

Responsibilities:

• Functional Testing, Database Testing, Compatibility Testing, Power Consumption Testing, and Usability Testing.
• Used Soap UI and Restful services for testing Web Services and Protractor for testing Angular in working with different front end
• Used SoapUI tool to test SOA based architecture application to test SOAP services and REST API
• Created Test Scripts in SoapUI and Restful for Testing using Web Services
• Experience in CI/CD Tools includes Jenkins
• Developed and executed test cases for XML / SOAP and REST services using SoapUI tool
• Tested the Business applications on Mobile web and native app both on Android and iOS real devices and emulators.
• Tested the application devices like iPhone/iPad/Samsung/LG.
• Experienced in Mobile testing for Mobile Web and Mobile App(Android & iOS) using Appium(Selenium 3.0), DeviceAnywhere emulators on iOS& Android devices, worked on Cloud based device applications.
• Performed mobile testing includes UI, Functional and Installation on DeviceAnywhere and Appium with various configurations of iOS& Android devices and mobile browser testing.
• Creating test scripts with consideration to end-to-end system flows
• Using ADB commands for testing.

Quality Analyst, Test Lead

Confidential, San Antonio, TX

Platform: Main Frame, SQL Server, .Net

Responsibilities:

• Conduct a wide range of quality-control tests and analysis to ensure that software meets or exceeds specified standards and end-user requirements. Using Quality Center 9.2
• Created test plans and test scripts with consideration to end-to-end system flows.
• Worked on MAP and HAMP loans i.e. non-gse and gse (Fannie Mae and Freddie Mac) loans.
• Involved in writing scripts in QTP.
• Analyze requirements and design aspects of projects, interface with client leads and other development organizations.
• Helped offshore team in writing test scripts. Interacted with SA and BA for any project related queries from the team.
• Involved in testing activities in Mainframe and SQL Server.
• Involved in Functional testing, Integration testing and Regression testing.

Quality Analyst, Test Lead

Confidential

Platform: Oracle, SQL Server, Lombardi, SAP Business Object, Crystal Reports

Responsibilities:

• Conduct a wide range of quality-control tests and analysis to ensure that software meets or exceeds specified standards and end-user requirements. Using Quality Center 11.0
• Created test plans and test scripts with consideration to end-to-end system flows.
• Identify, recommend and implements process improvements to enhance testing strategies.
• Involved in testing Reports and Business Object testing.
• Involved in testing activities in SQL Developer, Oracle 9i.
• Involved in Functional testing, Integration testing and UI testing.

Functional QA

Confidential, San Antonio, TX

Platform: Main Frame, People Soft

Responsibilities:

• Conduct a wide range of quality-control tests and analysis to ensure that software meets or exceeds specified standards and end-user requirements. Using Quality Center. Conducted tests for Debit card, Credit cards & checks using NBS system.
• Draft and revise test plans and scripts with consideration to end-to-end system flows.
• Document, evaluate and research test results.
• Identify, recommend and implements process improvements to enhance testing strategies.
• Analyze requirements and design aspects of projects, interface with client leads and other development organizations.
• Involved in Functional testing, Integration testing and Regression testing.
• Involved in writing scripts in QTP.

QA

Confidential

Responsibilities:

• Requirements gathering sessions and creation of Requirements Traceability Matrix
• Involved in creating Test cases and transferring the test cases/scripts from MS EXCEL to Quality Center.
• Performed web based and server based application testing.
• Used Quality Center for Test execution, defect logging and reporting.
• Coordination of work between offshore and onsite
• Involved in Functional testing, Integration testing and Regression testing
• Used SQL tools like TOAD to run SQL queries and validate the data.

Test Analyst

Confidential

Responsibilities:

• Analyze the Business Requirement Document (BRD), Functional Specification Documents to prepare Test
• Cases based on Test Plans
• Used Quality Center for creating Test Cases, executing Test Cases, Defect logging and reporting.
• Involved in Functional testing, Integration testing, Regression testing, UAT, and Usability Testing
• Tested the application for compatibility using different browsers

Tester

Confidential

Responsibilities:

• Involved in creating Test scenarios and Test cases.
• Involved in Functional testing, Integration testing and Regression testing activities
• Used Quality Center for executing Test Cases, logging defects and reporting.
• Worked on SEO (Search Engine Optimization).
• Worked on CRM (Customer Relationship Management) portal.
• Conducted database testing by running SQL queries
• Involved in Test Automation using QTP