Resume

Sign in

ETL Testing, SQL, UNIX, Data Analysis

Location:
Mississauga, ON, Canada
Posted:
January 15, 2020

Contact this candidate

Resume:

PAYAL AGRAWAL

Quality Oriented Testing Professional

Ph: +1-437-***-****

Email: adba9a@r.postjobfree.com

LinkedIn: linkedin.com/in/payal-p-agrawal

Career Summary

Over 3 years of experience as Software Testing Professional in Information Technology and Services Industry.

Delivered multiple projects and produced quality products for clients.

Communicate with clients to understand their requirements and prepare test plan accordingly.

Expertise in planning, designing, reviewing and executing SIT Test cases and performed UAT with clients.

Analyze complex and high volume of data to perform validations and mappings.

Execute test cases and document results for various types of testing like smoke, system integration, functional and regression testing.

Developed shell script to automate ETL testing process to reduce manual effort and time during test execution.

Knowledge in front end activities like Ordering, Billing in Telecommunication domain.

Performed Udmey trainings and have knowledge in Selenium testing.

Passionate about learning and exploring new environments and concepts.

Technical Skills

Testing Framework

ETL testing on Citrix –Unix(Ab Initio back end testing), Ab-initio Control Center

Databases Technologies

Teradata, SQL

o

Operating Systems

Windows 7/10.

Test Management tool

HP-ALM (QC), JIRA

Programming Language

Basic Java Programming and Selenium WebDriver

Document Management Tool

MS Office (Excel, Word and PowerPoint)

Communication Tool

MS Outlook

Education

Bachelor’s of Technology in Computer Science, Banasthali University, India Jul 2012- May 2016

Professional Achievements

Received appreciation award for execution of complex areas, deliver projects independently through ETL process and involve in customer/client relationship management.

Received recognition points for learning and delivering projects in new Ab-initio Tool Control Center in short time lines.

Professional Experience Summary

Accenture Solutions Pvt. Ltd Jul 2016-Oct 2019

Test Engineering Analyst Dec 2017-Oct 2019

Performed Data Warehouse testing using ETL Methodology in Business Intelligence team in Telecommunication domain.

Designed, planned and execute ETL Test plans and scripts/scenarios as per design level documents like High Level design, Low level design documents and Mapping sheets.

Responsible to prepare and represent our test plans, test cases and end result with Design and Business (clients) for delivery approval.

Extract data from various source format like flat files (Siebel CRM data), CSV files etc, apply different kind of transformation and load the target data in Teradata.

Ensure the quality of testing by Defect identification and communicate to developers using Quality Centre (HP-ALM).

Execute schedules on Ab-initio Server for Extraction and Transformation.

Implement business logics and mappings to validate loaded target data in Teradata.

Operate HP Quality Center: Test Center, Test Lab, defect management for Defect Analyzing and Reporting.

Execute and delivered projects on new tool Ab Initio Control Centre in very short timelines.

Programmed ETL environment cleanup shell scripts to reduce the manual time efforts during ETL execution.

Experienced to work on Ad Hoc requests and incidents and share the results in very short timelines.

Test Engineering Associate Jul 2016-Nov 2017

Enabled Environment Support Team to create, modify and share test data with System Integration Team.

Collaborate with third parties to generate and process test data.

Shared over 10,000 test data within a month.

Support Defect and Change Management team to collaborate with test team and third parties to analyzed and resolve the defects.

Shaped and enhanced knowledge to learn and parallel work with BI Team.

Academic Achievements

Received Student Pilot License scholarship (2012) from DGCA for studying SPL course and completed 5 hours of flying.

Academic Experience Summary

Department of Information Technology & Communication(DOIT, Jaipur) Jul 2015-Dec 2015

Student Trainee

Support developers in unit testing.

Helped in UI testing, defect tracking, reproducing and reporting.



Contact this candidate