PROFESSIONAL SUMMARY:

• Over 8 years of professional experience including Seven plus years of progressive experience in Quality Assurance and Testing in Financial, Telecom and Insurance domain.
• Experience in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) including Test planning, testing estimation, Testing deliverables development, Test execution, and Defect management.
• Hands on experience working in Waterfall and Agile environment.
• Experience in reviewing product backlogs, creating and maintaining task boards, Test Plan, Test cases and traceability matrix for different Sprints and Cycles.
• Hands - on experience in analyzing requirements, system design specifications (SDS), user stories and preparing the Gap Analysis Document (GAR) using a standard checklist.
• Proficient in performing various types of testing including Environment acceptance, Functional, System, System Integration, Usability, Regression, UAT and End to End testing.
• Hands on experience in Test cases development and preparation of Test data for positive, negative and boundary condition testing.
• Hand on experience in Data warehouse testing and data validation, experienced in using and validating the ETL tool configuration, workflow, and Meta data for Informatica Power Center and Data Stage.
• Hands on experience in Web testing including Functionality, Usability, Compatibility, and Security testing.
• Hand on experience in Web services testing using tools like SOAP UI.
• Hands on experience using HP/JIRA Test and defect management tools.
• Experience working in agile environment, analyzing and reviewing Product backlogs, Task boards, User Stories for different Sprints.
• Hand on experience in Automation and Performance Testing Plan including Requirement gathering, test plan creation, Test scripts development, Scripts customization, execution, and Results analysis.
• Possess excellent skills in communication, documentation and problem solving, with a strong technical background.
• Quick learner, proven ability to work excellently and efficiently in both independent and team work environments.

TECHNICAL EMPHASIS:

Languages: VB.NET | VBScript |HTML | JAVA | .NET Framework | Visual Basic | SQL

Software: JIRA | Microsoft Office 2003/2007/2010 | SharePoint | Confluence

Technologies: MS .Net Web Technology | Client/Server

ETL Tools: Informatics Power Center | Data stage

Data Warehouse: Informatica | DataStage | Master Data Management (MDM) | IBM Initiate Master Data Engine | Workbench

EAI/SOA Software Packages: TIBCO BW 5.6/5.7 | EMS 4.3

Databases: Oracle | MS Access | DBMS | DB2 | SQL Server

Methodologies: Waterfall | Agile

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

Software QA Engineer

Responsibilities:

• We have been following the KANBAN Agile Methodology.
• Worked in an Agile Methodology and Kanban framework with respect to the change in application requirements.
• We follow BDD - Behavior-Driven Development approach.
• I have reviewed and analyzed User Stories, Backlogs, Design documents, Data mapping documents and created BDD’s for all stories.
• Participating in daily standup, backlog, functional specification and design review meeting.
• Meet with business users, business analyst and technical team to clarify any GAP identified during the review.
• Developed Test Plan, BDD’s and reviewed with the project team.
• Developed BDD’s (test cases) for integration testing, interfaces (inbound and outbound) and data flow validation.
• Responsible for developing the test cases to validate the ETL process, business rules, Data transformation rules, Reports layouts and data in Data Stage tool.
• Create requirements and Test matrix for ETL and Reporting Test cases in JIRA.
• Acted as the liaison between developers and business analysts to prioritize bug resolution.
• Tested the application for browser compatibility on various browsers like IE7, IE8, and Firefox.
• Developed automation test script using Selenium.
• Wrote complex SQL queries for Oracle database for backend/frontend comparative analysis i.e., to check the correctness of the data stored in the database.
• Collaborated with the web services development team.
• Responsible for configuration of the test environment, installation of applications, software’s, tools and code movement into the test environment.
• Responsible for identification and creation of test data in a test environment. Analyzed the impact analysis and identified the regression test cases during Regression testing after defect fix.
• Tested functionality and performance of web services/APIs using Soap UI.
• Created test data in Excel Spread sheet and converted it to the XML files for SOAP UI calls.
• Developed an automation process in Java to compare and validate multiple client files and created reports for the result set. This process reduced the testing time significantly. It used to be a manual effort but now all 36 clients are being validated in few hours.

Environment: Data Stage, JIRA, Zephyr, DB2, JAVA, Unix, JASON, XML, SOAP UI, Selenium.

Confidential,Kansas City, MO

Sr. Quality Assurance Analyst

Responsibilities:

• Worked in Agile environment and Scrum framework.
• Reviewed and analyzed User Stories, Backlogs, Design documents, Data mapping documents and existing used cases.
• Participated in daily standup, backlog, functional specification and design review meeting.
• Developed Test Plan, reviewed with the project team.
• Developed Test scenarios and Test cases for Functional testing.
• We used to have around 150 TIBCO mappings, I was involved in validating and testing of all these mappings.
• Create requirements and Test matrix for ETL and Reporting Test cases in HP Quality Center/JIRA
• Acted as the liaison between developers and business analysts to prioritize bug resolution.
• Wrote complex SQL queries in Microsoft SQL Server.
• Collaborated with the web services development team and worked o different API’s.
• Tested functionality and performance of web services/APIs using Soap UI.
• Responsible for configuration of the test environment, installation of applications, software’s, tools and code movement into the test environment.
• Responsible for identification and creation of test data in a test environment. Analyzed the impact analysis and identified the regression test cases during Regression testing after defect fix.
• Created test data in Excel Spread sheet and converted it to the XML files for SOAP UI calls.
• Acts as “customer advocate” when investigating defects found in production.
• Provides feedback based on application knowledge and understanding of customer issues.
• Reviews application and project documentation to ensure it meets customer needs.
• Trained team members on application, analysis and to support the product.

