Payal Kumari

1-404-***-****

acvvr6@r.postjobfree.com:acvvr6@r.postjobfree.com

Alpharetta,GA.

Sr. QA Analyst/Tester

8+ years of experience in all phases of Software development & QA testing that includes web-based,mobile and BI/data warehousing systems.

Strong experience in writing Test plan, and execution of unit, integration, performance & acceptance testing to support agile application development and system enhancement project.

Proficient in various test methodology such as GUI, Functional, Regression, System Performance, Integration, Database and data Integrity testing.

Sound experience in test estimation, planning, writing test cases,test matrix & defects tracking

Proficient in data design techniques, tools and standards –Data Profiling, Data Cleansing, setting data quality rules and test automation

Ability to do deep Data analysis & look into complex data issues and resolution, take care of data cleansing activities & perform data sanity and data integrity check

strong ability to perform query performance tuning and overall system performance optimization

Test data intensive BI reports (Business Object, Cognos 10, Tableau 9) and assist reporting team on data structure, data quality and query performance issues

Experience in Manual and Automated Testing of web-based, mobileand BI-data warehouse applications.

Sound experience in defect tracking, reporting, reviewing and analyzing the test results using Defect Tracking tool Quality Center

Sound database experience using TERADATA, Oracle10g/11g, SQL Server 2014, PL/SQL,UNIX

Strong Data analysis and data profiling skills including data model change management, reverse engineering,source to target mapping, database view & materialized view creation, Indexes creation & performance tuning

In-depth understanding of XML/XSD schema,Java Object Oriented Programming concepts, version control, release management and DB script creation & execution,

Proficient working in UNIX/Linux environment, well versed with advance Unix command, file handling,shell scripting and analyzing large data file on Unix server

Expertise in writing and executing test scripts using Selenium, SQL Scripts and UNIX Shell Script

Proficient in various test methodology such as GUI, Functional, Regression, System Performance, Integration, Validations, Compatibility, Database and End-to-End data movement testing.

Strong knowledge ofWeb Services based SOA Architecture, XML Web services, WSDL file,SOAPUIbased automated testing, look into performance and security aspect of web based application

Strong understanding of Logical/Physical, Relational and Dimensional data model and data modeling processes, ETL and data warehousing processes

Strong experience in XML, XSD, UML, Visio to understand complex data files and class diagrams, use case diagrams, user stories to understand & analyze business functionality and functional specs.

Highly organized and an enthusiastic team player dedicated to team success and customer satisfaction.

Strong analytical, troubleshooting, problem solving, Communication skill

Experienced in offshore-onsite project execution model.

Languages: Java, C++, PL/SQL, XML, XSD, Perl

RDBMS:Oracle 11g/10g/, TERADATA, SQL Server 2014

Scripting: JavaScript, XML,DHTML,UUIXShell Scripting

Operating Systems: Windows,UNIX, Linux, Solaris

Testing Tools : Selenium, HP QC, HP LoadRunner 12,Web Services, SOAP UI, JIRA, JUnit

BI/Data warehousing: Business Object, Cognos10,MS BI,Tableau9

Data modeling & Profiling: CA ERwin, ER/Studio, Data profiler-Trillium

MS Office: MS WORD, Excel, PowerPoint, MS Visio

Business Domain: Life science, Health care & Insurance, Finance, Auto, Telecom

Masters in Computer Science &Bioinformatics – BanasthaliVidyapith, India.

Bachelors of Science – Patna University,India.

Crawford & Company, Atlanta, GA (Oct 2012–Till Date) through Apex Systems Inc

Role: Sr. QA Test Engineer

Project Description:

Dmtri E79 Solution offers to the risk management community the ability to track both multi-coverage claims and enterprise-wide exposure to risk. This gives risk managers the ability to conduct unlimited analysis on the impact of risk exposure on the financial operations of their company. The analysis may be used to calculate risk on a historical, current, or future basis. Customers can perform any number of financial analytics to support their decision-making process

Responsibilities:

Participates in the review of the requirements and functional specification, lead development of test plan test strategy and test cases.

Executes test cases for functional/system/integration testing, and documents test results and communicates defects status against the test execution

Perform end to end testing of Web based application and ODS/Reporting System

Perform manual and automated testing to identify overall system quality –w.r.t system functionality, performance, security and scalability.

Actively participate in user acceptance testing & user interface reviews to ensure a great user experience

Prepare system test plan and test cases, execute test cases, defects reporting and tracking, ensure defects resolution& closure

Execute functional, system, performance, and regression tests

Define and track quality assurance metrics. Monitor & instruct team members on proper procedures & best practices ensure process compliance

Plan and design performance tests cases, executes test cases and scripts through analysis of design document and SQL scripts.

Perform deep data analysis to look into data structure, complex data issue impacting production system

Create views/mv, database object and write SQL queries for data validation and data analysis in source and target schema

Conduct web services testing through usage of SOAP UI, XML and WSDL. Validate the SOAP Web Services through SOAP request and response messages.

