SUMMARY:

• 8+ years of Software Quality Assurance (QA) experience in testing Data Warehouse, Database, Web, Client -
• Server Systems and Applications.
• Experienced in creating Test Cases, Test Scenarios, Traceability Matrix and Test Scripts for testing process.
• Experience to understand & translate business requirements into test scenarios.
• Expertise in taking the functional requirements & convert the use case into test case by adding specific data to ascenario.
• Expert in ETL testing from source to target data flow.
• Strong technical expertise in Integration testing, Functional testing, GUI testing, Backend testing.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Experience with domain knowledge like Financial, Insurance, Healthcare.
• Experience in Star/Snowflake schema modeling, Fact & Dimension Tables, Conceptual, Logical & Physical datamodeling.
• Experience in testing using ETL tools Informatica Power Center and IBM Infosphere.
• Used Autosys for scheduling Jobs.
• Worked on automation Fitnesse tool for SQL scripts.
• Created UNIX shell scripts for handling files and running the Autosys jobs.
• Expertise in Relational Database Systems like Oracle, Sybase, SQL Server, Teradata & Netezza.
• Skilled in Stored Procedures, Functions, Oracle Performance Tuning, Indexes.
• Exposure to the entire process of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience in Offshore-Onshore work model.
• Excellent verbal & communication skills along with clear understanding of business procedures and ability to work as an individual/part of a team.
• Quick learner and adaptive to new & challenging technological environments.

TECHNICAL SKILLS:

ETL Tools: IBM InfoSphere DataStage 11.x,9.x/8.X, Informatica Power Center 9.x/8.x

Languages: SQL, PL/SQL, C, C++, SharePoint, .Net, UNIX

RDBMS: Oracle 11G/10G/9i, TERADATA R13, V6, Microsoft SQL Server 2017/2012/2008 , Netezza 7.0, DB2

Tools: & Utilities:SQL Navigator, TOAD, SQL* Loader, SQL Developer, SQL PLUS, Putty, SQL Assistant, WinSQL

BI Tools: Business Objects, Cognos

Data Modeling: Erwin 7.2/4.1.4, Microsoft Visio

Testing Tools: HP Quality Center, HP ALM, IBM Rational ClearQuest, RTC, CA Rally

Scheduling Tools: Autosys, Crontab, Control-M

Version Control: Borland Star team, IBM Rational ClearCase

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr.Test Engineer

Responsibilities:

• Providing timelines for testing strategy.
• Working on requirements with the DI team.
• Presenting impact analysis to business SME's and data stewards in order to determine if results extracted from the RRDW are in line with requirements.
• Schedule daily scrum meetings with the team members and discussed daily updates and any road blocks.
• Used TOAD and SQL Developer Software for Querying ORACLE
• Assigning of test cases to team.
• Create and execute SQL queries to fetch data from Oracle database to validate the mapping.
• Working on writing test cases and uploading them in ALM.
• Executing the test cases in ALM.
• Validating transformation logic, validating that data has been loaded without record loss, truncation usingSQL queries.
• Performed data testing.
• Extract data from source and compare that data to a legacy source in order to perform impact analysis is alsorequired.
• Creating a defect when the source and target data mismatches
• Using ALM for bug tracking and reporting, also followed up with the development team to verify bug fixes, and update bug status.
• Performed production testing once the code went live.

Environment: HP ALM, SQL Developer, Toad, Oracle 11g, SharePoint.

Confidential, Charlotte, NC

Sr. Test Engineer

Responsibilities:

• Participated in the Business Requirement Documents and the Functional Specification Documents.
• Prepared the Test plan for Functional specification document.
• Prepared the test objectives for the test plan.
• Created Traceability Matrix to ensure that all the requirements are covered by the test cases.
• Developed Test scenarios, Test cases.
• Prepared the test scripts in HP ALM.
• Executed the test scripts through HP ALM.
• Testing includes both front end web applications and backend testing using sql scripts.
• Logged the defects using IBM Rational Clear Quest.
• Queryed the DBs using SQLs for validations.
• Validated the source and target mappings using the SQL queries.
• Validated all the transformations from source to target.
• Run the autosys jobs in UNIX.
• Created Test Data to validate various scenarios.
• Validated the reports generated through batch reports.
• Transferred the files from one server to another server using the NDM.
• Used UNIX commands for executing the scripts, copying the files.
• Attended daily scrum calls and provided the status of testing.
• Performed regression testing for making sure whole functionality is working as expected.

Environment: HP ALM, IBM Rational Clear Quest, UNIX, Autosys, Oracle 11g.

Confidential, Charlotte, NC

Sr. Test Engineer

Responsibilities:

• Analyze the User/Business requirements, Functional specs and create the Test Plans, Test cases forSystem testing.
• Coordinate with the business analysts, developers and discussed issues in interpreting the requirements.
• Created Quality Plan, Test Scenarios, Test Cases, execute test cases, track issues to closure.
• Prepared the QA Effort estimate for the identified User stories and Change requests.
• Validated the SOAP output backend results by writing SQL queries and executing them in TOAD.
• Performed API Testing, GUI front-end and Backend testing for internal web-based applications
• Extensively used Data stage to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata toTeradata.
• Involved in Test Plan Review and Write Test Scripts using Requirements document.
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Written extensive UNIX Shell scripting for data parsing and text parsing needs including archiving the old data,running backend jobs & setting up of job dependencies.
• Performed extensive data validations against Data Warehouse
• Loaded flat file Data into Teradata tables using Unix Shell scripts.
• Responsible for verifying business requirements, ETL Analysis, ETL test and design of the flow and thelogic for the Data warehouse using Datastage and Shell Scripting
• Tested several Datastage Mappings to validate the business conditions.
• Conditional testing of constraints based on the business rules
• Designed and executed the test cases on the application as per company standards and tracked the defectsusing CA Rally.
• Analyse the Production incidents and assign the Incidents to appropriate team/ person.
• Designed and prepared scripts to monitor uptime/downtime of different system components.
• Generate the execution results and sent it across to the team, by way of gathering and analysing the Test Metricsfor the purpose of reporting.
• Actively participate in the complete Test Set design and Execution.

