Lakshmi K

ETL QA Lead

adbtub@r.postjobfree.com

937-***-****

Allen (75013)

Professional Summary:

A technically competent professional with 13 years of experience in end-to-end Data Warehousing (ETL, DWBI) and Business Intelligence Testing projects.

Managed QA/Test Program/project teams of Test Leads, subject matter experts, testers, both onsite and remote/offshore teams for ETL and Reporting application areas.

Responsible for estimating/forecasting, resourcing, process/deliverable quality reviews, test design, test environment set up, test plan/script creation, test execution and implementation of large and complex projects spanning multiple applications.

Participated in governance process, reported testing progress/test results, conducted triage meetings with business/BAs, development, project management and test teams to prioritize & close defects in a timely manner.

Developed and maintained the Quality Assurance Program Plan and implemented the documented quality and testing policies, plans, and processes to support the plan.

Experience in testing within an Azure based environment.

Coordinated with Project Managers to ensure problem identification, resolution, and tracking. Recommended quality improvements or changes to senior management, developing processes, procedures, and systems and software work products to correct potential deficiencies.

Determined staffing requirements, allocated staff accordingly, and ensured that projects are staffed to succeed. Coached and mentored testing team members in testing methodologies, documentation, compliance and best practices.

Demonstrated leadership to go above and beyond the call of duty to deliver quality software. Kept abreast of technical trends with regard to Quality Assurance and evaluated their value for improving software delivery process.

Managed end-to-end testing spanning several projects to make sure all the integration points were working per business processes/requirements. Experience with performing IT Audits.

Proficient in Relational database Oracle, MS SQL Server SQL, Teradata, DB2, Data Warehousing concepts and ETL Concepts.

Extensive ETL/CUBE/ BI testing .

Experience in large scale application development testing.

Extensive experience with both data migration and data transformation testing

Experience leading teams towards automation and performance using risk-based testing approach

Preparing, managing time estimates and fixed bid deliverables (SOW).

In depth Knowledge about Agile/SCRUM environment.

Experience testing OLAP data warehouse and integrations/BI processes.

Tested customized reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options [drill up, drill down and drill anywhere].

Familiarity with database design, test script automation, TFS and data testing.

Experience in JIRA, ALM and TFS.

Expertise in Data warehouse concepts and technologies like OLTP, OLAP, Normalization/De-normalization, Data Models (Star/ Snow Flake Schemas), DataMart (Dimensions and Facts) and Reporting.

Good understanding of Dimensional modelling, Dimensions, Facts, Star/Snowflake schemas, Online Transaction Processing Systems (OLTP), Online Analytical Processing Systems (OLAP), data mining and data migration capabilities.

Technical skills:

Conceptual knowledge : Data warehouse/Data lake Concepts

ETL Tools : Data stage, Informatica Power center,Oracle Warehouse Builder,SSIS.

Reporting Tool : Power BI,SSRS,Business Objects, Cognos,Microstartegy

Test Management Tool : Quality Center,TFS,Jira

Database : Oracle, MS SQL server,DB2,T SQL, Teradata,MY SQL,U SQL.

Scheduling Tool : Control –M Enterprise Manager

Other Tools : AQT, TOAD

Methodologies : Agile,Scrum, Waterfall

Certifications:

External Certification : Oracle 9i SQL

External Certification : Oracle 9i PLSQL

External Certification : Oracle 11g SQL

External Certification : ISEB ISTQB Foundation certificate in Software Testing

External Certification : Informatica Power Center.

Internal Certification : CCP (Cognizant Certified Professional) Data warehouse

Internal Certification : CCP Level 0: Life Sciences

Internal Certification : CCP Level 0: Retail

Project Summary:

IntrinsiQ - AmerisourceBergen, Frisco, TX Apr 2018 – Present

Role: ETL QA Lead

Responsibilities:

Serve as Quality Assurance Test Lead for the creation of a data warehouse using MS SQL 2017 and TFS On- Prem and then migrating to the Azure Data Lake.

Perform analysis to establish and document current and future processes, requirements, and technical specifications.

Responsible for the creation, execution, and documentation of the Master Test Plan, Detailed Test Plan.

Use T-SQL and U-SQL for ETL Validation of data from Raw to CDM and from CDM to the CDW.

Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.

