We provide IT Staff Augmentation Services!

Technical Test Lead Resume

SUMMARY:

  • 7+ years of experience in the fields of Information Technology, Cable and Advertising, Financial, Aeronautical focusing on Quality Assurance and Testing.
  • Expert in writing SQL queries and experienced in testing Functional, ETL and BI applications.
  • Experience in Software Development Life Cycle (SDLC) using Waterfall Model, Rational Unified Process (RUP) with a good understanding of Agile Methodology.
  • Data Analysis: Experience in Data Analysis involving Data Cleansing, Data Conversions, Data Transformation, Data Quality Analysis, Data Relationships, Source Systems Analysis and Reporting Analysis.
  • Excellent analytical skills in understanding business process and functionality requirements while translating them into system specifications
  • Extensive experience in IT industry in testing client server and web based applications
  • Creating Use cases and Activity diagrams using UML tools and Microsoft Visio.
  • Familiar with Data flow diagrams, Work flow diagrams and Process flow diagrams.
  • Worked with the development team to ensure testing issues were resolved.
  • Performed backend data testing using PL/SQL scripts to check the data consistency, data integrity in the application and database as data was fetched from different database tables.
  • Proficient in using any flavor of UNIX operating system by writing various UNIX commands.
  • Extensive experience in performing data mart and data validation testing for data migration
  • Perform bug tracking and Reporting using Quality Center.
  • Experience in working with Analysts, Managers and Developers during the software development life cycle (SDLC).
  • Extensive experience of Data Integration between various systems, sources, and databases. Experience in implementation of ETL methodology in Data Extraction, Transformation and Loading using Informatica.
  • Proficient in Data warehousing and business intelligence concepts, design principles, and software architecture.
  • Experience in Unit Testing, Integration testing, System Testing (Functionality and Regression), Performance testing and User Acceptance Testing.
  • Strong experience in working with HP/ALM, Quality Center and QTP.
  • Strong working knowledge of Team Foundation Server (TFS) and Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
  • Experienced in GAP Analysis, Cost Benefit Analysis, organizing, facilitating and coordinating JAD sessions, weekly meetings, conference calls and other regular project meetings.
  • Valuable experience in coordinating with off shore resources and vendor selection.
  • Involved in the development of Test Plans, Test Cases and maintaining the Traceability and Test Matrix.
  • Detail oriented with strong multitasking and interpersonal skills and ability to resolve problems.
  • Motivated, self - starter, with exceptional team building and leadership skills.

EXPERTISE INCLUDES:

  • HP Test Director
  • HP Quality Center
  • Rational Clear Quest
  • JIRA
  • TFS,MTM
  • SQL
  • PL/SQL
  • SQL Developer
  • DB Visualizer
  • SQLDX
  • Squirrel
  • Oracle 11g/10g/9i
  • Hadoop Hive
  • SQL Server
  • HP Vertica
  • TERADATA
  • Informatica Business Objects
  • Microstrategy
  • Tableau Cognos

PROFESSIONAL EXPERIENCE:

Confidential

Technical Test Lead

Responsibilities:

  • Tested all the ETL processes developed for fetching data from SAP, SQL Server, Teradata to the target Market Data warehouse Oracle using complex SQL queries.
  • Experience in SAP BW Testing, Data Migration testing and BI report testing
  • Worked on Confidential Solution tool Perfaware during data migration from PeopleSoft DB to HCM fusion on oracle cloud to achieve 100% Test Data Coverage.
  • Worked on SAP BO and Micro strategy report validation.
  • Carried out Test Case Execution and Defect logging also did Weekly reporting and test report preparation.
  • Tracked defects to closure by coordinating with the dev team.
  • Tested source data for data completeness, data correctness and data integrity.
  • Performed End to end testing starting from the source to the report.
  • Conducted and co-ordinated with integration testing and regression testing.
  • Participated in business requirements gathering and in modifications of the requirements based on the scope.
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
  • Prepared test data to cover all the test scenarios.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
  • Also used JIRA to update the project plan and daily progress including defects.

Environment: Informatica 9.1, SQL Server 2010, SQL developer for Oracle, SAP SE16, Teradata HP Quality Center/ALM 10.0,Microstrategy BI tool

Confidential

Technical Test Lead, Dallas,TX

Responsibilities:

  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • Tested all the ETL processes developed for fetching data from SQL servere system to the target Market Data warehouse Oracle using complex SQL queries.
  • Tested the entire compliance reports generated using Cognos BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
  • Tracked defects to closure by coordinating with the dev team.
  • Tested source data for data completeness, data correctness and data integrity.
  • Performed End to end testing starting from the source to the report.
  • Conducted and co-ordinated with integration testing and regression testing.
  • Participated in business requirements gathering and in modifications of the requirements based on the scope.
  • Participated in Sprint review meeting for Web based applications and involved in Sprint planning meetings.
  • Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
  • Defect logging, assignment and tracking through (MTM) Microsoft Test Manager.
  • Prepared test data to cover all the test scenarios.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
  • Also used JIRA to update the project plan and daily progress including defects.

