SUMMARY

• Around 6 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 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 and can write complex SQL queries to validate the data conditions against any database.
• Proficient in development, execution, maintenance of Test Plans, Test Cases, Test Scripts, Test Specifications, Test Scenarios and Traceability Matrix.
• Solid analytical and dynamic troubleshooting skills.
• 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.
• Proficient in SQL queries.
• 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.
• Participated in requirement analysis, documenting use cases, executing test plans and defect tracking using ALM.
• Experience in Black box, white box, negative/positive, port testing.
• Participating in Defect life cycle and User acceptance Testing (UAT) for better productivity.
• Self-motivated and excellent abilities to learn new languages and other concepts quickly, excellent interpersonal skills, abilities to communicate with team players.

TECHNICAL SKILLS

Operating Systems: Windows 2007/7/8, UNIX (Linux, unix)

Databases: Oracle 10g/ 11g, SQL Server, Sybase, MS Access, Teradata.

ETL Tools: Informatica 7.1, 8.1, 8.6.1, SSIS, Data Stage.

Packages: MS-Office, Visual Studio. 2005.

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

ETL 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.
• Performed an hybrid role of business analyst and tester for the Agile development projects.
• 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.
• Used Jira for reporting and tracking bugs, and update on resolved bugs.
• 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 dev team.
• 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.
• Used Informatica to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Extensively involved with backend testing by writing complex SQL queries.
• 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.

Environment: Informatica, MS SQL Server 2008, Agile, UNIX, Micro Strategy, MS Excel, MS Access, Teradata, Teradata SQL Assistant, Oracle 10g, MySQL,Jira, Windows 8, Quality Center/ALM 11,SQL, TOAD, Flat Files

Confidential, CA

QA/ETL Tester.

Responsibilities:

• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM and performing end to end testing.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Informatica Testing and designing of the flow and the logic for the Data warehouse project.
• Participated in Regression testing after each build.
• Extensively worked in agile environment, with daily scrum meeting, stand up meetings, presentations and review.
• Performed data analysis and data profiling using SQL and ETL Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Good experience in writing SQL in order to data validation in migration as part of backend testing.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and BI Business objects.
• Co-ordinate with development and QA team for handling of defects with respect to data
• Validated Business Objects Reports and Universes against Datawarehouse/Data mart Database by writing SQL Queries.
• Performed data quality analysis using advanced SQL skills.
• Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
• As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries Microsoft SQL Server.

Environment: ETL Informatica 9x, BI Business Objects XIR4, Quality Center/ALM (HP Application Lifecycle Management 11.0), QTP, SQL Server 2012, UNIX, Oracle 11g, SQL, PL/SQL, Oracle 10g, Agile, MS Office, Teradata 12, DB2, XML, HTML, Windows and Unix, Shell Scripting.

Confidential, Newark, Augora Hills, CA

QA Tester

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.
• 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.
• 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.
• Maintain SQL scripts for creation of database objects.

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