Delegated QA meetings with the team and Project Management.

Experience in testing within an Azure based environment.

Identifying and analyzing quality risks.

Determining testing scope using risk-based testing approach.

Ability to react to changing project plans and come up with creative alternatives.

Reviewing supplier deliverables and providing feedback and direction.

Preparing and facilitating the implementation of test plans

Participated in walkthrough meetings and defect report meetings periodically with the client.

Recommended finely-tuned changes to meet all guidelines.

Used strong time-management skills to juggle around multiple projects simultaneously.

Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.

Mentored new QA resources to understand the business process and our test methodologies.

Environment: SSIS,Azure,Datalake,Cloud,U SQL,Power BI,TFS.

Pier1 Imports, Fort Worth, TX Jan 2018– Mar 2018

Role: ETL QA Lead

Responsibilities:

Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution writing complex SQL.

Functioned as the Onsite / Offshore coordinator and Team Lead

Involved in analysing the requests for new, enhanced, and modified systems, against user and business

requirements.

Prepare RTM, Test Plan, Defect report status.

Expertly handles last minute requests and stressful situations

Developed test strategy based on design/architectural documents, requirements, specifications and other documented sources

Developed test cases and test scripts based on documented sources.

Exposure to all stages of SDLC, STLC and Defect Tracking.

Written SQL Queries extensively for Data validation.

Ability to react to changing project plans and come up with creative alternatives.

Reviewing supplier deliverables and providing feedback and direction.

Preparing and managing the project testing schedule

Preparing and facilitating the implementation of test plans

Participated in walkthrough meetings and defect report meetings periodically with the client.

Recommended finely-tuned changes to meet all guidelines.

Used strong time-management skills to juggle around multiple projects simultaneously.

Environment: SSIS,SQL Server,Power BI,Rally.

Belk, Charlotte, NC Sep 2013 – Dec 2017

Role: ETL Test Lead

Responsibilities:

Preparing detailed test strategy, test plan, test scripts and test cases by understanding the business logic and user requirements.

Coordinated testing readiness effort, including creation of test plans, test cases and test scripts.

Work with process team to confirm business requirements associated with testing effort

Analyzed the System Design Document, Software Specification Document and prepared System test plan by dividing the application into manageable units.

Experience in testing within an Azure based environment.

Performed Traceability Matrix to fix discrepancies in BRD and Test plan.

Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.

Delegated QA meetings with the team and Project Management.

Prepare RTM, Test Plan, Defect report status

Conduct defect review meetings.

Lead different master detail, summary reports, ad-hoc reports and on demand reports.

Identifying and analyzing quality risks.

Determining testing scope using risk-based testing approach.

Ability to react to changing project plans and come up with creative alternatives.

Preparing, managing time estimates and fixed bid deliverables (SOW).

Reviewing supplier deliverables and providing feedback and direction.

Assessing Risk to schedule, cost, or quality on project and testing engagement.

Preparing and managing the project testing schedule

Preparing and facilitating the implementation of test plans

Participated in walkthrough meetings and defect report meetings periodically with the client.

Recommended finely-tuned changes to meet all guidelines.

Used strong time-management skills to juggle around multiple projects simultaneously.

Environment: Datastage8.5,Teradata 12.0,DB2,Business Objects, Quality Center.

Cognizant Technology Solutions:

Marks and Spencer,London,UK Jun 2012 – Aug 2013

ETL/BI Test Lead

Responsibilities:

Requirements study in testing perceptive, understanding the functionality and scope of the application.

Worked as lead for entire release.

Involved in analysis of end user requirements and business rules based on given preliminary design documentation and working closely with tech leads and data analysts in understanding the current system.

Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.

Functioned as the Onsite / Offshore coordinator and Team Lead

Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Datastage.

To understand the functionalities of the Business/Transactions

Prepare RTM, Test Plan, Defect report status

Conduct defect review meetings.

Authoring Test cases for mapping functionality of the designed warehouse.

Involved in complete verification of Data Harmonization/Migration.

Identification and Management of Defects using Quality Center.

Done active participation in conference-calls and meetings.

Handled entire responsibility of verifying the code in Test environment by testing them in different environments before deployment of code in Production.

Reviewed test results, issues and defects related to business units.

Organized the timelines for executing jobs to refresh data across all databases .

Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.

