We provide IT Staff Augmentation Services!

Qa Analyst/ Etl Tester Resume

0/5 (Submit Your Rating)

Hartford, CT

SUMMARY

  • Over 8 years of diverse experience in Information Technology with emphasis on Software Quality Assurance, Software testing on Client/Server and Web - based applications.
  • Good understanding of quality assurance testing methodology relative to the Software Development Lifecycle (SDLC) as well as STLC
  • Detail understanding of ICD 9/ANSI/HL7 to ICD 10/ANSI/HL7 coding standards in Medicare and Medicaid domains of the healthcare industry.
  • Extensive experience in reviewing and analyzing FRS (Functional requirement specifications and SRS, and writing detailed Test Plans, Test Cases, and Test Scripts.
  • Excellent working knowledge in design & implementation of all QA Test strategy plans for both Manual and Automation as demanded by the AUT.
  • Extensive Experience in Pre-Test Architectural overview, Load contribution analysis, Planning and Test Execution and Post test result analysis.
  • Performed various kinds of tests like Integration Testing, System Testing, Functional Testing, Stress and Performance Testing, Load Testing, Volume testing, User Acceptance Testing etc.
  • Exposure to End-to-End data validation for ETL & BI systems.
  • Strong hands-on skills in developing of test scripts for Extract-Transform-Load (ETL) Routines in the data warehousing environment.
  • Worked in various facets of Software Development Life Cycle. Well versed with all stages of SDLC.
  • Expertise in testing GUI applications and SQL Query Scripts and SQL commands for testing.
  • Exposure on HP QTP Using VB Script and Descriptive programming.
  • Experience in Business Analysis, Design, Structured & Object Oriented Programming, Development, Testing and Tracking Defects.
  • Experienced in Testing Methodologies & Validations and Verifications to ensure the Software Quality Control and meeting the demands set by Stake Holders.
  • Performed Regression, Stress/Load/Volume along with Black box and white box testing on Web, Client-Server Applications.
  • Additional expertise in interpretation of requirement models to identify test effort needs, data driven testing and performance testing on various platforms.
  • Dedicated, highly motivated professional proficient in object oriented analysis and design using Java and C++ and application servers such as Apache, Web Logic and Web Sphere and IIS.
  • Experienced on dealing Off - Shore projects and deliver Testing Deliverables on time for the end user.
  • High proficiency in Scheduling and Managing resources and activities in QA Teams.
  • Involved in Setup and maintenance of QA Test Lab hardware and software, Present and train team members on new tools obtained.

TECHNICAL SKILLS

Testing Tools: Win runner, QTP, Load runner, Test Director and Quality Center

Operating System: Windows 95/98/2000/NT/XP, MS DOS, UNIX, Sun Solaris

Browsers: IE4.0, 5.x, 6.x and Nets cape 4.07, 4.72, 4.73, 6.0

Languages: C, C++, Visual Basic, COBOL, SQL, and PL\SQL

Databases: Oracle, SQL Server, DB2, Sybase, MS Access

Scripting Languages: Java Script, VB Script, HTML, XML, and DHTML

Adv. Technologies: Applets, Beans, JDBC, ODBC, EJB, Servlet and Lotus Notes

GUI: Visual Basic, AWT, Swing

Web/App Servers: Apache, IIS, Web logic, Info Vista, Vista Mart, IPlanet and Web Sphere

Protocols: TCP/IP, FTP, SOAP, HTTP

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

QA Analyst/ ETL Tester

Responsibilities:

  • Reviewing Business Requirement Documents and the Technical Specification.
  • Set up a QA process and ensured it was effective project wide.
  • Documented test cases corresponding to business rules and other operating conditions.
  • Wrote tractability matrices based on use cases and business requirements documents (BRDs) using HP Quality Center/ALM as QA Status Report, QA Summary Reports, QA Test Logs.
  • Created Test input Data Requirements and prepared the test data for data driven testing.
  • Created complex SQL, triggers, store procedures and PL/SQL queries and UNIX scripts to perform data validation testing; also utilized ETL, EDI, OLAP, and flat files for data profiling and data validation testing.
  • Verify that data is transformed correctly according to various business requirements and rules.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Installed HP Tools, related Addins and the required patches.
  • Performed negative testing by entering improper data to make sure appropriate error messages are displayed.
  • Validated the Report GUI for Report testing and Functional testing of the reports by looking against the data displayed in data mart and reports.
  • Involved in detail testing of Fact Tables, Dim Tables and validated the load Data in the Tables and XML messages.
  • Generated connection between the tools for proper test management.
  • Understanding of Software and hardware compatibility issues with Mercury Tools and Troubleshooting them.
  • Addressing customer queries and solving the issues in the automation process.
  • Documented and sent reports according to the standards.
  • Implemented training documents for end users and involved in the training.
  • Created and executed Test scripts to verify complex system requirements.
  • Reported the failed test cases, tracked the defects and verified the fixes in multiple environments.
  • Work with development, users and support groups to understand the application architecture, use and current production issues to simulate the best possible real time scenarios for load and stress testing.
  • Defining the test scenarios and making sure that scripts are working according to planned scenario.
  • Attending meetings with other groups and explain performance objective, strategy and progress.
  • Interacted with Stakeholders during testing, isolated bottlenecks at different levels and suggested Tune-up methodology.
  • Used Quality center to log defects and generate defect reports and graphs.
  • Performed automated test using QTP Tool.
  • Performed various types of testing using Check Points (GUI, Bitmap, text check points) using QTP.
  • Handling duplicate objects and dynamic objects using index property and Regular expressions.
  • Actively participated in enhancement meetings focused at making the application more reliable.

Environment: QC 10.0/ALM 11.5, QTP 10.0, SQL Server 2012/2008R2, Microsoft Business Intelligence Development Studio, Microsoft Visual Studio 2012.

Confidential, Conshohocken, PA‎

Sr. QA Analyst

Responsibilities:

  • Reviewed and analyzed new user requirements, program design, coding, and Unit testing.
  • Understanding the application under test, writing test plan, defining test strategy, create the test matrix and guiding the test engineers in scripting.
  • High Level Test Plans were written by incorporating User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results.
  • Developed detailed Testing Methodologies, Test Matrices, Test cases and Test scripts,
  • Interacted with Stakeholders during testing, isolated bottlenecks at different levels and suggested Tune-up methodologies.
  • Attended meetings to outline and present performance testing strategies and objectives.
  • Created functional, regression, and data-driven test scripts, and created batch test scripts in QTP for ETL, SQL and Oracle database with TOAD.
  • Performed Functional/Regression testing and Performance/Stress/Load testing.
  • Performed Data driven testing and script enhancement.
  • Interacted with developers to resolve for the defects, which would affect income generating functionality in Production.
  • Used Team Foundation Server (TFS) to log defects and generate defect reports and graphs.
  • Actively participated in enhancement meetings focused at making the application more reliable.
  • Monitored Team Foundation Server (TFS) to close the bugs/cases as and when developers fixed the bugs.
  • Helped new team members understand the site functions.
  • Responsible for daily back up of the team’s working files.
  • Generated Test data for various types of testing to valid data, Invalid data, Partial data and bad data testing.
  • Production issues to simulate the best possible real time scenarios for System and Performance testing.
  • Conducted weekly walkthroughs on the application progress for meeting schedules and provided the QA status update periodically to the management.
  • Creating reports for higher management on performance test results. Developed various reports and metrics to measure and track testing effort.

Environment: Team Foundation Server(TFS), Java/EJB, Servlet/JSP, JDBC, XML, HTML, JavaScript, DHTML, Web Logic, Websphere, Oracle 8i, SQL, UNIX and LINUX

Confidential

QA Analyst

Responsibilities:

  • Extensively used Quality Center, for test planning, bug tracking and reporting.
  • Uploaded Business requirements, test scenarios, test cases and defects for MS Excel to Test Director.
  • Developed detailed Testing Methodologies, Test Matrices, Test cases and Test scripts.
  • Wrote VB scripts using QTP.
  • Master GUI Map is maintained in the central repository and changes are made to it for every version.
  • Written SQL scripts to validate the data in the database on the back end and Master Files.
  • Performed Functional/Regression testing and Unit testing, Integration testing, Black box, and User acceptance testing.
  • Developed scenarios for Regression/Functional testing, which covers more than 90% of the Critical scenarios for the application.
  • Generated Automation Scripts and TSL Test Scripts using Win Runner for Regression Testing and the additional scripts are generated for each version.
  • Used QTP extensively for Regression Testing.
  • Performed Security Testing for unauthorized access of the application with Positive and negative testing
  • Performed System testing and End to End testing.
  • Data driven testing is performed and the scripts are enhanced.
  • Interacted with developers to resolve for the saviour priority bug issues, which would affect income-generating functionality in Production.
  • Always met the deadline when required to do Regression testing and multi-browser testing.
  • Work with developers, business and Release managers to discuss ways to fix the defects.
  • Helped new team members understand the site functions.
  • In charged of daily back up of the team’s working files.

Environment: Quality Center, Java, Java scripts, Oracle, VB Script SQL, UNIX, Windows NT, HTML, XML, XSLT, and Internet Explorer.

Confidential

QA Tester/Analyst

Responsibilities:

  • Analyzed the business requirements and system specifications to understand the application.
  • Interacted with business analysts on application design and specifications.
  • Performed manual tests at various levels of the SDLC.
  • Responsible for performing functional testing of the application.
  • Defined the scope of the testing process, goal oriented scenarios and individual responsibilities of the team members. Estimated the possible test challenges based upon the business requirements and a proactive approach is followed in executing the test plan.
  • Responsible for writing SQL queries for performing backend testing of the application.
  • Developed Test Plan, Test case, Test Metrics and Test Reports using Mercury Quality Center.
  • Designed Test Cases using Functional Requirements Specification and Use Cases
  • Validated software functional specifications through testing to make sure the developers have coded according to functional specifications.
  • Generated Test Harness and Orthogonal Array Test case and Test plan documents.
  • Rigorously performed Regression Testing using Manual testing.
  • Performed Usability Testing of the application by conducting interviews, sessions and questionnaires with business users.
  • Mercury Quality Center was used to report the Defects.

Environment: Quality Center, DWH, C#.Net, ASP, Oracle 9i.

We'd love your feedback!