SUMMARY

• Over 9+ yrs of Professional IT experience specialized in Software Quality Assurance Testing wif Manual and Automation - Web-based application, WebUI Interface, Middleware, Database and Client/Server environments, Datawarehouse environment involved in all phases of SDLC - analysis, design, development and testing using database technologies;
• Seeking new challenges dat fully leverages my cross-industry experience as well as my strong technical and interpersonal skills.
• Experience in Banking and Financials, ERP, E-Commerce, Education, Oracle Financials, Travel, Retail, Health care and Insurance Domain
• Expertise in Software Quality Assurance Manual and Automation Testing, responsible for executing and coordinating testing projects
• Analyze Business project requirements for manual and automation testing, creating test plan and effort estimation for test execution. Interact wif the business partner to deliver the scope of the project wif utmost quality on time
• Execution of manual testing and automation testing for GUI, Web application using various tools like HP-ALM Quality Center, JIRA, Selenium Web Driver, SoapUI, Jenkins, QTP, Load Runner, Reporting Tools
• Expertise in automating Functional and Regression testing of web applications wif different Browsers and Mobile devices iphone/Android/ipad
• Interpreted and converted manual test cases into automation smoke and regression suites.
• Good wif Agile, Scrum and Waterfall Methodologies. Extensive experience in writing SQL queries. Performed Agile Testing by implementing Agile Methodologies meeting the expectation of Business needs through early and continuous delivery of Valuable Software
• Work wif product stakeholders to identify and prioritize tests dat are candidates for automation and regression
• Develop new automated test cases and enhance current test suite as new functionality is built
• Run automated test suite using Java and evaluate performance, functionality, and scalability
• Executing GUI Web application testing using Selenium WebDriver according to policies and procedures
• Performed Mobile Browser testing using devices iphone/Android/ipad and Proficient in database Oracle and Sqlserver for backend testing of web application using SQL, writing queries to confirm correctness of data entered via UI, and data manipulation
• Run Automated Test Plans for Smoke/Regression Test using Jenkins and generate Cucumber Reports for Passed/Failed status
• Good knowledge and experience wif Behavior-Driven Development and Test-Driven Development
• Expertise in Testing Web applications, browser compatibility, load performance and involved in various phases of Testing life cycle such as Functional, Regression, Integration, System testing, UAT
• Expertise in all types of Test Documentation: Test Strategy, Test Plan, Test Approach, Test Scenarios, Test Cases, Test Report, also has extensive experience in creating graphical reports for TEMPeffective visualization on defect management process
• Experienced in ETL Testing, Developed SQL scripts to validate relational database tables
• Proficient in data warehousing development life cycle and involved in creating Source To Target Mapping, ETL test using SQL/PLSQL scripts, Data Profiling and Automation of data quality checks
• Involved in Mobile browser testing using Cloud service
• Experience wif Databases and Performed end-to-end testing on backend DB validations (on different Servers) using SQL, PL/SQL, DB2 and Oracle on Unix Environments
• Expertise in End-to-End Test Management and Tools - HP Quality Center(ALM), Microsoft Test Manager, QTP, JIRA, Load Runner, Test Director and IBM Rational tools. Has played a key role during SIT, UAT and providing support post production ensuring the release is deployed into production wifout affecting the functionality
• Generate QA metrics, daily testing status reports to the management highlight risk and issues during execution
• Lead On-site/off-shore project co-ordination, Manual and Automation Testing, System Support and Software Development
• Provide direction to the team in creating all the testing artifacts, review the document before delivered to the stakeholders to ensure completeness
• Good wif Agile, Scrum and Waterfall Methodologies. Extensive experience in writing SQL queries. Performed Agile Testing by implementing Agile Methodologies meeting the expectation of Business needs through early and continuous delivery of Valuable Software
• Lead software test operations such as ensuring the availability of Test Environments and Test Data. Involved in Formal Reviews, Walkthroughs and Inspections
• Coordinate Test Meetings/Defect Status Meetings wif impacted teams, Business, 3rd party vendors for the status of test progress and defect resolve completion status
• Highly organized wif the ability to manage multi-tasking and willingness to work hard to achieve employer objectives. Proficient in understanding new technologies, accomplishing projects goals successfully. Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives
• Experience in testing a wide range of applications including ERP, E-Commerce, Java and Web and Microsoft applications. Strong problem solving and troubleshooting skills, highly motivated and ability to work as an individual and also as a dynamic leader in a team

