SUMMARY:

• IT professional with over 7+ years of experience as a ETL Tester & Software Quality Analyst with experience in Healthcare, Banking and Retail domain
• Proficient in performing ETL, BI, backend manual testing.
• Adept in writing SQL scripts required for testing various ETL and backend processes
• Worked with Initial and Incremental load testing within ETL Testing.
• Worked on UNIX platform heavily
• Worked in all phases of STLC and can prepare all kinds of documents and reports
• Thorough Knowledge in Web Services testing using SOAP UI
• Experience in working Agile Scrum environment
• Experience in understanding the business & technology of the client system AND providing them with quality deliverables
• Profound knowledge of Agile/ Waterfall Software Development Life Cycle and Software Testing Life Cycle
• Experience in analyzing Business Requirement Documents, Functional Requirement Documents and Technical Specification Documents
• Creation of Test Plans, Test Cases and Test Scripts based on Requirements and Specifications
• Expertise in QA project scoping, estimation, Defect tracking and reporting skills
• Worked in manual testing with an edge in end to end manual testing
• Familiar in using different defect tracking tools such as JIRA & HP Quality Center /ALM
• Experience in validating source data coming from various database using SQL queries
• Experienced in Black Box, Integration, Regression, Functional and Front End testing
• Experience in Testing applications on UNIX environment
• Strong problem solving, troubleshooting and efficient to handle multiple tasks easily
• Excellent Communication, Analytical and Interpersonal skills

WORK EXPERIENCE:

Sr. ETL Tester

Confidential - Las Vegas, NV

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Executed Test Cases using positive and negative data in Quality Center's Test Lab and reported results and defects using Quality Center's Defects tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and source data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using HP Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.

Environment: HP ALM, Informatica Power Center 9.5,MS Excel, Oracle 11g, SQL, PL/SQL, Teradata utilities, TOAD, UNIX, Windows

ETL Tester

Confidential - Henderson, NV

Responsibilities:

• Developed Test Plan and Test Cases based on Functional Requirements/ Low Level Design documents.
• Involved in Data Warehouse testing while sourcing data from multiple sources to SDAR.
• Involved in ETL & Report testing, executed SQL queries to validate data in target database.
• Performed End User Data Validation on Cognos as a Reporting Tool.
• Detected Defects, Communicated to developers using Bug Reporting Tool and Tracking Defects using Quality Center.
• Extensively used Quality Center for test planning, bug tracking and reporting.
• Uploaded test scenarios, test cases and defects to Quality Center and SharePoint.
• Extensively developed SQL scripts on Oracle for validating test cases.
• Validated the archived jobs using DVO (data validation tool)
• Implemented Data Validation Option (DVO) for understanding on how to run tests, and evaluated the test results.
• Performed QA Testing in distributed UNIX/ Windows Environment, Oracle databases as back end and performed end-to- end testing.
• Involved in complete QA Life Cycle.
• Participated in Project Manager/ Tech Leads walkthroughs and defect report meetings periodically.

Environment: HP ALM, Oracle 11g, Informatica 9.5, DVO,MS Office, Unix, Cognos 8.4, Toad.

ETL/ SQL Tester

Confidential - Atlanta, GA

Responsibilities:

• Created functional test cases, test conditions, test data and performed integration, system, regression, positive, negative, E2E testing.
• Escalated testing issues, interacted with business users/analysts, developers, external teams to resolve the defects/issues.
• Tested all the ETL process developed to load the data into the data marts.
• Tested the various reports like Dashboards, Summary and Drill through reports developed in business objects
• Execute SQL test scripts and record actual result.
• Interacted with Project team and users to get information about the application and decide various tests that can be performed for the specific application.
• Preparing and Reporting Daily/Weekly Status Reports.
• Extensively involved in Regression, smoke and Sanity testing.
• Tested various data feeds based on the data flow diagrams from deposits, loan to General ledger.
• Written complex SQL queries to perform data validations.
• Maintained and contributed the entire progress reporting exercise.
• Took part in daily scrum and weekly progress calls for the move.

Environment: Informatica 9, Agile - Scrum, Oracle 11g, MS SQL2008, MS Office, HP ALM

Quality Analyst

Confidential - Deerfield, IL

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Develop and execute User Acceptance Test Plans
• Assist in the maintenance of technical and non-technical SDLC documentation
• Assist in the creation of test strategy.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Executed Test cases in different phases of testing like Smoke, Functional, Integration, GUI and System testing
• Involved in meetings with Automation team for Development of Automation Scripts in QTP
• Logged defects using Quality Center
• Involved in testing XML scripts for Sales Summary
• Worked in backend Testing using Mainframes commands for verifying logs and validating transaction details
• Verified whether the front-end sales were correctly stored in the back-end database by using SQL queries
• Attended Status update meeting, review meeting and technical discussions.

Quality Analyst

Confidential - Sunnyvale, CA

Responsibilities:

• Implemented Page Objects, Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium.
• Created & Maintained Automation Selenium Automation Scripts for the Scrum Stories.
• Worked on Appium framework for mobile testing.
• Scheduled Shell scripts in UNIX scheduler for data reconciliation.
• Responsible in implementation of the presentation layer for the application using HTML5, CSS3, JAVASCRIPT.
• Implemented backend testing by retrieving PL/SQL squeries.
• Execution of automated Test Scripts through Maven. Used Maven for building the WebDriver project.
• Tested compatibility of application for dynamic and static content under various cross browsers using HTML ids and XPATH in Selenium.
• Integrated with Continuous Integration tools Jenkins for running test on regular basis automatically.
• Also responsible for converting automation scripts to new framework using Selenium WebDriver, Java and TestNG/Junit.
• Created AngularJS Custom Directives to make the code more simple and understandable.
• Experience in using Jenkins as a Continuous Integration server to configure with Git Hub and Maven.
• Performed Regression Testing at various phases of development life cycle for impacted existing functionality.
• Involved in testing Web services (SOAP and REST) and XML with tool called SOAP UI, for the local WSDL / with URL and created Test cases, run them, do load testing, security testing.
• Worked in Agile - Behavior Driven Development (BDD) model.
• Worked on Agile (SCRUM) Methodology and used JIRA for defect tracking.

Environment: Java, Gherkin, Cucumber, Angular JS, Selenium, Maven 3.1.1, Eclipse, Git, JIRA, Protractor, Soap UI, Jenkins, TestNG, Junit, Agile (SCRUM).