Dhana Soundarya Lakshmi Janarthanan

Detail-oriented professional with over 10 years of experience in quality assurance, expertise in ETL QA concepts, and 3 years of experience as a business analyst. Insightful Business Analyst known for high productivity and efficient task completion. Possess specialized skills in data analysis, process improvement, and project management. Excel in critical thinking, communication, and problem-solving to deliver effective solutions. Committed to leveraging these abilities for success in challenging business environments.

• Cognizant Certified Professional in Quality center-Practitioner
• General Insurance
• Guidewire Claim Center Business for Practitioners
• Guidewire Policy Center Testing for Learners
• Insurance Claims
• DW testing Methodologies

• English
• Tamil
• Hindi

• Date of Birth: 02/24/87
• Nationality: Indian
• Marital Status: Married
• Visa Status: H4 EAD

• Facets Data Transformation and Data Migration, Healthcare Client, Test Lead/QA Tester, SQL Developer, HP Quality Centre, Autosys, 30, 08/01/16 – 11/30/20, The project involves transformation from one legacy application to another application. For the initial phase, both the applications will run parallel, once all the functions are setup in the new application according to the customer's business specifications the legacy system will be decommissioned., Involved in Requirement gathering and Requirement Analysis, Involved in the preparation of Test Plan and Test Estimations, Preparation of Test Scenarios and Test cases adhering to Complex requirements shared by business, Involved in Execution of the test scripts., Analyzing the data till the Front-End Database level in case of any data discrepancy., Involved in testing the reports with reference to the Backend database., Involved in extensive Execution phase and list the defects to the development team and track them efficiently through QC., Drive the Defect triage calls on daily basis involving Testing, delivery, and business stakeholders.
• Sales and Market Intelligence & Loans Onboarding, Insurance Client, Test Lead/QA Tester, SQL Developer, Tableau v8, HP Quality Centre, Autosys, 13, 03/01/15 – 03/31/16, The project involves onboarding Loans which are purchased from other Vendors. The loan details are provided in files, which are stored in the database with the help of a framework. Tableau reports are generated based on the Loans data in the database., Involved in Requirement gathering and Requirement Analysis, Involved in the preparation of Test Plan and Test Estimations, Preparation of Test Scenarios and Test cases adhering to Complex requirements shared by business, Loading of data into respective tables using Autosys (Workload Control Center) tool., Involved in Execution of the test scripts., Analyzing the data till the Front End Database level in case of any data discrepancy., Involved in testing the reports with reference to the Backend database., Involved in extensive Execution phase and list the defects to the DEV team and track them efficiently through QC., Drive the Defect triage calls on daily basis involving Testing, delivery and business people.
• Guidewire implementation, Insurance Client, QA Tester/Test Lead, Informatica Power Center 9.5.1, Autosys, Ultra Edit, HP Quality Center 11.0, Toad for Oracle 11, 20, 05/01/13 – 03/31/15, A new Claims operating system was built which will be a single point entry for all claim administration activities using the Guidewire Claim Center., Involved in the preparation of Test Plan and Test Estimations, Involved in Requirement gathering and Requirement Analysis, Preparation of Test Scenarios and Test cases adhering to Complex requirements shared by business, Loading of data into respective tables using Autosys (Workload Control Center) tool., Involved in Execution of the test scripts and analyzing the Informatica Mappings., Analyzing the data till the Front End Database level in case of any data discrepancy., Involved in extensive Execution phase and list the defects to the DEV team and track them efficiently through QC., Drive the Defect triage calls on daily basis involving Testing, delivery and business people.
• MTC(Maintenance-Enhancement) Dataservices, Insurance client., QA Tester, QuickTest Professional, SoapUI, Ultra Edit, HP Quality Center 11.0, Toad for Oracle 11, 2, 06/01/11 – 05/31/13, The Enhancement of applications which are running successfully in live as per Business Customer’s requirement in Shared services Line of Business is dealt here., Functioning as a Track lead and acting as a single point of Contact for offshore., Performed Production Checkout for Critical applications., Involved in the preparation of Test Plan and Test Estimations, Involved in Requirement gathering and Requirement Analysis, Preparation of Test Scenarios and Test cases adhering to Complex requirements shared by business, Involved in Execution of the test scripts., Analyzing the data till the Front-End Database level in case of any data discrepancy., Involved in extensive Execution phase and list the defects to the DEV team and track them efficiently through QC., Attend regular Defect Triage calls with Vendors outside Cognizant.
• EDA Claimsphere, Healthcare Client, QA Tester, Business Objects, PL SQL Developer, 12, 10/01/10 – 04/30/11, The Project involves designing of the Reports and Dash boards using Business Objects and deployed., Analyzing the user specification/Client requirement documentation, Prepared and reviewed detailed test scenarios and test cases covering the mappings and Reports, Execution of test cases and defect tracking, Write SQL queries respect to the business scenarios., Involved in collection of test metrics, Prepared System Integration Test cases and Regression Template for all phases of the project, Worked in Validation of Operational reports