We provide IT Staff Augmentation Services!

Sr.test Analyst / Etl Tester Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Over Ten yearsof experience across Agile Methodologies, Waterfall Model, Kanban approach, SDLC Models and STLC as well.
  • Proficient in different phases of Testing like Black Box Testing, Functionality Testing, Automation Testing, Backend Testing, Unit Testing, System Testing, web Testing, Load Testing, Mobile Testing, Regression Testing andUser Acceptance Testing.
  • Automation experience with QTP and exposure to Selenium tool.
  • Expertise in preparing Test Strategy, Test plan documents with exit and entry criteria's.
  • Experience in Testing Methodologies, Designing Test Plans and Test Cases, Verifying and Validating various applications and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Good exposure in Banking, Credit Card Services, Financial Services, Health Domain, Insurance, Merchandising and Retail Services Domain.
  • Expertise in creating UAT Scenarios and Test Cases.
  • Excellent work experience in Quality Center, JIRA, QTP, ALM, Version one, IBM Rational Test Manager, Functional Tester, Clear Quest.
  • Excellent work experience with Mobile Testing with different mobile application platforms(Apple iOS, Android, Microsoft Windows Phone, Blackberry) Mobile Testing tools such as Zapfix and eggplant
  • Expertise in End - to-End, Functional, Integration, Backend and Regression, UAT Testing. Excellent problem solving skills and testing experience in complex Business systems
  • Involved in writing and enhancing script. Performed Bug and Defect reporting using reporting tools such as Quality center and locally developed tools. Involved in maintaining Test Matrix.
  • Experience in writing System test plans, defining test cases, developing and maintaining test scripts and documenting all phases of QA process.
  • Developed Informatica, Data Stage test environment for UAT testing and used all ETL.
  • Expertise in creating business scenarios by involving with Business team during requirement phases and providing guidelines to Testing team on Test Plan creation.
  • Experienced Quality Assurance professional with hands on experience in testing various enterprise applications and Leading onshore and offshore Testing team.
  • Expertise in Resource Planning, Estimation, Reporting Metrics, Defect Reports and execution summary reports.
  • Extensively used SQL for performing DWH testing and worked with complex SQL joins.
  • Providing strategic and tactical direction to the project team.
  • Leading the Project with offshore resources and closely monitored them to execute the project activities
  • Experience with Web Application, Mainframe testing. Expertise in developing business based functional test scenarios. Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools. Scheduling, assigning execution task based on priorities and coordinating with the team members.
  • Worked as Individual Team member possess Strong analytical and Problem solving skills by Involving in various stages of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Platforms: Windows XP, 7, 8, 8.1, 9x/NT,UNIX

Testing Tools: Test Director, Test Manager, Quality Center, JIRA, ALM, Version One, QTP, Exposure to Selenium, ETL

Language: Java, C, SQL, PL/SQL, XML

Databases: Oracle 11i, SQL Server, MS-Access, Sybase, DB2, Mainframe

Applications: MS-Word, MS-Excel, MS-Visio, MS-Power Point, MS-Access

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Test Analyst / ETL Tester

Environment: Windows, XP Agile Testing Approach,UAT Test Scripts, Test Strategy, Test plan preparation

Responsibilities:

  • Analyzing the requirement and understand the current system and followed Agile Testing Approach
  • Preparing Test Strategy Documents, Test plan and estimation.
  • Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
  • Interacted with the developers and other team members to ensure in capturing the current system scenarios in order to execute them to attain High Quality of software.
  • Prepared detailed Test Plan, Test scripts and test cases for testing new functionality and ensuring existing custom functionality is not disturbed.
  • Performed System Integration and Regression Testing for all releases.
  • Worked with Business team and helped them in executing all complex scenarios on UAT scripts and by leading onshore QA Team.
  • Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
  • Measured performance improvement by capturing pre and post upgrade from logs.
  • Executed all the test cases in the planned test cycles and logged the defects.
  • Coordinated requirement, Daily scrum calls to address all issues to ensure testing will be completed in given timelines.
  • Created Testing Execution Reports, Test metrics and share with project team.

Confidential

Sr.Test Analyst

Environment: Windows, XP Agile Testing Approach, Kanban Model, UAT Test Scripts

Responsibilities:

  • Leading the Functional Testing Team, providing Testing Strategy and Estimation the Project leads
  • Followed Agile Testing Methodology Approach
  • Gathering requirement by attending business requirement meeting and clarify all the questions and clarifications to the offshore team
  • Involved with business team and other portfolio team to resolve all the impediment for testing team.
  • Coordinate with offshore on each requirement clarifications and providing the plans based on the priority of the user stories assigned for the sprint.
  • Followed scrum methodology with offshore team and at onshore followed the Kanban model approach.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Monitoring and reviewing the deliverables from offshore
  • Involved in creating test scenarios along with scrum master and business users.
  • Defect reporting, monitoring and triage of the defects for the and followed the process in Version One.
  • Performed the Overall Testing/Development Status reporting to whole Project Team on weekly basis.
  • Attending Daily scrum call discussion with onshore and offshore. Responsible for the overall quality and timeliness of the testing deliverables.

Confidential, Deerfield, Illinois

Software Quality Analyst

Environment: Windows, XP Waterfall model Approach, UAT Test Scripts, Test Strategy, Test plan preparation

Responsibilities:

  • Prepared Testing Strategy, Test Plan documents and shared with the Project Leads.
  • Preparing Test Scenarios, Test cases and Test Data Preparations. Providing test plan walkthrough to project team
  • Gathering requirement by attending business requirement meeting and clarify all the questions and clarifications to the offshore team.
  • Monitoring and reviewing the execution tasks performed by offshore and shared with Project on daily basis.
  • Involved in creating business scenario creation for UAT users during UAT Execution.
  • Involved in functionality, regression testing, integration testing and system testing. Involved in creating and executing the automation test scripts using the tool QTP.
  • Defect reporting, monitoring and triage of the defects for the SIT & UAT testing.
  • Defect Monitoring and action upon further progress.
  • Providing Closure Report to Project on each releases.
  • Responsible for the overall quality and timeliness of the testing deliverables.

Confidential, Schaumburg IL.

Automation Testing Lead and onsite Co-ordinator

Environment: Windows, XP Watermodel Testing Approach, QTP,QC, Test Strategy, Test plan preparation

Responsibilities:

  • Leading the Automation Testing Team and providing Testing Estimates(L0, L1 and L2) to the Project leads
  • Prepared Automation plan and Automation Strategy Documents.
  • Identify the Automation Framework to ensure each application is capable of handing the approach.
  • Coordinate multiple projects and meet deadlines
  • Working with offshore in preparing test scripts. Providing test scripts walkthrough to project team
  • Automation script review on all the deliverables
  • Monitoring and reviewing the execution tasks performed by offshore
  • Performed BACKUP Test lead to my test manager whenever applicable for follow-up with all applications.
  • Performed the Overall Testing Status reporting to whole Project Team on weekly basis.
  • Working on developing tools to reduce the Manual effort of functional teams
  • Providing Test plan inputs to test manager
  • Ensuring Quality Reviews and Metrics Collections
  • Conducting periodic Quality Assurance Activities.
  • Responsible for the overall quality and timeliness of the testing deliverables.

Confidential, Schaumburg IL

Sr. Software Quality Analyst(Mobile Testing)

Environment: Windows, XP, Androis, ios, blackberry Waterfall model Approach,, Zapfix, QTP

Responsibilities:

  • Performed a Sr. Tester of Mobile Application and leading the Testing Team(Onshore/Offshore)
  • Providing Testing Estimates(L0, L1 and L2) to the Project leads based on the timeline and quantity of Testing required for releases.
  • Performed Testing Support to the team on weekly Project implementation.
  • All survey applications testing are done with real device(Apple, Androi IOS, Blackberry, windows phone).
  • Co-ordinated with offshore team on Mobile Testing using the Testing tools such as Zapfix and Eggplant tool. Also provided inputs to Automation team to perform the Automated scripts for all Mobile devices.
  • Responsible for creation the Test Strategy and Test Plan Documents.
  • Coordinate multiple projects and meet deadlines
  • Preparing and reviewing test scripts which created by the Team.
  • Providing the walkthrough to the Business team on all Testscenarios to ensure all Testingscenarios are covered from Development perspective.
  • Monitoring complete Test Cycles phases tasks performed by offshore
  • Triage call with developer and Project team.
  • Performed the Overall Testing Status reporting to whole Project Team on weekly basis.
  • Working on developing tools to reduce the Manual effort of functional teams
  • Providing Test Strategy inputs to test manager and also ensured Quality Reviews and Metrics Collections
  • Ensured and followed Quality Assurance process within QA Testing Team.
  • Responsible for the overall quality and timeliness of the testing deliverables.

Confidential

Quality Analyst and Onsite Co-Ordinator

Environment: Windows, XP Agile Testing Approach,UAT Test Scripts, Test Strategy, Test plan preparation

Responsibilities:

  • Providing Testing Estimates to the Project lead
  • Preparing Test Plan document for across all portfolios
  • Attending requirements gathering for the releases TPR, understanding requirements and getting clarification for any ambiguous requirement
  • Coordinating with the all application’s Business team(Statements, Statements Reprints(STARS), Documents Composition facility (DCF)/ Letters, Embossing, PEGA, RPL Statements, CBNA, Macys Statements & Letters and CMI REL for requirement clarifications.
  • Working with all business team & Host Team to clarify on Print Matrix for respective applications.
  • Conditioning the accounts for each portfolio which are in scope of our IBS Systems.
  • Working with Transaction Services Team for volume and Merline test scenarios.
  • Validating all the files in MMS server which are moved to the respective DD splits and scenarios without any issues.
  • Responsible for validating the files which MMS received. Validating the Hard copy of statements for all Portfolios. Other than IBS system remaining statements are validating with Sample copies of hard copies.
  • Defining the test scenarios and test data for the SIT & UAT testing
  • Providing the walkthrough for all our scripts for each application.
  • Defect reporting, monitoring and triage of the defects for the SIT & UAT testing.
  • Defect Monitoring and action upon further progress.
  • Performed the Overall Testing Status reporting to whole Project Team on weekly basis.

Confidential

Test Analyst

Responsibilities:

  • Analyzing the Conversion Table Object models.
  • Parsing the Flat File and preparing the Test Input Data.
  • Test Execution and Report Generation.
  • Result Analysis and Assigning Defects and following up along
  • Executed Functional and Regression Test Cases
  • Identified and logged defects and followed them with Dev team until the closure
  • Created Test Scenarios, Test Cases after going through the functional requirements
  • Maintained Traceability Matrix and Test Summary Report
  • Worked as defect coordinator. Participation in triage meeting on weekly basis
  • Coordinated with the Development Teams and Business Users on Defect Analysis
  • Attended Business reviews and Functional walkthrough

Confidential, Jersey City NJ

UAT Test Analyst

Responsibilities:

  • Responsible for downstream testing of CI application.
  • Responsible for defining the test cycles and test scheduling
  • Co-ordination of Test execution with the Business user
  • Responsible for defining the test scenarios and test data for the UAT testing
  • Defect reporting, monitoring and triage of the defects for the UAT testing.
  • Performed 3-way data reconciliation between OCW - iFeed - CRS.
  • Project Customization and adding users to the tool in QC.
  • Creating Groups to the projects in QC.
  • Uploading the defects into QC for various projects.
  • Logging defects in Quality centre and follow up on that.
  • Defect Monitoring and action upon further progress.

Confidential

Test Lead

Responsibilities:

  • Project Customization and adding users to the tool in QC.
  • Gathering requirements and identifying the possible scenarios for Functional Testing Activities
  • Preparing the Test Plan and defining the Strategy.
  • Analyze use case and prepare Test Scenarios for Functional Testing
  • Framing the Test Cases and ensuring Requirement coverage through Traceability Matrix.
  • Identifying the Test data and reviewing Test Bed Pull sheets for execution.
  • Participating in Walk through session to Clients on Test scenarios.
  • Executing Functional tests and monitoring the Test coverage of the application during Test Execution.
  • Analyzing the Test Results and Assigning Defects and following up.
  • Updating and maintaining the list of defects for my team in the Defect tracker.
  • Creating reports and metrics.
  • Mentoring New Joiners and grooming them to meet project requirements
  • Ensuring Quality Reviews and Metrics Collections

We'd love your feedback!