SUMMARY:

• 9+ Years of IT experience in Analysis and Testing on Database using SQL Expertise in ETL/ Data warehouse backend testing and BI Intelligence reports testing Flexible to work with Netezza, SQL Server and Oracle 10g databases, MapR file system
• Data comparison by using various tools like Toad, Apache Drill
• BI Adhoc testing by using Cognos, TM1 PAW
• Worked with different BI models such as Star and Snowflake and strong working knowledge in dimensional modeling
• Proficient in providing technical expertise throughout the life - cycle of a project
• Have knowledge on debugging of Data Stage, Cognos report studio, SSIS, SSAS and SSRS packages
• Excellent Writing skills of Test Strategy, Test Scenarios and Test Cases
• Have Domain knowledge of Retail, Telecom and Manufacturing
• Highly analytical with strong thinking and problem resolving skills
• Solid understanding of FRD, SRS and Source to Target mapping
• Conducting Business walkthroughs with Customer and performing reviews on requirements
• Participation in design Model reviews
• Strong knowledge of Software Testing Life cycle and Software Development Life Cycles
• Expertise in Team Management skills
• Have good knowledge on effort estimation
• Have Experience in Application Testing
• Good exposure in Bug Triage and have Experience in Bug tracking Tools like QC, VSTS

TECHNICAL SKILLS:

Database: Netezza, SQL Server and Oracle 10g

File System: MapR

ETL Tools: Data Stage, SSIS, Informatica

Reporting Tools: TM1 Paw, Cognos Query Studio, Cognos Report Studio, SSAS, SSRS

Other Tools: Toad, Apache Drill, IceDQ, MS office, CA work station, Putty, SSH tectia

Applications: RPAS, MDM Sitehub

Languages: SQL, PL/SQL

Testing: Data wareHouse, Cube, Files, Data Migration, ETL, BI Report, Various applications

Domain: Retail, Telecom & Manufacturer

Test Management Tools: HP ALM, VSTS

Operating System: Windows 95/98/2000/XP, Unix

Methodologies: Waterfall Model, Agile Modeling

PROFESSIONAL EXPERIENCE:

Confidential

Test Lead

Tools: Apache Drill, ICEDQ, TM1 Excel Paw

Applications: RPAS, TM1 Paw

Environment: MapR, TM1, Extract files

Responsibilities:

• Understanding measures data at RPAS
• Data validation from RPAS application to TM1 Paw
• Data validation from TM1 paw to LP export files
• Designing test approach, Test scenarios
• Test scenario’s business review
• Data validation of Reports
• Managing onsite and offshore team and daily activities
• Designing of complex SQL scripts to test the complete functionality.
• Manage the test process and execution using Quality Center, generated reports for test coverage analysis
• Conduct Defect Triage meeting with Dev & project management team to know the defect status

Confidential

Test Lead

Environment: Netezza, SQL, Datastage, Cognos

Responsibilities:

• Verifying Data mart model to support business requirements in BI
• Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement
• Test plan design and strategies documents for variuos modules
• Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.
• Writing complex SQL scripts to test the complete functionality. Verification of SCD type 1, type 2 dimension and Fact table data validation by using complex sql queries
• Data validation of Cognos reports & Adhoc view by using sql
• Execution of Datastage jobs through Datastage & Unix
• Support business by providing data from Datamart in UAT phase
• Manage the test process and execution using Quality Center, generated reports for test coverage analysis
• Conduct Defect Triage meeting with Dev & project management team to know the defect status
• Managing onsite and offshore team and daily activities

Confidential

Test Lead/DA

Environment: Netezza, SQL, Datastage

Responsibilities:

• Works with existing Triversity team to understand the functionality of existing POS system for creating the Test Plan and Strategies
• Perform data analysis on EDW data to identify various possible sales transactions
• Works as DA to design data model for Master data movement from EDW to Xstore
• Data quality of TLOG transactions
• Design meetings to understand New POS system Xstore
• Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement
• Sales TLOG & Balance file transaction from Triversity and Xstore source systems
• Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.
• Writing complex SQL scripts to test the complete functionality
• Using ICEDQ tool for data comparison
• Execution of Datastage jobs through Datastage & Unix
• Manage the test process and execution using Quality Center, generated reports for test coverage analysis
• Conduct Defect Triage meeting with Dev & project management team to know the defect status

Confidential

Test Lead

Environment: Netezza, SQL, Datastage

Responsibilities:

