Test Cases Data

Amrit Kaur

Phone: 703-***-****

Email: ****************@*****.***

SUMMARY

Complete understanding of QA Methodology and QA Strategy including Software Development Life Cycle (SDLC).

Efficient in performing Manual Testing.

Good knowledge on SDLC methodologies (Waterfall, Agile).

Expertise in designing and developing strategic Test plans, Test Cases, Test Scenarios, Test Reports for manual testing

Knowledge of using HP ALM/Quality Center for developing test cases/ steps and maintaining the test cases repository.

Able to write SQL queries.

Knowledge of HTML, Visio, SAP.

Knowledge about statistical analysis of data.

Advance EXCEL (relative and absolute cell reference, V-lookup, U-lookup, other functions), Macros.

Ability to adapt to a wide range of work environments.

Knowledge of Selenium IDE.

Technical Skills:

Tools: HP ALM/Quality Center, Power BI, SAP, VISIO, MS Access, Tableau

Databases: SQL Server, Oracle, MS Access

Application Tools: MS Office.

KEY SKILLS:

Test Cases, Plans

Defect & Bug Discovery

Issue Identification & Documentation

Education:

Guru Nanak khalsa College (INDIA) May 2014

Bachelor’s Degree, Computer Science

Coursework:

CompSciPrep.LLC Chantilly, VA December 2015 – April 2016

QA and Data Analysis Coursework:

Software Development Life Cycle (SDLC).

Performed Manual Testing to test Web applications.

Good knowledge on QA testing methodologies (Waterfall, Agile) and have in-depth knowledge on all phases of SDLC.

Designing and developing strategic Test plans, Test Cases, Test Scripts, Test Scenarios, Test Reports for manual testing

Performed HP ALM/Quality Center for developing test cases/ steps and maintaining the test cases repository.

Wrote complex SQL queries.

Learnt to Perform different types of tests such as integration, Regression, Functional, Performance, Black Box, Compatibility.

Worked with different operating system like windows and Unix.

Practiced HTML.

Expert in EXCEL (relative and absolute cell reference, V-lookup, U-lookup)

System & Unit Testing, Regression Testing, Load Testing.

Able to quickly learn new technologies and tools.

Work experience:

Navy Federal Credit Union, (Aerotek) July 2017 to Current

(Vianna)

Analyst

UAT of database, including validation of complex business rules.

Used Visio to document complex database and structure into logical grouping.

Created UI Screens using MS Access including some code behind, per developer’s instructions.

Entered data into the Database.

Created organizational charts using Visio.

Performed advance excel functions and lookups to gather and clean up data from different reports and sources mainly for having accurate most up-to-date date for JVS reports.

Converted text files into reports and meaningful data using Monarch and IDEA.

Prepared monthly reports with JVS threshold data using OnDemand, Datawatch Monarch and IDEA tools.

Conducted interviews with key personnel to identify client’s complementary user entity controls (CUECs).

Evaluated controls and supporting documentation to determine adequacy of control.

Performed a comprehensive analysis of SSAE-16/18 reports for 17 vendors to determine what controls client should have in place.

Prepared deliverable to report on client’s control environment.

Gathered control information to respond to audit request.

Prepared report assessment of controls from SSAE-16/18 reports.

Performed SharePoint Admin tasks.

Conservation International, (Hire Strategy) May 2017 to June 2, 2017

(Crystal city) (one month contract)

Jr. Data Analyst

Worked Independently and with Team Lead as required to perform necessary data cleaning and transformation.

Loaded data into Access database to support data analysis.

Imported data into SharePoint.

Visualized data in Excel and Power BI and prepared dashboards for reports.

Developed relationships among many data sets to create single data set.

Performed SQL queries to retrieve data from database.

Prepared data in Excel by gathering missing data from various sources.

Uploaded data into Access database.

Performed AP invoices upload into Unit 4 Business world for payments.

Rehau Inc. (Leesburge, VA) December 2016 to April 2017

Data &

Customs Coordinator:

Prepared three years of data in excel spreadsheet for Duty draw back and Pivot tables to Visualized different data.

Data Assist in auditing U.S and Canadian customs entries to ensure compliance in accordance with the rules and regulations

Identified all customs entries for the past 3 years for imports of materials used in the Mercedes finished goods production.

prepare downloads of reports from SAP for deliveries to Mercedes for finished goods.

prepared data for customs brokers for Mercedes for them to obtain a duty drawback.

Assist in Harmonized Tariff System and maintain.

Assist with Accounts payable reconciliation to assure compliance with each of the audited custom entries.

Assist customs brokers with questions they might have on completing any customs entries.

Excel, word, SAP, MS Outlook, PowerPoint.

Ranstad, K12(Mid-Vendor), (Herndon VA)

Document Processor: June-Sep 2016

Job description:

The Document Processor (DP) is responsible for reviewing and processing enrollment applications, student enrollment documentation and student file maintenance.

• Performs organizational clerical tasks

• Develop a student record filing system to meet the needs of the elementary, secondary and special education teams.

• General filing and records maintenance and Processing and verifying information associated with prospective student accounts

• Input student enrollment documentation.

• Ensure state compliancy guidelines are met for all incoming enrollment documents

• Establish secure access to student records

• Provide enrollment updates on peak periods and Attend various meetings

• Process incoming and outgoing student record requests

• Maintain a log of student record activity

• Work successfully in a highly collaborative team environment

• Other clerical tasks as needed.

*Word, SharePoint, TVE, Salesforce, MS Outlook

Administration Assistant Punjab, India December 2013-May 2015

Mitter Fasteners:

Assist in filing duties

Answer phones calls and greet clients.

General Administrative duties.

Created Quarter reports in excel and visualize data for profit reports.

Help organize office activities.

Assist in delivery, handling of mail and Sorted and Delivered Mail to Correct Branches.

Maintained Schedule with Courier Daily

Assisted customers with any other inquiries

Provided timely and efficient customer service to staff and faculty.

Contact this candidate