Environment: Informatica 9.1, SQL Server 2010, TFS, MTM, SQL developer for Oracle, HP Quality Center/ALM 10.0,Cognos BI tool, Netezza

Confidential

Sr.QA Analyst, West Chester, PA

Responsibilities:

  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • Tested all the ETL processes developed for fetching data from Hadoop Hive system to the target Market Data warehouse Oracle using complex SQL queries.
  • Tested the entire compliance reports generated using Tableau BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
  • Performed data validation on the flat files that were generated in UNIX and Hadoop environment using UNIX and Hadoop fs commands as necessary.
  • Tracked defects to closure by coordinating with the dev team.
  • Tested source data for data completeness, data correctness and data integrity.
  • Performed End to end testing starting from the source to the report.
  • Conducted and co-ordinated with integration testing and regression testing.
  • Participated in business requirements gathering and in modifications of the requirements based on the scope.
  • Participated in Sprint review meeting for Web based applications and involved in Sprint planning meetings.
  • Worked on JIRA to effectively manage the product life cycle
  • Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
  • Defect logging, assignment and tracking through (MTM) Microsoft Test Manager.
  • Worked on data migration in SQL server for one of the web based application where the historical data from CRM system was migrated to new system OMS database.
  • Prepared test data to cover all the test scenarios.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
  • Also used JIRA to update the project plan and daily progress including defects.

Environment: Informatica 9.1, SQL Server 2010, SQL developer for Oracle, HP Quality Center/ALM 10.0, XML, Hadoop Hive, Tableau BI tool, HP Vertica database, SQLDX for Hadoop hive, Squirrel client for Hadoop, DB visualizer for Vertica, JIRA

Confidential

ETL/BI.QA Analyst, West Chester, PA

Responsibilities:

  • Prepare Test Strategy and detailed Test Plan for testing Global One - Client Server application and Enhance Custody - Web Based application emphasizing on the scope, approach and effort estimation
  • Analyze the Business requirements to formulate design and, document Test Scenarios and Test Cases
  • Construct and maintain Requirements Traceability Matrix
  • Worked with the DW Architecture team in Testing complex Delta processing Loads
  • Prepared PL/SQL scripts for executing backend queries and performing data analysis.
  • Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Design and execute the test cases on the application as per company standards.
  • Preventing occurrences of multiple runs by flagging processed dates.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags.
  • Interacting with senior peers or subject matter experts to learn more about the data.
  • Identifying duplicate records in the staging area before data gets processed.
  • Extensively written test scripts for back-end validations.
  • Testing of multiple ECM Reports using SQL Queries on Toad
  • Responsible for Database Migration from Oracle 9i to Oracle 10g
  • Execute SQL queries to perform Backend testing to ensure data validation
  • Performed extensive integration testing of the application to and from the UNIX and Mainframe systems
  • Perform volume testing to monitor system s threshold for uploading and downloading transactions to and from the other downstream systems
  • Conduct Regression testing on the system each time a new build comes through
  • Overall responsibility for defect management - Defect logging, reporting, tracking, testing, closing etc using Rational Clear Quest
  • Responsible for weekly status update meetings
  • Mentor junior testers and provided one-on-one training on the application with emphasis on improvising the overall quality of software process
  • Provide technical presentations and training workshops for end users

Environment: Toad, Informatica, SQL, PL/SQL, SQL Developer, MS-Office, Rational Clear Quest, HP Quality center, UNIX, Shell Scripting, Mainframe, Windows XP and Oracle

Confidential

Test Engineer, New York, New York

Responsibilities:

  • Prepare Test Strategy and detailed Test Plan for testing Global One - Client Server application and Enhance Custody - Web Based application emphasizing on the scope, approach and effort estimation
  • Analyze the Business requirements to formulate design and, document Test Scenarios and Test Cases
  • Construct and maintain Requirements Traceability Matrix
  • Worked with the DW Architecture team in Testing complex Delta processing Loads
  • Prepared PL/SQL scripts for executing backend queries and performing data analysis.
  • Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Design and execute the test cases on the application as per company standards.
  • Preventing occurrences of multiple runs by flagging processed dates.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags.
  • Interacting with senior peers or subject matter experts to learn more about the data.
  • Identifying duplicate records in the staging area before data gets processed.
  • Extensively written test scripts for back-end validations.
  • Testing of multiple ECM Reports using SQL Queries on Toad
  • Responsible for Database Migration from Oracle 9i to Oracle 10g
  • Execute SQL queries to perform Backend testing to ensure data validation
  • Performed extensive integration testing of the application to and from the UNIX and Mainframe systems
  • Perform volume testing to monitor system s threshold for uploading and downloading transactions to and from the other downstream systems
  • Conduct Regression testing on the system each time a new build comes through
  • Overall responsibility for defect management - Defect logging, reporting, tracking, testing, closing etc using Rational Clear Quest
  • Responsible for weekly status update meetings
  • Mentor junior testers and provided one-on-one training on the application with emphasis on improvising the overall quality of software process
  • Provide technical presentations and training workshops for end users

Environment: Toad, SQLServer, SQL Developer, MS-Office, Rational Clear Quest, UNIX, Shell scripting, Mainframe, Windows XP and Oracle

Hire Now