SUMMARY

• 7+ years of IT experience in the Quality Analysis and Testing of Data Warehouses, Business Intelligence solutions, Data Marts, ETL, OLAP, in Financial, Health Care and Retail domains.
• Excellent QA experience in all phases of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of QA methodologies, disciplines, tasks, resources and documenting.
• ETL Tester with INFORMATICA, SSIS Warehouse Environment and OLAP Reporting via SSRS and COGNOS.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Strong skill in Backend Testing using SQL queries on Oracle and SQL Server.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification.
• Experience on working with Confidential QC (Quality Center), WinRunner, Rational Tools - Rational Clear Quest, Rational Clear Case, Rational Requisite Pro and Telelogic DOORS.
• Knowledge on Web Services and SQL 2008, WCF tool (Windows Communication Foundation) manually.
• Professional experience in designing Testing Framework (UNIX Shell Script based) and developing Test Scripts & Suites for UNIX environments.
• Extensive experience in developing Test Plans, Test Scenarios, Test Strategies, Test Cases, Test Reports and RTMs.
• Experience on Data profiling, Data Validation, Data Integrity
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Proficient in SQL, PERL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Have solid experience on database query tools such as TOAD, SQL Navigator, and Teradata SQL Assistant, Rapid SQL, and SQL Plus.
• Experience is testing the Reports for data validation and cosmetic content.
• Hands-onQA Analystresponsible for coordinating and performing functional and data-related testing.
• Experience in working with Multiple Relational Databases like Oracle 9i/8i/7.x, SQL Server 2000, MS Access, XML and Flat Files. Expertise in writing SQL queries to verify the database.Experience in maintaining the test environments; involved in requesting the deployments, requesting data loads, data base backups, restarting the servers, trouble shooting issues.
• Experience in meeting with Business Analysts and End Users to define, document and review functional and technical requirements.

TECHNICAL SKILLS

Operating Systems: Windows XP, NT, Linux, UNIX.

Languages Known: C,.Net, PL/SQL 8.x/2.x, SQL*Plus

Database: Oracle 9i/10g, Teradata, MS SQL Server, MS Access, SQL Server, IBM DB2

Testing Tools: Quality Center 9.2/10, Confidential ALM, Test Director.

Reporting Tools: Cognos 8.4/10.2, Crystal Reports 6.5, Business Objects 5.1

Datamodelling Tools: Erwin 8, Designer 2000

ETL Tools: Informatica, SQL*Loader, TOAD, Data Profile

PROFESSIONAL EXPERIENCE

Confidential, Atlanta,GA

Sr.ETL Tester

Responsibilities:

• Participate in weekly meeting with the management team and walkthroughs
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Attended daily scrum meetings and bi-weekly sprint planning meetings for agile projects.
• Involved in extensive Data validation using SQL queries and back-end testing
• Created test scripts and test cases to thoroughly test different complex functionality of the application.
• Copying Input data files from ACS to UNIX test server and Pre-Prod server using FTP and validating the Data.
• Performed Testing process in an Agile environment.
• Analyzed Business Requirements for creating and reviewing test documents - Test Strategy, Test Plans, Test Scenarios and Test Cases
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed automated test scripts for upgrading the application using QTP.
• Expertise of the flow of the data from the source through the ETL process into the target warehouse.
• Reviewed test cases written by other members of the testing team.
• Added test cases as per compliance to additional business requirements in the next phase of testing cycle.
• Involved in Functional testing and Web Service testing using WCF.
• Experience testing ETL products, tested transaction for ETL using INFORMATICA and SSIS and OLAP REPORTING using SSRS and COGNOS.
• Actively involved in daily sync up meetings with development team, business system analyst, project manager, senior test team lead in the project.
• Created and managed test data required for executing test scenarios.
• Experience testing ETL products, tested transaction for ETL using INFORMATICA and SSIS and OLAP REPORTING using SSRS. Performed testing extensively for integration and unit testing of standalone and distributed GUI-based applications and GUI-less SOA Web Services.
• Hands-on management of QA department including, but not limited to, developing complex SQL queries, analytics/theoreticals, and Enterprise Data Warehousing (EDW) on the Teradata platform
• Interacted with cross functional groups such as Development, Architecture and Data Conversion to better understand the functionality and resolve the defects effectively
• Experience in defect analysis. Logged defects using the Team Foundation Server.
• Submitted Weekly Test status report to summarize the number of defects found and number of defects tested to the Test team lead.
• Actively involved in daily bug triage meetings for the testing team.
• Involved in in Bi-Weekly All-Hands meeting with the entire Project Team members.

Environment: Informatica,Cognos,SSIS,SSRS,Teradata,TOAD, Confidential (Quality Center), Linux/Unix, Oracle 11g, Microstrategy SQL Server, HTML, Windows 7

Confidential, Philadelphia, PA

ETL Tester

Responsibilities:

