Apr 2023 – Present · 3 yrs 1 mo

• Responsible for end-to-end ETL testing (Extract, Transform, Load), Test Automation Framework using TestNG and Java, cutting manual effort by 35% and driving continuous improvements in automation practices.
• Migrated Automation test suite framework from a local environment to AWS cloud (GitHub, Jenkins, AWS EC2, Athena, Redshift, S3), achieving a 45% reduction in test execution time and improved efficiency in testing process.
• Optimized test automation SQL queries in BigQuery/Athena and performed ETL/Data Warehouse testing and database testing, leading to a 25% reduction in infrastructure costs while improving query performance and resource utilization.
• Proficient in querying complex data using Google BigQuery, ensuring data accuracy and completeness.
• Developed and executed robust functional and database test cases in Pre-Production environments, ensuring accurate validation of data workflows and system functionality.
• Collaborated with developers, and product owners, teams in Agile environments, participating in sprint planning, defect triage, and release readiness discussions.
• Led a QA team, providing direction on testing methodologies, assigning tasks, reviewing deliverables, and mentoring junior testers to ensure consistent output and team growth.
• Performed API testing using Postman, validating RESTful services.
• Proficient in debugging and querying large datasets using Google BigQuery and SQL, validating ETL logic, data integrity, and schema transformations.
• Managed defect lifecycle using JIRA and TracTickets, ensuring timely resolution of bugs and minimizing production risks.
• Utilized Python scripts for functional testing, including data comparison utilities, result validation functions, and dynamic test data generators.
• Proactively identified quality gaps and recommended enhancements to improve testing strategies, team efficiency, and product reliability.

Apr 2021 – Mar 2023 · 1 yr 11 mos

• Designed and executed comprehensive test scenarios and functional test cases to validate ETL flows and software features across data-driven applications.
• Conducted extensive ETL testing and database validation across MySQL, BigQuery, MongoDB, and
• Elasticsearch, validating data transformations and complex joins, to ensure data integrity and business logic implementation.
• Conducted API testing with REST Assured/Postman and performance/load testing using JMeter, identifying bottlenecks that improved system response times by 15%
• Generated detailed test reports highlighting results and improvement areas
• Execute tests to identify software defects and ensure functionalities meet specified requirements.
• Collaborated closely with cross-functional Agile teams during sprint planning, daily stand-ups, and retrospectives to align on test goals and ensure timely delivery.
• Executed manual and exploratory testing to uncover defects, usability issues, and inconsistencies across different user scenarios.
• Worked closely with developers and product owners to analyze, track, and resolve defects using Jira, ensuring timely bug fixes and maintaining release quality.

Apr 2020 – Mar 2021 · 11 mos

• Designed and executed comprehensive test cases for validating end-to-end data flows.
• Performed data validation and backend testing by writing complex HiveQL queries, MySQL queries, and aggregations to ensure data accuracy and integrity in data pipelines.
• Conducted NoSQL database testing on MongoDB, validating document structures, nested fields, and query outputs to match business requirements.
• Verified data ingestion, indexing, and retrieval in Elasticsearch, including index mapping, document creation, and query-based testing.
• Logged, tracked, and managed defects using Jira, and participated in daily stand-ups
• Performed functional testing of web and data-driven applications, validating business logic and ensuring requirements were accurately implemented.

Apr 2018 – Mar 2020 · 1 yr 11 mos

• Collected, organized, and analyzed complex datasets to generate actionable insights that supported strategic decisions across departments.
• Served as a key liaison between product, engineering, and business teams to translate data findings into product improvements and business outcomes.
• Partnered with Product Managers to evaluate and execute Proofs of Concept (POCs), validating product feasibility and aligning data-driven insights with functional and non-functional requirements.
• Mentored and guided junior analysts, promoting best practices in data exploration, reporting, and stakeholder communication.
• Identified and optimized data workflows to improve overall data accuracy, consistency, and availability, increasing the efficiency and reach of analytics operations.
• Conducted manual testing and data validation, ensuring that analytical outputs aligned with business logic and system expectations.
• Collaborated in Agile environments, participating in sprint planning and retrospectives to align analytical deliverables with iterative development cycles.
• Applied strong problem-solving and debugging skills to resolve discrepancies in reports, source data, and process outputs, ensuring data quality across all stages.
• Supported cross-functional teams by delivering tailored reports, dashboards, and documentation to communicate key trends and KPIs using Microsoft Office tools.

Apr 2017 – Mar 2018 · 11 mos

• Translated raw data into meaningful insights by structuring and analyzing datasets to support strategic
• decision-making across departments.
• Provided guidance to team members and facilitated cross-functional collaboration to ensure alignment
• on data initiatives.
• Applied strong problem-solving and debugging skills to resolve discrepancies in reports, source data, and process outputs, ensuring data quality across all stages.
• Streamlined data processes to boost accuracy, consistency, and accessibility across the organization.

Oct 2014 – Mar 2017 · 2 yrs 5 mos

• Conducted in-depth online research using search engines (Google, Yahoo, Bing) to gather relevant business and executive information across industries and geographies.
• Extracted and verified executive and company data from professional databases such as LinkedIn, Hoovers, Xing, Viadeo, OneSource, and Jigsaw, ensuring accuracy and completeness.
• Engaged in targeted lead generation efforts, identifying potential business contacts and decision-makers to fuel business development pipelines.
• Collaborated with cross-functional teams to understand data requirements, refine search strategies, and optimize data collection processes for better insights.