SUMMARY

• 7+ years of IT experience in Quality Assurance for ETL, Business Intelligence, Data Warehousing, Web based, Client/Server applications using Manual and Automated testing tools.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Gathered and articulated business requirements in order to oversee the development of test plans and test scripts.
• Extensive experience in requirements gathering and analysis, design, development, testing and validation in Data centric projects (data bases, data warehousing and business intelligence space). 
• Extensive experience with test management and test automation tools like Quality Center Test Director, Quick Test Professional, and Rational Clear Quest
• Extensive experience in ETL and BI testing for many data extractions and data migration projects.
• Well versed with SQL, PL/SQL and can write complex SQL queries to validate the data conditions against any database including Sybase, Teradata, SQL Server, DB2 and Oracle
• Proficient in development, execution, maintenance of Test Plans, Test Cases, Test Scripts, Test Specifications, Test Scenarios and Traceability Matrix
• Experience in working Agile Methodology (Scrum) and used JIRA.
• Experience in complex Manual and Automation Testing of GUI and functional aspects of the client - server and web based applications in all phases of SDLC
• Experience in Functional, Regression, GUI, Usability, Integration, Exploratory, Smoke, Backend, Adhoc, Load, Performance, Black Box and White Box Testing
• Experience in IDQ, DVO Testing.
• Proficient in SQL queries in Teradata
• Experience in testing new enhancements in the IBM WebSphere Data Stage - Multiple Job Compile, Surrogate key generator Stage, Job Report, Message handler options. 
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• All testing engagements completed within project timelines and consistently met live-date project deadlines.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
• Strong in Web application testing and understand architecture in terms of functionality.
• Good experience in Authoring and Reviewing test cases.
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Excellent Communication, Analytical and Interpersonal skills.

SKILL 

Database: Oracle, SQL Server 2005/2008, IBM DB2, Teradata, Sybase

Change Mgt Tools: Test Director 8.0, Quality Center, Rational Clear Quest

Data Warehouse Tools: Informatica, SSIS, MS DTS Packages, Ab Initio, Data Stage, Talend

Functional Test Tools: WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0

BI Tools: Cognos 8.0 Series & Business Objects

Languages: PL/SQL, T-SQL, SQL, XSLT, Visual Basic, PERL, UNIX,hive

Office Tools: MS Office Suite, MS Project, Microsoft Share Point, TFS

Operating System: UNIX, LINUX, Windows, MS-DOS

Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester

Standards: VSTF 2008, METAL, SQL Server Analysis Server

Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, SSAS, SSRS, XML Spy 2010

Web Technologies: XML, HTML, JavaScript, VBScript

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

ETL/Talend

Responsibilities:

• Designing the Test Scenarios as per the business requirements and Mapping documents.
• Profiling the data using Talend and sql.
• Testing Validation rules as per the requirement in different cases.
• Acquired knowledge in complex sql scenarios.
• Worked on pulling data from multiple sources for all possible test cases.
• Data Ingestion: Too many source systems worked on complex system
• Acquired good knowledge in terms of subject area (customer, product, inventory etc...) and relation to the business.
• Involved in end to end testing and in different stages of the project.
• Worked on different source systems like SFDC, ORACLE, NXGEN, AOMS, and SAP…
• Designed an approach for the team in functional testing.
• Understand the transformation rules and create test cases based on the business requirement.
• Worked closely with the development in fixing the defects (Regression testing) and find the root cause of the issue.

Environment: Hive, Beeline, big data, Talend (ETL Tool), Jira

Confidential,Westchester, PN 

