We provide IT Staff Augmentation Services!

Etl/tester Resume

Wilmington-dE

Summary

  • Over 6 years of diverse experience in Software Testing with emphasis in Quality Assurance and of testing large database driven applications.
  • Involved in developing the Test Plan and maintaining the Test Matrix.
  • Expertise in performing Manual, ETL and Backend Testing.
  • Experienced in ETL process for both before data validation and after data validation process.
  • Experienced in defect tracking using Quality Center (QC), ClearQuest and Test Directory.
  • Experience in highly complex projects with participation in the full Software Development Life Cycle (SDLC).
  • Experience in Unix shell scripts.
  • Experience in performing Backend testing and writing SQL queries from SQL Server, Oracle for Data Integrity and used TOAD to execute the queries
  • Can work independently, lead or work within a team in a time sensitive environment.
  • Willingness and ability to easily adapt to and learn any newer technology or software.
  • Experienced in requirements analysis, Test development & Execution and Defect Reporting & Tracking.
  • Involved extensively in manual testing, testing procedures which include System, Regression, Interface, Database and UAT Testing
  • Expertise in QA Methodologies like Agile and Water fall methodologies.
  • Well versed in ETL processes, performance based systems, and ETL process flow and standards and In-depth knowledge of Enterprise Data warehousing ETL Processes and Data warehousing requirements.
  • In-depth knowledge and hands on experience on Black box testing types like Alpha, Smoke, Functional, Integration, Regression, System and User Acceptance Testing.
  • Experience in Car Rentals, Banking and Salesforce CRM sectors.

Technical Skills

Testing Tools: Rational Test Studio, Quality Center, Clear Quest, ALM Test Director, QTP

Programming Languages:C, C++, HTML, UML and SQL.

OS: Windows NT, Windows 9x/ME/XP/2000, UNIX and Linux

Databases: Oracle 9i/10g/11g, My Sql, MS Access, SQL Server

SDLC: Waterfall, Agile methodology

Applications: MS Word, Excel, Rational Rose,Informatica

PROFESSIONAL EXPERIENCE:

Confidential Wilmington-DE

Role: ETL/Tester

Responsibilities:

  • Involved with preparation and execution of test cases, Functional, Regression and Integration Testing.
  • Involved in reviewing functional requirement documents and the technical specification.
  • Analyzed system requirements and wrote test cases, test scripts for testing the application.
  • Performed manual testing prior to automate testing on the application.
  • Implemented defect management processes to prevent and track the cause of defects and their correction.
  • Experience in using SQL for back-end and ETL testing and used SQL queries on Oracle tables populated by ETL process in order to view successful transactions of data and for validating data.
  • Understand complex ETL (Informatica) mapping logic to create end to end testing process. Involve in coordinating the White box and Black box testing for the data warehouse by checking ETLprocedures/mappings.
  • Interacted with developers to resolve technical issues and investigated software for faults.
  • Worked with Quality Center for defect tracking and defect management
  • Involved in reviewing and enhancing test cases for application functionality testing.
  • Using Quality Center to create the detailed Test Plan and Test Cases from the business requirements documents and meetings.
  • Worked with users as well as with Business Analysts to plan and implement the test Plan.
  • Generated defect reports/graphs using Quality Center for the developers and project managers.
  • Found, reported and also traced the status of bugs using QC.
  • Extensively worked on any requirement upgrade and/or change request while doing UAT.
  • Worked closely with development team to ensure the application performance and stability and also ensure the application completes the whole end-to-end process.
  • Participated in weekly status meeting with Development and Management Teams

Environment: UNIX, Flat files, Oracle10g/11g, Informatica, HP Quality Center, TOAD, SQL Server 2005/2008

Confidential Park Ridge, NJ

Quality Analyst

