SUMMARY

• IT professional with 5 years of extensive working experience in ETL technologies, Data Warehousing and manual testing.
• Experience in all phases of Testing Lifecycle (SDLC and STLC) and defect life cycle with expertise in the Integration, Functional, Regression, Smoke, Load and System Testing.
• Designed Test Plans, Test Strategies, & Test Cases, and Summarized Test Coverage and Defect Reports.
• Experience in Dimensional Data Modeling using Star and Snowflake Schema
• Good experience in writing SQL/PLSQL to data validation in migration as part of backend testing and comparing data from Flat files to database for the feeds.
• Extensive experience in testing ETL jobs developed for data extraction, transformations and loading in a corporate wide ETL solutions.
• Extensive experience in adhering software development methodologies including both Agile (Scrum) and Waterfall models.

TECHNICAL SKILLS

Testing Tools: HP ALM, JIRA

Databases: SQL Server, Oracle, MySQL

Tools: TOAD, SQL Query Analyzer.

Methodologies: Agile, Waterfall methodologies

Internet Tools: HTML, XML.

Office Tools: MS Office Suite, MS Project

PROFESSIONAL EXPERIENCE

Confidential

ETL Quality Analyst

Responsibilities:

• Involved in full SDLC, detailed design, data design, creation of functional and technical documentation and testing.
• Involved in BA walkthroughs and ETL Specification Document.
• Worked with the Dev team in gathering information for some ambiguous requirements.
• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Preparation of test scenario’s and test cases based on Business Requirement Document.
• Wrote complex SQL scripts for individual tables by following the transformation rules in S2T documents, which includes writing identity rule and for all the other columns of the table.
• Used JOIN’s, Rank, Row Number, Lpad, Trim, and Replace, CASE functions based on the conditions mentioned in the S2T document.
• Regression testing of the extract files and tables.
• Analysis of the mismatched records and further proceeded with either raising a defect using ALM and check whether the ambiguity still exists or not.
• Follow up with existing defects and new defects in ALM.
• Worked with UAT defects, enhancement defects, production defects.
• Developed reports by using Application Life Cycle Management metrics for daily status reports.
• Status update on daily basis to the upper management by providing the daily metrics based on the defects opened, closed or retested and on the number of the test cases executed.
• Responsible for executing the System Test Cases and reporting defects Application Life Cycle Management
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings.

Environment: Talend Open Studio, Oracle, Toad, SharePoint, HP ALM, Windows.

Confidential

ETL Quality Analyst

Responsibilities:

• Analyzed the Business and User requirements and created test plan and test specifications.
• Defined the test criteria and project schedules, and base lined the Test Plan with the help of project meetings and walkthroughs.
• Worked with the automation and data integration team integrating the system and developing utilities in support of the new software. Involved in functional testing performed on various objects.
• Tested the ETL process and validated the data loaded in source tables by comparing it against source data and business logic. Tested Ran SQL queries and stored procedures for database testing for the validation of the data displayed.
• Developed Test Cases and automated Test scripts based on the functionality of individual screens and overall system flow. Performed Data Driven Test using the test Data from Data files, Excel files etc…
• Reported bugs after detecting them and kept track of them using the JIRA. Worked with Requirements, Test Lab and Defects module in QC. Loaded test cases from excel sheet into Test Lab. Generated various reports in QC to view the progress of testing.
• Responsible in creating and modifying the existing documentation and submitting them in perforce (Version control System).
• Handling Different Exceptions through report events to ensure that script runs smoothly without any obstacles.
• Maintained Test Matrix for latest test results information in excel
• Executed tests in Debug mode to make sure they run smoothly by inserting breakpoints, monitor variables and control the tests to identify and isolate defects.
• Performed Regression testing of the application when new objects are added to the application.

Environment: Windows 2000, HTML, XML, DB, QTP 8.2, Informatica PowerCenter 8.6, Java, JSP, JIRA

Confidential

Application Tester

Responsibilities:

• Understanding software requirement specification and identifying the required test scenarios
• Tested Loan application Module and decision module using Internet Explorer.
• Used Waterfall methodology.
• Exposure in Black Box Testing.
• Experience in executing test cases to test the application functionality against the requirements
• Defect reporting and tracking using Microsoft excel.

Environment: JSP, Servlet, Java Script, J2EE, Oracle 11g, SQL Developer, MS Excel, MS Project.