PROFESSIONAL SUMMARY:

• Over 6 years of experience in Information Technology with emphasis on Software Testing/Quality Assurance.
• Experience in using Quality Assurance for ETL, Backend, Web based, Client/Server Applications using Manual and Automated testing tools.
• Good understanding of QA methodology and Software Development Life Cycle (SDLC).
• Involved in analysis, design and quality assurance of Client/server and Web applications for Healthcare, Insurance, Finance and Banking.
• Extensive experience with testing Multi - Tier application architecture.
• Developed Test Plans, Test Scenarios, and Test cases, Test Scripts, Test reports and Test Metrics for Manual as well as Automated testing for various applications to ensure proper business compliance.
• Diverse experience in Information Technology with emphasis on Quality Assurance, Manual Testing, Automated Testing.
• Excellent knowledge in ETL validation, Data Model Validations.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Extensive experience in client/server and web application testing using System Testing, Functionality Testing (White & Black Box), Integration Testing, Regression Testing, Smoke Testing, GUI Testing, Data base Testing and User acceptance testing.
• Experience in using Visual Source Safe and CVS
• Extensive experience with Data warehouse applications.
• Strong experience in automating the test using QTP and modifying the script code using VB Script.
• Strong knowledge in Automation tool QTP and Quality Center.
• Experience in End-to-End testing with CMM and ISO standards.
• Experience in BPT (Business Process Testing) by using QTP
• Expertise in Problem solving and Bug Reports using Bug Tracking Tools.
• Strong skills in backend (in both Relational & Hierarchical database) testing. Writing SQL queries, generating reports to ensure data integrity and validating business rules
• Experience in working with Databases and using SQL, SQL Server, Oracle
• Good Knowledge in design/testing and implementation of stored procedures, triggers and functions at database level using PL/SQL
• Experience in testing Business Intelligence reports generated by various BI Tools like OBIEE, COGNOS and Business Objects.
• Ability to handle multiple tasks and work independently as well as in a team.
• Good team player with excellent written and verbal communication, interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

Data warehousing Tools: Informatica 9.5/9.1/8.6, Business Objects, COGNOS, OBIEE

Testing Tools: Mercury Quality Center 10.0/9.0, Quick Test Pro 9.2/ 10.0, HP Quality Center, Load Runner

Languages: HTML, T-SQL, PL/SQL

Operating Systems: Windows XP/Vista/7/8, UNIX

Methodologies: SDLC, Agile

Databases: Oracle 10g/9i, SQL Server 2008/2005, MS Access

Office Software s: MS Office (Word, Excel, PowerPoint), MS Project

PROFESSIONAL EXPERIENCE:

Confidential - Minneapolis,MN

ETL Tester

Responsibilities:

• Developed Test Plans, Test Scenarios, Test Cases, Traceability Matrix, Test Summary Reports and Test Execution Metrics.
• Developed and Executed the Test cases & Scripts for Functional, System, Regression, Integration, Performance and UAT.
• Involved in writing Complex queries using SQL for Data Integrity checks.
• Participation in Requirement / Use Case analysis, Risk analysis and configuration management.
• Validating the data in various stages of data movement from Source to Staging and from Staging to Data Warehouse tables.
• Created Test Cases using the SDLC procedures and reviewed them with the Test Manager.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future s.
• Retested the modifications, once bugs are fixed after reinstalling the application.
• Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.
• Developed presentation and testing implementation learning to other testing resources for cross functional .
• Extensively tested the OBIEE report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the Data files from source to make sure correct data has been captured to be loaded to target tables
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in SQL Server.
• Validate the SELL In, SELL Thru data models and validated the OBIEE reports with Oracle source systems Demantra and Fusion
• Involved in Defect Review meetings with Business Core Team and Developed use-case Analysis
• Actively participating in project specification reviews, writing and maintaining QA technical documentation.
• Identify/debug, troubleshoot, modify, document, test the production issues and create production support schedule.

Environment: Informatica 9.5, Oracle 11i/10g, SQL developer, SQL Server 2012, Toad, OBIEE, Autosys, Rational Clear Quest, Clear Case, Windows

