SUMMARY:

• 5+ years of extensive experience in Quality Assurance testing of data warehousing and Business Intelligence processes, Web Based and Client/Server applications.
• Excellent knowledge in implementation of different QA methodologies/policies, strategies and plans in all stages of SDLC.
• Excellent knowledge in test planning, coordinating, execution and leading the testing process.
• Tested various ETL processes developed using ETL tools like Informatica Power center, Ab Initio and Data stage.
• Tested various reports generated by Business Objects, Micro Strategy and Cognos.
• Proficient in querying various RDMS like Oracle, Teradata, DB2, SQL server & Netezza.
• Excellent knowledge of defect management and tracking using Quality Center, JIRA and TFS.
• Performed automated testing using tool like Quick Test Professional and Selenium.
• Adept at backend testing and data validation testing using SQL queries
• Proficient in Functional, Negative, Regression, System, Integration, User Acceptance (UAT), Security, Usability and compatibility testing during the various phases of the development of the application
• Performed the functional testing, integration testing, system testing and regression testing on the application thoroughly executing the manual/automation testing scripts/test cases
• Experience in performing data validation and preparation of test data in UNIX environment using various UNIX commands and editors.
• Excellent Domain Knowledge in Financial and Insurance.
• Hands on experience in both Waterfall and Agile QA methodologies.
• Coordinated testing efforts and effectively managed Off - Shore teams.
• Self-conscientious starter, strong team skills and ability to lead a team toward achieving organizational objectives.

TECHNICAL EXPERTISE:

Operating Systems: UNIX, Linux, Guidewire and Windows 98/NT/2000/XP/7/10

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

RDBMS: Oracle 8i/9i/10g/11g, Teradata, IBM DB2, and SQL Server 2005/2008/2012, Netezza,Toad.

ETL Tools: Informatica Power Center 8.x/9.x, Data Services and Data stage.

BI Tools: Micro strategy, Business Objects, Cognos and HyperionVisual Insight

Testing Tools: Rational Clear Quest, HP QC ALM 11.0, Selenium, Quick Test Professional, ARF (In house application)

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. QA Analyst

Responsibilities:

• Tested the Informatica mappings and other ETL Processes for the Enterprise Data Warehouse.
• Analyzed Source Qualifier, aggregates and filter logic in Informatica power center against the Business Requirements.
• Validated the Informatica mappings developed to fetch data from different sources. ETL Tasks include analyzing mappings in Informatica Power Center and Developer for loading the data from SQL Server, Oracle and DB2 environments to Netezza staging environment for the enterprise Data warehouse.
• Created extensive SQL scripts to validate the data transfer from source to target.
• Created mockup data based on the different test cases/scenarios.
• Involved in System Integration Testing with external/Internal interface and understood overall business functionalities.
• Used Win SCP to access and copy parameter files of Informatica and flat files extracts in UNIX OS.
• Performed extensive data validation and data verification by creating scripts and reports in the Enterprise Data Warehouse.
• Proposed and built the QA Validation dashboard using stored procedure to validate the key KPI’s against source and the warehouse hub.
• Created and used complex MicroStrategy reports using filter prompts and custom groups extensively for testing data warehouse.
• Tested the MicroStrategy reports using the Integrity Manager during the upgrade from MicroStrategy 9.4 to 10.2.
• Involved in testing of the Informatica platform from Informatica Power Center 9.2 to 9.6.
• Involved in testing the Guidewire UI screens against the EDW reports which were being used by the business teams.
• Written test scripts and stored procedures to automate the testing for the key performance indicators in EDW through ARF.
• Complete understanding of the business process for a thorough test strategy and test case write-up.
• Participated in SCRUM meetings and actively shared opinions on testing perspectives and necessities of testing in various items that are being worked open.
• Uploaded the Test Plan, Test Scripts, Scenarios and Final Reports in the Quality Center for every application using excel worksheets and created test plans in Quality Center directly.
• Created the test plans in HP quality center.
• Used HP Quality center and Share point for the test documentation and communication purposes.
• Created UAT test scenarios and reports and provided the feedback for analysis team.
• Worked on all phases of SDLC as efficient team player.

ETL/Backend Tester

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing
• Tested the ETL Data stage Jobs and other ETL Processes (DW Testing).
• Extensively written SQL to confirm the data transfer from source to target.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Worked with developers to tune the SQL for Teradata, Validated primary key and primary index and tested the performance of different joins based on the frequently used reports in MicroStrategy.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Involved in System Integration Testing with external/Internal interface and understood overall customer business functionalities.
• Tested all the reports generated using MicroStrategy BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated with integration testing and regression testing.
• Worked with the team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.

ETL/QA Tester

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios.
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Fetched data from different sources like mainframes and Teradata and queried using Teradata SQL
• Tested the source data for data completeness and data correctness.
• Tested the PL/SQL package that loaded data into staging from the source database.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level.
• Prepared sample test data by inserting data into staging tables.
• Prepared all the test scenarios and shared across the team.
• Involved in testing all the reports that were generated through Micro strategy.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend datamart through SQL and also using excel for data comparison.
• Involved in end to end testing of the entire process flow starting from the source database to the target datamart to the reports by considering all possible scenarios.
• Was involved in running the Informatica jobs from UNIX box for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Coordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP ALM 11.0 for all the team members to review.
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.

QA Analyst

Responsibilities:

• Reviewed requirements for testability and usability, and consulted development staff with regards to system functionality.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Involved in ETL process testing using Ab Initio ETL tool
• Tested the flow of data from front end to backend databases.
• Tested the real time updates happening in the databases through web services using SOAP UI.
• Tested the ETL processes that ran to load the reference data into the central repository.
• Develop, maintain and execute manual test cases.
• Performed smoke testing, Functionality testing, Integration testing, and Regression testing.
• Participated in review meetings for creating Test plan and test results summary.
• Analyzing business and functional requirement to design SIT and UAT Test Cases
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM on daily basis, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.
• Participated in the meetings with business users to present future functionality of the application, gather information from them to know about their need and send this information to test manager.