Post Job Free

Resume

Sign in

Sql Server Life Insurance

Location:
Cary, NC
Posted:
September 21, 2023

Contact this candidate

Resume:

Harsha Ph.: 919-***-****

Email: adzuyo@r.postjobfree.com

Experience Summary

·Proficiency in testing Web and GUI applications.

·Extensive experience in testing clinical and pharmaceutical applications

·Extensive knowledge of 21 Code of Federal Regulations (21 CFR Part 11., 210, 211 and 820), FDA, and GxP’s(GDP, GMP, GLP and GCP) including electronic records, electronic signatures, system validation strategies and documentation.

·Ensure the correct functioning and validation of clinical trial software with focus on patient safety and integrity of clinical study data following the FDA’s 21CFR Part-11 requirements

·Assists with validation team/initiatives in preparations for validation activates, and perfuming system/application testing

·Hands-on experience in Functional testing of Mobile Application in iOS and Android devices and web application testing in IE/ Chrome/ Safari browsers.

·Create Validation Plan, Risk Assessment, Test Summary reports and capture test metrics

·Efficient in running SQL queries in the database and perform validation.

·Significant experience in testing WEB, Mobile and Client/Server applications developed in Java, J2EE and .Net technologies.

·Performed Functional, Integration, Regression, System and Black Box Testing.

·Extensively worked on testing web application on different browsers

·Experience in software testing documentation.

·Proficiency in Multiple Web Browser Testing.

·Extensive experience in Test case Design, Review and Execution.

·Strong understanding of SDLC and STLC process.

·Extensive experience in creating test cases, test plans and documenting defects and test reports.

·Extensively worked on Defect Management process which includes Identifying, Analyzing, reproducing and communicating with team members in fixing and closure of defects.

·Good at analyzing requirements, gathering the requirements

·Expertise in working with Multiple teams, create test scenarios & test plans as per business requirements, functional requirement document, traceability matrix, bug report, execution summary report.

·Generating the reports using the Quality Center9.0 for complete life cycle by orderly management of different tabs in the QC

·Managed Requirements, Test Plans, and Test Cases using Mercury Quality Center 9.0.

·Expertise in QA Testing with Windows/Unix Environment and Oracle, SQL Server databases as back end

Technical Skills:

Operating Systems: Windows XP, Windows 7/8, UNIX, Linux, Windows 95,

Windows NT 4.0

Databases: Oracle 7.x/8i, MS-Access7.0 and SQL Server6.5/7.0

Methodologies: Agile, Watrefal

Test Management Tools: HP Quality Center (9.0, 11), Clear Case

Bug Tracking Tool: Clear Quest (6.0), HP Quality Center (ALM), JIRA, Bugzilla, Rally

Technologies: Java,J2EE, .NET,XML, Sharepoint.

Other Skills: Offshore Management, Virtual Environment setup,

Power Point, MS Word, MS Excel, MS Office, .

Professional Experience:

Infosys Jul-2020- Till Date

Client: Pacific Life Insurance Company

User Acceptance Tester Jul’2021- Till Date

Pacific Life offers life insurance, annuities and investment products to individuals and businesses. Pacific Life sells term life insurance and a broad selection of permanent policies, including life insurance with long-term care benefits. Stable Value solutions provide employers the opportunity to empower their employees to grow their savings while minimizing their risk. Stable Value is a low-risk plan investment option focused on principal preservation and liquidity, while providing steady, positive returns to participants

·Created test scenarios and test cases in JIRA

·Reviewed test scenarios, test cases with business users

·Created E2E test scenarios and developed test scripts for E2E testing

·Executed test cases and documented test results in JIRA

·Created Validation Plan, UAT Test Plan

·Created test data for Validation and User Acceptance Testing.

·Lead the User Acceptance Testing

·Helped business users in Sprint, Validation and UAT testing.

·Created defects in JIRA and Worked with developers and business users resolving defects

·Reviewed test execution with business users

·Worked with business users and development team after go live issues.

.

Client: Truist Financial

Functional Tester Jul’2020- June’2021

Truist Online Banking and Client Portal

