Websites
Summary
Skills
Work History
Education
Additional Information
Work Availability
Timeline
Generic
Ramya Selvaraj

Ramya Selvaraj

Data Quality Analyst
London

Summary

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
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
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
US
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

Anna University
08.2002 - 05.2006
Ramya SelvarajData Quality Analyst