Resume

Sign in

Technical test lead

Location:
Mountain View, CA
Salary:
100000
Posted:
March 12, 2018

Contact this candidate

Resume:

Sushma Mohankumar

** ***** **** ***** ****: 669-***-****

San Jose, CA 95134 ac4sdm@r.postjobfree.com

Summary

7+ years of experience in the fields of Information Technology, Cable and Advertising, Retail,Financial,

Aeronautical focusing both Manual and Automation Quality Assurance and Testing

Expert in writing SQL queries and experienced in testing Functional, ETL and BI

applications using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL

applications.

Experience in Software Development Life Cycle (SDLC) using Waterfall Model, Rational Unified Process

(RUP) with a good understanding of Agile Methodology.

Strong Experience in Big data testing using Hadoop HDFS commands and writing complex SQLs using

HIVE SQL language

Data Analysis: Experience in Data Analysis involving Data Cleansing, Data Conversions, Data

Transformation, Data Quality Analysis, Data Relationships, Source Systems Analysis and Reporting

Analysis.

Excellent analytical skills in understanding business process and functionality requirements while

translating them into system specifications

Creating Use cases and Activity diagrams using UML tools and Microsoft Visio.

Familiar with Data flow diagrams, Work flow diagrams and Process flow diagrams.

Gather data necessary to accomplish analysis from a number of sources, accumulate it together in

prearranged format and enter the data in several data analysis software.

Experience in using Oracle Databases, DB2 UDB, Sybase, SQL Server, Redbrick, Netezza, and

Teradata.Experience with SQL Server Security and SQL Server Auditing.

Expert in using Test Management Tools – HP QLM

Did extensive Front-End Web Testing using QTP and Quality Center.

Developing data analytical databases from complex financial source data.

Worked with different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, SQL plus

Experience in writing complex SQL and PL/SQL statements and validating XML feeds.

Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance

Monitor for monitoring and tuning MS SQL Server performance.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL

Server, MS Excel, MS Access, Flat Files and XML feeds.

Expert in Test plan, Test strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect

Management.

Excellent working knowledge of Sybase, Oracle 10g/9i, MS Office, TOAD & MS SQL Server 2000.Created

stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports.

Performed backend data testing using PL/SQL scripts to check the data consistency, data integrity in the

application and database as data was fetched from different database tables.

Proficient in using any flavor of UNIX operating system by writing various UNIX commands.

Extensive experience in performing data mart and data validation testing for data migration

Perform bug tracking and Reporting using Quality Center.

Experience in working with Analysts, Managers and Developers during the software development life cycle

(SDLC). *Strong experience identifying the user interface web services issues, including SoapUI

Extensive experience of Data Integration between various systems, sources, and databases. Experience

in implementation of ETL methodology in Data Extraction, Transformation and Loading using Informatica.

Proficient in Data warehousing and business intelligence concepts, design principles, and software

architecture.

In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and

ETL.

Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and

assess if it complete and fully understand EDW and ETL Architecture.

Strong data base experience in Oracle, SQL Server 2000/2005, IBM DB2 and Sybase.

Expertise in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data

Warehouse/ETL applications.

Extensive testing ETL experience using Ab Initio (GDE 1.14, Co > Op 2.14) & Informatica (Power Center/

Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)

Experience in Business Intelligence in generating various reports using Cognos, Business

Objects,Microstrategy, Tableau

Involved in the ETL processes where in the organizations were using Data stage, Informatica, Abinitio and

Autosys tools.

Experience in Unit Testing, Integration testing, System Testing (Functionality and Regression),

Performance testing and User Acceptance Testing.

Strong working knowledge of Team Foundation Server (TFS) and Microsoft Test Manager (MTM)on Visual

Studio Team Foundation (VSTF) in managing product lifecycle.

Skills

ETL tools Operating Systems

Informatica 9.1/8.1/7.x Windows XP/NT/2000

Data Stage 7.5 DOS

Ab Initio (GDE 1.13, Co>Op 2.13) Mac 10.4

Big Data Technology UNIX-LINUX

Programming/Scripting Languages Databases

SQL Hadoop

HIVE QL Hive

HDFS Oracle 10g/9i/8i/7.3

PL/SQL MS SQL Server 6.5/7.0/7.5/2005,2008

JCL Sybase12.0/11.0

XML, HTML MS Access 2005

Python Teradata V2R6/V2R5

Test Management tool Netezza NPS 8050.

Test Director9.0/8.0/7.5 HP Vertica

Quality Center 11/10/9.0 Reporting tools

QTP Tableau

Load Runner Cognos

Win Runner Mcrostrategy

HP ALM

JIRA

Experience

Technical Test Lead 04/2017 Current

INFOSYS Pleasanton, CA

Client: The GAP Inc.

Project details : Replace tool Orbit upload/download templates with Maestro (Master data management tool)

forms for all the modules like Location hierarchy, Store attributes, Metrics, Style attributes and Integrate with EDW

tables.

Developed Test Plans, test scripts and executed the test scripts

