EXPERIENCE SUMMARY

• ISTQB, HP Certified ALM and QTP Professional with 14+ years of experience in the field of Software Testing.
• Expertise in Manual testing, ETL Testing (10+ Years), Automation testing and proficient in Software Engineering Process Models and Standards. Expert in ETL Testing, TDM, Travel Transportation, P&C Insurance & Banking Domains including IBC & GAA reporting.
• Proficient in Black Box testing like ETL Testing, Functional Testing, Integration Testing, System Testing, Regression Testing, Installation Testing, Usability Testing
• Expert in P&C domain and hands on experience in IBC & GAA reports testing (Auto stat plan premiums reporting, Losses, commercial liability, QASP, FCSA & Schedules 89 & 90)
• Work with business and development teams to understand the requirements and plan accordingly
• Planning, deploying and managing the testing effort for any given project/engagement
• Experienced in efforts estimation, resource allocation and delegate testing activities
• Handled diverse team of Quality Assurance specialists Onshore - Offshore model
• Building up and leading the 20+ Testing Team members to the success of project
• Enhance QA methodology for test, defect management and tools supporting processes
• Review test strategies and test plans and ensure coverage for functional, SIT, performance and aspects are covered and tested
• Supporting and assisting in UAT planning and execution
• Well versed with the End to End testing activities from initiation till closure (test planning to Production deployment)
• Maintain defect triage process, defects review and communicating the same to project team
• Defining the scope of testing within the context of each release/deliverable
• Applying the appropriate test measurements and metrics in the project
• Coach, develop and provide guidance to team members on QA processes and best practices
• Report bugs, create and provide metrics on bugs as they move through the bug cycle
• Present QA status of testing with state-of-the-art dashboards and highlight key blockers and where help is needed to the business/leadership teams
• Review of Scenarios, Test cases and traceability matrix
• Proficient in different software development life cycle models, CMMI level procedures and processes
• Experience in test strategy preparation for TDM capabilities like Sensitivity Profiling, Data Masking, Data sub-setting & Test data generation for test data needs
• Extensive experience in testing and reviewing of dimensional modeling (Star and Snowflake) of data warehouse & managing 20+ member teams
• Work experience reviewing and testing of data maps between various legacy systems and relational databases
• Experience includes testing of applications which use integrated databases using SSIS, Informatica, Teradata, Oracle, SQL Server and DB2
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications
• Worked in multiple responsibilities such as reviewing of ETL architecture, ETL design, analysis and ETL technical specifications
• Strong hands on experience in ETL Testing on relational databases, flat files, Xml’s using SSIS & Informatica
• Extensive experience on test data planning for multiple releases, data loads on to QA environments using Control-M scheduler tool
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases
• Solid Back End Testing experience by writing complex SQL Queries

TECHNICAL SKILLS

Insurance Software(s): Duck Creek (P&C)

Testing Tools: HP-QTP 9.2v, 10v, 11v

Languages: C, C++, Java

Scripting Languages: Shell Script, HTML, VB Script, Java Script

ETL Tools: SSIS, Informatica & Ab Initio

RDBMS: Oracle, SQL Server, Teradata

Information Discovery tools: Oracle SQL Developer, Teradata SQL Assistant

Operating Systems: Windows 2003, XP, Windows 8.

Defect tracking tools: Azure DevOps, TFS, HP-QC, ALM, JIRA

Version Control: Visual Source Safe 6.0

Job Scheduler tool: Control M

Bulk Data Processing: Mainframe

BI Reporting tools: MicroStrategy, Web Focus (Operational & Financial)

PROFESSIONAL EXPERIENCE

Confidential

Test Lead

Environnent: Duck Creek application, Azure Devops, MicroStrategy Reporting, Putty & SharePoint, SQL Server Management Studio, Control-M, SSIS & WinsQL

Responsibilities:

