We provide IT Staff Augmentation Services!

Test Lead Resume

Quincy, MA


  • Overall 9+ years of experience in Information technology.
  • 7 years of experience in Datawarehouse,Datamart and Business Intelligence (ETL & BI) testing, functional and database testing in Insurance domain.
  • 2 years of experience in Confidential on Data Quality, Reporting, Dashboards, Qualys integrations in investment banking domain.
  • Experience in end - to-end DWBI testing including creation of test plan & test strategy, preparation of test estimates, test approach, defect tracking, test cases review and Metrics collation.
  • Proficient in analyzing Business Requirements, System Requirements, Functional Requirement Specification (FRS), Design Documents, Use Case Specifications, and User Stories.
  • Well acquainted with all phases of Software Development Life Cycle & Software Testing Life Cycle Concepts.
  • Excellent Analytical, Problem Solving and Documentation skills including Team leadership coupled with aptitude to motivate team members towards goals, and strong interpersonal, written & oral communication skills and capable to work on multiple project/product assignments.
  • Strong at testing ETL process & BI Reports and ensuring data correctness & data quality as per the Business requirements.
  • Experience in using Service NOW CMDB platform to create reports, Dashboards, Identify data quality issues.
  • Experience in writing Unix commands.
  • Experience in using Autosys tool.
  • Experience in setting up QA best practices and making sure that team is following the set process.
  • Strong experience in DWBI Testing, Data Migration Testing, Database Testing, Regression, System Integration and UAT.
  • Has experience in Agile Development Methodology.
  • Sound knowledge and experience in Test Design, Test Execution and Test Results Analysis.
  • Hands on experience in designing and executing test scripts.
  • Extensive experience in test data setup based on business requirement.
  • Extensively performed ETL, Datamart (IBM DataStage) testing and Report (OBIEE) testing.
  • Experience in testing jobs developed by IBM Datastage and Informatica tool.
  • Good knowledge and working experience in using UNIX commands
  • Validated reports developed in OBIEE.
  • Experience in trading tools like Long View trading system (LVTS), iRouter, iCross, QAT, IPO applications.
  • Having experience on IBM OPTIM tool.
  • Experience in TDM (test data management) Re- Engineering data end to end process to analyze relationships between all tables from each DB to subset data using IBM OPTIM tool.
  • Experience in identifying PII elements to mask data for any DB.
  • Possess Excellent problem solving skills and Flexible to the work environment
  • Good understanding and experience of every phase of QA Life cycle, beginning with planning to the release of the product.
  • Experience in creating Requirement Traceability Matrix to ensure comprehensive test coverage of requirements.
  • Good experience in writing Queries for the following databases (Teradata, MS-Access, Oracle 10g/11g, SQL Server)
  • Good experience in using tools like SQL Developer, TOAD, SQL server management studio.
  • Possessing Strong SQL skills.
  • Closely worked with business to understand the features and design the test approach.
  • Experience in GUI Testing, System & Functional Testing, Ad-hoc testing, Black Box Testing, And White Box Testing.
  • Experience in Defect management, defect analysis and defect reporting using various Defect Tracking Tools like HPALM, JIRA.
  • Experience in writing Unix commands using tools like Putty.
  • Experience in using WinScp, FileZilla tools.
  • Lead team of testers of team size up to 6, Managed small to medium size projects, and have experience in interacting with offshore teams, onsite teams, clients counterparts.


Database: MS-Access, Oracle 10g/11g, Teradata

ETL Tools: Datastage, Informatica, IBM OPTIM and Autosys tool.

Platforms: Confidential

Reporting Tools: OBIEE

Test Management Tools: HP Quality Centre, ALM, JIRA

Operating System: Windows,UNIX

Defect Tracking Tools: Rational ClearQuest,JIRA, ALM

Languages: SQL, VB, Java

Other tools: Toad, MS Visio, SQL Developer, MS SQL Server, WinSCP, FIleZilla


Confidential, Quincy, MA