ETL/QA/ Informatica Tester

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification.
• Performed Functional tests for multiple source tables and dealt with integration project.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Performed tests on Data Quality Checks in IDQ environment and DVO Testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Developed test scripts using QTP for Functionality and Regression Testing. 
• Supporting UAT team in defect analysis and providing data refresh and keeping track of all the jobs and workflows run on time .(number of mappers-map reduce)
• Worked on TOAD and SQL Developer ,involved in fusion of data from different sources and executed complex queries as part of functional testing
• Basic Job Scheduling, monitoring using Autosys (UNIX commands).
• Involved in coordinating and preparing Validation Test Plans, Test Methodology and Test cases as per Functional and Business requirement for System/Functional Test Specification and Unit/Integration Test specification set by the SOP's, Best practices, policies, and procedures of the company.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Extracted data from Oracle and upload to Teradata tables using Teradata.
• Generated testing reports and metrics, trend graphs according to the test plan.
• Performed the data validation and datatypes mismatch
• Involved in rigorous meetings with offshore testing team and allocating resource for a particular production issue to be cleared on priority.
• Coordinated all the defects and root cause for the defects, to ensure quality of the data (ALM).
• Used UC4 tool for Scheduling different jobs and created data dependency checks for proper migration of data. 
• Source systems worked on CSG,AOMS.
• Testing and tracking defect logs (ALM) ,ensure PK and FK relation is as per requirement.
• Tested data migration to ensure that integrity of data was not compromised.
• Created test data for all ETL mapping rules to test the functionality of the Informatica Jobs
• Tested the ETL process as per the business logic before and after data validations.
• Tested the messages published by ETL tool and data loaded into various databases
• Testing of records with logical delete using flags.

Environment: Informatica, MS SQL Server 2008, DVO,IDQ, UNIX, Teradata, Teradata SQL Assistant, Oracle 10g, TOAD, QTP ,Windows 2007,Quality Center/ALM 11, T-SQL, SQL, Teradata Studio, TOAD,UC4.

ETL/QA/Informatica Tester

Responsibilities:

• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Tested and compared the Cognos Power Play cubes to the original requirements for complete functionality
• Create Informatica Parallel Jobs to extract, transformation and loading of the data using Informatica design toll in the parallel processing mode. 
• Logged the defects in the HP Quality center/ALM
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Developed test scripts using QTP for Functionality and Regression Testing. 
• Used Mercury HP Quality Center/ALM to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team
• Worked as a consultant in delivering quality data centric solutions for various business domains
• Involved in coordinating and preparing Validation Test Plans, Test Methodology and Test cases as per Functional and Business requirement for System/Functional Test Specification and Unit/Integration Test specification set by the SOP's, Best practices, policies, and procedures of the company.
• Tested and validated the Cognos Report Net reports by running similar SQL queries against the source system(s)
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Involved in running the job stream in UNIX and in Cntrl M. 
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Generated testing reports and metrics, trend graphs according to the test plan
• Performed the data validation once the Batch Job execution is completed
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Data Report testing in Cognos
• Used Informatica to move data to the warehouse using the stored Procedure thereby enabling faster moment of data. 
• Managed and executed the test process, using Agile Methodology 
• Tested data migration to ensure that integrity of data was not compromised.
• Created test data for all ETL mapping rules to test the functionality of the Informatica Jobs
• Tested the ETL process for both before data validation and after data validation process.
• Tested the messages published by ETL tool and data loaded into various databases
• Testing of records with logical delete using flags.

Environment: Informatica, MS SQL Server 2008, Agile, UNIX ,Cognos ,MS Excel, MS Access, Teradata, Teradata SQL Assistant, Oracle 10g, MySQL, QTP ,Windows 2007,Quality Center/ALM 11, T-SQL, SQL, MOSS, TOAD, Flat Files

ETL/QA Informatica Tester

Responsibilities:

