SUMMARY

• 8+ years of experience in Quality Assurance Testing of Business Intelligence, Datawarehouse, DataMart, databases, Web - Based, Client-Server Application
• Good experience in implementing Test Life Cycle starting from planning, creating, executing, reporting and tracking defects.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, Data Cleansing, Data Scrubbing and Data Migration
• Experience in preparation of Test Matrix and identifying the Test Data.
• I was involved in all Test activities such as System Testing, Integration Testing, UAT, pre-production and Batch processing of front end inbound, outbound interfaces for all IPOS systems.
• Good experience as SOAP Web Services Tester, in testing web services via SOAP
• Has good knowledge of web technologies like Web Services, SOAP, XML, HTML,, ASP, JSP, ASP.NET, .NET, JavaScript, VB Script, VB, Java, C, C#, and C++.
• Participated in monitoring historical loads in UAT and PROD environments.
• Used ClearQuest, TFS and Jira tools for defect/bug management.
• Excellent skills in Defect Management/Problem Solving including tracking defects, issues and reporting using Team Foundation Server ( TFS) /Test Director/Quality Center.
• Proficiency with use of all modules in HP QC or ALM (Application Lifecycle Management).
• Preparation of Test Case Documents from SRS, Business Development document or User Stories
• Involved in testing end to end ETL process, DWH applications and SQL Queries for data validation.
• Extensively worked on Data cleansing and Data Staging of operational sources using ETL processes
• Proficient experience in different Databases like Oracle, SQL Server and Teradata
• Preparation of Bug Profile and assigning the severity as per the project state and phase of development
• Experience in developing complex SQL queries using joins, sub queries and correlated sub queries
• Experienced in working in Agile Scrum, Waterfall and SDLC methodology environments
• Extensive experience in Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica and other ETL tools
• Good experience in BI tools like Cognos and Business Objects for testing reports
• Extensive experience in various levels and types of tests such as Regression, Functional, System, Integration, Adhoc, Smoke
• Experience in testing Web-Services using REST clients
• Experience in Platform testing
• Expertise in problem solving and Bug Reports using Test Management Tools like HP Quality Center, JIRA, RALLY
• Well versed with UNIX Commands and UNIX Shell Scripts and worked with many commands including, sftp, tail, head, sed, awk, cut, grep, sort, uniq, etc
• Team-oriented and ability to understand and adapt to new technologies and environment
• Excellent analytical, written and verbal communication skills

TECHNICAL SKILLS

Testing Tools: Quality Center 9/10, Quick Test Pro 8.0/6.5/6.0, Load Runner, REST Clients

Databases: Oracle 9i/10g/11g, Teradata, DB2

Languages: C, SQL, UNIX Shell script

ETL Tools: Informatica Power Center 8.5,Data Stage, Business Object 6.5.1

Operating Systems: WindowsNT/2000/XP, UNIX, LINUX

Bug Tracking Tools: Rational Clear Quest, Bugzilla, HP QC 9/10, ALM 11, JIRA, RALLY.TFS.

Others: MS Office

Web Technologies: SOAP UI 4.5, Web services, C#.NET, VB.NET, ASP.Net, XML, HTML, DHTML, XSLT, CSS, PHP, and AJAX.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Senior ETL/QA Tester

Responsibilities:

• Analyze Business Required Documents and Detailed Design Documents to create test cases and test scripts.
• Executed manual test scripts for using TFS.
• Responsible for reporting bugs through the TFS and verified known bugs against new builds.
• Proactively involve in weekly meetings to discuss about the testing approaches with the development team.
• Test the data flow from the various sources to the target based on mapping documents and business logics.
• Use Toad as a tool to query different databases like DB2, SQL Server.
• Extensively use Beyond Compare tool to compare data.
• Execute complex SQL queries to validate the data between source and target .
• Validate both canned and ad-hoc reports generated in the Dashboard by developing SQL queries using joins, analytical functions.
• Involve in System Integration and Regression Testings.
• Work with Business Analysts and Development leads to understand the business requirements and the application functionalities.
• Tested the reports generated by SQL Server reporting services (SSRS) and checked as they are as per the Organization standards
• Performed End to end testing starting from the source to the report.
• Prepared test data to cover all the test scenarios.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse.
• Performed Functionality, Stress, Security, GUI & Regression testing of web-based applications.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Extracted data from various sources like flat files and SQL Server.
• Written Test Cases for ETL to compare Source and Target database systems.
• Involved in development and implementation of test cases test plans test data and test scripts.
• Defined and executed test cases across a number of internally developed Front and Middle office applications through Clear Quest.

Confidential, Malborough, Massachusetts

Senior QA/ETL Tester

Responsibilities:

