Candidates About

 

 

Santhi Selvam

 

PROFRESSIONAL  SUMMARY

 

 

• 6 years of Experience with full system development lifecycle, including designing, developing and implementing test plans, test cases and test processes fuelling swift corrective actions and significant cost savings.
• Strong Experience with Manual Testing and Client-Server applications.
• Extensive experience in reviewing Functional Documents, Business documents (BRD), Test Cases, Test scripts and Execution.
• Highly experienced in Functional testing, Integration testing, System testing, End-to-End, UAT and Regression Testing.
• Experience in Data Warehouse applications testing using Informatica Power Centre and multiple platforms.
• Well versed with all the phases of Software Development Life Cycle (SDLC) Including Agile Methodologies and extensively worked in all the phases holding major responsibilities
• Excellent experience in identifying, documenting and execution of different scenarios for the system and integration testing.

·         Experience in execution of ETL Jobs (ETL Testing) and report issues.

·         Experience in Oracle PL/SQL and Stored Procedures.

·         Extensive experience in writing SQL queries for data validation and verification.

• Experience in defect logging using JIRA and HP Quality Center systems.
• Experience with GUI application testing, Database testing and Front-end testing. 

·         Strong experience in building Test Case document for different scenarios, Test Case Execution, Test Data Preparation, Test Environment Setup, Defect Verification and Management, Metrics Collection, Creation of Test Design Specification, Verification of requirement specification.

• Extensive working experience on Functionality Testing - Regression Testing, System Testing. GUI Testing, Integration Testing.
• Expertise in creating business components, high level flow diagrams and converting the scripts.
• Experience working in Banking, Financial Services and Healthcare solutions.

 

 

 

TECHNICAL SKILLS SUMMARY

 

 

SCRIPTING TOOLS                        Java, Java Script, SQL, VB Script

OPERATING SYSTEM                     Windows/NT, UNIX, LINUX

RDBMS                                           Oracle, DB2, MS SQL, PL/SQL

OTHER TOOLS                                JIRA, HP QC, Informatica Power Center (ETL), TOAD, SQL        Developer

 

 

 

 

 

 

PROFRESSIONAL EXPERIENCE

 

Client: National Medical Care, MA                                                               Oct 2016 – Till Date

                                                                                                                               

Role: QA Tester

Project: Orders & Treatment Interfaces (Clinical Systems)

 

Implementation of eCube Clinicals was mainly focused on the patients visiting Incentre for Hemodialysis. Each phase of the project was to integrate the eCube Clinical information system with the CHAIRSIDE and SRM applications, providing the clinician the ability to act upon Incentre treatment orders. In addition, these Incentre orders, results and treatment data are passed back to the eCube™ Clinicals system after completion of the patient record. 

 

The objective of this project is mainly to provide testing support for the projects and changes requests implemented from eCube Clinicals systems to the Treatment & Lab system Chairside and Spectra applications respectively.

 

Responsibilities:        

 

·         Performed Functional testing, End to End, back end verification and Regression testing.

·         Performed ETL integration testing to compare the clinical source data and the data transformed by the ETL process in the target database.

·         Involved in requirements and design meetings, review and analysis of design documentations.

·         Performed verification of Clinical UI interfaces for different order categories submissions and the transmitting of HL7 messages from the Source app to the target applications.

·         Prepared Test cases according to the business specification and wrote simple to complex SQL Scripts to verify the back-end tables.

·         Worked on the creation of extensive SQL queries for data verification.

·         Ensure that all the Test Cases are clear, concise, detailed and updated regularly in the Quality Center.

·         Responsible to report bugs using Quality Center and MS Excel. Created the defects and mapped directly to the requirements in the Quality Center.

·         Worked side-by-side with the technical team as well as developers to enable defect free implementations.

·         Updated bug status through regular communications with Development team.

·         Performed Front-End Testing, Functionality Testing, and Data Driven ETL Testing using the SQL Developer for the ETL team.

·          Testing of various functionalities along with the implementation team, resolved the issues and problems.

·         Co-ordinate with the Dev team during the code and the data migration from development to higher environments.

·         Participated in status meetings, review sessions and defect meetings to meet the deliverables.

 

