SUMMARY:

• Over 7+ years of professional QA experience in test case design, test script development in different environments and platforms.
• 5 years of experience in Data Warehouse applications, ETL testing using Informatica Power Center and SSIS(MSBI) on multiple platforms.
• 2 years of experience in Manual Testing and Content Management.
• Hands on experience in testing the Big Data using Hadoop (HIVE).
• Hands on experience in database testing and writing complex SQL queries.
• Experience in reporting tools like SSRS and Tableau.
• Knowledge on creating views and dashboards using Tableau.
• Extensive experience in all aspects of SDLC (Software Development life cycle) and STLC (Software Testing Life Cycle).
• Strong knowledge of Data warehousing methods and Architectures, Star Schema modeling, Fact and Dimension table design, Physical and logical data modeling.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension (SCD) phenomenon, Surrogate key assignment.
• Experience in working of Data Migration projects.
• Experience in working of multiple databases like Oracle, MySQL, Netezza, Postgress, Hive.
• Knowledge on working with Unix commands.
• Knowledge on Automation tools like Selenium and QTP.
• Extensive experience in Automation & Manual Testing of Web based and Client - Server applications.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts 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 and Regression testing.
• Exposure to multiple tools like HP QC/ (ALM), JIRA, Rally.
• Well versed in GUI application testing, Database testing and Front-end vs. Back-end testing.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Expertise in many Testing methodologies like Water Fall model, Agile-Scrum.
• Highly adaptive to a team environment and proven ability to work in a fast-paced teaming environment with good communication skills.

TECHNICAL SKILLS:

Operating Systems: AIX 5.2, Unix, Windows 98/2000/ NT/XP.

Programming Languages: C, C++, SQL, PL/SQL, COBOL, JCL, HTML, XML.

Databases: Oracle 10g/9i/8i, SQL Server, MS-Sql, Postgress and Hadoop (HIVE), Netezza

Datawarehouse tools: Informatica, Sql-server2008 MSBI (SSIS), Reporting tools(Tableau,SSRS)

Testing Tools: HP Quality Center /ALM, QTP, Jira, Rally

Automation Tools: Selenium WebDriver and Test NG Framework

PROFESSIONAL EXPERIENCE:

Confidential, Chevy Chase, MD

Senior software QA

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts.
• Formulate methods to perform Positive and Negative testing against requirements.
• Performed Manual Testing of the application Front-End and Functionality. Identified the critical test scripts to be automated.
• Performed Verification, Validation, and Transformations on the Input data before loading into target database.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions.
• Perform Functional, Data Validation, Integration and regression testing.
• Involved in testing Unix shell scripts to run various ETL Scripts to load the data into Target Database.
• Worked on Jira to log defects and track resolution till the closing of defect after retesting.
• Worked closely with users and program developers to ensure application development meets to user´s expectations.
• worked on data migration while migrating the data from netezza to Hadoop database

Environment: Informatica 8.6.1, PL/SQL Developer for Oracle, UNIX, Putty, Windows XP, Postgress, Hadoop.

Confidential, Woodland Hills, CA

ETL tester

• Actively participated in analyzing test plan as per the business requirements.
• Organized Test Cases, bugs, tracking of defect in the QC tool, through connectivity of QC.
• Participated in walkthroughs and reviews with developers establishing quality policy conformance.
• Performed Backend testing to validate the data using Toad, added SQL queries to the required Test cases.
• Performed Positive testing, Negative testing, Functional testing, Navigational testing, System Testing and Regression testing in different phases.
• Defect tracking is done in the Quality Center 9.0 to add, review, repair and analyze defects.
• Worked closely with development team to resolve the defects and testability issues throughout Software Test Life Cycle.
• Participated in the team meetings to discuss the issues arising out of testing.
• Time to Time discussions with business analyst to know more details of the project.

Environment: Oracle 10g, HP Quality Center 10.0, PuTTY, UNIX, Windows 7, Agile Scrum, SQL browser.

Confidential

ETL QA

• Participated in the requirements, design, and release readiness reviews.
• Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of the Informatica based ETL process.
• Created and maintained test documentation and test plans.
• Development and Execution of Test Cases for Informatica ETL components.
• Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality.
• Participated in the requirements, design, and release readiness reviews.
• Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of the Informatica based ETL process.
• Created and maintained test documentation and test plans.
• Development and Execution of Test Cases for Informatica ETL components.
• Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality.

Environment: Informatica, UNIX, SQL-SERVER2005, MSBI (SSIS, SSRS) and Quality Center 9.0 .