Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

ASHISH KUMAR OJHA

San Diego

Summary

Meticulous and strategic QA Test Lead with over 15 years of expertise in Business Analysis, Software Testing (ETL, Mainframe, Automation, Manual), and Business Intelligence across diverse sectors including P&C Insurance, Investment Banking, and Wealth Management.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Test Lead- Insurance Company of the West, CA

LTIMindtree
San Diego
05.2020 - Current
  • Gathered and documented business requirements for AI-based testing and automation solutions in the insurance sector.
  • Collaborated with QA, development, and product teams to align test strategies with business goals and compliance needs.
  • Facilitated the implementation of Test Data Management (TDM) processes including data masking, synthetic data creation, and environment refresh coordination.
  • Conducted impact analysis and ensured traceability across requirements, test cases, and defect logs using JIRA and HP ALM.
  • Led UAT efforts, coordinated stakeholder signoffs, and prioritized business-critical defects for resolution.
  • Ensured compliance with regulatory standards (e.g., NCCI, HIPAA) in system design and testing workflows.
  • Supported Agile ceremonies, provided effort estimates, and tracked KPIs to improve delivery timelines and testing efficiency.
  • Projects: 1. Test lead- Insurance Company of West , San Diego, CA
  • May 2020 - Present
  • Tools: ETL, SQL Server Management, PAS, CAS, JIRA, SPLUNK, POSTMAN

Business & QA Analyst Lead

INSURITY
Hartford
01.2019 - 04.2020
  • Ensured adherence to quality standards while understanding project goals, business processes, and system functionality.
  • Presented process workflows, test strategies, and implementation plans to stakeholders.
  • Identified validation points and challenges for integrated systems (policy/claims, billing, data warehouse, reports, third-party services) and developed detailed QA plans.
  • Conducted training and support on software tools, system compatibility, and issue resolution.
  • Defined and orchestrated risk-based testing strategies aligned with customer and business priorities.
  • Participated in end-to-end project implementation, including QA estimation and planning.
  • Coordinated testing activities and led defect triage meetings with stakeholders.
  • Used tools like TFS, MTM, and PPM for test and project management.
  • Performed data validation using complex SQL queries to confirm ETL and data migration accuracy.
  • Validated UI screens and business reports for internal teams.
  • Technologies: ETL
  • Tools: SQL Server Management, PAS, CAS, JIRA, SPLUNK, POSTMAN

Test Lead

Central Mutual Insurance Company
Van Wert
05.2018 - 12.2018
  • Analyzed functional and technical requirements using BRDs, SRS, and use case flows to support solution design.
  • Guided teams in identifying critical data needs and aligning them with business objectives.
  • Supported RFP responses by reviewing requirements and providing solution inputs to BD and vertical teams.
  • Reviewed operational metrics and proposed improvements to end-to-end testing methodologies.
  • Contributed to test estimation, planning, and strategy based on project scope and stakeholder expectations.
  • Assessed ETL data models and clarified requirements with business stakeholders.
  • Led daily activities of QA teams, performed risk/impact analysis, and proposed mitigation strategies.
  • Reviewed source data, validated staging, and verified data transformations per business mapping specs.
  • Ensured accurate population of target fields based on business rules and data requirements.
  • Technologies: ETL, IBM MAINFRAMES
  • Tools: ALM 12.0, SQL Server Management Data Base: DB2

Test Lead

Mercer Investments
Vernon Hills
09.2015 - 04.2018
  • Analyzing the functional requirements using BRD’s, SRS and Use case architecture flows.
  • Raised quality bugs in TFS with proper follow up with issues.
  • Designing Automation test suited by using selenium web driver and IDE
  • Identification of project improvements and implementation of tools for cost effective models
  • Involved in preparing Test Estimation, Test Plan & strategy, Test Scripts, and test execution plan as per project requirements.
  • Technologies: JAVA, QTP, DOT Net, ETL
  • Tools: ALM 11.0, SQL Server Management, SQL Developer
  • Data Base: DB2 & SQL server, Selenium

Test Lead