• Analyze Business / Functional requirements by interacting with Business, Development and Project team
• Analyze system (functional and non-functional) requirements and review the functional design specifications
• Involved in Understanding the requirements and preparing the test strategy, test plan Performing functional, System and Regression testing
• Documented Test Results, Traceability Matrix Consolidation and preparation of test summary reports, daily status reports and weekly status reports
• Review the FSD, Data Model & STM’s as per the business requirements
• Ensure the overall quality of the project & Data loads using Control-M on to QA env
• Established “Best Practices” and plan for continuous improvement of processes
• Data Validation between Staging, Integration & Datamart using complex queries as per the source target mappings
• Validations of BI reports (Operational & Financial) in MicroStrategy and Web Focus
• Identified, report bugs with logs and traces appropriate root cause to the problem
• Reporting bugs and Requirement walk through Daily interaction with the client & onshore team about status and execution plan
• Review Test cases at Feature, Module, Regression and Business Process levels
• Expert in multi-tasking on parallel releases & involved in end to end project initiation to PROD deployment
• Successfully delivered around 15+ releases on the above major project in the past 3.8 Years
• Show casing the QA metrics to the PM’s and senior management

Confidential

Test Lead

Environnent: TDM Central tool, Informatica, Cognos, Oracle, SQL Server, Unix, Citrix, Putty & SharePoint

Responsibilities:

• Analyze Business/Functional requirements by interacting with Business and Project team
• Preparation of Test Strategy, Test Plan and Effort estimates
• Extracting the data from different source systems and loading them to the TDM Central environment and validating the Source and TDM central tables data
• Develop test procedures and other quality documentation: test plans, test cases, and status reports for management
• Responsible for Identifying scenarios and creates SQL scripts for identified scenarios validate data transformations
• Running the data loads to the target environments
• Test data design and preparation
• Data mining and reservation for future needs
• accept and clarify testing requirements
• identify and prioritize test conditions addressing product risks and features to be tested
• define specific tests that must be designed for that area
• design test cases and sets of test cases to cover test conditions
• identify necessary test data to support test conditions and test cases
• schedule test executions in order
• execute or delegate exploratory, automated, and regression tests
• analyze actual results against the expected ones
• participate in the technical review process contributing behavioral viewpoint
• Bug metrics and triage
• Validation of Cognos BI Reports
• Involved and coordinated SIT testing with multiple teams
• Support provided to the business users on the UAT testing
• Reviewed the UAT bugs/observations and root cause analysis was prepared and best practices implemented in the next upcoming releases
• Calling out the risks/issues foreseen with the senior management

Confidential

Test Lead

Environment: Informatica, Teradata, DB2, Control M, Citrix

Responsibilities:

• Analyze Business / Functional requirements by interacting with Business, Development and Project team
• Analyze system (functional and non-functional) requirements and review the functional design specifications
• ETL Test Cases Preparation based on the business requirements and Mapping Logic
• Prepare and Review Test cases at Feature, Module, Regression and Business Process levels
• Executing the test cases, Reporting bugs and Requirement walk through Daily interaction with the client & onshore team about status and execution plan
• Testing the result by preparing SQL queries for source and target for each scenario in functional spec
• Data validation using Information Discovery tools, preparation of test execution report
• Involved in Understanding the requirements and preparing the test plan Performing functional, System and Regression testing to make sure application is meeting all the requirements
• Documented Test Results, Traceability Matrix Consolidation and preparation of test summary reports, daily status reports and weekly status reports
• Execution of functional test cases, to the compliance of the functional design documents
• Detect, analyze and report bugs with logs and traces appropriate to the problem, for further analysis by the development team
• Mentoring new members
• Ensure the overall quality of the project
• Plan the necessary skills update for the team to perform the tasks efficiently
• Review the functional documents and Requirement analysis document and raised reviewed comments against it and got it fixed
• Established “Best Practices” and plan for continuous improvement of processes

Confidential

Test Lead

Environment: Informatica, Oracle, SQL/PLSQL, WinCvs, Xfree86, MVS

Responsibilities:

