PROFESSIONAL SUMMARY:

• 5 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.
• 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: ETL TOOLS: Datastage 7.5,5.2,5.1(Designer, Director, Manager, Administrator), Parallel Extender, Informatica 9.0.1

Scripting: UNIX Shell Scripting

Languages: Java 2.0, C, C++, PL/SQL

Operating Systems: UNIX, Windows NT, Windows 95, MS DOS, Windows XP

RDBMS: Teradata 13, 12, V2R5, V2R6, V2R12, DB2 Oracle 9i/8i/7.x, Sybase, MSAccess.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema, Snow-Flake Schema, FACT and Dimension Tables, Physical and Logical Data Modeling

Scheduling Tools: Control-M

QA TOOLS: Test Director, QTP, HP Quality Center

Reporting Tools: Business Objects, OBIEE

Others: TOAD

PROFESSIONAL EXPERIENCE:

Confidential

QA/ Data Warehouse Tester

• Worked on ETL Testing, Reporting Capabilities Testing, GUI application testing, Database testing and Front-end testing.
• Involved in loading data using Hadoop and testing
• 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, Datastage, OBIEE, Business Objects, Informatica

Confidential

QA/Data Warehouse Tester

• 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
• 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.
• Developed TPT scripts
• Involved in identifying the feed and sending it to RACE and TDS
• Involved in the FRR coding and Unit Testing
• Involved in End to End Testing

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

Confidential

Test Engineer

• 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.
• Cross verification of logs in UNIX by using putty.
• 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, HP Quality Center, Soap UI, HTML, Informatica, Web 2.0, SOA, Oracle 10g, TOAD and Windows 7/XP Professional, UNIX, Business Objects, DataStage