Thorough out the project in various iterations/Sprints – conducted 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 project business

requirements for various templates in Maestro.

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.

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 supportS

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 using CAWA application

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

Extensively tested several Microstrategy Reports – to validate data and cosmetics of the report.

Technical Test Lead 04/2016 03/2017

INFOSYS San Jose, CA

Client: Limited Brands- Victoria Secret, Bed Bath Works

Project Details:

Oracle HCM Implementation – Data migration from People soft to Oracle HCM Fusion application

VSIOM(Victoria secret int. operating model) – Datawarehouse testing mainly from teradata to Oracle and

reports validation . Data includes Product, Location, Sales Order, Purchase order of all the stores)

QA duties included:

Tested all the ETL processes developed for fetching data from SAP, SQL Server, Teradata to the target

Market Data warehouse Oracle using complex SQL queries.

Experience in SAP BW Testing, Data Migration testing and BI report testing.

Worked on Infosys Solution tool Perfaware during data migration from PeopleSoft DB to HCM fusion on

oracle cloud to achieve 100% Test Data Coverage.

Tested and analyzed web services and wrote detailed reports. Collaborated with web services

development team to resolve outstanding issues.

Worked on SAP BO and Micro strategy report validation. Carried out Test Case Execution and Defect

logging also did Weekly reporting and test report preparation.

Carried out ETL testing from Teradatata to Oracle database

Tracked defects to closure by coordinating with the dev team.

Tested source data for data completeness, data correctness and data integrity.

Performed End to end testing starting from the source to the report.

Conducted and co-ordinated with integration testing and regression testing.

Performed testing on all DML activities like Data insertions, updates, deletes

Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target

tables in the data warehouse

Prepared test data to cover all the test scenarios.

Maintained all the test cases in HP Quality Center and logged all the defects into the defects module

Technical Test Lead 02/2015 03/2016

Infosys Dallas, TX

Client: Titilemax Finance

Project details:

Cashwise Migration : Storewise data was migrated from SQL server data base to Oracle and ETL testing

from Oracle to Netezza.

Report testing in Cognos reporting tool Credex Migration: Credex data was migrated from Teradata to

Oracle database and ETL was done in Informatica to pull the data from Oracle to Netezza.

Report testing in Cognos.

QA duties included:

Created test cases and test plans for user acceptance testing and system testing based on functional

specifications.

Tested all the ETL processes developed for fetching data from SQL servere system to the target Market

Data warehouse Oracle using complex SQL queries.

Tested the entire compliance reports generated using Cognos BI tool by validating the data in the report

against the database according to the requirement specifications using SQL.

Tracked defects to closure by coordinating with the dev team.

Tested source data for data completeness, data correctness and data integrity in Teradata database.

Designed developed and implemented web services testing procedures.

Tested and analyzed web services and wrote detailed reports.

Written complex SQL queries for data checks.Performed End to end testing starting from the source to the

report.

Conducted and co-ordinated with integration testing and regression testing

Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the

product life cycle.

Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target

tables in the data warehouse.

Defect logging, assignment and tracking through (MTM) Microsoft Test Manager.Prepared test data to

cover all the test scenarios.

Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.

Environment: Informatica 9.1, SQL Server 2010, TFS, MTM, SQL developer for Oracle, HP Quality Center/ALM

10.0,Cognos BI tool, Netezza, Teradata.

Sr. ETL QA Analyst 03/2013 04/2015

IT America Inc. West Chester, PA

Client: Comcast Spotlight

Project Details:

Multiple projects having ETL and Business Intelligence reports in Advertising applications like VOD(Video

on demand), CM360(Comcast media 360), Sellable network reference, ODCR (On Demand Credit

Rating).

Various IAM(Interactive application messaging) apps testing Web based applications like OMS(Order

Management system), Saleslook CRM, Operative Express.

QA Duties included :

Created test cases and test plans for user acceptance testing and system testing based on functional

specifications.

Tested all the ETL processes developed for fetching data from Hadoop Hive system to the target Market

Data warehouse Oracle using complex SQL queries.

Tested the entire compliance reports generated using Tableau BI tool by validating the data in the report

against the database according to the requirement specifications using SQL.

Performed data validation on the flat files that were generated in UNIX and Hadoop environment using

UNIX and Hadoop fs commands as necessary.

Tracked defects to closure by coordinating with the dev team.Tested source data for data completeness,

data correctness and data integrity.

Performed End to end testing starting from the source to the report.

Conducted and co-ordinated with integration testing and regression testing.

Participated in Sprint review meeting for Web based applications and involved in Sprint planning meetings.

Worked on JIRA to effectively manage the product life cycle.

Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target

tables in the data warehouse.

Defect logging, assignment and tracking through (MTM) Microsoft Test Manager.

Worked on data migration in SQL server for one of the web based application where the historical data

from CRM system was migrated to new system OMS database.

Prepared test data to cover all the test scenarios.Maintained all the test cases in HP Quality Center and

logged all the defects into the defects module.