Truist Online Banking and Client Portal helps to transitioning the current SunTrust and BB&T online channels to Truist Online and other evolving digital channels.

·Reviewed functional and business requirements.

·Developed test cases as per business requirements in Rally.

·Executed test cases in in Rally

·executed test cases in Perfecto for Mobile Testing.

·Used Snipping tool to take Screen Shots as per the requirements to meet the acceptance criteria

·Regression testing is performed manually in Rally documented the test results.

·Involved in integration testing

·Posted queries about requirement on the discussion board in Rally

·Discussed about the critical defects win daily standup

Environment: Agile, Rally, Microsoft Word, Microsoft Excel, Perfecto, SoapUI, AWS, Windows 7 and Windows 10

Cenduit

CSV Test Analyst Jan’20 - Feb’20

Cenduit Atlassian Solution Design- JIRA Implémentation

Worked side-by-side with Cprime to receive an Atlassian Assessment which would identify ways to migrate some of their key processes to be done within Atlassian Tools, primarily JIRA Software, JIRA Service Desk and Confluence, and to identify key pain points within Cenduit's current processes.

·Reviewed functional and business requirements.

·writing and executing test scripts for customized systems based on approved client requirements and use cases including IQ and OQ based test types

·Write and or execute test scripts that will challenge requirements and database/data flow integrity with regards to data analytics data flow models

·Analyzed client requirements to develop test plans.

·adhering to applicable regulations including 21CFR Part 11.

·Supported manual testing of critical functionality requirements including data set up for Client UAT and live implementation

Environment: Atlassian JIRA, Microsoft Word, Microsoft Excel

YPrime, Inc Jan’16 – Jul ‘19

Software Tester

Raleigh, NC

YPrime, Inc. is a leader and innovator in eClinical solutions and technologies used exclusively in clinical research, healthcare and IT. We help Life Science organizations align process with technology to increase productivity, reduce costs, minimize risk, and grow strategically.

·Responsible to execute testing and validation in accordance to Y-Prime and customer SOP’s dependent within project timelines

·Worked in Agile/Scrum Development environment with frequently changing requirement and features.

·Review requirement Documents, functional specifications and involved in developing test strategy, test plan and test case documents.

·Develop validation plans according to a risk-based testing methodology and risk based change controls.

·Ensure the correct functioning and validation of clinical trial software with focus on patient safety and integrity of clinical study data following the FDA’s 21CFR Part-11 requirements

·Involved in Risk assessment meetings.

·Writing functional test plans from the system requirement documents

·Execute and develop validation plans according to a risk-based testing methodology and risk-based change control.

·Performed regression test on new code prior to implementing into the test environments.

·Performing end to end regression in dev environments prior to release to functional testing teams.

·Executing test scripts and logged the defects and worked with developers to resolve the issues.

·Responsible for regression testing after fixing bugs.

·Performed EDI Transmission.

·Create Test Summary reports and capture test metrics

·Utilize defect tracking system to document defects and track resolution

·Using SQL Server Management Studio to execute and perform SQL query to validate back-end table updates

·Working knowledge of SQL and interacting with DB as part of verifying the test case results.

.

Environment: .Net, SQL Server 2012, Assembla, TFS, VSO, Veeva Vault, EDI, Google Chrome, IE, FF, Snagit Editor

Fidelity Investments Jul’15 – Dec’15

Software QA Analyst

Durham, NC

Advisor Digital Experience.

WI is in the process of developing a new web experience for our Advisor clients. Our ultimate goal is to provide a place for an Advisor to go to obtain detailed information about the plans they have with Fidelity, insights about those plans and the retirement markets in general, and tools that will help them to manage their practice.

Responsibilities:

·Created test cases in QC based on system specification

·Reviewed test cases with business, system analysts and development team

·Executed test cases and documented test results in QC

·Worked with developers and system analysts resolving defects

·Created test execution checklist

·Reviewed test execution with business, systems analysts and developers

·Attended daily stand up meeting.

·Created regression test scripts in Sahi pro.

·Created test data using Sahi pro.

·Used SOA Para soft tool for web services testing.

·Involved setting and mining test data for test case execution.