TECHNICAL SKILLS

RDBMS (Database): Oracle Exadata, MS SQL Server, DB2, MS Access

Domain Expertise: Banking & Financials, ERP, Education, E-Commerce, Oracle Financials EBS - AR/AP/GL, Travel, HealthCare, Insurance

Operating Systems: Unix/Linux, Windows 9x/2000/XP/Vista/7/8/10

Languages: SQL, PL/SQL, VB Script, JAVA, Xpath, Gherkin Script, Python

Testing Methodologies: Database, Functional, Regression, Integration, Web Services, Performance, Agile Testing, Mobile Testing(iphone/Android/ipad), ETL Testing

Test management Tools: HP Quality Center-ALM, Selenium Web Driver, Selenium IDE, CICD Jenkins, Microsoft Test Manager, QTP, JIRA, Mingle, Version One, Test Director, Load Runner

Test Web Service Tools: Web Methods Developer, Middleware, SOAP UI, CU, SOLAR, DataPower, Postman

Microsoft Technologies: VB, Visual Source safe, Share Point, MPP, ASP, Test Manager

Datawarehouse/Reporting/ Middleware: IBM Data stage, Informatica, TestNG, Cucumber, Jaspersoft Reports, Data Quality, Data Profiling and mapping, Crystal/Java Elixir/MSTR/BI/Tableau Reporting, Middleware, Mainframes, SRM Sales Force

PROFESSIONAL EXPERIENCE

Confidential, Phoenix

Senior Software Quality Analyst

Responsibilities:

• Analyze Business Requirements, Prepare Technical design documents, Project Plan, Test Plan, Test Strategy, Test Cases, Data mapping documents for ETL data load, Responsible for performing source system analysis, identification of key data issues and Task tracking.
• Executing GUI web application testing wif Selenium according to policies and procedures
• Developed automated test cases using Java and enhance current test suite as new functionality is built
• Performed Mobile Browser testing using devices iphone/Android/ipad and backend testing of web application using SQL, writing queries to confirm correctness of data entered via UI, and data manipulation
• Run Automated Test Plans for Smoke/Regression Test using Jenkins and generate Cucumber Reports for Passed/Failed status
• Involved and Co-ordinate Functional, Website, Performance, Webmethods testing, Mobile Browser and Regression Testing
• Design, customize, Test and involved in implementation of Web Project by coordinating wif Business and cross functional teams and provided support till post production launch.
• Create/execute/debug both manual and automated test suites using HP ALM Quality Center, Selenium Web Driver, CICD Jenkins and IBM Rational test management tools by reducing the overall project execution timeline and cost save to the Organization.
• Verification of ETL data feed files (Source system data) wif database tables matching Business transformation rules.
• Creating/Maintaining Requirements, Test scenarios, Test cases, Defect management using HP ALM Quality Center. Development of SQL queries and Reports
• Involved in Functional, Website Navigation, Browser Compatability, Regression, SIT and Performance Testing of E-Commerce Applications, UAT Testing
• Convert manual tests into automated test suites for Regression/Smoke tests.
• Provided Guidance in developing test cases and track the execution in Quality Center, along wif graphs for TEMPeffective QA progress tracking
• Leading collaborative efforts wif various application teams involved in dis project for: Speedy problem solving. Webmethods testing, Integration testing and User Acceptance testing. Test Data and Test Environment management. Allocating Task
• Coordinate Test Meetings/Defect Status Meetings wif impacted teams, Business, 3rd party vendors for the status of test progress and defect resolve completion status.Interacted wif the Business users by responding to the queries and provided Environment, Data, Test execution and process improvement support.
• E2E Data setup and synch-up validation wif in prescribed timeline and performed data creation process based on the project test data need for Business users.
• Involved in preparing various projects data, environment and defect metrics for Reporting and Root Cause Analysis.

