We provide IT Staff Augmentation Services!

Sr. Quality Analyst/ Etl Tester Resume

4.00/5 (Submit Your Rating)

Bloomington, IL

SUMMARY

  • 9 years of IT experience in Software Quality Assurance and involved in testing on various levels of Quality Assurance for Client/Server, Web based, and Mainframes Environments of Insurance, Tele - communication, Retail, e-Comerce & Travel Agencies Software application needs.
  • Extensive experience in co-ordination for Offshore Team.
  • Proficient in the complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Business Analysis.
  • Extensive experience in Verification, Validation, Electronic Data Interchange (EDI) and Integration Testing.
  • Analyzed requirements, design documents, functional specifications, use cases and data experiences in preparing and executing the Test Plans, Test Scenarios, Test Cases and Test Procedures and Defect Management.
  • Developed Test plans, Test cases and test scripts manually and using automation tools like Quick Test Professional, Test Link and Quality Center.
  • Extensive experience in Web-Service Testing.
  • Extensive work experience and expertise in Black Box Testing, Main Frame Testing, User Interface (UI) Testing, Integration Testing, EDI testing, System Testing, Backend Testing, User Acceptance Testing (UAT) and Regression Testing.
  • Extensive experience in Content Management System (CMS).
  • Extensive experience in PERFECTO, SOA Testing, PeopleSoft and Mobile Application Testing.
  • Experience in Test Automation middleware environment (J2EE applications, Web services), Front end environment (Web and client / server applications), backend environment (database and non-GUI applications.
  • Experience in creating Test Data, Analyzing Defects in TRAC, JIRA and interacting with development team to resolve issues.
  • Extensive experience in P&C (Property and Casualties).
  • Extensive experience in Infotainment projects for navigation system, Bluetooth system and application search.
  • Extensive experience in agile environment, with daily scrum meetings; stand up meetings, burn-down charts,, presentations and review.
  • Sound knowledge in games.
  • Ability to dig into technical problems and write clear and detailed Defect Reports in different defect tracking tools like JIRA, TRAC, ALM QC.
  • Extensive experience in HIPPA, and IEEE (Standard For Software and System Documentation); and ISO 2000.
  • Excellent conceptual and working knowledge on testing in Oracle, SQL Server, Sybase environments.
  • Experience in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL, Forms, Reports in Oracle.
  • Extensive experience in B2B and B2C (business to business and Business to Customer).
  • Extensive experience in Application Programming Interface (API).
  • Proficient working knowledge in Waterfall Model, Spiral Model, and Agile Scrum development.
  • Working as a QA Analysts in Implementing the Lean Process improvement methods to improve quality, eliminate waste, reduce time and reduce total cost in the Development process.
  • Executing various types of SQL queries using different types of Query tools like TOAD, SQL Programmer.
  • Involved in all phases software development life cycle in terms of analysis, Design, coding, Testing and Implementation in Mainframes Environment.
  • Extensive Documentation Skills for use in Standardization of Testing and Programming Procedures and Guidelines.
  • Involved and Validated all the documents and the testing procedures with HIPPA program.
  • Extensive experience in Sales Force application and testing its integration.
  • Strong analytical, interpersonal skills, committed, result oriented, hard working with a quest Zeal to learn new knowledge and communication skills.
  • Ability to work independently and in a team under deadline pressure.

TECHNICAL SKILLS

Technologies: FACETS, Java/ J2EE, .NET, C++, Sales Force, COBOL

Operating System: Windows 2000, XP, Vista, Unix/ Linux

Automation Tools: PERFECTO, Test Link, ALM 10.0, W Runner 8.0, QTP 9.2, SOAP UI, ALM (QC)11.5, Quality Center10.0, PeopleSoft

Bug Tracking Tools: TRAC, JIRA, HP QC10.0, Mantis, Bug Track, QNXT

Database: Oracle, SQL Server 2008, Sybase

Database Query tool: TOAD, DB Artisan, SQL Developer

Office Products: MS-Office 2010, MS-Office 2007, MS-Office 2003

Configuration Tools: VSS 2005, PVCS

Scripting Language: VB Script

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Sr. Quality Analyst/ ETL Tester

Responsibilities:

  • Involvement in Early Test Coverage for each of the Strategic Connections to ensure each Connection and challenges is executing test cases.
  • Involved in QA Management, QA Testing, and Web Analysis.
  • Involved in testing an application for “P&C” Claims.
  • Performed Agile testing using scrum practices, to keep the customer involved.
  • Tested all the functionalities for QNXT (P&C) for claims Life and Health.
  • Involved in Agile Scrum planning and reached the certain goal.
  • Conducted all the testing activities on different line of business on TRIZETTO QNXT.
  • Served as a single point of contact for the project test team to work with the Strategic Connections.
  • Worked closely with the aligned TAE to understand the test environment requirements captured for the project at a high level.
  • Involved in Mainframe Testing using Selenium automation tool.
  • Job operated within a very agile environment, with daily scrum meetings; stand up meetings, burn-down charts,, presentations and review.
  • Facilitated the daily scrum meetings, planning, review and retrospective.
  • Involved in participation and verifying the project testing scope, and objectives through internal project management methodologist.
  • Analyzed and Tested Web Based User Interface application using Java, SQL, HTML and UNIX.
  • Assisted in Main Frame Testing, EDI Testing, System, Performance and Implementation Test Environment set up coordination and scheduling by working closely with the test lead and aligned TAE.
  • Involved in testing and validating all the documents and resources provided by FACTES.
  • Participate in Testing documentation reviews and walk-throughs of test environment deliverables such as the environment topology.
  • Execute all the web service test case in SOAP UI and REST API model tool.
  • Involved in the Test Design coverage across the various functionalities, levels and types of testing (Integration, System & ATDD, Non-functional, UAT ).
  • Involved in Unit Testing J2EE.
  • Involved in Front-end Testing and Backend Testing of the applications.
  • Involved in Main Frame testing of an Report a Loss application which includes System Testing, Regression Testing, Functional Testing, Main Frame Performance Testing, Integration Testing.
  • Involved in HIPPA training provide for Life Claim and Health Claim system.
  • Maintain all the business and testing documents according to ICP and ISO Standard of Confidential .
  • Design test plan and document of understanding for the Main Frame testing.
  • Performed System Integration Testing to ensure the integrity with database.
  • Performed the Functional Verification Test, EDI Testing, Batch Testing, Regression, User Interface (UI) and User Acceptance Test as per the requirement in various environments.
  • Validating all the CRM data are fetch from Sales Force are displayed in Report a Loss Application.
  • Involve in Mobile Application Testing in different devices (I-pad, Samsung Galaxy, I-phone, HTC, etc.)
  • Create Test Plan and Test Case for Mobile Application and Mainframe Testing.
  • Involved in testing different points of integration in Sales Force.
  • Execute and create Mobile Test Charters in Test Link.
  • Involve in static review of BCD session, QA Set, Use Case, Business Scenarios, Functional Requirement, Technical Requirements, and Non- Functional Requirements.
  • Conducts various types of testing like Business Function Test, Test Design, Test Development, and Defect Tracking were done using Test Director.
  • Involved in Quality Audit and Exploratory Testing.
  • Responsible for all Builds, Build Validation Testing, Regression, Verification and Validation Test.
  • Responsible for entire QA Life Cycle, which includes Requirement Analysis, Designing, Developing and Execution of the entire QA process and documentation of Test Plans, Test Cases and Test Procedures.
  • Involved in all phases of Report a Loss application development life cycle in terms of analysis, Design, coding, Testing and Implementation in Mainframes Environment.
  • Prepared the estimates for the test effort and negotiating with the Project teams. Preparing the work plans based on the Project time lines and implementing them.
  • Created functional, integration and regression Test Cases based on use cases, Business Requirements, Functional Requirements Documents and Design Requirements Document in Test Link.
  • Co-ordinate with RBC Team (Offshore Team) and have an interaction with them regarding the flow of Report a Claim.
  • Detected the defects and assigning them to the developers as per their Severity and impact on application by providing the proper description in the TRAC.
  • Conduct the Test Script review meetings with business analyst and development team to explain the test scenario covered in the test scripts for Mainframe.
  • Designed Test Cases based on data mapping document for development team analyzing the source and targets.
  • Involved in writing of Positive and Negative Test cases in Test link.
  • Worked in Agile methodologies.

Environment: Test Link, TRAC, Selenium, Perfecto, REST, QNXT, Agile, Sales Force, Java, XML, Oracle9i-10g, SQL,PL/SQL, Internet Explorer, Sun Solaris 2.7, Windows NT, MS Office, Unix/Linux.

Confidential, Arkansas

System Test Engineer

Responsibilities:

  • Worked with different Interface systems supporting our application and performed End-to-End integration testing
  • Developed Test Cases In Test Director.
  • Extensively worked on handling the application response for Positive and Negative sets of data using Data Driven Testing.
  • Used Database Checkpoint to verify whether our application is getting the same data from the database.
  • Responsible to create and maintain Shared Object Repository.
  • Responsible for weekly status meetings showing progress and future testing efforts
  • End-to-end testing.
  • Participate in all testing related activities such as technical walkthroughs and lifecycle reviews
  • Conducted Functional, Integration and Regression testing.
  • Performed Positive and Negative testing on the application
  • Creating test plans, test cases and test procedures in accordance to project level guidelines and corporate methodologies.
  • Involved in different stages of application deployment testing.
  • Verified Settlement file.
  • Worked closely with Development team to discuss the design and testing aspects of the applications to design the Test plans
  • Designed test cases. Executed test under various business processes.
  • Involved in implementing QA methodology and Test Matrices
  • Performed System Testing, Functional Testing, Black Box testing, UAT (User Acceptance Testing) and Regression Testing.
  • Logged and Traced defects using QC
  • Interacting with developers to resolve technical issues
  • Verified Recon file
  • Submitted Orders By different MOP using Credit Card, Check, GL, Accounts.

Environment: IIS 4.0, IE 5.0, Windows 2000/XP, Web sphere 6.0 (GOS and BAS), Web sphere 5.1, Test Director7.6, Java ATG Frame work, Windows XP,UNIX, HTML, XML (DAS) database - Oracle.

Confidential, Boston, MA

ETL Tester

Responsibilities:

  • Led a team of 4 DW testers and managed 2 modules independently.
  • Written Test Cases for ETL to compare Source and Target database systems and reviewed IBM DataStage mappings and test cases before delivering to Client
  • Performed extensive testing of Business Objects reports using back end testing approach. Used SQL queries on the database to validate report outputs against functional requirement specification document.
  • Extensively used IBM DataStage to load data from Flat Files to Oracle, Oracle to flat files and Oracle to Oracle.
  • Executing and monitoring jobs through Autosys.
  • Writing shell scripts for data file transfers, data extraction from file based on selection criteria, error logging and post testing clean up processes.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using IBM DataStage and provide technical support and hands-on mentoring in the use of IBM DataStage for testing.
  • Worked with business analysts and SMEs to understand data and functional requirements.
  • Reused sub-procedures and functions, which reduce the coding.
  • Extensively used Recovery Scenarios while doing the regression testing
  • Performed IST (Integrated System Testing) regression GUI testing on different operating system and browsers.
  • Responsible for Defining Testing methodology, created Test Plans and Test cases based on functional requirements.
  • Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
  • Performed testing of ETL data load process and Purge/archive process to ensure the code meets business requirements and transformation rules are working as specified in the requirements.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Prepared test plans/test schedules with inputs from Project manager and development team

Environment: HP-Quality Center, IBM Infosphere DataStage 8.0, Oracle, DB2, SQL, UNIX, Autosys.

Confidential

Test Engineer

Responsibilities:

  • Requirement study, Creation of test cases, Test case execution and defect reporting through Test director.
  • Worked on application, which includes Warehouse management, Procument planning, Web application, which includes e-commerce, related testing.
  • Web testing on the online application. Also has been part of batch testing.
  • Involved in direct client calls and reports directly to the client leads.
  • Production smoke test on web application.

Environment: Mercury Test Director

Confidential

Test Engineer

Responsibilities:

  • Testing on the Clients Software using Automated testing using tools
  • Mercury Win runner as the Frame work for the Data driven testing
  • Mercury Test Director as the Test Repository
  • Creating test scenarios
  • Test cases & Test Scripts
  • Execution of test cases
  • Defect prevention (internal)
  • Defect logging for the application for the client.

Environment: Mercury Test Director, Win runner 8.0

We'd love your feedback!