·Attended change control meeting.

·Attended Iteration closing and new iteration planning sessions.

Environment: QC12, JIRA, Agile, Web services, AQL tool, Saahi pro, Java, J2EE, Google Chrome, IE, FF,

Measurement Inc Jan’15 – Apr’15

Software QA Analyst Durham, NC

Measurement Incorporated™ (MI) is a full-service educational company that provides achievement tests and scoring services for state governments, other testing companies, and various organizations. Since its founding, MI has earned and continues to uphold its reputation as the industry leader in providing professional hand scoring services for essays and open-ended exams.

Responsibilities:

·Maintain and execute test cases.

·Tests on Windows 7, 8, Vista, XP, Mac, and Linux operating systems

·Write SQL queries, SQL Joins for back-end testing via SQL Server 2008.

·Performed functional, regression testing.

·Worked on multiple browsers IE, FF, Google Chrome

·Verified fixes on QA and Staging environments.

Environment: Fogbugz, SQL Server, Java, J2EE, Google Chrome, Android, Mac Book, IE, FF, Browser Stack, MS Office Suite.

Rho Inc Aug’14 – Dec’14

Software Test Engineer Chapel Hill, NC

Rho is a full-service, professionally managed CRO (contract research organization) optimally sized to deliver results from clinical research with agility and adaptability. Provide excellent service to some of the nation’s leading pharmaceutical, biotechnology, and medical device companies as well as a number of federal agencies under FDA rules and regulations.

Responsibilities:

·Involved in functional testing and system testing of Rho portal.

·Regression testing is performed manually

·Documented the test results in JIRA

·Participated in daily scrums

·Worked on multiple browsers IE, FF, Google Chrome

Environment: Spring, MVC, Eclipse, SOAP, Agile, Java, J2EE, Team City, Browser Stack, Oracle, My SQL, XML, Share Point, Microsoft Excel and MS Word, JIRA.

Duke Energy Jul’12 – Mar’14

QA Analyst/Tester

Cary, NC

Duke Energy is a leading energy company focused on electric power and gas distribution operations, and other energy services in the Americas – including a growing portfolio of renewable energy assets.

(Duke Energy’s Franchised Electric & Gas operations provide safe, reliable and competitively priced electricity to customers in North Carolina, South Carolina, Florida, Indiana, Kentucky and Ohio.

HR & Finance Integration Project

Role: Defect Coordinator.

Responsibilities:

·Worked with our offshore team to find out if they are having issues, as well as discuss about the defects to see if they need more info or if the defects are not being created/updated properly

·Created Daily ALM status reports

·Updating the defects based on the information provided by developers, testers and Bas in ALM 11.

·Created for stabilization reports after go live

·Prepared Power Point Slides for project steering team review.

·Assist in the deployment process to verify production releases.

Environment: Share Point 2010, SQL Server, .net, Power Point, Quality Center 11.0, ALM 11. Agile, Selenium IDE, XMl, Selenium Web driver, Crystal Reports, .net, Java, J2EE, C#, Web methods,

Progress Energy Aug’11 to Jul’12

System Tester/Analyst

Progress Energy, headquartered in Raleigh, North Carolina is a subsidiary of Duke Energy and prior to its merger with Duke Energy was a Fortune 500 energy company with more than 21,000 megawatts of generation capacity and $9 billion in annual revenues. Progress Energy includes two major electric utilities that serve approximately 3.1 million customers in the Carolinas and Florida.

System testing was done for the applications to check the compatibility on Win 7.

Project: Win 7 compliance and remediation project—Application Tester

System testing was done for the applications to check the compatibility on Win 7.

·I was honored with excellence award for my hard work and accomplishments in this project.

Responsibilities:

·Developed test scripts and test cases in word document.

·Involved totally in manual testing of the application

·Executed test cases for functional testing and system testing.

·Created Test reports for every build & sent to developers

·Regression testing is performed manually.

Environment: Oracle, mainframe, DB2, SQL, MS Office,.NET, Crystal Reports, VBA, ASP, .NET, C#, SQL Server.

Education:

Master of Business Administration

Osmania University, India.



Contact this candidate