SUMMARY

• Over 7 + years of experience in the IT Industry as a QA analyst in the various Data warehouse / Business Intelligence applications.
• Extensive experience in Manual Testing of ETL and BI applications in Integration Testing, System Testing, Performance Testing, Functionality Testing, Post - Implementation Testing and Regression Testing.
• Good experience in Scrum and Waterfall Methodologies.
• Expertise in design and development of test scenarios and Test cases to validate all the requirements.
• Good understanding of data warehouse development and testing methodologies and ETL concepts.
• Good Knowledge on Hadoop Cluster architecture and monitoring the cluster.
• Tested many reports developed in Quick view
• Proficient in ETL testing and methodologies like control mechanism of the batch loads, generation of error logs, loading and processing of rejected records, testing of SCD 2 implementations - ensuring surrogate key integrity and checking process dependencies.
• Experience in various databases like Oracle, SQL Server, MS Access, Sybase and Teradata.
• Extensive experience in writing complex SQL Queries, Analytical SQL and T-SQL statements.
• Exceptional analytical and problem solving skills, communication skills, strong decision making skills and organization skills.
• Extensive experience in working with off-shore Team and onsite projects.
• Sound experience in Knowledge Transfer and Mentoring whenever required.
• Excellent Team player with good communication skills and coordination in team meetings.

TECHNICAL SKILLS

RDBMS: Oracle 10g,11g, Sybase, DB2, and SQL Server

Testing Tools: HP QC, ALM

ETL/BI Tools: InformaticaPowerCenter9.x, SSIS,SSRS

Languages: SQL and Unix scripting

Operating systems: Windows and Unix

PROFESSIONAL EXPERIENCE

Confidential, Addison, TX

DWH/Data Migration Tester

Responsibilities:

• Developed and execute test cases, test scenarios and followed-up defects.
• Studied User Requirement Specifications (URS) and converted them to Functional Requirement Specifications (FRS) and Software Requirement Specifications (SRS) for application modules.
• Used ALM to import test data, defects and test cases.
• Bug reporting, tracking and documentation on the Bug tracking System using ALM.
• Analyzed the results of manual and automated tests.
• Run the jobs through CA Autosys scheduler.
• Experience in managing Hadoop clusters using Cloudera Manager tool.
• Written shell scripts for testing the data file created by SAS jobs.
• Conducted functional and regression testing using QTP.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Used Dynamic SQL Queries in carrying out various Back-End testing for promoting maintainability and code-reuse.
• Worked with VSAM files and loaded the data into Data warehousing using Informatica.
• Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values
• Participated in daily defect tracking conference calls with developers, UAT and dev team using TFS.
• Participated in requirement walkthroughs and creation of test plan.
• Conducted Gap Analysis to ensure all Business Requirements was covered by test cases.
• Performed Sanity Testing and Smoke Testing.
• Involved in testing the databases using complex SQL queries executed in TOAD.
• Developed test jobs for testing needs using SAS.

Environment: ALM, XML, Teradata 13, Teradata SQL Assistant, Toad, Informatica 9.0, SQL Server 2012, Oracle 11, UNIX, Windows

Confidential, Tampa, Florida

DW Tester

Responsibilities:

• Developed the complete Test documents like Test Plan, Test Cases, and Test Scripts by analyzing Business requirement documents, Technical and functional design documents, Use cases.
• Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
• Extensively involved in System testing / Functional, Regression testing and Integration testing
• Involved in test management using Quality center and TFS.
• Performed Database (metadata) validation before loading the data in to the target tables.
• Performed Data Validation by testing the delta/daily and reconcile/data loads.
• Created SQL compare statements to validate Actual results with the Expected Results.
• Trackedand executedtheUser AcceptanceTest Cases (UAT) with respect to the requirements to determine the featurecoverage.
• Worked with many different source systems including XML Files, VSAM Files, Flat Files and Relational Data.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Worked onAutosysforBatch ProcessingETL, PL/SQL subprograms and performed backend testing.
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Worked on Informatica Workflow Manager to run the workflows and Monitored the status and logs in Workflow Monitor
• Written several complex SQL queries for validating Business Objects Reports.
• Extensively tested Business Objects reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Responsible for defects management and driving to resolution and retesting the same.
• Estimated level of effort (LOE) for testing effort and reported to Test Leads.
• Performed Quality Assurance activities for data validation, data scrubbing, data profiling.
• Created shell scripts and used Unix commands to manipulate input files for test execution
• Created test data for all ETL mapping rules to test the functionality according to requirements.
• Used Rational Clear Quest for defect management.
• Ensured quality products delivered and installed as specified in the statement of work (SOW).

