SUMMARY

• Around 7 Years of experience in ETL Testing, Manual testing Performance Testing, Stress Testing, Load Testing, Functionality Testing, Integration Testing, System Testing, Regression Testing.
• Created and Published Test Cases, Test Plans, Automated and Manual Test Scripts,
• Test Metrics, Defect Reports and Test Results.
• Experienced in identifying scenarios, analyzing large data, creating test data, maintaining test cases, developing automation test scripts, performance testing, manual test execution and presenting test results.
• Created and Published Test Cases, Test Plans, Automated and Manual Test Scripts, Test Metrics, Defect Reports and Test Results.
• Performed data centric backend testing of applications using UNIX and SQL scripts.
• Experience in UNIX Shell Programming for scheduling, file manipulation etc.
• Involved conducting usability sessions on the existing version of the intranet and testing the existing enterprise portal design or website.
• Working experience in Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS) and Integration Services (SSIS).
• Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
• Skilled in utilizing Test Automation and Test Management tools such as QTP, Win Runner, Load Runner, Test Director and Quality Center (QC) and experienced in performing White Box, Black Box Testing.
• Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
• Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server and Transformation.
• Maintained and created test cases for NICE Actimize testing and System Integration Testing (SIT).
• Experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server, and Informatics Power Center, Power art (Repository Manager, Server manager, and Mapping Designer, Mapplet Designer, Transformation Developer and Warehouse designer).
• Prepared and Validated the Suspicious Activity Reports. For Prompted accurate reporting with strong relationships with law enforcement and processed to close accounts.
• Experience mostly involved in ETL design & development using MSBI suit SSIS, SSRS & SSAS, and Informatica Power Center.
• Worked Extensively on ETL process using SSIS package.
• Experienced in identifying scenarios, analyzing large data, creating test data, maintaining test cases, developing automation test scripts, performance testing, manual test execution and presenting test results.
• Good understanding of business intelligence concepts and concepts related to reporting tools such as SSRS , Web FOCUS and Tableau.
• Experienced in Functional, Integration, Regression, System and Performance Testing.
• Excellent T - SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in QA and Manual Testing in Mobile handset and GSM/GPRS/3G/CDMA WAP Applications.

TECHNICAL SKILLS

Operating systems: Win 95, 98, 2000, XP,NT, Sun Solaris, AS 400, VSAM,MS-DOS,UNIX

Languages: C, C++, HTML, DHTML, XML, ASP.NET

Testing Tools: Load Runner, WinRunner Rational Clear Quest, QTP, Selenium WebDriver, TestNG, Selenium IDE.

Test Management Tools: HP Quality Center (QC), HP Quick Test Professional, HP Application Lifecycle Management (ALM), Post man, QTest

Databases: SQL Server, Oracle, Sybase, DB2UDB, PL/SQL, Oracle 8.x,9.x,10.x, DB2, SQL Server, MS Access

Web/App Servers: Apache, Web Logic, Web Sphere and IIS

Scripting: VBScript, JavaScript, Shell Script, VuGen Scripting

Others: Shell Scripts, MS Office, TOAD.

PROFESSIONAL EXPERIENCE

Confidential

ETL QA analyst

Responsibilities:

• Key communication and coordination link between Confidential PMO, scrum development teams and the QA Resources within the scrum teams.
• Analyze the requirements in Business Requirement Document and create Technical design documents for minor enhancements.
• Created Alert Generation mechanism, SAM module workflow, and Policy Manager Usage
• Worked on testing the Transaction Monitoring (TM/SAM) source and use of funds. Identifies, analyzed and monitored relationships of address, phone number and IP address.
• Created the SAR forms and validated the data from Alert to Case and filed the SAR forms on suspicious alerts.
• Create Requirement Traceability Matrix.
• Create jobs in DataStage as per the business requirements.
• Wrote queries to test the Actimize Application to support impact of user interface views
• Schedule the jobs in Control-M and ensure successful runs of the job cycles to load data in concerned environment (Testing/Production).
• Identified and wrote test cases for customer due diligence (CDD) should drive risk management - identified type of business, beneficial owners.
• Support code deployment to the various environments (testing/Production) till the warranty period.
• Support System Integration & User Acceptance Testing.
• Supported technical team members in modification of workflows and application views in RCM application
• Actimize Raised defects as necessary.
• Create ETL Mapping and Transformations using Data Stage to move data from multiple sources into target.
• Configure and integrate of various data sources like Oracle, Netezza, and MS SQL Server, Flat file into the staging area and design ETL processes.
• Supported firm wide Risk Scoring Methodology periodic reviews and impact analysis by conducting SME and technical meetings and editing documents such as Impact Analysis Reports and Change Management Release Notes.
• Analyze the AML(Anti Money Laundering) risks associated with the client from a technical perspective
• Source to target data validation by writing SQL scripts.
• Write, execute and debug SQL queries to perform data completeness, correctness, data transformation and data quality testing.
• Manage risks, issues and resolutions including mitigation and contingency planning for the work stream and elevate any risks and issues at program level to the overall test lead.
• Plan test scenarios to address QA Testing during the ETL Development phase, covering
• Metadata, script verification as well as transformation rules, Rules and source to target mapping verification etc.
• Perform applications and integration testing involving .Net applications, web services, AWS databases
• Establish pre-requisites for testing including test data needs.
• Import data and monitor data quality using Data loader or Data Import Wizard.
• Configure Users, Profiles, Roles, and Workflows and provide user level, profile level and record level security.
• Manage defect triages and interfaces with Development partners as well as business teams to enable quicker resolution.
• Design and executes test cases.
• Participate in scrum & test planning meetings, leadership team meetings, project status meetings, design reviews, scrum team meetings, status and stand-up meetings and walk-troughs.
• Experience testing distributed systems, including testing on the Hadoop platform and user-level Hadoop configuration and administration skills.
• Performed QA tasks such as writing Test Cases, execution, reports, etc. in Q test Management tool.
• Used in Project Management, Task Tracking, Requirement Management, and Test Management.

