Data Engineer
Resume:
Shraddha Barve
***************@*****.***
Professional Summary
7+ years of experience as a QA Test Engineer using Manual & Automation Testing. Strong knowledge of Software Development Life Cycle (SDLC) as well as Software Testing Life Cycle (STLC) and the Role of QA in different testing methodologies.
Experience in Software Development Life Cycle (SDLC) methodologies and techniques with expertise in Requirements Gathering, Analysis, Testing, Development, and post-production support of various applications.
Solid Back End Testing experience by writing and executing SQL Queries
Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
Extensive working knowledge in various SDLC methodologies like Waterfall and Agile Scrum
Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
Expertise in designing the test scenarios and scripting the test cases to test the application and Test Data Management Plan.
Strong working experience on HP-ALM
Experience in designing scripts in Keyword driven framework and Data Driven Framework
Experienced with technologies like ETL, Data, WSDL, SOAP, SOAP UI, XML, XPath and Web Services
Creation of test data and Automation of test cases for system and analyzing bug tracking reports
Experience in validating mobile web and native apps on Android and iPhone devices
Expert in preparing Traceability Matrix to map requirement coverage with test cases.
Expertise Shell Scripting experience on UNIX, Linux and Windows environment
Automated and scheduled the jobs using UNIX Shell Scripting
Extensively tested ETL methodology for supporting data extraction, transformations and loading processing
Experience in performance testing using LoadRunner
Good working experience in Oracle, Unix Shell Scripting
Extensively strong on databases including Oracle, MS SQL Server
Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
Extensively worked on UFT for automation
Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing
Good Communication, interpersonal, and Teamwork skills
Having H4-EAD as work authorization
Technical Skills:
Testing Tools: Quick Test Pro (QTP), LoadRunner, Quality Center
Databases: Oracle, MS SQL Server
Defect Tracking: Quality Center & JIRA,Relly
Requirement Tracking: JIRA, HP-ALM
Tools: TOAD, SSMS, Win SQL & XML Spy
Operating Systems: Windows, UNIX, Linux
Tools: MS-Office suite (Word, Excel, Power Point & Outlook)
IIT Workforce, GA, USA Mar 2020 – Till Date
QA Test Engineer
Client: North America MedTech Group
NAMG is all about providing software solutions to the hospital systems. The software applications they build are to benefit the patients, hospital management, and healthcare providers (doctors) alike, in various aspects such as accessing the patient records, tracking the appointments, maintaining doctors’ information, etc.
Environment: MySQL Database, JIRA, Version 1, Web Services, SOAP, SOAP UI, JIRA, Agile, Microsoft Excel
Responsibilities:
Reviewed the requirements documents in detail and multiple discussion with team to prepare and finalize Requirement Traceability Matrix document.
Created test scenario for Patient, Doctor, Admin & Insurance module.
Worked on detail test cases as per requirement and test scenario to cover functionality testing.
Uploaded test cases to Version-1 tool for test management.
Worked on creation of test data for functional requirement testing.
Tested Patient website, Doctor Website & Admin Website and created defects as needed.
Raise and Track a Defect by JIRA, and co-ordinate with Development and BA to fix the Defect following Defect Life Cycle and make sure they are addressed in time.
Update the status of Test cases in Version-1 to reflect the progress of System Testing to all the other applications.
Identify and communicate critical finding during System Testing so that they can be taken care during the deployment phase.
Worked on database testing to validate the data as entered through website.
Written complex queries to test & validate the data in multiple tables as per functional need.
Performed database testing with SQL queries to verify data integrity.
Performed regression testing of multiple modules.
Performed Schema/Structure validation for Data types, Data length, Date format and key’s to Target tables.
Performed XML Request & Response Data validation from different interfaces via SOAP UI web services API Tool.
Monitoring the logs and Performance of the application
Correct testing defects and support all testing, including but not limited to: Development Integration Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing.
Escalate the Issues that can impact and need attention of the Management.
Prepare Test Support and Test Case Results at the end of the Testing Phase to keep tracks of all the raised bugs, severity in tabular as well as Graphical form.
Writing and executing scripts for data validation and testing of the sessions & data integrity
WorldTech Lab, FL Aug 2018– Feb 2020
Business & Quality Analyst
Scope of the project was to design a cloud computing – based Healthcare Software as a Service (SaaS) Platform (HSP) for delivering health information services with low cost, high clinical value, and high usability.
Environment: Waterfall-Scrum Hybrid, MS Office (MS Word, MS Excel, MS PowerPoint), JIRA 6.1, MS Visio and UI framework interface, Oracle Database, Web Service
Responsibilities:
Developed business requirements and related business rules to understand the customer needs.
Evaluated approaches for integration of cloud applications into other enterprise systems, applications to design Healthcare Software as a Service Platform.
Defined and documented business and functional requirements for client’s business processes, applications and data through JAD, interviews, workshops, and/or existing systems documentation or procedures.
Provided expertise and input in helping the team make right decisions on implementing business requests.
Worked closely with key business stakeholders, analysts and senior management to understand their business strategy and questions, identify research needs, help design experiments and make recommendations based on results.
Align stakeholders and analysts on a prioritized view of how to use analytics to support business initiatives and strategy.
Conformed to standard software development life cycle (SDLC) methodologies to ensure projects and maintenance activities are documented and deployed on time and on budget.
Performed GAP analysis by carefully studying the As-Is system (Legacy Electronic Health Records also known as Hospital Information Systems) and To-Be system (cloud based Healthcare Software as a Service) for more business opportunities.
Created test plan and executed test scripts as per requirement
Raised defects and tracked till closer as needed
Supported UAT with business users
Lead and participated in business discussions, providing an informed point of view and advocating for change when needed
Sysco Corporation, TX Jan 2018– June 2018
Quality Analyst
Environment: Oracle, Autosys jobs, Flat Files, API & ETL Testing, Windows, HP ALM, Teradata SQL
Responsibilities:
Created Test plan for ETL Testing as per data mapping documents
Executed test plans and scripts to validate the functionality
Supported test data creation, analysis of test results etc.
Provide real time support (analysis and troubleshooting) for System Testing Efforts (SAT) for other impacted applications.
Make recommendations for improvement of applications to programmers and ETL developers.
Raise and Track a Defect by HP QC/ALM, and co-ordinate with Development and BA to fix the Defect following Defect Life Cycle and make sure they are addressed in time.
Communicated critical finding during System Testing on timely manner to support smooth software delivery.
Participate in Scheduled UAT (User Acceptance Testing) to ensure system/application is built as per Client/User expectations and User is satisfied with the implementations.
Debugging and Scheduling the ETL Jobs and workflows, and monitoring error /bad file logs on ETL tool.
Performed database testing with SQL queries to verify data integrity using QTP/UFT.
Created complex SQL queries to test the Data validation and verification from Source to Target tables.
Prepare Test Support and Test Case Results at the end of the Testing Phase to keep tracks of all the raised bugs, severity in tabular as well as Graphical form.
Prepare System Release Notes doc.
Non functional testing to support performance requirement for jobs
Gammastack June 2014 – Feb 2017
Program Quality Analyst
Environment: Unix, Oracle, Autosys jobs, Flat Files, API & ETL Testing, Windows, HP ALM, Web Services, SOAP, SOAP UI,QTP/UFT, Agile
Responsibilities:
Support ad hoc requests from testing team, which can involve creation of ETL test data, analysis of test results etc.
Provide real time support (analysis and troubleshooting) for System Testing Efforts (SAT) for other impacted applications.
Raise and Track a Defect by HP QC/ALM, and co-ordinate with Development and BA to fix the Defect following Defect Life Cycle and make sure they are addressed in time.
Update the status of Test cases in QC to reflect the progress of Integration and System Testing to all the other applications.
Identify and communicate critical finding during System Testing so that they can be taken care during the deployment phase.
Participate in Scheduled IPWT (Inter Pair Wise Testing) to ensure that ETL/UI application is working fine in integrated environment.
Participate in Scheduled UAT (User Acceptance Testing) to ensure system/application is built as per Client/User expectations and User is satisfied with the implementations.
Debugging and Scheduling the ETL Jobs and workflows, and monitoring error /bad file logs on ETL tool.
Performed database testing with SQL queries to verify data integrity using QTP/UFT.
Created complex SQL queries to test the Data validation and verification from Source to Target tables
Performed Schema/Structure validation for Data types, Data length, Date format and key’s from Source to Target tables.
Automated designing and developing the test scripts using Query Surge Tool to validate the data from Source to Target for Records Count, Data filtering.
Prepare Test Support and Test Case Results at the end of the Testing Phase to keep tracks of all the raised bugs, severity in tabular as well as Graphical form.
Prepare System Release Notes doc.
Document the learning of the Project and identify Progressive and Improvement areas of an application.
Am Webtech Oct 2011 – Apr 2014
Test Analyst
Environment: Oracle 11g, SQL, PL/SQL, SOAP, SOAP UI, UNIX, QTP/UFT, ALM/HP Quality Center, TOAD, SQL Navigator, Mainframes, MicroStrategy, MS Excel, Agile, XML, ETL
Responsibilities:
CRM process involves the activities and strategies that companies use to manage their interaction with current and potential customers
Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
Involved in Test Execution phase.
Responsible for GUI Testing and Functional Testing (System Integration Testing) using Black box technique like BVA, ECP, and Decision tables etc.
Execution of Manual Test Cases and running automation scripts to do a regression testing.
Involved in testing based on Use case specifications.
Database testing, Mainframe system to check the customer and data validations.
Clear look on updating concepts and finding defect, sending it with suggestion
Conducted functional testing by providing valid/invalid inputs to ensure complete coverage for functionality.
Participation in Defect call and in call with BA for clarification on functionalities.
Involved in Project Meetings and interacting with other team member in order to resolve the problems.
Participate in cross knowledge transition with other team member to get an insight for End to End functionality.
Performed database testing with SQL queries to verify data integrity
Prepared reusable function in QTP/UFT to use across the automation scripts.
Developed and Performed execution of Test Scripts manually to verify the expected results.
Used Quality Center to state requirements, test plan, test cases, and update test run status for each iteration and to report the defects.
Used TOAD & SQL Navigator GUI tools for Querying Database.
Worked on Informatica tool for Regression Testing.
Involved in testing the XML files and checked whether data is parsed and loaded to staging table
Tested the data and data integrity among various sources and targets.
Contact this candidate