Designed automated test cases, test plans and executed tests using HP Quality Center.

Maintained latest version of test cases in Quality Center and ensured that was well communicated within the team.

Issue analysis and defect assignment to the development teams.

Trained new team members and also mentored them to understand the business process along with testing of data.

Environment: DB2, Data stage, Microstartegy, HP Quality Center.

Pfizer, New York, NY Jun 2010 – May 2012

DWH Test Lead

Responsibilities:

Designed the entire testing plan, test case scenarios and test cases for the business application based on functional documents and user stories.

Requirements study in testing perceptive, understanding the functionality and scope of the application.

Authoring Test cases for mapping functionality of the designed warehouse.

Involved in complete verification of Data Harmonization.

Involved in complete verification of Data Migration.

Identification and Management of Defects using Quality Center.

Written SQL Queries extensively for Data validation.

Done active participation in conference-calls and meetings.

Created test cases for Staging area.

Involved in complete verification of Staging area..

Developed test plan and test lab for the projects to create and access requirements, defects, test cases and reports for the status.

Conducted test case reviews and presented the test cases/test scenarios to the team members for all iterations.

Performed all aspects of verification, validation including functional, structural, regression, load and system testing

Written complex SQL queries for data validation for verifying the ETL Mapping Rules.

Tested Metadata of tables including the data types, constraints and default values on the columns.

Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, trouble shooting issues.

Participated in daily SCRUM meetings and demonstrated the daily status of testing to the team.

Inserted checkpoints where needed, to compare the current behaviour of the application being tested to its behaviour in the earlier version .

Environment: Oracle 10g,Teradata12.0,Informatica 8.6.1,Cognos, Quality Center.

Pfizer, London, UK Dec 2009– May 2010

Sr ETL/BI tester

Responsibilities:

Reviewed Business Requirement Documents (BRD) for accuracy and completeness of business requirements.

Participated in preparation of test plans and updated bug status reports.

Expertise in automating test cases.

Wrote test cases and test plans for client based reporting application and its related data.

Involved in Smoke, Integration and Functional Testing.

Provided reliable, timely support of integration and performance testing processes.

Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members.

Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.

Conducted discussions and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions

Enhanced existing test scripts, provided documentation including QA reports.

Created test scripts, performed System Integration testing, Regression testing and reviewed test results.

Expertise in writing SQL queries, SQL scripts and performing Database testing.

Exposure to all stages of SDLC, STLC and Defect Tracking.

Created test plans and testing strategies.

Actively participated in project status meetings.

Environment: Oracle,Datastage,Cognos,Quality Center.

Standard Chartered Bank,Singapore Feb 2007– Dec 2009

Sr ETL/BI tester

Responsibilities:

Requirements study in testing perceptive, understanding the functionality and scope of the application.

Authoring Test cases for mapping functionality of the designed warehouse.

Created test cases for ODS, ETL to Fermat staging area and Reporting.

Worked as module lead for entire release.

Involved in complete verification of ETL and DQM modules.

Preparation and updation of RTM and other internal tracking documents.

Written SQL Queries extensively for Data validation.

Created test cases for ODS, ETL to Fermat staging area and Reporting.

Executing Queries on AQT (Advance Query Tool) to verify the Data.

Written SQL Queries extensively for Data validation.

Testing Data stage ETL jobs using complex SQL queries.

Reviewed log files for ETL jobs in Data Stage Director.

Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.

Environment: Oracle,Datastage,Hyperion, Quality Center.

Dubai Islamic Bank,Dubai Aug 2005– Jan 2007

ETL /BI Tester

Responsibilities:

Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications

Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results.

Worked as ETL/BI Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project

Experienced in writing complex SQL queries for extracting data from multiple tables

Wrote SQL queries to validate source data versus data in the data warehouse.

Authoring Test cases for mapping functionality of the designed warehouse.

Involved in complete verification of ETL,BI module.

Preparation and updation of RTM and other internal tracking documents.

Created test cases for ODS, ETL,BI module.

Full filled Requirement Traceability Matrix using Test Director.

Environment: Oracle,Datastage,Crystal Reports,Test Director.

EDUCATION:

Bachelor of Engineering in Computer Science and Engineering with distinction, Anna University, India,May 2005.

Contact this candidate