Test Lead


  • To analyze existing CMDB application and gather requirement for enhancement of an existing process
  • To develop data quality reports and work with platform teams to resolve the issues.
  • Develop reports, Dashboards based on user requirements.
  • Develop CMDB health dashboards to measure measure data accuracy, data completeness.
  • Involved in Qualys vulnerability integration with CMDB testing.
  • Identify activities/ tasks, task level estimates, schedule, dependencies and risks. Participate in knowledge gathering sessions conducted by customer/ other business teams and Provide feedback on requirements understanding and design from application SME perspective.
  • Analyze functional/nonfunctional requirements and seek clarifications for finalizing requirements.
  • Define the data process governance for application mapping requirements to complete loading process into CMDB Cycle.
  • Validate and verify the status of application mapping process in CMDB and certify with app owners.
  • To collect Asset analysis and utilization of Report for monthly, quarterly, yearly and adhoc process based to Management.
  • To validate the Data quality with business owner and application owners for required data that loaded in CMDB.
  • To collect application codes from Application inventory team and sync up with CMDB Business configuration items
  • Remove/Archive/Verify the duplicate CI components in CMDB Repository and verify with Business and Application owners.
  • Data Quality Validation process with Reporting and KPI generating team and supporting for carry out in quality data from reports to Management
  • Creating key performance Indicators for IT Asset Inventory Data Health
  • Identify and resolve process gaps for IT Assets purchase Orders, Vendor Feeds & ISM weekly Feeds

Technolgies: Service NOW discovery, Service NOW Reproting, Oracle, MS Access, MS Excel, S Powerpoint, MS word


Test Lead


  • Worked as Test Lead.
  • Handled team of up to 4 members and responsible for overall QA deliverable of the team
  • On boarding and off boarding resources to the projects
  • Involved in functional, ETL, Datamart, reporting, regression and system integration testing.
  • Prepared the test cases and uploaded the test case into QC using QC add-in tool in Excel.
  • Involving in discussion on the requirements with functional leads based on the implementation and testing of data- warehousing and reporting concepts. Also suggesting best practices and value ads.
  • Based on the requirement determining the scope of work in the effort estimations.
  • Involving in automating the scripts for test execution, writing medium to complex SQL Queries to test the functionality.
  • Involving in test case, test script preparation, test data preparation process for files in Unix using putty and also in Test Execution using ETL and reporting tools
  • Using HP QC as test management tool to track whole STLC phases from Requirement to Defect tracking.
  • Responsible for designing and executing complex SQL scripts for data validation
  • Created Dashboard to generate reports from QC.
  • Preparing test closure documents
  • Mentored new resources.
  • Responsible for writing test strategy and test plans
  • Entirely responsible for Planning, prioritization and allocation of testing tasks to team members
  • Conducting test case reviews
  • Timely escalations on critical issues
  • Responsible for QA completion report & QA Sign off
  • Test metrics collection & project postmortem & implementation of lesson learned
  • Prepared the Daily status & weekly status Report
  • Project progress tracking and resource management
  • Providing guidance to team members on project scope & day today testing activities
  • Responsible for test approach and test scenarios walk through to Development team and Business Analysts
  • Responsible for assigning task and tracking the progress of team members
  • Used the test management tool ALM for test design and test execution andJirafor defect logging and tracking
  • Track and prepare the report of testing activities like Testing progress, Test case coverage and Defects discovered
  • Responsible for defining test automation approach by using Platinum
  • Participating in daily status calls
  • Responsible for collecting and publishing monthly test metrics

Technology & Tools - Windows 7, UNIX, Data stage, Sql Developer, Putty, WinScp, HP QC/ALM, Autosys


Test Analyst


  • Worked as Test Analyst.
  • Involved in functional, regression and system integration testing.
  • Prepared the test cases and uploaded the test case into QC using QC add-in tool in xls.
  • Based on the requirement determining the scope of work in the effort estimations.
  • Involving in test case, test script preparation, test data preparation
  • Raising defects in defect tracking tools, ALM. Track and follow-up the defects with Dev team till closure
  • Preparing test closure documents
  • Placed orders on LVTS and receive response from ICross engine once orders are executed.
  • Involved in end to end testing from the time when order is placed until order was executed and send response back.
  • Validated different scenarios as per requirement with traders in test environment.

Technology & Tools - Windows 7, UNIX, Putty, WinScp, LVTS trading tool, iCross, IPO, iRouter, Oracle 11G, Quality Center

Hire Now