SUMMARY

• Over 6+ years of IT experience as Test Analyst in Data Warehousing ETL Testing projects
• Interact with Business users and Technical team to review business requirements and technical specifications.
• Involved in Agile methodology of project implementation.
• Review application specifications and create documents to identify test scenarios
• Identify Integration, System, Performance, User Acceptance Testing scenarios.
• Enhance testing and project quality metrics by working with test engineers
• Identify and create detailed test cases and map them to system requirements and design specifications
• Prepare detailed test plan and test cases by understanding the business logic and user requirements
• Identify application specific test scenarios, test cases, and test scripts from requirements and design documents
• Identify and collect test data to support testing
• Create and maintain test environment for software testing execution
• Create test data and test scenarios, test management and defect tracking/reporting
• Perform different types of Testing: Integration, System, Performance, User Acceptance Testing and Regression.
• Document test results in test tools and validates test cases are complete for future releases.
• Analyzing automation frame works and building automation scripts with VB script and debugging them in QTP 11.0.
• Designing the reusable functions and library files according to the framework.
• Involving in developing the automation scripts based on the manual test cases to replicate every design step through automation tool.
• Involving in automation scripts peer reviews, execution and analyzing the results.
• Prioritizing test cases to be automated and utilizing automation scripts during every release regression.
• Involving in data conversion verifications: source and target verification in every release for correctness of data as per rules mentioned in ETL (Extract Transform and Load) specs - using complicated queries.
• Involving in data cleansing verification: cleansed addresses and name verifications in every release for correctness of standards.
• Good understanding of Teradata Data Warehouse Architecture and complete understanding of data warehousing life cycle.
• Good understanding of AWS Redshift Architecture and complete understanding of data warehousing life cycle.
• Involved in writing the UNIX Shell Scripts to compare the large size data files
• Involved in issue escalation and weekly status reporting
• Create and maintain test plans that define test objectives
• Track and modify test scripts as new functionality is rolled out
• Isolate and communicate defects and requirement variances into Quality Center.
• Expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.

TECHNICAL SKILLS:

Testing Tools: Quality Centre, Mantis, Jira, Siebel

ETL Tool: Abinitio

Languages: C, SQL, UNIX Shell Scripting

Tools /Utilities: MF-Workbench, MF-Resolve

Software Packages: MS Office

Databases: MS SQL Server, Oracle, Teradata, Redshift

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE:

Associate Consultant

Confidential

Responsibilities:

• Understanding the Business Requirement, Mapping Document and Design Documents
• Analyzing the Source (flat files, Oracle) behaviors to identify the extensive testing ways
• Identified all possible test cases for different kinds of loads like History, Incremental.
• Creation of test scenarios and test cases based on requirement documents.
• Execution of the test cases and if any mismatching found then raise the defect.
• Involved in retesting testing.
• Involved in executing the both history and incremental process

Associate Consultant

Confidential

Responsibilities:

• Understanding the Business Requirement, Mapping Document and Design Documents
• Participated in sprint planning meetings
• Involved in executing the Test cases for ETL Testing between Fla files and Target by using Data Base Queries, UNIX Commands.
• Prepare Test scenario and test cases templates
• Attending daily scrum / standup calls to give the status update and to know the status of the user stories

Associate Consultant

Confidential

Responsibilities:

• As this Project input is flat files, all the downstream systems (ARD, CS2, Siebel applications) behavior analyzed completely to generate all possible ways to scenarios.
• Participated in preparing the test data through source systems to insert the records into the error tables, unique violation tables and log tables
• Created work tables to compare the target tables by inserting the source data into tables.
• Coordinating with the business users to help them out in solving technical constrains.
• Creating the test cases in Quality Centre along with the SQL Queries
• Involved in executing the both history and incremental process

Associate Consultant

Confidential

Responsibilities:

• Understanding the Business Requirement, Mapping Document and Design Documents
• Participated in sprint planning meetings
• Prepare Test scenario and test cases templates.
• Involved in peer review meetings
• Prepare the test estimation sheet based on the history and incremental loads
• Involved in executing the Test cases for ETL Testing between Source (Data base, flat files) and Target (Data base, flat files) by using Data Base Queries, UNIX Commands and Shell Scripts
• Involved in executing the both history and incremental process
• Involved in test the migrated reports functionality and UI from the source (OBIEE, Power Pivot and Teradata) and target (BO)
• Attending daily scrum / standup calls to give the status update and to know the status of the user stories
• Involved in retesting and regression testing and end-to-end testing
• Raise the defects in ALM for tracking purpose
• Interacted with Development, Requirements teams for defect review
• Prepared Test Traceability Matrix to ensure requirement coverage
• Status reporting - ensure proper communication between the Onsite and Offshore teams
• Create the Test Logs and Test Summary Reports

Environment: Quality Center, Mantis, Jira, Siebel, SoapUI, SQL, UNIX Shell Scripting, MF-Workbench, MF-Resolve, XML, MS SQL Server, Oracle, Teradata.

Confidential

DWH Tester

Roles & Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Developed ETL test plans based on test strategy, Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules
• Written test cases and completed unit test documentation.
• Used Unix environment variables in various. ksh files which comprises of specified locations to build Ab Initio Graphs
• Involved in pager rotation program to support 24 x 7 production support.

Environment: QC,UNIX (K-Shell Script), Oracle 9i, DB2, Windows 2000 Pro, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD