NEHA KARNA Contact number: 1-312-***-****
**** * ********* ***, *******, IL 60660 ****.*********@*****.***
Career Objective:
Highly motivated and experience accomplished Quality Assurance Software Testing of various Web based applications, System Analysis, Software Validation and Client-Server applications. Expert at leading complex multistage projects. Proven ability to test all phases of project life: inception, documentation, procurement, deployment, and monitoring. Outstanding mentoring skills. Exceptional technical-to-business communication skills. Strong analytical and problem-solving skills utilizing logical and systematic approach. Ability to work as a team member or individually. Proven leadership skills. Excellent presentation skills in MS PowerPoint. Capable of making critical decisions while under pressure and assuming responsibility for results. Outstanding customer service skills. Excellent writing and verbal communication skills.
Technical Skills:
Methodologies
STLC, SDLC
QA methodology
Agile, Waterfall
Platforms
Windows, Mainframe
ETL tools
Informatica Power Center, Informatica TDM, TSO Mainframe, DB2
QA Tools
HP Quality Center, QTEST
Defect tracking and management Tools
JIRA and SharePoint
Office Tools
MS Office
Database
MS SQL Server, Oracle, My SQL, DB2
Programming language
SQL
Career Profile and skills:
Have Excellent in communication to give better services and able possess strong analytical and problem-solving skills.
Able to answer questions or resolve problem with minimal supervision.
Hard-working, highly motivated, eager to learn, and “get more work done” attitude.
Detail oriented, resourceful in the completion of projects, and effective at multi-tasking and able to make appropriate documentation.
Hands on Skills:
Systems Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Test Plans, Test Strategies and Test Cases, Defect Report, Agile methodology, Waterfall, and V-Model, SQL, Oracle 10g/11g database, MS SQL Server, DB2, Informatica Power Center, HP Quality Center, JIRA, Mainframe, distributed databases using SQL queries.
Professional Experience:
Project 1: 10/07/2019-03/13/2020
QA Test Engineer
HCSC Testing services, Chicago, IL
Description: The objective of this project was to mask the PHI data by using Informatica TDM tool. HCSC is managing the original PHI data in mainframe system. We used to take mainframe files data and masking according to business rule. Downstream systems are using this masking data in unsecured environments. I played as QA test analyst role in this project. My responsibilities were to analyze requirements, prepare test case document and validate the masking data according to business rules.
Responsibilities:
Analyzed the business requirements.
Designing the test cases and preparing SQL queries.
Participated in daily SCRUM stand-up call, grooming session, sprint planning, sprint review and retrospective meetings.
Validated the data masking files according to business rules.
Validated the masking mainframe file by compared with source mainframe file.
Validated the Db2 tables data which are masked by Informatica TDM tool.
Executed test scripts and verified the results. Reported Bugs to developers through the JIRA.
Documented and tracked defects identified during testing. Report accurate testing status and recommend release to the next environment.
Participated in the system testing.
Involved in design reviews, meeting and test activates on a regular basis.
Worked closely with development teams and customers to design, architect, implement, and support new projects.
Ability to clearly present information, verbally and in writing, to audiences of diverse technical backgrounds.
Update and send the daily status to TMs and ensure the status is up to date in the repository.
Participated in defect triage call, retest the defects and track them to closure.
Participated in Sprint demos and involve as the test analyst in the respective areas.
Worked with TLs/Test coordinators on the query resolutions and communicate.
Updated and maintain the test case document and defect report document for any of the changes.
Project 2
Trainee (ETL tester)
Cognizant USA, Irving TX 08/05/2019-10/06/2019
I am as a trainee in Cognizant as ETL tester.
Have basic knowledge on Informatica, Data-ware house and ETL.
Knowledge of SQL and basics of UNIX.
Knowledge on SDLC and STLC.
Created mappings, workflows and sessions.
QA software testing training:
Testing training and certification 2016 -2017
Education:
Harry S Truman College, Chicago, Illinois 2017-2019
Associate in Computer Science.
Tri Chandra College, Tribhuvan University, Kathmandu, Nepal. 2011 - 2014
Bachelor’s degree in Physics.