Environment: Windows platform, Hybris(E-commerce application), POS(point of services), Data stage, Eclipse IDE, Unix, Web Methods, JAVA1.8, Selenium Web Driver, Middleware Web Services, TestNG, SOAP UI, Gherkin, Informatica, MPP, Sql Server, Notepad plus, Mobile Devices iphone/Samsung Galaxy/ipad, Postman

Confidential, Phoenix

Senior Software Quality Analyst

Responsibilities:

• Analyze Business Requirements, Prepare Technical design documents, Project Plan, Test Plan, Test Strategy, Test Cases, Data mapping documents for ETL data load, Responsible for performing source system analysis, identification of key data issues and Task tracking.
• Run automated test suite and evaluate performance, functionality, and scalability
• Performed backend testing of web application using SQL, writing queries to confirm correctness of data entered via UI, and data manipulation.
• Involved and Co-ordinate Functional, Website, Performance, Webmethods testing and Regression Testing of Oracle Financials Application and integration systems wif Oracle Financials.
• Design, customize, Test and involved in implementation of Oracle Financials requirements by coordinating wif Business and cross functional teams and provided support till post production launch.
• Create/execute/debug both manual and automated test suites using Quality Center, Selenium Web Driver, QTP and IBM Rational test management tools by reducing the overall project execution timeline and cost save to the Organization.
• Web service integration validation wif different Vocado web applications and Inbound/outbound file transfer process verification wif ETL/BI servers.
• Verification of ETL data feed files (Source system data) wif database tables matching Business transformation rules.
• Creating/Maintaining Requirements, Test scenarios, Test cases, Defect management using HP Quality Center. Development of SQL queries and Jasper Letters and Reports for Oracle Financials revenue verification.
• Involved in Functional Website Navigation Black box/White box, Regression, and Performance Testing of Oracle Financials Applications.
• Involved in Mobile browser testing using 3rd party Cloud service
• Convert manual tests into automated test suites for Regression/Smoke tests.
• Provided Guidance in developing test cases and track the execution in Quality Center, along wif graphs for TEMPeffective QA progress tracking
• Leading collaborative efforts wif various application teams involved in dis project for: Speedy problem solving. Webmethods testing, Integration testing and User Acceptance testing. Test Data and Test Environment management. Allocating Task
• Coordinate Testing Meetings/Defect Status Meetings wif impacted teams, Business, 3rd party vendors for the status of test progress and defect resolve completion status.Interacted wif the Business users by responding to the queries and provided Environment, Data, Test execution and process improvement support.
• E2E Data setup and synch-up validation wif in prescribed timeline and performed data creation process based on the project test data need for Business users.
• Involved in preparing various projects data, environment and defect metrics for Reporting and Root Cause Analysis.

Environment: Windows platform, Oracle Financials DB/APPs(EBS), Data stage, Unix, Web Methods, JAVA1.8, Selenium Web Driver, XPath,BI/Jasper Reports, Middleware Web Services, TestNG, SOAP UI, MPP, Sql Server, Notepad plus

Confidential, Phoenix

Sr. Software Quality Analyst

Responsibilities:

• Analyze Business Requirements, Prepare Test Plan, Test Strategy, Identify Test approach, conducted RRA(Requirement Risk Analysis)
• Execution of manual testing and automation testing for GUI web application, using tools like QTP, Load Runner
• Interpreted and converted manual test cases into automation smoke and regression suites.
• Executing GUI testing according to policies and procedures using QTP, Load Runner
• Involved in Mobile browser testing using 3rd party Cloud service- perfecto tool
• Performed backend testing of application using SQL, writing queries to confirm correctness of data entered via UI, and data manipulation.
• Creating/Maintaining Requirements, Test scenarios, Test cases, Defect management using HP Quality Center
• Involved and Co-ordinate Functional, Webmethods testing, Performance, Regression and Integration Testing of Entire Banking Application using Oracle, Middleware Web Services, SOAP UI, Web Methods and Unix File Processing
• Automate dynamic Views/Stored procedures creation from Data mapping documents using Unix/Perl and Test XML file generation for business validation.
• ETL inbound/outbound XML files validation matching source/legacy systems.
• Analyze and interpret all complex data on all target systems and provide resolutions to all data issues and coordinate wif data analyst to validate all requirements.
• Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications. Developed SQL queries and reports for Data Quality check
• Lead software test operations such as ensuring the availability of test environments and test data. Reporting to the Management regarding test completion status every EOD, using the HP QC Reports and Graphs. Reporting included:
• Number of test cases executed - passed / failed.
• Number of types of test cases executed (functional, integration, regression).
• Number of issues logged against the failed test cases.
• Test Management - Coordinating the QA test activities and assisting the team to ensure dat the tasks are delivered wif high quality on time
• Coordinate Testing Meetings/Defect Status Meetings wif impacted teams, Business, 3rd party vendors for the status of test progress and defect resolve completion status.
• Interacted wif the Clients by responding to the queries from Business user and provided support to the application.Create test report document as phase end deliverable for signoff