• Create test cases based on user stories and acceptance criteria
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group.
• Involved in Test plan, Test case preparation and assigning defects through TFS (Team Foundation Server
• Worked on configuration management using Visual Studio Team System (VSTS), Team Foundation Server (TFS), VSS and Subversion.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Tested several Informatica Mappings to validate the business conditions.
• Involve in weekly planning meeting, stories grooming meeting with the team and give QA estimates
• Use Rally as a repository for test cases and for defect tracking
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Co-ordination / Interaction with implementation team batch process related issues
• Developed Test Cases and Test Scripts for System and UAT Testing
• Worked on issues with migration from development to testing and testing to UAT environments.
• Involved in preparing test data for UAT and participated in UAT signoff
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Involved in various meetings on Agile methodology.
• Interacted with QA and Development Engineers to learn about work flow, analyzed the test process, and helped develop strategies for testing products and services in an agile environment.
• Developed test scripts using QTP for Functionality and Regression Testing.
• Involved in conversion of Win Runner scripts to QTP (Quick Test Pro).
• Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing.
• Involve in communicating with Product Management to understand the Business requirements
• Take a snapshot of the recent build and deploy in QA environment when necessary
• Execute Complex SQL queries to validate various reports data using joins, sub queries, analytical functions, set operators
• Execute various ant commands to install Database, load schema, load data into DB from flat files
• Use JMT to execute jobs.
• Performed SOA/Web Services testing using SOAP UI and tested XML files using Soap UI.
• Involve in various usability studies for usability improvement of the applications
• Test various reports by executing complex SQL queries such as joins, analytical functions, sub-queries
• Experience in using XMLs for application configuration
• Test REST Services by using REST Clients
• Use Toad and SQL Developer to write SQL Queries to validate the data
• Involve in various types of testing such as Functional, Smoke, Regression, Ad-hoc
• Check log files to trace issues
• Experience in using hub for different routes
• Use Cygwin to run mbeef scripts

Confidential, Boston, MA

Senior QA/ETL Tester

Responsibilities:

• Analyze Business Required Documents, Functional Specification Document and project needs
• Involve in preparation of Test Data to test the functionality of the applications
• Involve in writing Test Scripts and Required Traceability Matrix required in the process of analyzing the expected and actual results.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Manage the testing process, schedule batch tests, log and track defects using Quality Center.
• Assisted in promotion of Informatica code and Unix Shell scripts from UAT to Production
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Created UAT test cases and scenarios based on Use Cases, and made sure those UAT test cases meets the business requirements.
• To verify data completeness, data transformation, data quality, integration testing, UAT and regression testing.
• Written Test Cases for ETL to compare Source and Target database systems.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Managed and executed the test process, using Agile Methodology
• Implement Test Life Cycle starting from planning, creating, executing, reporting and tracking defects
• Used Quality Center and ALM as a repository for Test Cases and for Defect Tracking
• Proactively involve in communicating the status of critical issues and escalate to appropriate management, when required
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables
• Used Toad to query the Oracle database
• Develop complex SQL queries using joins, sub queries and correlated sub queries for data validation
• Involve in logging defects in the system and delivering the work within the SLA time
• Involve in regular meetings with developers to report various problems
• Create UNIX scripts for file transfer and manipulation, check status of jobs in UNIX and tail log files while the loading is under processing
• Use Autosys for job scheduling
• Extensive use of Filezilla and WinSCP for file transfer from windows server to Unix server and vice-versa

Confidential, East Providence, RI

QA/DWH Analyst

Responsibilities:

• Performed UAT testing
• Responsible for complete manual testing of application under test (UAT)
• Assisted System Test and UAT testing.
• Gathers requirement and specification documents from business teams and covert them into test case scenarios
• Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System
• Involved in writing Test Cases and RTM involved in the process of analyzing the expected and actual results
• Used Quality Center as a repository for Test Cases and for Defect Tracking
• Wrote test cases for the Informatica mappings and BI reports
• Written test cases for source and target data validations
• Extensively used Informatica 8.5 tool in this project to load data from Flat files to Oracle XML
• Written several complex SQL queries for validating Reports
• Validated data in the reports by writing simple to complex SQL queries against EDWH
• Involved in testing XML files and checked whether data is parsed and loaded to staging tables
• Performed Integration, End-to-End and System testing
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports
• Executed various SQL Queries to perform the backend testing

Confidential, San Ramon, CA

QA Tester 

Responsibilities:

• Designed, Developed, Executed and Analyzed Test plans, Test Cases & Test Scripts for Functional, Integration, System and Regression Testings
• Performed Inbound and Outbound Data Validation
• Involved in preparation of Test Data to test the functionality of the sources
• Tested all DataStage jobs and ETL flow for data validation
• Used DataStage Director to schedule jobs, testing and debugging its components and monitoring results
• Used SQL queries to extract data from the target tables to prove the data mapping
• Tested various ETL Scripts to load the data into Target Data Warehouse (Oracle / Teradata)
• Involved in understanding of the Specifications for Data Warehouse ETL Process and interacted with the designers and the end users for informational requirements
• Validated Data in Database using SQL queries (Teradata, Oracle)
• Used the Teradata PMON tool in monitoring the queries
• Familiar with Teradata Load and Unload utilities
• Validated Conditions, Rules by using SQL
• Involved in proactively communicating the status of critical issues and escalate to appropriate management, when required
• Extensively used HP Quality Center as a defect tracking tool to log, close and generate reports
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager
• Involved in fixing up the production issues, logging defects in the system and delivering the work within the SLA time