PROFILE:

• 5 Years of experience in SDLC, QA Lifecycle, Data Conversion, Data Warehousing and Business Intelligence (BI).
• 5 years of experience in Data Conversion and Data Warehousing (ETL) Testing.
• Adept on Property & Casualty and Health Insurance domain
• In depth knowledge of Data warehousing concepts, Dimensional Data modelling, Star schema and Snow flake schema
• Extensive experience in testing Extract, Transform and Load (ETL) processes and Reports.
• Strong technical skill in ETL tools Data Stage, Informatica and SSIS.
• Experience in testing reports generated by the OLAP tools (reporting tools Business Objects, Cognos)
• Demonstrated experience in using RBDMS like Teradata, DB2, SQL Server and Oracle
• Worked with business analysts, development leads and managers in outlining entry and exit criteria for QA.
• Proficient in developing Testing Strategies, Test Cases, Test Plans for Web based (Client /Server) and Data warehouse Projects.
• Developed Test Plans, Test Requirements, Test Cases, Test Reports, and defect tracking as required by the project.
• Good understanding of ETL Test Processes and Test Methodologies.
• Expert in writing SQL/PLSQL for Data Comparison, Data Integration and Data Migration.
• Experience in testing applications developed using Waterfall model, V and Agile methodologies
• Experienced in Data Warehouse testing errors and provide support to programmers to correct defects in the system.
• Proficient in SQL experience in writing queries for back - end testing to validate data transactions.
• Extensive knowledge of relational data modelling and relational database concepts.
• Proficient experience in different Databases like Oracle and SQL Server.
• Strong exposure to data warehouse ETL environment, Informatica/Data Stage.
• Tested data warehouse components, data marts, testing of Dimension and Fact table loads.
• Worked with Informatica & Data Stage transformations such as multi joins of heterogeneous flat files.
• Extensive exposure in testing of ETL process to load IDS, EDW and Data mart environment.
• Ability to conduct walkthroughs in order to formulate and design complete and detailed test plans and test cases for System, Functional, and User Acceptance Testing.
• Well versed with application business requirement analysis.
• Excellent at client interaction, project management and co-ordination with off-shore team.
• Versatile team player with excellent communication and interpersonal skills. Exceptional ability to quickly master new concepts and technologies

TECHNICAL SKILLS:

QA Tools / Software: QTP 9.2, Quality Centre 9.0

Testing Types: Functional, Integration, System, Regression and User Interface

Database: Oracle 10g / 11g, SQL Server 2005/2008, SQL/PLSQL,T-SQL, Teradata. DB2

Database Tool: Toad, PLSQL Developer and MS Access

ETL Tool: Informatica Power Center, Data Junction

Reporting Tool: Business Objects XI R4 and Cognos

Languages: C, Java, .NET,SQL, UML2.0, XML 1.0

Operating Systems: Linux, Windows XP/7

WORK EXPERIENCE:

Confidential, Overland Park, KS

Responsibilities:

• Established the business analysis methodology using Iterative model of SDLC.
• This project process is done by Agile Methodology.
• Involved in preparation of Effort estimation document and presented to clients.
• Design and Develop Plans for different application releases.
• Created and executed detail DW test scripts and Test cases based on the Mapping Design documents.
• Co-ordination between offshore and onsite and escalation on any delay/issues to respective Manager.
• Write SQL Queries as per DW Design Mapping document to validate respective tables logic.
• Validating fields present in the reports are as agreed in specifications.
• Arranged meetings with business analyst in better understanding the DW Design Mapping documents Transformation Rules by using business naming conventions.
• UtilizedQuality Centerto map the Requirements, Test Cases to develop Requirement Traceability Matrix
• Performed various types of testing, such as Black box, Functional, SIT and Regression testing
• Determined testing scope and prioritized deliverables in different phases.
• Tested ETL process for both before data validation and after data validation process.
• Used database tools to transform data from various data sources like Oracle, SQL Server and flat files
• Work closely with Application Developer to adhere to the reports in timely manner. Any delay more than One day is escalated to avoid delay in testing.

Environment: HP Quality Centre (9.0), Informatica, Business Objects XI R2 and SQL2005, Oracle 11i and Teradata

Confidential

Responsibilities:

• UtilizedQuality Centerto map the Requirements, Test Cases to develop Requirement Traceability Matrix
• Performed various types of testing, such as Black box, Functional, System and Regression testing
• Go through the DW Mapping Design documents to create multiple test cases based on documents to validate DW data with respective DW Tables.
• Tested loaded data warehouse components like ODS (Stage), EDW and data marts tables after the jobs run.
• Tested the messages published by ETL tool and data loaded into various databases.
• Transformed data from various data sources like SQL, Oracle and flat files
• Work closely with DW Developers to follow up on open defects to close within the time line.
• Written SQL queries for checking the Data Transactions based on DW Mapping Design documents.
• Extensively worked with GUI, functional testing and methodologies.

Environment: SSIS, SQL2008, Oracle 10g, and Cognos

Confidential

Responsibilities:

• Established the business analysis methodology using Iterative model of SDLC.
• Facilitate System, Regression and User Acceptance Testing.
• Created and executed detail function test scripts and Test cases based on the business requirements.
• Responsible for Data Mapping testing by writing SQL Queries.
• Validating fields present in the reports are as agreed in specifications.
• Arranged meetings with business customers in better understanding the reports by using business naming conventions.
• Involved in validating the aggregate table based on the rollup process documented in data mapping.
• Wrote and executed detailed test cases including prerequisites, detailed instructions and anticipated results
• Created multiple test scenarios based on business rules to create data driven testing
• Performed various types of testing, such as Black box, Functional, System and Regression
• Determined testing scope and prioritized deliverables in different phases.
• Tested data warehouse components, data marts, testing of Dimension and Fact loads.
• Tested 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.
• Extensively used ETL SSIS to load from operational system (Oracle database) and flat files into the target data warehouse.
• Transformed data from various data sources like Oracle, flat files
• Work closely with Application Developer to adhere to the reports in timely manner. Any delay more than One day is escalated to avoid delay in testing.
• Written SQL queries for checking the Data Transactions and Database Integrity in Oracle.
• Extensively worked with GUI, functional testing and methodologies

Environment: HP Quality Centre, SSIS, Oracle and SQL2005,