SUMMARY

• QA Analyst with 11 plus years of experience majorly in to Data warehouse testing, Big Data Framework and business intelligence reports testing. Posses diverse experience in domains: insurance, banking, financials, mortgage and supply chain management. Possess good experience in implementing, monitoring, enforcing and documenting all processes for testing as per standards defined by the organization.
• Technically sound in understanding data model, data - warehouse architecture and posses wide experience in tracking and preparing the reports of testing activities like test execution results, test case coverage, required resources, defect management, performance baselines etc.
• Extensive experience in ETL/ Data warehouse testing and BI Intelligence reports testing.
• Strong knowledge of Agile Methodology and Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support)and agile scrum methodolgies
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Experience in preparing test reports from Quality Center and prepared daily test status reports to communicate the test status with the team.
• Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Experience working in AWS environment using various features of Amazon web services such as S3, listener, sequencer, executor, EMR, ECS.
• Intermediate level of coding skills in Python 3.7.
• Experience in leveraging Python 3.7 for regression testing and automation of the ETL tests.
• Extensive ETL testing experience using Informatica 8.1/7.1/6.2 and10.1 (Power Center/ Power Mart), Ab-initio.
• Experience in executing the autosys jobs for ETL.
• Extensive reports testing experience using OBIEE 10g, 11g, Micro Strategy 10.4, 10.11
• Extensive Knowledge of Database Systems - Oracle 11g, 10g, 9i, Teratada 15.10, SQL server 2012, 2008.
• Experience with Big data and corresponding tools - Impala, HIVE and Big Data Framework.
• Ability to handle multiple tasks and have strong organizational and time management skills.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Worked on various industry verticals - Insurance, Banking,Financials and Mortgage.
• Strong Knowledge of Data warehousing concepts, Relational Database Management Systems and Dimensional modeling (Star schema and Snowflake schema).
• Experience in reconciliation of data between EBS and data warehouse / reports.
• Exposure in PL/SQL and UNIX shell scripting.
• Strong problem-solving skills. Good Analytical, communication and interpersonal skills.
• Good track record of being a team member and leading a team.
• Excellent communication, interpersonal, analytical skills and strong ability to lead a team.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 9.0/11.0 (ALM), JIRA

Databases: Oracle 8i/9i/10g/11g/12c, DB2 8.0/7.0, SQL Server 2012/2008, Teradata 15.10

Utility Tools: SQL Developer, TOAD, SQL Plus, SQL Assistant (Teradata)

Big Data Tools: Impala, Hive

ETL Tools: Informatica 10.1 and other versions, Ab-initio, Oracle warehouse builder

Reporting Tools: OBIEE 10g, 11g reports, Microstrategy 10.4, 10.11

Programming Languages: Python 3.7, PL/SQL, VBA, C, and C++

Scripting Languages: UNIX

Data Modeling Tools: ERWin

Operating Systems: Windows XP/2000/2007, Linux

Other tools and utilities: Autosys

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Senior ETL Tester

Responsibilities:

• Develop ETL test scripts based on technical specifications/Data load documents and Source to Target mappings for Data Mart project at the client side.
• Develop complex SQL queries using Toad for Oracle or SQL developer to validate ETL process and ensure data flow from source database(MFDW) to target database(MFDM/TSDM) is as per the business requirements.
• Analyze and review Informatica (ETL) mappings to understand the technical implementation of business rules.
• Perform system integration testing of ETL process to validate the data flow from source system to target system and reconcile data between source and target systems.
• Run and monitor the ETL jobs via autosys. Make configuration changes related to autosys to suit the testing needs.
• Validate ETL jobs on AWS environment such as Redshift database.
• Use AWS tools including S3, Sequencer, EMR, ECS etc.
• Create valid test data either by using test data generator tool or by using SQL scripts to cover all the test scenarios including negative test cases.
• Create defects identified in the testing process in JIRA for defect management purpose.
• Conduct walkthrough of the defects to all the stakeholders of the project on a regular basis.
• Participate in daily stand up calls and provide high level status on a day to day basis.
• Perform regression testing on a regular basis to ensure that the existing functionality is not broken due to new deployments /code changes.

