Preethi Sadagopan

• Company Overview: Two Harbors Investment Corp. is a real estate investment trust, which invests in residential mortgage-backed securities, residential mortgage loans and other financial assets. Its objective is to provide risk-adjusted returns to its stockholders over the long-term, primarily through dividends and secondarily through capital appreciation.
• As a Senior QA Analyst I was involved in testing the ETL processes, web application testing, reports and API testing for various projects since 2018.

Responsibilities:

• Participate in sprint planning, retrospectives, and daily stand-ups as part of the Agile process
• Collaborated with cross-functional agile teams to plan and execute testing activities in 2-week sprints
• Developed and executed test plans for releases, resulting in a 98% pass rate and on-time delivery for all major milestones
• Used Zephyr to write test cases and JIRA for logging defects.
• Assisted in preparing regression test suites for automation and ran the automated tests after every release.
• Identified and reported high-priority bugs, collaborating with developers to resolve them before release deadlines
• Implemented a comprehensive testing strategy that reduced production defects by 35% and increased customer satisfaction.
• Involved in validating the data mappings (for both ETL process and BI reports).
• Ran the Active batch job (that executes SSIS packages) to load the data into tables and verify the data loaded into staging and integration tables.
• Used SQL for validating the data load.
• Validated SSRS and MicroStrategy reports, and the data rendered in the reports.
• Validated API/Web services using Postman. Ran the API tests by using collection runner for selected environments.
• Performed Functional, Data Integration testing, UAT testing for various releases.
• Communicated effectively with developers, BA's, PM's, stakeholder’s after performing post production validation.
• Track the results of testing and report on key metrics.
• Provided training and mentorship to peer QA team members, enhancing team skills and performance.

• Company Overview: Knowledge Marketing is a technology firm in Plymouth, Minnesota that transforms how businesses reach their customers with marketing communications. We incorporate tools for email marketing, online data collection and back office circulation management into a single integrated solution.
• As QA Analyst I involved in testing the following products: Email Marketing, Marketing Automation, Domain Tracking, Surveys and Form designer. Worked on new development and enhancements for these products and also tested the fixes for production bugs.

Responsibilities:

• Developed and executed manual and automated test cases to validate software functionality.
• Collaborated with project managers to track project progress and address critical issues.
• Developed and executed Automation test scripts using Selenium.
• Integrate automation tests into CI/CD pipelines and support continuous testing practices.
• Coordinated with development teams to resolve defects identified during testing.
• Documented testing procedures and results for compliance and future reference.
• Participated in test planning and requirement gathering sessions to align testing efforts with project goals.
• Used Test Manager for writing test cases and TFS for tracking defects.
• Used Fiddler and Postman for testing web services (API testing).
• Prepared status summary reports with details of executed, passed and failed test cases.
• Educate peers in QA standards and best practices.
• Perform regression testing, integration testing, performance testing, and security testing as needed.
• Tested data in backend by writing SQL Queries.
• Ran A/B tests to test email campaigns and tested the email preview in different browsers.

• The Project involves testing the following web applications: Media Accounting, Non Media and Digital systems. The applications were converted from desktop to Web. All the applications are integrated with each other. Media Accounting System is used to post invoice data to the General Ledger in AX. Involved in performing System Integration testing, Functional testing, Regression testing and reports testing.

Responsibilities:

• Analyzed the Business Requirement Document, Functional Specification documents to prepare Test Cases.
• Coordinated day-to-day changes, activities for testing, processes, and environment changes/impacts to the Release.
• Prepared test data for executing test cases.
• Performed functional testing of application by executing Test Steps from Test Cases.
• Performed Regression testing, GUI testing, and system and reports testing.
• Provided update to Team Lead about the daily Testing activity progress.
• Used JIRA for writing test cases (in zephyr) and tracking defects.
• Involved in conducting defect triage meeting and triage defects.
• Performed testing in Microsoft dynamics AX to make sure all accounting accrual deferral journal entries /write off entries and invoices are posted in AX.
• Prepared status summary reports with details of executed, passed and failed test cases.

• Tech Refresh Project is to replace the aging superdome server platform with an updated environment that supports enterprise standard operating systems and applications. This project also implements a Business Continuity Plan environment per enterprise standards.

Responsibilities:

• Performed Data Integrity Testing. Testing critical schema objects like verifying the count and list of objects in source and target tables, views and Materialized views.
• Performed Connectivity Testing like DB connectivity and application connectivity with db.
• Performed Security testing like validating password rules, users, roles, privileges etc.
• Performance Testing is done by measuring the time taken to execute a query in the existing Vs new servers.
• Datamart specific reports and the secure reports (SSRS) are tested.
• Extensively used TOAD to create SQL queries to verify the integrity of the database
• Maintain and provide status and progress of project activities in weekly status meetings.
• Prepared test case summary reports with details of executed, passed and failed test cases.

• Matrix Care is the leading certified, cloud-based EHR solution designed to help long-term care and senior living communities deliver superior care, resulting in better outcomes for their residents.

Responsibilities:

• Create and implement detailed and well-structured test plans and end-to-end customer experience test cases for initial product launch and new features being introduced
• Provide accurate testing time estimates
• Prioritize, plan and coordinate all testing activities; includes identifying, recording and tracking bugs
• Perform regression testing once bugs are resolved
• Partner with product and engineering teams to help validate customer experience and ensure quality delivery of product features

• CME Group Inc. (Chicago Mercantile Exchange) is one of the largest options and futures exchanges. It owns and operates large derivatives and futures exchanges in Chicago, and New York City, as well as online trading platforms. It also owns the Dow Jones stock and financial indexes, and CME Clearing Services, which provides settlement and clearing of exchange trades.

Responsibilities:

• Analyzed Software Requirements documents and Business Requirements documents to get a better understanding of the system on both Technical and Business perspectives.
• Developed extensive Test Plan and written Test Cases for various modules.
• Develop QA Automation Test Framework to ensure the code reusability and code maintainability, which reduces the script development time.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Coordinate with developers and project team members to triage and resolve issues.

• Performed Web Services testing and Validated XML request/response data using SOAPUI - this tool is used to locate WSDL file on internet.
• Maintain and provide status and progress of project activities.
• Designed and developed automation test scripts using Quick test Professional.
• Modified and Executed automated and manual test scripts for different modules using QTP.
• Documented Test cases, Test results and Test procedures.

• Involved in testing the designing and development of data warehouse environment.
• Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Created test data at design level based on ETL mapping document for both positive and negative scenarios.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Performed SQL analysis and involved in testing of MicroStrategy reports.