Environment:  Windows, MS SQL Server, UNIX, Oracle 12c/Exadata, Informatica PowerCenter 9.6, HL7, HP Quality Center.

 

 

Client: Principal Financial Corp, IA                                                Mar ‘2016 – ‘Sep 2016

                                                                                                                               

Project:  People Central systems Conversion

Role: QA Tester

 

Overview: People central system maintains the Human resource information for all the principal employees and contractors who works across the country. The data collected on daily basis from different source feeds are stored in the people central data warehouse to preserve historical information for an employee and generate reports like Active employees or contractors dropped from the company, Duplicate entries for an employee and to capture change in personal information.

 

The testing objective is mainly to compare the data quality between the tables loaded via the PL/SQL process and the tables loaded via the ETL process from different source feeds.

 

Responsibilities:

·         Involved in requirement analysis, design, development, testing, documentation and administrator Tasks.

·         Testing of various functionalities along with the implementation team, resolved the issues and problems.

·         Prepared Test cases, according to the business specification and wrote SQL Scripts to verify the test cases.

·         Ensure that all the Test Cases are updated in the Quality Center along with Master Test Plan.

·         Responsible to report bugs using Quality Center and MS Excel. Created Test lab and map the defects directly to the requirements in the Quality Center.

·         Updated bug status through regular communications with Development team.

·         Conducted meetings to review the data comparison and accuracy with the team.

·         Performed Data Driven Testing using the SQL Developer.

·         Created extensive SQL queries to analyse and compare the data between the tables loaded via the PL/SQL engine and the ETL processes.

·         Created ETL test data for all ETL mapping rules to test the functionality of the Informatica.

·         Created PL/SQL procedures to repeat the iterative testing with the SQL statements

·         Developed test plans for initial implementation, all break/fix and enhancement changes to System.

·         Comprehensive knowledge of software testing, Software Development Life Cycle and manual testing methodologies.

·         Gathered requirements to conduct thorough functionality and end to end testing.

 

Environment:  UNIX, Oracle 11g, PL/ SQL (Packages, Procedures & Functions), HP Quality Center Bug Tracking, SQL Developer, Informatica Power Center 9.1

 

Client: Principal Financial Corp, IA                                                       Sep ‘2015 – ‘Feb 2016

                                                                                                                               

Project:  Group Dental – Claims Systems

Role: QA Tester (Web Application and ETL Testing)

 

Overview:  The Principal Financial Group (Principal) offers businesses individuals and institutional clients a wide range of financial products and insurance products through its diverse family of financial services companies.

 

The objective of the testing is to support the claims process and the payment generation to the providers.

 

Responsibilities:    

·         Involved in project requirements and design meetings, review and analysis of design documentations.

·         Prepared Test cases, according to the business specification and wrote SQL Scripts to verify the test cases.

·         Ensure that all the Test Cases are updated in the Quality Center along with Master Test Plan.

·         Executed tests and log results. Designed, Communicated, and enhanced QA testing plan for the application. Prepared and executed test cases manually for different modules.

·         Generated Project status reports thru Quality Center and Document Generator for team meetings and Management review.

·         Responsible to report bugs using Quality Center and MS Excel. Created Test lab and map the defects directly to the requirements in the Quality Center.

·         Updated bug status through regular communications with Development team.

·         Performed Front-End Testing, Functionality Testing, and Data Driven Testing using the SQL Developer.

·         Developed extensive SQL queries to validate the backend data.

·         Involved Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems. Used Test director for bug tracking

·         Developed and executed functional, integration and system test plans for initial implementation, all break/fix and enhancement changes.

·         Comprehensive knowledge of software testing, Software Development Life Cycle, and IVR manual testing methodologies.

·         Supported documentation across extending testing team as directed by UAT Manager, and SIT Manager.

·         Authorized, scheduled, supervised and smoke-tested thin code and data migration from development to test environments.

·         Gathered requirements to conduct and schedule stress tests. Checked the functionality of the website.

 

Environment: Microsoft Windows, Oracle 11g, Informatica PowerCenter (ETL), HP Quality Center, UAT, SQL Developer

 

Client: MetLife USA, India                                                                                    Aug ’2013 - Jun ’2015

                                                                                                                               

Role: Test Engineer

Project: METBANK PHASE II

 

MetLife was in the process of building an Enterprise Data Warehouse and Data Mart for Individual Business.  The Individual Business Data Warehouse will integrate the information from various data source systems into one central repository providing the organization a cross-enterprise consolidated view of the information

 

Testing support was provided for the ongoing projects and change requests for the data warehouse application.

 

 

 

 

 

Responsibilities:    

• Prepared Test cases according to the business specification and wrote simple to complex SQL Scripts to verify the back-end tables.
• Ensure that all the Test Cases are clear, concise, detailed and updated regularly in the Quality Center.
• Responsible to report bugs and map the defects directly to the requirements in the JIRA.
• Worked side-by-side with the technical team as well as developers to enable defect free implementations.
• Updated bug status through regular communications with Development team.
• Performed Functionality Testing, and Data Driven Testing using the SQL Developer.
•  Testing of various functionalities along with the implementation team, resolved the issues and problems. Used JIRA for bug tracking
• Smoke-tested thin code and coordination with DEV team for data migration from development to QA environments.
• Participated in status meetings, review sessions and defect meetings to meet the deliverables.

·         Prepared formal test documentation including test cases, test summary reports, Bug fix and test evidence procedures, and reports. 

·         Performed testing in different environments- QA, UAT and Production Support environment.

·            Conditioned the data for testing different environment.

·            Conducted Data Integrity Testing by cross reference to the source and the target systems.

·            Prepared and maintained documents like Defect Report, Test Report.

·            Participated in status meetings, review sessions, defect meetings in order to meet the deliverables.

 

Environments: SQL, Windows/UNIX,  MS Access,  JIRA Defect Tracking, Informatica PowerCenter 9.1

 

Client: Royal Bank of Canada                                                                               Oct ’2012 - Jul ’2013

                                                                                                                               

Role: Associate Tester

Project: USWM - Client Source

 

Client Source has been developed to meet Private Client Division’s need to gather and store KYC information in a manner that is easy to create, retrieve and relate amongst our clients’ accounts. The first step is to create a client profile. The client profile contains information like the name, address, assets, income etc. about the client. This information is consistent for any account a client opens because it is specific to the client.  Later, when you open an account, you will enter information specific to each account, like objectives and risk tolerance.  

 

Major Modules:

·         Create Clients

·         Create Accounts

·         Form Generations

 

Responsibilities:    

 

• Attend the Project Kickoff Meetings with PM and Dev and understand the requirements.
• Prepare the estimate for the Project kickoff meetings attended and share with Leads.
• Create the test plan in Quality Center by referring to the BRD.
• Set up the test plan review meeting with Dev and PM and explain the test scenarios/cases in QC.
• Conduct Meetings and co-ordinate with Dev and Release team to deploy the code & setup for QA and UAT environment
• Track the new/ updated requirements in the project and modify testing artifacts accordingly
• Identify and track defects while effectively coordinating efforts with developers or responsible parties to ensure defect resolution.
• Ensure the resolved defects are re-tested
• Provide analysis and data for use in debugging.
• Logging and Tracking defects using HP QC.
• Involved in triaging the Production Issues and preparing documentation & analysis for the issues reported.
• Interaction with onsite coordinators, Dev and PMs for clarifications or other needs.
• Prepare Daily status and send to the onsite coordinator. Prepare and maintain documents such as test environment sheet, metrics sheet, RCA doc, sign off doc, readme doc.

 

Environment: MS SQL Server 2008., Windows, Oracle, HP QC, SQL Developer

 

Employer:   Polaris Consulting and Services, India                               Mar '2012 – Sep ’2012

                                                                                                                               

Role    : Associate QA Tester

 

Responsibilities:

·         Develop test plan and work on the creation of test cases and test scenarios

·         After the test scenarios are signed off, the team would work on documenting the test cases

·         Participate in the training of software testing methodologies

·         Prepare test data

·         Execute the test cases

·         Report defects

·         Prepare test reports

·         Provide inputs for test metric collection

·         Scope the required tests needed per the requirements.

·         Design the required test strategy in line with the scope and organization standards

·         Participate in the defect review and other internal project related meetings.

Environment: Windows, Oracle 11g, Visual Source Safe, Visual Basic, Quality Center

 

 

EDUCATION

 

Bachelor of Computer Application (BCA), University of Madras