Environment: Informatica 9.1, SQL, PL/SQL, Remedy, DB2, Oracle 11g / 10g, TOAD, Rational Clear Quest, Rational Clear Case, Doors, Oracle SQL Developer, XML, PuTTy, VB Script, Quality Center 10, Agile, Micro Soft TFS (Team Foundation Server), MS Visual Studio, Business Objects XI, Autosys, SQL Server 2008, SSIS, SSRS, SSAS, Windows XP, UNIX

Confidential, NH

QA Tester

Responsibilities:

• Analyzed system requirement specification document and developed test plans, test cases to cover overall quality assurance testing.
• Used the Agile methodology as part of the software development life cycle
• Categorized the test cases based on their modularity, functionality and priority.
• Conducted Functionality, Integration and End-to-Endtesting of the AUT.
• Performed browser compatibility testing on different platforms and data validations for all reports.
• Performed Structural Back-End Testing to verify each and every object in the different structure of the Database.
• Conducted Functional Back-End Testing by breaking the test data into finite number of testable pieces based on the application’s functionality on both input and output criteria.
• Developed a Back-EndBoundaryTest Strategy on the database to verify boundary conditions based on Financial Business logic.
• Carried out a Back-End Database Stress Testing approach that involves subjecting the test database to heavy loads.
• Reviewed and fine-tuned the SQL queries using hints for maximum efficiency and performance during the Unit Testing, System Integration and User Acceptance Testing for Database Testing and Gray-Box testing.
• Extensively worked with UNIX commands and Unix shell scripts
• Tested Oracle PL/SQL Packages for creating and generating complex reports for management decision-making processes.
• Tested Data masking and made extensive use of SQL NavigatorExplain Plan to view and analyze complex SQL Queries as part of the Database Back-End Testing.
• Prepared test data for positive and negative test scenarios for both Back-End and Functional testing as documented in the test plan.
• Used Quality Center to plan tests, manage test assets, and create and run manual and external scripts to check GUI and functional features.
• Performed browser compatibility testing on deferent platforms and data validations for all reports
• Tested the application for Broken Links to ensure proper navigation
• Created manual test cases for Functional, GUI and Database testing of the application.
• Communicated status and presented defect information to the developers and various members of the project team to resolve issues to ensure the defect-free delivery of the Software application.
• Responsible for weekly status meetings showing the progress reports and the future testing efforts of the QA Team
• Documented the Daily Defects Status with the help of Test Metrics
• Participated in Walkthrough’s and Technical Reviews all through the testing phase.
• Executed the test cases using sample source documents as inputs during UAT and ensured that the final outcomes of the tests are satisfactory
• Tracked and logged defects in Quality Center and coordinated with development teams on issues
• Performed formal reviews of all documented test cases and keep the latest documents in a common repository for Project Team.
• Executed Smoke Testing to test the main features of the application as and when required.
• Defined a number of test cases using quality data to validate end-to-end business processes during the UAT and Validated the system set up for transactions and user access in UAT
• Provided bug status and regular updates to all concerned

Environment: Agile Software Development, Manual Testing, Quality Center, Windows XP / 2000, UNIX, Oracle, Developer 2000, SQL, PL/SQL, SQL Navigator, Java, JSP, IIS, XML, HTML, BEA Web Logic, MS Project, MS Office

Confidential, Rochester, MN

Data warehouse Tester

Responsibilities:

• Reviewing Functional Requirements documents and Detailed Design Documents (DDD).
• Test and validate the functional Test Cases based on S2T mapping document.
• Prepare the Test Data for the Initial, Incremental (Daily Inserts and Updates) and historical Load testing and validate.
• Transformation rules applied are thoroughly reviewed and tested the data loads.
• Mentored Junior ETL QA Team members.
• Test and validate various data sources in ETL like CSV flat files and different RDBMS (17 Sources).
• Wrote the complex SQL queries against the Source and Target databases.
• Co-Ordinate with team members working in three different-locations.
• Test and maintained Data Integration Global tables to check the status of control loads.
• Test and validate the rejected records and the log files.
• Validate Data Stage Jobs, update processes, Control Loads, and Scheduling mechanism.

Environment: Data Stage 7.X, Sybase, Sybase IQ, DB2, SQL Server, Oracle, Windows XP, Sun Solaris 2.7, FTP Explorer, MS Excel, MS Word, Rapid SQL, Toad, Quest Central, Quality Center 8.2