Support UNIX requests for various applications, updated Unix Job script as per the requirement, do extensive file handling to analyze data files on QA & Prd server

work with Unix servers to analyze data in Unix File using various Unix command, look into job failure, log file, re-running the batch job manually.

Coordinate with business analyst and business user on system functionality and application performance acceptance in varying test scenario

Perform end to end ETL testing to verify business & technical transformation rule, data movement, data quality rules

Perform GUI, Functional, Integration, Regression, Performance and Backend DB testing.

Perform Load testing and Performance testing to ensure the application is able to handle expected load without any performance issue.

Actively take part in project meetings to discuss the findings, bug fixes, build changes

Recommend correct usage of Indexes, partitioned columns, correct joins and data filter criteria.

Ensure that all system tests, functional and non-functional are successfully completed and documented and all problems are resolved

Perform defect logging and tracking in Quality Center till the defects are resolved and further validation is performed and closed.

Coordination with architect and development team on issues found during testing and defects resolution.

Create Requirement Traceability Matrix (RTM) document.

Lead defect meetings, communicate daily and weekly status on defects matrix, status, Issues, QA tasks and initiatives

Environment: Oracle11g, PL/SQL, UNIX, HP QC, HP Load Runner 12, SOAP UI, Java, XML.MS Visio, Fiddler, MS VSS

Apex Systemshttp://www.hcltech.com/(Jan 2012 to Oct 2012)

Client: Crawford & Company, Atlanta GA

Role: Sr. QA Engineer.

Project Description:

Dmtri“CheckWriting is corefinancial module. This module covers Bank Account, Pending Payment and Payment Check related data of the user. The Adjuster or Claimant can now enter or update exciting Bank Account Detail related to a Payment Check .It gives flexibility to the Claimant or Adjuster to track his claim starting from entering and modifying a new Pending Payment up to the approval and deposit of the check in the bank. The claimant or Adjuster can modify the data related to a specific Claim at any point depending upon the permissions they have. This functionality keeps step by step track of all Claim records which are under the process of approval and Payment. The Vendor also gets the flexibility of approving and passing the record to next label in the hierarchy on one single platform.

Responsibilities:

Created test plan/test strategy and test cases suit by referring requirement & design specification document

Executed test cases for functional/system/integration testing and documented test results and communicated defects status against the test execution

Ensure that approved changes are integrated into the existing test scripts and versioning is done.

Executed functional, application, performance, and regression tests

participate in review meetings for defect status and resolution of issues

Planned and executed performance and load test by utilizing HP LoadRunner

Worked closely with business & technical team in analyzing, debugging, and reporting application defects data issues and resolving system performance bottleneck, perform root cause analysis for major defects

Performed white box, black box, regression, backend testing, load and performance testing of the application.

Created Positive and negative Test Data in XML files for Claim products in support of UAT for Business Rules validation

Performed data validationtesting to verify data correctness and completeness

Work with technical analysts to identify unit testing coverage and ensure any gaps in functionality are documented and addressed.

Wrote technical product documentation for new features, known issues and best practice around

Attend weekly QA meeting to give an update on the progress of the project and report all the issues related to testing.

Environment: Oracle 11g, PL/SQL, JAVA, UNIX,HP QC, XML, SOAP,MS office, MS Visio.

Bioware Systems, India(March 2009 to July 2010)

Role: QA Analyst

Project Description:

Geneious Pro is revolutionary bioinformatics software application that is both ultra-powerful and easy to use. This is powerful server software package designed specifically for highly data intensive computing and for faster analysis of large volumes ofdat leading to more discoveries (designed specifically for Scientists, researchers and world leading universities).Worked on this enhancement project as Lead QA Analyst. My work was of multitasking nature and primarily involved in data analysis using different Linux commands along with Perl Programming, performed functional analysis interacting with domain experts, performed end-to-end functionality testing, data validation& UI testing to ensure greater user experience.

Responsibilities

Designed, developed and executed test plans and all the test cases aligned to system functionality

Coordinated with development team and Test Manager on the progress of test initiatives, testing efforts, Issues and testing completion timeline.

Performed end to end testing of software product according to functional specifications using Linux based environment, Oracle and PL /SQL

Performed GUI testing, functional testing, regression testing, integration and system testing and coordinated UAT.

Actively participated in user interface testing to ensure a great user experience.

Wrote technical product documentation for new features, usage approach & best practice around the product

Looked for innovative ways to automate and uncover any obscure defects in software product

Coordinated in preparing Testing and UAT environment, performed Load testing, Volume testing and scalability testing as part of system performance testing

Tested application load time, response time, application endurance on heavy load of concurrent users and its performance

Tested data model and database objects in db as per enterprise standard, guidelines and naming standards

Ensured correct indexes are created, Joins are applied on right columns and correct filter criteria is applied in PL/SQL code.

Provided fixes for critical bugs and assisted code moves to QA and production system

Participated in design discussion, coordination with development leads and lead analyst to clarify and resolve functionality and data related issues