• Involved in writing detailed test plans and test cases to verify functionality and adherence to business requirements.
• Interacted with Business users to create business requirements.
• Actively participated in the System solution phase.
• Formulated the System and functional requirements from the BR and participated in the review process.
• Created user defined functions and parameterized the test using external flat files and databases.
• Performed Backend testing to verify the data integrity by passing SQL Queries.
• Created detailed project test plans and test cases functional, system, end to end
• Used IBM Rational Quality Manager in managing and tracking of test schedule, test case execution and overall defect management.
• Hands on experience in creation of test plan and test cases.
• Experience with integration of data across various sources in an ETL process, versioning, manual correction of tables, address correction.
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Created functional, system and end-to-end test cases.
• Reorganized old Datawarehouse records into a much more efficient data mart system.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Performed database back end testing by executing complex queries regarding Joins, Stored Procedures & Triggers
• Experience validating the data at each transformation - source tables, staging tables, loading tables and finally destination tables/views --using the data mapping files and data dictionaries.
• Facilitated the defect release cycles with the different test cycles.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Developed many Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Expertise working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual ETL functionality (properly processing good data i.e., transformations, calculations, and derivations).
• Actively participated in the user training aspects including documentation and online sessions.
• Extensively worked on the UAT support with end business user group against the UAT test plans and test cases.
• Defects found during testing were raised as Test issues in the Issue View and are assigned to the respective developers for troubleshooting and rectification.

Environment: Informatica, Erwin, Mercury Quality Center,Windows,Cognos, SQL,QTP,Teradata, Business Intelligence, SQL server 2005,SSIS, Oracle, PL/SQL,TOAD, XML,Unix/Linux,QTP.

Confidential, NH

ETL Tester

Responsibilities:

• Involved in designing of Test Scenarios based on design documents to start the testing process from scratch.
• Involved in developing Master Test plan and User Acceptance Test plan.
• Coordinating between different user groups, other areas of application, teams and individuals.
• Used SQL Queries to retrieve data from tables and to perform Back-End Testing.
• Created Test cases End to End Scenarios based on Business flow.
• Performed risk assessed Functionality Testing.
• Querying data from different database tables as per the requirement and executing the source queries from workflows. Involved in data migration from Data stage to Informatica.
• Written Test cases for multiple scenario’s like Multiple Drivers and Multiple Vehicles,
• Executed the test cases of Cover Page, Driver Information, Vehicle Details Page, Claims or losses, Quote Summary Page and Billing Information.
• Wrote test cases for various billing scenarios like Credit cards, Electronic Fund transfer, Agency Bill, Bill for Deposit etc.
• Managing testing enhancements and customizations of existing ETL processes.
• Used Win Runner for Regression testing to check for unintended errors after each release.
• Executed scripts with different sets of data using Data Driven Wizard in Win Runner.
• Parameterize property values for objects and Checkpoints in Win Runner.
• Performed Positive Testing and Negative Testing both manually.
• Test Director was used to perform bug tracking.
• Analysis of Client Supplied Products (Requirements) obtained from Test Director.
• Mapped the requirements to the Test Cases using the Requirement Traceability Matrix.

Environment: QTP, HTML,ETL, Business Intelligence, Windows, UNIX,Quality Center, SQL, Oracle, PL/SQL, Crystal Reports

Confidential, New York, NY

Sr. QA/ETL Tester

Responsibilities:

• Define and implement test suites for various aspects of software testing (e.g. things like functional, System, UAT, Regression etc
• Involved in the Defect tracking Management.
• Validated Hospital and Medical claims processing.
• Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
• Collected requirements and tested several business reports.
• Tested the conversion of 835 EDI transactions from along with ICD 9 to ICD 10 codes.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend testing
• Analyzed the change detection process on Facets database tables to capture the daily changes done by Users through Online Facets Application.
• Validated the reports and files according to HIPAA enforced standards
• Performed Defect Tracking and Change Control Procedures using Rational ClearQuest, and Configuration Management and Version Control using Rational Clear Case.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
• Written Test Cases for ETL to compare Source and Target database and Tested records with logical delete using flags
• Using Rational Clear Quest creating the defects which are related to Service plans and Service plan Ids and managing the same.

Environment: Quality Center,Windows NT 4.0, SQL, Oracle PL/SQL, XML, Unix/Linux,QTP.

Confidential

QA Tester

Responsibilities:

• Involved in analyzing user requirements for application enhancements and preparing testing specifications.
• Developed comprehensive test plans based on test & business scenarios.
• Involved in validating major releases by running the system tests and regression tests
• Prepared test data based on exact definition of test scenarios (for positive testing)
• Prepared test data as per exact opposite definition of scenarios (for negative testing)
• Executed test cases on test region and validated functionality of the new fix and verified if new fix is impacting existing functionality
• Conducted regression testing on release, verified that no new defects were caused by production fixes.
• Wrote SQL quires to validate the data in the database by using stored procedures.
• Bug tracking was done through JIRA.

Environment: Quality Center,Jira, MS Office suite, SQl, MS ExcelEDUCATION: M.SC. IN MATHEMATICS, NATIONAL UNIVERSITY, BANGLADESH