Confidential, San Francisco, CA

Senior ETL Tester

Responsibilities:

• Define the scope of testing and scenarios to be covered for ETL related stories such as data validation between source and target systems, validations of the transformation logic, flat file data transfers, and validation of various measures loaded into the fact tables at the database level.
• Preparation of a broad level QA / Test strategy document which lists out different areas- data marts, schemas, BI dashboard under test and different methodology in testing it should follow while performing actual QA task.
• Prepare test plan covering the ETL functionality to be tested and estimate the testing effort including both ongoing testing and regression testing. Identify the facts, dimensions, aggregate tables and other database objects that need to be tested. Specify at high level the critical metrics, KPIs that would be covered as part of the testing.
• Develop test scripts for end to end testing of the upgrade of Micro strategy reports from version 10.4 to 11.1.
• Prepare test scripts for business intelligence reports depending on the BI tools: Micro strategy 10.4, 11.1.
• Reviewing User Stories to ensure technical accuracy, compliance and/or completeness and to mitigate risk.
• Validate data movement from multiple source systems ( Oracle 12C, Teradata 14.2, Impala ) to target systems (Teradata 14.2, Impala) using SQL / PL SQL queries based on technical design documents, source to target mapping specification.
• Automate ETL test validation to the extent possible by using Python 3.7
• Reconcile data between source and target systems or between various enterprise applications (such as database versus reporting layer) by leveraging SQL / PL SQL queries as part of data completeness testing.
• Validate data in the BI reports with ETL layer. Build ad-hoc reports in the BI tool and validate the data of ad-hoc reports.
• Identify data mismatch instances between sources and target database systems or between flat file and target tables.
• Analyze the root cause of the data mismatches between source and target systems or between various enterprise applications. Determine if the data mismatch is because of the defects in the ETL functionality or at the reporting layer (BI tool).
• Develop complex unix commands / shell scripts to test the data flow from flat files to database tables and vice versa.
• Prepare test cases to test each of the ETL components / objects such as facts, dimensions, aggregate tables, views or other database objects, tables and various fields in them.
• Design ETL specific test scripts to evaluate the performance of data movement between source and target systems, response time of data retrieval.
• Prepare complex SQL, PL/ SQL scripts as part of test cases to validate the BI reports, ad-hoc reports data, ETL functionality depending on data load scenarios such as full load, incremental load (refresh).
• Analyze if there are any gaps in the business rules or check if any of the business rules are contradicting each other. Validation of the business rules either from ETL perspective or business intelligence reports during the corresponding test execution phase.
• Performing integration testing of ETL processes to validate the flow from source systems to target systems and reconciling information between the systems.
• Extensively leveraging various unix commands such as grep, find, sed, cmp, awk to complete data movement validations from flat file to database and vice versa.
• Develop SQL / PL SQL test scripts to automate the ETL functionality testing to the extent possible by leveraging tools such as TOAD, SQL advantage etc.
• Identify root cause of each of the defects if possible and suggest the fixes to be implemented for resolving the defects in a timely manner.
• Document the test results and defects in detail using JIRA 7.8 software or other test management tools.

Confidential, Herndon, VA

Senior ETL Tester

Responsibilities:

• Develop ETL test scripts based on technical specifications/Data load documents and Source to Target mappings for Data Mart project at the client side.
• Develop complex SQL queries using Toad for Oracle or SQL developer to validate ETL process and ensure data flow from source database(MFDW) to target database(MFDM/TSDM) is as per the business requirements.
• Analyze and review Informatica (ETL) mappings to understand the technical implementation of business rules.
• Perform system integration testing of ETL process to validate the data flow from source system to target system and reconcile data between source and target systems.
• Run and monitor the ETL jobs via autosys. Make configuration changes related to autosys to suit the testing needs.
• Create valid test data either by using test data generator tool or by using SQL scripts to cover all the test scenarios including negative test cases.
• Create defects identified in the testing process in JIRA for defect management purpose.
• Conduct walkthrough of the defects to all the stakeholders of the project on a regular basis.
• Participate in daily stand up calls and provide high level status on a day to day basis.
• Perform regression testing on a regular basis to ensure that the existing functionality is not broken due to new deployments /code changes.
• Assist the test lead in preparing the test strategy document. Prepare the test closure report after completion of testing for the corresponding release.
• Apply mortgage industry domain knowledge to the extent possible to develop functional test scenarios.
• Automate regression test execution to the maximum extent by using Python 2.7 and Data Testing Framework (DTF tool - client side inbuilt tool).
• Prepare test execution status report and communicate to QA Lead and Manager on a regular basis. Identify,analyze and communicate risks associated with project to QA manager and other stakeholders.

Confidential

Test lead

Responsibilities:

• Developed Test Plans, test scripts and executed the test scripts for EFR DW Project.
• Lead a team of 5 members successfully.
• Throughout the project in various iterations - conducted system testing, integration testing, functional testingand integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application of the client.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Targetmappings.
• Extensively interacted with developers,business teams to understand the project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Administrate project review, escalations, quality assurance, tasks’ completion, project deliverables, customer interface; project status reporting for the project.
• Reconciliation of data between EBS and data warehouse / reports.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM).
• Defects identified during test execution phase are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Conduct walkthrough of the defects in the defect triage calls to all the stakeholders of the project.
• Created test cases for ETL mappings and design documents for production support.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Build easy to medium complex Macros (VBA) to automate test execution to the extent possible.
• Report weekly and daily test execution status to QA Manager.
• Identify and raise risks from QA perspective.

Confidential

Tester

Responsibilities:

• Design and document Data warehouse (EDW) testing strategy covering the test cases for validating the data completeness and correctness of the ETL processes etc.
• Analyze and review Informatica (ETL) mappings to understand the technical implementation of business rules.
• Build test queries with multiple joins, indexes, temporary tables, analytical functions, and sub queries linking by unions, intersection, and minus operators etc.
• Administrate project review, escalations, quality assurance, tasks’ completion, project deliverables, customer interface & project status reporting for the project.
• Test Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to test the functionality for various modules.
• Scheduling defect triage meetings to keep track and level of severity defects and communicating it to project manager with execution score card with defect status.
• Provide technical know-how, support, mentoring & coaching team members on technology, business & other project specific aspects.
• Conducted Defect walk through with the development team for clear understanding for defects and to make it to closure.
• Log and publish the test results and raise the defects to the mantis defect/change management system.
• Use UNIX scripts to test the data loaded in to data warehouse.
• Created scripts to test the database objects such as tables, views, queries for new enhancement in the application using SQL developer.
• Develop Macros in excel using Visual Basic for Applications (VBA).

Confidential

Quality Engineer

Responsibilities:

• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Developed reports test scripts based on the technical specifications / functional design documents.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Tested the ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the database.
• Execute Test Scripts and report the defects using Quality Center.
• Reconciliation of data between EBS and data warehouse / reports for Financials and SCM Modules.
• Tested the OBIEE reports data with the database and in some scenarios with the source system directly.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Effectively communicate testing activities and findings in oral and written formats.
• Analyze the data models generated from tools such as ERWin.
• Functional testing using the J Meter tool.
• Provide feedback on the data models before the start of coding by developers.
• Develop Macros using Visual Basic for applications for automation of files, reports generation in excel.
• Develop SQL, PL/ SQL scripts to validate the data populated in data warehouse tables of Oracle.
• To test that the Data warehouse tables are getting populated as per the business logic.
• Prepare Daily Status Report, Weekly status report for internal reference.
• Provide QA approval before production release.

Confidential

Software Engineer Trainee

Responsibilities:

• Completed training in various software development technologies such as Oracle, Visual Basic.
• Involved in full development life cycle of planning, analysis, design, development.
• Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Created tables, indexes on tables to improve performance by eliminating full database scans.
• Worked on SQL Server 2005, 2008.