• Works closely with Business to undestand the functionality of the project for creating the Test Plan and Strategies
• Data model validation to find out the issues in design
• Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement
• Managed Off shore team to support Onsite - Offshore model
• Test plan design and strategies documents for variuos modules
• Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.
• Writing complex SQL scripts to test the complete functionality
• Execution of Datastage jobs through Datastage & Unix
• Support for UAT phase
• Manage the test process and execution using Quality Center, generated reports for test coverage analysis
• Conduct Defect Triage meeting with Dev & project management team to know the defect status
• KT to new members in team
• Managing onsite and offshore team and daily activities

Confidential

Test Lead

Environment: Netezza, SQL, Datastage

Responsibilities:

• Works closely with Business to undestand the functionality of the project for creating the Test Plan and Strategies
• Data model validation to find out the issues in design
• Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement
• Managed Off shore team to support Onsite - Offshore model
• Test plan design and strategies documents for variuos modules
• Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.
• Writing complex SQL scripts to test the complete functionality
• Execution of Datastage jobs through Datastage & Unix
• Support for UAT phase
• Manage the test process and execution using Quality Center, generated reports for test coverage analysis
• Conduct Defect Triage meeting with Dev & project management team to know the defect status
• KT to new members in team
• Managing onsite and offshore team and daily activities

Confidential

Test Lead

Environment: Netezza, SQL, Datastage

Responsibilities:

• Works closely with Business to undestand the functionality of the project for creating the Test Plan and Strategies
• Data model validation to find out the issues in design
• Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement
• Managed Off shore team to support Onsite - Offshore model
• Test plan design and strategies documents for variuos modules
• Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.
• Writing complex SQL scripts to test the complete functionality
• Execution of Datastage jobs through Datastage & Unix
• Support for UAT phase
• Manage the test process and execution using Quality Center, generated reports for test coverage analysis
• Conduct Defect Triage meeting with Dev & project management team to know the defect status
• KT to new members in team
• Managing onsite and offshore team and daily activities

Confidential

Sr.Test Engineer

Environment: MS SQL Server 2008 R2 Database, SQL, SSIS, SSAS, SSRS

Responsibilities:

• Requirement Analysis
• Technical discussion with Test, Development teams and Project Manager
• Draft Test scenarios and Test Cases
• Development of Stored Procedures which required in testing and development
• Data Modelling Testing by using SQL
• Debugging the stored procedures
• Conducts Defect Triage meeting with Dev & project management team to know the defect status
• Daily updates to the Onsite PM on the progress of the testing.
• KT to new members in team

Confidential

Sr.Test Engineer

Environment: MS SQL Server 2008 R2 Database, .NET

Responsibilities:

• Performed Requirement Analysis to understand the customer requirements
• Participated in Database design meetings and reviews
• Participated in Application design meetings and reviews
• Designed Test Scenarios and test cases to cover the requirement
• Involved in technical discussions with Test, Development teams
• Conducted Defect Triage meeting with Dev & project management team to know the defect status
• Involved in project status tracking

Confidential

Test Engineer

Environment: MS SQL Server 2008 R2 Database, SSIS, SSAS and SSRS

Responsibilities:

• Perform Requirement Analysis to understand the business requirement
• Perform Designing of Test cases from Source to Staging, Staging to Cube and Source to Reports
• Perform System Testing, Performance Testing, Regression Testing
• Technical discussion with Test, Development and Confidential Team’s
• Update Daily status to the Clients in Daily Stand-up Calls and clarified the doubts if any
• UAT and Production support
• Debugging the Packages, Jobs as well
• Upload test cases into VSTF, executed the test cases and raised the Defects for the same
• Defect Tracking

Confidential

Test Engineer

Environment: MS SQL Server 2008 Database, SQL

Responsibilities:

• Interact with Onsite people over Conference calls
• Responsible for the implementation of configuration management
• Draft Test scenarios and Test Cases
• Review the test cases prepared by other Peer QA Engineers
• Involve in Database testing, functionality testing, System testing of the project
• Defect logging and Defect follow up in bug tracking tool Team Foundation Server
• Involve in Deployment of the builds in SIT and support in UAT and PROD environments
• Coordinate with the Project Lead for the new builds
• Daily updates to the QA Lead and Project Lead on the progress of the project
• Prepare release summary reports/Status

Confidential

Test Engineer

Environment: MS SQL Server 2008 Database, SSIS, SSAS, SSRS, SQL

Responsibilities:

• Requirement Analysis on Outage and KeyWest Modules
• Designing of Test cases from Source to Staging, Staging to Cube and Source to Reports
• System Testing, Performance Testing, Regression Testing, Rollback Testing & UAT
• Technical discussion with Test, Development and Confidential Team’s
• Defect tracking calls
• Daily status to the Clients in Daily Stand-up Calls and clarified the doubts if any
• Understanding the structure of Applications in source production support