Profile

• Overall 9 & 1/2 Years of experience in System Integration Testing of Web & ETL Applications.
• Having 6 years of experience in Data Warehousing (ETL) Testing.
• 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 and having knowledge on PLSQL
• 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

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.

Database Tool

Toad and MS Access

ETL Tool

Informatica Power Centre 8.6.1, Data Stage & SSIS(SQL Server Integration Services)

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

GUI

HTML, CSS, JavaScript 3.0.3 and XHTML.

Others Tools

Having good knowledge on ANT1.4/1.5, PVCS, CVS

• Masters in Computers Applications
• Bachelor’s Degree in Computers Science

Client Confidential,KanSas City MO Nov 2011 to Present
Position Sr ETL Tester/Module Lead

Project Description

Module: Alineo 3.2

The scope of the project is to Migration from Other System Alineo3.2 to existing applications BCBS COMMON, which are used by the entire organization.

Module: MPI (Master Patient Index)

The scope of the assignment is to bring up the best feasible solution for hygienic/exclusions across the BE keys to raise up the fresh BE keys for the members. The process includes the effort for elimination of duplicates/cleanup the un-structured flow of programs/streamline the processing database with consolidation of data integrity. .

Module: PCMH (Patient Centered Medical Home)

The scope of the project to enclose a PCMH feature which gives connectivity between the two legacy systems for a business indeed within BCBS.

My 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 Target(IDS)/data validation from Source (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 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,KS Jul 2009 to Nov 2011
Position Sr ETL Tester

Project Description

GOAL- Globalization of Application Landscape

The scope of the project is to Migration the existing applications (Claims, Finance, Legal and Underwriting policy) which are used by the entire organization.

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

Position ETL Tester

Project Description

Module: Inventory Reports

The scope of the project is to ENHANCE the existing reports, which are used by the entire organization.

My 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,Monterey Park CA June 2006 to June 2008
Position ETL Tester

Project Description

Module: CDW

The scope of the project is to ENHANCE the existing Systems, which are used by the entire organization.

My 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.
• Incremental testing of Enterprise Data Warehouse.
• 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 Informatica 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, Informatica, DB2, Oracle and SQL2005,

Confidential, San Jose, CA Jan 2005 to Feb 2007
Position QA Tester

Project Description
Package Manager is related to group of readymade products. Instead of ordering for individual products, now the customer can order for the entire package. A package is a group of products grouped according some criteria. Package differs from product list in the way,

My 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.