SUMMARY:

• Over 6 years of experience in Enterprise Software Quality Assurance (QA), automation and manual testing, Managing test planning and test strategy, QA Analyst, Web Service automation testing, Back - end job flow testing using ESP scheduler, End to End ETL/Data Warehouse test and development using Informatics and related databased technology.
• 1 Year as lead QA Analyst for currency upgrade project using Linux, Oracle, Shell script, Basic Automation using ruby cucumber, ESP Scheduler at Confidential, Columbus OH
• 2 Years in project test strategy, test planning and execution of on-line Web Interface using web technologies, Web Services automation using SOAP UI Pro and SQL & backend database at Confidential
• 3 Year in testing planning, QA analyst, project test strategy, end-to-end test execution of data warehouse system using ETL, Oracle, PL/SQL, SQL and Unix at Confidential Investment, PA

TECHNICAL SKILLS:

Methodologies: Agile, Waterfall

Operating Systems: Windows 2000/XP/7, UNIX/Linux

Bug Tracking: HP Quality Center, Jira

Middleware: RESTful Web Services, SOAP UI Pro

Databases/Tools: Informatica 9.1/8, Oracle 9i/10g/11g/12c, TOAD

Languages: HTML, SQL, PL/SQL, Ruby, Cucumber

Software Package: CA Workstation (ESP Scheduler), ServiceNow, Splunk (Log Analysis)

PROFESSIONAL EXPERIENCE:

SQA Project Analyst/Tester

Confidential, Columbus, OH

Responsibilities:

• Developing test strategy documentation and getting review/approval from stakeholders
• Building dependency matrix for each application component so that end-to-end dependency can be identified for smooth migration without blockers.
• Unix Shell programming and Linux/Unix commands
• Test data setup and Informatica workflow execution, validation of workflow mapping and target database
• Building test suite for application and review of regression test suite.
• Review of Unix shell scripts, ESP Jobs and database migration and performing impact analysis.
• Performs functional, Regression, System Integration, User Acceptance
• Log Analysis and application health check review.
• Coordination with external team’s test leads for dependencies and execution of test cases and managing decencies.
• Performance and non-functional testing
• Develops and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products
• Conducts variance management by analyzing and verifying test results, providing status and progress reports
• Uses Agile in daily scrum/standup. Review work done, pending work, what are we doing today, what we did yesterday, any blocker for test data or defect blocking future testing, goal for today etc.
• Microsoft Word, Excel, Power Point, Visio for writing test document, requirements, test cases, test data, test strategy
• Visio for business process flow walk through end to end.
• Power Point for presentation and show and tell of what is tested overview of the end to end testing and gain approval from stakeholders
• Test data management through SQL
• Used SQL for fetching the data from database using sql queries, complex query join for relational data
• Tracks defects and life cycle management in Quality center
• Used SharePoint to store documents
• RTC to store manage stories and approval
• Followed SQA best practices for all phases of testing using Unit, system, user acceptance testing
• Implements Agile testing practices and test planning
• Analyze requirement carefully against the business use cases
• Identify gaps early and highlight so that we catch gap early in the process and avoid rework later, save cost

Environment: SQL, Oracle 11g/12c, Toad, Quality Control, SOAPUI Pro 1.4, Unix, ESP, Informatica ETL

SQA Analyst

Confidential, Wheeling, West Virginia

Responsibilities:

• Reviews requirements for testability and usability, consulted with development and business team for system functionality
• Executes testing for online security questions and authentication
• Perform usability and digital content testing in various browsers and operating system, mobile devices.
• Performs SOAP/RESTful Web Services automation testing using SOAPUI Pro
• Builds the xml and JSON request payload for RESTFul Web Services and testing, verification of web service response
• Performs functional, user experience, Regression, System Integration, User Acceptance
• Configuration and content testing for web-based online application
• Performance non-functional testing in various browsers and operating system
• Tests application security features, including session expiry, book marking, passwords and compatibility across multiple browser types
• Develops and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products
• Conducts variance management by analyzing and verifying test results, providing status and progress reports
• Creates test cases, test plans, executed database queries for testing purposes
• Uses Agile in daily scrum/standup. Review work done, pending work, what are we doing today, what we did yesterday, any blocker for test data or defect blocking future testing, goal for today etc.
• Visio for business process flow walk through end to end.
• Power Point for presentation and show and tell of what is tested overview of the end to end testing and gain approval from stakeholders
• Test data management through SQL
• Used SQL for fetching the data from database using sql queries, complex query join for relational data
• Insert, update, delete SQL for data updates
• DDL statement to create alter table using SQL
• Manages test case using Quality Center
• Tracks defects and life cycle management in Quality center
• Used SharePoint to store documents
• VSS to store version control documents followed SQA best practices for all phases of testing using Unit, system, user acceptance testing
• Performance testing to make sure that customer get quality system
• Measures testing effectiveness by logging all production defects comparing month by month
• Test automation of Web Services and most of the UI component
• Security testing of application
• Implements Agile testing practices and test planning
• Analyze requirement carefully against the business use cases
• Review with all stakeholders for completeness and approval

Environment: SQL, Oracle 10g, Toad, Web/App Server, HTML, Quality Control, SOAPUI Pro 1.4, Google Chrome REST Client, Splunk (Log Analysis)

Informatica ETL QA Analyst

Confidential, Oaks, Pennsylvania

Responsibilities:

• Verified business requirements and functional specifications
• Analyzed database and understanding the data model
• Executed Informatica Workflow, deployment of workflow and processing from OLTP database to Decision Support Database (DSS) and testing of workflow
• Compared the source and target data and identifying gaps and defects
• Tested workflows and unit and system testing
• Conducted system functionality testing: developed and executed test cases, produced problem reports, suggestions, system test logs, and test incidents reports
• Involved in code and deployment document reviews
• Used Agile for Biweekly team planning, stories review, estimation for testing, development/build. Discuss dependencies, sequencing. Prioritize stories to be build and tested both from business and IT
• Responsible for end to end DSS database ETL which is used to generate reporting and statement
• Tested the statement print process end-to-end
• Executed the print job (execution only).These were written by develop, comparing the customer data in the database and on the statement. Test script and execution using Quality Center
• Mapped requirement and test case and getting approval from business partner using Quality Center
• Used SQA best practices on all phases of testing
• Compared logs from month to month to measure testing effectiveness
• Used Agile Methodology for testing practices and test planning
• Created the Test Process/Support Documentation
• Identified gaps early to prevent rework
• Mapped requirements to test scenario/test cases
• Understand nonfunctional requirements
• Performed end of day test batches using Informatica

Environment: Informatica Power center 8.1, SQL, PL/SQL, Oracle 9i, Quality Control