CITI Equities
06.2015 - 08.2015
  • Analyzing the functional requirements using FSD’s, BRD’s and Architecture flow
  • Involved in preparing Test Estimation, Test Plan, Test Scenarios, Test plan as per project requirements
  • Validation of Order linking between Equity/Derivatives trading system.
  • Validation of OATS Report and sending this report to FINRA for verification
  • Executing the test cases in UAT and providing sign off for Production release
  • Coordinating stakeholders for business clarifications and query resolution.
  • Broadcasting monthly matrices to Client.
  • Validation of FIX Tags for Compliance purposes.
  • Technologies: IBM Mainframes, Web UI (Java), .NET desktop applications
  • Tools: QC9.2, ALM 11.0, QTP 10.0, JCL, SPUFI & QMF, SQL, SOAP UI (XML), DTF and Informatica 8.6.0
  • Data Base: DB2, Microsoft SQL Server Management

Senior Test Engineer

Marsh & McLennan Companies
Des Moines
03.2013 - 05.2015
  • Understanding the requirements, FRD thoroughly and preparing Test Plan, Test Scenarios & Test Cases.
  • Highlighting the risks/ challenges during appropriate time
  • Processing all types of batch requests come from client as well as SDG team.
  • Participated in the review meeting, walkthroughs, status meetings and deployment support with closing working on weekends.
  • Prepared query logs, weekly status reports and maintained quality standards
  • Used Test Track Pro as part of defect management tool.
  • Participated in Auditing of the application and maintaining quality artefacts.
  • Technologies: Java, .Net
  • Tools: HPQC 9.2., Test Track Pro, SQL Developer, SOAP UI, Stored procedures, Selenium

Senior Test Ananlyst

RSA – UKRIS TMS
01.2012 - 02.2013
  • Analyzing the requirements using ASD and DSD documents related to project.
  • Involved in preparing Test Plan, Test Scenarios and Test Cases as per project plan.
  • Involved in self & peer reviews, execution plan preparation, and DSR.
  • Analyzing COBOL programs to understand the business logic behind batch processing and on-line processing
  • Involved in test execution of functional testing (Integration, SIT, Regression etc.)
  • Database testing using DB2 (SQL queries for all migrated data)
  • JCL preparation/submission for batch testing and online transactions using CICS routines.
  • Participating in and coordinating teams in test execution. Key mentor and POC for all the risks/issues related to business & technical aspects.
  • Technologies: IBM Mainframes (COBOL, CICS), .NET desktop applications
  • Tools: QC9.2, JCL, SPUFI & QMF and SQL Data Base: DB2, IMS DB

Project Engineer

Wipro Technologies
Colorado
12.2009 - 12.2011
  • Analyzed requirement and technical specification to determine feasibility for testing and identifying gap in requirements from testing standpoint.
  • Developed test strategy to validate end-to-end processing.
  • Created test plans, test cases, test data and executed them.
  • Participated in defect management strategy and coordinated with technical teams to ensure timely resolution of defects.
  • Prepared tests sign off documents with testing metrics and project learning.
  • Projects: Project Engineer- Charles Schwab, Colorado (USA)
  • Technologies: IBM Mainframes (COBOL, CICS), WEB UI, JCL, SPUFI
  • Tools: Manual Web testing, QC9.2, SQL, Oracle Server Data Base: DB2

Education

Bachelor of Technology - Engineering

Orissa Engineering College
Bhubaneshwar, India
07-2008

Skills

  • ETL Testing & Data Warehousing – Advanced
  • SQL, DB2, Oracle, Informatica – Excellent
  • Automation (Selenium, Testim) – Advanced
  • BI Tools (COGNOS, Power BI, SSRS) – Advanced
  • Mainframe Testing (JCL, COBOL) – Advanced
  • TDM & Data Compliance (GDPR) – Excellent
  • Agile / Waterfall Methodologies – Excellent

Certification

  • ISTQB Certified Tester – Foundation Level
  • AINS24-A (General Insurance)
  • Certified in Basic & Master Agile Testing – ATA Malaysia
  • NCFM – Financial Markets, Commercial Banking, Equity & Derivatives
  • Certified in First Aid & CPR – American Red Cross

Timeline

Test Lead- Insurance Company of the West, CA

LTIMindtree
05.2020 - Current

Business & QA Analyst Lead

INSURITY
01.2019 - 04.2020

Test Lead

Central Mutual Insurance Company
05.2018 - 12.2018

Test Lead

Mercer Investments
09.2015 - 04.2018

Test Lead

CITI Equities
06.2015 - 08.2015

Senior Test Engineer

Marsh & McLennan Companies
03.2013 - 05.2015

Senior Test Ananlyst

RSA – UKRIS TMS
01.2012 - 02.2013

Project Engineer

Wipro Technologies
12.2009 - 12.2011

Bachelor of Technology - Engineering

Orissa Engineering College

Similar Profiles

CREATE PROFILE