Environment: Informatica 9.1, SQL Server 2010, SQL developer for Oracle, HP Quality Center/ALM 10.0, XML,

Hadoop Hive, Tableau BI tool, HP Vertica database, SQLDX for Hadoop hive, Squirrel client for Hadoop, DB

visualizer for Vertica, JIRA.

ETL/BI Tester 07/2012 01/2013

Honeywell Aerospace Bangalore, KA

Responsibilities included:.

Prepare Test Strategy and detailed Test Plan for testing Global One -Client Server application and

Enhance Custody - Web Based application emphasizing on the scope, approach and effort estimation.

Analyze the Business requirements to formulate design and, document Test Scenarios and Test Cases.

Construct and maintain Requirements Traceability Matrix.

Worked with the DW Architecture team in Testing complex Delta processing Loads.

Prepared PL/SQL scripts for executing backend queries and performing data analysis.

Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.

Involved in Business analysis and requirements gathering.

Assisted in creating fact and dimension table implementation in Star Schema model based on

requirements.

Developed test plans based on test strategy.

Created and executed test cases based on test strategy and test plans based on ETL Mapping document.

Preparation of technical specifications and Source to Target mappings.

Extensively used SQL programming in backend and front-end functions, procedures, packages to

implement business rules and security.

Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with

performance tuning of complex SQL queries.

Design and execute the test cases on the application as per company standards.

Preventing occurrences of multiple runs by flagging processed dates.

Written Test Cases for ETL to compare Source and Target database systems.

Testing of records with logical delete using flags.

Interacting with senior peers or subject matter experts to learn more about the data.

Identifying duplicate records in the staging area before data gets processed.

Extensively written test scripts for back-end validations.

Testing of multiple ECM Reports using SQL Queries on Toad.

Responsible for Database Migration from Oracle 9i to Oracle 10g.

Execute SQL queries to perform Backend testing to ensure data validation.

Performed extensive integration testing of the application to and from the UNIX and Mainframe systems.

Perform volume testing to monitor system's threshold for uploading and downloading transactions to and

from the other downstream systems.

Conduct Regression testing on the system each time a new build comes through.

Overall responsibility for defect management - Defect logging, reporting, tracking, testing, closing etc using

Rational Clear Quest.

Responsible for weekly status update meetings.

Mentor junior testers and provided one-on-one training on the application with emphasis on improvising the

overall quality of software process.

Provide technical presentations and training workshops for end users Environment: Toad, Informatica,

SQL, PL/SQL, SQL Developer, MS-Office, Rational Clear Quest, HP Quality center, UNIX, Shell Scripting,

Mainframe, Windows XP and Oracle.

Test Engineer 11/2009 07/2012

Geodesic Techniques Pvt. Ltd. Bengaluru, KA

Responsibilities included:.

Prepare Test Strategy and detailed Test Plan for testing Global One -Client Server application and

Enhance Custody - Web Based application emphasizing on the scope, approach and effort estimation.

Analyze the Business requirements to formulate design and, document Test Scenarios and Test Cases.

Construct and maintain Requirements Traceability Matrix.

Worked with the DW Architecture team in Testing complex Delta processing Loads.

Prepared PL/SQL scripts for executing backend queries and performing data analysis.

Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.

Involved in Business analysis and requirements gathering.

Assisted in creating fact and dimension table implementation in Star Schema model based on

requirements.

Developed test plans based on test strategy.

Created and executed test cases based on test strategy and test plans based on ETL Mapping document.

Preparation of technical specifications and Source to Target mappings.

Extensively used SQL programming in backend and front-end functions, procedures, packages to

implement business rules and security.

Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with

performance tuning of complex SQL queries.

Design and execute the test cases on the application as per company standards.

Preventing occurrences of multiple runs by flagging processed dates.

Written Test Cases for ETL to compare Source and Target database systems.

Testing of records with logical delete using flags.

Interacting with senior peers or subject matter experts to learn more about the data.

Identifying duplicate records in the staging area before data gets processed.

Extensively written test scripts for back-end validations.

Testing of multiple ECM Reports using SQL Queries on Toad.

Responsible for Database Migration from Oracle 9i to Oracle 10g.

Execute SQL queries to perform Backend testing to ensure data validation.

Performed extensive integration testing of the application to and from the UNIX and Mainframe systems.

Perform volume testing to monitor system's threshold for uploading and downloading transactions to and

from the other downstream systems.

Conduct Regression testing on the system each time a new build comes through.

Overall responsibility for defect management - Defect logging, reporting, tracking, testing, closing etc using

Rational Clear Quest.

Responsible for weekly status update meetings.

Mentor junior testers and provided one-on-one training on the application with emphasis on improvising the

overall quality of software process.

Provide technical presentations and training workshops for end users Environment: Toad, SQLServer, SQL

Developer, MS-Office, Rational Clear Quest, UNIX, Shell scripting, Mainframe, Windows XP and Oracle.

Education and Training

Bachelor of Engineering: Visveswariah Technological University

Bangalore, India



Contact this candidate