SUMMARY:

• Software test professional with 10+ years of ETL testing experience in Health care domain,Mortgage,Telecom and Banking Domain.
• Involved in preparation of test scenarios and cases, test estimation, test execution, defect tracking and test summary reporting.usiness Intelligence Architect, Possess a Bachelors of Engineering and proven ability to manage multiple projects effectively.
• Experience in strategy, design, estimation, execution and reporting of test cases.
• Worked in projects, which were implemented by Agile Methodology.
• Experience in Preparing the Test Plan, Test Estimation and Test Summary Report.
• Expertise in analyzing functional issues and problem solving.
• Expertise in database testing on AWS Redshift, IBM Netezza and Microsoft SQL Server 2005.
• Experience in ETL and Reports (Micro strategy) Testing.
• Experience in developing automation software using Cucumber framework, Gherkin
• Flexible to adapt to new environments and work culture.
• Doing the Defect Analysis.
• Experience in Testing Tools like HP Quality Center 10.0, HP ALM 11.0 and HP ALM 12.
• Strong knowledge in SQL queries.
• Strong working knowledge in UNIX.
• Trained in HP Sprinter and SAP Testing.

TECHNICAL SKILLS:

Knowledge Domains: Health Care, Telecom and Banking.

Platform/Technologies: Microsoft SQL Server 2000/2005/2008/2012.

Tools/Packages: HP ALM, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Environment: s: Redshift, Java, Cucumber/Gherkin, REST client, Jenkins, JIRA, Crucible, TIBCO GEMS, Agile

System Analyst

Responsibilities:

• Writing the SQL’s based on the mapping document.
• Conversion of SQL’s from Netezza to Redshift.
• Preparation and execution of test cases.
• Validation of data by using DTF.
• Validation of data between Tableau Report and Databases.
• Responsible for developing automation software using Cucumber framework, Gherkin.
• Conducted working sessions with team.
• Conducted Retrospective sessions.

Confidential

Environment: s: Oracle 12c, GEMS, Java, Cucumber/Gherkin, REST client, JDBC, JMS, XML, Jenkins, Maven, JIRA, Crucible, TIBCO GEMS, Agile

System Analyst

Responsibilities:

• Understanding the use cases.
• Writing the user stories based on use cases.
• Preparation and execution of test cases.
• Validation of XML’s.
• Responsible for developing automation software using Cucumber framework, Gherkin.
• Posted messages using GEMs for manual testing.
• Developed REST client to test the data on external systems
• Coordinating with Business teams for requirement analysis and development.
• Supported application issues in higher environments
• Used GIT for version controlling and maven for building code
• Involved in peer reviews using Crucible and participated in design discussions
• Validating the data in Axway

Confidential

Environment: s: MS SQL 2010, UNIX

System Analyst

Responsibilities:

• Gathering requirements and to come up with understanding document.
• Involved in test estimation, preparation and execution of test cases.
• Count Validation between source and target tables.
• Data content Validation between source and target tables.
• Concatenating columns.
• Using joins with many tables.
• Verifying logics as per business requirement.
• Experience working with huge volumes of data, analyzing record sets for Data Quality, Data Validation and Metrics using SQL.
• Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.
• In collaboration with other team members, analyzed raw data to ensure the data will meet the business need. Worked with the business owner to identify key data elements that will be monitored on an on - going basis to ensure a high level of data quality within the Warehouse.
• Designing the SQL queries based on FDD.
• Attending regular project review calls / meetings. Monitor and escalate issues effectively, ensuring clear communication channels and timely voicing of risks on the projects.

Confidential

Environment: s: Microsoft.NET 4.0/VB.NET, Microsoft SQL Server 2008

Test Engineer

Responsibilities:

• Preparation of Test cases based on FDD.
• Involved in Manual Testing activities.
• Involved in functional and system testing.
• Conducting Regression Testing.

Confidential

Environment: s: Java, Hermes JMS, Quality Center 9.2.

Test Analyst

Responsibilities:

• Understanding User Stories and Preparing Test cases for new functionality accordingly.
• Involved in Requirement Analysis with designers and component level designers.
• Designing and Review of the test scenarios.
• Designing of the Functional Test Cases.
• Following Agile Testing Methodology with effective deliveries for the Customer satisfaction.
• Involved in CIT, OGS (Ongoing Support) & IVVT Support of SIP Trunking Service
• Involved in executing the test cases at sanity, functional and regression level.
• Execution of Scenarios for T2R and L2C flows.
• Execution of Inflight Testing Scenarios to check the new functionality with previously created faults.
• Maintain test environments and authorizing deployment of builds.
• Report, track & handle the defects in QC.
• Participating in daily defect status call and scrum call with programmer.
• Joining the weekly meeting and discuss proactively regarding the issues and open items.