Lalita Kumari

• Leveraged DBT for data transformation, testing, and documentation within Snowflake, effectively managing metadata using DBT docs to enhance collaboration and clarity across 3+ teams.
• Administered Snowflake databases, managing 30+ reader and client-owned accounts via shares. Configured MFA and custom admin roles, ensuring secure, controlled access; also managed 50+ reader accounts, including user additions, password resets, and IP whitelisting.
• Developed automated SQL and DBT test scripts, including macros and seed tests, to support functional, regression, and continuous integration testing processes, impacting 5+ critical data pipelines.
• Managed and optimized Snowflake data pipelines, overseeing data transformations, merging, and normalization processes, ensuring seamless data flow across 5+ data sources.
• Conducted end-to-end ETL testing, verifying data accuracy, completeness, and integrity across multiple systems, leading to 99%+ data accuracy in production.
• Supported the setup and management of Fivetran data pipelines, ensuring reliable data flow from source systems to target data warehouses.
• Collaborated with Fivetran to automate data extraction and loading processes, enabling scalable, timely, and accurate integration for analytics and reporting, reducing data integration time by 30%.
• Generated detailed performance reports, analyzing product trends and identifying 5+ opportunities for improvement, contributing to product optimization and enhanced decision-making.

• Evaluated use cases and software requirements to design and execute detailed test cases, ensuring comprehensive functionality and performance coverage.
• Meticulously documented 100+ test results and provided weekly status updates to stakeholders, maintaining transparency and supporting informed decision-making
• Delivered actionable reports to management, highlighting key findings, risks, and recommendations to enhance product quality.
• Collaborated with project management, development teams, and customers to align on project goals, requirements, and testing needs.
• Facilitated effective communication and coordination, ensuring testing objectives were met and project milestones achieved.
• Tested Guidewire products (Policy Center, Billing Center, Claim Center, and Data Warehouse) within the Property and Casualty Insurance domain, utilizing both Waterfall and Agile methodologies.
• Led quality assurance efforts by analyzing testing outcomes, driving process improvements, and providing detailed reports to management.
• Facilitated effective communication and coordination across teams, ensuring 90%+ of testing objectives were met and 100% of project milestones achieved.
• Trained and mentored 3-4 junior QA testers and analysts on complex testing scenarios and methodologies, ensuring 95% team competency and productivity.

• Analyzed ETL mapping documents and collaborated with the Business Team to clarify requirements and ensure alignment.
• Worked within an Agile environment, testing the application under SCRUM methodology.
• Participated in kickoff meetings, ensuring clear understanding of project goals and timelines.
• Reviewed requirements, and both functional and technical design documents, ensuring all criteria were met.
• Executed ETL test jobs from AWS Airflow DAG, verifying test cases and validating data accuracy.
• Contributed to the creation of test scenarios and test cases based on requirements, and analyzed results to ensure accuracy.
• Acted as the interface between offshore teams and client managers, facilitating communication and project coordination.
• Led ETL validation testing, focusing on data completeness, transformation, quality, integration, UAT, and regression testing.
• Performed comprehensive database testing by writing complex SQL queries in Snowflake DB, testing various application scenarios.

• Validated data integrity by executing ETL test cases and performing end-to-end testing across data pipelines.
• Developed automated test scripts using SQL to validate data accuracy, completeness, and transformation processes.
• Collaborated with business and technical teams to review requirements and identify key areas for testing.
• Reported testing results and provided detailed analysis, ensuring that project requirements were met and quality standards were upheld.
• Conducted regression, UAT, and integration testing to ensure data flow integrity across systems.
• Performed thorough data validation to ensure proper data transformation, quality, and consistency within the data warehouse environment.

• Conducted a range of Black Box Testing methodologies, including Functional Testing, Regression Testing, Unit Testing, Integration Testing, User Acceptance Testing, and White Box Testing on the Thunderhead tool to validate setup provisions migrated to a new database.
• Led a team of 4-5 members and executed SQL queries to verify that participant data was successfully loaded into the new database, comparing test files with production data for accuracy.
• Designed, executed, and maintained automated Test Cases using the ECHO tool for regression testing, ensuring continuous test coverage.
• Developed SQL queries using QMF to query the DB2 database within a mainframe environment, performing data validation.
• Performed comprehensive analysis and testing, designing flows and logic to extract analytical data from source databases.
• Executed Backend Testing and validated Health Plan Pricing Data, ensuring data integrity throughout the process.
• Tested data validation processes before and after the data validation stages to ensure accurate migration and transformation.

• Prepared test cases based on SRS (Software Requirements Specification) and design documents, collaborating with developers to review and finalize test scenarios.
• Conducted database testing using SQL queries, ensuring accurate data validation and consistency across the system.
• Performed Functional Testing and Integration Testing, executing manual tests on web-based applications to verify functionality and integration across modules.
• Participated in daily status meetings, providing updates on testing progress and reporting any issues or blockers.
• Assisted in the identification, documentation, and tracking of defects, working closely with the development team to ensure timely resolution.
• Contributed to the creation of test plans and test scripts, ensuring comprehensive coverage of all features and functionalities.
• Supported regression testing to verify that new updates did not affect existing functionality.
• Learned and implemented best practices in manual testing and contributed to improving testing workflows and processes.