Environment: CA Rally, Infosphere Datastage 11.1, Oracle 11, SQL server 2005/2008, Teradata, UNIX, Autosys, RTCWinSCP

Confidential, Charlotte, NC

Sr. Test Engineer

Responsibilities:

• Understanding the requirement by analyzing Business requirement document, detailed design documentand Feature brief document and discussing with the business people of client.
• Involved in Project Management activities like reporting and mail communication. Provide technical assistance inidentifying, evaluating, designing and specifying systems and procedures that are cost effective, efficient and meet business requirements and CORE goals
• Worked with ETL group for understating ETL tool Informatica powercenter, sources systems including SQL
• Server, Oracle, Teradata and Flat Files Offer business support, define business requirements and analyzeproject impacts
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data.
• Involved in writing and implementation of the test plan and developed test cases and Test scripts in QualityCenter (ALM).
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent dataentry into the database.
• Performing Backend Testing on the Web-based application using SQL Queries on Oracle database.
• Status reporting on the daily and weekly basis to Project Manager Consumption by product engineering, documentation,, user experience and user interface groups using IBM Rational Rose.
• Developed data models to support the redesign of financial management reporting data warehouse.
• SQL queries were written to verify the data in both source and target schemas to validate the Datamigration
• 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.
• Written several UNIX scripts for invoking data reconciliation.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle were used in this project to writeShell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification ofduplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using ALM.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: HP ALM, Informatica Power Center 9.5, Autosys, Oracle, Teradata, Windows 7, PowerShell scripting

Confidential, Charlotte, NC

Sr. Test Engineer

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL toverify/validate my test cases.
• Created Quality Plan, Test Scenarios, Test Cases, execute test cases, track issues to closure.
• Prepared the QA Effort estimate for the identified User stories and Change requests.
• Define the Test strategy and contribute to the Project Test Plan.
• Worked on issues with migration from development to testing.
• Worked on Business Intelligence reporting system that was primarily functioning on Neteeza
• Applications OLTP environment with Cognos for Business Intelligence reporting
• Verified the dirty data through user friendly reports, conducted post-cleanse data audit to cleanse the residualerrors for data conversion and migration projects.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification ofduplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documentingthe test results using JIRA.
• Involved in the complete QA Lifecycle activities like Pre-testing phase, Acceptance Testing Phase, Testing
• Phase and also in User Acceptance Testing (UAT).
• In coordination with System Analyst, Project Manager and Business Analyst reviewed and suggested updates to Business Requirement documentation.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used SQL for Querying the Neteeza database for data validation.
• Worked on Automation testing with using Fitnesse tool.

Environment: SQL, PL/SQL, UNIX, Neteza, putty, Shell Scripting, IBM Datastage, AUTOSYS,ORACLE 11G, Fitnesse.

Confidential, Charlotte, NC

Sr. ETL Tester

Responsibilities:

• Created Traceability Matrix to ensure that all the requirements are covered by the test cases.
• Developing Test Plan, Test scenarios, Test cases, Test Scripts and Traceability Matrix.
• Extensively used Datastage to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata toTeradata.
• Create and execute SQL queries to fetch data from Oracle database to validate the UI Data.
• Coordinated with developers and analysts for gathering requirement and documented in test strategy.
• Quality Center (ALM) for analyzed, documented Test strategy, tracking and bug reporting.
• Tested complex objects to the universe to enhance the report functionality.
• Tested ad hoc and canned reports for Business objects.
• Tested Business Objects reports and Web Intelligence reports.
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Written extensive UNIX Shell scripting for data parsing and text parsing needs including archiving the old data,running backend jobs & setting up of job dependencies.
• Tested several Datastage transformations to validate the business conditions.
• Conditional testing of constraints based on the business rules
• Designed and executed the test cases on the application as per company standards and tracked the defectsusing HP Quality Center 9.2
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Used Excel Pivoting for various running totals, total sales for trades, highest performance of trades

Environment: Datastage, Oracle 10g, SQL, PowerShell scripting, Business Objects, HP ALM, Windows 7, UNIXAutosys, Star Team.

Confidential, CA

Sr. ETL Tester

Responsibilities:

• Responsible for developing Quality Assurance and implementing Quality Standards.
• Participate in requirements gathering sessions with Users.
• Involved in Collecting and analyzing business requirements and functional specifications.
• Involved in preliminary discussions of the Module with the core team.
• Involved in Test Plan Review and Write Test Scripts using Requirements document.
• Involved in Preparation of Test cases and reviewing test cases and testing (functional, integration and regression)the application.
• Executes manual test scripts for Maximo project
• Logs and tracks defects for Maximo project
• Experienced in User Acceptance Testing (UAT) testing for both alpha and beta testing. Did a complete UAT testing for the Maximo project.
• Involved in Raising bugs and Validation of fixed bugs.
• Working knowledge of defect management using in QC.
• Created Test Data to validate various scenarios.
• Write Data validation SQL’s for data validation.
• Validate GUI layout as per Requirements document.
• Responsible for testing systems after Patches and Upgrades.
• Worked extensively on validating User’s data visibility setup.
• End User and Documentation.
• Preparation of Requirement Traceability Matrix.
• Prepared Effort estimation and review reports.

Environment: Informatica 8.6, Autosys, DB2, SQL/PLSQL, PowerShell scripting, AIX, HP Quality Center, Oracle 11GTeradataaR13.