Quality Assurance Sql Server
Resume:
Sri Poorani Manoharan
*************@*****.***
PROFESSIONAL SUMMARY
Working as Software Quality Assurance Engineer with 10 Years 7 Months of experience in Software Testing Life Cycle (STLC) of Web based applications, SAP GUI, NWBC, SQL Server, Teradata, Control M, JIRA, QTest
Proficient in preparation of Test Plans, Test Cases, Test Procedures, Integration Testing, Defect tracking.
Hands on Experience in HP ALM, QTest, JIRA for defect tracking and SQL Server used for backend database
Experience in various Software Test Methodologies such as System/Functional Testing, Integration Testing, Black box testing, Requirement Based Testing and Regression Testing, Database Testing, Teradata, Control-M.
Effective in Requirement based testing and Expertise in SQL Database
Exposure in Software Engineering Process and familiar with various Life Cycle Models like Waterfall and Agile Software Methodology. API testing, ETL Testing, Postman, Snowflake and good knowledge on AWS
Good expertise on Web based applications testing and SAP NWBC, SAP MM, SAP PLM testing by understanding and analyzing the Requirements, ensure on time deliverable with customer specification are met.
Expertise in handling large team, Team Lead, Test Strategy, Test Plan, Traceability, Release activities.
Handled a team as a Scrum master and worked on Product Life Cycle management.
Excellent Communication and interpersonal skills with abilities in resolving complex software issues.
Ability to work in a team environment and as an individual with strong technical and communication skills, and good zeal in adapting new technologies with short learning curve.
AREAS OF EXPERIENCE
Team Lead, Requirements Management, Tractability, Interacting with Business Analyst
Worked on Health Care domain, Line of Business, PSL, Provider Grouping, Programs, MCP, MCT
Proactively involved in Grooming call with business, sprint planning, multiple projects handling at a time
Agile Software Methodology, System Integration Testing, Functional Testing, Black Box Testing, Supporting UAT testing
Knowledgeable on Automation Testing, HP Unified Functional Testing (UFT), VB Script, SQL, SAP MM. SAP PLM, SAP EHS
Project Management, Test Life Cycle, Defect Life Cycle
TECHNICAL SKILLS
Operating Systems : Windows 2007
Databases : SQL, Teradata, Control M
Testing Concepts : STLC, Test Management, SAP MM
Testing Tools : UFT (Unified Functional Testing)
Tools & Utilities : MS - Office and MS - Excel
Test Management Tools : Quality Center (HP ALM)
Scripting Language : VB Script
PROFESSIONAL EXPERIENCE
Client: Anthem Inc Oct-2021 - Mar-2025
Project: PIMS UI
Testing Tools: JIRA, QTest, Website health care tool, Teradata, SQL Server, Control M, AWS
Project Description:
The Purpose of this project is to do enhancement of Payment Innovation management System Unlimited Innovation to work on various features of Health care domain. FT Calculation, EPHC Contract Mode, Episode Bundle Payments, Provider data exchange are the modules as part of PIMS UI. It also has Creation of Provider Grouping and Program specific to Line of Business such as Commercial, Medicaid and Medicare. Worked with different team GBD, FT, Payment Model, Attribution for Data Preparation from PIMS UI. Involved in EPHC 1.0, EPHC 2.0 projects.
Roles and Responsibilities:
Interact and communicate with business partners and technology teams
Involved in Sprint Planning, Grooming call, Retrospective and Scrum meeting
Handling the SIT Team by scheduling Test case walkthrough, SIT Status call and guiding them on completing Stories
Validate new functionality and ensure existing systems are not impacted negatively
Understanding of testing methodologies such as static & dynamic testing, black box and white box testing. Experience in system integration testing, Database testing supported UAT team in data preparation.
Used JIRA tool for tracking the User Stories, Sub task and Defect management
Completed System Integration testing before deadline and delivered 100% defect free UAT.
Client: Anthem Inc May-2022 - Jul-2022
Project: SPS
Testing Tools: JIRA, QTest, Website health care tool, Teradata, SQL Server, Control M, AWS
Project Description:
The purpose of this project is to validate Adds and Drops of Taxpayer Identification Numbers (TINs) and National Provider Identifiers (NPIs). Coordinated with various team PDL, Attribution as part of this Project.
Roles and Responsibilities:
•Interact and communicate with business partners and technology teams
•Involved in Sprint Planning, Grooming call, Retrospective and Scrum meeting
•Preparation of Test Strategy, Test case, Test execution and walkthrough Test result with business
•Analysis of Adds and Drops of NPI and TIN, impact on Provider grouping, comparing the result with Production data
Client: Anthem Inc Jun-2023 - Aug-2023
Project: Wellcap
Company: Carelon Global Solutions
Testing Tools: JIRA, QTest, Website health care tool, Teradata, SQL Server, Control M, AWS
Project Description:
The purpose of this project is to support Wellcap team in data preparation based on the criteria provided for Provider Grouping. Termination, voiding, creation of Provider grouping is considered.
Multiple delta is taken is considered and modification of PG is done in each delta and shared with Wellcap team for validation.
Roles and Responsibilities:
•Interact and communicate with business partners and technology teams
•Involved in Sprint Planning, Grooming call, Retrospective and Scrum meeting
•Preparation of Test Strategy, Test case, Test execution and walkthrough Test result with business
•Creation, Updation, Modification of data is done based on the criteria provided by Business.
• Creation of Data should be considered specific to Line to Business Commercial, Medicaid, Medicare and PSL PPO, HMO with various Program types FPP, PRR.
Client: Hewlett Packard Enterprise June 2020 - Sep 2021
Project: SUPPLIER CAMPAIGN REPORTING
Testing Tools: SAP GUI, NWBC, HP ALM
Technology: SAP MM, SAP PLM, SAP EHS
Project Description:
The Purpose of this project is to rebuild compliance solutions around SAP EHSM, the business needs a way to reach out to suppliers in an automated fashion and for supplier level information. For this project, the scope will be for acquiring the supplier’s GSE acknowledgement.
Roles and Responsibilities:
•Interact and communicate with business partners and technology teams
•Validate new functionality and ensure existing systems are not impacted negatively
•Create and program a testing environment from scratch uploading test cases and execution of test cases
•Understanding of testing methodologies such as static & dynamic testing, black box and white box testing. Experience in system integration testing
•Defect Logging and generated daily based report from HP ALM and sent to Project Team
•Completed System Integration testing before deadline and delivered 100% defect free UAT.
Client: Hewlett Packard Inc Jan 2019 - May 2020
Project: TRACER
Testing Tools: SAP GUI, HP ALM
Technology: SAP MM, SAP PLM, SAP EHS
Project Description:
Regulatory Model Number is generated for the various products using WTR-TRACER module in SAP NWBC. It also helps in managing Business rule for its Approval Objective, Components, Change request and creating Regulated Item – Certification package.
Roles and Responsibilities:
•Quick understanding the business and technical requirements in order to design & execute appropriate tests scripts
•Validate new functionality and ensure existing systems are not impacted negatively
•Test case development and uploading in HP Application Lifecycle Management and HP ALM
•Defect Logging and generated daily based report from HP ALM and sent to Project Team
•Reviewing and ensure quality of the deliverable is par with the customer specifications
•Completed System Integration testing before deadline and delivered 100% defect free UAT.
Client: Hewlett Packard Jun 2016 - Dec 2018
Project: SERPENT
Testing Tools: SAP GUI, HP ALM
Technology: SAP MM, SAP PLM, SAP EHS
Project Description:
SAP EHSM related project which supports organization in managing business process related to environment, health and safety. It provides functionality supports in managing incidents, assessing risk, and complying with product compliance requirements
Roles and Responsibilities:
•Involved in Requirement gathering with Business Analyst as a Test Lead
•Assigning the Technical specification design to the respective team members
•Creating Test Environment and identifying test data
•Managing team of 7members and setting up regular meetings
•Working in Agile Test Methodology
•Creating log on Defects, tracking the defect
•Focus on customer satisfaction and on time deliverables
•Involved in both Test life cycle and Defect life cycle and Delivering defect free UAT
Client: Hewlett Packard Aug-2014 - May 2016
Project: FMD
Testing Tools: SAP GUI, HP ALM
Technology: SAP MM, SAP PLM, SAP EHS
Project Description:
This project enables the submission of Full Material Disclosure (FMD) declarations into the Environment to enable the HPE business to more rapidly respond to Regulatory Compliance.
Roles and Responsibilities:
•Interacting with BA for better understanding of the requirements as a Test Lead
•Managing team of 8members and assigning documents
•Collaborating with team members, creating test environment and setting up regular meetings
•Working in Agile Test Methodology
•Logging defects and managing on the same after fix
•Focus on customer satisfaction and on time deliverables
•Involved in both Test life cycle and Defect life cycle and Delivering defect free UAT
EDUCATION
Bachelors of Engineering in Computer Science, Anna University
AWARDS & RECOGNITIONS
•Received “Hall of Fame” award at Hewlett Packard for the year 2015 for “SERPENT” projects for quick learning and on time delivery with defect free UAT.
•Received Token of Appreciation for organizing team activities and for being responsible in Tasks in the year of 2016.
•Received “Excellence in delivery” by the manager for the Project “FMD”.
•Received “Excellence at work” by my manager for PIMS Project taking addition responsivities of managing the Team and working on multiple User Stories in the year of 2022
Contact this candidate