SUMMARY

• Overall 9+ Years of experience in SDLC, QA Lifecycle, testing of Web applications, Data Warehousing and Business Intelligence (BI) applications Having 7+ years of experience in Data Warehousing (ETL) Testing.
• In depth knowledge of Data warehousing concepts, Dimensional Data modelling, Star schema and Snow flake schema
• Experience in All modules of Facets 4.31 and Facets 4.71.
• 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
• Have 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.
• Having good experience on Banking (BFS), Insurance and Health Insurance domain
• Good understanding of ETL Test Processes and Test Methodologies.
• Expert in writing SQL, working on 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.
• Experience in Black Box Testing, Data Driven Testing, Regression Testing, Back End and Front End Testing, Functionality Testing, UAT, Integration and System Testing.
• 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, DB2 Mainframes 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 and SharePoint(Having good knowledge on TFS)

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

Application Server/Web Server: Apache Tomcat 3.3, IBM WebSphere Application Server 5.x/6.x, JBoss4.0.3 and WebLogic 7.0,8.0,9.0

Web Services: SOAP

IDEs: Eclipse 2.x/3.x, WSAD 5.0/5.1 and RAD 6.0/7.0.

Framework: Struts 1.1/1.2/2.0

Database: Oracle 8i/9i/10g, IBM DB2, SQL 2008,T-SQL,Sybase and Teradata V2R5/V2R6 and MS Access.

Database Tool: Toad and MS SQL

ETL Tool: Informatica Power Centre 8.6.1, Data Stage, SSIS(SQL Server Integration Services) and SAP DS

Reporting Tool: Business Objects XI R2 and Cognos

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

J2EE Technologies: JDBC 2.0, Servlets 2.1/2.4/2.5, and JSP 1.2/2.0/2.1.

Operating Systems: Linux, Windows 98/2000/XP/07

GUI: HTML, CSS, JavaScript 3.0.3 and XHTML.

Others Tools: ANT1.4/1.5, PVCS, CVS, Facets

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

Sr ETL Tester/ Test Lead

Responsibilities:

• Established the business analysis methodology using Iterative model of SDLC.
• Created and executed detail functions DW test scripts based on the DW Mapping Design Documents.
• Responsible for Data Mapping testing by writing SQL Queries.
• Involved in Delta load testing and compare source and target data.
• Involved in GAP Analysis as per requirements and communicate with our BA on finding GAP Issues.
• Arranged meetings with business customers in better understanding the reports by using business naming conventions.
• Work closely with DW Developer to follow up on defects to get closed within the timelines and the same to be informed to the customer.
• Coordinate with offshore team members to finish assigned work with in the time line.
• We will have weekly status meeting offshore &onshore team members.
• Performed various types of testing, such as Functional, SIT and Regression testing.
• Data testing in SAP (Source) data to migrate properly load into Target NY PAL Studio system.
• Data testing in NY PAL Studio application (Source) data to migrate properly in Target NY PAL CI System.
• Involved RPT Database testing for EDW data with Reporting data.

Environment: Clear Quest, Informatica, SAP DS, SAP Business Objects XI R3, XML, SAP,SQL Server 2008 and Oracle

Confidential

Sr ETL Tester

Responsibilities:

• Established the business analysis methodology using Iterative model of SDLC.
• Created and executed detail functions DW test scripts based on the DW Mapping Design Documents.
• Responsible for Data Mapping testing by writing SQL Queries.
• Arranged meetings with business customers in better understanding the reports by using business naming conventions.
• UtilizedClear Quest tool to create defects and assign to respective Developer.
• Performed various types of testing, such as Functional, SIT and Regression testing
• Determined testing scope and prioritized deliverables in different phases.
• Tested data warehouse components, data marts, testing of Dimension and Fact tables.
• Tested Claims data in Facets.
• Extensively used ETL Data Stage to load from different source systems and load into the target data warehouse.
• Work closely with DW Developer to follow up on defects to get closed within the timelines and the same to be informed to stake holder.
• Ensured the process oriented steps to get the job done within the timelines to avoid un-interrupted business service/requirements.

Environment: Team Room, Clear Quest, Data Stage, Cognos, XML, DB2 and Teradata

Confidential

Sr ETL Tester/ Lead

Responsibilities:

• Established the business analysis methodology using Iterative model of SDLC.
• Design and Develop Test Plans for different application releases.
• Created and executed detail functions DW test scripts based on the DW Mapping Design Documents.
• Validate Claims data which is coming from Facets System to Source Systems(Alineo, PCMH and MPI)
• Data Validation from Difference Sources(Alineo, PCMH & MPI) to Stage(IDS)/data validation from Stage (IDS) to Target(EDW)
• Responsible for Data Mapping testing by writing SQL Queries.
• Arranged meetings with business customers in better understanding the reports by using business naming conventions. Coordinate between Offshore and Onshore team.
• UtilizedDaptivetool to create defects and assign to respective Developer.
• Performed various types of testing, such as Black box, Functional, SIT and Regression testing
• Determined testing scope and prioritized deliverables in different phases.
• Tested Claims data in Facets.
• Tested data warehouse components, data marts, testing of Dimension and Fact tables.
• Extensively used ETL Data Stage to load from XML and flat files into the target data warehouse.
• Transformed data from various data sources like XML and flat (.DAT,CSV)files
• Work closely with DW Developer to follow up on defects to get closed within the timelines and the same to be informed to stake holder.
• Ensured the process oriented steps to get the job done within the timelines to avoid un-interrupted business service/requirements.
• Written SQL queries for checking the Data Transactions.
• Extensively worked with GUI, functional testing and methodologies for creating test data.

Environment: SharePoint, Daptive, Data Stage, Facets, Business Object XI R2, XML, XSD, Oracle 10G, Sybase, T-SQL and DB2.

Confidential, Overland Park, KS

ETL Tester

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 data warehouse components, data marts, testing of Dimension and Fact tables.
• Tested ETL process for both before data validation and after data validation process.
• Extensively used ETL Informatica to load from operational systems and flat files into the target data warehouse.
• Transformed data from various data sources like Oracle, SQL2005 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 Object XI R2 and SQL2005, Oracle and Teradata

Confidential

ETL Tester

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.
• Extensively used ETL (SSIS) tool to load from operational systems and flat files to target data warehouse environment.
• 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 8i, Teradata and Cognos

Confidential

ETL Tester

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, DB2, Oracle and SQL2005

Confidential

QA Tester

Responsibilities:

• Analyzed the Business Requirement Documents, make additions in the test plan and prepared detailed test cases.
• Design and Develop Testing Strategy and Plans for current and forthcoming releases.
• Create test cases and review the test scripts created by the test team
• Manage Builds and Releases going into QA environment
• Organize regular business sponsor, process owner and, client representative meetings to keep the information flowing and communication channels clear and baseline expectations.
• Plan and conduct both Functional and Regression testing activities
• Setting up of test data by entering transactions/trades and executing Batch Jobs
• Mentor and manage test resources, facilitate training and learning sessions both onsite and offsite.
• Participate in project planning meetings and outline priorities together with the Project and Technology team.
• Provide accurate and precise estimates to the project management team, and raise any risks, with possible solutions to mitigate.
• Coordinate with business, technology and project teams spread across sites and manage application release into SIT, UAT and plan production releases.
• Coordinate with business users and provide support for the UAT testing and reporting.

Environment: Quality Centre, Java, J2EE, Websphere and Oracle 8i.