Technical test lead
Resume:
Sushma Mohankumar
** ***** **** ***** ****: 669-***-****
San Jose, CA 95134 *****************@*****.***
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