Lead and support all quality initiatives that are implemented during each phase of the system development life cycle.

Ensured that all system tests are successfully completed and documented and all problems are resolved before release and code deployment

Environment: UNIX, Perl scripting, Oracle10g, PL/SQL, XML, HTML, HP QC, MS Office.

Delhi University, India (Aug 2008 to June2009)

Role: Data Analyst

Project Description:

Understanding the biology of bacteria relies on identification and analysis of essential genes, genes required for growth to a fertile adult. The main aim of this project was identification of Essential Proteins using Database of Essential Genes responsible for the viability of the fungus. Such proteins are the most suitable drug targets, with condition that they don't have a homologous protein in humans. The purpose was to develop a cost and time efficient strategy for finding the drug targets and providing new ventures to the pharmaceutical development in designing new and effective anti-fungal drug.

Responsibilities:

Involved in the system requirement analysis, design discussion, functional analysis of the system

Performed data analysis on huge volume of data collected from different sources and filtered the relevant data and further performed data mining using different Unix commands along with Perl Programming and SQL queries to determine patterns within the data with the goal of identifying relationships and predicting future trend and events.

Performed data modeling and pattern based analysis on research information

Prepared detailed Test Plans on final sets of data and solution

Developed test cases and performed unit test and system test

Environment: Java, MATLAB, Oracle 9i, PL/SQL, UNIX, UNIX Shell Scripting, HTML

National Institute of immunology, India (March 2008 to Aug 2008)

Role: Data Analyst

Project Description:

The main theme of the research project was to understand the structural principles that govern sequence to structure relationships in proteins and binding of various ligands to proteins. These structural principles has been used to develop novel knowledge based computational methods for prediction of substrate specificity of proteins and also for predicting structural folds for proteins in absence of detectable sequence homology.

Responsibilities:

Involved in data analysis, and data mining to recognize patterns and exceptions in research database collected from many sources

Pattern discovery and finding predictive information in a large database to accurately predict data behavior and data pattern

Data modeling to recognize significant facts, relationships, trends and data anomalies

Prepare and maintain data artifacts documents

Analysis and root cause findings of data inconsistencies, uneven data pattern

Environment: UNIX, SUN Solaris, Perl scripting, TERADATA, TERADATA SQL Assistant, PL/SQL

Hutchison Telecom (July 2007 – March 2008)

Role: QA Test Engineer

Project Description:

HPOS-DWH is the point of sale data warehouse system. The objective of the DWH system is to address MIS reporting requirements and data feed to the various downstream systems. DWH mainly stores data on subscriber, subscription plan, sales of product and services, channel management, customer information management, new connections, cancellation, and inventory management at different stages in the channel, bill statement and invoicing data

Responsibilities:

Developed and executed test plans and test cases, performed different types of testing - black box testing, white box testing, system, regression and load testing

Prepared system test plan and test cases, defined system test criteria to test data flow from

multiple source in staging area and loading into target system properly into related tables and data is consistent.

Responsible for stress testing of Load process to make sure that Load job don't break during heavy loads

Coordination with architect and development team on issues found during testing and defects resolution and closure

Closely involved in development and testing of logical and physical data model using data modeling tool ERWIN as per the system data requirement

Tested database objects as per enterprise standard, guidelines and naming standards

Tested MLOAD, FASTEXPORT and TPUMP script for loading data into Teradata.

Worked on complete SDLC from extraction, Transformation and Loading of data using Informatica Powecenter and Teradata load job utility in Linux OS environment

Provided testing status to project stakeholders; prepared project quality related processes and QA artifacts documents

worked on Unix servers to analyze data in Unix File using various Unix command, look into job failure, look into the log file, re-running the batch job manually.

Interacted with development team, DBA and business users in a support role to analyze data issues, finding root cause and data fixes.

Environment: .Net,TERADATA,Linux,Oracle10g,PL/SQL,Teradata Sqlassistamt,TOAD, Informatica 8.0, QTP, HP QC, Load Runner 8.1

JawaharLal Nehru University,India (Jan’ 2007 to July 2007)

Role: Research Analyst

Project Description:

Molecular Dynamics was a live on-going project of CSIR –INDIA.The purpose of this project was to study the dynamics of proteins both for local fluctuations to correlated motion of sections of the protein using Molecular dynamics method. Molecular dynamics (MD) is a computer simulation of physical movements of atoms and molecules. The atoms and molecules are allowed to interact for a period of time, giving a view of the motion of the atoms.

Responsibilities:

Involved in the system requirement, functional analysis and quality assurance activity

Involved in data modeling and data analysis and resolution of unexpected data trend issues

Correlation analysis of Wild and Mutant protein.

Prepared system test plan and prepared system test cases for this data intensive application

Performed through database testing and data validation

Deeply analyzed and ensured application data accuracy

Environment: UNIX, MatLab,C, Perl, Oracle9i, PL/SQL, MS Visio, MS Word, MS Excel

Contact this candidate