Environment: TIBCO Business Works (BW) 5.6/5.7, ADB Adapters, ASP.NET Web Services, SQL Server Management Studio 2013, Visual Studio 2013, Share Point, JIRA, Oracle, JAVA, JASON, XML, SOAP UI, Selenium.

Confidential, Overland Park, KS

Sr. QA Analyst

Responsibilities:

• Participated in daily standup, backlog, functional specification and design review meeting.
• Reviewing and analyzing the Business Analysis, Architecture Design, Integration, change requests document to understand the requirements, testing scope and finalized the testing approach.
• Meet with business users, business analyst and technical team to understand the change request.
• Developed new and updated existing test cases to test the change requests.
• Performed System, System Integration and end to end testing.
• Identified and created test data for testing.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Interacted with developers, Business & Management Teams and End Users
• Participated in regular project status meetings related to testing
• Maintained and updates test cases, test designs, service ware, and support documentation to ensure testing and support of applications is accurate.
• Coordinated with all integrated teams on end-to-end application testing and business process quality.
• Extensively worked on the Data Setup for all integrated teams based on the test scenarios. Loaded data to different databases using SQL Loader and SQL scripts and maintained a repository for data loading scripts.
• Used Shell scripts extensively for automation of file manipulation and data loading procedures.
• Execute batch processing and verify the jobs status and data in database tables
• Tracked the defects using Quality Center and generated defect summary reports
• Modified Configuration file according to space constraints
• Wrote shell scripts to run PL/SQL programs and job scheduling.
• Connected remotely to UNIX servers using PUTTY and FTP files across different test environments by using winscp and Command prompt.
• Prepared status summary reports with details of executed, passed and failed test cases
• Wrote and executed SQL queries to perform the backend data validation using SQL developer, SQL server management studio.
• Prepared test progress and defect report and communicated to management.
• Facilitated defect review meetings and improved existing defect management process, driven team to work in the faster manner by reporting defects status.

Environment: - Quality Center, Callidus Incentive Compensation System, Oracle 11g, SQL Server 2008, IIS 6.0, Actuate Reporting, Informatica.

Confidential,Kansas City, MO

Software Engineer

Responsibilities:

• Written Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Quality Center based on the Business Requirements, Functional Requirements and Business Workflows.
• Validated flat files coming from downstream systems and mocked up feed files by using VI editor.
• Participated in business requirements reviews and software system (application) designs for testability.
• Coordinated the Onsite and Offshore teams to resolve issues.
• Track and report upon testing activities, including the test case execution stage, defect status if any defects opened during execution and the testing results status.
• Ensuring content and structure of all the testing artifacts are documented in SharePoint Tool.
• Tested the data extraction procedures designed to extract data into flat feed files.
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
• Generated Reports in Front end and validated Reports in Backend to ensure data integrity and validate Business rules.
• Reviewed Error log files in UNIX box when an order fails to load into SQL tables.
• Facilitated defect review meetings and improved existing defect management process, driven team to work in the faster manner by reporting defects status.
• Prepared and maintained the release and cycles to keep track of code movement and testing using Quality Center.
• Responsible for uploading Test cases into Quality Center using excel add-in.
• Developed and generated test progress and defect reports from Quality Center.
• Utilize defect tracking tool HP Quality Center to trace, assign, verify and close defects.

Environment: .NET Web Services 3.5, C# 3.5, SQL Server 2008, IIS 6.0, Oracle 10g, SQL Server 2008, IIS 6.0, Informatica, MS office 2007, Share Point, Subversion, Quality Center 11.0

Confidential ,Minneapolis, MN

C# .NET Developer

Responsibilities:

• Developed ASP.NET WebServices to provide Confidential t’s health records data to medical claims processing .NET application using C#.
• Developed conceptual, logical and physical design documents.
• Provided support to ASP.NET Web-Forms applications.
• Developed Soap Extension to provide user authentication framework for WebServices.
• Created Unit Test Cases using MB Unit and TDD.NET tools.
• Skilled in using MS SQL Server tables, views, stored procedures, etc.
• Extensively worked on writing Stored Procedures, Triggers, Functions and Views.
• Created and maintained SSIS packages to Import/Export data from flat files, XML, Excel and Oracle.
• Experience in software unit testing and efficient at fact-finding, root cause analysis and bug-fixing.
• Migrated of classis ASP applications to ASP.Net and C#, MS Access to SQL Server.
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Developed and generated test progress and defect reports from Quality Center.
• Utilize defect tracking tool HP Quality Center to trace, assign, verify and close defects.

Environment: ASP.NET WebServices 3.5, C# 3.5, SQL Server 2008, IIS 6.0, Visual Studio.NET 2008 with Team Foundation Server (TFS), Quality Center.