• Tested several ETL job activities for Informatica using Informatica designer Created ETL test data for all ETL mapping rules to test the functionality of the Informatica jobs. 
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center/ALM
• Strong testing Quality Assurance experience within agile environment. 
• Wrote the Insert, Update, Delete and Error Processing test cases in all the stages.
• Wrote PL/SQL stored procedures for certain data validations
• Used Quality Center/ALM for test planning and execution and Rational Clear Quest was used for defect tracking.
• Involved in testing the Cognos reports by writing complex SQL queries
• Validated the interface from Frontend to backend tables
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Tested the validity and correctness of data in the system using data centric testing. 
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Performed Sanity testing, Security testing, black box and white box testing, web testing and GUI testing
• Performed testing on Java, .NET and on web based applications
• Was involved in executing the Regression testing on new Builds
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica 
• Developed Test Cases for Deployment Verification, ETL Data Validation and Data Report testing in SSRS report testing.
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Performed an hybrid role of business analyst and tester for the Agile development projects
• Worked with Test Analysts to ensure that defects are tracked and documented and results communicated to developers and stakeholders.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Trained the users for the User Acceptance Testing (UAT) and explained about each link, tab and search functionalities to the users.
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS). 
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Generated testing reports and metrics, trend graphs according to the test plan
• Created and executed SQL queries in ORACLE and MS SQL server
• Performed tests on various browsers
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: MS SQL Server 2008, Oracle 11g (SQL, PL/SQL), UNIX ,SSRS, TOAD, MS Access, QTP, Informatica, HP Quality Center/ALM 11, Teradata 13.0,XML, XSD, XML Spy, Agile, Rational Clear Quest

ETL/QA Backend Tester

Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Worked with Business analysis team to prepare a detailed Business Requirement documents.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, and GUI & Regression testing of web-based applications.
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with Production environment to resolve several data issues.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Tested several reports and automated using Quick Test Pro (QTP).
• Written several Stored Procedures and modified existing stored procedures.
• Involved with extraction routines to verify all the required data loaded into target systems.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of informatica jobs
• Used SQL on UNIX platform to perform Backend Testing on databases.
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Reported the defects in Quality Center and documented the report queries
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
• Used SQL queries and custom programs to perform data validation.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Oracle 10g, Teradata 12.0, SQL Server 2008, SQL, PL/SQL, Stored Procedures, HTML, Java Script, Quick Test Pro, HP Quality Center, Agile, Autosys, MS Office Suite, Informatica, PERL, Cognos, HTML, JAVA, JSP, JavaScript, Rational Clear Quest, Clear Case, RUP, TOAD, Requisite Pro, Test Manager, Automation/Manual Testing, UNIX.

Data Warehouse Tester

Responsibilities:

• Worked closely with the development teams to replicate end user issues.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Modified the design as per the changes in requirements.
• Interacted with the client on a daily basis and attended status meetings.
• Worked with developer to improve database performance.
• Created and maintained development, QA and audit database environments
• Attended status meetings and sending team status reports.
• Use of TOAD to write SQL queries and validate the backend
• Documentation of Test Results, Test Reports and Test Summary Report.
• Performed Database Testing using SQL queries for testing reports.
• Defined QA procedures to plan, design, execute, evaluate and report results of software testing under minimal or no supervision.
• Worked with QA team members and application developers; quickly capture the major business functions and technology to design and implement tests of system functionality that exercise all critical intersystem integration points.
• Utilized mercury test suite for requirement management, test case creation, execution and defect tracking.
• Executed Ab Initio ETL sessions in different stages Source to Stage & Staging to Data ware to Datamart and to Business objects.
• Tested many Ab Initio graphs and tested the functionality of ETL mapping rules.
• Wrote PL/SQL stored procedures for certain data validations

Environment: PL/SQL, SQL, Test Director, UNIX, Shell Scripting, Quality Center, Ab Initio (GDE 1.12, Co>Op 2.12), MVS, JCL, VSAM Files, XML Files, CSV, COBOL II, Copy Books, Autosys, Crontab, Oracle 10g, Sybase 12.3, Business Objects XIR2, TOAD, WinSQL AUTOSYS, TOAD

Software Engineer

Responsibilities:

• Worked on gathering requirements for loan level and pool level amortization process.
• Prepared detailed business requirement documents.
• Reviewed the Business Requirement Documents and the Technical Specification.
• Developed Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed System Testing and Integrity Testing using WinRunner.
• Developed, tracked and managed Issues Log created during the test phase using Excel.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Performed extensive database testing.
• Performed Load Testing, Stress Testing and Performance testing using LoadRunner.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.
• Maintain SQL scripts for creation of database objects.

Environment: SQL, PL/SQL, Autosys, Test Director, JSP, Java Script, HTML, Windows NT/2000, UNIX