Versatile, proactive Quality Assurance lead with sound understanding of product requirements and broad business acumen derived from experience driving efficiency at a range of demanding employers, including WPP, Travelers, AAA, Amex & Comcast.
Data warehousing and Business Intelligence (BI) professional utilizing SQL Server, GCP, Big Query, BI stack, and Tableau tools
Hands-on experience in SSIS, ETL testing, Tableau, Power BI, Unix, Hadoop, MS SQL, T-SQL, Web service testing – SOAPUI/Postman, and Automation with Selenium.
Experience in leading Agile test teams for Insurance, Media and Banking customers, handled Test Metrics, Requirement drafting, Test Design, Test Plans, Test Strategy, Test Design, and Execution, Defect management process, UAT, and test sign-offs.
Handled various stages of product/application testing Functional, Integration, System, Regression, and User Acceptance Testing. Experience in handling JIRA, Rally, and CI/CD tools.
Detail-oriented Data Quality Analyst adept at performing data analysis and recognizing key problem areas to assist in root cause identification. Exceptionally talented at auditing data on a regular basis to provide data integrity and quality.
Release-planning specialist trained in advanced Excel modeling. Creative solutions architect with real-time problem-solving flexibility.
ISTQB Certified Professional
Skills
SQL Server Scripting
MS SQL, T-SQL
Data Warehousing Concepts
Data Visualization – Tableau and Power BI
Big Data - Hadoop
Regression Analysis
ETL Unix
Web Service QA Soap UI
ALM, Jira, Rally, Jenkins
Client Relationships
Change Management
Vendor Management
Internal Communications
Agile, Automation, Selenium, Python
Data Organization
Quality Inspections
Root Cause Analysis
Data Analysis
Data Validation
Quality Assurance Requirements
Data Modeling
Quality Assurance Procedures
Presentation Skills
Extraction Transformation and Loading (ETL)
User Acceptance Testing (UAT)
Data Evaluation
Present Findings
Data and Analytics
Presentations and Decks
Trend Data Analysis
Write Reports
Work History
Data Quality Analyst
WPP
London
11.2019 - Current
Responsible for verifying releases of interlinked products making up the Proteus stack.
Provide insight on Data Matching between Entity, Delivery, Aggregate and Log Data.
Performed data reconciliations between different parts of the same system and between systems.
Build dashboards in tableau to monitor key operating metrics.
Used Panda API to read data from data sheets for Python based test automation.
Automated data comparison of PROD and QA data with Selenium and Java
Executing all levels of testing (Exploratory, System, Integration, and Regression).
Used defect tracking systems to report issues to the development teams and working with them to satisfactory issue resolution. Including providing where relevant annotated screenshots, log files and detailed steps to reproduce any reported issues.
Use of static techniques and requirements analysis to derive tests cases.
Coordinate needs for data testing from different data developers. Used Panda API to read data from data sheets for Python based test automation.
Test Lead
Cognizant - Travellers Insurance
India, UK
06.2016 - 08.2018
Involved in validating business requirements in Teradata using complex T-SQLs.
Executed Sanity check, Record count validation, Duplicate validation, Referential Integrity checks, Primary Key validation and Mapping validation for the user stories within a particular iteration.
Created SQLs to validate data for daily Ab-Initio ETL loads.
Executed ETL jobs via Autosys for Ab Initio schemas exposed by developers.
Executed Unix shell scripts for validating monthly financial data for data loaded in Teradata FinDB.
Involved in System Testing, UAT and Regression testing for various phases of STLC.
Involved in Sprint Planning, Rally updating, ALM updating exercises, Retrospective meetings and Daily scrum calls.
Involved in producing various reports using Tableau to project monthly financial performance to stakeholders.
Developed visuals based on business requirements using Tableau to showcase claims incurred region wise.
Involved in writing complex SQLs to support Tableau reports.
Embedded Tableau reports in application page to support role specific access.
Monitoring the Agile test team’s progress and proving an accurate update on the Daily progress and Status to clients and all stakeholders.
Designed multiple dashboards using Tableau - Power Query and Power Pivot tools for calculating monthly metrics.
Provided maintenance and development of defect fixes for new and existing Tableau reports.
Providing estimates for the functional changes during sprint planning meeting using the Points based estimation technique.
Involved in End to end automation and optimization of the regression test suite using Selenium, Autosys and Jenkins.
Test Lead
Cognziant - Comcast
India
11.2014 - 05.2016
• Involved in validating and setting up Email and text records in SQL server.
• Involved in requirement analysis and preparation of use case documents; use case diagrams, activity diagrams, and flow chart diagrams.
• Testing functional requirements and preparing test plan, test strategy and test estimation.
• Created Automation suite for regression cases using Parasoft and Selenium IDE.
• As an offshore team lead, monitoring the Teams Progress and proving an accurate update on the Daily progress and Status to clients and all stakeholders.
• Identifying risks proactively and highlighting them to Business for appropriate contingency and mitigation.
Test analyst
Cognizant - AAA Insurance
India, US, Thailand and Hong Kong
07.2012 - 03.2013
• Leading QA team and responsible for QA deliverables in every sprint release, including test estimation, test plan, test conditions and test execution summary report.
• Plan for functional, regression cycles for every release and provide signoffs with risks and analysis to aid go-live decisions for management team.
• Participate in defect review meetings and provide defect reports.
• Communicate testing issues to QA Manager and Client Manager.
• Recommends whether the test exit criteria have been met.
• Responsible for defect coordination for 100-member team. Involved right from Scope Analysis/ Defect planning for Sprints to preparing Memo at end of each Sprint.
• Involved in Stream lining the Defect review process with many initiatives. Implemented 3 levels of review to improve the quality of defects and minimize the defect flowing back to Testing from Triage/Development.
• Coordinated dis-positioning and tracking of defects for various Sprints throughout the testing life cycle.
• Performed Task allocation for team on daily basis and collect/report status for onsite leads analysis. Precisely update detailed Status on defects to management for project level decision. Call out any blocking issues on time, to avoid any delays in defect dis-positioning.
• Acted as bridge between Onsite and Offshore in getting clarification for defects from Onsite Scrum Leads/Business.
• Responsible for monitoring accuracy of defects present in RTC & QC and to maintain sync between the two.
• Coordinated more than 35+ members to get RTC and QC access.
Business Analyst
Cognizant - Amex
India
03.2011 - 06.2012
• Responsible for project coordination and preparation of requirements documents.
• Involved in requirement analysis and preparation of use case documents; use case diagrams, activity diagrams, and flow chart diagrams.
• Conducting weekly status calls with the stakeholders and prepares weekly status reports and project metrics. Involved in writing system requirement specification (SRS), functional Requirement specification (FRS) and requirements traceability matrix (RTM).
• Performed requirement walkthroughs with the Dev. and QA teams with the aim to develop test strategies and test plans such that test cases reflect user needs.
• Liaised with business and functional owners during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Responsible for performing GAP and Risk analysis of existing system and evaluating benefits of new system.
• Responsible for conducting Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
• Involved in validating technical designs created by IT developers against functional specifications.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Prepared business process models, defined milestone deliverables, and established critical success factors. Involved in preparation of Use Cases, Test Plans and Scripts.
• Worked with PM to prepare and manage project plan for resource allocation and capacity planning which includes offshore team coordination and work allocation. Cater to application support activities; analysis and resolving of issues / trouble tickets and also aiding in business sign off’s.
• Involved in different business processes and assisted organization to get price-effective creation with an increased quality, effectiveness and satisfied client service.
Onsite Coordinator
L&T Infotech - Travellers Insurance
US
05.2010 - 09.2010
• Responsible for Offshore Coordination
• Preparation of Business Requirement Documentation
• Responsible for Clarifying client requirements, business needs, and project objectives via feedback sessions and client meetings, in collaboration with all stakeholder
• Allocating task for the offshore team
• Preparing detailed documentation of business and system requirements, process flows, and data models
• Responsible for maintaining requirements in Share point and Quality centre
• Involved in SQL Preparation for various Change Controls
• Responsible for Testing / SQL Validations in different Environments
QA Analyst
L&T Infotech - Travellers Insurance
India
06.2006 - 04.2010
• Performed Black Box testing (Functionality, Regression-Testing, User-Interface testing) for Quantum product (web based application).
• Preparation of Test-Scenarios, Test-Conditions, Test-Cases and Test data.
• Involved in Functionality Testing, Integration Testing, System Testing, Regression Testing.
• Identifying Regression and E2E test cases.
• Worked closely with SME's and testing team to conduct end to end testing of the application
• Plan for regression cycles for every release
• Reporting Bugs through using QC and defect status tracking in QC.
• Verifying current live defects (Not closed or rejected) tracking them till closure.
• Updating the issues log with identified test problems on a daily basis, logging issues with a detailed description of the problem and a script number.
• Worked closely with SME's and testing team to conduct end to end testing of the application
• Responsible for testing in different test environments before implementing the changes to Production system
• Prepared user documentation, imparted training to key users and provided Production Support
• Communicated with client on a daily basis and developed an automation program in COBOL to generate reports which reduced two third of the testing time
• Project was chosen for SAS 70, wherein actively coordinated various SAS 70 activities within the team
Education
Holds Bachelor of Engineering - Electronics And Communication Engineering
Anna University
India
08.2002 - 05.2006
MBA - Human Reosources
Bharathiyar University
India
06.2008 - 01.2010
Additional Information
No Visa sponsorship required
Contact - 07448626484
Mail - ramyapriyadharsni.selvaraj@gmail.com
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Data Quality Analyst
WPP
11.2019 - Current
Test Lead
Cognizant - Travellers Insurance
06.2016 - 08.2018
Test Lead
Cognziant - Comcast
11.2014 - 05.2016
Test analyst
Cognizant - AAA Insurance
07.2012 - 03.2013
Business Analyst
Cognizant - Amex
03.2011 - 06.2012
Onsite Coordinator
L&T Infotech - Travellers Insurance
05.2010 - 09.2010
MBA - Human Reosources
Bharathiyar University
06.2008 - 01.2010
QA Analyst
L&T Infotech - Travellers Insurance
06.2006 - 04.2010
Holds Bachelor of Engineering - Electronics And Communication Engineering