We provide IT Staff Augmentation Services!

Quality Analyst Lead Resume

Irving, TX

SUMMARY:

  • QA Lead with full system development and test lifecycle experience, including designing, developing and implementing test plans, test cases and test processes to ensure best quality product
  • Qualifications include 8 years of ETL testing and software testing in Banking and Retail domains.
  • Backed by strong credentials including Masters degree in computer science, Bachelors in computer science degree, test management and defect logging and monitoring tools; and cross - platform skills in Windows and Unix.
  • Expertised in different types of functional testing: black box testing, system testing, integration testing, regression testing, end to end testing (E2E), web based testing, windows based testing, GUI based testing, database (backend) testing (oracle)
  • Extensive knowledge of software development (SDLC) and testing life cycle(STLC) including test strategy preparation, test plan document, test case creation, test execution and bug tracking
  • Worked in various QA methodologies (V model, waterfall model, Agile methodology )
  • Hands on experience in various test and project management tools: JIRA, Confluence, Quality Center 9.2 / 11,TestLink, Bugzilla, SharePoint, BMC Remedy, MS-Visio, Microsoft Project Plan.
  • Working experience of running SQL queries to validate database backend and reports testing using different tools like TOAD, IBM Data studio, QMF and sql developer client)
  • Worked on various warehouse applications Data stage, Informatica, Master Data Management (MDM) and Enterprise Data warehouse (EDW) and Business objects.
  • Worked on various oracle retail applications including oracle product information management(PIM), oracle retail merchandising System (RMS), oracle retail price management (RPM), oracle retail sales audit (ReSA)
  • Good knowledge of UNIX commands, batch processing, monitoring and event and error log verification
  • Extensive experience in Data validation and verification in all ETL Stages (Source, Staging and Target environments).
  • Familiar in Testing Web Services and XML Data.
  • Experience in Performance Tuning of SQL and Stored Procedures.
  • Exceptional leadership, interpersonal and coordination skills. Good team player
  • Skilled in onsite-offshore coordination and conflict management. Working experience with big size teams (25+ members)
  • Interaction with the design, development teams to keep myself abreast with the changes in design, development and release cycles.
  • Highly motivated and adaptive with an ability to grasp things quickly

TECHNICAL SKILLS:

Platform: Universe, UNIX (AIX 5.3) (putty), Oracle.

Hardware: Oracle Exadata

Applications: CMOS (Catalog Management System), Oracle Product Information Management, Oracle Retail Merchandising System (RMS), Oracle Retail Price Management (RPM), Oracle Retail Sales Audit, Enterprise (ReSA), Data Warehouse, SAP BI Launchpad, XML manager(for XML verification)

QA Tools used: JIRA, Confluence

Database: Oracle 11g and Vertica (Sql Developer)

Browser: IE,Mozilla and Chrome.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Quality Analyst Lead

Responsibilities:

  • Requirement document understanding to gather the requirements of the project
  • Knowledge transfer to offshore and their query resolution on time
  • Test strategy and management plan creation and project plan creation
  • Involved in resource management and effort / cost estimations before and during project timelines
  • Involved in timeline discussion with client and other stakeholders
  • Application overview document creation (if needed)
  • Interaction with the business, design and development teams on daily basis for query resolution and other information gathering
  • Organize sessions with business/ design / development teams as per the need of the project
  • Participate in business document creation (Business process flows)
  • Review of test cases created by test engineers, test cases execution (system and end to end testing)
  • Integration test flow creation using MS Visio software
  • Test data creation
  • Troubleshooting and environmental issue resolution
  • Test execution, defect reporting and defect retesting
  • System testing, integration testing & end to end testing
  • Work with message queue team and help investigating the issues in message queue
  • Smoke testing and regression testing once any new build is deployed
  • Defect logging in JIRA tool and conducting defect triage meetings with developers and other stakeholders
  • Responsible for creating test case summary report, weekly and daily status reports, bug reports
  • Participate in test closure activities
  • Active participation in UAT organized by business users
  • Document management in Confluence

Confidential, Columbus, OH

Sr. ETL Quality Analyst (Team Lead)

Responsibilities:

  • Analyzed the Business Requirements and Business Rules and worked with Business Analysts and Business Users for preparing Test Plans.
  • Reviewed the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
  • Participated in business requirement walk through, design walk through.
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for System/Integration testing, User acceptance testing, Functional, Regression Testing and Backend (Database) Testing.
  • Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
  • Worked closely with Project Managers, Business Analysts, Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements.
  • Worked in coordination with developers and analysts to develop test plan, maintain requirements traceability matrix, compile test summary data and provide work estimation for test preparation and execution.
  • Worked in an agile environment and attended the Project status meetings and discussed on project related issues, risks and testing roadblocks with the team.
  • Responsible for creating general and detailed test approaches, Test Methodologies, and executing test cases and test plans.
  • Involved in Unit Testing, System Testing, Integration Testing, and User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
  • Performed the tests in both the INT, QA and contingency/backup environments.
  • Prioritized the test cases based on the projected metrics and project deadlines.
  • Prepared Test Scenarios by creating mockup data based on the different test cases.
  • Tested for negative data to check that the job fails on any critical error.
  • Analyzed the data and applied relevant transformations and verified that the source data types are correct.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Verified fixes and closed bugs during regression test cycle.
  • Attended Bi-weekly defect review and defect status meetings.
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Monitored the session logs/log files in Data stage.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Created data-driven test scripts using Verification points and synchronization points along with appropriate test data, parameters and data structures.
  • Executed the test cases using web services and validated the responses from the web services.
  • Executed test cases from Quality Center to validate the functionality of the application and created tickets in Quality Center for the defects in a timely manner.
  • Performed Black-box testing, White-box testing, and System Testing, Data Integrity Testing, Sanity, Regression and end-end testing.
  • Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Clearly communicated and documented test results and defect resolutions during all phases of testing.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Worked extensively with Database Procedures, Functions, Joins and Triggers using PL/SQL to apply business rules.
  • Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects Involved in data warehouse testing by checking ETL procedures/mappings.
  • Written complex SQL queries for validating the data against different kinds of reports.
  • Tested the reports and maintenance of daily, monthly and yearly.
  • Reviewed Business Requirement Document (BRD), Functional Specification Document (FSD) and Design Document Specifications (DDS).

Confidential, Philadelphia, PA

ETL Tester

Responsibilities:

  • Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
  • Extracted data from various sources and to targets like Flat files, Oracle, Teradata
  • Written several of SQL statements to validate the data against different target systems including Oracle and Teradata.
  • Transformed and loaded the data into target database (Teradata) using Informatica Power Center.
  • Worked on SQL tools like TOAD, Rapid SQL to run SQL queries to validate the data.
  • Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
  • Involved in FTP process to transfer the files from one server to other.
  • Performed quality control analysis and validates results of conversion programs. Used extensive SQL query.
  • Evaluated actual data load results. Involved with high volume testing
  • Implemented SDLC, QA methodologies and concepts in the Project
  • Completely involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
  • Extensively used Mercury Quality Center (TEST DIRECTOR) and Created Test Cases in the TEST PLAN according to the specifications.
  • Used TEST LAB to run the Test cases.
  • Reported Defects and prioritized outstanding defects using Test Director / Quality Center.
  • Created the test data & Coordinating with Developers/Leads in resolving bugs.
  • Clearly communicated and documented test results and defect resolutions during all phases of testing.
  • Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Created Daily, Monthly, and Quarterly Schedules using Maestro Scheduling Tool.
  • Created Maestro Jobs to execute UNIX Shell scripts, SQL Scripts, Informatica Workflows etc.
  • Created dependencies on Jobs, Job Streams and monitored the Maestro Flow for Daily, Weekly and Monthly jobs.
  • Executed Maestro Jobs using Composer and Conman Commands

Environment: Informatica 8.6, Oracle 8i/9i/10G, Teradata V2R5/V2R6 Teradata SQL Assistant, Flat files, PL/SQL, TOAD 8.0, SQL, UNIX, Cognos, Maestro 8.0 (Tivoli Work Scheduler), Charm, Remedy, Test Director/Quality Center, SUN SOLARIS

Confidential, GA

QA Tester

Responsibilities:

  • Analyzed product specifications and scoping activities associated with the project.
  • Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
  • Collaborated with QA staff on using documentation standards in the development and review of Test Plan and test cases.
  • Used QTP tool for GUI testing, automation of routine batch processes, pre-positioning of test data Prepared Test Strategy document, System Test Plan, Performance Test Plan, Acceptance Test Plan, Traceability matrix and Test Summary Reports
  • Extensively worked with backend activities by writing complex queries for testing Sales Reports, Top Selling Products, and Profit Reports.
  • Performed functional, System Integration, User Acceptance, load, performance, stress and regression testing of the product.
  • Performed the Back-End integration testing to ensure data consistency on Oracle Database.
  • Created batch scripts to automate the execution of the recorded scripts
  • Performed Load and Performance Testing to identify and report performance bottlenecks.
  • Created Load test data in Load testing environment by using Load Runner.
  • Stress testing was done using Load Runner to verify and validate the system and software function properly and without error under different stress conditions.
  • Created Test lab reports and defect reports on a daily basis.
  • Responsible for documenting and resolving testing issues and ensuring software is working while producing a high quality final product out of the test phase to be release
  • Work with the QA and Project Managers to set and evaluate milestone criteria to ensure released products are on schedule with high quality.

Environment: .NET, ASP, C#, HTML, CSS, Microsoft IIS, Windows, VSS, PL/SQL, Ms Office, Oracle, WSDL, windows XP, Unix, Mac OS v10.4, VSS, SQL, Ms Office, IE6, Mozilla Firefox 2.0, Safari 2 and Toad.

Hire Now