We provide IT Staff Augmentation Services!

Test Lead Resume

Quincy, MA

SUMMARY

  • 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.

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Test Lead

Responsibilities:

  • 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

Confidential

Test Lead

Responsibilities:

  • 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

Confidential

Test Analyst

Responsibilities:

  • 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