Still Struggling with Tech Hiring? Discover Olibr's Solution Now!
Login / RegisterDeveloperClient
Login/Register

Vipul Havale

Test Analyst

  • Pune, MH
  • 4 years
Notice Period: 90 Days

    Candidate's About

    Experienced software tester with 4.7 years in System & Functional testing, specializing in Database, DWH/ETL, Web Services, and Data Science Testing. Skilled in data transformations, ETL test case preparation, SQL validations, and data mapping analysis. Strong DWH concepts understanding.

    Work & Experience

    T

    Test Analyst

    Dec 21 - PRESENT

    Technology

    • Icon
      Linux
    • Icon
      C
    • Icon
      C++
    • Icon
      Java
    • Icon
      SQL
    • Icon
      Git
    • Icon
      Jenkins

    Tools

    • Icon
      Jira
    • Perform test analysis and create test plans, test cases, and test scripts.
    • Execute test cases and document test results.
    • Identify defects, track them using defect tracking tools, and perform defect triage.
    • Collaborate with cross-functional teams to ensure quality deliverables.
    • Conduct regression testing and participate in test automation efforts.
    Read More

    SPP

    Test Analyst

    • Validated customer extract parts and performed complete data testing.
    • Verified extracts with over 1.8 million records using Unix and tools.
    • Conducted functional testing based on business requirements.
    • Coordinated with the automation testing team to automate test scripts using TOSCA.
    • Analyzed ETL requirements, prepared and reviewed test cases.
    • Executed test cases using complex queries to ensure adherence to business logic.
    • Conducted count checks, reconciled records, checked data types, removed duplicates, and validated keys.
    • Verified application-level database testing and interfacing with external systems.
    • Reported and closed defects in the Defect Tracking tool ALM.
    • Collaborated with the development team in defect fixing and regression testing.
    • Prepared Test Traceability matrix and Test reports.
    • Participated in project status review meetings.
    • dwh/etl
    • Toad
    • Unix
    View Details
    T

    Test Analyst

    May 18 - Oct 21

    Technology

    • Icon
      Linux
    • Icon
      C
    • Icon
      C++
    • Icon
      Java
    • Icon
      SQL
    • Icon
      Git
    • Icon
      Jenkins

    Tools

    • Icon
      Jira
    • Performed test analysis, created test plans, and designed test cases.
    • Executed test cases and documented test results.
    • Identified and reported defects using defect tracking tools.
    • Collaborated with cross-functional teams to ensure quality deliverables.
    • Conducted regression testing and participated in test automation efforts.


    Quantum Mediation [ DTQM]

    Test Analyst

    • Analyzed ETL requirements and prepared test cases, reviewing them.
    • Executed test cases using complex queries to ensure adherence to business logic.
    • Conducted count checks, reconciled records, ensured data type accuracy, removed duplicates, and validated keys.
    • Applied transformation logic before data loading.
    • Verified aggregate values and calculated measures in fact tables.
    • Checked modeling views and applied CDC on incremental load tables.
    • Performed data checks on dimension and history tables.
    • Verified BI reports based on loaded fact and dimension tables.
    • Analyzed SRS, design, and user interface specifications.
    • Prepared test scenarios and cases.
    • Conducted application-level database testing.
    • Facilitated customer requests from billing system to external systems.
    • Reported and closed defects in the Defect Tracking tool ALM.
    • Collaborated with the development team in defect fixing and regression testing.
    • Prepared Test Traceability matrix and Test reports upon test completion.
    • Participated in project status review meetings.
    • dwh/etl
    • SSIS
    • Tibco
    • Job Run
    View Details

    NDCS – eunED Integration [Fiber optics Switch Synchronization ]

    Test Analyst

    • Analyzed customer requirements and created test conditions.
    • Created test cases based on Business Requirements Specification documents in HP ALM.
    • Interacted with Business Analysts and Developers to design test plans and strategies.
    • Prepared Traceability matrix mapping customer requirements to test scenarios.
    • Participated in test case reviews with clients.
    • Prepared test reports and shared them with clients.
    • Conducted sanity tests, system integration tests, and regression tests.
    • Executed test cases in HP ALM and logged defects.
    • Prepared documentation including Testing Progress and Test Coverage.
    • Provided project status updates to the Project Manager.
    • Made recommendations for system enhancement features.
    • Assisted the Business team in User Acceptance Testing.


    • Database testing
    • Web service testing
    View Details

    Circuit Move Over Length – CMOL

    Test Analyst

    • Analyzed customer requirements and created test conditions.
    • Created test cases based on Business Requirements Specification documents in HP ALM.
    • Interacted with Business Analysts and Developers to design test plans and strategies.
    • Executed test cases in HP ALM and logged defects.
    • Prepared Traceability matrix mapping customer requirements to test scenarios.
    • Participated in test case reviews with clients.
    • Prepared test reports and shared them with clients.
    • Conducted sanity tests, system integration tests, and regression tests.
    • Prepared documentation including Testing Progress and Test Coverage.
    • Provided project status updates to the Project Manager.
    • Made recommendations for system enhancement features.
    • Assisted the Business team in System Integration Testing.
    • Database testing
    • Web service testing
    • System Integration Test
    View Details

    Intelligent Rating & Charging

    Test Analyst

    • Read the stories and analyzed them, prepared test cases.
    • Used Jira agile project management tool to track stories.
    • Created test cases based on Business Requirements Specification documents in HP ALM.
    • Interacted with Business Analysts and Developers to design test plans and strategies.
    • Prepared Traceability matrix and participated in test case reviews.
    • Prepared test reports and performed sanity, system integration, and regression testing.
    • Executed test cases, logged defects, and provided status updates.
    • Recommended system enhancements and assisted with Iteration Testing.
    • Joined scrum meetings and kept up-to-date with development technology and testing tools.
    • Ensured data integrity and applied transformation logic during data loading.
    • Verified aggregate values and calculated measures in fact tables.
    • Checked modeling views based on target tables.


    • dwh/etl
    • SSIS
    • Tibco
    • Job Run
    View Details

    Payment Dunning (Payment BSS integration}

    Test Analyst

    • Validated data sources, extracted data, applied transformation logic, and loaded data in target tables.
    • Designed, documented, and executed test plans, scenarios, and cases using manual and automated testing tools.
    • Utilized HEVO, Microsoft Excel for data manipulation and analysis.
    • Managed defect management process using HP ALM.
    • Demonstrated strong attention to detail, organization skills, and ability to handle multiple projects.
    • Analyzed and interpreted management information.
    • Collaborated effectively in geographically dispersed teams.
    • Applied various data warehousing methodologies and data modeling concepts.
    • Wrote complex SQL queries and had proficiency in Oracle SQL, Hevo, Excel, and OLAP.
    • Presented findings and communicated effectively with technical and business stakeholders.
    • Compiled data from multiple sources for effective decision making.
    • Database testing
    • Webservice testing
    • EDI file processing
    • etl testing
    View Details

    Education

    V

    B.Tech B.E.

    Vishweshwarayya Technological University
    2005 - 2009

    Achievements

    • Received Performance award from Ericsson for better performances