Siva Sankari Kalyana raman
Quality Assurance Lead
Norwood,MA
Summary
15+ years of experience in Software Quality Assurance with strong knowledge in SDLC and STLC. Extensive experience in testing Client/Server and Web based Applications. Proficient in writing various SQL Queries and involved in backend testing of the applications. Expertise in designing and developing strategic Test plans, Test Cases, Test Scenarios & Test Reports. Have good knowledge in using the automation tools QTP and Selenium using Java. Expertise in API testing using SOAP UI, POSTMAN collection and RESTFUL services, Rest Assured Java library and TestNG. Good exposure in defect tracking, reporting, and generating detailed reports using Defect Tracking tools like Quality Center, Rational Clear Quest. Proficient in analyzing Business & Functional requirement specifications. Proficient in various test methodologies such as GUI, Functional, Regression, System Integration, Acceptance, Database, End-to-End and ETL testing. Ability to handle multiple projects simultaneous and managing within the deadlines by Planning, Executing and Monitoring. Worked towards building a strong team environment and managing QA activities. Experience in working on both Agile and Waterfall projects.
Overview
18
18
years of professional experience
Work History
Senior Quality Assurance Engineer
Oracle America
04.2022 - 11.2023
- Prepared the Test Design, Review and Execution of test cases with project meetings and walkthroughs
- Executed the test cases through TestRail and captured the object evidence
- Backend verification of DMW using SQL developer and Pl/SQL scripts
- Performed server-side activities needed for validating the product
- Performed validation of Interim and Patch fixes of the bugs and worked on various SDLC documents pertaining to the release
- Created various clinical studies with different data model from labs and other EDC systems
- Used the DMW to provide to run validation checks across different data sources and standardized data structures for review, cleaning, and analysis
- Validated the aggregation of data from different sources for data processing activities like discrepancy management and provisioned in various formats to support downstream stakeholders
- Verified and validated various database objects for programs and tables in Oracle Life Science Data Hub (LSH)
- Validated the data loaded into Oracle LSH through PL/SQL and custom programs
- Verified the Information retrieval from the data repository through various Data Marts
- Performed loading of data from Oracle Databases, SAS, Text files with different security privileges
- Execution and data processing through PL/SQL programs Worked on various SDLC documents pertaining to major release of the product.
Quality Engineer
John Hancock
12.2019 - 04.2022
- Preparation of Test Strategy and Test plan, Test Design, Review and Execution of test cases with project meetings and walk-throughs
- Implemented Test Strategy and methodologies at various phases of STLC
- Involved in design and automation of Fund change project modules using REST Assured Java library and TestNG Framework
- Performed Web testing and API testing of Client Access using SOAP UI and POSTMAN collections
- Drafted test cases in Quality Center and actively participated in Business review, defects review and Daily Stand-up meeting with various stakeholders and resolved technical issues related to QA activities.
SQA Test Lead
Wipro Limited, StateStreet
12.2018 - 11.2019
- Performed analysis on Business requirements, Configuration Matrix and Change request specifications
- Preparation of Test Strategy and Test plan, Test Design, Review and Execution of test cases with project meetings and walkthroughs
- Involved in Automated Test execution of screening modules using Selenium JAVA
- Front end UI testing of third-party vendor FircoSoft and backend validation using SQL developer.
SQA Test Lead
Wipro Limited, TJX Companies Inc.
11.2013 - 08.2015
- Performed analysis on business process through Use Cases, Workflows, Requirement specifications and Change request specification
- Preparation of System Test Plan, Test Design, Review and executing the test cases with project meetings and walkthroughs
- Mainframe testing of the application in CICIZ regions
- Front end GUI testing of web application
- Executed the test cases and reviewed the Test Cases, Scenarios prepared by the team through internal reviews
- Actively participated in Business review meetings, weekly conference call with clients and resolved the technical issues related to QA activities.
SQA Test Lead
Wipro Limited, State Street
08.2013 - 10.2013
- Performed analysis on business process through Use Cases, Workflows, Requirement specifications and Change request specification
- Preparation of System Test Plan, Test Design, Review and executing the test cases with project meetings and walkthroughs
- Prepared the Test data setup and involved in booking various transactions through MCH
- Performed front end GUI testing of web application and executed the SQL Queries for backend testing through SQL Developer
- Ensured the Defect Slippage ratio is minimal and under the norms specified for the project
- Interacted with Business and DEV team on specific defects and for any CMRs.
SQA Test Lead
Wipro Limited, State Street
10.2010 - 11.2012
- Involved in requirement analysis and interacted with business and DEV team for functionality implementation
- Developed test plans, which included testing overview approach, strategy, and complete scope of testing in Microsoft Office Suite
- Executed the Test Cases to verify actual results to expected results
- Prepared the Requirement Traceability Matrix (RTM) and involved in Test Design, Test Review
- Implemented Orthogonal Array (OA) Techniques for preparing the Test scenarios
- Performed the Test Data setup and preparation and monitored the test execution progress
- Prepared the Daily and Weekly status reports, Test Closure Report and tracked the defects to closure for QA activities
- Handled multiple applications such as Interactive Report designer, Enterprise Service Platform, Enterprise Client reporting and data bases related to MySS.
SQA Test Lead
Wipro Limited, State Street
04.2010 - 09.2010
- Understanding the Business requirement and Functional requirement specifications
- Preformed following testing manually - Functional, Negative & Regression, System and User Acceptance testing
- Performed regression testing by repeated execution of test cases in each build; verified the fixation of bugs and reported new bugs that arose in the defect-tracking tool
- Involved in statistical way of testing the application using Orthogonal Array techniques
- Prepared the Dependency Structure Matrix (DSM) for Prioritization of Functional Test Suites
SQA Test Lead
Wipro Technologies, State Street
07.2009 - 03.2010
- Gathered, analyzed, and verified high level software requirement specification (SRS)
- Executed different levels of Software Testing Life Cycle (STLC)
- Involved in defect tracking and logging defects using Quality Center and tracked the defects to closure
- Performed back-end testing by creating SQL Queries in Relational Database Management System (RDBMS) using Oracle 9i
- Preformed File based testing of Phase 4 files using multi-edit tool and performed the data validation testing using Microsoft SQL Query Analyzer.
SQA Test Lead
Wipro Technologies, State Street
02.2009 - 06.2009
- Performed following testing manually - Functional, Negative, & Regression
- Prepared the Test Strategy and ensured the full test coverage with minimal defect slippages
- Logged defects in Rational Clear Quest and done analysis and tracked till the closure of Defects.
Project Engineer
Wipro Technologies, State Street
10.2007 - 01.2009
- Designed the System Test Plan and written the System test Cases for the BERS application and actively participated as a Quality Coordinator for the project
- Involved in testing the batch jobs with autosys
- Developed the screens in the applications using JAVA Spring framework and written Unit Test Plan and Unit Test Cases and System Test Cases for the applications and tested it.
Project Engineer
Wipro Technologies, State Street
05.2007 - 09.2007
- Involved in developing the Report & Maintenance screens of the application using JAVA/J2EE Spring framework
- Prepared the Unit Test cases, involved in bug fixing and executed the Mainframe feed files.
Project Engineer
Wipro Technologies,Northwest Airlines
05.2006 - 04.2007
- Involved in developing the Order Certificate module using JAVA/J2EE Spring framework
- Reviewed the data model of eNCI with adherence to NWA and data model standards
- Prepared the Unit Test cases for customer & bank details and involved in bug fixing and reporting.
Project Engineer
Wipro Technologies
09.2005 - 04.2006
- Involved in developing the static pages & login module using J2EE Struts framework
- Reviewed the data model w.r.t standards.
Education
Masters in computer science and engineering (M.E) -
Anna University
Tamil Nadu, IndiaBachelors in computer science and engineering (B.E) - undefined
Madras University
Tamil Nadu, IndiaSkills
undefined
Timeline
Senior Quality Assurance Engineer
Oracle America
04.2022 - 11.2023
Quality Engineer
John Hancock
12.2019 - 04.2022
SQA Test Lead
Wipro Limited, StateStreet
12.2018 - 11.2019
SQA Test Lead
Wipro Limited, TJX Companies Inc.
11.2013 - 08.2015
SQA Test Lead
Wipro Limited, State Street
08.2013 - 10.2013
SQA Test Lead
Wipro Limited, State Street
10.2010 - 11.2012
SQA Test Lead
Wipro Limited, State Street
04.2010 - 09.2010
SQA Test Lead
Wipro Technologies, State Street
07.2009 - 03.2010
SQA Test Lead
Wipro Technologies, State Street
02.2009 - 06.2009
Project Engineer
Wipro Technologies, State Street
10.2007 - 01.2009
Project Engineer
Wipro Technologies, State Street
05.2007 - 09.2007
Project Engineer
Wipro Technologies,Northwest Airlines
05.2006 - 04.2007
Project Engineer
Wipro Technologies
09.2005 - 04.2006
Masters in computer science and engineering (M.E) -
Anna University
Bachelors in computer science and engineering (B.E) - undefined
Madras University
Similar Profiles
Dallas FreemanDallas Freeman
Application Sales Executive at Oracle AmericaApplication Sales Executive at Oracle America
YVETTE AGBORTARHYVETTE AGBORTARH
Agile Product Owner at Oracle AmericaAgile Product Owner at Oracle America
Joey PeñaJoey Peña
Oracle Latin America - Deal Mgmt. Sr. Mgr. at Oracle America, IncOracle Latin America - Deal Mgmt. Sr. Mgr. at Oracle America, Inc