SUMMARY:

• Over 6+ Years of IT Experienced in Prepared documentation such as business requirements and functional specifications based on business needs and used the information to develop detailed comprehensive test strategies to verify system changes to meet the needs of the client.
• Good testing experience in Financial and Banking domains.
• Excellent understanding of the Agile Software Development Life Cycle (SDLC), STLC and the role of Quality Assurance Agile Methodologies and Agile PLM
• Developed several ETL applications to Extract, Transform and Load data into tables as part of Data Warehouse testing using various tools.
• Experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Participated in design walkthroughs and verified QC Test Scripts and results.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Performed Back End Testing by executing SQL queries.
• Excellent understanding of product lifecycles (PLC) with primary focus on requirements definition, documentation and systems design validation to ensure that the project deliverables are implemented
• Experienced in Software Development Life Cycle (SDLC) and Project Life Cycle working as QA in Healthcare domain with prime focus on Claims adjudication, billing, provider, eligibility and prior authorization for Medicare, Medicaid and Blue Programs.
• Expertise in querying and testing RDBMS such as Teradata, DB2, Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Extensively worked with Relational Database Management Systems (RDBMS) including Oracle, MS SQL, SYBASE, DB2 and MS Access.
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Solid understanding of STLC and SDLC

TECHNICAL SKILLS:

TESTING TOOLS: Load Runner, UFT/QTP, Web Services

BUG REPORTING: ALM/Quality Center, CQTM, Clear Quest

REQUIREMENT MGMT TOOLS: Caliber RM, Rational Requisite Pro

PROGRAMMING LANGUAGES: PL/SQL, TSL (Test Script Language), VB Script

RDBMS: Oracle, MS Access, SQL Server, DB2

OFFICE SOFTWARE: MS Office (Word, Excel, PowerPoint)

OPERATING SYSTEM: Windows, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, Alabama

Sr. QA / ETL/ Data Warehouse Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Understand the ETL Design and Mapping documents and identify the Test Scenarios and prepared the Test cases.
• Developed test cases in the test lab of HP ALM/ Quality Center.
• Involved in developing Automation scripts using UFT/QTP.
• Prepared test scenarios and test cases in HP ALM/ Quality Center
• Involved in Smoke Test, Integration, End to End, RBT, and ETL Workflows testing.
• Provide ongoing support to UAT defect management, test data coordination, data mining and batch issue resolution.
• Managed the Metadata associated with ETL processes used to populate the data warehouse.
• Involved in extensive DATA validation using SQL queries and back - end testing
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Created high level use case diagrams, process composition diagrams and data modeling

  Reviewed Informatica mappings and test cases before delivering to Client.

• Extensively performed ETL and QA Testing process to ensure the quality of the software.
• Used UFT/QTP to perform Regression testing upon new builds and updated the scripts accordingly.
• Responsible for preparing and executing System Test Plan and Test cases using HP ALM/ Quality Center
• Performed Business Process Testing using BPT (Business process testing) module of HP ALM/Quality Center and UFT/QTP.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Preparation of System Test Results after Test case execution.
• Ability to use testing tools to execute tests (HP ALM/ Quality Center)
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Managing, tracking, documenting defects using HP ALM/ Quality Center.
• Performed Functional, Regression, Data Integrity, System, Compatibility testing.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Installed the UFT/QTP for automating test cases and developed user defined functions to support Automated Scripts, used Data Driven Testing and Data Base accessing techniques to support the Scripts
• Interacted with developers to report and track bugs using HP ALM/ Quality Center
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database.
• Agile testing process focused in (functional and non-functional requirements, compatibility, load, stress, end-to-end, defect removal, alpha/beta, scenario and others) and analyzes and reports test results
• Used HP ALM/ Quality Center for managing and reporting defects.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Investigated software bugs and reporting to the developers using HP ALM/ Quality Center Defect Module.
• Prepared automated scripts for Maintenance and Regression testing using UFT/QTP.
• Preparing and supporting the QA and UAT test environments.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: SQL, PL/SQL, UNIX, putty, XML Files, HP ALM/ Quality Center, ORACLE, UFT, MS Office, MS Excel, MS Word, Teradata SQL Assistant, Agile, SOAP UI.