Environment: Data stage, NICE ACTIMIZE 6.0 ( single cloud-based platform), Hadoop, Oracle SQL developer, SAS, Netezza, Q test, Jira, SharePoint, Box, Kanban board(Sprint).

Confidential

QA Tester

Responsibilities:

• Responsible for preparing Master Test Plan, the document projecting the scope and various activities involved in the project lifecycle.
• Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
• Involved in designing and reviewing test scenarios, test cases and requirement traceability Matrices. Conducting test execution and reporting and tracking defects to closure.
• Responsible for preparing test data and test environment to execute the test cases.
• Responsible for peer review the test cases prepared by other team members and executing the test Cases.
• Performed functional testing by executing the QTP Scripts from Test Director. Used Python to launch QTP scripts from command line for continuous integration testing.
• Involved in the Smoke test, Functional test & Regression testing
• Involved on testing the new functionality based on test cases and coordinated with development team in fixing the issues, Defect Management by Logging and Tracking bugs during execution in Test lab.
• Regularly followed up with the development team to discuss the defects identified during Testing.
• Involved with Test Coverage Metrics and Defect metrics such as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements.
• Prepared and Presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using HPALM
• Run Compatibility Testing (cross Windows/ Mac and Android/ iOS platforms, cross browsers, cross mobile devices - phones, tablets, iPads etc)
• Coordinated QA, SIT and UAT sessions and executed UAT scenarios with end users for final approval and user signoff.
• Tested the application under different networks and Internet speeds including on 3G, 4G/LTE and Wi-Fi.
• Developed QA processes automation test scripts using Python/Selenium to test Web based user interfaces for different types of browsers. Validated the data from Front End to Back End tables in Oracle Database.
• Worked with POS System and involved in testing functionalities related to sales tracking, POS scanning, Store ISP, ordering forecast, adjustments, custom retail price and promotions in POS.
• Responsible for performance measurement strategies to observe application and infrastructure performance across diverse hardware, operating systems, application servers, and databases, includes Client Experience.
• Responsible for creating the performance test plan, test strategy document, managing performance test scheduling and logistics, after reviewing and verifying performance requirements. Includes analysis, reporting and presenting performance test results to stakeholders.
• Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
• Responsible for providing valuable feedback to developers in order to fix the defects.
• Wrote Test cases and tested Mobile device applications on windows 8/10 tablets, iPads, and iPhone that interfaced with cloud based Rest API service and Azure SQL as well as AWS MySQL.
• Responsible for requirement review meetings test scenarios and test case walkthrough sessions, defect triage calls and test results presentations during software testing life cycle.
• Ensured the quality of testing defects status and bug reporting throughout the testing process by working with fellow as well as senior testers.
• Involved in collecting test status metrics, preparation and submission of daily and weekly status report.

Environment: Word, PPT, Excel, HP/ALM, HP Performance Manager, QTP,POS,API Testing, Postman, Integrations, JSON, XML, COBOL, IBM Order Management, Mainframes application, Apple, Android mobile application.

Confidential

QA Analyst

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Experience in SDLC and Agile methodologies such as SCRUM.
• Developed multiple Map Reduce programs for analyzing the insurance data of the customer and produce summary results from Hadoop to downstream systems.
• Writing in SQL and PL/SQL scripting.
• Gathering business requirements from the Business team and generating system workflows Involved in creating the targeted questionnaire for SMEs and Business users for elaborating requirements.
• Experience testing distributed systems, including testing on the Hadoop platform and user-level Hadoop configuration and administration skills.
• Creating deployment slots in Azure webapps for web and mobile apps for different clients, as needed. Monitoring the Azure VMs in azure.
• Experience with the Cloud (Azure) DevOps - Infrastructure and Platform as a service.
• Expertise in Data Warehouse, ETL Verification, BI reports.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Involving in Functional Testing & Regression Testing.
• Teradata SQL Conversion to Hadoop and Data validation.
• Take a Pre-shot and post shot of data package execution in QA.
• Verifying SSIS logs for execution packages and results.
• Creating test cases for ETL mappings and design documents for production support.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Created DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
• Involvement in Preparation of Test Procedures, Test Scenarios, Cases and Test Data.
• Responsible for GUI and Functional Testing, using Black box Testing Techniques.
• Involvement in Test Execution, Results Analyzing and Defect Reporting.
• Involved in Automation Infrastructure Development using Selenium.
• Created Test cases Using Element locators and Selenium Web driver methods.
• Enhanced Test cases using Java programming features and TestNG Annotations.
• Execution of Selenium Test cases and Reporting defects.
• Conducting Data driven testing, cross browser testing and parallel test execution.
• Enhancing the Test Scripts for Global Execution.
• Involvement in solving Environmental problems along with Technical Support
• People Involved in Regression Testing using Selenium.
• Preparation of weekly and monthly status reports.

Environment: MS Word, PPT, Excel and Visio, FACETS 4.31/4.51, MTM testing tool, QTP , Market Place ( Benefit Focus Web Application), Java, Selenium Web driver with TestNG framework,Hp QC.