Responsibilities:

  • Involved in the business requirement meetings, design sessions, and in finalizing the requirements to meet expected business requirement.
  • Involved test plan creating test cases, test data, execution of test cases, logging defects into test management systems and provided daily test status reports to the project team and upper management.
  • Executed various types of testing like regression, cross-browser, smoke testing, sanity testing, UAT.
  • Tested mobile applications in GSM, CDMA, and tablet across different platforms.
  • Involved in Functional, Integration, Regression and End-to-End testing of the application against user requirements.
  • Tested web 2.0 Face book, Twitter and email API integration to Main site.
  • Responsible to Test all the applications and transport the data to the target Warehouse Oracle tables and use the HPQC ALM tool to report bugs and fix them in order.
  • Responsible for preparing Test strategy, Developing Test plan, Test cases, and Writing test Scripts by Decomposing business Requirements and Developing Test scenarios to support quality deliverables
  • Performed cross browser testing on IE 6,7,8,9 FF, Chrome, Safari and mobile browsers.
  • Involved in mobile a web application testing and training to new employees.
  • Extensive experience in working on various POS, member module, and user profiles etc.
  • Tested portal applications and also role based navigations, translations, single sign-on with other systems.
  • Performed lead responsibilities in setting test system, test data and in performing other system integrations and also involved in knowledge transfers sessions, business requirement meetings.
  • Involved in day to day meetings with business users, business analysts and development teams in JAD sessions.
  • Involved in User guide preparations and conducting business users training sessions.

Environment: Windows NT/2000, Java, Quality Center, Informatica, UNIX, Oracle10g, SQL

Confidential Philadelphia,PA

QualityAnalyst

Responsibilities:

  • Responsible for testing of Salesforce.com application for Global Account Managers and Strategic Account Salesreps.
  • Prepared Test plan and Test cases for different sales channels like Enterprise, Metro-E, RHC and SMB after going through the business requirements.
  • Involved in testing the end-end business process for ICB, OA and Contract Escalation approval process on ICB, OA and CE objects.
  • Tested the ETL process for both before data validation and after data validation process. Tested the message published by ETL tool and data loaded into various databases.
  • Written test cases based on ETL mapping document and input into HP Quality Center.
  • Conducted Security and record level access testing using Role Hierarchy, Organization Wide Defaults (OWD), Sharing rules and Manual Sharing.
  • Interfaced with the developers to resolve technical issues and investigated software bugs.
  • Involved in testing the work-order application In-Bound and Out-Bound services, using SOAP UI.
  • Performed the Back end testing to ensure data consistency on frontend by writing and executing SQL Queries using Data Loader and Salesforce Schema.
  • Monitored the testing process in regular interval for its timely completion.
  • Coordinated with developers on Defect Status on a regular basis.
  • Documented and tracked test scripts, test result, test analysis, and reported the defects using Quality Center.
  • Actively participated in project status meeting.

Environment: Salesforce.com, SQL, Data Loader, Web Services, SOAP UI, Windows XP, Mercury Quality Center, APEX, Visual Force, UNIX.

Confidential India

QualityAnalyst

Responsibilities:

  • Understanding the Business Requirements and Functional Specification of the Web Application.
  • Designing various scenarios based on functional specifications.
  • Performed application level testing for migration of 2 portals.
  • Created test data for various scenarios for different applications.
  • Preparing test cases and execution of test cases and analyzing the test results.
  • Verifying various links and content as per documentation provided.
  • Used Quality Center (QC) for Defect Management.
  • Taking ownership of user creation requirement and responsibilities as required.
  • Extensively worked on handling the application response for Positive and Negative sets of data using Data Driven Testing.
  • Participated in Executing Test Cases for Functional Testing and Prepared Bug report.
  • Performed System Testing, Functional Testing, Black Box testing, UAT (User Acceptance Testing) and Regression Testing.
  • Used Quality Center for preparing the test plans and manual test scripts.
  • Consolidated Test Results and Prepared Test Reports.
  • Participated in Project meetings, release meetings, and QA status meeting.

Environment: Windows NT/2000, .NET, Quality Center, UNIX, Oracle10g, SQL.

Confidentia India

QA Engineer

Responsibilities:

  • Understanding the Business Requirements and Functional Specifications of the web application.
  • Extensively worked on handling the application response for Positive and Negative sets of data using Data Driven Testing.
  • Involved in Executing Test Cases for Functional Testing and Prepared Bug report.
  • Performed System Testing, Functional Testing, Black Box testing, UAT (User Acceptance Testing) and Regression Testing.
  • Bugs were reported to Developers using Test Director and after rectification from Developers regression testing was performed.
  • Interacted with Technical team in providing clear solutions to requirements.
  • Consolidated Test Results and Prepared Test Reports.

Environment: Windows NT/2000/XP, Java Web Application, Test Directors.

Hire Now