Confidential, Chicago IL

QA Analyst/ Data Warehouse Tester

Responsibilities:

• Converted Business Requirements and Design Documentation into Test Cases and Test Scripts.
• Implementing Agile (Scrum) methodology throughout the Branch.
• Generated the test execution report in ALM/ Quality Center to be reviewed by the QA manager and development team.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Executed and logged defects within ALM/ Quality Center
• Performing data analysis between the tables and applications by using SQL.
• Created and executed Test Cases for some of the modules of the application under test (AUT) using ALM/ Quality Center Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Extensive UAT Testing Manually.
• Performed Smoke, Functional, Regression, System and User Acceptance Testing (UAT) in Web application.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Automate existing functional manual regression/smoke test cases using UFT/QTP
• Responsible for defect tracking and management metrics, defects are logged and change requests are submitted using ALM/ Quality Center
• Attend the daily Scrum Meeting in the Agile environment to discuss all the outstanding Issues.
• Wrote complex SQL scripts for Backend testing and Frontend Data validations
• Extensively used ALM/ Quality Center for test planning, bug tracking and reporting.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Performed Backend testing using SQL queries to validate data.
• Executed test scripts in UFT/QTP for regression testing to ensure the quality of the system
• Interacted with developers to report and track bugs using ALM/ Quality Center.
• Worked with ETL group for understating Data Stage.
• Used SQL queries to validate the data between the backend and the front end
• Responsible for functional, regression, user acceptance and performance testing
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Tested the ETL graphs and other ETL Processes (DW Testing).
• As a member of the Agile Scrum team participated in daily standup meetings, project status meetings as well as retrospective meetings and iteration reviews.
• Developed test scripts for the test cases in UFT/QTP for functional and regression testing.
• Performed Database (metadata) validation before loading the data into the target tables.
• Tracked and reported defect using ALM/ Quality Center
• Triage and troubleshoot environment issues
• Responsible for different Data mapping activities from Source systems to Teradata.
• Provide data mining, test data creation, test results evaluation and test support to an integrated project team
• Manage defects, environment issues and status reporting

Environment: ALM/ Quality Center, Backend, Java, J2EE, Agile, UFT/QTP, ETL, Data Warehousing, Load runner, Oracle, SQL, Teradata, PL/SQL, FACETS

Confidential, Cleveland, OH

QA Analyst/ Tester

Responsibilities:

• Analyzed Business Requirement document and Business Use Cases in development of Test Plans
• Participated in the work-scope meetings and peer review meetings to evaluate Use Cases with Business and Design team
• Facilitated system maintenance and enhancement through design documents, process flow diagrams, use case diagrams etc.
• Comply with the system development life cycle (SDLC) and Project Management Methodology (PMLC) by participating in scope assessment, risk and cost analysis
• Performed Usability and Integration testing manually.
• Created Test Cases, Test Scenarios in Quality Center ensured traceability to Business Use Cases and according to application.
• Wrote test plan for the newly introduced Hedge Fund trading system module.
• Participated in conducting System testing and End to End testing manually.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Detected, reported and tracked defects using Quality Center.
• Provide support and data as and when needed to the performance Team.
• Performed automated testing using Win runner application.
• Developed test scripts for the test cases in Win runner for functional and regression testing.
• Performed Positive and Negative testing to test response of the application under test by creating Data Driven tests.
• Coordinate with Operations team to make sure that new platform has robust testing processes.
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Recommend and implement naming convention for Test Cases, Test Sets and Defects.
• Perform Gap Analysis
• Attended Weekly status meeting in reporting and provided a weekly report that includes test metrics consisting of status reports.

Environment: Java, J2EE, Quality Center, Black Box, Grey Box, MS Windows Server, MS Excel, Web Application, Windows.