SUMMARY:

• Over 9 years of Software Quality Assurance (QA) experience in Data Warehouse (ETL & BI)
• Experience in defining testing methodologies; Creating test plans and test cases, Verifying and validating application software and documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• In depth technical knowledge and understanding of Data Warehousing, Hadoop Ecosystems, UNIX, SQL, HDFS, HIVE, Hue, Oracle, XML, Teradata.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification, and Identifying Data Mismatch.
• Involvement in all phases of STLC (Systems Testing Life Cycle).
• Strong working experience on Extraction, Transformation, and Load (ETL) of data from Legacy systems using Informatica and Ab Initio.
• Extensive experience with Analysis, Test case plan designing, Metadata designing, Designing Mapping sheet, ETL Designing, Testing, Bug Analysis, Bug Reporting and Re Testing and UAT.
• Good experience in working with Onsite - Offshore team model projects.
• Tested data, extracted from various sources like Oracle, Flat file, XML, SQL SERVER, and loaded into Flat File and Oracle database.
• Work extensively with Slowly Changing Dimensions & Audit Table.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion, and loading
• Well versed with Manual Testing Methodologies and Principles.
• Application Data Warehousing experience in Healthcare, Telecom and Retail domain.
• Worked on Agile Methodology.

TECHNICAL SKILLS:

Core Skills: Big Data, ETL and Data Warehouse Testing

ETL Tools: Ab Initio GDE 3.7, Informatica Power Center 9.x

Utility Tools: Hue, HIVE, HDFS, TOAD, PUTTY, Teradata SQL Assistant, SQL Developer, Control M Workload Automation, JIRA, Tortoise SVN

Databases: Teradata, Oracle 11g, SQL SERVER 2008, MS Access

Programming: SQL, PL/SQL

Environment: Windows, UNIX (AIX 5.2), MS DOS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT, and Dimensions Tables, Physical and Logical Data Modeling

Microsoft Office: Word, PPT, Excel

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

ETL Tester

Responsibilities:

• Involved in XML validation against Source
• XML validation in Hadoop system
• Involved in creating dummy XML files
• Involved in Data Quality testing
• Bug Reporting and Retesting

Environment: Hadoop Ecosystem, Hue, HIVE, HDFS, Unify, Oracle, XML files

Confidential

ETL Tester

Responsibilities:

• Involved in Requirement Analysis, Review, and Testing Strategy Preparation
• Test plan and Test Case preparation on the scenario by business
• Involved in creating dummy test data
• Involved in running Jobs using ab initio graphs
• Involved in functional testing and regression testing
• Involved in Data Analysis and Data Validation
• Bug Reporting and Retesting

Environment: Ab initio GDE 3.2.7.2, Oracle 11g/10g, Tera data, PUTTY, SQL

Confidential, San Francisco, CA

ETL Tester

Responsibilities:

• Involved in running jobs for the data created by upstream to SDM using Ab Initio
• Involved in functional testing and regression testing
• Involved in Data Analysis and Data Validation
• Bug Reporting and Retesting

Environment: Ab initio GDE 3.2.7.2, Oracle 11g/10g, Tera data, PUTTY, SQL

Confidential, San Francisco, CA

ETL Tester

Responsibilities:

• Involved in Requirement Analysis
• Involved in creating Test plan and Test Case preparation on the scenario by business
• Involved in running jobs for the data published to stage by upstream
• Involved in Smoke Testing and Regression testing
• Involved in Data Validation
• Bug Reporting and Retesting

Environment: Ab initio GDE 3.2.7.2, Tera data, SQL, PUTTY

Confidential, Louisville, KY

ETL Tester

Responsibilities:

• Ensured processes are followed at all stages of Software Testing Life Cycle.
• Involved in Requirement Gathering including Attribute Analysis which helps in Designing Data Model.
• Designing Metadata including Table Doc and Table Attribute Document.
• Involved in Test Case Planning.
• Involved in designing ETL Mapping Sheet.
• Involved in Designing Dummy Test Data for 835 and 837 medical claims.
• Involved in Source to Target Validation.
• Responsible in Designing and Validating Mapping Sheet for data (Source XML)
• Involved in Requirement Review and Testing Strategy Preparation.
• Bug Reporting and Retesting.

Environment: Informatica Power Center 9.5, Oracle 11g/10g, TOAD, XML and SQL

Confidential

Quality Analyst

Responsibilities:

• Ensured processes are followed at all stages of Software Testing Life Cycle.
• Involved in Designing Dummy Test Data.
• Involved in Designing Test Cases.
• Involved in Requirement Review and Testing Strategy Preparation.
• Bug Reporting and Retesting

Environment: VB.Net, Web 2.0, SQL Server 2000/2005/2008, ASP.Net

Confidential

Quality Analyst

Responsibilities:

• Ensured processes are followed at all stages of Software Testing Life Cycle.
• Involved in Designing Dummy Test Data.
• Involved in Designing Test Cases.
• Involved in Requirement Review and Testing Strategy Preparation.
• Bug Reporting and Retesting

Environment: Oracle forms 6i