SUMMARY

• Around 7 years of experience in Software Quality Assurance Testing Data base, BI & Web applications.
• Good knowledge in Banking, Insurance, Health Care domains.
• Conversant with all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC).
• Worked in both Agile & Waterfall methodologies.
• Experience in Web/GUI functional testing and worked and tested SOA environments
• Skilled in creating test traceability matrix, test plan, test design, use cases, test cases, test procedures, test log, automated test scripts and defect reporting.
• Worked with discrete databases like Teradata, SQL Server, Oracle, DB2.
• Experienced with various ETL tools like SSIS, Informatica, Data Stage, Ab initio.
• Sound knowledge of Data Warehouse terminology.
• Expertise in testing complex Business rules by using mapping documents.
• Experienced in using UNIX commands for shell scripting.
• Expertise in writing complex SQL queries.
• Expertise in RDBMS backend testing for data validation and data integrity using SQL.
• Extremely dedicated self - motivated Proactive and willing to assume responsibility.
• Good experience on Team Management for different projects.
• Personal skills include Excellent Communication, strong sense of Organization and Effective Time Management and have the Ability to work in a team as well as independently.
• Executed negative and positive test cases to test application functionality against user requirements.
• Effectively manage multiple work assignments and priorities.

TECHNICAL SKILLS

Test Tools: Quick Test Pro, Win Runner and Test Director and Rational Test Suite

Programming Language: . Net, XML & HTML

Database: Oracle, SQL Server, Teradata, DB2

Tracking Tools: Win Runner, Quality Center, Test Director, ALM and Bugzilla

Utilities: Visio, SQL Load, FTP, Telnet, Rational Clear Case, All Fusion

Operating Systems: Citrix, HP-UX, UNIX, DOS, Windows

Miscellaneous: MS DOS, Word, Excel, Power Point

ETL/BI Tools: Informatica 8.6.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Business Object, Crystal Reports, SSIS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL QA Analyst

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Performed both Positive Testing and Negative Testing.
• Performed Code review of automation Scripts and made comments for changes made in the script.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Involved in Data migration and Data distribution testing
• Validated the web services by testing the WSDLs using SOAP UI.
• Validated all the ETL mappings developed to fetch data from OLTP system to the data warehouse.
• Participated in SCRUM and SPRINT meetings.
• Created Scenarios as per business requirements with various user loads using Performance Center.
• Extensively used SQL to query the Database to setup the test data.
• Assigned critical performance Defects to the developer using JIRA.
• Weekly meeting with the management team and share the Status Report on the weekly basis.
• Tested and validated data on Micro Strategy reports.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Worked on JIRA and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using JIRA.

Environment: Netezza, JIRA, MS Office, Informatica, MS SQL, Agile, Scrum

Confidential, Richmond, VA

ETL/BI/ QA Analyst

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
• Worked with autosys for orchestration of files
• Involved in implementation of the Test plans, Test cases and Test Scripts.
• Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
• Tested the data and data integrity among various sources and targets.
• Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc
• Reviewed Informatics mappings and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• The reports that were created in Business Objects were testing by running the SQL statements
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Reviewed the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Involved in preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.
• Designs, test scripts, for data driven test for Web- based pricing and underwriting system
• Involved in deployment of programs using web logic server
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
• Hands on experience working with SQL Server DTS Packages.

Environment: Informatica Power Center 8.1, Business Objects, MS SQL Server 2012, Teradata, Unix Shell Scripting, XML, TOAD 9.2,Oracle 9.2, HP Quality Center, Rational Suite, DBArtisan 8.5.2, Autosys, MQ’s

Confidential, Richmond, VA

BI/ETL tester/ UAT Tester

Responsibilities:

• Written complex SQL queries for Credit Rating System and Risk Rating System and validated the ETL Conditions.
• Managed multiple projects for EDWH Group for all testing activities related to both ETL and BI
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports and written extensive SQL for comparing the records against source data.
• Supervising the QA team in accomplishing their tasks as per the deadlines.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards
• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations and Ensured that the mappings are correct
• Conducted data validation testing and extracted certain column of data from a number to files using PERL.
• Wrote complex SQL queries to validate EDW data versus EDM source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• A given test case will be a ‘Pass’ if the EDW results (expected value) match exactly with EDM (actual value).
• Used PERL for automating all the types of modules at a time and Worked with PERL control structures & Regular Expressions for substitutions based on matches.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation.
• Written UNIX Shell scripts for cleanup, error logging, text parsing, job scheduling and job sequencing.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Debugging the SQL-Statements and stored procedures
• Developed regression test scripts for the application
• Involved in metrics gathering, analysis and reporting to concerned team
• Conducted review sessions on test case and regression test scripts in quality center
• Load new or modified data into back-end Oracle database.
• Involved in testing procedures, functions, packages and triggers as a part of backend testing using Toad.
• Identified and recommended required to the testing effort
• Conducted & Knowledge Transfer Sessions on new applications to QA Analysts

Environment: Teradata, TOAD, Windows XP, HP Quality Center 9.2, Oracle 10G, SQL Server 2008/2012, XML, XML Spy 2008, Shell Scripting, OBIEE, UNIX, VB Script, COBOL II, File-Aid, Informatica, SSIS

Confidential, OH

ETL Tester

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Designed and developed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases using complex SQL queries.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Validated Data Migration and Data Cleansing
• Logged defects using HP Quality Center 10, linked defects with requirements and generated Defect Reports in QC.
• Participated in change review meetings and suggested on the testability of the CRs.
• Tested drill down reports, sub reports, linked reports, parameterized reports created using SSRS.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Used Toad to query against the Oracle data source.
• Tested Fast-Load, MultiLoad, and BTEQ utilities.
• Tested Informatica jobs scheduled using Autosys.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to identify and validate the code written for the data movement into the database tables.
• Retested the resolved defects/issues after the developers fix the defects.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Informatica 9.0, Oracle 10g, My SQL, Teradata V2R5, SSRS, SSAS, Teradata SQL Assistant, AutoSys, TOAD 8.0, UNIX, Quality Center 10.0