SUMMARY

• 7+ years of Total IT experience as Data warehouse Tester/Analyst
• Knowledge on Teradata Viewpoint, transferring the data from one region to another region, monitoring the jobs
• Strong knowledge on Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Extensive experience in reviewing Business Requirement documents, Software Requirement documents and preparing Test Cases, Test Script and Execution.
• Working Knowledge on Hadoop Job Tracker, Bedrock, HDFS and Sqoop
• Experience in writing Hive queries, checking data in HDFS
• Experience in exporting data from hadoop to Teradata using Sqoop
• Knowledge of tracking Hadoop jobs through Job Tracker, Bedrock
• Knowledge on Hcatalog, Cloudera, Horton works and MaPR distributions
• Knowledge on Pig, Cloudera Impala and HBase
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in ETL Testing, Reporting Capabilities Testing, GUI application testing, Database testing and Front-end testing.
• Strong Knowledge on HP Quality Centre
• Experience with QA Methodologies including Agile(Scrum) methodology and Waterfall
• Experience in writing Complex queries and testing
• Knowledge on DataStage and Hadoop
• Providing Daily, weekly status updates to Supervisor and Top management
• Extensively worked with Teradata 13, 12 and BTEQ.
• Experience in troubleshooting and improving performance
• Strong knowledge in UNIX
• Sound knowledge of Teradata Architecture and hands on in writing Teradata SQL’s, Macro’s and making use of Teradata utilities like, Fast Load, Fast Export, Multi Load, TPT and TPUMP and Teradata session monitor console
• Experienced in working with Teradata ETL tools like Fast Load, Multi Load, TPT, Tpump and Fast Export. Also worked extensively on Teradata Query Submitting and processing tools like BTEQ and Teradata SQL Assistant (queryman).
• Extensively worked on backend testing and well versed with SQL, PL/SQL queries to run the data integrity tests.
• Involved in End to End VZBDW application testing
• Solid understanding of Testing Methodologies, Writing test cases, Acceptance Test Plan/ Report, Integration Test Plan/Report, Unit Test Plan/Report.
• Ability to work in a team as well as independently. Cope well in a high intensity work environment with excellent interaction/communication skills.

TECHNICAL SKILLS

Testing Tools: Quick Test Professional, Quality Center, Test Director

Bug Reporting Tools: Rational Clear Quest, Remedy

Operating Systems: Windows 7/XP, Vista, DOS, UNIX, LINUX, Mac

Query Tool: SQL Assistant, TOAD, SQL Navigator and SQL Plus

Internet Technologies: VB Script, Java script, HTML, .NET

Database: Teradata, Oracle, SQL Server, MS Access and DB2

ETL Tools: Data Stage, Informatica

Big Data Skills: Hadoop

Languages: C, PL*SQL, Java, XML, MS VB

Office Tools: Microsoft Office Suite, Visio

PROFESSIONAL EXPERIENCE

Confidential, Ashburn VA

Data Warehouse Tester

Responsibilities:

• Worked on ETL Testing, Reporting Capabilities Testing, GUI application testing, Database testing and Front-end testing.
• Involved in loading the files through Hadoop in SIT environment and verify whether the load was successful and also responsible for checking the failures in load and find the root cause.
• Involved in writing Hive queries and tracking the jobs in Job Tracker & Bedrock
• Involved in checking data in HDFS to verify the data loaded as expected
• Tested Sqoop export process to make sure data from HDFS properly copied to Teradata
• Involved in setting and testing Unix environments for sox and non-sox regions.
• Participating in Requirements walk through, reviewing with different teams for requirements testability, scalability, preparing test scenarios, reviewing the test scenarios with BAs/Program team members/Business users and add the finalized details in respective tools.
• Maintaining and monitoring the Unix environment by enabling the crons.
• Worked on transferring data from one region to another region using Teradata Data mover.
• Worked on loading different types of files using Teradata utilizes like TPT, Mload, Fload and through Data Stage
• Strong knowledge in troubleshooting the issues related to Unix, Teradata and Data Stage
• Experience in writing complex SQL scripts.
• Analyzed business and functional requirements to derive test plans, test cases, procedures, and expected results for testing UNIX/Teradata based data warehouse applications.
• Interacting with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Involved in reviewing Business Requirement documents, Software Requirement documents and preparing Test Cases, Test Script and Execution.

Environment: Teradata 13, UNIX, Hadoop, Informatica, QTP, HP Quality Center, Datastage7.5SQL assistant, Hive, HDFC, Hadoop Job Tracker, Sqoop, Bedrock

Confidential, Ashburn VA

Data Warehouse Tester

Responsibilities:

• Involved in the design meetings
• Generated test plans, test cases and test steps for manual testing.
• Involved in different phases of Software Development Life Cycle (SDLC).
• Involved in preparation of Test Plan document and Test Cases
• Created Data Driven Tests to validate the same scenario with different sets of test data
• Worked closely with the User Acceptance Test Coordinator, Project Manager and Business System Analysts to understand business processes and develop concrete User Acceptance Test (UAT) cases
• Extensively used test management tools like Quality Center, and QTP to carry out test case documentation, execution, and defect logging
• Responsible for creating traceability matrix to ensure all requirements are covered by test cases
• Worked on XML Shredding which will parse the file and load, using Teradata XML services and testing the result
• Worked on MDM Product mapping by implementing the FINTRAN approach
• Developed automated scripts using QTP for performing Regression testing.
• Modified the test cases and re-ran them for the purpose of Regression testing.
• Undergone through Regression, Assembly and Functional testing.
• Used Quality Center as Bug tracking tool.
• Identified the billing indicators and send to MDM for product assignment
• Developed BTeq’s and Stored Procedures in Teradata to implement ETL logic.
• Implemented business logic using BTeq scripts.
• Documented test results and SQL outputs and provided daily execution status to Team Lead
• Review target to source mapping documents and other design, requirement documents and identify design defects
• Performed regression and smoke tests when new functionality is added or during defects retesting
• Followed Agile(Scrum) Methodology implemented in project plan
• Involved in the FRR coding and Unit Testing
• Involved in End to End Testing
• Coordinate onsite, offshore teams in designing, developing and reviewing test cases and test scripts

Environment: Teradata 12, UNIX, Quality Center, SQL assistant, XML data files, Unix Shell Scripting

Confidential, Washington DC

Sr. Test Engineer

Responsibilities:

• Extensive Used Mercury Service Test Tool to test the Web Services (WSDL’s) and SOA on our Service Layer and also Soap UI to test the Web Services.
• Extensive experience of creating Work Spaces, Test suites and Test Cases in SOAP UI
• Provided Technical support, and working with our Development group to resolve more advanced issues when necessary
• Extensive experience on batch testing in SOAP UI Tool.
• Provided analysis related to Troubleshooting defects and bug fixes.
• Making extensive use of Quality Center to log the Defects in Defect tab and to manage the Test Scripts in Test Plan Tab and Test Run Status in Test Lab.
• Involved in trouble shoot the defects and bug fixes
• Extensively used Quality Center to manage requirements and map those requirements to Test Cases.
• Extensively used TOAD for Backend Testing by writing the SQL Queries (Select Statements and JOINS) in the SQL Editor.
• Worked closely with Developers by following the Agile (Scrum) Methodology.
• Actively participated in monthly UAT Sessions and generated the Action Item Documents and prioritize them in the Monthly Iteration Cycles.

Environment: HP QTP 9.5, HP Quality Center 9.2, Soap UI, HTML, Informatica, Web 2.0, SOA, Oracle 10g, TOAD and Windows 7/XP Professional and UNIX

Confidential

Test Engineer

Responsibilities:

• Involved in testing functionalities of the application which deals with the insurance claims related to property and casualty.
• Generated test plans, test cases and test steps for manual testing.
• Involved in different phases of Software Development Life Cycle (SDLC).
• Involved in preparation of Test Plan document and Test Cases
• Developed automated scripts using QTP for performing Regression testing.
• Modified the test cases and re-ran them for the purpose of Regression testing.
• Undergone through Regression, Assembly and Functional testing.
• Conducted performance testing of the applications by generating scripts using Load Runner.
• Used Quality Center as Bug tracking tool.
• Performed test execution and reporting using ALM
• Extensively Used QTP 8.2 to develop the Regression Test Suite with the design and implementation of QTP Automation Framework.
• Performed Data Driven Testing using QTP 8.2 to test the application with different set of data.
• Developed End to End automated test scripts by using Descriptive Programming and Function Libraries in QTP 8.2.
• Enhanced the scripts through parameterization, additional user Defined functions and modified the scripts according to changing Application Needs using QTP 8.2.
• Extensively used Quality Center 8.2 for test planning, maintain test cases and test scripts for test execution and for Bug Tracking.
• Extensively involved in Backend Testing by writing the SQL Queries (Select Statements and JOINS) in the SQL Editor
• Worked closely with Developers and Functional Architects by following the Agile (Scrum) Methodology.
• Actively participated in Design Reviews and Weekly Status Meetings.

Environment: HP Quality Center 10.0, HP Quick Test Pro, SQL, PL/SQL, Java script, Mainframe VSAM Files, XML Files, Flat Files, UNIX, Oracle 10G, DB2, TOAD, Shell Scripting, PERL

Confidential

QA Tester

Responsibilities:

• Understanding the requirements of the client and act as a sole functional resource
• Involved in designing and developing the Front end application using Visual basic (VB).
• Conducted Sanity Testing, Documentation Testing, Browser Compatibility Testing, Installation Testing, System Testing
• Executed test cases and documented bugs found during the process of testing.
• Tracked extensive IT testing issues of the whole project resulting from test execution and categorized according to severity of the problem.
• Managed the overall testing effort, including coordination of testing personnel and test lab resources
• Created SQL queries to retrieve data from database to validate the input data.
• Prepared Test data for the inputs of the test cases.
• Tested the functionality of the application with multiple data including positive and negative data for multiple times.
• Defects entered, tracked and maintained with Bug Tracking System.

Environment: Test Director, Rational Clear Quest, Visual Basic 6.0, MSSQL Server