Environment: Windows platform, PMOL(Payment Manager Online), Oracle, Informatica, Middleware Web Services, SOAP UI, Web Methods Developer, Unix, Java, Winscp, Putty, Share Point, Testing and Reporting Tools, Android /iOS Mobile Browser Testing, Cloud service

Confidential, Phoenix

Senior Software Quality Analyst

Responsibilities:

• Analyze Business Requirements, Prepare Test Plan, Test Strategy, Identify Test approach, conducted RRA(Requirement Risk Analysis)
• Involved and Co-ordinated Functional, Performance and Regression Testing of Entire Web Application
• Execution of manual testing and automation testing for GUI, using tools like QTP, Load Runner
• Interpreted and converted manual test cases into automation smoke and regression suites.
• Executing GUI testing according to policies and procedures using QTP, Load Runner
• Did performance testing, scheduling, maintenance, and database backup/restore.
• Performed backend testing of application using SQL, writing queries to confirm correctness of data entered via UI, and data manipulation.
• Creating/Maintaining Requirements, Test scenarios, Test cases, Defect management using HP Quality Center. Developed SQL queries and reports for Data Quality check
• Involved and Co-ordinated Integration testing - Web application, Web Services (SOAP UI),Middleware(SOLAR) .Lead software test operations such as ensuring the availability of test environments and test data
• Develop test cases and track the execution in Quality Center, along wif graphs for TEMPeffective QA progress tracking. Organizing and managing test cases and defining test strategy and test plan as required. ETL inbound/outbound files validation matching wif E2E data setup requirements.
• Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications. Review test conditions, test cases, test results and defect status for appropriate completeness
• Test Management - Coordinating the QA test activities and assisting the team to ensure dat the tasks are delivered wif high quality on time
• Conduct Review/Walkthrough the Data Characteristics wif the application teams and Normalize the volume of the accounts to minimize the complexity of the data setup. Provided Guidance in developing and execting manual functional test cases and tracked the test results and defects in Quality center. Coordinate Testing Meetings/Defect Status Meetings wif impacted teams, Business, 3rd party vendors for the status of test progress and defect resolve completion status.
• Identify the root cause for the data setup issues by organizing bridge calls wif test support teams. Create test report document as phase end deliverable for signoff

Environment: Windows, MYCA, AESP, Card Services, Triumph, GDAS, MYCA eStatement, CRS, eSDR, Yodlee (3rd party interface), Informatica, Mainframe, DB2, SQL, Java, CU, SOLAR, SOAP UI (Web service Tool), Enlist, Share Point, Testing and MSTR Reporting Tools.

Confidential, Phoenix

Software Quality Analyst

Responsibilities:

• Analyze Business requirements and prepare Test Plan, Test Strategy and Conduct RRA to quantify the risk level of a requirement and estimate testing timeline based on the RRA risk factors
• Interpreted and converted manual test cases into automation smoke and regression suites.
• Performed backend testing of application using SQL, writing queries to confirm correctness of data entered via UI, and data manipulation.
• Experience of working on network protocols such as HTTP, TCP/IP, etc.
• Developed SQL scripts to validate relational database tables.
• Created Test Plans, Test Cases and Scripts for UAT, functional and regression testing.
• Involved in Functional and Performance Testing of Entire Application. Interacted wif the Clients by responding to the queries from Business user and provided support to the application. Ensure end to end testing is completed in Integration Testing before UAT starts. Create test report document as phase end deliverable for signoff

Environment: Windows, MSTR Reporting, Java, DB2, SQL, UNIX, Share Point and Testing Tools.