Developer Data

MathuMathi Jeyaprabahar

Senior ETL Analyst / QA Analyst

Email ID: **********@*****.***

Mobile: 407-***-****

Professional Summary:

Over 6+ years of experience in Quality Assurance in Information Technology, involving analysis, both Manual and Automation testing of client server and web applications.

Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.

Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support).

As a QA Analyst – Worked on various industry verticals – Financials, Restaurants, Telecommunications and Banking

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.

Experience in using Automation Tool: Quick Test Professional (QTP),Quality Center (QC) Client/Server.

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 testing ETL experience using Informatica 9.5 .

Excellent Knowledge of Database Systems – Oracle 10g, SQL server, DB2 and Data ware house concepts.

Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.

Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.

Experience in RDBMS, Oracle (PL/SQL), MYSQL and associated SQL Programming Knowledge.

Extensive Working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts.

Experience in Business Intelligence testing in reports using Business Objects

Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint), Ms-Access, MS Visio.

A very good team player with excellent Communication (Verbal and Technical), Presentation and reporting skills.

TECHNICAL SKILLS

Testing Tools

HP Quality Center 9.0/11.0 (ALM), QTP 9.0

Databases

Oracle 9i/12c, Teradata, SQL Server 2007.

Languages

Informatica, SQL, PL/SQL UNIX Shell Scripting.

Tools

TOAD, SQL*Loader

Web Technologies

HTML, Apache, Java Script, CSS

Operating Systems

Windows, LINUX

Professional Experience:

Client: Darden, Orlando, FL Jun 2018 – Till date

Sr. ETL Analyst / QA Analyst

Responsibilities:

Developed Test Plans, test scripts and executed the test scripts for Darden –Adobe campaign Project.

Thorough out the project in various iterations/Sprints – conducted system testing, integration testing, functional testing and 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

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Extensively interacted with developers, business& management teams to understand the OPM 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.

Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)

Defects identified in testing environment 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.

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support

Setting up, monitoring and using Job Control System in Development/QA/Prod

Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,

Scheduling and automating jobs to be run in a batch process

Effectively communicate testing activities and findings in oral and written formats

Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts

Extracted data from various sources like Oracle, flat files and DB2 server.

Worked on issues with migration of Data from development to QA-Test Environment

Environment: Oracle 10g/11g, Informatica Power Center 9.5, HP QC 9.0/11.0, SQL developer, SQL and PL/SQL

Client: Raymond James, St. Petersburg, FL Feb 2016 - May 2018

ETL Analyst/SQL Tester

Responsibilities:

Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications

Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Performed data quality analysis using advanced SQL skills.

Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.

Extensive SQL querying on Staging, Datawarehouse and DataMart.

Ensured Error logs and audit tables are generated and populated properly

Performed UAT and Regression Testing.

Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Tracking and reporting the issues to project team and management during test cycles.

Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.

Contribute in the development of knowledge transfer documentation.

Environment:, Oracle 9i, PLSQL, Business Objects, UNIX,LINUX .

Client: Key Bank, Cleveland, OH(Remote) Aug 2013 – Jan 2016

Company: iGATE Technologies Chennai, India

ETL Tester

Responsibilities:

Reviewed Business Requirement Document (BRD) for accuracy and Completeness.

Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications

Created the use cases, activity diagrams and sequence diagrams.

Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.

Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.

Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and TestData.

Worked with IT Development team to ensure feasibility of design and clarify user requirements.

Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.

Performed Data Analysis and developed Data Mapping documents for ETL projects.

Developed Test Cases and SQL Queries to perform various Validations.

Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.

Performed Unit Testing, Integration Testing, User Acceptance Testing and Requirement Testing.

Executed Test Cases with respect to Source and Target database tables.

Written SQL queries tovalidate reports against the database.

Extensive SQL querying on Staging,Datawarehouse andDataMarts.

Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Validated reports based on Functional Requirements.

Checked the reports for any naming inconsistencies and to improve user readability.

Environment: Informatica,Oracle PLSQL,TOAD 9.5, MS Office, Windows Agile Scrum, Web services, HTML and JavaScript

Education: Bachelor’s in Computers Science from Anna University, India.

Contact this candidate