• Analyze Business / Functional requirements by interacting with Business, Development and Project team
• Analyze system (functional and non-functional) requirements and review the functional design specifications
• Preparation of test strategies, test scenarios, test cases & created input test data in Quality Center for various modules
• Data Loading to the downstream systems and validating the tables against the files loaded
• Executed test scripts in QC, Performed Manual Testing on various Modules & Functionalities of the Application as per the Functional and Business specifications documents
• Preparation of test execution report
• Documented Test Results, Traceability Matrix Consolidation and preparation of test summary reports, daily status reports and weekly status reports
• Prepare and Review Test cases at Feature, Module, Regression and Business Process levels
• Execution of functional test cases, to the compliance of the functional design documents
• Detect, analyze and report bugs with logs and traces appropriate to the problem, for further analysis by the development team
• Submitted status report and feedbacks in daily meetings with clients
• Mentoring new members
• Ensure the overall quality of the project
• Plan the necessary skills update for the team to perform the tasks efficiently
• Review the functional documents and Requirement analysis document and raised reviewed comments against it and got it fixed
• Established “Best Practices” and plan for continuous improvement of processes

Confidential

Test Analyst

Responsibilities:

• Understanding the application under test
• Understanding the Software Requirements and Specifications
• Involved in preparation of Test Plan
• Identified Test scenarios as per Software Requirements and Specifications
• Prepared Test Cases as per Software Requirements and Specifications
• Preparation of test data for various levels of testing
• Generation of automation test scripts using the testing tool
• Preparation of test scripts for each feature list
• Preparation of Test Log after Execution of Tests
• Preparation of Interim Test Reports
• Test data preparation and execution
• Executed Test scripts and prepared the defect Report
• Logging the defects in Quality Center- HP
• Responsible for various testing activities like Functional, system, Integration, UAT and End to End Testing
• Reported the defect list to the Development Team
• Involved in Daily status meetings with development team along with testing team
• Working closely with Development team and preparing weekly status reports for client reference

Confidential

Software Test Engineer

Environment: C#, ASP.Net, SQL Server 2005, VTrac

Responsibilities:

• Understanding the Software Requirements and Specifications
• Involved in preparation of Test Plan
• Identified Test scenarios as per Software Requirements and Specifications
• Prepared Test Cases as per Software Requirements and Specifications
• Executed Test Cases and Prepared the Bug Report
• Developed Test scripts as per Software Requirements and Specifications
• Executed Test scripts and Prepared the Bug Report
• Logging the bugs in VTrac
• Responsible for various testing activities like Functional, Sanity, Integration and End to End Testing
• Reported the Bug list to the Development Team
• Involved in Daily status meetings with development team along with testing team
• Working closely with Development team and preparing weekly status reports for client reference
• Preparation of test data for various levels of testing

Confidential

Software Test Engineer

Environment: VB.Net, ASP.Net and SQL Server 2005

Responsibilities:

• Understanding the Software Requirements and Specifications
• Identified Test scenarios as per Software Requirements and Specifications
• Prepared Test Cases as per Software Requirements and Specifications
• Executed Test Cases and Prepared the Bug Report
• Logging the bugs in VTrac
• Responsible for various testing activities like Functional, Integration and System testing
• Reported the Bug list to the Development Team
• Involved in Daily status meetings with development team along with testing team
• Working closely with Development team and preparing weekly status reports

Confidential

Software Test Engineer

Environment: Java, J2EE, Oracle9i

Responsibilities:

• Understanding the Software Requirements and Specifications
• Developed Test Cases as per Software Requirements and Specifications
• Executed Test Cases, Prepared the Bug Report, Daily and weekly status reports
• Reported the Bug list to the Development Team

Confidential

Software Test Engineer

Environment: .Net Technologies, SQL Server 2000

Responsibilities:

• Involved in manual testing for the following activities
• Understanding the Software Requirements and Specifications
• Developed Test Cases as per Software Requirements and Specifications
• Executed Test Cases and Prepared the Bug Report
• Reported the Bug list to the Development TeamAwards and Accolades
• Received Rock Star award for the extra mile of efforts showcased in end to end project delivery in Capgemini
• Received Bronze star award for training the FLP resources on the software testing in Capgemini
• Received STAR TEAM award for successful implementation of Cabin Crew Tracking Program one of the biggest IT change programs within British Airways.
• Received On the Spot TCS Gem award for successfully completing the TIARA assessment
• Received Appreciation notes from Assurance delivery owner for my hard work, Commitment and significant contribution on complex project delivery