Qa Analyst/ Etl Tester Resume
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