Confidential - Plano, TX

DW Tester

Responsibilities:

• Involved in the full software life cycle for testing (STLC) activities from test planning, test execution to test monitoring, status reporting, documentation and Business Objects report validation.
• Reviewed requirements documented (mapping document/Report Specs) by Business Analyst for thorough understanding of the application.
• Validating the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
• Created Test Cases using the SDLC procedures and reviewed them with the Test lead.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future s.
• Validating the external data source by connecting thru Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.
• Testing included Unit, System, Regression testing, Business Objects reports testing.
• Provide flexible & high quality support to wider Testing strategies on key regular deliverables & ad hoc reporting issues.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• ETL validation, Data Model Validation.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Retested the modifications, once bugs are fixed after reinstalling the application.
• Developed automated scripts for functional and regression testing.
• Reported the bugs through email notifications to developers using Quality Center.
• Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.

Environment: Informatica 9.1, Business Objects, Mercury Quality Center 10.0, Oracle 9i/10g, SQL Server 2008, Microsoft Office

Confidential, Birmingham, AL

ETL Tester

Responsibilities:

• Performed ETL test scenarios by writing SQL scripts with consideration of Business scenarios.
• Exclusively worked with ETL team to analyze the source and Target Database systems
• Exclusively worked on ETL test case scenarios with business functionality and generated the reports for business users.
• Translating business requirements and technical specifications into test cases, test script.
• Identifying the gaps between the requirements and use cases.
• Creating and managing system testing schedule and executing the test cases against the functional specifications.
• Created manual and automated tests by conducting functionality testing, regression testing.
• Worked closely with the project team in planning, coordination and implementing QA methodology in Agile Environment.
• Developed Test cases for different Loan scenarios (Conventional\\High balance\\Jumbo).
• Executed test cases manually to verify the expected results, as well as using automation tool Quality Center and QTP.
• Involved in preparation and enhancement of automated scripts for the identified automation scenarios using QTP.
• Analyzed and helped in modifying the Use Cases and created the Test cases based on them.
• Used Quality center to track, analyze and document defects.
• Reporting and tracking defects using test management.
• Involved in developing Entry & Exit criteria and defined the pass and fail standards.
• Performed Positive & Negative Testing.
• Participated in various meetings and discussed Enhancement and Modification Request issues (Change Requests).
• Performed Functional, Smoke, Integration, and System testing of Data warehouse application.
• Involved in Data testing by writing SQL queries in database tables to ensure UI result match the Database results.
• Validated Source -Target mappings applying various transformation rules and Business Rules.
• Involved in testing various reports created using Cognos.
• Effective co-ordination between development team and testing team.

Environment: Quality Center 9.5, QTP 10.0, Informatica 8.6, Cognos, XML, SQL Server 2008/2005UNIX, Excel

Confidential, Lansing MI

ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performing database testing to verify backend database transactions.
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts.
• Created and executed goal oriented and manual scenarios using Load Runner Controller.
• Creating traceability relationship between requirements in the same module and also between different modules. Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: HP Quality Center, Informatica 8.6, Oracle 10g, QTP 9.2, SQL, PL/SQL, SQL*Plus, Load Runner, UNIX

Confidential, Irving TX

ETL Tester

Responsibilities:

• Involved in the testing of Data Marts using Power Center
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Tested Business Objects reports migration and created Business Objects reports for defect tracking.
• Reports created in Business Objects were tested by running SQL statements.
• Coordinated the test data, Business Objects environment and UAT of reports
• Performed User Acceptance Testing and Regression Testing.
• Participated in discussions with the business owners regarding rating test cases/results.
• Wrote T-SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Wrote several UNIX scripts for invoking data reconciliation.
• Created UNIX shell scripts for file transfer and file manipulation
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Involved in functional testing the Web application using Quick Test Pro.
• Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
• Performed User Acceptance Testing and Regression testing.
• Involved in System Analysis, Design and Development of the OLAP application
• Extensively used Informatica client tools to extract data stored in database and for testing purposes.

Environment: Informatica 8.1, Quick Test Pro, Unix Shell Scripting, Oracle, SQL server, Toad