We provide IT Staff Augmentation Services!

Etltester /onsite Qa Lead/uat Coordinator Resume

Pittsburgh, PA

SUMMARY:

  • Total work experience of over 11 years (7.6 years of onsite experience) in Verification & Validation in Web based applications in Java, Java API, ASP, VB.Net, Mainframes, AS400 and Client - Server technologies with Visual Basic across business domains of Banking, Insurance and Retail.
  • Experience in Functional area- WorkDay -HCM and Hands on WorkDay HCM Core Concepts
  • Implemented whole life cycle of testing Methodologies starting from planning, creating, executing, reporting and tracking the defects.
  • Experience in writing test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements and documented all phases of QA process.
  • Experienced in various SDLC methodologies - Waterfall, Agile, Scrum and Sprint.
  • Extensive experience in Web Based and GUI based client/server applications Application Testing / Automation Testing(SOAP-UI/SOAP-UI PRO) / System & Integration Testing / End-to-End Testing / Back-End Testing (SQL/TOAD)/User acceptance testing (UAT) & Test Data Management & Mobile Testing & API testing/ Work-Day-HCM testing/Performance-Testing(JMeter)
  • Experience in testing Standardandpoors.com and Web Services using SOAP UI tool.
  • Excellent experience in backend testing on Oracle and written SQL queries.
  • Expertise in database querying, data manipulation and population using SQL
  • Hands on experience in performing Functionality Testing, Integration Testing, System Testing, Regression Testing, Performance Testing, Data Migration Testing, Web Service Testing and UAT and Business-Flow testing.
  • Expertise in using Test Management Tools ALM, QC 10, Clear-Quest, Rational Team Concert, Rational Test Manager.
  • Ability to interact with Business users and Developers regarding Knowledge transfer, Testing Status, Defect & Change Tracking.
  • Updating the issues log with identified test problems on a daily basis, logging issues with a detailed description of the problem and a script number.
  • Responsible for the planning and coordination of contingencies when scheduling and maintaining current status of projects and assigned project deadlines.
  • Ability to perform under pressure and meeting product release deadlines.
  • Having good knowledge of Data warehousing concepts.
  • Worked as an Onsite coordinator as well as Test Lead PBS project Denmark for a period of 1.6 year. 1+ year of experience in Cardiff, UK for FIS Project.
  • Got Excellent Performance Award from L&T InfoTech and Appreciation Award from PBS (Payment Business Services - Denmark) Client.

WORK EXPERIENCE:

Confidential, Pittsburgh, PA

ETL Tester /Onsite QA Lead/UAT Coordinator

Responsibilities:

  • Analysis of requirements and application functionalities
  • Participating in technical discussions with customer for getting the business clarifications and requirements gaps and closely working with business team for getting the business clarifications
  • Conducting scrum meeting and calls
  • Creation of stories and tasks in version one as part of agile process
  • Involved in the preparation of test plan/test materials and integration test case preparation for downstream applications.
  • Involved in Functional Testing, Regression Testing, Sanity Testing, Database Testing/Back-end testing, Black-box testing, UI Testing, Compatibility testing of the ARP UI applications and API testing
  • Performed Database testing by executing SQL queries using TOAD tool and verifying the business rules for each application
  • Validate the records in Source and Target by using SQL
  • Experience in system Integration testing, Database API testing, Functional testing (Black box testing) Security, Recovery, Negative, Regression testing, and Cross Browser testing and User Acceptance Testing and performance testing using JMeter.
  • Performed extensive back end validations using SQL queries in TOAD to verify that the data has been processed correctly based on the business requirements
  • Experience with SQL and PL/SQL to query Oracle database to check/compare process inputs/outputs using complex joins and sub queries
  • Preparation of the KT docs/videos and project status report.
  • Conducting defect triage meetings
  • Conducting UAT kick-off meeting and sharing the status report with stake holders
Confidential, Pittsburgh, PA

QA Consultant

Responsibilities:

  • Involved in Functional and Integration testing which includes preparation of Test Conditions and testing functionality.
  • Responsible for doing functional/integration testing after the configuration done for all modules (Core-HR, Reporting, Compensation, Security).
  • Created the Supervisory Organizations, Locations, Time Profile.
  • Created the cost centre, region and hierarchies.
  • Maintained the Staffing Models: Job, Headcount, and Position Management.
  • Configured the Business Process e.g., Hire BP, Termination BP Etc.
  • Tested the Hiring Business process
  • Configured compensation plan, grade, and profile.
  • Configured Compensation eligibility rules and tested with positive and negative scenarios
  • Configured security groups (Role/User/Job/Manager) and assigning roles.
  • Involved in testing the migrated data(Employee Data - Used I load Templates and EIB)
  • Worked extensively in creating various custom reports (Advanced/Matrix/Trending) and created calculated fields(Arithmetic Calculations/Roundup Values/Single Instance/Multiple Instance/TureFalse)
Confidential, Pittsburgh, PA

ETL Tester

Responsibilities:

  • Analysis of requirements and application functionalities
  • Performed Application testing extensively using Positive and as well as negative scenarios of all the DDC UI screens.
  • Involved in Functional Testing, Regression Testing, Sanity Testing, Database Testing/Back-end testing, Black-box testing, UI Testing, Cross Browser testing and User Acceptance Testing.
  • Compatibility testing of the DDC UI applications
  • Performed Database testing by executing SQL queries using TOAD tool.
  • Prepared test data for Business rule verifications.
  • Involved in the preparation of UAT test cases and test data
  • Perform Data Validation between CMP tables and Platinum files(Hires/Changes/Term)
  • Preparation of understanding documents for the end users.
  • Performed ETL/Record count validation and data validations.
  • Web-Service testing of the Golden Source online application using SOAP-UI tool
  • Data Driven Testing and preparing Test Data for the Web-Service testing.
  • Logging defects and tracking them till closure in ALM.
  • Creating stories and tasks in Version-One for the in-scope stories of the agile-sprint.
  • Creating and updating test-plan for each sprint.
  • Co-ordinating with the offshore team and assigning the tasks
  • Preparing DDC project weekly status report
  • Conducting defect triage meeting and scrum meeting
Confidential

QA Analyst

Responsibilities:

  • Analysis of requirements and application functionalities
  • Manual execution of Functional Tests, Regression Testing of the SSP portal.
  • Performed system testing, Re-testing and Regression testing.
  • Performed Integration testing with CHIMES application - Combined Healthcare Information and Montana Eligible System
  • Created Test Cases, Test Scenarios, Test data in JAMA
  • Web-Service testing of the ACA online application using SOAP-UI tool - Affordable Care Act
  • Set up the test suits, test framework and automates the testing in SOAP UI.
  • Preparing Test Data for the Web-Service testing.
  • Defect tracking with JIRA.

Environment: Net, SQL, SOAP-UI-PRO, JIRA, JAMA, IE7.0, WindowsXP, Toad for Oracle

Hire Now